How To Add Wolf&Vigors To NPC

Hello guys , since i couldn't find anything helpfull about that
i will release my own guide.. , hope you will enjoy it :D

Adding Wolf :

For Wolf Use the below mssql queries! : [SQL SIDE]

PHP Code:

Update _RefPackageItem SET Service = 1 WHERE CodeName128 = 'PACKAGE_ITEM_COS_P_FLUTE'

PHP Code:

Update _RefPricePolicyOfItem SET Service = 1 WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'

PHP Code:

Update _RefScrapOfPackageItem SET Service = 1 WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'

PHP Code:

Update _RefShopGoods SET Service = 1 WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'

For Wolf add the below Text into your Media.pk2! : [Media.PK2 SIDE]

refshopgoods.txt :

PHP Code:

1    15    STORE_CA_STABLE_TAB3    PACKAGE_ITEM_COS_P_FLUTE    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_CH_STABLE_TAB3    PACKAGE_ITEM_COS_P_FLUTE    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_EU_STABLE_TAB3    PACKAGE_ITEM_COS_P_FLUTE    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_KT_STABLE_TAB3    PACKAGE_ITEM_COS_P_FLUTE    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_WC_STABLE_TAB3    PACKAGE_ITEM_COS_P_FLUTE    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx

refscrapofpackageitem.txt :

PHP Code:

1    15    PACKAGE_ITEM_COS_P_FLUTE    ITEM_COS_P_FLUTE    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    29952

refpricepolicyofitem.txt :

PHP Code:

1    15    PACKAGE_ITEM_COS_P_FLUTE    1    0    2000000    -1    xxx    -1    xxx    -1    xxx    -1    xxx

refpackageitem.txt :

PHP Code:

1    15    24822    PACKAGE_ITEM_COS_P_FLUTE    0    EXPAND_TERM_ALL    SN_ITEM_COS_P_FLUTE    SN_ITEM_COS_P_FLUTE_TT_DESC    cos\cos_p_flute.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx

**ddj File location in worng because PHP Code removes \ So Change it to cos\cos_p_flute.ddj

We Finished Add Wolfs into NPC :P !

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

Adding Vigors [25% Hp&Mp Potions] :

For Vigors Use the below text and add into MSSQL! : [SQL SIDE]

Table Name : _RefPackageItem

PHP Code:

1    15    84037    PACKAGE_ITEM_ETC_ALL_SPOTION_01    0    EXPAND_TERM_ALL    SN_ITEM_ETC_ALL_SPOTION_01    SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC    item\etc\all_spotion_01.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx

**ddj File location in worng because PHP Code removes \ So Change it to item\etc\all_spotion_01.ddj

Table Name : _RefPricePolicyOfItem

PHP Code:

1    15    PACKAGE_ITEM_ETC_ALL_SPOTION_01    1    0    20000    -1    xxx    -1    xxx    -1    xxx    -1    xxx

Table Name : _RefScrapOfPackageItem

PHP Code:

1    15    PACKAGE_ITEM_ETC_ALL_SPOTION_01    ITEM_ETC_ALL_SPOTION_01    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    86685

Table Name : _RefShopGoods

PHP Code:

1    15    STORE_CA_POTION_TAB1    PACKAGEITEM_ETC_ALL_SPOTION_01    25    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_CH_POTION_TAB1    PACKAGEITEM_ETC_ALL_SPOTION_01    27    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_EU_POTION_TAB1    PACKAGEITEM_ETC_ALL_SPOTION_01    27    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_KT_POTION_TAB1    PACKAGEITEM_ETC_ALL_SPOTION_01    23    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_WC_POTION_TAB1    PACKAGEITEM_ETC_ALL_SPOTION_01    26    -1    xxx    -1    xxx    -1    xxx    -1    xxx

For Vigors add the below Text into your Media.pk2! : [Media.PK2 SIDE]

refpackageitem.txt :

PHP Code:

1    15    84114    PACKAGE_ITEM_ETC_ALL_SPOTION_01    0    EXPAND_TERM_ALL    SN_ITEM_ETC_ALL_SPOTION_01    SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC    item\etc\all_spotion_01.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx

