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

 

[mStation]

Thank you so much, i've tried everything to get an offline server running and this worked flawlessly. A thousand hearty thanks!

glad it helped you!

 

[craigj]

Just looking and skim reading through looks like a very good guide. Thanked.

P.S. Can you add my msn please mate - [email protected]

 

[God33344]

ne1 no wut ports i shud forward so i stop getting this error on my DBserv??

(Windows socket error , the 10048 one)

and also it keeps saying check user count on its screen :s

 

[Dazz]

Forward 7000,7100,72000,7300

Check IP's.

 

[God33344]

ive forwarded them m8, and still getting the error =/

 

[Dazz]

your IP's correct?

 

[God33344]

yeah theyre all correct, its just giving tht error when ever it runs , although it works perfectly when i use my internal ip or 127.0.0.1, only when i use external i get the error... ;/

 

[Dazz]

not every ip is ure external, use ure routers ip on most of em

theres only bout 3 global ips tat you need

 

[God33344]

k ill try tht ta

 

[God33344]

lmao pissin me off, i had the same error with logdataserv before i forwarded my 7000 - 7300 ports but that got fixed, and now this 1 just keeps erroring with my external -.-

 

[Pimpz0r]

the link you have for sql doesnt work do u have a new one?

 

[Weikster]

the link you have for sql doesnt work do u have a new one?

http://www.lomcn.co.uk/forum/showthread.php?t=60927

 

[LostLord]

it wont let me restore my database any help please

Microsoft sql-dmo (odbc sqlstate: 42000) this is what the error is called

 

[Xx69xX]

hi people

just managed after some silly mistakes to get my offline server going..

unfortunatly the laptop i done it on is a ***** for playing mir.. i have 2 other laptops in the house (both wireless) but can be hooked up to router...

is there any way i can play mt offline server from another laptop ?
while hosted on this 1.. obviously ill b in the same house as host1 on same ip

im sure i did this b4 but i think maybe it was because both my pcs where hooked up via wire?

any help?

cheers

 

[ednet]

On the forum i find links to

Client 1.4
Client 1.9

Server 1.4
Server 1.9

But in the IDiot Guide to MIR2 server, There is a Client 2.3 link ?

Can the client 2.3 connect to a 1.4 server ?

I noticed Fernys 1.4 untouched server files does not give virus alerts , which makes me happy

 

[ednet]

And yes I can run my server offline
1.4 client / 1.4 server

but no monsters, struggling with SQL server at the moment to update the monster tables...

 

[ALETIER]

STEP 4
dont work ne help with this?

 

[ednet]

STEP 4
dont work ne help with this?

Please describe the problem, and where you get stuck...(alot of details)..."it doesn't work" is a bit vague

 

[ednet]

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


I'm stuck at step 5

Using the 1.4 server files,
I can connect the DB using DBcommander, but with DBcommander I cannot import the mob file (because there are no mobs running).
So I've Installed SQL 2000 Personal Edition (No errors), SQL server runs...

But im stuck at connecting the DB to the SQL, because the 1.4 files do not have a file called "mir2sql2000backup"...Any ideas how to get around this ?







Edit: Ok i stole them from MirRevenge, they are included in the serverZip "mir2sql2000backup"

 

[ALETIER]

cant download the files! so i have no clue where 2 start

Download the edited mirserver files from here: My Personal FTP

RapidShare Link (max 10 downloads)

if anyone feels to host i will be happy..

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

files not found on rapid share or on his personal ftp

any 1 have these files i can nick please?