ilch.de :: Forum :: Ilch Clan 1.1 :: Fehlersuche und Probleme

Versuche es damit:
100
101
102
103
104
105
106
107
108
109
110
<?php 
//Copyright by Stefan Jungbauer 
//www.zocker-eppingen.de 
//V 1.1 
 
 
defined ('main') or die ( 'no direct access' );
 
 
if (empty($_GET['sum'])) {
  
 
  
    $heute = date ('Y-m-d');
     
    $ges_visits = db_result(db_query("SELECT SUM(count) FROM prefix_counter"),0);
    $ges_heute  = @db_result(db_query("SELECT count FROM prefix_counter WHERE date = '".$heute."'"),0);
    $ges_gestern = @db_result(db_query('SELECT count FROM prefix_counter WHERE date < "'.$heute.'" ORDER BY date DESC LIMIT 1'),0);
 
    $gbook  = @db_result(db_query("SELECT count(ID) FROM prefix_gbook"),0);
    $posts  = @db_result(db_query("SELECT count(ID) FROM prefix_posts"),0);
    $topic  = @db_result(db_query("SELECT count(ID) FROM prefix_topics"),0);
    $gesuser  = @db_result(db_query("SELECT count(ID) FROM prefix_user where recht >= -2"),0);
    $gesmember  = @db_result(db_query("SELECT count(ID) FROM prefix_user where recht < -2"),0);
 
 
    $gesch1  = @db_result(db_query("SELECT count(ID) FROM prefix_user where geschlecht = 1"),0);
    $gesch2  = @db_result(db_query("SELECT count(ID) FROM prefix_user where geschlecht = 2"),0);
 
    $bges = @db_count_query("SELECT COUNT(ID) FROM prefix_gallery_imgs");
     
 
 
 
echo '<table>
     <tr><td>'.$lang['today'].':</td><td>'.$ges_heute.'</td></tr>
     <tr><td>'.$lang['yesterday'].':</td><td>'.$ges_gestern.'</td></tr>
     <tr><td>Online:</td><td>'.ges_online().'</td></tr>
     <tr><td>Gbook einträge:</td><td>'.$gbook.'</td></tr>    <tr><td>Forum Posts:</td><td>'.$posts.'</td></tr>
     <tr><td>Forum Threads:</td><td>'.$topic.'</td></tr>
     <tr><td>Bilder in Gallery:</td><td>'.$bges.'</td></tr>
     <tr><td>Site User:</td><td>'.$gesuser.'</td></tr>
     <tr><td>Member:</td><td>'.$gesmember.'</td></tr>
     <tr><td> -Männliche: </td><td>'.$gesch1.'</td></tr>
     <tr><td> -Weibliche: </td><td>'.$gesch2.'</td></tr>
     <tr><td>'.$lang['whole'].':</td><td>'.$ges_visits.'</td></tr>
     
    <tr><td><a class="box" href="index.php?statistik"><b>... '.$lang['more'].'</b></a></td><td></td></table>';
     
} else {
 
$title = $allgAr['title'].' :: Statistik';
$hmenu = 'Statistik';
$design = new design ( $title , $hmenu , 0 );
$design->header();
 
    $anzahlShownTage = 7;
     
    echo '<br /><table width=90%" align="center" class="border" cellpadding="0" cellspacing="1" border="0"><tr><td>';
  echo '<table width="100%" border="0" cellpadding="5" cellspacing="0">';
  echo '<tr class="Chead"><td colspan="3" align="center"><b>Site Statistik</b></td></tr>';
     
    $max_in = 0;
    $ges = 0;
    $dat = array();
    $max_width = 200;
     
    $maxErg = db_query('SELECT MAX(count) FROM `prefix_counter`');
    $max_in = db_result($maxErg,0);
     
    $erg = db_query ("SELECT count, DATE_FORMAT(date,'%a der %d. %b') as datum FROM `prefix_counter` ORDER BY date DESC LIMIT ".$anzahlShownTage);
    while ($row = db_fetch_row($erg) ) {
     
      $value = $row[0];
 
        if ( empty($value) ) {
          $bwidth = 0;
      } else {
          $bwidth = $value/$max_in * $max_width;
          $bwidth = round($bwidth,0);
        }  
         
        echo '<tr class="Cnorm">';
      echo '<td>'.$row[1].'</td>';
        echo '<td><table width="'.$bwidth.'" border="0" cellpadding="0" cellspacing="0">';
        echo '<tr><td height="2" class="border"></td></tr></table>';      
        echo '</td><td align="right">'.$value.'</td></tr>';
 
 
 
       
        $ges += $value;
    }
 
 
     
    $gesBesucher = db_query('SELECT SUM(count) FROM prefix_counter');
    $gesBesucher = @db_result($gesBesucher,0);
     
    echo '<tr class="Cmite"><td colspan="3"><div align="right">';
    echo 'Wochen Summe: '.$ges.'</div>';
    echo 'Besucher Gesamt '.$gesBesucher.' &nbsp; Maximal '.$max_in.'<br /><br />';
    echo '</td></tr><tr class="Cdark">';
    echo '<td colspan="3" align="center">[ <a href="javasript:window.close()">Fenster Schliesen</a> ]</td>';
    echo '</tr></table></td></tr></table><br />';
     
    $design->footer();
     
}
?>
Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Fehlersuche und Probleme » Statistik aktualisieren
