| ™Shi6on |
17-08-2014 06:45 AM |
وحضرتك بدل ما اعمل كل ده استخدم الكويري ده ولا اصل في بعض المشرفين قلولي حاول متعملش الكويري ايه رأيك !!
اقتباس:
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,OrgOb jCodeName128,NameStrID128,DescStrID128,CashItem,Bi onic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Cou ntry,Rarity,CanTrade,CanSell,Canbuy,CanBorrow,CanD rop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Pr ice,CostRepair,CostRevive,CostBorrow,KeepingFee,Se llPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqL evel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLev el4,MaxContain,RegionID,Dir,OffsetX,OffsetY,Offset Z,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,As socFileObj128,AssocFileDrop128,AssocFileIcon128,As socFile1_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,@AssocF ile,@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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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 H34D.B4NG3R.'
|
|
