Create your own Private Server Tutorial.

[Mustlord59]

Originally Posted by csoresz2

itemdatatable...

Can you give an example on how to do it inside the itemdatatable because the numbers are not lined up with the columns correctly even though i use Notepad ++

[rockinn]

Originally Posted by al3css

Doesn`t work for me! in AMT_ACCOUNT you say no?i try different password and nop doesn`t works!"Server connection has ended".



Give us an example if i put somethink wrong....

you modified AMT_ACCOUNT did you modify AMT_MASTER as well ? those 2 tables need to be synchronized

[al3css]

yes i modify it..same accountid like administrator id..i pui the name id "test1111","1234567890" AMT_ACCOUNT and to AMT_MASTER same..and nothink my friend can`t connect...

[Feldunost]

Originally Posted by al3css

yes i modify it..same accountid like administrator id..i pui the name id "test1111","1234567890" AMT_ACCOUNT and to AMT_MASTER same..and nothink my friend can`t connect...

LOL man, the password cannot be more than 8 characters ... ^^ check navicat and edit it manually ...

[al3css]

but lol... manually i make the account..it`s another method?

[al3css]

look here what i have:

in 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,***)




('account','','18',2011-02-05 00:00:00',2011-02-05 00:00:00,2011-02-05 00:00:00,null,null,null,null,null,'N','N','0',null ,null,null,null,null,null,null,null);



AMT_ACCOUNT:

ACCOUNTID PASSWORD
account password





=FAIL :-J



btw i use navicat lite version...

[Feldunost]

Edit1: Okay so for you it's another problem ...

If you live in european, why do you put 2011-02-05 00:00:00 in date creation ?
It means that the account has not been created yet xD ?

Put 2011-01-26 00:00:00 for the three (creation, last, modify date)


Edit2: Ups i am stupid it's the good date ... well i don't understand why it isn't working :/

[al3css]

2011-02-05 20:05:10 now i put that...but nothink..... give me your account example...




ok my friend create caracter,nd press connection button....lol now SERVER CONNECTION HAS ENDED can`t enter in the world.....

[al3css]

Originally Posted by Feldunost

Edit1: Okay so for you it's another problem ...

If you live in european, why do you put 2011-02-05 00:00:00 in date creation ?
It means that the account has not been created yet xD ?

Put 2011-01-26 00:00:00 for the three (creation, last, modify date)


Edit2: Ups i am stupid it's the good date ... well i don't understand why it isn't working :/

look...






EDIT1: i use windows xp pro !
EDIT2: with hamachi my friend can connect..
EDIT3: i oppened ports...but i use celestia client....curent celestia client....it`s the client wrong?[i am only that i can enter in the world,only my friend get server ended when try to enter in the world]

[Feldunost]

AMT_ACCOUNT:

hedizaoui, test
sedrun, test


AMT_MASTER
hedizaoui,,18,2011-01-26 00:00:00,2011-01-26 00:00:00,2011-01-26 00:00:00,null,null,null,null,null,'N','N','0',null ,null,null,null,null,null,null,null


It's that i have, the two works even if sedrun account is not on AMT_MASTER ...
If accountid is less or equal than 4 characters, it doesn't works.


But it seems that it's another problem for you ...


I am watching if the client needs some special ports like 80 ... it would be very bad if yes ... :/



Edit: LOL it seems that i have the same problem but it has began only with rockinn ... xD

[al3css]

Originally Posted by Feldunost

AMT_ACCOUNT:

hedizaoui, test
sedrun, test


AMT_MASTER
hedizaoui,,18,2011-01-26 00:00:00,2011-01-26 00:00:00,2011-01-26 00:00:00,null,null,null,null,null,'N','N','0',null ,null,null,null,null,null,null,null


It's that i have, the two works even if sedrun account is not on AMT_MASTER ...
If accountid is less or equal than 4 characters, it doesn't works.


But it seems that it's another problem for you ...


I am watching if the client needs some special ports like 80 ... it would be very bad if yes ... :/

and 8080...look if need 80 or 8080....9100...


accounts work but connect to world with character doesn`t work

[Feldunost]

I have put an DMZ and shutted down the firewall, it's not ports who make problems ... still false ... for rockinn.

If i put external ip on oracle database, i cannot start server.

[al3css]

Feldunost you know how make a caracter GM to use commands?please tell me how?

[Feldunost]

Originally Posted by al3css

Feldunost you know how make a caracter GM to use commands?please tell me how?

I think that i have some ideas for that, you can see in LOGINSTATUS, that there is accountlv, i am sure that it's something who has an incident with that ... I have just to find out what parameter.

Plus if you check SERVERCONFIG, at extra, you can see the end:
AllAdmin: Y

So there is some others parameters who need to be found

[al3css]

thx thx...alot for info...