set_filenames(array( 'content' => 'stats.tpl') ); $template->assign_block_vars("hoofdpagina", array('titel' => 'Statistieken')); $template->assign_block_vars("hoofdpagina_e", array()); $count = mysql_query("SELECT count(1) AS total FROM bsp_domeinen WHERE categorie != 9") or die(mysql_error()); $num = mysql_fetch_object($count); $template->assign_var('paginas', $num->total); $count = mysql_query("SELECT count(1) AS total FROM bsp_domeinen WHERE categorie = 9") or die(mysql_error()); $num = mysql_fetch_object($count); $template->assign_var('ero_links', $num->total); $count = mysql_query("SELECT count(1) AS total FROM bsp_partners") or die(mysql_error()); $num = mysql_fetch_object($count); $template->assign_var('links', $num->total); $count = mysql_query("SELECT count(1) AS total FROM bsp_rubrieken") or die(mysql_error()); $num = mysql_fetch_object($count); $template->assign_var('rubrieken', $num->total); $count = mysql_query("SELECT count(1) AS total FROM bsp_domeinen WHERE berichtenbalk = 1") or die(mysql_error()); $num = mysql_fetch_object($count); $template->assign_var('berichtenbalk', $num->total); $count = mysql_query("SELECT count(1) AS total FROM bsp_stembus") or die(mysql_error()); $num = mysql_fetch_object($count); $template->assign_var('poll', $num->total); $i = 0; $query = mysql_query("SELECT domein,gdomein,aangemaakt FROM bsp_domeinen WHERE active = 1 ORDER BY id DESC LIMIT 10") or die(mysql_error()); while($ob = mysql_fetch_object($query)) { $i++; $template->assign_block_vars('top10_new', array( 'nr' => $i, 'domein' => $ob->domein, 'gdomein' => $KDOMEINEN[$ob->gdomein], 'datum' => date("d-m", $ob->aangemaakt) )); } $i = 0; $query = mysql_query("SELECT domein,gdomein,aantallinks FROM bsp_domeinen WHERE active = 1 ORDER BY aantallinks DESC LIMIT 10") or die(mysql_error()); while($ob = mysql_fetch_object($query)) { $i++; $template->assign_block_vars('top10_most', array( 'nr' => $i, 'domein' => $ob->domein, 'gdomein' => $KDOMEINEN[$ob->gdomein], 'datum' => $ob->aantallinks )); } $i = 0; $query = mysql_query("SELECT domein,gdomein,aangepast FROM bsp_domeinen WHERE active = 1 ORDER BY aangepast DESC LIMIT 10") or die(mysql_error()); while($ob = mysql_fetch_object($query)) { $i++; $template->assign_block_vars('top10_changed', array( 'nr' => $i, 'domein' => $ob->domein, 'gdomein' => $KDOMEINEN[$ob->gdomein], 'datum' => date("d-m", $ob->aangepast) )); } include('includes/footer.inc.php'); ?>