opentable("Abfrage");

$zeit = time();

$num = dbquery("SELECT count(download_id) AS download_count FROM ".DB_DOWNLOADS);

$data = dbarray($num);

$anzahl = $data['download_count'];

$alle       = 24*60*60*3600;

$dreihundertsechsig    = 24*60*60*360;



$i_all    = $zeit - $alle;

$i_00    = $zeit - $dreihundertsechsig;

$n_all    = dbquery("SELECT count(download_id) AS download_count FROM ".DB_DOWNLOADS." WHERE download_datestamp >= $i_all");

$n_00    = dbquery("SELECT count(download_id) AS download_count FROM ".DB_DOWNLOADS." WHERE download_datestamp >= $i_00");



$d_all = dbarray($n_all);

$anzahl_all = $d_all['download_count'];



$d_00 = dbarray($n_00);

$anzahl_00 = $d_00['download_count'];

echo "<table align='center' width='700' cellpadding='3' cellspacing='1' class='tbl3'><tr>";

echo "<form name='chooseform' method='post' action=''>

<dl>

<dd><td class='tbl2' align='left'><input type='radio' name='choose' value='all' />Alle Dateien ($anzahl_all)<br />

<input type='radio' name='choose' value='dreihundertsechsig'>365 Tage ($anzahl_00)<br /></dl><center></tr>\n</table>\n";

echo "<center><input type='submit' name='show' value='Abfrage senden' class='button' /><br /><br /></center></form>\n";