**ddj File location in worng because PHP Code removes \ So Change it to item\etc\all_spotion_01.ddj

refpricepolicyofitem.txt :

PHP Code:

1    15    PACKAGE_ITEM_ETC_ALL_SPOTION_01    1    0    20000    -1    xxx    -1    xxx    -1    xxx    -1    xxx

refscrapofpackageitem.txt :

PHP Code:

1    15    PACKAGE_ITEM_ETC_ALL_SPOTION_01    ITEM_ETC_ALL_SPOTION_01    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    86767

refshopgoods.txt :

PHP Code:

1    15    STORE_WC_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_SPOTION_01    26    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_KT_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_SPOTION_01    23    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_EU_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_SPOTION_01    27    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_CH_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_SPOTION_01    27    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_CA_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_SPOTION_01    25    -1    xxx    -1    xxx    -1    xxx    -1    xxx

We Finished Add Vigots into NPC :P !

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

*it will bee add to all Stable&Potions NPC's in each town!
Wolf Price = 2,000,000 and Vigors Price = 20,000 Each .

[Prices Can be changed but just make sure the price in refpricepolicyofitem will be the same as _RefPricePolicyOfItem Table!]

**Media Files location :

\server_dep\silkroad\textdata

***Make Sure that all the IDS are unique! and not duplicate!
[Watch refpackageitem.txt and refscrapofpackageitem To Make Sure!]

Anyway it supposed to take 10 minutes maximum! , Hope you find this usefull , if this is helpfull i will add a guides to add
All EU&China ITEMS 10D~11D~12D Into NPC Too.

Have A Nice Day , FallDown.

Re: [Release]How To Add Wolf&Vigors To NPC

thanks :)

Re: [Release]How To Add Wolf&Vigors To NPC

Ty so much bro <3

i added vigors to npc it's ok but when i want to buy 50 vigor with ctrl + mouse click or write 50 unit i getting dc how can i buy it with 50 unit on 1 click?

Re: [Release]How To Add Wolf&Vigors To NPC

oh lol , 1 sec i solve it for you

yea found it :D

_RefPricePolicyOfItem

its

PHP Code:

1 15 PACKAGE_ITEM_ETC_ALL_POTION_01 1 0 20000 0 xxx 0 xxx 0 xxx 0 xxx

and should be

PHP Code:

1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx

sorry about that :D [Just in SQL Change it!]

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by FallDown

oh lol , 1 sec i solve it for you

yea found it :D

_RefPricePolicyOfItem

its

PHP Code:

1 15 PACKAGE_ITEM_ETC_ALL_POTION_01 1 0 20000 0 xxx 0 xxx 0 xxx 0 xxx

and should be

PHP Code:

1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx

sorry about that :D [Just in SQL Change it!]

Ty so much bro i will try now.

Re: [Release]How To Add Wolf&Vigors To NPC

well this is tested as working so yea..
you welcome..

Re: [Release]How To Add Wolf&Vigors To NPC

still getting same error please help me.
I can buy 1 unit its ok but when i buy more than 1 unit getting game crash

Re: [Release]How To Add Wolf&Vigors To NPC

do you sure ? , did you changed as i said at server side ?

oh and path did you use item\etc\all_spotion_01.ddj ?

Re: [Release]How To Add Wolf&Vigors To NPC

from refpackage
PACKAGE_ITEM_ETC_ALL_SPOTION_01's ID : 84044
how can i change it to 84037
i cant change it with manual.

Re: [Release]How To Add Wolf&Vigors To NPC

you dont. just change in media!

Re: [Release]How To Add Wolf&Vigors To NPC

in media.pk2
_refpackageitem

1 15 84114 PACKAGE_ITEM_ETC_ALL_SPOTION_01 0 EXPAND_TERM_ALL SN_ITEM_ETC_ALL_SPOTION_01 SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC itemetcall_spotion_01.ddj -1 xxx -1 xxx -1 xxx -1 xxx

that 84114 will change to 84044?

FallDown can you make my all settings with TW?

Re: [Release]How To Add Wolf&Vigors To NPC

