cyberium

It's a working patch Don't worry about theses trainling space warning... I will resolve it next commit. (but i can't for now too much modification on ahbuyer are comming)

FlexBB is a pretty good choice . The theme is not far than Vbultin one and it's good. (perhaps just little bit less dark than before)

Try this git clone git://github.com/cyberium/mangos.git new_ahbot cd new_ahbot git checkout new_ahbot git diff master > ../ahbot.patch go to your repository (of course in bash mode) git apply ../ahbot.patch Greetings

In this code you can see on config buyer are working mysql> SELECT * FROM auction WHERE lastbid!=0; +--------+---------+----------+---------------+-----------+-------------+------------+------------+---------+----------+---------+ | id | houseid | itemguid | item_template | itemowner | buyoutprice | time | buyguid | lastbid | startbid | deposit | +--------+---------+----------+---------------+-----------+-------------+------------+------------+---------+----------+---------+ | 116433 | 7 | 1335924 | 41603 | 1 | 1000000 | 1286013666 | 4294967295 | 90900 | 30000 | 30000 | | 116421 | 7 | 1335904 | 41603 | 1 | 40000 | 1286013399 | 4294967295 | 30001 | 30000 | 30000 | | 116439 | 7 | 1335923 | 41603 | 1 | 300000 | 1286013689 | 4294967295 | 221100 | 30000 | 30000 | | 116440 | 7 | 1117718 | 41603 | 1 | 9000000 | 1286013715 | 4294967295 | 239400 | 210000 | 210000 | +--------+---------+----------+---------------+-----------+-------------+------------+------------+---------+----------+---------+ 4 rows in set So i don't see where the problem are... I will try your conf when you post it. Anyway i will work on buyer next week (started now to modify algorithm to make it more unpredictable) If you whant some new stuff (you think it will be important to have) on ah seller part or see any other bug please be free to post it. If no feedback about it i will considere all is fine and do code rebase only for future "under review" section. Here is my plan for buyer part. - make a decision about auction entry only 1 time. (mean at next auction scan by buyer it will be ignored) - the more cheaper are the item the more chance you will have to sell it. - if there is other item same as your (selled by ahbot or other player) less expensive you will have less chance to sell it. - if this kind of item is the only one exist on the ah you will have more chance to sell it at expensive price. - The bid will be computed to be minimal one. (percentage of total price) - And probably other idea... so stay tuned

Sorry due to stupid naming of variable... Updated...

Update: - Removed the need of getauctionhouseentrybyfaction method. - Added ingame commands just type (in level 3 account) .ahbot help for complete list. - Some comment added and some optimisation. @ EARTHWALKER, Just updated so please try with latest build. ps: didnt have time till now to test gcc compilation...

If you are satisfied with your actual ahbot conf can you please share it with us? I will make it new default. I still working on the new ingame command, i have to implement status and rebuild before i update the patch. I hope i will have time today.

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

Yes do something like mysql> DELETE FROM auction WHERE itemowner=4294967295 AND lastbid=0; All ingame command are disabled. Work in progress...

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

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.

Ok i see the error, i will push correction after some test. 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)

Abnormal, verify theses settings : AuctionHouseBot.Alliance.Price.Ratio = 200 AuctionHouseBot.Horde.Price.Ratio = 200 AuctionHouseBot.Neutral.Price.Ratio = 200 AuctionHouseBot.BuyPrice.Seller = 1

yes regarding tour table we can see auction house number 7 (neutral) items are not yet bided. Strange because just tried it and on my config i have item buyed and bided normaly. Anyway thanks i am investigating.

Not confirmed for me. It work no mater faction used. If you are sure, give me more info about item selled, price etc...

Yes this bug was resolved by last patch, so you probably not reset your table before testing my last revision? Normaly this would not happen now. Thanks for your excellent feedback.

Not yet, however it's on my todo. ( at least with ingame command )

Update: - added comment on the code. - removed some bug on ahbuyer. Has i said i only will debug ahbuyer for now. No optmising or adding stuff on it. Can anyone give me feedback on the ahbuyer?

Price compute method changed. I hope i will get more feedback than now. I confirm ahbuyer don't work as expected iam trying to get it work.

You remember me my first visit on Molten Core...

I cannot reproduce it. For compute of the price, iam not satisfied for now. What do you think about : Compute the buyout price : Take de base price ( from DB ) Apply the "price ratio" (in ahbot conf file) Randomize the value for exemple (-30%, +30%) Compute de bind price: Take 50% the buyout price (just computed) Randomize the value for exemple (-40%, +40%) Exemple: price is 23 gold from DB, conf file set to 200 (%) price = 23*(200/100) = 46 price = random ( 46-(46*(30/100)), 46+(46*(30/100))) = 52 for ex. aviable range (32.2 .. 59.8) bind = price*(50/100) = 26 bind = random ( bind-(price*(40/100)), bind+(price*(40/100))) = 41 for ex. aviable range ( 5.2 .. 46.8) I olso think about add settings to specify different ratio on the aviable categories but not sure if it will be usefull. Greetings

Purpose : Avoid conflit when pulling from another repository. (or between 2 patch) Case : AHBOT and PLAYERBOT need to modify same file in the same place. What file : original Makefile.am ## Sub-directories to parse The problem : ahbot Makefile.am ## Sub-directories to parse SUBDIRS = AuctionHouseBot playerbot Makefile.am ## Sub-directories to parse SUBDIRS = playerbot goal : ## Sub-directories to parse SUBDIRS = AuctionHouseBot playerbot or ## Sub-directories to parse SUBDIRS = AuctionHouseBot SUBDIRS+ = playerbot Didn't found any clean way to avoid merge conflit in all case. (ahbot first or playerbot first) Any proposal are welcome.

Basicaly you are right and you correctly understaind the functionality. Anyway i didn't develloped this in this way. I limited the ratio to 10000 (thinking it's enought to make some difference between faction). if (getConfig(CONFIG_UINT32_AHBOT_ALLIANCE_RATIO)>10000) setConfig(CONFIG_UINT32_AHBOT_ALLIANCE_RATIO,10000); if (getConfig(CONFIG_UINT32_AHBOT_HORDE_RATIO)>10000) setConfig(CONFIG_UINT32_AHBOT_HORDE_RATIO,10000); if (getConfig(CONFIG_UINT32_AHBOT_NEUTRAL_RATIO)>10000) setConfig(CONFIG_UINT32_AHBOT_NEUTRAL_RATIO,10000); So if you whant i can elevate that value... Anyway you still didn't give me an example of yellow/orange sellable item you whant to see in the AH...

The complete explanation is : If you want 3000 orange items in every AH you should change your conf to this AuctionHouseBot.Alliance.Items.Amount.Ratio = 100 AuctionHouseBot.Horde.Items.Amount.Ratio = 100 AuctionHouseBot.Neutral.Items.Amount.Ratio = 100 AuctionHouseBot.Items.Amount.Orange = 3000 Olso if you have no orange items loaded from the DB you will obviously didn't get any of that color on the AH. So you must be sure your required skill, lvl, item vendor, etc... settings is correctly set to let a chance for orange item pass the filter. Unfortunaly i have not an exemple of sellable yellow or orange items until now except elementium bar. Thanks for your feedback Skirnir. To all, what ingame command do you need to use related to ahbot? (only level3) Greetings

Thank Xeross i will investigate this.