Update Gracia Final to Epilogue

[ADONES]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

Hello everybody,

actualy i am running the Gracia Fianal Server and all work fine... But i now want to upgrade to the cool "Epilogue"
that l2jserver team coded for us.

Is there some discription (guide) or can someone post me how to update my server "G2 Final" to "Epilogue" because i dont want to do mistakes and lose data of players or server configurations.

Thank u for help

[blacksea]

backup your mysql
./database_installer.sh and follow the process

[ADONES]

ok thank u....

and what do i got to do with my server properties etc...?
(I mean all my old configs)

and do i only got to install the new database update or the server update too ?

[janiii]

updating a server is not only about updating the database, but also updating the whole datapack and copying new files.

make a backup of your server and database before you do any change!

1. you should know what you have changed, check your custom changes
2. backup also configs, check their changes to default values
3. update database
4. download new l2j server, (build), copy new dist files
5. update new config with previous values (do not replace the new config files with old files, as you would miss some new configs!)
6. read the new configs, as they contain new config options and info which could be important for you

[ADONES]

thank u for help

[Krab]

Please help i can't success to update from Final to Epiloge:

i have use database_installer and update then start login and game server it ok. but when i login to the world and open inventory i have no see any items but weight and textures show they on my char, But inventory slots is emty. and they have some other items somsing like mask but amount of this is 21kkk

What i did wrong?

sorry for my poor English

[janiii]

did you also update the server files? is your client version compatible with server version (check min/max client protocol revision in config)?

[jurchiks]

maybe you just installed, but didn't update the epilogue client?

[Krab]

yap, i run server from other dir, i used russian client he is 148 protocol... may be they are diffrent... i try to use NA\EU client may this help me...

[shoko]

I use this mysql script is work fine

Code: Select all

 ALTER TABLE `castle` CHANGE `treasury` `treasury` BIGINT NOT NULL default 0;  ALTER TABLE `character_skills` DROP `skill_name`;ALTER TABLE `heroes` DROP `char_name`;  ALTER TABLE `characters` ADD `vitality_points` SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER `bookmarkslot`; ALTER TABLE `custom_armorsets` DROP `skill_id`;ALTER TABLE `custom_armorsets` DROP `skill_lvl`;ALTER TABLE `custom_armorsets` ADD `skill` VARCHAR(70) NOT NULL DEFAULT '0-0;' AFTER `feet`; UPDATE `characters` SET `fame`=50000 WHERE `fame`>50000 ALTER TABLE `character_recipebook` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`,`charId`,`classIndex`) UPDATE character_subclasses SET class_id=128 WHERE class_id=129 AND charId IN (SELECT charId FROM characters where race=5 AND sex=1); -- female main -> male soulbreaker subUPDATE character_subclasses SET class_id=129 WHERE class_id=128 AND charId IN (SELECT charId FROM characters where race=5 AND sex=0); -- male main   -> female soulbreaker subUPDATE character_subclasses SET class_id=132 WHERE class_id=133 AND charId IN (SELECT charId FROM characters where race=5 AND sex=1); -- female main -> male soulhound subUPDATE character_subclasses SET class_id=133 WHERE class_id=132 AND charId IN (SELECT charId FROM characters where race=5 AND sex=0); -- male main   -> female soulhound sub ALTER TABLE `custom_armor` ADD `depositable` varchar(5) NOT NULL default 'false' AFTER `tradeable`;ALTER TABLE `custom_etcitem` ADD `depositable` varchar(5) NOT NULL default 'false' AFTER `tradeable`;ALTER TABLE `custom_weapon` ADD `depositable` varchar(5) NOT NULL default 'false' AFTER `tradeable`;  UPDATE `character_quests` SET `value` = 1 WHERE (`name` = '606_WarWithVarkaSilenos' AND `var` = 'cond' AND `value` > 1); ALTER TABLE `castle` ADD `showNpcCrest` enum('true','false') DEFAULT 'false' NOT NULL AFTER `regTimeEnd`;  ALTER TABLE `characters` ADD `title_color` MEDIUMINT UNSIGNED NOT NULL default '16777079' AFTER `title`; ALTER TABLE `character_friends` DROP PRIMARY KEY, ADD PRIMARY KEY (`charId`, `friendId`),DROP column `friend_name`; ALTER TABLE `character_friends` ADD `relation` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `friendId`  ALTER TABLE `custom_armor` ADD `additionalname` varchar(120) NOT NULL default '' AFTER `name`; ALTER TABLE `custom_etcitem` ADD `additionalname` varchar(100) NOT NULL default '' AFTER `name`; ALTER TABLE `custom_weapon` ADD `additionalname` varchar(120) NOT NULL default '' AFTER `name`; ALTER TABLE `custom_npc` ADD `enchant` INT NOT NULL default 0 after `armor`; UPDATE `items` SET `loc` = 'WAREHOUSE' WHERE `loc` = 'FREIGHT'; ALTER TABLE `characters` ADD `createTime` DECIMAL( 20, 0 ) NOT NULL DEFAULT '0' AFTER `vitality_points` ;    

[MELERIX]

for what ?

you don't need to run these queries manually.

these update queries are executed automatically by the database_installer when you select (a) at the end.

[ADONES]

Hello Guys,

i did it and Epilogue worked fine, all the account information etc. ... was still there.
But my Npc's wasn't there anymore.. gm-shop, buffer... same for the droplist... it wasn't there too.

Thats the way i did it:

1. downloaded server, datapack (nightlies)
2. changed my custom properties from the old configs in the new configs
3. extracted the server, datapack into my old "L2J Server" directory
4. copy--->paste the new changed configs with my custom properties into the config folder
5. run the (datapack_installer.bat) (windows) from the tool directory
6. I started the login/gameserver

can someone help and tell me what i did wrong?

ty in advance
ADONES

[rocoder]

But my Npc's wasn't there anymore.. gm-shop, buffer... same for the droplist... it wasn't there too.

because you diden't use custom tables for them..next time all customs add in custom tables:P