tnx sir,
can u add codes of stones? D11, to npc?
with elixirs

Re: [Release]How To Add Wolf&Vigors To NPC

its easy.. , just look at the stones from honor
and change payment device to 2 , its so easy..

you can use any item as a templete for items from his kind!
it took me 5 minutes to understand how its works so believe me its easy..

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by ajan05

still getting same error please help me.
I can buy 1 unit its ok but when i buy more than 1 unit getting game crash

happened to me too, any way to fix it?

Re: [Release]How To Add Wolf&Vigors To NPC

pl can u share table from mysql??

and thx alot for this

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by ajan05

still getting same error please help me.
I can buy 1 unit its ok but when i buy more than 1 unit getting game crash

could anyone tell me if this is a server or clientsided problem?

Re: [Release]How To Add Wolf&Vigors To NPC

thx so much

when i try i got this ERROR

Imageshack - 57290730.jpg

any idea about that ??

Re: [Release]How To Add Wolf&Vigors To NPC

I added the querys ok, but when I edited the pk2 txt files and imported any one of them back in, they crash my splash screen upon sro startup:?:

Re: [Release]How To Add Wolf&Vigors To NPC

I have add all txt files to SQL and Media.pk2
i can see in any potion npcs. But i can buy max 5unit. How can i change it?

RefPackageItem

Code:

1 15 85917 PACKAGE_ITEM_ETC_ALL_SPOTION_01 0 EXPAND_TERM_ALL SN_ITEM_ETC_ALL_SPOTION_01 SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC item\etc\all_spotion_01.ddj -1 xxx -1 xxx -1 xxx -1 xxx

RefPricePolicyOfITem

Code:

1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 2000 -1 xxx -1 xxx -1 xxx -1 xxx

RefScrapOfPackageItem

Code:

1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 ITEM_ETC_ALL_SPOTION_01 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 88569

RefShopGoods

Code:

1 15 STORE_CA_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 25 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 STORE_CH_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 STORE_EU_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 STORE_KT_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 23 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 STORE_WC_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 26 -1 xxx -1 xxx -1 xxx -1 xxx

RefObjItem

Code:

23 50 2 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 HP??? 25 HP???(%) 0 MP??? 25 MP???(%) -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 0 0 0

itemdata_5000

Code:

1 23 ITEM_ETC_ALL_SPOTION_01 ?? ?? ??? (?) xxx SN_ITEM_ETC_ALL_SPOTION_01 SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC 0 0 3 3 1 3 180000 3 0 1 1 1 255 3 1 0 0 1 0 1000 0 0 0 19 380 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_ch_bag.bsr item\etc\all_spotion_01.ddj xxx xxx 50 2 0 0 6 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0 0 0 0 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 HP??? 25 HP???(%) 0 MP??? 25 MP???(%) -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 0 0

Re: [Release]How To Add Wolf&Vigors To NPC

I ran the 4 queries and in all tables shows the wolf active with "1". I extracted and modified the pk2 files and copy/pasted the text to the bottom of each text file and imported them back in the media.pk2. Then I started the game and the wolf does not show up under tab 3 in any city. But I do see the wolf in hotan tab3. Is there something I may be overlooking? It's such an easy tutorial, yet it's not working for me:?:

Re: [Release]How To Add Wolf&Vigors To NPC

heyy guyz ,

About Adding the Files to Media.pk .. you cant just copy and past them to media ( as i think ) but you have to enter this Date one by one , you cant just cope and past all line .

it gives you More spaces between the Entries , u must click tab between every entry that you tube :)

now we have the problem of buying the Vigor from NPC i did not fined the correct solution for it yet .

hope to fine any one that can help :)

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by 3d2000

heyy guyz ,

About Adding the Files to Media.pk .. you cant just copy and past them to media ( as i think ) but you have to enter this Date one by one , you cant just cope and past all line .

it gives you More spaces between the Entries , u must click tab between every entry that you tube :)

I have been copy/paste then tab to line the columns up. I'll try to manually type in every line, but can you just add it to the bottom of the txt file?

Re: [Release]How To Add Wolf&Vigors To NPC

