2.3 Server Guide - Idiot Proof

[mStation]

2.3 Server Guide - Idiot Proof with videos

!!07/12/2008 - UPDATE / REMAKE OF THE SERVER GUIDE!!​

This Guide Is For Windows XP Home / Professional Users

IF YOU ARE LOOKING FOR THE WINDOWS VISTA PRESS HERE

!!ATTENTION!! : Before continuing you must know the following things..
The server files are packed which means that most of the recent antivirus programs out there.. like AVG, Kaspersky or whatever will recon that the exes zipped in the server files are viruses.. which means that before continuing you must add an execption to your antivirus programs to disable scanning in C:\Mirserver... if you don't do this in most cases the antivirus application might not delete the file if you say it not to but it will block it anyway which will turn into having a server not working properly.. take a few minutes before starting the guide to check if you have or not an antivirus on your pc.. and if u do add an exception..

Another thing is that in the server files i created 3 .bat files so that they will set the files for you but i created them only for windows xp users which have english operating system language.. if you have different languages than english then post here and i will help you out!

STEP 1
----------------------------------------------------------------------​

Make sure you are a Windows XP Users and that the language of the operating system is in English..to do so press START > RUN and type winver

STEP 2
----------------------------------------------------------------------​

Download the Legend Of Mir 2.3 Client from this website: GamersHell - I think Client will be hosted for some long time here..

When you have downloaded the file extract it anywhere and double click on the Mir20Client.exe

The installation will start.. this will take a few minutes depending on your system.. in order to install it correctly follow this easy steps..

Starting from the first window after it has read the installation files press:
- Next
- Yes
- Insert Username and Company (i have put . and .) & press Next
- Don't Change Destination Folder & press Next
- Next
Now wait for installation to complete.. after it has installed press
- Finish!

STEP 3
----------------------------------------------------------------------​

Download the SQL Server from here: LINK DOWN.. CAN ANYONE PROVIDE A LINK FOR THIS BEFORE ME? - i found this link which seems to work: Host

In order to install it correctly make sure that you havent got it already installed.. if you have then go into Control Panel > Add and Remove Programs and Uninstall the Microsoft SQL Server 2000..

if you have uninstalled it or it's your first installation then you can double click the SQLEVAL.exe and extract it in C:\

When it says "The Specified Output Folder Does Not Exist. Create it?" choose YES

After the installation has unpacked the files you will get a message saying "The package has been delivered successfully."

Now open C:\SQLEVAL and double click on autorun.exe

At the window choose:
SQL SERVER 2000 Components then Install Database Server..

Now follow my clicks and press:
- Next
- (make sure Local Computer is selected) and press Next
- (make sure Create a New instance of SQL Server, or install Client tools is selected) and press Next
- Name = . & Company = .
- Press YES
- (make sure Server and Client Tools is selected) and press Next
- Next
- (make sure Typical is selected) and press Next
- (make sure "Use the Same account for each service" is selected and double check that "Use The Local System Account" is selected) and press Next
- Choose Mixed Mode and input as password: sa
- Press Next

Here are 2 pictures of each window and what i clicked on..


if the images get cancelled by imageshack then you can download these: Images Part3

Now wait for it to installation to complete.. after it has completed you can delete the C:\SQLEVAL folder..

STEP 4
----------------------------------------------------------------------​

Download the edited mirserver files from here: MegaUpload

I don't know how long i will keep the files here so if someone else is willing to mirror i will be glad

This server files are already setted and have a few fixes in them.. the fixes are the mapquest error and the missing tables in sql that dont allow gt to work.. (Credit to TravisW)

Put the Mirserver.exe in C:\ and double click it.. in the window make sure it will extract itself in C:\ and press Install..

Now go in C:\Mirserver and double click on "1-Set Up Maps.bat"
This will copy for you all the maps in your client folder into your server files..

Now double click on "2-Set Up My Client files.bat"
This will fix your client files so that you can connect correctly to them
This will also create a Diamond Shortcut on your desktop.. use this to play the game from now on

Now double click on "3-Set Up Server Starter.bat"
This will fix your serverstarter and set it to work directly
This will also create a Serverstarter shorcut on your desktop, use this to start the server from now on

STEP 5
----------------------------------------------------------------------​

This is the last part of the Guide.. maybe also the most important part tbh..

If till now you haven't restarted your computer then do you can choose to do it now and let the SQL server service manager load by himself or simple make it load right away.. here i will tell you how to continue without restarting..

