function get_users($user_ids)
{
if (!$user_ids) {
return array();
}
$user_ids_str = implode(',', $user_ids);
$sql = "SELECT `user_id`, `user_username`, `user_fname`, `user_lname`, `user_photo` FROM `se_users`\r\n \tWHERE `user_id` IN ({$user_ids_str})";
$user_list = array();
$res = he_database::query($sql);
while ($row = he_database::fetch_row_from_resource($res)) {
$author = new se_user();
$author->user_exists = 1;
$author->user_info['user_id'] = $row['user_id'];
$author->user_info['user_username'] = $row['user_username'];
$author->user_info['user_fname'] = $row['user_fname'];
$author->user_info['user_lname'] = $row['user_lname'];
$author->user_info['user_photo'] = $row['user_photo'];
$author->user_displayname();
$user_list[$row['user_id']] = $author;
}
return $user_list;
}
function recent_taked_quizzes($count = 10)
{
$query = he_database::placeholder("SELECT `play`.`user_id` AS `play_user_id`, `play`.`play_stamp`, `quiz`.*\r\n\t\t\tFROM `se_he_quiz_play` AS `play`\r\n\t\t\tINNER JOIN ( \r\n\t\t\t SELECT MAX(`play_stamp`) AS `play_stamp` FROM `se_he_quiz_play`\r\n\t\t\t WHERE `play_stamp`!=0\r\n\t\t\t GROUP BY `quiz_id`\r\n\t\t\t) AS `last` ON (`play`.`play_stamp`=`last`.`play_stamp`)\r\n\t\t\tINNER JOIN `se_he_quiz` AS `quiz` ON (`play`.`quiz_id`=`quiz`.`quiz_id`)\r\n\t\t\tWHERE `quiz`.approved = 1 AND `quiz`.`status`=1\r\n\t\t\tLIMIT ?", $count);
$takes = array();
$res = he_database::query($query);
$quiz_arr = array();
while ($quiz = he_database::fetch_row_from_resource($res)) {
$quiz['user'] = new se_user(array($quiz['play_user_id']));
$quiz['photo_url'] = $quiz['photo'] ? he_quiz::photo_url() . $quiz['photo'] : '';
$quiz_arr[$quiz['quiz_id']] = $quiz;
}
return $quiz_arr;
}
