Toplu Mob Spawn Ekleme '' Query ''

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ılırdı www.joymaxtr.com'
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