2015-09-04 03:59:46 +02:00
< ? php
/////////////////////////////////////////////////////////////////
/// getID3() by James Heinrich <info@getid3.org> //
// available at http://getid3.sourceforge.net //
// or http://www.getid3.org //
// also https://github.com/JamesHeinrich/getID3 //
/////////////////////////////////////////////////////////////////
// //
// /demo/demo.mysql.php - part of getID3() //
// Sample script for recursively scanning directories and //
// storing the results in a database //
// See readme.txt for more details //
// ///
/////////////////////////////////////////////////////////////////
die ( 'Due to a security issue, this demo has been disabled. It can be enabled by removing line 16 in demos/demo.mysql.php' );
// OPTIONS:
$getid3_demo_mysql_encoding = 'ISO-8859-1' ;
$getid3_demo_mysql_md5_data = false ; // All data hashes are by far the slowest part of scanning
$getid3_demo_mysql_md5_file = false ;
2017-05-15 20:37:10 +02:00
define ( 'GETID3_DB_HOST' , 'localhost' );
define ( 'GETID3_DB_USER' , 'root' );
define ( 'GETID3_DB_PASS' , 'password' );
define ( 'GETID3_DB_DB' , 'getid3' );
2015-09-04 03:59:46 +02:00
define ( 'GETID3_DB_TABLE' , 'files' );
// CREATE DATABASE `getid3`;
ob_start ();
if ( ! mysql_connect ( GETID3_DB_HOST , GETID3_DB_USER , GETID3_DB_PASS )) {
2017-05-15 20:37:10 +02:00
$errormessage = ob_get_contents ();
ob_end_clean ();
die ( 'Could not connect to MySQL host: <blockquote style="background-color: #FF9933; padding: 10px;">' . mysql_error () . '</blockquote>' );
2015-09-04 03:59:46 +02:00
}
if ( ! mysql_select_db ( GETID3_DB_DB )) {
2017-05-15 20:37:10 +02:00
$errormessage = ob_get_contents ();
ob_end_clean ();
die ( 'Could not select database: <blockquote style="background-color: #FF9933; padding: 10px;">' . mysql_error () . '</blockquote>' );
2015-09-04 03:59:46 +02:00
}
ob_end_clean ();
$getid3PHP_filename = realpath ( '../getid3/getid3.php' );
if ( ! file_exists ( $getid3PHP_filename ) || ! include_once ( $getid3PHP_filename )) {
2017-05-15 20:37:10 +02:00
die ( 'Cannot open ' . $getid3PHP_filename );
2015-09-04 03:59:46 +02:00
}
// Initialize getID3 engine
$getID3 = new getID3 ;
2017-05-15 20:37:10 +02:00
$getID3 -> setOption ( array (
'option_md5_data' => $getid3_demo_mysql_md5_data ,
'encoding' => $getid3_demo_mysql_encoding ,
));
2015-09-04 03:59:46 +02:00
2017-05-15 20:37:10 +02:00
function RemoveAccents ( $string ) {
// Revised version by markstewardØhotmail*com
return strtr ( strtr ( $string , 'ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝàáâãäåçèéêëìíîïñòóôõöøùúûüýÿ' , 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy' ), array ( 'Þ' => 'TH' , 'þ' => 'th' , 'Ð' => 'DH' , 'ð' => 'dh' , 'ß' => 'ss' , ' => 'OE' , ' => 'oe' , 'Æ' => 'AE' , 'æ' => 'ae' , 'µ' => 'u' ));
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function BitrateColor ( $bitrate , $BitrateMaxScale = 768 ) {
// $BitrateMaxScale is bitrate of maximum-quality color (bright green)
// below this is gradient, above is solid green
$bitrate *= ( 256 / $BitrateMaxScale ); // scale from 1-[768]kbps to 1-256
$bitrate = round ( min ( max ( $bitrate , 1 ), 256 ));
$bitrate -- ; // scale from 1-256kbps to 0-255kbps
$Rcomponent = max ( 255 - ( $bitrate * 2 ), 0 );
$Gcomponent = max (( $bitrate * 2 ) - 255 , 0 );
if ( $bitrate > 127 ) {
$Bcomponent = max (( 255 - $bitrate ) * 2 , 0 );
} else {
$Bcomponent = max ( $bitrate * 2 , 0 );
}
return str_pad ( dechex ( $Rcomponent ), 2 , '0' , STR_PAD_LEFT ) . str_pad ( dechex ( $Gcomponent ), 2 , '0' , STR_PAD_LEFT ) . str_pad ( dechex ( $Bcomponent ), 2 , '0' , STR_PAD_LEFT );
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function BitrateText ( $bitrate , $decimals = 0 ) {
return '<span style="color: #' . BitrateColor ( $bitrate ) . '">' . number_format ( $bitrate , $decimals ) . ' kbps</span>' ;
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function fileextension ( $filename , $numextensions = 1 ) {
if ( strstr ( $filename , '.' )) {
$reversedfilename = strrev ( $filename );
$offset = 0 ;
for ( $i = 0 ; $i < $numextensions ; $i ++ ) {
$offset = strpos ( $reversedfilename , '.' , $offset + 1 );
if ( $offset === false ) {
return '' ;
}
}
return strrev ( substr ( $reversedfilename , 0 , $offset ));
}
return '' ;
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function RenameFileFromTo ( $from , $to , & $results ) {
$success = true ;
if ( $from === $to ) {
$results = '<span style="color: #FF0000;"><b>Source and Destination filenames identical</b><br>FAILED to rename' ;
} elseif ( ! file_exists ( $from )) {
$results = '<span style="color: #FF0000;"><b>Source file does not exist</b><br>FAILED to rename' ;
} elseif ( file_exists ( $to ) && ( strtolower ( $from ) !== strtolower ( $to ))) {
$results = '<span style="color: #FF0000;"><b>Destination file already exists</b><br>FAILED to rename' ;
} else {
ob_start ();
if ( rename ( $from , $to )) {
ob_end_clean ();
$SQLquery = 'DELETE FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`filename` = "' . mysql_real_escape_string ( $from ) . '")' ;
mysql_query_safe ( $SQLquery );
$results = '<span style="color: #008000;">Successfully renamed' ;
} else {
$errormessage = ob_get_contents ();
ob_end_clean ();
$results = '<br><span style="color: #FF0000;">FAILED to rename' ;
$success = false ;
}
}
$results .= ' from:<br><i>' . $from . '</i><br>to:<br><i>' . $to . '</i></span><hr>' ;
return $success ;
2015-09-04 03:59:46 +02:00
}
if ( ! empty ( $_REQUEST [ 'renamefilefrom' ]) && ! empty ( $_REQUEST [ 'renamefileto' ])) {
2017-05-15 20:37:10 +02:00
$results = '' ;
RenameFileFromTo ( $_REQUEST [ 'renamefilefrom' ], $_REQUEST [ 'renamefileto' ], $results );
echo $results ;
exit ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'm3ufilename' ])) {
2017-05-15 20:37:10 +02:00
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
echo WindowsShareSlashTranslate ( $_REQUEST [ 'm3ufilename' ]) . " \n " ;
exit ;
2015-09-04 03:59:46 +02:00
} elseif ( ! isset ( $_REQUEST [ 'm3u' ]) && ! isset ( $_REQUEST [ 'm3uartist' ]) && ! isset ( $_REQUEST [ 'm3utitle' ])) {
2017-05-15 20:37:10 +02:00
echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">' ;
echo '<html><head><title>getID3() demo - /demo/mysql.php</title><style>BODY, TD, TH { font-family: sans-serif; font-size: 10pt; } A { text-decoration: none; } A:hover { text-decoration: underline; } A:visited { font-style: italic; }</style></head><body>' ;
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function WindowsShareSlashTranslate ( $filename ) {
if ( substr ( $filename , 0 , 2 ) == '//' ) {
return str_replace ( '/' , '\\' , $filename );
}
return $filename ;
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function mysql_query_safe ( $SQLquery ) {
static $TimeSpentQuerying = 0 ;
if ( $SQLquery === null ) {
return $TimeSpentQuerying ;
}
$starttime = microtime ( true );
$result = mysql_query ( $SQLquery );
$TimeSpentQuerying += ( microtime ( true ) - $starttime );
if ( mysql_error ()) {
die ( '<div style="color: red; padding: 10px; margin: 10px; border: 3px red ridge;"><div style="font-weight: bold;">SQL error:</div><div style="color: blue; padding: 10px;">' . htmlentities ( mysql_error ()) . '</div><hr size="1"><pre>' . htmlentities ( $SQLquery ) . '</pre></div>' );
}
return $result ;
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function mysql_table_exists ( $tablename ) {
return ( bool ) mysql_query ( 'DESCRIBE ' . $tablename );
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function AcceptableExtensions ( $fileformat , $audio_dataformat = '' , $video_dataformat = '' ) {
static $AcceptableExtensionsAudio = array ();
if ( empty ( $AcceptableExtensionsAudio )) {
$AcceptableExtensionsAudio [ 'mp3' ][ 'mp3' ] = array ( 'mp3' );
$AcceptableExtensionsAudio [ 'mp2' ][ 'mp2' ] = array ( 'mp2' );
$AcceptableExtensionsAudio [ 'mp1' ][ 'mp1' ] = array ( 'mp1' );
$AcceptableExtensionsAudio [ 'asf' ][ 'asf' ] = array ( 'asf' );
$AcceptableExtensionsAudio [ 'asf' ][ 'wma' ] = array ( 'wma' );
$AcceptableExtensionsAudio [ 'riff' ][ 'mp3' ] = array ( 'wav' );
$AcceptableExtensionsAudio [ 'riff' ][ 'wav' ] = array ( 'wav' );
}
static $AcceptableExtensionsVideo = array ();
if ( empty ( $AcceptableExtensionsVideo )) {
$AcceptableExtensionsVideo [ 'mp3' ][ 'mp3' ] = array ( 'mp3' );
$AcceptableExtensionsVideo [ 'mp2' ][ 'mp2' ] = array ( 'mp2' );
$AcceptableExtensionsVideo [ 'mp1' ][ 'mp1' ] = array ( 'mp1' );
$AcceptableExtensionsVideo [ 'asf' ][ 'asf' ] = array ( 'asf' );
$AcceptableExtensionsVideo [ 'asf' ][ 'wmv' ] = array ( 'wmv' );
$AcceptableExtensionsVideo [ 'gif' ][ 'gif' ] = array ( 'gif' );
$AcceptableExtensionsVideo [ 'jpg' ][ 'jpg' ] = array ( 'jpg' );
$AcceptableExtensionsVideo [ 'png' ][ 'png' ] = array ( 'png' );
$AcceptableExtensionsVideo [ 'bmp' ][ 'bmp' ] = array ( 'bmp' );
}
if ( ! empty ( $video_dataformat )) {
return ( isset ( $AcceptableExtensionsVideo [ $fileformat ][ $video_dataformat ]) ? $AcceptableExtensionsVideo [ $fileformat ][ $video_dataformat ] : array ());
} else {
return ( isset ( $AcceptableExtensionsAudio [ $fileformat ][ $audio_dataformat ]) ? $AcceptableExtensionsAudio [ $fileformat ][ $audio_dataformat ] : array ());
}
2015-09-04 03:59:46 +02:00
}
if ( ! empty ( $_REQUEST [ 'scan' ])) {
2017-05-15 20:37:10 +02:00
if ( mysql_table_exists ( GETID3_DB_TABLE )) {
$SQLquery = 'DROP TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
mysql_query_safe ( $SQLquery );
}
2015-09-04 03:59:46 +02:00
}
if ( ! mysql_table_exists ( GETID3_DB_TABLE )) {
2017-05-15 20:37:10 +02:00
$SQLquery = " CREATE TABLE ` " . mysql_real_escape_string ( GETID3_DB_TABLE ) . " ` ( " ;
$SQLquery .= " `ID` int(11) unsigned NOT NULL auto_increment, " ;
$SQLquery .= " `filename` text NOT NULL, " ;
$SQLquery .= " `last_modified` int(11) NOT NULL default '0', " ;
$SQLquery .= " `md5_file` varchar(32) NOT NULL default '', " ;
$SQLquery .= " `md5_data` varchar(32) NOT NULL default '', " ;
$SQLquery .= " `md5_data_source` varchar(32) NOT NULL default '', " ;
$SQLquery .= " `filesize` int(10) unsigned NOT NULL default '0', " ;
$SQLquery .= " `fileformat` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `audio_dataformat` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `video_dataformat` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `audio_bitrate` float NOT NULL default '0', " ;
$SQLquery .= " `video_bitrate` float NOT NULL default '0', " ;
$SQLquery .= " `playtime_seconds` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `tags` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `artist` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `title` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `remix` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `album` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `genre` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `comment` text NOT NULL, " ;
$SQLquery .= " `track` varchar(7) NOT NULL default '', " ;
$SQLquery .= " `comments_all` longtext NOT NULL, " ;
$SQLquery .= " `comments_id3v2` longtext NOT NULL, " ;
$SQLquery .= " `comments_ape` longtext NOT NULL, " ;
$SQLquery .= " `comments_lyrics3` longtext NOT NULL, " ;
$SQLquery .= " `comments_id3v1` text NOT NULL, " ;
$SQLquery .= " `warning` longtext NOT NULL, " ;
$SQLquery .= " `error` longtext NOT NULL, " ;
$SQLquery .= " `track_volume` float NOT NULL default '0', " ;
$SQLquery .= " `encoder_options` varchar(255) NOT NULL default '', " ;
$SQLquery .= " `vbr_method` varchar(255) NOT NULL default '', " ;
$SQLquery .= " PRIMARY KEY (`ID`) " ;
$SQLquery .= " ) " ;
mysql_query_safe ( $SQLquery );
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
$ExistingTableFields = array ();
2015-09-04 03:59:46 +02:00
$result = mysql_query_safe ( 'DESCRIBE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' );
while ( $row = mysql_fetch_array ( $result )) {
2017-05-15 20:37:10 +02:00
$ExistingTableFields [ $row [ 'Field' ]] = $row ;
2015-09-04 03:59:46 +02:00
}
if ( ! isset ( $ExistingTableFields [ 'encoder_options' ])) { // Added in 1.7.0b2
2017-05-15 20:37:10 +02:00
echo '<b>adding field `encoder_options`</b><br>' ;
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` ADD `encoder_options` VARCHAR(255) default "" NOT NULL AFTER `error`' );
mysql_query_safe ( 'OPTIMIZE TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' );
2015-09-04 03:59:46 +02:00
}
if ( isset ( $ExistingTableFields [ 'track' ]) && ( $ExistingTableFields [ 'track' ][ 'Type' ] != 'varchar(7)' )) { // Changed in 1.7.0b2
2017-05-15 20:37:10 +02:00
echo '<b>changing field `track` to VARCHAR(7)</b><br>' ;
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` CHANGE `track` `track` VARCHAR(7) default "" NOT NULL' );
mysql_query_safe ( 'OPTIMIZE TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' );
2015-09-04 03:59:46 +02:00
}
if ( ! isset ( $ExistingTableFields [ 'track_volume' ])) { // Added in 1.7.0b5
2017-05-15 20:37:10 +02:00
echo '<H1><FONT COLOR="red">WARNING! You should erase your database and rescan everything because the comment storing has been changed since the last version</FONT></H1><hr>' ;
echo '<b>adding field `track_volume`</b><br>' ;
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` ADD `track_volume` FLOAT NOT NULL AFTER `error`' );
mysql_query_safe ( 'OPTIMIZE TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' );
2015-09-04 03:59:46 +02:00
}
if ( ! isset ( $ExistingTableFields [ 'remix' ])) { // Added in 1.7.3b1
2017-05-15 20:37:10 +02:00
echo '<b>adding field `encoder_options`, `alternate_name`, `parody`</b><br>' ;
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` ADD `remix` VARCHAR(255) default "" NOT NULL AFTER `title`' );
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` ADD `alternate_name` VARCHAR(255) default "" NOT NULL AFTER `track`' );
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` ADD `parody` VARCHAR(255) default "" NOT NULL AFTER `alternate_name`' );
mysql_query_safe ( 'OPTIMIZE TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' );
2015-09-04 03:59:46 +02:00
}
if ( isset ( $ExistingTableFields [ 'comments_all' ]) && ( $ExistingTableFields [ 'comments_all' ][ 'Type' ] != 'longtext' )) { // Changed in 1.9.0
2017-05-15 20:37:10 +02:00
echo '<b>changing comments fields from text to longtext</b><br>' ;
// no need to change id3v1
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` CHANGE `comments_all` `comments_all` LONGTEXT NOT NULL' );
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` CHANGE `comments_id3v2` `comments_id3v2` LONGTEXT NOT NULL' );
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` CHANGE `comments_ape` `comments_ape` LONGTEXT NOT NULL' );
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` CHANGE `comments_lyrics3` `comments_lyrics3` LONGTEXT NOT NULL' );
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` CHANGE `warning` `warning` LONGTEXT NOT NULL' );
mysql_query_safe ( 'ALTER TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` CHANGE `error` `error` LONGTEXT NOT NULL' );
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function SynchronizeAllTags ( $filename , $synchronizefrom = 'all' , $synchronizeto = 'A12' , & $errors ) {
global $getID3 ;
set_time_limit ( 30 );
$ThisFileInfo = $getID3 -> analyze ( $filename );
getid3_lib :: CopyTagsToComments ( $ThisFileInfo );
if ( $synchronizefrom == 'all' ) {
$SourceArray = ( ! empty ( $ThisFileInfo [ 'comments' ]) ? $ThisFileInfo [ 'comments' ] : array ());
} elseif ( ! empty ( $ThisFileInfo [ 'tags' ][ $synchronizefrom ])) {
$SourceArray = ( ! empty ( $ThisFileInfo [ 'tags' ][ $synchronizefrom ]) ? $ThisFileInfo [ 'tags' ][ $synchronizefrom ] : array ());
} else {
die ( 'ERROR: $ThisFileInfo[tags][' . $synchronizefrom . '] does not exist' );
}
$SQLquery = 'DELETE FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`filename` = "' . mysql_real_escape_string ( $filename ) . '")' ;
mysql_query_safe ( $SQLquery );
$TagFormatsToWrite = array ();
if (( strpos ( $synchronizeto , '2' ) !== false ) && ( $synchronizefrom != 'id3v2' )) {
$TagFormatsToWrite [] = 'id3v2.3' ;
}
if (( strpos ( $synchronizeto , 'A' ) !== false ) && ( $synchronizefrom != 'ape' )) {
$TagFormatsToWrite [] = 'ape' ;
}
if (( strpos ( $synchronizeto , 'L' ) !== false ) && ( $synchronizefrom != 'lyrics3' )) {
$TagFormatsToWrite [] = 'lyrics3' ;
}
if (( strpos ( $synchronizeto , '1' ) !== false ) && ( $synchronizefrom != 'id3v1' )) {
$TagFormatsToWrite [] = 'id3v1' ;
}
getid3_lib :: IncludeDependency ( GETID3_INCLUDEPATH . 'write.php' , __FILE__ , true );
$tagwriter = new getid3_writetags ;
$tagwriter -> filename = $filename ;
$tagwriter -> tagformats = $TagFormatsToWrite ;
$tagwriter -> overwrite_tags = true ;
$tagwriter -> tag_encoding = $getID3 -> encoding ;
$tagwriter -> tag_data = $SourceArray ;
if ( $tagwriter -> WriteTags ()) {
$errors = $tagwriter -> errors ;
return true ;
}
$errors = $tagwriter -> errors ;
return false ;
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
$IgnoreNoTagFormats = array ( '' , 'png' , 'jpg' , 'gif' , 'bmp' , 'swf' , 'pdf' , 'zip' , 'rar' , 'mid' , 'mod' , 'xm' , 'it' , 's3m' );
2015-09-04 03:59:46 +02:00
if ( ! empty ( $_REQUEST [ 'scan' ]) || ! empty ( $_REQUEST [ 'newscan' ]) || ! empty ( $_REQUEST [ 'rescanerrors' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'DELETE from `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` = "")' ;
mysql_query_safe ( $SQLquery );
$FilesInDir = array ();
if ( ! empty ( $_REQUEST [ 'rescanerrors' ])) {
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ]) . '">abort</a><hr>' ;
echo 'Re-scanning all media files already in database that had errors and/or warnings in last scan<hr>' ;
$SQLquery = 'SELECT `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`error` <> "")' ;
$SQLquery .= ' OR (`warning` <> "")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
while ( $row = mysql_fetch_array ( $result )) {
if ( ! file_exists ( $row [ 'filename' ])) {
echo '<b>File missing: ' . $row [ 'filename' ] . '</b><br>' ;
$SQLquery = 'DELETE FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`filename` = "' . mysql_real_escape_string ( $row [ 'filename' ]) . '")' ;
mysql_query_safe ( $SQLquery );
} else {
$FilesInDir [] = $row [ 'filename' ];
}
}
} elseif ( ! empty ( $_REQUEST [ 'scan' ]) || ! empty ( $_REQUEST [ 'newscan' ])) {
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ]) . '">abort</a><hr>' ;
echo 'Scanning all media files in <b>' . str_replace ( '\\' , '/' , realpath ( ! empty ( $_REQUEST [ 'scan' ]) ? $_REQUEST [ 'scan' ] : $_REQUEST [ 'newscan' ])) . '</b> (and subdirectories)<hr>' ;
$SQLquery = 'SELECT COUNT(*) AS `num`, `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' GROUP BY `filename`' ;
$SQLquery .= ' HAVING (`num` > 1)' ;
$SQLquery .= ' ORDER BY `num` DESC' ;
$result = mysql_query_safe ( $SQLquery );
$DupesDeleted = 0 ;
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
$SQLquery = 'DELETE FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE `filename` LIKE "' . mysql_real_escape_string ( $row [ 'filename' ]) . '"' ;
mysql_query_safe ( $SQLquery );
$DupesDeleted ++ ;
}
if ( $DupesDeleted > 0 ) {
echo 'Deleted <b>' . number_format ( $DupesDeleted ) . '</b> duplicate filenames<hr>' ;
}
if ( ! empty ( $_REQUEST [ 'newscan' ])) {
$AlreadyInDatabase = array ();
set_time_limit ( 60 );
$SQLquery = 'SELECT `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
while ( $row = mysql_fetch_array ( $result )) {
//$AlreadyInDatabase[] = strtolower($row['filename']);
$AlreadyInDatabase [] = $row [ 'filename' ];
}
}
$DirectoriesToScan = array ( ! empty ( $_REQUEST [ 'scan' ]) ? $_REQUEST [ 'scan' ] : $_REQUEST [ 'newscan' ]);
$DirectoriesScanned = array ();
while ( count ( $DirectoriesToScan ) > 0 ) {
foreach ( $DirectoriesToScan as $DirectoryKey => $startingdir ) {
if ( $dir = opendir ( $startingdir )) {
set_time_limit ( 30 );
echo '<b>' . str_replace ( '\\' , '/' , $startingdir ) . '</b><br>' ;
flush ();
while (( $file = readdir ( $dir )) !== false ) {
if (( $file != '.' ) && ( $file != '..' )) {
$RealPathName = realpath ( $startingdir . '/' . $file );
if ( is_dir ( $RealPathName )) {
if ( ! in_array ( $RealPathName , $DirectoriesScanned ) && ! in_array ( $RealPathName , $DirectoriesToScan )) {
$DirectoriesToScan [] = $RealPathName ;
}
} elseif ( is_file ( $RealPathName )) {
if ( ! empty ( $_REQUEST [ 'newscan' ])) {
if ( ! in_array ( str_replace ( '\\' , '/' , $RealPathName ), $AlreadyInDatabase )) {
$FilesInDir [] = $RealPathName ;
}
} elseif ( ! empty ( $_REQUEST [ 'scan' ])) {
$FilesInDir [] = $RealPathName ;
}
}
}
}
closedir ( $dir );
} else {
echo '<div style="color: red;">Failed to open directory "<b>' . htmlentities ( $startingdir ) . '</b>"</div><br>' ;
}
$DirectoriesScanned [] = $startingdir ;
unset ( $DirectoriesToScan [ $DirectoryKey ]);
}
}
echo '<i>List of files to scan complete (added ' . number_format ( count ( $FilesInDir )) . ' files to scan)</i><hr>' ;
flush ();
}
$FilesInDir = array_unique ( $FilesInDir );
sort ( $FilesInDir );
$starttime = time ();
$rowcounter = 0 ;
$totaltoprocess = count ( $FilesInDir );
foreach ( $FilesInDir as $filename ) {
set_time_limit ( 300 );
echo '<br>' . date ( 'H:i:s' ) . ' [' . number_format ( ++ $rowcounter ) . ' / ' . number_format ( $totaltoprocess ) . '] ' . str_replace ( '\\' , '/' , $filename );
$ThisFileInfo = $getID3 -> analyze ( $filename );
getid3_lib :: CopyTagsToComments ( $ThisFileInfo );
if ( file_exists ( $filename )) {
$ThisFileInfo [ 'file_modified_time' ] = filemtime ( $filename );
$ThisFileInfo [ 'md5_file' ] = ( $getid3_demo_mysql_md5_file ? md5_file ( $filename ) : '' );
}
if ( empty ( $ThisFileInfo [ 'fileformat' ])) {
echo ' (<span style="color: #990099;">unknown file type</span>)' ;
} else {
if ( ! empty ( $ThisFileInfo [ 'error' ])) {
echo ' (<span style="color: #FF0000;">errors</span>)' ;
} elseif ( ! empty ( $ThisFileInfo [ 'warning' ])) {
echo ' (<span style="color: #FF9999;">warnings</span>)' ;
} else {
echo ' (<span style="color: #009900;">OK</span>)' ;
}
$this_track_track = '' ;
if ( ! empty ( $ThisFileInfo [ 'comments' ][ 'track' ])) {
foreach ( $ThisFileInfo [ 'comments' ][ 'track' ] as $key => $value ) {
if ( strlen ( $value ) > strlen ( $this_track_track )) {
$this_track_track = str_pad ( $value , 2 , '0' , STR_PAD_LEFT );
}
}
if ( preg_match ( '#^([0-9]+)/([0-9]+)$#' , $this_track_track , $matches )) {
// change "1/5"->"01/05", "3/12"->"03/12", etc
$this_track_track = str_pad ( $matches [ 1 ], 2 , '0' , STR_PAD_LEFT ) . '/' . str_pad ( $matches [ 2 ], 2 , '0' , STR_PAD_LEFT );
}
}
$this_track_remix = '' ;
$this_track_title = '' ;
if ( ! empty ( $ThisFileInfo [ 'comments' ][ 'title' ])) {
foreach ( $ThisFileInfo [ 'comments' ][ 'title' ] as $possible_title ) {
if ( strlen ( $possible_title ) > strlen ( $this_track_title )) {
$this_track_title = $possible_title ;
}
}
}
$ParenthesesPairs = array ( '()' , '[]' , '{}' );
foreach ( $ParenthesesPairs as $pair ) {
if ( preg_match_all ( '/(.*) ' . preg_quote ( $pair { 0 }) . '(([^' . preg_quote ( $pair ) . ']*[\- ' . preg_quote ( $pair { 0 }) . '])?(cut|dub|edit|version|live|reprise|[a-z]*mix))' . preg_quote ( $pair { 1 }) . '/iU' , $this_track_title , $matches )) {
$this_track_title = $matches [ 1 ][ 0 ];
$this_track_remix = implode ( " \t " , $matches [ 2 ]);
}
}
if ( ! empty ( $_REQUEST [ 'rescanerrors' ])) {
$SQLquery = 'UPDATE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` SET ' ;
$SQLquery .= ' `last_modified` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'file_modified_time' ] ) ? $ThisFileInfo [ 'file_modified_time' ] : '' ) . '"' ;
$SQLquery .= ', `md5_file` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'md5_file' ] ) ? $ThisFileInfo [ 'md5_file' ] : '' ) . '"' ;
$SQLquery .= ', `md5_data` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'md5_data' ] ) ? $ThisFileInfo [ 'md5_data' ] : '' ) . '"' ;
$SQLquery .= ', `md5_data_source` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'md5_data_source' ] ) ? $ThisFileInfo [ 'md5_data_source' ] : '' ) . '"' ;
$SQLquery .= ', `filesize` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'filesize' ] ) ? $ThisFileInfo [ 'filesize' ] : 0 ) . '"' ;
$SQLquery .= ', `fileformat` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'fileformat' ] ) ? $ThisFileInfo [ 'fileformat' ] : '' ) . '"' ;
$SQLquery .= ', `audio_dataformat` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'audio' ][ 'dataformat' ] ) ? $ThisFileInfo [ 'audio' ][ 'dataformat' ] : '' ) . '"' ;
$SQLquery .= ', `video_dataformat` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'video' ][ 'dataformat' ] ) ? $ThisFileInfo [ 'video' ][ 'dataformat' ] : '' ) . '"' ;
$SQLquery .= ', `vbr_method` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'mpeg' ][ 'audio' ][ 'VBR_method' ] ) ? $ThisFileInfo [ 'mpeg' ][ 'audio' ][ 'VBR_method' ] : '' ) . '"' ;
$SQLquery .= ', `audio_bitrate` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'audio' ][ 'bitrate' ] ) ? floatval ( $ThisFileInfo [ 'audio' ][ 'bitrate' ]) : 0 ) . '"' ;
$SQLquery .= ', `video_bitrate` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'video' ][ 'bitrate' ] ) ? floatval ( $ThisFileInfo [ 'video' ][ 'bitrate' ]) : 0 ) . '"' ;
$SQLquery .= ', `playtime_seconds` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'playtime_seconds' ] ) ? floatval ( $ThisFileInfo [ 'playtime_seconds' ]) : 0 ) . '"' ;
$SQLquery .= ', `track_volume` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'replay_gain' ][ 'track' ][ 'volume' ]) ? floatval ( $ThisFileInfo [ 'replay_gain' ][ 'track' ][ 'volume' ]) : 0 ) . '"' ;
$SQLquery .= ', `comments_all` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ] ) ? serialize ( $ThisFileInfo [ 'comments' ]) : '' ) . '"' ;
$SQLquery .= ', `comments_id3v2` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ][ 'id3v2' ] ) ? serialize ( $ThisFileInfo [ 'tags' ][ 'id3v2' ]) : '' ) . '"' ;
$SQLquery .= ', `comments_ape` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ][ 'ape' ] ) ? serialize ( $ThisFileInfo [ 'tags' ][ 'ape' ]) : '' ) . '"' ;
$SQLquery .= ', `comments_lyrics3` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ][ 'lyrics3' ] ) ? serialize ( $ThisFileInfo [ 'tags' ][ 'lyrics3' ]) : '' ) . '"' ;
$SQLquery .= ', `comments_id3v1` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ][ 'id3v1' ] ) ? serialize ( $ThisFileInfo [ 'tags' ][ 'id3v1' ]) : '' ) . '"' ;
$SQLquery .= ', `warning` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'warning' ] ) ? implode ( " \t " , $ThisFileInfo [ 'warning' ]) : '' ) . '"' ;
$SQLquery .= ', `error` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'error' ] ) ? implode ( " \t " , $ThisFileInfo [ 'error' ]) : '' ) . '"' ;
$SQLquery .= ', `album` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ][ 'album' ] ) ? implode ( " \t " , $ThisFileInfo [ 'comments' ][ 'album' ]) : '' ) . '"' ;
$SQLquery .= ', `genre` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ][ 'genre' ] ) ? implode ( " \t " , $ThisFileInfo [ 'comments' ][ 'genre' ]) : '' ) . '"' ;
$SQLquery .= ', `comment` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ][ 'comment' ] ) ? implode ( " \t " , $ThisFileInfo [ 'comments' ][ 'comment' ]) : '' ) . '"' ;
$SQLquery .= ', `artist` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ][ 'artist' ] ) ? implode ( " \t " , $ThisFileInfo [ 'comments' ][ 'artist' ]) : '' ) . '"' ;
$SQLquery .= ', `tags` = "' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ] ) ? implode ( " \t " , array_keys ( $ThisFileInfo [ 'tags' ])) : '' ) . '"' ;
$SQLquery .= ', `encoder_options` = "' . mysql_real_escape_string ( trim (( ! empty ( $ThisFileInfo [ 'audio' ][ 'encoder' ]) ? $ThisFileInfo [ 'audio' ][ 'encoder' ] : '' ) . ' ' . ( ! empty ( $ThisFileInfo [ 'audio' ][ 'encoder_options' ]) ? $ThisFileInfo [ 'audio' ][ 'encoder_options' ] : '' ))) . '"' ;
$SQLquery .= ', `title` = "' . mysql_real_escape_string ( $this_track_title ) . '"' ;
$SQLquery .= ', `remix` = "' . mysql_real_escape_string ( $this_track_remix ) . '"' ;
$SQLquery .= ', `track` = "' . mysql_real_escape_string ( $this_track_track ) . '"' ;
$SQLquery .= 'WHERE (`filename` = "' . mysql_real_escape_string ( isset ( $ThisFileInfo [ 'filenamepath' ]) ? $ThisFileInfo [ 'filenamepath' ] : '' ) . '")' ;
} elseif ( ! empty ( $_REQUEST [ 'scan' ]) || ! empty ( $_REQUEST [ 'newscan' ])) {
//$SQLquery = 'INSERT INTO `'.mysql_real_escape_string(GETID3_DB_TABLE).'` (`filename`, `last_modified`, `md5_file`, `md5_data`, `md5_data_source`, `filesize`, `fileformat`, `audio_dataformat`, `video_dataformat`, `audio_bitrate`, `video_bitrate`, `playtime_seconds`, `artist`, `title`, `remix`, `album`, `genre`, `comment`, `track`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyrics3`, `comments_id3v1`, `warning`, `error`, `encoder_options`, `vbr_method`, `track_volume`) VALUES (';
$SQLquery = 'INSERT INTO `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '` (`filename`, `last_modified`, `md5_file`, `md5_data`, `md5_data_source`, `filesize`, `fileformat`, `audio_dataformat`, `video_dataformat`, `audio_bitrate`, `video_bitrate`, `playtime_seconds`, `tags`, `artist`, `title`, `remix`, `album`, `genre`, `comment`, `track`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyrics3`, `comments_id3v1`, `warning`, `error`, `encoder_options`, `vbr_method`, `track_volume`) VALUES (' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'filenamepath' ] ) ? $ThisFileInfo [ 'filenamepath' ] : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'file_modified_time' ] ) ? $ThisFileInfo [ 'file_modified_time' ] : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'md5_file' ] ) ? $ThisFileInfo [ 'md5_file' ] : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'md5_data' ] ) ? $ThisFileInfo [ 'md5_data' ] : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'md5_data_source' ] ) ? $ThisFileInfo [ 'md5_data_source' ] : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'filesize' ] ) ? $ThisFileInfo [ 'filesize' ] : 0 ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'fileformat' ] ) ? $ThisFileInfo [ 'fileformat' ] : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'audio' ][ 'dataformat' ] ) ? $ThisFileInfo [ 'audio' ][ 'dataformat' ] : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'video' ][ 'dataformat' ] ) ? $ThisFileInfo [ 'video' ][ 'dataformat' ] : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'audio' ][ 'bitrate' ] ) ? floatval ( $ThisFileInfo [ 'audio' ][ 'bitrate' ]) : 0 ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'video' ][ 'bitrate' ] ) ? floatval ( $ThisFileInfo [ 'video' ][ 'bitrate' ]) : 0 ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'playtime_seconds' ] ) ? floatval ( $ThisFileInfo [ 'playtime_seconds' ]) : 0 ) . '", ' ;
//$SQLquery .= '"'.mysql_real_escape_string(!empty($ThisFileInfo['tags'] ) ? implode("\t", $ThisFileInfo['tags']) : '').'", ';
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ] ) ? implode ( " \t " , array_keys ( $ThisFileInfo [ 'tags' ])) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ][ 'artist' ] ) ? implode ( " \t " , $ThisFileInfo [ 'comments' ][ 'artist' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( $this_track_title ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( $this_track_remix ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ][ 'album' ] ) ? implode ( " \t " , $ThisFileInfo [ 'comments' ][ 'album' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ][ 'genre' ] ) ? implode ( " \t " , $ThisFileInfo [ 'comments' ][ 'genre' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ][ 'comment' ] ) ? implode ( " \t " , $ThisFileInfo [ 'comments' ][ 'comment' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( $this_track_track ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'comments' ] ) ? serialize ( $ThisFileInfo [ 'comments' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ][ 'id3v2' ] ) ? serialize ( $ThisFileInfo [ 'tags' ][ 'id3v2' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ][ 'ape' ] ) ? serialize ( $ThisFileInfo [ 'tags' ][ 'ape' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ][ 'lyrics3' ] ) ? serialize ( $ThisFileInfo [ 'tags' ][ 'lyrics3' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'tags' ][ 'id3v1' ] ) ? serialize ( $ThisFileInfo [ 'tags' ][ 'id3v1' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'warning' ] ) ? implode ( " \t " , $ThisFileInfo [ 'warning' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'error' ] ) ? implode ( " \t " , $ThisFileInfo [ 'error' ]) : '' ) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( trim (( ! empty ( $ThisFileInfo [ 'audio' ][ 'encoder' ]) ? $ThisFileInfo [ 'audio' ][ 'encoder' ] : '' ) . ' ' . ( ! empty ( $ThisFileInfo [ 'audio' ][ 'encoder_options' ]) ? $ThisFileInfo [ 'audio' ][ 'encoder_options' ] : '' ))) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'mpeg' ][ 'audio' ][ 'LAME' ]) ? 'LAME' : ( ! empty ( $ThisFileInfo [ 'mpeg' ][ 'audio' ][ 'VBR_method' ]) ? $ThisFileInfo [ 'mpeg' ][ 'audio' ][ 'VBR_method' ] : '' )) . '", ' ;
$SQLquery .= '"' . mysql_real_escape_string ( ! empty ( $ThisFileInfo [ 'replay_gain' ][ 'track' ][ 'volume' ]) ? floatval ( $ThisFileInfo [ 'replay_gain' ][ 'track' ][ 'volume' ]) : 0 ) . '")' ;
}
flush ();
mysql_query_safe ( $SQLquery );
}
}
$SQLquery = 'OPTIMIZE TABLE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
mysql_query_safe ( $SQLquery );
echo '<hr>Done scanning!<hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'missingtrackvolume' ])) {
2017-05-15 20:37:10 +02:00
$MissingTrackVolumeFilesScanned = 0 ;
$MissingTrackVolumeFilesAdjusted = 0 ;
$MissingTrackVolumeFilesDeleted = 0 ;
$SQLquery = 'SELECT `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`track_volume` = 0)' ;
$SQLquery .= ' AND (`audio_bitrate` > 0)' ;
$result = mysql_query_safe ( $SQLquery );
echo 'Scanning <span ID="missingtrackvolumeNowScanning">0</span> / ' . number_format ( mysql_num_rows ( $result )) . ' files for track volume information:<hr>' ;
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
echo '<script type="text/javascript">if (document.getElementById("missingtrackvolumeNowScanning")) document.getElementById("missingtrackvolumeNowScanning").innerHTML = "' . number_format ( $MissingTrackVolumeFilesScanned ++ ) . '";</script>. ' ;
flush ();
if ( file_exists ( $row [ 'filename' ])) {
$ThisFileInfo = $getID3 -> analyze ( $row [ 'filename' ]);
if ( ! empty ( $ThisFileInfo [ 'replay_gain' ][ 'track' ][ 'volume' ])) {
$MissingTrackVolumeFilesAdjusted ++ ;
$SQLquery = 'UPDATE `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' SET `track_volume` = "' . $ThisFileInfo [ 'replay_gain' ][ 'track' ][ 'volume' ] . '"' ;
$SQLquery .= ' WHERE (`filename` = "' . mysql_real_escape_string ( $row [ 'filename' ]) . '")' ;
mysql_query_safe ( $SQLquery );
}
} else {
$MissingTrackVolumeFilesDeleted ++ ;
$SQLquery = 'DELETE FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`filename` = "' . mysql_real_escape_string ( $row [ 'filename' ]) . '")' ;
mysql_query_safe ( $SQLquery );
}
}
echo '<hr>Scanned ' . number_format ( $MissingTrackVolumeFilesScanned ) . ' files with no track volume information.<br>' ;
echo 'Found track volume information for ' . number_format ( $MissingTrackVolumeFilesAdjusted ) . ' of them (could not find info for ' . number_format ( $MissingTrackVolumeFilesScanned - $MissingTrackVolumeFilesAdjusted ) . ' files; deleted ' . number_format ( $MissingTrackVolumeFilesDeleted ) . ' records of missing files)<hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'deadfilescheck' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT COUNT(*) AS `num`, `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' GROUP BY `filename`' ;
$SQLquery .= ' ORDER BY `num` DESC' ;
$result = mysql_query_safe ( $SQLquery );
$DupesDeleted = 0 ;
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
if ( $row [ 'num' ] <= 1 ) {
break ;
}
echo '<br>' . htmlentities ( $row [ 'filename' ]) . ' (<font color="#FF9999">duplicate</font>)' ;
$SQLquery = 'DELETE FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE `filename` LIKE "' . mysql_real_escape_string ( $row [ 'filename' ]) . '"' ;
mysql_query_safe ( $SQLquery );
$DupesDeleted ++ ;
}
if ( $DupesDeleted > 0 ) {
echo '<hr>Deleted <b>' . number_format ( $DupesDeleted ) . '</b> duplicate filenames<hr>' ;
}
$SQLquery = 'SELECT `filename`, `filesize`, `last_modified`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
$totalchecked = 0 ;
$totalremoved = 0 ;
$previousdir = '' ;
while ( $row = mysql_fetch_array ( $result )) {
$totalchecked ++ ;
set_time_limit ( 30 );
$reason = '' ;
if ( ! file_exists ( $row [ 'filename' ])) {
$reason = 'deleted' ;
} elseif ( filesize ( $row [ 'filename' ]) != $row [ 'filesize' ]) {
$reason = 'filesize changed' ;
} elseif ( filemtime ( $row [ 'filename' ]) != $row [ 'last_modified' ]) {
if ( abs ( filemtime ( $row [ 'filename' ]) - $row [ 'last_modified' ]) != 3600 ) {
// off by exactly one hour == daylight savings time
$reason = 'last-modified time changed' ;
}
}
$thisdir = dirname ( $row [ 'filename' ]);
if ( $reason ) {
$totalremoved ++ ;
echo '<br>' . htmlentities ( $row [ 'filename' ]) . ' (<font color="#FF9999">' . $reason . '</font>)' ;
flush ();
$SQLquery = 'DELETE FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`filename` = "' . mysql_real_escape_string ( $row [ 'filename' ]) . '")' ;
mysql_query_safe ( $SQLquery );
} elseif ( $thisdir != $previousdir ) {
echo '. ' ;
flush ();
}
$previousdir = $thisdir ;
}
echo '<hr><b>' . number_format ( $totalremoved ) . ' of ' . number_format ( $totalchecked ) . ' files in database no longer exist, or have been altered since last scan. Removed from database.</b><hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'encodedbydistribution' ])) {
2017-05-15 20:37:10 +02:00
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
$SQLquery = 'SELECT `filename`, `comments_id3v2`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`encoder_options` = "' . mysql_real_escape_string ( $_REQUEST [ 'encodedbydistribution' ]) . '")' ;
$result = mysql_query_safe ( $SQLquery );
$NonBlankEncodedBy = '' ;
$BlankEncodedBy = '' ;
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
$CommentArray = unserialize ( $row [ 'comments_id3v2' ]);
if ( isset ( $CommentArray [ 'encoded_by' ][ 0 ])) {
$NonBlankEncodedBy .= WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
} else {
$BlankEncodedBy .= WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
}
echo $NonBlankEncodedBy ;
echo $BlankEncodedBy ;
exit ;
} elseif ( ! empty ( $_REQUEST [ 'showfiles' ])) {
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encodedbydistribution=' . urlencode ( '%' )) . '">show all</a><br>' ;
echo '<table border="1">' ;
$SQLquery = 'SELECT `filename`, `comments_id3v2`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$result = mysql_query_safe ( $SQLquery );
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
$CommentArray = unserialize ( $row [ 'comments_id3v2' ]);
if (( $_REQUEST [ 'encodedbydistribution' ] == '%' ) || ( ! empty ( $CommentArray [ 'encoded_by' ][ 0 ]) && ( $_REQUEST [ 'encodedbydistribution' ] == $CommentArray [ 'encoded_by' ][ 0 ]))) {
echo '<tr><td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ])) . '">m3u</a></td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td></tr>' ;
}
}
echo '</table>' ;
} else {
$SQLquery = 'SELECT `encoder_options`, `comments_id3v2`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' ORDER BY (`encoder_options` LIKE "LAME%") DESC, (`encoder_options` LIKE "CBR%") DESC' ;
$result = mysql_query_safe ( $SQLquery );
$EncodedBy = array ();
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
$CommentArray = unserialize ( $row [ 'comments_id3v2' ]);
if ( isset ( $CommentArray [ 'encoded_by' ][ 0 ])) {
if ( isset ( $EncodedBy [ $row [ 'encoder_options' ]][ $CommentArray [ 'encoded_by' ][ 0 ]])) {
$EncodedBy [ $row [ 'encoder_options' ]][ $CommentArray [ 'encoded_by' ][ 0 ]] ++ ;
} else {
$EncodedBy [ $row [ 'encoder_options' ]][ $CommentArray [ 'encoded_by' ][ 0 ]] = 1 ;
}
}
}
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encodedbydistribution=' . urlencode ( '%' ) . '&m3u=1' ) . '">.m3u version</a><br>' ;
echo '<table border="1"><tr><th>m3u</th><th>Encoder Options</th><th>Encoded By (ID3v2)</th></tr>' ;
foreach ( $EncodedBy as $key => $value ) {
echo '<tr><TD VALIGN="TOP"><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encodedbydistribution=' . urlencode ( $key ) . '&showfiles=1&m3u=1' ) . '">m3u</a></td>' ;
echo '<TD VALIGN="TOP"><b>' . $key . '</b></td>' ;
echo '<td><table border="0" WIDTH="100%">' ;
arsort ( $value );
foreach ( $value as $string => $count ) {
echo '<tr><TD ALIGN="RIGHT" WIDTH="50"><i>' . number_format ( $count ) . '</i></td><td> </td>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encodedbydistribution=' . urlencode ( $string ) . '&showfiles=1' ) . '">' . $string . '</a></td></tr>' ;
}
echo '</table></td></tr>' ;
}
echo '</table>' ;
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'audiobitrates' ])) {
2017-05-15 20:37:10 +02:00
getid3_lib :: IncludeDependency ( GETID3_INCLUDEPATH . 'module.audio.mp3.php' , __FILE__ , true );
$BitrateDistribution = array ();
$SQLquery = 'SELECT ROUND(audio_bitrate / 1000) AS `RoundBitrate`, COUNT(*) AS `num`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`audio_bitrate` > 0)' ;
$SQLquery .= ' GROUP BY `RoundBitrate`' ;
$result = mysql_query_safe ( $SQLquery );
while ( $row = mysql_fetch_array ( $result )) {
$this_bitrate = getid3_mp3 :: ClosestStandardMP3Bitrate ( $row [ 'RoundBitrate' ] * 1000 );
if ( isset ( $BitrateDistribution [ $this_bitrate ])) {
$BitrateDistribution [ $this_bitrate ] += $row [ 'num' ];
} else {
$BitrateDistribution [ $this_bitrate ] = $row [ 'num' ];
}
}
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>Bitrate</th><th>Count</th></tr>' ;
foreach ( $BitrateDistribution as $Bitrate => $Count ) {
echo '<tr>' ;
echo '<td align="right">' . round ( $Bitrate / 1000 ) . ' kbps</td>' ;
echo '<td align="right">' . number_format ( $Count ) . '</td>' ;
echo '</tr>' ;
}
echo '</table>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'emptygenres' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `fileformat`, `filename`, `genre`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`genre` = "")' ;
$SQLquery .= ' OR (`genre` = "Unknown")' ;
$SQLquery .= ' OR (`genre` = "Other")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
if ( ! in_array ( $row [ 'fileformat' ], $IgnoreNoTagFormats )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
}
exit ;
} else {
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?emptygenres=' . urlencode ( $_REQUEST [ 'emptygenres' ]) . '&m3u=1' ) . '">.m3u version</a><br>' ;
$EmptyGenreCounter = 0 ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>m3u</th><th>filename</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
if ( ! in_array ( $row [ 'fileformat' ], $IgnoreNoTagFormats )) {
$EmptyGenreCounter ++ ;
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">m3u</a></td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '</tr>' ;
}
}
echo '</table>' ;
echo '<b>' . number_format ( $EmptyGenreCounter ) . '</b> files with empty genres' ;
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'nonemptycomments' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `filename`, `comment`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`comment` <> "")' ;
$SQLquery .= ' ORDER BY `comment` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
} else {
$NonEmptyCommentsCounter = 0 ;
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?nonemptycomments=' . urlencode ( $_REQUEST [ 'nonemptycomments' ]) . '&m3u=1' ) . '">.m3u version</a><br>' ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>m3u</th><th>filename</th><th>comments</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
$NonEmptyCommentsCounter ++ ;
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">m3u</a></td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
if ( strlen ( trim ( $row [ 'comment' ])) > 0 ) {
echo '<td>' . htmlentities ( $row [ 'comment' ]) . '</td>' ;
} else {
echo '<td><i>space</i></td>' ;
}
echo '</tr>' ;
}
echo '</table>' ;
echo '<b>' . number_format ( $NonEmptyCommentsCounter ) . '</b> files with non-empty comments' ;
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'trackzero' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `filename`, `track`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`track` <> "")' ;
$SQLquery .= ' AND ((`track` < "1")' ;
$SQLquery .= ' OR (`track` > "99"))' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
if (( strlen ( $row [ 'track' ]) > 0 ) && ( $row [ 'track' ] < 1 ) || ( $row [ 'track' ] > 99 )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
}
exit ;
} else {
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?trackzero=' . urlencode ( $_REQUEST [ 'trackzero' ]) . '&m3u=1' ) . '">.m3u version</a><br>' ;
$TrackZeroCounter = 0 ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>m3u</th><th>filename</th><th>track</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
if (( strlen ( $row [ 'track' ]) > 0 ) && ( $row [ 'track' ] < 1 ) || ( $row [ 'track' ] > 99 )) {
$TrackZeroCounter ++ ;
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">m3u</a></td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '<td>' . htmlentities ( $row [ 'track' ]) . '</td>' ;
echo '</tr>' ;
}
}
echo '</table>' ;
echo '<b>' . number_format ( $TrackZeroCounter ) . '</b> files with track "zero"' ;
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'titlefeat' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `filename`, `title`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`title` LIKE "%feat.%")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
} else {
echo '<b>' . number_format ( mysql_num_rows ( $result )) . '</b> files with "feat." in the title (instead of the artist)<br><br>' ;
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?titlefeat=' . urlencode ( $_REQUEST [ 'titlefeat' ]) . '&m3u=1' ) . '">.m3u version</a><br>' ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>m3u</th><th>filename</th><th>title</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">m3u</a></td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '<td>' . preg_replace ( '#(feat\. .*)#i' , '<b>\\1</b>' , htmlentities ( $row [ 'title' ])) . '</td>' ;
echo '</tr>' ;
}
echo '</table>' ;
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'tracknoalbum' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `filename`, `track`, `album`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`track` <> "")' ;
$SQLquery .= ' AND (`album` = "")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
} else {
echo '<b>' . number_format ( mysql_num_rows ( $result )) . '</b> files with a track number, but no album<br><br>' ;
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?tracknoalbum=' . urlencode ( $_REQUEST [ 'tracknoalbum' ]) . '&m3u=1' ) . '">.m3u version</a><br>' ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>m3u</th><th>filename</th><th>track</th><th>album</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">m3u</a></td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '<td>' . htmlentities ( $row [ 'track' ]) . '</td>' ;
echo '<td>' . htmlentities ( $row [ 'album' ]) . '</td>' ;
echo '</tr>' ;
}
echo '</table>' ;
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'synchronizetagsfrom' ]) && ! empty ( $_REQUEST [ 'filename' ])) {
2017-05-15 20:37:10 +02:00
echo 'Applying new tags from <b>' . $_REQUEST [ 'synchronizetagsfrom' ] . '</b> in <b>' . htmlentities ( $_REQUEST [ 'filename' ]) . '</b><ul>' ;
$errors = array ();
if ( SynchronizeAllTags ( $_REQUEST [ 'filename' ], $_REQUEST [ 'synchronizetagsfrom' ], 'A12' , $errors )) {
echo '<li>Sucessfully wrote tags</li>' ;
} else {
echo '<li>Tag writing had errors: <ul><li>' . implode ( '</li><li>' , $errors ) . '</li></ul></li>' ;
}
echo '</ul>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'unsynchronizedtags' ])) {
2017-05-15 20:37:10 +02:00
$NotOKfiles = 0 ;
$Autofixedfiles = 0 ;
$FieldsToCompare = array ( 'title' , 'artist' , 'album' , 'year' , 'genre' , 'comment' , 'track' );
$TagsToCompare = array ( 'id3v2' => false , 'ape' => false , 'lyrics3' => false , 'id3v1' => false );
$ID3v1FieldLengths = array ( 'title' => 30 , 'artist' => 30 , 'album' => 30 , 'year' => 4 , 'genre' => 99 , 'comment' => 28 );
if ( strpos ( $_REQUEST [ 'unsynchronizedtags' ], '2' ) !== false ) {
$TagsToCompare [ 'id3v2' ] = true ;
}
if ( strpos ( $_REQUEST [ 'unsynchronizedtags' ], 'A' ) !== false ) {
$TagsToCompare [ 'ape' ] = true ;
}
if ( strpos ( $_REQUEST [ 'unsynchronizedtags' ], 'L' ) !== false ) {
$TagsToCompare [ 'lyrics3' ] = true ;
}
if ( strpos ( $_REQUEST [ 'unsynchronizedtags' ], '1' ) !== false ) {
$TagsToCompare [ 'id3v1' ] = true ;
}
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?unsynchronizedtags=' . urlencode ( $_REQUEST [ 'unsynchronizedtags' ]) . '&autofix=1' ) . '">Auto-fix empty tags</a><br><br>' ;
echo '<div id="Autofixing"></div>' ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr>' ;
echo '<th>View</th>' ;
echo '<th>Filename</th>' ;
echo '<th>Combined</th>' ;
if ( $TagsToCompare [ 'id3v2' ]) {
echo '<th><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?unsynchronizedtags=' . urlencode ( $_REQUEST [ 'unsynchronizedtags' ]) . '&autofix=1&autofixforcesource=id3v2&autofixforcedest=A1' ) . '" title="Auto-fix all tags to match ID3v2 contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match ID3v2?\');">ID3v2</a></th>' ;
}
if ( $TagsToCompare [ 'ape' ]) {
echo '<th><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?unsynchronizedtags=' . urlencode ( $_REQUEST [ 'unsynchronizedtags' ]) . '&autofix=1&autofixforcesource=ape&autofixforcedest=21' ) . '" title="Auto-fix all tags to match APE contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match APE?\');">APE</a></th>' ;
}
if ( $TagsToCompare [ 'lyrics3' ]) {
echo '<th>Lyrics3</th>' ;
}
if ( $TagsToCompare [ 'id3v1' ]) {
echo '<th><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?unsynchronizedtags=' . urlencode ( $_REQUEST [ 'unsynchronizedtags' ]) . '&autofix=1&autofixforcesource=ape&autofixforcedest=2A' ) . '" title="Auto-fix all tags to match ID3v1 contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match ID3v1?\');">ID3v1</a></th>' ;
}
echo '</tr>' ;
$SQLquery = 'SELECT `filename`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyrics3`, `comments_id3v1`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` = "mp3")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
$lastdir = '' ;
$serializedCommentsFields = array ( 'all' , 'id3v2' , 'ape' , 'lyrics3' , 'id3v1' );
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
if ( $lastdir != dirname ( $row [ 'filename' ])) {
echo '<script type="text/javascript">if (document.getElementById("Autofixing")) document.getElementById("Autofixing").innerHTML = "' . htmlentities ( $lastdir , ENT_QUOTES ) . '";</script>' ;
flush ();
}
$FileOK = true ;
$Mismatched = array ( 'id3v2' => false , 'ape' => false , 'lyrics3' => false , 'id3v1' => false );
$SemiMatched = array ( 'id3v2' => false , 'ape' => false , 'lyrics3' => false , 'id3v1' => false );
$EmptyTags = array ( 'id3v2' => true , 'ape' => true , 'lyrics3' => true , 'id3v1' => true );
foreach ( $serializedCommentsFields as $field ) {
$Comments [ $field ] = array ();
ob_start ();
if ( $unserialized = unserialize ( $row [ 'comments_' . $field ])) {
$Comments [ $field ] = $unserialized ;
}
$errormessage = ob_get_contents ();
ob_end_clean ();
}
if ( isset ( $Comments [ 'ape' ][ 'tracknumber' ])) {
$Comments [ 'ape' ][ 'track' ] = $Comments [ 'ape' ][ 'tracknumber' ];
unset ( $Comments [ 'ape' ][ 'tracknumber' ]);
}
if ( isset ( $Comments [ 'ape' ][ 'track_number' ])) {
$Comments [ 'ape' ][ 'track' ] = $Comments [ 'ape' ][ 'track_number' ];
unset ( $Comments [ 'ape' ][ 'track_number' ]);
}
if ( isset ( $Comments [ 'id3v2' ][ 'track_number' ])) {
$Comments [ 'id3v2' ][ 'track' ] = $Comments [ 'id3v2' ][ 'track_number' ];
unset ( $Comments [ 'id3v2' ][ 'track_number' ]);
}
if ( ! empty ( $Comments [ 'all' ][ 'track' ])) {
$besttrack = '' ;
foreach ( $Comments [ 'all' ][ 'track' ] as $key => $value ) {
if ( strlen ( $value ) > strlen ( $besttrack )) {
$besttrack = $value ;
}
}
$Comments [ 'all' ][ 'track' ] = array ( 0 => $besttrack );
}
$ThisLine = '<tr>' ;
$ThisLine .= '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">view</a></td>' ;
$ThisLine .= '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
$tagvalues = '' ;
foreach ( $FieldsToCompare as $fieldname ) {
$tagvalues .= $fieldname . ' = ' . ( ! empty ( $Comments [ 'all' ][ $fieldname ]) ? implode ( " \n " , $Comments [ 'all' ][ $fieldname ]) : '' ) . " \n " ;
}
$ThisLine .= '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?synchronizetagsfrom=all&filename=' . urlencode ( $row [ 'filename' ])) . '" title="' . htmlentities ( rtrim ( $tagvalues , " \n " ), ENT_QUOTES ) . '" target="retagwindow">all</a></td>' ;
foreach ( $TagsToCompare as $tagtype => $CompareThisTagType ) {
if ( $CompareThisTagType ) {
$tagvalues = '' ;
foreach ( $FieldsToCompare as $fieldname ) {
if ( $tagtype == 'id3v1' ) {
getid3_lib :: IncludeDependency ( GETID3_INCLUDEPATH . 'module.tag.id3v1.php' , __FILE__ , true );
if (( $fieldname == 'genre' ) && ! empty ( $Comments [ 'all' ][ $fieldname ][ 0 ]) && ! getid3_id3v1 :: LookupGenreID ( $Comments [ 'all' ][ $fieldname ][ 0 ])) {
// non-standard genres can never match, so just ignore
$tagvalues .= $fieldname . ' = ' . ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) . " \n " ;
} elseif ( $fieldname == 'comment' ) {
if ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) && isset ( $Comments [ 'all' ][ $fieldname ][ 0 ]) && ( rtrim ( substr ( $Comments [ $tagtype ][ $fieldname ][ 0 ], 0 , 28 )) != rtrim ( substr ( $Comments [ 'all' ][ $fieldname ][ 0 ], 0 , 28 )))) {
$tagvalues .= $fieldname . ' = [[' . $Comments [ $tagtype ][ $fieldname ][ 0 ] . ']]' . " \n " ;
if ( trim ( strtolower ( RemoveAccents ( substr ( $Comments [ $tagtype ][ $fieldname ][ 0 ], 0 , 28 )))) == trim ( strtolower ( RemoveAccents ( substr ( $Comments [ 'all' ][ $fieldname ][ 0 ], 0 , 28 ))))) {
$SemiMatched [ $tagtype ] = true ;
} else {
$Mismatched [ $tagtype ] = true ;
}
$FileOK = false ;
} else {
$tagvalues .= $fieldname . ' = ' . ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) . " \n " ;
}
} elseif ( $fieldname == 'track' ) {
// intval('01/20') == intval('1')
$trackA = ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' );
$trackB = ( isset ( $Comments [ 'all' ][ $fieldname ][ 0 ]) ? $Comments [ 'all' ][ $fieldname ][ 0 ] : '' );
if ( intval ( $trackA ) != intval ( $trackB )) {
$tagvalues .= $fieldname . ' = [[' . $trackA . ']]' . " \n " ;
$Mismatched [ $tagtype ] = true ;
$FileOK = false ;
} else {
$tagvalues .= $fieldname . ' = ' . $trackA . " \n " ;
}
} elseif (( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? rtrim ( substr ( $Comments [ $tagtype ][ $fieldname ][ 0 ], 0 , 30 )) : '' ) != ( isset ( $Comments [ 'all' ][ $fieldname ][ 0 ]) ? rtrim ( substr ( $Comments [ 'all' ][ $fieldname ][ 0 ], 0 , 30 )) : '' )) {
$tagvalues .= $fieldname . ' = [[' . ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) . ']]' . " \n " ;
if ( strtolower ( RemoveAccents ( trim ( substr (( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ), 0 , 30 )))) == strtolower ( RemoveAccents ( trim ( substr (( isset ( $Comments [ 'all' ][ $fieldname ][ 0 ]) ? $Comments [ 'all' ][ $fieldname ][ 0 ] : '' ), 0 , 30 ))))) {
$SemiMatched [ $tagtype ] = true ;
} else {
$Mismatched [ $tagtype ] = true ;
}
$FileOK = false ;
if ( ! empty ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) && ( strlen ( trim ( $Comments [ $tagtype ][ $fieldname ][ 0 ])) > 0 )) {
$EmptyTags [ $tagtype ] = false ;
}
} else {
$tagvalues .= $fieldname . ' = ' . ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) . " \n " ;
if ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) && ( strlen ( trim ( $Comments [ $tagtype ][ $fieldname ][ 0 ])) > 0 )) {
$EmptyTags [ $tagtype ] = false ;
}
}
} elseif (( $tagtype == 'ape' ) && ( $fieldname == 'year' )) {
if ((( isset ( $Comments [ 'ape' ][ 'date' ][ 0 ]) ? $Comments [ 'ape' ][ 'date' ][ 0 ] : '' ) != ( isset ( $Comments [ 'all' ][ 'year' ][ 0 ]) ? $Comments [ 'all' ][ 'year' ][ 0 ] : '' )) && (( isset ( $Comments [ 'ape' ][ 'year' ][ 0 ]) ? $Comments [ 'ape' ][ 'year' ][ 0 ] : '' ) != ( isset ( $Comments [ 'all' ][ 'year' ][ 0 ]) ? $Comments [ 'all' ][ 'year' ][ 0 ] : '' ))) {
$tagvalues .= $fieldname . ' = [[' . ( isset ( $Comments [ 'ape' ][ 'date' ][ 0 ]) ? $Comments [ 'ape' ][ 'date' ][ 0 ] : '' ) . ']]' . " \n " ;
$Mismatched [ $tagtype ] = true ;
$FileOK = false ;
if ( isset ( $Comments [ 'ape' ][ 'date' ][ 0 ]) && ( strlen ( trim ( $Comments [ 'ape' ][ 'date' ][ 0 ])) > 0 )) {
$EmptyTags [ $tagtype ] = false ;
}
} else {
$tagvalues .= $fieldname . ' = ' . ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) . " \n " ;
if ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) && ( strlen ( trim ( $Comments [ $tagtype ][ $fieldname ][ 0 ])) > 0 )) {
$EmptyTags [ $tagtype ] = false ;
}
}
} elseif (( $fieldname == 'genre' ) && ! empty ( $Comments [ 'all' ][ $fieldname ]) && ! empty ( $Comments [ $tagtype ][ $fieldname ]) && in_array ( $Comments [ $tagtype ][ $fieldname ][ 0 ], $Comments [ 'all' ][ $fieldname ])) {
$tagvalues .= $fieldname . ' = ' . ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) . " \n " ;
if ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) && ( strlen ( trim ( $Comments [ $tagtype ][ $fieldname ][ 0 ])) > 0 )) {
$EmptyTags [ $tagtype ] = false ;
}
} elseif (( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) != ( isset ( $Comments [ 'all' ][ $fieldname ][ 0 ]) ? $Comments [ 'all' ][ $fieldname ][ 0 ] : '' )) {
$skiptracknumberfield = false ;
switch ( $fieldname ) {
case 'track' :
case 'tracknumber' :
case 'track_number' :
$trackA = ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' );
$trackB = ( isset ( $Comments [ 'all' ][ $fieldname ][ 0 ]) ? $Comments [ 'all' ][ $fieldname ][ 0 ] : '' );
if ( intval ( $trackA ) == intval ( $trackB )) {
$skiptracknumberfield = true ;
}
break ;
}
if ( ! $skiptracknumberfield ) {
$tagvalues .= $fieldname . ' = [[' . ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) . ']]' . " \n " ;
$tagA = ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' );
$tagB = ( isset ( $Comments [ 'all' ][ $fieldname ][ 0 ]) ? $Comments [ 'all' ][ $fieldname ][ 0 ] : '' );
if ( trim ( strtolower ( RemoveAccents ( $tagA ))) == trim ( strtolower ( RemoveAccents ( $tagB )))) {
$SemiMatched [ $tagtype ] = true ;
} else {
$Mismatched [ $tagtype ] = true ;
}
$FileOK = false ;
if ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) && ( strlen ( trim ( $Comments [ $tagtype ][ $fieldname ][ 0 ])) > 0 )) {
$EmptyTags [ $tagtype ] = false ;
}
}
} else {
$tagvalues .= $fieldname . ' = ' . ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) ? $Comments [ $tagtype ][ $fieldname ][ 0 ] : '' ) . " \n " ;
if ( isset ( $Comments [ $tagtype ][ $fieldname ][ 0 ]) && ( strlen ( trim ( $Comments [ $tagtype ][ $fieldname ][ 0 ])) > 0 )) {
$EmptyTags [ $tagtype ] = false ;
}
}
}
if ( $EmptyTags [ $tagtype ]) {
$FileOK = false ;
$ThisLine .= '<td bgcolor="#0099cc">' ;
} elseif ( $SemiMatched [ $tagtype ]) {
$ThisLine .= '<td bgcolor="#ff9999">' ;
} elseif ( $Mismatched [ $tagtype ]) {
$ThisLine .= '<td bgcolor="#ff0000">' ;
} else {
$ThisLine .= '<td bgcolor="#00cc00">' ;
}
$ThisLine .= '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?synchronizetagsfrom=' . $tagtype . '&filename=' . urlencode ( $row [ 'filename' ])) . '" title="' . htmlentities ( rtrim ( $tagvalues , " \n " ), ENT_QUOTES ) . '" TARGET="retagwindow">' . $tagtype . '</a>' ;
$ThisLine .= '</td>' ;
}
}
$ThisLine .= '</tr>' ;
if ( ! $FileOK ) {
$NotOKfiles ++ ;
echo '<script type="text/javascript">if (document.getElementById("Autofixing")) document.getElementById("Autofixing").innerHTML = "' . htmlentities ( $row [ 'filename' ], ENT_QUOTES ) . '";</script>' ;
flush ();
if ( ! empty ( $_REQUEST [ 'autofix' ])) {
$AnyMismatched = false ;
foreach ( $Mismatched as $key => $value ) {
if ( $value && ( $EmptyTags [ " $key " ] === false )) {
$AnyMismatched = true ;
}
}
if ( $AnyMismatched && empty ( $_REQUEST [ 'autofixforcesource' ])) {
echo $ThisLine ;
} else {
$TagsToSynch = '' ;
foreach ( $EmptyTags as $key => $value ) {
if ( $value ) {
switch ( $key ) {
case 'id3v1' :
$TagsToSynch .= '1' ;
break ;
case 'id3v2' :
$TagsToSynch .= '2' ;
break ;
case 'ape' :
$TagsToSynch .= 'A' ;
break ;
}
}
}
$autofixforcesource = ( ! empty ( $_REQUEST [ 'autofixforcesource' ]) ? $_REQUEST [ 'autofixforcesource' ] : 'all' );
$TagsToSynch = ( ! empty ( $_REQUEST [ 'autofixforcedest' ]) ? $_REQUEST [ 'autofixforcedest' ] : $TagsToSynch );
$errors = array ();
if ( SynchronizeAllTags ( $row [ 'filename' ], $autofixforcesource , $TagsToSynch , $errors )) {
$Autofixedfiles ++ ;
echo '<tr bgcolor="#00CC00">' ;
} else {
echo '<tr bgcolor="#FF0000">' ;
}
echo '<td> </th>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ])) . '" title="' . htmlentities ( implode ( " \n " , $errors ), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '<td><table border="0">' ;
echo '<tr><td><b>' . $TagsToSynch . '</b></td></tr>' ;
echo '</table></td></tr>' ;
}
} else {
echo $ThisLine ;
}
}
}
echo '</table><br>' ;
echo '<script type="text/javascript">if (document.getElementById("Autofixing")) document.getElementById("Autofixing").innerHTML = "";</script>' ;
echo 'Found <b>' . number_format ( $NotOKfiles ) . '</b> files with unsynchronized tags, and auto-fixed ' . number_format ( $Autofixedfiles ) . ' of them.' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'filenamepattern' ])) {
2017-05-15 20:37:10 +02:00
$patterns [ 'A' ] = 'artist' ;
$patterns [ 'T' ] = 'title' ;
$patterns [ 'M' ] = 'album' ;
$patterns [ 'N' ] = 'track' ;
$patterns [ 'G' ] = 'genre' ;
$patterns [ 'R' ] = 'remix' ;
$FieldsToUse = explode ( ' ' , wordwrap ( preg_replace ( '#[^A-Z]#i' , '' , $_REQUEST [ 'filenamepattern' ]), 1 , ' ' , 1 ));
//$FieldsToUse = explode(' ', wordwrap($_REQUEST['filenamepattern'], 1, ' ', 1));
foreach ( $FieldsToUse as $FieldID ) {
$FieldNames [] = $patterns [ " $FieldID " ];
}
$SQLquery = 'SELECT `filename`, `fileformat`, ' . implode ( ', ' , $FieldNames );
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` NOT LIKE "' . implode ( '") AND (`fileformat` NOT LIKE "' , $IgnoreNoTagFormats ) . '")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
echo 'Files that do not match naming pattern: (<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?filenamepattern=' . urlencode ( $_REQUEST [ 'filenamepattern' ]) . '&autofix=1' ) . '">auto-fix</a>)<br>' ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>view</th><th>Why</th><td><b>Actual filename</b><br>(click to play/edit file)</td><td><b>Correct filename (based on tags)</b>' . ( empty ( $_REQUEST [ 'autofix' ]) ? '<br>(click to rename file to this)' : '' ) . '</td></tr>' ;
$nonmatchingfilenames = 0 ;
$Pattern = $_REQUEST [ 'filenamepattern' ];
$PatternLength = strlen ( $Pattern );
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 10 );
$PatternFilename = '' ;
for ( $i = 0 ; $i < $PatternLength ; $i ++ ) {
if ( isset ( $patterns [ $Pattern { $i }])) {
$PatternFilename .= trim ( strtr ( $row [ $patterns [ $Pattern { $i }]], ':\\*<>|' , ';-¤«»¦' ), ' ' );
} else {
$PatternFilename .= $Pattern { $i };
}
}
// Replace "~" with "-" if characters immediately before and after are both numbers,
// "/" has been replaced with "~" above which is good for multi-song medley dividers,
// but for things like 24/7, 7/8ths, etc it looks better if it's 24-7, 7-8ths, etc.
$PatternFilename = preg_replace ( '#([ a-z]+)/([ a-z]+)#i' , '\\1~\\2' , $PatternFilename );
$PatternFilename = str_replace ( '/' , '× , $PatternFilename );
$PatternFilename = str_replace ( '?' , '¿' , $PatternFilename );
$PatternFilename = str_replace ( ' "' , ' , $PatternFilename );
$PatternFilename = str_replace ( '("' , '( , $PatternFilename );
$PatternFilename = str_replace ( '-"' , '- , $PatternFilename );
$PatternFilename = str_replace ( '" ' , ' , $PatternFilename . ' ' );
$PatternFilename = str_replace ( '"' , ' , $PatternFilename );
$PatternFilename = str_replace ( ' ' , ' ' , $PatternFilename );
$ParenthesesPairs = array ( '()' , '[]' , '{}' );
foreach ( $ParenthesesPairs as $pair ) {
// multiple remixes are stored tab-seperated in the database.
// change "{2000 Version\tSomebody Remix}" into "{2000 Version} {Somebody Remix}"
while ( preg_match ( '#^(.*)' . preg_quote ( $pair { 0 }) . '([^' . preg_quote ( $pair { 1 }) . ']*)(' . " \t " . ')([^' . preg_quote ( $pair { 0 }) . ']*)' . preg_quote ( $pair { 1 }) . '#' , $PatternFilename , $matches )) {
$PatternFilename = $matches [ 1 ] . $pair { 0 } . $matches [ 2 ] . $pair { 1 } . ' ' . $pair { 0 } . $matches [ 4 ] . $pair { 1 };
}
// remove empty parenthesized pairs (probably where no track numbers, remix version, etc)
$PatternFilename = preg_replace ( '#' . preg_quote ( $pair ) . '#' , '' , $PatternFilename );
// "[01] - Title With No Artist.mp3" ==> "[01] Title With No Artist.mp3"
$PatternFilename = preg_replace ( '#' . preg_quote ( $pair { 1 }) . ' +\- #' , $pair { 1 } . ' ' , $PatternFilename );
}
// get rid of leading & trailing spaces if end items (artist or title for example) are missing
$PatternFilename = trim ( $PatternFilename , ' -' );
if ( ! $PatternFilename ) {
// no tags to create a filename from -- skip this file
continue ;
}
$PatternFilename .= '.' . $row [ 'fileformat' ];
$ActualFilename = basename ( $row [ 'filename' ]);
if ( $ActualFilename != $PatternFilename ) {
$NotMatchedReasons = '' ;
if ( strtolower ( $ActualFilename ) === strtolower ( $PatternFilename )) {
$NotMatchedReasons .= 'Aa ' ;
} elseif ( RemoveAccents ( $ActualFilename ) === RemoveAccents ( $PatternFilename )) {
$NotMatchedReasons .= 'ée ' ;
}
$actualExt = '.' . fileextension ( $ActualFilename );
$patternExt = '.' . fileextension ( $PatternFilename );
$ActualFilenameNoExt = (( $actualExt != '.' ) ? substr ( $ActualFilename , 0 , 0 - strlen ( $actualExt )) : $ActualFilename );
$PatternFilenameNoExt = (( $patternExt != '.' ) ? substr ( $PatternFilename , 0 , 0 - strlen ( $patternExt )) : $PatternFilename );
if ( strpos ( $PatternFilenameNoExt , $ActualFilenameNoExt ) !== false ) {
$DifferenceBoldedName = str_replace ( $ActualFilenameNoExt , '</b>' . $ActualFilenameNoExt . '<b>' , $PatternFilenameNoExt );
} else {
$ShortestNameLength = min ( strlen ( $ActualFilenameNoExt ), strlen ( $PatternFilenameNoExt ));
for ( $DifferenceOffset = 0 ; $DifferenceOffset < $ShortestNameLength ; $DifferenceOffset ++ ) {
if ( $ActualFilenameNoExt { $DifferenceOffset } !== $PatternFilenameNoExt { $DifferenceOffset }) {
break ;
}
}
$DifferenceBoldedName = '</b>' . substr ( $PatternFilenameNoExt , 0 , $DifferenceOffset ) . '<b>' . substr ( $PatternFilenameNoExt , $DifferenceOffset );
}
$DifferenceBoldedName .= (( $actualExt == $patternExt ) ? '</b>' . $patternExt . '<b>' : $patternExt );
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ])) . '">view</a></td>' ;
echo '<td> ' . $NotMatchedReasons . '</td>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $ActualFilename ) . '</a></td>' ;
if ( ! empty ( $_REQUEST [ 'autofix' ])) {
$results = '' ;
if ( RenameFileFromTo ( $row [ 'filename' ], dirname ( $row [ 'filename' ]) . '/' . $PatternFilename , $results )) {
echo '<TD BGCOLOR="#009900">' ;
} else {
echo '<TD BGCOLOR="#FF0000">' ;
}
echo '<b>' . $DifferenceBoldedName . '</b></td>' ;
} else {
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?filenamepattern=' . urlencode ( $_REQUEST [ 'filenamepattern' ]) . '&renamefilefrom=' . urlencode ( $row [ 'filename' ]) . '&renamefileto=' . urlencode ( dirname ( $row [ 'filename' ]) . '/' . $PatternFilename )) . '" title="' . htmlentities ( basename ( $row [ 'filename' ]) . " \n " . basename ( $PatternFilename ), ENT_QUOTES ) . '" target="renamewindow">' ;
echo '<b>' . $DifferenceBoldedName . '</b></a></td>' ;
}
echo '</tr>' ;
$nonmatchingfilenames ++ ;
}
}
echo '</table><br>' ;
echo 'Found ' . number_format ( $nonmatchingfilenames ) . ' files that do not match naming pattern<br>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'encoderoptionsdistribution' ])) {
2017-05-15 20:37:10 +02:00
if ( isset ( $_REQUEST [ 'showtagfiles' ])) {
$SQLquery = 'SELECT `filename`, `encoder_options` FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`encoder_options` LIKE "' . mysql_real_escape_string ( $_REQUEST [ 'showtagfiles' ]) . '")' ;
$SQLquery .= ' AND (`fileformat` NOT LIKE "' . implode ( '") AND (`fileformat` NOT LIKE "' , $IgnoreNoTagFormats ) . '")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
} else {
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encoderoptionsdistribution=1' ) . '">Show all Encoder Options</a><hr>' ;
echo 'Files with Encoder Options <b>' . $_REQUEST [ 'showtagfiles' ] . '</b>:<br>' ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '<td>' . $row [ 'encoder_options' ] . '</td>' ;
echo '</tr>' ;
}
echo '</table>' ;
}
} elseif ( ! isset ( $_REQUEST [ 'm3u' ])) {
$SQLquery = 'SELECT `encoder_options`, COUNT(*) AS `num` FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` NOT LIKE "' . implode ( '") AND (`fileformat` NOT LIKE "' , $IgnoreNoTagFormats ) . '")' ;
$SQLquery .= ' GROUP BY `encoder_options`' ;
$SQLquery .= ' ORDER BY (`encoder_options` LIKE "LAME%") DESC, (`encoder_options` LIKE "CBR%") DESC, `num` DESC, `encoder_options` ASC' ;
$result = mysql_query_safe ( $SQLquery );
echo 'Files with Encoder Options:<br>' ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>Encoder Options</th><th>Count</th><th>M3U</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td>' . $row [ 'encoder_options' ] . '</td>' ;
echo '<TD ALIGN="RIGHT"><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encoderoptionsdistribution=1&showtagfiles=' . ( $row [ 'encoder_options' ] ? urlencode ( $row [ 'encoder_options' ]) : '' )) . '">' . number_format ( $row [ 'num' ]) . '</a></td>' ;
echo '<TD ALIGN="RIGHT"><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encoderoptionsdistribution=1&showtagfiles=' . ( $row [ 'encoder_options' ] ? urlencode ( $row [ 'encoder_options' ]) : '' ) . '&m3u=.m3u' ) . '">m3u</a></td>' ;
echo '</tr>' ;
}
echo '</table><hr>' ;
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'tagtypes' ])) {
2017-05-15 20:37:10 +02:00
if ( ! isset ( $_REQUEST [ 'm3u' ])) {
$SQLquery = 'SELECT `tags`, COUNT(*) AS `num` FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` NOT LIKE "' . implode ( '") AND (`fileformat` NOT LIKE "' , $IgnoreNoTagFormats ) . '")' ;
$SQLquery .= ' GROUP BY `tags`' ;
$SQLquery .= ' ORDER BY `num` DESC' ;
$result = mysql_query_safe ( $SQLquery );
echo 'Files with tags:<br>' ;
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
echo '<tr><th>Tags</th><th>Count</th><th>M3U</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td>' . $row [ 'tags' ] . '</td>' ;
echo '<td align="right"><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?tagtypes=1&showtagfiles=' . ( $row [ 'tags' ] ? urlencode ( $row [ 'tags' ]) : '' )) . '">' . number_format ( $row [ 'num' ]) . '</a></td>' ;
echo '<td align="right"><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?tagtypes=1&showtagfiles=' . ( $row [ 'tags' ] ? urlencode ( $row [ 'tags' ]) : '' ) . '&m3u=.m3u' ) . '">m3u</a></td>' ;
echo '</tr>' ;
}
echo '</table><hr>' ;
}
if ( isset ( $_REQUEST [ 'showtagfiles' ])) {
$SQLquery = 'SELECT `filename`, `tags` FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`tags` LIKE "' . mysql_real_escape_string ( $_REQUEST [ 'showtagfiles' ]) . '")' ;
$SQLquery .= ' AND (`fileformat` NOT LIKE "' . implode ( '") AND (`fileformat` NOT LIKE "' , $IgnoreNoTagFormats ) . '")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
} else {
echo '<table border="1" cellspacing="0" cellpadding="3">' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '<td>' . $row [ 'tags' ] . '</td>' ;
echo '</tr>' ;
}
echo '</table>' ;
}
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'md5datadupes' ])) {
2017-05-15 20:37:10 +02:00
$OtherFormats = '' ;
$AVFormats = '' ;
$SQLquery = 'SELECT `md5_data`, `filename`, COUNT(*) AS `num`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`md5_data` <> "")' ;
$SQLquery .= ' GROUP BY `md5_data`' ;
$SQLquery .= ' ORDER BY `num` DESC' ;
$result = mysql_query_safe ( $SQLquery );
while (( $row = mysql_fetch_array ( $result )) && ( $row [ 'num' ] > 1 )) {
set_time_limit ( 30 );
$filenames = array ();
$tags = array ();
$md5_data = array ();
$SQLquery = 'SELECT `fileformat`, `filename`, `tags`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`md5_data` = "' . mysql_real_escape_string ( $row [ 'md5_data' ]) . '")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result2 = mysql_query_safe ( $SQLquery );
while ( $row2 = mysql_fetch_array ( $result2 )) {
$thisfileformat = $row2 [ 'fileformat' ];
$filenames [] = $row2 [ 'filename' ];
$tags [] = $row2 [ 'tags' ];
$md5_data [] = $row [ 'md5_data' ];
}
$thisline = '<tr>' ;
$thisline .= '<TD VALIGN="TOP" style="font-family: monospace;">' . implode ( '<br>' , $md5_data ) . '</td>' ;
$thisline .= '<TD VALIGN="TOP" NOWRAP>' . implode ( '<br>' , $tags ) . '</td>' ;
$thisline .= '<TD VALIGN="TOP">' . implode ( '<br>' , $filenames ) . '</td>' ;
$thisline .= '</tr>' ;
if ( in_array ( $thisfileformat , $IgnoreNoTagFormats )) {
$OtherFormats .= $thisline ;
} else {
$AVFormats .= $thisline ;
}
}
echo 'Duplicated MD5_DATA (Audio/Video files):<table border="1" cellspacing="0" cellpadding="2">' ;
echo $AVFormats . '</table><hr>' ;
echo 'Duplicated MD5_DATA (Other files):<table border="1" cellspacing="0" cellpadding="2">' ;
echo $OtherFormats . '</table><hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'artisttitledupes' ])) {
2017-05-15 20:37:10 +02:00
if ( isset ( $_REQUEST [ 'm3uartist' ]) && isset ( $_REQUEST [ 'm3utitle' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
$SQLquery = 'SELECT `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`artist` = "' . mysql_real_escape_string ( $_REQUEST [ 'm3uartist' ]) . '")' ;
$SQLquery .= ' AND (`title` = "' . mysql_real_escape_string ( $_REQUEST [ 'm3utitle' ]) . '")' ;
$SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
}
$SQLquery = 'SELECT `artist`, `title`, `filename`, COUNT(*) AS `num`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`artist` <> "")' ;
$SQLquery .= ' AND (`title` <> "")' ;
$SQLquery .= ' GROUP BY `artist`, `title`' . ( ! empty ( $_REQUEST [ 'samemix' ]) ? ', `remix`' : '' );
$SQLquery .= ' ORDER BY `num` DESC, `artist` ASC, `title` ASC, `playtime_seconds` ASC, `remix` ASC' ;
$result = mysql_query_safe ( $SQLquery );
$uniquetitles = 0 ;
$uniquefiles = 0 ;
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while (( $row = mysql_fetch_array ( $result )) && ( $row [ 'num' ] > 1 )) {
$SQLquery = 'SELECT `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`artist` = "' . mysql_real_escape_string ( $row [ 'artist' ]) . '")' ;
$SQLquery .= ' AND (`title` = "' . mysql_real_escape_string ( $row [ 'title' ]) . '")' ;
if ( ! empty ( $_REQUEST [ 'samemix' ])) {
$SQLquery .= ' AND (`remix` = "' . mysql_real_escape_string ( $row [ 'remix' ]) . '")' ;
}
$SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC' ;
$result2 = mysql_query_safe ( $SQLquery );
while ( $row2 = mysql_fetch_array ( $result2 )) {
echo WindowsShareSlashTranslate ( $row2 [ 'filename' ]) . " \n " ;
}
}
exit ;
} else {
echo 'Duplicated aritst + title: (<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?artisttitledupes=1&samemix=1' ) . '">Identical Mix/Version only</a>)<br>' ;
echo '(<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?artisttitledupes=1&m3u=.m3u' ) . '">.m3u version</a>)<br>' ;
echo '<table border="1" cellspacing="0" cellpadding="2">' ;
echo '<tr><th colspan="3"> </th><th>Artist</th><th>Title</th><th>Version</th><th> </th><th> </th><th>Filename</th></tr>' ;
while (( $row = mysql_fetch_array ( $result )) && ( $row [ 'num' ] > 1 )) {
$uniquetitles ++ ;
set_time_limit ( 30 );
$filenames = array ();
$artists = array ();
$titles = array ();
$remixes = array ();
$bitrates = array ();
$playtimes = array ();
$SQLquery = 'SELECT `filename`, `artist`, `title`, `remix`, `audio_bitrate`, `vbr_method`, `playtime_seconds`, `encoder_options`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`artist` = "' . mysql_real_escape_string ( $row [ 'artist' ]) . '")' ;
$SQLquery .= ' AND (`title` = "' . mysql_real_escape_string ( $row [ 'title' ]) . '")' ;
$SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC' ;
$result2 = mysql_query_safe ( $SQLquery );
while ( $row2 = mysql_fetch_array ( $result2 )) {
$uniquefiles ++ ;
$filenames [] = $row2 [ 'filename' ];
$artists [] = $row2 [ 'artist' ];
$titles [] = $row2 [ 'title' ];
$remixes [] = $row2 [ 'remix' ];
if ( $row2 [ 'vbr_method' ]) {
$bitrates [] = '<B' . ( $row2 [ 'encoder_options' ] ? ' style="text-decoration: underline; cursor: help;" title="' . $row2 [ 'encoder_options' ] : '' ) . '">' . BitrateText ( $row2 [ 'audio_bitrate' ] / 1000 ) . '</b>' ;
} else {
$bitrates [] = BitrateText ( $row2 [ 'audio_bitrate' ] / 1000 );
}
$playtimes [] = getid3_lib :: PlaytimeString ( $row2 [ 'playtime_seconds' ]);
}
echo '<tr>' ;
echo '<TD NOWRAP VALIGN="TOP">' ;
foreach ( $filenames as $file ) {
echo '<a href="' . htmlentities ( 'demo.browse.php?deletefile=' . urlencode ( $file ) . '&noalert=1' ) . '" onClick="return confirm(\'Are you sure you want to delete ' . addslashes ( $file ) . '? \n(this action cannot be un-done)\');" title="' . htmlentities ( 'Permanently delete ' . " \n " . $file , ENT_QUOTES ) . '" target="deletedupewindow">delete</a><br>' ;
}
echo '</td>' ;
echo '<TD NOWRAP VALIGN="TOP">' ;
foreach ( $filenames as $file ) {
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $file )) . '">play</a><br>' ;
}
echo '</td>' ;
echo '<TD VALIGN="MIDDLE" ALIGN="CENTER" ><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?artisttitledupes=1&m3uartist=' . urlencode ( $artists [ 0 ]) . '&m3utitle=' . urlencode ( $titles [ 0 ])) . '">play all</a></td>' ;
echo '<TD VALIGN="TOP" NOWRAP>' . implode ( '<br>' , $artists ) . '</td>' ;
echo '<TD VALIGN="TOP" NOWRAP>' . implode ( '<br>' , $titles ) . '</td>' ;
echo '<TD VALIGN="TOP" NOWRAP>' . implode ( '<br>' , $remixes ) . '</td>' ;
echo '<TD VALIGN="TOP" NOWRAP ALIGN="RIGHT">' . implode ( '<br>' , $bitrates ) . '</td>' ;
echo '<TD VALIGN="TOP" NOWRAP ALIGN="RIGHT">' . implode ( '<br>' , $playtimes ) . '</td>' ;
echo '<TD VALIGN="TOP" NOWRAP ALIGN="LEFT"><table border="0" cellspacing="0" cellpadding="0">' ;
foreach ( $filenames as $file ) {
echo '<tr><TD NOWRAP ALIGN="RIGHT"><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $file )) . '"><span style="color: #339966;">' . dirname ( $file ) . '/</span>' . basename ( $file ) . '</a></td></tr>' ;
}
echo '</table></td>' ;
echo '</tr>' ;
}
}
echo '</table>' ;
echo number_format ( $uniquefiles ) . ' files with ' . number_format ( $uniquetitles ) . ' unique <i>aritst + title</i><br>' ;
echo '<hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'filetypelist' ])) {
2017-05-15 20:37:10 +02:00
list ( $fileformat , $audioformat ) = explode ( '|' , $_REQUEST [ 'filetypelist' ]);
$SQLquery = 'SELECT `filename`, `fileformat`, `audio_dataformat`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` = "' . mysql_real_escape_string ( $fileformat ) . '")' ;
$SQLquery .= ' AND (`audio_dataformat` = "' . mysql_real_escape_string ( $audioformat ) . '")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
echo 'Files of format <b>' . $fileformat . '.' . $audioformat . '</b>:<table border="1" cellspacing="0" cellpadding="4">' ;
echo '<tr><th>file</th><th>audio</th><th>filename</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td>' . $row [ 'fileformat' ] . '</td>' ;
echo '<td>' . $row [ 'audio_dataformat' ] . '</td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '</tr>' ;
}
echo '</table><hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'trackinalbum' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `filename`, `album`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`album` LIKE "% [%")' ;
$SQLquery .= ' ORDER BY `album` ASC, `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
} elseif ( ! empty ( $_REQUEST [ 'autofix' ])) {
getid3_lib :: IncludeDependency ( GETID3_INCLUDEPATH . 'module.tag.id3v1.php' , __FILE__ , true );
getid3_lib :: IncludeDependency ( GETID3_INCLUDEPATH . 'module.tag.id3v2.php' , __FILE__ , true );
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
$ThisFileInfo = $getID3 -> analyze ( $filename );
getid3_lib :: CopyTagsToComments ( $ThisFileInfo );
if ( ! empty ( $ThisFileInfo [ 'tags' ])) {
$Album = trim ( str_replace ( strstr ( $ThisFileInfo [ 'comments' ][ 'album' ][ 0 ], ' [' ), '' , $ThisFileInfo [ 'comments' ][ 'album' ][ 0 ]));
$Track = ( string ) intval ( str_replace ( ' [' , '' , str_replace ( ']' , '' , strstr ( $ThisFileInfo [ 'comments' ][ 'album' ][ 0 ], ' [' ))));
if ( $Track == '0' ) {
$Track = '' ;
}
if ( $Album && $Track ) {
echo '<hr>' . htmlentities ( $row [ 'filename' ]) . '<br>' ;
echo '<i>' . htmlentities ( $Album ) . '</i> (track #' . $Track . ')<br>' ;
echo '<b>ID3v2:</b> ' . ( RemoveID3v2 ( $row [ 'filename' ], false ) ? 'removed' : 'REMOVAL FAILED!' ) . ', ' ;
$WriteID3v1_title = ( isset ( $ThisFileInfo [ 'comments' ][ 'title' ][ 0 ]) ? $ThisFileInfo [ 'comments' ][ 'title' ][ 0 ] : '' );
$WriteID3v1_artist = ( isset ( $ThisFileInfo [ 'comments' ][ 'artist' ][ 0 ]) ? $ThisFileInfo [ 'comments' ][ 'artist' ][ 0 ] : '' );
$WriteID3v1_year = ( isset ( $ThisFileInfo [ 'comments' ][ 'year' ][ 0 ]) ? $ThisFileInfo [ 'comments' ][ 'year' ][ 0 ] : '' );
$WriteID3v1_comment = ( isset ( $ThisFileInfo [ 'comments' ][ 'comment' ][ 0 ]) ? $ThisFileInfo [ 'comments' ][ 'comment' ][ 0 ] : '' );
$WriteID3v1_genreid = ( isset ( $ThisFileInfo [ 'comments' ][ 'genreid' ][ 0 ]) ? $ThisFileInfo [ 'comments' ][ 'genreid' ][ 0 ] : '' );
echo '<b>ID3v1:</b> ' . ( WriteID3v1 ( $row [ 'filename' ], $WriteID3v1_title , $WriteID3v1_artist , $Album , $WriteID3v1_year , $WriteID3v1_comment , $WriteID3v1_genreid , $Track , false ) ? 'updated' : 'UPDATE FAILED' ) . '<br>' ;
} else {
echo ' . ' ;
}
} else {
echo '<hr>FAILED<br>' . htmlentities ( $row [ 'filename' ]) . '<hr>' ;
}
flush ();
}
} else {
echo '<b>' . number_format ( mysql_num_rows ( $result )) . '</b> files with <b>[??]</b>-format track numbers in album field:<br>' ;
if ( mysql_num_rows ( $result ) > 0 ) {
echo '(<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?trackinalbum=1&m3u=.m3u' ) . '">.m3u version</a>)<br>' ;
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?trackinalbum=1&autofix=1' ) . '">Try to auto-fix</a><br>' ;
echo '<table border="1" cellspacing="0" cellpadding="4">' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td>' . $row [ 'album' ] . '</td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '</tr>' ;
}
echo '</table>' ;
}
echo '<hr>' ;
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'fileextensions' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `filename`, `fileformat`, `audio_dataformat`, `video_dataformat`, `tags`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
$invalidextensionfiles = 0 ;
$invalidextensionline = '<table border="1" cellspacing="0" cellpadding="4">' ;
$invalidextensionline .= '<tr><th>file</th><th>audio</th><th>video</th><th>tags</th><th>actual</th><th>correct</th><th>filename</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
$acceptableextensions = AcceptableExtensions ( $row [ 'fileformat' ], $row [ 'audio_dataformat' ], $row [ 'video_dataformat' ]);
$actualextension = strtolower ( fileextension ( $row [ 'filename' ]));
if ( $acceptableextensions && ! in_array ( $actualextension , $acceptableextensions )) {
$invalidextensionfiles ++ ;
$invalidextensionline .= '<tr>' ;
$invalidextensionline .= '<td>' . $row [ 'fileformat' ] . '</td>' ;
$invalidextensionline .= '<td>' . $row [ 'audio_dataformat' ] . '</td>' ;
$invalidextensionline .= '<td>' . $row [ 'video_dataformat' ] . '</td>' ;
$invalidextensionline .= '<td>' . $row [ 'tags' ] . '</td>' ;
$invalidextensionline .= '<td>' . $actualextension . '</td>' ;
$invalidextensionline .= '<td>' . implode ( '; ' , $acceptableextensions ) . '</td>' ;
$invalidextensionline .= '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
$invalidextensionline .= '</tr>' ;
}
}
$invalidextensionline .= '</table><hr>' ;
echo number_format ( $invalidextensionfiles ) . ' files with incorrect filename extension:<br>' ;
echo $invalidextensionline ;
2015-09-04 03:59:46 +02:00
} elseif ( isset ( $_REQUEST [ 'genredistribution' ])) {
2017-05-15 20:37:10 +02:00
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
$SQLquery = 'SELECT `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (BINARY `genre` = "' . $_REQUEST [ 'genredistribution' ] . '")' ;
$SQLquery .= ' AND (`fileformat` NOT LIKE "' . implode ( '") AND (`fileformat` NOT LIKE "' , $IgnoreNoTagFormats ) . '")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
} else {
if ( $_REQUEST [ 'genredistribution' ] == '%' ) {
$SQLquery = 'SELECT COUNT(*) AS `num`, `genre`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` NOT LIKE "' . implode ( '") AND (`fileformat` NOT LIKE "' , $IgnoreNoTagFormats ) . '")' ;
$SQLquery .= ' GROUP BY `genre`' ;
$SQLquery .= ' ORDER BY `num` DESC' ;
$result = mysql_query_safe ( $SQLquery );
getid3_lib :: IncludeDependency ( GETID3_INCLUDEPATH . 'module.tag.id3v1.php' , __FILE__ , true );
echo '<table border="1" cellspacing="0" cellpadding="4">' ;
echo '<tr><th>Count</th><th>Genre</th><th>m3u</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
$GenreID = getid3_id3v1 :: LookupGenreID ( $row [ 'genre' ]);
if ( is_numeric ( $GenreID )) {
echo '<tr bgcolor="#00FF00;">' ;
} else {
echo '<tr bgcolor="#FF9999;">' ;
}
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?genredistribution=' . urlencode ( $row [ 'genre' ])) . '">' . number_format ( $row [ 'num' ]) . '</a></td>' ;
echo '<td nowrap>' . str_replace ( " \t " , '<br>' , $row [ 'genre' ]) . '</td>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3u=.m3u&genredistribution=' . urlencode ( $row [ 'genre' ])) . '">.m3u</a></td>' ;
echo '</tr>' ;
}
echo '</table><hr>' ;
} else {
$SQLquery = 'SELECT `filename`, `genre`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`genre` LIKE "' . mysql_real_escape_string ( $_REQUEST [ 'genredistribution' ]) . '")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
echo '<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?genredistribution=' . urlencode ( '%' )) . '">All Genres</a><br>' ;
echo '<table border="1" cellspacing="0" cellpadding="4">' ;
echo '<tr><th>Genre</th><th>m3u</th><th>Filename</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<TD NOWRAP>' . str_replace ( " \t " , '<br>' , $row [ 'genre' ]) . '</td>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ])) . '">m3u</a></td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '</tr>' ;
}
echo '</table><hr>' ;
}
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'formatdistribution' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `fileformat`, `audio_dataformat`, COUNT(*) AS `num`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' GROUP BY `fileformat`, `audio_dataformat`' ;
$SQLquery .= ' ORDER BY `num` DESC' ;
$result = mysql_query_safe ( $SQLquery );
echo 'File format distribution:<table border="1" cellspacing="0" cellpadding="4">' ;
echo '<tr><th>Number</th><th>Format</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<TD ALIGN="RIGHT">' . number_format ( $row [ 'num' ]) . '</td>' ;
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?filetypelist=' . $row [ 'fileformat' ] . '|' . $row [ 'audio_dataformat' ]) . '">' . ( $row [ 'fileformat' ] ? $row [ 'fileformat' ] : '<i>unknown</i>' ) . (( $row [ 'audio_dataformat' ] && ( $row [ 'audio_dataformat' ] != $row [ 'fileformat' ])) ? '.' . $row [ 'audio_dataformat' ] : '' ) . '</a></td>' ;
echo '</tr>' ;
}
echo '</table><hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'errorswarnings' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `filename`, `error`, `warning`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`error` <> "")' ;
$SQLquery .= ' OR (`warning` <> "")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
if ( ! empty ( $_REQUEST [ 'm3u' ])) {
header ( 'Content-type: audio/x-mpegurl' );
echo '#EXTM3U' . " \n " ;
while ( $row = mysql_fetch_array ( $result )) {
echo WindowsShareSlashTranslate ( $row [ 'filename' ]) . " \n " ;
}
exit ;
} else {
echo number_format ( mysql_num_rows ( $result )) . ' files with errors or warnings:<br>' ;
echo '(<a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?errorswarnings=1&m3u=.m3u' ) . '">.m3u version</a>)<br>' ;
echo '<table border="1" cellspacing="0" cellpadding="4">' ;
echo '<tr><th>Filename</th><th>Error</th><th>Warning</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td>' ;
echo '<td>' . ( ! empty ( $row [ 'error' ]) ? '<li>' . str_replace ( " \t " , '<li>' , htmlentities ( $row [ 'error' ])) . '</li>' : ' ' ) . '</td>' ;
echo '<td>' . ( ! empty ( $row [ 'warning' ]) ? '<li>' . str_replace ( " \t " , '<li>' , htmlentities ( $row [ 'warning' ])) . '</li>' : ' ' ) . '</td>' ;
echo '</tr>' ;
}
}
echo '</table><hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'fixid3v1padding' ])) {
2017-05-15 20:37:10 +02:00
getid3_lib :: IncludeDependency ( GETID3_INCLUDEPATH . 'write.id3v1.php' , __FILE__ , true );
$id3v1_writer = new getid3_write_id3v1 ;
$SQLquery = 'SELECT `filename`, `error`, `warning`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` = "mp3")' ;
$SQLquery .= ' AND (`warning` <> "")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
$totaltofix = mysql_num_rows ( $result );
$rowcounter = 0 ;
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
if ( strpos ( $row [ 'warning' ], 'Some ID3v1 fields do not use NULL characters for padding' ) !== false ) {
set_time_limit ( 30 );
$id3v1_writer -> filename = $row [ 'filename' ];
echo ( $id3v1_writer -> FixID3v1Padding () ? '<span style="color: #009900;">fixed - ' : '<span style="color: #FF0000;">error - ' );
} else {
echo '<span style="color: #0000FF;">No error? - ' ;
}
echo '[' .++ $rowcounter . ' / ' . $totaltofix . '] ' ;
echo htmlentities ( $row [ 'filename' ]) . '</span><br>' ;
flush ();
}
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'vbrmethod' ])) {
2017-05-15 20:37:10 +02:00
if ( $_REQUEST [ 'vbrmethod' ] == '1' ) {
$SQLquery = 'SELECT COUNT(*) AS `num`, `vbr_method`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' GROUP BY `vbr_method`' ;
$SQLquery .= ' ORDER BY `vbr_method`' ;
$result = mysql_query_safe ( $SQLquery );
echo 'VBR methods:<table border="1" cellspacing="0" cellpadding="4">' ;
echo '<tr><th>Count</th><th>VBR Method</th></tr>' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr>' ;
echo '<TD ALIGN="RIGHT">' . htmlentities ( number_format ( $row [ 'num' ])) . '</td>' ;
if ( $row [ 'vbr_method' ]) {
echo '<td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?vbrmethod=' . $row [ 'vbr_method' ], ENT_QUOTES ) . '">' . htmlentities ( $row [ 'vbr_method' ]) . '</a></td>' ;
} else {
echo '<td><i>CBR</i></td>' ;
}
echo '</tr>' ;
}
echo '</table>' ;
} else {
$SQLquery = 'SELECT `filename`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`vbr_method` = "' . mysql_real_escape_string ( $_REQUEST [ 'vbrmethod' ]) . '")' ;
$result = mysql_query_safe ( $SQLquery );
echo number_format ( mysql_num_rows ( $result )) . ' files with VBR_method of "' . $_REQUEST [ 'vbrmethod' ] . '":<table border="1" cellspacing="0" cellpadding="3">' ;
while ( $row = mysql_fetch_array ( $result )) {
echo '<tr><td><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?m3ufilename=' . urlencode ( $row [ 'filename' ])) . '">m3u</a></td>' ;
echo '<td><a href="' . htmlentities ( 'demo.browse.php?filename=' . rawurlencode ( $row [ 'filename' ]), ENT_QUOTES ) . '">' . htmlentities ( $row [ 'filename' ]) . '</a></td></tr>' ;
}
echo '</table>' ;
}
echo '<hr>' ;
2015-09-04 03:59:46 +02:00
} elseif ( ! empty ( $_REQUEST [ 'correctcase' ])) {
2017-05-15 20:37:10 +02:00
$SQLquery = 'SELECT `filename`, `fileformat`' ;
$SQLquery .= ' FROM `' . mysql_real_escape_string ( GETID3_DB_TABLE ) . '`' ;
$SQLquery .= ' WHERE (`fileformat` <> "")' ;
$SQLquery .= ' ORDER BY `filename` ASC' ;
$result = mysql_query_safe ( $SQLquery );
echo 'Copy and paste the following into a DOS batch file. You may have to run this script more than once to catch all the changes (remember to scan for deleted/changed files and rescan directory between scans)<hr>' ;
echo '<PRE>' ;
$lastdir = '' ;
while ( $row = mysql_fetch_array ( $result )) {
set_time_limit ( 30 );
$CleanedFilename = CleanUpFileName ( $row [ 'filename' ]);
if ( $row [ 'filename' ] != $CleanedFilename ) {
if ( strtolower ( $lastdir ) != strtolower ( str_replace ( '/' , '\\' , dirname ( $row [ 'filename' ])))) {
$lastdir = str_replace ( '/' , '\\' , dirname ( $row [ 'filename' ]));
echo 'cd "' . $lastdir . '"' . " \n " ;
}
echo 'ren "' . basename ( $row [ 'filename' ]) . '" "' . basename ( CleanUpFileName ( $row [ 'filename' ])) . '"' . " \n " ;
}
}
echo '</PRE>' ;
echo '<hr>' ;
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function CleanUpFileName ( $filename ) {
$DirectoryName = dirname ( $filename );
$FileExtension = fileextension ( basename ( $filename ));
$BaseFilename = basename ( $filename , '.' . $FileExtension );
$BaseFilename = strtolower ( $BaseFilename );
$BaseFilename = str_replace ( '_' , ' ' , $BaseFilename );
//$BaseFilename = str_replace('-', ' - ', $BaseFilename);
$BaseFilename = str_replace ( '(' , ' (' , $BaseFilename );
$BaseFilename = str_replace ( '( ' , '(' , $BaseFilename );
$BaseFilename = str_replace ( ')' , ') ' , $BaseFilename );
$BaseFilename = str_replace ( ' )' , ')' , $BaseFilename );
$BaseFilename = str_replace ( ' \'\'' , ' , $BaseFilename );
$BaseFilename = str_replace ( '\'\' ' , ' , $BaseFilename );
$BaseFilename = str_replace ( ' vs ' , ' vs. ' , $BaseFilename );
while ( strstr ( $BaseFilename , ' ' ) !== false ) {
$BaseFilename = str_replace ( ' ' , ' ' , $BaseFilename );
}
$BaseFilename = trim ( $BaseFilename );
return $DirectoryName . '/' . BetterUCwords ( $BaseFilename ) . '.' . strtolower ( $FileExtension );
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
function BetterUCwords ( $string ) {
$stringlength = strlen ( $string );
$string { 0 } = strtoupper ( $string { 0 });
for ( $i = 1 ; $i < $stringlength ; $i ++ ) {
if (( $string { $i - 1 } == '\'' ) && ( $i > 1 ) && (( $string { $i - 2 } == 'O' ) || ( $string { $i - 2 } == ' ' ))) {
// O'Clock, 'Em
$string { $i } = strtoupper ( $string { $i });
} elseif ( preg_match ( '#^[\'A-Za-z0-9À-ÿ]$#' , $string { $i - 1 })) {
$string { $i } = strtolower ( $string { $i });
} else {
$string { $i } = strtoupper ( $string { $i });
}
}
static $LowerCaseWords = array ( 'vs.' , 'feat.' );
static $UpperCaseWords = array ( 'DJ' , 'USA' , 'II' , 'MC' , 'CD' , 'TV' , '\'N\'' );
$OutputListOfWords = array ();
$ListOfWords = explode ( ' ' , $string );
foreach ( $ListOfWords as $ThisWord ) {
if ( in_array ( strtolower ( str_replace ( '(' , '' , $ThisWord )), $LowerCaseWords )) {
$ThisWord = strtolower ( $ThisWord );
} elseif ( in_array ( strtoupper ( str_replace ( '(' , '' , $ThisWord )), $UpperCaseWords )) {
$ThisWord = strtoupper ( $ThisWord );
} elseif (( substr ( $ThisWord , 0 , 2 ) == 'Mc' ) && ( strlen ( $ThisWord ) > 2 )) {
$ThisWord { 2 } = strtoupper ( $ThisWord { 2 });
} elseif (( substr ( $ThisWord , 0 , 3 ) == 'Mac' ) && ( strlen ( $ThisWord ) > 3 )) {
$ThisWord { 3 } = strtoupper ( $ThisWord { 3 });
}
$OutputListOfWords [] = $ThisWord ;
}
$UCstring = implode ( ' ' , $OutputListOfWords );
$UCstring = str_replace ( ' From , ' from , $UCstring );
$UCstring = str_replace ( ' \'n\' ' , ' \'N\' ' , $UCstring );
return $UCstring ;
2015-09-04 03:59:46 +02:00
}
echo '<hr><form action="' . htmlentities ( $_SERVER [ 'PHP_SELF' ], ENT_QUOTES ) . '" method="get">' ;
echo '<b>Warning:</b> Scanning a new directory will erase all previous entries in the database!<br>' ;
echo 'Directory: <input type="text" name="scan" size="50" value="' . htmlentities ( ! empty ( $_REQUEST [ 'scan' ]) ? $_REQUEST [ 'scan' ] : '' , ENT_QUOTES ) . '"> ' ;
echo '<input type="submit" value="Go" onClick="return confirm(\'Are you sure you want to erase all entries in the database and start scanning again?\');">' ;
echo '</form>' ;
echo '<hr><form action="' . htmlentities ( $_SERVER [ 'PHP_SELF' ], ENT_QUOTES ) . '" method="get">' ;
echo 'Re-scanning a new directory will only add new, previously unscanned files into the list (and not erase the database).<br>' ;
echo 'Directory: <input type="text" name="newscan" size="50" value="' . htmlentities ( ! empty ( $_REQUEST [ 'newscan' ]) ? $_REQUEST [ 'newscan' ] : '' , ENT_QUOTES ) . '"> ' ;
echo '<input type="submit" value="Go">' ;
echo '</form><hr>' ;
echo '<ul>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?deadfilescheck=1' ) . '">Remove deleted or changed files from database</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?md5datadupes=1' ) . '">List files with identical MD5_DATA values</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?artisttitledupes=1' ) . '">List files with identical artist + title</a> (<a href="' . $_SERVER [ 'PHP_SELF' ] . '?artisttitledupes=1&samemix=1">same mix only</a>)</li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?fileextensions=1' ) . '">File with incorrect file extension</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?formatdistribution=1' ) . '">File Format Distribution</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?audiobitrates=1' ) . '">Audio Bitrate Distribution</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?vbrmethod=1' ) . '">VBR_Method Distribution</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?tagtypes=1' ) . '">Tag Type Distribution</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?genredistribution=' . urlencode ( '%' )) . '">Genre Distribution</a></li>' ;
//echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?missingtrackvolume=1').'">Scan for missing track volume information (update database from pre-v1.7.0b5)</a></li>';
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encoderoptionsdistribution=1' ) . '">Encoder Options Distribution</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?encodedbydistribution=' . urlencode ( '%' )) . '">Encoded By (ID3v2) Distribution</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?trackinalbum=1' ) . '">Track number in Album field</a></li>' ;
echo '<li><a href="' . htmlentities ( $_SERVER [ 'PHP_SELF' ] . '?tracknoalbum=1' ) . '">Track number, but no Album</a></li>' ;
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 )) {
2017-05-15 20:37:10 +02:00
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">' ;
2015-09-04 03:59:46 +02:00
}
2017-05-15 20:37:10 +02:00
echo '</body></html>' ;
