Stuffs to get before setting up your server.
1. SQL 2000 here:http://download.microsoft.com/download/e/6/e/e6ea2122-5c4d-4a0d-baa8-8138548f9973/SQLEVAL.exe
2. Server Files :http://forum.ragezone.com/showthread.php?t=121633&highlight=o2jam+server+files
3. Client files--- Part I of the client here:http://www.savefile.com/files/114507
Part II of the client here:http://www.savefile.com/files/114605
Part III of the client here:http://www.savefile.com/files/127601
Complie everything into 1 folder.
4. Get Chinese Language installed
Place the server files and client in C drive or any drive you would preferred.
Set your language to Chinese(PRC) as well.
* Check Local IP
* Go to Run > type CMD > type ipconfig
** Start of Guide **
First ,open Enterprice Manager in Start-->All Programs--> Microsoft SQL Server, and click Enterprise Manager.
Next , you need to create databases .
To create database
First ,select Databases, right click and Create new Database, name it test2, create two more and name it o2jamtrade and onlinereport.
Next , restoring the database .
To restore the database
Right click in test2, All Tasks, Restore Database. Restore as Select From Device, select Devices, Add, ... , then select o2-database in C:\o2jam-ragezone\o2-database\test2 and click OK 3 times.
Then click the Options tab , tick Force restore over existing database , click OK.
Do the steps as above to o2jamtrade and onlinereport database
Next , u need to amend some files in the Tables , double click test2(right side of the list) ,click Tables
Look for a file call -> T_o2jam_gatewayaddr , right click it -> open table ->return all rows .
Change all the ip to your LAN ip and all the ports to 15010. Save and close it
Look for another file call -> T_o2jam_planetInfo , right click it-> Design Table .
You will see a data type call char , click it and drag down the list and click varchar.
Save and close it.
Now , right click T_o2jam_planetInfo (yes the previous one) -> open table ->return all rows .
Change all the ip to your LAN ip and all the ports to 15030 and Close it.
Adding ODBC links
Go control panel -> Administrative Tools-> Data Sources (ODBC)
Next , click System DSN , click Add , Select SQL server, click finish.
You will come to a new page :
Name it test2 and type (local) in the server .
Tick With SQL server auth ,tick connecto to SQL , type in your login ID +password
Click next , tick Change the default database , select test2 , click next ,finish , OK.
DO the same steps again for 2 times , except that u named it o2jamtrade and onlinereport.
After finish adding , close ODBC.
Next, go to C:\o2jam-ragezone\SERVER-COMERCIAL\SERVER\DATA
Double click Channel list.
You will see this
[SQL]
DNS = test2
UID = sa(change to ur id)
PWD = 123(change to ur pw)
Save and close it
Next , go to C:\o2jam-ragezone\SERVER-COMERCIAL\SERVER
Double click config.
You will see this
[CONFIG]
PORT = 15030( make sure is 15030)
CHANNEL = [0/0]
CAPACITY = 150
PLAYMODE = 0
[DBmanager]
IP = 192.168.1.64(ur lan ip)
PORT = 15037
[SQLCONFIG]
DRIVER = {SQL Server**
SERVER = 192.168.1.64(ur lan ip)
[SQL1]
DSN = test2
UID = sa(make sure id and pw are correct)
PWD = 123
[SQL2]
DSN = test2
UID = sa
PWD = 123
[SCORE]
GEM = 1.0
EXP = 1.0
Save and close it.
Next , double click config_gm.
You will see this
[CONFIG]
PORT1 = 15037
PORT2 = 15047
CAPACITY = 100
[SQLCONFIG]
DRIVER = {SQL Server**
SERVER = 192.168.1.64(ur lan ip)
[SQL1]
DSN = test2
UID = sa (make sure id and pw are correct)
PWD = 123
[SQL2]
DSN = test2
UID = sa
PWD = 123
Save and close it
Next, double click config_gw.
You will see this
[CONFIG]
PORT = 15010(make sure is 15010)
CAPACITY = 1000
[DBmanager]
IP = 192.168.1.64(ur lan ip)
PORT = 15047
[SQLCONFIG]
DRIVER = {SQL Server**
SERVER = 192.168.1.64(ur lan ip)
[SQL1]
DSN = test2
UID = sa(make sure id and pw are correct)
PWD = 123
[SQL2]
DSN = test2
UID = sa
PWD = 123
Save and close it.
Now u are done with the config , next launch the server .
Click O2JamGManager first , follow by O2JamGateWay and finally O2JamServer .
When u sucessfully launch all 3 , your own server is up!
Next connect to the server .
Go to C:\o2jam-ragezone\o2-clientpatch
Look for a launcher call launchserv, right click and edit (with notepad).
Replace the IP in the notepad with your IP and save it.
Next ,copy launchserv ,OTwo1 and a folder call o2jam and paste over to your client .
Double click the lancher to get into the game.
How to create accounts
First ,open Enterprice Manager in Start-->All Programs--> Microsoft SQL Server, and click Enterprise Manager.
Next the database called test2 , double click it , double click tables.
Find a file there call member , right click it , open tables , return to rows.
Then u will a table full of nos and words .
Yes , u will create account in the table by insert the info according to the rows.
Sex=0 female
Sex=1 male
Let say the id of the last account is 46524 , the new account's id you going to create should be 46525. And also set the registdate and also set id9you to -1
you guys also can use the latest Microsoft SQL 2005 Express + Manager. just that when to update the database, click the options and enable overwrite. then update from the backupdatabase.
http://img2.freeimagehosting.net/uploads/16042c7f59.gifAbout the ODBC, common error comes from the location.
<hostname>\sqlexpress
ie. narumi\sqlexpress
http://img2.freeimagehosting.net/uploads/0c4404c2cc.gifP.S. - Still if we can hack the client side files, so can use english navigation panels, I wouldnt be so confused now lol.
That chinese client got f***** virus spyware, damn, took me a while to clean up that. deleted the main installer, just going to use the extracted O2jam for now on.
