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

 

[kevin87]

... i named the spells i cudnt see , having it unticked in f12 u cnt see any, i can see some except from the ones i listed... im new at this, but im not a retard thanks. lol

 

[mStation]

its a client problem.. u seem to have only magic.wil and not magic2.wil in your client files.. check and tell me if i'm right

 

[kevin87]

wrong... its in there, to be honest im sure they actually work aswell lmfao just no skin on it, so was wondering if u had a idea how to fix :P

 

[virus]

thank u that sorted my problem is there anything else i should know since im running on vista?

guess problem solved im not good with sql 2005 with vista because i aint really had a good shot at it but if things are running well thats a bonus i wont take credit for helping people as im that type of bloke

btw nice poetry on ya site ^_^

 

[mStation]

this will surely be a happy day for all of you.. i have setted a new guide and new files which i personalized so that u don't need to do nearly nothing.. if you can't get a server to work now with these new istructions (which are in the main post of this thread) then you must stop trying to make a server because u really aren't good enough..

i tried my own guide twice and i have made also some screenshots of the most hardest parts so that they can turn out to be easy..

every word of the guide must be read.. not only the steps.. it's important to read it all!

 

[virus]

this will surely be a happy day for all of you.. i have setted a new guide and new files which i personalized so that u don't need to do nearly nothing.. if you can't get a server to work now with these new istructions (which are in the main post of this thread) then you must stop trying to make a server because u really aren't good enough..

i tried my own guide twice and i have made also some screenshots of the most hardest parts so that they can turn out to be easy..

every word of the guide must be read.. not only the steps.. it's important to read it all!

Keep up the YouTube Links it will help beginners a good chance to start i like that idear

 

[Zen2]

Keep up the YouTube Links it will help beginners a good chance to start i like that idear

Good idea seems as mstation doesnt seem to be english it may be abit easyer to work it out from a video tuturial.

Nice thread though ^ ^


/Zen2

 

[mStation]

ill be putting them back in then.. will do it later though!

any how i feel that this new guide is much easier now since the server files are edited and have .bat files to autoconfigure them selfs..

 

[Omen_lom]

It looks like a nice guide very well laid out.

 

[virus]

yup should put it as a update sticky as its got abit of everyone adding parts to as it goes along also, thats ****ing teamwork

 

[noisound]

very well done m2station

 

[mStation]

i am working out a complete guide for windows vista users.. hope this will help someone

 

[virus]

i am working out a complete guide for windows vista users.. hope this will help someone

yes i think xp a bit easyer now to the public, we need to try work on vista.
lot complication with vista even people's changing OS because of the files not working so it would be ideal my friend

 

[Bless]

Can you re up mir server plzz RapidShare Mirserver Already Setted

 

[mStation]

i don't have the files anymore on my pc cause of my laptop dieing this week so i think i will have to redo them from the start.. i hope to get this fixed before tomorrow.. sorry

 

[mStation]

as requested the files are again available for download.. sorry it took my soo much time

 

[zuess]

Could anyone help me.. im trying to import the mongen table but im using sql 2005 enterprise manager and there is no way i can import or update a table (i have tried for hours to find a way and im just not used to this programme but i need to use it because im using vista)

any help would be appriciated

 

[Ful/Psy_Inc.]

Could anyone help me.. im trying to import the mongen table but im using sql 2005 enterprise manager and there is no way i can import or update a table (i have tried for hours to find a way and im just not used to this programme but i need to use it because im using vista)

any help would be appriciated

im stuck on the very same bit , anyone know how to sort this? thanks

 

[mStation]

replied some possible solutions on the vista idiot proof server guide.. look there..

btw please append sql 2005 questions on the other thread.. this should suppose you are using sql 2000..

thanks

 

[bungle]

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