|
You last visited: Today at 22:48
Advertisement
Items has no price at npc !!
Discussion on Items has no price at npc !! within the SRO Private Server forum part of the Silkroad Online category.
07/17/2014, 04:25
|
#1
|
elite*gold: 0
Join Date: Jun 2014
Posts: 90
Received Thanks: 40
|
Items has no price at npc !!
hello Epvp
i've added power items at npc but after adding it i've faced a little problem ..
you can see the problem through the following screen shot ..
Some items has no price at npc .. that error is in EU Sets Only ..
|
|
|
07/17/2014, 05:07
|
#2
|
elite*gold: 0
Join Date: Mar 2014
Posts: 72
Received Thanks: 38
|
So UnitedSro comming soon?
|
|
|
07/17/2014, 05:51
|
#3
|
elite*gold: 0
Join Date: Jun 2014
Posts: 90
Received Thanks: 40
|
Quote:
Originally Posted by Emboiment
So UnitedSro comming soon?
|
-_-
|
|
|
07/17/2014, 06:01
|
#4
|
elite*gold: 0
Join Date: Aug 2012
Posts: 748
Received Thanks: 227
|
Self explaining >.>
RefPricePolicyofItem.txt
|
|
|
07/17/2014, 07:02
|
#5
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
did you checked refprice ( Clinet & media side ) ?
|
|
|
07/17/2014, 16:20
|
#6
|
elite*gold: 0
Join Date: May 2007
Posts: 125
Received Thanks: 22
|
i have this problem when i put 4 or 5 payment method if you have 4-5 try to put 1 and see if work. also check refprice on client side.
|
|
|
07/17/2014, 21:49
|
#7
|
elite*gold: 0
Join Date: Jun 2014
Posts: 90
Received Thanks: 40
|
1- i've 1 payment method
2- i copied lines from database (refpricepolicyofitem)
3- still have same problem .. its only on Legs,head,foot,shoulder EU (H.a & L.a Only)
any help ?
|
|
|
07/18/2014, 05:08
|
#8
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
Upload ur Refprice DB & media line for those items ..
try to remvoe those items from refpackage / refscrap / refprice / refshopgood db & media side
this query will give you the media lines to
just replace the empty space from spaces to "tabs" & put in media
and readd them using this one !
( working by item id from refobjectcommon )
Quote:
USE SRO_VT_SHARD /* ITEMS TO NPC FOR GOLD by Caipi */
Declare @ItemID int
Declare @yourPrice int
Declare @WhichTAB varchar(74)
SET @ItemID = 42158 /* The Item ID of the Item you want to add to the NPC*/ --## <--
SET @yourPrice = 1 /* The price per Unit */ --## <--
SET @WhichTAB = 'STORE_STATIIC_TABG1' /* To which Tab at which NPC you want to add the Item*/
/* Codename instead of the ID */
Declare @CodeName varchar (74) SET @CodeName = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @ItemID)
/* Which Itemdata.txt is affected in the Media.pk2*/
Declare @newItemID varchar(5)
Declare @lastPrice varchar(25) SET @lastPrice = (SELECT Price FROM _RefObjCommon WHERE ID = @ItemID)
Declare @yourPriceCHAR varchar(25) SET @yourPriceCHAR = @yourPrice
IF (@ItemID < 5000) SET @newItemID = 5000
else if (@ItemID < 10000) SET @newItemID = 10000
else if (@ItemID < 15000) SET @newItemID = 15000
else if (@ItemID < 20000) SET @newItemID = 20000
else if (@ItemID < 25000) SET @newItemID = 25000
else if (@ItemID < 30000) SET @newItemID = 30000
else if (@ItemID < 35000) SET @newItemID = 35000
else if (@ItemID < 40000) SET @newItemID = 40000
else SET @newItemID = 45000
print ''
print @CodeName + ' from Media\server_dep\silkroad\textdata\itemdata_'+@new ItemID+'.txt'
print 'Change the current Price of '+@lastPrice+' to '+@yourPriceCHAR+' at the itemdata_'+@newItemID+'. (For the visual Price ingame)'
/*END which Itemdata.txr*/
/*for _RefObjCommon Price*/
UPDATE _RefObjCommon SET Price = @yourPrice WHERE ID = @ItemID
/* for _RefPackageItem */
IF EXISTS (SELECT CodeName128 FROM _RefPackageItem WHERE CodeName128 = 'Package_'+@CodeName)
BEGIN
print 'Already added @ RefPackageItem/.txt!'
END
ELSE BEGIN
Declare @SN varchar(74) SET @SN = (SELECT NameStrID128 FROM _RefObjCommon WHERE ID = @ItemID)
Declare @DESC varchar(74) SET @Desc = (SELECT DescStrID128 FROM _RefObjCommon WHERE ID = @ItemID)
Declare @DDJ varchar(74) SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID = @ItemID)
INSERT INTO _RefPackageItem (Service,Country,CodeName128,SaleTag,ExpandTerm,Na meStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc 128,Param2,Param2_Desc128,Param3,Param3_Desc128,Pa ram4,Param4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,0,'EXPAND_TERM_ALL',@SN ,@Desc,@DDJ,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @TOPID varchar (10) SET @TOPID = (SELECT MAX(ID) FROM _RefPackageItem)
print ''
print 'Add the following line @ refpackageitem.txt'
print '1 15 '+@TOPID+' PACKAGE_'+@CodeName+' 0 EXPAND_TERM_ALL '+@SN+' '+@DESC+' '+@DDJ+' -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
/* for _RefPricePolicyOfItem */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND PaymentDevice = 2 AND Cost = @yourPrice)
BEGIN
print 'Already added @ RefPricePolicyOfItem/.txt!'
END
ELSE BEGIN
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDev ice,PreviousCost,Cost,Param1,Param1_Desc128,Param2 ,Param2_Desc128,Param3,Param3_Desc128,Param4,Param 4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,1,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @NEWPRICE varchar(15) SET @NEWPRICE = @yourPrice
print ''
print 'Add the following line @ refpricepolicyofitem.txt'
print '1 15 PACKAGE_'+@CodeName+' 1 0 '+@NEWPRICE+' -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
/* for _RefShopGoods */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefTabCodeName = @WhichTAB)
BEGIN
print 'Already added @ RefShopGoods/.txt!'
END
ELSE BEGIN
Declare @newSLOTINDEX varchar(15) SET @newSLOTINDEX = (SELECT MAX(SlotIndex) FROM _RefShopGoods WHERE RefTabCodeName = @WhichTAB)+1
INSERT INTO _RefShopGoods (Service,Country,RefTabCodeName,RefPackageItemCode Name,SlotIndex,Param1,Param1_Desc128,Param2,Param2 _Desc128,Param3,Param3_Desc128,Param4,Param4_Desc1 28)
VALUES (1,15,@WhichTAB,'PACKAGE_'+@CodeName,@newSLOTINDEX ,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
print ''
print 'Add the following line @ refshopgoods.txt'
print '1 15 '+@WhichTAB+' '+'PACKAGE_'+@CodeName+' '+@newSLOTINDEX+' -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
/* for _RefScrapOfPackageItem */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefItemCodeName = @CodeName)
BEGIN
print 'Already added @ RefScrapOfPackageItem/.txt!'
END
ELSE BEGIN
INSERT INTO _RefScrapOfPackageItem (Service,Country,RefPackageItemCodeName,RefItemCod eName,OptLevel,Variance,Data,MagParamNum,MagParam1 ,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6 ,MagParam7,MagParam8,MagParam9,MagParam10,MagParam 11,MagParam12,Param1,Param1_Desc128,Param2,Param2_ Desc128,Param3,Param3_Desc128,Param4,Param4_Desc12 8)
VALUES (1,15,'PACKAGE_'+@CodeName,@CodeName,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @ScrapIndex varchar(15)
SET @ScrapIndex = (SELECT MAX([Index]) FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)
print ''
print 'Add the following line @ refscrapofpackageitem.txt'
print '1 15 '+'PACKAGE_'+@CodeName+' '+@CodeName+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx '+@ScrapIndex
print ''
END
print ''
print ''
print 'Done!'
|
Query to get item id
Quote:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_MALL_AVATAR_NASRUN'
|
|
|
|
|
Similar Threads
|
Price for these items?
08/29/2012 - Dekaron - 3 Replies
Hi :) Let's say I have ... a gm char. With some cool stuff on it. Do you know the price for these items? Please be serious lol :D
10% pk/pvp damage tolerance
10% movement speed gem
10% critical resistance gem
Vado Morie
Kona Robin
Hellion's Seal
Items are on siz. Oh and yea, how much do 60% talismans worth?
|
How i can change the price of NPC items, or to add new items ?
02/14/2011 - SRO Private Server - 3 Replies
As the title says, i want to know how i can change the price of NPC items or to add silk items to npc :) ( private servers ). Thank You.
|
Selling price of items
01/19/2011 - Flyff Private Server - 2 Replies
Ok guys,
I am probably to stupid for this, but I can edit alot... though I cannot find the string where to put the price of an item you sell to a NPC...
for example, at the lvl 15 quest, I get a reskill, when I sell this to an NPC, I get 7.5 mil... which is kind of way too much.
I would like to change that on my server, but I cannot find how / where.
After a search on the forum, I still didn't find any usefull answers.
Anyone any ideas where to change the sell price?
|
All times are GMT +2. The time now is 22:48.
|
|