Could you be nice friendly and help with this querry ? just ot make it right :)

[DarkTimess]

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

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

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

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 :)

[MentaL]

[pr0xy1337]

DECLARE @POSX INT SET @POSX -6360

make it

DECLARE @POSX INT SET @POSX = -6360

Also

print 'Done'

[DarkTimess]

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 ?

[pr0xy1337]

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 =)