[SQL] Query to add Unique spot very fast

Printable View

Show 100 post(s) from this thread on one page

28-06-12
mesoman

Re: [SQL] Query to add Unique spot very fast

Nice Bro U good man
29-06-12
comfortsro

Re: [SQL] Query to add Unique spot very fast

Great release,

tried --> For the people have Identity error

Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '+'.
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".

Still got this error.. any solutions?
30-06-12
firat0912

Re: [SQL] Query to add Unique spot very fast

i get this Stupid errror.

Quote:

Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '+'.
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".
30-06-12
atossuper

Re: [SQL] Query to add Unique spot very fast

Thanks for this release, can you tell me when exactly this mob or unique appear ? and how we can change the time for make it appear for example every 1 hour
02-07-12
arabianfox

Re: [SQL] Query to add Unique spot very fast

Quote:

Originally Posted by atossuper

Thanks for this release, can you tell me when exactly this mob or unique appear ? and how we can change the time for make it appear for example every 1 hour

SET @mindealy = 3600 >> (3600 seconds = 60 min = 1 hour)
SET @maxdelay = 5400 >> (5400 seconds = 90 min = 1.5 hours)

with this settings Unique will appears every 1 to 1.5 hours but not less than 1 hour and not more than 1.5 hours.
03-07-12
MrPGT

Re: [SQL] Query to add Unique spot very fast

hi guy's

i am a little noob in SQL can any1 tell me how i can fix the SQL ERROR MSG

Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '+'.
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".

?
04-07-12
chinowyc

1 Attachment(s)

Re: [SQL] Query to add Unique spot very fast

How Fix? Attachment 108305
04-07-12
LordShreck

2 Attachment(s)

Re: [SQL] Query to add Unique spot very fast

Attachment 108318 Attachment 108319
04-07-12
collerok

Re: [SQL] Query to add Unique spot very fast

I guess it can be used to spawn NPCs where i want to?
05-07-12
InsaneDev

Re: [SQL] Query to add Unique spot very fast

success but no unique appear
09-07-12
nemo07

Re: [SQL] Query to add Unique spot very fast

that's good query for noobs :)
22-07-12
ahmedov

Re: [SQL] Query to add Unique spot very fast

Doesnt Work Can AnyOne Help I Am Using 2005
24-07-12
K4bo

Re: [SQL] Query to add Unique spot very fast

can i make it spawn like demon or lord
spawn every 2~3h and 4~6h .....etc
04-09-12
trytokillme

Re: [SQL] Query to add Unique spot very fast

Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '+'.
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".

How to fix?
05-09-12
DymerOnline

Re: [SQL] Query to add Unique spot very fast

lol at all the responses xD

The query is good if you wanna add 1 spawn for each monster you wanna have on your server, but if you do it with Uniques then there will be 1 unique on every spawn point you use..

A simple explanation about how the spawns work:

on Tab_RefTactics you will find some basic info about the mob you want to add as a spawn (doesnt need to be added every time you add a spawn).
on Tab_RefHive you will find all the groups of spawns in the game (1 group for each location was created by Joymax, but you can create one group and assign multiple spawns to it).
on Tab_RefNest you will find the spawns themselves, which are linked to the Tactics (dwTacticsID) and to the Hive (dwHiveID)..

This means that if your monster exists on Tactics, you can use it's tactics to create a new spawn, or new spawns..How to find out?

use SRO_VT_SHARD

Select * from Tab_RefTactics where dwObjID = (select ID from _RefObjCommon where CodeName128 like '%Monster Name%')

DwTacticsID is the ID of Tab_RefTactics, a little self explanatory (as if the chinese wanted anybody to edit their db)..

Use your head and look around, you will find a way to change the stuff on your own then ^^ and not use queries that could preety much faq up your db.
12-09-12
nobleknight

Re: [SQL] Query to add Unique spot very fast

Thnx alot bro its working fine ^^ keep it up
16-10-12
ahmedlove13

Re: [SQL] Query to add Unique spot very fast

bro i have problem

Qurey Dont Save
05-11-12
ahmedlove13

Re: [SQL] Query to add Unique spot very fast

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

Re: [SQL] Query to add Unique spot very fast

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
20-12-12
arabianfox

Re: [SQL] Query to add Unique spot very fast

Quote:

Originally Posted by Luukn

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

SQL version is 2005 or 2008 R2 ??!!
20-12-12
Avira

Re: [SQL] Query to add Unique spot very fast

To know all its works only in sql 2008 r2 only

and use your = Brain.exe

its works for me
20-12-12
arabianfox

Re: [SQL] Query to add Unique spot very fast

Quote:

Originally Posted by Avira

To know all its works only in sql 2008 r2 only

and use your = Brain.exe

its works for me

"To Know all" > this including me ?!!!!! :)
20-12-12
Avira

Re: [SQL] Query to add Unique spot very fast

Quote:

Originally Posted by arabianfox

"To Know all" > this including me ?!!!!! :)

1st Best Regards From Me Bro For Share This Query
2nd The One He Cannot Use This is Very Lazy To Follow the Tutorial He Make..
3rd not Including You

You are the Sharing the query

Best Regard From Me
21-12-12
Luukn

Re: [SQL] Query to add Unique spot very fast

Heya =)

iam using SQL 2008r2
04-01-13
Luukn

Re: [SQL] Query to add Unique spot very fast

Hey Guys,

i edited the Code from Arabianfox a little bit, so it will work for ppl who have SQL2005 or some else.
It isnt complex like his one but it works fine =)

Credits go to Arabianfox for this nice Query !!!!! I only edited !!!

Query 1 To findout Monster ID:

PHP Code:

/****** 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%'

--------------------------------------------------------------------------------------------

Query 2 to find out TacticsID from Monster with the ID you found with the code below:

PHP Code:

/****** 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

--------------------------------------------------------------------------------------------

Dont forget to stay the Character at the place where you want to spawn it and log it out before you do all !!!
Ok, now you got all needed Information.

Lets Start with query 3 (Add the Spot to the game):

PHP Code:

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 !'

AGAIN!!!! Credits go to Arabianfox !!!!!!!

I only edited for those who got errors like:

PHP Code:

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".

Show 100 post(s) from this thread on one page