[Patch] Auction House Bot (Xeross' Branch)

[mrelfire]

I have recompiled this morning, strange thing happened : every items are sold at 0, and I can not buy any : is their a new config options?

[cyberium]

Abnormal, verify theses settings :

AuctionHouseBot.Alliance.Price.Ratio = 200
AuctionHouseBot.Horde.Price.Ratio = 200
AuctionHouseBot.Neutral.Price.Ratio = 200
AuctionHouseBot.BuyPrice.Seller = 1

[Obliviron]

How do i make a patch for http://github.com/cyberium/mangos/tree/new_ahbot?

Sorry, i'm just a noob

[Skirnir]

@cyberium, thats what I reported as "quite spendable". For MySQL tables, check my post.

I have recompiled this morning, strange thing happened : every items are sold at 0, and I can not buy any : is their a new config options?

Tested it with AuctionHouseBot. ... .Ratio = 200, but remains.

Yours

Skirnir

[mrelfire]

My config below

AuctionHouseBot.Alliance.Items.Amount.Ratio = 33

AuctionHouseBot.Horde.Items.Amount.Ratio = 33

AuctionHouseBot.Neutral.Items.Amount.Ratio = 66

AuctionHouseBot.Name = "Greedy"

AuctionHouseBot.MinTime = 1

AuctionHouseBot.MaxTime = 72

AuctionHouseBot.Items.Vendor = 1

AuctionHouseBot.Items.Loot = 1

AuctionHouseBot.Items.Misc = 1

AuctionHouseBot.Bind.No = 1

AuctionHouseBot.Bind.Pickup = 0

AuctionHouseBot.Bind.Equip = 1

AuctionHouseBot.Bind.Use = 1

AuctionHouseBot.Bind.Quest = 0

AuctionHouseBot.ItemsPerCycle.Boost = 4000

AuctionHouseBot.ItemsPerCycle.Normal = 1000

AuctionHouseBot.BuyPrice.Seller = 1

AuctionHouseBot.BuyPrice.Buyer = 0

AuctionHouseBot.Alliance.Price.Ratio = 50

AuctionHouseBot.Horde.Price.Ratio = 50

AuctionHouseBot.Neutral.Price.Ratio = 50

AuctionHouseBot.Items.ItemLevel.Min = 0

AuctionHouseBot.Items.ItemLevel.Max = 0

AuctionHouseBot.Items.ReqLevel.Min = 0

AuctionHouseBot.Items.ReqLevel.Max = 0

AuctionHouseBot.Items.ReqSkill.Min = 0

AuctionHouseBot.Items.ReqSkill.Max = 0

AuctionHouseBot.Items.Amount.Grey = 0

AuctionHouseBot.Items.Amount.White = 10000

AuctionHouseBot.Items.Amount.Green = 12000

AuctionHouseBot.Items.Amount.Blue = 14000

AuctionHouseBot.Items.Amount.Purple = 14000

AuctionHouseBot.Items.Amount.Orange = 12000

AuctionHouseBot.Items.Amount.Yellow = 10000

AuctionHouseBot.Class.Consumable = 6

AuctionHouseBot.Class.Container = 4

AuctionHouseBot.Class.Weapon = 8

AuctionHouseBot.Class.Gem = 3

AuctionHouseBot.Class.Armor = 8

AuctionHouseBot.Class.Reagent = 1

AuctionHouseBot.Class.Projectile = 2

AuctionHouseBot.Class.TradeGood = 10

AuctionHouseBot.Class.Generic = 1

AuctionHouseBot.Class.Reciepe = 6

AuctionHouseBot.Class.Quiver = 1

AuctionHouseBot.Class.Quest = 1

AuctionHouseBot.Class.Key = 1

AuctionHouseBot.Class.Misc = 5

AuctionHouseBot.Class.Glyph = 3

# Buyer config

AuctionHouseBot.Alliance.Buyer.Enabled = 1

AuctionHouseBot.Horde.Buyer.Enabled = 1

AuctionHouseBot.Neutral.Buyer.Enabled = 1

AuctionHouseBot.Buyer.Bid.Interval = 1

AuctionHouseBot.Buyer.BidDigin.Interval = 1

AuctionHouseBot.BuyerPrice.Grey = 1

AuctionHouseBot.BuyerPrice.White = 1

AuctionHouseBot.BuyerPrice.Green = 5

AuctionHouseBot.BuyerPrice.Blue = 12

AuctionHouseBot.BuyerPrice.Purple = 15

AuctionHouseBot.BuyerPrice.Orange = 20

AuctionHouseBot.BuyerPrice.Yellow = 22

I have played as you sayd but nothing, still the problem

[cyberium]

Ok i see the error, i will push correction after some test.

@cyberium, thats what I reported as "quite spendable". For MySQL tables, check my post.

Sorry some time i have don't understaind at first read some english expression (anyway your table was clear about this but i was looking only on AH number)

[Obliviron]

No items making for me too.

I use same settings as guy above and auctionhouse is empty.

[cyberium]

Update :

- More precise price now.

- Avoid zero cost. But if you set price.ratio very low you will get lot of item with minimal price (1c)

- Remove trailing space.

[mrelfire]

try this morning, but still same problems

I am not lucky

[Skirnir]

Works* :-)

