[PATCH] AuctionHouse Bot

[EARTHWALKER]

Very weird. Only thing I can think of is that I couldn't apply the characters_auctionhousebot_update.sql

It just comes up with this error.

Query:
/*Table structure for table `auctionhousebot` */
ALTER TABLE `auctionhousebot`
 ADD COLUMN `percentgreytradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items' AFTER `maxtime`,
 ADD COLUMN `percentorangetradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Orange Trade Goods auction items' AFTER `percentpurpletradegoods`,
 ADD COLUMN `percentyellowtradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Yellow Trade Goods auction items' AFTER `percentorangetradegoods`,
 ADD COLUMN `percentgreyitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Grey auction items' AFTER `percentyellowtradegoods`,
 ADD COLUMN `percentorangeitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Orange auction items' AFTER `percentpurpleitems`,
 ADD COLUMN `percentyellowitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Yellow auction items' AFTER `percentorangeitems`,
 ADD COLUMN `minpricegrey` int(11) default '100' COMMENT 'Minimum price of Grey items (percentage).' AFTER `percentyellowitems`,
 ADD COLUMN `maxpricegrey` int(11) default '150' COMMENT 'Maximum price of Grey items (percentage).' AFTER `minpricegrey`,
 ADD COLUMN `minpriceorange` int(11) default '3250' COMMENT 'Minimum price of Orange items (percentage).' AFTER `maxpricepurple`,
 ADD COLUMN `maxpriceorange` int(11) default '5550' COMMENT 'Maximum price of Orange items (percentage).' AFTER `minpriceorange`,
 ADD COLUMN `minpriceyellow` int(11) default '5250' COMMENT 'Minimum price of Yellow items (percentage).' AFTER `maxpriceorange`,
 ADD COLUMN `maxpriceyellow` int(11) default '6550' COMMENT 'Maximum price of Yellow items (percentage).' AFTER `minpriceyellow`,
 ADD COLUMN `minbidpricegrey` int(11) default '70' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 70' AFTER `maxpriceyellow`,
 ADD COLUMN `maxbidpricegrey` int(11) default '100' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpricegrey`,
 ADD COLUMN `minbidpriceorange` int(11) default '80' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 80' AFTER `maxbidpricepurple`,
 ADD COLUMN `maxbidpriceorange` int(11) default '100' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpriceorange`,
 ADD COLUMN `minbidpriceyellow` int(11) default '80' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 80' AFTER `maxbidpriceorange`,
 ADD COLUMN `maxbidpriceyellow` int(11) default '100' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpriceyellow`,
 ADD COLUMN `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxbidpriceyellow`,
 ADD COLUMN `maxstackorange` int(11) default '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxstackpurple`,
 ADD COLUMN `maxstackyellow` int(11) default '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxstackorange`,
 ADD COLUMN `buyerpriceorange` int(11) default '20' COMMENT 'Multiplier to vendorprice when buying orange items from auctionhouse' AFTER `buyerpricepurple`,
 ADD COLUMN `buyerpriceyellow` int(11) default '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse' AFTER `buyerpriceorange`

Error occured at:2010-04-03 19:21:03
Line no.:40
Error Code: 1060 - Duplicate column name 'percentgreytradegoods'

If I remove the line ' ADD COLUMN `percentgreytradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items' AFTER `maxtime`,'

Another error comes up and so on.

This is very frustrating. Still quite fun though

[mrelfire]

The auction house doesn't work any more today, so something has changed, I suspect, just to know what to take it into account

[EARTHWALKER]

If I had an error of any sort, perhaps it could be traced, but no error; nothing!

[xeross155]

If I had an error of any sort, perhaps it could be traced, but no error; nothing!

Those errors are caused by using the update SQL it was originally part of AHBot when it changed structure but the new auctionhousebot.sql doesn't need it.

Could you post the settings of the ahbot in both the config and the database that you have ?

Thanks, Xeross

[EARTHWALKER]

Here's my config:-

