Thread: How to make a Cataclysm alpha server + make it public

This is not made by me or mmopro.org team !!!

Credits: wazlefish

Ok, the aim of this tutorial is to tell you exactly how to make a cataclysm alpha server on a step by step basis, then make it public. So lets get started...

What you will need to download

You will need a GIT Client which can be found here - [Only registered and activated users can see links. ]

You will need Microsoft Visual C++ 2008/2010 (I used 2010 for my compile). These can be downloaded free from here - [Only registered and activated users can see links. ] [Only registered and activated users can see links. ]

MySQL Server which can be found here - [Only registered and activated users can see links. ]

And you need a program to edit your database (an SQL Client). You have 3 options for this. The free option is Heidi SQL and can be found here - [Only registered and activated users can see links. ]
Then you have the 2 other options which you can download as a trial. (I used SQLyog). SQLyog can be found [Only registered and activated users can see links. ] and Navicat can be found [Only registered and activated users can see links. ]

Now you will need to download the Cataclysm alpha.

The enGB client can be found here - [Only registered and activated users can see links. ]
The enUS client can be found here - [Only registered and activated users can see links. ]

Getting the core

1)Install the GIT Client you downloaded
2)Once its installed, run Git Bash. This is found at start -- All Programs -- Git -- Git Bash. This is shown in a screenshot below...



3)Once Git Bash is open, type the following into the console... git clone git://github.com/Fabi/diamondcore.git

4)Once that has been completed, Type this into the console... cd diamondcore

5)And finally, type this into the console... git pull git://github.com/Fabi/diamondcore.git cataclysm_alpha

You now have the core, it should be found at c:/Users/YOURNAME/diamondcore

Compiling the core

1) First install visual c++ express 2010 or 2008. A computer restart will be required in the installation.

2) Ok, once it is installed,we can compile the core. Open up the diamondcore folder and double click on the "win" folder. You should see 2 files named "DiamondCore_90" and "DiamondCore_100".

Compiling with c++ express 2008

1) If you installed visual c++ 2008 open the program and drag and drop "DiamondCore_90" Into the program. This is shown in the screenshot below...



2) Now select the "Build" menu at the top of the page and select "Configuration Manager". There are 2 drop down menus. Once is named "Active solution configuration" and the other one is called "Active solution platform". Make sure that the "Active solution platform" is set to "Win32" and the "Active Solution configuration" is set to Release. This is shown in the screenshot below...



3) Now that you have the settings configured, go on the build menu again and select "Build Solution".

4) Sit back and wait for the Build to finish, it shouldn't take too long.

5) Once the build has been completed, scroll down the page and follow the steps under "After the build"

Compiling with c++ express 2010


1) Open up visual c++ 2010 and drag and drop the file "DiamondCore_100" into the program. This is shown in the screenshot below...



2) On the solution explorer to the left of the page, right click on "Solution 'DiamondCore_100'" and select "Configuration Manager".There are 2 drop down menus. Once is named "Active solution configuration" and the other one is called "Active solution platform". Make sure that the "Active solution platform" is set to "Win32" and the "Active Solution configuration" is set to Release. This is shown in the screenshot below...



3) Right click on "Solution 'DiamondCore_100' and select "Build Solution"

4) Once it has been completed, go onto the next section.

After the build

With the Build finished, we need to move and rename some files. This process is exactly the same on both the c++ 2008 compile and the c++2010 compile.

1) Go to your diamondcore folder and double click on "src". Now double click on the "logonserver" folder. Inside this folder there should be a file called "logonserver.conf.dist". Rename this file to "logonserver.conf".

2) Go back to the "src" file and enter the "worldserver" file. Inside of here there should be a file called "worldserver.conf.dist". Rename this file to "worldserver.conf".

3) Copy the "logonserver.conf" and the "worldserver.conf" and paste them into the following file. "C:\Users\YOURNAME\diamondcore\bin\Win32_Relea se" There will already be files in there but replace them.

4) Download this file... [Only registered and activated users can see links. ]

5) Place the contents of the zip file into ""C:\Users\YOURNAME\diamondcore\bin\Win32_Rele ase" The folder inside of the zip file should be called "dbc"

6) Open up "WorldServer.conf" with notepad and change the "DataDir = "" To DataDir = "C:\Users\YOURNAME\diamondcore\bin\Win32_Relea se"

MySQL and database editing

1)Install MySQL which you downloaded at the start as a typical install. Once finished, we need to configure the server... During the configuration, select the following when they come up... Standard Configuration -- Install as Windows Path, Service name "MySQL" and tick "Launch MySQL automatically" -- now for this part, set your username as "root" and set your password as "diamondcore".

Now we are done installing MySQL.

2) Install the SQL client which you downloaded. I will be using SQLyog throughout this part of the tutorial so I suggest you install this as well.

3) Open up the client (I opened up SQLyog) on the connection info, fill it out as shown below... (The password was diamondcore)



4)Once we are connected, we are going to create 3 new databases. On SQLyog, I right clicked on the White area to the left of the page and selected "Create Database" I named this database "characters"

5) Right click on the white area again, create a new database named "logon"

6) Create another database and name it "world".

7) Right click on the "characters database you created , go down to import and select "Restore from SQL Dump". Navigate to the following folder and select the "characters.sql" file... "C:\Users\Callum\diamondcore\sql"

8) Do the same with the logon file except select the "logon.sql" file instead.

9) Go to "[Only registered and activated users can see links. ]" and click on "Download Source". Select the .zip file and wait for the download to finish. This button is shown in the screenshot below...



10) Place the files within the zip folder in your diamondcore folder.

