WoW : TBC emu

10/29/2006 02:59 imported__AiM_#1
What i need?

- WoW 1.12.x (find it yourself)
- TBC 2.0.0 Build 5991 (worldofwarcraft.com/downloads/expansion-bc/WoW-2.0.0.5991-enUS-Installer-downloader.exe)

- MySQL - (mysql.com)
- Navicat - (navicat.com)
- WinMPQ - (rapidshare.de/files/37157465/WinMPQfinal_TBC.rar.html)
- Mangos TBC Emu - (rapidshare.de/files/37045544/debugV3_1_.rar.html)
- AD.exe - for map extraction - (rapidshare.de/files/37157775/ad.exe.html)
- A Mangos Database (SQL Files) - (filebeam.com/79c30a184b10871a0d96926d30e13245) from compboy

How do i Install?

__________________________________________________ ________/\
First Step: Installation, MAPS and DBC extraction /
__________________________________________________ ________/

Install WoW and upgrade to 1.12.1
Install Burning Crusade Beta client build 5991
Install MySQL and Navicat
Extract WinMPQ

Extract the Mangos TBC Emu intro any DIRECTORY you want.. as long you remmeber it.

After that take AD.exe copy it intro your WoW 1.12.1 root DIRECTORY where wow.exe is then create a folder called "maps" whitout the quotes in the WoW 1.12.1 root DIRECTORY, then execute AD.exe wait a few min depending on your computer speed.
**NOTE** If it AD.exe says it cant open patch-2.MPQ its normal just let it go.

When AD.exe is done, copy the "MAPS" directory from WoW 1.12.1 and put it in the Mangos TBC root directory where mangosd.exe and realmd.exe are.

**NOTE** i am using enUS as a exemple here.
Open WinMPQ now and open "/Data/enUS/locale-enUS.MPQ from TBC Beta DIRECTORY, select all the DBC files and extract them intro the Mangos TBC emu root DIRECTORY then rename the DBCClientFile DIRECTORY to dbc.

or just download the DBC from here: (filebeam.com/58069e201ca17a662b745cbd9ba6ecf5) from DDDooGGG

__________________________________________________ ________/\
Second Step: ZOMG WTF is MySQL!? /
__________________________________________________ ________/

Assuming you have MySQL installed and Navicat to make the job easier. open Navicat and make a connection to your MySQL Server.

Create a database for your World server, any name can be used aslong it dont contain spaces and create an other one for your Realm server.
This can be done by Right-Clicking in the left box it will bring a menu like in the Fig. 01 Image.

[Only registered and activated users can see links. Click Here To Register...]

Right-Click on your world database and choose "Execute Batch File.." (Fig. 02) find your world server SQL file. ( mangos.sql )
(IMPORTANT)Wait till mangos.sql is done Executing it should takes few mins.
Right-Click on your realm database and choose "Execute Batch File.." (Fig. 02) find your realm server SQL for the realm server ( realmd.sql )

DO NOT FORGET! to change the realmlist ip in the realm server database the default included in the compboy SQL is "dotawow.ath.cx" you must change it for 127.0.0.1 for local play or your internet IP to allow connection from the net.
*OPTIONAL* in the realmlist table you can change the name of your server.

Now if you did evreything correctly it should look like this in Navicat... This image is only an exemple
bcemu is the World Server Database in this image.

[Only registered and activated users can see links. Click Here To Register...]

Third Step: Configuring Mangos /
__________________________________________________ ________/

Go intro your mangos TBC emu folder and find those files called "mangosd.conf" and "realmd.conf"

For Mangosd.conf change the info so it match MySQL info

Code:
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;user;pass;realm_server"
WorldDatabaseInfo = "127.0.0.1;3306;user;pass;world_server"
For Realmd.conf change the info so it match MySQL info
**NOTE** The LoginDatabaseInfo line should be the same as the line from Mangosd.conf

