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;
