شـريـط الاهـداءات | |
قسم المواضيع المكررة و المخالفة هنا يتم وضع المواضيع المخالفة والمواضيع المكررة |
|
أدوات الموضوع | تقييم الموضوع | انواع عرض الموضوع |
11-01-2013, 09:08 PM | #1 | ||||||||||||
|
بسم الله الرحمن الرحيم انا مش بحب الكلام الكتير ^^ الصور شويه معلومات كده الداتا فيها معظم الافتارات الجديده الداتا فيها سكلات 120 بس مش شغاله مع الكلينت :( الداتا اصلا d10 بس فيها لغايه d13 عشان تفتح الاسكلات +الايتم استخدم الموضوع ده ^^>>>>>عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] نيجى بقى لى اهم حاجه الدونلود ^^ الكلينت <<<عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] >>>>> الداتا بيس <<<<عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] >>>> تمت اضافه سايت للموضوع السايت ده مش جميل وبس لا سهل كمان وممكن تعدل فيه برحتك صوره كدا على الماشى النسخه ديه محطوط فيها اغانى وكده حضرتك ممكن يا تمسحها خالص ^^ يا تغير الاغانى وتحط اسمها فى index زى الموضوع ده ^^ عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] الدونلود ,,,<<<<عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] >>> عايز تضيف افتار بسهوله ,, استخدم ديه عشان تعرف لو الافتار عاندك ولا لا كود:
USE SRO_VT_SHARD -- SRO_VT_SHARD = 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 كود:
USE SRO_VT_SHARD 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.' غير طبعا للكود الى انت هتضيفوا عايز تضيفوا لى الايتم mall _RefPackageItem _RefPricePolicyOfItem _RefScrapOfPackageItem _RefShopGoods استخدم ده ^^ كود:
SE SRO_VT_SHARD 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 ^^ عايز تخلى الدجرى 13 او 12 يتمسك من لفل 100 اتفضل استخدم ديه وادعيلى ومتنساش تعدل فى المديا ^^ كود:
USE [SRO_VT_SHARD] UPDATE [dbo].[_RefObjCommon] SET ReqLevel1 = 100 WHERE CodeName128 like '%11_A_RARE%' للعندو مشكله مع الكلينت ينزل المديا من هنا عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] يا شباب علشان تشغلوا الداتا دى صح ومن غير مشاكل حملوا الميديا من الصفحة الأولى ولازم تعملوا اسامى الداتا بالأسماء التقليدية ( sro_vt_account ) ( sro_vt_shard ) ( sro_vt_shardlog ) شكرا للاخ kassas شرح طريقه عمل الابديت السليم ^^ 1_اول حاجه تفتح SMC Folder وتعمل ملفين جداد اول واحد تسميه Patch_Internal التاني Patch_Internal_Comp وبعدين تفتح ServiceManager.cfg /* */ SMC { DivisionManager "yourip",15880 } ModulePatch { SrcPath ".\Patch_Internal" DestPath ".\Patch_Internal_Comp" } ده تحطوه بدل الى عاندكم نيجى بقى للمهم حطيت افاتار مثلا فى الداتا وعايز لما تعملوا فى المديا متعدش تطلع وتدخل الملفات او عايز تعملها عند كل الناس الى بتلعب عاندك سهل جدا هتروف فى Patch_Internal وتاخد الملفات الجهازه بتاعت الافتار اذا كانت للداتا او برتكلس او المديا فى حاله المديا هتغير بس الايدى زى الى فى sql عاندك واللنك لو غيرتوا تروح تفتح السيرفر وتيجى عاند smc وتدوس علي Modulepatch وتدوس كليك يمين علي SR_Client وبعدين دوس SR_Client 22 دلوقتي حتشوف اخر اصدار بقي حتحط التاريخ واليوم والسنه ده بيضاف لاول مره وبعدين دوس Read Patch Data وبعدين ال SMC حيتأكد من الصيع والحاجات بتاعت الملفات وحيشيل اي صيغه مش معروفه دلوقتي بقي تدوس Analyze patch data وبعدين اعمل upload اول ميقولك ان نجح وتلاقيه خلص خالص اقفل GatewayServer وDownloadServer وروح على sql >>>>SRO_VT_ACCOUNT>>>>Tables>>> _ModuleVersionFile وتستنى لغايه ميحمل وتروح لى اخر حاجه بعدين غير 0 لى 1 واقفل وافتح GatewayServer وDownloadServer وافتح السيرفر وكده يبقى عملت الابديت صح مش زى الشروحات القديمه الى مكنتش بتكمل الجزء ده ^^ |
||||||||||||
التعديل الأخير تم بواسطة xxxlitaxxx ; 22-01-2013 الساعة 05:00 AM
|
11-01-2013, 09:17 PM | #2 | ||||||||||
|
اللللللللله عليك
|
||||||||||
|
11-01-2013, 09:34 PM | #3 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
11-01-2013, 10:23 PM | #4 | ||||||||||||
|
ايه يجدعان الداتا وحشه ولا ايه ^^
|
||||||||||||
|
11-01-2013, 10:29 PM | #5 | ||||||||||||
|
تشكرا يا معلم علي الداتا والكلينت :flowers: |
||||||||||||
|
11-01-2013, 10:34 PM | #6 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
12-01-2013, 12:17 AM | #7 | ||||||||||||
|
تسلم يا معلم |
||||||||||||
|
12-01-2013, 12:35 AM | #8 | ||||||||||||
|
أوي بقا يا مزاج الشغل أيوه بقايا رجاله جامده يا باشا |
||||||||||||
|
12-01-2013, 12:53 AM | #9 | ||||||||||
|
جامده تسلم
|
||||||||||
|
12-01-2013, 02:51 AM | #10 | ||||||||||
|
تمامـ ..
|
||||||||||
|
12-01-2013, 05:09 AM | #11 | ||||||||||||
|
تسلم ايدك ياباشا وجارى التجربة |
||||||||||||
|
12-01-2013, 08:59 AM | #12 | ||||||||||||
|
الكلينت فى مشكلة موش بيفتح وبيجيب c4
|
||||||||||||
|
12-01-2013, 09:17 AM | #13 | ||||||||||||
|
تسلم يا باشا
|
||||||||||||
|
12-01-2013, 10:06 AM | #14 | ||||||||||||
|
مش عارف اقلك ايه ! بس بسم الله مشاء الله تسلم يا كبير
|
||||||||||||
|
12-01-2013, 11:58 AM | #15 | ||||||||||||||||||
|
اقتباس:
اقتباس:
اقتباس:
اقتباس:
اقتباس:
اقتباس:
|
||||||||||||||||||
|
الكلمات الدليلية |
بدون |
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|