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

Hi Cthulhu Ftagn,
First of all i want to be apolagyzed about my bad english
The repack it's awsome... i'm already runed him...
I've got all updates without problem...
Already i'm install the ahbot and if you can give me some commands i can't run him... (bow)
I saw a few posts back, something about the website with armory ... and have a some questons about it:
1.Can i use it with MangosWeb Enhancement?
2.Do u have a website with the armory which run on deck?
and if you could send me a link and a small installation guide for it I would be very grateful ... and if all goes well for you to donate for the good work.
Thanks in advance.

Originally Posted by jimmy6666

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.

You're very welcome.

Originally Posted by Stefan30

Hi Cthulhu Ftagn,
First of all i want to be apolagyzed about my bad english
The repack it's awsome... i'm already runed him...
I've got all updates without problem...
Already i'm install the ahbot and if you can give me some commands i can't run him... (bow)
I saw a few posts back, something about the website with armory ... and have a some questons about it:
1.Can i use it with MangosWeb Enhancement?
2.Do u have a website with the armory which run on deck?
and if you could send me a link and a small installation guide for it I would be very grateful ... and if all goes well for you to donate for the good work.
Thanks in advance.

It's not a playerbot, it's an auction house bot that populates the auction house; you don't "run" it. But my tutorial is at this post Click
1. The armory isn't uploaded yet, and I have never used MangosWeb Enhancement.
2. What is "deck"? The installation/configuration guide for the current website is already on the first page.

Originally Posted by ellenya

Hello Cthulhu Ftagn I once asked a couple of you could perhaps ICC, Ulduar
and (Trial of the Crusader) was a great scripts mega nice of you!

The server wow Titans is fully scripted what you can perhaps steal or something

Greetings Ellenya

Sorry for my english I'm German xD

Well, I'm not going to "steal" anything. Plus you can't steal scripts.

Originally Posted by skiik

Anyone know if battlegrounds works? I tried going into warsong gulch with my lvl 18 char and the instance entrence is red and i cant enter...
Also is there a list of instances that are and are not working properly at lvl 80 so i can post it on my motd to manage expectations.

Thanks in advance

There is not a list of working/non-working instances; but you can do this for certain "events".

Code:

.lookup event NAME
.event start ID

This one was a PM, but I'll post the answer here so that it might help others who are using the server on their LANS:

Originally Posted by Narcoleptic

Hi there
First of all i want to thank you for this great repack
Now i really need your help...first can you tell me or make me a step by step on how to use the update files...? i just copy them to the folder and replace them??? i´m a noob on this things please help me out...
And my major problem...i did all the things you said in the intructions to make the server and it worked very well but i have a problem...i can only connect to the server on the computer i have the server running...all the other computers on my LAN cannot access the server it shows up the server name but nothing happens ( Please friend can you help me out with this problem...? what should i do?? i dont want to make it online because i dont have internet where i have the server only a LAN...so what configuration should i use?? please tell me what i must do to play on my lan with all the computers i´m desperate and no one says a word...
I have all the ports well forward in the router and the firewall acuses the attemp to connect and allow them...but nothing happens...please friend help me...
Big Hug

1. Press Start > Run OR Windows Key + R this will bring up the Run box

2. Type cmd and press OK


3. Type ipconfig /all at the command prompt press Enter


4. Now find your internal IP address (it should start with 192.168.#.#), as you can see mine is 192.168.1.15


How to edit your database:

Install SQLYog: SQLyog

Make sure you have C:\MySQL.bat running (or MySQL running as a service), then load it up and click Continue, then make sure your connection looks like below:

(Click New to make a connection)



Username is root
Password is mangos

Now click Connect

1. Click next to the + of the realmd database.
2. Right-click on the realmlist table and click Open Table.
3. Now edit the address portion by double-clicking where it reads 127.0.0.1 and change it to your internal IP address.
4. Click the little blue disk next to the red trash can, and your done.



Now on each machine that will be logging into the server on your LAN change the realmlist.wtf file to: (use your internal IP)

Code:

set realmlist 192.168.1.15
set patchlist 192.168.1.15
set realmlistbn ""
set portal us

If you will be logging into the server from the host machine as well, make sure your realmlist.wtf file looks like below:

Code:

set realmlist 127.0.0.1
set patchlist 127.0.0.1
set realmlistbn ""
set portal us

That should do it for the LAN. Now as far as installing the updates goes, go to my post here: Tutorial

Then replace the current x64 and Win32 folders with the ones that are in the Cumulative Update packs.


EDIT:

There were a few updates last night and early this morning.

Code:

[10426] Remove not needed checks from IsNoStackAuraDueToAura 
[10425] Add comment in Aura::CanProcFrom 
[10424] Fix 50334 additional targets part 
[10423] Load most spell chains data from SkillLineAbility.dbc

So.. here we go.

Just a heads up. The armory required edits to the core and the files needed to run it were in excess of 400 MB ZIPPED! and 1.27 GB extracted, this is because it has a 3D viewer and needed all the textures from the toons/items to be included, so I will not be releasing it. Sorry.

It is my belief that a repack should be atleast portable on a thumb drive with your other software, so... maybe I'll find a less hard drive gobbling one later on.

Update Compiling:

Code:

MaNGOS updated to 10426 (required_10423_01_mangos_spell_chain)

Originally Posted by 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:

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.

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

Yep, that's correct. You just create a character normally, then configure, just don't use this toon for playing after you logged in with it. It should be used strictly to populate the auction house.