نفل موبس

[ruxana]

انا عايز انقل موبس من ال JUPITER الي تيلبورت انا عاملو جديد فاضي خالص

كود الموبس MOB_JUPITER_WATER_PROTECTION_CLONE

[افندينا ™Hamboka™]

USE SRO_VT_SHARD
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, 'OldMobID', 'NewMobID')WHERE dwObjID LIKE 'OldMobIDAgain';


Jangan mobs: select * from _RefObjCommon where CodeName128 like '%MOB_CH%'
Donwhang' mob: select * from _RefObjCommon where CodeName128 like '%MOB_WC%'
Donwhan mobs2: select * from _RefObjCommon where CodeName128 like '%MOB_OA%'
Hotan mobs : select * from _RefObjCommon where CodeName128 like '%MOB_KT%'
Karakoram mobs : select * from _RefObjCommon where CodeName128 like '%MOB_KK%'
Taklamakan mob : select * from _RefObjCommon where CodeName128 like '%MOB_TK%'
Downhang Cave' mob : select * from _RefObjCommon where CodeName128 like '%MOB_DH%'
Roc Mountain' mob : select * from _RefObjCommon where CodeName128 like '%MOB_RM%'
Constantinople mob : select * from _RefObjCommon where CodeName128 like '%MOB_EU%'
Samarkand mob: select * from _RefObjCommon where CodeName128 like '%MOB_AM%'
Samarkand' mob : select * from _RefObjCommon where CodeName128 like '%MOB_CA%'
Jangan cave' mob : select * from _RefObjCommon where CodeName128 like '%MOB_TQ%'
Alexandria' mob : select * from _RefObjCommon where CodeName128 like '%MOB_SD%'
Jupiter'deki mob : select * from _RefObjCommon where CodeName128 like '%MOB_JUPITER%'
Forgotten World' Mob : select * from _RefObjCommon where CodeName128 like '%MOB_GOD%'

[افندينا ™Hamboka™]

use [SRO_VT_SHARD]
------------------------go --------- Angel
declare @UNIquecode varchar(129) = 'MOB_%%% & NPC_%%%' --------- Unique Or NPC Or Mob Code -------
declare @Charname varchar(64) = '[GM]Angel'------------ char name ---------
declare @dwObjID int = ( select ID from _RefObjCommon where CodeName128 = @UNIquecode )
declare @dwTacticsID int = (select dwTacticsID from Tab_RefTactics where dwObjID = @dwObjID )
declare @LatestRegion smallint = ( select TOP 1 nRegionDBID from tab_RefNest where dwTacticsID = @dwTacticsID )
declare @PosX real =( select TOP 1 fLocalPosX from tab_RefNest where dwTacticsID = @dwTacticsID )
declare @PosY real =( select TOP 1 fLocalPosY from tab_RefNest where dwTacticsID = @dwTacticsID )
declare @PosZ real =( select TOP 1 fLocalPosZ from tab_RefNest where dwTacticsID = @dwTacticsID )
update _char set LatestRegion = @LatestRegion where CharName16 = @Charname
update _char set PosX = @PosX where CharName16 = @Charname
update _char set PosY = @PosY where CharName16 = @Charname
update _char set PosZ = @PosZ where CharName16 = @Charname
print ''
print 'لو ال NPC , Mob , Unique متنقلش المكان المطلوب هتعمل ريسترت للأكونت وتتأكد فيه إنى الأكونت ف المكان المطلوب '
print 'By Angel For www.*************'

[ruxana]

الكيوري الاول اول حاجه ال room فاضيا يعني مافيش new ID انا مش عايز انقل موبس مكان موبس

انا عايز انقل الموبس لي room فاضيا واعملو respwand

الكيوري التاني مش نافع علشان بيجيب مشاكل في السيرفر و الاكونت مش بيدخل

[Dev.Ri3o]

كل اللى هتعملو هتاخد السطور ال RefNest بتاعة ال Mobs ده وتعملها Copy بس بإحداثيات مختلفة هتعمل ال Query ده

USE SRO_VT_SHARD
Go
Declare @ID_MOB int = (Select ID From _RefObjCommon Where CodeName128 Like 'MOB_CH_TIGERWOMAN')
Select * From Tab_RefNest Where dwTacticsID in (Select dwTacticsID From Tab_RefTactics Where dwObjID = @ID_MOB)

هيجبلك ال Spots بتاعة خدها Copy وزود براحتك وعدل على الاحداثيات
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
لو هو ملوش اصلا Spot اعمل ال Query اللى بيعمل Spot لل Monster

USE SRO_VT_SHARD /* Add Unique Spot */

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_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60 -- Minimum time before appears in seconds
SET @maxdelay = 120 -- 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,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!'


هتعمل ال Identity لل Tab_RefNest و ال Tab_RefTactics و Tab_RefHive هتخلى ال IDentity : Yes عشان تترتب لوحدها

[Dev.Ri3o]

كل اللى هتعملو هتاخد السطور ال RefNest بتاعة ال Mobs ده وتعملها Copy بس بإحداثيات مختلفة هتعمل ال Query ده

