How To Add Wolf&Vigors To NPC

[3d2000]

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

[vidalokajr]

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

[FreaQii]

thx so much

when i try i got this ERROR

Imageshack - 57290730.jpg

any idea about that ??

How have you this fix??

[3d2000]

How have you this fix??

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

[FreaQii]

I have this all add in the SRO_VT_SHARD_INIT Database

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

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

(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

(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)

[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 ??

[FreaQii]

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.


Client is NOT modified.

3d2000 when you know TeamViewer you can show self.

[3d2000]

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 ^^

[vantuto]

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


Uploaded with ImageShack.us

[3d2000]

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 :)

[FreaQii]

THANKS 3d2000 for the HELP
All WORK :)

[Oventiful]

aloot of errors in ur topic !

[WeeMan]

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.

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

[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?

[ducker997]

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

[jibwafu]

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.

[na9er]

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

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

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

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

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

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

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 

[GhosTsReapeR]

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

[Hypo]

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

[Hypo]

Nice one !

[Hypo]

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

i got same error !

[Hypo]

Hello !

[HoNoR Kal]

:x:x:x:x

[Serif94]

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

[anikan1985]

u need edit media.pk2 and db