2.3 Server Guide - Idiot Proof 4 VISTA

[mStation]

This Guide Is For Windows Vista Users

Please read the ATTENTION! note i wrote for the xp server guide

STEP 1
----------------------------------------------------------------------​

Download the Legend Of Mir 2.3 Client from this website: GamersHell

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 2
----------------------------------------------------------------------​

Download the SQL Server 2005 and its essential parts from here:

[this part presumes that you dont have sql 2005 installed.. if you do then uninstall it and follow this guide completly]

OPEN THIS LINK:
MSSQL 2005 Express Edition

Press "Download files below" and choose the 53.5 MB file..
Download it and open it..

If the program says

then choose Run Program

Now Follow My Clicks for having a correct installation:
- tick the accept licence terms and hit next
- next
- Run program
- Next
- You should have all Success.. with 0 errors and 0 warning.. else if you have some errors then stop and ask here.. if everything is okay then hit next
- Next
- Next
- Select Mixed Mode and input "sa" in enter password and "sa" in confirm psw
- Next
- Install
- Wait
- Wait more
- When completed press next and finish

OPEN THIS LINK:
Microsoft SQL Server 2005 Service Pack 2

Press "Download files below" and choose the 282.4 MB file (if you have not the vista 64bit version).. else if you have the 64bit download the 300+mb file
Download it and open it..

I installed this only because it's said to be a required bit for running sql correctly..

Follow my clicks also here:
- Next
- Select "I accept" and press next
- Next
- Next
- In this window if everything is correct you should get a message saying "Locked files not found" so press next
- Install
- Then next next and finish

OPEN THIS LINK:
SQL Server Management Studio Express

Press "Download files below" and choose the 38.5 MB file (if you have not the vista 64bit version).. else if you have the 64bit download the 39mb file
Download it and open it..

Just install the Studio Management without changing nothing.. keep everything to default..

STEP 3
----------------------------------------------------------------------​

Download the edited mirserver files from here: MegaUpload

if anyone feels to host i will be happy..

This server files are already setted and have a few fixes in them.. the fixes are the mapquest error and the server ips all setted to 127.0.0.1.. and some smaller things

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.. if the shortcut doesnt appear on the desktop try clicking in an empty place of the desktop and then hit F5 on the keyboard and see if the shortcut pops up..
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 4
----------------------------------------------------------------------​

This is the last part of the Guide.. maybe also the most important part tbh..

open START > ALL PROGRAMS > Microsoft SQL Server 2005 > SQL Server Management Studio Express..

when the window pops up you should have something like this:


it's very important to write down the server name because we will need to set this in our files.. in my case my server name is "Lux666-PC\SQLEXPRESS"

Select SQL Server Authentication and for login put "sa" and password "sa" and hit Connect

If you have entered the things i said you should now see some folders called:
Databases
Security
Server Objects etc etc

Right click on the folder called Databases and select "New Database"

In the window that pops up right the following this:
Where it says "Database Name" write "mir2"
Then press OK

Now double click on Databases
Right click on mir2 and choose Tasks > Restore > Database...

In the window that pops up select From Device and press the button with 3 dots which is at the right of From Device [...]

Then press Add
Then change the Files of Type to All files(*) and browse in C:\Mirserver\DBserver\ and select the database called "mir2(restorethis)"
Then press OK
Then press OK again and we are back at the window where we choose From device before..

Now here make sure you put the tick like in the image:


Uploaded with ImageShack.us

Now on the left top part press Options and choose "Overwrite the existing database"

Now press OK and everything should be restored correctly!

STEP 5
----------------------------------------------------------------------​

Now you still have to set a few things.. open the mirserver folder which is in C:\.. open the DBserver and open the dbsrc.txt

make sure that you change the red line to what i am going to tell you:
[SQL]
SQLType=mssql
SQLHost=127.0.0.1
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=sa

must become
SQLHost="ServerName" like i said before.. in my case, has i said.. this line will be
SQLHost=Lux666-PC\SQLEXPRESS

the same thing must be done in the !setup.txt which is in the M2server folder
which should look like this but with your personal servername.. (NOT MINE!)

[SQL]
UseSQL=TRUE
SQLHost=Lux666-PC\SQLEXPRESS
SQLUsername=sa
SQLPassword=sa
SQLDatabase=mir2
SQLType=mssql
SQLPort=3306
SQLCharDatabase=mir2

Now we can 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..

FAQ
1) Fixing the mongen!
Exporting the file we need:
Method 1) First way is Exporting the Tbl_Mongen using SQL 2000 following this steps:

Right click on the table TBL_Mongen and click on export and export
as text file.
Click OK on the next screen
Click the Delimited option at the top and then click next
On the choose the delimiter that separates fields option at the top, click on the 'Tab' button and in the Text Qualifier dropdown box on the right, click on {none}
Click on Next
Click on Finish

