Auction Bot running endless list of delete and insert queries

[Auntie Mangos]

Hi,

I am currently running a mangos sever rev 11195 with the modified auction bot from cyberium as described in http://getmangos.eu/community/topic/13 … de/page/2/.

I think (well pretty sure) that I messed something up as when the server starts up it spends about 15-20 minutes delete and insert queries into the auction database, after it has done that everything seems to work smoothly.

0 ms] SQL: SELECT account FROM characters WHERE guid = '4294967295'

62 ms] SQL: DELETE FROM auction WHERE id = '88053'

0 ms] SQL: SELECT account FROM characters WHERE guid = '4294967295'

0 ms] SQL: SELECT account FROM characters WHERE guid = '4294967295'

HBot> Boost value used to fill AH! (if this happens often adjust both ItemsPerC

cle in ahbot.conf)

ameEvent 41 "Leader of Jin'Alai, Kutube'sa" started.

ameEvent 43 "Leader of Jin'Alai, Chulo" removed.

ext game event check in 598 seconds.

62 ms] SQL: DELETE FROM item_instance WHERE guid='103744'

77 ms] SQL: DELETE FROM auction WHERE id = '88055'

61 ms] SQL: DELETE FROM item_instance WHERE guid='103745'

62 ms] SQL: DELETE FROM auction WHERE id = '88056'

46 ms] SQL: DELETE FROM item_instance WHERE guid='103747'

46 ms] SQL: DELETE FROM auction WHERE id = '88058'

62 ms] SQL: DELETE FROM item_instance WHERE guid='103751'

76 ms] SQL: DELETE FROM auction WHERE id = '88062'

62 ms] SQL: DELETE FROM item_instance WHERE guid='103756'

46 ms] SQL: DELETE FROM auction WHERE id = '88067'

... then ...

[46 ms] SQL: INSERT INTO item_instance (guid,owner_guid,data,text) VALUES

(40763

5,4294967295,'407635 1191182336 3 21894 1065353216 0 4294967295 0 0 0 0 0 0 0 1

0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 ', '')

[61 ms] SQL: INSERT INTO auction (id,houseid,itemguid,item_template,itemowner,bu

youtprice,time,buyguid,lastbid,startbid,deposit) VALUES

('267731', '2', '407635'

, '21894', '4294967295', '57132', '1300966153', '0', '0', '10244', '0')

[0 ms] SQL: DELETE FROM item_instance WHERE guid = '407636'

[61 ms] SQL: INSERT INTO item_instance (guid,owner_guid,data,text) VALUES

(40763

6,4294967295,'407636 1191182336 3 37808 1065353216 0 4294967295 0 0 0 0 0 0 0 1

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 90 90 0 0 ', '')

[61 ms] SQL: INSERT INTO auction (id,houseid,itemguid,item_template,itemowner,bu

youtprice,time,buyguid,lastbid,startbid,deposit) VALUES

('267732', '2', '407636'

, '37808', '4294967295', '1028081', '1300966153', '0', '0', '348693', '0')

[16 ms] SQL: DELETE FROM item_instance WHERE guid = '407637'

[47 ms] SQL: INSERT INTO item_instance (guid,owner_guid,data,text) VALUES

(40763

7,4294967295,'407637 1191182336 3 20971 1065353216 0 4294967295 0 0 0 0 0 0 0 1

0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 ', '')

[46 ms] SQL: INSERT INTO auction (id,houseid,itemguid,item_template,itemowner,bu

youtprice,time,buyguid,lastbid,startbid,deposit) VALUES

('267733', '2', '407637'

, '20971', '4294967295', '2566', '1300991353', '0', '0', '725', '0')

[15 ms] SQL: DELETE FROM item_instance WHERE guid = '407638'

Cheers

Darkelf

[rmensen]

The endless list all depends on how your ahbot.conf is configurated (mine does the same ).

I can help you with 2 things:

1. You could try to change the numbers behind the: "AuctionHouseBot.Items.Amount." to make the DELETE & INSERT faster.

2. Or change the number behind the: "AuctionHouseBot.ItemsPerCycle.Normal =" to a higher number than the default of 20, what (if I'm right) is calculated in minutes.

NOTE: If you make changes to the ahbot.conf file and you have the server running, you have to use the: ".ahbot reload" command in the mangosd.exe to make it work.

[Unkle Nuke]

When referring to using cyberium's AHBot, are you using his Git repository to patch AHBot into the core?

If so, that is your mistake. AHBot is now an official part of the core and is included with the sources. There have been several improvements and bug fixes since cyberium last worked upon the patch.