function get_index_list($count, $type) { switch ($type) { case 'popular': $query = he_database::placeholder("SELECT `quiz`.*, COUNT(`play`.`id`) AS `takes` FROM `se_he_quiz` AS `quiz`\r\n\t\t\t\t\tLEFT JOIN `se_he_quiz_play` AS `play` ON(`quiz`.`quiz_id`=`play`.`quiz_id`)\r\n\t\t\t\t\tWHERE `quiz`.`status`=1 AND `quiz`.`approved`=1\r\n\t\t\t\t\tGROUP BY `quiz`.`quiz_id`\r\n\t\t\t\t\tORDER BY `takes` DESC LIMIT ?, ?", 0, $count); break; case 'commented': $query = he_database::placeholder("SELECT `quiz`.*, COUNT(`comment`.`he_quizcomment_id`) AS `comment`\r\n FROM `se_he_quiz` AS `quiz`\r\n LEFT JOIN `se_he_quizcomments` AS `comment` ON(`quiz`.`quiz_id`=`comment`.`he_quizcomment_quiz_id`)\r\n WHERE `quiz`.`status`=1 AND `quiz`.`approved`=1\r\n GROUP BY `quiz`.`quiz_id`\r\n ORDER BY `comment` DESC LIMIT ?, ?", 0, $count); break; default: $query = he_database::placeholder("SELECT * FROM `se_he_quiz` \r\n WHERE `status`=1 AND `approved`=1\r\n ORDER BY `id` DESC LIMIT ?, ?", 0, $count); break; } $res = he_database::query($query); $quiz_list = array(); while ($quiz = he_database::fetch_row_from_resource($res)) { $quiz['photo_url'] = $quiz['photo'] ? he_quiz::photo_url() . $quiz['photo'] : ''; $quiz['photo_dir'] = $quiz['photo'] ? he_quiz::photo_dir() . $quiz['photo'] : ''; $quiz['size'] = getimagesize($quiz['photo_dir']); $quiz_list[$quiz['quiz_id']] = $quiz; } return $quiz_list; }