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

[Statiic]

just exec...

[lembo12]

Order (execute the first one then the other one and so on..):

tbl_OnlineOffline
->
tbl_RandomPlayer&Date
->
sp_GetRandomTime
->
sp_RandomPlayerID
->
sp_extraSilk
->
sp_GetSilkperHour
->
sp_AddLogChar


tbl = Table
sp = Stored Procedure

SRO_VT_SHARD -> Shard DB
SRO_VT_ACCOUNT -> Account DB
SRO_VT_SHARDLOG -> Log DB

It's should exec ? or leave it ?

when i try to exec it i found proplems
what should i do in it

[s0na]

thnx ;) good work

[lembo12]

Some Help please

[fabien31]

Hello,

First thanks you very much for this release again :)

i have a little question!

I have do some try to make it works and he works properly for win 1 silk every hours,
now i wanted to change a little bit this and make 10 silks every 12h, 30 every 24h

so for this i have try to to add into tbl _Silk/hours-config

defaultsilk colunm
Rates 10 as
Requirements 720

but this is apparently don't works cause nothing happend after 12h

I also tryed to add it into

RewardSilk colunm
Rate 10
Requirements 720

Nothing happend here too

What wrong i do ?

Allowed day was all on 0 tryed whit 1 too

If someone can help me into this issue :)

Thanks you very much if ou read and help

regard
fabien

[serend]

bah i installed this but never seem to get silk added

[Eroticus]

Awesome :) works perfect om Ezma DB :)

Thanks bro :P

[amama]

Done everything according to the guide, but its not working. Am online with non gm and gm acc too since 10 hours, but 0 silk given for them, neither after relog. No idea why.

[amama]

#bump

[Blackdiana]

Hi
Pls help me, this query give 1silk/1hour, I would like to settings it, that 1 silk/3 hours, and the random player is not needed silk. How to need setting this? Ahead thank you for your help.

[VanSoR]

Why It's not work ?

[anikan1985]

isnt working for me , all querys added but noone get silk per hour.

[anikan1985]

working fine now , but its only update the silks evry 24 h ;) but dosnt matter thanks for the script ^, ^

[Sir DeviL]

_Extrasilk isnt working with me gets an error with defination thingy

[Jason1990]

What i've to do with these?

Order (execute the first one then the other one and so on..):

tbl_OnlineOffline
->
tbl_RandomPlayer&Date
->
sp_GetRandomTime
->
sp_RandomPlayerID
->
sp_extraSilk
->
sp_GetSilkperHour
->
sp_AddLogChar


tbl = Table
sp = Stored Procedure

SRO_VT_SHARD -> Shard DB
SRO_VT_ACCOUNT -> Account DB
SRO_VT_SHARDLOG -> Log DB