[VB3 RC3] Board Spent Time

[Kentaurus]

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.php?p=467976&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.

[eXtremeTim]

Was waiting for this one. Does this track the total time on site or just when in forums since your text says time in forums.

[Kentaurus]

Was waiting for this one. Does this track the total time on site or just when in forums since your text says time in forums.If your site uses the forum engine (it includes global.php to make queries and such) then it will track the total time on site. Otherwise if the rest of the site is just static html or any other news/articles program it has no way of tracking time spent.

[eXtremeTim]

by site i ment the whole of the board ;)

[Kentaurus]

by site i ment the whole of the board ;)
Oh. Yes, it keeps track of everywhere. Forums, Threads, Usercp, private messages... actually everything.

[eXtremeTim]

Hey can you make this say second minutes and hours ect instead of just one of them?

[Kentaurus]

Hey can you make this say second minutes and hours ect instead of just one of them?
that's what it does already. My screenshot only shows minutes but that is only an example. It goes seconds-minutes-hours-days-weeks-months and up to years, although I have yet to see someone that spent a complete year of his life in a forum.

[eXtremeTim]

No i mean like

Time online: 1 minute, 34 seconds

or 3 weeks, 4 days, 2 hours, 1 minute, 23 seconds

or something along thoose lines like this hack for vb2 did.

[Kentaurus]

No i mean like

Time online: 1 minute, 34 seconds

or 3 weeks, 4 days, 2 hours, 1 minute, 23 seconds

or something along thoose lines like this hack for vb2 did.
Seems like I am not getting your questions :) I should read more carefully.

Yes, it can be done. That's a little too specific for my needs but should be a simple change. I really didn't check on the hack for vb2 so I only went with what people were asking for in the request forum. I'll look into it.

[eXtremeTim]

Thanks man i would really love to have it like that.

[aloha]

How would you exempt the moderators and admins from this?

[Gio Takahashi]

How often is the timer supposed to update?

[Kentaurus]

Thanks man i would really love to have it like that..txt updated and added one screenshot. It was a small change in effect :)

How would you exempt the moderators and admins from this?There are two ways to do it: you can either disable logging for the moderators and adminstrators (it would require further hacking), or just don't display it. If your administrator usergroup is 6 and your moderator's is 5 you can add a template conditional:

<if condition="$post[usergroupid] != 6 AND $post[usergroupid] != 5">
Your code here for printing the board spent time, $post[timespent]
</if>

Then you would only display the time spent in the board for non-moderators and administrators.

How often is the timer supposed to update?It keeps updating as long as you are browsing the board. Whenever you click on a hyperlink and browse another page it updates the time spent in the forum. If you don't have any activity in the forum in the same time setting that you have for your cookie expire options in the admin control panel then it stop recording the board spent time and whenever you log in/open the forum again it starts adding to the time again.

[Gio Takahashi]

I meant the post bit. on my forums, the timer has yet to update, everyone's timer says "< 1 sec"

[eXtremeTim]

Wicked dude. Any chance you can make an online leaderboard? Kinda like memberlist but shows user name posts and time online and is sorted by greatest time online?

[Kentaurus]

I meant the post bit. on my forums, the timer has yet to update, everyone's timer says "< 1 sec"
Did you run the query in the instructions? (phpmyadmin or admincp)

alter table user add timespent int not null;

If you forget to run that query the forum doesn't give you any error, it just shows < 1 sec all the time.

[MGM]

nice hack! I used the one for vB2, ill use this for vB3 as well ;)

* MGM clicks Install

MGM out

[Boofo]

What if i just want to put this in the memberinfo template and nowhere else. Do I still need to addd all of the code?

[Anarchy]

A leader board would be great, i would love a leader board.!

[Kentaurus]

What if i just want to put this in the memberinfo template and nowhere else. Do I still need to addd all of the code?
If you only want it in the memberinfo template you can skip the file modifications in showthread.php

[GamerzWorld]

Im getting same. I just checked in phpmyadmin and it said i did have the collumn added so not that

[Ronin]

I am also having the same issue. Doesn't seem to be updating. I ran the query. I even removed the entry and ran it again. Same thing. I double checked all the edits for the files and templates the phrases are there as well. But still no go! :(

[GamerzWorld]

Has any body actually got this working ... lol

[infernonet]

thanks nice hack good work :)

[MrNase]

Does it count from the day the hack was build in or will this hack display the online time from the opening of the board till now?

[Kentaurus]

I am also having the same issue. Doesn't seem to be updating. I ran the query. I even removed the entry and ran it again. Same thing. I double checked all the edits for the files and templates the phrases are there as well. But still no go! :(I have tested it in at least 3 boards and it seems to be working. Did you make the changes in sessions.php? That could be the only reason it is not updating. In sessions.php.

In sessions.php this query:

$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET lastactivity = " . TIMENOW . "
WHERE userid = $bbuserinfo[userid]
", 'lastvisit');

