public static function get_by_id($id) { global $mysqli; $config = new Config(); $id = sanitize_input($id); $sql = "SELECT `id`, `username`, `email`, `full_name`, `bio`, `url`, `points`, `invites`, `password`, `date_added`, `date_joined` FROM `{$config->database->{$config->site_identifier}->prefix}users` WHERE `id` = {$id}"; $query = mysqli_query($mysqli, $sql); $result = mysqli_fetch_assoc($query); if (!is_array($result)) { return null; } else { $user = new User($result); $user->email_notifications = $user->email_notifications(); return $user; } }