11) Extract the file within the "PreAlpha" folder

12)Navigate to your mysql installation folder (Mine was found in C:\Program Files (x86)\MySQL\MySQL Server 5.1) and open the my.ini file with notepad. Once the file is open, press ctrl+f and type "server section" without the quotation marks. Under this section, you need to type the following, again without the quotation marks... "max_allowed_packet = 125M". I placed this beneath the section of text saying "# The TCP/IP Port the MySQL Server will listen on
port=3306".

Once this is done, restart your computer (This is necessary or else you can't import the next sql file.)

13) Go back onto your SQL client and follow the same step as used in step 7/8 except select the file you extracted in the "PreAlpha" folder. This is shown in the screenshot below...



14) Download the source files from this link - "[Only registered and activated users can see links. ]" and place them into your diamondcore folder. Replace all of the files that it needs to overwrite.

15) Go back onto your SQL client and perform the same step from steps 7/8 to install all of the updates from the " C:\Users\YOURNAME\diamondcore\sql\Updates" File. These should all be done on the world database.

16) Now perform the "Restore from SQL dump" to add all of the files from the "C:\Users\YOURNAME\diamondcore\sql\cataclysm_a lpha ". The way to tell which database you need to perform the "Restore from SQL Dump" on is yb looking at the first word of the sql file. For example, the file "1_logon_realmlist_realmbuilds.sql" will go on the logon database as it has "logon" in its name.

17)Your database is pretty much complete. Now it is time to make it public.

Making your server public
1) First of all, go to "http://dyndns.org/" and register an account.

2) Once you are logged in, go to this address... "[Only registered and activated users can see links. ]"

3)Go through all of the steps on that page. I used the following settings on my page...



4)Port Forwarding time. I have forwarded all of the following ports on my router...

Code:

3724
	6112
	6881 - 6999
	1119
	1427014 - 27050
	4380
	3036
	3306
	6112
	6881
	8050
	8093
	8129
	3727
	80
	8085
	3724
	8086 - 8087

The reason there are so many is because i have ran off many cores and had many realms running through my router.

5) Once your ports are correctly forwarded and your firewall exceptions have been added, you need to access your SQL client and enter the logon database. To do this, double click on the logon database, then double click on "tables" then select "realmlist". Click on the table data tab to the right of the page just below half way down.

6) Change the name of the realm to what ever you want.

7) Change the address of the realm to your external ip. If your unsure what it is, this website can tell you - [Only registered and activated users can see links. ]

Your server should now be ready!

Starting and connecting to your realm

1) Go to your wow cataclysm beta directory "C:\Program Files\World of Warcraft Beta" or if your on a 64 bit operating system "C:\Program Files (x86)\World of Warcraft Beta".

2) Go to the "Data" file and then enter the enUS or enGB file. Inside that file is another file named "relamlist.wtf".

3)Open your realmlist with notepad and enter the following...

Code:

set realmlist YOUR DYNDNS HOST HERE

So for my realmlist it was

Code:

set realmlist delusionwow.dyndns.info

This is what other people need to place in their realmlist if they want to connect to your server.

4)Go to your diamondcore folder and enter the bin/win32 folder. in here, start up both the "Logonserver.exe" and the "WorldServer.exe". I receive quite a lot of errors when the WorldServer.exe is loading however these are to be expected at this stage in the database development.

5)When WorldServer.exe has finished loading, type the following commands to add accounts to the server...

account create accountname accountpassword

account set gm accountname numberfrom 0-3 (0 = member, 2 = Moderator 3 = GM)

account set addon accountname numberfrom 1-2 (1= Burning Crusade 2 = WOTLK/Cataclysm).


6)Load up your cataclysm beta and you should be able to log in.

Thanks for reading this tutorial and I hope it has worked correctly for you. It took quite a while to make this tutorial so please leave your feedback below, cheers!

CREDITS
--------------
king48488 for creating the DiamondCore project thread. His post can be found [Only registered and activated users can see links. ]

MaNGOS for the database files

Credits to all of the creators of the programs used throughout this tutorial

Myself (Wazlefish) for creating this tutorial.

When I am trying to preform "Restore from SQL dump" as you say in step 15 I get errors. Example:
"Error occured at:2010-05-20 20:49:43
Line no.:1
Error Code: 1146 - Table 'world.spell_proc_event' doesn't exist"

The same happens when I am trying to preform "Restore from SQL dump" at step 16, it worked fine with the Logon database but when i tried with the World and Character databases i got more errors. Example:
Error occured at:2010-05-20 20:52:50
Line no.:3
Error Code: 1060 - Duplicate column name 'power8'

I could really use some help :)

README:

Pre-Alpha translates to EXTREMELY BUGGY. In addition, a pre-release-pre-private server release is of the utmost unstable. Do not accuse this method as being wrong or buggy, simply compiling it is prone to bugs. Alpha comes before a beta (obviously 'cause A comes before B), meaning that even Blizzard's version is prone to crashes. They released a pre-Alpha to bring attraction and the media.

Compile and use with care!!

----
@kekipop
Try doing it through the command line. Many times, 3rd party clients cause issues.

is there a program i could use in place of microsoft visual c++ , because it wont download for me.

strange shouldn't be any problem downloading c++ :/

Nice Job

Hello there,

Thanks for the great guide, just wondering if you might be able to assist me with my problem though.



Basically, thats the message i get after inputting the text into the console.

Apologies for my lack of knowledge on this subject your help would be much appreciated.

Mike

I keep getting and error at step 5 saying "fatal: Couldn't find remote ref cataclysm_alpha". What does this mean and how do i fix the problem? Can anyone help with this?