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/13121/world-of-warcraft-server-for-windows-installation-guide/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'

Any advice on cleanning this up and/or stopping it from happening would be great.

Cheers

Darkelf

[Ambal]

Please, repost this bugreport in AuctionBot topic. Closed.