how to add monster on silkorad maps

Do I need help like adding a monster to my silkroad maps and modifying them?

use the Query to add new Unique spot its work with monster to :)


USE SRO_VT_SHARD

DECLARE @[Only registered and activated users can see links. Click Here To Register...] VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...] = 'MOB_SAVI1' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'Your Char name here' -- 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 @[Only registered and activated users can see links. Click Here To Register...] = 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 = @[Only registered and activated users can see links. Click Here To Register...])

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 @[Only registered and activated users can see links. Click Here To Register...])
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 @[Only registered and activated users can see links. Click Here To Register...])
SET IDENTITY_INSERT Tab_RefHive OFF

/* get position coordinates of your character */

DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT SET @[Only registered and activated users can see links. Click Here To Register...] = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT SET @[Only registered and activated users can see links. Click Here To Register...] = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT SET @[Only registered and activated users can see links. Click Here To Register...] = (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 @[Only registered and activated users can see links. Click Here To Register...],@POSX @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...],0 @[Only registered and activated users can see links. Click Here To Register...],@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!'

ok and to remove any monster anywhere on a map please?

Quote:

Originally Posted by wwatson ok and to remove any monster anywhere on a map please?

USE SRO_VT_SHARD

DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_NPC VARCHAR (max)

SET @[Only registered and activated users can see links. Click Here To Register...]or_NPC = 'MOB_ASA_NORSEGODTYR_EVENT' -- MonsterCodeName or NPC in Table _RefobjCommon

-- ©NorseGodTyr

DELETE FROM [SRO_VT_SHARD].[dbo].[Tab_RefNest]
Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics]
Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where Codename128 LIKE @[Only registered and activated users can see links. Click Here To Register...]or_NPC) )

Quote:

Originally Posted by NorseGodTyr USE SRO_VT_SHARD DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_NPC VARCHAR (max) SET @[Only registered and activated users can see links. Click Here To Register...]or_NPC = 'MOB_ASA_NORSEGODTYR_EVENT' -- MonsterCodeName or NPC in Table _RefobjCommon -- ©NorseGodTyr DELETE FROM [SRO_VT_SHARD].[dbo].[Tab_RefNest] Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics] Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where Codename128 LIKE @[Only registered and activated users can see links. Click Here To Register...]or_NPC) )

Can you show me how to move B4 monsters out of Samakan map

Quote:

Originally Posted by thangchohd0 Can you show me how to move B4 monsters out of Samakan map

use the query and change x y for this mobs or add new spots!

Quote:

Originally Posted by C 9 use the query and change x y for this mobs or add new spots!

Can you give me more specific instructions? I'm new to the job so I'm still young

use this query to add uniques spots / mobs spot

Quote:

USE SRO_VT_SHARD 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 = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z SET @mindealy = 0 -- Minimum time before appears in seconds SET @maxdelay = 0 -- Maximum time before appears in seconds SET @INITRADIUS = 25 -- Radius around spot unique can generated at SET @RADIUS = 30 -- 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!'

Quote:

Originally Posted by C 9 use this query to add uniques spots / mobs spot

Where did you add this mod to this position? and this is the level lv mod
I have just learned to do so many unknown things hope you sympathize with me

Quote:

Originally Posted by thangchohd0 Where did you add this mod to this position? and this is the level lv mod I have just learned to do so many unknown things hope you sympathize with me

put your mob name and make characters to make an spot

Quote:

Originally Posted by thangchohd0 Can you show me how to move B4 monsters out of Samakan map

[Only registered and activated users can see links. Click Here To Register...]