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:

Peter12

Dedicated Member
Dedicated Member
Jun 1, 2007
92
0
52
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.

Guide followed, account creation problem. Not a lot i can do about it.

Oh and so much for a 'September' server, your forum and website is down now aswell. :mooned:

At the end of the day, i've never played around with these files before so am downloading to mess around with in my spare time. I'm not creating a server, i'm not even thinking about it. I just want to use to test server to **** around with some of the features. I hope this is ok with you Sir.
 
Upvote 0

Kazuki

Dedicated Member
Dedicated Member
Feb 4, 2006
202
2
65
Guide followed, account creation problem. Not a lot i can do about it.

Oh and so much for a 'September' server, your forum and website is down now aswell. :mooned:

At the end of the day, i've never played around with these files before so am downloading to mess around with in my spare time. I'm not creating a server, i'm not even thinking about it. I just want to use to test server to **** around with some of the features. I hope this is ok with you Sir.
Who said anything about a 'September' server?

My point is, you gave us so much grief and yet can't follow a guide to set up a set of files.


As for your error, just try searching?
 
Upvote 0

Peter12

Dedicated Member
Dedicated Member
Jun 1, 2007
92
0
52
guide has been changed to make it even more easy..

The problem i had has nothing to do with your guide but something completely unmentioned. It's ok though, was just pointless asking people who clearly didn't know. Managed to fix the problem myself.
 
Upvote 0

mStation

Golden Oldie
Golden Oldie
Oct 29, 2003
2,042
69
255
♫♪♫ ♦♥♠♣ ♀♂♀
The problem i had has nothing to do with your guide but something completely unmentioned. It's ok though, was just pointless asking people who clearly didn't know. Managed to fix the problem myself.

ovviously i'm not on forums 24h so i cant sort everything but i'm already working on a error section on this server guide so that if u get some errors u can fix them straight away..


any ideas about the error 10048?

its a windows socket error i suppose.. do CTRL-ALT-CANC and open taskmanager.. under the process tab look for any on the mir exes which are still running.. i suppose it will be a logingate.exe or a rungate.exe or a selgate.exe.. if u find it then stop the process by killing it..

if u can't fix it like this then reboot your system and use serverlauncher next time like shown in the first post of this thread!
 
Last edited:
Upvote 0

Xx69xX

Golden Oldie
Golden Oldie
Dec 2, 2005
2,150
154
170
getting this error???

only thing i can think that iv done differntly is install and reinstall SQL a few times and where it says default i cnt choose that so i just rite a name... but that is irrelivant

iv done everything else 100% correct any idea

?

Edit=
heres the screenie of the 1 bit i cant do?
it wont let me click default is this anything to do with it???

 
Last edited:
Upvote 0

Xx69xX

Golden Oldie
Golden Oldie
Dec 2, 2005
2,150
154
170
well iv now reinstalled it after removing all the sql programs iv had

now iv got this error

 
Upvote 0

Painkiller

LOMCN Veteran
Veteran
Loyal Member
Feb 11, 2006
316
2
65
lo peepz av got everything running checked the ips like 10 times over but for some reason i still can't seem 2 b able 2 make a char i click "new char"
input the name but it jst stays blank any1 help? ty

/brandon
 
Upvote 0

mStation

Golden Oldie
Golden Oldie
Oct 29, 2003
2,042
69
255
♫♪♫ ♦♥♠♣ ♀♂♀
lo peepz av got everything running checked the ips like 10 times over but for some reason i still can't seem 2 b able 2 make a char i click "new char"
input the name but it jst stays blank any1 help? ty

/brandon

are u using any antivirus or internet security programs? as far as i know if u did everything correctly this means that the problem is dued from some other applications u have installed..
 
Upvote 0

Xx69xX

Golden Oldie
Golden Oldie
Dec 2, 2005
2,150
154
170
are u using any antivirus or internet security programs? as far as i know if u did everything correctly this means that the problem is dued from some other applications u have installed..
ill try turning all programs off once im home from work.

if you could have a look at my other thread for me id appreciate that as its the only problem i have now >.<

ty m8
 
