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`; 


[Bones_3DFC]

To undo the query can we simply run a new query with "drop?"
Example:

ALTER TABLE `VB_user` DROP `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity` ;

[curriertech]

How hard would it be to let users decide if they want this to show, instead of it being forum-wide? I have a rather tempermental group on my hands, and while some really like this feature, others are crying about it already.

[tnguy3n]

Originally Posted by exceem

Here is what i got, got around 60 in all


had no errors today, going to reinstall tomorrow and moniter what happens

from the error warning, it must be some other hacks causing that because this hack has nothing to do with showthread or viewing forum query. It only updates the 'timeonboard' field in user table.

[tnguy3n]

Originally Posted by Bones_3DFC

To undo the query can we simply run a new query with "drop?"
Example:

ALTER TABLE `VB_user` DROP `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity` ;

yup, and reverse your modified file.

[tnguy3n]

Originally Posted by curriertech

How hard would it be to let users decide if they want this to show, instead of it being forum-wide? I have a rather tempermental group on my hands, and while some really like this feature, others are crying about it already.

Just simply add an additional field which give users an options whether to show that or not. Then in plugin, put a condition to check whether to show it.

[tanyeri24]

Originally Posted by exceem

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

is there?

[exceem]

Originally Posted by tnguy3n

from the error warning, it must be some other hacks causing that because this hack has nothing to do with showthread or viewing forum query. It only updates the 'timeonboard' field in user table.

The only other hacKs i have installed is vbadvanced, and a "whos visited today"

Ill reinstall today and see what happens, had it just been over1 day I would have put it down to a server glitch, but over 3 days it woudl be something else :ermm:

[eXtremeTim]

Originally Posted by tnguy3n

PHP Code:

$average = (TIMENOW - $post[joindate])/86400; 


Umm that wont work quite right lol. That would give me the number of days they have been registered.

Now I think I see what your saying lol. Your giving me a way to get to the solution.

I didnt need any help there lol I was just more or less trying to suggest it as a feature becuase the 3.0.x version had it as a feature.

[tnguy3n]

Originally Posted by eXtremeTim

Umm that wont work quite right lol. That would give me the number of days they have been registered.

Now I think I see what your saying lol. Your giving me a way to get to the solution.

I didnt need any help there lol I was just more or less trying to suggest it as a feature becuase the 3.0.x version had it as a feature.

lol... my bad.
try:

PHP Code:

$average = $post[timeonboard]/((TIMENOW - $post[joindate])/86400); 


[GamerJunk.net]

Sorry if this has been asked before, but does this also include time spent in the admincp?