[Done 1.5.x] More More Stats

[Thomas]

I installed the mod and have run the query....

It still wount work...


/thomas

[Spaceman-Spiff]

hmm... you can disable the online time one if it doesnt work for you...

[Shadow's Pawn]

Hi

I get this errormessage:

Unknown column 'onlineTime' in 'field list'
Fil: /home/dykkesid/www/forum/Sources/Profile.php
Linje: 892

Ideas?

/Thomas

Where did you run the query?  Can you open up phpmyadmin and check the member's table to make sure that there is a field called onlineTime in the member's table?

[Thomas]

Hi

I had changed the prefix of my database to something other than yabbse. When I changed this - the update worked.

/Thomas

[Thomas]

Hi again

A couple of questions.

Why doesent my profilpage show som tome after online time:
http://www.dykkesiden.com/forum/index.php?action=viewprofile;user=admin

My stats page looks like this:
http://www.dykkesiden.com/forum/index.php?board=;action=stats
Is this right? I should probably stand on the top, but the otheres is definataly wrong...

/Thomas

[Shadow's Pawn]

That's because the online time mod doesn't work with the current version of yabbse.

[bluesyrio]

Does anyone know if there are plans to make the online time mod compatible with 1.5.5?

[Shadow's Pawn]

Please check the Online Time thread.

http://www.yabbse.org/community/index.php?thread=7991

There is a fix.

[Shadow's Pawn]

This might just be my forums, but the stats for Top 10 Online Time doesn't display properly on any of my forums or on my test forum.  The stats just stack the times onto the people below them, so it looks like this:

Joe       1 hour 2 minutes
Brian     1 hour 2 minutes 1 hour 1 minute
Craig     1 hour 2 minutes 1 hour 1 minute 1 hour
Larry     1 hour 2 minutes 1 hour 1 minute 1 hour 20 minutes

Etc.

Just thought I would let you know.  I fixed it on mine but it was a sloppy solution, in my opinion, so I'm declining to post it so that you can post a more graceful solution to this.

[dvucko]

This might just be my forums, but the stats for Top 10 Online Time doesn't display properly on any of my forums or on my test forum.  The stats just stack the times onto the people below them, so it looks like this:

Joe       1 hour 2 minutes
Brian     1 hour 2 minutes 1 hour 1 minute
Craig     1 hour 2 minutes 1 hour 1 minute 1 hour
Larry     1 hour 2 minutes 1 hour 1 minute 1 hour 20 minutes

Etc.

Just thought I would let you know.  I fixed it on mine but it was a sloppy solution, in my opinion, so I'm declining to post it so that you can post a more graceful solution to this.

Use this code in Stats.php:  

Code Select Expand

   // Top 10 Online Time
   if ($modSettings['stats_top_online_time'] == 1)
   {
      $stats_request = mysql_query("SELECT memberName, realName, onlineTime FROM {$db_prefix}members WHERE onlineTime > 0 ORDER BY onlineTime DESC LIMIT 10;") or database_error(__FILE__, __LINE__);
      while ($stats_rows = mysql_fetch_array($stats_request))
      {
         $onlineTime = "";
         $temptime = floor($stats_rows['onlineTime']/3600);
         $request3[0]=$stats_rows['onlineTime'];
         if ($temptime > 0) {
            $onlineTime = "$temptime {$txt['ontime2']}";
            if ($temptime > 1)  $onlineTime .= $txt['ontime5'];
            $request3[0] = $request3[0]%(3600*$temptime);
         }
         $temptime = floor($request3[0]/60);
         if ($temptime > 0) {
            $onlineTime .= " $temptime {$txt['ontime3']}";
            if ($temptime > 1)  $onlineTime .= $txt['ontime5'];
            $request3[0] = $request3[0]%(60*$temptime);
         }
         if ($memsettings[28] > 0) {
            $onlineTime .= " $request3[0] {$txt['ontime4']}";
            if ($temptime > 1)  $onlineTime .= $txt['ontime5'];
         }
         $euser = urlencode($stats_rows['memberName']);
         $displayStats[$counter]['contents'] .= '<tr>
                              <td><font size="2"><a href="' . $scripturl . '?action=viewprofile;user=' . $euser . '">' . $stats_rows['realName'] . '</a></font></td>
                              <td align="right"><font size="2">' . $onlineTime . '</font></td>
                           </tr>';
      }
      $displayStats[$counter]['title'] = $txt['yse_stats_18'];
      $displayStats[$counter]['icon'] = 'stats_posters.gif';
      $counter++;
   }