Thread: [Release] TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit

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


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:


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:


Now your Auction House should be populated when you start up the server.