}
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);
