PageRenderTime 62ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 1ms

/components/com_fabrik/libs/getid3/demos/demo.mysql.php

https://github.com/chrisinammo/arthurmcneil
PHP | 2130 lines | 1790 code | 304 blank | 36 comment | 290 complexity | db9679172893e0a2f4024ed94d60afd2 MD5 | raw file
Possible License(s): LGPL-2.1, AGPL-1.0 
    

  1. <?php
    2. 

  2. /////////////////////////////////////////////////////////////////
    3. 

  3. /// getID3() by James Heinrich <info@getid3.org>               //
    4. 

  4. //  available at http://getid3.sourceforge.net                 //
    5. 

  5. //            or http://www.getid3.org                         //
    6. 

  6. /////////////////////////////////////////////////////////////////
    7. 

  7. //                                                             //
    8. 

  8. // /demo/demo.mysql.php - part of getID3()                     //
    9. 

  9. // Sample script for recursively scanning directories and      //
    10. 

  10. // storing the results in a database                           //
    11. 

  11. // See readme.txt for more details                             //
    12. 

  12. //                                                            ///
    13. 

  13. /////////////////////////////////////////////////////////////////
    14. 

  14. 

  15. // OPTIONS:
    16. 

  16. $getid3_demo_mysql_encoding = 'ISO-8859-1';
    17. 

  17. $getid3_demo_mysql_md5_data = false;        // All data hashes are by far the slowest part of scanning
    18. 

  18. $getid3_demo_mysql_md5_file = false;
    19. 

  19. 

  20. define('GETID3_DB_HOST',  'localhost');
    21. 

  21. define('GETID3_DB_USER',  'getid3');
    22. 

  22. define('GETID3_DB_PASS',  'getid3');
    23. 

  23. define('GETID3_DB_DB',    'getid3');
    24. 

  24. define('GETID3_DB_TABLE', 'files');
    25. 

  25. 

  26. 

  27. if (!@mysql_connect(GETID3_DB_HOST, GETID3_DB_USER, GETID3_DB_PASS)) {
    28. 

  28. 	die('Could not connect to MySQL host: <blockquote style="background-color: #FF9933; padding: 10px;">'.mysql_error().'</blockquote>');
    29. 

  29. }
    30. 

  30. if (!@mysql_select_db(GETID3_DB_DB)) {
    31. 

  31. 	die('Could not select database: <blockquote style="background-color: #FF9933; padding: 10px;">'.mysql_error().'</blockquote>');
    32. 

  32. }
    33. 

  33. 

  34. if (!@include_once('../getid3/getid3.php')) {
    35. 

  35. 	die('Cannot open '.realpath('../getid3/getid3.php'));
    36. 

  36. }
    37. 

  37. // Initialize getID3 engine
    38. 

  38. $getID3 = new getID3;
    39. 

  39. $getID3->setOption(array(
    40. 

  40. 	'option_md5_data' => $getid3_demo_mysql_md5_data,
    41. 

  41. 	'encoding'        => $getid3_demo_mysql_encoding,
    42. 

  42. ));
    43. 

  43. 

  44. 

  45. function RemoveAccents($string) {
    46. 

  46. 	// Revised version by markstewardØhotmail*com
    47. 

  47. 	return strtr(strtr($string, 'ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝàáâãäåçèéêëìíîïñòóôõöøùúûüýÿ', 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy'), array('Þ' => 'TH', 'þ' => 'th', 'Ð' => 'DH', 'ð' => 'dh', 'ß' => 'ss', 'Œ' => 'OE', 'œ' => 'oe', 'Æ' => 'AE', 'æ' => 'ae', 'µ' => 'u'));
    48. 

  48. }
    49. 

  49. 

  50. function FixTextFields($text) {
    51. 

  51. 	$text = getid3_lib::SafeStripSlashes($text);
    52. 

  52. 	$text = htmlentities($text, ENT_QUOTES);
    53. 

  53. 	return $text;
    54. 

  54. }
    55. 

  55. 

  56. function BitrateColor($bitrate, $BitrateMaxScale=768) {
    57. 

  57. 	// $BitrateMaxScale is bitrate of maximum-quality color (bright green)
    58. 

  58. 	// below this is gradient, above is solid green
    59. 

  59. 

  60. 	$bitrate *= (256 / $BitrateMaxScale); // scale from 1-[768]kbps to 1-256
    61. 

  61. 	$bitrate = round(min(max($bitrate, 1), 256));
    62. 

  62. 	$bitrate--;    // scale from 1-256kbps to 0-255kbps
    63. 

  63. 

  64. 	$Rcomponent = max(255 - ($bitrate * 2), 0);
    65. 

  65. 	$Gcomponent = max(($bitrate * 2) - 255, 0);
    66. 

  66. 	if ($bitrate > 127) {
    67. 

  67. 		$Bcomponent = max((255 - $bitrate) * 2, 0);
    68. 

  68. 	} else {
    69. 

  69. 		$Bcomponent = max($bitrate * 2, 0);
    70. 

  70. 	}
    71. 

  71. 	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);
    72. 

  72. }
    73. 

  73. 

  74. function BitrateText($bitrate, $decimals=0) {
    75. 

  75. 	return '<span style="color: #'.BitrateColor($bitrate).'">'.number_format($bitrate, $decimals).' kbps</span>';
    76. 

  76. }
    77. 

  77. 

  78. function fileextension($filename, $numextensions=1) {
    79. 

  79. 	if (strstr($filename, '.')) {
    80. 

  80. 		$reversedfilename = strrev($filename);
    81. 

  81. 		$offset = 0;
    82. 

  82. 		for ($i = 0; $i < $numextensions; $i++) {
    83. 

  83. 			$offset = strpos($reversedfilename, '.', $offset + 1);
    84. 

  84. 			if ($offset === false) {
    85. 

  85. 				return '';
    86. 

  86. 			}
    87. 

  87. 		}
    88. 

  88. 		return strrev(substr($reversedfilename, 0, $offset));
    89. 

  89. 	}
    90. 

  90. 	return '';
    91. 

  91. }
    92. 

  92. 

  93. function RenameFileFromTo($from, $to, &$results) {
    94. 

  94. 	$success = true;
    95. 

  95. 	if ($from === $to) {
    96. 

  96. 		$results = '<span style="color: #FF0000;"><b>Source and Destination filenames identical</b><br>FAILED to rename';
    97. 

  97. 	} elseif (!file_exists($from)) {
    98. 

  98. 		$results = '<span style="color: #FF0000;"><b>Source file does not exist</b><br>FAILED to rename';
    99. 

  99. 	} elseif (file_exists($to) && (strtolower($from) !== strtolower($to))) {
    100. 

  100. 		$results = '<span style="color: #FF0000;"><b>Destination file already exists</b><br>FAILED to rename';
    101. 

  101. 	} elseif (@rename($from, $to)) {
    102. 

  102. 		$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    103. 

  103. 		$SQLquery .= ' WHERE (`filename` = "'.mysql_escape_string($from).'")';
    104. 

  104. 		safe_mysql_query($SQLquery);
    105. 

  105. 		$results = '<span style="color: #008000;">Successfully renamed';
    106. 

  106. 	} else {
    107. 

  107. 		$results = '<br><span style="color: #FF0000;">FAILED to rename';
    108. 

  108. 		$success = false;
    109. 

  109. 	}
    110. 

  110. 	$results .= ' from:<br><i>'.$from.'</i><br>to:<br><i>'.$to.'</i></span><hr>';
    111. 

  111. 	return $success;
    112. 

  112. }
    113. 

  113. 

  114. if (!empty($_REQUEST['renamefilefrom']) && !empty($_REQUEST['renamefileto'])) {
    115. 

  115. 

  116. 	$results = '';
    117. 

  117. 	RenameFileFromTo($_REQUEST['renamefilefrom'], $_REQUEST['renamefileto'], $results);
    118. 

  118. 	echo $results;
    119. 

  119. 	exit;
    120. 

  120. 

  121. } elseif (!empty($_REQUEST['m3ufilename'])) {
    122. 

  122. 

  123. 	header('Content-type: audio/x-mpegurl');
    124. 

  124. 	echo '#EXTM3U'."\n";
    125. 

  125. 	echo WindowsShareSlashTranslate($_REQUEST['m3ufilename'])."\n";
    126. 

  126. 	exit;
    127. 

  127. 

  128. } elseif (!isset($_REQUEST['m3u']) && !isset($_REQUEST['m3uartist']) && !isset($_REQUEST['m3utitle'])) {
    129. 

  129. 

  130. 	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>';
    131. 

  131. 

  132. }
    133. 

  133. 

  134. 

  135. function WindowsShareSlashTranslate($filename) {
    136. 

  136. 	if (substr($filename, 0, 2) == '//') {
    137. 

  137. 		return str_replace('/', '\\', $filename);
    138. 

  138. 	}
    139. 

  139. 	return $filename;
    140. 

  140. }
    141. 

  141. 

  142. function safe_mysql_query($SQLquery) {
    143. 

  143. 	$result = @mysql_query($SQLquery);
    144. 

  144. 	if (mysql_error()) {
    145. 

  145. 		die('<FONT COLOR="red">'.mysql_error().'</FONT><hr><TT>'.$SQLquery.'</TT>');
    146. 

  146. 	}
    147. 

  147. 	return $result;
    148. 

  148. }
    149. 

  149. 

  150. function mysql_table_exists($tablename) {
    151. 

  151. 	return (bool) mysql_query('DESCRIBE '.$tablename);
    152. 

  152. }
    153. 

  153. 

  154. function AcceptableExtensions($fileformat, $audio_dataformat='', $video_dataformat='') {
    155. 

  155. 	static $AcceptableExtensionsAudio = array();
    156. 

  156. 	if (empty($AcceptableExtensionsAudio)) {
    157. 

  157. 		$AcceptableExtensionsAudio['mp3']['mp3']  = array('mp3');
    158. 

  158. 		$AcceptableExtensionsAudio['mp2']['mp2']  = array('mp2');
    159. 

  159. 		$AcceptableExtensionsAudio['mp1']['mp1']  = array('mp1');
    160. 

  160. 		$AcceptableExtensionsAudio['asf']['asf']  = array('asf');
    161. 

  161. 		$AcceptableExtensionsAudio['asf']['wma']  = array('wma');
    162. 

  162. 		$AcceptableExtensionsAudio['riff']['mp3'] = array('wav');
    163. 

  163. 		$AcceptableExtensionsAudio['riff']['wav'] = array('wav');
    164. 

  164. 	}
    165. 

  165. 	static $AcceptableExtensionsVideo = array();
    166. 

  166. 	if (empty($AcceptableExtensionsVideo)) {
    167. 

  167. 		$AcceptableExtensionsVideo['mp3']['mp3']  = array('mp3');
    168. 

  168. 		$AcceptableExtensionsVideo['mp2']['mp2']  = array('mp2');
    169. 

  169. 		$AcceptableExtensionsVideo['mp1']['mp1']  = array('mp1');
    170. 

  170. 		$AcceptableExtensionsVideo['asf']['asf']  = array('asf');
    171. 

  171. 		$AcceptableExtensionsVideo['asf']['wmv']  = array('wmv');
    172. 

  172. 		$AcceptableExtensionsVideo['gif']['gif']  = array('gif');
    173. 

  173. 		$AcceptableExtensionsVideo['jpg']['jpg']  = array('jpg');
    174. 

  174. 		$AcceptableExtensionsVideo['png']['png']  = array('png');
    175. 

  175. 		$AcceptableExtensionsVideo['bmp']['bmp']  = array('bmp');
    176. 

  176. 	}
    177. 

  177. 	if (!empty($video_dataformat)) {
    178. 

  178. 		return (isset($AcceptableExtensionsVideo[$fileformat][$video_dataformat]) ? $AcceptableExtensionsVideo[$fileformat][$video_dataformat] : array());
    179. 

  179. 	} else {
    180. 

  180. 		return (isset($AcceptableExtensionsAudio[$fileformat][$audio_dataformat]) ? $AcceptableExtensionsAudio[$fileformat][$audio_dataformat] : array());
    181. 

  181. 	}
    182. 

  182. }
    183. 

  183. 

  184. 

  185. if (!empty($_REQUEST['scan'])) {
    186. 

  186. 	if (mysql_table_exists(GETID3_DB_TABLE)) {
    187. 

  187. 		$SQLquery  = 'DROP TABLE `'.GETID3_DB_TABLE.'`';
    188. 

  188. 		safe_mysql_query($SQLquery);
    189. 

  189. 	}
    190. 

  190. }
    191. 

  191. if (!mysql_table_exists(GETID3_DB_TABLE)) {
    192. 

  192. 	$SQLquery  = 'CREATE TABLE `'.GETID3_DB_TABLE.'` (';
    193. 

  193. 	$SQLquery .= ' `ID` mediumint(8) unsigned NOT NULL auto_increment,';
    194. 

  194. 	$SQLquery .= ' `filename` text NOT NULL,';
    195. 

  195. 	$SQLquery .= ' `LastModified` text NOT NULL,';
    196. 

  196. 	$SQLquery .= ' `md5_file` varchar(32) NOT NULL default "",';
    197. 

  197. 	$SQLquery .= ' `md5_data` varchar(32) NOT NULL default "",';
    198. 

  198. 	$SQLquery .= ' `md5_data_source` varchar(32) NOT NULL default "",';
    199. 

  199. 	$SQLquery .= ' `filesize` int(10) unsigned NOT NULL default "0",';
    200. 

  200. 	$SQLquery .= ' `fileformat` varchar(255) NOT NULL default "",';
    201. 

  201. 	$SQLquery .= ' `audio_dataformat` varchar(255) NOT NULL default "",';
    202. 

  202. 	$SQLquery .= ' `video_dataformat` varchar(255) NOT NULL default "",';
    203. 

  203. 	$SQLquery .= ' `audio_bitrate` float NOT NULL default "0",';
    204. 

  204. 	$SQLquery .= ' `video_bitrate` float NOT NULL default "0",';
    205. 

  205. 	$SQLquery .= ' `playtime_seconds` varchar(255) NOT NULL default "",';
    206. 

  206. 	$SQLquery .= ' `tags` varchar(255) NOT NULL default "",';
    207. 

  207. 	$SQLquery .= ' `artist` varchar(255) NOT NULL default "",';
    208. 

  208. 	$SQLquery .= ' `title` varchar(255) NOT NULL default "",';
    209. 

  209. 	$SQLquery .= ' `remix` varchar(255) NOT NULL default "",';
    210. 

  210. 	$SQLquery .= ' `album` varchar(255) NOT NULL default "",';
    211. 

  211. 	$SQLquery .= ' `genre` varchar(255) NOT NULL default "",';
    212. 

  212. 	$SQLquery .= ' `comment` varchar(255) NOT NULL default "",';
    213. 

  213. 	$SQLquery .= ' `track` varchar(7) NOT NULL default "",';
    214. 

  214. 	$SQLquery .= ' `comments_all` text NOT NULL,';
    215. 

  215. 	$SQLquery .= ' `comments_id3v2` text NOT NULL,';
    216. 

  216. 	$SQLquery .= ' `comments_ape` text NOT NULL,';
    217. 

  217. 	$SQLquery .= ' `comments_lyrics3` text NOT NULL,';
    218. 

  218. 	$SQLquery .= ' `comments_id3v1` text NOT NULL,';
    219. 

  219. 	$SQLquery .= ' `warning` text NOT NULL,';
    220. 

  220. 	$SQLquery .= ' `error` text NOT NULL,';
    221. 

  221. 	$SQLquery .= ' `track_volume` float NOT NULL default "0",';
    222. 

  222. 	$SQLquery .= ' `encoder_options` varchar(255) NOT NULL default "",';
    223. 

  223. 	$SQLquery .= ' `vbr_method` varchar(255) NOT NULL default "",';
    224. 

  224. 	$SQLquery .= ' PRIMARY KEY (`ID`)';
    225. 

  225. 	$SQLquery .= ') TYPE=MyISAM;';
    226. 

  226. 

  227. 	safe_mysql_query($SQLquery);
    228. 

  228. }
    229. 

  229. 

  230. $ExistingTableFields = array();
    231. 

  231. $result = mysql_query('DESCRIBE `'.GETID3_DB_TABLE.'`');
    232. 

  232. while ($row = mysql_fetch_array($result)) {
    233. 

  233. 	$ExistingTableFields[$row['Field']] = $row;
    234. 

  234. }
    235. 

  235. if (!isset($ExistingTableFields['encoder_options'])) { // Added in 1.7.0b2
    236. 

  236. 	echo '<b>adding field `encoder_options`</b><br>';
    237. 

  237. 	mysql_query('ALTER TABLE `'.GETID3_DB_TABLE.'` ADD `encoder_options` VARCHAR(255) DEFAULT "" NOT NULL AFTER `error`');
    238. 

  238. 	mysql_query('OPTIMIZE TABLE `'.GETID3_DB_TABLE.'`');
    239. 

  239. }
    240. 

  240. if (isset($ExistingTableFields['track']) && ($ExistingTableFields['track']['Type'] != 'varchar(7)')) { // Changed in 1.7.0b2
    241. 

  241. 	echo '<b>changing field `track` to VARCHAR(7)</b><br>';
    242. 

  242. 	mysql_query('ALTER TABLE `'.GETID3_DB_TABLE.'` CHANGE `track` `track` VARCHAR(7) DEFAULT "" NOT NULL');
    243. 

  243. 	mysql_query('OPTIMIZE TABLE `'.GETID3_DB_TABLE.'`');
    244. 

  244. }
    245. 

  245. if (!isset($ExistingTableFields['track_volume'])) { // Added in 1.7.0b5
    246. 

  246. 	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>';
    247. 

  247. 	echo '<b>adding field `track_volume`</b><br>';
    248. 

  248. 	mysql_query('ALTER TABLE `'.GETID3_DB_TABLE.'` ADD `track_volume` FLOAT NOT NULL AFTER `error`');
    249. 

  249. 	mysql_query('OPTIMIZE TABLE `'.GETID3_DB_TABLE.'`');
    250. 

  250. }
    251. 

  251. if (!isset($ExistingTableFields['remix'])) { // Added in 1.7.3b1
    252. 

  252. 	echo '<b>adding field `encoder_options`, `alternate_name`, `parody`</b><br>';
    253. 

  253. 	mysql_query('ALTER TABLE `'.GETID3_DB_TABLE.'` ADD `remix` VARCHAR(255) DEFAULT "" NOT NULL AFTER `title`');
    254. 

  254. 	mysql_query('ALTER TABLE `'.GETID3_DB_TABLE.'` ADD `alternate_name` VARCHAR(255) DEFAULT "" NOT NULL AFTER `track`');
    255. 

  255. 	mysql_query('ALTER TABLE `'.GETID3_DB_TABLE.'` ADD `parody` VARCHAR(255) DEFAULT "" NOT NULL AFTER `alternate_name`');
    256. 

  256. 	mysql_query('OPTIMIZE TABLE `'.GETID3_DB_TABLE.'`');
    257. 

  257. }
    258. 

  258. 

  259. 

  260. function SynchronizeAllTags($filename, $synchronizefrom='all', $synchronizeto='A12', &$errors) {
    261. 

  261. 	global $getID3;
    262. 

  262. 

  263. 	set_time_limit(30);
    264. 

  264. 

  265. 	$ThisFileInfo = $getID3->analyze($filename);
    266. 

  266. 	getid3_lib::CopyTagsToComments($ThisFileInfo);
    267. 

  267. 

  268. 	if ($synchronizefrom == 'all') {
    269. 

  269. 		$SourceArray = @$ThisFileInfo['comments'];
    270. 

  270. 	} elseif (!empty($ThisFileInfo['tags'][$synchronizefrom])) {
    271. 

  271. 		$SourceArray = @$ThisFileInfo['tags'][$synchronizefrom];
    272. 

  272. 	} else {
    273. 

  273. 		die('ERROR: $ThisFileInfo[tags]['.$synchronizefrom.'] does not exist');
    274. 

  274. 	}
    275. 

  275. 

  276. 	$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    277. 

  277. 	$SQLquery .= ' WHERE (`filename` = "'.mysql_escape_string($filename).'")';
    278. 

  278. 	safe_mysql_query($SQLquery);
    279. 

  279. 

  280. 

  281. 	$TagFormatsToWrite = array();
    282. 

  282. 	if ((strpos($synchronizeto, '2') !== false) && ($synchronizefrom != 'id3v2')) {
    283. 

  283. 		$TagFormatsToWrite[] = 'id3v2.3';
    284. 

  284. 	}
    285. 

  285. 	if ((strpos($synchronizeto, 'A') !== false) && ($synchronizefrom != 'ape')) {
    286. 

  286. 		$TagFormatsToWrite[] = 'ape';
    287. 

  287. 	}
    288. 

  288. 	if ((strpos($synchronizeto, 'L') !== false) && ($synchronizefrom != 'lyrics3')) {
    289. 

  289. 		$TagFormatsToWrite[] = 'lyrics3';
    290. 

  290. 	}
    291. 

  291. 	if ((strpos($synchronizeto, '1') !== false) && ($synchronizefrom != 'id3v1')) {
    292. 

  292. 		$TagFormatsToWrite[] = 'id3v1';
    293. 

  293. 	}
    294. 

  294. 

  295. 	getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'write.php', __FILE__, true);
    296. 

  296. 	$tagwriter = new getid3_writetags;
    297. 

  297. 	$tagwriter->filename       = $filename;
    298. 

  298. 	$tagwriter->tagformats     = $TagFormatsToWrite;
    299. 

  299. 	$tagwriter->overwrite_tags = true;
    300. 

  300. 	$tagwriter->tag_encoding   = $getID3->encoding;
    301. 

  301. 	$tagwriter->tag_data       = $SourceArray;
    302. 

  302. 

  303. 	if ($tagwriter->WriteTags()) {
    304. 

  304. 		$errors = $tagwriter->errors;
    305. 

  305. 		return true;
    306. 

  306. 	}
    307. 

  307. 	$errors = $tagwriter->errors;
    308. 

  308. 	return false;
    309. 

  309. }
    310. 

  310. 

  311. $IgnoreNoTagFormats = array('', 'png', 'jpg', 'gif', 'bmp', 'swf', 'zip', 'mid', 'mod', 'xm', 'it', 's3m');
    312. 

  312. 

  313. if (!empty($_REQUEST['scan']) || !empty($_REQUEST['newscan']) || !empty($_REQUEST['rescanerrors'])) {
    314. 

  314. 

  315. 	$SQLquery  = 'DELETE from `'.GETID3_DB_TABLE.'`';
    316. 

  316. 	$SQLquery .= ' WHERE (`fileformat` = "")';
    317. 

  317. 	safe_mysql_query($SQLquery);
    318. 

  318. 

  319. 	$FilesInDir = array();
    320. 

  320. 

  321. 	if (!empty($_REQUEST['rescanerrors'])) {
    322. 

  322. 

  323. 		echo '<a href="'.$_SERVER['PHP_SELF'].'">abort</a><hr>';
    324. 

  324. 

  325. 		echo 'Re-scanning all media files already in database that had errors and/or warnings in last scan<hr>';
    326. 

  326. 

  327. 		$SQLquery  = 'SELECT `filename`';
    328. 

  328. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    329. 

  329. 		$SQLquery .= ' WHERE (`error` <> "")';
    330. 

  330. 		$SQLquery .= ' OR (`warning` <> "")';
    331. 

  331. 		$SQLquery .= ' ORDER BY `filename` ASC';
    332. 

  332. 		$result = safe_mysql_query($SQLquery);
    333. 

  333. 		while ($row = mysql_fetch_array($result)) {
    334. 

  334. 

  335. 			if (!file_exists($row['filename'])) {
    336. 

  336. 				echo '<b>File missing: '.$row['filename'].'</b><br>';
    337. 

  337. 				$SQLquery = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    338. 

  338. 				$SQLquery .= ' WHERE (`filename` = "'.mysql_escape_string($row['filename']).'")';
    339. 

  339. 				safe_mysql_query($SQLquery);
    340. 

  340. 			} else {
    341. 

  341. 				$FilesInDir[] = $row['filename'];
    342. 

  342. 			}
    343. 

  343. 

  344. 		}
    345. 

  345. 

  346. 	} elseif (!empty($_REQUEST['scan']) || !empty($_REQUEST['newscan'])) {
    347. 

  347. 

  348. 		echo '<a href="'.$_SERVER['PHP_SELF'].'">abort</a><hr>';
    349. 

  349. 

  350. 		echo 'Scanning all media files in <b>'.str_replace('\\', '/', realpath(!empty($_REQUEST['scan']) ? $_REQUEST['scan'] : $_REQUEST['newscan'])).'</b> (and subdirectories)<hr>';
    351. 

  351. 

  352. 		$SQLquery  = 'SELECT COUNT(*) AS `num`, `filename`';
    353. 

  353. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    354. 

  354. 		$SQLquery .= ' GROUP BY `filename`';
    355. 

  355. 		$SQLquery .= ' ORDER BY `num` DESC';
    356. 

  356. 		$result = safe_mysql_query($SQLquery);
    357. 

  357. 		$DupesDeleted = 0;
    358. 

  358. 		while ($row = mysql_fetch_array($result)) {
    359. 

  359. 			set_time_limit(30);
    360. 

  360. 			if ($row['num'] <= 1) {
    361. 

  361. 				break;
    362. 

  362. 			}
    363. 

  363. 			$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    364. 

  364. 			$SQLquery .= ' WHERE `filename` LIKE "'.mysql_escape_string($row['filename']).'"';
    365. 

  365. 			safe_mysql_query($SQLquery);
    366. 

  366. 			$DupesDeleted++;
    367. 

  367. 		}
    368. 

  368. 		if ($DupesDeleted > 0) {
    369. 

  369. 			echo 'Deleted <b>'.number_format($DupesDeleted).'</b> duplicate filenames<hr>';
    370. 

  370. 		}
    371. 

  371. 

  372. 		if (!empty($_REQUEST['newscan'])) {
    373. 

  373. 			$AlreadyInDatabase = array();
    374. 

  374. 			set_time_limit(60);
    375. 

  375. 			$SQLquery  = 'SELECT `filename`';
    376. 

  376. 			$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    377. 

  377. 			$SQLquery .= ' ORDER BY `filename` ASC';
    378. 

  378. 			$result = safe_mysql_query($SQLquery);
    379. 

  379. 			while ($row = mysql_fetch_array($result)) {
    380. 

  380. 				//$AlreadyInDatabase[] = strtolower($row['filename']);
    381. 

  381. 				$AlreadyInDatabase[] = $row['filename'];
    382. 

  382. 			}
    383. 

  383. 		}
    384. 

  384. 

  385. 		$DirectoriesToScan  = array(@$_REQUEST['scan'] ? $_REQUEST['scan'] : $_REQUEST['newscan']);
    386. 

  386. 		$DirectoriesScanned = array();
    387. 

  387. 		while (count($DirectoriesToScan) > 0) {
    388. 

  388. 			foreach ($DirectoriesToScan as $DirectoryKey => $startingdir) {
    389. 

  389. 				if ($dir = opendir($startingdir)) {
    390. 

  390. 					set_time_limit(30);
    391. 

  391. 					echo '<b>'.str_replace('\\', '/', $startingdir).'</b><br>';
    392. 

  392. 					flush();
    393. 

  393. 					while (($file = readdir($dir)) !== false) {
    394. 

  394. 						if (($file != '.') && ($file != '..')) {
    395. 

  395. 							$RealPathName = realpath($startingdir.'/'.$file);
    396. 

  396. 							if (is_dir($RealPathName)) {
    397. 

  397. 								if (!in_array($RealPathName, $DirectoriesScanned) && !in_array($RealPathName, $DirectoriesToScan)) {
    398. 

  398. 									$DirectoriesToScan[] = $RealPathName;
    399. 

  399. 								}
    400. 

  400. 							} else if (is_file($RealPathName)) {
    401. 

  401. 								if (!empty($_REQUEST['newscan'])) {
    402. 

  402. 									if (!in_array(str_replace('\\', '/', $RealPathName), $AlreadyInDatabase)) {
    403. 

  403. 										$FilesInDir[] = $RealPathName;
    404. 

  404. 									}
    405. 

  405. 								} elseif (!empty($_REQUEST['scan'])) {
    406. 

  406. 									$FilesInDir[] = $RealPathName;
    407. 

  407. 								}
    408. 

  408. 							}
    409. 

  409. 						}
    410. 

  410. 					}
    411. 

  411. 					closedir($dir);
    412. 

  412. 				} else {
    413. 

  413. 					echo '<FONT COLOR="RED">Failed to open directory "<b>'.$startingdir.'</b>"</FONT><br><br>';
    414. 

  414. 				}
    415. 

  415. 				$DirectoriesScanned[] = $startingdir;
    416. 

  416. 				unset($DirectoriesToScan[$DirectoryKey]);
    417. 

  417. 			}
    418. 

  418. 		}
    419. 

  419. 		echo '<i>List of files to scan complete (added '.number_format(count($FilesInDir)).' files to scan)</i><hr>';
    420. 

  420. 		flush();
    421. 

  421. 	}
    422. 

  422. 

  423. 	$FilesInDir = array_unique($FilesInDir);
    424. 

  424. 	sort($FilesInDir);
    425. 

  425. 

  426. 	$starttime = time();
    427. 

  427. 	$rowcounter = 0;
    428. 

  428. 	$totaltoprocess = count($FilesInDir);
    429. 

  429. 

  430. 	foreach ($FilesInDir as $filename) {
    431. 

  431. 		set_time_limit(300);
    432. 

  432. 

  433. 		echo '<br>'.date('H:i:s').' ['.number_format(++$rowcounter).' / '.number_format($totaltoprocess).'] '.str_replace('\\', '/', $filename);
    434. 

  434. 

  435. 		$ThisFileInfo = $getID3->analyze($filename);
    436. 

  436. 		getid3_lib::CopyTagsToComments($ThisFileInfo);
    437. 

  437. 

  438. 		if (file_exists($filename)) {
    439. 

  439. 			$ThisFileInfo['file_modified_time'] = filemtime($filename);
    440. 

  440. 			$ThisFileInfo['md5_file']           = ($getid3_demo_mysql_md5_file ? md5_file($filename) : '');
    441. 

  441. 		}
    442. 

  442. 

  443. 		if (empty($ThisFileInfo['fileformat'])) {
    444. 

  444. 

  445. 			echo ' (<span style="color: #990099;">unknown file type</span>)';
    446. 

  446. 

  447. 		} else {
    448. 

  448. 

  449. 			if (!empty($ThisFileInfo['error'])) {
    450. 

  450. 				echo ' (<span style="color: #FF0000;">errors</span>)';
    451. 

  451. 			} elseif (!empty($ThisFileInfo['warning'])) {
    452. 

  452. 				echo ' (<span style="color: #FF9999;">warnings</span>)';
    453. 

  453. 			} else {
    454. 

  454. 				echo ' (<span style="color: #009900;">OK</span>)';
    455. 

  455. 			}
    456. 

  456. 

  457. 			$this_track_track = '';
    458. 

  458. 			if (!empty($ThisFileInfo['comments']['track'])) {
    459. 

  459. 				foreach ($ThisFileInfo['comments']['track'] as $key => $value) {
    460. 

  460. 					if (strlen($value) > strlen($this_track_track)) {
    461. 

  461. 						$this_track_track = str_pad($value, 2, '0', STR_PAD_LEFT);
    462. 

  462. 					}
    463. 

  463. 				}
    464. 

  464. 				if (ereg('^([0-9]+)/([0-9]+)$', $this_track_track, $matches)) {
    465. 

  465. 					// change "1/5"->"01/05", "3/12"->"03/12", etc
    466. 

  466. 					$this_track_track = str_pad($matches[1], 2, '0', STR_PAD_LEFT).'/'.str_pad($matches[2], 2, '0', STR_PAD_LEFT);
    467. 

  467. 				}
    468. 

  468. 			}
    469. 

  469. 

  470. 			$this_track_remix = '';
    471. 

  471. 			$this_track_title = '';
    472. 

  472. 			if (!empty($ThisFileInfo['comments']['title'])) {
    473. 

  473. 				foreach ($ThisFileInfo['comments']['title'] as $possible_title) {
    474. 

  474. 					if (strlen($possible_title) > strlen($this_track_title)) {
    475. 

  475. 						$this_track_title = $possible_title;
    476. 

  476. 					}
    477. 

  477. 				}
    478. 

  478. 			}
    479. 

  479. 

  480. 			$ParenthesesPairs = array('()', '[]', '{}');
    481. 

  481. 			foreach ($ParenthesesPairs as $pair) {
    482. 

  482. 				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)) {
    483. 

  483. 					$this_track_title = $matches[1][0];
    484. 

  484. 					$this_track_remix = implode("\t", $matches[2]);
    485. 

  485. 				}
    486. 

  486. 			}
    487. 

  487. 

  488. 

  489. 

  490. 			if (!empty($_REQUEST['rescanerrors'])) {
    491. 

  491. 

  492. 				$SQLquery  = 'UPDATE `'.GETID3_DB_TABLE.'` SET ';
    493. 

  493. 				$SQLquery .= '`LastModified` = "'.mysql_escape_string(@$ThisFileInfo['file_modified_time']).'", ';
    494. 

  494. 				$SQLquery .= '`md5_file` = "'.mysql_escape_string(@$ThisFileInfo['md5_file']).'", ';
    495. 

  495. 				$SQLquery .= '`md5_data` = "'.mysql_escape_string(@$ThisFileInfo['md5_data']).'", ';
    496. 

  496. 				$SQLquery .= '`md5_data_source` = "'.mysql_escape_string(@$ThisFileInfo['md5_data_source']).'", ';
    497. 

  497. 				$SQLquery .= '`filesize` = "'.mysql_escape_string(@$ThisFileInfo['filesize']).'", ';
    498. 

  498. 				$SQLquery .= '`fileformat` = "'.mysql_escape_string(@$ThisFileInfo['fileformat']).'", ';
    499. 

  499. 				$SQLquery .= '`audio_dataformat` = "'.mysql_escape_string(@$ThisFileInfo['audio']['dataformat']).'", ';
    500. 

  500. 				$SQLquery .= '`video_dataformat` = "'.mysql_escape_string(@$ThisFileInfo['video']['dataformat']).'", ';
    501. 

  501. 				$SQLquery .= '`audio_bitrate` = "'.mysql_escape_string(@$ThisFileInfo['audio']['bitrate']).'", ';
    502. 

  502. 				$SQLquery .= '`video_bitrate` = "'.mysql_escape_string(@$ThisFileInfo['video']['bitrate']).'", ';
    503. 

  503. 				$SQLquery .= '`playtime_seconds` = "'.mysql_escape_string(@$ThisFileInfo['playtime_seconds']).'", ';
    504. 

  504. 				$SQLquery .= '`tags` = "'.mysql_escape_string(@implode("\t", @array_keys(@$ThisFileInfo['tags']))).'", ';
    505. 

  505. 				$SQLquery .= '`artist` = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['artist'])).'", ';
    506. 

  506. 

  507. 				$SQLquery .= '`title` = "'.mysql_escape_string($this_track_title).'", ';
    508. 

  508. 				$SQLquery .= '`remix` = "'.mysql_escape_string($this_track_remix).'", ';
    509. 

  509. 

  510. 				$SQLquery .= '`album` = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['album'])).'", ';
    511. 

  511. 				$SQLquery .= '`genre` = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['genre'])).'", ';
    512. 

  512. 				$SQLquery .= '`comment` = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['comment'])).'", ';
    513. 

  513. 

  514. 				$SQLquery .= '`track` = "'.mysql_escape_string($this_track_track).'", ';
    515. 

  515. 

  516. 				$SQLquery .= '`comments_all` = "'.mysql_escape_string(@serialize(@$ThisFileInfo['comments'])).'", ';
    517. 

  517. 				$SQLquery .= '`comments_id3v2` = "'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['id3v2'])).'", ';
    518. 

  518. 				$SQLquery .= '`comments_ape` = "'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['ape'])).'", ';
    519. 

  519. 				$SQLquery .= '`comments_lyrics3` = "'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['lyrics3'])).'", ';
    520. 

  520. 				$SQLquery .= '`comments_id3v1` = "'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['id3v1'])).'", ';
    521. 

  521. 				$SQLquery .= '`warning` = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['warning'])).'", ';
    522. 

  522. 				$SQLquery .= '`error` = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['error'])).'", ';
    523. 

  523. 				$SQLquery .= '`encoder_options` = "'.mysql_escape_string(trim(@$ThisFileInfo['audio']['encoder'].' '.@$ThisFileInfo['audio']['encoder_options'])).'", ';
    524. 

  524. 				$SQLquery .= '`vbr_method` = "'.mysql_escape_string(@$ThisFileInfo['mpeg']['audio']['VBR_method']).'", ';
    525. 

  525. 				$SQLquery .= '`track_volume` = "'.mysql_escape_string(@$ThisFileInfo['replay_gain']['track']['volume']).'" ';
    526. 

  526. 				$SQLquery .= 'WHERE (`filename` = "'.mysql_escape_string(@$ThisFileInfo['filenamepath']).'")';
    527. 

  527. 

  528. 			} elseif (!empty($_REQUEST['scan']) || !empty($_REQUEST['newscan'])) {
    529. 

  529. 

  530. 				$SQLquery  = 'INSERT INTO `'.GETID3_DB_TABLE.'` (`filename`, `LastModified`, `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 (';
    531. 

  531. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['filenamepath']).'", ';
    532. 

  532. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['file_modified_time']).'", ';
    533. 

  533. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['md5_file']).'", ';
    534. 

  534. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['md5_data']).'", ';
    535. 

  535. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['md5_data_source']).'", ';
    536. 

  536. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['filesize']).'", ';
    537. 

  537. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['fileformat']).'", ';
    538. 

  538. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['audio']['dataformat']).'", ';
    539. 

  539. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['video']['dataformat']).'", ';
    540. 

  540. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['audio']['bitrate']).'", ';
    541. 

  541. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['video']['bitrate']).'", ';
    542. 

  542. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['playtime_seconds']).'", ';
    543. 

  543. 				$SQLquery .= '"'.mysql_escape_string(@implode("\t", @array_keys(@$ThisFileInfo['tags']))).'", ';
    544. 

  544. 				$SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['artist'])).'", ';
    545. 

  545. 

  546. 				$SQLquery .= '"'.mysql_escape_string($this_track_title).'", ';
    547. 

  547. 				$SQLquery .= '"'.mysql_escape_string($this_track_remix).'", ';
    548. 

  548. 

  549. 				$SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['album'])).'", ';
    550. 

  550. 				$SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['genre'])).'", ';
    551. 

  551. 				$SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['comment'])).'", ';
    552. 

  552. 

  553. 				$SQLquery .= '"'.mysql_escape_string($this_track_track).'", ';
    554. 

  554. 

  555. 				$SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['comments'])).'", ';
    556. 

  556. 				$SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['id3v2'])).'", ';
    557. 

  557. 				$SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['ape'])).'", ';
    558. 

  558. 				$SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['lyrics3'])).'", ';
    559. 

  559. 				$SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['id3v1'])).'", ';
    560. 

  560. 				$SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['warning'])).'", ';
    561. 

  561. 				$SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['error'])).'", ';
    562. 

  562. 				$SQLquery .= '"'.mysql_escape_string(trim(@$ThisFileInfo['audio']['encoder'].' '.@$ThisFileInfo['audio']['encoder_options'])).'", ';
    563. 

  563. 				$SQLquery .= '"'.mysql_escape_string(!empty($ThisFileInfo['mpeg']['audio']['LAME']) ? 'LAME' : @$ThisFileInfo['mpeg']['audio']['VBR_method']).'", ';
    564. 

  564. 				$SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['replay_gain']['track']['volume']).'")';
    565. 

  565. 

  566. 			}
    567. 

  567. 			flush();
    568. 

  568. 			safe_mysql_query($SQLquery);
    569. 

  569. 		}
    570. 

  570. 

  571. 	}
    572. 

  572. 

  573. 	$SQLquery = 'OPTIMIZE TABLE `'.GETID3_DB_TABLE.'`';
    574. 

  574. 	safe_mysql_query($SQLquery);
    575. 

  575. 

  576. 	echo '<hr>Done scanning!<hr>';
    577. 

  577. 

  578. } elseif (!empty($_REQUEST['missingtrackvolume'])) {
    579. 

  579. 

  580. 	$MissingTrackVolumeFilesScanned  = 0;
    581. 

  581. 	$MissingTrackVolumeFilesAdjusted = 0;
    582. 

  582. 	$MissingTrackVolumeFilesDeleted  = 0;
    583. 

  583. 	$SQLquery  = 'SELECT `filename`';
    584. 

  584. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    585. 

  585. 	$SQLquery .= ' WHERE (`track_volume` = "0")';
    586. 

  586. 	$SQLquery .= ' AND (`audio_bitrate` > "0")';
    587. 

  587. 	$result = safe_mysql_query($SQLquery);
    588. 

  588. 	echo 'Scanning <span ID="missingtrackvolumeNowScanning">0</span> / '.number_format(mysql_num_rows($result)).' files for track volume information:<hr>';
    589. 

  589. 	while ($row = mysql_fetch_array($result)) {
    590. 

  590. 		set_time_limit(30);
    591. 

  591. 		echo '<script>if (document.getElementById("missingtrackvolumeNowScanning")) document.getElementById("missingtrackvolumeNowScanning").innerHTML = "'.number_format($MissingTrackVolumeFilesScanned++).'";</script>. ';
    592. 

  592. 		flush();
    593. 

  593. 		if (file_exists($row['filename'])) {
    594. 

  594. 

  595. 			$ThisFileInfo = $getID3->analyze($row['filename']);
    596. 

  596. 			if (!empty($ThisFileInfo['replay_gain']['track']['volume'])) {
    597. 

  597. 				$MissingTrackVolumeFilesAdjusted++;
    598. 

  598. 				$SQLquery  = 'UPDATE `'.GETID3_DB_TABLE.'`';
    599. 

  599. 				$SQLquery .= ' SET `track_volume` = "'.$ThisFileInfo['replay_gain']['track']['volume'].'"';
    600. 

  600. 				$SQLquery .= ' WHERE (`filename` = "'.mysql_escape_string($row['filename']).'")';
    601. 

  601. 				safe_mysql_query($SQLquery);
    602. 

  602. 			}
    603. 

  603. 

  604. 		} else {
    605. 

  605. 

  606. 			$MissingTrackVolumeFilesDeleted++;
    607. 

  607. 			$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    608. 

  608. 			$SQLquery .= ' WHERE (`filename` = "'.mysql_escape_string($row['filename']).'")';
    609. 

  609. 			safe_mysql_query($SQLquery);
    610. 

  610. 

  611. 		}
    612. 

  612. 	}
    613. 

  613. 	echo '<hr>Scanned '.number_format($MissingTrackVolumeFilesScanned).' files with no track volume information.<br>';
    614. 

  614. 	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>';
    615. 

  615. 

  616. } elseif (!empty($_REQUEST['deadfilescheck'])) {
    617. 

  617. 

  618. 	$SQLquery  = 'SELECT COUNT(*) AS `num`, `filename`';
    619. 

  619. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    620. 

  620. 	$SQLquery .= ' GROUP BY `filename`';
    621. 

  621. 	$SQLquery .= ' ORDER BY `num` DESC';
    622. 

  622. 	$result = safe_mysql_query($SQLquery);
    623. 

  623. 	$DupesDeleted = 0;
    624. 

  624. 	while ($row = mysql_fetch_array($result)) {
    625. 

  625. 		set_time_limit(30);
    626. 

  626. 		if ($row['num'] <= 1) {
    627. 

  627. 			break;
    628. 

  628. 		}
    629. 

  629. 		echo '<br>'.FixTextFields($row['filename']).' (<font color="#FF9999">duplicate</font>)';
    630. 

  630. 		$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    631. 

  631. 		$SQLquery .= ' WHERE `filename` LIKE "'.mysql_escape_string($row['filename']).'"';
    632. 

  632. 		safe_mysql_query($SQLquery);
    633. 

  633. 		$DupesDeleted++;
    634. 

  634. 	}
    635. 

  635. 	if ($DupesDeleted > 0) {
    636. 

  636. 		echo '<hr>Deleted <b>'.number_format($DupesDeleted).'</b> duplicate filenames<hr>';
    637. 

  637. 	}
    638. 

  638. 

  639. 	$SQLquery  = 'SELECT `filename`, `filesize`, `LastModified`';
    640. 

  640. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    641. 

  641. 	$SQLquery .= ' ORDER BY `filename` ASC';
    642. 

  642. 	$result = safe_mysql_query($SQLquery);
    643. 

  643. 	$totalchecked = 0;
    644. 

  644. 	$totalremoved = 0;
    645. 

  645. 	$previousdir = '';
    646. 

  646. 	while ($row = mysql_fetch_array($result)) {
    647. 

  647. 		$totalchecked++;
    648. 

  648. 		set_time_limit(30);
    649. 

  649. 		$reason = '';
    650. 

  650. 		if (!file_exists($row['filename'])) {
    651. 

  651. 			$reason = 'deleted';
    652. 

  652. 		} elseif (filesize($row['filename']) != $row['filesize']) {
    653. 

  653. 			$reason = 'filesize changed';
    654. 

  654. 		} elseif (filemtime($row['filename']) != $row['LastModified']) {
    655. 

  655. 			if (abs(filemtime($row['filename']) - $row['LastModified']) != 3600) {
    656. 

  656. 				// off by exactly one hour == daylight savings time
    657. 

  657. 				$reason = 'last-modified time changed';
    658. 

  658. 			}
    659. 

  659. 		}
    660. 

  660. 

  661. 		$thisdir = dirname($row['filename']);
    662. 

  662. 		if ($reason) {
    663. 

  663. 

  664. 			$totalremoved++;
    665. 

  665. 			echo '<br>'.FixTextFields($row['filename']).' (<font color="#FF9999">'.$reason.'</font>)';
    666. 

  666. 			flush();
    667. 

  667. 			$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    668. 

  668. 			$SQLquery .= ' WHERE (`filename` = "'.mysql_escape_string($row['filename']).'")';
    669. 

  669. 			safe_mysql_query($SQLquery);
    670. 

  670. 

  671. 		} elseif ($thisdir != $previousdir) {
    672. 

  672. 

  673. 			echo '. ';
    674. 

  674. 			flush();
    675. 

  675. 

  676. 		}
    677. 

  677. 		$previousdir = $thisdir;
    678. 

  678. 	}
    679. 

  679. 

  680. 	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>';
    681. 

  681. 

  682. } elseif (!empty($_REQUEST['encodedbydistribution'])) {
    683. 

  683. 

  684. 	if (!empty($_REQUEST['m3u'])) {
    685. 

  685. 

  686. 		header('Content-type: audio/x-mpegurl');
    687. 

  687. 		echo '#EXTM3U'."\n";
    688. 

  688. 

  689. 		$SQLquery  = 'SELECT `filename`, `comments_id3v2`';
    690. 

  690. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    691. 

  691. 		$SQLquery .= ' WHERE (`encoder_options` = "'.mysql_escape_string($_REQUEST['encodedbydistribution']).'")';
    692. 

  692. 		$result = mysql_query($SQLquery);
    693. 

  693. 		$NonBlankEncodedBy = '';
    694. 

  694. 		$BlankEncodedBy = '';
    695. 

  695. 		while ($row = mysql_fetch_array($result)) {
    696. 

  696. 			set_time_limit(30);
    697. 

  697. 			$CommentArray = unserialize($row['comments_id3v2']);
    698. 

  698. 			if (isset($CommentArray['encoded_by'][0])) {
    699. 

  699. 				$NonBlankEncodedBy .= WindowsShareSlashTranslate($row['filename'])."\n";
    700. 

  700. 			} else {
    701. 

  701. 				$BlankEncodedBy    .= WindowsShareSlashTranslate($row['filename'])."\n";
    702. 

  702. 			}
    703. 

  703. 		}
    704. 

  704. 		echo $NonBlankEncodedBy;
    705. 

  705. 		echo $BlankEncodedBy;
    706. 

  706. 		exit;
    707. 

  707. 

  708. 	} elseif (!empty($_REQUEST['showfiles'])) {
    709. 

  709. 

  710. 		echo '<a href="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%').'">show all</a><br>';
    711. 

  711. 		echo '<table border="1">';
    712. 

  712. 

  713. 		$SQLquery  = 'SELECT `filename`, `comments_id3v2`';
    714. 

  714. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    715. 

  715. 		$result = mysql_query($SQLquery);
    716. 

  716. 		while ($row = mysql_fetch_array($result)) {
    717. 

  717. 			set_time_limit(30);
    718. 

  718. 			$CommentArray = unserialize($row['comments_id3v2']);
    719. 

  719. 			if (($_REQUEST['encodedbydistribution'] == '%') || (!empty($CommentArray['encoded_by'][0]) && ($_REQUEST['encodedbydistribution'] == $CommentArray['encoded_by'][0]))) {
    720. 

  720. 				echo '<tr><td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</a></td>';
    721. 

  721. 				echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td></tr>';
    722. 

  722. 			}
    723. 

  723. 		}
    724. 

  724. 		echo '</table>';
    725. 

  725. 

  726. 	} else {
    727. 

  727. 

  728. 		$SQLquery  = 'SELECT `encoder_options`, `comments_id3v2`';
    729. 

  729. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    730. 

  730. 		$SQLquery .= ' ORDER BY (`encoder_options` LIKE "LAME%") DESC, (`encoder_options` LIKE "CBR%") DESC';
    731. 

  731. 		$result = mysql_query($SQLquery);
    732. 

  732. 		$EncodedBy = array();
    733. 

  733. 		while ($row = mysql_fetch_array($result)) {
    734. 

  734. 			set_time_limit(30);
    735. 

  735. 			$CommentArray = unserialize($row['comments_id3v2']);
    736. 

  736. 			if (isset($EncodedBy[$row['encoder_options']][@$CommentArray['encoded_by'][0]])) {
    737. 

  737. 				$EncodedBy[$row['encoder_options']][@$CommentArray['encoded_by'][0]]++;
    738. 

  738. 			} else {
    739. 

  739. 				$EncodedBy[$row['encoder_options']][@$CommentArray['encoded_by'][0]] = 1;
    740. 

  740. 			}
    741. 

  741. 		}
    742. 

  742. 		echo '<a href="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%').'&m3u=1">.m3u version</a><br>';
    743. 

  743. 		echo '<table border="1"><tr><th>m3u</th><th>Encoder Options</th><th>Encoded By (ID3v2)</th></tr>';
    744. 

  744. 		foreach ($EncodedBy as $key => $value) {
    745. 

  745. 			echo '<tr><TD VALIGN="TOP"><a href="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode($key).'&showfiles=1&m3u=1">m3u</a></td>';
    746. 

  746. 			echo '<TD VALIGN="TOP"><b>'.$key.'</b></td>';
    747. 

  747. 			echo '<td><table border="0" WIDTH="100%">';
    748. 

  748. 			arsort($value);
    749. 

  749. 			foreach ($value as $string => $count) {
    750. 

  750. 				echo '<tr><TD ALIGN="RIGHT" WIDTH="50"><i>'.number_format($count).'</i></td><td>&nbsp;</td>';
    751. 

  751. 				echo '<td><a href="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode($string).'&showfiles=1">'.$string.'</a></td></tr>';
    752. 

  752. 			}
    753. 

  753. 			echo '</table></td></tr>';
    754. 

  754. 		}
    755. 

  755. 		echo '</table>';
    756. 

  756. 

  757. 	}
    758. 

  758. 

  759. } elseif (!empty($_REQUEST['audiobitrates'])) {
    760. 

  760. 

  761. 	getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.audio.mp3.php', __FILE__, true);
    762. 

  762. 	$BitrateDistribution = array();
    763. 

  763. 	$SQLquery  = 'SELECT ROUND(audio_bitrate / 1000) AS `RoundBitrate`, COUNT(*) AS `num`';
    764. 

  764. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    765. 

  765. 	$SQLquery .= ' WHERE (`audio_bitrate` > 0)';
    766. 

  766. 	$SQLquery .= ' GROUP BY `RoundBitrate`';
    767. 

  767. 	$result = safe_mysql_query($SQLquery);
    768. 

  768. 	while ($row = mysql_fetch_array($result)) {
    769. 

  769. 		@$BitrateDistribution[getid3_mp3::ClosestStandardMP3Bitrate($row['RoundBitrate'] * 1000)] += $row['num'];  // safe_inc
    770. 

  770. 	}
    771. 

  771. 

  772. 	echo '<table border="1" cellspacing="0" cellpadding="3">';
    773. 

  773. 	echo '<tr><th>Bitrate</th><th>Count</th></tr>';
    774. 

  774. 	foreach ($BitrateDistribution as $Bitrate => $Count) {
    775. 

  775. 		echo '<tr>';
    776. 

  776. 		echo '<TD ALIGN="RIGHT">'.round($Bitrate / 1000).' kbps</td>';
    777. 

  777. 		echo '<TD ALIGN="RIGHT">'.number_format($Count).'</td>';
    778. 

  778. 		echo '</tr>';
    779. 

  779. 	}
    780. 

  780. 	echo '</table>';
    781. 

  781. 

  782. 

  783. } elseif (!empty($_REQUEST['emptygenres'])) {
    784. 

  784. 

  785. 	$SQLquery  = 'SELECT `fileformat`, `filename`, `genre`';
    786. 

  786. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    787. 

  787. 	$SQLquery .= ' WHERE (`genre` = "")';
    788. 

  788. 	$SQLquery .= ' OR (`genre` = "Unknown")';
    789. 

  789. 	$SQLquery .= ' OR (`genre` = "Other")';
    790. 

  790. 	$SQLquery .= ' ORDER BY `filename` ASC';
    791. 

  791. 	$result = safe_mysql_query($SQLquery);
    792. 

  792. 

  793. 	if (!empty($_REQUEST['m3u'])) {
    794. 

  794. 

  795. 		header('Content-type: audio/x-mpegurl');
    796. 

  796. 		echo '#EXTM3U'."\n";
    797. 

  797. 		while ($row = mysql_fetch_array($result)) {
    798. 

  798. 			if (!in_array($row['fileformat'], $IgnoreNoTagFormats)) {
    799. 

  799. 				echo WindowsShareSlashTranslate($row['filename'])."\n";
    800. 

  800. 			}
    801. 

  801. 		}
    802. 

  802. 		exit;
    803. 

  803. 

  804. 	} else {
    805. 

  805. 

  806. 		echo '<a href="'.$_SERVER['PHP_SELF'].'?emptygenres='.urlencode($_REQUEST['emptygenres']).'&m3u=1">.m3u version</a><br>';
    807. 

  807. 		$EmptyGenreCounter = 0;
    808. 

  808. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    809. 

  809. 		echo '<tr><th>m3u</th><th>filename</th></tr>';
    810. 

  810. 		while ($row = mysql_fetch_array($result)) {
    811. 

  811. 			if (!in_array($row['fileformat'], $IgnoreNoTagFormats)) {
    812. 

  812. 				$EmptyGenreCounter++;
    813. 

  813. 				echo '<tr>';
    814. 

  814. 				echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</a></td>';
    815. 

  815. 				echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    816. 

  816. 				echo '</tr>';
    817. 

  817. 			}
    818. 

  818. 		}
    819. 

  819. 		echo '</table>';
    820. 

  820. 		echo '<b>'.number_format($EmptyGenreCounter).'</b> files with empty genres';
    821. 

  821. 

  822. 	}
    823. 

  823. 

  824. } elseif (!empty($_REQUEST['nonemptycomments'])) {
    825. 

  825. 

  826. 	$SQLquery  = 'SELECT `filename`, `comment`';
    827. 

  827. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    828. 

  828. 	$SQLquery .= ' WHERE (`comment` <> "")';
    829. 

  829. 	$SQLquery .= ' ORDER BY `comment` ASC';
    830. 

  830. 	$result = safe_mysql_query($SQLquery);
    831. 

  831. 

  832. 	if (!empty($_REQUEST['m3u'])) {
    833. 

  833. 

  834. 		header('Content-type: audio/x-mpegurl');
    835. 

  835. 		echo '#EXTM3U'."\n";
    836. 

  836. 		while ($row = mysql_fetch_array($result)) {
    837. 

  837. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    838. 

  838. 		}
    839. 

  839. 		exit;
    840. 

  840. 

  841. 	} else {
    842. 

  842. 

  843. 		$NonEmptyCommentsCounter = 0;
    844. 

  844. 		echo '<a href="'.$_SERVER['PHP_SELF'].'?nonemptycomments='.urlencode($_REQUEST['nonemptycomments']).'&m3u=1">.m3u version</a><br>';
    845. 

  845. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    846. 

  846. 		echo '<tr><th>m3u</th><th>filename</th><th>comments</th></tr>';
    847. 

  847. 		while ($row = mysql_fetch_array($result)) {
    848. 

  848. 			$NonEmptyCommentsCounter++;
    849. 

  849. 			echo '<tr>';
    850. 

  850. 			echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</a></td>';
    851. 

  851. 			echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    852. 

  852. 			if (strlen(trim($row['comment'])) > 0) {
    853. 

  853. 				echo '<td>'.FixTextFields($row['comment']).'</td>';
    854. 

  854. 			} else {
    855. 

  855. 				echo '<td><i>space</i></td>';
    856. 

  856. 			}
    857. 

  857. 			echo '</tr>';
    858. 

  858. 		}
    859. 

  859. 		echo '</table>';
    860. 

  860. 		echo '<b>'.number_format($NonEmptyCommentsCounter).'</b> files with non-empty comments';
    861. 

  861. 

  862. 	}
    863. 

  863. 

  864. } elseif (!empty($_REQUEST['trackzero'])) {
    865. 

  865. 

  866. 	$SQLquery  = 'SELECT `filename`, `track`';
    867. 

  867. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    868. 

  868. 	$SQLquery .= ' WHERE (`track` <> "")';
    869. 

  869. 	$SQLquery .= ' AND ((`track` < "1")';
    870. 

  870. 	$SQLquery .= ' OR (`track` > "99"))';
    871. 

  871. 	$SQLquery .= ' ORDER BY `filename` ASC';
    872. 

  872. 	$result = safe_mysql_query($SQLquery);
    873. 

  873. 

  874. 	if (!empty($_REQUEST['m3u'])) {
    875. 

  875. 

  876. 		header('Content-type: audio/x-mpegurl');
    877. 

  877. 		echo '#EXTM3U'."\n";
    878. 

  878. 		while ($row = mysql_fetch_array($result)) {
    879. 

  879. 			if ((strlen($row['track']) > 0) && ($row['track'] < 1) || ($row['track'] > 99)) {
    880. 

  880. 				echo WindowsShareSlashTranslate($row['filename'])."\n";
    881. 

  881. 			}
    882. 

  882. 		}
    883. 

  883. 		exit;
    884. 

  884. 

  885. 	} else {
    886. 

  886. 

  887. 		echo '<a href="'.$_SERVER['PHP_SELF'].'?trackzero='.urlencode($_REQUEST['trackzero']).'&m3u=1">.m3u version</a><br>';
    888. 

  888. 		$TrackZeroCounter = 0;
    889. 

  889. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    890. 

  890. 		echo '<tr><th>m3u</th><th>filename</th><th>track</th></tr>';
    891. 

  891. 		while ($row = mysql_fetch_array($result)) {
    892. 

  892. 			if ((strlen($row['track']) > 0) && ($row['track'] < 1) || ($row['track'] > 99)) {
    893. 

  893. 				$TrackZeroCounter++;
    894. 

  894. 				echo '<tr>';
    895. 

  895. 				echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</a></td>';
    896. 

  896. 				echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    897. 

  897. 				echo '<td>'.FixTextFields($row['track']).'</td>';
    898. 

  898. 				echo '</tr>';
    899. 

  899. 			}
    900. 

  900. 		}
    901. 

  901. 		echo '</table>';
    902. 

  902. 		echo '<b>'.number_format($TrackZeroCounter).'</b> files with track "zero"';
    903. 

  903. 

  904. 	}
    905. 

  905. 

  906. 

  907. } elseif (!empty($_REQUEST['titlefeat'])) {
    908. 

  908. 

  909. 	$SQLquery  = 'SELECT `filename`, `title`';
    910. 

  910. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    911. 

  911. 	$SQLquery .= ' WHERE (`title` LIKE "%feat.%")';
    912. 

  912. 	$SQLquery .= ' ORDER BY `filename` ASC';
    913. 

  913. 	$result = safe_mysql_query($SQLquery);
    914. 

  914. 

  915. 	if (!empty($_REQUEST['m3u'])) {
    916. 

  916. 

  917. 		header('Content-type: audio/x-mpegurl');
    918. 

  918. 		echo '#EXTM3U'."\n";
    919. 

  919. 		while ($row = mysql_fetch_array($result)) {
    920. 

  920. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    921. 

  921. 		}
    922. 

  922. 		exit;
    923. 

  923. 

  924. 	} else {
    925. 

  925. 

  926. 		echo '<b>'.number_format(mysql_num_rows($result)).'</b> files with "feat." in the title (instead of the artist)<br><br>';
    927. 

  927. 		echo '<a href="'.$_SERVER['PHP_SELF'].'?titlefeat='.urlencode($_REQUEST['titlefeat']).'&m3u=1">.m3u version</a><br>';
    928. 

  928. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    929. 

  929. 		echo '<tr><th>m3u</th><th>filename</th><th>title</th></tr>';
    930. 

  930. 		while ($row = mysql_fetch_array($result)) {
    931. 

  931. 			echo '<tr>';
    932. 

  932. 			echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</a></td>';
    933. 

  933. 			echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    934. 

  934. 			echo '<td>'.eregi_replace('(feat\. .*)', '<b>\\1</b>', FixTextFields($row['title'])).'</td>';
    935. 

  935. 			echo '</tr>';
    936. 

  936. 		}
    937. 

  937. 		echo '</table>';
    938. 

  938. 

  939. 	}
    940. 

  940. 

  941. 

  942. } elseif (!empty($_REQUEST['tracknoalbum'])) {
    943. 

  943. 

  944. 	$SQLquery  = 'SELECT `filename`, `track`, `album`';
    945. 

  945. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    946. 

  946. 	$SQLquery .= ' WHERE (`track` <> "")';
    947. 

  947. 	$SQLquery .= ' AND (`album` = "")';
    948. 

  948. 	$SQLquery .= ' ORDER BY `filename` ASC';
    949. 

  949. 	$result = safe_mysql_query($SQLquery);
    950. 

  950. 

  951. 	if (!empty($_REQUEST['m3u'])) {
    952. 

  952. 

  953. 		header('Content-type: audio/x-mpegurl');
    954. 

  954. 		echo '#EXTM3U'."\n";
    955. 

  955. 		while ($row = mysql_fetch_array($result)) {
    956. 

  956. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    957. 

  957. 		}
    958. 

  958. 		exit;
    959. 

  959. 

  960. 	} else {
    961. 

  961. 

  962. 		echo '<b>'.number_format(mysql_num_rows($result)).'</b> files with a track number, but no album<br><br>';
    963. 

  963. 		echo '<a href="'.$_SERVER['PHP_SELF'].'?tracknoalbum='.urlencode($_REQUEST['tracknoalbum']).'&m3u=1">.m3u version</a><br>';
    964. 

  964. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    965. 

  965. 		echo '<tr><th>m3u</th><th>filename</th><th>track</th><th>album</th></tr>';
    966. 

  966. 		while ($row = mysql_fetch_array($result)) {
    967. 

  967. 			echo '<tr>';
    968. 

  968. 			echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</a></td>';
    969. 

  969. 			echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    970. 

  970. 			echo '<td>'.FixTextFields($row['track']).'</td>';
    971. 

  971. 			echo '<td>'.FixTextFields($row['album']).'</td>';
    972. 

  972. 			echo '</tr>';
    973. 

  973. 		}
    974. 

  974. 		echo '</table>';
    975. 

  975. 

  976. 	}
    977. 

  977. 

  978. 

  979. } elseif (!empty($_REQUEST['synchronizetagsfrom']) && !empty($_REQUEST['filename'])) {
    980. 

  980. 

  981. 	echo 'Applying new tags from <b>'.$_REQUEST['synchronizetagsfrom'].'</b> in <b>'.FixTextFields($_REQUEST['filename']).'</b><ul>';
    982. 

  982. 	$errors = array();
    983. 

  983. 	if (SynchronizeAllTags($_REQUEST['filename'], $_REQUEST['synchronizetagsfrom'], 'A12', $errors)) {
    984. 

  984. 		echo '<li>Sucessfully wrote tags</li>';
    985. 

  985. 	} else {
    986. 

  986. 		echo '<li>Tag writing had errors: <ul><li>'.implode('</li><li>', $errors).'</li></ul></li>';
    987. 

  987. 	}
    988. 

  988. 	echo '</ul>';
    989. 

  989. 

  990. 

  991. } elseif (!empty($_REQUEST['unsynchronizedtags'])) {
    992. 

  992. 

  993. 	$NotOKfiles        = 0;
    994. 

  994. 	$Autofixedfiles    = 0;
    995. 

  995. 	$FieldsToCompare   = array('title', 'artist', 'album', 'year', 'genre', 'comment', 'track');
    996. 

  996. 	$TagsToCompare     = array('id3v2'=>false, 'ape'=>false, 'lyrics3'=>false, 'id3v1'=>false);
    997. 

  997. 	$ID3v1FieldLengths = array('title'=>30, 'artist'=>30, 'album'=>30, 'year'=>4, 'genre'=>99, 'comment'=>28);
    998. 

  998. 	if (strpos($_REQUEST['unsynchronizedtags'], '2') !== false) {
    999. 

  999. 		$TagsToCompare['id3v2'] = true;
    1000. 

  1000. 	}
    1001. 

  1001. 	if (strpos($_REQUEST['unsynchronizedtags'], 'A') !== false) {
    1002. 

  1002. 		$TagsToCompare['ape'] = true;
    1003. 

  1003. 	}
    1004. 

  1004. 	if (strpos($_REQUEST['unsynchronizedtags'], 'L') !== false) {
    1005. 

  1005. 		$TagsToCompare['lyrics3'] = true;
    1006. 

  1006. 	}
    1007. 

  1007. 	if (strpos($_REQUEST['unsynchronizedtags'], '1') !== false) {
    1008. 

  1008. 		$TagsToCompare['id3v1'] = true;
    1009. 

  1009. 	}
    1010. 

  1010. 

  1011. 	echo '<a href="'.$_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1">Auto-fix empty tags</a><br><br>';
    1012. 

  1012. 	echo '<div id="Autofixing"></div>';
    1013. 

  1013. 	echo '<table border="1" cellspacing="0" cellpadding="3">';
    1014. 

  1014. 	echo '<tr>';
    1015. 

  1015. 	echo '<th>View</th>';
    1016. 

  1016. 	echo '<th>Filename</th>';
    1017. 

  1017. 	echo '<th>Combined</th>';
    1018. 

  1018. 	if ($TagsToCompare['id3v2']) {
    1019. 

  1019. 		echo '<th><a href="'.$_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>';
    1020. 

  1020. 	}
    1021. 

  1021. 	if ($TagsToCompare['ape']) {
    1022. 

  1022. 		echo '<th><a href="'.$_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>';
    1023. 

  1023. 	}
    1024. 

  1024. 	if ($TagsToCompare['lyrics3']) {
    1025. 

  1025. 		echo '<th>Lyrics3</th>';
    1026. 

  1026. 	}
    1027. 

  1027. 	if ($TagsToCompare['id3v1']) {
    1028. 

  1028. 		echo '<th><a href="'.$_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>';
    1029. 

  1029. 	}
    1030. 

  1030. 	echo '</tr>';
    1031. 

  1031. 

  1032. 	$SQLquery  = 'SELECT `filename`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyrics3`, `comments_id3v1`';
    1033. 

  1033. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1034. 

  1034. 	$SQLquery .= ' WHERE (`fileformat` = "mp3")';
    1035. 

  1035. 	$SQLquery .= ' ORDER BY `filename` ASC';
    1036. 

  1036. 	$result = safe_mysql_query($SQLquery);
    1037. 

  1037. 	$lastdir = '';
    1038. 

  1038. 	while ($row = mysql_fetch_array($result)) {
    1039. 

  1039. 		set_time_limit(30);
    1040. 

  1040. 		if ($lastdir != dirname($row['filename'])) {
    1041. 

  1041. 			echo '<script>if (document.getElementById("Autofixing")) document.getElementById("Autofixing").innerHTML = "'.htmlentities($lastdir, ENT_QUOTES).'";</script>';
    1042. 

  1042. 			flush();
    1043. 

  1043. 		}
    1044. 

  1044. 

  1045. 		$FileOK      = true;
    1046. 

  1046. 		$Mismatched  = array('id3v2'=>false, 'ape'=>false, 'lyrics3'=>false, 'id3v1'=>false);
    1047. 

  1047. 		$SemiMatched = array('id3v2'=>false, 'ape'=>false, 'lyrics3'=>false, 'id3v1'=>false);
    1048. 

  1048. 		$EmptyTags   = array('id3v2'=>true,  'ape'=>true,  'lyrics3'=>true,  'id3v1'=>true);
    1049. 

  1049. 

  1050. 		$Comments['all']     = @unserialize($row['comments_all']);
    1051. 

  1051. 		$Comments['id3v2']   = @unserialize($row['comments_id3v2']);
    1052. 

  1052. 		$Comments['ape']     = @unserialize($row['comments_ape']);
    1053. 

  1053. 		$Comments['lyrics3'] = @unserialize($row['comments_lyrics3']);
    1054. 

  1054. 		$Comments['id3v1']   = @unserialize($row['comments_id3v1']);
    1055. 

  1055. 

  1056. 		if (isset($Comments['ape']['tracknumber'])) {
    1057. 

  1057. 			$Comments['ape']['track'] = $Comments['ape']['tracknumber'];
    1058. 

  1058. 			unset($Comments['ape']['tracknumber']);
    1059. 

  1059. 		}
    1060. 

  1060. 		if (!empty($Comments['all']['track'])) {
    1061. 

  1061. 			$besttrack = '';
    1062. 

  1062. 			foreach ($Comments['all']['track'] as $key => $value) {
    1063. 

  1063. 				if (strlen($value) > strlen($besttrack)) {
    1064. 

  1064. 					$besttrack = $value;
    1065. 

  1065. 				}
    1066. 

  1066. 			}
    1067. 

  1067. 			$Comments['all']['track'] = array(0=>$besttrack);
    1068. 

  1068. 		}
    1069. 

  1069. 

  1070. 		$ThisLine  = '<tr>';
    1071. 

  1071. 		$ThisLine .= '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">view</a></td>';
    1072. 

  1072. 		$ThisLine .= '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    1073. 

  1073. 		$tagvalues = '';
    1074. 

  1074. 		foreach ($FieldsToCompare as $fieldname) {
    1075. 

  1075. 			$tagvalues .= $fieldname.' = '.@implode(" \n", @$Comments['all'][$fieldname])." \n";
    1076. 

  1076. 		}
    1077. 

  1077. 		$ThisLine .= '<td><a href="'.$_SERVER['PHP_SELF'].'?synchronizetagsfrom=all&filename='.urlencode($row['filename']).'" TITLE="'.htmlentities(rtrim($tagvalues, "\n"), ENT_QUOTES).'" TARGET="retagwindow">all</a></td>';
    1078. 

  1078. 		foreach ($TagsToCompare as $tagtype => $CompareThisTagType) {
    1079. 

  1079. 			if ($CompareThisTagType) {
    1080. 

  1080. 				$tagvalues = '';
    1081. 

  1081. 				foreach ($FieldsToCompare as $fieldname) {
    1082. 

  1082. 

  1083. 					if ($tagtype == 'id3v1') {
    1084. 

  1084. 

  1085. 						getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v1.php', __FILE__, true);
    1086. 

  1086. 						if (($fieldname == 'genre') && !getid3_id3v1::LookupGenreID(@$Comments['all'][$fieldname][0])) {
    1087. 

  1087. 

  1088. 							// non-standard genres can never match, so just ignore
    1089. 

  1089. 							$tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n";
    1090. 

  1090. 

  1091. 						} elseif ($fieldname == 'comment') {
    1092. 

  1092. 

  1093. 							if (rtrim(substr(@$Comments[$tagtype][$fieldname][0], 0, 28)) != rtrim(substr(@$Comments['all'][$fieldname][0], 0, 28))) {
    1094. 

  1094. 								$tagvalues .= $fieldname.' = [['.@$Comments[$tagtype][$fieldname][0].']]'."\n";
    1095. 

  1095. 								if (trim(strtolower(RemoveAccents(substr(@$Comments[$tagtype][$fieldname][0], 0, 28)))) == trim(strtolower(RemoveAccents(substr(@$Comments['all'][$fieldname][0], 0, 28))))) {
    1096. 

  1096. 									$SemiMatched[$tagtype] = true;
    1097. 

  1097. 								} else {
    1098. 

  1098. 									$Mismatched[$tagtype]  = true;
    1099. 

  1099. 								}
    1100. 

  1100. 								$FileOK = false;
    1101. 

  1101. 							} else {
    1102. 

  1102. 								$tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n";
    1103. 

  1103. 							}
    1104. 

  1104. 

  1105. 						} elseif ($fieldname == 'track') {
    1106. 

  1106. 

  1107. 							// intval('01/20') == intval('1')
    1108. 

  1108. 							if (intval(@$Comments[$tagtype][$fieldname][0]) != intval(@$Comments['all'][$fieldname][0])) {
    1109. 

  1109. 								$tagvalues .= $fieldname.' = [['.@$Comments[$tagtype][$fieldname][0].']]'."\n";
    1110. 

  1110. 								$Mismatched[$tagtype]  = true;
    1111. 

  1111. 								$FileOK = false;
    1112. 

  1112. 							} else {
    1113. 

  1113. 								$tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n";
    1114. 

  1114. 							}
    1115. 

  1115. 

  1116. 						} elseif (rtrim(substr(@$Comments[$tagtype][$fieldname][0], 0, 30)) != rtrim(substr(@$Comments['all'][$fieldname][0], 0, 30))) {
    1117. 

  1117. 

  1118. 							$tagvalues .= $fieldname.' = [['.@$Comments[$tagtype][$fieldname][0].']]'."\n";
    1119. 

  1119. 							if (strtolower(RemoveAccents(trim(substr(@$Comments[$tagtype][$fieldname][0], 0, 30)))) == strtolower(RemoveAccents(trim(substr(@$Comments['all'][$fieldname][0], 0, 30))))) {
    1120. 

  1120. 								$SemiMatched[$tagtype] = true;
    1121. 

  1121. 							} else {
    1122. 

  1122. 								$Mismatched[$tagtype]  = true;
    1123. 

  1123. 							}
    1124. 

  1124. 							$FileOK = false;
    1125. 

  1125. 							if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) {
    1126. 

  1126. 								$EmptyTags[$tagtype] = false;
    1127. 

  1127. 							}
    1128. 

  1128. 

  1129. 						} else {
    1130. 

  1130. 

  1131. 							$tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n";
    1132. 

  1132. 							if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) {
    1133. 

  1133. 								$EmptyTags[$tagtype] = false;
    1134. 

  1134. 							}
    1135. 

  1135. 

  1136. 						}
    1137. 

  1137. 

  1138. 					} elseif (($tagtype == 'ape') && ($fieldname == 'year')) {
    1139. 

  1139. 

  1140. 						if ((@$Comments['ape']['date'][0] != @$Comments['all']['year'][0]) && (@$Comments['ape']['year'][0] != @$Comments['all']['year'][0])) {
    1141. 

  1141. 

  1142. 							$tagvalues .= $fieldname.' = [['.@$Comments['ape']['date'][0].']]'."\n";
    1143. 

  1143. 							$Mismatched[$tagtype]  = true;
    1144. 

  1144. 							$FileOK = false;
    1145. 

  1145. 							if (strlen(trim(@$Comments['ape']['date'][0])) > 0) {
    1146. 

  1146. 								$EmptyTags[$tagtype] = false;
    1147. 

  1147. 							}
    1148. 

  1148. 

  1149. 						} else {
    1150. 

  1150. 

  1151. 							$tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n";
    1152. 

  1152. 							if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) {
    1153. 

  1153. 								$EmptyTags[$tagtype] = false;
    1154. 

  1154. 							}
    1155. 

  1155. 

  1156. 						}
    1157. 

  1157. 

  1158. 					} elseif (($fieldname == 'genre') && !empty($Comments['all'][$fieldname]) && !empty($Comments[$tagtype][$fieldname]) && in_array($Comments[$tagtype][$fieldname][0], $Comments['all'][$fieldname])) {
    1159. 

  1159. 

  1160. 						$tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n";
    1161. 

  1161. 						if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) {
    1162. 

  1162. 							$EmptyTags[$tagtype] = false;
    1163. 

  1163. 						}
    1164. 

  1164. 

  1165. 					} elseif (@$Comments[$tagtype][$fieldname][0] != @$Comments['all'][$fieldname][0]) {
    1166. 

  1166. 

  1167. 						$tagvalues .= $fieldname.' = [['.@$Comments[$tagtype][$fieldname][0].']]'."\n";
    1168. 

  1168. 						if (trim(strtolower(RemoveAccents(@$Comments[$tagtype][$fieldname][0]))) == trim(strtolower(RemoveAccents(@$Comments['all'][$fieldname][0])))) {
    1169. 

  1169. 							$SemiMatched[$tagtype] = true;
    1170. 

  1170. 						} else {
    1171. 

  1171. 							$Mismatched[$tagtype]  = true;
    1172. 

  1172. 						}
    1173. 

  1173. 						$FileOK = false;
    1174. 

  1174. 						if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) {
    1175. 

  1175. 							$EmptyTags[$tagtype] = false;
    1176. 

  1176. 						}
    1177. 

  1177. 

  1178. 					} else {
    1179. 

  1179. 

  1180. 						$tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n";
    1181. 

  1181. 						if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) {
    1182. 

  1182. 							$EmptyTags[$tagtype] = false;
    1183. 

  1183. 						}
    1184. 

  1184. 

  1185. 					}
    1186. 

  1186. 				}
    1187. 

  1187. 

  1188. 				if ($EmptyTags[$tagtype]) {
    1189. 

  1189. 					$FileOK = false;
    1190. 

  1190. 					$ThisLine .= '<TD BGCOLOR="#0099CC">';
    1191. 

  1191. 				} elseif ($SemiMatched[$tagtype]) {
    1192. 

  1192. 					$ThisLine .= '<TD BGCOLOR="#FF9999">';
    1193. 

  1193. 				} elseif ($Mismatched[$tagtype]) {
    1194. 

  1194. 					$ThisLine .= '<TD BGCOLOR="#FF0000">';
    1195. 

  1195. 				} else {
    1196. 

  1196. 					$ThisLine .= '<TD BGCOLOR="#00CC00">';
    1197. 

  1197. 				}
    1198. 

  1198. 				$ThisLine .= '<a href="'.$_SERVER['PHP_SELF'].'?synchronizetagsfrom='.$tagtype.'&filename='.urlencode($row['filename']).'" TITLE="'.htmlentities(rtrim($tagvalues, "\n"), ENT_QUOTES).'" TARGET="retagwindow">'.$tagtype.'</a>';
    1199. 

  1199. 				$ThisLine .= '</td>';
    1200. 

  1200. 			}
    1201. 

  1201. 		}
    1202. 

  1202. 		$ThisLine .= '</tr>';
    1203. 

  1203. 

  1204. 		if (!$FileOK) {
    1205. 

  1205. 			$NotOKfiles++;
    1206. 

  1206. 

  1207. 			echo '<script>if (document.getElementById("Autofixing")) document.getElementById("Autofixing").innerHTML = "'.htmlentities($row['filename'], ENT_QUOTES).'";</script>';
    1208. 

  1208. 			flush();
    1209. 

  1209. 

  1210. 			if (!empty($_REQUEST['autofix'])) {
    1211. 

  1211. 

  1212. 				$AnyMismatched = false;
    1213. 

  1213. 				foreach ($Mismatched as $key => $value) {
    1214. 

  1214. 					if ($value && ($EmptyTags["$key"] === false)) {
    1215. 

  1215. 						$AnyMismatched = true;
    1216. 

  1216. 					}
    1217. 

  1217. 				}
    1218. 

  1218. 				if ($AnyMismatched && empty($_REQUEST['autofixforcesource'])) {
    1219. 

  1219. 

  1220. 					echo $ThisLine;
    1221. 

  1221. 

  1222. 				} else {
    1223. 

  1223. 

  1224. 					$TagsToSynch = '';
    1225. 

  1225. 					foreach ($EmptyTags as $key => $value) {
    1226. 

  1226. 						if ($value) {
    1227. 

  1227. 							switch ($key) {
    1228. 

  1228. 								case 'id3v1':
    1229. 

  1229. 									$TagsToSynch .= '1';
    1230. 

  1230. 									break;
    1231. 

  1231. 								case 'id3v2':
    1232. 

  1232. 									$TagsToSynch .= '2';
    1233. 

  1233. 									break;
    1234. 

  1234. 								case 'ape':
    1235. 

  1235. 									$TagsToSynch .= 'A';
    1236. 

  1236. 									break;
    1237. 

  1237. 							}
    1238. 

  1238. 						}
    1239. 

  1239. 					}
    1240. 

  1240. 

  1241. 					$autofixforcesource = (@$_REQUEST['autofixforcesource'] ? $_REQUEST['autofixforcesource'] : 'all');
    1242. 

  1242. 					$TagsToSynch        = (@$_REQUEST['autofixforcedest']   ? $_REQUEST['autofixforcedest']   : $TagsToSynch);
    1243. 

  1243. 

  1244. 					$errors = array();
    1245. 

  1245. 					if (SynchronizeAllTags($row['filename'], $autofixforcesource, $TagsToSynch, $errors)) {
    1246. 

  1246. 						$Autofixedfiles++;
    1247. 

  1247. 						echo '<tr bgcolor="#00CC00">';
    1248. 

  1248. 					} else {
    1249. 

  1249. 						echo '<tr bgcolor="#FF0000">';
    1250. 

  1250. 					}
    1251. 

  1251. 					echo '<td>&nbsp;</th>';
    1252. 

  1252. 					echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'" TITLE="'.FixTextFields(implode("\n", $errors)).'">'.FixTextFields($row['filename']).'</a></td>';
    1253. 

  1253. 					echo '<td><table border="0">';
    1254. 

  1254. 					echo '<tr><td><b>'.$TagsToSynch.'</b></td></tr>';
    1255. 

  1255. 					echo '</table></td></tr>';
    1256. 

  1256. 				}
    1257. 

  1257. 

  1258. 			} else {
    1259. 

  1259. 

  1260. 				echo $ThisLine;
    1261. 

  1261. 

  1262. 			}
    1263. 

  1263. 		}
    1264. 

  1264. 	}
    1265. 

  1265. 

  1266. 	echo '</table><br>';
    1267. 

  1267. 	echo '<script>if (document.getElementById("Autofixing")) document.getElementById("Autofixing").innerHTML = "";</script>';
    1268. 

  1268. 	echo 'Found <b>'.number_format($NotOKfiles).'</b> files with unsynchronized tags, and auto-fixed '.number_format($Autofixedfiles).' of them.';
    1269. 

  1269. 

  1270. } elseif (!empty($_REQUEST['filenamepattern'])) {
    1271. 

  1271. 

  1272. 	$patterns['A'] = 'artist';
    1273. 

  1273. 	$patterns['T'] = 'title';
    1274. 

  1274. 	$patterns['M'] = 'album';
    1275. 

  1275. 	$patterns['N'] = 'track';
    1276. 

  1276. 	$patterns['G'] = 'genre';
    1277. 

  1277. 	$patterns['R'] = 'remix';
    1278. 

  1278. 

  1279. 	$FieldsToUse = explode(' ', wordwrap(eregi_replace('[^A-Z]', '', $_REQUEST['filenamepattern']), 1, ' ', 1));
    1280. 

  1280. 	//$FieldsToUse = explode(' ', wordwrap($_REQUEST['filenamepattern'], 1, ' ', 1));
    1281. 

  1281. 	foreach ($FieldsToUse as $FieldID) {
    1282. 

  1282. 		$FieldNames[] = $patterns["$FieldID"];
    1283. 

  1283. 	}
    1284. 

  1284. 

  1285. 	$SQLquery  = 'SELECT `filename`, `fileformat`, '.implode(', ', $FieldNames);
    1286. 

  1286. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1287. 

  1287. 	$SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")';
    1288. 

  1288. 	$SQLquery .= ' ORDER BY `filename` ASC';
    1289. 

  1289. 	$result = safe_mysql_query($SQLquery);
    1290. 

  1290. 	echo 'Files that do not match naming pattern: (<a href="?filenamepattern='.urlencode($_REQUEST['filenamepattern']).'&autofix=1">auto-fix</a>)<br>';
    1291. 

  1291. 	echo '<table border="1" cellspacing="0" cellpadding="3">';
    1292. 

  1292. 	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>'.(!@$_REQUEST['autofix'] ? '<br>(click to rename file to this)' : '').'</td></tr>';
    1293. 

  1293. 	$nonmatchingfilenames = 0;
    1294. 

  1294. 	$Pattern = $_REQUEST['filenamepattern'];
    1295. 

  1295. 	$PatternLength = strlen($Pattern);
    1296. 

  1296. 	while ($row = mysql_fetch_array($result)) {
    1297. 

  1297. 		set_time_limit(10);
    1298. 

  1298. 		$PatternFilename = '';
    1299. 

  1299. 		for ($i = 0; $i < $PatternLength; $i++) {
    1300. 

  1300. 			if (isset($patterns[$Pattern{$i}])) {
    1301. 

  1301. 				$PatternFilename .= trim(strtr($row[$patterns[$Pattern{$i}]], ':\\*<>|', ';-¤«»¦'), ' ');
    1302. 

  1302. 			} else {
    1303. 

  1303. 				$PatternFilename .= $Pattern{$i};
    1304. 

  1304. 			}
    1305. 

  1305. 		}
    1306. 

  1306. 

  1307. 		// Replace "~" with "-" if characters immediately before and after are both numbers,
    1308. 

  1308. 		// "/" has been replaced with "~" above which is good for multi-song medley dividers,
    1309. 

  1309. 		// but for things like 24/7, 7/8ths, etc it looks better if it's 24-7, 7-8ths, etc.
    1310. 

  1310. 		$PatternFilename = eregi_replace('([ a-z]+)/([ a-z]+)', '\\1~\\2', $PatternFilename);
    1311. 

  1311. 		$PatternFilename = str_replace('/',  '×',  $PatternFilename);
    1312. 

  1312. 

  1313. 		$PatternFilename = str_replace('?',  '¿',  $PatternFilename);
    1314. 

  1314. 		$PatternFilename = str_replace(' "', ' “', $PatternFilename);
    1315. 

  1315. 		$PatternFilename = str_replace('("', '(“', $PatternFilename);
    1316. 

  1316. 		$PatternFilename = str_replace('-"', '-“', $PatternFilename);
    1317. 

  1317. 		$PatternFilename = str_replace('" ', '” ', $PatternFilename.' ');
    1318. 

  1318. 		$PatternFilename = str_replace('"',  '”',  $PatternFilename);
    1319. 

  1319. 		$PatternFilename = str_replace('  ', ' ',  $PatternFilename);
    1320. 

  1320. 

  1321. 

  1322. 		$ParenthesesPairs = array('()', '[]', '{}');
    1323. 

  1323. 		foreach ($ParenthesesPairs as $pair) {
    1324. 

  1324. 

  1325. 			// multiple remixes are stored tab-seperated in the database.
    1326. 

  1326. 			// change "{2000 Version\tSomebody Remix}" into "{2000 Version} {Somebody Remix}"
    1327. 

  1327. 			while (ereg('^(.*)'.preg_quote($pair{0}).'([^'.preg_quote($pair{1}).']*)('."\t".')([^'.preg_quote($pair{0}).']*)'.preg_quote($pair{1}), $PatternFilename, $matches)) {
    1328. 

  1328. 				$PatternFilename = $matches[1].$pair{0}.$matches[2].$pair{1}.' '.$pair{0}.$matches[4].$pair{1};
    1329. 

  1329. 			}
    1330. 

  1330. 

  1331. 			// remove empty parenthesized pairs (probably where no track numbers, remix version, etc)
    1332. 

  1332. 			$PatternFilename = ereg_replace(preg_quote($pair), '', $PatternFilename);
    1333. 

  1333. 

  1334. 			// "[01]  - Title With No Artist.mp3"  ==>  "[01] Title With No Artist.mp3"
    1335. 

  1335. 			$PatternFilename = ereg_replace(preg_quote($pair{1}).' +\- ', $pair{1}.' ', $PatternFilename);
    1336. 

  1336. 

  1337. 		}
    1338. 

  1338. 

  1339. 		// get rid of leading & trailing spaces if end items (artist or title for example) are missing
    1340. 

  1340. 		$PatternFilename  = trim($PatternFilename, ' -');
    1341. 

  1341. 

  1342. 		if (!$PatternFilename) {
    1343. 

  1343. 			// no tags to create a filename from -- skip this file
    1344. 

  1344. 			continue;
    1345. 

  1345. 		}
    1346. 

  1346. 		$PatternFilename .= '.'.$row['fileformat'];
    1347. 

  1347. 

  1348. 		$ActualFilename = basename($row['filename']);
    1349. 

  1349. 		if ($ActualFilename != $PatternFilename) {
    1350. 

  1350. 

  1351. 			$NotMatchedReasons = '';
    1352. 

  1352. 			if (strtolower($ActualFilename) === strtolower($PatternFilename)) {
    1353. 

  1353. 				$NotMatchedReasons .= 'Aa ';
    1354. 

  1354. 			} elseif (RemoveAccents($ActualFilename) === RemoveAccents($PatternFilename)) {
    1355. 

  1355. 				$NotMatchedReasons .= 'ée ';
    1356. 

  1356. 			}
    1357. 

  1357. 

  1358. 

  1359. 			$actualExt  = '.'.fileextension($ActualFilename);
    1360. 

  1360. 			$patternExt = '.'.fileextension($PatternFilename);
    1361. 

  1361. 			$ActualFilenameNoExt  = (($actualExt  != '.') ? substr($ActualFilename,   0, 0 - strlen($actualExt))  : $ActualFilename);
    1362. 

  1362. 			$PatternFilenameNoExt = (($patternExt != '.') ? substr($PatternFilename,  0, 0 - strlen($patternExt)) : $PatternFilename);
    1363. 

  1363. 

  1364. 			if (strpos($PatternFilenameNoExt, $ActualFilenameNoExt) !== false) {
    1365. 

  1365. 				$DifferenceBoldedName  = str_replace($ActualFilenameNoExt, '</b>'.$ActualFilenameNoExt.'<b>', $PatternFilenameNoExt);
    1366. 

  1366. 			} else {
    1367. 

  1367. 				$ShortestNameLength = min(strlen($ActualFilenameNoExt), strlen($PatternFilenameNoExt));
    1368. 

  1368. 				for ($DifferenceOffset = 0; $DifferenceOffset < $ShortestNameLength; $DifferenceOffset++) {
    1369. 

  1369. 					if ($ActualFilenameNoExt{$DifferenceOffset} !== $PatternFilenameNoExt{$DifferenceOffset}) {
    1370. 

  1370. 						break;
    1371. 

  1371. 					}
    1372. 

  1372. 				}
    1373. 

  1373. 				$DifferenceBoldedName  = '</b>'.substr($PatternFilenameNoExt, 0, $DifferenceOffset).'<b>'.substr($PatternFilenameNoExt, $DifferenceOffset);
    1374. 

  1374. 			}
    1375. 

  1375. 			$DifferenceBoldedName .= (($actualExt == $patternExt) ? '</b>'.$patternExt.'<b>' : $patternExt);
    1376. 

  1376. 

  1377. 

  1378. 			echo '<tr>';
    1379. 

  1379. 			echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">view</a></td>';
    1380. 

  1380. 			echo '<td>&nbsp;'.$NotMatchedReasons.'</td>';
    1381. 

  1381. 			echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">'.FixTextFields($ActualFilename).'</a></td>';
    1382. 

  1382. 

  1383. 			if (@$_REQUEST['autofix']) {
    1384. 

  1384. 

  1385. 				$results = '';
    1386. 

  1386. 				if (RenameFileFromTo($row['filename'], dirname($row['filename']).'/'.$PatternFilename, $results)) {
    1387. 

  1387. 					echo '<TD BGCOLOR="#009900">';
    1388. 

  1388. 				} else {
    1389. 

  1389. 					echo '<TD BGCOLOR="#FF0000">';
    1390. 

  1390. 				}
    1391. 

  1391. 				echo '<b>'.$DifferenceBoldedName.'</b></td>';
    1392. 

  1392. 

  1393. 

  1394. 			} else {
    1395. 

  1395. 

  1396. 				echo '<td><a href="'.$_SERVER['PHP_SELF'].'?filenamepattern='.urlencode($_REQUEST['filenamepattern']).'&renamefilefrom='.urlencode($row['filename']).'&renamefileto='.urlencode(dirname($row['filename']).'/'.$PatternFilename).'" TITLE="'.FixTextFields(basename($row['filename']))."\n".FixTextFields(basename($PatternFilename)).'" TARGET="renamewindow">';
    1397. 

  1397. 				echo '<b>'.$DifferenceBoldedName.'</b></a></td>';
    1398. 

  1398. 

  1399. 			}
    1400. 

  1400. 			echo '</tr>';
    1401. 

  1401. 

  1402. 			$nonmatchingfilenames++;
    1403. 

  1403. 		}
    1404. 

  1404. 	}
    1405. 

  1405. 	echo '</table><br>';
    1406. 

  1406. 	echo 'Found '.number_format($nonmatchingfilenames).' files that do not match naming pattern<br>';
    1407. 

  1407. 

  1408. 

  1409. } elseif (!empty($_REQUEST['encoderoptionsdistribution'])) {
    1410. 

  1410. 

  1411. 	if (isset($_REQUEST['showtagfiles'])) {
    1412. 

  1412. 		$SQLquery  = 'SELECT `filename`, `encoder_options` FROM `'.GETID3_DB_TABLE.'`';
    1413. 

  1413. 		$SQLquery .= ' WHERE (`encoder_options` LIKE "'.mysql_escape_string($_REQUEST['showtagfiles']).'")';
    1414. 

  1414. 		$SQLquery .= ' AND (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")';
    1415. 

  1415. 		$SQLquery .= ' ORDER BY `filename` ASC';
    1416. 

  1416. 		$result = safe_mysql_query($SQLquery);
    1417. 

  1417. 

  1418. 		if (!empty($_REQUEST['m3u'])) {
    1419. 

  1419. 

  1420. 			header('Content-type: audio/x-mpegurl');
    1421. 

  1421. 			echo '#EXTM3U'."\n";
    1422. 

  1422. 			while ($row = mysql_fetch_array($result)) {
    1423. 

  1423. 				echo WindowsShareSlashTranslate($row['filename'])."\n";
    1424. 

  1424. 			}
    1425. 

  1425. 			exit;
    1426. 

  1426. 

  1427. 		} else {
    1428. 

  1428. 

  1429. 			echo '<a href="'.$_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1">Show all Encoder Options</a><hr>';
    1430. 

  1430. 			echo 'Files with Encoder Options <b>'.$_REQUEST['showtagfiles'].'</b>:<br>';
    1431. 

  1431. 			echo '<table border="1" cellspacing="0" cellpadding="3">';
    1432. 

  1432. 			while ($row = mysql_fetch_array($result)) {
    1433. 

  1433. 				echo '<tr>';
    1434. 

  1434. 				echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    1435. 

  1435. 				echo '<td>'.$row['encoder_options'].'</td>';
    1436. 

  1436. 				echo '</tr>';
    1437. 

  1437. 			}
    1438. 

  1438. 			echo '</table>';
    1439. 

  1439. 

  1440. 		}
    1441. 

  1441. 

  1442. 	} elseif (!isset($_REQUEST['m3u'])) {
    1443. 

  1443. 

  1444. 		$SQLquery  = 'SELECT `encoder_options`, COUNT(*) AS `num` FROM `'.GETID3_DB_TABLE.'`';
    1445. 

  1445. 		$SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")';
    1446. 

  1446. 		$SQLquery .= ' GROUP BY `encoder_options`';
    1447. 

  1447. 		$SQLquery .= ' ORDER BY (`encoder_options` LIKE "LAME%") DESC, (`encoder_options` LIKE "CBR%") DESC, `num` DESC, `encoder_options` ASC';
    1448. 

  1448. 		$result = safe_mysql_query($SQLquery);
    1449. 

  1449. 		echo 'Files with Encoder Options:<br>';
    1450. 

  1450. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    1451. 

  1451. 		echo '<tr><th>Encoder Options</th><th>Count</th><th>M3U</th></tr>';
    1452. 

  1452. 		while ($row = mysql_fetch_array($result)) {
    1453. 

  1453. 			echo '<tr>';
    1454. 

  1454. 			echo '<td>'.$row['encoder_options'].'</td>';
    1455. 

  1455. 			echo '<TD ALIGN="RIGHT"><a href="'.$_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1&showtagfiles='.($row['encoder_options'] ? urlencode($row['encoder_options']) : '').'">'.number_format($row['num']).'</a></td>';
    1456. 

  1456. 			echo '<TD ALIGN="RIGHT"><a href="'.$_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1&showtagfiles='.($row['encoder_options'] ? urlencode($row['encoder_options']) : '').'&m3u=.m3u">m3u</a></td>';
    1457. 

  1457. 			echo '</tr>';
    1458. 

  1458. 		}
    1459. 

  1459. 		echo '</table><hr>';
    1460. 

  1460. 

  1461. 	}
    1462. 

  1462. 

  1463. } elseif (!empty($_REQUEST['tagtypes'])) {
    1464. 

  1464. 

  1465. 	if (!isset($_REQUEST['m3u'])) {
    1466. 

  1466. 		$SQLquery  = 'SELECT `tags`, COUNT(*) AS `num` FROM `'.GETID3_DB_TABLE.'`';
    1467. 

  1467. 		$SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")';
    1468. 

  1468. 		$SQLquery .= ' GROUP BY `tags`';
    1469. 

  1469. 		$SQLquery .= ' ORDER BY `num` DESC';
    1470. 

  1470. 		$result = safe_mysql_query($SQLquery);
    1471. 

  1471. 		echo 'Files with tags:<br>';
    1472. 

  1472. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    1473. 

  1473. 		echo '<tr><th>Tags</th><th>Count</th><th>M3U</th></tr>';
    1474. 

  1474. 		while ($row = mysql_fetch_array($result)) {
    1475. 

  1475. 			echo '<tr>';
    1476. 

  1476. 			echo '<td>'.$row['tags'].'</td>';
    1477. 

  1477. 			echo '<TD ALIGN="RIGHT"><a href="'.$_SERVER['PHP_SELF'].'?tagtypes=1&showtagfiles='.($row['tags'] ? urlencode($row['tags']) : '').'">'.number_format($row['num']).'</a></td>';
    1478. 

  1478. 			echo '<TD ALIGN="RIGHT"><a href="'.$_SERVER['PHP_SELF'].'?tagtypes=1&showtagfiles='.($row['tags'] ? urlencode($row['tags']) : '').'&m3u=.m3u">m3u</a></td>';
    1479. 

  1479. 			echo '</tr>';
    1480. 

  1480. 		}
    1481. 

  1481. 		echo '</table><hr>';
    1482. 

  1482. 	}
    1483. 

  1483. 

  1484. 	if (isset($_REQUEST['showtagfiles'])) {
    1485. 

  1485. 		$SQLquery  = 'SELECT `filename`, `tags` FROM `'.GETID3_DB_TABLE.'`';
    1486. 

  1486. 		$SQLquery .= ' WHERE (`tags` LIKE "'.mysql_escape_string($_REQUEST['showtagfiles']).'")';
    1487. 

  1487. 		$SQLquery .= ' AND (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")';
    1488. 

  1488. 		$SQLquery .= ' ORDER BY `filename` ASC';
    1489. 

  1489. 		$result = safe_mysql_query($SQLquery);
    1490. 

  1490. 

  1491. 		if (!empty($_REQUEST['m3u'])) {
    1492. 

  1492. 

  1493. 			header('Content-type: audio/x-mpegurl');
    1494. 

  1494. 			echo '#EXTM3U'."\n";
    1495. 

  1495. 			while ($row = mysql_fetch_array($result)) {
    1496. 

  1496. 				echo WindowsShareSlashTranslate($row['filename'])."\n";
    1497. 

  1497. 			}
    1498. 

  1498. 			exit;
    1499. 

  1499. 

  1500. 		} else {
    1501. 

  1501. 

  1502. 			echo '<table border="1" cellspacing="0" cellpadding="3">';
    1503. 

  1503. 			while ($row = mysql_fetch_array($result)) {
    1504. 

  1504. 				echo '<tr>';
    1505. 

  1505. 				echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    1506. 

  1506. 				echo '<td>'.$row['tags'].'</td>';
    1507. 

  1507. 				echo '</tr>';
    1508. 

  1508. 			}
    1509. 

  1509. 			echo '</table>';
    1510. 

  1510. 

  1511. 		}
    1512. 

  1512. 	}
    1513. 

  1513. 

  1514. 

  1515. } elseif (!empty($_REQUEST['md5datadupes'])) {
    1516. 

  1516. 

  1517. 	$OtherFormats = '';
    1518. 

  1518. 	$AVFormats    = '';
    1519. 

  1519. 

  1520. 	$SQLquery  = 'SELECT `md5_data`, `filename`, COUNT(*) AS `num`';
    1521. 

  1521. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1522. 

  1522. 	$SQLquery .= ' WHERE (`md5_data` <> "")';
    1523. 

  1523. 	$SQLquery .= ' GROUP BY `md5_data`';
    1524. 

  1524. 	$SQLquery .= ' ORDER BY `num` DESC';
    1525. 

  1525. 	$result = safe_mysql_query($SQLquery);
    1526. 

  1526. 	while (($row = mysql_fetch_array($result)) && ($row['num'] > 1)) {
    1527. 

  1527. 		set_time_limit(30);
    1528. 

  1528. 

  1529. 		$filenames = array();
    1530. 

  1530. 		$tags      = array();
    1531. 

  1531. 		$md5_data  = array();
    1532. 

  1532. 		$SQLquery  = 'SELECT `fileformat`, `filename`, `tags`';
    1533. 

  1533. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1534. 

  1534. 		$SQLquery .= ' WHERE (`md5_data` = "'.mysql_escape_string($row['md5_data']).'")';
    1535. 

  1535. 		$SQLquery .= ' ORDER BY `filename` ASC';
    1536. 

  1536. 		$result2 = safe_mysql_query($SQLquery);
    1537. 

  1537. 		while ($row2 = mysql_fetch_array($result2)) {
    1538. 

  1538. 			$thisfileformat = $row2['fileformat'];
    1539. 

  1539. 			$filenames[] = $row2['filename'];
    1540. 

  1540. 			$tags[]      = $row2['tags'];
    1541. 

  1541. 			$md5_data[]  = $row['md5_data'];
    1542. 

  1542. 		}
    1543. 

  1543. 

  1544. 		$thisline  = '<tr>';
    1545. 

  1545. 		$thisline .= '<TD VALIGN="TOP" style="font-family: monospace;">'.implode('<br>', $md5_data).'</td>';
    1546. 

  1546. 		$thisline .= '<TD VALIGN="TOP" NOWRAP>'.implode('<br>', $tags).'</td>';
    1547. 

  1547. 		$thisline .= '<TD VALIGN="TOP">'.implode('<br>', $filenames).'</td>';
    1548. 

  1548. 		$thisline .= '</tr>';
    1549. 

  1549. 

  1550. 		if (in_array($thisfileformat, $IgnoreNoTagFormats)) {
    1551. 

  1551. 			$OtherFormats .= $thisline;
    1552. 

  1552. 		} else {
    1553. 

  1553. 			$AVFormats .= $thisline;
    1554. 

  1554. 		}
    1555. 

  1555. 	}
    1556. 

  1556. 	echo 'Duplicated MD5_DATA (Audio/Video files):<table border="1" cellspacing="0" cellpadding="2">';
    1557. 

  1557. 	echo $AVFormats.'</table><hr>';
    1558. 

  1558. 	echo 'Duplicated MD5_DATA (Other files):<table border="1" cellspacing="0" cellpadding="2">';
    1559. 

  1559. 	echo $OtherFormats.'</table><hr>';
    1560. 

  1560. 

  1561. 

  1562. } elseif (!empty($_REQUEST['artisttitledupes'])) {
    1563. 

  1563. 

  1564. 	if (isset($_REQUEST['m3uartist']) && isset($_REQUEST['m3utitle'])) {
    1565. 

  1565. 

  1566. 		header('Content-type: audio/x-mpegurl');
    1567. 

  1567. 		echo '#EXTM3U'."\n";
    1568. 

  1568. 		$SQLquery  = 'SELECT `filename`';
    1569. 

  1569. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1570. 

  1570. 		$SQLquery .= ' WHERE (`artist` = "'.mysql_escape_string($_REQUEST['m3uartist']).'")';
    1571. 

  1571. 		$SQLquery .= ' AND (`title` = "'.mysql_escape_string($_REQUEST['m3utitle']).'")';
    1572. 

  1572. 		$SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';
    1573. 

  1573. 		$result = safe_mysql_query($SQLquery);
    1574. 

  1574. 		while ($row = mysql_fetch_array($result)) {
    1575. 

  1575. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    1576. 

  1576. 		}
    1577. 

  1577. 		exit;
    1578. 

  1578. 

  1579. 	}
    1580. 

  1580. 

  1581. 	$SQLquery  = 'SELECT `artist`, `title`, `filename`, COUNT(*) AS `num`';
    1582. 

  1582. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1583. 

  1583. 	$SQLquery .= ' WHERE (`artist` <> "")';
    1584. 

  1584. 	$SQLquery .= ' AND (`title` <> "")';
    1585. 

  1585. 	$SQLquery .= ' GROUP BY `artist`, `title`'.(@$_REQUEST['samemix'] ? ', `remix`' : '');
    1586. 

  1586. 	$SQLquery .= ' ORDER BY `num` DESC, `artist` ASC, `title` ASC, `playtime_seconds` ASC, `remix` ASC';
    1587. 

  1587. 	$result = safe_mysql_query($SQLquery);
    1588. 

  1588. 	$uniquetitles = 0;
    1589. 

  1589. 	$uniquefiles  = 0;
    1590. 

  1590. 

  1591. 	if (!empty($_REQUEST['m3u'])) {
    1592. 

  1592. 

  1593. 		header('Content-type: audio/x-mpegurl');
    1594. 

  1594. 		echo '#EXTM3U'."\n";
    1595. 

  1595. 		while (($row = mysql_fetch_array($result)) && ($row['num'] > 1)) {
    1596. 

  1596. 			$SQLquery  = 'SELECT `filename`';
    1597. 

  1597. 			$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1598. 

  1598. 			$SQLquery .= ' WHERE (`artist` = "'.mysql_escape_string($row['artist']).'")';
    1599. 

  1599. 			$SQLquery .= ' AND (`title` = "'.mysql_escape_string($row['title']).'")';
    1600. 

  1600. 			if (@$_REQUEST['samemix']) {
    1601. 

  1601. 				$SQLquery .= ' AND (`remix` = "'.mysql_escape_string($row['remix']).'")';
    1602. 

  1602. 			}
    1603. 

  1603. 			$SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';
    1604. 

  1604. 			$result2 = safe_mysql_query($SQLquery);
    1605. 

  1605. 			while ($row2 = mysql_fetch_array($result2)) {
    1606. 

  1606. 				echo WindowsShareSlashTranslate($row2['filename'])."\n";
    1607. 

  1607. 			}
    1608. 

  1608. 		}
    1609. 

  1609. 		exit;
    1610. 

  1610. 

  1611. 	} else {
    1612. 

  1612. 

  1613. 		echo 'Duplicated aritst + title: (<a href="'.$_SERVER['PHP_SELF'].'?artisttitledupes=1&samemix=1">Identical Mix/Version only</a>)<br>';
    1614. 

  1614. 		echo '(<a href="'.$_SERVER['PHP_SELF'].'?artisttitledupes=1&m3u=.m3u">.m3u version</a>)<br>';
    1615. 

  1615. 		echo '<table border="1" cellspacing="0" cellpadding="2">';
    1616. 

  1616. 		echo '<tr><th colspan="3">&nbsp;</th><th>Artist</th><th>Title</th><th>Version</th><th>&nbsp;</th><th>&nbsp;</th><th>Filename</th></tr>';
    1617. 

  1617. 

  1618. 		while (($row = mysql_fetch_array($result)) && ($row['num'] > 1)) {
    1619. 

  1619. 			$uniquetitles++;
    1620. 

  1620. 			set_time_limit(30);
    1621. 

  1621. 

  1622. 			$filenames = array();
    1623. 

  1623. 			$artists   = array();
    1624. 

  1624. 			$titles    = array();
    1625. 

  1625. 			$remixes   = array();
    1626. 

  1626. 			$bitrates  = array();
    1627. 

  1627. 			$playtimes = array();
    1628. 

  1628. 			$SQLquery  = 'SELECT `filename`, `artist`, `title`, `remix`, `audio_bitrate`, `vbr_method`, `playtime_seconds`, `encoder_options`';
    1629. 

  1629. 			$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1630. 

  1630. 			$SQLquery .= ' WHERE (`artist` = "'.mysql_escape_string($row['artist']).'")';
    1631. 

  1631. 			$SQLquery .= ' AND (`title` = "'.mysql_escape_string($row['title']).'")';
    1632. 

  1632. 			$SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';
    1633. 

  1633. 			$result2 = safe_mysql_query($SQLquery);
    1634. 

  1634. 			while ($row2 = mysql_fetch_array($result2)) {
    1635. 

  1635. 				$uniquefiles++;
    1636. 

  1636. 				$filenames[] = $row2['filename'];
    1637. 

  1637. 				$artists[]   = $row2['artist'];
    1638. 

  1638. 				$titles[]    = $row2['title'];
    1639. 

  1639. 				$remixes[]   = $row2['remix'];
    1640. 

  1640. 				if ($row2['vbr_method']) {
    1641. 

  1641. 					$bitrates[]  = '<B'.($row2['encoder_options'] ? ' style="text-decoration: underline; cursor: help;" TITLE="'.$row2['encoder_options'] : '').'">'.BitrateText($row2['audio_bitrate'] / 1000).'</b>';
    1642. 

  1642. 				} else {
    1643. 

  1643. 					$bitrates[]  = BitrateText($row2['audio_bitrate'] / 1000);
    1644. 

  1644. 				}
    1645. 

  1645. 				$playtimes[] = getid3_lib::PlaytimeString($row2['playtime_seconds']);
    1646. 

  1646. 			}
    1647. 

  1647. 

  1648. 			echo '<tr>';
    1649. 

  1649. 			echo '<TD NOWRAP VALIGN="TOP">';
    1650. 

  1650. 			foreach ($filenames as $file) {
    1651. 

  1651. 				echo '<a href="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="Permanently delete '."\n".FixTextFields($file)."\n".'" TARGET="deletedupewindow">delete</a><br>';
    1652. 

  1652. 			}
    1653. 

  1653. 			echo '</td>';
    1654. 

  1654. 			echo '<TD NOWRAP VALIGN="TOP">';
    1655. 

  1655. 			foreach ($filenames as $file) {
    1656. 

  1656. 				echo '<a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($file).'">play</a><br>';
    1657. 

  1657. 			}
    1658. 

  1658. 			echo '</td>';
    1659. 

  1659. 			echo '<TD VALIGN="MIDDLE" ALIGN="CENTER" ><a href="'.$_SERVER['PHP_SELF'].'?artisttitledupes=1&m3uartist='.urlencode($artists[0]).'&m3utitle='.urlencode($titles[0]).'">play all</a></td>';
    1660. 

  1660. 			echo '<TD VALIGN="TOP" NOWRAP>'.implode('<br>', $artists).'</td>';
    1661. 

  1661. 			echo '<TD VALIGN="TOP" NOWRAP>'.implode('<br>', $titles).'</td>';
    1662. 

  1662. 			echo '<TD VALIGN="TOP" NOWRAP>'.implode('<br>', $remixes).'</td>';
    1663. 

  1663. 			echo '<TD VALIGN="TOP" NOWRAP ALIGN="RIGHT">'.implode('<br>', $bitrates).'</td>';
    1664. 

  1664. 			echo '<TD VALIGN="TOP" NOWRAP ALIGN="RIGHT">'.implode('<br>', $playtimes).'</td>';
    1665. 

  1665. 

  1666. 			echo '<TD VALIGN="TOP" NOWRAP ALIGN="LEFT"><table border="0" cellspacing="0" cellpadding="0">';
    1667. 

  1667. 			foreach ($filenames as $file) {
    1668. 

  1668. 				echo '<tr><TD NOWRAP ALIGN="RIGHT"><a href="demo.browse.php?filename='.rawurlencode($file).'"><span style="color: #339966;">'.dirname($file).'/</span>'.basename($file).'</a></td></tr>';
    1669. 

  1669. 			}
    1670. 

  1670. 			echo '</table></td>';
    1671. 

  1671. 

  1672. 			echo '</tr>';
    1673. 

  1673. 		}
    1674. 

  1674. 

  1675. 	}
    1676. 

  1676. 	echo '</table>';
    1677. 

  1677. 	echo number_format($uniquefiles).' files with '.number_format($uniquetitles).' unique <i>aritst + title</i><br>';
    1678. 

  1678. 	echo '<hr>';
    1679. 

  1679. 

  1680. } elseif (!empty($_REQUEST['filetypelist'])) {
    1681. 

  1681. 

  1682. 	list($fileformat, $audioformat) = explode('|', $_REQUEST['filetypelist']);
    1683. 

  1683. 	$SQLquery  = 'SELECT `filename`, `fileformat`, `audio_dataformat`';
    1684. 

  1684. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1685. 

  1685. 	$SQLquery .= ' WHERE (`fileformat` = "'.mysql_escape_string($fileformat).'")';
    1686. 

  1686. 	$SQLquery .= ' AND (`audio_dataformat` = "'.mysql_escape_string($audioformat).'")';
    1687. 

  1687. 	$SQLquery .= ' ORDER BY `filename` ASC';
    1688. 

  1688. 	$result = safe_mysql_query($SQLquery);
    1689. 

  1689. 	echo 'Files of format <b>'.$fileformat.'.'.$audioformat.'</b>:<table border="1" cellspacing="0" cellpadding="4">';
    1690. 

  1690. 	echo '<tr><th>file</th><th>audio</th><th>filename</th></tr>';
    1691. 

  1691. 	while ($row = mysql_fetch_array($result)) {
    1692. 

  1692. 		echo '<tr>';
    1693. 

  1693. 		echo '<td>'.$row['fileformat'].'</td>';
    1694. 

  1694. 		echo '<td>'.$row['audio_dataformat'].'</td>';
    1695. 

  1695. 		echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    1696. 

  1696. 		echo '</tr>';
    1697. 

  1697. 	}
    1698. 

  1698. 	echo '</table><hr>';
    1699. 

  1699. 

  1700. } elseif (!empty($_REQUEST['trackinalbum'])) {
    1701. 

  1701. 

  1702. 	$SQLquery  = 'SELECT `filename`, `album`';
    1703. 

  1703. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1704. 

  1704. 	$SQLquery .= ' WHERE (`album` LIKE "% [%")';
    1705. 

  1705. 	$SQLquery .= ' ORDER BY `album` ASC, `filename` ASC';
    1706. 

  1706. 	$result = safe_mysql_query($SQLquery);
    1707. 

  1707. 	if (!empty($_REQUEST['m3u'])) {
    1708. 

  1708. 

  1709. 		header('Content-type: audio/x-mpegurl');
    1710. 

  1710. 		echo '#EXTM3U'."\n";
    1711. 

  1711. 		while ($row = mysql_fetch_array($result)) {
    1712. 

  1712. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    1713. 

  1713. 		}
    1714. 

  1714. 		exit;
    1715. 

  1715. 

  1716. 	} elseif (!empty($_REQUEST['autofix'])) {
    1717. 

  1717. 

  1718. 		getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v1.php', __FILE__, true);
    1719. 

  1719. 		getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v2.php', __FILE__, true);
    1720. 

  1720. 

  1721. 		while ($row = mysql_fetch_array($result)) {
    1722. 

  1722. 			set_time_limit(30);
    1723. 

  1723. 			$ThisFileInfo = $getID3->analyze($filename);
    1724. 

  1724. 			getid3_lib::CopyTagsToComments($ThisFileInfo);
    1725. 

  1725. 

  1726. 			if (!empty($ThisFileInfo['tags'])) {
    1727. 

  1727. 

  1728. 				$Album = trim(str_replace(strstr($ThisFileInfo['comments']['album'][0], ' ['), '', $ThisFileInfo['comments']['album'][0]));
    1729. 

  1729. 				$Track = (string) intval(str_replace(' [', '', str_replace(']', '', strstr($ThisFileInfo['comments']['album'][0], ' ['))));
    1730. 

  1730. 				if ($Track == '0') {
    1731. 

  1731. 					$Track = '';
    1732. 

  1732. 				}
    1733. 

  1733. 				if ($Album && $Track) {
    1734. 

  1734. 					echo '<hr>'.FixTextFields($row['filename']).'<br>';
    1735. 

  1735. 					echo '<i>'.$Album.'</i> (track #'.$Track.')<br>';
    1736. 

  1736. 					echo '<b>ID3v2:</b> '.(RemoveID3v2($row['filename'], false) ? 'removed' : 'REMOVAL FAILED!').', ';
    1737. 

  1737. 					echo '<b>ID3v1:</b> '.(WriteID3v1($row['filename'], @$ThisFileInfo['comments']['title'][0], @$ThisFileInfo['comments']['artist'][0], $Album, @$ThisFileInfo['comments']['year'][0], @$ThisFileInfo['comments']['comment'][0], @$ThisFileInfo['comments']['genreid'][0], $Track, false) ? 'updated' : 'UPDATE FAILED').'<br>';
    1738. 

  1738. 				} else {
    1739. 

  1739. 					echo ' . ';
    1740. 

  1740. 				}
    1741. 

  1741. 

  1742. 			} else {
    1743. 

  1743. 

  1744. 				echo '<hr>FAILED<br>'.FixTextFields($row['filename']).'<hr>';
    1745. 

  1745. 

  1746. 			}
    1747. 

  1747. 			flush();
    1748. 

  1748. 		}
    1749. 

  1749. 

  1750. 	} else {
    1751. 

  1751. 

  1752. 		echo '<b>'.number_format(mysql_num_rows($result)).'</b> files with <b>[??]</b>-format track numbers in album field:<br>';
    1753. 

  1753. 		if (mysql_num_rows($result) > 0) {
    1754. 

  1754. 			echo '(<a href="'.$_SERVER['PHP_SELF'].'?trackinalbum=1&m3u=.m3u">.m3u version</a>)<br>';
    1755. 

  1755. 			echo '<a href="'.$_SERVER['PHP_SELF'].'?trackinalbum=1&autofix=1">Try to auto-fix</a><br>';
    1756. 

  1756. 			echo '<table border="1" cellspacing="0" cellpadding="4">';
    1757. 

  1757. 			while ($row = mysql_fetch_array($result)) {
    1758. 

  1758. 				echo '<tr>';
    1759. 

  1759. 				echo '<td>'.$row['album'].'</td>';
    1760. 

  1760. 				echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    1761. 

  1761. 				echo '</tr>';
    1762. 

  1762. 			}
    1763. 

  1763. 			echo '</table>';
    1764. 

  1764. 		}
    1765. 

  1765. 		echo '<hr>';
    1766. 

  1766. 

  1767. 	}
    1768. 

  1768. 

  1769. } elseif (!empty($_REQUEST['fileextensions'])) {
    1770. 

  1770. 

  1771. 	$SQLquery  = 'SELECT `filename`, `fileformat`, `audio_dataformat`, `video_dataformat`, `tags`';
    1772. 

  1772. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1773. 

  1773. 	$SQLquery .= ' ORDER BY `filename` ASC';
    1774. 

  1774. 	$result = safe_mysql_query($SQLquery);
    1775. 

  1775. 	$invalidextensionfiles = 0;
    1776. 

  1776. 	$invalidextensionline  = '<table border="1" cellspacing="0" cellpadding="4">';
    1777. 

  1777. 	$invalidextensionline .= '<tr><th>file</th><th>audio</th><th>video</th><th>tags</th><th>actual</th><th>correct</th><th>filename</th></tr>';
    1778. 

  1778. 	while ($row = mysql_fetch_array($result)) {
    1779. 

  1779. 		set_time_limit(30);
    1780. 

  1780. 

  1781. 		$acceptableextensions = AcceptableExtensions($row['fileformat'], $row['audio_dataformat'], $row['video_dataformat']);
    1782. 

  1782. 		$actualextension      = strtolower(fileextension($row['filename']));
    1783. 

  1783. 		if ($acceptableextensions && !in_array($actualextension, $acceptableextensions)) {
    1784. 

  1784. 			$invalidextensionfiles++;
    1785. 

  1785. 

  1786. 			$invalidextensionline .= '<tr>';
    1787. 

  1787. 			$invalidextensionline .= '<td>'.$row['fileformat'].'</td>';
    1788. 

  1788. 			$invalidextensionline .= '<td>'.$row['audio_dataformat'].'</td>';
    1789. 

  1789. 			$invalidextensionline .= '<td>'.$row['video_dataformat'].'</td>';
    1790. 

  1790. 			$invalidextensionline .= '<td>'.$row['tags'].'</td>';
    1791. 

  1791. 			$invalidextensionline .= '<td>'.$actualextension.'</td>';
    1792. 

  1792. 			$invalidextensionline .= '<td>'.implode('; ', $acceptableextensions).'</td>';
    1793. 

  1793. 			$invalidextensionline .= '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    1794. 

  1794. 			$invalidextensionline .= '</tr>';
    1795. 

  1795. 		}
    1796. 

  1796. 	}
    1797. 

  1797. 	$invalidextensionline .= '</table><hr>';
    1798. 

  1798. 	echo number_format($invalidextensionfiles).' files with incorrect filename extension:<br>';
    1799. 

  1799. 	echo $invalidextensionline;
    1800. 

  1800. 

  1801. } elseif (isset($_REQUEST['genredistribution'])) {
    1802. 

  1802. 

  1803. 	if (!empty($_REQUEST['m3u'])) {
    1804. 

  1804. 

  1805. 		header('Content-type: audio/x-mpegurl');
    1806. 

  1806. 		echo '#EXTM3U'."\n";
    1807. 

  1807. 		$SQLquery  = 'SELECT `filename`';
    1808. 

  1808. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1809. 

  1809. 		$SQLquery .= ' WHERE (BINARY `genre` = "'.$_REQUEST['genredistribution'].'")';
    1810. 

  1810. 		$SQLquery .= ' AND (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")';
    1811. 

  1811. 		$SQLquery .= ' ORDER BY `filename` ASC';
    1812. 

  1812. 		$result = safe_mysql_query($SQLquery);
    1813. 

  1813. 		while ($row = mysql_fetch_array($result)) {
    1814. 

  1814. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    1815. 

  1815. 		}
    1816. 

  1816. 		exit;
    1817. 

  1817. 

  1818. 	} else {
    1819. 

  1819. 

  1820. 		if ($_REQUEST['genredistribution'] == '%') {
    1821. 

  1821. 

  1822. 			$SQLquery  = 'SELECT COUNT(*) AS `num`, `genre`';
    1823. 

  1823. 			$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1824. 

  1824. 			$SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")';
    1825. 

  1825. 			$SQLquery .= ' GROUP BY `genre`';
    1826. 

  1826. 			$SQLquery .= ' ORDER BY `num` DESC';
    1827. 

  1827. 			$result = safe_mysql_query($SQLquery);
    1828. 

  1828. 			getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v1.php', __FILE__, true);
    1829. 

  1829. 			echo '<table border="1" cellspacing="0" cellpadding="4">';
    1830. 

  1830. 			echo '<tr><th>Count</th><th>Genre</th><th>m3u</th></tr>';
    1831. 

  1831. 			while ($row = mysql_fetch_array($result)) {
    1832. 

  1832. 				$GenreID = getid3_id3v1::LookupGenreID($row['genre']);
    1833. 

  1833. 				if (is_numeric($GenreID)) {
    1834. 

  1834. 					echo '<tr bgcolor="#00FF00;">';
    1835. 

  1835. 				} else {
    1836. 

  1836. 					echo '<tr bgcolor="#FF9999;">';
    1837. 

  1837. 				}
    1838. 

  1838. 				echo '<td><a href="'.$_SERVER['PHP_SELF'].'?genredistribution='.urlencode($row['genre']).'">'.number_format($row['num']).'</a></td>';
    1839. 

  1839. 				echo '<TD NOWRAP>'.str_replace("\t", '<br>', $row['genre']).'</td>';
    1840. 

  1840. 				echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3u=.m3u&genredistribution='.urlencode($row['genre']).'">.m3u</a></td>';
    1841. 

  1841. 				echo '</tr>';
    1842. 

  1842. 			}
    1843. 

  1843. 			echo '</table><hr>';
    1844. 

  1844. 

  1845. 		} else {
    1846. 

  1846. 

  1847. 			$SQLquery  = 'SELECT `filename`, `genre`';
    1848. 

  1848. 			$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1849. 

  1849. 			$SQLquery .= ' WHERE (`genre` LIKE "'.mysql_escape_string($_REQUEST['genredistribution']).'")';
    1850. 

  1850. 			$SQLquery .= ' ORDER BY `filename` ASC';
    1851. 

  1851. 			$result = safe_mysql_query($SQLquery);
    1852. 

  1852. 			echo '<a href="'.$_SERVER['PHP_SELF'].'?genredistribution='.urlencode('%').'">All Genres</a><br>';
    1853. 

  1853. 			echo '<table border="1" cellspacing="0" cellpadding="4">';
    1854. 

  1854. 			echo '<tr><th>Genre</th><th>m3u</th><th>Filename</th></tr>';
    1855. 

  1855. 			while ($row = mysql_fetch_array($result)) {
    1856. 

  1856. 				echo '<tr>';
    1857. 

  1857. 				echo '<TD NOWRAP>'.str_replace("\t", '<br>', $row['genre']).'</td>';
    1858. 

  1858. 				echo '<td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</a></td>';
    1859. 

  1859. 				echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    1860. 

  1860. 				echo '</tr>';
    1861. 

  1861. 			}
    1862. 

  1862. 			echo '</table><hr>';
    1863. 

  1863. 

  1864. 		}
    1865. 

  1865. 

  1866. 

  1867. 	}
    1868. 

  1868. 

  1869. } elseif (!empty($_REQUEST['formatdistribution'])) {
    1870. 

  1870. 

  1871. 	$SQLquery  = 'SELECT `fileformat`, `audio_dataformat`, COUNT(*) AS `num`';
    1872. 

  1872. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1873. 

  1873. 	$SQLquery .= ' GROUP BY `fileformat`, `audio_dataformat`';
    1874. 

  1874. 	$SQLquery .= ' ORDER BY `num` DESC';
    1875. 

  1875. 	$result = safe_mysql_query($SQLquery);
    1876. 

  1876. 	echo 'File format distribution:<table border="1" cellspacing="0" cellpadding="4">';
    1877. 

  1877. 	echo '<tr><th>Number</th><th>Format</th></tr>';
    1878. 

  1878. 	while ($row = mysql_fetch_array($result)) {
    1879. 

  1879. 		echo '<tr>';
    1880. 

  1880. 		echo '<TD ALIGN="RIGHT">'.number_format($row['num']).'</td>';
    1881. 

  1881. 		echo '<td><a href="'.$_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>';
    1882. 

  1882. 		echo '</tr>';
    1883. 

  1883. 	}
    1884. 

  1884. 	echo '</table><hr>';
    1885. 

  1885. 

  1886. } elseif (!empty($_REQUEST['errorswarnings'])) {
    1887. 

  1887. 

  1888. 	$SQLquery  = 'SELECT `filename`, `error`, `warning`';
    1889. 

  1889. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1890. 

  1890. 	$SQLquery .= ' WHERE (`error` <> "")';
    1891. 

  1891. 	$SQLquery .= ' OR (`warning` <> "")';
    1892. 

  1892. 	$SQLquery .= ' ORDER BY `filename` ASC';
    1893. 

  1893. 	$result = safe_mysql_query($SQLquery);
    1894. 

  1894. 

  1895. 	if (!empty($_REQUEST['m3u'])) {
    1896. 

  1896. 

  1897. 		header('Content-type: audio/x-mpegurl');
    1898. 

  1898. 		echo '#EXTM3U'."\n";
    1899. 

  1899. 		while ($row = mysql_fetch_array($result)) {
    1900. 

  1900. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    1901. 

  1901. 		}
    1902. 

  1902. 		exit;
    1903. 

  1903. 

  1904. 	} else {
    1905. 

  1905. 

  1906. 		echo number_format(mysql_num_rows($result)).' files with errors or warnings:<br>';
    1907. 

  1907. 		echo '(<a href="'.$_SERVER['PHP_SELF'].'?errorswarnings=1&m3u=.m3u">.m3u version</a>)<br>';
    1908. 

  1908. 		echo '<table border="1" cellspacing="0" cellpadding="4">';
    1909. 

  1909. 		echo '<tr><th>Filename</th><th>Error</th><th>Warning</th></tr>';
    1910. 

  1910. 		while ($row = mysql_fetch_array($result)) {
    1911. 

  1911. 			echo '<tr>';
    1912. 

  1912. 			echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td>';
    1913. 

  1913. 			echo '<td>'.(!empty($row['error'])   ? '<li>'.str_replace("\t", '<li>', FixTextFields($row['error'])).'</li>' : '&nbsp;').'</td>';
    1914. 

  1914. 			echo '<td>'.(!empty($row['warning']) ? '<li>'.str_replace("\t", '<li>', FixTextFields($row['warning'])).'</li>' : '&nbsp;').'</td>';
    1915. 

  1915. 			echo '</tr>';
    1916. 

  1916. 		}
    1917. 

  1917. 	}
    1918. 

  1918. 	echo '</table><hr>';
    1919. 

  1919. 

  1920. } elseif (!empty($_REQUEST['fixid3v1padding'])) {
    1921. 

  1921. 

  1922. 	getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'write.id3v1.php', __FILE__, true);
    1923. 

  1923. 	$id3v1_writer = new getid3_write_id3v1;
    1924. 

  1924. 

  1925. 	$SQLquery  = 'SELECT `filename`, `error`, `warning`';
    1926. 

  1926. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1927. 

  1927. 	$SQLquery .= ' WHERE (`fileformat` = "mp3")';
    1928. 

  1928. 	$SQLquery .= ' AND (`warning` <> "")';
    1929. 

  1929. 	$SQLquery .= ' ORDER BY `filename` ASC';
    1930. 

  1930. 	$result = safe_mysql_query($SQLquery);
    1931. 

  1931. 	$totaltofix = mysql_num_rows($result);
    1932. 

  1932. 	$rowcounter = 0;
    1933. 

  1933. 	while ($row = mysql_fetch_array($result)) {
    1934. 

  1934. 		set_time_limit(30);
    1935. 

  1935. 		if (strpos($row['warning'], 'Some ID3v1 fields do not use NULL characters for padding') !== false) {
    1936. 

  1936. 			set_time_limit(30);
    1937. 

  1937. 			$id3v1_writer->filename = $row['filename'];
    1938. 

  1938. 			echo ($id3v1_writer->FixID3v1Padding() ? '<span style="color: #009900;">fixed - ' : '<span style="color: #FF0000;">error - ');
    1939. 

  1939. 		} else {
    1940. 

  1940. 			echo '<span style="color: #0000FF;">No error? - ';
    1941. 

  1941. 		}
    1942. 

  1942. 		echo '['.++$rowcounter.' / '.$totaltofix.'] ';
    1943. 

  1943. 		echo FixTextFields($row['filename']).'</span><br>';
    1944. 

  1944. 		flush();
    1945. 

  1945. 	}
    1946. 

  1946. 

  1947. } elseif (!empty($_REQUEST['vbrmethod'])) {
    1948. 

  1948. 

  1949. 	if ($_REQUEST['vbrmethod'] == '1') {
    1950. 

  1950. 

  1951. 		$SQLquery  = 'SELECT COUNT(*) AS `num`, `vbr_method`';
    1952. 

  1952. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1953. 

  1953. 		$SQLquery .= ' GROUP BY `vbr_method`';
    1954. 

  1954. 		$SQLquery .= ' ORDER BY `vbr_method`';
    1955. 

  1955. 		$result = safe_mysql_query($SQLquery);
    1956. 

  1956. 		echo 'VBR methods:<table border="1" cellspacing="0" cellpadding="4">';
    1957. 

  1957. 		echo '<tr><th>Count</th><th>VBR Method</th></tr>';
    1958. 

  1958. 		while ($row = mysql_fetch_array($result)) {
    1959. 

  1959. 			echo '<tr>';
    1960. 

  1960. 			echo '<TD ALIGN="RIGHT">'.FixTextFields(number_format($row['num'])).'</td>';
    1961. 

  1961. 			if ($row['vbr_method']) {
    1962. 

  1962. 				echo '<td><a href="'.$_SERVER['PHP_SELF'].'?vbrmethod='.$row['vbr_method'].'">'.FixTextFields($row['vbr_method']).'</a></td>';
    1963. 

  1963. 			} else {
    1964. 

  1964. 				echo '<td><i>CBR</i></td>';
    1965. 

  1965. 			}
    1966. 

  1966. 			echo '</tr>';
    1967. 

  1967. 		}
    1968. 

  1968. 		echo '</table>';
    1969. 

  1969. 

  1970. 	} else {
    1971. 

  1971. 

  1972. 		$SQLquery  = 'SELECT `filename`';
    1973. 

  1973. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1974. 

  1974. 		$SQLquery .= ' WHERE (`vbr_method` = "'.mysql_escape_string($_REQUEST['vbrmethod']).'")';
    1975. 

  1975. 		$result = safe_mysql_query($SQLquery);
    1976. 

  1976. 		echo number_format(mysql_num_rows($result)).' files with VBR_method of "'.$_REQUEST['vbrmethod'].'":<table border="1" cellspacing="0" cellpadding="3">';
    1977. 

  1977. 		while ($row = mysql_fetch_array($result)) {
    1978. 

  1978. 			echo '<tr><td><a href="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</a></td>';
    1979. 

  1979. 			echo '<td><a href="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</a></td></tr>';
    1980. 

  1980. 		}
    1981. 

  1981. 		echo '</table>';
    1982. 

  1982. 

  1983. 	}
    1984. 

  1984. 	echo '<hr>';
    1985. 

  1985. 

  1986. } elseif (!empty($_REQUEST['correctcase'])) {
    1987. 

  1987. 

  1988. 	$SQLquery  = 'SELECT `filename`, `fileformat`';
    1989. 

  1989. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1990. 

  1990. 	$SQLquery .= ' WHERE (`fileformat` <> "")';
    1991. 

  1991. 	$SQLquery .= ' ORDER BY `filename` ASC';
    1992. 

  1992. 	$result = safe_mysql_query($SQLquery);
    1993. 

  1993. 	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>';
    1994. 

  1994. 	echo '<PRE>';
    1995. 

  1995. 	$lastdir = '';
    1996. 

  1996. 	while ($row = mysql_fetch_array($result)) {
    1997. 

  1997. 		set_time_limit(30);
    1998. 

  1998. 		$CleanedFilename = CleanUpFileName($row['filename']);
    1999. 

  1999. 		if ($row['filename'] != $CleanedFilename) {
    2000. 

  2000. 			if (strtolower($lastdir) != strtolower(str_replace('/', '\\', dirname($row['filename'])))) {
    2001. 

  2001. 				$lastdir = str_replace('/', '\\', dirname($row['filename']));
    2002. 

  2002. 				echo 'cd "'.$lastdir.'"'."\n";
    2003. 

  2003. 			}
    2004. 

  2004. 			echo 'ren "'.basename($row['filename']).'" "'.basename(CleanUpFileName($row['filename'])).'"'."\n";
    2005. 

  2005. 		}
    2006. 

  2006. 	}
    2007. 

  2007. 	echo '</PRE>';
    2008. 

  2008. 	echo '<hr>';
    2009. 

  2009. 

  2010. }
    2011. 

  2011. 

  2012. function CleanUpFileName($filename) {
    2013. 

  2013. 	$DirectoryName = dirname($filename);
    2014. 

  2014. 	$FileExtension = fileextension(basename($filename));
    2015. 

  2015. 	$BaseFilename  = basename($filename, '.'.$FileExtension);
    2016. 

  2016. 

  2017. 	$BaseFilename = strtolower($BaseFilename);
    2018. 

  2018. 	$BaseFilename = str_replace('_', ' ', $BaseFilename);
    2019. 

  2019. 	//$BaseFilename = str_replace('-', ' - ', $BaseFilename);
    2020. 

  2020. 	$BaseFilename = str_replace('(', ' (', $BaseFilename);
    2021. 

  2021. 	$BaseFilename = str_replace('( ', '(', $BaseFilename);
    2022. 

  2022. 	$BaseFilename = str_replace(')', ') ', $BaseFilename);
    2023. 

  2023. 	$BaseFilename = str_replace(' )', ')', $BaseFilename);
    2024. 

  2024. 	$BaseFilename = str_replace(' \'\'', ' “', $BaseFilename);
    2025. 

  2025. 	$BaseFilename = str_replace('\'\' ', '” ', $BaseFilename);
    2026. 

  2026. 	$BaseFilename = str_replace(' vs ', ' vs. ', $BaseFilename);
    2027. 

  2027. 	while (strstr($BaseFilename, '  ') !== false) {
    2028. 

  2028. 		$BaseFilename = str_replace('  ', ' ', $BaseFilename);
    2029. 

  2029. 	}
    2030. 

  2030. 	$BaseFilename = trim($BaseFilename);
    2031. 

  2031. 

  2032. 	return $DirectoryName.'/'.BetterUCwords($BaseFilename).'.'.strtolower($FileExtension);
    2033. 

  2033. }
    2034. 

  2034. 

  2035. function BetterUCwords($string) {
    2036. 

  2036. 	$stringlength = strlen($string);
    2037. 

  2037. 

  2038. 	$string{0} = strtoupper($string{0});
    2039. 

  2039. 	for ($i = 1; $i < $stringlength; $i++) {
    2040. 

  2040. 		if (($string{$i - 1} == '\'') && ($i > 1) && (($string{$i - 2} == 'O') || ($string{$i - 2} == ' '))) {
    2041. 

  2041. 			// O'Clock, 'Em
    2042. 

  2042. 			$string{$i} = strtoupper($string{$i});
    2043. 

  2043. 		} elseif (ereg('^[\'A-Za-z0-9À-ÿ]$', $string{$i - 1})) {
    2044. 

  2044. 			$string{$i} = strtolower($string{$i});
    2045. 

  2045. 		} else {
    2046. 

  2046. 			$string{$i} = strtoupper($string{$i});
    2047. 

  2047. 		}
    2048. 

  2048. 	}
    2049. 

  2049. 

  2050. 	static $LowerCaseWords = array('vs.', 'feat.');
    2051. 

  2051. 	static $UpperCaseWords = array('DJ', 'USA', 'II', 'MC', 'CD', 'TV', '\'N\'');
    2052. 

  2052. 

  2053. 	$OutputListOfWords = array();
    2054. 

  2054. 	$ListOfWords = explode(' ', $string);
    2055. 

  2055. 	foreach ($ListOfWords as $ThisWord) {
    2056. 

  2056. 		if (in_array(strtolower(str_replace('(', '', $ThisWord)), $LowerCaseWords)) {
    2057. 

  2057. 			$ThisWord = strtolower($ThisWord);
    2058. 

  2058. 		} elseif (in_array(strtoupper(str_replace('(', '', $ThisWord)), $UpperCaseWords)) {
    2059. 

  2059. 			$ThisWord = strtoupper($ThisWord);
    2060. 

  2060. 		} elseif ((substr($ThisWord, 0, 2) == 'Mc') && (strlen($ThisWord) > 2)) {
    2061. 

  2061. 			$ThisWord{2} = strtoupper($ThisWord{2});
    2062. 

  2062. 		} elseif ((substr($ThisWord, 0, 3) == 'Mac') && (strlen($ThisWord) > 3)) {
    2063. 

  2063. 			$ThisWord{3} = strtoupper($ThisWord{3});
    2064. 

  2064. 		}
    2065. 

  2065. 		$OutputListOfWords[] = $ThisWord;
    2066. 

  2066. 	}
    2067. 

  2067. 	$UCstring = implode(' ', $OutputListOfWords);
    2068. 

  2068. 	$UCstring = str_replace(' From “', ' from “', $UCstring);
    2069. 

  2069. 	$UCstring = str_replace(' \'n\' ', ' \'N\' ', $UCstring);
    2070. 

  2070. 

  2071. 	return $UCstring;
    2072. 

  2072. }
    2073. 

  2073. 

  2074. 

  2075. 

  2076. echo '<hr><form action="'.FixTextFields($_SERVER['PHP_SELF']).'">';
    2077. 

  2077. echo '<b>Warning:</b> Scanning a new directory will erase all previous entries in the database!<br>';
    2078. 

  2078. echo 'Directory: <input type="text" name="scan" size="50" value="'.FixTextFields(!empty($_REQUEST['scan']) ? $_REQUEST['scan'] : '').'"> ';
    2079. 

  2079. 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?\');">';
    2080. 

  2080. echo '</form>';
    2081. 

  2081. echo '<hr><form action="'.FixTextFields($_SERVER['PHP_SELF']).'">';
    2082. 

  2082. echo 'Re-scanning a new directory will only add new, previously unscanned files into the list (and not erase the database).<br>';
    2083. 

  2083. echo 'Directory: <input type="text" name="newscan" size="50" value="'.FixTextFields(!empty($_REQUEST['newscan']) ? $_REQUEST['newscan'] : '').'"> ';
    2084. 

  2084. echo '<input type="SUBMIT" value="Go">';
    2085. 

  2085. echo '</form><hr>';
    2086. 

  2086. echo '<ul>';
    2087. 

  2087. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?deadfilescheck=1">Remove deleted or changed files from database</a></li>';
    2088. 

  2088. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?md5datadupes=1">List files with identical MD5_DATA values</a></li>';
    2089. 

  2089. echo '<li><a href="'.$_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>';
    2090. 

  2090. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?fileextensions=1">File with incorrect file extension</a></li>';
    2091. 

  2091. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?formatdistribution=1">File Format Distribution</a></li>';
    2092. 

  2092. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?audiobitrates=1">Audio Bitrate Distribution</a></li>';
    2093. 

  2093. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?vbrmethod=1">VBR_Method Distribution</a></li>';
    2094. 

  2094. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?tagtypes=1">Tag Type Distribution</a></li>';
    2095. 

  2095. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?genredistribution='.urlencode('%').'">Genre Distribution</a></li>';
    2096. 

  2096. //echo '<li><a href="'.$_SERVER['PHP_SELF'].'?missingtrackvolume=1">Scan for missing track volume information (update database from pre-v1.7.0b5)</a></li>';
    2097. 

  2097. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1">Encoder Options Distribution</a></li>';
    2098. 

  2098. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%').'">Encoded By (ID3v2) Distribution</a></li>';
    2099. 

  2099. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?trackinalbum=1">Track number in Album field</a></li>';
    2100. 

  2100. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?tracknoalbum=1">Track number, but no Album</a></li>';
    2101. 

  2101. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?titlefeat=1">"feat." in Title field</a></li>';
    2102. 

  2102. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?emptygenres=1">Blank genres</a></li>';
    2103. 

  2103. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?trackzero=1">Track "zero"</a></li>';
    2104. 

  2104. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?nonemptycomments=1">non-empty comments</a></li>';
    2105. 

  2105. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?unsynchronizedtags=2A1">Tags that are not synchronized</a> (<a href="'.$_SERVER['PHP_SELF'].'?unsynchronizedtags=2A1&autofix=1">autofix</a>)</li>';
    2106. 

  2106. echo '<li><a href="'.$_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>';
    2107. 

  2107. //echo '<li><a href="'.$_SERVER['PHP_SELF'].'?filenamepattern='.urlencode('A - T').'">Filenames that don\'t match pattern</a></li>';
    2108. 

  2108. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?correctcase=1">Correct filename case (Win/DOS)</a></li>';
    2109. 

  2109. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?fixid3v1padding=1">Fix ID3v1 invalid padding</a></li>';
    2110. 

  2110. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?errorswarnings=1">Files with Errors and/or Warnings</a></li>';
    2111. 

  2111. echo '<li><a href="'.$_SERVER['PHP_SELF'].'?rescanerrors=1">Re-scan only files with Errors and/or Warnings</a></li>';
    2112. 

  2112. echo '</ul>';
    2113. 

  2113. 

  2114. $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`';
    2115. 

  2115. $SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    2116. 

  2116. $result = mysql_query($SQLquery);
    2117. 

  2117. if ($row = mysql_fetch_array($result)) {
    2118. 

  2118. 	echo '<hr><b>Currently in the database:</b><TABLE>';
    2119. 

  2119. 	echo '<tr><TH ALIGN="LEFT">Total Files</th><td>'.number_format($row['TotalFiles']).'</td></tr>';
    2120. 

  2120. 	echo '<tr><TH ALIGN="LEFT">Total Filesize</th><td>'.number_format($row['TotalFilesize'] / 1048576).' MB</td></tr>';
    2121. 

  2121. 	echo '<tr><TH ALIGN="LEFT">Total Playtime</th><td>'.number_format($row['TotalPlaytime'] / 3600, 1).' hours</td></tr>';
    2122. 

  2122. 	echo '<tr><TH ALIGN="LEFT">Average Filesize</th><td>'.number_format($row['AvgFilesize'] / 1048576, 1).' MB</td></tr>';
    2123. 

  2123. 	echo '<tr><TH ALIGN="LEFT">Average Playtime</th><td>'.getid3_lib::PlaytimeString($row['AvgPlaytime']).'</td></tr>';
    2124. 

  2124. 	echo '<tr><TH ALIGN="LEFT">Average Bitrate</th><td>'.BitrateText($row['AvgBitrate'] / 1000, 1).'</td></tr>';
    2125. 

  2125. 	echo '</table>';
    2126. 

  2126. }
    2127. 

  2127. 

  2128. ?>
    2129. 

  2129. </BODY>
    2130. 

  2130. </HTML>
    2131.