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

**aladrin** · 28-08-10, 01:46 PM

thank you very much

**GrandpaJohn** · 28-08-10, 02:02 PM

@CT:

all 3 of the last updates, 0015, 0016, and 0017 went in sucessfully with no problems and everything runs great keep up the great work you're awesome ty

**CthulhuFtagn** · 28-08-10, 02:51 PM

Thanks Granpa, hope your grandkids are enjoying it.

**GrandpaJohn** · 28-08-10, 05:15 PM

@CT:

yup they are my one son, who has 4 children said its hard to get them off the their pc and into bed at nite. they do miss the auctionhouse tho but we pretty much give them what they ask for. lol keep up the great work CT

**skiik** · 28-08-10, 07:17 PM

Awwww such a sweet story. My oldest is about 2. Hmm wonder if thats too young to start...

Originally Posted by GrandpaJohn

@CT:

yup they are my one son, who has 4 children said its hard to get them off the their pc and into bed at nite. they do miss the auctionhouse tho but we pretty much give them what they ask for. lol keep up the great work CT

**CthulhuFtagn** · 28-08-10, 08:47 PM

This release is for the coolest granpa in West Palm Beach, Florida: GranpaJohn.

Update Available:

Code:

MaNGOS updated to 10418
AHBOT added with Readme file
Characters DB updates for AHBOT
Updated mangosd.conf with AHBOT information

CU_0018.zip (10.77 MB)

**skiik** · 28-08-10, 09:46 PM

Wicard, you're the man...

Originally Posted by CthulhuFtagn

This release is for the coolest granpa in West Palm Beach, Florida: GranpaJohn.

Update Available:

Code:

MaNGOS updated to 10418
AHBOT added with Readme file
Characters DB updates for AHBOT
Updated mangosd.conf with AHBOT information

CU_0018.zip (10.77 MB)

**CthulhuFtagn** · 28-08-10, 10:14 PM

Fixing some errors with the Armory... will update tomorrow morning.

Optional MaNGOS Blizzlike Armory:
UPLOADING (128 MB)

How to install the MaNGOS Blizzlike Armory:
Delete all files inside the C:\Server\htdocs folder

Extract the Optional_Armory.zip file to anywhere

Stop the MySQL Service by either:
1. Closing the mysql.bat file
or, if you have installed mysql as a service
2. Click Start > Run (or Windows Key + R) and type services.msc
Look for the MySQL service, double-click it and click Stop

Copy the extracted Server folder and overwrite the current C:\Server folder

Restart the mysql service

Start the apache service (if it's not already started)
Note: If you have teamviewer running, it will interfere with apache.
1. Double-click the Apache.bat file
or
2. Double-click C:\Server\apache\apache_installservice.bat to start it as a service

Now open a browser and go to http://127.0.0.1 (or, if you are using a no-ip.org etc address through port 80, go there) and voila!

To edit the configuration go to C:\Server\htdocs\configuration\ and you can edit the mysql.php and settings.php files using your favorite text editor.

**GrandpaJohn** · 29-08-10, 10:08 AM

@CT:

it went sucessfully, server running great and the auctionhouse works perfect thank you so much, now they can buy their own stuff and say look what i bought, even tho most of it will be less valuable than what my son and i gave them. LOL just because they accquired it on their own. you're amazing keep up the great work we all love ya

**CthulhuFtagn** · 29-08-10, 11:52 AM

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.