i will upload everything in .txt file so it wont get ruin okay ?

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by SL1MSH4DY

I have been copy/paste then tab to line the columns up. I'll try to manually type in every line, but can you just add it to the bottom of the txt file?

yes :)) (i think )

Re: [Release]How To Add Wolf&Vigors To NPC

FML I edited the pk2 manually with a tab between each column and manually imported them back into the pk2 and restarted the server and it still didn't work! Here's my text lines in each txt file. What's wrong with this?

refpackageitem.txt

http://i66.photobucket.com/albums/h2...ackageitem.jpg

refpricepolicyofitem.txt

http://i66.photobucket.com/albums/h2...licyofitem.jpg

refshopgoods.txt

http://i66.photobucket.com/albums/h2...fshopgoods.jpg

refscrapofpackageitem.txt

http://i66.photobucket.com/albums/h2...ackageitem.jpg

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by SL1MSH4DY

FML I edited the pk2 manually with a tab between each column and manually imported them back into the pk2 and restarted the server and it still didn't work! Here's my text lines in each txt file. What's wrong with this?

hope u like this

http://forum.ragezone.com/f722/relea...1/#post6702101

Re: [Release]How To Add Wolf&Vigors To NPC

I have the same problem "3d2000" Anyone know how to solve this as it did in the tutorial
error :
BSObj Plugin Sorry my english :D

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by 3d2000

thx so much

when i try i got this ERROR

Imageshack - 57290730.jpg

any idea about that ??

How have you this fix??

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by FreaQii

How have you this fix??

you may try This :)
http://forum.ragezone.com/f722/relea...1/#post6702101

Re: [Release]How To Add Wolf&Vigors To NPC

I have this all add in the SRO_VT_SHARD_INIT Database

Code:

(table)refshopgoods: 1 15 STORE_KT_SMITH_TAB1 PACKAGE_ITEM_CH_SPEAR_10_A 25 -1 xxx -1 xxx -1 xxx -1 xxx

Code:

(table)refpricepolicyofitem: 1 15 PACKAGE_ITEM_CH_SPEAR_10_A 1 0 4491000 -1 xxx -1 xxx -1 xxx -1 xxx

Code:

(table)refpackageitem: 1 15 84037 PACKAGE_ITEM_CH_SPEAR_10_A 0 EXPAND_TERM_ALL SN_ITEM_CH_SPEAR_10_A SN_ITEM_CH_SPEAR_10_A_TT_DESC item\china\weapon\spear_10.ddj -1 xxx -1 xxx -1 xxx -1 xxx

Code:

(table)refscrapofpackageitem: 1 15 PACKAGE_ITEM_CH_SPEAR_10_A ITEM_CH_SPEAR_10_A 0 0 78 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86685

But when I open for example the "refscrapofpackageitem" table again than can I not found the codes. :(: I would have added nothing!!!

I can the Server Start and too Connect without one error but I see not in the NPC SPEAR 10Degree. (I have too all add in the Media.pk2)

Re: [Release]How To Add Wolf&Vigors To NPC

http://forum.ragezone.com/f722/relea...-shops-791723/

you may check this :)

also .. can you plzz tell me how do u add them in your Data Base ??

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by 3d2000

http://forum.ragezone.com/f722/relea...-shops-791723/

you may check this :)

also .. can you plzz tell me how do u add them in your Data Base ??

Now I have fix DB problem & Media.pk2 problem too but when I start Silkroad Launcher and click Start come this error now.
http://img850.imageshack.us/img850/4725/errordp.png

Client is NOT modified.

3d2000 when you know TeamViewer you can show self.

Re: [Release]How To Add Wolf&Vigors To NPC

heyy broo ,, when you add Codes to your Media make Sure that the ID if the Itesm is unique .. alsoo is Identical to your Data base so you dont have any problems

NOte .. when you add the codes in your Media you have to use Tap separator ( dont use space in your media , just hit tap )

try it again :) GOOD luck ^^

Re: [Release]How To Add Wolf&Vigors To NPC

hello all i have this error help me please thank you very much
http://img851.imageshack.us/img851/1675/sanstitreui.png

