The Arcive of Official vBulletin Modifications Site.

Total Time Online Hack v1.0 · **Released**: 08-27-2002

[ Click Here ] to download the latest update!

Nifty Addon by TECK:

[View TECK's Modification]

Yeah my first hack for vb2.2.7

but then again its compatible with vb2.2.6 as well tested on both

What does this hack do? Just as the title states

it calculates the total time online for each user

Configurable::
The time limit before a user is considered inactive is configurable and is included in the install txt file... so if you want a user to be defined as inactive after 3 minutes then there'll be a variable in the script to limit that configure that

Also Configurable is the amount of users to show per page on the leader time online board

That is also configurable in the timeonline.php included with the zip...

Features ::
Includes both viewable on the postbit and getinfo templates...
Includes a leader board for the top users time online

What to do? ::
Queries to Run (1)
File Modification (5)
Template Modificatiion (2)
Templates to Add (3)
Files to Upload (1) :: [ timeonline.php ] (forum directory)

It's an easy hack to install (took me a little time to configure) but it looks great imo... probably a hack that will use and that i can see every forum having... why not right

Enjoy yet another release...

And if you like this hack i would be greatful if you could click install

thanks...

Edit ::
Viewable Demo [ Here ]

Note ::
If for some odd reason you get a division by zero error

find:

PHP Code:


			
$daysreg = floor((time() - $lead[2]) / 86400); 

          $daysreg = iif($daysreg == 0,'1','$daysreg'); // checking to see if not registered for more then a day to prevent division by zero

        $dotimeperday = floor($lead[3] / $daysreg);

replace with:

PHP Code:


			
$daysregs = floor((time() - $lead[2]) / 86400); 

          if($daysregs == 0) { // checking to see if not registered for more then a day to prevent division by zero

            $daysreg = 1;

          } else {

            $daysreg = $daysregs;

          }

        $dotimeperday = floor($lead[3] / $daysreg);

g-force2k2

TECK · #**212** 09-23-2002, 01:31 PM

hmm g-force, i just realised that the hack it's adding a query everywhere, in all pages. i really dont like that because i'm trying to stay with an average of max 18queries on my forums.

and you should use in your sessions.php something like:

Code:

$timeactive = time() - $bbuserinfo['lastactivity'];
if ($bbuserinfo['userid'] != 0 and $timeactive < (5 * 60)) {
  $DB_site->query("UPDATE user SET timeactivity=timeactivity+$timeactive WHERE userid='$bbuserinfo[userid]'");
}

so it doesnt perform a query also for quests. it will save you some serverload.

UPDATE

check below how to optimise the code and eliminate the extra query...
wait for g-force to update his files... or do it yourself if your belt is strong enough.

g-force2k2 · #**213** 09-23-2002, 03:51 PM

NSeXcellent:

make sure that the link is this:

PHP Code:


			
<a href='timeonline.php?s=$session[sessionhash]&action=view_leader'>Time Online:</a>

xevito:

everything is included in the zip file, other changes are just custom ones nothing necessary

Da GoTTi:

did you include the $post[onlinetime] variable in the postbit?

Neo:

how would you do it?

TECK:

thanks for the addition

i will add the link to the first post

regards...

g-force2k2

TECK · #**214** 09-23-2002, 04:37 PM

ok, g-force i found a way to dont load any query at all. you can update your code if you want... is your hack and it's a great tool.
now let's optimise shall we?

here it is what i did, step by step (keep in mind i used my own terms, change them to yours):
run this query:
[sql]ALTER TABLE user ADD timeactivity int(10) unsigned DEFAULT '0' NOT NULL AFTER posts[/sql]
in /admin/functions.php find:

Code:

$post[joindate]=vbdate($registereddateformat,$post[joindate]);

replace it with:

Code:

    $post[joindate]=vbdate($registereddateformat,$post[joindate]);

    // activity time
    $post[activity] = floor($post[timeactivity] / 3600);
    if ($post[activity] <> 1) {
      $pluralhour = 's';
    } else {
      $pluralhour = '';
    }

in /admin/sessions.php find:

Code:

  if ($ourtimenow - $bbuserinfo['lastactivity'] > $cookietimeout) {
    if (!isset($bypass)) {
      if ($noshutdownfunc) {
        $DB_site->query("UPDATE user SET lastvisit=lastactivity,lastactivity=$ourtimenow".iif($showforumusers,",inforum='0' ","")." WHERE userid='$bbuserinfo[userid]'");
      } else {
        $shutdownqueries[99]="UPDATE user SET lastvisit=lastactivity,lastactivity=$ourtimenow".iif($showforumusers,",inforum='0'","")." WHERE userid='$bbuserinfo[userid]'";
      }
    }
    $bbuserinfo['lastvisit'] = $bbuserinfo['lastactivity'];
  } else {
    if (!isset($bypass)) {
      if ($noshutdownfunc) {
        $DB_site->query("UPDATE user SET lastactivity=$ourtimenow".iif($showforumusers,",inforum='0' ","")." WHERE userid='$bbuserinfo[userid]'");
      } else {
        $shutdownqueries[99]="UPDATE user SET lastactivity=$ourtimenow".iif($showforumusers,",inforum='0' ","")." WHERE userid='$bbuserinfo[userid]'";
        // This update will be done in the doshutdownfunction automatically, but the old method was doing screwy things!!
      }
    }
    $bbuserinfo['lastvisit'] = $bbuserinfo['lastvisit'];
  }

replace it with:

Code:

  $timeactive = time() - $bbuserinfo['lastactivity'];
  if ($ourtimenow - $bbuserinfo['lastactivity'] > $cookietimeout) {
    if (!isset($bypass)) {
      if ($noshutdownfunc) {
        $DB_site->query("UPDATE user SET ".iif($bbuserinfo['userid']!=0 and $timeactive<(1*60),"timeactivity=timeactivity+$timeactive,","")."lastvisit=lastactivity,lastactivity=$ourtimenow".iif($showforumusers,",inforum='0' ","")." WHERE userid='$bbuserinfo[userid]'");
      } else {
        $shutdownqueries[99]="UPDATE user SET ".iif($bbuserinfo['userid']!=0 and $timeactive<(1*60),"timeactivity=timeactivity+$timeactive,","")."lastvisit=lastactivity,lastactivity=$ourtimenow".iif($showforumusers,",inforum='0'","")." WHERE userid='$bbuserinfo[userid]'";
      }
    }
    $bbuserinfo['lastvisit'] = $bbuserinfo['lastactivity'];
  } else {
    if (!isset($bypass)) {
      if ($noshutdownfunc) {
        $DB_site->query("UPDATE user SET ".iif($bbuserinfo['userid']!=0 and $timeactive<(1*60),"timeactivity=timeactivity+$timeactive,","")."lastactivity=$ourtimenow".iif($showforumusers,",inforum='0' ","")." WHERE userid='$bbuserinfo[userid]'");
      } else {
        $shutdownqueries[99]="UPDATE user SET ".iif($bbuserinfo['userid']!=0 and $timeactive<(1*60),"timeactivity=timeactivity+$timeactive,","")."lastactivity=$ourtimenow".iif($showforumusers,",inforum='0' ","")." WHERE userid='$bbuserinfo[userid]'";
        // This update will be done in the doshutdownfunction automatically, but the old method was doing screwy things!!
      }
    }
    $bbuserinfo['lastvisit'] = $bbuserinfo['lastvisit'];
  }

in postbit template, add:

Code:

Activity Online: <font color="#E4630A">$post[activity]</font> hour$pluralhour

anywhere you like... voila, no queries loaded and also the event time is set to 1, so no more limits and worries about the exact time...

as i said before, i did it this way because all i wanted to have is the time in postbit.
the results? a screenshot is here...

go ahead and update your cool hack now.

thanks for letting me aport a small contribution to it.

cheers.
floren.

monitox · #**215** 09-23-2002, 06:01 PM

Great great HACK ! :classic:

Thank YOU very much man !
I use it on a (mutilated

) 2.2.2 board and works PERFECT !

Have A Cool Day !

monitox · #**216** 09-23-2002, 07:15 PM

TECK > your modification is NOT working for me :glasses:
Give me MySQL error

PS: esti cumva Roman ?

TECK · #**217** 09-23-2002, 07:21 PM

monitox, it doesnt work because the params and variables are not identical. this is a custom install for my forum, not the original hack. just wait for g-force to customize it, because you add an extra query on the process with his current hack...

and yes i'm romanian.. you can tell by the name.

GoTTi · #**218** 09-23-2002, 09:47 PM

g-force =

Yes the code is in the postbit, here is what I got in there:

<p align="right"><smallfont><a href="javascript

peneditsigwindow(490,320,'$session[sessionhash]','$post[userid]')">Edit Sig</a> | <a href="report.php?s=$session[sessionhash]&postid=$post[postid]">Report this post to a moderator</a> | $post[iplogged] | <a href='timeonline.php?s=$session[sessionhash]&action=view_leader'>Time Online:</a>$post[onlinetime]</smallfont></p>

anything wrong?

g-force2k2 · #**219** 09-24-2002, 01:52 PM

Da_GoTTi: did you make the admin/functions.php file edit? regards...

g-force2k2

NSeXcellent · #**220** 09-24-2002, 02:43 PM

Quote:

Originally posted by g-force2k2
NSeXcellent:

make sure that the link is this:

PHP Code:

<a href='timeonline.php?s=$session[sessionhash]&action=view_leader'>Time Online:</a>

Its identical to that. It just brings up a blank page.

GoTTi · #**221** 09-24-2002, 10:39 PM

yes the modification is on the functions....

all of it is in correctly, i dunno what is causing it.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07215 seconds Memory Usage 2,333KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (6)bbcode_code (4)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!