[SQL] auto free Silk/Hour based on the Online time (System)

[L0ckam]

Everything works but dont add any silk to chars :S

[infor]

like putting the car free silk look in minutes active time

will someone passes me a tutorial on how to configure this application

[tk69]

not work full bug /:

[tschulian]

Works 50:50, but it wont update the OnlineOffline table when new chars are created..

[DrugDealers]

good release

[nex92]

I got a problem i add all tables and strored procedures like you write on topic.
I using SQL Manager 2012 and SQL Express 2012 everything worknig fine without adding silks after 60 mins + gone.
I already waiting 100 mins and didnt get the silks.Trying to Relog,Teleport,Restart the server and nothing.

Maybe someone find the solution how to fix it on SQL 2012?
Thanks for answers.

[dunarsund]

@ _AddLogChar :)


from

    IF exists (SELECT [WEEKDAYS] FROM [_Silk/Hour-Config] WHERE [WEEKDAYS] like DATENAME(WEEKDAY, GETDATE()))
        BEGIN
            UPDATE _OnlineOffline
            SET [eSilk] = [eSilk] + (@Silk*[Silk/Hour])
            WHERE CharID = @CharID
                    
            exec SRO_VT_ACCOUNT.dbo._extraSilk @CharID, @Silk
        END 

to »

IF exists (SELECT [WEEKDAYS] FROM [_Silk/Hour-Config] WHERE [WEEKDAYS] = DATENAME(WEEKDAY, GETDATE()))
    BEGIN
        Declare @CurLevel smallint;
        SELECT @CurLevel = CurLevel FROM SRO_VT_SHARD.dbo._Char with(NOLOCK) WHERE CharID = @CharID
        
        IF (@CurLevel >= 60)
            BEGIN
                UPDATE _OnlineOffline
                SET [eSilk] = ISNULL([eSilk],0) + (@Silk*[Silk/Hour])
                WHERE CharID = @CharID
                    
                exec SRO_VT_ACCOUNT.dbo._extraSilk @CharID, @Silk
            END
    END 

Ok i tried this code but i get an error wich says "Incorrect Syntax near 'END'

Some help will be greatly appreciated :)

[asianking]

worked for me, but the auto notification always show play 0 hour. I do get the silk, but the auto notification is showing wrong hour.

[tschulian]

I was checking out the whole query and added one thing which increases the performance enormously. Because without that little "addon" the WHOLE tables is being updated everytime a Char Triggers the _AddLogChar Procedure.



And can some1 tell me what eSilk means?
Since what I found it the only possible thing is that this are the Amount of Silks given out in total. Am I right?

[hellspawn80]

still work good! i added it to Blackrogue 110cap DB with SQL 2014!

thx