is changed to

$timespent = TIMENOW - $session['lastactivity'];
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET lastactivity = " . TIMENOW . ",
timespent=timespent+$timespent
WHERE userid = $bbuserinfo[userid]
", 'lastvisit');

make sure it is that exact code you change, some lines above that there is another one that looks alike but also modifies lastvisit. (that is in the instructions already, it is not something new).


Gio Takahashi, did you do anything special besides the instructions? It seems to be working on your board.

[GamerzWorld]

Is it possible you could upload your session.php id change it to match my arcade hack but itd eliminate that...

[MrNase]

Does it count from the day the hack was build in or will this hack display the online time from the opening of the board till now?
:nervous::banana:

[GamerzWorld]

Fixed and to answer your question Nase it starts when you install the hqack

[HiDeo]

Thanks I download and install now

[FleaBag]

Very nice hack, should give my users something to talk about.

[Anarchy]

Leader Board not a good idea?

[Kentaurus]

Actually it's a good idea.

I would like to know if you want it into the memberlist (you see an extra "time spent" column in memberlist and can sort by it) or as a separate page.

[Anarchy]

It would be great if it were accessable in the members list and then you could be able to sort by it.

[GamerzWorld]

The Average time didnt work when i installed vb 3 Cand 3

[Kentaurus]

The Average time didnt work when i installed vb 3 Cand 3
I have to re-check all my hacks for RC3. If there is the need for any modification I'll post it in the proper thread.

[mharmon]

I also had trouble with this hack on my VB3 RC2 board. It shows Average Time <1 Sec.

How would I go about deleting the time spent entry in my database and then trying again?

What query would I run to do this?

[Kentaurus]

I also had trouble with this hack on my VB3 RC2 board. It shows Average Time <1 Sec.

How would I go about deleting the time spent entry in my database and then trying again?

What query would I run to do this?
UPDATE user SET timespent=0

this resets the time spent in the board for all users to 0. If this query gives you any error it is because the column was never added to the user table.

[gmarik]

Spent all the time in the world :) thanks

[mharmon]

kentaurus ---

thanks for ther quick reply. I did that query and it didn't give me an error -- although now it still says <1 for both entries on the site.

any suggestions?

[Kentaurus]

kentaurus ---

thanks for ther quick reply. I did that query and it didn't give me an error -- although now it still says <1 for both entries on the site.

any suggestions?That query resets both the average time and the total time. The average time is not stored, it is calculated.

Maybe I should explain how I the average time works, as the < 1 sec might not be a problem at all. The average time is calculated by

time spent on board / days since you registered

that is, if you have been on the board for 50 minutes and you registered 2 days ago the average time would be 25 minutes. If you don't login for two days your average time drops to 12 minutes since you have 4 days registered.

In that case since this hack is new you may have very small total time spent, maybe your user has 10-20 minutes. If you registered a year ago that is 10 minutes / 365 days.. that is a very low number and maybe less than 1.

This is also how the average post count in the forum works, it makes a total posts / days since you registered

[mharmon]

kentaurus :

how often does it update the "time spent in foruns" field?

[Zeitgeist]

kentaurus :

how often does it update the "time spent in foruns" field?
Everytime you click on a link in the forum.

[GamerzWorld]

It wont work for Rc3 for me

[mharmon]

Same here...

I actually got mine to say "2" instead of <1 but it never goes above that.. any suggestions guys?? I have to get this hack working! :)

[eXtremeTim]

Actually it's a good idea.

I would like to know if you want it into the memberlist (you see an extra "time spent" column in memberlist and can sort by it) or as a separate page.
Second page would be better. There enough stuff on the member list as it is.

[Kentaurus]

It wont work for Rc3 for me
Did you re-made all the file changes for RC3? It's working in my RC3 board.

mharmon, could you give me the registered date and total spent time for the user that appears with "2"?

[mharmon]

There comes a time in every man's life that he must admit he is a dumb ass.

I was changing the wrong line in sessions.php . . . It works great when you change the right one.

Thanks for this great hack! :)

[Oblivion Knight]

Working great for me on RC3, thanks kentaurus.! :)

[Kentaurus]

An update for this one. Some extra modifications that will let you add the board spent time (total and average) to the memberlist. You can also sort by it to see who is the user with most board spent time.

[mharmon]

kentaurus --

it's working great for me now -- is there anyway to take out the "seconds" though on the display in the forums?

[mharmon]

[quoute]test[/quote]

[mharmon]

test

[Apostle]

It uh... doesn't work for me :(
I've got it installed on my forums (www.theapostleofgod.com/forums).

I'm using RC3. I followed the instructions, made the postbit changes, updated the sql db, updated all the files, uploaded them all.

