[SQL Query] File to Add Small Pets to Vendor

[Whitethebunny]

Simple SQL query to add Small Pets to a vendor, also Vendor query available at bottom.

Directions:
-Copy text into a Notepad document.
-Run a 'Replace' replacing: ##### with your Vendors ID.
-Save file as "[Anything].sql"
-Run query in your database.

Note: If you do not have a 2.4 database, simply remove all of the queries following the item entry "8489" i.e. Delete entries 35227 and on.

INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '11825', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '11826', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '4401', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '10398', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '34492', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '34493', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '23713', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '32588', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '20371', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '23083', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '34425', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '13584', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '32616', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '32622', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '30360', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '33993', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '25535', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '13583', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '22114', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '33154', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '32617', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '34478', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '32233', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '13582', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '19450', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '11023', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '34535', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '10360', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '29958', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '29901', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '29364', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '10361', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '29960', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '8485', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '8486', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '8487', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '8488', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '8489', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '35227', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '35350', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '32498', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '33818', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '38628', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '35504', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '34955', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '35349', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '38050', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '33816', '1', '0');
INSERT INTO `vendors` (`entry`, `item`, `amount`, `max_amount`) VALUES ('#####', '39656', '1', '0');

SQL Query for a Small Pets vendor.

Directions:
-Copy text into a Notepad document.
-Run a 'Replace' replacing: ##### with your Vendors ID.
-Save file as "[Anything-NPC].sql"
-Run query in your database.

INSERT INTO `creature_names` (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `civilian`, `Leader`, `entry`) VALUES ('Small Pets', 'Vendor', '', '0', '0', '0', '8909', '0', '0', '0', '0', NULL, '#####');
INSERT INTO `creature_proto` (`minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `auras`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `entry`) VALUES ('70', '70', '35', '10000', '10000', '100', '3', '4224', '1500', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14', '#####');

[Hellgawd]

Pretty nifty. Here's an idea for next time, or even edit this for this time: Make the vendor for us!
Save us the work.

[dongel]

Looks good , im gonna check it out