예제 #1
0
// 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);
예제 #2
0
// 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";