HeyPretty
Verified Member
- 10
- 2016
- 6
- Location
- Seattle, WA
I run these every time I start a new DB so I hope they're helpful.
This will make everything free (money-wise) from all vendors.
This will make training costs free.
This lovely command will turn all bags into 36 slot containers. Tooltips are not updated but who cares?
This is a shining beacon for tradeskillers. This sets all stackable items to 1000. Used with the above code, and you'll be hard pressed to use up all of your bag space. Set stackable > 0 to make unstackable items stackable.
This will increase the drop rate from mobs. Just changing the settings in worldserver.conf isn't much of an improvement. Change that -20- to 75 or 100 for loot explosion.
These two queries will allow all players to wear gear 20 levels above their own.
This will make it easier to level your guild considering the smaller numbers of guild members.
This will make everything free (money-wise) from all vendors.
Code:
UPDATE `item_template` SET `BuyPrice` = 0;
This will make training costs free.
Code:
UPDATE `npc_trainer` SET `spellcost` = 0;
This lovely command will turn all bags into 36 slot containers. Tooltips are not updated but who cares?
Code:
UPDATE `item_template` SET `ContainerSlots` = 36 WHERE `ContainerSlots` > 0;
This is a shining beacon for tradeskillers. This sets all stackable items to 1000. Used with the above code, and you'll be hard pressed to use up all of your bag space. Set stackable > 0 to make unstackable items stackable.
Code:
UPDATE `item_template` SET `stackable` = 1000 WHERE `stackable` > 1;
This will increase the drop rate from mobs. Just changing the settings in worldserver.conf isn't much of an improvement. Change that -20- to 75 or 100 for loot explosion.
Code:
UPDATE creature_loot_template SET ChanceorQuestChance = ChanceorQuestChance * 20;
These two queries will allow all players to wear gear 20 levels above their own.
Code:
UPDATE `item_template` SET `RequiredLevel` = 1 WHERE `RequiredLevel` BETWEEN 1 AND 20;
UPDATE `item_template` SET `RequiredLevel` = `RequiredLevel` - 20 WHERE `RequiredLevel` > 20;
This will make it easier to level your guild considering the smaller numbers of guild members.
Code:
UPDATE `guild_xp_for_level` SET `xp_for_next_level` = (`xp_for_next_level` / 100);
Last edited: