USE SRO_VT_SHARD /* Add Mobs Multiple Spots */ /* This Query can uses for add spawn unique spot(s) by 20x spot. Leave Character names don't change if u want few of spots not all of 20x For example : if u want to add unique name MOB_RM_ROC in only 5 selected spots. create 5 characters and go with them to the selected 5 spots in-game then logout these characters, then edit here first 5 characters names to get 5x spots, monster codename 'MOB_RM_ROC' , spawn time and radius if u need more or few spots than 5x just change character name for an exists characters. */ -- Declare expression. Declare @monsterCodeName Varchar(Max) , @mindealy Int , @MaxDelay Int , @InitRadius Int , @radius Int , @nestiD Int , @hiveID Int , @TacticsID Int , @monsterID Int , @charname1 Varchar(64) , @region1 Int , @posX1 Int , @posY1 Int , @posZ1 Int , @charname2 Varchar(64) , @region2 Int , @posX2 Int , @posY2 Int , @posZ2 Int , @charname3 Varchar(64) , @region3 Int , @posX3 Int , @posY3 Int , @posZ3 Int , @charname4 Varchar(64) , @region4 Int , @posX4 Int , @posY4 Int , @posZ4 Int , @charname5 Varchar(64) , @region5 Int , @posX5 Int , @posY5 Int , @posZ5 Int , @charname6 Varchar(64) , @region6 Int , @posX6 Int , @posY6 Int , @posZ6 Int , @charname7 Varchar(64) , @region7 Int , @posX7 Int , @posY7 Int , @posZ7 Int , @charname8 Varchar(64) , @region8 Int , @posX8 Int , @posY8 Int , @posZ8 Int , @charname9 Varchar(64) , @region9 Int , @posX9 Int , @posY9 Int , @posZ9 Int , @charname10 Varchar(64) , @region10 Int , @posX10 Int , @posY10 Int , @posZ10 Int , @charname11 Varchar(64) , @region11 Int , @posX11 Int , @posY11 Int , @posZ11 Int , @charname12 Varchar(64) , @region12 Int , @posX12 Int , @posY12 Int , @posZ12 Int , @charname13 Varchar(64) , @region13 Int , @posX13 Int , @posY13 Int , @posZ13 Int , @charname14 Varchar(64) , @region14 Int , @posX14 Int , @posY14 Int , @posZ14 Int , @charname15 Varchar(64) , @region15 Int , @posX15 Int , @posY15 Int , @posZ15 Int , @charname16 Varchar(64) , @region16 Int , @posX16 Int , @posY16 Int , @posZ16 Int , @charname17 Varchar(64) , @region17 Int , @posX17 Int , @posY17 Int , @posZ17 Int , @charname18 Varchar(64) , @region18 Int , @posX18 Int , @posY18 Int , @posZ18 Int , @charname19 Varchar(64) , @region19 Int , @posX19 Int , @posY19 Int , @posZ19 Int , @charname20 Varchar(64) , @region20 Int , @posX20 Int , @posY20 Int , @posZ20 Int -------------------------------------------------------- /* Unique veya mob bilgilerini yazıcağınız böyle */ Set @monsterCodeName = 'MOB_CODE_NAME' -- Yaratığın refobjcommon tablosundaki "CodeName128" adı , query'nin çalışabilmesi için doğru canavar kod adı olmalı. Set @mindealy = 60 -- Minimum kaç saniye içinde spawn olması Set @MaxDelay = 120 -- Maximum kaç saniye içinde spawn olması Set @InitRadius = 100 -- Radius around spot unique can generated at - Kaç yarıcarp içinde spawn olması TigerGirl'in 600 Set @radius = 500 -- Radius around spot Unique can move in - Kaç yarıcarp içinde dolaşması - TigerGirl'in 1000 -- 20x Character names to get monster position X Y Z - Karakterlerin adını yazacağınız bölüm Set @charname1 = 'Character 1' Set @charname2 = 'Character 2' Set @charname3 = 'Character 3' Set @charname4 = 'Character 4' Set @charname5 = 'Character 5' Set @charname6 = 'Character 6' Set @charname7 = 'Character 7' Set @charname8 = 'Character 8' Set @charname9 = 'Character 9' Set @charname10 = 'Character 10' Set @charname11 = 'Character 11' Set @charname12 = 'Character 12' Set @charname13 = 'Character 13' Set @charname14 = 'Character 14' Set @charname15 = 'Character 15' Set @charname16 = 'Character 16' Set @charname17 = 'Character 18' Set @charname18 = 'Character 18' Set @charname19 = 'Character 19' Set @charname20 = 'Character 20' /* Ayarlamalar Bitti. Sorguyu çalıştırmak için F5 tuşuna basın */ -------------------------------------------------------- /* Get parameters for tables Inserting */ Set @monsterID = (Select ID From _RefObjCommon Where CodeName128 = @monsterCodeName) Set @hiveID = (Select Max(dwHiveID) From Tab_RefHive)+1 Set @TacticsID = (Select Max(dwTacticsID) From Tab_RefTactics)+1 Set @region1 = (Select (LatestRegion) From _Char Where CharName16 = @charname1) Set @posX1 = (Select (POSX) From _Char Where CharName16 = @charname1) Set @posY1 = (Select (POSY) From _Char Where CharName16 = @charname1) Set @posZ1 = (Select (POSZ) From _Char Where CharName16 = @charname1) Set @region2 = (Select (LatestRegion) From _Char Where CharName16 = @charname2) Set @posX2 = (Select (POSX) From _Char Where CharName16 = @charname2) Set @posY2 = (Select (POSY) From _Char Where CharName16 = @charname2) Set @posZ2 = (Select (POSZ) From _Char Where CharName16 = @charname2) Set @region3 = (Select (LatestRegion) From _Char Where CharName16 = @charname3) Set @posX3 = (Select (POSX) From _Char Where CharName16 = @charname3) Set @posY3 = (Select (POSY) From _Char Where CharName16 = @charname3) Set @posZ3 = (Select (POSZ) From _Char Where CharName16 = @charname3) Set @region4 = (Select (LatestRegion) From _Char Where CharName16 = @charname4) Set @posX4 = (Select (POSX) From _Char Where CharName16 = @charname4) Set @posY4 = (Select (POSY) From _Char Where CharName16 = @charname4) Set @posZ4 = (Select (POSZ) From _Char Where CharName16 = @charname4) Set @region5 = (Select (LatestRegion) From _Char Where CharName16 = @charname5) Set @posX5 = (Select (POSX) From _Char Where CharName16 = @charname5) Set @posY5 = (Select (POSY) From _Char Where CharName16 = @charname5) Set @posZ5 = (Select (POSZ) From _Char Where CharName16 = @charname5) Set @region6 = (Select (LatestRegion) From _Char Where CharName16 = @charname6) Set @posX6 = (Select (POSX) From _Char Where CharName16 = @charname6) Set @posY6 = (Select (POSY) From _Char Where CharName16 = @charname6) Set @posZ6 = (Select (POSZ) From _Char Where CharName16 = @charname6) Set @region7 = (Select (LatestRegion) From _Char Where CharName16 = @charname7) Set @posX7 = (Select (POSX) From _Char Where CharName16 = @charname7) Set @posY7 = (Select (POSY) From _Char Where CharName16 = @charname7) Set @posZ7 = (Select (POSZ) From _Char Where CharName16 = @charname7) Set @region8 = (Select (LatestRegion) From _Char Where CharName16 = @charname8) Set @posX8 = (Select (POSX) From _Char Where CharName16 = @charname8) Set @posY8 = (Select (POSY) From _Char Where CharName16 = @charname8) Set @posZ8 = (Select (POSZ) From _Char Where CharName16 = @charname8) Set @region9 = (Select (LatestRegion) From _Char Where CharName16 = @charname9) Set @posX9 = (Select (POSX) From _Char Where CharName16 = @charname9) Set @posY9 = (Select (POSY) From _Char Where CharName16 = @charname9) Set @posZ9 = (Select (POSZ) From _Char Where CharName16 = @charname9) Set @region10 = (Select (LatestRegion) From _Char Where CharName16 = @charname10) Set @posX10 = (Select (POSX) From _Char Where CharName16 = @charname10) Set @posY10 = (Select (POSY) From _Char Where CharName16 = @charname10) Set @posZ10 = (Select (POSZ) From _Char Where CharName16 = @charname10) Set @region11 = (Select (LatestRegion) From _Char Where CharName16 = @charname11) Set @posX11 = (Select (POSX) From _Char Where CharName16 = @charname11) Set @posY11 = (Select (POSY) From _Char Where CharName16 = @charname11) Set @posZ11 = (Select (POSZ) From _Char Where CharName16 = @charname11) Set @region12 = (Select (LatestRegion) From _Char Where CharName16 = @charname12) Set @posX12 = (Select (POSX) From _Char Where CharName16 = @charname12) Set @posY12 = (Select (POSY) From _Char Where CharName16 = @charname12) Set @posZ12 = (Select (POSZ) From _Char Where CharName16 = @charname12) Set @region13 = (Select (LatestRegion) From _Char Where CharName16 = @charname13) Set @posX13 = (Select (POSX) From _Char Where CharName16 = @charname13) Set @posY13 = (Select (POSY) From _Char Where CharName16 = @charname13) Set @posZ13 = (Select (POSZ) From _Char Where CharName16 = @charname13) Set @region14 = (Select (LatestRegion) From _Char Where CharName16 = @charname14) Set @posX14 = (Select (POSX) From _Char Where CharName16 = @charname14) Set @posY14 = (Select (POSY) From _Char Where CharName16 = @charname14) Set @posZ14 = (Select (POSZ) From _Char Where CharName16 = @charname14) Set @region15 = (Select (LatestRegion) From _Char Where CharName16 = @charname15) Set @posX15 = (Select (POSX) From _Char Where CharName16 = @charname15) Set @posY15 = (Select (POSY) From _Char Where CharName16 = @charname15) Set @posZ15 = (Select (POSZ) From _Char Where CharName16 = @charname15) Set @region16 = (Select (LatestRegion) From _Char Where CharName16 = @charname16) Set @posX16 = (Select (POSX) From _Char Where CharName16 = @charname16) Set @posY16 = (Select (POSY) From _Char Where CharName16 = @charname16) Set @posZ16 = (Select (POSZ) From _Char Where CharName16 = @charname16) Set @region17 = (Select (LatestRegion) From _Char Where CharName16 = @charname17) Set @posX17 = (Select (POSX) From _Char Where CharName16 = @charname17) Set @posY17 = (Select (POSY) From _Char Where CharName16 = @charname17) Set @posZ17 = (Select (POSZ) From _Char Where CharName16 = @charname17) Set @region18 = (Select (LatestRegion) From _Char Where CharName16 = @charname18) Set @posX18 = (Select (POSX) From _Char Where CharName16 = @charname18) Set @posY18 = (Select (POSY) From _Char Where CharName16 = @charname18) Set @posZ18 = (Select (POSZ) From _Char Where CharName16 = @charname18) Set @region19 = (Select (LatestRegion) From _Char Where CharName16 = @charname19) Set @posX19 = (Select (POSX) From _Char Where CharName16 = @charname19) Set @posY19 = (Select (POSY) From _Char Where CharName16 = @charname19) Set @posZ19 = (Select (POSZ) From _Char Where CharName16 = @charname19) Set @region20 = (Select (LatestRegion) From _Char Where CharName16 = @charname20) Set @posX20 = (Select (POSX) From _Char Where CharName16 = @charname20) Set @posY20 = (Select (POSY) From _Char Where CharName16 = @charname20) Set @posZ20 = (Select (POSZ) From _Char Where CharName16 = @charname20) -------------------------------------------------------- /* Start tables inserting values */ IF EXISTS (Select * From _RefObjCommon Where CodeName128 = @monsterCodeName) And (EXISTS (Select * From _Char Where CharName16 = @charname1) Or EXISTS (Select * From _Char Where CharName16 = @charname2) Or EXISTS (Select * From _Char Where CharName16 = @charname3) Or EXISTS (Select * From _Char Where CharName16 = @charname4) Or EXISTS (Select * From _Char Where CharName16 = @charname5) Or EXISTS (Select * From _Char Where CharName16 = @charname6) Or EXISTS (Select * From _Char Where CharName16 = @charname7) Or EXISTS (Select * From _Char Where CharName16 = @charname8) Or EXISTS (Select * From _Char Where CharName16 = @charname9) Or EXISTS (Select * From _Char Where CharName16 = @charname10) Or EXISTS (Select * From _Char Where CharName16 = @charname11) Or EXISTS (Select * From _Char Where CharName16 = @charname12) Or EXISTS (Select * From _Char Where CharName16 = @charname13) Or EXISTS (Select * From _Char Where CharName16 = @charname14) Or EXISTS (Select * From _Char Where CharName16 = @charname15) Or EXISTS (Select * From _Char Where CharName16 = @charname16) Or EXISTS (Select * From _Char Where CharName16 = @charname17) Or EXISTS (Select * From _Char Where CharName16 = @charname18) Or EXISTS (Select * From _Char Where CharName16 = @charname19) Or EXISTS (Select * From _Char Where CharName16 = @charname20)) Begin --# [1] dbo.Tab_RefTactics Set Identity_Insert Tab_RefTactics On Insert InTo Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponSeto,btBattleStyl e,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,Diver sionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,Diversio nKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,bt HomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) Values (@TacticsID @monsterID,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 @monsterCodeName) Set Identity_Insert Tab_RefTactics Off --# [2] dbo.Tab_RefHive Set Identity_Insert Tab_RefHive On Insert InTo Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescSt ring128) Values @hiveID,0,1,0,0,0,0,1,1 @monsterCodeName) Set Identity_Insert Tab_RefHive Off --# [3] dbo.Tab_RefNest Set Identity_Insert Tab_RefNest On -- Spot 1 : IF EXISTS (Select * From _Char Where CharName16 = @charname1) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region1 @posX1 @posY1 @posZ1,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 2 : IF EXISTS (Select * From _Char Where CharName16 = @charname2) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region2 @posX2 @posY2 @posZ2,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 3 : IF EXISTS (Select * From _Char Where CharName16 = @charname3) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region3 @posX3 @posY3 @posZ3,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 4 : IF EXISTS (Select * From _Char Where CharName16 = @charname4) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region4 @posX4 @posY4 @posZ4,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 5 : IF EXISTS (Select * From _Char Where CharName16 = @charname5) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region5 @posX5 @posY5 @posZ5,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 6 : IF EXISTS (Select * From _Char Where CharName16 = @charname6) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region6 @posX6 @posY6 @posZ6,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 7 : IF EXISTS (Select * From _Char Where CharName16 = @charname7) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region7 @posX7 @posY7 @posZ7,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 8 : IF EXISTS (Select * From _Char Where CharName16 = @charname8) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region8 @posX8 @posY8 @posZ8,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 9 : IF EXISTS (Select * From _Char Where CharName16 = @charname9) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region9 @posX9 @posY9 @posZ9,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 10 : IF EXISTS (Select * From _Char Where CharName16 = @charname10) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region10 @posX10 @posY10 @posZ10,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 11 : IF EXISTS (Select * From _Char Where CharName16 = @charname11) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region11 @posX11 @posY11 @posZ11,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 12 : IF EXISTS (Select * From _Char Where CharName16 = @charname12) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region12 @posX12 @posY12 @posZ12,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 13 : IF EXISTS (Select * From _Char Where CharName16 = @charname13) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region13 @posX13 @posY13 @posZ13,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 14 : IF EXISTS (Select * From _Char Where CharName16 = @charname14) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region14 @posX14 @posY14 @posZ14,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 15 : IF EXISTS (Select * From _Char Where CharName16 = @charname15) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region15 @posX15 @posY15 @posZ15,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 16 : IF EXISTS (Select * From _Char Where CharName16 = @charname16) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region16 @posX16 @posY16 @posZ16,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 17 : IF EXISTS (Select * From _Char Where CharName16 = @charname17) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region17 @posX17 @posY17 @posZ17,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 18 : IF EXISTS (Select * From _Char Where CharName16 = @charname18) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region18 @posX18 @posY18 @posZ18,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 19 : IF EXISTS (Select * From _Char Where CharName16 = @charname19) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region19 @posX19 @posY19 @posZ19,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End -- Spot 20 : IF EXISTS (Select * From _Char Where CharName16 = @charname20) Begin Set @nestiD = (Select Max(dwNestID) From Tab_RefNest)+1 Insert InTo Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTim eMax,dwMaxTotalCount,btFlag,btRespawn,btType) Values @nestiD @hiveID,@TacticsID @region20 @posX20 @posY20 @posZ20,0 @radius,@InitRadius,0 @mindealy @MaxDelay,1,0,1,0) End Set Identity_Insert Tab_RefNest Off print '' print '' print 'Sorgu başarıyla çalıştırıldı.' End Else Begin print '' print '' Print 'Monster Code Name or Character names not exists - Yaratık adları ya da Karakter adları bulunamıyor' print '' Print 'Please retype the correct settings to query executing successfuly. - Ayarları tekrar girin' End