Total Time Spent On Forums

Total Time Spent On Board
Author: tnguy3n
Live Demo: http://12.226.255.221/vb35

This hack shows total time that users spent on the board.

To show all time units including seconds, minutes, hours, etc, uncomment lines for thoese variables in "Total Spent Time On Board" plugin.

Query: 1
File modification: 1
Plugins: 2
Template mod: 2

Update: 10/12/05
Add option to show user's total spent time on forums in the profile.
If you want to run the User's Total Spent Time In Profile as an stand-alone hack, you have to run run following query:

PHP Code:

ALTER TABLE `user` ADD `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity`; 


[Lea Verou]

Originally Posted by Danieldude

Okay, if there is no way to use this without a query, how would I do it in phpMyAdmin? But when I submit the query I get "You have to choose at least one column to display"

Will it work if I put it in memberinfo instead of postbit? I really like it but I want a more minimal postbit...

[utw-Mephisto]

Wanted to check demo but your site seems to be down s

[tnguy3n]

Originally Posted by Loukrhtia

Will it work if I put it in memberinfo instead of postbit? I really like it but I want a more minimal postbit...

You can change the hook to memberinfo_complete, then change all vars $post['timeonboard'] to $userinfo['timeonboard'].

[Lea Verou]

Originally Posted by tnguy3n

You can change the hook to memberinfo_complete, then change all vars $post['timeonboard'] to $userinfo['timeonboard'].

Wait, I don't know php, I am only good on changing templates! :P
If I just put $userinfo['timeonboard'] in place of $post['timeonboard'] will it work?
Or do I have to alter the code too? What specifically should I do in the php code?

[smokering]

get no errors all went well but get no info looks as if nothing changed?

[FleaBag]

Originally Posted by tnguy3n

It tracks the time when a user start to login 'til (s)he logout (or timeout), then add up to total & store in database.

Ahh! Wondered if it takes into the past too, thought it was too good to be true!

Nice hack though, I'll use it.

[exceem]

installed, changed the hook so it would display on the member info but all i see is "time on board : sec"

any ideas?

[edit]

fixed had to edit the sql to include my table prefix[/edit]

[exceem]

is there any way to display a "top 10 list of the time spent online" ?

[michaelbenson]

I had a 3.0.X version of this hack installed, does this mean that the Total Time Spent will be from when i installed that version, or upgraded to this?

[tnguy3n]

Originally Posted by michaelbenson

I had a 3.0.X version of this hack installed, does this mean that the Total Time Spent will be from when i installed that version, or upgraded to this?

this plugin is written for vb 3.5, not an update or port of any hack. Check if the hack you installed coincidently had the field name, then you don't have to alter user table, and it would calculate your time rather than new time of this plugin.