Initiate Mage
- Joined
- May 13, 2012
- Messages
- 1
- Reaction score
- 0
Thnx alot bro its working fine ^^ keep it up
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!its also the
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near 'dwNestID'.
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '+'.
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 27
Must declare the scalar variable "@MAXTACTICS".
Msg 137, Level 15, State 2, Line 32
Must declare the scalar variable "@MAXHIVE".
Msg 137, Level 15, State 2, Line 44
Must declare the scalar variable "@MAXNEST".
in my query =(
i looked into all sites but there is no answer to anyone heere
To know all its works only in sql 2008 r2 only
and use your = Brain.exe
its works for me
1st Best Regards From Me Bro For Share This Query"To Know all" > this including me ?!!!!!
/****** Script for Select Object info from RefObjCommon Table by Luuk ******/
SELECT TOP 1000 [ID]
,[CodeName128]
FROM [SRO_VT_SHARD_INIT].[dbo].[_RefObjCommon]
WHERE [CodeName128] like '%TIGERWOMAN%'
/****** Script for Select ID`s command from Tactics Table by Luuk ******/
SELECT TOP 1000 [dwObjID]
,[dwTacticsID]
FROM [SRO_VT_SHARD_INIT].[dbo].[Tab_RefTactics]
WHERE [dwObjID] like '1954' -- Type in ID of a Monster from _RefObjCommon
USE SRO_VT_SHARD_INIT /* Add Unique Spot By Arabianfox */ ----> Updated by Luuk <----
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @TACTICS int
DECLARE @Amount int
/* put your settings here */
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table you logged off, to get mob position X Y Z
SET @mindealy = 10800 -- Minimum time before appears in seconds
SET @maxdelay = 21500 -- Maximum time before appears in seconds
SET @INITRADIUS = 600 -- Radius around spot unique can generated at
SET @RADIUS = 700 -- Radius around spot Unique can move in
SET @Amount = 1 -- XX Times this Unique will appear max (i only checked 1 -20)
SET @TACTICS = 33 -- give in dwTacticsID (You will find it in Tab_RefTactics 33 = TigerWoman)
/* end of settings area */
/* 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
(
dwHiveID,
dwTacticsID,
nRegionDBID,
fLocalPosX,
fLocalPosY,
fLocalPosZ,
wInitialDir,
nRadius,
nGenerateRadius,
nChampionGenPercentage,
dwDelayTimeMin,
dwDelayTimeMax,
dwMaxTotalCount,
btFlag,
btRespawn,
btType
)
VALUES
(105,@TACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,@Amount,0,1,0)
print 'Done! Restart Server and Uniq/Mob will spawn there !'
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near 'dwNestID'.
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '+'.
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 27
Must declare the scalar variable "@MAXTACTICS".
Msg 137, Level 15, State 2, Line 32
Must declare the scalar variable "@MAXHIVE".
Msg 137, Level 15, State 2, Line 44
Must declare the scalar variable "@MAXNEST".
use SRO_VT_SHARD
declare @charname varchar (50)
set @charname = 'Royalblade'
declare @dwnestID int
set @dwnestID = (select top 1 dwnestID from Tab_RefNest order by dwNestID desc)+1
declare @region int
declare @curx int
declare @cury int
declare @curz int
set @region = (select LatestRegion from _char where charname16 = @Charname)
set @curx = (select posx from _char where charname16 = @Charname)
set @cury = (select posy from _char where charname16 = @Charname)
set @curz = (select posz from _char where charname16 = @Charname)
insert Tab_RefNest (dwNestID, dwHiveID, dwTacticsID, nRegionDBID, fLocalPosX, fLocalPosY, fLocalPosZ, wInitialDir, nRadius, nGenerateRadius, nChampionGenPercentage, dwDelayTimeMin, dwDelayTimeMax, dwMaxTotalCount, btFlag, btRespawn, btType)
values (@dwnestID, YOUR DWHIVEID HERE,your dwtacticsid here, @Region, @curx, @cury, @curz, 1000, 1000, 200, 0, 18000, 23000, 1, 0, 1, 0)
How to make 3-4 Spawnpoints for ONE unique? Now i got 4 spawnpoints and 4 uniques.
yeah Thats what iam ask me too
any one got a Good answer for this ?