[Tyrant1984]

I have the same issue on my server! Secrets tested my SQL on his server and it worked fine.



create new spellset 'sk_pet_test' ID 1015

INSERT INTO `npc_spells` (`id`, `name`, `parent_list`, `attack_proc`, `proc_chance`) VALUES
(1015, 'sk_pet_test', 0, -1, 3);

add level 58 SK pet to spellset ID 1015

INSERT INTO `npc_spells_entries` (`id`, `npc_spells_id`, `spellid`, `type`, `minlevel`, `maxlevel`, `manacost`, `recast_delay`, `priority`) VALUES
(8071, 1015, 495, 32, 1, 255, 0, -1, 20);

Create NPCID 999160 a lvl60 SK assigned with NPC_SPELLS_ID 1015

INSERT INTO `npc_types` (`id`,`name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`gender`,`texture`,`helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`npcspecialattks`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,`luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,`armortint_red`,`armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,`sec_melee_type`,`runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,`npc_aggro`,`spawn_limit`,`attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,`see_improved_hide`,`trackable`,`isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,`scalerate`,`private_corpse`,`unique_spawn_by_name`) VALUES ('999160','Madame_Serena','','60','71','5','1','200','1','0','0','6','0','0','0','0','1015','202','0','0','1','20','','55','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','28','28','1.3','6','6','6','6','6','6','1','1','0','84','0','0','0','0','94','94','94','94','94','94','94','0','0','1','0','1','0','0','0','0','0','100','0','0');

#dbspawn 999160 and she just sits there, does not work for me but for Secrets. Have maps files, restarted server, everything.


Also, my wizard froggies in sebilis and raid mobs don't cast at all either. The whole thing is like bugged. Code/DB is p. stock, haven't messed with spells tbh.

help QQ