[DiscordArchive] Hey guys, when i make from heidisql a custom npc, what do i need to change else in other tables ?
[DiscordArchive] Hey guys, when i make from heidisql a custom npc, what do i need to change else in other tables ?
Archived author: cyberpro98 • Posted: 2025-09-13T19:15:36.212000+00:00
Original source
Hey guys, when i make from heidisql a custom npc, what do i need to change else in other tables ?
Archived author: Ryan Turner • Posted: 2025-09-13T19:26:46.680000+00:00
Original source
creature_template and creature_template_model
Archived author: cyberpro98 • Posted: 2025-09-13T19:29:28.946000+00:00
Original source
I have done it all but kinda " doesn´t exist "
Archived author: cyberpro98 • Posted: 2025-09-13T19:29:32.365000+00:00
Original source
INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction, npcflag, speed_walk, speed_run, speed_swim, speed_flight, detection_range, scale, rank, dmgschool, DamageModifier, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, type, type_flags, lootid, pickpocketloot, skinloot, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, ExperienceModifier, RacialLeader, movementId, RegenHealth, mechanic_immune_mask, spell_school_immune_mask, flags_extra, ScriptName, VerifiedBuild) VALUES (900013, 0, 0, 0, 0, 0, 'Thunderfury Quest line', ' Echoes of Azeroth', 'Quest', 0, 80, 80, 0, 35, 2, 1.05, 1.14286, 1, 1, 18, 1, 0, 0, 1, 2000, 2000, 1, 1, 1, 768, 2048, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1.1, 1, 1, 1, 0, 0, 1, 0, 0, 2, '', 12340);
INSERT INTO creature_template_model (CreatureID, Idx, CreatureDisplayID, DisplayScale, Probability, VerifiedBuild) VALUES (900013, 0, 25517, 2, 1, 12340);
INSERT INTO creature_model_info (DisplayID, BoundingRadius, CombatReach, Gender, DisplayID_Other_Gender) VALUES (25517, 1, 0, 1, 0);
Archived author: Ryan Turner • Posted: 2025-09-13T19:31:13.865000+00:00
Original source
I'm not on the pc, you could use keira which makes it more easier to use.
Also that last number of creture_template refers to verifiedBuild (sniffed) you can keep it 0
Archived author: cyberpro98 • Posted: 2025-09-13T19:32:45.580000+00:00
Original source
AC> reload creature_template 900013
Entry 900013 not found in creature_template table.
Archived author: Ryan Turner • Posted: 2025-09-13T19:33:09.222000+00:00
Original source
You've to restart
Archived author: Ryan Turner • Posted: 2025-09-13T19:33:12.468000+00:00
Original source
not reload
Archived author: cyberpro98 • Posted: 2025-09-13T19:35:00.358000+00:00
Original source
I tried more times
Archived author: cyberpro98 • Posted: 2025-09-13T19:35:04.032000+00:00
Original source
Figured it out lol