زى ما بتحوط اى ايتم فى NPC
لو مبتعرفش
جرب ال Query دى
كود PHP:
USE SRO_VT_SHARD /* ITEMS TO NPC FOR GOLD by Caipi */ Declare @ItemID int Declare @yourPrice int Declare @WhichTAB varchar(74)
SET @ItemID = 39495 /* The Item ID of the Item you want to add to the NPC*/ --## <-- SET @yourPrice = 50 /* The price per Unit */ --## <-- SET @WhichTAB = 'STORE_ST_CH_CLOSEH_TAB1' /* 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_'+@newItemID+'.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,NameStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,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 = 1 AND Cost = @yourPrice) BEGIN print 'Already added @ RefPricePolicyOfItem/.txt!' END ELSE BEGIN INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_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,RefPackageItemCodeName,SlotIndex,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128) 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,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) VALUES (1,15,'PACKAGE_'+@CodeName,@CodeName,8,1073741823,140,2,30064771144,30064771150,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+' 8 1073741823 140 2 30064771144 30064771150 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!'
OR
كود PHP:
USE SRO_VT_SHARD /* ITEMS TO NPC FOR GOLD by Caipi */ Declare @ItemID int Declare @yourPrice int Declare @WhichTAB varchar(74)
SET @ItemID = 23 /* The Item ID of the Item you want to add to the NPC*/ --## <-- SET @yourPrice = 5000 /* The price per Unit */ --## <-- SET @WhichTAB = 'STORE_CH_POTION_TAB1' /* 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_'+@newItemID+'.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,NameStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,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 = 1 AND Cost = @yourPrice) BEGIN print 'Already added @ RefPricePolicyOfItem/.txt!' END ELSE BEGIN INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_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,RefPackageItemCodeName,SlotIndex,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128) 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,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) 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!'
لو معرفتش بردو شوف دول
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
07-06-2014, 10:59 PM
![الصورة الرمزية GM] COMNDs]](image.php?s=fb0a9f7714682f62462b76ac6fa7f96a&u=117095&dateline=1396717221)
المواضيع المتشابهه
.gif){kind=icon}
العرض العادي