Code:
# Database connection settings for the realm server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;user;pass;world_server"
Save those files and Run Mangosd.exe and Realmd.exe and that should be it.
11/12/2006 13:19 solas#2
Hi ich habe es zum laufen bekommen...nur springt er vom Charactermenü immer zurück zur Realmliste. Woran liegt das?


Code:
2006-11-12 13:25:45 Using configuration file realmd.conf.
2006-11-12 13:25:45 MaNGOS realm daemon /0.6-SVN (Win32)
2006-11-12 13:25:45 <Ctrl-C> to stop.

2006-11-12 13:25:45 Database: 127.0.0.1;3306;root;mypw;bcserver
2006-11-12 13:25:45 Connected to MySQL database at 127.0.0.1

2006-11-12 13:25:45 SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2006-11-12 13:25:45 Added realm "BC Test".
2006-11-12 13:25:45 realmd process priority class set to HIGH
2006-11-12 13:25:45 
2006-11-12 13:26:10 Accepting connection from '127.0.0.1:1461'
2006-11-12 13:26:10 [Auth] got data for cmd 0 ibuf length 40
2006-11-12 13:26:10 [AuthChallenge] got header, body is 0x24 bytes
2006-11-12 13:26:10 [AuthChallenge] got full packet, 0x24 bytes
2006-11-12 13:26:10 [AuthChallenge] name(6): 'DENNIS'
2006-11-12 13:26:10 SQL: SELECT `password`,`gmlevel`,`banned`,`locked`,`last_ip` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:26:10 [AuthChallenge] Account 'DENNIS' is not locked to ip
2006-11-12 13:26:10 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:26:11 [Auth] got data for cmd 1 ibuf length 75
2006-11-12 13:26:11 [AuthLogonProof] checking...
2006-11-12 13:26:11 User 'DENNIS' successfully authed
2006-11-12 13:26:11 SQL: UPDATE `account` SET `sessionkey` = '56877A50CCC761D1F7B7BE9ECD1486B6023D6A8A9DC7ED1513167F9788B419D1E7F946DFD5B65C0B', `last_ip` = '127.0.0.1', `last_login` = NOW() WHERE `username` = 'DENNIS'
2006-11-12 13:26:11 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:26:11 [RealmList]
2006-11-12 13:26:11 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:26:11 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:26:37 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:26:37 [RealmList]
2006-11-12 13:26:37 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:26:37 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:27:01 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:27:01 [RealmList]
2006-11-12 13:27:01 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:27:01 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:27:27 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:27:27 [RealmList]
2006-11-12 13:27:27 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:27:27 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:27:32 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:27:32 [RealmList]
2006-11-12 13:27:32 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:27:32 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:27:37 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:27:37 [RealmList]
2006-11-12 13:27:37 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:27:37 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:27:42 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:27:42 [RealmList]
2006-11-12 13:27:42 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:27:42 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:27:47 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:27:47 [RealmList]
2006-11-12 13:27:47 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:27:47 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:27:52 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:27:52 [RealmList]
2006-11-12 13:27:52 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:27:52 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:27:57 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:27:57 [RealmList]
2006-11-12 13:27:57 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:27:57 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:28:02 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:28:02 [RealmList]
2006-11-12 13:28:02 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:28:02 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:28:16 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:28:16 [RealmList]
2006-11-12 13:28:16 SQL: SELECT `id` FROM `account` WHERE `username` = 'DENNIS'
2006-11-12 13:28:16 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 1 AND `realmid` = '1'
2006-11-12 13:28:47 Accepting connection from '127.0.0.1:1490'
2006-11-12 13:28:47 [Auth] got data for cmd 0 ibuf length 40
2006-11-12 13:28:47 [AuthChallenge] got header, body is 0x24 bytes
2006-11-12 13:28:47 [AuthChallenge] got full packet, 0x24 bytes
2006-11-12 13:28:47 [AuthChallenge] name(6): 'PLAYER'
2006-11-12 13:28:47 SQL: SELECT `password`,`gmlevel`,`banned`,`locked`,`last_ip` FROM `account` WHERE `username` = 'PLAYER'
2006-11-12 13:28:47 [AuthChallenge] Account 'PLAYER' is not locked to ip
2006-11-12 13:28:47 SQL: SELECT `id` FROM `account` WHERE `username` = 'PLAYER'
2006-11-12 13:28:47 [Auth] got data for cmd 1 ibuf length 75
2006-11-12 13:28:47 [AuthLogonProof] checking...
2006-11-12 13:28:47 User 'PLAYER' successfully authed
2006-11-12 13:28:47 SQL: UPDATE `account` SET `sessionkey` = 'B733374C88CF99F2F010EFAC1BF71BFCF144BBDDEE75AEAD4578CB736A6ADE6AFBC1FAB67B7087EB', `last_ip` = '127.0.0.1', `last_login` = NOW() WHERE `username` = 'PLAYER'
2006-11-12 13:28:47 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:28:47 [RealmList]
2006-11-12 13:28:47 SQL: SELECT `id` FROM `account` WHERE `username` = 'PLAYER'
2006-11-12 13:28:47 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 3 AND `realmid` = '1'
2006-11-12 13:29:13 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:29:13 [RealmList]
2006-11-12 13:29:13 SQL: SELECT `id` FROM `account` WHERE `username` = 'PLAYER'
2006-11-12 13:29:13 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 3 AND `realmid` = '1'
2006-11-12 13:29:49 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:29:49 [RealmList]
2006-11-12 13:29:49 SQL: SELECT `id` FROM `account` WHERE `username` = 'PLAYER'
2006-11-12 13:29:49 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 3 AND `realmid` = '1'
2006-11-12 13:29:50 [Auth] got data for cmd 16 ibuf length 5
2006-11-12 13:29:50 [RealmList]
2006-11-12 13:29:50 SQL: SELECT `id` FROM `account` WHERE `username` = 'PLAYER'
2006-11-12 13:29:50 SQL: SELECT `numchars` FROM `realmcharacters` WHERE `acctid` = 3 AND `realmid` = '1'
11/16/2006 11:48 DoSewow#3
Jo habe das gleiche Problem..
Kann das daran liegen das ich nen DE_CLIENT benutze ??


