Neler yeni
Bu konu sonsuza kadar sabitlendi.

admin

Joymax Family
Forum Yöneticisi
Aileden Biri
Joymax Amiral
Katılım
5 Şub 2021
Mesajlar
90
Tepkime puanı
38
Puanları
118
Ülke
TÜRKİYE
Ad
JoymaxTR
Soyad
Family
Discord
JoymaxTR#7857
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

Aileden Biri
Katılım
26 Mar 2022
Mesajlar
3
Tepkime puanı
1
Puanları
1
Ülke
SİNGAPUR
Ad
BURAK
Soyad
BA
Discord
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

Joymax Family
Forum Yöneticisi
Aileden Biri
Joymax Amiral
Katılım
5 Şub 2021
Mesajlar
90
Tepkime puanı
38
Puanları
118
Ülke
TÜRKİYE
Ad
JoymaxTR
Soyad
Family
Discord
JoymaxTR#7857
ID'leri veya identiyleri kapalı olabilir database'nizi kontrol edin kodlar sorunsuz çalışmaktadır.
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.
 
Üst