[DEV] O2Jam v1.8 Server that uses MySQL

[PureSpectre]

Overall progress - 35%

O2Jam version 1.8 Server using MySQL Database
-- alpha release
Hacked and ported by ChronoSentinel

What it can do:
- login works the way it should but buggy
- you'll get stuck on channel select

Notes:
- You'll need a MySQL ODBC Driver and MySQL. [duh~]
- You'll also need some MySQL knowledge, just-in-case.
- Use your own .ojs and .dat files.
- Open T_O2Jam.sql and change all the IP addresses in that
  file to the one reported by the server executables.
- You'll need two schemas: 'O2Jam' and 'O2JamTrade'.
- Execute all SQL queries in the 'Database' folder.
- Put your database's IP address and password in all *.ini
  files and DATA/Channel.txt.

Feel free to contribute any development by posting them here.

You must be registered to see links

I tried and I'm still trying, but I am stuck at one point.

The server keeps calling P_O2Jam_Login with a constant value as User_Index_ID regardless of what the account is actually assigned for. I want to know how am I supposed to let the server/client know what the user's User_Index_ID is.

Anyone actually know how this works?

-- This is queried when you login / hit GO.
CALL P_O2Jam_Certify_9You ('testID','test','127.0.0.1')
-- This is queried when you select a channel
CALL P_O2Jam_Log_In ('O2JamGateWay','testID','test',4204767,'127.0.0.1'

4204767 is definitely not the User_Index_ID of that account.

 

[kitez]

sorry i can't help you but i will support you. btw, i guess you also should edit the asp page because it's used for buyment avatar process in game..

 

[xXxMarcoxXx]

Cool poop! Btw, this is o2Jam 1.8 (Chinese), right?
Is there a way to use my o2Jam Philippines client files instead of downloading the chinese ones?

 

[kitez]

Cool poop! Btw, this is o2Jam 1.8 (Chinese), right?
Is there a way to use my o2Jam Philippines client files instead of downloading the chinese ones?

i guess not, you must use the china client.

 

[redelmo]

Overall progress - 35%

O2Jam version 1.8 Server using MySQL Database
-- alpha release
Hacked and ported by ChronoSentinel

What it can do:
- login works the way it should but buggy
- you'll get stuck on channel select

Notes:
- You'll need a MySQL ODBC Driver and MySQL. [duh~]
- You'll also need some MySQL knowledge, just-in-case.
- Use your own .ojs and .dat files.
- Open T_O2Jam.sql and change all the IP addresses in that
  file to the one reported by the server executables.
- You'll need two schemas: 'O2Jam' and 'O2JamTrade'.
- Execute all SQL queries in the 'Database' folder.
- Put your database's IP address and password in all *.ini
  files and DATA/Channel.txt.

Feel free to contribute any development by posting them here.

You must be registered to see links

I tried and I'm still trying, but I am stuck at one point.

The server keeps calling P_O2Jam_Login with a constant value as User_Index_ID regardless of what the account is actually assigned for. I want to know how am I supposed to let the server/client know what the user's User_Index_ID is.

Anyone actually know how this works?

-- This is queried when you login / hit GO.
CALL P_O2Jam_Certify_9You ('testID','test','127.0.0.1')
-- This is queried when you select a channel
CALL P_O2Jam_Log_In ('O2JamGateWay','testID','test',4204767,'127.0.0.1'

4204767 is definitely not the User_Index_ID of that account.

I hope this helps. i have no idea how this thing works

 

[kitez]

btw, is it has complete database? because some items can't be bought in o2jam v1.8 server files........

 

[PureSpectre]

~redelmo: No, it does not help. I already have that.
~kitez: It's not. Like I said, the development stuck there.