Inset into top10

Results 1 to 3 of 3
  1. #1
    Sorcerer Supreme serend is offline
    Member +Rank
    Mar 2012 Join Date
    eurosro.coLocation
    338Posts

    Inset into top10

    trying to make script insert into top 10 players items ill set this as a cronjob but kind stuck on how to link/nsert into the charname::

    Code:
    SELECT TOP 10 * FROM _JobRank WHERE JobType = 1 ORDER BY Rank
    declare @CharName varchar(64) 
    set @CharName = 'Test'
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_01',100,0
    or would this work

    Code:
    (SELECT TOP 10 CharName FROM _JobRank WHERE JobType = 1 ORDER BY Rank = 
     (EXEC _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_01',100,0'))


  2. #2
    Sorcerer Supreme serend is offline
    Member +Rank
    Mar 2012 Join Date
    eurosro.coLocation
    338Posts

    Re: Inset into top10

    bump any help please

  3. #3
    Sorcerer Supreme serend is offline
    Member +Rank
    Mar 2012 Join Date
    eurosro.coLocation
    338Posts

    Re: Inset into top10

    bump again



Advertisement