[VB3 RC3] Board Spent Time

This hack keeps track of how much time a user has been online at the
forums and adds it to the information in any of his posts, then any
other user can see if you have been 1 hour, 5 hours, 1 day or even up
to years online at the forum.

Also this hack calculates an "average time online" in a very similar way to
how the average posts works.

Thanks to the people that suggested this hack in the request forum, it is
a really nice one and a very fun one too!

Keep in mind this hack will only start tracking the time that you are online once you install it, it has no way of knowing how much time you had been on the forums before.


*Update*: You can show the board spent time in your memberlist, then you can use your memberlist as a leaderboard. For this modification see this post: https://vborg.vbsupport.ru/showpost....6&postcount=50


Info for hackers:
You may modify, improve, upgrade, redistribute this hack, include it
in another hack or yours or translate it provided you do it free of
charge and you distribute it in www.vbulletin.org at least, there is no
need to pm me asking for permission
Some portions of the code are (c) Jelsoft Enterprises Ltd.

[enginethatcan't]

HUGE PROBLEM!!!

some reason my members names are not showing up in the posts anymore!!!

I uploaded all orginal files, and templates. WHAT CAN I DO???

[Reeve of shinra]

* installed

It will be interesting to see how much time people waste away on my site.

[Kentaurus]

Originally Posted by enginethatcan't

HUGE PROBLEM!!!

some reason my members names are not showing up in the posts anymore!!!

I uploaded all orginal files, and templates. WHAT CAN I DO???

revert your postbit and postbit_legacy template, that should do it.

[Kentaurus]

Originally Posted by alfaowner

Okay, sorry, but where would the $timespent go? I really have no idea. Myine is also not showing up, i tried both tempaltes too! I am using the new style forum just like this one with drop down links etc...

Anywhere you want. Edit your postbit or postbit_legacy template and add $timespent before Posts: for example

[Kentaurus]

Originally Posted by kennethj

When installing the addition - running the install ... php file gives and error:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: 
  UPDATE setting SET optioncode='
  <input type=\\\ ...
... </table>'
  WHERE varname='memberlistfields'
mysql error: Table 's####freaky.setting' doesn't exist

mysql error number: 1146

Date: Wednesday 03rd of March 2004 10:53:32 AM
Script: http://www.freakybutfun.com/forum/ad...st.php?start=1
Referer: http://www.freakybutfun.com/forum/ad...memberlist.php

the table is wrong :: should be 'vB3s####freaky.setting' ::

is Not adding the table prefix sor some reason.
Is there another way to run this ? thru the admin cp? or what is going wrong as everything else with the board is working with no problems.

admin cp is renamed -



great hach and addition - thanks

I updated the install.php so it takes the prefix correctly. Seems I forgot to update that file. Please download it again.

[kennethj]

Originally Posted by Kentaurus

I updated the install.php so it takes the prefix correctly. Seems I forgot to update that file. Please download it again.

thank you for the up date - worked great

[enginethatcan't]

Originally Posted by Kentaurus

revert your postbit and postbit_legacy template, that should do it.

done thanks

[alfaowner]

Originally Posted by Kentaurus

Anywhere you want. Edit your postbit or postbit_legacy template and add $timespent before Posts: for example

ok, just add $timespent and nothing else? is it possible that someone that knows this, or how to do it, could post the code for me. thank you ALOT!

[Wifey]

Run the following queries. You can do it via phpmyadmin, or at the
"Execute SQL Query" section at the Admin Control Panel
Remember to prefix the table if you need to



alter table user add timespent int not null;

In this part of the hack, is that the entire query that you run? Or are each of those a separate query to run?

I ran that and it said that line 74 was altered, but the hack isn't working.

[Nj?rd Eriksson]

Just installed it, and while Time Spent is working, Average Time isn't.

For example:

Join Date: Oct 2003
Location: Connecticut USA
Age: 28
Posts: 269
Time Spent on Forum:
16 Minutes 34 Seconds
Average Time:
< 1 sec

That's definitely more than 1 second. As Average Time is calculated, what could the reason be? I followed all the instructions in the .txt.

[Nj?rd Eriksson]

For some or other reason it doesn't count the time of at least one of my super-moderators (usergroup ID 5) either. Didn't have the opportunity yet to check out others.

Marla
"Whatever happens, happens."

Join Date: Dec 2002
Location: Nihilism
Posts: 1,982
Time: Not available

(I changed the "< 1 sec" phrase to "Not available")

What can be done?

[Nj?rd Eriksson]

Originally Posted by Nj?rd Eriksson

For some or other reason it doesn't count the time of at least one of my super-moderators (usergroup ID 5) either. Didn't have the opportunity yet to check out others.

Marla
"Whatever happens, happens."

Join Date: Dec 2002
Location: Nihilism
Posts: 1,982
Time: Not available

(I changed the "< 1 sec" phrase to "Not available")

What can be done?

Nopes, time counting for another one of my super-moderator works:

Jack
the Ripper?

Join Date: Jul 2002
Location: Behind your fridge
Posts: 987
Time: 1 h 7 m 45 s

Weird thing ... any idea why the time isn't counted for the particular user Marla?

[admiralapril]

Thanks for the great hack.


Question.... I just installed this about an hour ago and it seems to be working fine for everyone except one of my moderators (User group ID 6). The time spent is < 1 min and average time is < 1 min also, even though she's been online almost the whole time since I installed it.

I haven't tested it for other moderators since they haven't been online yet. But why would it work for some members and not for others? Different usergroup, I guess? How can I fix it?

Join Date: Jan 2003
Location: New York
Posts: 1,241
Time spent in forums: < 1 min
Average time: < 1 min

[Chris Gwynne]

Ok, I'm having the same problem a few of the people are having with this one. I've installed everything right too, would really appreciate a fix for it..

Time spent on CouchRaider: 6 Minutes 8 Seconds
Average time: 11 Minutes 44 Seconds

The average time is simply not correct, how do I go about rectifying it?

[templates911]

I get a Fatal error: Call to undefined function: explain_time() in /usr/www/users/templ911/includes/functions_showthread.php on line 429 when i try to install this.