Create your own Private Server Tutorial.

[csoresz2]

Account Creation Query

it is from carchlord.tk

 Spoiler

REM INSERTING into USER.AMT_ACCOUNT
Insert into USER.AMT_ACCOUNT (ACCOUNTID,PASSWORD) values ('account','password');


REM INSERTING into USER.AMT_MASTER
Insert into USER.AMT_MASTER (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE,MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_YN,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMINATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,***) values ('account','','18',to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),null,null,null,null,null,'N','N','0',null,null,null,null,null,null,null,null);

[tomi-cro]

Originally Posted by csoresz2

Account Creation Query

it is from carchlord.tk

 Spoiler

REM INSERTING into USER.AMT_ACCOUNT
Insert into USER.AMT_ACCOUNT (ACCOUNTID,PASSWORD) values ('account','password');


REM INSERTING into USER.AMT_MASTER
Insert into USER.AMT_MASTER (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE,MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_YN,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMINATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,***) values ('account','','18',to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),null,null,null,null,null,'N','N','0',null,null,null,null,null,null,null,null);

where to put that ?

[csoresz2]

idk...PLSKQL?

[al3css]

log in PSQL server 7.0..and go at tables section and search for AMT_ACCOUNT and insert (ACCOUNTID,PASSWORD) values ('account','password'); table and AMT_MASTER and insert (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE, MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_Y N,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMI NATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,***) values ('account','','18',to_timestamp('2 6/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),null,null,null,null,null,'N','N',' 0',null,null,null,null,null,null,null,null);

[tomi-cro]

Originally Posted by al3css

log in PSQL server 7.0..and go at tables section and search for AMT_ACCOUNT and insert (ACCOUNTID,PASSWORD) values ('account','password'); table and AMT_MASTER and insert (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE, MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_Y N,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMI NATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,***) values ('account','','18',to_timestamp('2 6/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),null,null,null,null,null,'N','N',' 0',null,null,null,null,null,null,null,null);

LoL cant find insert all i see are hyroglifes

[Feldunost]

Olalalala, the easiest way should be to insert it on php script to make it automatic ... (thanks to carchlord.tk)


SQL Plus, alef, password, account and write:


Insert into ALEF.AMT_ACCOUNT (ACCOUNTID,PASSWORD) values ('Minera','waouw');


Insert into ALEF.AMT_MASTER (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE, MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_Y N,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMI NATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,***) values ('Minera','','18',to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),null,null,null,null,null,'N','N',' 0',null,null,null,null,null,null,null,null);



I am testing it with client ...


EDIT: Even with account creation, i cannot pass the login test ... :/
EDIT2: Password should be crypted tough ... ?

[Mustlord59]

I will tell you how i passed the login test, i used what you said before about navicat, and i went to Amt_aaccounttable and made and account, then i left navicat open and run login,relay,and world and the .bat file for the laucher should be your ip, i ran the game and i got through login, and you should have decrypted files changed the info and reincrypted them

I need the solution to the no world problem where there is no npc's or mobs and you cant even move from your spot, you move a little and then you are takin back you your original postion

[Feldunost]

Possibilities:

- Client not in chinese (not compatible)?
- Server who is not correctly set-up ?


Actually, i tested your solution, still it doesn't works but it receives the query like:




In login server the socket id 2998 is the client when i click login after typing Minera, wouaw. (login) ...

Relayserver communicate well with login server
Loginserver communicate well with Gameserver

It's weird totally :/



EDIT: OMFG it was only the Minera (doesn't accept the Majs M) i edited on minera, test.
I am logged on, i can see pnj, i can move also !!!!! YAY !!!!!

[Mustlord59]

How can you move? is there a world?
with all npc?
and what client you using, i am using nlgames client

[tomi-cro]

fck i made acc but it say server is closed when i log in (

[Feldunost]

The problem so is that nlgames modified the client socket connections so it doesn't allows you to communicate with our server ...

They are ******* retards, i am on Celestia FIRST client ever made by them witouth modifications, i have still the installer i think


Now we need to find what is the best client because i cannot say any word, i cannot access to options by esc ...

Tough, the best client was surely the last client Celestia they made ? ...

[Mustlord59]

For some reason when i try to access sql plus it says Tsn listener failed to start dedicated server process, i was running it yesterday but i dunno what happened

@Feldunost, what did you do, did you use celestia fix without overiting anything?

[Feldunost]

Go to TNS names.ora and erase the line who says

Dedicated server (account listener)

It's just one line

[Mustlord59]

Erase this line (Server=Dedicated) ?

[Feldunost]

Yes.

Restart after it should works ?

I have erased and it has no incident.