Could you be nice friendly and help with this querry ? just ot make it right :)
Hello.
So well i have never used a add unique spot querry befor and i got hard understand how it is to add one.
So after i tryed this one
Code:
USE SRO_VT_SHARD
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! !'
and maked it to
Code:
USE SRO_VT_SHARD
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @TACTICS int
DECLARE @Amount int
SET @CHARNAME = Raizo
SET @mindealy = 60
SET @maxdelay = 120
SET @INITRADIUS = 200
SET @RADIUS = 300
SET @Amount = 2
SET @TACTICS = 38640
DECLARE @REGION INT SET @REGION = Raizo
DECLARE @POSX INT SET @POSX -6360
DECLARE @POSY INT SET @POSY = 30,0410461
DECLARE @POSZ INT SET @POSZ = 1426
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
And i getting errors
PHP Code:
Msg 102, Level 15, State 1, Line 22Incorrect syntax near '-'.Msg 102, Level 15, State 1, Line 23Incorrect syntax near ','.Msg 128, Level 15, State 1, Line 48The name "Done" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
Could anyone tell me where i did wrong to fix it ? :)
Thanks.
P.S this querry was made from
arabianfox
On link
http://forum.ragezone.com/f722/sql-q...e-spot-855558/
Querry changed on page 4 from
Luukn the 2005 version
that is the one i am using.
Thanks :)
Re: Could you be nice friendly and help with this querry ? just ot make it right :)
Code:
DECLARE @POSX INT SET @POSX -6360
make it
Code:
DECLARE @POSX INT SET @POSX = -6360
Also
Re: Could you be nice friendly and help with this querry ? just ot make it right :)
Alriht looks good. errors are gone now i getting this error
Msg 102, Level 15, State 1, Line 25
Incorrect syntax near ','.
but i cant find the ','. i will keep looking see if i can find but if i not i hope you can see it :)
It is this one that i getting error from. My PosY is there and its in temple
DECLARE @POSY INT SET @POSY = 30,0410461
So what to do ?
Solved :)
had to remove the , to a . :P
But i cant see any unique here O.o Any ides ? anything i need add in the media pk2 that i have add a spot here or ?
Re: Could you be nice friendly and help with this querry ? just ot make it right :)
No you just have to wait, let your server open for few hours or whatever time u specified there it will spawn.. If added correctly ofc =)