so open START > PROGRAMS > Microsoft SQL Server > Service Manager..

when the window pops up press the PLAY button and wait a few seconds.. if everything has been done correctly u should have the STOP button turning Red and the PLAY button turning Grey..

this is a picture of what should happen:


Now open START > PROGRAMS > Microsoft SQL Server > Enterprise Manager
when the window loads press the + near Microsoft SQL Servers
then press the + near SQL Server Group
then press the + near (local) (Windows NT)
then select Databases
Right click on it and choose "New Database"
In the window where it asks to give it a name call it mir2 & press Ok

Now press the + near Databases and select mir2
Right click on it and choose All Activities > Restore Database
Choose the Restore: From File option
Press Select Devices
Press Add
Under filename press the button with [ ... ] and browse to C:\Mirserver\DBServer and select mir2sql2000backup and press OK
Then press OK again
Then press OK again and you should return to the window where u selected the "FROM FILE" option before
In this window now choose in the top part the window tab called "Options" and here choose "Force restore Over existing database" then press OK

this are 3 pictures of what i described above:


if the images get cancelled by imageshack then you can download these: Images Part3

if everything has been done correctly then u shouldnt get any errors..

STEP 6
----------------------------------------------------------------------​

You can now start the server using the serverstarter link on your desktop..
wait it to load completly.. if you have done all the things i did u also will get this message at the end of the M2server.exe

[07/12/2008 11.01.21] LoginServer Connected(127.0.0.1:5600)
[07/12/2008 11.01.21] Gate[0](127.0.0.1:2135) Opened...
[07/12/2008 11.01.24] DBServer Connected(127.0.0.1:6000)

which means that the server is running correctly..

Now use the diamond link to open mir and create a new char..

FAQS
----------------------------------------------------------------------​

THERE ARE NO MONSTERS INGAME, HOW DO I ADD THEM:
Download this mogentxtfile: Here
Then i'm not sure of the procedure since i don't have SQL2000 installed but it should be something like this:
- open enterprise manager of sql.. open the mir2 db.. open tables.. right click on tbl_mogen and select all activities.. import data..
- then when the window pops up press next
- data source must be set to text file
- filename must be the txt mogen file u downloaded
- select copy tables and press next
- enlarge the source field to see the complete names of the tables.. one should be tbl_mogen$ and the other tbl_mogen$data.. select the first one
- under the destination voice press the arrow down and choose [mir2].[dbo].[TBL_MONGEN]
- in the transform voice press the ... and in the new window that pops up select
- "Create destination table" and "drop and recreate destination table" then press OK
- then press next and next again.. it should delete the table and recreate it with the new info in..

I WANT TO BE A GAMEMASTER, HOW DO I ADD MYSELF:
For setting yourself as GM open Enterprise Manager.. go into mir2 db.. open the tables and select right click on tbl_admin and choose open table -> show all rows..

then press the grey square on the row containing 10 Sting 127.0.0.1 and choose delete
on a new row write 10 GMCHARNAMETHATYOUWANTTOUSE and ip which in local is 127.0.0.1

 

[Peter12]

Unfortunately the files contain an error in the mapquest.txt.. u need to fix it.. ill soon add this step in the server setup guide.. for now go into C:\Mirserver\M2Server\Envir and open the mapquest.txt and delete the 14th row from the file.. then try to reload the server!

Have done this, and still having the same problem.
DBServer won't connect. Any other suggestions?

 

[Gough]

Have done this, and still having the same problem.
DBServer won't connect. Any other suggestions?

server says

[07/09/2008 16:36:03] Guilds: 0
[07/09/2008 16:36:03] Total Castles: 1
[07/09/2008 16:36:09] DBServer Connected(127.0.0.1:6000)
[07/09/2008 16:36:12] Gate[0](127.0.0.1:4038) Opened...
[07/09/2008 16:36:33] LoginServer Connected(127.0.0.1:5600)
[07/09/2008 16:46:01] Users: 0
[07/09/2008 16:56:01] Users: 0

dose this mean its the client?

 

[Peter12]

server says

[07/09/2008 16:36:03] Guilds: 0
[07/09/2008 16:36:03] Total Castles: 1
[07/09/2008 16:36:09] DBServer Connected(127.0.0.1:6000)
[07/09/2008 16:36:12] Gate[0](127.0.0.1:4038) Opened...
[07/09/2008 16:36:33] LoginServer Connected(127.0.0.1:5600)
[07/09/2008 16:46:01] Users: 0
[07/09/2008 16:56:01] Users: 0

