[Trinity] Recreating the Legend of the Bengal Tiger

[FrostyC]

So we all know the Legend of the Bengal Tiger Cave in STV. If not, read about it here. Well I've made an SQL script that recreates the myth. I used this video for reference.
This was made for Trinity, it might work with some other emulators, but I wouldn't try it unless you've confirmed it does work for your database first.

Here's what this SQL does:

1. Remove "Tiger Riding" skill requirement from 3 of the 4 mounts, changing it to current Riding skill.
2. Make the mounts Bind on Pickup (they are currently Bind on Use, not good unless you want AH flooded with them).
3. Make the World Mount Vendor NPC an actual vendor.
4. Add all 4 mounts to World Mount Vendor's vendor list.
5. Spawn the vendor.
6. Create a .tele command to the Bengal Tiger Cave.

Just execute the SQL on your world DB, then .tele BengalTigerCave to check it out.
The generic teleport is .go xyz -12836.4 -1379.02 112.721 if anyone is wondering.

Pastebin
MultiUpfile
MirrorUpload.net
OWNEDCORE ATTACHMENT: Legend of the Bengal Tiger.zip

View Code:

/*Fix Items that require "Tiger Riding" skill to normal Riding Skill & make them BoP*/
REPLACE INTO `item_template` (`entry`, `RequiredSkill`, `RequiredSkillRank`, `bonding`) VALUES (8627, 762, 75, 3);
REPLACE INTO `item_template` (`entry`, `RequiredSkill`, `RequiredSkillRank`, `bonding`) VALUES (8630, 762, 75, 3);
REPLACE INTO `item_template` (`entry`, `RequiredSkill`, `RequiredSkillRank`, `bonding`) VALUES (8633, 762, 75, 3);

/*Add Vendor Flag (npcflag 128) for vendor to "World Mount Vendor" (NPC 7747)*/
REPLACE INTO `creature_template` (`entry`, `npcflag`) VALUES (7747, 128);

/*Adds Items to "World Mount Vendor" (NPC 7747)*/
INSERT INTO `npc_vendor` (`entry`, `item`) VALUES (7747, 8627);
INSERT INTO `npc_vendor` (`entry`, `item`) VALUES (7747, 8628);
INSERT INTO `npc_vendor` (`entry`, `item`) VALUES (7747, 8630);
INSERT INTO `npc_vendor` (`entry`, `item`) VALUES (7747, 8633);

/*Spawn "World Mount Vendor" (NPC 7747) in the Cave*/
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (5000000, 7747, 0, 1, 1, 0, 0, -12833.5, -1377.17, 112.917, 3.74826, 300, 0, 0, 198, 0, 0, 0, 0, 0, 0);

/*Create a .tele command called "BengalTigerCave"*/
INSERT INTO `game_tele` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES (10000, -12836.4, -1379.02, 112.721, 0.871346, 0, 'BengalTigerCave');