Interesting fun server trainer, Have a vanity pet spell trainer

[Kuraria]

you can have a trainer teach you all vanity pet summons =D let me know what you guys think. eliminates the need for a pet item vendor plus there are some pets you'd have to make custom items to summon because they have a summon spell but no retail item. includes some pets you can't get normally like the corrupted kitten from the horde quest in felwood.

http://i320.photobucket.com/albums/n...208_044523.jpg

if you have any issues when you try and summon odds are there isn't a creature_proto for that pet which I ran into a lot so you just use.

REPLACE INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`attacktype`,`mindamage`,`maxdamage`,`can_ranged`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`respawntime`,`armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money`,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`fly_speed`,`extra_a9_flags`,`spell1`,`spell2`,`spell3`,`spell4`,`spell_flags`,`modImmunities`) VALUES (<<put creature entry here>>,1,1,35,64,64,0,1,16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.5,0.35,'',0,0,0,0,2.5,8,14,0,0,0,0,0,0,0);

Filebeam - Free Fast File Hosting

**** useful mysql query to flesh out missing proto's in your database ****

alot of times it fixes spells you didn't know were broken or how they were =D

SELECT creature_names.entry, creature_proto.entry FROM creature_names
LEFT JOIN creature_proto ON creature_names.entry = creature_proto.entry WHERE creature_proto.entry IS NULL

using this will give you a list of any missing creature_proto in your database.. I used it to weed out the pets that wouldn't summon because of the missing data. if anyone needs help let me know and I'll do my best.

[Hellgawd]

That's pretty cool! =]

[yrref]

coooooooooooooooool

[Warwenw]

That is AWESOME!
I'll truly use this thanks a bunch!
+Rep (my second and last for today)

Regards WarWenW

[Kuraria]

ty for all the replies and I'm happy everyone enjoys it... if you have any suggestions just let me know... I know a little bit about stuff so if anyone have a idea and needs some help with it lemme know.

[Ezio]

Uhmm , Good Release , Have Mini Tyrael? All mini pets?

[Kuraria]

*edit* added sql query to first posting =D

[Kuraria]

Uhmm , Good Release , Have Mini Tyrael? All mini pets?

147 mini pets in all some of which you can't get other then learning the spell to summon them. and yes Mini Tyrael is included. I think it's a uhmmm... great release for someone that didn't copy and paste it from a svn or repack. this was both a learning task and labor of love enjoying blizz's in game non-combat pets.

[Ascent[Tech]]

Lol, nice done dude! :]

+Rep cookie to you.

[Kuraria]

Lol, nice done dude! :]

+Rep cookie to you.

*bow* thank you... thank you... any corrections, additions or suggestions are greatly appreciated. this would include new vendors, trainers or maybe even bosses.

[Stevengeek]

Hehe, nice

[svedin]

thats nice

[Sounddead]

Great job +rep x2

[Kuraria]

I'm currently working a new mall location... working really hard on it with original spawns, vendors and quests. hopefully its this well received =D

[Aelus]

Haha, cool stuff.