Uploaded with ImageShack.us

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by vantuto

hello all i have this error help me please thank you very much

heyy broo ,, can you plzz tell us the what you did

you have to add the Correct code to all tables in your Database

so plzz tell me :)

Re: [Release]How To Add Wolf&Vigors To NPC

THANKS 3d2000 for the HELP
All WORK :)

Re: [Release]How To Add Wolf&Vigors To NPC

aloot of errors in ur topic !

4 Attachment(s)

Re: [Release]How To Add Wolf&Vigors To NPC

Has anyone managed to fix the client crash issue when buying more than 1 vigor?

Edit: The 'Data' flag in _RefScrapOfPackageItem needs to be set to 0 instead of 1.

This should work.

Code:

USE SRO_VT_SHARD GO --Wolf UPDATE [dbo].[_RefPackageItem] SET Service = 1 WHERE CodeName128 = 'PACKAGE_ITEM_COS_P_FLUTE' UPDATE [dbo].[_RefPricePolicyOfItem] SET Service = 1 WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE' UPDATE [dbo].[_RefScrapOfPackageItem] SET Service = 1 WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE' UPDATE [dbo].[_RefShopGoods] SET Service = 1 WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE' GO --Vigors SET IDENTITY_INSERT [dbo].[_RefPackageItem] ON INSERT [dbo].[_RefPackageItem] (Service, Country, ID, CodeName128, SaleTag, ExpandTerm, NameStrID, DescStrID, AssocFileIcon, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES('1', '15', '84037', 'PACKAGE_ITEM_ETC_ALL_SPOTION_01', '0', 'EXPAND_TERM_ALL', 'SN_ITEM_ETC_ALL_SPOTION_01', 'SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC', 'item\etc\all_spotion_01.ddj', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') SET IDENTITY_INSERT [dbo].[_RefPackageItem] OFF INSERT [dbo].[_RefPricePolicyOfItem] (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES('1', '15', 'PACKAGE_ITEM_ETC_ALL_SPOTION_01', '1', '0', '20000', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') SET IDENTITY_INSERT [dbo].[_RefScrapOfPackageItem] ON INSERT [dbo].[_RefScrapOfPackageItem] (Service, Country, RefPackageItemCodeName, RefItemCodeName, OptLevel, Variance, Data, MagParamNum, MagParam1, MagParam2, MagParam3, MagParam4, MagParam5, MagParam6, MagParam7, MagParam8, MagParam9, MagParam10, MagParam11, MagParam12, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128, [Index]) VALUES('1', '15', 'PACKAGE_ITEM_ETC_ALL_SPOTION_01', 'ITEM_ETC_ALL_SPOTION_01', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '86685') SET IDENTITY_INSERT [dbo].[_RefScrapOfPackageItem] OFF INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_CA_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_SPOTION_01', '25', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_CH_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_SPOTION_01', '27', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_EU_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_SPOTION_01', '27', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_KT_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_SPOTION_01', '23', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_WC_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_SPOTION_01', '26', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') GO

Re: [Release]How To Add Wolf&Vigors To NPC

I've added all parts needed to my database and media.pk2, and when I start my client it crashes before getting to login screen, anyone know how to resolve this issue?

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by Zenji

I've added all parts needed to my database and media.pk2, and when I start my client it crashes before getting to login screen, anyone know how to resolve this issue?

Same here

Re: How To Add Wolf&Vigors To NPC

in Database:
hi guys kinda new. im having trouble with how to add those codes _refpackage item in Database???
i cant find any _refpackage in my silkroads database i have extracted it but i cant find it.

Re: How To Add Wolf&Vigors To NPC

Thx WeeMan for ur querie and i change small things so vigor (X-Large) can be add it

PHP Code:

USE SRO_VT_SHARD GO --Vigors SET IDENTITY_INSERT [dbo].[_RefPackageItem] ON INSERT [dbo].[_RefPackageItem] (Service, Country, ID, CodeName128, SaleTag, ExpandTerm, NameStrID, DescStrID, AssocFileIcon, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES('1', '15', '84038', 'PACKAGE_ITEM_ETC_ALL_POTION_05', '0', 'EXPAND_TERM_ALL', 'SN_ITEM_ETC_ALL_POTION_05', 'SN_ITEM_ETC_ALL_POTION_05_TT_DESC', 'item\etc\all_potion_05.ddj', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') SET IDENTITY_INSERT [dbo].[_RefPackageItem] OFF INSERT [dbo].[_RefPricePolicyOfItem] (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES('1', '15', 'PACKAGE_ITEM_ETC_ALL_POTION_05', '1', '0', '20000', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') SET IDENTITY_INSERT [dbo].[_RefScrapOfPackageItem] ON INSERT [dbo].[_RefScrapOfPackageItem] (Service, Country, RefPackageItemCodeName, RefItemCodeName, OptLevel, Variance, Data, MagParamNum, MagParam1, MagParam2, MagParam3, MagParam4, MagParam5, MagParam6, MagParam7, MagParam8, MagParam9, MagParam10, MagParam11, MagParam12, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128, [Index]) VALUES('1', '15', 'PACKAGE_ITEM_ETC_ALL_POTION_05', 'ITEM_ETC_ALL_POTION_05', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '86686') SET IDENTITY_INSERT [dbo].[_RefScrapOfPackageItem] OFF INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_CA_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_POTION_05', '26', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_CH_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_POTION_05', '28', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_EU_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_POTION_05', '28', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_KT_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_POTION_05', '24', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') INSERT [dbo].[_RefShopGoods] VALUES('1', '15', 'STORE_WC_POTION_TAB1', 'PACKAGE_ITEM_ETC_ALL_POTION_05', '27', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx', '-1', 'xxx') GO

media.pk2
---------------refpackageitem.txt

PHP Code:

1    15    84037    PACKAGE_ITEM_ETC_ALL_POTION_05    0    EXPAND_TERM_ALL    SN_ITEM_ETC_ALL_POTION_05    SN_ITEM_ETC_ALL_POTION_05_TT_DESC    item\etc\all_potion_05.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx

--------------refpricepolicyofitem.txt

PHP Code:

1    15    PACKAGE_ITEM_ETC_ALL_POTION_05    1    0    1150    0    xxx    0    xxx    0    xxx    0    xxx

-------------refscrapofpackageitem.txt

PHP Code:

1    15    PACKAGE_ITEM_ETC_ALL_POTION_05    ITEM_ETC_ALL_POTION_05    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    86685

-------------refshopgoods.txt

PHP Code:

1    15    STORE_CA_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_POTION_05    26    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_CH_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_POTION_05    28    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_EU_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_POTION_05    28    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_KT_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_POTION_05    24    -1    xxx    -1    xxx    -1    xxx    -1    xxx 1    15    STORE_WC_POTION_TAB1    PACKAGE_ITEM_ETC_ALL_POTION_05    27    -1    xxx    -1    xxx    -1    xxx    -1    xxx

Re: How To Add Wolf&Vigors To NPC

i added it, working fine, just while they are in shop it shows no icon, but after buying them, icon shows up, any ideas?

Re: How To Add Wolf&Vigors To NPC

Hello all i got error same you have 3d2000 so if you fixed it please try to pm me . :)

Re: How To Add Wolf&Vigors To NPC

Nice one !

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by nikluetke

could anyone tell me if this is a server or clientsided problem?

i got same error !

Re: How To Add Wolf&Vigors To NPC

Hello !

Re: How To Add Wolf&Vigors To NPC

:x:x:x:x

Re: How To Add Wolf&Vigors To NPC

how to fix when i buy 50 vigors i get dc :/

Re: How To Add Wolf&Vigors To NPC

u need edit media.pk2 and db

Re: How To Add Wolf&Vigors To NPC

and what exactly ?

Re: [Release]How To Add Wolf&Vigors To NPC

Quote:

Originally Posted by 3d2000

thx so much

when i try i got this ERROR

Imageshack - 57290730.jpg

any idea about that ??

Same error. Please help!!!

EDIT: Fixed. Price aren't showing on wolf.