Open StraysFromPath opened 1 year ago
I setup a medium between the three versions I think here's z_mounts_and_riding.sql
:
-- Re-enable Summon Felsteed (Warlock)
DELETE FROM `disables` WHERE `sourceType`=1 AND `entry` IN (3631, 4487, 4488, 4489, 4490);
-- Remove incorrect mail about riding which doesn't match Vanilla levels
DELETE FROM `mail_level_reward` WHERE `level` <= 60;
-- Move letter about cold weather flying to level 71 instead of 70, as in Wotlk classic
UPDATE `mail_level_reward` SET `level` = 71 WHERE `mailTemplateId` IN (285, 284);
-- Riding Skills
UPDATE npc_trainer SET ReqLevel=30 WHERE SpellID=33388;
UPDATE npc_trainer SET MoneyCost=120000 WHERE SpellID=33388;
UPDATE npc_trainer SET ReqLevel=60 WHERE SpellID=33391;
UPDATE npc_trainer SET MoneyCost=1500000 WHERE SpellID=33391;
UPDATE npc_trainer SET ReqLevel=70 WHERE SpellID=34090;
UPDATE npc_trainer SET MoneyCost=7500000 WHERE SpellID=34090;
DELETE FROM npc_trainer WHERE SpellID=13819;
DELETE FROM npc_trainer WHERE SpellID=23214;
DELETE FROM npc_trainer WHERE SpellID=34767;
DELETE FROM npc_trainer WHERE SpellID=23161;
UPDATE npc_trainer SET ReqLevel=30 WHERE SpellID=13820;
UPDATE npc_trainer SET ReqLevel=30 WHERE SpellID=34768;
UPDATE npc_trainer SET ReqLevel=30 WHERE SpellID=1710;
UPDATE npc_trainer SET ReqLevel=68 WHERE SpellID=33950;
If you wanted to make it exactly like WotLK simply don't ever run mounts_and_riding.sql
.
I setup a medium between the three versions I think here's
z_mounts_and_riding.sql
:-- Re-enable Summon Felsteed (Warlock) DELETE FROM `disables` WHERE `sourceType`=1 AND `entry` IN (3631, 4487, 4488, 4489, 4490); -- Remove incorrect mail about riding which doesn't match Vanilla levels DELETE FROM `mail_level_reward` WHERE `level` <= 60; -- Move letter about cold weather flying to level 71 instead of 70, as in Wotlk classic UPDATE `mail_level_reward` SET `level` = 71 WHERE `mailTemplateId` IN (285, 284); -- Riding Skills UPDATE npc_trainer SET ReqLevel=30 WHERE SpellID=33388; UPDATE npc_trainer SET MoneyCost=120000 WHERE SpellID=33388; UPDATE npc_trainer SET ReqLevel=60 WHERE SpellID=33391; UPDATE npc_trainer SET MoneyCost=1500000 WHERE SpellID=33391; UPDATE npc_trainer SET ReqLevel=70 WHERE SpellID=34090; UPDATE npc_trainer SET MoneyCost=7500000 WHERE SpellID=34090; DELETE FROM npc_trainer WHERE SpellID=13819; DELETE FROM npc_trainer WHERE SpellID=23214; DELETE FROM npc_trainer WHERE SpellID=34767; DELETE FROM npc_trainer WHERE SpellID=23161; UPDATE npc_trainer SET ReqLevel=30 WHERE SpellID=13820; UPDATE npc_trainer SET ReqLevel=30 WHERE SpellID=34768; UPDATE npc_trainer SET ReqLevel=30 WHERE SpellID=1710; UPDATE npc_trainer SET ReqLevel=68 WHERE SpellID=33950;
If you wanted to make it exactly like WotLK simply don't ever run
mounts_and_riding.sql
.
So cool!
This is interesting but you did not update any of the mount items so whilst you can ride at 30, you still cannot learn any mounts until 40.
@StraysFromPath haha yeah I totally missed those, I expected them to be in the file...these are the numbers I came up with for those but use whatever you want :).
/* Black Stallion Bridle */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 2411;
/* Palomino */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000, SellPrice = 0 WHERE entry = 2413;
/* Pinto Bridle */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 2414;
/* White Stallion */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000, SellPrice = 0 WHERE entry = 2415;
/* Swift Razzashi Raptor */
UPDATE item_template SET RequiredLevel = 60 WHERE entry = 19872;
/* Swift Zulian Tiger */
UPDATE item_template SET RequiredLevel = 60 WHERE entry = 19902;
/* Horn of the Red Wolf */
UPDATE item_template SET Quality = 4, bonding = 1, BuyPrice = 1000000 WHERE entry = 5663;
/* Horn of the Dire Wolf */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 5665;
/* Horn of the Brown Wolf */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 5668;
/* Horn of the Timber Wolf */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 1132;
/* Horn of the Winter Wolf */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000 WHERE entry = 1133;
/* Horn of the Gray Wolf */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000 WHERE entry = 1134;
/* Horn of the Black Wolf */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000 WHERE entry = 1041;
/* Reins of the Winterspring Frostsaber */
UPDATE item_template SET SellPrice = 0, RequiredLevel = 60 WHERE entry = 13086;
/* Whistle of the Ivory Raptor */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 13317;
/* Green Mechanostrider */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 13321;
/* Unpainted Mechanostrider */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 13322;
/* Purple Mechanostrider */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 13323;
/* Red and Blue Mechanostrider */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 13324;
/* Fluorescent Green Mechanostrider */
UPDATE item_template SET BuyPrice = 30000, RequiredLevel = 30 WHERE entry = 13325;
/* Icy Blue Mechanostrider Mod A */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 13327;
/* Black Ram */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 13328;
/* Frost Ram */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 13329;
/* Red Skeletal Horse */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 13331;
/* Blue Skeletal Horse */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 13332;
/* Brown Skeletal Horse */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 13333;
/* Green Skeletal Warhorse */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 13334;
/* Deathcharger's Reins */
UPDATE item_template SET Quality = 3, BuyPrice = 300000, SellPrice = 250000, RequiredLevel = 60 WHERE entry = 13335;
/* Reins of the Ancient Frostsaber */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 12302;
/* Reins of the Nightsaber */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 12303;
/* Reins of the Primal Leopard */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 12325;
/* Reins of the Tawny Sabercat */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 12326;
/* Reins of the Golden Sabercat */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 12327;
/* Horn of the Red Wolf */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 12330;
/* Horn of the Arctic Wolf */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 12351;
/* White Stallion Bridle */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 12353;
/* Palomino Bridle */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 12354;
/* Red Mechanostrider */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 8563;
/* Horn of the Skeletal Mount */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 100000 WHERE entry = 8583;
/* Whistle of the Mottled Red Raptor */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 8586;
/* Whistle of the Emerald Raptor */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 8588;
/* Old Whistle of the Ivory Raptor */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000 WHERE entry = 8589;
/* Old Whistle of the Obsidian Raptor */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000 WHERE entry = 8590;
/* Whistle of the Turquoise Raptor */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 8591;
/* Whistle of the Violet Raptor */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 8592;
/* Blue Mechanostrider */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 8595;
/* Reins of the Spotted Nightsaber */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 100000 WHERE entry = 8628;
/* Reins of the Striped Nightsaber */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 8629;
/* Reins of the Striped Dawnsaber */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 47100;
/* Reins of the Bengal Tiger */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000, SellPrice = 0 WHERE entry = 8630;
/* Reins of the Striped Frostsaber */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 8631;
/* Reins of the Spotted Frostsaber */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 8632;
/* Reins of the Leopard */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000, SellPrice = 0 WHERE entry = 8633;
/* Black War Steed Bridle */
UPDATE item_template SET BuyPrice = 30000 WHERE entry = 18241;
/* Reins of the Black War Tiger */
UPDATE item_template SET BuyPrice = 30000 WHERE entry = 18242;
/* Black Battlestrider */
UPDATE item_template SET BuyPrice = 30000 WHERE entry = 18243;
/* Black War Ram */
UPDATE item_template SET BuyPrice = 30000 WHERE entry = 18244;
/* Horn of the Black War Wolf */
UPDATE item_template SET BuyPrice = 30000 WHERE entry = 18245;
/* Whistle of the Black War Raptor */
UPDATE item_template SET BuyPrice = 30000 WHERE entry = 18246;
/* Black War Kodo */
UPDATE item_template SET BuyPrice = 30000 WHERE entry = 18247;
/* Red Skeletal Warhorse */
UPDATE item_template SET BuyPrice = 30000 WHERE entry = 18248;
/* Gray Kodo */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 15277;
/* Brown Kodo */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 15290;
/* Green Kodo */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 15292;
/* Teal Kodo */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 15293;
/* Gray Ram */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 5864;
/* Brown Ram */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 5872;
/* White Ram */
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry = 5873;
/* Harness: Black Ram */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000 WHERE entry = 5874;
/* Harness: Blue Ram */
UPDATE item_template SET Quality = 3, bonding = 1, BuyPrice = 30000 WHERE entry = 5875;
/* Horn of the Frostwolf Howler */
UPDATE item_template SET BuyPrice = 300000, RequiredLevel = 60 WHERE entry = 19029;
/* Stormpike Battle Charger */
UPDATE item_template SET BuyPrice = 300000, RequiredLevel = 60 WHERE entry = 19030;
/* Reins of the Swift Stormsaber */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 18902;
/* Reins of the Swift Frostsaber */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 18766;
/* Reins of the Swift Mistsaber */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 18767;
/* Reins of the Swift Dawnsaber */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 18768;
/* Swift Green Mechanostrider */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 18772;
/* Swift White Mechanostrider */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry = 18773;
/* Swift Yellow Mechanostrider */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18774;
/* Swift Palomino */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18776;
/* Swift Brown Steed */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18777;
/* Swift White Steed */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18778;
/* Swift White Ram */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18785;
/* Swift Brown Ram */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18786;
/* Swift Gray Ram */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18787;
/* Swift Blue Raptor */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18788;
/* Swift Olive Raptor */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18789;
/* Swift Orange Raptor */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18790;
/* Purple Skeletal Warhorse */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18791;
/* Great White Kodo */
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=18793;
--Blood Elf Racial Mounts
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry=28927;
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=28936;
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry=29220;
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry=29221;
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry=29222;
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=29223;
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=29224;
--Dranei Racial Mounts
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry=28481;
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry=29743;
UPDATE item_template SET BuyPrice = 30000, SellPrice = 0, RequiredLevel = 30 WHERE entry=29744;
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=29745;
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=29746;
UPDATE item_template SET BuyPrice = 300000, SellPrice = 0, RequiredLevel = 60 WHERE entry=29747;
60% Mount at 40 and 100% Mount at 60 is a little bit torture.
Can it be please optional for WOTLK style mount training during earlier phases?