HOW ADD NEW ADVANCED ELIXIR - VSRO SERVER
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
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
Code:
_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
Code:
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
Code:
_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
Code:
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_D ESC 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
Code:
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
Code:
[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.
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
Code:
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_D ESC 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
Code:
[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)
Code:
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_D ESC 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
 |
