That query resets both the average time and the total time. The average time is not stored, it is calculated.

Maybe I should explain how I the average time works, as the < 1 sec might not be a problem at all. The average time is calculated by

time spent on board / days since you registered

that is, if you have been on the board for 50 minutes and you registered 2 days ago the average time would be 25 minutes. If you don't login for two days your average time drops to 12 minutes since you have 4 days registered.

In that case since this hack is new you may have very small total time spent, maybe your user has 10-20 minutes. If you registered a year ago that is 10 minutes / 365 days.. that is a very low number and maybe less than 1.

This is also how the average post count in the forum works, it makes a total posts / days since you registered

kentaurus :

how often does it update the "time spent in foruns" field?

Everytime you click on a link in the forum.

It wont work for Rc3 for me

Same here...

I actually got mine to say "2" instead of <1 but it never goes above that.. any suggestions guys?? I have to get this hack working! :)

Second page would be better. There enough stuff on the member list as it is.

Did you re-made all the file changes for RC3? It's working in my RC3 board.

mharmon, could you give me the registered date and total spent time for the user that appears with "2"?

There comes a time in every man's life that he must admit he is a dumb ass.

I was changing the wrong line in sessions.php . . . It works great when you change the right one.

Thanks for this great hack! :)

Working great for me on RC3, thanks kentaurus.! :)

An update for this one. Some extra modifications that will let you add the board spent time (total and average) to the memberlist. You can also sort by it to see who is the user with most board spent time.