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 ??
Printable View
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.
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 ^^
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
THANKS 3d2000 for the HELP
All WORK :)
aloot of errors in ur topic !
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
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?
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.
Thx WeeMan for ur querie and i change small things so vigor (X-Large) can be add it
media.pk2PHP 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
---------------refpackageitem.txt
--------------refpricepolicyofitem.txtPHP 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
-------------refscrapofpackageitem.txtPHP Code:1 15 PACKAGE_ITEM_ETC_ALL_POTION_05 1 0 1150 0 xxx 0 xxx 0 xxx 0 xxx
-------------refshopgoods.txtPHP 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
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
i added it, working fine, just while they are in shop it shows no icon, but after buying them, icon shows up, any ideas?
Hello all i got error same you have 3d2000 so if you fixed it please try to pm me . :)
Nice one !