[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
How do I apply this?
rektbyfaith
11-04-2025, 05:04 PM #11Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
How do I apply this?
Original source
Open your SQL program (heidisql, navicat etc.) and apply a query (make sure to insert the correct values)
rektbyfaith
11-04-2025, 05:04 PM #12Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
Open your SQL program (heidisql, navicat etc.) and apply a query (make sure to insert the correct values)
Original source
thank you so much
rektbyfaith
11-04-2025, 05:04 PM #13Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
thank you so much
Original source
:aimer: (Y)
rektbyfaith
11-04-2025, 05:04 PM #14Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
:aimer: (Y)
Original source
Sorry to necro an old post, however I discovered that setting stack size for EVERYTHING has 2 problems...
First makes items no longer able to be disenchanted.
Second, it lowers all items that should remain higher than 1000.... such as honor points. etc..
Here is the SYNTAX FIX:
UPDATE `item_template` SET `stackable` = 1000 WHERE `stackable` BETWEEN 2 AND 999;
That will make anything between those numbers stack to 1000 with out lowering the higher value stacked items such as honor points, etc.
hope this helps
=)
rektbyfaith
11-04-2025, 05:04 PM #15Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
Sorry to necro an old post, however I discovered that setting stack size for EVERYTHING has 2 problems...
First makes items no longer able to be disenchanted.
Second, it lowers all items that should remain higher than 1000.... such as honor points. etc..
Here is the SYNTAX FIX:
UPDATE `item_template` SET `stackable` = 1000 WHERE `stackable` BETWEEN 2 AND 999;
That will make anything between those numbers stack to 1000 with out lowering the higher value stacked items such as honor points, etc.
hope this helps
=)
Original source
Thanks, these are good for funservers.
rektbyfaith
11-04-2025, 05:04 PM #16Archived author: HeyPretty • Posted: 2025-11-04T18:04:26.328475
Original source
Thanks, these are good for funservers.
1 Guest(s)
1 Guest(s)