USER; $navPath=array("songs"); $SEO["title"]="missy's buttery list of hot buttered rum songs and lyrics"; $SEO["desc"]="missy's buttery list of hot buttered rum songs and lyrics, listing all the songs high altitude bluegrass band hot buttered rum plays live, how many times they've been played, the first and last appearance, and who wrote the song"; $SEO["keys"]="missy, baron, buttery, song, list, hot buttered rum, songs, lyrics, composers, show dates"; $songs=new songs(1); $ppl=new people(1); $sortCol=empty($sortCol)?"names":$sortCol; $sortDir=empty($sortDir)?"a":$sortDir; // DEAL WITH DATA AND SORTING $songs->getShows(); foreach($songs->items as $k=>$item) { $keys["k".$k]=$k; $names["k".$k]=strtolower(preg_replace("[\W]","",$item->name)); $auths["k".$k]=($item->nonhbrwriter!=""?$item->nonhbrwriter:($item->author_person!="0"&&$item->author_person!=""?$ppl->items[$item->author_person]->lastname.($item->composer_person!="0"&&$item->composer_person!=""?" / ".$ppl->items[$item->composer_person]->lastname:""):"")); $dispAuths["k".$k]=($item->nonhbrwriter!=""?$auths["k".$k]:"".$auths["k".$k].""); $times["k".$k]=$item->shows->numItems; if($item->shows->numItems>0) { list($firstKeys["k".$k],$firstDates["k".$k])=$item->shows->colMin("showdate"); list($lastKeys["k".$k],$lastDates["k".$k])=$item->shows->colMax("showdate"); } else { list($firstKeys["k".$k],$firstDates["k".$k])=array(0,0); list($lastKeys["k".$k],$lastDates["k".$k])=array(0,0); } $showsSince["k".$k]=$item->showsSince($lastDates["k".$k], date("Y-m-d")); } if(!empty($sortCol)) { $fn="a".($sortDir=="r"?"r":"")."sort"; $fn($$sortCol); } ?>
details | instrumentation [advanced search]numItems; ?> songs
$item) { $class=++$i%2?"lt":"dk"; $sk = $keys[$k]; $firstDate=split("-",$firstDates[$k]); $lastDate=split("-",$lastDates[$k]); ?> numItems<1) { print ""; } ?>
" class="DkBg">name":""; ?> " class="DkBg">Composer":""; ?> " class="DkBg">times
played
":" "; ?> " class="DkBg">first":""; ?> " class="DkBg">last":""; ?> " class="DkBg">shows
since
":" "; ?>
items[$sk]->showDisplayName(); ?>           
no results