الموقع العربي الاول للعبة Silkroad Online

[QUOTE='GM] COMNDs];5060307'][SIZE="5"][FONT="Georgia"][COLOR="Blue"]زى ما بتحوط اى ايتم فى 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!' [/PHP]
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)

/*for _RefObjCommon Price*/
UPDATE _RefObjCommon SET Price = @yourPrice WHERE ID = @ItemID

/* 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!' [/PHP]
لو معرفتش بردو شوف دول
[URL="http://www.silkroad4arab.com/vb/showthread.php?p=4262613"][SIZE="4"][FONT="Comic Sans MS"][COLOR="Red"]شرح كيفية اضافة NPC[/COLOR][/FONT][/SIZE][/URL]
[URL="http://www.youtube.com/watch?v=UybLu8Bz11g"][COLOR="Crimson"][SIZE="4"][FONT="Comic Sans MS"]شرح كيفية اضافة NPC فديو[/FONT][/SIZE][/COLOR][/URL]

لو فى مشكلة كلمنى 
!Yahoo[/COLOR][/FONT][/SIZE][/QUOTE]

الخيارات الإضافية
الخيارات المتنوعة تفعيل الروابط تلقائيآ في المشاركة تقييم الموضوع إذا أردت, تستطيع إضافة تقييم لهذا الموضوع.

07-06-2014 11:13 PM
GM] COMNDs]	زى ما بتحوط اى ايتم فى 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!' لو معرفتش بردو شوف دول شرح كيفية اضافة NPC شرح كيفية اضافة NPC فديو لو فى مشكلة كلمنى !Yahoo
07-06-2014 10:59 PM
ToOoOoT	مفيش افاتارات جديدة!؟ عايز ملفات افاتارات جديدة انا بعرف اضيف الافاتار وكلة تمام بس ناقصني حاجة واحدة بس اني احطة في ان بي سي! شكرا

ضوابط المشاركة
تستطيع إضافة مواضيع جديدة تستطيع الرد على المواضيع تستطيع إرفاق ملفات تستطيع تعديل مشاركاتك BB code متاحة الابتسامات متاحة كود [IMG] متاحة كود HTML معطلة قوانين المنتدى

ضوابط المشاركة

تستطيع إضافة مواضيع جديدة

تستطيع الرد على المواضيع

تستطيع إرفاق ملفات

تستطيع تعديل مشاركاتك

BB code متاحة

الابتسامات متاحة

كود [IMG] متاحة

كود HTML معطلة

قوانين المنتدى

	ط§ظ„ط¨ظ‚ط§ط، ظ…ط³ط¬ظ„ ط¯ط§ط¦ظ…ط¢

الـجـروب الـرسـمـي لـلـمـنـتـدى Silkroad4arab Facebook | Official Group