USE SRO_VT_SHARD
Go
Declare @ID_MOB int = (Select ID From _RefObjCommon Where CodeName128 Like 'MOB_CH_TIGERWOMAN')
Select * From Tab_RefNest Where dwTacticsID in (Select dwTacticsID From Tab_RefTactics Where dwObjID = @ID_MOB)

هيجبلك ال Spots بتاعة خدها Copy وزود براحتك وعدل على الاحداثيات
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
لو هو ملوش اصلا Spot اعمل ال Query اللى بيعمل Spot لل Monster

USE SRO_VT_SHARD /* Add Unique Spot */

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_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60 -- Minimum time before appears in seconds
SET @maxdelay = 120 -- 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,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!'


هتعمل ال Identity لل Tab_RefNest و ال Tab_RefTactics و Tab_RefHive هتخلى ال IDentity : Yes عشان تترتب لوحدها

[Scrox]

الموضوع بسيط خالص انت تروح المكان الفاضى بالشخصية وهناك تعمل ريستارت
للاميل وتعمل الكيورى دى خد كوبى بيست على واضعة كدة وانا حطتلك الكود بتاعك الانت جبتوا :pipe1:
ملاحظة
لازم بعد ريستارت واستخدام كيورى تقفل الجيم سيرفر وتفتحوا تانى
USE SRO_VT_SHARD
DECLARE @RefID int,
@Cord_X int,
@Cord_Y int,
@Cord_Z int,
@Region int

SELECT @Cord_X = PosX,
@Cord_Y = PosY,
@Cord_Z = PosZ,
@Region = LatestRegion

FROM _Char WHERE CharName16 = 'ERIXON'

SELECT @RefID = R.dwTacticsID
FROM Tab_RefTactics R
JOIN _RefObjCommon O
ON O.ID = R.dwObjID
WHERE O.CodeName128 LIKE 'MOB_JUPITER_WATER_PROTECTION_CLONE'

UPDATE TAB_RefNest
SET fLocalPosX = @CORD_X,
fLocalPosY = @CORD_Y,
fLocalPosZ = @CORD_Z,
nRegionDBID = @Region
WHERE dwTacticsID = @RefID

[ruxana]

الكيوري بتاع ERIXON شغال بس افتح الجيم بعد الريستارت مافيش موبس برضو

[Mr Z!dane]

كل اللى هتعملو هتاخد السطور ال RefNest بتاعة ال Mobs ده وتعملها Copy بس بإحداثيات مختلفة هتعمل ال Query ده

USE SRO_VT_SHARD
Go
Declare @ID_MOB int = (Select ID From _RefObjCommon Where CodeName128 Like 'MOB_CH_TIGERWOMAN')
Select * From Tab_RefNest Where dwTacticsID in (Select dwTacticsID From Tab_RefTactics Where dwObjID = @ID_MOB)

هيجبلك ال Spots بتاعة خدها Copy وزود براحتك وعدل على الاحداثيات
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
لو هو ملوش اصلا Spot اعمل ال Query اللى بيعمل Spot لل Monster

USE SRO_VT_SHARD /* Add Unique Spot */

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_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60 -- Minimum time before appears in seconds
SET @maxdelay = 120 -- 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,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!'


هتعمل ال Identity لل Tab_RefNest و ال Tab_RefTactics و Tab_RefHive هتخلى ال IDentity : Yes عشان تترتب لوحدها

كلام مظبوط ، عشان يبقي فيه respond

[Scrox]

الكيوري بتاع ERIXON شغال بس افتح الجيم بعد الريستارت مافيش موبس برضو

:play_ball: بعد ما تعمل كيورى اقفل game_server وافتحوا تانى

[Mr Z!dane]

تابع موضوعك ..

[ruxana]

انا عملت كل الي قالو عليه و بردو مافيش الموبس مش بيتنقل

[Scrox]

افهمنى انت تروح المكأن العايز فية موبس وتعمل ريستارت للشخصية وبعدين ا تعمل الكيورى وتقفل الجيم سيرفر وتفتحوا تانى

ودى كيورى تانى جربوا

USE [SRO_VT_SHARD]
------------------------Made By Erixon----------------------------
DECLARE @KINGEDITOR1 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)

SET @KINGEDITOR1 = 'Mob' ----- Your MOB Name
SET @CHARNAME = 'test' ----- Charactar name [ where you Want to set npc ]

Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @KINGEDITOR1)
Declare @AS2 int SET @AS2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @AS1)
Declare @AS3 int SET @AS3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @AS2)

Declare @ASpos1 int SET @ASpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos2 int SET @ASpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos3 int SET @ASpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos4 int SET @ASpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)

UPDATE Tab_RefNest
SET nregiondbid = @ASpos1,
flocalposx = @ASpos2,
flocalposy = @ASpos3,
flocalposz = @ASpos4
WHERE dwnestid = @AS3 and dwtacticsid = @AS2

[Dev.Ri3o]

يبقى ال Mobs ملوش اصلا Spot عشان يتنقل منو اعملو New Spot زى ما انا مديك ال Query فوق التانى وقف Char واكبت ال Code واعمل New Spot بعد اما توقف ال Char اقفلو وبعدها اعمل ال Query واعمل Restart لل Server Files وشوف

[Scrox]

يغلق لعدم المتابعة

##