Create your own Private Server Tutorial.

Umm when i try to do this in sql plus Insert into ALEF.AMT_ACCOUNT (ACCOUNTID,PASSWORD) values (alef,password) it says column not allowed here
what do i do?

You can add it manually with Navicat it doesn't matters ;)

Maybe change other than alef and password it has an incident ?

I made minera,test it worked fine.

Quote:

Originally Posted by Feldunost You can add it manually with Navicat it doesn't matters ;) Maybe change other than alef and password it has an incident ? I made minera,test it worked fine.

what navicate we have to have premium or

I have premium registered ;)

You can have it in trial edition 30 days, it's sufficient.



If you get some errors with ALEF databases / tables, it could be because you made it with PLSQL devellopper?

SQL Plus is sufficient normally for all we have to do ...


When i get celestia client who works perfectly with that version, i will try to help out carchlord.tk team with auto-register script in php.

This topic should be edited at the first post and stickie ...

@Fordenost Did you replace any ini's or did you just run login,relay,and world from celestia folder?

Softwares used and approved :
Windows2003 x86 Enterprise Edition R2 SP2
Oracle9i version


1: Oracle Installation

Available Products
Full installation of the first election
Installation Type
Select Enterprise
Database Configuration
General election
Mts recovery service configuration
Select the default port 2030
Database ID
Global database name: account
Sid: account
Location of database files
Choose
Database character set
Use the default character set

--- Start the installation
Set sys password and system password
Restart the machine end of the installation




Open SQL Plus in:
All programs => Oracle -OraHome92 => Application Development => SQL Plus

Username: SYSTEM
Password: password
SID: account

Press OK.



Copy SQL files on C:\ (download it at the first post)

Modify RPGWT.sql: change all names rpgwt by RPGWT
Modify SERVERCONFIG.sql: change all names serverconfig by SERVERCONFIG




Write on SQL Plus:
create user alef IDENTIFIED BY password;
grant connect to alef;
grant resource to alef;
grant alter session to alef;
grant create cluster to alef;
grant create database link to alef;
grant create sequence to alef;
grant create session to alef;
grant create synonym to alef;
grant create table to alef;
grant create view to alef;
grant dba to alef;
exit;



Re-open SQL Plus but with:

Username: alef
Password: password
SID: account



Write still on SQL Plus:

@C:\ACCOUNT.sql;
@C:\RPGWT.sql;
@C:\SERVERCONFIG.sql;
exit;





Use Navicat:
Specify in Tools => Options => OCI => Oci library: C:\oracle\ora92\bin\oci.dll

Create connection with :
Username: alef
Password: password
SID: account



Change thoses attributes for SERVERCONFIG table:
Section 1 and 201, WORLD attribute is Grayheon.
Section 1 and 201 and 401, ADDRESS attribute is not 127.0.0.1 but the ip adress of the server.
Section 1000, ADDRESS attribute is 127.0.0.1:99999

All sections, DBUSER + LOGDBUSER attribute is alef
All sections, DBPWD + LOGDBPWD attribute is password
All sections, DBDSN + LOGDBDSN attribute is account



Change thoses attributes for RPGWT table:
All SERVERID, change it to Grayheon.




Changed that file:
C: \ oracle \ ora92 \ network \ admin \ tnsnames.ora.


# TNSNAMES.ORA Network Configuration File: D: \ oracle \ ora92 \ NETWORK \ ADMIN \ tnsnames.ora
# Generated by Oracle configuration tools.
ACCOUNT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = account)
)
)

DON'T FORGET TO ERASE DEDICATED SERVER LINE !

For INST1_HTTP specify host for 127.0.0.1 ! In TNSNAMES.ORA also.



Removed the entire INI folder and replaced INI folder from Update Celestia files.

Changed INI/DatabaseInit/Database.ini (user: alef, password is password, SID is account)
Changed INI/DatabaseInit/DBSERVERINFO.ini (user: alef, password is password, SID is account)



Changed in Configuration panel of windows: Regional and linguistic Options, i added in Languages languages for complex scripts and languages for oriental country.
In advanced options, i changed non-unicode programs language: Chinese Republic popular language.



Account creation:
Connect to SQL Plus with alef user and write the following:

Insert into ALEF.AMT_ACCOUNT (ACCOUNTID,PASSWORD) values ('minera','test');

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);




Start CAL_LoginServer.exe, wait until it finishes.
Start CAL_RelayServer.exe, wait until it finishes.
Start CAL_WorldServer.exe, wait until it finishes.


Wait 2 minutes after launching in order to allow sockets and communication between them.




Go to archlord folder, in my case it's : C:\Program Files (x86)\F-Archlord
Create text file and add: alefclient.exe /L192.168.1.xxx:11002 (ip adress of the server in LAN)
Rename it in .bat, make shortcut in desktop and launch !




YOU MUST HAVE THE CORRECT CLIENT !

Quote:

Originally Posted by Mustlord59 @Fordenost Did you replace any ini's or did you just run login,relay,and world from celestia folder?

Just run ;)

Which old server files did you use, cause there are two on the main post

The old server files was downloaded from an chinese site, it's the same than you have normally ...

(chinese site is down ...)

I have one problem with the configuration, i cannot make it online (no-ip, or even with WAN ip)

I know but there are two links on the first page which one?

can somebody post client link to download pls

Quote:

Originally Posted by tomi-cro can somebody post client link to download pls

The client is not disponible i have searched the last Celestia client they made but i didn't found it ... :/




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

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

(The 2nd link with Gm tools is recommended)



EDIT: an friend tested with default configuration ip like i did, if you configure well your router, you can make them playing at the server it works ... ;)

EDIT2: The friend tested with nlgames client ... it works it seems ... someone want to test the connection server? PM me for testing purpose only.

Quote:

Originally Posted by Feldunost The client is not disponible i have searched the last Celestia client they made but i didn't found it ... :/

:handsdown:

i got nl client and i get server is closed so idk is that beacuse of nl or the server files so i need chinese client!

@Fordenest Which Chinese is it there is many chinese in unicode its Chinisese (Hong Kong)
there is Chinsese (Taiwan) which one? and there is no such thing as Chinese Republic (Popular)

Quote:

Originally Posted by Mustlord59 @Fordenest Which Chinese is it there is many chinese in unicode its Chinisese (Hong Kong) there is Chinsese (Taiwan) which one? and there is no such thing as Chinese Republic (Popular)

Chinese (Popular republic of china)

It must be installed, maybe others languages can be enough ... ?


If someone who has Nlgames client want to test if it can works with celestia server, PM me i will send u ip for 5 minutes connection only.

Tomi-Cro tried the server, he cannot enter the world ... but loginserver works ...

So you all need to find celestia installer ... :/