I just can't figure out what I'm doing wrong. I dont' get anny errors, but I don't see the time online :(

--Sadly, I have to take this hack out, it has affected new user registration :(

[Me2Be]

Is there a way to remove this from being shown for administrators?

[Kentaurus]

It uh... doesn't work for me :(
I've got it installed on my forums (www.theapostleofgod.com/forums (http://www.theapostleofgod.com/forums)).

I'm using RC3. I followed the instructions, made the postbit changes, updated the sql db, updated all the files, uploaded them all.

I just can't figure out what I'm doing wrong. I dont' get anny errors, but I don't see the time online :(

--Sadly, I have to take this hack out, it has affected new user registration :(You don't seem to have it installed in that URL. The postbit/memberinfo templates show nothing about the users. At the very least it should show < 1 sec. Maybe it is the template modifications?

I don't see how it could break new user registration. It doesn't modify the register.php at all.

[Kentaurus]

Is there a way to remove this from being shown for administrators?In the postbit template you might have added something like:

Time in board: $post[timespent]

Change it to:

<if condition="$post[usergroupid]!=6">
Time in board: $post[timespent]
</if>

Then it is not shown for the administrators

[eXtremeTim]

lets try </if> instead of /if>

[eXtremeTim]

An update for this one. Some extra modifications that will let you add the board spent time (total and average) to the memberlist. You can also sort by it to see who is the user with most board spent time.Its working great thanks :)

[Kentaurus]

Its not working.
Works in my forum. You remembered to go to ACP and check that Board Spent Time checkboxes, right? :)

[Kentaurus]

kentaurus --

it's working great for me now -- is there anyway to take out the "seconds" though on the display in the forums?
To get rid of the "seconds" part:

In the hack:


if ($time <= 1)
{
return $ignoredefault ? "" : $vbphrase['less_than_1_second'];
}
else if ($time < 60) // 60 is not still a minute
{
return $time." ".$vbphrase['seconds'];
}

change it to


if ($time < 60)
{
return $ignoredefault ? "" : "< 1 min";
}

[eXtremeTim]

Works in my forum. You remembered to go to ACP and check that Board Spent Time checkboxes, right? :)
I had fixed it already :).

[Kentaurus]

I had fixed it already :).
Care to share what was it? ;)

[AutomatikStudio]

This is rather odd. I had a someone just join and in their profile it says

Time spent in forums: 1 Minute 32 Seconds
Average time: 11 Hours 2 Minutes 24 Seconds

Now...maybe I missed something...but how does only being in the forums for a total of 1 min. and 32 seconds make a total average of over 11 hours?

[mharmon]

kentaurus -- taking the seconds out worked fantastic -- thanks. :)

[eXtremeTim]

Care to share what was it? ;)
ftp client locked up

[eXtremeTim]

kentaurus -- taking the seconds out worked fantastic -- thanks. :)
Its becuase they have not been registered a day. So they out of say maybe the hour they have been registered that much time on would give a much higher avg time.

[Codeman05]

Ok well I installed this and all the querys...both fields still say <1 :(
Any ideas? I did edit the right line btw in sessions.php ;)

btw were are these boxes you speak of:
Works in my forum. You remembered to go to ACP and check that Board Spent Time checkboxes, right? :)

[Codeman05]

lmao wow I'm an idiot...upgraded from RC2 -> RC3 and it works fine :)

GREAT hack works perfect :D

[mharmon]

Any update on why in private messages it shows a long number instead of the Days, etc...?

[Kentaurus]

Any update on why in private messages it shows a long number instead of the Days, etc...?
In includes/functions_showthread.php

find:
// format posts number
$post['posts'] = vb_number_format($post['posts']);


change it to:
// Hack: get the timespent and avgtimespent
$post['avgtimespent'] = explain_time(floor($post['timespent']/((TIMENOW-$post['joindate'])/86400)));
$post['timespent'] = explain_time($post['timespent']);

// format posts number
$post['posts'] = vb_number_format($post['posts']);

[mharmon]

worked great. thanks for kentaurus

[mharmon]

Actually this didn't work. It fixed the private message problem -- but it then made all the time counts in the threads say <1

[Kentaurus]

Actually this didn't work. It fixed the private message problem -- but it then made all the time counts in the threads say <1Oops, I modified the hack, removed some code and somehow forgot to tell that. If you change that code in functions_showthread now the modifications done in showthread.php should now be undone. That is delete in showthread.php the two ocurrences of

$post['avgtimespent'] = explain_time(floor($post['timespent']/((TIMENOW-$post['joindate'])/86400)));
$post['timespent'] = explain_time($post['timespent']);


they are no longer needed since now it is done in the functions_showthread part, that also adds compatibility with the private messages and wherever else you use a postbit.

[mharmon]

Kentaurus --

That fixed it.. sorry for being such a pest on this -- it's just such a cool addition. :)

[mharmon]

I found another small bug. If someone has been on the forums 2 Days and 15 minutes for example, it says:

2 Day 15 Minutes

It leaves off the "s" for Days

[Kentaurus]

I found another small bug. If someone has been on the forums 2 Days and 15 minutes for example, it says:

