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

Everything works but dont add any silk to chars :S

like putting the car free silk look in minutes active time

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

:scared:

not work full bug :(:/:

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

good release

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.

Quote:

---

Originally Posted by Caipi

@ _AddLogChar :)


from

PHP Code:

---

    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 »

PHP Code:

---

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 :)

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.

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.

http://i.imgur.com/2OtixlB.png

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?

http://i.imgur.com/TG7tTJa.png

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

thx