mirror of
https://github.com/rivi-s/pfQuest.git
synced 2026-11-17 16:44:35 +00:00
338 lines
12 KiB
Bash
Executable File
338 lines
12 KiB
Bash
Executable File
#!/bin/bash
|
|
root="DBC"
|
|
rootsql="client-data.sql"
|
|
versions="vanilla turtle tbc wotlk"
|
|
locales="enUS koKR frFR deDE zhCN zhTW esES esMX ruRU jaJP ptBR"
|
|
|
|
# delete old extraction
|
|
if [ -f "$rootsql" ]; then
|
|
rm $rootsql
|
|
fi
|
|
|
|
function Run() {
|
|
echo "- $1" && $1
|
|
}
|
|
|
|
function WorldMapOverlay() {
|
|
cat >> $rootsql << EOF
|
|
DROP TABLE IF EXISTS \`WorldMapOverlay_${v}\`;
|
|
CREATE TABLE \`WorldMapOverlay_${v}\` (
|
|
\`areaID\` smallint(3) unsigned NOT NULL,
|
|
\`zoneID\` smallint(3) unsigned NOT NULL,
|
|
\`texture\` varchar(255),
|
|
\`textureWidth\` smallint(3) unsigned NOT NULL,
|
|
\`textureHeight\` smallint(3) unsigned NOT NULL,
|
|
\`offsetX\` smallint(3) unsigned NOT NULL,
|
|
\`offsetY\` smallint(3) unsigned NOT NULL,
|
|
\`hitRectTop\` smallint(3) unsigned NOT NULL,
|
|
\`hitRectLeft\` smallint(3) unsigned NOT NULL,
|
|
\`hitRectBottom\` smallint(3) unsigned NOT NULL,
|
|
\`hitRectRight\` smallint(3) unsigned NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='WorldMapOverlay';
|
|
|
|
EOF
|
|
|
|
if [ -d $root/$v ] && [ -f $root/$v/WorldMapOverlay.dbc.csv ]; then
|
|
cat $root/$v/WorldMapOverlay.dbc.csv | tail -n +2 | sort -nt ',' -k3,3 | while read line; do
|
|
areaID=$(echo $line | cut -d "," -f 3)
|
|
zoneID=$(echo $line | cut -d "," -f 2)
|
|
texture=$(echo $line | cut -d "," -f 9)
|
|
textureWidth=$(echo $line | cut -d "," -f 10)
|
|
textureHeight=$(echo $line | cut -d "," -f 11)
|
|
offsetX=$(echo $line | cut -d "," -f 12)
|
|
offsetY=$(echo $line | cut -d "," -f 13)
|
|
top=$(echo $line | cut -d "," -f 14)
|
|
left=$(echo $line | cut -d "," -f 15)
|
|
bottom=$(echo $line | cut -d "," -f 16)
|
|
right=$(echo $line | cut -d "," -f 17)
|
|
|
|
echo "INSERT INTO \`WorldMapOverlay_${v}\` VALUES ($areaID, $zoneID, $texture, $textureWidth, $textureHeight, $offsetX, $offsetY, $top, $left, $bottom, $right);" >> $rootsql
|
|
done
|
|
fi
|
|
}
|
|
|
|
|
|
function AreaTrigger() {
|
|
cat >> $rootsql << EOF
|
|
DROP TABLE IF EXISTS \`AreaTrigger_${v}\`;
|
|
CREATE TABLE \`AreaTrigger_${v}\` (
|
|
\`ID\` smallint(3) unsigned NOT NULL,
|
|
\`MapID\` smallint(3) unsigned NOT NULL,
|
|
\`X\` float NOT NULL DEFAULT 0.0,
|
|
\`Y\` float NOT NULL DEFAULT 0.0,
|
|
\`Z\` float NOT NULL DEFAULT 0.0,
|
|
\`Size\` float NOT NULL DEFAULT 0.0
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='AreaTrigger';
|
|
|
|
EOF
|
|
|
|
if [ -d $root/$v ] && [ -f $root/$v/AreaTrigger.dbc.csv ]; then
|
|
cat $root/$v/AreaTrigger.dbc.csv | tail -n +2 | sort -nt "," -k1,1 | while read line; do
|
|
id=$(echo $line | cut -d "," -f 1)
|
|
map=$(echo $line | cut -d "," -f 2)
|
|
x=$(echo $line | cut -d "," -f 3)
|
|
y=$(echo $line | cut -d "," -f 4)
|
|
z=$(echo $line | cut -d "," -f 5)
|
|
size=$(echo $line | cut -d "," -f 6)
|
|
|
|
echo "INSERT INTO \`AreaTrigger_${v}\` VALUES ($id, $map, $x, $y, $z, $size);" >> $rootsql
|
|
done
|
|
fi
|
|
}
|
|
|
|
function WorldMapArea() {
|
|
cat >> $rootsql << EOF
|
|
DROP TABLE IF EXISTS \`WorldMapArea_${v}\`;
|
|
CREATE TABLE \`WorldMapArea_${v}\` (
|
|
\`zoneID\` smallint(3) unsigned NOT NULL,
|
|
\`mapID\` smallint(3) unsigned NOT NULL,
|
|
\`areatableID\` smallint(3) unsigned NOT NULL,
|
|
\`name\` varchar(255) NOT NULL,
|
|
\`x_min\` float NOT NULL DEFAULT 0.0,
|
|
\`y_min\` float NOT NULL DEFAULT 0.0,
|
|
\`x_max\` float NOT NULL DEFAULT 0.0,
|
|
\`y_max\` float NOT NULL DEFAULT 0.0
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='WorldMapArea';
|
|
|
|
EOF
|
|
|
|
if [ -d $root/$v ] && [ -f $root/$v/WorldMapArea.dbc.csv ]; then
|
|
cat $root/$v/WorldMapArea.dbc.csv | tail -n +2 | sort -nt ',' -k3,3 | while read line; do
|
|
zone=$(echo $line | cut -d "," -f 1)
|
|
map=$(echo $line | cut -d "," -f 2)
|
|
area=$(echo $line | cut -d "," -f 3)
|
|
name=$(echo $line | cut -d "," -f 4)
|
|
x_min=$(echo $line | cut -d "," -f 5)
|
|
y_min=$(echo $line | cut -d "," -f 6)
|
|
x_max=$(echo $line | cut -d "," -f 7)
|
|
y_max=$(echo $line | cut -d "," -f 8)
|
|
|
|
echo "INSERT INTO \`WorldMapArea_${v}\` VALUES ($zone, $map, $area, $name, $y_max, $y_min, $x_max, $x_min);" >> $rootsql
|
|
done
|
|
fi
|
|
}
|
|
|
|
function FactionTemplate() {
|
|
cat >> $rootsql << EOF
|
|
DROP TABLE IF EXISTS \`FactionTemplate_${v}\`;
|
|
CREATE TABLE \`FactionTemplate_${v}\` (
|
|
\`factiontemplateID\` smallint(3) unsigned NOT NULL,
|
|
\`factionID\` smallint(3) unsigned NOT NULL,
|
|
\`A\` smallint(1) NOT NULL,
|
|
\`H\` smallint(1) NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='WorldMapArea';
|
|
|
|
EOF
|
|
|
|
if [ -d $root/$v ] && [ -f $root/$v/FactionTemplate.dbc.csv ]; then
|
|
cat $root/$v/FactionTemplate.dbc.csv | tail -n +2 | sort -nt ',' -k3 | while read line; do
|
|
factiontemplate=$(echo $line | cut -d "," -f 1)
|
|
faction=$(echo $line | cut -d "," -f 2)
|
|
friendly=$(echo $line | cut -d "," -f 5) # field 5
|
|
hostile=$(echo $line | cut -d "," -f 6) # field 6
|
|
|
|
if [ $(( 4 & $hostile )) != 0 ] || [ $hostile = 1 ]; then
|
|
horde=-1
|
|
elif [ $(( 4 & $friendly )) != 0 ] || [ $friendly = 1 ]; then
|
|
horde=1
|
|
else
|
|
horde=0
|
|
fi
|
|
|
|
if [ $(( 2 & $hostile )) != 0 ] || [ $hostile = 1 ]; then
|
|
alliance=-1
|
|
elif [ $(( 2 & $friendly )) != 0 ] || [ $friendly = 1 ]; then
|
|
alliance=1
|
|
else
|
|
alliance=0
|
|
fi
|
|
|
|
echo "INSERT INTO \`FactionTemplate_${v}\` VALUES ($factiontemplate, $faction, $alliance, $horde);" >> $rootsql
|
|
done
|
|
fi
|
|
}
|
|
|
|
function Lock() {
|
|
cat >> $rootsql << EOF
|
|
DROP TABLE IF EXISTS \`Lock_${v}\`;
|
|
CREATE TABLE \`Lock_${v}\` (
|
|
\`id\` smallint(3) unsigned NOT NULL,
|
|
\`locktype\` smallint(3) NOT NULL,
|
|
\`data\` smallint(3) unsigned NOT NULL,
|
|
\`skill\` smallint(3) unsigned NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Lock';
|
|
|
|
EOF
|
|
|
|
if [ -d $root/$v ] && [ -f $root/$v/Lock.dbc.csv ]; then
|
|
cat $root/$v/Lock.dbc.csv | tail -n +2 | while read line; do
|
|
id=$(echo $line | cut -d "," -f 1)
|
|
locktype=$(echo $line | cut -d "," -f 2)
|
|
locktype=$(echo $locktype | cut -d "x" -f 2)
|
|
data=$(echo $line | cut -d "," -f 10)
|
|
skill=$(echo $line | cut -d "," -f 18)
|
|
|
|
# hackfix to display chests
|
|
if [ "$id" = "57" ]; then
|
|
echo "INSERT INTO \`Lock_${v}\` VALUES (57, 2, 1, 0);" >> $rootsql
|
|
else
|
|
echo "INSERT INTO \`Lock_${v}\` VALUES ($id, $locktype, $data, $skill);" >> $rootsql
|
|
fi
|
|
|
|
done
|
|
fi
|
|
}
|
|
|
|
function SkillLine() {
|
|
cat >> $rootsql << EOF
|
|
DROP TABLE IF EXISTS \`SkillLine_${v}\`;
|
|
CREATE TABLE \`SkillLine_${v}\` (
|
|
\`id\` smallint(3) unsigned NOT NULL,
|
|
\`name_loc0\` varchar(255) NOT NULL,
|
|
\`name_loc1\` varchar(255) NOT NULL,
|
|
\`name_loc2\` varchar(255) NOT NULL,
|
|
\`name_loc3\` varchar(255) NOT NULL,
|
|
\`name_loc4\` varchar(255) NOT NULL,
|
|
\`name_loc5\` varchar(255) NOT NULL,
|
|
\`name_loc6\` varchar(255) NOT NULL,
|
|
\`name_loc7\` varchar(255) NOT NULL,
|
|
\`name_loc8\` varchar(255) NOT NULL,
|
|
\`name_loc10\` varchar(255) NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='SkillLine';
|
|
|
|
EOF
|
|
|
|
index=0
|
|
for loc in $locales; do
|
|
# locale fixes
|
|
if [ "$loc" = "ruRU" ] && [ "$v" == "vanilla" ]; then
|
|
dbcslot=0 # there's no index for ruRU in 1.12, using enUS index
|
|
elif [ "$loc" = "ptBR" ] && [ "$v" == "vanilla" ]; then
|
|
dbcslot=0 # there's no index for ptBR in 1.12, using enUS index
|
|
elif [ "$loc" = "esMX" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "frFR" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "jaJP" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "koKR" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "ruRU" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "zhTW" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "ptBR" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=7 # turtle uses xxYY (loc7) for ptBR
|
|
else
|
|
dbcslot=$index
|
|
fi
|
|
|
|
if [ -d $root/$v ] && [ -f $root/$v/$loc/SkillLine.dbc.csv ]; then
|
|
tail -n +2 $root/$v/$loc/SkillLine.dbc.csv | while read line; do
|
|
id=$(echo $line | cut -d , -f 1)
|
|
entry=$(echo $line | cut -d , -f $(expr 4 + $dbcslot))
|
|
|
|
if [ "$loc" = "enUS" ]; then
|
|
echo "INSERT INTO \`SkillLine_${v}\` VALUES ($id, $entry, '', '', '', '', '', '', '', '', '');" >> $rootsql
|
|
elif [ "$loc" = "ptBR" ] && [ "$v" == "turtle" ]; then
|
|
echo "UPDATE \`SkillLine_${v}\` SET name_loc7 = $entry WHERE id = $id;" >> $rootsql
|
|
else
|
|
echo "UPDATE \`SkillLine_${v}\` SET name_loc$index = $entry WHERE id = $id;" >> $rootsql
|
|
fi
|
|
done
|
|
fi
|
|
index=$(expr $index + 1)
|
|
done
|
|
}
|
|
|
|
function AreaTable() {
|
|
cat >> $rootsql << EOF
|
|
DROP TABLE IF EXISTS \`AreaTable_${v}\`;
|
|
CREATE TABLE \`AreaTable_${v}\` (
|
|
\`id\` int(3) unsigned NOT NULL,
|
|
\`zoneID\` smallint(3) unsigned NOT NULL,
|
|
\`name_loc0\` varchar(255) NOT NULL,
|
|
\`name_loc1\` varchar(255) NOT NULL,
|
|
\`name_loc2\` varchar(255) NOT NULL,
|
|
\`name_loc3\` varchar(255) NOT NULL,
|
|
\`name_loc4\` varchar(255) NOT NULL,
|
|
\`name_loc5\` varchar(255) NOT NULL,
|
|
\`name_loc6\` varchar(255) NOT NULL,
|
|
\`name_loc7\` varchar(255) NOT NULL,
|
|
\`name_loc8\` varchar(255) NOT NULL,
|
|
\`name_loc10\` varchar(255) NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='AreaTable';
|
|
|
|
EOF
|
|
|
|
|
|
index=0
|
|
for loc in $locales; do
|
|
# locale fixes
|
|
if [ "$loc" = "ruRU" ] && [ "$v" == "vanilla" ]; then
|
|
dbcslot=0 # there's no index for ruRU in 1.12, using enUS index
|
|
elif [ "$loc" = "ptBR" ] && [ "$v" == "vanilla" ]; then
|
|
dbcslot=0 # there's no index for ptBR in 1.12, using enUS index
|
|
elif [ "$loc" = "esMX" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "frFR" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "jaJP" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "koKR" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "ruRU" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "zhTW" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=0 # no turtle client for that language, falling back to enUS
|
|
elif [ "$loc" = "ptBR" ] && [ "$v" == "turtle" ]; then
|
|
dbcslot=7 # turtle uses xxYY (loc7) for ptBR
|
|
else
|
|
dbcslot=$index
|
|
fi
|
|
|
|
if [ -d $root/$v ] && [ -f $root/$v/$loc/AreaTable.dbc.csv ]; then
|
|
tail -n +2 $root/$v/$loc/AreaTable.dbc.csv | while read line; do
|
|
id=$(echo $line | cut -d , -f 1)
|
|
zoneID=$(echo $line | cut -d , -f 3)
|
|
entry=$(echo $line | cut -d , -f $(expr 12 + $dbcslot))
|
|
if ! [ -z "$entry" ] && [ "$entry" != "\"\"" ]; then
|
|
entry=$(echo $entry | sed 's/""/\\"/g')
|
|
fi
|
|
|
|
# some zones must be flagged with UNUSED for some locales
|
|
unused_zones="55 276 394 407 470 474 476 696 697 698 699 1196"
|
|
if [ "$loc" = "zhCN" ]; then
|
|
for unused in $unused_zones; do
|
|
if [ "$unused" == "$id" ]; then
|
|
entry="\"$(echo ${entry} | sed 's/"//g')UNUSED\""
|
|
fi
|
|
done
|
|
fi
|
|
|
|
if [ "$loc" = "enUS" ]; then
|
|
echo "INSERT INTO \`AreaTable_${v}\` VALUES ($id, $zoneID, $entry, '', '', '', '', '', '', '', '', '');" >> $rootsql
|
|
elif [ "$loc" = "ptBR" ] && [ "$v" == "turtle" ]; then
|
|
echo "UPDATE \`AreaTable_${v}\` SET name_loc7 = $entry WHERE id = $id;" >> $rootsql
|
|
else
|
|
echo "UPDATE \`AreaTable_${v}\` SET name_loc$index = $entry WHERE id = $id;" >> $rootsql
|
|
fi
|
|
done
|
|
fi
|
|
index=$(expr $index + 1)
|
|
done
|
|
}
|
|
|
|
# build sql tables
|
|
for v in $versions; do
|
|
echo "Expansion: $v"
|
|
|
|
Run WorldMapOverlay
|
|
Run AreaTrigger
|
|
Run WorldMapArea
|
|
Run FactionTemplate
|
|
Run Lock
|
|
Run SkillLine
|
|
Run AreaTable
|
|
done
|