Attached Files

Local Server.rar (134.3 KB, 222 views)

Stuffs to get before setting up your server.

1. SQL 2000 here
2. Server Files
3. Client files--- Part I of the client here
   
   Part II of the client here
   
   Part III of the client here
   
   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

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.gif



About the ODBC, common error comes from the location.
<hostname>\sqlexpress
ie. narumi\sqlexpress

http://img2.freeimagehosting.net/uploads/0c4404c2cc.gif


P.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.