B3 Server Guide

[anto135]

cud a mod stick this plz
http://www.lomcn.co.uk/forum/attachment.php?attachmentid=2061

this guide was made by anto121 (sometimes anto135)

this guide is rushed and for people who dont have a clue what to do wiv these files.
Also there might be spelling mistakes.

links
------
SQL--=http://download.microsoft.com/download/e/6/e/e6ea2122-5c4d-4a0d-baa8-8138548f9973/SQLEVAL.exe

files--=http://www.h4x3r.us/mordeth/sqlmir.rar

B2filesupdate--=http://www.h4x3r.us/mordeth/B2SQLMIR.rar

account pages for sqlmir--=http://www.h4x3r.us/mordeth/sqlmirweb.rar

mapinfo for sqlmir--=http://www.h4x3r.us/mordeth/mapinfo.rar

Installing SQL
--------------

Ok download sql, once downloaded click on sql it unzip it then and go to where you have unziped it to.
Click autorun.exe. When its loaded click SQL Server 2000 Components then click Install Database Server.
On this first installation part make sure 'local computer' is clicked.
Click next make sure 'create a new instance of SQL Server or install client tools' is ticked.
Click next.
Click next again.
Click yes and in this part make sure Use the 'same account for each service Auto start sql service' is ticked
also make sure use local system account is clicked.
Click next on this part make sure 'mixed mode (Windows authentication and SQL server authentication)' is ticked.
Click next make a password of 123456.
The next boxes in the instalation are left alone

Seting Up The Database
----------------------
download this http://www.lomcn.co.uk/forum/attachment.php?attachmentid=2017
u will need it later on.

When installed browse the Start Menu and find the program group 'Microsoft SQL Server'.
From within there click on 'Enterprise Manager'
when in click the + sign near 'microsoft SQL Servers' click + again click + again
click on databases.
When you see some items come up right click
click new database call it Mir2_Common click ok.
Go into tables leave that for the moment.
Remember the thing you downloaded before, unzip it.
Go back on ur tables right click click all tasks then click import data.
Click next make sure from the drop down table make sure 'Microsoft Access' is selected.
On the file name at the right there is a button click it and
wherever you unziped that file to, go on that file.
click next the next part doesnt need anything doing to it.
click next make sure 'copy table(s) and view(s) from the source database'is clicked.
Click next click select all.
Click next make sure 'run immediately' is clicked click next then your done.

Seting up ODBC
--------------
Go in control panel if ur on windows xp click switch to classic view at the left hand side.
Go in Administrative Tools and go on Data Sources (ODBC) on the right hand side click add
scroll down to SQL Server and click it call it Mir2_Common description not needed
serverlocal).
Click next make sure 'With SQL Server authentication using a login ID and password entered by the user'
and 'Connect to SQL Server to obtain default settings for the additional configuration options'
are both clicked.
login ID:sa password:123456
Click next make sure Change the default database to: is clicked and underneath it is Mir2_Common is there.
Click next in this window just leave it and click next then your done.

Setting Up The Server Files SQL server
--------------------------
Well this is part is pretty basic go in gamesvr go in GameSvr.ini
make sure it says.
[Config]
DSN = Mir2_Common
ID = sa
PASS = 123456

Go in loginsvr go in loginsvr.ini make sure it says.
[Config]
DSN = Mir2_Common
ID = sa
PASS = 12345

Go in DBsvr go in DBsvr.ini make sure it says.
[Config]
DSN = Mir2_Common
ID = sa
PASS = 12345

[SERVER]
SERVERIP = 127.0.0.1
PORT = 5600
LocalPort = 5100

LoginGate

IP:Ur ip
Port:5500
LocalPort:7000

Select Character Gate

IP:127.0.0.1
Port:5100
LocalPort:7100

These can be edited by click file and then config

The other ports for the other files are already set up

Making an Account
-----------------
Go in enterprise manage, go in databases, go in tables,
and look for TBL_ACCOUNT, right click, click on open table, click on return all rows
fill it in.
FLD_LOGINID is your id.
FLD_PASSWORD is your password.
FLD_USERNAME is your name.
FLD_CERTIFICATION is 0.
FLD_CERTIFICATION2 is -1
thats that part done. Ok click off that.
Look for TBL_ACCOUNTADD, right click, click on open table, click on return all rows and
FLD_LOGIN is ur id same one as before.
FLD_SSNO no idea i just put my password in there.
FLD_BIRTHDAY is ur birthdate year/month/day.
FLD_PHONE your phone number.
FLD_MOBILEPHONE is your mobile number.
FLD_ADDRESS1 is your address.
FLD_ADDRESS2 is your second address.
FLD_EMAIL is your email.
FLD_QUIZ1 is your question.
FLD_ANSWER1 is your answer to that question.
FLD_QUIZ2 is your second question.
FLD_ANSWER2 is your second answer to the second question.

Well thats about it hope this helps.

Made by anto121 (sometimes anto135)