AzerothCore-Content

AzerothCore-Content copied to clipboard

SQL/AzerothCoreHeirloomVendors.sql was outdated

2

I have modified the SQL, But I haven't tested it in detail. SET @BoA :=601704; SET @guid :=601704; DELETE FROM `creature_template` WHERE `entry`=@BoA; 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`,`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`,`RacialLeader`,`movementId`,`RegenHealth`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`VerifiedBuild`)VALUES (@BOA,0,0,0,0,0,25900,0,0,0,'GlowingSoul','HeirloomMerchant',NULL,0,63,64,1,35,130,1,1.14286,1,0,0,2000,2000,2,33024,2048,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,1,0,0,1,0,2,'',12340); -- Text...

zhangzc

The AzerothCorePersonalTeleporter.sql not working <-- same Problem, what was the fix?!?

2

Same Issue as well: got no gossip from the SQL-Code-Input:  ppishero told anything about missing SQL, but not just what is missing there - so pls tell me, anyone^^...

Hangasilly