Experienced Elementalist
- Joined
- Apr 9, 2007
- Messages
- 211
- Reaction score
- 1
First Download These
1. SQL Server 2000 Download Now
2. O2Jam Server Files Download Now
3. O2Jam Client
Part 1
Part 2
Part 3
and put it in one folder
4. Hamachi VPN Client Download Now
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
o2jamtrade
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
Now Install Hamachi
And Power it On
and see theres an ip kind like this 5.13.1.43.1
something that starts in 5.....
now thats your hamachi ip
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 hamachi 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 hamachi 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
(the login id is alway "sa")
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 = 5.....(your hamachi ip)
PORT = 15037
[SQLCONFIG]
DRIVER = {SQL Server**
SERVER = 5........(your hamachi 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 = 5......(your hamachi 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 = 5.....(your hamachi ip)
PORT = 15047
[SQLCONFIG]
DRIVER = {SQL Server**
SERVER = 5......(your hamachi 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 can delete the id9you column
So if you want some more questions
pls... reply here
1. SQL Server 2000 Download Now
2. O2Jam Server Files Download Now
3. O2Jam Client
Part 1
Part 2
Part 3
and put it in one folder
4. Hamachi VPN Client Download Now
** 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
o2jamtrade
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
Now Install Hamachi
And Power it On
and see theres an ip kind like this 5.13.1.43.1
something that starts in 5.....
now thats your hamachi ip
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 hamachi 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 hamachi 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
(the login id is alway "sa")
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 = 5.....(your hamachi ip)
PORT = 15037
[SQLCONFIG]
DRIVER = {SQL Server**
SERVER = 5........(your hamachi 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 = 5......(your hamachi 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 = 5.....(your hamachi ip)
PORT = 15047
[SQLCONFIG]
DRIVER = {SQL Server**
SERVER = 5......(your hamachi 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 can delete the id9you column
So if you want some more questions
pls... reply here
Last edited by a moderator:
