EARTHWALKER

May 30, 2010

First my Ad.exe creates a maps and dbc of about 350mb.

That's about right dude. Mine is currently at 324mb

Just follow what has been said and you'll be ok.

May 30, 2010

A refreshing change to see someone actually READ the post and answer it in a professional and easy-going manner. Doesn't seem to be the norm today.

May 30, 2010

That's _very_ basic math.

So you give him the answer and then are arrogant and rude with your comment.

Not really needed was it. Shame there is no karma/anti-karma button on this forum.

May 30, 2010

realmd DB account_banned table

He didn't ask where the bans are kept. If you read his post again, you'll maybe understand his question.

May 29, 2010

EARTHWALKER
I see 2 things that may cause the problems

This looks like you've already applied the patch, try using it on a clean repository

The other thing could be it's incompatible with the newer revisions, would have to update it then.

Definitely not applied as each time fails, so I'll try it on a spinky clean repo and see. if it doesn;t work then, it has to be it needs updating to latest core. I wish I was more knowledgeable as I do have some time

Did that and now I have these errors:-

$ git apply Addon/AHBot/ahbot.patch
Addon/AHBot/ahbot.patch:3526: trailing whitespace.

error: README.AHBOT: already exists in working directory
error: sql/characters_auctionhousebot.sql: already exists in working directory
error: sql/characters_auctionhousebot_update.sql: already exists in working dire
ctory
error: src/game/AuctionHouseBot.cpp: already exists in working directory
error: src/game/AuctionHouseBot.h: already exists in working directory

Mangos rev 9999 btw

May 29, 2010

I'm almost at the point of giving up. Everything I try just comes up with errors.

This is what I get atm:-

$ git apply --check ahbot/ahbot.patch

error: README.AHBOT: already exists in working directory

error: sql/characters_auctionhousebot.sql: already exists in working directory

error: sql/characters_auctionhousebot_update.sql: already exists in working dire

ctory

error: src/game/AuctionHouseBot.cpp: already exists in working directory

error: src/game/AuctionHouseBot.h: already exists in working directory

error: patch failed: src/game/AuctionHouseHandler.cpp:28

error: src/game/AuctionHouseHandler.cpp: patch does not apply

error: patch failed: src/game/AuctionHouseMgr.cpp:462

error: src/game/AuctionHouseMgr.cpp: patch does not apply

error: patch failed: src/game/AuctionHouseMgr.h:84

error: src/game/AuctionHouseMgr.h: patch does not apply

error: patch failed: src/game/Chat.cpp:681

error: src/game/Chat.cpp: patch does not apply

error: patch failed: src/game/Chat.h:108

error: src/game/Chat.h: patch does not apply

error: patch failed: src/game/Level3.cpp:52

error: src/game/Level3.cpp: patch does not apply

error: patch failed: src/game/Mail.cpp:37

error: src/game/Mail.cpp: patch does not apply

error: patch failed: src/game/Makefile.am:37

error: src/game/Makefile.am: patch does not apply

error: patch failed: src/game/Player.h:1439

error: src/game/Player.h: patch does not apply

error: patch failed: src/game/World.cpp:60

error: src/game/World.cpp: patch does not apply

error: patch failed: src/game/World.h:181

error: src/game/World.h: patch does not apply

error: patch failed: src/mangosd/mangosd.conf.dist.in:1405

error: src/mangosd/mangosd.conf.dist.in: patch does not apply

error: patch failed: win/VC100/game.vcxproj:349

error: win/VC100/game.vcxproj: patch does not apply

Here is my server info....in case that helps.

server info

MaNGOS/0.16.0-DEV (* * Revision 10005 - *) for Win32 (little-endian)

Using script library: Default MaNGOS scripting library

Using World DB: UDB 0.12.0 (391) for MaNGOS 9999 with SD2 SQL for rev. 1702

Using creature EventAI: ACID 3.0.4 - Final Release for Mangos (3.3.2 Client)

May 18, 2010

VH is only 78% scripted so far.

http://www.scriptdev2.com/acid-and-sd2-t2478.html Been like that for a very long time. That page will give you some info on any instances that are finished and working. No idea about your git problem as I don't understand it at all. My git method consists of C&P from what other people have suggested

May 18, 2010

Arcemu and mangos are not databases, They are cores. Probably where you are going wrong.

That would be like looking for icecream in a butchers shop

May 18, 2010

You really need to provide some more details here.

what revision are you trying to compile, what windows flavour are you using; or perhaps linux? What compiling program are you using: and what version?

May 18, 2010

What exactly do you mean by 'control panel'?

May 13, 2010

I'm not 100% certain, but I would try characters/characters/death_expire_time set to 0

At least that is what I would try.