2 Day 15 Minutes

It leaves off the "s" for DaysThat's right.. I don't know how I didn't spot it. Here is how to fix it.

In the includes/functions_showthread.php

find

else
{
return $newtime." ".$vbphrase['day']." ".explain_time($time%86400,true);
}


change it to:

else
{
return $newtime." ".$vbphrase['days']." ".explain_time($time%86400,true);
}


That is just adding an "s" to day

The txt is already updated

[mharmon]

kentaurus -- i'm glad i could help you get this hack working 100% :)

sorry I was such a pest. :)

[mharmon]

BTW -- What will this do to server load?

[Kentaurus]

BTW -- What will this do to server load?
nothing noticeable, no queries are added (just I query is modified) and there is only some code to format the time the user has been in the forum. It is currently running in my forum that has 100 users online at peak hours.

[Yahhoon23]

Alright, I did this hack, everything is fine except it's not showing up.

The only obvious thing i can think of is that I didn't enable it in the ACP but can't find it.

Thanks in advance

-------------------
Location of Forums - http://www.wirelessmatt.com/forums

[Kentaurus]

Alright, I did this hack, everything is fine except it's not showing up.

The only obvious thing i can think of is that I didn't enable it in the ACP but can't find it.

Thanks in advance

-------------------
Location of Forums - http://www.wirelessmatt.com/forums
which part is not showing up, the time in the postbit / memberinfo or the memberlist?

If it is the postbit / memberinfo, did you do the template edits in the correct style?

[Yahhoon23]

sorry for not being more in depth, but it's not showing up on the actual thread under their name.

I didn't try to do it thru the memberlist yet. I just did the first one that u had.

[Baugh]

Installed this hack (my first vB hack to install ever). Absolutely love it! Thanks man.

[Kentaurus]

sorry for not being more in depth, but it's not showing up on the actual thread under their name.

I didn't try to do it thru the memberlist yet. I just did the first one that u had.did you modify the postbit (OR) postbit_legacy template?

If you use the normal postbit template you need to add $timespent somewhere, if you use the new vertical (horizontal?) template then you need to add $timespent to postbit_legacy

[Holidazed]

Are there any plans for making this HTL compatible? I really want this hack, but HTL compatibility would make it easier for me to deal with.

[Kentaurus]

Are there any plans for making this HTL compatible? I really want this hack, but HTL compatibility would make it easier for me to deal with.
Once HTL1.1 is out and I can create txt from there (<hint>Bug Kurafire a little</hint>) I will make it HTL compatible

[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/admincp#/install_spent_memberlist.php?start=1
Referer: http://www.freakybutfun.com/forum/admincp#/install_spent_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 -

An update for this one. Some extra modifications that will let you add the board spent time (total and average) to the memberlist. You can also sort by it to see who is the user with most board spent time.

great hach and addition - thanks

[Beermonster]

* Beermonster installed

Thanks :)

[alfaowner]

did you modify the postbit (OR) postbit_legacy template?

If you use the normal postbit template you need to add $timespent somewhere, if you use the new vertical (horizontal?) template then you need to add $timespent to postbit_legacy

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

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

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]

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]

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/admincp#/install_spent_memberlist.php?start=1
Referer: http://www.freakybutfun.com/forum/admincp#/install_spent_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]

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]

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

[alfaowner]

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]

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.

[ogetbilo]

Can you please update your insallation instructions for VB3.0gold?
I did everything what it says on your instructions. Now I have <1sec for all my users except 3.
Those 3 are showing 3 sec, 3sec, 5sec respectively and they are not updating.

[Anarchy]

yeah i would like it too

[Catch-22|BL]

Thanks for the hack!

I got the "total time spent" and "memberlist leaderboard" working so I am happy. I did not get the "average time" to work properly, so I just took it out of the postbit and can easily forget about it. Hey, in real life we must appreciate that two out of three is not bad! :)

[ogetbilo]

Thanks for the hack!

I got the "total time spent" and "memberlist leaderboard" working so I am happy. I did not get the "average time" to work properly, so I just took it out of the postbit and can easily forget about it. Hey, in real life we must appreciate that two out of three is not bad! :)
what is your version of VB3?
I could not get it working on VB3Gold.

[Vivi Ornitier]

this hack isn't workin for gold. I put it in my postbit_legacy template and it doesn't show anything

[Anarchy]

need it to work please.

[ogetbilo]

Kentaurus,
Can you please at least post a removal tool if you are not planning to make this hack work in vB3gold?:(

[007]

Awesome. Works perfect with my old timeonline column from VB2 :) Also works perfect on 3.01 if anyone's wondering.

[Eternal2u]

*Travels up to that sacred install button and quickly presses it*

Thanx. man..the mems on my board who live on it will EXTREMELY appreciate this.

[sean289855]

I thikn I have everything. The only thing I might not have done run rihgt run the SQL query. Can someone help me how I shoudl do this. That I know exactly if it is me.

