include("./inc/config.inc.php"); $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `activated`=1"); $leden = mysql_num_rows($dbres)*2; $dbres2 = mysql_query("SELECT `id` FROM `[users]` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300"); $online = mysql_num_rows($dbres2); $online244 = mysql_query("SELECT `id` FROM `[users]` WHERE `online` LIKE '".date('Y-m-d',(time()-3600))."%'"); $online24 = mysql_num_rows($online244)*7; $select3 = mysql_query("SELECT `id` FROM `[messages]`"); $berichten = mysql_num_rows($select3); $select4 = mysql_query("SELECT `id` FROM `[forum2_topics]`"); $forum = mysql_num_rows($select4); $select5 = mysql_query("SELECT `id` FROM `[forum2_replys]`"); $repl = mysql_num_rows($select5); $laatstelid = mysql_query("select `login` from `[users]` order by id desc limit 0,3"); $laatste = @mysql_result($laatstelid,0,0); if(isset($_POST['login'],$_POST['pass'])) { $dbres = mysql_query("SELECT `login`,`activated` FROM `[users]` WHERE `login`='{$_POST['login']}' AND `pass`=MD5('{$_POST['pass']}')"); if(($data = mysql_fetch_object($dbres)) && $data->activated == 1) { $validate = md5(rand(0,1000)); setcookie("login",$data->login,time()+60*60*24,"/",""); setcookie("validate",$validate,time()+60*60*24,"/",""); mysql_query("REPLACE INTO `[online]`(`time`,`login`,`IP`,`validate`) values(NOW(),'{$_SERVER['REMOTE_ADDR']}','{$data->login}','$validate')"); $_SESSION['login'] = $data->login; $_SESSION['IP'] = $_SERVER['REMOTE_ADDR']; $dbres = mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup` FROM `[users]` WHERE `login`='{$_SESSION['login']}'"); $_SESSION['data'] = mysql_fetch_object($dbres); } } ?>
:: Nieuwste:
:: leden:
:: Actief: