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

Code:

---

DECLARE @POSX INT SET @POSX -6360

---

make it

Code:

---

DECLARE @POSX INT SET @POSX = -6360

---

Also

Code:

---

print 'Done'

---

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 ?

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