[Deep Blue]

Well, it ran once, isnt updating times, any ideas? I'm stuck at something silly like 1 min 16 seconds!

[Mijae]

Thanks I download and install now
Does this add a query to each page?

[Kentaurus]

Does this add a query to each page?
No, it doesn't. It uses the existing session query. It adds NO queries :)

[subu1]

works perfect on vb3 Gold thxxx and click install :-)

[Zylone]

It's installed on my forums and is working properly as you can see by visiting:

http://www.V6F150.com/forums and by viewing any thread.

I do have one problem however... there are a few members that visit daily yet their total time spent is stuck on a particular time 5 minutes say. another one of my admins has only 30 minutes yet he spends alot of time there as well.

It seems to be working fine for me and a bunch of other members but for some it is not working.

I know on a few it's not really working with is members who use AOL services. Maybe this could be a problem behind it?

How exactly does it calculate the time spent... cookies?

[Zylone]

I just realized this is for VB3 RC3... I am running VB3 3.0.1 would this have any effect on it?

[subu1]

Hi, i want a Page for the best of 10 Online User *g*

greetz subu1

[Princeton]

I was having some problems so I did some modifications (nothing major); hopefully, it can help others.

// ================================================= \\
// == [ BOARD SPENT ONLINE BY KENTAURUS - GTP BEGIN ]
$jointime = (TIMENOW - $userinfo['joindate']) / 86400; // Days Joined
if ($jointime < 1)
{ // User has been a member for less than one day.
$show['timespent'] = explain_time($userinfo['timespent']);
$show['avgtimespent'] = $show['timespent'];
}
else
{
$show['avgtimespent'] = explain_time(floor($userinfo['timespent'] / $jointime));
$show['timespent'] = explain_time($userinfo['timespent']);
}
// == [ 00-00-2004 - GTP END ]
// ================================================= \\

[xscape2me]

I'm using vb3.0.3 and it shows up but almost eveyrone is < 1 sec, and for myself it's been stuck at 35 seconds. So i count this as not working at all.

And princeton, if your going to show some code, it would help others if you let us know where that goes.

[xscape2me]

I wish I coul delete my own post, i got it workin finally

*clicks install*

[Osterling]

does this hack take awhile to kick in cuz right now i am just getting

Time spent in forums: < 1 sec
Average time: < 1 sec

[Osterling]

it says:

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;

is there more then one query i need to run because the Average time: < 1 sec isn't changing

[Datenpapst]

it says:

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;


