include("includes/connect.php"); if(checklogin(false) == false){ header("location:http://".$domein."login.php?e=1&url=".getCurrentPageUrl()); } /*Bovenaan*/ $menu = 5; $submenu = 1; $paginakeywords = ''; $style="userindex"; include "layout/header.php"; $maxaantal_sql = mysql_query("SELECT * FROM `".SQL_PF."users` WHERE `id`= '".$_COOKIE['id']."'"); $maxaantal = mysql_fetch_assoc($maxaantal_sql); $huizen_sql = mysql_query("SELECT * FROM `".SQL_PF."huizen` WHERE `user_id` = ".$_COOKIE['id']); $huizen = mysql_num_rows($huizen_sql); $matches = 0; $spotlight = 0; while($data = mysql_fetch_array($huizen_sql)){ $match_sql=mysql_query("SELECT * FROM `".SQL_PF."matches` WHERE `huizen_id` = ".$data['id']); $matches+= mysql_num_rows($match_sql); $spotlight_sql = mysql_query("SELECT * FROM `".SQL_PF."spotlight` WHERE `huizen_id` = ".$data['id']." AND `tijd`+(`uren`*3600) > NOW()"); $spotlight+= mysql_num_rows($spotlight_sql); } $zoek_sql = mysql_query("SELECT * FROM `".SQL_PF."zoek` WHERE `user-id` = ".$_COOKIE['id']); $zoek = mysql_num_rows($zoek_sql); while($data = mysql_fetch_array($zoek_sql)){ $match_sql=mysql_query("SELECT * FROM `".SQL_PF."matches` WHERE `zoek_id` = ".$data['id']); $matches+= mysql_num_rows($match_sql); } ?>
| Login: | =$maxaantal['login']?> |
|---|---|
| E-mail: | =$maxaantal['email']?> |
| Huizen: | =$huizen?> / =$maxaantal['maxhuizen']?> |
| Zoek opdrachten: | =$zoek?> / =$maxaantal['maxzoek']?> |
| Matches: | =$matches?> |
| Huizen in spotlight: | =$spotlight?> / =$huizen?> |
| Gegevens bewerken | |