Sorry for the delayed response. Just got back from my holiday. Let me try and demonstrate what I did to make a level 70 Monster Summoning pet (since I believe previously, they only went up to 60).
First, I created a new NPC with the stats I wanted (all test data, I didn't really tweak it properly):
Code:
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`, `mindmg`, `maxdmg`, `npcspecialattks`, `aggroradius`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `d_meele_texture1`, `d_meele_texture2`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `see_invis`, `qglobal`, `see_invis_undead`, `AC`, `npc_aggro`, `spawn_limit`, `attack_speed`, `findable`, `STR`, `STA`, `DEX`, `AGI`, `_INT`, `WIS`, `CHA`) VALUES (639, 'MonsterSum5', NULL, 70, 0, 1, 24, 4200, 2, 0, 0, 9, 90, 0, 0, 0, 163, 0, 200, 680, '', 0, 1, 1, 1, 1, 1, 1, 0, 0, 0, 2, 305, 305, 305, 305, 305, 0, 0, 1, 1200, 0, 0, 0, 0, 305, 305, 305, 305, 305, 305, 305);
Note: I forced 'id' 639 because in the stock database it appears pets are below 1000, and ended at 638.
Then I went to table: pets, and inserted this record at the end:
Code:
INSERT INTO `pets` (`type`, `npcID`, `temp`) VALUES ('MonsterSum5', 639, 0);
This gave me my path from Pets to NPC_types so when I used #makepet [type], the right NPC showed up.
Finally, in game I can now type #makepet MonsterSum5 and get Gebobtik to show up and give me my much needed support. Things to note, the body type of the NPC you are trying to spawn needs to be in the zone_chr.txt file, or in the global_chr.txt so the pet doesn't show up as a human model with bad hair. Also, you might need to mess with Gender once in a while. I am finding many inconsistencies with how things appear simply because they are not #gender 2 or something.
As for adding a pet-summoning spell or effect, that is not something I have tried yet. Messing with spells data scares me. Good luck, and I hope this helps a little.