-
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
-
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
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
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
-
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
-
Re: How To Add Wolf&Vigors To NPC
-
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
-
Re: [Release]How To Add Wolf&Vigors To NPC
Quote:
Originally Posted by
3d2000
Same error. Please help!!!
EDIT: Fixed. Price aren't showing on wolf.