} if (isset($areatype[$row[1] . "@" . $row[0]])) { $type = $areatype[$row[1] . "@" . $row[0]]; } $dbc[$row[0]] = array($row[1], $row[0], $row[3], 0, 0, 0, 0, $type, $row[2]); } // Update data with coords, where available // 3.1.3.new: xiisffffxx // 3.2.2a: xiisffffxxx $dbc_tmp = dbc2array_("WorldMapArea.dbc", "xiisffffxxx"); foreach ($dbc_tmp as $row) { if (isset($dbc[$row[1]])) { $dbc[$row[1]][3] = $row[5] < $row[6] ? $row[5] : $row[6]; // x_min $dbc[$row[1]][4] = $row[3] < $row[4] ? $row[3] : $row[4]; // y_min $dbc[$row[1]][5] = $row[5] < $row[6] ? $row[6] : $row[5]; // x_max $dbc[$row[1]][6] = $row[3] < $row[4] ? $row[4] : $row[3]; // y_max } } unset($dbc_tmp); print_insert('INSERT INTO `aowow_zones` VALUES', $dbc); // TODO: Get duplicates from Map.dbc automatically. Currently they are: ?> -- Onyxia's Lair UPDATE aowow_zones SET mapID = 249 WHERE areatableID = 2159; -- Hall of Legends UPDATE aowow_zones SET mapID = 450 WHERE areatableID = 2917;
-- SkillLine.dbc DROP TABLE IF EXISTS `freedomhead_skill`; CREATE TABLE `freedomhead_skill` ( `skillID` mediumint(11) unsigned NOT NULL, `categoryID` mediumint(11) NOT NULL, `name_loc0` varchar(255) NOT NULL, PRIMARY KEY (`skillID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; <?php $dbc = dbc2array_("SkillLine.dbc", "nixsxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"); print_insert('INSERT INTO `freedomhead_skill` VALUES', $dbc);