Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Guide] Setup Your Server

Newbie Spellweaver
Joined
Apr 27, 2009
Messages
13
Reaction score
0
The links are not working.....please put a new link thanks......
 
Newbie Spellweaver
Joined
Nov 27, 2010
Messages
20
Reaction score
0
Stuffs to get before setting up your server.
  1. SQL 2000
  2. Server Files
  3. Client files--- Part I of the client

    Part II of the client

    Part III of the client

    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



All credits goes to me : BladeX and RaGEZONE


No One Is Allowed To Publish My Guide Anywhere Or Copy My Guide Without My Permission.

can u refresh the client link? :(:
 
Initiate Mage
Joined
Apr 28, 2009
Messages
3
Reaction score
0
hm... i have an error... i can't start exe files... they start and closing after one second...
Servers: 1.5, 1.8...
MSSQL: 2000
Windows: Server 2008 x64...
help plz
 
Initiate Mage
Joined
May 9, 2009
Messages
4
Reaction score
0
Stuffs to get before setting up your server.
  1. SQL 2000
  2. Server Files
  3. Client files--- Part I of the client

    Part II of the client

    Part III of the client

    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



All credits goes to me : BladeX and RaGEZONE


No One Is Allowed To Publish My Guide Anywhere Or Copy My Guide Without My Permission.

Can you update the link pls???:(:
 
Experienced Elementalist
Joined
Mar 10, 2011
Messages
229
Reaction score
50
Help Here :/ I Use My VPS Windows 2008 r2 To Run The Server i Successfully run it But when i try to connect to server it sends me an chinese text and i think it means the could not connect to server but i think i have a problem to my port ? I know this thread is too old but i wan't to create an o2jam server :)
 
Newbie Spellweaver
Joined
Jan 26, 2014
Messages
31
Reaction score
0
It should be great if someone can re-upload the links :D Let's make O2 Jam one more time! ^_^
 
Junior Spellweaver
Joined
Oct 23, 2006
Messages
179
Reaction score
6
Hello from 2018.

If there is anyone still looking for O2Jam files (server, client, emulator, tools, documents, song pack OJN/OJM, etc.), here is the well-organized mirror link:


For SQL Server setup file, you can download any version (2000+) from Microsoft. It's not that hard nowadays to get an ISO file.
 
Last edited:
Initiate Mage
Joined
May 13, 2018
Messages
2
Reaction score
0
blade i open the 1.8 o2jam private server but i didn't connect to my server :(
 
Back
Top