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]

this answer can help u

http://www.lomcn.co.uk/forum/showpost.php?p=630123&postcount=2

 

[alibaydoun]

ok i followed the guide step to step re- checked everything and when i go to click mir2 i get connection closed. happened to few other ppl ... whats the fix

 

[mStation]

have u setted correctly the client?

Go to the server folder C:/mirserver/m2server and copy and paste the mir2.exe in your game folder.

Then copy and paste in the game folder your mir.ini and rename the new file to mir2.ini.. open it and paste this inside it:
[setup]
patched=0
Param1=127.0.0.1
Param2=
Param3=
Param4=
Param5=
[Option]
SkillSetting=0
Sound=1
ShowAllItem=0
EffectSetting=1
ShowSkillBar=0

Now create a new text file called Servers.ini and open it and paste this inside:
[Server1]
ServerName=Diamond
ServerAddr=127.0.0.1
ServerPort=7000
SelectServerAddr=127.0.0.1
SelectServerPort=7100
GameServerAddr=127.0.0.1
GameServerPort=7200

 

[alibaydoun]

i've done all of that but im still getting connection closed... i've went over it again and again...can u screenie exactly what u mean if u have time,

help appriciated

thanks in advance

 

[oO~Unknown~Oo]

i've done all of that but im still getting connection closed... i've went over it again and again...can u screenie exactly what u mean if u have time,

help appriciated

thanks in advance

the only probs i can think of are the ip and server name

you MUST have them all correct (ktest and 127.0.0.1 )

 

[mStation]

i've done all of that but im still getting connection closed... i've went over it again and again...can u screenie exactly what u mean if u have time,

help appriciated

thanks in advance

are u using vista with sql 2000?

 

[TheMightyOne]

i get this message..

Loaded client version information and server table...
Loading StdItem.DB...
[17/11/2008 23:09:51] StartTimer exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'


followed the guide quite thoroughly, didn't think i would get a problem


help would be great please.

thanks.

 

[Gough]

i beleave you have not got your password correct in one of the config files in your server files.
check dbcec file in your DBServer folder of your server and check you have the correct password for your sql in there. you cant miss it it has..

SQLUsername=sa
SQLPassword=(YOUR SQL PASSWORD)

 

[TheMightyOne]

thanks that now works, now i get connection closed lol.

although i'm noticing that when i launch the server the LoginGate, Selgate say "ktest" whereas the others say Diamond. does that make any difference?

 

[Gough]

lol well the server name is wrong in config of selgate. this is good im helping someone when i have a server thats stopped working lol. hope that works for you

 

[EvilAtHeart]

how do i put it online please can someone help mepunk:

 

[TravisW]

thanks that now works, now i get connection closed lol.

although i'm noticing that when i launch the server the LoginGate, Selgate say "ktest" whereas the others say Diamond. does that make any difference?

logingate,selgate will always say ktest, doesn't matter.
Login server isn't connected=connection closed, or you have wrong ip in client's servers.ini

 

[mStation]

i just realised that some people really really really mess things up because they don't read.. i don't know if this might be one of your cases but in this guide i wrote:

C:\mirserver\DBServer\dbsrc.ini

SQLType = mssql
SQLHost = 127.0.0.1
SQLPort = 3306
SQLDatabase = mir2
SQLUsername = sa
SQLPassword = sa (or enter the password you entered while setting up SQL Server 2000).

C:\mirserver\M2Server\!Setup.txt

UseSQL = True
SQLHost = 127.0.0.1
SQLUsername = sa
SQLPassword = sa (or enter the password you entered while setting up SQL Server 2000)
SQLDatabase = mir2
SQLType = mssql
SQLCharDatabase=mir2

ovviously where i wrote:
SQLPassword = sa (or enter the password you entered while setting up SQL Server 2000)

means that u don't have to but the (or enter...2000) part into the server settings ini's... i thought this was ovvious but i just fixed someones problem because he just copied and pasted everything and didn't use his "brain" at all!!

where i say setting up the SQL Server i mean that if we give mir2 as the db name we can also choose to give something else

where we give sa as username and pippo as password this means that the ini's must be changed! and making sure u put sa as user and pippo as password.. this is important.. and this is very basic.. people awake from your lethargy

 

[alibaydoun]

where we give sa as username and pippo as password this means that the ini's must be changed! and making sure u put sa as user and pippo as password.. this is important.. and this is very basic.. people awake from your lethargy

i didnt get this part, are u saying to use "pippo" as our sql password

 

