PageRenderTime 47ms CodeModel.GetById 12ms RepoModel.GetById 0ms app.codeStats 0ms

/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

Large files files are truncated, but you can click here to view the full file

    

  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. 						$t…
    1161.

Large files files are truncated, but you can click here to view the full file