Create your own Private Server Tutorial.

Account Creation Query

it is from carchlord.tk

Quote:

Originally Posted by csoresz2 Account Creation Query it is from carchlord.tk  Spoiler Code: 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,SEX) values ('account','[Only registered and activated users can see links. Click Here To Register...]','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 ?

idk...PLSKQL?

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,SEX) values ('account','[Only registered and activated users can see links. Click Here To Register...]','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);

Quote:

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,SEX) values ('account','[Only registered and activated users can see links. Click Here To Register...]','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

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,SEX) values ('Minera','[Only registered and activated users can see links. Click Here To Register...]','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 ... ?

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

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:

[Only registered and activated users can see links. Click Here To Register...]


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 !!!!!



[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

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

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

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

They are fucking 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 ? ...

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?

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

Dedicated server (account listener)

It's just one line ;)

Erase this line (Server=Dedicated) ?

Yes.

Restart after it should works ?

I have erased and it has no incident.