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


[Virtuosofriend]

Did everyone else freeze after upgraded to 3.5.4?

[mvolking]

Originally Posted by Virtuosofriend

Did everyone else freeze after upgraded to 3.5.4?

I'm running 3.5.4 and no problems.

[Virtuosofriend]

Hmmm.Do you have to edit a php file or something?

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

Can you post here the file modification,if any,it seems it is not in the instructions.

[hotwheels]

Originally Posted by Virtuosofriend

Hmmm.Do you have to edit a php file or something?

Can you post here the file modification,if any,it seems it is not in the instructions.

here ya go:

[Total Time Spent On Board
Author: tnguy3n
Live Demo: http://www.vbviet.org

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 mod: 1
Template mod: 1

#----------------------- \?/ ----------------------#

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


######### FILE MODIFICATION ##########
Open includes/class_core.php, (1 change)

FIND:

// on this to be updated in real time.
$this->registry->db->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET lastactivity = " . TIMENOW . "
WHERE userid = " . $this->userinfo['userid'] . "
", 'lastvisit');

REPLACE WITH:

// on this to be updated in real time.
/* $this->registry->db->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET lastactivity = " . TIMENOW . "
WHERE userid = " . $this->userinfo['userid'] . "
", 'lastvisit');
*/

if(TIMENOW - $this->userinfo['lastactivity'] > $this->registry->options['cookietimeout'])
{
$newtime = '0';
}
else
{
$newtime = TIMENOW - $this->userinfo['lastactivity'];
}
$this->registry->db->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET lastactivity = " . TIMENOW . ",
timeonboard = timeonboard + $newtime
WHERE userid = " . $this->userinfo['userid'] . "
", 'lastvisit');


########## PLUGINS ###########
UPLOAD timeonboard.xml plugin

########## TEMPLATE MOD ############

In postbit(_legacy),

FIND:

<div>
$vbphrase[posts]: $post[posts]
</div>


BELOW, ADD:

<div>
<strong>Time spent on board:</strong><br /> $post[timeonboard]
</div>

<! --- all done --- >

[lifesourcerec]

It's still not calculating into days, hours, etc. and I've uploaded the plugin.

[xlegends]

For Those Not using Postbit Legacy and using postbit only. Basically modified postbit same way

########## TEMPLATE MOD ############

In postbit,

FIND:

				<div>
					$vbphrase[posts]: $post[posts]
				</div>


BELOW, ADD:

				<div>
					<strong>Time spent on board:</strong><br /> $post[timeonboard]
				</div>

<! --- all done --- >

[Virtuosofriend]

Originally Posted by hotwheels

here ya go:

thanks very much.It seems i had some problems reading the readme text ;x

[deeps_ar]

Is this working now? Can I go ahead and install it?

[---MAD---]

does this work on 3.5.4?

[speedracer68]

I too have the same question. Does it work in 3.5.4? I'm sure some of the guys on my site will be shocked. Also, is the count retroactive or only from the point I install it and on?