is there more then one query i need to run because the Average time: < 1 sec isn't changing
I installed the hack, but it does not work... :( Its not displayed in the profil.

[Lonny]

Doesn't work for 3.0.3

[integra99]

Works fine for me, you people that say "It doesn't work," why not ellaborate a bit more and hopefully we can help you get it fixed?

[Keyser S?ze]

Works fine for me, you people that say "It doesn't work," why not ellaborate a bit more and hopefully we can help you get it fixed?


hmm, im trying to get it to work in 3.0.3 but heres the problem

instructions say

################################################## ######################
# Code modifications in includes/functions_showthread.php
################################################## ######################

---------------------------------------------------
Find this code:
---------------------------------------------------

// ###################### Start getreputationimage #######################

-----

thats not in functions_showthread.php

thats in functions_reputation.php, i guess that was changed after RC3, so where do i put this, can it go anywhere in showthread?

[y2krazy]

/me clicks install!

[venomx]

Yep functions_showthread.php has no // ###################### Start getreputationimage ####################### if vb3.0.3

[venomx]

Plus if it was why would we want to remove the code for the getreputationimage?

[royals]

Plus if it was why would we want to remove the code for the getreputationimage?

if you notice his replacement code -its at the bottom so you're not really removing it.


Edited - Running great! Thanks!

[royals]

Where do I take out the seconds so they don't show? Some of my users stay logged in 24/7 and time is going to add up fast. Seconds aren't really needed (kind of cool though)

[mlevenson]

An update for this one. Some extra modifications that will let you add the board spent time (total and average) to the memberlist. You can also sort by it to see who is the user with most board spent time.

Ok so I installed this but since everythign I read says it won't work for 3.03, how do I remove it from the admincp?

[Silverstangs]

I am running VB 3.0.3 and I attempted to install this hack but I keep on getting a error when I click the member's list...


Fatal error: Call to undefined function: explain_time() in stangcountry/forums/memberlist.php on line 496

and this is the line that I have for it......

$userinfo['avgtimespent'] = explain_time(floor($userinfo['timespent']/((TIMENOW-$userinfo['joindate'])/86400)));

Can someone explain what I missed.......

[royals]

I have a problem with one of my members - her time is stuck at 26 min 55 seconds. We can't figure out what it is. All other members seem to be ok.

Is it a setting on her computer we can look at or something else?

[mlevenson]

is there an update for this for 3.03????

[Megareus Rex]

Is there a way to insert this into people's profiles?

[Pip]

is there an update for 3.0.3?

[Lexina]

Dudes, can we have a functions_showthread.php mod for 3.0.3? I just need to know where to chuck the code...

[ScottA]

Dudes, can we have a functions_showthread.php mod for 3.0.3? I just need to know where to chuck the code...
Just put it after the last function in functions_showthread.php. I just finished installing this hack on a 3.0.3 install and it works fine.

[h75]

INSTALL :rolleyes: Nice one!

[Benj]

this looks like a great hack - thinking of adding it! 1 question tho. doesnt this hack greatly increase server load??

[Pixelgrounds]

Does anyone have a update of this mod for vb 3.0.3 ?

[jluerken]

is there more then one query i need to run because the Average time: < 1 sec isn't changing


Also my Average Time is not working on 3.0.3. Anyone an idea?

[mikehawk]

Awesome! It works great! Installed.

How much resources does this use? Will it be hard on my bandwidth?

[Boots]

installed with 3.0.4 -- works great

[Boots]

I'd much prefer a seperate page that shows the top 25 users sorted by online time. Has anyone done this? It'd save me from reinventing the wheel.

[The Realist]

Just installed this hack and mine is saying the folowing:

Time spent in forums: 1 hour 4 minutes 42 seconds
Average time: < 1 sec

Average time is not working?

Is there a query missing as the instructions state only:

alter table user add timespent int not null;

Laters

[Dark Zero]

the average time is:
time spent in the forum divided with the join date

if your join date is too old, u require much time spent for move the average
(you can notice the new members have more average)

[SHARKY]

i wold love to have this can someone update this install for vb 3.0.3 i installed but all i get is errors for my edits in functions_showthread.php and member.php

[mikehawk]

I had it on my vb with 3.03 and since I upgrade to vb3.04, it is all screwed up now.

What should I do?

[Dark Zero]

only need to add again the phrases

[Boots]

here's what happens when I get bored and have too much time on my hands hahaha

http://forums.reality-check.ca/timewasters.php

[jluerken]

here's what happens when I get bored and have too much time on my hands hahaha

http://forums.reality-check.ca/timewasters.php

hrhrhr nice one boots :D :up:

[docvader]

here's what happens when I get bored and have too much time on my hands hahaha

http://forums.reality-check.ca/timewasters.php

Boots. Love it. Can you tell us how you did that?

[Boots]

Boots. Love it. Can you tell us how you did that?

Just a simple php file that does a calculation based on the timespent column which this mod adds to the database. It just dumps it to a template. Maybe I'll do up some instructions and post it up.

[docvader]

Just a simple php file that does a calculation based on the timespent column which this mod adds to the database. It just dumps it to a template. Maybe I'll do up some instructions and post it up.
Installed on a heavily hacked 3.03 board without any problems. Works great.

One question: I've added the "time spent" calls to my FORUMHOME template, to show this information for each individual person in a welcome message. However, the time is not being shown. What do I have to add where, to make it work? I tried putting the "showthread" hack stuff into forumdisplay, but, that didn't do it.

Anyone have any ideas?

[royals]

How do I remove seconds? People are getting into months for time spent and its too much even after I shortened the phrases.

[nautiqeman]

I'm not really positive on this, so I'm just throwing it out there. I noticed that a user signed up some time during the day and I noticed that she already had over a day on her time spent already -- has anyone else seen this or maybe fixed it if they had

[Elfo King]

This work on 3.0.3 ???
The istruction file, for 3.0.3 is bad....first on functions_shohtread....
Have correct version for 3.0.3 ?

[nintendo]

here's what happens when I get bored and have too much time on my hands hahaha

http://forums.reality-check.ca/timewasters.php

Nice! Can you please post that! I got users that have made close to 10,000 posts. I think they would 'love' to see how much money there losing by living at the boards instead of having a 'real' job!!!

[DeadGaze]

ok dude here is the fix for 3.0.3 hehe :p

just goto includes/functions_showthread.php
remove the following code from it

// Hack: get the timespent and avgtimespent
$post['avgtimespent'] = explain_time(floor($post['timespent']/((TIMENOW-$post['joindate'])/86400)));
$post['timespent'] = explain_time($post['timespent']);


now goto root/showthread
and find >

$postbits .= construct_postbit($post, $template);

if (!empty($parsed_postcache['text']) AND !$stopsaveparsed)

Add above

// Hack: get the timespent and avgtimespent
$post['avgtimespent'] = explain_time(floor($post['timespent']/((TIMENOW-$post['joindate'])/86400)));
$post['timespent'] = explain_time($post['timespent']);


now find >

$DB_site->free_result($listposts);

// hooks child posts up to new parent if actual parent has been deleted

add above

// Hack: get the timespent and avgtimespent
$post['avgtimespent'] = explain_time(floor($post['timespent']/((TIMENOW-$post['joindate'])/86400)));
$post['timespent'] = explain_time($post['timespent']);


Now you are done
have fun

[reteep]

Hi there,

sorry DeadGaze, doesn't work on vb 3.0.6 here.. still call to undefined function in showthread..

Anyone got a fix?

[Hideo Kojima]

Hi there,

sorry DeadGaze, doesn't work on vb 3.0.6 here.. still call to undefined function in showthread..

Anyone got a fix?

up :(

[Megareus Rex]

Ok, I have a small problem...

One of my members complains his board spent time doesn't increase. After further investigation, I realized this is true. He's the only one this happens to, so I can't understand it...

Any thoughts?

(Other than that, great hack)

[AmpSul]

Works on my 3.0.7. Nice one!!

[DarkEternal3]

I installed this and now when I try to bring up a member profile all I get is a white page of nothing. The hack seems to be working though. What could I have screwed up?

[Marco van Herwaarden]

Chances are there is either a templated screwed up (or missing from an alternative style) or there is a space or newline after the closing "?>" in one of the edited php-files.

[DarkEternal3]

ahh found it, was missing a ;

[nintendo]

instructions say

################################################## ######################
# Code modifications in includes/functions_showthread.php
################################################## ######################

---------------------------------------------------
Find this code:
---------------------------------------------------

// ###################### Start getreputationimage #######################

-----

thats not in functions_showthread.php

thats in functions_reputation.php, i guess that was changed after RC3, so where do i put this, can it go anywhere in showthread?

It's in /includes/functions_reputation.php

I made the change there and it's working on my boards.

[AxEsLoCkEd]

i made the modifications in functions_showtread but i'm getting less than 1 second

[007]

Have had this installed for a while on two different boards. It's been fine on my first board, but my second board I have noticed some member's time is lower that it used to be..

Is there any possible way time can go down?

It's somehow happening and I would LOVE to get suggestions. Any ideas?

Please and thank you!

~006

[hitmanuk2k]

OK I don't want to add it to the postbit, but I want to show it on Profile pages. Is the only way to do this to add to the postbit? Or what?

[Virtuosofriend]

can sb explain me what it doesnt work on VB 3.0.5?Or is there anybody with 3.0.5 forum that has it and it actually works?

[Rickie3]

i'm running vb ver 3.0.3 i cant find this code in functions_showthread.php

################################################## ######################
# Code modifications in includes/functions_showthread.php
################################################## ######################

---------------------------------------------------
Find this code:
---------------------------------------------------

// ###################### Start getreputationimage #######################

is there any chance of somebody re-doing all the instructions to suit 3.0.3 for a dummy like me,i find it much easier if everything is in order,i would really love this addition on my forum,help appreciated

[Rickie3]

can someone help please?? :rolleyes:

[Virtuosofriend]

it is located in your includes/functions_reputation.php file but dont bother to install it because it doesnt work.

[Rickie3]

but dont bother to install it because it doesnt work.

well my friend can you explain why it doesnt work??,i actually sat back and read every thread over and over and i finally got it to work,and it does exactly what its supposed to,it works perfectly for me on my test board 3.0.3,and 3.0.7,the secret is to read carefully

what i did was place everything in order to the attached below,it is not a rewrite of the original,just placed in order to make the coding for 3.0.3 and 3.0.7 a little easier

[artonex]

hey Rickie3 so that above file works with vb3.0.7?

[Rickie3]

hey Rickie3 so that above file works with vb3.0.7?
working fine on my test board 3.0.7 with no probs at all.you can see it in action here working on 3.0.3 www.sats-general.com

[paul41598]

Yah thanks Rickie3, those instructions worked perfectly! :D

[MojoNixon]

Ok ....i used your instructions carefully... i started the query, added the phrases..but nothing changed since before.. What now?

[paul41598]

Ok ....i used your instructions carefully... i started the query, added the phrases..but nothing changed since before.. What now?

You didnt do something correctly. Make sure you found the exact line found in includes/sessions.php, there were a few tricky ones.

Because if you do everything in his instructions, it does work. 3.0.7 anyways..

[MojoNixon]

Thanx for your help ...i checked it. ...but its still not displaying. Not in the Thread and not in the Profile Page. I´m using 3.0.7

[BLazeD1]

I have this installed on 3.0.7

It works fine in forum posts etc, but in PMs it looks like this:

Time Spent Online: 1109

ie, the minutes, seconds etc arent displayed - only a number

[csidlernet]

preety cool.

[EH-Jay]

Did you run the query in the instructions? (phpmyadmin or admincp)

alter table user add timespent int not null;

If you forget to run that query the forum doesn't give you any error, it just shows < 1 sec all the time.
Hey Kentaurus,
I get the same error. I ran the query perfect:
Your SQL-query has been executed successfully (Query took 0.0234 sec)
SQL-query:
ALTER TABLE user ADD timespent int NOT NULL
And it's still < 1 sec

I made all the correct changes, obviously because it's showing < 1 sec, but it won't update.

Any help?

[EH-Jay]

So I guess this problem is going to stay in limbo then?

[98EXL]

I'm either a complete moron, or not, but, in includes/function_showthread.php, I do not have:

// ###################### Start getreputationimage #######################

I can't even start the hack, so sad

[Andreas]

Guess this Hack needs an Update ... fetch_reputation_image() has been move to functions_reputation.php.

Anyway, I think functions_showthread.php is still the right place.

Look for


// ###################### Start process_highlight_postbit #######################


And place the Code above that, might work.

[98EXL]

Guess this Hack needs an Update ... fetch_reputation_image() has been move to functions_reputation.php.

Anyway, I think functions_showthread.php is still the right place.

Look for


// ###################### Start process_highlight_postbit #######################


And place the Code above that, might work.


as soon as I typed that, went to page 12, there it was.

Clicks install....this works great already!

[Virtuosofriend]

well my friend can you explain why it doesnt work??,i actually sat back and read every thread over and over and i finally got it to work,and it does exactly what its supposed to,it works perfectly for me on my test board 3.0.3,and 3.0.7,the secret is to read carefully

what i did was place everything in order to the attached below,it is not a rewrite of the original,just placed in order to make the coding for 3.0.3 and 3.0.7 a little easier

Because simply it doesnt work.I have tested in all the forums i am admin and it doesnt work.And believe me i have far more experience than you.

[Rickie3]

Because simply it doesnt work.I have tested in all the forums i am admin and it doesnt work.And believe me i have far more experience than you.it does work!!!!!!! it is currently working on my forum and has done for the last 3 weeks,it is also working fine on my test board.Quite frankly i could'nt care less if you have more experience,i'm still learning for sure.What all the forums have you tested it in??????,I am a admin as well

P.S you have a nice forum

[lewisbeech]

i am trying to install this on 3.0.8, and i cannot find '// ###################### Start getreputationimage #######################' in the funtions_showthread.php file.
please help

[RustedBucket]

2 questions.

First, I want to use the $post[timespent] result in the Postbit template based on the users online status, but I can't seem to get it to cooperate. Using something like this in postbit_legacy:

<if condition="$post[onlinestatus]!='Online'">$post[timespent]</if>

Does nothing. The value for $post[timespent] is viewable regardless that status. Basically I only want to display this if the user is Online, not for Invisible or Offline. I can't read the value of $onlinestatus in this template either. Any clues on how to get a value I can use a conditonal against?

Second question: What the easiet way to change the time to reflect 00:00:00 vs # hours # minutes # seconds??

Thanks alot

[Azra_el]

i am trying to install this on 3.0.8, and i cannot find '// ###################### Start getreputationimage #######################' in the funtions_showthread.php file.
please help


not finding the getreputationimage part either... any clues?

[snags204]

any word how to integrate this with 3.0.8? Thanks

[hotwheels]

i wouldn't get to excited......i have spent 1/2 the day trying to get this to work with 3.07, everything show's, but the time is stuck......

Time spent in forums: 1 minute 29 seconds
Average time: < 1 sec

Just sit's right there, and doesn't do anything

[hotwheels]

https://vborg.vbsupport.ru/attachment.php?attachmentid=26658https://vborg.vbsupport.ru/attachment.php?attachmentid=16367
I tried running this program with both hack suggestion's, neither one work's with 3.07.....not sure what those that claim their's work's did, but i know i can't get it working.
That's a shame too, kind of a kewl idea....

hotwheels of insanemustangs.com

[hotwheels]

after 14 hours i gained 3 seconds...........woot

Time spent in forums: 1 minute 32 seconds

[007]

Does this work on 3.5 RC2?

[pmkb]

^^^ Ditto.

https://vborg.vbsupport.ru/showthread.php?t=95790

http://www.vbulletin.com/forum/showthread.php?t=153616

[007]

Ok I found out this doesn't work in vB3.5 RC3... If anybody can make it into a plugin that would be awesome.. :)

[thetoolman]

# Code modifications in includes/functions_showthread.php

... i dont have a functions_showthread.php file. any ideas?

[peterska2]

This is for vB 3.0.x NOT 3.5.x

[WAR]

This is for vB 3.0.x NOT 3.5.x

I would love to see this ported over to 3.5 as well

[Alphawolf83]

Nice work! *clicks install* :)

One lil question: The info saved in $post[avgtimespent]: Is this the average time the certain user spent or an average of all users in the forum?

[serhat_kk]

i cannot find

// ###################### Start getreputationimage #######################

in includes/functions_showthread.php at vbulletin 3.0.9 what can i do?

thanks

[pmkb]

Any chance this will get ported to 3.6?

[rob4448585]

any support for this??????

[hddstudio]

I've seen a Vb 3.6.x forum using this....is it already ported to 3.6.x ??? Where can I fiind it ?

[giotmuadong]

do you have an update?