dose this mean its the client?

Mine just says its connected and thats it lol.

You sure you've copied the exe with the ammendments?
I can actually get onto the server and attempt to make an account. As my DBServer hasn't connected, i can't actually make an account. Getting there slowly but surely lol.

 

[Gough]

Mine just says its connected and thats it lol.

You sure you've copied the exe with the ammendments?
I can actually get onto the server and attempt to make an account. As my DBServer hasn't connected, i can't actually make an account. Getting there slowly but surely lol.

maybe ill try setting up client again.. have to get a shower and that now.. going the club for a few pints.

if your db server isnt working it could be your sql... i have managed to set one up after trying to make a mir server for last few years lol

 

[Peter12]

maybe ill try setting up client again.. have to get a shower and that now.. going the club for a few pints.

if your db server isnt working it could be your sql... i have managed to set one up after trying to make a mir server for last few years lol

Aye, uninstalled and gonna try sql now.
Hopefully that'll sort out the problem.

 

[mStation]

for dbserver make sure u are getting a correctly working sql and make sure that u have the sql setting part correct too.. because its the only thing i can think..

if u cant start again from zero.. follow the guide slowly and make sure u get things done as the should be

 

[Peter12]

for dbserver make sure u are getting a correctly working sql and make sure that u have the sql setting part correct too.. because its the only thing i can think..

if u cant start again from zero.. follow the guide slowly and make sure u get things done as the should be

Is Vista compatible with sql version 200?

 

[Peter12]

Before i go any further, is this supposed to happen? (Trying to find out the problem before i reach the end of the installation.)

http://img124.imageshack.us/my.php?image=65443214hy2.jpg

 

[Monkeh]

yo m i got the server up n running n got mobs n stuff but i can only get them spawnin on oMa King Maps so its quie a pisstake ive searched lomcn n its just not working so what could it be any suggestions? thanks m8

 

[Gough]

Before i go any further, is this supposed to happen? (Trying to find out the problem before i reach the end of the installation.)

http://img124.imageshack.us/my.php?image=65443214hy2.jpg

add me to msn and ill try to help you when i get back from club

 

[Peter12]

add me to msn and ill try to help you when i get back from club

I'll take that asin no it shouldn't?

 

[mStation]

Is Vista compatible with sql version 200?

no.. they arent compatible.. there is a guide on how to set up a sql 2005 in the server help section.. here is the link!

yo m i got the server up n running n got mobs n stuff but i can only get them spawnin on oMa King Maps so its quie a pisstake ive searched lomcn n its just not working so what could it be any suggestions? thanks m8

the server files are setted to have mobs only in past bichon and evil mir maps.. if u want other files u have to add them in the tbl_mogen inside the mir2 db which u can reach using the enterprise manager of mssql 2000..

also u can import a typical mogen file offered by mirrealms using this link: http://www.lomcn.co.uk/forum/showthread.php?t=57585

but importing isnt soo simply.. u need to know what you are doing

 

[Monkeh]

well at the moment id rather import and then get to know what im doing afterwards so could you tell me how you imported the file since i couldnt do it n ive already tryed lol

 

[Peter12]

no.. they arent compatible.. there is a guide on how to set up a sql 2005 in the server help section.. here is the link!

Now you tell me, no wonder it never worked. >.< lol.

Meh i give up. sql 2005 is completely different to 2000 thus making this guide irrelevant now.

 

[Gough]

ok i have the game running (local) and no spawns which i have now just found out there are only a few working further into the game... i want all spawns so i can start at level 1 can someone help to sort out this problem please

 

[Peter12]

Right ok i've got onto the main server screen and when i go to make an account i get 'failed to create user account -1'

any ideas?

 

[Gough]

lol i can make an account but dont have any mobs

 

[Peter12]

lol i can make an account but dont have any mobs

Atleast you can get ingame hehe.

Took me so long to set this up as guide never said Vista users would have to use SQL 2005, not 2000

 

[Gough]

this dosnt support mobs. when you wait for message of the day you get it saying its only a test server and no mobs in it.

can anyone tell me how to get the mobs working? been trying all day

 

[Kazuki]

Now you tell me, no wonder it never worked. >.< lol.

Meh i give up. sql 2005 is completely different to 2000 thus making this guide irrelevant now.

I'm sorry, but I just have to say how funny I find this. You used to call the Meteora Team and our server so much, yet you can't even follow a guide to set a pre-built and tested server up.