File.sql is displaying the wrong names and comments
Closed this issue · 2 comments
osleyder85 commented
TrinityCore - WowPacketParser
Detected build: V9_2_5_44061
Detected locale: enUS
Targeted database: Shadowlands
File.sql is showing the wrong names and comments, here are some examples:
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+229;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID+0, 55347, 974, 5861, 5870, '0', '0', 0, 0, 0, -4159.22900390625, 6297.49853515625, 13.6002044677734375, 2.059488534927368164, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 44061), -- �盟市民 (Area: The Darkmoon Faire - Difficulty: 0) (Auras: 73811 - Citizen Costume)
(@CGUID+1, 57983, 974, 5861, 5870, '0', '0', 0, 0, 0, -4141.46337890625, 6384.376953125, 13.20028877258300781, 4.276056766510009765, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 44061), -- �倫瑪 (Area: The Darkmoon Faire - Difficulty: 0)
(@CGUID+2, 14841, 974, 5861, 5870, '0', '0', 0, 0, 0, -4075.453125, 6354.99462890625, 13.19501590728759765, 4.485496044158935546, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 44061), -- ç‘žæž— (Area: The Darkmoon Faire - Difficulty: 0)
(@CGUID+3, 14847, 974, 5861, 5870, '0', '0', 0, 0, 1, -4078.15625, 6304.4443359375, 13.20196723937988281, 0.78539818525314331, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 44061), -- è–©æ�œæ–¯â€§å¸•é‡Œæ�教授 (Area: The Darkmoon Faire - Difficulty: 0)
(@CGUID+4, 55264, 974, 5861, 5870, '0', '0', 0, 0, 1, -4088.263916015625, 6359.9375, 13.15959644317626953, 4.101523876190185546, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 44061), -- 沙茲‧�幣手 (Area: The Darkmoon Faire - Difficulty: 0)
(@CGUID+5, 68231, 0, 5861, 5870, '0', '0', 0, 0, 0, -6.6299295425415039, 3.931654691696166992, 1.201351523399353027, 1.110579252243041992, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 44061), -- ����椅 (Area: The Darkmoon Faire - Difficulty: 0)
DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+229;
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
(@CGUID+0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '73811'), -- �盟市民 - 73811 - Citizen Costume
(@CGUID+7, 0, 0, 0, 1, 0, 0, 0, 0, 0, '73810'), -- �盟市民 - 73810 - Citizen Costume
(@CGUID+13, 0, 0, 0, 1, 0, 0, 0, 0, 0, '27747 102209'), -- æ•µæ–¹è¿·ä½ é£›è‰‡ - 27747 - Steam Tank Passive, 102209 - Bombs Away
(@CGUID+14, 0, 0, 0, 1, 0, 0, 0, 0, 0, '27747 102222'), -- 敵方�克 - 27747 - Steam Tank Passive, 102222 - Searching
(@CGUID+15, 0, 0, 1, 0, 0, 0, 0, 0, 0, '73813'), -- 部�市民 - 73813 - Citizen Costume
(@CGUID+16, 0, 0, 0, 1, 0, 0, 0, 0, 0, '73814'), -- 部�市民 - 73814 - Citizen Costume
(@CGUID+17, 0, 0, 0, 0, 0, 0, 0, 0, 0, '73809'), -- �盟市民 - 73809 - Citizen Costume
(@CGUID+18, 0, 0, 0, 1, 0, 0, 0, 0, 0, '73811'), -- �盟市民 - 73811 - Citizen Costume
UPDATE `creature_template` SET `VehicleId`=2724 WHERE `entry`=68238; -- ç�«ç®æ�–æ�–椅
UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=24171; -- [DND] 다í�¬ë¬¸ ì¶•ì œ 대ìƒ�
UPDATE `creature_template` SET `VehicleId`=2724 WHERE `entry`=68239; -- è �å°¾ç�…æ�–æ�–椅
UPDATE `creature_template` SET `gossip_menu_id`=0 WHERE `entry`=14849; -- 暗月工作人員
UPDATE `creature_template` SET `minlevel`=1, `maxlevel`=1 WHERE `entry`=55270; -- 金波兒
UPDATE `creature_template` SET `VehicleId`=2724 WHERE `entry`=68232; -- �鷲���椅
UPDATE `creature_template` SET `minlevel`=1, `maxlevel`=1 WHERE `entry`=55271; -- 莎�
UPDATE `creature_template` SET `minlevel`=1, `maxlevel`=1 WHERE `entry`=55268; -- 阿迦
UPDATE `creature_template` SET `gossip_menu_id`=0 WHERE `entry`=14847; -- è–©æ�œæ–¯â€§å¸•é‡Œæ�教授
INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES
(55306, 55307, 0, UNKNOWN, 'æ°£ç�ƒæŽ¨è»\Š - æ°£ç�ƒæŽ¨è»\Šå…”å�', UNKNOWN, UNKNOWN); -- æ°£ç�ƒæŽ¨è»Š - æ°£ç�ƒæŽ¨è»Šå…”å�
DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+0;
INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 56887, 0, 0, 0, 0, 0, 0, 0, 44061); -- 14841 (ç‘žæž—)
DELETE FROM `gossip_menu` WHERE (`MenuID`=6225 AND `TextID`=@NPCTEXTID+0);
DELETE FROM `creature_template_addon` WHERE `entry` IN (178298 /*178298 (Widget)*/, 178299 /*178299 (Gizmo)*/, 54642 /*54642 (敵方å�¦å…‹) - Steam Tank Passive, Searching*/, 54643 /*54643 (æ•µæ–¹è¿·ä½ é£›è‰‡) - Steam Tank Passive, Bombs Away*/);
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
(178298, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 178298 (Widget)
(178299, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 178299 (Gizmo)
(54642, 0, 0, 0, 1, 0, 0, 0, 0, 0, '27747 102222'), -- 54642 (敵方�克) - Steam Tank Passive, Searching
(54643, 0, 0, 0, 1, 0, 0, 0, 0, 0, '27747 102209'), -- 54643 (æ•µæ–¹è¿·ä½ é£›è‰‡) - Steam Tank Passive; Bombs Away
UPDATE `creature_template_addon` SET `bytes1`=1 WHERE `entry`=55449; -- 55449 (è³“å ¤)
UPDATE `creature_template_addon` SET `mount`=39192 WHERE `entry`=55761; -- 55761 (�力浦)
UPDATE `creature_template_addon` SET `bytes1`=3 WHERE `entry`=55448; -- 55448 (é”é…·)
UPDATE `creature_template_addon` SET `visibilityDistanceType`=3, `auras`='46598 103320 16245' WHERE `entry`=55307; -- 55307 (æ°£ç�ƒæŽ¨è»Šå…”å�) - Ride Vehicle Hardcoded, Balloon Cart Contents, Freeze Anim
UPDATE `creature_template_addon` SET `auras`='46598 96847' WHERE `entry`=55306; -- 55306 (氣�推車) - Ride Vehicle Hardcoded, Blue Doll State
UPDATE `creature_template_addon` SET `aiAnimKit`=645 WHERE `entry`=55305; -- 55305 (�爾‧�德阿)
UPDATE `creature_template_addon` SET `visibilityDistanceType`=3 WHERE `entry`=74333; -- 74333 (Arco, Iniciar Corrida) - Powerup - Area Trigger - Start Arch
UPDATE `creature_template_addon` SET `auras`='101696 101734' WHERE `entry`=54490; -- 54490 (肚邊龜) - Ring Toss, Ring Toss
UPDATE `creature_template_addon` SET `auras`='46322' WHERE `entry`=55225; -- 55225 (�焰雜�師) - NPC Juggle Torch (Juggling)
UPDATE `creature_template_addon` SET `auras`='102905' WHERE `entry`=55226; -- 55226 (�焰雜�師) - NPC Juggle Torch Aura
UPDATE `creature_template_addon` SET `bytes1`=50331648, `emote`=0 WHERE `entry`=85484; -- 85484 (�斯特)
UPDATE `creature_template_addon` SET `auras`='46322' WHERE `entry`=55342; -- 55342 (�焰雜�師) - NPC Juggle Torch (Juggling)
UPDATE `creature_template_addon` SET `mount`=78112 WHERE `entry`=14823; -- 14823 (希拉斯‧暗月)
UPDATE `creature_template_addon` SET `auras`='102905' WHERE `entry`=55222; -- 55222 (�焰雜�師) - NPC Juggle Torch Aura
UPDATE `creature_template_addon` SET `auras`='102905' WHERE `entry`=55223; -- 55223 (�焰雜�師) - NPC Juggle Torch Aura
UPDATE `creature_template_addon` SET `auras`='43313' WHERE `entry`=24171; -- 24171 ([DND] 다í�¬ë¬¸ ì¶•ì œ 대ìƒ�) - Target Indicator
UPDATE `creature_template_addon` SET `visibilityDistanceType`=4 WHERE `entry`=74388; -- 74388 (Cartello dell'Accampamento) - Powerup - Area Trigger - Camp, Aura Very Tall - Yellow - State
UPDATE `creature_template_addon` SET `auras`='73813' WHERE `entry`=55348; -- 55348 (部�市民) - Citizen Costume
UPDATE `creature_template_addon` SET `bytes1`=1, `auras`='73811' WHERE `entry`=55347; -- 55347 (�盟市民) - Citizen Costume
INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
(6225, @NPCTEXTID+0, 44061); -- 14841 (ç‘žæž—)
DELETE FROM `gossip_menu` WHERE (`MenuID`=26888 AND `TextID`=42798) OR (`MenuID`=26818 AND `TextID`=42769) OR (`MenuID`=13012 AND `TextID`=18284) OR (`MenuID`=16967 AND `TextID`=24693);
INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
(26888, 42798, 44061), -- 181097 (Simon Sezdans)
(26818, 42769, 44061), -- 181097 (Simon Sezdans)
(13012, 18284, 44061), -- 54485 (潔西�‧羅傑斯)
(16967, 24693, 44061); -- 85519 (Christoph VonFeasel)
meji46 commented
I assume you have applied the latest TC commits regarding locales for creature_template. There has been an error generating the SQL files in the UPDATE queries. Names have been updated in the creature_template table instead of creature_template_locale (most of the creature names on your table will be from the locale zhTW).
mdX7 commented