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


[Daniel]

<a href="https://vborg.vbsupport.ru/showpost.php?p=789743&postcount=10" target="_blank">https://vborg.vbsupport.ru/showp...3&postcount=10</a>
Anyone?

[tnguy3n]

is that the error message when got when you ran the query? :question:

[michaelbenson]

Originally Posted by tnguy3n

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.

Well there is a vb 3.0.X modification pretty identical
https://vborg.vbsupport.ru/showthrea...e+Spent+Forums

Just assumed this was an update of this version.

[TygerTyger]

I've installed it in memberinfo_complete and it seems to be running fine, but it's simply displaying the time spent as numbers, without hours/seconds or whatever. It simply says time spent: 644

Any idea what the problem might be?

[tnguy3n]

Originally Posted by TygerTyger

I've installed it in memberinfo_complete and it seems to be running fine, but it's simply displaying the time spent as numbers, without hours/seconds or whatever. It simply says time spent: 644

Any idea what the problem might be?

check first post. I updated to show user's spent time in profile.

live demo: http://192.168.1.101/vb35/member.php...lastposter&f=2

[TygerTyger]

Works perfectly, thank you very much sir.

I assume the SQL add. is still needed, in which case might be an idea to include it in the Profile version instructions.

I'm not sure if the demo URL is supposed to be based at what appears to be a localhost address lol, but at any rate it doesn't load anything.

[Lea Verou]

It doesn't work for me
No errors but it shows nothing...

[tnguy3n]

Originally Posted by Loukrhtia

It doesn't work for me
No errors but it shows nothing...

That would be correct. You still need to add timeonboard column in user table as in the original hack.

[Lea Verou]

So the recording will start AFTER I install the hack?? vB doesn't record it?
Cause then the result wouldn't be correct!

[tnguy3n]

Originally Posted by Loukrhtia

It doesn't work for me
No errors but it shows nothing...

did you modify your template?