Realm of the Mad God server files

[JewSanta]

I am going to make it clear. I did not create these nor have I worked on the current release of them. I am simply moving them over to RZ because I feel that the people developing here can do more with them.

There are a couple things you will need before we can get started.
Server files and client:

You must be registered to see links

Yogda:

You must be registered to see links

Visual Studio: (I am linking 2010 express. Should be able to do everything we need)

You must be registered to see links

MySQL:

You must be registered to see links

Installation and setup:

Server Files Part 1:

Spoiler

Once you go to that github link found above you are going to download the server zip.
The button to start the download is at the upper left section of the site (Just Below the network tab) Go ahead and hit zip.
This will start your download.
Go ahead and extract it to the location you desire. I put mine on my desktop.

Visual Studio:

Spoiler

Run through the visual studio installer.
This is the area where I will not be able to help too much.
I use the premium version and the installers are a little different.
If you have any questions feel free to ask and I will help to the best of my ability.

MySQL:

Spoiler

Once it is downloaded go ahead and hit run.
First you are going to install MySQL products.
Make sure you check skip checking for updates.
Keep hitting next till you get to the password configuration.
The default password for the server files is botmaker however I dont like the massive security hole that presents.
Set up a password for your SQL Server that you will remember.
We are going to change the default password in the server code shortly.
Once installed you are going to open and run Dump20130404.SQL found in your server files folder.

Server Files Part 2:

Spoiler

First thing we need to edit is confreader.
It is in the db section.
Lines 47 and 55 both contain a password called botmaker.
Replace it with the password that you configured for MySQL
You will need to do the same with the config files found in the Server and wServer.
You can open these configs in Visual Studio or a notepad from the folders.
Once these are configured you can build your solution.

Yogda:

Spoiler

Once installed go ahead and open up Yogda
Open up the client.swf found in the server folder.
Search realmofthemadgod
The search should send you to a few lines one of which being 3702.
Edit that to say 127.0.0.1
4213 will be the next line we are going to edit.
Scroll down a little bit to the line and change it to say 127.0.0.1:8080
Save your new client. It should save to Client-new.swf

Launching:

Spoiler

Open Server>bin>release and run server.exe as an admin
Open wServer>bin>release and run the wServer.exe as an admin
Your server is now online and you can connect.
To open your client you either need a browser or flash loader to open the swf.
I will dig up my old one if enough people need it.

Opening the server to friends:

Spoiler

The changes to open your server to friends are fairly brief.
Note: You will no longer be able to connect via localhost when doing this.
The same lines we edited in Yogda must now be edited to your ip.
3702 should now read as your ip IE: 11.22.33.44
4312 should now read as your ip with port 8080 IE: 11.22.33.44:8080
You do need to port forward those 2 ports.
The last change you need to make is opening the server files.
This is done in the solution, open it up and under the server project open the char folder and then open up list.cs
On line 41 it says DNS = (text here that I can not remember)
Change this line to say DNS = "11.22.33.44",
Where 11.22.33.44 is your ip.
You may also need to disable your windows firewall if friends are unable to connect.

Again, I just made the tutorial for RZ. I had no part in creating the server files.
If anyone has questions I will answer them to the best of my ability.
These server files do not contain Dungeons and Oryx.
They do have realm events such as Sphinx and other random spawns.
The spawn rates are a little high however that is adjustable.
There is one problem that I have not been able to fix (nor has anyone else to my knowledge) where all the entities jitter and vibrate a LOT. I am messing around with some possible fixes but nothing I would waste time noting.

Hope it helps you guys,

Santa

 

[Omnija]

Thanks for sharing, could you release a pre-compiled version. I recently reformatted my computer and don't want to install vs.

 

[JewSanta]

The whole thing is essentially pre-compiled.
Look in the release folders and see if they are there.
You should be able to launch the client-new.swf (I may have to double check that)
If you change the pass in your configs it should work.

 

[ninein]

help ! loop connect

 

[trhero]

can we make playable on website?

 

[JewSanta]

@ninein Did you register an account?

@trhero all you have to do is embed the client-new.swf into the webpage of choice.

 

[ninein]

@ninein Did you register an account?

@trhero all you have to do is embed the client-new.swf into the webpage of choice.

hi. JewSanta
i register test account = username : 1@gmail.com pass:12345678
and i try username : asd@gmail.com pass:12345678

it same.

 

[Wokki]

I tried opening the wServer.exe and got this error.

What's wrong with it?

 

[JewSanta]

Something is wrong with an IP somewhere along the way if I had a guess.
The reconnect loop was never a problem I ran into personally.
Try turning off your firewall for testing purposes. If that doesn't work let me know.

@schematic what were you doing when that happened?

 

[Wokki]

@schematic what were you doing when that happened?

All I did was run Server.exe as Admin (Started just fine) and then tried starting wServer.exe as Administrator and this is what happened.

And I didn't compile the files, thought it'd work fine without doing so as you had told Omnija.

 

[JewSanta]

I never tried without compiling. i simply made a guesds of it. give compiling a shot and tell me if that fixes it.

 

[ninein]

turning off your firewall for testing . It that doesn't work. it same :/:

 

[Wokki]

I can't seem to be able to open the server.sln with the given Visual Studio.

EDIT: Downloaded Visual Studio C# 2010 and was able to open up the sln file. Built it, but now the error is this.

 

[ninein]

i connect success. I did not do anything. :ehh:

but connect success.

 

[JewSanta]

@Schematic what version of vs do you have?

@ninein congrats, strange that it just wouldn't let you connect

 

[Wokki]

@JewSanta, here are the details from the VS and the VCC++ 2010 Express that I downloaded from the link you gave.

Microsoft Visual Studio 2010
Version 10.0.30319.1 RTMRel
Microsoft .NET Framework
Version 4.0.30319 RTMRel

Installed Version: VC Express

Microsoft Visual C++ 2010   01013-532-2002287-70214
Microsoft Visual C++ 2010

 

[trhero]

i am getting this error
1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

 

[trhero]

I tried opening the wServer.exe and got this error.

What's wrong with it?

same problem over here hwo can i fix this?

 

[Omnija]

i am getting this error
1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

It's because create and death both have it in the character mysql. I haven't tested myself but i think their's already a death column some where else, so try deleting the death line.

 

[Wokki]

It's because create and death both have it in the character mysql. I haven't tested myself but i think their's already a death column some where else, so try deleting the death line.

I changed it to DEFAULT '0000-00-00 00:00:00'. With that change I was able to import it.
However, I also tried importing it with MySQL Workbench, which for some reason let me import it without giving any errors.

Still unable to launch the wServer.exe, though. The error remains the same as in my 2nd previous post.

I also get this error when opening it in C# (I know this is from C++, but it's the exact same when opening in C#)

I'll try downloading Visual Studio 2010 Ultimate and attempt building with that and see if it works then, as apparently solution folders are not supported in Express version (That's what I found from googling)