"; $settings['footer'] = "

"; /*** MY_SQL ***/ include("./config.inc.php"); /**** OUT ****/ if(isset($out)) { $sql = mysql_query("SELECT * FROM banner_sys WHERE id = '$out' AND actief = '1' LIMIT 1"); if(mysql_num_rows($sql) == 0) { echo $settings['header']; echo "Deze banner bestaat niet (meer)!\n"; echo $settings['footer']; } else { // update kliks mysql_query("UPDATE banner_sys SET kliks = kliks + 1 WHERE id = '$out'"); // list $list = mysql_fetch_array($sql); // redirect HEADER("Location: $list[url]"); } /**** BANNER ****/ } else { $sql = mysql_query("SELECT * FROM banner_sys WHERE verloopt > '". time() ."' AND actief = '1'"); $banners = mysql_num_rows($sql); if($banners == 0) { echo $settings['header']; echo "Jouw banner hier? Klik hier..\n"; echo $settings['footer']; } else { // deactiveer banners mysql_query("UPDATE banner_sys SET actief = '0' WHERE (verloopt < '". time() ."' OR gebruikt >= credits) AND actief = '1'"); // selecteer random banner $sql = mysql_query("SELECT * FROM banner_sys WHERE actief = '1' ORDER BY RAND() LIMIT 1"); $list = mysql_fetch_array($sql); // update gebruikt mysql_query("UPDATE banner_sys SET gebruikt = gebruikt + 1 WHERE id = '$list[id]'"); echo $settings['header']; echo "\n"; echo $settings['footer']; } } ?>