Total Time Online Hack v1.0

[ 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

[wolfe]

just updated to VBB 2.2.7 and getting this on the time online leader board

Call to undefined function: dotimeonline() in /usr/local/psa/home/vhosts/mysite.com/httpdocs/forums/timeonline.php on line 39

[NTLDR]

You NEED to re-apply all your hacks, they won't work otherwise

In particular you don't have the dotimeonline() function in functions.php which this hack requires. Follow the instructions and re-apply the hack

[wolfe]

d00d i have got the bit in my functions.php and still not working

[NTLDR]

Well you can't have done it correctly, check to make sure.

As the error message states, theres no dotimeonline() function avalible. This hack works fine on 2.2.7.

[wolfe]

oh **** made a mistake works great now thanx d00d

[NTLDR]

No problem, we all make silly little mistakes

[pjgoncalves]

this is a really cool hack!

i'm having a problem

this line:

  $DB_site->query("UPDATE user SET timeonline=timeonline+$newtime WHERE userid='$bbuserinfo[userid]'");

is causing this:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: UPDATE user SET timeonline=timeonline+94 WHERE userid='1'
mysql error: Unknown column 'timeonline' in 'field list'

mysql error number: 1054

and i have the timeonline in the field list as shown on the pic in attach.. any idea to fix this 'little' prob?

greets,
paulo

[g-force2k2]

pjgoncalves,

did you run the query? regards...

PHP Code:

ALTER TABLE user ADD timeonline int(10) NOT NULL DEFAULT '0' 


g-force2k2

[NSeXcellent]

Originally posted by g-force2k2
pjgoncalves,

did you run the query? regards...

PHP Code:

ALTER TABLE user ADD timeonline int(10) NOT NULL DEFAULT '0' 


g-force2k2

Im stuck on doing that. Can you explain to me what that means? I cannot figure out what you mean by 'Run Query'... Thanks G

[g-force2k2]

NSeXcellent

just download the file i attached and place it in your admin folder... then run the url...

ie: ...forum/admin/test.php

and it should run the query for you regards... haven't tested it but it should work regards...

g-force2k2