2.3 Server Guide - Idiot Proof

mStation

Golden Oldie
Golden Oldie
Oct 29, 2003
2,042
69
255
♫♪♫ ♦♥♠♣ ♀♂♀
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
 
Last edited:

jane

LOMCN Veteran
Veteran
Loyal Member
Mar 28, 2003
304
0
113
Great Britain
just like to say it was a wicked guide but for some like me who is trying to make a server for the first time is there a guide for how to do things like change items/maps/exp and making quests ect ect. as once i have the server running i dont want it to be a euro clone but not sure what to do.

P.S many thanks for help also server is for offline use untill i know what im doing then i might give running a server a go
 
Last edited:
Upvote 0

MrMike

LOMCN Veteran
Veteran
Mar 9, 2004
473
1
64
Posts: 126,982
mStation nice guide mate im loooking for the edited mir server files on ur post. The link is down now just wondering if the files are stil about. If any 1 has them could you upload and send me a link please ?

Its ok i found it now thankz anyways......
 
Last edited:
Upvote 0

msferna1

Dedicated Member
Dedicated Member
Feb 17, 2009
54
0
33
well i can't creat char's. I put in teh name of the char etc, say ok and it isnt made (its not getting recorded...) does any 1 know how 2 fix this plz? i did everything like disable unpnp,antiviruse programe,etc plus i cant find this mir2sql2000backup thing thanks :)
 
Last edited:
Upvote 0

mafy

Dedicated Member
Dedicated Member
Nov 9, 2008
51
0
32
Romania,Timisoara
[13.12.2009 17:14:31] -- --> Error Keeping Query Alive!
[13.12.2009 17:14:31] -- --> Error Keeping QueryCommand Alive!
[13.12.2009 17:14:31] -- --> Error Keeping charQuery Alive!
[13.12.2009 17:14:31] -- --> Error Keeping charQueryCommand Alive!
 
Upvote 0

mafy

Dedicated Member
Dedicated Member
Nov 9, 2008
51
0
32
Romania,Timisoara
wot i do were :(
Loaded client version information and server table...
Loading StdItem.DB...
[13.12.2009 17:18:26] StartTimer exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'
[13.12.2009 17:19:26] -- --> Error Keeping Query Alive!
[13.12.2009 17:19:26] -- --> Error Keeping QueryCommand Alive!
[13.12.2009 17:19:26] -- --> Error Keeping charQuery Alive!
[13.12.2009 17:19:26] -- --> Error Keeping charQueryCommand Alive!
 
Upvote 0

mafy

Dedicated Member
Dedicated Member
Nov 9, 2008
51
0
32
Romania,Timisoara
hwot i do here pls tel me

Loaded client version information and server table...
Loading StdItem.DB...
[13.12.2009 17:18:26] StartTimer exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'
[13.12.2009 17:19:26] -- --> Error Keeping Query Alive!
[13.12.2009 17:19:26] -- --> Error Keeping QueryCommand Alive!
[13.12.2009 17:19:26] -- --> Error Keeping charQuery Alive!
[13.12.2009 17:19:26] -- --> Error Keeping charQueryCommand Alive!
:(
 
Upvote 0

Omen_lom

Golden Oldie
Golden Oldie
May 29, 2006
1,761
14
144
errm I havnt touched the files like that in ages but I presume you have an error with your SQL password or username. Are your desired detail in all the appropriate text fields in the files???. Because it wont work if it cannot login.
 
Upvote 0

Weikster

LOMCN Veteran
Veteran
Jan 21, 2009
421
11
44
36th chamber
hwot i do here pls tel me

Loaded client version information and server table...
Loading StdItem.DB...
[13.12.2009 17:18:26] StartTimer exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'
[13.12.2009 17:19:26] -- --> Error Keeping Query Alive!
[13.12.2009 17:19:26] -- --> Error Keeping QueryCommand Alive!
[13.12.2009 17:19:26] -- --> Error Keeping charQuery Alive!
[13.12.2009 17:19:26] -- --> Error Keeping charQueryCommand Alive!
:(

Make sure in !Setup.txt in m2server and dbsrc.txt in dbserver folders' have your sql password from when you installed sql.

SQLDatabase=YOUR DB NAME
SQLUsername=sa
SQLPassword=YOUR SQL PASSWORD
 
Upvote 0

Flame

Terminus
Veteran
Loyal Member
Oct 17, 2003
412
1
115
EDIT: Fixed it sorry for post lol >.< BTW what is TBL_MONGEN supposed 2 look like? because it looks the same as it did b4 i did it lol!
 
Last edited:
Upvote 0

Blaine

Dedicated Member
Dedicated Member
Mar 1, 2010
21
0
27
i keep getting "The network path was not found" when going throught the SQL Server Service Manager.

i have NOSFERATUM in Server
But Nothing in SERVICES... Its meant to say SQL Server but nothing?


Any ideas please
 
Last edited:
Upvote 0

Blaine

Dedicated Member
Dedicated Member
Mar 1, 2010
21
0
27
LOL thats mate, i got it sorted now but having a error with the legend of mir folder, the exe to play the server
 
Upvote 0

Blaine

Dedicated Member
Dedicated Member
Mar 1, 2010
21
0
27
i installed the legend of mir file on this thread installed it and server side is online but the exe in legend of mir folder isnt working, it keeps saying browze files ? any ideas ?
 
Upvote 0

Blaine

Dedicated Member
Dedicated Member
Mar 1, 2010
21
0
27
is it because you have a antivirus running? or is it because you don't have a sound card driver installed?

i have everything turned off, the funny thing is,i was offline then i had to do a reboot and now exe isnt working
 
Upvote 0

Blaine

Dedicated Member
Dedicated Member
Mar 1, 2010
21
0
27
i done that, and u know when u log in, i get the 1.4 login gate :S but earlyer it was the 2.3 login gate,
 
Upvote 0