cms2day Forum - Community & Support rund ums cms2day

Zitat

echo "<div class=\"box\" style=\"margin-bottom: 20px;\">";

$zeit = time();

$tagzeit = $zeit-86400;
$sql_tag = mysql_query("SELECT * FROM counter WHERE zeit>'$tagzeit' AND zeit!='0'");
$tag = mysql_num_rows($sql_tag);

$gesternzeit = $zeit-172800;
$heutezeit = $zeit-86400;
$sql_gestern = mysql_query("SELECT * FROM counter WHERE zeit>'$gesternzeit' AND zeit<'$heutezeit' AND zeit!='0'");
$gestern = mysql_num_rows($sql_gestern);

$stundenzeit = $zeit-3600;
$sql_stunde = mysql_query("SELECT * FROM counter WHERE zeit>'$stundenzeit' AND zeit!='0'");
$stunde = mysql_num_rows($sql_stunde);

$wochenzeit = $zeit-604800;
$sql_woche = mysql_query("SELECT * FROM counter WHERE zeit>'$wochenzeit' AND zeit!='0'");
$woche = mysql_num_rows($sql_woche);

$newscount = mysql_query("SELECT * FROM modul_news WHERE status='0'");
$news = mysql_num_rows($newscount);


echo "<h3>Aktuelle Statistik Ihrer Seite:</h3>";

echo "<table width=\"100%\"cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";


echo "<tr>\n";
echo " <td width='60%' align='left'>Besucher in der letzten Stunde:</td>\n";
echo " <td width='40%' align='right'>".$stunde."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo " <td width='60%' align='left'>Besucher letzte 24 Stunden:</td>\n";
echo " <td width='40%' align='right'>".$tag."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo " <td width='60%' align='left'>Besucher gestern:</td>\n";
echo " <td width='40%' align='right'>".$gestern."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo " <td width='60%' align='left'><p>Besucher letzten 7 Tage:</p></td>\n";
echo " <td width='40%' align='right'><p>".$woche."</p></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo " <td width='60%' align='left'><p>News Total:</p></td>\n";
echo " <td width='40%' align='right'><p>".$news."</p></td>\n";
echo "</tr>\n";


echo "</table>\n";



echo "</div>";