[DiscordArchive] Speaking of ah-bot, does anyone happen to have an SQL script written to increase the number of items
[DiscordArchive] Speaking of ah-bot, does anyone happen to have an SQL script written to increase the number of items
Original source
Speaking of ah-bot, does anyone happen to have an SQL script written to increase the number of items that can be placed on the AH by the bot?
rektbyfaith
07-24-2023, 02:13 PM #1Archived author: Binarynova • Posted: 2023-07-24T14:13:08.368000+00:00
Original source
Speaking of ah-bot, does anyone happen to have an SQL script written to increase the number of items that can be placed on the AH by the bot?
Original source
lazy sql but
```SQL
-- alliance
UPDATE `mod_auctionhousebot` SET `maxitems` = x WHERE`auctionhouse` = 2;
-- horde
UPDATE`mod_auctionhousebot` SET `maxitems` = x WHERE `auctionhouse` = 6;
-- neutral
UPDATE `mod_auctionhousebot` SET `maxitems` = x WHERE `auctionhouse` = 7;
```
in config you can change AuctionHouseBot.ItemsPerCycle = 200 to whatever value per cycle that the bot runs
rektbyfaith
07-24-2023, 02:18 PM #2Archived author: samantha • Posted: 2023-07-24T14:18:51.254000+00:00
Original source
lazy sql but
```SQL
-- alliance
UPDATE `mod_auctionhousebot` SET `maxitems` = x WHERE`auctionhouse` = 2;
-- horde
UPDATE`mod_auctionhousebot` SET `maxitems` = x WHERE `auctionhouse` = 6;
-- neutral
UPDATE `mod_auctionhousebot` SET `maxitems` = x WHERE `auctionhouse` = 7;
```
in config you can change AuctionHouseBot.ItemsPerCycle = 200 to whatever value per cycle that the bot runs
Original source
Learn from it, it is pretty easy.
rektbyfaith
07-24-2023, 02:19 PM #3Archived author: samantha • Posted: 2023-07-24T14:19:21.597000+00:00
Original source
Learn from it, it is pretty easy.
Original source
Will do. SQL is just new and scary to me. Appreciate it!
rektbyfaith
07-24-2023, 02:19 PM #4Archived author: Binarynova • Posted: 2023-07-24T14:19:41.405000+00:00
Original source
Will do. SQL is just new and scary to me. Appreciate it!
Original source
i highly recommend setting up a dev/non-prod server to do testing if you're scared about changes
rektbyfaith
07-24-2023, 02:21 PM #5Archived author: DoctorB0NG • Posted: 2023-07-24T14:21:15.238000+00:00
Original source
i highly recommend setting up a dev/non-prod server to do testing if you're scared about changes
Original source
Oh for sure. I have a local setup that I'll test the script on before deploying.
rektbyfaith
07-24-2023, 02:24 PM #6Archived author: Binarynova • Posted: 2023-07-24T14:24:08.868000+00:00
Original source
Oh for sure. I have a local setup that I'll test the script on before deploying.
1 Guest(s)
1 Guest(s)