} else { $user_email = $user_email; $user_newemail = $user_email; $subnet_id = $new_subnet_id; if ($new_subnet_id != $user->user_info['user_subnet_id']) { $result = 819; } else { $result = 191; } } // UPDATE DATABASE $database->database_query("UPDATE se_users SET user_subnet_id='{$subnet_id}', user_email='{$user_email}', user_newemail='{$user_newemail}', user_username='******', user_timezone='{$user_timezone}', user_profilecat_id='{$user_profilecat_id}' WHERE user_id='{$user->user_info['user_id']}' LIMIT 1"); if (count($usersettings) > 0) { $database->database_query("UPDATE se_usersettings SET " . implode(", ", $usersettings) . " WHERE usersetting_user_id='{$user->user_info['user_id']}' LIMIT 1"); // Flush cached usersettings $usersettings_static =& SEUser::getUserSettings($user->user_info['user_id']); $usersettings_static = NULL; $cache_object = SECache::getInstance(); if (is_object($cache_object)) { $cache_object->remove('site_user_settings_' . $user->user_info['user_id']); } } // IF USERNAME HAS CHANGED, DELETE OLD RECENT ACTIVITY if ($user->user_info['user_username'] != $user_username) { $database->database_query("DELETE FROM se_actions WHERE action_user_id='{$user->user_info['user_id']}'"); } // RESET USER INFO $user = new se_user(array($user->user_info['user_id'])); // UPDATE COOKIES $user->user_setcookies(); }
function user_settings($select_fields = "*") { global $database; $this->usersetting_info =& SEUser::getUserSettings($this->user_info['user_id']); //$this->usersetting_info = $database->database_fetch_assoc($database->database_query("SELECT $select_fields FROM se_usersettings WHERE usersetting_user_id='".$this->user_info[user_id]."'")); }