Ich habe mal vorhin versucht die Online Box in einer Statistik Box eingefügen aber misslungen.
Ich möchte jetzt einfach diese Statistik mit der Online Box verbinden...
Wäre nett wenn mir einer Helfen würde.
statistik.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 | <?php # Copyright by Manuel Staechele # Support www.ilch.de 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"),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(*) 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>Mitglieder:</td><td>'.$gesuser.'</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>'; $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.' 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(); } |
?>
Zuletzt modifiziert von StyLe am 06.09.2010 - 15:45:42