[Guide] Re Create Weapon

this tut made for who wanna Re Creat new weapons based on the old weapons
i dont know if it here or no but i searched alot and didnt find it here

i know my english is bad so dont cat like a teacher and try to say your english is bad i (already know that)

PHP Code:


			
[PHP]
In this Tutorial Series i will try to teach you how to edit your Media.pk2 step by setp.
This iss the first of many Tutorials and now i will try to explain how to reCreate a weapon

[/PHP]

Explanation

PHP Code:


			
What did i mean with "reCreate" it mean that we select a old Weapon and make a new based on this Item , simple example iss Legendary 2-H Sword as CH Blade

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

itemoption.txt (isnt importent)

TO DO - Extract the files into a folder.

--------------------------------------------------------------------------

You will be editing the following database tables:

THESE HANDLE YOUR ITEMS

_RefObjCommon

--------------------------------------------------------------------------

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

Explanation

PHP 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.

--------------------------------------------------------------------------

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 @CommonID_old INT
DECLARE @ItemLinkID INT
DECLARE @ItemLinkID_old 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 'New Common ID you have to use: '+cast(@CommonID as varchar(15))
print 'New Common Link ID you have to use: '+cast(@ItemLinkID as varchar(15))
SET @ItemLinkID_old = (SELECT Link FROM _RefObJCommon WHERE CodeName128 = 'ITEM_EU_TSWORD_11_SET_B_RARE')--Your Item Name
SET @CommonID_old = (SELECT Link FROM _RefObJCommon WHERE CodeName128 = 'ITEM_EU_TSWORD_11_SET_B_RARE')--Your Item Name
print 'Old Common ID: '+cast(@CommonID_old as varchar(15))
print 'Old Common Link ID: '+cast(@ItemLinkID_old as varchar(15))

Code:

SELECT * FROM _RefObjCommon WHERE ID = 'Old Common ID'
SELECT * FROM _RefObjItem WHERE ID = 'Old Common Link ID'

TO DO - Copy both rows into a new txt file and it should look like this (If u use my item name) :

Explanation

PHP Code:


			
[Red marked] This is the Common ID
[Orang marked] This is the Item Link id
[Yellow Marked] This iss the kind of weapon (8 for 2H) New Codes are : (Spear 14 / Blade 2) for more codes select a random CH Weapon from Database and look at TypID8
[Green Marked] Which Country can use this item ( 3 = Neutral 1 = Europe 2 = China) 
[Blue Marked] Item name (Change this for example from EU to CH

Now change : Red marked to your New Common ID , Orang marked to Item Link ID , Yellow to your king of Weapon (at this weapon 2) and the green marked to 3

--------------------------------------------------------------------------

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

Explanation

Code:

[Orang marked]Link number and Item ID (_RefObjItem)

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

PHP Code:


			
1 [COLOR="red"]25679[/COLOR] [COLOR="red"]ITEM_CH_TSWORD_11_SET_B_RARE[/COLOR] ?????_?? xxx SN_[COLOR="blue"]ITEM_CH_TSWORD_11_SET_B[/COLOR] SN_[COLOR="Blue"]ITEM_CH_TSWORD_11_SET_B[/COLOR]_TT_DESC 0 0 3 1 6 [COLOR="Yellow"]8[/COLOR] 180000 [COLOR="Lime"]1[/COLOR] 6 1 1 1 255 3 1 1 1 0 0 12540000 5427 8141 0 9000 4389000 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_tsword_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_tsword_11_set_b.ddj xxx xxx 1 2 0 0 31 40 81 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 2492 2638 3046 3224 81,8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 2 15 1 ITEM_EU_TSWORD_12_A_RARE 1 ITEM_EU_TSWORD_12_B_RARE     1 ITEM_EU_TSWORD_12_C_RARE -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0

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

Part 3 - Media.pk2 Entries (Glow)

Add this row to your itemoption.txt

Code:

ITEM_CH_TSWORD_11_SET_B_RARE 1

Dont try to Copy my lines from this Tutorial because the ID arent changed

I hope you like this Guid guys this tut was by Mangnyang not by me

i just try to get new tut here