-
Make sure you create a toon for the AHBot first, and log in atleast once with that toon.
The new mangosd.conf file contains the new information to be edited, here's my configuration:
Code:
AuctionHouseBot.EnableSeller = 1
AuctionHouseBot.EnableBuyer = 1
AuctionHouseBot.Account = 6
AuctionHouseBot.GUID = 2
AuctionHouseBot.VendorItems = 1
AuctionHouseBot.LootItems = 1
AuctionHouseBot.OtherItems = 1
AuctionHouseBot.No_Bind = 1
AuctionHouseBot.Bind_When_Picked_Up = 0
AuctionHouseBot.Bind_When_Equipped = 1
AuctionHouseBot.Bind_When_Use = 1
AuctionHouseBot.Bind_Quest_Item = 0
AuctionHouseBot.ItemsPerCycle = 200
AuctionHouseBot.UseBuyPriceForSeller = 0
AuctionHouseBot.UseBuyPriceForBuyer = 0
You'll have to go into your database to assign one of your toons as the AHBot, here's how to find the AuctionHouseBot.Account and AuctionHouseBot.GUID numbers.
1. Make sure MySQL is running
2. Download and install SQLYog from http://code.google.com/p/sqlyog/downloads/list
3. Open SQLYog and make sure the connection looks like below
Click New, name the connection MaNGOS
http://img840.imageshack.us/img840/8781/accountaj.jpg
username is root password is mangos
Now click Connect
Click the + next to the characters database on the left, then right-click on the characters table and click Open Table
Click to enlarge:
http://img833.imageshack.us/img833/1162/charactersc.jpg
Look for the toon you created and note the guid and account numbers, as you can see from my AHBot config I used Loktar as my bot.
AND, since people can't bother to READ the ReadmeAHBOT.txt file I included, make sure to set your min and max items for your auctions.
Here's my settings:
Code:
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Alliance";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Alliance";
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Horde";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Horde";
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Neutral";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Neutral";
I put the Readme files there for a reason.
You should get something like this when you click Search:
http://img641.imageshack.us/img641/6894/auctionsm.jpg
Now your Auction House should be populated when you start up the server.
-
Awesome TRM. Updates worked flawlessly and I love the AH :). Thanks.
And as for that issue I was having earlier where skills/talents weren't saving - I reinstalled and only executed the essential character sql files and it's fine now, so I am guessing it was a corrupted sql file somewhere.
-
Well, I'm glad you got that issue worked out. Hopefully I can keep the updates rolling without hiccups.
Update Available:
Code:
MaNGOS updated to 10422 (required_10422_01_mangos_spell_proc_event)
Added correct vmap extractor to the tools folder
Added an updated Quice DB Editor (1.2.53)
CU_0019.zip (12.96 MB)
http://img291.imageshack.us/img291/7662/quice1.jpg
username: root
password: mangos
http://img828.imageshack.us/img828/3222/quice2.jpg
When using Quice, make sure to set your DBC path (where you placed your dbc folder).
Click Settings > Set DBC Path...
Make sure it looks like below (I'm using the 64-bit version)
http://img411.imageshack.us/img411/4963/quice3.jpg
-
@CT:
all updated everything is working great havent tried the armory yet dont know if i want to sounds complicated what is it basically for ? anything important ? if noyt think i'll just let it be. your updates are the greatest they go in so easy
-
Thanks, the armory is giving me some problems so I took down the link until I can work them out... it's nothing important unless you want a fancy-schmancy wow-like armory for the website.
-
@CT:
oh naa not really i dont even use the web site so i dont reckon i need that
-
It's gonna be a lot of work to get it updated and working well with 3.3.5a so I'll keep you informed, but I wouldn't worry about it at all. Looks like it's a slow day for updates, hasn't been one in MaNGOS, ScriptDev2, or YTDB in atleast 8 hours... gives me more time to work on other things.
EDIT: Had a break thru... looks like the Armory is working great now! w00t!
http://img37.imageshack.us/img37/8055/armorysm.jpg
-
Looks great man, awesome work as always:)
-
It took a lot of prodding and poking in .php files and configs but I finally got it going... going to do a few more tests with character information, but I think it'll be in the next release.
EDIT: Oh, yeah! A few 'little' bugs, like it's only showing the main hand on my rogue, but it works well enough.
http://img39.imageshack.us/img39/8055/armorysm.jpg
-
Hi TRM just wanted to say thanks a million for putting in the AHbot. That was the one thing I was hanging out for as I play solo!!! Makes it feel like the real servers now. Thanks again.