AuctionHouseBot.Seller.Enabled = 1
AuctionHouseBot.Buyer.Enabled = 1
AuctionHouseBot.Account = 5
AuctionHouseBot.Character = 8
AuctionHouseBot.Items.Vendor = 0
AuctionHouseBot.Items.Loot = 1
AuctionHouseBot.Items.Misc = 0
AuctionHouseBot.Bind.No = 1
AuctionHouseBot.Bind.Pickup = 0
AuctionHouseBot.Bind.Equip = 1
AuctionHouseBot.Bind.Use = 1
AuctionHouseBot.Bind.Quest = 0
AuctionHouseBot.ItemsPerCycle = 200
AuctionHouseBot.BuyPrice.Seller = 0
AuctionHouseBot.BuyPrice.Buyer = 0

here's the database bit:-

                            Create Table         
CREATE TABLE `auctionhousebot` (
 `auctionhouse` int(11) NOT NULL DEFAULT '0' COMMENT 'mapID of the auctionhouse.',
 `name` char(25) DEFAULT NULL COMMENT 'Text name of the auctionhouse.',
 `minitems` int(11) DEFAULT '0' COMMENT 'This is the minimum number of items you want to keep in the auction house. a 0 here will make it the same as the maximum.',
 `maxitems` int(11) DEFAULT '0' COMMENT 'This is the number of items you want to keep in the auction house.',
 `mintime` int(11) DEFAULT '8' COMMENT 'Sets the minimum number of hours for an auction.',
 `maxtime` int(11) DEFAULT '24' COMMENT 'Sets the maximum number of hours for an auction.',
 `percentgreytradegoods` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items',
 `percentwhitetradegoods` int(11) DEFAULT '27' COMMENT 'Sets the percentage of the White Trade Goods auction items',
 `percentgreentradegoods` int(11) DEFAULT '12' COMMENT 'Sets the percentage of the Green Trade Goods auction items',
 `percentbluetradegoods` int(11) DEFAULT '10' COMMENT 'Sets the percentage of the Blue Trade Goods auction items',
 `percentpurpletradegoods` int(11) DEFAULT '1' COMMENT 'Sets the percentage of the Purple Trade Goods auction items',
 `percentorangetradegoods` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the Orange Trade Goods auction items',
 `percentyellowtradegoods` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the Yellow Trade Goods auction items',
 `percentgreyitems` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the non trade Grey auction items',
 `percentwhiteitems` int(11) DEFAULT '10' COMMENT 'Sets the percentage of the non trade White auction items',
 `percentgreenitems` int(11) DEFAULT '30' COMMENT 'Sets the percentage of the non trade Green auction items',
 `percentblueitems` int(11) DEFAULT '8' COMMENT 'Sets the percentage of the non trade Blue auction items',
 `percentpurpleitems` int(11) DEFAULT '2' COMMENT 'Sets the percentage of the non trade Purple auction items',
 `percentorangeitems` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the non trade Orange auction items',
 `percentyellowitems` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the non trade Yellow auction items',
 `minpricegrey` int(11) DEFAULT '100' COMMENT 'Minimum price of Grey items (percentage).',
 `maxpricegrey` int(11) DEFAULT '150' COMMENT 'Maximum price of Grey items (percentage).',
 `minpricewhite` int(11) DEFAULT '150' COMMENT 'Minimum price of White items (percentage).',
 `maxpricewhite` int(11) DEFAULT '250' COMMENT 'Maximum price of White items (percentage).',
 `minpricegreen` int(11) DEFAULT '800' COMMENT 'Minimum price of Green items (percentage).',
 `maxpricegreen` int(11) DEFAULT '1400' COMMENT 'Maximum price of Green items (percentage).',
 `minpriceblue` int(11) DEFAULT '1250' COMMENT 'Minimum price of Blue items (percentage).',
 `maxpriceblue` int(11) DEFAULT '1750' COMMENT 'Maximum price of Blue items (percentage).',
 `minpricepurple` int(11) DEFAULT '2250' COMMENT 'Minimum price of Purple items (percentage).',
 `maxpricepurple` int(11) DEFAULT '4550' COMMENT 'Maximum price of Purple items (percentage).',
 `minpriceorange` int(11) DEFAULT '3250' COMMENT 'Minimum price of Orange items (percentage).',
 `maxpriceorange` int(11) DEFAULT '5550' COMMENT 'Maximum price of Orange items (percentage).',
 `minpriceyellow` int(11) DEFAULT '5250' COMMENT 'Minimum price of Yellow items (percentage).',
 `maxpriceyellow` int(11) DEFAULT '6550' COMMENT 'Maximum price of Yellow items (percentage).',
 `minbidpricegrey` int(11) DEFAULT '70' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 70',
 `maxbidpricegrey` int(11) DEFAULT '100' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 100',
 `minbidpricewhite` int(11) DEFAULT '70' COMMENT 'Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 70',
 `maxbidpricewhite` int(11) DEFAULT '100' COMMENT 'Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 100',
 `minbidpricegreen` int(11) DEFAULT '80' COMMENT 'Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 80',
 `maxbidpricegreen` int(11) DEFAULT '100' COMMENT 'Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 100',
 `minbidpriceblue` int(11) DEFAULT '75' COMMENT 'Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 75',
 `maxbidpriceblue` int(11) DEFAULT '100' COMMENT 'Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 100',
 `minbidpricepurple` int(11) DEFAULT '80' COMMENT 'Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 80',
 `maxbidpricepurple` int(11) DEFAULT '100' COMMENT 'Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 100',
 `minbidpriceorange` int(11) DEFAULT '80' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 80',
 `maxbidpriceorange` int(11) DEFAULT '100' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 100',
 `minbidpriceyellow` int(11) DEFAULT '80' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 80',
 `maxbidpriceyellow` int(11) DEFAULT '100' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 100',
 `maxstackgrey` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
 `maxstackwhite` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
 `maxstackgreen` int(11) DEFAULT '3' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
 `maxstackblue` int(11) DEFAULT '2' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
 `maxstackpurple` int(11) DEFAULT '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
 `maxstackorange` int(11) DEFAULT '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
 `maxstackyellow` int(11) DEFAULT '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
 `buyerpricegrey` int(11) DEFAULT '1' COMMENT 'Multiplier to vendorprice when buying grey items from auctionhouse',
 `buyerpricewhite` int(11) DEFAULT '1' COMMENT 'Multiplier to vendorprice when buying white items from auctionhouse',
 `buyerpricegreen` int(11) DEFAULT '5' COMMENT 'Multiplier to vendorprice when buying green items from auctionhouse',
 `buyerpriceblue` int(11) DEFAULT '12' COMMENT 'Multiplier to vendorprice when buying blue items from auctionhouse',
 `buyerpricepurple` int(11) DEFAULT '15' COMMENT 'Multiplier to vendorprice when buying purple items from auctionhouse',
 `buyerpriceorange` int(11) DEFAULT '20' COMMENT 'Multiplier to vendorprice when buying orange items from auctionhouse',
 `buyerpriceyellow` int(11) DEFAULT '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse',
 `buyerbiddinginterval` int(11) DEFAULT '1' COMMENT 'Interval how frequently AHB bids on each AH. Time in minutes',
 `buyerbidsperinterval` int(11) DEFAULT '1' COMMENT 'number of bids to put in per bidding interval',
 PRIMARY KEY (`auctionhouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

I think that's what you want.

Also here's my server info from console:-

server info
MaNGOS/0.16.0-DEV (* * Revision 9661 - 6b825a11f2671035dbc66832f76d270d0a8ee9fb)
for Win32 (little-endian)
Using script library: ScriptDev2 (for MaNGOS 9603+) Revision [1663] 2010-04-01 2
0:02:15 (Win32)
Using World DB: UDB 0.12.0 (389) for MaNGOS 9630 with SD2 SQL for rev. 1656
Using creature EventAI: ACID 3.0.4 - Final Release for Mangos (3.3.2 Client)
Online players: 0 (max: 0) Queued players: 0 (max: 0)
Server uptime: 11 Second(s).

And here is the console info at load:-

Initialize AuctionHouseBot...
========AuctionHouseBot========
loaded 5 grey trade goods
loaded 256 white trade goods
loaded 28 green trade goods
loaded 8 blue trade goods
loaded 2 purple trade goods
loaded 0 orange trade goods
loaded 0 yellow trade goods
loaded 1004 grey items
loaded 533 white items
loaded 3047 green items
loaded 907 blue items
loaded 89 purple items
loaded 0 orange items
loaded 0 yellow items
AuctionHouseBot> [AHBot-x001] is now loaded
AuctionHouseBot> updated by Xeross (Original by Naicisum, ChrisK, Paradox)
AuctionHouseBot> Includes AHBuyer by Kerbe and Paradox
WORLD: World initialized

Hows that for efficiency

[Unkle Nuke]

I'm a little confused here. Do we have a working update or not?

I'm ready to test this, just as soon as I patch my core for compiling a 3.3.2 server. So I just grab this from your Git repo, right xeross?

[kreegoth]

My configs are set same as yours ( with the exception of using my own Account and GUID values) and I have no items whatsoever. Ive looked over the configs and the sql data and can see nothing wrong with it..

[xeross155]

@EARTHWALKER: You only gave me the table structure I need to have the content

@UnkleNuke: It should work, but it seems everyone except me can't get it to work.

@Kreegoth: Hmm I'll try another test run.

[mfour]

I double checked my settings with yours Xeross, but problem remains. I am clueless here. I have tried it with a character from my previous AHBot (client 3.2.2a) with no luck. I also tried it on a completely fresh DB, with a new character, but still no luck, sadly.

[xeross155]

Ye I'll try to debug it now.

Works just fine, perhaps logging in on the ahbot account and entering the game with the ahbot character will fix it, other then that I'm out of ideas.

What you could try is using my branch instead of merging (If you haven't done so already)

git clone git://github.com/xeross/mangos.git
git checkout -b ahbot origin/ahbot

And compile that

[EARTHWALKER]

@EARTHWALKER: You only gave me the table structure I need to have the content.

I had a feeling you'd want something else.

I'm not sure how to get that info, but hopefully I've got it right this time

auctionhouse    name    minitems    maxitems    mintime    maxtime    percentgreytradegoods    percentwhitetradegoods    percentgreentradegoods    percentbluetradegoods    percentpurpletradegoods    percentorangetradegoods    percentyellowtradegoods    percentgreyitems    percentwhiteitems    percentgreenitems    percentblueitems    percentpurpleitems    percentorangeitems    percentyellowitems    minpricegrey    maxpricegrey    minpricewhite    maxpricewhite    minpricegreen    maxpricegreen    minpriceblue    maxpriceblue    minpricepurple    maxpricepurple    minpriceorange    maxpriceorange    minpriceyellow    maxpriceyellow    minbidpricegrey    maxbidpricegrey    minbidpricewhite    maxbidpricewhite    minbidpricegreen    maxbidpricegreen    minbidpriceblue    maxbidpriceblue    minbidpricepurple    maxbidpricepurple    minbidpriceorange    maxbidpriceorange    minbidpriceyellow    maxbidpriceyellow    maxstackgrey    maxstackwhite    maxstackgreen    maxstackblue    maxstackpurple    maxstackorange    maxstackyellow    buyerpricegrey    buyerpricewhite    buyerpricegreen    buyerpriceblue    buyerpricepurple    buyerpriceorange    buyerpriceyellow    buyerbiddinginterval    buyerbidsperinterval
2    Alliance    0    0    8    24    0    27    12    10    1    0    0    0    10    30    8    2    0    0    100    150    150    250    800    1400    1250    1750    2250    4550    3250    5550    5250    6550    70    100    70    100    80    100    75    100    80    100    80    100    80    100    0    0    3    2    1    1    1    1    1    5    12    15    20    22    1    1
6    Horde    0    0    8    24    0    27    12    10    1    0    0    0    10    30    8    2    0    0    100    150    150    250    800    1400    1250    1750    2250    4550    3250    5550    5250    6550    70    100    70    100    80    100    75    100    80    100    80    100    80    100    0    0    3    2    1    1    1    1    1    5    12    15    20    22    1    1
7    Neutral    0    0    8    24    0    27    12    10    1    0    0    0    10    30    8    2    0    0    100    150    150    250    800    1400    1250    1750    2250    4550    3250    5550    5250    6550    70    100    70    100    80    100    75    100    80    100    80    100    80    100    0    0    3    2    1    1    1    1    1    5    12    15    20    22    1    1

[mfour]

Ye I'll try to debug it now.

Works just fine, perhaps logging in on the ahbot account and entering the game with the ahbot character will fix it, other then that I'm out of ideas.

What you could try is using my branch instead of merging (If you haven't done so already)

[b]git clone git://github.com/xeross/mangos.git
git checkout -b ahbot origin/ahbot[/b]

That is what I have done, it is rather strange. By all counts it should work, I'll keep tinkering.

[EARTHWALKER]

Ye I'll try to debug it now.

Works just fine, perhaps logging in on the ahbot account and entering the game with the ahbot character will fix it, other then that I'm out of ideas.

What you could try is using my branch instead of merging (If you haven't done so already)

git clone git://github.com/xeross/mangos.git
git checkout -b ahbot origin/ahbot

And compile that

I cleared out my mangos folder completely (made a backup). And did what you said.

Here's the result:-

EARTHWALKER@THEBEAST c:/mangos
$ git clone git://github.com/xeross/mangos.git
Initialized empty Git repository in C:/mangos/mangos/.git/
remote: Counting objects: 44631, done.
remote: Compressing objects: 100% (8363/8363), done.
remote: Total 44631 (delta 36594), reused 44205 (delta 36202)
Receiving objects: 100% (44631/44631), 29.83 MiB | 607 KiB/s, done.
Resolving deltas: 100% (36594/36594), done.
Checking out files: 100% (3936/3936), done.

EARTHWALKER@THEBEAST c:/mangos
$ git checkout -b ahbot origin/ahbot
fatal: Not a git repository (or any of the parent directories): .git

lmao. Ok, I've put my backup( thankfully) back to where it was and all fine again...apart from ahbot of course

[Skirnir]

Initialized empty Git repository in C:/mangos/mangos/

c:/mangos

[...]

fatal: Not a git repository (or any of the parent directories): .git

Don't give up on yourself, start learning how to read today! ;-)

[xeross155]

Earthwalker once again the configuration settings in your mysql database are set to allow 0 items in the auction house by the ahbot, modify them to your likings.

And with reading that I mean it sais how you should give me config/database info required to analyse.

@Skirnir: ?, seems it created the mangos repository in C:/mangos/mangos there, so you'd have to enter that directory.

[Skirnir]

@xeross155: If your really wondering what I was referring to, I'll explain it to you (I know your busy to post a reply in every thread at this forum ;-) ). EARTHWALKER checked out your repository to C:\\mangos\\mangos. That was told him by his console output. But instead of changing to that dir, he stayed in C:\\mangos and just blindly followed the given instructions. Now the comandline output told him, that there is no git repo in the directory where he is. But instead of reading the comandline (and realizing his mistake) he just posted it here to blow this thread some more. Just having a closer look to what he is doing might have saved us from this little discussion.

Regards

Skirnir

[EARTHWALKER]

But instead of reading the comandline (and realizing his mistake) he just posted it here to blow this thread some more.

So I am following instructions exactly as posted and it goes wrong and now I'm being flamed for trying.

Ok, have it your way. Obviously me doing my best to figure this out as to be honest I don't understand git one little bit, is wrong and I should just forget it and give up.

That's what I'll do then. I came here from arcemu as the so-called mods and admins there were as useful as a chocolate fireguard, and was part of this community many years ago as you can see from my registrations date.

I guess I came back too soon.

I suppose as long as you are ok Skirnir, stuff everyone else who isn't a mastermind of git.

Have fun.

[EARTHWALKER]

Earthwalker once again the configuration settings in your mysql database are set to allow 0 items in the auction house by the ahbot, modify them to your likings.

And with reading that I mean it sais how you should give me config/database info required to analyse.

Thanks for all your help m8. It's been an experience.

I did change the min and max columns to 500/1000 for all three and waited about an hour to see if it was going to populate as it should do well within that time. Still no joy.

I won't waste any more of your time as Skirnir has pointed out I am posting to big-up myself or something.

Thanks again.

[Skirnir]

So I am following instructions exactly as posted and it goes wrong and now I'm being flamed for trying.

I suppose as long as you are ok Skirnir, stuff everyone else who isn't a mastermind of git.

[...]

I won't waste any more of your time as Skirnir has pointed out I am posting to big-up myself or something.

Ah cmon, first it was a joke and later it wasn't even directed at you. Just try watching what the commandline says. sometimes it's not that wrong :-) And that wasn't even a "git mistake" with svn it woulda been the same. It's just 50% of this thread is filled with how can I apply this patch, how do I configure it. If the posts inside this thread rly don't help you, get on IRC and I'll guide you personally.

As you said "have fun" ;-)

Skirnir

[kreegoth]

Mine is set for 5000 min 7000 max.. Left test server on overnight.. still no items. As i said it Seems correct.. I have logged the Character in and out.. Configs are correct.. Ive used a new char the old char everything.. So im not really sure What do you.. Try posting your configs you Sql data and all and i will go DIRECTLY from what your using Xeross see if that helps.

[xeross155]

@Skirnir: If you're interested in pissing him off go somewhere else, for now we need this damn patch fixed.

@Earthwalker: My apologies for forgetting the cd command, my bad.

@Kreegoth: Hmm ye I can't seem to reproduce it.

@Everyone In Here

Please create a ZIP/RAR/7Z/Whatever archive of your mangos git repository, the entire tree so not just the .git directory and please upload it somewhere and give me a link to it, please make sure you don't put any confidential data in it, not that I would use it but just as a general warning.

Thanks for your attention, hope we can fix this.

Regards, Xeross

[Kanzaki]

Hi all)

I've a problem.

After world initializing server is restarting with such mistake in log:

SQL: SELECT guid, data, name, position_x, position_y, position_z, map, totaltime, leveltime, at_login, zone, level FROM characters WHERE guid = '3875'

query ERROR: Unknown column 'data' in 'field list'

guid='3875' is ID of my ahbot.

R9669 (insider42) + ahbot (Naicisum)

I was tryed to change GUID's for ahbot, but i've got the same mistake =\\

Does anyone know what to do? '

[kreegoth]

Well I spent the last two days looking over the Ahbot files..

After around 20 or 30 botched compiles ( attempts.. lets call them attempts LOL)

I have come up with this

DOWNLOAD NOW!

Try the following:

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

cd mangos

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

Backup Xeross's Files for Auctionhouse.cpp and Auctionhouse.h (always back up:P)

Then Extract Copy and paste my Auctionhouse.cpp and Auctionhouse.h files into the correct directory.(Game folder under Source)

Compile and load.

Worked for me.

[mrelfire]

Well I spent the last two days looking over the Ahbot files..

After around 20 or 30 botched compiles ( attempts.. lets call them attempts LOL)

I have come up with this

DOWNLOAD NOW!

Try the following:

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

cd mangos

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

Backup Xeross's Files for Auctionhouse.cpp and Auctionhouse.h (always back up:P)

Then Extract Copy and paste my Auctionhouse.cpp and Auctionhouse.h files into the correct directory.(Game folder under Source)

Compile and load.

Worked for me.

I am lost, what is the difference between yours and Xeross155 ? which one should we take ?

[kreegoth]

You take his. ALL mine is, is a filebeam upload of the auctionhouse.cpp and auctionhouse.h files. So use his as you normally would then just extract my fixes to the correct folder. If you already have Xeross's Repo just extract mine into the Src/Game/ Folder So it overwrites his files.

Sorry im used to SVN and not git so im not sure how to create a patch atm...

BTW Tested and confirmed working with a fresh compilation of mangos rev 9672