$user['status'] $infos = array('id','username','mail_address','nb_image_line','nb_line_page', 'status','language','maxwidth','maxheight','expand', 'show_nb_comments','recent_period','template', 'forbidden_categories'); $query_user = 'SELECT * FROM '.USERS_TABLE; $query_done = false; $user['is_the_guest'] = false; if (isset($_COOKIE['id'])) { $session_id = $_COOKIE['id']; $user['has_cookie'] = true; } else if (isset($_GET['id'])) { $session_id = $_GET['id']; $user['has_cookie'] = false; } else { $user['has_cookie'] = false; } if (isset($session_id) and ereg("^[0-9a-zA-Z]{".$conf['session_id_size']."}$", $session_id)) { $page['session_id'] = $session_id; $query = ' SELECT user_id,expiration,NOW() AS now FROM '.SESSIONS_TABLE.' WHERE id = \''.$page['session_id'].'\' ;'; $result = pwg_query($query); if (mysql_num_rows($result) > 0) { $row = mysql_fetch_array($result); if (strnatcmp($row['expiration'], $row['now']) < 0) { // deletion of the session from the database, because it is // out-of-date $delete_query = ' DELETE FROM '.SESSIONS_TABLE.' WHERE id = \''.$page['session_id'].'\' ;'; pwg_query($delete_query); } else { $query_user .= ' WHERE id = '.$row['user_id']; $query_done = true; } } } if (!$query_done) { $query_user .= ' WHERE id = 2'; $user['is_the_guest'] = true; } $query_user .= ';'; $row = mysql_fetch_array(pwg_query($query_user)); // affectation of each value retrieved in the users table into a variable // of the array $user. foreach ($infos as $info) { if (isset($row[$info])) { // If the field is true or false, the variable is transformed into a // boolean value. if ($row[$info] == 'true' or $row[$info] == 'false') $user[$info] = get_boolean($row[$info]); else $user[$info] = $row[$info]; } else { $user[$info] = ''; } } // special for $user['restrictions'] array $user['restrictions'] = explode(',', $user['forbidden_categories']); if ($user['restrictions'][0] == '') { $user['restrictions'] = array(); } $isadmin = false; if ($user['status'] == 'admin') { $isadmin =true; } // calculation of the number of picture to display per page $user['nb_image_page'] = $user['nb_image_line'] * $user['nb_line_page']; init_userprefs($user); ?>