ADD COLUMN `tooltip_loc<?php
echo $L;
?>
` text NOT NULL AFTER `tooltip_loc0`,
ADD COLUMN `buff_loc<?php
echo $L;
?>
` text NOT NULL AFTER `buff_loc0`;
ALTER TABLE freedomhead_talenttab ADD COLUMN `name_loc<?php
echo $L;
?>
` varchar(32) NOT NULL AFTER `name_loc0`;
<?php
SQLGenerator::PrintUpdate('', SQLGenerator::Unpack("Achievement_Category.dbc", SQLGenerator::Localize("nxSxxxxxxxxxxxxxxxxx"), true), array(0 => "id"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_achievement', SQLGenerator::Unpack("Achievement.dbc", SQLGenerator::Localize("nxxxSxxxxxxxxxxxxxxxxSxxxxxxxxxxxxxxxxxxxxxSxxxxxxxxxxxxxxxxxx"), true), array(0 => "id"), array(1 => "name_loc{$L}", 2 => "description_loc{$L}", 3 => "reward_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_achievementcriteria', SQLGenerator::Unpack("Achievement_Criteria.dbc", SQLGenerator::Localize("nxxxxxxxxSxxxxxxxxxxxxxxxxxxxxx"), true), array(0 => "id"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_char_titles', SQLGenerator::Unpack("CharTitles.dbc", SQLGenerator::Localize("nxSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"), true), array(0 => "id"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_skill', SQLGenerator::Unpack("SkillLine.dbc", SQLGenerator::Localize("nxxSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"), true), array(0 => "skillID"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_spelldispeltype', SQLGenerator::Unpack("SpellDispelType.dbc", SQLGenerator::Localize("nSxxxxxxxxxxxxxxxxxxx"), true), array(0 => "id"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_spellmechanic', SQLGenerator::Unpack("SpellMechanic.dbc", SQLGenerator::Localize("nSxxxxxxxxxxxxxxxx"), true), array(0 => "id"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_resistances', SQLGenerator::Unpack("Resistances.dbc", SQLGenerator::Localize("nxxSxxxxxxxxxxxxxxxx"), true), array(0 => "id"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_itemset', SQLGenerator::Unpack("ItemSet.dbc", SQLGenerator::Localize("nSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"), true), array(0 => "itemsetID"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_spellrange', SQLGenerator::Unpack("SpellRange.dbc", SQLGenerator::Localize("nxxxxxSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"), true), array(0 => "rangeID"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_zones', SQLGenerator::Unpack("AreaTable.dbc", SQLGenerator::Localize("nxxxxxxxxxxSxxxxxxxxxxxxxxxxxxxxxxxx"), true), array(0 => "areatableID"), array(1 => "name_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_factions', SQLGenerator::Unpack("Faction.dbc", SQLGenerator::Localize("nxxxxxxxxxxxxxxxxxxxxxxSxxxxxxxxxxxxxxxxSxxxxxxxxxxxxxxxx"), true), array(0 => "factionID"), array(1 => "name_loc{$L}", 2 => "description1_loc{$L}"));
SQLGenerator::PrintUpdate('freedomhead_itemenchantmet', SQLGenerator::Unpack("SpellItemEnchantment.dbc", SQLGenerator::Localize("nxxxxxxxxxxxxxSxxxxxxxxxxxxxxxxxxxxxxx"), true), array(0 => "itemenchantmetID"), array(1 => "text_loc{$L}"));
// HTTP SERVER ERROR!!!!!!!! SQLGenerator::PrintUpdate('freedomhead_spell', SQLGenerator::Unpack("Spell.dbc", SQLGenerator::Localize("nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxSxxxxxxxxxxxxxxxxSxxxxxxxxxxxxxxxxSxxxxxxxxxxxxxxxxSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"), true), array(0=>"spellID"), array(1=>"spellname_loc$L", 2=>"rank_loc$L", 3=>"tooltip_loc$L", 4=>"buff_loc$L"));
SQLGenerator::PrintUpdate('freedomhead_talenttab', SQLGenerator::Unpack("TalentTab.dbc", SQLGenerator::Localize("nSxxxxxxxxxxxxxxxxxxxxxx"), true), array(0 => "id"), array(1 => "name_loc{$L}"));
//SQLGenerator::PrintUpdate('', SQLGenerator::Unpack(".dbc", SQLGenerator::Localize(""), true), );
<?php
set_time_limit(300);
ini_set("memory_limit", "2500M");
require_once 'Configuration.php';
require_once 'Classes/SQLGenerator.Class.php';
new SQLGenerator($FCCore['DataDirectory'] . $FCCore['English548'], $FCCore['Locale']);
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_achievementcategory` VALUES', SQLGenerator::Unpack("Achievement_Category.dbc", "nisx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_achievement` VALUES', SQLGenerator::Unpack("Achievement.dbc", "niiissiiiiisiix"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_achievementcriteria` VALUES', SQLGenerator::Unpack("Achievement_Criteria.dbc", "niiiiiiiisxxxxxxxxxxxxxxxxiixii")); --- Unknown fields | Not Working !!!!!
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_glyphproperties` VALUES', SQLGenerator::Unpack("GlyphProperties.dbc", "niii"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_items', SQLGenerator::Unpack("Item.db2", "niixiiii")); --- DB2 File | Not Working !!!!!
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_char_titles` (id,name_loc0) VALUES', SQLGenerator::Unpack("CharTitles.dbc", "nxsxxx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_item_extended_cost` VALUES', SQLGenerator::Unpack("ItemExtendedCost.dbc", "niixiiiiiiiiiiix")); --- DB2 File | Not Working !!!!!
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_skill_line_ability` VALUES', SQLGenerator::Unpack("SkillLineAbility.dbc", "xiiiixxixxiixx")); --- Unknown fields | Not Working !!!!!
// Connection RESET FFS !!!!! SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_skill` VALUES', SQLGenerator::Unpack("SkillLine.dbc", "nixsxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_spelldispeltype` VALUES', SQLGenerator::Unpack("SpellDispelType.dbc", "nsxxx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_spellmechanic` VALUES', SQLGenerator::Unpack("SpellMechanic.dbc", "ns"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_resistances` VALUES', SQLGenerator::Unpack("Resistances.dbc", "nxxs"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_spellcasttimes` VALUES', SQLGenerator::Unpack("SpellCastTimes.dbc", "nixx"));
//SQLGenerator::PrintSQL('<br />', SQLGenerator::RemovePath(SQLGenerator::Unpack("SpellIcon.dbc", "ns")));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_lock` VALUES', SQLGenerator::Unpack("Lock.dbc", "niiiiixxxiiiiixxxiiiiixxxxxxxxxxx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_icons` VALUES', SQLGenerator::Unpack("ItemDisplayInfo.dbc", "nxxxxsxxxxxxxxxxxxxxxxxxxx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_itemset` VALUES', SQLGenerator::Unpack("ItemSet.dbc", "nsiiiiiiiiiixxxxxxxiiiiiiiiiiiiiiiiii"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_spell` VALUES', SQLGenerator::Unpack("Spell.dbc", "niiixxxxxxxxxxxxxxxxxxxxxxxxiixxiixiixxiixixxxixxiiiiiiiiiiiiiiiiiiixxxiiiiiixxxiiixxxiiiiiiiiiiiiiiifffiiiiiiiiixxxiiifffxxxxxxxxxxxixxsxxxxxxxxxxxxxxxxsxxxxxxxxxxxxxxxxsxxxxxxxxxxxxxxxxsxxxxxxxxxxxxxxxxixxixxxxixxxfffxxxxxxxxxxxxxxx")); -- NOT YET PARSED!!!!
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_spellduration` VALUES', SQLGenerator::Unpack("SpellDuration.dbc", "nixx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_spellrange` VALUES', SQLGenerator::Unpack("SpellRange.dbc", "nffffxsx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_spellradius` VALUES', SQLGenerator::Unpack("SpellRadius.dbc", "nfxxx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_itemenchantmet` VALUES', SQLGenerator::Unpack("SpellItemEnchantment.dbc", "nxxxxxxxxxxsxxxxxxxxxxxxxx"));
//SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_gemproperties` VALUES', SQLGenerator::Unpack("GemProperties.dbc", "nixxxx"));
SQLGenerator::PrintSQL('<br />INSERT INTO `freedomhead_talent` VALUES', SQLGenerator::Unpack("Talent.dbc", "niiiiiiiixxxxixxixxxxix"));
public static function MapGenerator($DBCArray)
{
$FinalDBC = array();
$MapDBC = $DBCArray[0][0];
$MapFormat = $DBCArray[0][1];
$AreaDBC = $DBCArray[1][0];
$AreaFormat = $DBCArray[1][1];
$WorldMapDBC = $DBCArray[2][0];
$WorldMapFormat = $DBCArray[2][1];
$MapType = array();
$AreaType = array();
$TempDBC = SQLGenerator::Unpack($MapDBC, $MapFormat, true);
foreach ($TempDBC as $Row) {
$MapType[$Row[0]] = $Row[1];
if ($Row[3]) {
$AreaType[$Row[0] . "@" . $Row[3]] = $Row[1];
}
}
$TempDBC = SQLGenerator::Unpack($AreaDBC, $AreaFormat, true);
foreach ($TempDBC as $Row) {
$Type = 0;
if (isset($maptype[$Row[1]])) {
$Type = $maptype[$Row[1]];
}
if (isset($areatype[$Row[1] . "@" . $Row[0]])) {
$Type = $areatype[$Row[1] . "@" . $Row[0]];
}
$FinalDBC[$Row[0]] = array($Row[1], $Row[0], $Row[2], 0, 0, 0, 0, $Type);
}
$TempDBC = SQLGenerator::Unpack($WorldMapDBC, $WorldMapFormat, true);
foreach ($TempDBC as $Row) {
if (isset($FinalDBC[$Row[1]])) {
$FinalDBC[$Row[1]][3] = $Row[5] < $Row[6] ? $Row[5] : $Row[6];
$FinalDBC[$Row[1]][4] = $Row[3] < $Row[4] ? $Row[3] : $Row[4];
$FinalDBC[$Row[1]][5] = $Row[5] < $Row[6] ? $Row[6] : $Row[5];
$FinalDBC[$Row[1]][6] = $Row[3] < $Row[4] ? $Row[4] : $Row[3];
}
}
unset($TempDBC);
echo base64_decode(SQLGenerator::GetHeader('Group.dbc'));
return $FinalDBC;
}
