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

 

[Blaine]

All i do it change the IP's on files in folders to go online because me and my bro wanna play together on it, can i have little info on putting it online please

 

[Blaine]

i sorted it =), the only thing is now is gettin it online

i dont understand how to sort out mobs

 

[lina]

 

[Blaine]

i changed all ip address to my ip address to get it online so my brother an play and m2 server isnt working now, any ideas?

 

[Anonlol]

Read the sticky router setup for what IPs to change and which to not change

What does m2server say?

 

[Blaine]

where can i find it please,

 

[Blaine]

it always says no reasponing

 

[Monkeh]

is sqleval 2000 compatibale with windows 7 or is there a different one to use?

 

[Chris22]

SQL 2005 for win 7

 

[neamtu]

Re: 2.3 Server Guide - Idiot Proof with videos

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 don`t understand here ^^ how i make this step to spawn mobs everywhere .. sorry but i am from other country . If some one could explaion more .. like to an idiot but the rest its ok .. its running just don`t spawn >.<

 

[Sami]

same problem here neamtu...

 

[Sami]

i got server running oonly 2 problems :1 i cant get tbl_mongen imported and 2 some items like fox items ..well...i cant see them..they like a small dot..any help 4 me mStation ?

 

[riddic123]

got a problem cant create a char lol ?

 

[icerock]

Hello! Please help with configuring the server. He did all the instructions but nothing happens. In M2server shows an error - [15.10.2011 10:50:35] StartTimer exception: [Microsoft] [ODBC SQL Server Driver] [DBNETLIB] SQL-Server does not exist or access denied
[15.10.2011 10:51:36] - -> Error Keeping Query Alive!
[15.10.2011 10:52:08] - -> Error Keeping QueryCommand Alive!
[15.10.2011 10:52:40] - -> Error Keeping charQuery Alive!
[15.10.2011 10:53:13] - -> Error Keeping charQueryCommand Alive!
I apologize for my English, wrote a translator
If anyone has the Russian instructions for installing and configuring the server, I'll be very grateful.
We just shut down the server in Uzbekistan www.mir2.uz, and play like.
Thank you for your attention

 

[VIP]

i want do a server but i have problem need download SQL and mir server files and all links error so any1 can help me pls ?

---------- Post Merged at 01:21 AM ---------- Previous Post was at 01:21 AM ----------

i want do a server but i have problem need download SQL and mir server files and all links error so any1 can help me pls ?

---------- Post Merged at 01:22 AM ---------- Previous Post was at 01:21 AM ----------

i want do a server but i have problem need download SQL and mir server files and all links error so any1 can help me pls ?

 

[spartekas]

Ya sorry about that... Did change end of the address to .org lol and found this so was excited..

I found a post with mirserver2.3.exe but with no files, just self installing trojans like Conduit, search protect.

These can be uninstalled for a bit. But they will majorly piss ya off and slow pc down. And they will reinstall themselves..

And dont turn AV off. Mediafire detected it

Solution---http://www.mediafire.com/download/squjcp89edw01ul/HousecallLauncher.exe
Runs on XP

If someone needs or cant find the file give me a shout I may have it

 

[Tai]

Your running 2 of the same gate/ Rungate and rungate. It happens

That post is seven years old. I think Kazuki is probably over it now?