April 4, 2010

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.

April 4, 2010

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.

April 4, 2010

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

April 4, 2010

@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

April 3, 2010

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

April 3, 2010

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

April 3, 2010

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

April 3, 2010

Patch added fine, compiled fine, realmd and mangosd all work fine, ahbot loaded with the console displaying thousands of items loaded, enter server ok, check AH and

No items. Now I am lost..lol.

April 3, 2010

Thanks m8... WOOT.

I grabbed a patch from further up, did what you wrote and bingo!

EARTHWALKER@THEBEAST c:/mangos/ahbot (master)
$ patch -p1 < 9652_AHBbot.patch
patching file `README.AHBOT'
patching file `sql/characters_auctionhousebot.sql'
patching file `sql/characters_auctionhousebot_update.sql'
patching file `src/game/AuctionHouseBot.cpp'
patching file `src/game/AuctionHouseBot.h'
patching file `src/game/AuctionHouseHandler.cpp'
patching file `src/game/AuctionHouseMgr.cpp'
patching file `src/game/AuctionHouseMgr.h'
patching file `src/game/Chat.cpp'
Hunk #1 succeeded at 669 (offset 1 line).
patching file `src/game/Chat.h'
patching file `src/game/Level3.cpp'
patching file `src/game/Mail.cpp'
patching file `src/game/Makefile.am'
patching file `src/game/Player.h'
Hunk #1 succeeded at 1422 (offset 9 lines).
patching file `src/game/World.cpp'
patching file `src/game/World.h'
patching file `src/mangosd/mangosd.conf.dist.in'
patching file `win/VC100/game.vcxproj'
patching file `win/VC80/game.vcproj'
patching file `win/VC90/game.vcproj'

Now to get the bugger working on the server. Should be easy now the difficult part is out of the way

April 3, 2010

I tried it without the -m and even more errors popped up so can't continue to get the patch, not that I would have a clue how to integrate the patch anyway.

Thanks for trying though, but now I know this is for linux anyway, I won't waste hours trying it over and over again thinking I'd typed something wrong.

Hopefully someone will either come up with some windows commands or just a patch and a way to SVN it as I can do that. I wouldn't have a clue how to integrate a patch with this git thing. I'd have a better time translating outer-mongolian

April 2, 2010

Tried that and after doing this line:-

HASH=`git log ahbot --pretty=oneline | grep -m 1 '\\[9[0-9]\\{3\\}]' | cut -d " " -f 1`

I got this error:-

EARTHWALKER@THEBEAST c:/mangos/ahbot (master)
$ HASH=`git log ahbot --pretty=oneline | grep -m 1 '\\[9[0-9]\\{3\\}]' | cut -d "
" -f 1`
grep: invalid option -- m
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.

Any clues?

BASH script to generate AHbot patch file. I originally wrote this for playerbot, but it works for AHbot as well with a couple of modifications.
#!/bin/bash -x
git clone git://github.com/mangos/mangos.git ahbot
cd ahbot
git fetch git://github.com/xeross/mangos.git ahbot:ahbot
HASH=`git log ahbot --pretty=oneline | grep -m 1 '\\[9[0-9]\\{3\\}]' | cut -d " " -f 1`
git diff $HASH ahbot > ../ahbot.patch
skinlayers

March 31, 2010

EARTHWALKER@THEBEAST c:/mangos (master)
$ git apply --check Addon/AHBot/auctionhousebot_005b.patch
error: patch failed: src/game/AuctionHouseHandler.cpp:27
error: src/game/AuctionHouseHandler.cpp: patch does not apply
error: patch failed: src/game/Mail.cpp:1022
error: src/game/Mail.cpp: patch does not apply

Tested with 9646

Seems as though mangos has been altered once again..lol

March 29, 2010

Very latest version dude and yes I removed the dist.in part as you described. No need to sigh m8, this is fun. At least that's how I look at it

March 28, 2010

Of course it's fun. I love it. Seriously. There's almost nothing more enjoyable than having a mare of a problem, only to eventually find an answer.

You go devs, throw at us whatever you can, WE CAN TAKE IT...mwhuhahahahaha!

I grabbed your file Temporary and now have this:-

$ git apply --check Addon/AHBot/mangos-9573-ahbot.patch

error: patch failed: src/game/AuctionHouseHandler.cpp:27

error: src/game/AuctionHouseHandler.cpp: patch does not apply

error: patch failed: src/game/Player.h:1423

error: src/game/Player.h: patch does not apply

This is very intriguing.

Sign In

Profiles

Bug Tracker

Wiki

Release Notes

Forums

Downloads

Blogs

Events

Posts posted by EARTHWALKER

Contact Us

Repositories

Important Information