/** * Gets a user's profile data, according to the given $user_id * @param int $user_id The user's id * @return mixed The selected user's profile */ public static function getPublicProfileOfUser($user_id) { if (self::$getPublicOfUserQuery === null) { self::$getPublicOfUserQuery = DatabaseFactory::getFactory()->getConnection()->prepare("SELECT user_id, user_name, user_email, user_active, user_has_avatar\n FROM users WHERE user_id = :user_id LIMIT 1"); } self::$getPublicOfUserQuery->execute(array(':user_id' => $user_id)); $user = self::$getPublicOfUserQuery->fetch(); if (self::$getPublicOfUserQuery->rowCount() == 1) { if (Config::get('USE_GRAVATAR')) { $user->user_avatar_link = AvatarModel::getGravatarLinkByEmail($user->user_email); } else { $user->user_avatar_link = AvatarModel::getPublicAvatarFilePathOfUser($user->user_has_avatar, $user->user_id); } } else { Session::add('feedback_negative', Text::get('FEEDBACK_USER_DOES_NOT_EXIST')); } return $user; }
/** * Gets a user's profile data, according to the given $user_id * @param int $user_id The user's id * @return mixed The selected user's profile */ public static function getPublicProfileOfUser($user_id) { $database = DatabaseFactory::getFactory()->getConnection(); $sql = "SELECT user_id, user_name, user_email, user_active, user_has_avatar, user_deleted\n FROM users WHERE user_id = :user_id LIMIT 1"; $query = $database->prepare($sql); $query->execute(array(':user_id' => $user_id)); $user = $query->fetch(); if ($query->rowCount() == 1) { if (Config::get('USE_GRAVATAR')) { $user->user_avatar_link = AvatarModel::getGravatarLinkByEmail($user->user_email); } else { $user->user_avatar_link = AvatarModel::getPublicAvatarFilePathOfUser($user->user_has_avatar, $user->user_id); } } else { Session::add('feedback_negative', Text::get('FEEDBACK_USER_DOES_NOT_EXIST')); } // all elements of array passed to Filter::XSSFilter for XSS sanitation, have a look into // application/core/Filter.php for more info on how to use. Removes (possibly bad) JavaScript etc from // the user's values array_walk_recursive($user, 'Filter::XSSFilter'); return $user; }
public static function getAllInstructors() { $database = DatabaseFactory::getFactory()->getConnection(); $sql = "SELECT user_id, user_name, user_email, user_active, user_has_avatar, user_deleted FROM users WHERE user_account_type = 6"; $query = $database->prepare($sql); $query->execute(); $all_users_profiles = array(); foreach ($query->fetchAll() as $user) { // all elements of array passed to Filter::XSSFilter for XSS sanitation, have a look into // application/core/Filter.php for more info on how to use. Removes (possibly bad) JavaScript etc from // the user's values array_walk_recursive($user, 'Filter::XSSFilter'); $all_users_profiles[$user->user_id] = new stdClass(); $all_users_profiles[$user->user_id]->user_id = $user->user_id; $all_users_profiles[$user->user_id]->user_name = $user->user_name; $all_users_profiles[$user->user_id]->user_email = $user->user_email; $all_users_profiles[$user->user_id]->user_active = $user->user_active; $all_users_profiles[$user->user_id]->user_deleted = $user->user_deleted; $all_users_profiles[$user->user_id]->user_avatar_link = Config::get('USE_GRAVATAR') ? AvatarModel::getGravatarLinkByEmail($user->user_email) : AvatarModel::getPublicAvatarFilePathOfUser($user->user_has_avatar, $user->user_id); } return $all_users_profiles; }