Hello & Welcome to our community. Is this your first visit? Register

Page 2 of 5 FirstFirst 12345 LastLast
Results 16 to 30 of 62
  1. #16
    Member

    Rank
    Member
    Join Date
    Apr 2012
    Posts
    67

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

    Not work for me :(
    Code:
    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".

  2. #17
    Banned nukertube's Avatar

    Rank
    Banned
    Join Date
    Oct 2011
    Location
    Brazil
    Posts
    224

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

    hey any help me ??



    PHP Code:
    Msg 8106Level 16State 1Line 25
    Table 
    'Tab_RefTactics' does not have the identity propertyCannot perform SET operation

  3. #18
    __F0X__ arabianfox's Avatar

    Rank
    True Member
    Join Date
    Nov 2011
    Posts
    292

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

    first post updated ,check the solution for identity error :)

  4. #19
    Banned nukertube's Avatar

    Rank
    Banned
    Join Date
    Oct 2011
    Location
    Brazil
    Posts
    224

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

    PHP Code:
    (1 row(saffected)

    (
    1 row(saffected)
    Msg 515Level 16State 2Line 43
    Cannot insert the value NULL into column 
    'nRegionDBID'table 'SRO_VT_SHARD.dbo.Tab_RefNest'column does not allow nullsINSERT fails.
    The statement has been terminated.
     
     
    Done
    Solved :þ

    Wrong #CharName hhhhhhhhhhhhhhhh
    Last edited by nukertube; 26-06-12 at 12:11 PM. Reason: Solved :þ

  5. #20
    Learning denise456's Avatar

    Rank
    True Member
    Join Date
    Feb 2012
    Location
    Brasil
    Posts
    302

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

    Nice Job Bro Thx.....

  6. #21
    __F0X__ arabianfox's Avatar

    Rank
    True Member
    Join Date
    Nov 2011
    Posts
    292

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

    first post updated :

    add another query for BR files

  7. #22
    Learning PHP *-* Statiic's Avatar

    Rank
    True Member
    Join Date
    Nov 2011
    Location
    Brazil
    Posts
    611

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

    I dont recommend put identity in the table tactics because it works without numerical sequence see the spawn of jupiter works from 10 to 10 ^^

  8. #23
    Ultimate Member nzamkdh's Avatar

    Rank
    Member
    Join Date
    Feb 2009
    Location
    Asian
    Posts
    173

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

    can release for add mobs (normal) not unique only?
    New on cabal svr

  9. #24
    __F0X__ arabianfox's Avatar

    Rank
    True Member
    Join Date
    Nov 2011
    Posts
    292

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

    Quote Originally Posted by nzamkdh View Post
    can release for add mobs (normal) not unique only?
    works too with mobs

  10. #25
    Ultimate Member nzamkdh's Avatar

    Rank
    Member
    Join Date
    Feb 2009
    Location
    Asian
    Posts
    173

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

    i change this :
    PHP Code:
    USE SRO_VT_SHARD /* Add Unique Spot By Arabianfox */

    DECLARE @UNIQUE VARCHAR (129)
    DECLARE @
    CHARNAME VARCHAR (64)
    DECLARE @
    mindealy INT
    DECLARE @maxdelay int
    DECLARE @INITRADIUS INT
    DECLARE @RADIUS int
    DECLARE @MAXNEST int = (SELECT MAX (dwNestIDFROM Tab_RefNest)+1
    DECLARE @MAXHIVE int = (SELECT MAX (dwHiveIDFROM Tab_RefHive)+1
    DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsIDFROM Tab_RefTactics)+1

    /* put your settings here */
    SET @UNIQUE 'MOB_JUPITER_IMMOTAL_GUARD' -- Unique code name from _RefobjCommon table
    SET 
    @CHARNAME 'Alibaba' -- Character name from _Char table to get mob position X Y Z
    SET 
    @mindealy 60  -- Minimum time before appears in seconds
    SET 
    @maxdelay 120  -- Maximum time before appears in seconds
    SET 
    @INITRADIUS 100  -- Radius around spot unique can generated at
    SET 
    @RADIUS 500  -- Radius around spot Unique can move in
    /* end of settings area */

    /* get ID of mob by code name */
    Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)

    SET IDENTITY_INSERT Tab_RefTactics ON
    INSERT INTO Tab_RefTactics 
    (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128VALUES
    (@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE)
    SET IDENTITY_INSERT Tab_RefTactics OFF

    SET IDENTITY_INSERT Tab_RefHive ON
    INSERT INTO Tab_RefHive 
    (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128VALUES
    (@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)
    SET IDENTITY_INSERT Tab_RefHive OFF

    /* get position coordinates of your character */

    DECLARE @REGION INT SET @REGION = (SELECT (LatestRegionFROM _Char WHERE CharName16 = @CHARNAME)
    DECLARE @
    POSX INT SET @POSX = (SELECT (POSXFROM _Char WHERE CharName16 = @CHARNAME)
    DECLARE @
    POSY INT SET @POSY = (SELECT (POSYFROM _Char WHERE CharName16 = @CHARNAME)
    DECLARE @
    POSZ INT SET @POSZ = (SELECT (POSZFROM _Char WHERE CharName16 = @CHARNAME)

    SET IDENTITY_INSERT Tab_RefNest ON
    INSERT INTO Tab_RefNest 
    (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btTypeVALUES
    (@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)
    SET IDENTITY_INSERT Tab_RefNest OFF


    print ''
    print ''
    print 'Done!' 
    and get error :
    PHP Code:
    Msg 102Level 15State 1Line 9
    Incorrect syntax near 
    '('.
    Msg 102Level 15State 1Line 9
    Incorrect syntax near 
    '+'.
    Msg 102Level 15State 1Line 10
    Incorrect syntax near 
    '('.
    Msg 102Level 15State 1Line 10
    Incorrect syntax near 
    '+'.
    Msg 102Level 15State 1Line 11
    Incorrect syntax near 
    '('.
    Msg 102Level 15State 1Line 11
    Incorrect syntax near 
    '+'.
    Msg 137Level 15State 2Line 27
    Must 
    declare the scalar variable "@MAXTACTICS".
    Msg 137Level 15State 2Line 32
    Must 
    declare the scalar variable "@MAXHIVE".
    Msg 137Level 15State 2Line 44
    Must 
    declare the scalar variable "@MAXNEST"
    Please help
    New on cabal svr

  11. #26
    Hardcore Member

    Rank
    Member
    Join Date
    Jan 2012
    Posts
    112

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

    Nice Bro U good man

  12. #27
    Registered

    Rank
    Member
    Join Date
    Jun 2012
    Posts
    16

    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?

  13. #28
    Member

    Rank
    Member
    Join Date
    Feb 2012
    Posts
    29

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

    i get this Stupid errror.
    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".

  14. #29
    Member

    Rank
    Member
    Join Date
    May 2012
    Posts
    50

    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

  15. #30
    __F0X__ arabianfox's Avatar

    Rank
    True Member
    Join Date
    Nov 2011
    Posts
    292

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

    Quote Originally Posted by atossuper View Post
    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.

 

 
Page 2 of 5 FirstFirst 12345 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HyperFilter
Sponsored by HyperFilter , secured by Incapsula , powered by LiteSpeed.
Mods by DBTech. All times are GMT +1. The time now is 04:04 PM.
Powered by vBulletin® Copyright , Jelsoft Enterprises Ltd.