echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?titlefeat=1') . '">"feat." in Title field</a></li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?emptygenres=1') . '">Blank genres</a></li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?trackzero=1') . '">Track "zero"</a></li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?nonemptycomments=1') . '">non-empty comments</a></li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?unsynchronizedtags=2A1') . '">Tags that are not synchronized</a> (<a href="' . $_SERVER['PHP_SELF'] . '?unsynchronizedtags=2A1&autofix=1">autofix</a>)</li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?filenamepattern=' . urlencode('[N] A - T {R}')) . '">Filenames that don\'t match pattern</a> (<a href="?filenamepattern=' . urlencode('[N] A - T {R}') . '&autofix=1">auto-fix</a>)</li>';
//echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?filenamepattern='.urlencode('A - T')).'">Filenames that don\'t match pattern</a></li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?correctcase=1') . '">Correct filename case (Win/DOS)</a></li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?fixid3v1padding=1') . '">Fix ID3v1 invalid padding</a></li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?errorswarnings=1') . '">Files with Errors and/or Warnings</a></li>';
echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?rescanerrors=1') . '">Re-scan only files with Errors and/or Warnings</a></li>';
echo '</ul>';
$SQLquery = 'SELECT COUNT(*) AS `TotalFiles`, SUM(`playtime_seconds`) AS `TotalPlaytime`, SUM(`filesize`) AS `TotalFilesize`, AVG(`playtime_seconds`) AS `AvgPlaytime`, AVG(`filesize`) AS `AvgFilesize`, AVG(`audio_bitrate` + `video_bitrate`) AS `AvgBitrate`';
$SQLquery .= ' FROM `' . mysql_real_escape_string(GETID3_DB_TABLE) . '`';
$result = mysql_query_safe($SQLquery);
if ($row = mysql_fetch_array($result)) {
echo '<hr size="1">';
echo '<div style="float: right;">';
echo 'Spent ' . number_format(mysql_query_safe(null), 3) . ' seconds querying the database<br>';
echo '</div>';
echo '<b>Currently in the database:</b><TABLE>';
echo '<tr><th align="left">Total Files</th><td>' . number_format($row['TotalFiles']) . '</td></tr>';
echo '<tr><th align="left">Total Filesize</th><td>' . number_format($row['TotalFilesize'] / 1048576) . ' MB</td></tr>';
echo '<tr><th align="left">Total Playtime</th><td>' . number_format($row['TotalPlaytime'] / 3600, 1) . ' hours</td></tr>';
echo '<tr><th align="left">Average Filesize</th><td>' . number_format($row['AvgFilesize'] / 1048576, 1) . ' MB</td></tr>';
echo '<tr><th align="left">Average Playtime</th><td>' . getid3_lib::PlaytimeString($row['AvgPlaytime']) . '</td></tr>';
echo '<tr><th align="left">Average Bitrate</th><td>' . BitrateText($row['AvgBitrate'] / 1000, 1) . '</td></tr>';
echo '</table>';
echo '<br clear="all">';
}
echo '</body></html>';
echo '<a href="#" onClick="alert(\'' . FixTextFields(implode('\\n', $fileinfo['error'])) . '\'); return false;" title="' . FixTextFields(implode("\n", $fileinfo['error'])) . '">error</a><br>';
}
}
echo '</td>';
echo '<td align="left"> </td>';
// Edit
echo '<td align="left"> <a href="' . $_SERVER['PHP_SELF'] . '?listdirectory=' . urlencode($listdirectory) . '&deletefile=' . urlencode($dirname . $filename) . '" onClick="return confirm(\'Are you sure you want to delete ' . addslashes($dirname . $filename) . '? \\n(this action cannot be un-done)\');" title="Permanently delete ' . addslashes($dirname . $filename) . '">delete</a></td>';
echo '</tr>';
}
}
echo '<tr bgcolor="#' . $getID3checkColor_Head . '">';
echo '<td><b>Average:</b></td>';
echo '<td align="right">' . number_format($TotalScannedFilesize / max($TotalScannedKnownFiles, 1)) . '</td>';
echo '<td> </td>';
echo '<td align="right">' . getid3_lib::PlaytimeString($TotalScannedPlaytime / max($TotalScannedPlaytimeFiles, 1)) . '</td>';
echo '<td align="right">' . BitrateText(round($TotalScannedBitrate / 1000 / max($TotalScannedBitrateFiles, 1))) . '</td>';
echo '<td rowspan="2" colspan="' . ($columnsintable - 5) . '"><table class="table" border="0" cellspacing="0" cellpadding="2"><tr><th align="right">Identified Files:</th><td align="right">' . number_format($TotalScannedKnownFiles) . '</td><td> </td><th align="right">Errors:</th><td align="right">' . number_format($FilesWithErrors) . '</td></tr><tr><th align="right">Unknown Files:</th><td align="right">' . number_format($TotalScannedUnknownFiles) . '</td><td> </td><th align="right">Warnings:</th><td align="right">' . number_format($FilesWithWarnings) . '</td></tr></table>';
echo '</tr>';
echo '<tr bgcolor="#' . $getID3checkColor_Head . '">';
echo '<td><b>Total:</b></td>';
echo '<td align="right">' . number_format($TotalScannedFilesize) . '</td>';
echo '<td> </td>';
echo '<td align="right">' . getid3_lib::PlaytimeString($TotalScannedPlaytime) . '</td>';
echo '<td> </td>';
echo '</tr>';
}
echo '</table>';
} else {
echo '<b>ERROR: Could not open directory: <u>' . $currentfulldir . '</u></b><br>';
}
}
echo '<A HREF="getid3.write.php?EditorFilename=' . urlencode($dirname . $filename) . '" TITLE="Edit Ogg comment tags">edit tags';
}
echo '</TD>';
echo '<TD ALIGN="LEFT"> <A HREF="' . $_SERVER['PHP_SELF'] . '?listdirectory=' . urlencode($listdirectory) . '&deletefile=' . urlencode($dirname . $filename) . '" onClick="return confirm(\'Are you sure you want to delete ' . addslashes($dirname . $filename) . '? \\n(this action cannot be un-done)\');" TITLE="Permanently delete ' . "\n" . FixTextFields($filename) . "\n" . ' from' . "\n" . ' ' . FixTextFields($dirname) . '">delete</A></TD>';
echo '</TR>';
}
}
if (isset($DirectoryContents["{$dirname}"]['other']) && is_array($DirectoryContents["{$dirname}"]['other'])) {
uksort($DirectoryContents["{$dirname}"]['other'], 'MoreNaturalSort');
foreach ($DirectoryContents["{$dirname}"]['other'] as $filename => $fileinfo) {
echo '<TR BGCOLOR="#' . ($rowcounter++ % 2 ? 'BBBBDD' : 'CCCCFF') . '">';
echo '<TD><A HREF="' . $_SERVER['PHP_SELF'] . '?filename=' . urlencode($dirname . $filename) . '"><I>' . $filename . '</I></A></TD>';
echo '<TD ALIGN="RIGHT"> ' . (isset($fileinfo['filesize']) ? number_format($fileinfo['filesize']) : '-') . '</TD>';
echo '<TD ALIGN="RIGHT"> ' . NiceDisplayFiletypeFormat($fileinfo) . '</TD>';
echo '<TD ALIGN="RIGHT"> ' . (isset($fileinfo['playtime_string']) ? $fileinfo['playtime_string'] : '-') . '</TD>';
echo '<TD ALIGN="RIGHT"> ' . (isset($fileinfo['bitrate']) ? BitrateText($fileinfo['bitrate'] / 1000) : '-') . '</TD>';
echo '<TD ALIGN="LEFT"> </TD>';
// Artist
echo '<TD ALIGN="LEFT"> </TD>';
// Title
echo '<TD ALIGN="LEFT" COLSPAN="2"> </TD>';
// MD5_data
echo '<TD ALIGN="LEFT"> </TD>';
// Tags
echo '<TD ALIGN="LEFT"> </TD>';
// Warning/Error
echo '<TD ALIGN="LEFT"> </TD>';
// Edit
echo '<TD ALIGN="LEFT"> <A HREF="' . $_SERVER['PHP_SELF'] . '?listdirectory=' . urlencode($listdirectory) . '&deletefile=' . urlencode($dirname . $filename) . '" onClick="return confirm(\'Are you sure you want to delete ' . addslashes($dirname . $filename) . '? \\n(this action cannot be un-done)\');" TITLE="Permanently delete ' . addslashes($dirname . $filename) . '">delete</A></TD>';
echo '</TR>';
}
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?encodedbydistribution=' . urlencode('%') . '">Encoded By (ID3v2) Distribution</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?trackinalbum=1">Track number in Album field</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?tracknoalbum=1">Track number, but no Album</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?titlefeat=1">"feat." in Title field</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?emptygenres=1">Blank genres</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?trackzero=1">Track "zero"</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?nonemptycomments=1">non-empty comments</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?unsynchronizedtags=2A1">Tags that are not synchronized</a> (<a href="' . $_SERVER['SCRIPT_NAME'] . '?unsynchronizedtags=2A1&autofix=1">autofix</a>)</li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?filenamepattern=' . urlencode('[N] A - T {R}') . '">Filenames that don\'t match pattern</a> (<a href="?filenamepattern=' . urlencode('[N] A - T {R}') . '&autofix=1">auto-fix</a>)</li>';
//echo '<li><a href="'.$_SERVER['SCRIPT_NAME'].'?filenamepattern='.urlencode('A - T').'">Filenames that don\'t match pattern</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?correctcase=1">Correct filename case (Win/DOS)</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?fixid3v1padding=1">Fix ID3v1 invalid padding</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?errorswarnings=1">Files with Errors and/or Warnings</a></li>';
echo '<li><a href="' . $_SERVER['SCRIPT_NAME'] . '?rescanerrors=1">Re-scan only files with Errors and/or Warnings</a></li>';
echo '</ul>';
$SQLquery = 'SELECT COUNT(*) AS `TotalFiles`, SUM(`playtime_seconds`) AS `TotalPlaytime`, SUM(`filesize`) AS `TotalFilesize`, AVG(`playtime_seconds`) AS `AvgPlaytime`, AVG(`filesize`) AS `AvgFilesize`, AVG(`audio_bitrate` + `video_bitrate`) AS `AvgBitrate`';
$SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';
$result = mysql_query($SQLquery);
if ($row = mysql_fetch_array($result)) {
echo '<hr><b>Currently in the database:</b><TABLE>';
echo '<tr><TH ALIGN="LEFT">Total Files</th><td>' . number_format($row['TotalFiles']) . '</td></tr>';
echo '<tr><TH ALIGN="LEFT">Total Filesize</th><td>' . number_format($row['TotalFilesize'] / 1048576) . ' MB</td></tr>';
echo '<tr><TH ALIGN="LEFT">Total Playtime</th><td>' . number_format($row['TotalPlaytime'] / 3600, 1) . ' hours</td></tr>';
echo '<tr><TH ALIGN="LEFT">Average Filesize</th><td>' . number_format($row['AvgFilesize'] / 1048576, 1) . ' MB</td></tr>';
echo '<tr><TH ALIGN="LEFT">Average Playtime</th><td>' . getid3_lib::PlaytimeString($row['AvgPlaytime']) . '</td></tr>';
echo '<tr><TH ALIGN="LEFT">Average Bitrate</th><td>' . BitrateText($row['AvgBitrate'] / 1000, 1) . '</td></tr>';
echo '</table>';
}
?>
</BODY>
</HTML>
echo '<TD ALIGN="LEFT"> </TD>';
// Tags
echo '<TD ALIGN="LEFT"> </TD>';
// Warning/Error
echo '<TD ALIGN="LEFT"> </TD>';
// Edit
echo '<TD ALIGN="LEFT"> <A HREF="' . $_SERVER['PHP_SELF'] . '?listdirectory=' . urlencode($listdirectory) . '&deletefile=' . urlencode($dirname . $filename) . '" onClick="return confirm(\'Are you sure you want to delete ' . addslashes($dirname . $filename) . '? \\n(this action cannot be un-done)\');" TITLE="Permanently delete ' . addslashes($dirname . $filename) . '">delete</A></TD>';
echo '</TR>';
}
}
echo '<TR BGCOLOR="#' . $getID3checkColor_Head . '">';
echo '<TD><B>Average:</B></TD>';
echo '<TD ALIGN="RIGHT">' . number_format($TotalScannedFilesize / max($TotalScannedKnownFiles, 1)) . '</TD>';
echo '<TD> </TD>';
echo '<TD ALIGN="RIGHT">' . PlaytimeString($TotalScannedPlaytime / max($TotalScannedKnownFiles, 1)) . '</TD>';
echo '<TD ALIGN="RIGHT">' . BitrateText(round($TotalScannedBitrate / 1000 / max($TotalScannedKnownFiles, 1))) . '</TD>';
echo '<TD ROWSPAN="2" COLSPAN="' . ($columnsintable - 5) . '">Identified Files: ' . $TotalScannedKnownFiles . '<BR>Unknown Files: ' . $TotalScannedUnknownFiles . '</TD>';
echo '</TR>';
echo '<TR BGCOLOR="#' . $getID3checkColor_Head . '">';
echo '<TD><B>Total:</B></TD>';
echo '<TD ALIGN="RIGHT">' . number_format($TotalScannedFilesize) . '</TD>';
echo '<TD> </TD>';
echo '<TD ALIGN="RIGHT">' . PlaytimeString($TotalScannedPlaytime) . '</TD>';
echo '<TD> </TD>';
echo '</TR>';
}
echo '</TABLE>';
} else {
echo '<B>ERROR: Could not open directory: <U>' . $currentfulldir . '</U></B><BR>';
}
}