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

**hnmitch** · 17-10-10, 09:21 PM

Thanks trm your the best!

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

**Vard** · 18-10-10, 10:13 AM

Really liking the repack but having trouble getting the ahbot to come back to life. Had it working for a bit a couple of versions ago but not sure what the settings I had then were and it's related to them or what...

My latest attempt has been with AllowTwoSide.Interaction.Auction = 0 and

AuctionHouseBot.EnableSeller = 1
AuctionHouseBot.EnableBuyer = 1
AuctionHouseBot.Account = 7
AuctionHouseBot.GUID = 6
AuctionHouseBot.VendorItems = 0
AuctionHouseBot.LootItems = 1
AuctionHouseBot.OtherItems = 0
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 = 1500
AuctionHouseBot.UseBuyPriceForSeller = 0
AuctionHouseBot.UseBuyPriceForBuyer = 0

Account 7 is a pure ahbot account with a single character guid = 6, account = 7

The auctionhousebot table has alliance and house min/max at 2500/3000 and neutral at 500/1000 everything else default.

I'm not seeing anything in the mangos startup about the ahbot.. just the section on loading auctions, does that mean it's not being loaded at all?

Any help appreciated.. also any info on how often the ahbot is meant to activate and if there is a manual way of forcing a cycle that would also be great to know.

**GrandpaJohn** · 18-10-10, 11:20 AM

@ Vard;

in the characters DB auctionhousebot table i have my alliance, horde, and neutral all set to min/max the same 1000, pretty sure that the min/max is suppose to be the same and mine works just fine

**revel** · 18-10-10, 12:38 PM

Hey there, first time user of a repack.

I got he server running and everything right off the install, however it doesn't seem to have AHBot installed... When I go to the database, the character.auctionhousebot table does not exist.

I tried running the accumulative updates, it added the table, but now Mangos won't boot.

WHat exactly is needed on this fresh install to make AHBot run without killing mangos?

**GrandpaJohn** · 18-10-10, 01:05 PM

@ revel;

in the updates there is an instruction sheet to tell you haow to setup the auction house try reading it and follow the instructions

**Vard** · 18-10-10, 07:31 PM

@ GrandpaJohn

Thanks for the advice - tried with min/max set to 1000 for each but the auction table remains empty.

Does the server need to be up for a certain amount of time before the ahbot activates now? From memory when it was working it first populated the auction hour upon boot up and outputted some messages.

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

@ vard:

make sure that you go into the auctionhousebot table and not the auction table or the auctionhouse table because you are saying auction table they are all 3 in the characters db

**Vard** · 18-10-10, 08:31 PM

@ GrandpaJohn

the auctionhousebot is the table that I have been putting the custom settings, the auction table is the one where I previously had auctions but now since my testing is empty. I don't have an auctionhouse table at all. Just did a new test install of Server_TRM335a + CU_0073 and it didn't create that table. Maybe this is the one that's causing me grief. What is in the auctionhouse table on your server and if it is small is it possible to post a sql dump of structure or structure & data?

Edit: Actually it looks like auctionhouse is the old name of the auction table. Checked the sql structure of the current db at git and it's not there though it's still listed on the wiki. Looks like a recent change. Maybe this is not my problem :|

Edit2: In case it was an issue with the data I brought over from a different repack I tried from scratch but still had no luck. I'm pretty sure the first time I saw it working it populated the auctionhouse right at the startup of mangod. So unless I was mistaken or that has been changed then it's not just cause I am not letting it run long enough.

Can someone tell me if I have missed something with the following steps?

Code:

moved previous server directory
extracted Server_TRM335a to c:/server and started up mysql
updated with CU_0073 (replaced manges x64 and executed the sql updates using sqlyog)
moved the dbc/maps/vmaps directories across and started mangosd and reamld (x64) 
created an ahbot account (ussing .account create & set addon / set gmlevel)
logged on, created a character, logged in with the character then quit (sqlyog shows it to be character 1, account 5)

Modified mangosd.conf (from the CU_0073 template)

AuctionHouseBot.EnableSeller = 1
AuctionHouseBot.EnableBuyer = 1
AuctionHouseBot.Account = 5
AuctionHouseBot.GUID = 1

set minitems and maxitems to 1000 for alliance, horde and neutral records in auctionhousebot table using sqlyog

restarted mangos but still didn't see any messages about ahbot in the console up
checked using sqlyog and the auction table still not populated

**impact1560** · 18-10-10, 10:36 PM

How do you backup all the account information? I need to reinstall my OS and I don't want people to start back over.

Thank You

**Vard** · 18-10-10, 11:16 PM

Easiest way would be to just copy the entire server directory.
Next easiest would be to just copy the MySQL directory (also a lot smaller without the maps, dbc and vmap directories)
Last would be to use sqlyog and use the backup functions there to create sql dumps of the tables.

If you only do a partial backup make sure you reinstall them back to the same version of the server or make sure you know how to update the tables to match a later version.