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

Is it work ?
any body try it ?

works ^^ thx

thread looks ugly. anyway thanks for share.

Quote:

Originally Posted by lushan1993 works ^^ thx

Quote:

Originally Posted by asanoftw thread looks ugly. anyway thanks for share.

04/07/2012, 16:27
:facepalm:

Awesome Work Keep Up!