Yes i get the same problem like solas, everytime i conenct to the realm after 3sec. i'm back to the Realmlist.

//edit:

Es geht habe nur ausversehen die datenbank falsch geschrieben ^^
11/17/2006 20:11 nesty#4
Funktioniert das auch mit der 1.12.2 version???
11/18/2006 13:51 DoSewow#5
jo, ich benutze selber die 1.12.2 und es klappt super.

Hmm mal so ne Frage am rande.. kann man den überhaupt in die Scherbenwelt? Ich probiere heir schon ne weile rum aber noch keine möglichkeit gefunden....
12/05/2006 23:27 T3quil4#6
Guten Abend

Bei mir besteht folgendes Problem:

Wenn ich mich einlogge und das Realm auswähle, dann bleibt er bei "In Realm einloggen" stehen und macht nicht weiter. Welche Ursache kann das haben?
12/31/2006 13:36 Freddy1337#7
Quote:
Originally posted by _AiM_@Oct 29 2006, 02:59
First Step: Installation, MAPS and DBC extraction /
__________________________________________________ ________/

Install WoW and upgrade to 1.12.1
Install Burning Crusade Beta client build 5991
Install MySQL and Navicat
Extract WinMPQ

Extract the Mangos TBC Emu intro any DIRECTORY you want.. as long you remmeber it.

After that take AD.exe copy it intro your WoW 1.12.1 root DIRECTORY where wow.exe is then create a folder called "maps" whitout the quotes in the WoW 1.12.1 root DIRECTORY, then execute AD.exe wait a few min depending on your computer speed.
**NOTE** If it AD.exe says it cant open patch-2.MPQ its normal just let it go.

