DB2 Reader for World of Warcraft data files
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.


Build Status Coverage Status

DB2 Reader

This is a small library to read DB2 and ADB files (data tables) from World of Warcraft.


This was developed using 64-bit PHP 7. Tests are also run against PHP 5.6. 64-bit versions are recommended to support unsigned 32-bit ints and 64-bit ints.

Mbstring extension is required for all formats, and gmp extension is required for WDC1 support.


// Instantiate an object with the path to a DB2 file.
$db2Reader = new Reader("Achievement.db2"); 
// Records are presented as simple arrays.
// Some fields are, themselves, arrays of values.
// Get individual records by ID with:
$record = $db2Reader->getRecord(17);
// Loop through records with:
foreach ($db2Reader->generateRecords() as $id => $record) { ... }
// All valid record IDs:
$ids = $db2Reader->getIds();
// You can set field names for convenience:
$db2Reader->setFieldNames([0 => "name", 1 => "note", ...]);
$record = $db2Reader->getRecord(17);
if ($record['name'] == "...") ...
// All integers are assumed to be unsigned, but you can change that by field:
$db2Reader->setFieldsSigned([2 => true, 7 => true]);
$record = $db2Reader->getRecord(17);
if ($record[2] < 0) ...
// You can get the calculated field types, 
// useful when dynamically creating database tables:
$types = $db2Reader->getFieldTypes();
if ($types['name'] == Reader::FIELD_TYPE_STRING) ...
// Finally, you can load an ADB, as long as you have its parent DB2.
// The ADB reader will only expose records in the ADB file
$adbReader = $db2Reader->loadAdb("Achievement.adb");

Also check out example.php, which is what I'm using during development.


Version Format Works Unit Tests
3.x - 6.x WDB2 Yes Yes
7.0.1 WDB3 No No
7.0.3 WDB4 No No
7.0.3 - 7.2.0 WDB5 Yes Yes
7.0.3 - 7.2.0 WCH7/8 Yes No
7.2.0 - 7.3.2 WDB6 Yes Yes
7.2.0 - ? Hotfix.tbl Yes No
7.3.5 WDC1 Yes No
8.0.1 - ? WDC2 Yes No

All features of DB2 files should be supported (offset map / embedded strings, copy blocks, common blocks, pallet data, etc).

ADBs/DBCache/Hotfix require their counterpart DB2 file for necessary metadata.


This is used for The Undermine Journal (Newsstand) to datamine items, pets, and other entities.


WDC1 / WDC2 support is preliminary and could use further improvements and code cleanup.

This work is neither endorsed by nor affiliated with Blizzard Entertainment.


Most of the file format details were found by documentation at the WoWDev wiki. Thanks to those who contribute there!


Copyright 2017 Gerard Dombroski

Licensed under the Apache License, Version 2.0 (the "License"); you may not use these files except in compliance with the License. You may obtain a copy of the License at


Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.