[VSRO] Add Vigors to NPC

01/24/2012 06:57 ffflashgamerrr#1
Hey Guys,
i just wanna know,
how can i add vigor potions to the NPC ?
04/08/2012 00:34 ique4ever#2
yea me too --'
04/08/2012 03:08 SunSoon#3
in DB

Table Name : _RefPackageItem
Quote:
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 itemetcall_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
Quote:
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx
Table Name : _RefScrapOfPackageItem
Quote:
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
Quote:
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
In Media Now..


refpackageitem.txt :

Quote:
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
**ddj File location is item\etc\all_spotion_01.ddj with \

refpricepolicyofitem.txt :
Quote:
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx

refscrapofpackageitem.txt :
Quote:
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 :
Quote:
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
04/08/2012 06:21 zChopper#4
It's fairly easy to be honest, use the guide above and ferrrsure you can do it ;o.
01/30/2013 01:30 1337Demon#5
I Got this error while trying add a code to _RefPricePolicyOfItem Table

[Only registered and activated users can see links. Click Here To Register...]
01/30/2013 01:48 fantasiaroad#6
Just read what it says :

cannot insert DUPLICATE key in object refpricepolicyofitem

Means, the thing you wanna add is already in refpricepolicyofitem.

Use this query to find it -->

Select * from dbo._RefpricePolicyOfItem
where RefPackageItemCodeName like
'%PACKAGE_ITEM_ETC_ALL_SPOTION%'

So, seems to be its already into the db, If its so you'll get a line when you use this query.
So you can just add a new line on refshopgoods.

1 15 STORE_CA_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 25 -1 xxx -1 xxx -1 xxx -1 xxx

Change the red part for the NPC
Change the blue part for the item spot, they start on 0, so should be, 0/1/2/3/4/5/6 etc.


Enjoy!
01/30/2013 17:05 1337Demon#7
Yes thanks for this its work fine , i got error when i trying to open SR_Gameserver its get more errors have a solution ???
please help me !


[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

Please help me fast .... pm me :(
01/30/2013 17:16 Zodiao#8
Quote:
Table Name : _RefShopGoods
Quote:
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
replace
PACKAGITEM
with PACKAGE_ITEM


Regards
01/30/2013 22:58 1337Demon#9
yea its works but while i try to open the sro_client its close why ? can you help me ?

Please don't forget pm me fast !
01/30/2013 23:33 Snow*#10
Quote:
Originally Posted by 1337Demon View Post
yea its works but while i try to open the sro_client its close why ? can you help me ?

Please don't forget pm me fast !
If everything is fine @ the DB, so you made something wrong in the media.pk2 lines, check them again.
01/31/2013 17:22 Zodiao#11
Right click on Database > Tasks > backup > Ok
01/31/2013 18:41 1337Demon#12
Thanks very much Sir Evil :)

So i have 3 errors , 1- I Got bug while try to buy vigor more than 1 unit , 2- How to make update for game , 3- How to write Notices In Client

Guys how to add Avatar Assassian and fox and mummy and Santa In vSRO Files please answer

Hi

Hurry up please Sir Evil

Hi bro please hurry up

Please any one answer !!!!!!!!!1

fantasiaroad why vigor when i bought from npc more than 1 unit i got bug ? please answer me

Hello !!!!!!!!!!!!!!!!!!!!!!!!!!!

I HAVE THIS ERROR ! WHILE TRYING TO BUY MORE THAN 1 UNIT I GOT BUG PLEASE ANY HELP OR Solution ?
02/02/2013 00:25 1337Demon#13
Hi !
06/01/2014 21:27 LyNx_76#14
Thnx for your effort bro it worked fine with me but i get this crash whenever i buy more than one vigor from the npc , can you help me out in this :)
04/22/2020 03:20 xmenx3n#15
Quote:
Originally Posted by SunSoon View Post
in DB

Table Name : _RefPackageItem


Table Name : _RefPricePolicyOfItem


Table Name : _RefScrapOfPackageItem


Table Name : _RefShopGoods


In Media Now..


refpackageitem.txt :



**ddj File location is item\etc\all_spotion_01.ddj with \

refpricepolicyofitem.txt :



refscrapofpackageitem.txt :


refshopgoods.txt :
thanks for sharing but there are some errors:
Table Name : _RefScrapOfPackageItem
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

change 1 to 0 to fix bug crash " can't buy more than 1 vigor from npc "
86685 change it to the max+1 of your RefScrapOfPackageItem Table and make sure that the RefScrapOfPackageItem.txt the same number

RefShopGoods:
Change PACKAGEITEM To PACKAGE_ITEM for each line

thanke you :)