When AD.exe is done, copy the "MAPS" directory from WoW 1.12.1 and put it in the Mangos TBC root directory where mangosd.exe and realmd.exe are.

**NOTE** i am using enUS as a exemple here.
Open WinMPQ now and open "/Data/enUS/locale-enUS.MPQ from TBC Beta DIRECTORY, select all the DBC files and extract them intro the Mangos TBC emu root DIRECTORY then rename the DBCClientFile DIRECTORY to dbc.

or just download the DBC from here: (filebeam.com/58069e201ca17a662b745cbd9ba6ecf5) from DDDooGGG
kann das bitte jmeand übersetzen? hrhrh
kann net sooo gut english^^
den rest vertseh ich aber...

thx Freddy
12/31/2006 16:50 Strike-#8
Erster Schritt: Installation, MAPS und DBC extraktion /

Installiere WoW und Patche auf 1.12.1
Installiere Burning Crusade Beta build 5991
Installiere MySQL und Navicat
Extrahiere WinMPQ

Danach nimm die AD.exe, kopiere sie in dein WoW 1.12.1 Verzeichnis wo die wow.exe liegt, dann erstelle einen Ordner den du maps nennst im selben Ordner. Dann starte die AD.exe und warte bis sie fertig ist.*NOTE* Wenn AD.exe sagt, sie kann patch-2.mpq nicht öffnen, das ist normal... einfach weiterlaufen lassen.

Wenn die AD.exe fertig ist, kopiere den maps ordner in deinen Mangons TBC Ordner wo mangosd.exe liegt.

*NOTE* ich benutze die enUS version als Beispiel hier.
Öffne WinMPQ und öffne /Data/enUS/locale-enUS.mpq aus deinem TBC Beta Verzeichnis, markiere alle DBC files und extrahiere sie in dein mangos Verzeichnis, dann benenne den DBCClientFile Ordner um zu dbc.

oder lade es dir hier herunter: filebeam.com/58069e201ca17a662b745cbd9ba6ecf5) from DDDooGGG
12/31/2006 18:22 Freddy1337#9
thx !!!!!!
12/31/2006 18:42 Freddy1337#10
hmmm
kann mir das nochmal wer erklären?
also BC is installiert, hab alle notwendigen daten heruntergeladen, mysql und frame network isnd auch installiert...
oder könnte es jemadn ganz übersetzen?^^
wäre sehr hilfreich

mfg freddy
12/31/2006 19:26 Strike-#11
wenn du das alles drauf hast und es so konfiguriert hast wie die bilder! zeigen... dann musst du den schritt configure mangos machen.
01/01/2007 15:24 Freddy1337#12
ne das batchen geht ja nicht :(
irgendwie das mit dem client file umbenennen vertseh ich net ganz naja muss ma shcaun
01/01/2007 15:55 Freddy1337#13
ok also hab jetzt alles hinbekommen außer:
bei mangos config und realmd config , was muss ich als username angeben? und was bei database?
immer wenn ich mangos.exe öffnen will shcließt sie sich sofort...
kann mir jemadn erklären auf deutsch was da genau rein muss?
01/01/2007 17:56 Strike-#14
Du musst das dort angeben wie du deine database genannt hast, bzw welchen username du da angegeben hast bei erstellen der database.

Und nur mal so ... 2 Doppelposts in einem Thread... Es gibt eine EDIT Funktion wie du ja selbst schon herausgefunden hast, bitte benutze diese auch!
01/01/2007 18:09 Freddy1337#15
ja das habe ich alles gemacht doch wenn ich die mangos.exe starten will schließt sie wieder sofort.....
Ich glaub ich hab da fehlen mir datein die in den bcemu ordner müssen oda so aber naja kann halt net sooo gut english, aufjedenfall sschließt sich die exe immer,,