[Release]Finally Working Codes for Vigor and Wolf to NPC

[3d2000]

First i like to Say thanks to Mr ( FallDown ) he helped a lot with his Release (http://forum.ragezone.com/f722/relea...rs-npc-796990/)

i tried them but i fined Some Errors to my files to i got the solution for them and here it is

Notes :

1- before you edit in any thing you have to make Some backup from your Database and your media.
2- when you edit in your media .dont make Spaces between your DATA . just hit ( tab ) from your Key board .. dont hit space

Adding Wolf to NPC ( we assume that your media have the correct .ddj file )

first we need to update your Data bass to make it Working .. we may use whose Quires ( from FallDown )

Update _RefPackageItem 
SET Service = 1 
WHERE CodeName128 = 'PACKAGE_ITEM_COS_P_FLUTE'

Update _RefPricePolicyOfItem 
SET Service = 1 
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'  

Update _RefScrapOfPackageItem 
SET Service = 1 
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'  

Update _RefShopGoods 
SET Service = 1 
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE' 

that is with SQL

second we need to add the correct code to your media
from refpackageitem.txt :

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\item_cos_p_flute.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx 

from RefPricePolicyOfItem.txt

1    15    PACKAGE_ITEM_COS_P_FLUTE    1    0    2000000    0    xxx    0    xxx    0    xxx    0    xxx 

from RefScrapOfPackageItem.txt

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 

from Refshopgoods.txt

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 

this Txt files from my working media so plzz dont say it dose not Working . if it is that meas you did some thing Wrong.

Adding Vigor

from your Data base you may inter this data bu your hand into your Data base

from table name _RefPackageItem inter this

1    15    84038    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 

from table name _RefPricePolicyOfItem

1    15    PACKAGE_ITEM_ETC_ALL_SPOTION_01    1    0    5000    0    xxx    0    xxx    0    xxx    0    xxx 

from table name _RefScrapOfPackageItem

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 

from table name _RefShopGoods

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 

now with Media PK

from RefPackageItem.txt

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 

from RefPricePolicyOfItem.txt

1    15    PACKAGE_ITEM_ETC_ALL_SPOTION_01    1    0    5000    0    xxx    -1    xxx    -1    xxx    -1    xxx 

from 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 

form 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 

now it is Done

Note:

read well guyz and make it Write with out any spacing or any wrong letters

ddj File location in worng because PHP Code removes \ So Change it to item\etc\all_spotion_01.ddj . this is must be Done

in this Release i solved the problem when buying 50 unite Vigor you got DC or the game got Crashed



if you got any Problems plss say it :))

good luck guyz :D

((thanks so much RageZone you helped me a lot :D

thanks mr Mohamed Mossa ))

[MentaL]

[iDarren]

Help me too !

What thing hapening with the Impage

[BadFist]

working but when i want to buy a stok 50 vigor i can buy only 5 and i ricive d/c after i log in in game i have 5 vigor each individual not 5 vigor stok who i can fix theat?

[iDarren]

This Screenshot by Lightshot

[3d2000]

working but when i want to buy a stok 50 vigor i can buy only 5 and i ricive d/c after i log in in game i have 5 vigor each individual not 5 vigor stok who i can fix theat?

if you use my files and codes .. just Restart your server to reconnect server with new data base :))

This Screenshot by Lightshot

i really dont know .. sorry :))

[arabianfox]

Many thanks

[Naty48]

the problem with buying 50 is just -1 instead of 0 in
RefScrapOfPackageItem.txt thats it , thanks anyway :D

[3d2000]

the problem with buying 50 is just -1 instead of 0 in
RefScrapOfPackageItem.txt thats it , thanks anyway :D

i copied those text from my Data and my Media :))

dose it make any Deference between different Servers and different Databases
i really Dont know

[Romochild]

On my files this worked with out me having to do anything... odd.

[ByMaSTeRr]

dog was vigor not

[3d2000]

dog was vigor not

i am sorry what do say ??

[vista1]

hard work

[SL1MSH4DY]

Could you upload your actual text files for the wolf? It still won't work for me and I've checked everything. Maybe I am importing them wrong in media.pk2?

Edit: I must be importing them wrong manually. It says successful, but then I extract it and the changes I made aren't in the text files. So is there a specific way to manually import these files? I'm going to look around at the moment.

Edit2: GOT IT! HAHAHA Finally :)

[3d2000]

:)) GOOD luck bro :D

[SL1MSH4DY]

What about white wolf to npc?

Edit: Got it in the npc but when I buy it, takes my gold, but i dont get it and DC. Looking into the problem.