Initiate Mage
- Joined
- May 13, 2012
- Messages
- 1
- Reaction score
- 0
Thnx alot bro its working fine ^^ keep it up
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
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 ?