Thanks a lot cyberium.

Yours Skirnir

* http://paste2.org/p/998777

[mrelfire]

Works* :-)

Thanks a lot cyberium.

Yours Skirnir

* http://paste2.org/p/998777

Did you change something, di you make something special ?

[cyberium]

mysql> SELECT * FROM auction WHERE buyoutprice = 0;
Empty set

mysql> SELECT * FROM auction WHERE buyoutprice = 1
;
+-------+---------+----------+---------------+------------+-------------+------------+---------+---------+----------+---------+
| id    | houseid | itemguid | item_template | itemowner  | buyoutprice | time       | buyguid | lastbid | startbid | deposit |
+-------+---------+----------+---------------+------------+-------------+------------+---------+---------+----------+---------+
|  1548 |       2 |  1197137 |          5051 | 4294967295 |           1 | 1285331278 |       0 |       0 |        1 |       0 |
|  5348 |       2 |  1200937 |         23473 | 4294967295 |           1 | 1285388938 |       0 |       0 |        1 |       0 |
|  6201 |       2 |  1201790 |          6096 | 4294967295 |           1 | 1285198198 |       0 |       0 |        1 |       0 |
| 17309 |       2 |  1212898 |         23473 | 4294967295 |           1 | 1285324318 |       0 |       0 |        1 |       0 |
|  7176 |       2 |  1202765 |           148 | 4294967295 |           1 | 1285273798 |       0 |       0 |        1 |       0 |
| 10170 |       2 |  1205759 |          6097 | 4294967295 |           1 | 1285403458 |       0 |       0 |        1 |       0 |
| 11700 |       2 |  1207289 |          6134 | 4294967295 |           1 | 1285201918 |       0 |       0 |        1 |       0 |
| 11754 |       2 |  1207343 |         25874 | 4294967295 |           1 | 1285407118 |       0 |       0 |        1 |       0 |
| 12947 |       2 |  1208536 |          6125 | 4294967295 |           1 | 1285367578 |       0 |       0 |        1 |       0 |
| 13625 |       2 |  1209214 |           154 | 4294967295 |           1 | 1285327978 |       0 |       0 |        1 |       0 |
| 17391 |       2 |  1212980 |          6125 | 4294967295 |           1 | 1285248898 |       0 |       0 |        1 |       0 |
| 13856 |       2 |  1209445 |         25874 | 4294967295 |           1 | 1285421578 |       0 |       0 |        1 |       0 |
| 14016 |       2 |  1209605 |           148 | 4294967295 |           1 | 1285363978 |       0 |       0 |        1 |       0 |
| 14579 |       2 |  1210168 |         25874 | 4294967295 |           1 | 1285378378 |       0 |       0 |        1 |       0 |
| 15049 |       2 |  1210638 |           127 | 4294967295 |           1 | 1285320838 |       0 |       0 |        1 |       0 |
| 15087 |       2 |  1210676 |            53 | 4294967295 |           1 | 1285194838 |       0 |       0 |        1 |       0 |
| 15450 |       2 |  1211039 |         25874 | 4294967295 |           1 | 1285346098 |       0 |       0 |        1 |       0 |
| 15472 |       2 |  1211061 |           119 | 4294967295 |           1 | 1285349698 |       0 |       0 |        1 |       0 |
+-------+---------+----------+---------------+------------+-------------+------------+---------+---------+----------+---------+
18 rows in set
mysql> 

