[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.