function songlist($criteria, $table_prefix = 'cb_') { global $database, $mainframe; // get the limits $limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', 10); $limitstart = $mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0); $chordBase = new ChordBase($database, "#__cb_"); $chordBase->setCriteria($criteria); $songs = $chordBase->songlist($limitstart, $limit); $categories = $chordBase->getCategories(); $writers = $chordBase->getWriters(); include_once "includes/pageNavigation.php"; $pageNav = new mosPageNav($chordBase->numSongs(), $limitstart, $limit); HTML_chordbase::songlist($songs, $categories, $writers, users_array(), $search, &$pageNav); }
$criteria["showAll"] = TRUE; } else { $criteria["showAll"] = FALSE; } // get the limits $criteria["limit"] = trim(mosGetParam($_REQUEST, 'limit', 20)); $criteria["limitstart"] = trim(mosGetParam($_REQUEST, 'limitstart', 0)); $chordBase->setCriteria($criteria); $songs = $chordBase->songlist(); $categories = $chordBase->getCategories(); $writers = $chordBase->getWriters(); include_once "includes/pageNavigation.php"; $pageNav = new mosPageNav($chordBase->numSongs(), $criteria["limitstart"], $criteria["limit"]); $permissions["Add Song"] = $chordBase->has_permission("Add Song", $cb_user_permission); $permissions["Publish Song"] = $chordBase->has_permission("Publish Song", $cb_user_permission); HTML_chordbase::songlist($songs, $categories, $writers, $search, &$pageNav, $permissions, $criteria); HTML_chordbase::footer(); break; } function editSong($song_id = "") { global $database, $Itemid, $my; HTML_chordbase::cb_header("Song Editor"); $chordBase = new ChordBase($database, "#__cb_"); $chordBase->setCriteria($criteria); $categories = $chordBase->getCategories(); $writers = $chordBase->getWriters(); $song = new cbSong($database, "#__cb_"); if ($song_id) { $song->load($song_id); $song->add_time = $song->add_time == 0 ? time() : $song->add_time;