PageRenderTime 64ms CodeModel.GetById 14ms RepoModel.GetById 0ms app.codeStats 1ms

/common/libraries/plugin/getid3/demos/demo.mysql.php

https://bitbucket.org/chamilo/chamilo/
PHP | 1528 lines | 1254 code | 214 blank | 60 comment | 207 complexity | 712d2a572e2d1745258e9f7f0fd93145 MD5 | raw file
Possible License(s): GPL-2.0, BSD-3-Clause, LGPL-2.1, LGPL-3.0, GPL-3.0, MIT

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. 

  16. //die('Due to a security issue, this demo has been disabled. It can be enabled by removing line 16 in demos/demo.mysql.php');
    17. 

  17. 

  18. 

  19. // OPTIONS:
    20. 

  20. $getid3_demo_mysql_encoding = 'ISO-8859-1';
    21. 

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

  22. $getid3_demo_mysql_md5_file = false;
    23. 

  23. 

  24. define('GETID3_DB_HOST',  'localhost');
    25. 

  25. define('GETID3_DB_USER',  'root');
    26. 

  26. define('GETID3_DB_PASS',  'password');
    27. 

  27. define('GETID3_DB_DB',    'getid3');
    28. 

  28. define('GETID3_DB_TABLE', 'files');
    29. 

  29. 

  30. // CREATE DATABASE `getid3`;
    31. 

  31. 

  32. if (!@mysql_connect(GETID3_DB_HOST, GETID3_DB_USER, GETID3_DB_PASS)) {
    33. 

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

  34. }
    35. 

  35. if (!@mysql_select_db(GETID3_DB_DB)) {
    36. 

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

  37. }
    38. 

  38. 

  39. if (!@include_once('../getid3/getid3.php')) {
    40. 

  40. 	die('Cannot open '.realpath('../getid3/getid3.php'));
    41. 

  41. }
    42. 

  42. // Initialize getID3 engine
    43. 

  43. $getID3 = new getID3;
    44. 

  44. $getID3->setOption(array(
    45. 

  45. 	'option_md5_data' => $getid3_demo_mysql_md5_data,
    46. 

  46. 	'encoding'        => $getid3_demo_mysql_encoding,
    47. 

  47. ));
    48. 

  48. 

  49. 

  50. function RemoveAccents($string) {
    51. 

  51. 	// Revised version by marksteward?hotmail*com
    52. 

  52. 	return strtr(strtr($string, '&#x160;&#x17D;&#x161;&#x17E;&#x;?ÁÂ?Ä?Ç?É?Ë?ÍÎ???ÓÔ?Ö??Ú?ÜÝ?áâ?ä?ç?é?ë?íî???óô?ö??ú?üý?', 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy'), array('?' => 'TH', '?' => 'th', '?' => 'DH', '?' => 'dh', 'ß' => 'ss', '&#x152;' => 'OE', '&#x153;' => 'oe', '?' => 'AE', '?' => 'ae', '?' => 'u'));
    53. 

  53. }
    54. 

  54. 

  55. function FixTextFields($text) {
    56. 

  56. 	$text = getid3_lib::SafeStripSlashes($text);
    57. 

  57. 	$text = htmlentities($text, ENT_QUOTES);
    58. 

  58. 	return $text;
    59. 

  59. }
    60. 

  60. 

  61. function BitrateColor($bitrate, $BitrateMaxScale=768) {
    62. 

  62. 	// $BitrateMaxScale is bitrate of maximum-quality color (bright green)
    63. 

  63. 	// below this is gradient, above is solid green
    64. 

  64. 

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

  66. 	$bitrate = round(min(max($bitrate, 1), 256));
    67. 

  67. 	$bitrate--;    // scale from 1-256kbps to 0-255kbps
    68. 

  68. 

  69. 	$Rcomponent = max(255 - ($bitrate * 2), 0);
    70. 

  70. 	$Gcomponent = max(($bitrate * 2) - 255, 0);
    71. 

  71. 	if ($bitrate > 127) {
    72. 

  72. 		$Bcomponent = max((255 - $bitrate) * 2, 0);
    73. 

  73. 	} else {
    74. 

  74. 		$Bcomponent = max($bitrate * 2, 0);
    75. 

  75. 	}
    76. 

  76. 	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);
    77. 

  77. }
    78. 

  78. 

  79. function BitrateText($bitrate, $decimals=0) {
    80. 

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

  81. }
    82. 

  82. 

  83. function fileextension($filename, $numextensions=1) {
    84. 

  84. 	if (strstr($filename, '.')) {
    85. 

  85. 		$reversedfilename = strrev($filename);
    86. 

  86. 		$offset = 0;
    87. 

  87. 		for ($i = 0; $i < $numextensions; $i++) {
    88. 

  88. 			$offset = strpos($reversedfilename, '.', $offset + 1);
    89. 

  89. 			if ($offset === false) {
    90. 

  90. 				return '';
    91. 

  91. 			}
    92. 

  92. 		}
    93. 

  93. 		return strrev(substr($reversedfilename, 0, $offset));
    94. 

  94. 	}
    95. 

  95. 	return '';
    96. 

  96. }
    97. 

  97. 

  98. function RenameFileFromTo($from, $to, &$results) {
    99. 

  99. 	$success = true;
    100. 

  100. 	if ($from === $to) {
    101. 

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

  102. 	} elseif (!file_exists($from)) {
    103. 

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

  104. 	} elseif (file_exists($to) && (strtolower($from) !== strtolower($to))) {
    105. 

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

  106. 	} elseif (@rename($from, $to)) {
    107. 

  107. 		$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    108. 

  108. 		$SQLquery .= ' WHERE (`filename` = "'.mysql_escape_string($from).'")';
    109. 

  109. 		safe_mysql_query($SQLquery);
    110. 

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

  111. 	} else {
    112. 

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

  113. 		$success = false;
    114. 

  114. 	}
    115. 

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

  116. 	return $success;
    117. 

  117. }
    118. 

  118. 

  119. if (!empty($_REQUEST['renamefilefrom']) && !empty($_REQUEST['renamefileto'])) {
    120. 

  120. 

  121. 	$results = '';
    122. 

  122. 	RenameFileFromTo($_REQUEST['renamefilefrom'], $_REQUEST['renamefileto'], $results);
    123. 

  123. 	echo $results;
    124. 

  124. 	exit;
    125. 

  125. 

  126. } elseif (!empty($_REQUEST['m3ufilename'])) {
    127. 

  127. 

  128. 	header('Content-type: audio/x-mpegurl');
    129. 

  129. 	echo '#EXTM3U'."\n";
    130. 

  130. 	echo WindowsShareSlashTranslate($_REQUEST['m3ufilename'])."\n";
    131. 

  131. 	exit;
    132. 

  132. 

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

  134. 

  135. 	echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">';
    136. 

  136. 	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>';
    137. 

  137. 

  138. }
    139. 

  139. 

  140. 

  141. function WindowsShareSlashTranslate($filename) {
    142. 

  142. 	if (substr($filename, 0, 2) == '//') {
    143. 

  143. 		return str_replace('/', '\\', $filename);
    144. 

  144. 	}
    145. 

  145. 	return $filename;
    146. 

  146. }
    147. 

  147. 

  148. function safe_mysql_query($SQLquery) {
    149. 

  149. 	$result = @mysql_query($SQLquery);
    150. 

  150. 	if (mysql_error()) {
    151. 

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

  152. 	}
    153. 

  153. 	return $result;
    154. 

  154. }
    155. 

  155. 

  156. function mysql_table_exists($tablename) {
    157. 

  157. 	return (bool) mysql_query('DESCRIBE '.$tablename);
    158. 

  158. }
    159. 

  159. 

  160. function AcceptableExtensions($fileformat, $audio_dataformat='', $video_dataformat='') {
    161. 

  161. 	static $AcceptableExtensionsAudio = array();
    162. 

  162. 	if (empty($AcceptableExtensionsAudio)) {
    163. 

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

  164. 		$AcceptableExtensionsAudio['mp2']['mp2']  = array('mp2');
    165. 

  165. 		$AcceptableExtensionsAudio['mp1']['mp1']  = array('mp1');
    166. 

  166. 		$AcceptableExtensionsAudio['asf']['asf']  = array('asf');
    167. 

  167. 		$AcceptableExtensionsAudio['asf']['wma']  = array('wma');
    168. 

  168. 		$AcceptableExtensionsAudio['riff']['mp3'] = array('wav');
    169. 

  169. 		$AcceptableExtensionsAudio['riff']['wav'] = array('wav');
    170. 

  170. 	}
    171. 

  171. 	static $AcceptableExtensionsVideo = array();
    172. 

  172. 	if (empty($AcceptableExtensionsVideo)) {
    173. 

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

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

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

  176. 		$AcceptableExtensionsVideo['asf']['asf']  = array('asf');
    177. 

  177. 		$AcceptableExtensionsVideo['asf']['wmv']  = array('wmv');
    178. 

  178. 		$AcceptableExtensionsVideo['gif']['gif']  = array('gif');
    179. 

  179. 		$AcceptableExtensionsVideo['jpg']['jpg']  = array('jpg');
    180. 

  180. 		$AcceptableExtensionsVideo['png']['png']  = array('png');
    181. 

  181. 		$AcceptableExtensionsVideo['bmp']['bmp']  = array('bmp');
    182. 

  182. 	}
    183. 

  183. 	if (!empty($video_dataformat)) {
    184. 

  184. 		return (isset($AcceptableExtensionsVideo[$fileformat][$video_dataformat]) ? $AcceptableExtensionsVideo[$fileformat][$video_dataformat] : array());
    185. 

  185. 	} else {
    186. 

  186. 		return (isset($AcceptableExtensionsAudio[$fileformat][$audio_dataformat]) ? $AcceptableExtensionsAudio[$fileformat][$audio_dataformat] : array());
    187. 

  187. 	}
    188. 

  188. }
    189. 

  189. 

  190. 

  191. if (!empty($_REQUEST['scan'])) {
    192. 

  192. 	if (mysql_table_exists(GETID3_DB_TABLE)) {
    193. 

  193. 		$SQLquery  = 'DROP TABLE `'.GETID3_DB_TABLE.'`';
    194. 

  194. 		safe_mysql_query($SQLquery);
    195. 

  195. 	}
    196. 

  196. }
    197. 

  197. if (!mysql_table_exists(GETID3_DB_TABLE)) {
    198. 

  198. 	$SQLquery  = 'CREATE TABLE `'.GETID3_DB_TABLE.'` (';
    199. 

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

  200. 	$SQLquery .= ' `filename` text NOT NULL,';
    201. 

  201. 	$SQLquery .= ' `LastModified` int(11) NOT NULL default "0",';
    202. 

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

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

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

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

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

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

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

  209. 	$SQLquery .= ' `audio_bitrate` float NOT NULL default "0",';
    210. 

  210. 	$SQLquery .= ' `video_bitrate` float NOT NULL default "0",';
    211. 

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

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

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

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

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

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

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

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

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

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

  221. 	$SQLquery .= ' `comments_id3v2` text NOT NULL,';
    222. 

  222. 	$SQLquery .= ' `comments_ape` text NOT NULL,';
    223. 

  223. 	$SQLquery .= ' `comments_lyrics3` text NOT NULL,';
    224. 

  224. 	$SQLquery .= ' `comments_id3v1` text NOT NULL,';
    225. 

  225. 	$SQLquery .= ' `warning` text NOT NULL,';
    226. 

  226. 	$SQLquery .= ' `error` text NOT NULL,';
    227. 

  227. 	$SQLquery .= ' `track_volume` float NOT NULL default "0",';
    228. 

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

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

  230. 	$SQLquery .= ' PRIMARY KEY (`ID`)';
    231. 

  231. 	$SQLquery .= ') TYPE=MyISAM;';
    232. 

  232. 

  233. 	safe_mysql_query($SQLquery);
    234. 

  234. }
    235. 

  235. 

  236. $ExistingTableFields = array();
    237. 

  237. $result = mysql_query('DESCRIBE `'.GETID3_DB_TABLE.'`');
    238. 

  238. while ($row = mysql_fetch_array($result)) {
    239. 

  239. 	$ExistingTableFields[$row['Field']] = $row;
    240. 

  240. }
    241. 

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

  242. 	echo '<b>adding field `encoder_options`</b><br>';
    243. 

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

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

  245. }
    246. 

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

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

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

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

  250. }
    251. 

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

  252. 	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>';
    253. 

  253. 	echo '<b>adding field `track_volume`</b><br>';
    254. 

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

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

  256. }
    257. 

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

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

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

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

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

  262. 	mysql_query('OPTIMIZE TABLE `'.GETID3_DB_TABLE.'`');
    263. 

  263. }
    264. 

  264. 

  265. 

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

  267. 	global $getID3;
    268. 

  268. 

  269. 	set_time_limit(30);
    270. 

  270. 

  271. 	$ThisFileInfo = $getID3->analyze($filename);
    272. 

  272. 	getid3_lib::CopyTagsToComments($ThisFileInfo);
    273. 

  273. 

  274. 	if ($synchronizefrom == 'all') {
    275. 

  275. 		$SourceArray = @$ThisFileInfo['comments'];
    276. 

  276. 	} elseif (!empty($ThisFileInfo['tags'][$synchronizefrom])) {
    277. 

  277. 		$SourceArray = @$ThisFileInfo['tags'][$synchronizefrom];
    278. 

  278. 	} else {
    279. 

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

  280. 	}
    281. 

  281. 

  282. 	$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    283. 

  283. 	$SQLquery .= ' WHERE (`filename` = "'.mysql_escape_string($filename).'")';
    284. 

  284. 	safe_mysql_query($SQLquery);
    285. 

  285. 

  286. 

  287. 	$TagFormatsToWrite = array();
    288. 

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

  289. 		$TagFormatsToWrite[] = 'id3v2.3';
    290. 

  290. 	}
    291. 

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

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

  293. 	}
    294. 

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

  295. 		$TagFormatsToWrite[] = 'lyrics3';
    296. 

  296. 	}
    297. 

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

  298. 		$TagFormatsToWrite[] = 'id3v1';
    299. 

  299. 	}
    300. 

  300. 

  301. 	getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'write.php', __FILE__, true);
    302. 

  302. 	$tagwriter = new getid3_writetags;
    303. 

  303. 	$tagwriter->filename       = $filename;
    304. 

  304. 	$tagwriter->tagformats     = $TagFormatsToWrite;
    305. 

  305. 	$tagwriter->overwrite_tags = true;
    306. 

  306. 	$tagwriter->tag_encoding   = $getID3->encoding;
    307. 

  307. 	$tagwriter->tag_data       = $SourceArray;
    308. 

  308. 

  309. 	if ($tagwriter->WriteTags()) {
    310. 

  310. 		$errors = $tagwriter->errors;
    311. 

  311. 		return true;
    312. 

  312. 	}
    313. 

  313. 	$errors = $tagwriter->errors;
    314. 

  314. 	return false;
    315. 

  315. }
    316. 

  316. 

  317. $IgnoreNoTagFormats = array('', 'png', 'jpg', 'gif', 'bmp', 'swf', 'pdf', 'zip', 'rar', 'mid', 'mod', 'xm', 'it', 's3m');
    318. 

  318. 

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

  320. 

  321. 	$SQLquery  = 'DELETE from `'.GETID3_DB_TABLE.'`';
    322. 

  322. 	$SQLquery .= ' WHERE (`fileformat` = "")';
    323. 

  323. 	safe_mysql_query($SQLquery);
    324. 

  324. 

  325. 	$FilesInDir = array();
    326. 

  326. 

  327. 	if (!empty($_REQUEST['rescanerrors'])) {
    328. 

  328. 

  329. 		echo '<a href="'.htmlentities($_SERVER['PHP_SELF']).'">abort</a><hr>';
    330. 

  330. 

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

  332. 

  333. 		$SQLquery  = 'SELECT `filename`';
    334. 

  334. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    335. 

  335. 		$SQLquery .= ' WHERE (`error` <> "")';
    336. 

  336. 		$SQLquery .= ' OR (`warning` <> "")';
    337. 

  337. 		$SQLquery .= ' ORDER BY `filename` ASC';
    338. 

  338. 		$result = safe_mysql_query($SQLquery);
    339. 

  339. 		while ($row = mysql_fetch_array($result)) {
    340. 

  340. 

  341. 			if (!file_exists($row['filename'])) {
    342. 

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

  343. 				$SQLquery = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    344. 

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

  345. 				safe_mysql_query($SQLquery);
    346. 

  346. 			} else {
    347. 

  347. 				$FilesInDir[] = $row['filename'];
    348. 

  348. 			}
    349. 

  349. 

  350. 		}
    351. 

  351. 

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

  353. 

  354. 		echo '<a href="'.htmlentities($_SERVER['PHP_SELF']).'">abort</a><hr>';
    355. 

  355. 

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

  357. 

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

  359. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    360. 

  360. 		$SQLquery .= ' GROUP BY `filename`';
    361. 

  361. 		$SQLquery .= ' ORDER BY `num` DESC';
    362. 

  362. 		$result = safe_mysql_query($SQLquery);
    363. 

  363. 		$DupesDeleted = 0;
    364. 

  364. 		while ($row = mysql_fetch_array($result)) {
    365. 

  365. 			set_time_limit(30);
    366. 

  366. 			if ($row['num'] <= 1) {
    367. 

  367. 				break;
    368. 

  368. 			}
    369. 

  369. 			$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    370. 

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

  371. 			safe_mysql_query($SQLquery);
    372. 

  372. 			$DupesDeleted++;
    373. 

  373. 		}
    374. 

  374. 		if ($DupesDeleted > 0) {
    375. 

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

  376. 		}
    377. 

  377. 

  378. 		if (!empty($_REQUEST['newscan'])) {
    379. 

  379. 			$AlreadyInDatabase = array();
    380. 

  380. 			set_time_limit(60);
    381. 

  381. 			$SQLquery  = 'SELECT `filename`';
    382. 

  382. 			$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    383. 

  383. 			$SQLquery .= ' ORDER BY `filename` ASC';
    384. 

  384. 			$result = safe_mysql_query($SQLquery);
    385. 

  385. 			while ($row = mysql_fetch_array($result)) {
    386. 

  386. 				//$AlreadyInDatabase[] = strtolower($row['filename']);
    387. 

  387. 				$AlreadyInDatabase[] = $row['filename'];
    388. 

  388. 			}
    389. 

  389. 		}
    390. 

  390. 

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

  392. 		$DirectoriesScanned = array();
    393. 

  393. 		while (count($DirectoriesToScan) > 0) {
    394. 

  394. 			foreach ($DirectoriesToScan as $DirectoryKey => $startingdir) {
    395. 

  395. 				if ($dir = opendir($startingdir)) {
    396. 

  396. 					set_time_limit(30);
    397. 

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

  398. 					flush();
    399. 

  399. 					while (($file = readdir($dir)) !== false) {
    400. 

  400. 						if (($file != '.') && ($file != '..')) {
    401. 

  401. 							$RealPathName = realpath($startingdir.'/'.$file);
    402. 

  402. 							if (is_dir($RealPathName)) {
    403. 

  403. 								if (!in_array($RealPathName, $DirectoriesScanned) && !in_array($RealPathName, $DirectoriesToScan)) {
    404. 

  404. 									$DirectoriesToScan[] = $RealPathName;
    405. 

  405. 								}
    406. 

  406. 							} else if (is_file($RealPathName)) {
    407. 

  407. 								if (!empty($_REQUEST['newscan'])) {
    408. 

  408. 									if (!in_array(str_replace('\\', '/', $RealPathName), $AlreadyInDatabase)) {
    409. 

  409. 										$FilesInDir[] = $RealPathName;
    410. 

  410. 									}
    411. 

  411. 								} elseif (!empty($_REQUEST['scan'])) {
    412. 

  412. 									$FilesInDir[] = $RealPathName;
    413. 

  413. 								}
    414. 

  414. 							}
    415. 

  415. 						}
    416. 

  416. 					}
    417. 

  417. 					closedir($dir);
    418. 

  418. 				} else {
    419. 

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

  420. 				}
    421. 

  421. 				$DirectoriesScanned[] = $startingdir;
    422. 

  422. 				unset($DirectoriesToScan[$DirectoryKey]);
    423. 

  423. 			}
    424. 

  424. 		}
    425. 

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

  426. 		flush();
    427. 

  427. 	}
    428. 

  428. 

  429. 	$FilesInDir = array_unique($FilesInDir);
    430. 

  430. 	sort($FilesInDir);
    431. 

  431. 

  432. 	$starttime = time();
    433. 

  433. 	$rowcounter = 0;
    434. 

  434. 	$totaltoprocess = count($FilesInDir);
    435. 

  435. 

  436. 	foreach ($FilesInDir as $filename) {
    437. 

  437. 		set_time_limit(300);
    438. 

  438. 

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

  440. 

  441. 		$ThisFileInfo = $getID3->analyze($filename);
    442. 

  442. 		getid3_lib::CopyTagsToComments($ThisFileInfo);
    443. 

  443. 

  444. 		if (file_exists($filename)) {
    445. 

  445. 			$ThisFileInfo['file_modified_time'] = filemtime($filename);
    446. 

  446. 			$ThisFileInfo['md5_file']           = ($getid3_demo_mysql_md5_file ? md5_file($filename) : '');
    447. 

  447. 		}
    448. 

  448. 

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

  450. 

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

  452. 

  453. 		} else {
    454. 

  454. 

  455. 			if (!empty($ThisFileInfo['error'])) {
    456. 

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

  457. 			} elseif (!empty($ThisFileInfo['warning'])) {
    458. 

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

  459. 			} else {
    460. 

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

  461. 			}
    462. 

  462. 

  463. 			$this_track_track = '';
    464. 

  464. 			if (!empty($ThisFileInfo['comments']['track'])) {
    465. 

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

  466. 					if (strlen($value) > strlen($this_track_track)) {
    467. 

  467. 						$this_track_track = str_pad($value, 2, '0', STR_PAD_LEFT);
    468. 

  468. 					}
    469. 

  469. 				}
    470. 

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

  471. 					// change "1/5"->"01/05", "3/12"->"03/12", etc
    472. 

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

  473. 				}
    474. 

  474. 			}
    475. 

  475. 

  476. 			$this_track_remix = '';
    477. 

  477. 			$this_track_title = '';
    478. 

  478. 			if (!empty($ThisFileInfo['comments']['title'])) {
    479. 

  479. 				foreach ($ThisFileInfo['comments']['title'] as $possible_title) {
    480. 

  480. 					if (strlen($possible_title) > strlen($this_track_title)) {
    481. 

  481. 						$this_track_title = $possible_title;
    482. 

  482. 					}
    483. 

  483. 				}
    484. 

  484. 			}
    485. 

  485. 

  486. 			$ParenthesesPairs = array('()', '[]', '{}');
    487. 

  487. 			foreach ($ParenthesesPairs as $pair) {
    488. 

  488. 				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)) {
    489. 

  489. 					$this_track_title = $matches[1][0];
    490. 

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

  491. 				}
    492. 

  492. 			}
    493. 

  493. 

  494. 

  495. 

  496. 			if (!empty($_REQUEST['rescanerrors'])) {
    497. 

  497. 

  498. 				$SQLquery  = 'UPDATE `'.GETID3_DB_TABLE.'` SET ';
    499. 

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

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

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

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

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

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

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

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

  507. 				$SQLquery .= '`audio_bitrate` = "'.mysql_escape_string(floatval(@$ThisFileInfo['audio']['bitrate'])).'", ';
    508. 

  508. 				$SQLquery .= '`video_bitrate` = "'.mysql_escape_string(floatval(@$ThisFileInfo['video']['bitrate'])).'", ';
    509. 

  509. 				$SQLquery .= '`playtime_seconds` = "'.mysql_escape_string(floatval(@$ThisFileInfo['playtime_seconds'])).'", ';
    510. 

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

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

  512. 

  513. 				$SQLquery .= '`title` = "'.mysql_escape_string($this_track_title).'", ';
    514. 

  514. 				$SQLquery .= '`remix` = "'.mysql_escape_string($this_track_remix).'", ';
    515. 

  515. 

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

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

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

  519. 

  520. 				$SQLquery .= '`track` = "'.mysql_escape_string($this_track_track).'", ';
    521. 

  521. 

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

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

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

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

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

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

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

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

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

  531. 				$SQLquery .= '`track_volume` = "'.mysql_escape_string(floatval(@$ThisFileInfo['replay_gain']['track']['volume'])).'" ';
    532. 

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

  533. 

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

  535. 

  536. 				$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 (';
    537. 

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

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

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

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

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

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

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

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

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

  546. 				$SQLquery .= '"'.mysql_escape_string(floatval(@$ThisFileInfo['audio']['bitrate'])).'", ';
    547. 

  547. 				$SQLquery .= '"'.mysql_escape_string(floatval(@$ThisFileInfo['video']['bitrate'])).'", ';
    548. 

  548. 				$SQLquery .= '"'.mysql_escape_string(floatval(@$ThisFileInfo['playtime_seconds'])).'", ';
    549. 

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

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

  551. 

  552. 				$SQLquery .= '"'.mysql_escape_string($this_track_title).'", ';
    553. 

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

  554. 

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

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

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

  558. 

  559. 				$SQLquery .= '"'.mysql_escape_string($this_track_track).'", ';
    560. 

  560. 

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

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

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

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

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

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

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

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

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

  570. 				$SQLquery .= '"'.mysql_escape_string(floatval(@$ThisFileInfo['replay_gain']['track']['volume'])).'")';
    571. 

  571. 

  572. 			}
    573. 

  573. 			flush();
    574. 

  574. 			safe_mysql_query($SQLquery);
    575. 

  575. 		}
    576. 

  576. 

  577. 	}
    578. 

  578. 

  579. 	$SQLquery = 'OPTIMIZE TABLE `'.GETID3_DB_TABLE.'`';
    580. 

  580. 	safe_mysql_query($SQLquery);
    581. 

  581. 

  582. 	echo '<hr>Done scanning!<hr>';
    583. 

  583. 

  584. } elseif (!empty($_REQUEST['missingtrackvolume'])) {
    585. 

  585. 

  586. 	$MissingTrackVolumeFilesScanned  = 0;
    587. 

  587. 	$MissingTrackVolumeFilesAdjusted = 0;
    588. 

  588. 	$MissingTrackVolumeFilesDeleted  = 0;
    589. 

  589. 	$SQLquery  = 'SELECT `filename`';
    590. 

  590. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    591. 

  591. 	$SQLquery .= ' WHERE (`track_volume` = "0")';
    592. 

  592. 	$SQLquery .= ' AND (`audio_bitrate` > "0")';
    593. 

  593. 	$result = safe_mysql_query($SQLquery);
    594. 

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

  595. 	while ($row = mysql_fetch_array($result)) {
    596. 

  596. 		set_time_limit(30);
    597. 

  597. 		echo '<script type="text/javascript">if (document.getElementById("missingtrackvolumeNowScanning")) document.getElementById("missingtrackvolumeNowScanning").innerHTML = "'.number_format($MissingTrackVolumeFilesScanned++).'";</script>. ';
    598. 

  598. 		flush();
    599. 

  599. 		if (file_exists($row['filename'])) {
    600. 

  600. 

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

  602. 			if (!empty($ThisFileInfo['replay_gain']['track']['volume'])) {
    603. 

  603. 				$MissingTrackVolumeFilesAdjusted++;
    604. 

  604. 				$SQLquery  = 'UPDATE `'.GETID3_DB_TABLE.'`';
    605. 

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

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

  607. 				safe_mysql_query($SQLquery);
    608. 

  608. 			}
    609. 

  609. 

  610. 		} else {
    611. 

  611. 

  612. 			$MissingTrackVolumeFilesDeleted++;
    613. 

  613. 			$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    614. 

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

  615. 			safe_mysql_query($SQLquery);
    616. 

  616. 

  617. 		}
    618. 

  618. 	}
    619. 

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

  620. 	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>';
    621. 

  621. 

  622. } elseif (!empty($_REQUEST['deadfilescheck'])) {
    623. 

  623. 

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

  625. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    626. 

  626. 	$SQLquery .= ' GROUP BY `filename`';
    627. 

  627. 	$SQLquery .= ' ORDER BY `num` DESC';
    628. 

  628. 	$result = safe_mysql_query($SQLquery);
    629. 

  629. 	$DupesDeleted = 0;
    630. 

  630. 	while ($row = mysql_fetch_array($result)) {
    631. 

  631. 		set_time_limit(30);
    632. 

  632. 		if ($row['num'] <= 1) {
    633. 

  633. 			break;
    634. 

  634. 		}
    635. 

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

  636. 		$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    637. 

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

  638. 		safe_mysql_query($SQLquery);
    639. 

  639. 		$DupesDeleted++;
    640. 

  640. 	}
    641. 

  641. 	if ($DupesDeleted > 0) {
    642. 

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

  643. 	}
    644. 

  644. 

  645. 	$SQLquery  = 'SELECT `filename`, `filesize`, `LastModified`';
    646. 

  646. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    647. 

  647. 	$SQLquery .= ' ORDER BY `filename` ASC';
    648. 

  648. 	$result = safe_mysql_query($SQLquery);
    649. 

  649. 	$totalchecked = 0;
    650. 

  650. 	$totalremoved = 0;
    651. 

  651. 	$previousdir = '';
    652. 

  652. 	while ($row = mysql_fetch_array($result)) {
    653. 

  653. 		$totalchecked++;
    654. 

  654. 		set_time_limit(30);
    655. 

  655. 		$reason = '';
    656. 

  656. 		if (!file_exists($row['filename'])) {
    657. 

  657. 			$reason = 'deleted';
    658. 

  658. 		} elseif (filesize($row['filename']) != $row['filesize']) {
    659. 

  659. 			$reason = 'filesize changed';
    660. 

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

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

  662. 				// off by exactly one hour == daylight savings time
    663. 

  663. 				$reason = 'last-modified time changed';
    664. 

  664. 			}
    665. 

  665. 		}
    666. 

  666. 

  667. 		$thisdir = dirname($row['filename']);
    668. 

  668. 		if ($reason) {
    669. 

  669. 

  670. 			$totalremoved++;
    671. 

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

  672. 			flush();
    673. 

  673. 			$SQLquery  = 'DELETE FROM `'.GETID3_DB_TABLE.'`';
    674. 

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

  675. 			safe_mysql_query($SQLquery);
    676. 

  676. 

  677. 		} elseif ($thisdir != $previousdir) {
    678. 

  678. 

  679. 			echo '. ';
    680. 

  680. 			flush();
    681. 

  681. 

  682. 		}
    683. 

  683. 		$previousdir = $thisdir;
    684. 

  684. 	}
    685. 

  685. 

  686. 	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>';
    687. 

  687. 

  688. } elseif (!empty($_REQUEST['encodedbydistribution'])) {
    689. 

  689. 

  690. 	if (!empty($_REQUEST['m3u'])) {
    691. 

  691. 

  692. 		header('Content-type: audio/x-mpegurl');
    693. 

  693. 		echo '#EXTM3U'."\n";
    694. 

  694. 

  695. 		$SQLquery  = 'SELECT `filename`, `comments_id3v2`';
    696. 

  696. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    697. 

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

  698. 		$result = mysql_query($SQLquery);
    699. 

  699. 		$NonBlankEncodedBy = '';
    700. 

  700. 		$BlankEncodedBy = '';
    701. 

  701. 		while ($row = mysql_fetch_array($result)) {
    702. 

  702. 			set_time_limit(30);
    703. 

  703. 			$CommentArray = unserialize($row['comments_id3v2']);
    704. 

  704. 			if (isset($CommentArray['encoded_by'][0])) {
    705. 

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

  706. 			} else {
    707. 

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

  708. 			}
    709. 

  709. 		}
    710. 

  710. 		echo $NonBlankEncodedBy;
    711. 

  711. 		echo $BlankEncodedBy;
    712. 

  712. 		exit;
    713. 

  713. 

  714. 	} elseif (!empty($_REQUEST['showfiles'])) {
    715. 

  715. 

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

  717. 		echo '<table border="1">';
    718. 

  718. 

  719. 		$SQLquery  = 'SELECT `filename`, `comments_id3v2`';
    720. 

  720. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    721. 

  721. 		$result = mysql_query($SQLquery);
    722. 

  722. 		while ($row = mysql_fetch_array($result)) {
    723. 

  723. 			set_time_limit(30);
    724. 

  724. 			$CommentArray = unserialize($row['comments_id3v2']);
    725. 

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

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

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

  728. 			}
    729. 

  729. 		}
    730. 

  730. 		echo '</table>';
    731. 

  731. 

  732. 	} else {
    733. 

  733. 

  734. 		$SQLquery  = 'SELECT `encoder_options`, `comments_id3v2`';
    735. 

  735. 		$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    736. 

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

  737. 		$result = mysql_query($SQLquery);
    738. 

  738. 		$EncodedBy = array();
    739. 

  739. 		while ($row = mysql_fetch_array($result)) {
    740. 

  740. 			set_time_limit(30);
    741. 

  741. 			$CommentArray = unserialize($row['comments_id3v2']);
    742. 

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

  743. 				$EncodedBy[$row['encoder_options']][@$CommentArray['encoded_by'][0]]++;
    744. 

  744. 			} else {
    745. 

  745. 				$EncodedBy[$row['encoder_options']][@$CommentArray['encoded_by'][0]] = 1;
    746. 

  746. 			}
    747. 

  747. 		}
    748. 

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

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

  750. 		foreach ($EncodedBy as $key => $value) {
    751. 

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

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

  753. 			echo '<td><table border="0" WIDTH="100%">';
    754. 

  754. 			arsort($value);
    755. 

  755. 			foreach ($value as $string => $count) {
    756. 

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

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

  758. 			}
    759. 

  759. 			echo '</table></td></tr>';
    760. 

  760. 		}
    761. 

  761. 		echo '</table>';
    762. 

  762. 

  763. 	}
    764. 

  764. 

  765. } elseif (!empty($_REQUEST['audiobitrates'])) {
    766. 

  766. 

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

  768. 	$BitrateDistribution = array();
    769. 

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

  770. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    771. 

  771. 	$SQLquery .= ' WHERE (`audio_bitrate` > 0)';
    772. 

  772. 	$SQLquery .= ' GROUP BY `RoundBitrate`';
    773. 

  773. 	$result = safe_mysql_query($SQLquery);
    774. 

  774. 	while ($row = mysql_fetch_array($result)) {
    775. 

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

  776. 	}
    777. 

  777. 

  778. 	echo '<table border="1" cellspacing="0" cellpadding="3">';
    779. 

  779. 	echo '<tr><th>Bitrate</th><th>Count</th></tr>';
    780. 

  780. 	foreach ($BitrateDistribution as $Bitrate => $Count) {
    781. 

  781. 		echo '<tr>';
    782. 

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

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

  784. 		echo '</tr>';
    785. 

  785. 	}
    786. 

  786. 	echo '</table>';
    787. 

  787. 

  788. 

  789. } elseif (!empty($_REQUEST['emptygenres'])) {
    790. 

  790. 

  791. 	$SQLquery  = 'SELECT `fileformat`, `filename`, `genre`';
    792. 

  792. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    793. 

  793. 	$SQLquery .= ' WHERE (`genre` = "")';
    794. 

  794. 	$SQLquery .= ' OR (`genre` = "Unknown")';
    795. 

  795. 	$SQLquery .= ' OR (`genre` = "Other")';
    796. 

  796. 	$SQLquery .= ' ORDER BY `filename` ASC';
    797. 

  797. 	$result = safe_mysql_query($SQLquery);
    798. 

  798. 

  799. 	if (!empty($_REQUEST['m3u'])) {
    800. 

  800. 

  801. 		header('Content-type: audio/x-mpegurl');
    802. 

  802. 		echo '#EXTM3U'."\n";
    803. 

  803. 		while ($row = mysql_fetch_array($result)) {
    804. 

  804. 			if (!in_array($row['fileformat'], $IgnoreNoTagFormats)) {
    805. 

  805. 				echo WindowsShareSlashTranslate($row['filename'])."\n";
    806. 

  806. 			}
    807. 

  807. 		}
    808. 

  808. 		exit;
    809. 

  809. 

  810. 	} else {
    811. 

  811. 

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

  813. 		$EmptyGenreCounter = 0;
    814. 

  814. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    815. 

  815. 		echo '<tr><th>m3u</th><th>filename</th></tr>';
    816. 

  816. 		while ($row = mysql_fetch_array($result)) {
    817. 

  817. 			if (!in_array($row['fileformat'], $IgnoreNoTagFormats)) {
    818. 

  818. 				$EmptyGenreCounter++;
    819. 

  819. 				echo '<tr>';
    820. 

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

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

  822. 				echo '</tr>';
    823. 

  823. 			}
    824. 

  824. 		}
    825. 

  825. 		echo '</table>';
    826. 

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

  827. 

  828. 	}
    829. 

  829. 

  830. } elseif (!empty($_REQUEST['nonemptycomments'])) {
    831. 

  831. 

  832. 	$SQLquery  = 'SELECT `filename`, `comment`';
    833. 

  833. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    834. 

  834. 	$SQLquery .= ' WHERE (`comment` <> "")';
    835. 

  835. 	$SQLquery .= ' ORDER BY `comment` ASC';
    836. 

  836. 	$result = safe_mysql_query($SQLquery);
    837. 

  837. 

  838. 	if (!empty($_REQUEST['m3u'])) {
    839. 

  839. 

  840. 		header('Content-type: audio/x-mpegurl');
    841. 

  841. 		echo '#EXTM3U'."\n";
    842. 

  842. 		while ($row = mysql_fetch_array($result)) {
    843. 

  843. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    844. 

  844. 		}
    845. 

  845. 		exit;
    846. 

  846. 

  847. 	} else {
    848. 

  848. 

  849. 		$NonEmptyCommentsCounter = 0;
    850. 

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

  851. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    852. 

  852. 		echo '<tr><th>m3u</th><th>filename</th><th>comments</th></tr>';
    853. 

  853. 		while ($row = mysql_fetch_array($result)) {
    854. 

  854. 			$NonEmptyCommentsCounter++;
    855. 

  855. 			echo '<tr>';
    856. 

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

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

  858. 			if (strlen(trim($row['comment'])) > 0) {
    859. 

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

  860. 			} else {
    861. 

  861. 				echo '<td><i>space</i></td>';
    862. 

  862. 			}
    863. 

  863. 			echo '</tr>';
    864. 

  864. 		}
    865. 

  865. 		echo '</table>';
    866. 

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

  867. 

  868. 	}
    869. 

  869. 

  870. } elseif (!empty($_REQUEST['trackzero'])) {
    871. 

  871. 

  872. 	$SQLquery  = 'SELECT `filename`, `track`';
    873. 

  873. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    874. 

  874. 	$SQLquery .= ' WHERE (`track` <> "")';
    875. 

  875. 	$SQLquery .= ' AND ((`track` < "1")';
    876. 

  876. 	$SQLquery .= ' OR (`track` > "99"))';
    877. 

  877. 	$SQLquery .= ' ORDER BY `filename` ASC';
    878. 

  878. 	$result = safe_mysql_query($SQLquery);
    879. 

  879. 

  880. 	if (!empty($_REQUEST['m3u'])) {
    881. 

  881. 

  882. 		header('Content-type: audio/x-mpegurl');
    883. 

  883. 		echo '#EXTM3U'."\n";
    884. 

  884. 		while ($row = mysql_fetch_array($result)) {
    885. 

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

  886. 				echo WindowsShareSlashTranslate($row['filename'])."\n";
    887. 

  887. 			}
    888. 

  888. 		}
    889. 

  889. 		exit;
    890. 

  890. 

  891. 	} else {
    892. 

  892. 

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

  894. 		$TrackZeroCounter = 0;
    895. 

  895. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    896. 

  896. 		echo '<tr><th>m3u</th><th>filename</th><th>track</th></tr>';
    897. 

  897. 		while ($row = mysql_fetch_array($result)) {
    898. 

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

  899. 				$TrackZeroCounter++;
    900. 

  900. 				echo '<tr>';
    901. 

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

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

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

  904. 				echo '</tr>';
    905. 

  905. 			}
    906. 

  906. 		}
    907. 

  907. 		echo '</table>';
    908. 

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

  909. 

  910. 	}
    911. 

  911. 

  912. 

  913. } elseif (!empty($_REQUEST['titlefeat'])) {
    914. 

  914. 

  915. 	$SQLquery  = 'SELECT `filename`, `title`';
    916. 

  916. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    917. 

  917. 	$SQLquery .= ' WHERE (`title` LIKE "%feat.%")';
    918. 

  918. 	$SQLquery .= ' ORDER BY `filename` ASC';
    919. 

  919. 	$result = safe_mysql_query($SQLquery);
    920. 

  920. 

  921. 	if (!empty($_REQUEST['m3u'])) {
    922. 

  922. 

  923. 		header('Content-type: audio/x-mpegurl');
    924. 

  924. 		echo '#EXTM3U'."\n";
    925. 

  925. 		while ($row = mysql_fetch_array($result)) {
    926. 

  926. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    927. 

  927. 		}
    928. 

  928. 		exit;
    929. 

  929. 

  930. 	} else {
    931. 

  931. 

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

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

  934. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    935. 

  935. 		echo '<tr><th>m3u</th><th>filename</th><th>title</th></tr>';
    936. 

  936. 		while ($row = mysql_fetch_array($result)) {
    937. 

  937. 			echo '<tr>';
    938. 

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

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

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

  941. 			echo '</tr>';
    942. 

  942. 		}
    943. 

  943. 		echo '</table>';
    944. 

  944. 

  945. 	}
    946. 

  946. 

  947. 

  948. } elseif (!empty($_REQUEST['tracknoalbum'])) {
    949. 

  949. 

  950. 	$SQLquery  = 'SELECT `filename`, `track`, `album`';
    951. 

  951. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    952. 

  952. 	$SQLquery .= ' WHERE (`track` <> "")';
    953. 

  953. 	$SQLquery .= ' AND (`album` = "")';
    954. 

  954. 	$SQLquery .= ' ORDER BY `filename` ASC';
    955. 

  955. 	$result = safe_mysql_query($SQLquery);
    956. 

  956. 

  957. 	if (!empty($_REQUEST['m3u'])) {
    958. 

  958. 

  959. 		header('Content-type: audio/x-mpegurl');
    960. 

  960. 		echo '#EXTM3U'."\n";
    961. 

  961. 		while ($row = mysql_fetch_array($result)) {
    962. 

  962. 			echo WindowsShareSlashTranslate($row['filename'])."\n";
    963. 

  963. 		}
    964. 

  964. 		exit;
    965. 

  965. 

  966. 	} else {
    967. 

  967. 

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

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

  970. 		echo '<table border="1" cellspacing="0" cellpadding="3">';
    971. 

  971. 		echo '<tr><th>m3u</th><th>filename</th><th>track</th><th>album</th></tr>';
    972. 

  972. 		while ($row = mysql_fetch_array($result)) {
    973. 

  973. 			echo '<tr>';
    974. 

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

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

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

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

  978. 			echo '</tr>';
    979. 

  979. 		}
    980. 

  980. 		echo '</table>';
    981. 

  981. 

  982. 	}
    983. 

  983. 

  984. 

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

  986. 

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

  988. 	$errors = array();
    989. 

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

  990. 		echo '<li>Sucessfully wrote tags</li>';
    991. 

  991. 	} else {
    992. 

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

  993. 	}
    994. 

  994. 	echo '</ul>';
    995. 

  995. 

  996. 

  997. } elseif (!empty($_REQUEST['unsynchronizedtags'])) {
    998. 

  998. 

  999. 	$NotOKfiles        = 0;
    1000. 

  1000. 	$Autofixedfiles    = 0;
    1001. 

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

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

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

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

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

  1006. 	}
    1007. 

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

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

  1009. 	}
    1010. 

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

  1011. 		$TagsToCompare['lyrics3'] = true;
    1012. 

  1012. 	}
    1013. 

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

  1014. 		$TagsToCompare['id3v1'] = true;
    1015. 

  1015. 	}
    1016. 

  1016. 

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

  1018. 	echo '<div id="Autofixing"></div>';
    1019. 

  1019. 	echo '<table border="1" cellspacing="0" cellpadding="3">';
    1020. 

  1020. 	echo '<tr>';
    1021. 

  1021. 	echo '<th>View</th>';
    1022. 

  1022. 	echo '<th>Filename</th>';
    1023. 

  1023. 	echo '<th>Combined</th>';
    1024. 

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

  1025. 		echo '<th><a href="'.htmlentities($_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1&autofixforcesource=id3v2&autofixforcedest=A1').'" title="Auto-fix all tags to match ID3v2 contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match ID3v2?\');">ID3v2</a></th>';
    1026. 

  1026. 	}
    1027. 

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

  1028. 		echo '<th><a href="'.htmlentities($_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1&autofixforcesource=ape&autofixforcedest=21').'" title="Auto-fix all tags to match APE contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match APE?\');">APE</a></th>';
    1029. 

  1029. 	}
    1030. 

  1030. 	if ($TagsToCompare['lyrics3']) {
    1031. 

  1031. 		echo '<th>Lyrics3</th>';
    1032. 

  1032. 	}
    1033. 

  1033. 	if ($TagsToCompare['id3v1']) {
    1034. 

  1034. 		echo '<th><a href="'.htmlentities($_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1&autofixforcesource=ape&autofixforcedest=2A').'" title="Auto-fix all tags to match ID3v1 contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match ID3v1?\');">ID3v1</a></th>';
    1035. 

  1035. 	}
    1036. 

  1036. 	echo '</tr>';
    1037. 

  1037. 

  1038. 	$SQLquery  = 'SELECT `filename`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyrics3`, `comments_id3v1`';
    1039. 

  1039. 	$SQLquery .= ' FROM `'.GETID3_DB_TABLE.'`';
    1040. 

  1040. 	$SQLquery .= ' WHERE (`fileformat` = "mp3")';
    1041. 

  1041. 	$SQLquery .= ' ORDER BY `filename` ASC';
    1042. 

  1042. 	$result = safe_mysql_query($SQLquery);
    1043. 

  1043. 	$lastdir = '';
    1044. 

  1044. 	while ($row = mysql_fetch_array($result)) {
    1045. 

  1045. 		set_time_limit(30);
    1046. 

  1046. 		if ($lastdir != dirname($row['filename'])) {
    1047. 

  1047. 			echo '<script type="text/javascript">if (document.getElementById("Autofixing")) document.getElementById("Autofixing").innerHTML = "'.htmlentities($lastdir, ENT_QUOTES).'";</script>';
    1048. 

  1048. 			flush();
    1049. 

  1049. 		}
    1050. 

  1050. 

  1051. 		$FileOK      = true;
    1052. 

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

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

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

  1055. 

  1056. 		$Comments['all']     = @unserialize($row['comments_all']);
    1057. 

  1057. 		$Comments['id3v2']   = @unserialize($row['comments_id3v2']);
    1058. 

  1058. 		$Comments['ape']     = @unserialize($row['comments_ape']);
    1059. 

  1059. 		$Comments['lyrics3'] = @unserialize($row['comments_lyrics3']);
    1060. 

  1060. 		$Comments['id3v1']   = @unserialize($row['comments_id3v1']);
    1061. 

  1061. 

  1062. 		if (isset($Comments['ape']['tracknumber'])) {
    1063. 

  1063. 			$Comments['ape']['track'] = $Comments['ape']['tracknumber'];
    1064. 

  1064. 			unset($Comments['ape']['tracknumber']);
    1065. 

  1065. 		}
    1066. 

  1066. 		if (isset($Comments['ape']['track_number'])) {
    1067. 

  1067. 			$Comments['ape']['track'] = $Comments['ape']['track_number'];
    1068. 

  1068. 			unset($Comments['ape']['track_number']);
    1069. 

  1069. 		}
    1070. 

  1070. 		if (isset($Comments['id3v2']['track_number'])) {
    1071. 

  1071. 			$Comments['id3v2']['track'] = $Comments['id3v2']['track_number'];
    1072. 

  1072. 			unset($Comments['id3v2']['track_number']);
    1073. 

  1073. 		}
    1074. 

  1074. 		if (!empty($Comments['all']['track'])) {
    1075. 

  1075. 			$besttrack = '';
    1076. 

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

  1077. 				if (strlen($value) > strlen($besttrack)) {
    1078. 

  1078. 					$besttrack = $value;
    1079. 

  1079. 				}
    1080. 

  1080. 			}
    1081. 

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

  1082. 		}
    1083. 

  1083. 

  1084. 		$ThisLine  = '<tr>';
    1085. 

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

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

  1087. 		$tagvalues = '';
    1088. 

  1088. 		foreach ($FieldsToCompare as $fieldname) {
    1089. 

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

  1090. 		}
    1091. 

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

  1092. 		foreach ($TagsToCompare as $tagtype => $CompareThisTagType) {
    1093. 

  1093. 			if ($CompareThisTagType) {
    1094. 

  1094. 				$tagvalues = '';
    1095. 

  1095. 				foreach ($FieldsToCompare as $fieldname) {
    1096. 

  1096. 

  1097. 					if ($tagtype == 'id3v1') {
    1098. 

  1098. 

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

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

  1101. 

  1102. 							// non-standard genres can never match, so just ignore
    1103. 

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

  1104. 

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

  1106. 

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

  1108. //echo __LINE__.'<br>';
    1109. 

  1109. //echo '<pre>';
    1110. 

  1110. //var_dump($tagtype);
    1111. 

  1111. //var_dump($fieldname);
    1112. 

  1112. //echo '<pre>';
    1113. 

  1113. //exit;
    1114. 

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

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

  1116. 									$SemiMatched[$tagtype] = true;
    1117. 

  1117. 								} else {
    1118. 

  1118. 									$Mismatched[$tagtype]  = true;
    1119. 

  1119. 								}
    1120. 

  1120. 								$FileOK = false;
    1121. 

  1121. 							} else {
    1122. 

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

  1123. 							}
    1124. 

  1124. 

  1125. 						} elseif ($fieldname == 'track') {
    1126. 

  1126. 

  1127. 							// intval('01/20') == intval('1')
    1128. 

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

  1129. //echo __LINE__.'<br>';
    1130. 

  1130. //echo '<pre>';
    1131. 

  1131. //var_dump($tagtype);
    1132. 

  1132. //var_dump($fieldname);
    1133. 

  1133. //echo '<pre>';
    1134. 

  1134. //exit;
    1135. 

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

  1136. 								$Mismatched[$tagtype]  = true;
    1137. 

  1137. 								$FileOK = false;
    1138. 

  1138. 							} else {
    1139. 

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

  1140. 							}
    1141. 

  1141. 

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

  1143. 

  1144. //echo __LINE__.'<br>';
    1145. 

  1145. //echo '<pre>';
    1146. 

  1146. //var_dump($tagtype);
    1147. 

  1147. //var_dump($fieldname);
    1148. 

  1148. //echo '<pre>';
    1149. 

  1149. //exit;
    1150. 

  1150. 							$tag…
    1151.

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