'; } else { include('lang.de.php'); echo ''; } //$result = mysql_query('SELECT id FROM GC_1 WHERE Archived = 0 AND (CountryID = 79 OR CountryID = "") '); //$not_archived = mysql_num_rows($result); // $result = mysql_query('SELECT id FROM GC_1 WHERE Archived = 1 AND (CountryID = 79 OR CountryID = "") '); // $archived = mysql_num_rows($result); // $gesamt = $archived + $not_archived ; // $archived_prozent = round(100/$gesamt * $archived, 1); // $not_archived_prozent = round(100/$gesamt * $not_archived, 1); $result = "SELECT count(*) from GC_1 WHERE `Archived` = 0"; $row = mysql_fetch_array(mysql_query($result)); $not_archived_all = $row[0]; unset($row); $result = "SELECT count(*) from GC_1 WHERE `Archived` = 1"; $row = mysql_fetch_array(mysql_query($result)); $archived_all = $row[0]; $gesamt_all = $archived_all + $not_archived_all ; $archived_prozent_all = round(100/$gesamt_all * $archived_all, 1); $not_archived_prozent_all = round(100/$gesamt_all * $not_archived_all, 1); ## Ältester Datensatz suchen $sql = mysql_query("SELECT `last_update` FROM GC_1 WHERE last_update != 0 ORDER by `last_update` ASC LIMIT 0,1 "); $last_update = date("d.m. H:i",mysql_result($sql,0)); function anzahl_caches($ID) { if($ID == "all") { $result = mysql_query('SELECT id FROM GC_1');} else { $result = mysql_query('SELECT id FROM GC_1 WHERE CountryID = '.$ID.''); } return mysql_num_rows($result); } function anzahl_caches_archived($ID) { if($ID == "all") { $result = mysql_query('SELECT id FROM GC_1 WHERE Archived = 1');} else { $result = mysql_query('SELECT id FROM GC_1 WHERE CountryID = '.$ID.' AND Archived = 1'); } return mysql_num_rows($result); } ?>