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>'; } }