Welcome, Guest. Please Login or Register.
March 28, 2024, 06:44:50 PM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  Development  |  Completed mods  |  [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 45212 times)
Thomas
Full Member
***
Posts: 203


WWW
Re:[Done 1.5.x] More More Stats
« Reply #45 on: February 02, 2004, 05: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, 10: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

ICQ - 8039201shadowpawn@hotmail.com WWW
Re:[Done 1.5.x] More More Stats
« Reply #47 on: February 04, 2004, 03:06:22 AM »
Reply with quote

Quote from: Thomas on February 01, 2004, 11:59:41 PM
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 07, 2004, 01:03:00 AM »
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 07, 2004, 01:16:26 AM »
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

ICQ - 8039201shadowpawn@hotmail.com WWW
Re:[Done 1.5.x] More More Stats
« Reply #50 on: February 07, 2004, 02:18:05 AM »
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, 02:27:22 PM »
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

ICQ - 8039201shadowpawn@hotmail.com WWW
Re:[Done 1.5.x] More More Stats
« Reply #52 on: February 11, 2004, 10: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

ICQ - 8039201shadowpawn@hotmail.com WWW
Re:[Done 1.5.x] More More Stats
« Reply #53 on: February 12, 2004, 01:54:08 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.
« Last Edit: February 12, 2004, 01:54:27 AM 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, 08:37:12 AM »
Reply with quote

Quote from: Shadow's Pawn on February 12, 2004, 01:54:08 AM
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:  ;)
   // 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  |  [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.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.024 seconds with 19 queries.