noslid7

hey, its not work, but, grats to try to help, 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); /* Erro SQL (1064):...

This work on 12/02/2023 "The error you are facing is due to the reserved word 'rank' in your SQL script. 'Rank' is a reserved word in MySQL and, therefore, cannot...

My problem is that the cannon is not dealing damage; the damage is low