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


[puertoblack2003]

great Hack *******INSTALLED**** no problems

[board.trash]

another nice hack from my friend tnguy3n

Thx ( clicks install )

[MissKalunji]

nuthing showing for me......

[tnguy3n]

@ board.trash: thanks, mate.

@ MissKalunji: try to add modify both postbit and postbit_legacy templates.

[MissKalunji]

Originally Posted by tnguy3n

@ board.trash: thanks, mate.

@ MissKalunji: try to add modify both postbit and postbit_legacy templates.

im trying on the member info page....

[tnguy3n]

Originally Posted by MissKalunji

im trying on the member info page....

It was meant to be an add-on for the Total Time Spent On Forums; however, if you want to install it as a stand-alone, you have to run the following query:

PHP Code:

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


[MissKalunji]

Originally Posted by tnguy3n

It was meant to be an add-on for the Total Time Spent On Forums; however, if you want to install it as a stand-alone, you have to run the following query:

PHP Code:

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


not working thanks anyway

[ImportPassion]

couldn't this be put in a plugin and called on init_startup?

PHP Code:

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 timeonboard = timeonboard + $newtime
        WHERE userid = " . $this->userinfo['userid'].""); 


or am i way off base?

[Chris M]

Moved to correct forum

Chris

[nintendo]

If you get..

You have to choose at least one Column to display

in phpMyAdmin, go to 'user' then use the 'Run SQL query/queries on database' form there, at the bottom