[Guide]How to add new Advance Elixir

[H34D_B4NG3R]

Part 1 - Setting Up

Tools that you will need
Pk2 extractor & editor
Text Editor
Your database and server

You will be editing the following files in your Media.pk2:
itemdata_45000.txt
TO DO - Extract the files into a folder.

You will be editing the following database tables:

These handle your Items
_RefObjCommon
_RefObjItem

[hr]

Part 2 - Database Entries


I will start with this first because there can be Problem with IDs


This part will use the following tables:
_RefObjCommon
_RefObjItem

Explanation

_RefObjCommon basically has every single item, character, monster and building that the game uses, if is not here then you can not use it anywhere else in the database.
_RefObjItem branches of from _RefObjCommon to specify attributes regarding Items.

First we have to use this Query to find out which ID we have to use

USE SRO_VT_SHARD
DECLARE @CommonID INT
DECLARE @ItemLinkID INT
SET @CommonID = (SELECT ID FROM _RefObJCommon WHERE ID = (SELECT MAX(ID) FROM _RefObJCommon))+1
SET @ItemLinkID = (SELECT ID FROM _RefObJItem WHERE ID = (SELECT MAX(ID) FROM _RefObJItem))+1
print 'Common ID you have to use: '+cast(@CommonID as varchar(15))
print 'Common Link ID you have to use: '+cast(@ItemLinkID as varchar(15))

Now after u have used this Query we can start to create a new Item !
First we need an old ADV Elixir for the column infos

SELECT * FROM _RefObjCommon WHERE CodeName128 = 'ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B _12'
SELECT * FROM _RefObjCommon WHERE ID = '12516'

Explanation

_CodeName128 iss the Column where the item server name iss define
12516 iss the Link id of "ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_12"

TO DO - Copy both rows into a new txt file and it should look like this :

_RefObjCommon

1 26028 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_12  ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_12 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_B_RARE_TT_DESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 40000 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 12516

_RefObjItem

12516 1 2 0 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100663296 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0

Explanation

[Red marked] Item and Link ID
[Green Marked] the amount of "+" the elixir make
[Orang marked] the name of item

Now change the Red marked to your ids from the Query , change the green marked to your wished plus (example: 15) and the orang marked to a random name (example : ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_C_ 12 )


TO DO - Past the rows into _RefObjCommon and _RefObjItem.

[hr]


Part 3 - Media.pk2 Entries

After you have finished the work on Databse the client side iss easy
Copy both lines from _RefObjCommon and _RefObjItem into a new txt file and edit them in 2 simple steps:

Step1:
Past the lines in 1 row of a txt file

1 26028 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_12 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_12 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_B_RARE_TT_DESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 40000 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 12516 12516 1 2 0 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100663296 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0

Explanation

[Orang marked] The Link id from _RefObjCommon and ID from _RefObjItem
[Red marked] Link id from _RefObjItem (useless)

Step2:
Delete the Link ids and the ID (Marked Orang and Red)

1 26028 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_12 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_12 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_B_RARE_TT_DESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 40000 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 1 2 0 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100663296 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0

TO DO - Past the row into your itemdata_45000.txt and import it into your Media.pk2

Explanation
To create new Shield/Armor or accessory elixir replace "WP" with SH/AR and AC above in the SQL Query

[hussienm37]

thx4ever for this topic

[•ᵔBeGodOfWarᵔ•]

Originally Posted by hussienm37

thx4ever for this topic

Press thanks button instant from writing ( thx , gz , etc. )