diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2005-07-11 07:14:49 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2005-07-11 07:14:49 +0000 |
| commit | b29feaca4960b7190744a12c34f8a587ab008966 (patch) | |
| tree | 4bcf5522cfd7d1b75a8b7aa56192f09ef790aa88 /modules | |
| parent | 53028c86faa8039a87bbdcabef6bc7441757ac18 (diff) | |
| download | ampache-b29feaca4960b7190744a12c34f8a587ab008966.tar.gz ampache-b29feaca4960b7190744a12c34f8a587ab008966.tar.bz2 ampache-b29feaca4960b7190744a12c34f8a587ab008966.zip | |
more xmlrpc mojo, along with some misc cleanup
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/lib.php | 94 |
1 files changed, 0 insertions, 94 deletions
diff --git a/modules/lib.php b/modules/lib.php index 90094be9..6192c4af 100644 --- a/modules/lib.php +++ b/modules/lib.php @@ -9,100 +9,6 @@ */ - -/* - * show_local_catalog_info() - * - */ -function show_local_catalog_info() { - global $settings, $username; - $dbh = dbh(); - - $query = "SELECT count(*) AS songs, SUM(size) AS size, SUM(time) as time FROM song"; - $db_result = mysql_query($query, $dbh); - $songs = mysql_fetch_array($db_result); - - $query = "SELECT count(*) FROM album"; - $db_result = mysql_query($query, $dbh); - $albums = mysql_fetch_row($db_result); - - $query = "SELECT count(*) FROM artist"; - $db_result = mysql_query($query, $dbh); - $artists = mysql_fetch_row($db_result); - - $sql = "SELECT count(*) FROM user"; - $db_result = mysql_query($sql, $dbh); - $users = mysql_fetch_row($db_result); - - $time = time(); - $last_seen_time = $time - 1200; - $sql = "SELECT count(DISTINCT s.username) FROM session AS s " . - "INNER JOIN user AS u ON s.username = u.username " . - "WHERE s.expire > " . $time . " " . - "AND u.last_seen > " . $last_seen_time; - $db_result = mysql_query($sql, $dbh); - $connected_users = mysql_fetch_row($db_result); - - $hours = floor($songs['time']/3600); - $size = $songs['size']/1048576; - - $days = floor($hours/24); - $hours = $hours%24; - - $time_text = "$days "; - $time_text .= ($days == 1) ? _("day") : _("days"); - $time_text .= ", $hours "; - $time_text .= ($hours == 1) ? _("hour") : _("hours"); - - if ( $size > 1024 ) { - $total_size = sprintf("%.2f", ($size/1024)); - $size_unit = "GB"; - } - else { - $total_size = sprintf("%.2f", $size); - $size_unit = "MB"; - } - - - print ' -<table class="border" cellspacing="1" cellpadding="3" width="100%" border="0"> - <tr class="table-header"> - <td colspan="2">' . _("Catalog Statistics") . '</td> - </tr> - <tr class="even"> - <td> ' . _("Total Users") . ' </td> - <td> <b>' . $users[0] .'</b> </td> - </tr> - <tr class="even"> - <td> ' . _("Connected Users") . ' </td> - <td> <b>' . $connected_users[0] .'</b> </td> - </tr> - <tr class="even"> - <td> ' . _("Albums") . ' </td> - <td> <b>' . $albums[0] .'</b> </td> - </tr> - <tr class="even"> - <td> ' . _("Artists") . ' </td> - <td> <b>' . $artists[0] .'</b> </td> - </tr> - <tr class="even"> - <td> ' . _("Songs") . ' </td> - <td> <b>' . $songs[0] .'</b> </td> - </tr> - <tr class="even"> - <td> ' . _("Catalog Size") . ' </td> - <td> <b>' . $total_size .' ' . $size_unit .'</b> </td> - </tr> - <tr class="even"> - <td> ' . _("Catalog Time") . ' </td> - <td> <b>' . $time_text .'</b> </td> - </tr> -</table> -'; - -} // show_local_catalog_info() - - /* * show_random_play() * |