عاوز اضيف يونكات

[ahmed akef00]

عاوز كوري تنزلي اليونكات دي الساعة 6 بليل والساعة 6 الصبح
TigerGril{titan
tigergirl titan
tigergirl titan
tigergirltitan
يعني اربعة من كل يونيك
cerberce{titan} اربعة
captian ivy [titan] g اربعة
uruchi [titan] اربعة
istutaru [ titan] اربعة
lordyankan {titan} اربعة
demonshitan {titan} اربعة
soso[titan]4 اربعة
عاوز اضفهم للعبة بحيث ارعة تيتن من كل وينك ينزلو السعاة 6 الصبح والساعة 6 باليل

[Dev.Sawy]

USE SRO_VT_SHARD /* Add Unique Spot By Arabianfox */

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 = 'Esm el acc 3shan el SPOT'' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'Game_Owner' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 300 -- Minimum time before appears in seconds
SET @maxdelay = 1800 -- Maximum time before appears in seconds
SET @INITRADIUS = 60 -- Radius around spot unique can generated at
SET @RADIUS = 50 -- 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!'
و الناس اللي مش فاهمه يعني ... يعني لو عايز ال Jupiter ينزل قدام باب المدينه هات اي اكونت و وقفه في الحته اللي انت عايزه ينزل فيها ال Unique و بعد كده تاخد اسم الاكونت من dbo__Char و تحطه بدل
Jupiter ينزل قدام باب المدينه هات اي اكونت و وقفه في الحته اللي انت عايزه ينزل فيها ال Unique و بعد كده تاخد اسم الاكونت من dbo__Char و تحطه بدل
كود PHP:
'Esm el acc 3shan el SPOT'

[Dev.Sawy]

USE BR_SHARD_DB /* Add Unique Spot By Mrs_Mero BR files */

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_RM_SPIRITS_CLON3' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'Esm el acc 3shan el SPOT' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 3600 -- Minimum time before appears in seconds
SET @maxdelay = 3601 -- 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) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY ,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay ,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!'
و الناس اللي مش فاهمه يعني ... يعني لو عايز ال Jupiter ينزل قدام باب المدينه هات اي اكونت و وقفه في الحته اللي انت عايزه ينزل فيها ال Unique و بعد كده تاخد اسم الاكونت من dbo__Char و تحطه بدل
'Esm el acc 3shan el SPOT'

[ahmed akef00]

يعني اول ما اضيف الكوري دي اليونكات دي هتظهر الساعة 6 ؟؟؟

[Dev.Sawy]

انت بتحدد الوقت انا مدهولك في الكيوري !! الوقت بيكون بالثواني
SET @mindealy = 3600 -- Minimum time before appears in seconds
SET @maxdelay = 3601 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
اخر حاجة دي مكان اليونيك يتحرك فية !!

[ahmed akef00]

USE BR_SHARD_DB /* Add Unique Spot By Mrs_Mero BR files */

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_RM_SPIRITS_CLON3' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'Esm el acc 3shan el SPOT' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 3600 -- Minimum time before appears in seconds
SET @maxdelay = 3601 -- 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) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY ,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay ,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!'
و الناس اللي مش فاهمه يعني ... يعني لو عايز ال Jupiter ينزل قدام باب المدينه هات اي اكونت و وقفه في الحته اللي انت عايزه ينزل فيها ال Unique و بعد كده تاخد اسم الاكونت من dbo__Char و تحطه بدل
'Esm el acc 3shan el SPOT'

يعني هما دول اليونكات الي انا عاوزه

[omar hapshy]

حظبطلك الكويري وحبعتهالك

[omar hapshy]

USE*SRO_VT_SHARD*/**Add*Unique*Spot*By*Mrs_Mero**/

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_كود اليونك'*--*Unique*code*name*from*_RefobjCommon*table
SET*@CHARNAME*=*'اسم الاكونت يابني هنا وقفو في حتة الاول'*--*Character*name*from*_Char*table*to*get*mob*positi on*X*Y*Z
SET*@mindealy*=*21600**--*Minimum*time*before*appears*in*seconds
SET*@maxdelay*=*21600**--*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*_R efObjCommon*WHERE*CodeName128*=*@UNIQUE)

SET*IDENTITY_INSERT*Tab_RefTactics*ON
INSERT*INTO*Tab_RefTactics*(dwTacticsID,dwObjID,bt AIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange ,btAggressType,AggressData,btChangeTarget,btHelpRe questTo,btHelpResponseTo,btBattleStyle,BattleStyle Data,btDiversionBasis,DiversionBasisData1,Diversio nBasisData2,DiversionBasisData3,DiversionBasisData 4,DiversionBasisData5,DiversionBasisData6,Diversio nBasisData7,DiversionBasisData8,btDiversionKeepBas is,DiversionKeepBasisData1,DiversionKeepBasisData2 ,DiversionKeepBasisData3,DiversionKeepBasisData4,D iversionKeepBasisData5,DiversionKeepBasisData6,Div ersionKeepBasisData7,DiversionKeepBasisData8,btKee pDistance,KeepDistanceData,btTraceType,btTraceBoun dary,TraceData,btHomingType,HomingData,btAggressTy peOnHoming,btFleeType,dwChampionTacticsID,Addition OptionFlag,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,btKeepMonsterCou ntType,dwOverwriteMaxTotalCount,fMonsterCountPerPC ,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag ,GameWorldID,HatchObjType,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*(LatestR egion)*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,dwTacti csID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ, wInitialDir,nRadius,nGenerateRadius,nChampionGenPe rcentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalC ount,btFlag,btRespawn,btType)*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 وتحط اسم الاكونت وكود اليونك كدة نزلت انتا اول يونك بينزل في مكان واحد كل 6 سعات وكمل انت بقي