vsro silk per hour how to set a limit

Results 1 to 1 of 1
  1. #1
    Newbie Nohduen is offline
    MemberRank
    Mar 2013 Join Date
    4Posts

    vsro silk per hour how to set a limit

    Can someone Tell me how I can make an Maximum amount of Silks, Like if some have 350 Silks thats the Script dont give him more

    I think i can change it Here:
    WHEN @totalMinutes >= (SELECT [Step3Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements')
    THEN (SELECT [Step3Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates')
    WHEN @totalMinutes >= (SELECT [Step2Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements')
    THEN (SELECT [Step2Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates')
    WHEN @totalMinutes >= (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements')
    THEN (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates')
    ELSE (SELECT DefaultSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates')
    END
    I tried a declare with IF ELSE, but i failed, can some one Help me :P ?




Advertisement