AuctionHouseBot.Alliance.Items.Amount.Ratio = 200
AuctionHouseBot.Horde.Items.Amount.Ratio = 0
AuctionHouseBot.Neutral.Items.Amount.Ratio = 50

AuctionHouseBot.Name = "AhBot"
AuctionHouseBot.MinTime = 1
AuctionHouseBot.MaxTime = 72

AuctionHouseBot.Items.Vendor = 1
AuctionHouseBot.Items.Loot = 1
AuctionHouseBot.Items.Misc = 1
AuctionHouseBot.Bind.No = 1
AuctionHouseBot.Bind.Pickup = 0
AuctionHouseBot.Bind.Equip = 1
AuctionHouseBot.Bind.Use = 1
AuctionHouseBot.Bind.Quest = 0

AuctionHouseBot.ItemsPerCycle.Boost = 2000
AuctionHouseBot.ItemsPerCycle.Normal = 200
AuctionHouseBot.BuyPrice.Seller = 1
AuctionHouseBot.BuyPrice.Buyer = 0
AuctionHouseBot.Alliance.Price.Ratio = 50
AuctionHouseBot.Horde.Price.Ratio = 200
AuctionHouseBot.Neutral.Price.Ratio = 200

AuctionHouseBot.Items.ItemLevel.Min = 0
AuctionHouseBot.Items.ItemLevel.Max = 0
AuctionHouseBot.Items.ReqLevel.Min = 0
AuctionHouseBot.Items.ReqLevel.Max = 0
AuctionHouseBot.Items.ReqSkill.Min = 0
AuctionHouseBot.Items.ReqSkill.Max = 0

AuctionHouseBot.Items.Amount.Grey = 0
AuctionHouseBot.Items.Amount.White = 2000
AuctionHouseBot.Items.Amount.Green = 2500
AuctionHouseBot.Items.Amount.Blue = 1500
AuctionHouseBot.Items.Amount.Purple = 1500
AuctionHouseBot.Items.Amount.Orange = 0
AuctionHouseBot.Items.Amount.Yellow = 0

AuctionHouseBot.Class.Consumable = 6
AuctionHouseBot.Class.Container = 4
AuctionHouseBot.Class.Weapon = 8
AuctionHouseBot.Class.Gem = 3
AuctionHouseBot.Class.Armor = 8
AuctionHouseBot.Class.Reagent = 1
AuctionHouseBot.Class.Projectile = 2
AuctionHouseBot.Class.TradeGood = 10
AuctionHouseBot.Class.Generic = 1
AuctionHouseBot.Class.Reciepe = 6
AuctionHouseBot.Class.Quiver = 1
AuctionHouseBot.Class.Quest = 1
AuctionHouseBot.Class.Key = 1
AuctionHouseBot.Class.Misc = 5
AuctionHouseBot.Class.Glyph = 3

# Buyer config
AuctionHouseBot.Alliance.Buyer.Enabled = 1
AuctionHouseBot.Horde.Buyer.Enabled = 1
AuctionHouseBot.Neutral.Buyer.Enabled = 1

AuctionHouseBot.Buyer.Bid.Interval = 1
AuctionHouseBot.Buyer.BidDigin.Interval = 1

AuctionHouseBot.BuyerPrice.Grey = 1
AuctionHouseBot.BuyerPrice.White = 1
AuctionHouseBot.BuyerPrice.Green = 5
AuctionHouseBot.BuyerPrice.Blue = 12
AuctionHouseBot.BuyerPrice.Purple = 15
AuctionHouseBot.BuyerPrice.Orange = 20
AuctionHouseBot.BuyerPrice.Yellow = 22

about 17000 items and no 0 cost.

Do not forget, before launch just patched server clean auction database manualy.

I will implement soon new ingame command to rebuild all auction data

[mrelfire]

Do not forget, before launch just patched server clean auction database manualy.

I will implement soon new ingame command to rebuild all auction data

=> Do we just need to truncate the table auction ?

=> I have tryed ahbot expire => seems not working

[cyberium]

Yes do something like

mysql> DELETE FROM auction WHERE itemowner=4294967295 AND lastbid=0;

All ingame command are disabled. Work in progress...

[mrelfire]

