[DiscordArchive] Shouldn't this give me all 3,000+ items that can be stacked up to 20?
[DiscordArchive] Shouldn't this give me all 3,000+ items that can be stacked up to 20?
Original source
Shouldn't this give me all 3,000+ items that can be stacked up to 20?
rektbyfaith
09-07-2022, 04:39 AM #1Archived author: XSNomad • Posted: 2022-09-07T04:39:20.406000+00:00
Original source
Shouldn't this give me all 3,000+ items that can be stacked up to 20?
Original source
`--where="stackable=20"`
rektbyfaith
09-07-2022, 11:35 PM #2Archived author: Revision • Posted: 2022-09-07T23:35:56.371000+00:00
Original source
`--where="stackable=20"`
Original source
That just gives me two items. " or no " same results.
![[Image: unknown.png?ex=690c4335&is=690af1b5&hm=1...d47d837b9&]](https://cdn.discordapp.com/attachments/369084351129845760/1017323896317419540/unknown.png?ex=690c4335&is=690af1b5&hm=1c558f083dd17fb82b1f4ce2dee1c8a5917d98b5d57ada3543b7d55d47d837b9&)
rektbyfaith
09-08-2022, 06:41 AM #3Archived author: XSNomad • Posted: 2022-09-08T06:41:58.001000+00:00
Original source
That just gives me two items. " or no " same results.
Original source
nvm, it's all on one line
rektbyfaith
09-08-2022, 06:42 AM #4Archived author: XSNomad • Posted: 2022-09-08T06:42:55.057000+00:00
Original source
nvm, it's all on one line
Original source
I'm looking for a 'quick' way to double the stack size. Is there an update set stackable =40 where stachable=20 command I can run?
rektbyfaith
09-08-2022, 06:44 AM #5Archived author: XSNomad • Posted: 2022-09-08T06:44:42+00:00
Original source
I'm looking for a 'quick' way to double the stack size. Is there an update set stackable =40 where stachable=20 command I can run?
Original source
```UPDATE `item_template` SET `stackable` = 40 WHERE `stackable` = 20;```
rektbyfaith
09-08-2022, 07:00 AM #6Archived author: Bench • Posted: 2022-09-08T07:00:45.218000+00:00
Original source
```UPDATE `item_template` SET `stackable` = 40 WHERE `stackable` = 20;```
Original source
This is what I thought but wasn't 100% sure. Thanks for confirming.
rektbyfaith
09-08-2022, 01:50 PM #7Archived author: XSNomad • Posted: 2022-09-08T13:50:23.318000+00:00
Original source
This is what I thought but wasn't 100% sure. Thanks for confirming.
Original source
```
Query OK, 3364 rows affected (0.12 sec)
Rows matched: 3364 Changed: 3364 Warnings: 0
```
rektbyfaith
09-08-2022, 01:51 PM #8Archived author: XSNomad • Posted: 2022-09-08T13:51:26.428000+00:00
Original source
```
Query OK, 3364 rows affected (0.12 sec)
Rows matched: 3364 Changed: 3364 Warnings: 0
```