WotLK and TBC realmserver

[FragFrog]

What is this release
In short, this is a realmserver for Mangos that allows both TBC and WotLK clients to connect. Supported versions are TBC 2.4.3 and WotLK 3.1.3.

Why support both clients
At the server I am currently helping as a developer there are quite a lot of players that prefer TBC over WotLK. To keep those as well as attract people who are interested in WotLK, we decided to not switch but keep one realm for each version. Since it is very difficult to host two realmservers on the same IP we decided to create one realmserver that would allow both clients to connect to a server. It will also show TBC and WotLK realms listed next to eachother (though of course, a WotLK client cannot connect to the TBC realm and vice versa).

Known issues
Nonexistant. There are a few warnings if you connect a WotLK server to a TBC realm account database but those are mostly a few extra columns that are not required for succesfull operation of the realmserver. Have not encountered a single crash using this either.

Release forms:
The compiled realmserver can be found here. This was compiled for Windows 2003 SP2.

Alternatively the GiT patch can be found here.

Installation
Windows users can simply overwrite their realmd serverfiles with the ones provided in the ZIP archive, restart their realmserver et voila. Alternatively you can apply the patch yourself and recompile your own server - git bash command:

git apply 0001-TBC-realmd-support.patch

After the realmserver has come online you will need to define a unique port/ip for each realm on your server, if you run both WotLK and TBC on the same machine you will thus need to set either of those to a nonstandard port like 8086. It goes without saying that for each realm you need a seperate folder with the server, maps and DBC files. Just make sure their mangos.conf point to the same LoginDatabaseInfo and have the correct RealmID.

Support
None. I figured this might help out a few others that want to run different realm versions alongside eachother, but don't count on any continued support

[MentaL]

[TrekPL]

I have question - I applied your patch and recompile everything. However I have a problem. You said both servers(realms) should be set on the same Login DB (you think about realmd DB?) and there is my problem - I'm running both servers for a while and there are duplicated entry in DB. My config: realm 1: TBC (world port 8085), realm 2:WOTLK(world port 8086)
(separated folders for all files, separated DB for every part (mangos, char, realm, scripts).

When I try to log in via TBC client it works perfectly. When I try to log in via WOTLK client - it displays only TBC realm. Both mangosd processes areconfigured correctly (port, realmd id)

I presume this problem is made by realmd db set - it is set to TBC realmd.

Do you think I should somehow merge both realmd DB's?

[FragFrog]

Aye, the realm database must be the same for both realms - otherwise they cannot connect to the same realm server. This is partially good since it means your users can simply create 1 account and be able to login with that on both servers, but unfortunately it also means you will have to perform a merge when you wish to merge two old realms into one.

[TrekPL]

Thank You

It is now working as it should :D

For those who could have the same problem as I was:

I had to delete all accounts from wotlk (fortunately there was only few of them and players agreed for this step) because as FragFrog said both clients will use the same login DB -> and character DB uses account numbers from login DB so if you have any accounts except basic (Admin, mod, GM) there will be duplicated entry and as a result of this errors. You can of course manually change all account numbers to prevent that (if you have already big number of players) but this will be very hard.

Thanks again FragFrog for this patch and instruction

[FragFrog]

A possible automatic way to insert entries from one database to the other:

INSERT INTO  `tbc_realmd`.`account`
  (`username`, `sha_pass_hash`, `gmlevel`, `email`, `joindate`, `banned`, `last_ip`, `locked`, `expansion`)
  (SELECT  `username`, `sha_pass_hash`, `gmlevel`, `email`, `joindate`, `banned`, `last_ip`, `locked`, `expansion`
   FROM    `wotlk_realmd`.`account`
   WHERE   `username` NOT IN
    (SELECT `username`
     FROM   `tbc_realmd`.`account`))

Replace both occurences of "tbc_realmd" with the name of your destination realmd database and "wotlk_realmd" with the name of your extra realmd database. This only works if one MySQL account has access to both databases, like your root account, and they are both on the same database server. I have not tested it yet, so no guarrantees.