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 { $user['id'] = $row['user_id']; $user['is_the_guest'] = false; } } } if (!isset($user['id'])) { $user['id'] = 2; $user['is_the_guest'] = true; } $query = ' SELECT u.*, uf.* FROM '.USERS_TABLE.' AS u LEFT JOIN '.USER_FORBIDDEN_TABLE.' AS uf ON id = user_id WHERE u.id = '.$user['id'].' ;'; $row = mysql_fetch_array(pwg_query($query)); // affectation of each value retrieved in the users table into a variable of // the array $user. foreach ($row as $key => $value) { if (!is_numeric($key)) { // If the field is true or false, the variable is transformed into a // boolean value. if ($value == 'true' or $value == 'false') { $user[$key] = get_boolean($value); } else { $user[$key] = $value; } } } // if no information were found about user in user_forbidden table OR the // forbidden categories must be updated if (!isset($user['need_update']) or !is_bool($user['need_update']) or $user['need_update'] == true) { $user['forbidden_categories'] = calculate_permissions($user['id']); } // forbidden_categories is a must be empty, at least if (!isset($user['forbidden_categories'])) { $user['forbidden_categories'] = ''; } // 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); ?>