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

[LordCloud]

I have changed now the last query. Here is my result. Maybe someone can check it.

 /* old Calculation of the silk amount*/
	/* 
	Declare @tMinutes bigint;
	Declare @Silk int;
	set @tMinutes = (SELECT [Minutes] from _OnlineOffline WHERE CharID = @CharID)
               
    IF (@tMinutes >= 60)
    BEGIN
	SET @Silk = CAST(((SELECT [Minutes] FROM _OnlineOffline WHERE CharID = @CharID) / 60) as int)
        UPDATE _OnlineOffline
        SET [Minutes] = [Minutes] % 60
        WHERE CharID = @CharID
		
		IF exists (SELECT [WEEKDAYS] FROM [_Silk/Hour-Config] WHERE [WEEKDAYS] like 'Montag' or [WEEKDAYS] like 'Dienstag' or WEEKDAYS like 'Mittwoch' or WEEKDAYS like 'Donnerstag' or WEEKDAYS like 'Freitag' or WEEKDAYS like 'Samstag' or WEEKDAYS like 'Sonntag')
        BEGIN
            UPDATE _OnlineOffline
            SET [eSilk] = [eSilk] + (@Silk*[Silk/Hour])
            WHERE CharID = @CharID
                    
				exec SRO_VT_ACCOUNT.dbo._extraSilk @CharID, @Silk
        END
    END
	*/
	/* new extansion */
	declare @CharIDSS	 int;
	Declare @Silk int;
	declare cur CURSOR for
		select CharID from _OnlineOffline
		where Status = 'Online' and [Minutes] >= 60;
	open cur
	fetch next from cur into @CharIDSS
	while @@FETCH_STATUS = 0 
	BEGIN
		SET @Silk = CAST(((SELECT [Minutes] FROM _OnlineOffline WHERE CharID = @CharIDSS) / 60) as int)
		UPDATE _OnlineOffline
		SET [Minutes] = [Minutes] % 60
		WHERE CharID = @CharIDSS
		IF exists (SELECT [WEEKDAYS] FROM [_Silk/Hour-Config] WHERE [WEEKDAYS] like 'Montag' or [WEEKDAYS] like 'Dienstag' or WEEKDAYS like 'Mittwoch' or WEEKDAYS like 'Donnerstag' or WEEKDAYS like 'Freitag' or WEEKDAYS like 'Samstag' or WEEKDAYS like 'Sonntag')
		BEGIN
			UPDATE _OnlineOffline
			SET [eSilk] = [eSilk] + (@Silk*[Silk/Hour])
			WHERE CharID = @CharIDSS
                    
			exec SRO_VT_ACCOUNT.dbo._extraSilk @CharIDSS, @Silk
		END
	fetch next from cur into @CharIDSS
	end
	close cur
	deallocate cur

[TryToMakeServer]

Well for me it doesnt work either.
Time isnt counting, neither "Onhold" doesnt change to "Online".
Also silk isnt loading, if I manual change "Onhold" to "Online", while the time is counting.
Im using mssql 2008 r2.

Thanks in advance, if somebody could help me out here.

[LordCloud]

You have to restart server to make everything fine.
Maybe you missed something ?

[TryToMakeServer]

I had restarted agent, shard and gameserver once.

I have looked into the txt files more than 8times.

No idea whats wrong.

Should I restart the mssql server aswell?

[TryToMakeServer]

So... I have reinstalled the whole host server.
Installed a fresh copy of mssql 2008 R2.
And it still doesnt work.
I have no clue, I will give up from my side.
If anyone knows a solution, thx in advance and bye :)

[Omar Fouad]

GJ !

imported , testing right now !

[Royalblade]

Well for me it doesnt work either.
Time isnt counting, neither "Onhold" doesnt change to "Online".
Also silk isnt loading, if I manual change "Onhold" to "Online", while the time is counting.
Im using mssql 2008 r2.

Thanks in advance, if somebody could help me out here.

if ur using a GS addon like evangelion or srzor... there is a function called: DisableLogs...
you have it enabled.
You NEEED logs for this to work.

[infor]

will someone shares a guide to work 100% please

[stele22]

Worked like a charm until i deleted all user accounts. Since then it counts minutes and shows online/offline but dun get silk at all. Anyone have fix for that?

EDIT: Tested on fresh server (110 based server), all queries were ok and it counts minutes and esilk but it dun give silk to chars.

[asianking]

mines the opposite. i get silk but minute doesnt count. Always stated " You have played 0 hour".

[stele22]

mines the opposite. i get silk but minute doesnt count. Always stated " You have played 0 hour".

I get that 2 but still no silks on account. Worked whole night on that and i'm so close of giving u up on that. Reinstalled Server 2008 R2, SQL 2008 R2 and all files twice and it still don't work even tho it counts everything as is it should. No errors. And i don't even know why it worked in the first place, before i deleted all user accounts.

[InPanic Kev]

Its so easy to make a Online System ..

Just Log ( Online / Offline ) Players via ( _LogEventChar ) in a Table .. after this Check if the Online Count is >= 60 exec addSilk + Log



whats the problem ? :P

[stele22]

Its so easy to make a Online System ..

Just Log ( Online / Offline ) Players via ( _LogEventChar ) in a Table .. after this Check if the Online Count is >= 60 exec addSilk + Log



whats the problem ? :P

I've done it all over gain and it works now. I don't wanna touch anything in DB. If it works - dun change it.
Question: how did you make that "you have earned 1 coin" thing?

EDIT: Me again :/ Still don't work as it should. It counts esilk for some people and don't count for others. Also on server start everyone got 1 silk but after 1 hour no one got silk. What is wrong now? This sh!t is driving me crazy! I've checked DB like 10000 times and still can't find any errors in tables and sp's.

[asianking]

if I check on database, I have the minute there... but in game, it doesn't show how many hour I played.

[stele22]

Worked for 3 weeks and the suddenly stopped after 3 weeks.



I've look at the logs and checked did anything happen on that time (4th of December at 23:43:44) and nothing happen' then. Is it safe for me to delete all tables related to silk/hour from db and drop them again? Or there is another solution? Forgot to mention that it doesn't count time, doesn't check online or offline... Anyone had problem like this?