[mStation]

no im just saying that if u installed sql and decided to change the password i suggested "sa" to something else then in the ini's u dont have to put "sa" as i described but the new password u have choosen!!!

 

[Mackem]

i know this is going to sound really dumb.but ohwell. I really find all this stuff confusing and i have no idea on how to use/run anything that is said in this thread. i am using windows vista and it all seems really different....i have got the sql200 and going to download sql2005 woul anyone be wiling to write a 100% IDIOT PROOF GUIDE on anything and everything for this please?(from the downloading to making every little detail with all 2.3 GM commands etc) SORRY FOR SOUNDING LIKE A RETARD BUT ITS TRU......
signd RiboFlavin P.S server will probably not be going live

 

[alibaydoun]

i've tried and tried on all 3 of my pc's read this guide inside out... cant seem to get it..well i get it but it just wont work so i dont know..i think im going to quit on this stuff for a while..too frustrating been working on it for weeks now and i still get con closed, and yes i checked all files etc..all have 127.0.0.1..so i retire, unless some1 will be kind enuff to set all the files and send me them over msn...that would be appriciated tbh if u got the time

 

[virus]

i get this message..

Loaded client version information and server table...
Loading StdItem.DB...
[17/11/2008 23:09:51] StartTimer exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'


followed the guide quite thoroughly, didn't think i would get a problem


help would be great please.

thanks.

u need to set the password you personally put, When You installed Sql in setup!.ini in m2server, like this

[SQL]
UseSQL=TRUE
SQLHost=Your IP! 192.168.*.*
SQLUsername=sa
SQLPassword=**** <<<<<<This Is Sql PassWord U Entered
SQLDatabase=mir2
SQLType=mssql
SQLPort=3306
SQLCharDatabase=mir2

[Setup]
SQLPort=3306
ItemNumber=41277904
ItemNumberEx=1073743998
ClientFile1=mir2.exe
ClientFile2=mir.exe
ClientFile3=Hell23.exe.exe
MonUpLvNeedKillBase=100
MonUpLvRate=16
MonUpLvNeedKillCount0=10
MonUpLvNeedKillCount1=20
MonUpLvNeedKillCount2=50
MonUpLvNeedKillCount3=80
MonUpLvNeedKillCount4=120

DO NOT FORGET YOUR IP'S BELOW THIS LIST AT MIDDLEISH BOTTOM

===================================================================================

Ports Fowarding Settings Useing Netgear also applies to other router/modem types





Then Check Your Firewall Rules! Very Important If Its On Wirless Especially



Hope This Helps

 

[alibaydoun]

i dont get it, i put my password as "123" for the sql, but still m2 is telling me it cannot sign on to "sa"

 

[alibaydoun]

ok guys, this is the last time i bother u just help me wiv this.


Loaded client version information and server table...
Loading StdItem.DB...
StdItem.DB loaded(758).
Loading MapFiles...
Mapfile loaded(429).
DecoItem loaded..
Loading Guild Territorys...
Loading Monster.DB...
Monster.DB loaded(502).
Loading Magic.DB...
Magic.DB loaded(55).
Loading MonGen.txt...
MonGen.txt loaded(255).
Loading GenMsg.txt...
GenMsg.txt loaded(6).
Loading UnbindList.txt...
UnbindList information loaded.
Loading BindList.txt...
BindList information loaded.
Loading MapQuest.txt...
MapQuest information loaded.
Loading QuestDiary\*.txt...
QuestDiary information loaded.
!Abuse.txt loaded..
Loading LineNotice...
Line Notice loaded...
Admin List loaded..
Guild List loaded..
PumpkinLists loaded..
Castle List loaded..
Castle initialized..
IDSoc Initialized..
GrobalEnvir loaded..
MakeStoneMines...
Merchant loaded...
GuardList loaded..
Npc loaded..
MakeItem loaded..
StartPoints loaded...
F-Engine resumed..
U-Engine initialized..
[7/7/2005 5:23:51 AM] Guilds: 0
[7/7/2005 5:23:51 AM] Total Castles: 1
[7/7/2005 5:24:16 AM] LoginServer Connected(127.0.0.1:5600)
[7/7/2005 5:24:19 AM] Gate[0](127.0.0.1:2334) Opened...
[7/7/2005 5:24:19 AM] DBServer Connected(127.0.0.1:6000)

that is what m2 is readin, but when i click the mir2.exe it gives connection closed, if all gates are connected that means all my ips are set, so whats the prob? why am i gettin con closed.