About TotalOnlineTime sort of

I Have Total online time but i want another one that counts only how much time you were online in 1 Week and after that resets to 0 automaticly? Can someone tell me how this could be done?

Quote:

---

Originally Posted by LasTCursE

I Have Total online time but i want another one that counts only how much time you were online in 1 Week and after that resets to 0 automaticly? Can someone tell me how this could be done?

---

Modify WZ_BLABLA_DISCCONECT stored procedure to save online count also to example (OnlineTime2)

Then do SQL Job to execute query every 1 week like....

Code:

---

Update MEMB_STAT Set OnlineColumn = 0

---

and done, simple isn't it?

Cheers

Well thank you Sir ! :)

Cheers