// ADD CRITERIA FOR FILTER $where = ""; if ($f_owner != "") { $where .= "se_users.user_id LIKE '%{$f_owner}%'"; } if ($f_owner != "" & $f_title != "") { $where .= " AND"; } if ($f_title != "") { $where .= " se_music.music_title LIKE '%{$f_title}%'"; } if ($where != "") { $where = "(" . $where . ")"; } // GET TOTAL ENTRIES $total_music = $music->music_list_total(NULL, NULL, $where); // MAKE ENTRY PAGES $page_vars = make_page($total_music, $entries_per_page, $p); $page_array = array(); for ($x = 0; $x <= $page_vars[2] - 1; $x++) { if ($x + 1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; } $page_array[$x] = array('page' => $x + 1, 'link' => $link); } // GET SONG LIST ARRAY $music_list = $music->music_list($page_vars[0], $entries_per_page, $sort, $where); // ASSIGN VARIABLES AND SHOW VIEW ENTRIES PAGE $smarty->assign('total_music', $total_music);
// ENSURE SORT/VIEW ARE VALID if ($s != "music_date DESC" && $s != "music_track_num ASC") { $s = "music_date DESC"; } if ($v != "0" && $v != "1") { $v = 0; } // ONLY MY FRIENDS' MUSIC if ($v == "1" && $user->user_exists) { // SET WHERE CLAUSE $where = "(\r\n SELECT\r\n TRUE\r\n FROM\r\n se_friends\r\n WHERE\r\n friend_user_id1={$user->user_info[user_id]} &&\r\n friend_user_id2=se_music.music_user_id &&\r\n friend_status=1\r\n ) \r\n "; } // CREATE ALBUM OBJECT $music_object = new se_music(); // GET TOTAL ALBUMS $browse_music_total = $music_object->music_list_total(NULL, NULL, $where); // MAKE ENTRY PAGES $music_per_page = 20; $page_vars = make_page($browse_music_total, $music_per_page, $p); // GET ALBUM ARRAY $browse_music_list = $music_object->music_list($page_vars[0], $music_per_page, $s, $where); // ASSIGN SMARTY VARIABLES AND DISPLAY MUSIC PAGE $smarty->assign('browse_music_list', $browse_music_list); $smarty->assign('browse_music_total', $browse_music_total); $smarty->assign('p', $page_vars[1]); $smarty->assign('maxpage', $page_vars[2]); $smarty->assign('p_start', $page_vars[0] + 1); $smarty->assign('p_end', $page_vars[0] + count($browse_music_list)); $smarty->assign('s', $s); $smarty->assign('v', $v); include "footer.php";