شـريـط الاهـداءات | |
قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة [ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ] |
|
أدوات الموضوع | انواع عرض الموضوع |
20-02-2013, 11:38 PM | #1 | ||||||||||||
|
عله سيلك رود ازاي تضيف avatar بل Query كود بلغة HTML:
USE SRO_VT_SHARD_INIT -- SRO_VT_SHARD_INIT = database name GO SELECT Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link FROM dbo._RefObjCommon WHERE (CodeName128 LIKE 'ITEM_MALL_AVATAR_%_NAME%') -- Ex:'ITEM_MALL_AVATAR_%_DRAGONDRESS%' GROUP BY Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link You will have to add it in _RefObjCommon and _RefObjItem using this query i made: Code: كود بلغة HTML:
USE SRO_VT_SHARD_INIT GO BEGIN Declare @CodeName1 varchar(129) Declare @CodeName2 varchar(129) Declare @Type1 varchar(129) Declare @Type int Declare @Gender1 varchar(129) Declare @Gender int END SET @CodeName1 = 'AVATAR_M_DRAGONDRESS' --- @Type = DRESS/ HAT/ ATTACH SET @CodeName2= 'avatar_m_dragondress' --- @Gender = MALE/ FEMALE SET @Type1 = 'DRESS' SET @Gender1 = 'MALE' /* Query for _RefObjCommon */ IF (@Type1 = 'HAT' OR @Type1 = 'DRESS' OR @Type1 = 'ATTACH') IF (@Type1 = 'DRESS') BEGIN SET @Type = '3' END IF (@Type1 = 'HAT') BEGIN SET @Type = '1' END IF (@Type1 = 'ATTACH') BEGIN SET @Type = '2' END BEGIN Declare @CodeName varchar(129) Set @CodeName = 'ITEM_MALL_' + @Codename1 Declare @SN varchar(74) SET @SN = 'SN_' +@CodeName Declare @DESC varchar(74) SET @DESC = @SN + '_TT_DESC' Declare @BSR1 varchar(129) SET @BSR1 = 'item\avatar\'+ @CodeName2 + '.bsr' Declare @BSR2 varchar(129) SET @BSR2 = 'item\etc\drop_ch_eventbox.bsr' Declare @DDJ varchar(74) SET @DDJ = 'Premium\Avatar\' + @CodeName2 + '.ddj' Declare @ObjectName varchar(129) SET @ObjectName = '??? ?? (?)' Declare @ObjectName1 varchar(129) SET @ObjectName1 = '[?,?,?,?,?,??]' Declare @ObjectName2 varchar(129) SET @ObjectName2 = '[?,??]' Declare @ObjectName3 varchar(129) SET @ObjectName3 = '[??,??]' Declare @AssocFile varchar(129) SET @AssocFile = 'xxx' Declare @Link int SET @Link = (SELECT MAX(Link)+1 FROM _RefObjCommon) Declare @ID int SET @ID = (SELECT MAX(Link)+1 FROM _RefObjCommon) END BEGIN INSERT INTO _RefObjCommon(Service,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,Canbuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES (1,@CodeName,@ObjectName,@AssocFile,@SN,@DESC,1,0,3,1,13,@Type,180000,3,0,0,1,1,159,1,1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,@BSR1,@BSR2,@DDJ,@AssocFile,@AssocFile,@Link) END /* Query for _RefObjItem */ IF (@Gender1 = 'MALE' OR @Gender1 = 'FEMALE') IF (@Gender1 = 'MALE') BEGIN SET @Gender = '1' END IF (@Gender1 = 'FEMALE') BEGIN SET @Gender = '0' END IF (@Type1 = 'HAT' OR @Type1 = 'DRESS' OR @Type1 = 'ATTACH') IF (@Type1 = 'DRESS') BEGIN INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link) VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,574,@ObjectName1,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,4,1,0) END IF (@Type1 = 'HAT') BEGIN INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link) VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,513,@ObjectName2,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,2,0,0) END IF (@Type1 = 'ATTACH') BEGIN INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link) VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,1280,@ObjectName3,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,1,0,0) END print '' print 'The query executed successfully.' print '' print ' Query made By mneam001.' _RefPackageItem _RefPricePolicyOfItem _RefScrapOfPackageItem _RefShopGoods كود بلغة HTML:
USE SRO_VT_SHARD_INIT GO Declare @CodeName varchar (74) Declare @yourPrice int Declare @WhichTAB varchar(74) SET @CodeName = 'ITEM_MALL_AVATAR_W_BLUE_SOULKNIGHT_ATTACH' /* The Spawncode of the item you want to add */ SET @yourPrice = 130 /* Silkprice */ SET @WhichTAB = 'MALL_AVATAR_ATTACH' /* To which Tab of the Item Mall do you want to add the Item*/ Declare @Data varchar(15) SET @Data = '0' /*Leave '0' as long as you're adding Avatars - otherwise Quantity of Item*/ IF exists(SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = @CodeName) BEGIN /*Only Avatar Tabs possible at the moment*/IF (@WhichTAB = 'MALL_AVATAR_ATTACH' OR @WhichTAB = 'MALL_AVATAR_DRESS' OR @WhichTAB = 'MALL_AVATAR_HAT') /*To make sure that the Tab is correct (in order to missspellings)*/ BEGIN /* Codename instead of the ID */ Declare @ItemID int SET @ItemID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @CodeName) /* Which Itemdata.txt is affected in the Media.pk2*/ Declare @newItemID varchar(5) 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 '' /*END which Itemdata.txt*/ /* for _RefPackageItem */ IF EXISTS (SELECT CodeName128 FROM _RefPackageItem WHERE CodeName128 = 'Package_'+@CodeName) BEGIN Declare @SN1 varchar(74) SET @SN1 = (SELECT NameStrID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName) Declare @DESC1 varchar(74) SET @Desc1 = (SELECT DescStrID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName) Declare @DDJ1 varchar(74) SET @DDJ1 = (SELECT AssocFileIcon FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName) Declare @TOPID1 varchar (10) SET @TOPID1 = (SELECT ID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName) print '##Check the following lines @ refpackageitem.txt!' print '1 15 '+@TOPID1+' PACKAGE_'+@CodeName+' 0 EXPAND_TERM_ALL '+@SN1+' '+@DESC1+' '+@DDJ1+' -1 xxx -1 xxx -1 xxx -1 xxx' print '' 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) BEGIN print '##Check the following lines @ RefPricePolicyOfItem.txt!' Declare @NEWPRICE1 varchar(15) SET @NEWPRICE1 = (SELECT Cost FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND PaymentDevice = 2) print '1 15 PACKAGE_'+@CodeName+' 2 0 '+@NEWPRICE1+' -1 xxx -1 xxx -1 xxx -1 xxx' print '1 15 PACKAGE_'+@CodeName+' 4 0 0 -1 xxx -1 xxx -1 xxx -1 xxx' print '1 15 PACKAGE_'+@CodeName+' 16 0 0 -1 xxx -1 xxx -1 xxx -1 xxx' print '' 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,2,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx') 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,4,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx') 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,16,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx') Declare @NEWPRICE varchar(15) SET @NEWPRICE = @yourPrice print '' print 'Add the following lines @ refpricepolicyofitem.txt' print '1 15 PACKAGE_'+@CodeName+' 2 0 '+@NEWPRICE+' -1 xxx -1 xxx -1 xxx -1 xxx' print '1 15 PACKAGE_'+@CodeName+' 4 0 0 -1 xxx -1 xxx -1 xxx -1 xxx' print '1 15 PACKAGE_'+@CodeName+' 16 0 0 -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 '##Check the following lines @ RefShopGoods.txt!' Declare @WhichTAB1 varchar(74) SET @WhichTAB1 = (SELECT RefTabCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'PACKAGE_'+@CodeName) Declare @newSLOTINDEX1 varchar(15) SET @newSLOTINDEX1 = (SELECT SlotIndex FROM _RefShopGoods WHERE RefPackageItemCodeName = 'PACKAGE_'+@CodeName AND RefTabCodeName = @WhichTAB1) print '1 15 '+@WhichTAB1+' '+'PACKAGE_'+@CodeName+' '+@newSLOTINDEX1+' -1 xxx -1 xxx -1 xxx -1 xxx' print '' 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 '##Check the following lines @ RefScrapOfPackageItem.txt!' Declare @ScrapIndex1 varchar(15) SET @ScrapIndex1 = (SELECT [Index] FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName) Declare @Data1 varchar(15) SET @Data1 = (SELECT Data FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName) print '1 15 '+'PACKAGE_'+@CodeName+' '+@CodeName+' 0 0 '+@Data1+' 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx '+@ScrapIndex1 print '' 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 [Index] FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName) print '' print 'Add the following line @ refscrapofpackageitem.txt' print '1 15 '+'PACKAGE_'+@CodeName+' '+@CodeName+' 0 0 '+@Data+' 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!' END ELSE BEGIN print 'The @WhichTAB value is incorrect!' END END else begin print '@CodeName value does not exist.' end Set service 1 query: كود بلغة HTML:
USE SRO_VT_SHARD_INIT GO UPDATE [dbo].[_RefObjCommon] SET Service = 1 WHERE CodeName128 like '%HerePutAvatarCode% Set saletag 0 query: كود بلغة HTML:
USE SRO_VT_SHARD_INIT GO UPDATE _RefPackageItem SET SaleTag = '0' WHERE (CodeName128 LIKE 'PACKAGE_ITEM_MALL_AVATAR%') صوره من PC |
||||||||||||
|
21-02-2013, 01:02 AM | #2 | ||||||||||||
Never ForGive
|
يا باشا الناس مش فهما حاجة ياريت يكون الشرح عربي ينـــقل الي عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] |
||||||||||||
التعديل الأخير تم بواسطة Mr Z!dane ; 21-02-2013 الساعة 01:05 AM
|
21-02-2013, 05:54 AM | #3 | ||||||||||||
|
تسلم ايدك
|
||||||||||||
|
04-03-2013, 09:15 PM | #4 | ||||||||||||
|
فين الترجمة !!
|
||||||||||||
|
06-03-2013, 04:11 PM | #5 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
06-03-2013, 07:05 PM | #6 | ||||||||||||
|
هو الكويرى ده هيفيد ناس كتير أوى بما فيهم أنا شخصياً بس ياريت لو حد يقولنا
هنعمل أيه وهنضيف أيه وهنغير أيه مش الاخ وأخده كوبى وباست وخلاص |
||||||||||||
|
06-03-2013, 07:09 PM | #7 | ||||||||||
|
يا ريت تكتب بالعربى .. و ياريت صور |
||||||||||
|
06-03-2013, 09:51 PM | #8 | ||||||||||||
|
مش فاهم
|
||||||||||||
|
09-03-2013, 12:25 AM | #9 | ||||||||||||
|
هو الموضوع مفيد جداً بس عاوز حد يشرحه بالعربى لإن كدا الواحد مش فاهم أى حاجة
ولا حتى هيعمل أيه لإنى بجد محتاج الكويرى ده وكويرى الأن بى سى والحمد لله أنت بتأخد الموضوع كوبى من موقع أجنبى وبتيجى تحته باسط بس بتغير العنوان والمقدمة |
||||||||||||
|
14-05-2014, 11:05 AM | #10 | ||||||||||||
|
Good Jop
|
||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|