USER;
$navPath=array("stats");
$SEO["title"]="statistics about what hot buttered rum has played, when, and how";
function decPlaces($num,$places) {
return round($num*pow(10,$places))/pow(10,$places);
}
?>
Come review the stats often -- they'll change as we continue to input more data!
popOneRecord();
$NUMSHOWS = $rs->record["cnt"];
$NUMDAYS = $rs->record["days"];
$rs=new rs("select distinct(shows.id) as cnt from shows, showsets, setsongs where setsongs.showset=showsets.id and showsets.showid=shows.id;");
$NUMSHOWSWSETLIST = $rs->length;
$rs=new rs("select distinct(showsets.id) as cnt from showsets, setsongs where setsongs.showset=showsets.id and showsets.isencore!=1;");
$NUMSETSWSONGS = $rs->length;
// SONGS PER SET
$rs->query("select count(*) as setcnt from showsets where showsets.isencore!=1;");
$rs->popOneRecord();
$NUMSETS = $rs->record["setcnt"];
$rs->query("select count(*) as sngcnt from showsets, setsongs where showsets.isencore!=1 and setsongs.showset=showsets.id;");
$rs->popOneRecord();
$NUMSETSONGS = $rs->record["sngcnt"];
// SONGS PER ENC
$rs->query("select count(*) as setcnt from showsets where showsets.isencore=1;");
$rs->popOneRecord();
$NUMENCS = $rs->record["setcnt"];
$rs->query("select count(*) as sngcnt from showsets, setsongs where showsets.isencore=1 and setsongs.showset=showsets.id;");
$rs->popOneRecord();
$NUMENCSONGS = $rs->record["sngcnt"];
?>
| total Shows: |
() [show stats] |
query("select Date_Format(showdate,'%Y') as y, count(date_format(showdate,'%Y')) as cnt from shows group by y order by y;");
$rs->records=array();
$rs->popRecords("y");
$YRSHOWS = $rs->records;
?>
shows per year: |
Average: ()
$item) { print $k.": ".$item["cnt"]." (".decPlaces(($item["cnt"]/$NUMSHOWS)*100,1)."%)
"; } ?> |
query("select Date_Format(showdate,'%m') as i, Date_Format(showdate,'%M') as m, count(date_format(showdate,'%M')) as cnt from shows group by m order by i;");
$rs->records=array();
$rs->popRecords("m");
$MONSHOWS = $rs->records;
?>
shows by month: |
$item) { print $k.": ".$item["cnt"]." (".decPlaces(($item["cnt"]/$NUMSHOWS)*100,1)."%)
"; } ?> |
query("select Date_Format(showdate,'%w') as i, Date_Format(showdate,'%W') as w, count(date_format(showdate,'%W')) as cnt from shows group by w order by i;");
$rs->records=array();
$rs->popRecords("w");
$DAYSHOWS = $rs->records;
?>
shows by day: |
$item) { print $k.": ".$item["cnt"]." (".decPlaces(($item["cnt"]/$NUMSHOWS)*100,1)."%)
"; } ?> |
query("select count(distinct(venues.state)) as cnt from venues, shows where shows.venue=venues.id;");
$rs->records=array();
$rs->popOneRecord();
$NUMSTATES = $rs->record["cnt"];
?>
states/territories: |
[state stats] |
query("select count(distinct(shows.venue)) as cnt from shows;");
$rs->records=array();
$rs->popOneRecord();
$NUMVENUES = $rs->record["cnt"];
?>
venues: |
[venue stats] |
| sets per show: |
() |
| encs per show: |
|
searchFields["nonhbrwriter"]=array("","=");
$NUMORIGS=$origs->getAll();
$covers=new songs(0);
$covers->searchFields["nonhbrwriter"]=array("","!=");
$NUMCOVERS=$covers->getAll();
?>
songs: |
[song stats]
originals: (%)
covers: (%) |
| songs per show: |
|
| songs per set: |
|
| songs per encore: |
|