[Dev] Arshivel
15-12-2012, 06:46 AM
http://img338.imageshack.us/img338/7545/gif1302156586680.gif
الموضوع ده شامل كل حاجه عن Unique
المش بيظهر
وى ازاى تطيف Unique فى العبه بى التريقه الصحيحه
معلشى مش هعرف اكيب صور مكسل افتح العبه :photo:
بس تعملو زاى الشرح وى ملكشى دعوه هتلقى كل حاجه تمام معاك
نبداً بسم الله
1_ ازاى اظهار الينك
ركز افتح ال SQL
ثم SRO_VT_SHARD ثم _RefObjCommon ثم
اعمل ال Query ده
SELECT [Service] /* End_OF_W0RLD */
,a.[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]
,[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]
FROM [SRO_VT_SHARD].[dbo].[_RefObjCommon] a,[dbo].[_RefObjItem] b
Where a.LINK = b.ID
AND Codename128 like 'MOB_SD_APIS%'
--or Codename128 like 'MOB_%'ok
GOال query ده بيسهل عليك امر بس عشان تطور على ال ID فى _RefObjCommon
http://img402.imageshack.us/img402/8476/dsadsads3.jpg
هتعملها كده
http://img442.imageshack.us/img442/738/dsde31.jpg
تمام كده اظهار ال Unique
طب ازاى اعمل ال Spot Unique صح
بس على الشرح ده كويس اوى
اولاً ده ال Query
USE SRO_VT_SHARD /* Add Unique Spot By End_OF_W0RLD_ From S4A */
DECLARE @UNIQUE VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1
/* put your settings here */
SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60 -- Minimum time before appears in seconds
SET @maxdelay = 120 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET @RADIUS = 500 -- Radius around spot Unique can move in
/* end of settings area */
/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2,DiversionBasisD ata3,DiversionBasisData4,DiversionBasisData5,Diver sionBasisData6,DiversionBasisData7,DiversionBasisD ata8,btDiversionKeepBasis,DiversionKeepBasisData1, DiversionKeepBasisData2,DiversionKeepBasisData3,Di versionKeepBasisData4,DiversionKeepBasisData5,Dive rsionKeepBasisData6,DiversionKeepBasisData7,Divers ionKeepBasisData8,btKeepDistance,KeepDistanceData, btTraceType,btTraceBoundary,TraceData,btHomingType ,HomingData,btAggressTypeOnHoming,btFleeType,dwCha mpionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0 ,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0, 2,0,0,112,@UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics OFF
SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,szDescString128) VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)
SET IDENTITY_INSERT Tab_RefHive OFF
/* get position coordinates of your character */
DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)
SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY ,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay ,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF
print ''
print ''
print 'Done!'
روح على SQL ثم SRO_VT_SHARD كليك يمين ثم NewQuery
هتعمل ال Query ال فوق ده تمام كده
بص بقا ركز معيا اوى
فوق فى ال SQL شايف كلمت Tools دى هتدوس عليها وى تختار Options
هتختار Designers
وى هتشيل علمت صح من Prevent saving changes That.....
ثم موافق
ال مش فاهم يفهم من الصور
http://img21.imageshack.us/img21/1476/ewqewq.jpg
http://img28.imageshack.us/img28/6987/asdsawq.jpg
ركز
اكين عرفين Tab_RefHive وا Tab_RefNest وا Tab_RefTactics
تهعمل كده فى كل وحده فيهم
http://img13.imageshack.us/img13/3314/dsade134.jpg
http://img502.imageshack.us/img502/2885/dsadasdsadddd.jpg
بعدين هتعمل ال Query Spot Unique
هتعمل ال اسم ال Cher وى كلو تمام بس اهممممممممممم
حاجججججججججججههههه
انك تمسح الكلم البى لون اخضر ده
وى تعمل Execute
http://img819.imageshack.us/img819/9117/30501503.jpg
سلامووووووووووووووووووزز
الموضوع من مجهودى :mf_swordfight:
سبب التعديل :نسيت صح الموضوع ده عشان الاعضاء وى starroad
سلاموز تانى ههههه
الموضوع ده شامل كل حاجه عن Unique
المش بيظهر
وى ازاى تطيف Unique فى العبه بى التريقه الصحيحه
معلشى مش هعرف اكيب صور مكسل افتح العبه :photo:
بس تعملو زاى الشرح وى ملكشى دعوه هتلقى كل حاجه تمام معاك
نبداً بسم الله
1_ ازاى اظهار الينك
ركز افتح ال SQL
ثم SRO_VT_SHARD ثم _RefObjCommon ثم
اعمل ال Query ده
SELECT [Service] /* End_OF_W0RLD */
,a.[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]
,[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]
FROM [SRO_VT_SHARD].[dbo].[_RefObjCommon] a,[dbo].[_RefObjItem] b
Where a.LINK = b.ID
AND Codename128 like 'MOB_SD_APIS%'
--or Codename128 like 'MOB_%'ok
GOال query ده بيسهل عليك امر بس عشان تطور على ال ID فى _RefObjCommon
http://img402.imageshack.us/img402/8476/dsadsads3.jpg
هتعملها كده
http://img442.imageshack.us/img442/738/dsde31.jpg
تمام كده اظهار ال Unique
طب ازاى اعمل ال Spot Unique صح
بس على الشرح ده كويس اوى
اولاً ده ال Query
USE SRO_VT_SHARD /* Add Unique Spot By End_OF_W0RLD_ From S4A */
DECLARE @UNIQUE VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1
/* put your settings here */
SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60 -- Minimum time before appears in seconds
SET @maxdelay = 120 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET @RADIUS = 500 -- Radius around spot Unique can move in
/* end of settings area */
/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2,DiversionBasisD ata3,DiversionBasisData4,DiversionBasisData5,Diver sionBasisData6,DiversionBasisData7,DiversionBasisD ata8,btDiversionKeepBasis,DiversionKeepBasisData1, DiversionKeepBasisData2,DiversionKeepBasisData3,Di versionKeepBasisData4,DiversionKeepBasisData5,Dive rsionKeepBasisData6,DiversionKeepBasisData7,Divers ionKeepBasisData8,btKeepDistance,KeepDistanceData, btTraceType,btTraceBoundary,TraceData,btHomingType ,HomingData,btAggressTypeOnHoming,btFleeType,dwCha mpionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0 ,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0, 2,0,0,112,@UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics OFF
SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,szDescString128) VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)
SET IDENTITY_INSERT Tab_RefHive OFF
/* get position coordinates of your character */
DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)
SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY ,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay ,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF
print ''
print ''
print 'Done!'
روح على SQL ثم SRO_VT_SHARD كليك يمين ثم NewQuery
هتعمل ال Query ال فوق ده تمام كده
بص بقا ركز معيا اوى
فوق فى ال SQL شايف كلمت Tools دى هتدوس عليها وى تختار Options
هتختار Designers
وى هتشيل علمت صح من Prevent saving changes That.....
ثم موافق
ال مش فاهم يفهم من الصور
http://img21.imageshack.us/img21/1476/ewqewq.jpg
http://img28.imageshack.us/img28/6987/asdsawq.jpg
ركز
اكين عرفين Tab_RefHive وا Tab_RefNest وا Tab_RefTactics
تهعمل كده فى كل وحده فيهم
http://img13.imageshack.us/img13/3314/dsade134.jpg
http://img502.imageshack.us/img502/2885/dsadasdsadddd.jpg
بعدين هتعمل ال Query Spot Unique
هتعمل ال اسم ال Cher وى كلو تمام بس اهممممممممممم
حاجججججججججججههههه
انك تمسح الكلم البى لون اخضر ده
وى تعمل Execute
http://img819.imageshack.us/img819/9117/30501503.jpg
سلامووووووووووووووووووزز
الموضوع من مجهودى :mf_swordfight:
سبب التعديل :نسيت صح الموضوع ده عشان الاعضاء وى starroad
سلاموز تانى ههههه