Else Method 2) Second way is using the TBL_Mongen.xls that mirrealms shared ages ago..
do to this download the file from here then open it with Excel.. press File > Save File As.. then choose in the File Type drop menu the voice saying Text (MS-Dos) *.txt and press Save.. in the window that pops up choose yes..

Importing the File to Sql 2005:
To be able to import you need to do 3 things explained in the following link.. (this step must be done once and will work forever..)
the 3 things

Now press start > run > cmd and make your command changing the red parts

in my case i used:
bcp mir2.dbo.tbl_mongen in C:\tbl_mongen_exported.txt -T -c -S Lux666-PC\SQLEXPRESS

the first one is the txt file you have exported
the second is the server name

 

[Dazz]

Try Elvin and Jaspers TD's all in one files mate, they work with me.

/Daz

 

[Bromen]

Cheers for help anyways, was just me, wasnt entering the right wil numbers.

 

[Dazz]

bah, we all have our blonde moments!

 

[pwnage]

i got this error.. COM Plus Catalog Requirement

i check the warning and it says this

- COM Plus Catalog Requirement (Warning)
Messages
COM Plus Catalog Requirement

If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.

any ideas? can i keep going or ?

 

[mazz]

I dont know vista sux tbh i just installed sql 2000 it works great until you try to actually use it
lol
then my DBserver cant keep a connection lol

the ****ty part is there is a (x86) install for sql 2000 which allows it to run 32 bit and 64 bit apps
im running vista 64 so this is the right version lol
and i know its not an ip because ive just backed everything up from the xp system ive bin running and it ran fine

 

[mazz]

Ok so i finally go this working for vista 64 bit home premium but when i use the manager to add a new data base i get an error
Do i need dbcommander for sql 2005

btw there is alot more to the 64 bit version for sql 2005 express but it does work now I may make a tut off of this 1 if its ok

 

[Orionstorm]

i have a little problem installin SQL 2005, at the mixed mode thingy it requires a sa password, so i put in sa, yet it says it requires a stronger pw...
any solutions for this, or could some1 gimme a link for sql 2000, since the link to ms is dead

 

[mStation]

simply put a stronger password, write it down somewhere so you can then put it into the setup.txt and the dbscr.ini..

 

[Nick13786]

Help Please

In step 3 i have downloaded the files to c:/mirserver and done the first part where i click on 1 set up maps.bat which all seemed to go okay but when i do part 2 set up my client files.bat i just says access is denied - 0 files copied, why is this??

Thanks

 

[mStation]

probably it's something to do with open folders or not full access to everything.. anyway you can simply open the .bat file to see what files are copied and in which position and just do it yourself manually

 

[Tom27]

Can i just add, you need to enable something in Sync center if youre on a router with vista or the dbserver wont start

 

[GilgaMesh]

Any idea's what to put?

 

[neptuneshaun]

dont you have to end a programe running aswell, its calle somethin like "nvideo.exe" (this might not be the exact name but iv heard of this)

 

[Silencer]

Nice guide, all worked except the shortcuts for the serverstarter and the gamestarter. But managed to get everything working and ingame anyway!

Now I just need to work out how I make myself a GM and how I upload new NPC's/Items/Maps to the server so I can test them

 

[akacary2]

Nice guide, all worked except the shortcuts for the serverstarter and the gamestarter. But managed to get everything working and ingame anyway!

Now I just need to work out how I make myself a GM and how I upload new NPC's/Items/Maps to the server so I can test them

In DB goto TBL_ADMIN and put ur char name in and set permission 2 10

D/L urself HH8 wil viewer and import new items in here, make sure they are all same image number in DnItems.wil, Items.wil and Stateitems.wil. They are diff images so make sure u get correct 1's.

Stateitem = Item on char, DnItems + Items = Floor and Bag but cnt remember which is which cos its l8 n im tired lol

NPC looks are updated in DB and new images are imported into NPC.wil / NPC2.wil

Maps are also updated in TBL_MAPINFO

Hope This Helped, If Not Then I'll Edit After Getting Sum Sleep lol

 

[fafafa]

The link for the download of mStation's mirserver.exe isn't working... can anyone rehost it please?

 

[Gezza]

http://www.file-upload.eu/download-1604625/Mirserver2.3.exe.html

 

[fafafa]

edit, fixed this

 

[GoldieDragon]

hi i cant fine mir2(restorethis) in C:/M2Server/DBServer have i done something wrong?

 

[FarmBoy]

http://www.file-upload.eu/download-1604625/Mirserver2.3.exe.html

I'm getting spammed by my anti virus because of this download, over 4 files are flashing up as Trojan and other things.


Anyone got a clean version?