after truncating the table everything is back to "normal" => thanks and great job

[thcobl]

Hi,

does anyone has some new patchfile for me

when i try to make it myself i only get errors

git clone git://github.com/xeross/mangos.git ahbot

cd ahbot

git checkout -b ahbot origin/ahbot

git diff 4bbb824c8088d28d9736bea51edcda586c471901 ahbot > ../ahbot.patch

[vladex]

the branch has been changed , to git://github.com/cyberium/mangos.git new_ahbot , this is "beta" ahbot, xeross's one is outdated i think.

[mnocz]

Hi,

does anyone has some new patchfile for me

when i try to make it myself i only get errors

git clone git://github.com/xeross/mangos.git ahbot

cd ahbot

git checkout -b ahbot origin/ahbot

git diff 4bbb824c8088d28d9736bea51edcda586c471901 ahbot > ../ahbot.patch

Hi,

try this:

cd ${CompileDir}
git clone [url]http://github.com/cyberium/mangos.git[/url] ahbot
cd ahbot
git checkout -b new_ahbot origin/new_ahbot
git diff  master new_ahbot > ${CompileDir}/patche/AHBot.patch
cd ${SourcesDir}
git apply ${CompileDir}/patche/AHBot.patch

${SourcesDir} - Subdirectory of ${CompileDir}, Mangos sources

If you use SD2, so you will be must edit the patch in "configure.ac" section before apply patch.

Change this:

    src/bindings/universal/Makefile
])

To this:

    src/bindings/ScriptDev2/Makefile
   src/bindings/ScriptDev2/scriptdev2.conf.dist

[thcobl]

If you use SD2, so you will be must edit the patch in "configure.ac" section before apply patch.

src/bindings/universal/Makefile

]) is not inthere but src/bindings/ScriptDev2/Makefile

src/bindings/ScriptDev2/scriptdev2.conf.dist is there allready

but when i try to apply patch i get :

generals:/home/svn/new_ahbot# git diff master new_ahbot > ${CompileDir}/patche/AHBot.patch

-su: /patche/AHBot.patch: No such file or directory

generals:/home/svn/new_ahbot# git diff master new_ahbot > ${CompileDir}../AHBot.patch

generals:/home/svn/new_ahbot# cd ../master

generals:/home/svn/master# git apply ${CompileDir}../AHBot.patch

error: patch failed: configure.ac:308

error: configure.ac: patch does not apply

[mnocz]

If you use SD2, so you will be must edit the patch in "configure.ac" section before apply patch.

src/bindings/universal/Makefile

]) is not inthere but src/bindings/ScriptDev2/Makefile

src/bindings/ScriptDev2/scriptdev2.conf.dist is there allready

but when i try to apply patch i get :

generals:/home/svn/new_ahbot# git diff master new_ahbot > ${CompileDir}/patche/AHBot.patch

-su: /patche/AHBot.patch: No such file or directory

generals:/home/svn/new_ahbot# git diff master new_ahbot > ${CompileDir}../AHBot.patch

generals:/home/svn/new_ahbot# cd ../master

generals:/home/svn/master# git apply ${CompileDir}../AHBot.patch

error: patch failed: configure.ac:308

error: configure.ac: patch does not apply

You must edit ${CompileDir}/patche/AHBot.patch

no ${SourcesDir}/configure.ac

[thcobl]

oke thx patch made

compile now

[thcobl]

in the old ahbot i could set how many bids it did at the same time

what option is there for in the ahbot.conf ?

is it AuctionHouseBot.Buyer.BidDigin.Interval = 1 ?

[mrelfire]

Can we go under review section now, because Ah bot is working perfectly, isn't it guys ?

[thcobl]

is there any help for buyer settings ?

everytime i start server it buys 1 item and after that it stops buying

nevermind it seems to work now

[cyberium]

AhBot todo list.

Seller part :

- implement ingame commands (i will soon push new "reloadconfig, rebuild, status, items ratio, items amount") i hope these command are enought to enjoy ahbot.

- re-rebase all code. (there is still some redundant code and some code must be optimised.

Buyer part :

- we must be sure it work like expected and probably do some improvement. (so i still need more feedback on it)

- rebase code.

when done we will ask an administrator to evaluate the code and implement any modification required to make it core part.

So yes we are not realy far but not close too