Welcome, Guest. Please Login or Register.
November 20, 2019, 03:02:49 PM
Home Help Search Login Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  Development  |  Completed mods  |  Topic: [Done 1.5.x] More More Stats « previous next »
Pages: 1 2 3 [4] Reply Ignore Print
Author Topic: [Done 1.5.x] More More Stats  (Read 27152 times)
Thomas
Full Member
***
Posts: 203



WWW
Re:[Done 1.5.x] More More Stats
« Reply #45 on: February 02, 2004, 12:19:57 PM »
Reply with quote

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

It still wount work... :'(


/thomas
Logged
Spaceman-Spiff
Mod Team
YaBB God
*****
Posts: 3689


My $txt[228]


Re:[Done 1.5.x] More More Stats
« Reply #46 on: February 02, 2004, 05:23:00 PM »
Reply with quote

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

   My mods, ysePak, codes, tutorials
    Support question IMs = bad.
Shadow's Pawn
Support Team
YaBB God
*****
Posts: 597


ich soll nicht toten


WWW
Re:[Done 1.5.x] More More Stats
« Reply #47 on: February 03, 2004, 10:06:22 PM »
Reply with quote

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?
Logged

apologize \A*pol"o*gize\, v. i. - To lay the foundation for a future offense.
Thomas
Full Member
***
Posts: 203



WWW
Re:[Done 1.5.x] More More Stats
« Reply #48 on: February 06, 2004, 08:03:00 PM »
Reply with quote

Hi

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

/Thomas
Logged
Thomas
Full Member
***
Posts: 203



WWW
Re:[Done 1.5.x] More More Stats
« Reply #49 on: February 06, 2004, 08:16:26 PM »
Reply with quote

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
Logged
Shadow's Pawn
Support Team
YaBB God
*****
Posts: 597


ich soll nicht toten


WWW
Re:[Done 1.5.x] More More Stats
« Reply #50 on: February 06, 2004, 09:18:05 PM »
Reply with quote

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

apologize \A*pol"o*gize\, v. i. - To lay the foundation for a future offense.
bluesyrio
Noobie
*
Posts: 21


I'm a llama!


Re:[Done 1.5.x] More More Stats
« Reply #51 on: February 11, 2004, 09:27:22 AM »
Reply with quote

Does anyone know if there are plans to make the online time mod compatible with 1.5.5?
Logged
Shadow's Pawn
Support Team
YaBB God
*****
Posts: 597


ich soll nicht toten


WWW
Re:[Done 1.5.x] More More Stats
« Reply #52 on: February 11, 2004, 05:30:46 PM »
Reply with quote

Please check the Online Time thread.

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

There is a fix.
Logged

apologize \A*pol"o*gize\, v. i. - To lay the foundation for a future offense.
Shadow's Pawn
Support Team
YaBB God
*****
Posts: 597


ich soll nicht toten


WWW
Re:[Done 1.5.x] More More Stats
« Reply #53 on: February 11, 2004, 08:54:08 PM »
Reply with quote

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.
« Last Edit: February 11, 2004, 08:54:27 PM by Shadow's Pawn » Logged

apologize \A*pol"o*gize\, v. i. - To lay the foundation for a future offense.
dvucko
Noobie
*
Posts: 2



WWW
Re:[Done 1.5.x] More More Stats
« Reply #54 on: February 12, 2004, 03:37:12 AM »
Reply with quote

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]
   // 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++;
   }
Logged
Pages: 1 2 3 [4] Reply Ignore Print 
YaBB SE Community  |  Development  |  Completed mods  |  Topic: [Done 1.5.x] More More Stats « previous next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.0.15 | SMF © 2017, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.066 seconds with 20 queries.