[DiscordArchive] so can you take a look at ... entries 95001 - 95026 and see if you have a '0' ?
[DiscordArchive] so can you take a look at ... entries 95001 - 95026 and see if you have a '0' ?
Archived author: Flavaflav • Posted: 2022-12-29T19:10:46.180000+00:00
Original source
```INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES (500145, 0, 0, 0, 0, 0, 30721, 0, 0, 0, 'GM Items', 'Blizzard Entertainment', NULL, 0, 80, 80, 0, 35, 4225, 1, 1.14286, 0.75, 3, 0, 0, 0, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 128, '0', 12340);```
Archived author: Flavaflav • Posted: 2022-12-29T19:13:23.399000+00:00
Original source
yeah he has an error in his inserts
Archived author: Guybrush • Posted: 2022-12-29T19:13:40.825000+00:00
Original source
yeah, 0 is an invalid value. It should either be an empty string, or the name of a script, or a fallback `ainame` value
Archived author: Flavaflav • Posted: 2022-12-29T19:13:45.049000+00:00
Original source
that should not be a '0' before 12340
Archived author: Flavaflav • Posted: 2022-12-29T19:13:59.682000+00:00
Original source
it should be '' ?
Archived author: Guybrush • Posted: 2022-12-29T19:14:09.297000+00:00
Original source
correct
Archived author: Flavaflav • Posted: 2022-12-29T19:14:24.816000+00:00
Original source
well that was fun to figure out ty!
Archived author: Guybrush • Posted: 2022-12-29T19:15:41.271000+00:00
Original source
I'll give credit where it's due. Shauren mentioned it about 6 hours ago https://discord.com/channels/37607328642...6300258355
Archived author: Guybrush • Posted: 2022-12-29T19:16:18.247000+00:00
Original source
Also https://github.com/TrinityCore/TrinityCo...1069-L1074 explicitly handles empty
Archived author: Flavaflav • Posted: 2022-12-29T19:18:02.202000+00:00
Original source
yeah I knew I had to search the DB but it was good to come home and read yours and Shauren's roadmap