Celestia serverfiles/source

[hotvision]

As we know some private servers use the Celestia Serverfiles.
We found new missing table and ini files/folders.

Siege exist uknown command to start it and here you can see if you decrypt and read data from gameserver console:

SiegeWarGroup...Interval....MaxChar.MinChar.Name.. ..GroupID.SpawnEnd....SubEnd..SubStart....EventEnd ....EventStart..DropItemTemplate....SpawnRate

Missing files:

skill specialization.ini
object static.ini

Missing tables:

AMT_COUPON_MASTER
AMT_COUPON_USER
AMT_EVENT_COUPON
COMPENRESULT


MISSING FOLDER:

MAP/DATA :
Compact folder
Geometry folder
Moonee folder

(adding this folders you can use other WORLD maps/and editing regiontemplate.ini and worldmap.ini file;remember to edit in client too)



SQL:

CREATE TABLE "SYSTEM"."AMT_COUPON_MASTER"
( "SEQ_MASTER" NUMBER(20,0),
"ACCOUNTID" VARCHAR2(32 BYTE),
"CHARID" VARCHAR2(32 BYTE),
"WORLD" VARCHAR2(32 BYTE),
"CP_CODE" CHAR(10 BYTE),
"USEYN" CHAR(10 BYTE)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;


CREATE TABLE "SYSTEM"."AMT_COUPON_USER"
( "SEQ_MASTER" NUMBER(32,0),
"COUPONNO" NUMBER(32,0),
"COMPEN" VARCHAR2(20 BYTE),
"USEYN" CHAR(10 BYTE),
"GAME_USEDT" VARCHAR2(20 BYTE),
"GAME_ITEMLOG" VARCHAR2(20 BYTE)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;


CREATE TABLE "SYSTEM"."AMT_EVENT_COUPON"
( "USEYN" VARCHAR2(20 BYTE),
"USEDATE" DATE,
"COUPONNO" NUMBER(32,0)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;



CREATE TABLE ."COMPENRESULT" (
"COMPENID" VARCHAR2(50 BYTE) NULL ,
"ACCOUNTID" VARCHAR2(50 BYTE) NULL ,
"WORLD" VARCHAR2(50 BYTE) NULL ,
"CHARID" VARCHAR2(50 BYTE) NULL
) ;

[csoresz2]

what does it mean?

[hotvision]

SQL? this use to create the missing table or do this manualy if you cant restore them

[raduelvis1]

thank you sir,but maybe you can explain for all :d wath the tables and the mising inis make :XD

[hotvision]

The first SQL tables you can use them for event items to distribute the event items (example: unique rings)for all peoples...

The ini files :

skill specialization.ini > Combos/craft skills etc
object static.ini > buildings/siege summons


Now i inserted combos on 1 place..where are the normal skills,and for objects i inserted in OBS files the buildings = arena = working then but you need to search for codes for arena = alot of time (isnt implanted at the moment)

[raduelvis1]

1 question sir abouth the arena,didnt tryed but can you take the codes from siege region and put them to arena,maybe will work

[hotvision]

nope they are incompatible but i will try it...