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


[Lea Verou]

Originally Posted by tnguy3n

did you modify your template?

I did. I probably have to run the query.
But before I do it,. please tell me how the recrding is done. Does this hack record it, so it starts recording AFTER its installation or vB records it and the hack just "grabs" the info?

[tnguy3n]

Originally Posted by Loukrhtia

I did. I probably have to run the query.
But before I do it,. please tell me how the recrding is done. Does this hack record it, so it starts recording AFTER its installation or vB records it and the hack just "grabs" the info?

start recording after installation of the hack, cuz vbulletin doesn't keep track on when/how long users login.

[Lea Verou]

Originally Posted by tnguy3n

start recording after installation of the hack, cuz vbulletin doesn't keep track on when/how long users login.

Then it's not an accurate measure.
Sorry, I'll uninstall :/

[tnguy3n]

Originally Posted by smokering

get no errors all went well but get no info looks as if nothing changed?

refresh the page or try to logout then login to see it.

[Gizmo5h1t3]

installed, works a treat.

/me clicks install

[exceem]

Ive had to temp uninstall this, i started to get a few random 1 off mysql errors, and the last thing I changed was this hack, going to leave it a few days and see what happens, anyone else getting errors?

[tnguy3n]

and what error you got?

[eXtremeTim]

How about an avg time per day spent

[tnguy3n]

Originally Posted by eXtremeTim

How about an avg time per day spent

PHP Code:

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


[exceem]

Originally Posted by tnguy3n

and what error you got?

Here is what i got, got around 60 in all

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle




FROM vb3_thread AS thread
LEFT JOIN vb3_forum AS forum USING (forumid)
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)





LEFT JOIN vb3_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(2258,2396,2370,2343,2307,2301,2263,2173,2090,20 66)

GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 10;

MySQL Error : Can't create/write to file '/tmp/#sql_7328_0.MYI' (Errcode: 13) Error Number : 1
Date : Tuesday, October 11th 2005 @ 12:37:44 PM
Script : http://www.exceem.co.uk/index.php
Referrer :
IP Address : IPADDRESSREMOVED
Username : Unregistered
Classname : vB_Database

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