[SQL] Query to add Unique spot very fast

[Luukn]

Sorry , was an double Post

[Nexus2oo7]

How to make 3-4 Spawnpoints for ONE unique? Now i got 4 spawnpoints and 4 uniques.

[Royalblade]

Nexus2oo7

use the dwhiveid and dwtacticsid from the previous uniques and simply run this crap

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) 

[Nexus2oo7]

can you explain it?

with an full example?

[DarkTimess]

I getting this error

Made a therad to get help from others to

http://forum.ragezone.com/f739/nice-...5/#post7823395

How i fix it and where did i do wrong in the code ?

[DarkTimess]

Is there anything i need add into media ? i added in the unique it stand it has spawn but i cant see any unique there i put the cords O.o

[sroYunk]

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 ?

[sroYunk]

yeah Thats what iam ask me too

any one got a Good answer for this ?

still no one have a idea =?

[Alexstars]

ty if i want descent in a specific time hourly every day How can I, for example, every day at 20:00

[lepitismak]

and for remove?

[MissinGDeaTh]

when i try to set identity for refobjcommon and refobjchar this error appears

'_RefObjChar' table
- Unable to create index 'PK__RefObjChar'.
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._RefObjChar' and the index name 'PK__RefObjChar'. The duplicate key value is (18004).
Could not create constraint. See previous errors.
The statement has been terminated.

[CandyQ]

Msg 8106, Level 16, State 1, Line 25
Table 'Tab_RefTactics' does not have the identity property. Cannot perform SET operation.!!!

[sacphonghung]

I set mindealy = 60 max dealy = 120 . I donot see the unique app??