[Archive] 4.3.4 SQL commands to make your ingame experience betterr
[Archive] 4.3.4 SQL commands to make your ingame experience betterr
Original source
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.
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);
rektbyfaith
11-04-2025, 05:04 PM #1Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
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.
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);
Original source
Thanks for the small tutorial! I'm sure it'll come in handy for some
![[Image: 1f642.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
rektbyfaith
11-04-2025, 05:04 PM #2Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
Thanks for the small tutorial! I'm sure it'll come in handy for some
Original source
The "stackable" command is absolutely the top, didn't ever think of that by myself
![[Image: 1f631.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
k:
rektbyfaith
11-04-2025, 05:04 PM #3Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
The "stackable" command is absolutely the top, didn't ever think of that by myself k:
Original source
These all look great, can't wait to give them a try! Thanks
rektbyfaith
11-04-2025, 05:04 PM #4Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
These all look great, can't wait to give them a try! Thanks
Original source
Just cane across this thread, and some of these look absolutely phenomenal! Thanks so much for posting!
rektbyfaith
11-04-2025, 05:04 PM #5Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
Just cane across this thread, and some of these look absolutely phenomenal! Thanks so much for posting!
Original source
This will be helpful, thank you for posting
rektbyfaith
11-04-2025, 05:04 PM #6Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
This will be helpful, thank you for posting
Original source
This was useful, thank you very mutch
rektbyfaith
11-04-2025, 05:04 PM #7Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
This was useful, thank you very mutch
Original source
Very helpful! Thanks for sharing
rektbyfaith
11-04-2025, 05:04 PM #8Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
Very helpful! Thanks for sharing
Original source
Stack to 1000 units ? OMG YES
I still have nightmares with bags full of mats xD
rektbyfaith
11-04-2025, 05:04 PM #9Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
Stack to 1000 units ? OMG YES
I still have nightmares with bags full of mats xD
Original source
Could be usefull at some point ??
![[Image: 263a.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/263a.png)
rektbyfaith
11-04-2025, 05:04 PM #10Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
Could be usefull at some point ??
1 Guest(s)
1 Guest(s)