[VSRO] Add Vigors to NPC

[ffflashgamerrr]

Hey Guys,
i just wanna know,
how can i add vigor potions to the NPC ?

[ique4ever]

yea me too --'

[SunSoon]

in DB

Table Name : _RefPackageItem

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

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

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

Table Name : _RefShopGoods

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 :

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 :

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

refscrapofpackageitem.txt :

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 :

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

[zChopper]

It's fairly easy to be honest, use the guide above and ferrrsure you can do it ;o.

[1337Demon]

I Got this error while trying add a code to _RefPricePolicyOfItem Table

[fantasiaroad]

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 *** -1 *** -1 *** -1 ***

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!

[1337Demon]

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 !












Please help me fast .... pm me

[Zodiao]

Table Name : _RefShopGoods
Quote:
1 15 STORE_CA_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 25 -1 *** -1 *** -1 *** -1 ***
1 15 STORE_CH_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 27 -1 *** -1 *** -1 *** -1 ***
1 15 STORE_EU_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 27 -1 *** -1 *** -1 *** -1 ***
1 15 STORE_KT_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 23 -1 *** -1 *** -1 *** -1 ***
1 15 STORE_WC_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 26 -1 *** -1 *** -1 *** -1 ***

replace
PACKAGITEM
with PACKAGE_ITEM


Regards

[1337Demon]

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 !

[Snow*]

Originally Posted by 1337Demon

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.

[Zodiao]

Right click on Database > Tasks > backup > Ok

[1337Demon]

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 ?

[1337Demon]

Hi !

[LyNx_76]

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

[xmenx3n]

Originally Posted by SunSoon

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 *** -1 *** -1 *** -1 *** 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