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


[Rahuldhanpat]

Ok frineds......help me here ....

I m sending my class_core.php plz edit it according to above said and plz give me again......i tried but some error came and my stop to function plz help me

And also tell me where to write query"don't mind i m new to this"Learning

[Rahuldhanpat]

still no replies

[Rahuldhanpat]

Plz send me this file via link .... PM me plz...

[Rahuldhanpat]

i m not able to run the queries even i made changes in the config.php

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['Admin']['canrunqueries'] = '';

// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$config['Admin']['undeletableusers'] = '';

// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$config['Admin']['superadministrators'] = '1';

Even now same prob...... I m not authorized to run query....

[YOimYO]

Just installed on 3.54.

Not working.

did all template edits, data base changes, and plugin uploads.

time on board remains at 0 forever


any suggestions ?


thx



EDIT :

OK found me prob. nvm

works perfect on 3.54


thanks alot for the usefull hack

[jodycwilliams]

What'd you do to fix it, cause I'm having the same problems? I have the sucker installed per instructions but getting jack to display on the my template.

Thankfully, it is recording the time spent on boards into the DB already, just need to get it to display now.

[jodycwilliams]

Fixed already, thanks anyhow :P

Great hack. Not the most fun install, but well worth it.

[tanyeri24]

it stopped to count immediately hmm I had no changes in templates and no changes at plugin. I checked the installation again but all fine still stopped to count, is there an answer?
thanks in advance

[lifesourcerec]

Still does it in seconds and xml file is not converting to days, hours, seconds. Guess I uninstall.

[JohnBee]

Hmm installed on 3.5.4

Only the profile version, no display.
Added the query - still nothing.
Installed the original .xml hoping it would spark a response (no go)
Remove the conditional to force display in profile template, I get the writting but no data is display'd

Very odd...

I'll uninstall it unti its sorted out. Nice idea though. I can't wait to use it

How can we remove the Query?
ALTER TABLE `VB_user` DROP `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity` ; (Does not work)