Upvote 0

2dope

Golden Oldie
Golden Oldie
Mar 15, 2005
514
13
125
ill try turning all programs off once im home from work.

if you could have a look at my other thread for me id appreciate that as its the only problem i have now >.<

ty m8
If you got that screen then I think you have installed the wrong version of SQL which could be why you are having problems.
 
Upvote 0

hornyfeker

Dedicated Member
Dedicated Member
Dec 10, 2006
15
0
47
Hi Im Very New To This Sort Of Stuff So Here Gose Ive Setup Sql 2000 On Vista Running Fine Dispite Other Ppls Probs But I Dont Have Ne Mobs Ive Renewed The Tbl Moghon To The New Tbl Moghon$data And Still No Mobs Ne Ideas Also Sql 2005 Dont Like Me Tryed That And Just Messed Everything Up >.< Ne Hlp Would Be Very Apreciated Ty
 
Upvote 0

Gemma

Dedicated Member
Dedicated Member
Feb 22, 2006
135
0
63
ill try turning all programs off once im home from work.

if you could have a look at my other thread for me id appreciate that as its the only problem i have now >.<

ty m8

try disableing unpnp sometimes that can cause the prob ( ink its for ppl to connect to the server but it also fixd my prob with svn files and td so give tht a shot
 
Upvote 0

Xx69xX

Golden Oldie
Golden Oldie
Dec 2, 2005
2,150
154
170
try disableing unpnp sometimes that can cause the prob ( ink its for ppl to connect to the server but it also fixd my prob with svn files and td so give tht a shot




Nope still no luck..

GateConnected
GateDisconnected
GateConnected
GateDisconnected
GateConnected
GateDisconnected
GateConnected
GateDisconnected

and in m2server=

DbServer Connected (127.0.0.1)..
DbServer Connected (127.0.0.1)..
DbServer Connected (127.0.0.1)..
DbServer Connected (127.0.0.1)..
DbServer Connected (127.0.0.1)..
DbServer Connected (127.0.0.1)..
DbServer Connected (127.0.0.1)..
 
Upvote 0

excluded

Golden Oldie
Golden Oldie
May 31, 2006
555
4
125
i havent read through all the thread but incase sumone didnt put.

If ur running windows vista -- u might need to install SQL 2000 + 2005 to get SQL connecting.

This is wot happened to me.
 
Upvote 0

Xx69xX

Golden Oldie
Golden Oldie
Dec 2, 2005
2,150
154
170
i havent read through all the thread but incase sumone didnt put.

If ur running windows vista -- u might need to install SQL 2000 + 2005 to get SQL connecting.

This is wot happened to me.


ty but im using xp >.<

i guess ill have to try on my other laptop one without internet connection lol
bet it works on there ffs lol
ill copy everything onto my pen tonight and pass across if it works
then its somink to do with my laptop which im sure it must be now lol

thnx for every1s help

ill let every 1 know the outcome.. will be at about 11pm as i got footie trainning tonight str8 from work
 
Upvote 0

Ali3n

Golden Oldie
Golden Oldie
Apr 27, 2004
705
5
125
Leicestershire
Hi, ive followed your guide word for word, however when i load LoM, i get

ID:____________
PASS:_________ OK

NEW CHANGE PASS

i can see this screen, however the area surounding it is pure black. and when i press enter after entering ID and password, it goes straight into the character selection screen, and the stone doors keep opening in a slightly smaller screen, it wont let me create a character, because the buttons are inactive.

Any thoughts?
 
Upvote 0

Xx69xX

Golden Oldie
Golden Oldie
Dec 2, 2005
2,150
154
170
ty but im using xp >.<

i guess ill have to try on my other laptop one without internet connection lol
bet it works on there ffs lol
ill copy everything onto my pen tonight and pass across if it works
then its somink to do with my laptop which im sure it must be now lol

thnx for every1s help

ill let every 1 know the outcome.. will be at about 11pm as i got footie trainning tonight str8 from work

it worked lol so can now continue on Zenith lol

(Files were on my pc before i moved lol now they r on both my laptops)
 
Upvote 0