VSRO Spota Unique Spawn Ekleme

admin · 18 Mar 2022

Kod:

USE SRO_VT_SHARD  --- JoymaxTR



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



/* GEREKLİ BİLGİLER */

SET @UNIQUE = 'MOB_CH_TIGERWOMAN' -- Unique kodunu yaziyorsunuz RefObjCommondan - CodeName128 ' columnunda bulabilirsiniz..

SET @CHARNAME = 'deneme' -- X Y Z koordinatlarini alacagi karakterin ismi - Char tablosu CharName16 columnunda bulabilirsiniz.

SET @mindealy = 3600  -- Saniyede bir belirdikten önce min.süre

SET @maxdelay = 3600  -- Saniyede bir belirdikten önce max.süre

SET @INITRADIUS = 20  -- Unique'nin belirdigi spotun çevresi

SET @RADIUS = 20  -- Unique'nin hareket ettigi spotun (bölgenin) çevresi

/* end of settings area */



/* get ID of mob by code name */

Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)





INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,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)







INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES

(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)





/* 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)





INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES

(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)







print ''

print ''

print 'JOYMAXTR.COM!'

burakba · 29 Mar 2022

Selam kardes, query okutunca boyle bir hata aliyoruz.

Msg 544, Level 16, State 1, Line 51
Cannot insert explicit value for identity column in table 'Tab_RefTactics' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 61
Cannot insert explicit value for identity column in table 'Tab_RefHive' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 85
Cannot insert explicit value for identity column in table 'Tab_RefNest' when IDENTITY_INSERT is set to OFF.

admin · 29 Mar 2022

ID'leri veya identiyleri kapalı olabilir database'nizi kontrol edin kodlar sorunsuz çalışmaktadır.

burakba' Alıntı:
Selam kardes, query okutunca boyle bir hata aliyoruz.

Msg 544, Level 16, State 1, Line 51
Cannot insert explicit value for identity column in table 'Tab_RefTactics' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 61
Cannot insert explicit value for identity column in table 'Tab_RefHive' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 85
Cannot insert explicit value for identity column in table 'Tab_RefNest' when IDENTITY_INSERT is set to OFF.

VSROSunucu · Pazartesi saat 14:04'de

Çok dağınık olmuş sanki @admin Bey biraz daha toparladım

SQL:

USE SRO_VT_SHARD
GO

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

/* GEREKLİ BİLGİLER */

SET @UNIQUE = 'MOB_CH_TIGERWOMAN' -- Unique kodunu yaziyorsunuz RefObjCommondan - CodeName128 ' columnunda bulabilirsiniz..

SET @CHARNAME = 'KarakterADI' -- X Y Z koordinatlarini alacagi karakterin ismi - Char tablosu CharName16 columnunda bulabilirsiniz.

SET @mindealy = 3600  -- Saniyede bir belirdikten önce min.süre
SET @maxdelay = 3600  -- Saniyede bir belirdikten önce max.süre

SET @INITRADIUS = 30  -- Unique'nin belirdigi spotun çevresi
SET @RADIUS = 50  -- Unique'nin hareket ettigi spotun (bölgenin) çevresi

Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,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)

INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128)
VALUES (@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)

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)

INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType)
VALUES (@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)

print 'Unique Başarıyla Eklendi.'

Language Chooser

Ara

Language Chooser

Ara

VSRO Spota Unique Spawn Ekleme

admin

Joymax Family

burakba

Aileden Biri

admin

Joymax Family

VSROSunucu

Aileden Biri

Whatsapp