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

[CthulhuFtagn]

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:

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:

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.

[Rathir]

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.

[Stefan30]

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:

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.

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

Sry again but my english is bad ...
I didn't understand what you mean... let me know if i understood you correctly:
You mean that i must to create the ahbot from the database - not from the game? - Cuz when i tried for first time i was logged in game account -> create a character with name: Ahbot -> and i logged in with him in game -> and then i configurated my mangosd.conf the following lines which you gave me? Does it correctly?
I really really sorry

[CthulhuFtagn]

Right on!

Update Available:

MaNGOS updated to 10426 (required_10423_01_mangos_spell_chain)

CU_0020.zip (12.96 MB)

[Stefan30]

Right on!

Update Available:

MaNGOS updated to 10426 (required_10423_01_mangos_spell_chain)

CU_0020.zip (12.96 MB)

thanks for the update