PageRenderTime 67ms CodeModel.GetById 9ms RepoModel.GetById 0ms app.codeStats 1ms

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

https://bitbucket.org/cbenelug/chamilo
PHP | 2615 lines | 2260 code | 291 blank | 64 comment | 248 complexity | 80552070f45bb4c53952935217b24f3e MD5 | raw file
Possible License(s): GPL-3.0, MIT, GPL-2.0, BSD-3-Clause, LGPL-2.1, LGPL-3.0 
    

  1. <?php

    2. 

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

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

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

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

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

  7. //                                                             //
    8. 

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

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

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

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

  12. //                                                            ///
    13. 

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

  14. 

    15. 

  15. 

    16. 

  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. 

  18. 

    19. 

  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. 

  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. 

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

  31. 

    32. 

  32. 

    33. 

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

    34. 

  34. {

    35. 

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

    36. 

  36. }

    37. 

  37. if (! @mysql_select_db(GETID3_DB_DB))

    38. 

  38. {

    39. 

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

    40. 

  40. }

    41. 

  41. 

    42. 

  42. if (! @include_once ('../getid3/getid3.php'))

    43. 

  43. {

    44. 

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

    45. 

  45. }

    46. 

  46. // Initialize getID3 engine
    47. 

  47. $getID3 = new getID3();

    48. 

  48. $getID3->setOption(array('option_md5_data' => $getid3_demo_mysql_md5_data, 

    49. 

  49.         'encoding' => $getid3_demo_mysql_encoding));

    50. 

  50. 

    51. 

  51. function RemoveAccents($string)

    52. 

  52. {

    53. 

  53.     // Revised version by marksteward�hotmail*com
    54. 

  54.     return strtr(strtr($string, '������������������������������������������������������������', 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy'), array(

    55. 

  55.             '�' => 'TH', '�' => 'th', '�' => 'DH', '�' => 'dh', '�' => 'ss', '�' => 'OE', '�' => 'oe', '�' => 'AE', 

    56. 

  56.             '�' => 'ae', '�' => 'u'));

    57. 

  57. }

    58. 

  58. 

    59. 

  59. function FixTextFields($text)

    60. 

  60. {

    61. 

  61.     $text = getid3_lib :: SafeStripSlashes($text);

    62. 

  62.     $text = htmlentities($text, ENT_QUOTES);

    63. 

  63.     return $text;

    64. 

  64. }

    65. 

  65. 

    66. 

  66. function BitrateColor($bitrate, $BitrateMaxScale = 768)

    67. 

  67. {

    68. 

  68.     // $BitrateMaxScale is bitrate of maximum-quality color (bright green)
    69. 

  69.     // below this is gradient, above is solid green
    70. 

  70.     

    71. 

  71. 

    72. 

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

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

    74. 

  74.     $bitrate --; // scale from 1-256kbps to 0-255kbps
    75. 

  75.     

    76. 

  76. 

    77. 

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

    78. 

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

    79. 

  79.     if ($bitrate > 127)

    80. 

  80.     {

    81. 

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

    82. 

  82.     }

    83. 

  83.     else

    84. 

  84.     {

    85. 

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

    86. 

  86.     }

    87. 

  87.     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);

    88. 

  88. }

    89. 

  89. 

    90. 

  90. function BitrateText($bitrate, $decimals = 0)

    91. 

  91. {

    92. 

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

    93. 

  93. }

    94. 

  94. 

    95. 

  95. function fileextension($filename, $numextensions = 1)

    96. 

  96. {

    97. 

  97.     if (strstr($filename, '.'))

    98. 

  98.     {

    99. 

  99.         $reversedfilename = strrev($filename);

    100. 

  100.         $offset = 0;

    101. 

  101.         for($i = 0; $i < $numextensions; $i ++)

    102. 

  102.         {

    103. 

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

    104. 

  104.             if ($offset === false)

    105. 

  105.             {

    106. 

  106.                 return '';

    107. 

  107.             }

    108. 

  108.         }

    109. 

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

    110. 

  110.     }

    111. 

  111.     return '';

    112. 

  112. }

    113. 

  113. 

    114. 

  114. function RenameFileFromTo($from, $to, &$results)

    115. 

  115. {

    116. 

  116.     $success = true;

    117. 

  117.     if ($from === $to)

    118. 

  118.     {

    119. 

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

    120. 

  120.     }

    121. 

  121.     elseif (! file_exists($from))

    122. 

  122.     {

    123. 

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

    124. 

  124.     }

    125. 

  125.     elseif (file_exists($to) && (strtolower($from) !== strtolower($to)))

    126. 

  126.     {

    127. 

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

    128. 

  128.     }

    129. 

  129.     elseif (@rename($from, $to))

    130. 

  130.     {

    131. 

  131.         $SQLquery = 'DELETE FROM `' . GETID3_DB_TABLE . '`';

    132. 

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

    133. 

  133.         safe_mysql_query($SQLquery);

    134. 

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

    135. 

  135.     }

    136. 

  136.     else

    137. 

  137.     {

    138. 

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

    139. 

  139.         $success = false;

    140. 

  140.     }

    141. 

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

    142. 

  142.     return $success;

    143. 

  143. }

    144. 

  144. 

    145. 

  145. if (! empty($_REQUEST['renamefilefrom']) && ! empty($_REQUEST['renamefileto']))

    146. 

  146. {

    147. 

  147.     

    148. 

  148.     $results = '';

    149. 

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

    150. 

  150.     echo $results;

    151. 

  151.     exit();

    152. 

  152. 

    153. 

  153. }

    154. 

  154. elseif (! empty($_REQUEST['m3ufilename']))

    155. 

  155. {

    156. 

  156.     

    157. 

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

    158. 

  158.     echo '#EXTM3U' . "\n";

    159. 

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

    160. 

  160.     exit();

    161. 

  161. 

    162. 

  162. }

    163. 

  163. elseif (! isset($_REQUEST['m3u']) && ! isset($_REQUEST['m3uartist']) && ! isset($_REQUEST['m3utitle']))

    164. 

  164. {

    165. 

  165.     

    166. 

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

    167. 

  167.     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>';

    168. 

  168. 

    169. 

  169. }

    170. 

  170. 

    171. 

  171. function WindowsShareSlashTranslate($filename)

    172. 

  172. {

    173. 

  173.     if (substr($filename, 0, 2) == '//')

    174. 

  174.     {

    175. 

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

    176. 

  176.     }

    177. 

  177.     return $filename;

    178. 

  178. }

    179. 

  179. 

    180. 

  180. function safe_mysql_query($SQLquery)

    181. 

  181. {

    182. 

  182.     $result = @mysql_query($SQLquery);

    183. 

  183.     if (mysql_error())

    184. 

  184.     {

    185. 

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

    186. 

  186.     }

    187. 

  187.     return $result;

    188. 

  188. }

    189. 

  189. 

    190. 

  190. function mysql_table_exists($tablename)

    191. 

  191. {

    192. 

  192.     return (bool) mysql_query('DESCRIBE ' . $tablename);

    193. 

  193. }

    194. 

  194. 

    195. 

  195. function AcceptableExtensions($fileformat, $audio_dataformat = '', $video_dataformat = '')

    196. 

  196. {

    197. 

  197.     static $AcceptableExtensionsAudio = array();

    198. 

  198.     if (empty($AcceptableExtensionsAudio))

    199. 

  199.     {

    200. 

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

    201. 

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

    202. 

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

    203. 

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

    204. 

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

    205. 

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

    206. 

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

    207. 

  207.     }

    208. 

  208.     static $AcceptableExtensionsVideo = array();

    209. 

  209.     if (empty($AcceptableExtensionsVideo))

    210. 

  210.     {

    211. 

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

    212. 

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

    213. 

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

    214. 

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

    215. 

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

    216. 

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

    217. 

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

    218. 

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

    219. 

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

    220. 

  220.     }

    221. 

  221.     if (! empty($video_dataformat))

    222. 

  222.     {

    223. 

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

    224. 

  224.     }

    225. 

  225.     else

    226. 

  226.     {

    227. 

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

    228. 

  228.     }

    229. 

  229. }

    230. 

  230. 

    231. 

  231. if (! empty($_REQUEST['scan']))

    232. 

  232. {

    233. 

  233.     if (mysql_table_exists(GETID3_DB_TABLE))

    234. 

  234.     {

    235. 

  235.         $SQLquery = 'DROP TABLE `' . GETID3_DB_TABLE . '`';

    236. 

  236.         safe_mysql_query($SQLquery);

    237. 

  237.     }

    238. 

  238. }

    239. 

  239. if (! mysql_table_exists(GETID3_DB_TABLE))

    240. 

  240. {

    241. 

  241.     $SQLquery = 'CREATE TABLE `' . GETID3_DB_TABLE . '` (';

    242. 

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

    243. 

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

    244. 

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

    245. 

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

    246. 

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

    247. 

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

    248. 

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

    249. 

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

    250. 

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

    251. 

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

    252. 

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

    253. 

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

    254. 

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

    255. 

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

    256. 

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

    257. 

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

    258. 

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

    259. 

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

    260. 

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

    261. 

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

    262. 

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

    263. 

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

    264. 

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

    265. 

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

    266. 

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

    267. 

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

    268. 

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

    269. 

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

    270. 

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

    271. 

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

    272. 

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

    273. 

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

    274. 

  274.     $SQLquery .= ') TYPE=MyISAM;';

    275. 

  275.     

    276. 

  276.     safe_mysql_query($SQLquery);

    277. 

  277. }

    278. 

  278. 

    279. 

  279. $ExistingTableFields = array();

    280. 

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

    281. 

  281. while ($row = mysql_fetch_array($result))

    282. 

  282. {

    283. 

  283.     $ExistingTableFields[$row['Field']] = $row;

    284. 

  284. }

    285. 

  285. if (! isset($ExistingTableFields['encoder_options']))

    286. 

  286. { // Added in 1.7.0b2
    287. 

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

    288. 

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

    289. 

  289.     mysql_query('OPTIMIZE TABLE `' . GETID3_DB_TABLE . '`');

    290. 

  290. }

    291. 

  291. if (isset($ExistingTableFields['track']) && ($ExistingTableFields['track']['Type'] != 'varchar(7)'))

    292. 

  292. { // Changed in 1.7.0b2
    293. 

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

    294. 

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

    295. 

  295.     mysql_query('OPTIMIZE TABLE `' . GETID3_DB_TABLE . '`');

    296. 

  296. }

    297. 

  297. if (! isset($ExistingTableFields['track_volume']))

    298. 

  298. { // Added in 1.7.0b5
    299. 

  299.     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>';

    300. 

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

    301. 

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

    302. 

  302.     mysql_query('OPTIMIZE TABLE `' . GETID3_DB_TABLE . '`');

    303. 

  303. }

    304. 

  304. if (! isset($ExistingTableFields['remix']))

    305. 

  305. { // Added in 1.7.3b1
    306. 

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

    307. 

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

    308. 

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

    309. 

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

    310. 

  310.     mysql_query('OPTIMIZE TABLE `' . GETID3_DB_TABLE . '`');

    311. 

  311. }

    312. 

  312. 

    313. 

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

    314. 

  314. {

    315. 

  315.     global $getID3;

    316. 

  316.     

    317. 

  317.     set_time_limit(30);

    318. 

  318.     

    319. 

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

    320. 

  320.     getid3_lib :: CopyTagsToComments($ThisFileInfo);

    321. 

  321.     

    322. 

  322.     if ($synchronizefrom == 'all')

    323. 

  323.     {

    324. 

  324.         $SourceArray = @$ThisFileInfo['comments'];

    325. 

  325.     }

    326. 

  326.     elseif (! empty($ThisFileInfo['tags'][$synchronizefrom]))

    327. 

  327.     {

    328. 

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

    329. 

  329.     }

    330. 

  330.     else

    331. 

  331.     {

    332. 

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

    333. 

  333.     }

    334. 

  334.     

    335. 

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

    336. 

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

    337. 

  337.     safe_mysql_query($SQLquery);

    338. 

  338.     

    339. 

  339.     $TagFormatsToWrite = array();

    340. 

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

    341. 

  341.     {

    342. 

  342.         $TagFormatsToWrite[] = 'id3v2.3';

    343. 

  343.     }

    344. 

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

    345. 

  345.     {

    346. 

  346.         $TagFormatsToWrite[] = 'ape';

    347. 

  347.     }

    348. 

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

    349. 

  349.     {

    350. 

  350.         $TagFormatsToWrite[] = 'lyrics3';

    351. 

  351.     }

    352. 

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

    353. 

  353.     {

    354. 

  354.         $TagFormatsToWrite[] = 'id3v1';

    355. 

  355.     }

    356. 

  356.     

    357. 

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

    358. 

  358.     $tagwriter = new getid3_writetags();

    359. 

  359.     $tagwriter->filename = $filename;

    360. 

  360.     $tagwriter->tagformats = $TagFormatsToWrite;

    361. 

  361.     $tagwriter->overwrite_tags = true;

    362. 

  362.     $tagwriter->tag_encoding = $getID3->encoding;

    363. 

  363.     $tagwriter->tag_data = $SourceArray;

    364. 

  364.     

    365. 

  365.     if ($tagwriter->WriteTags())

    366. 

  366.     {

    367. 

  367.         $errors = $tagwriter->errors;

    368. 

  368.         return true;

    369. 

  369.     }

    370. 

  370.     $errors = $tagwriter->errors;

    371. 

  371.     return false;

    372. 

  372. }

    373. 

  373. 

    374. 

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

    375. 

  375. 

    376. 

  376. if (! empty($_REQUEST['scan']) || ! empty($_REQUEST['newscan']) || ! empty($_REQUEST['rescanerrors']))

    377. 

  377. {

    378. 

  378.     

    379. 

  379.     $SQLquery = 'DELETE from `' . GETID3_DB_TABLE . '`';

    380. 

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

    381. 

  381.     safe_mysql_query($SQLquery);

    382. 

  382.     

    383. 

  383.     $FilesInDir = array();

    384. 

  384.     

    385. 

  385.     if (! empty($_REQUEST['rescanerrors']))

    386. 

  386.     {

    387. 

  387.         

    388. 

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

    389. 

  389.         

    390. 

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

    391. 

  391.         

    392. 

  392.         $SQLquery = 'SELECT `filename`';

    393. 

  393.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    394. 

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

    395. 

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

    396. 

  396.         $SQLquery .= ' ORDER BY `filename` ASC';

    397. 

  397.         $result = safe_mysql_query($SQLquery);

    398. 

  398.         while ($row = mysql_fetch_array($result))

    399. 

  399.         {

    400. 

  400.             

    401. 

  401.             if (! file_exists($row['filename']))

    402. 

  402.             {

    403. 

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

    404. 

  404.                 $SQLquery = 'DELETE FROM `' . GETID3_DB_TABLE . '`';

    405. 

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

    406. 

  406.                 safe_mysql_query($SQLquery);

    407. 

  407.             }

    408. 

  408.             else

    409. 

  409.             {

    410. 

  410.                 $FilesInDir[] = $row['filename'];

    411. 

  411.             }

    412. 

  412.         

    413. 

  413.         }

    414. 

  414.     

    415. 

  415.     }

    416. 

  416.     elseif (! empty($_REQUEST['scan']) || ! empty($_REQUEST['newscan']))

    417. 

  417.     {

    418. 

  418.         

    419. 

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

    420. 

  420.         

    421. 

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

    422. 

  422.         

    423. 

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

    424. 

  424.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    425. 

  425.         $SQLquery .= ' GROUP BY `filename`';

    426. 

  426.         $SQLquery .= ' ORDER BY `num` DESC';

    427. 

  427.         $result = safe_mysql_query($SQLquery);

    428. 

  428.         $DupesDeleted = 0;

    429. 

  429.         while ($row = mysql_fetch_array($result))

    430. 

  430.         {

    431. 

  431.             set_time_limit(30);

    432. 

  432.             if ($row['num'] <= 1)

    433. 

  433.             {

    434. 

  434.                 break;

    435. 

  435.             }

    436. 

  436.             $SQLquery = 'DELETE FROM `' . GETID3_DB_TABLE . '`';

    437. 

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

    438. 

  438.             safe_mysql_query($SQLquery);

    439. 

  439.             $DupesDeleted ++;

    440. 

  440.         }

    441. 

  441.         if ($DupesDeleted > 0)

    442. 

  442.         {

    443. 

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

    444. 

  444.         }

    445. 

  445.         

    446. 

  446.         if (! empty($_REQUEST['newscan']))

    447. 

  447.         {

    448. 

  448.             $AlreadyInDatabase = array();

    449. 

  449.             set_time_limit(60);

    450. 

  450.             $SQLquery = 'SELECT `filename`';

    451. 

  451.             $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    452. 

  452.             $SQLquery .= ' ORDER BY `filename` ASC';

    453. 

  453.             $result = safe_mysql_query($SQLquery);

    454. 

  454.             while ($row = mysql_fetch_array($result))

    455. 

  455.             {

    456. 

  456.                 //$AlreadyInDatabase[] = strtolower($row['filename']);
    457. 

  457.                 $AlreadyInDatabase[] = $row['filename'];

    458. 

  458.             }

    459. 

  459.         }

    460. 

  460.         

    461. 

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

    462. 

  462.         $DirectoriesScanned = array();

    463. 

  463.         while (count($DirectoriesToScan) > 0)

    464. 

  464.         {

    465. 

  465.             foreach ($DirectoriesToScan as $DirectoryKey => $startingdir)

    466. 

  466.             {

    467. 

  467.                 if ($dir = opendir($startingdir))

    468. 

  468.                 {

    469. 

  469.                     set_time_limit(30);

    470. 

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

    471. 

  471.                     flush();

    472. 

  472.                     while (($file = readdir($dir)) !== false)

    473. 

  473.                     {

    474. 

  474.                         if (($file != '.') && ($file != '..'))

    475. 

  475.                         {

    476. 

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

    477. 

  477.                             if (is_dir($RealPathName))

    478. 

  478.                             {

    479. 

  479.                                 if (! in_array($RealPathName, $DirectoriesScanned) && ! in_array($RealPathName, $DirectoriesToScan))

    480. 

  480.                                 {

    481. 

  481.                                     $DirectoriesToScan[] = $RealPathName;

    482. 

  482.                                 }

    483. 

  483.                             }

    484. 

  484.                             else 

    485. 

  485.                                 if (is_file($RealPathName))

    486. 

  486.                                 {

    487. 

  487.                                     if (! empty($_REQUEST['newscan']))

    488. 

  488.                                     {

    489. 

  489.                                         if (! in_array(str_replace('\\', '/', $RealPathName), $AlreadyInDatabase))

    490. 

  490.                                         {

    491. 

  491.                                             $FilesInDir[] = $RealPathName;

    492. 

  492.                                         }

    493. 

  493.                                     }

    494. 

  494.                                     elseif (! empty($_REQUEST['scan']))

    495. 

  495.                                     {

    496. 

  496.                                         $FilesInDir[] = $RealPathName;

    497. 

  497.                                     }

    498. 

  498.                                 }

    499. 

  499.                         }

    500. 

  500.                     }

    501. 

  501.                     closedir($dir);

    502. 

  502.                 }

    503. 

  503.                 else

    504. 

  504.                 {

    505. 

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

    506. 

  506.                 }

    507. 

  507.                 $DirectoriesScanned[] = $startingdir;

    508. 

  508.                 unset($DirectoriesToScan[$DirectoryKey]);

    509. 

  509.             }

    510. 

  510.         }

    511. 

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

    512. 

  512.         flush();

    513. 

  513.     }

    514. 

  514.     

    515. 

  515.     $FilesInDir = array_unique($FilesInDir);

    516. 

  516.     sort($FilesInDir);

    517. 

  517.     

    518. 

  518.     $starttime = time();

    519. 

  519.     $rowcounter = 0;

    520. 

  520.     $totaltoprocess = count($FilesInDir);

    521. 

  521.     

    522. 

  522.     foreach ($FilesInDir as $filename)

    523. 

  523.     {

    524. 

  524.         set_time_limit(300);

    525. 

  525.         

    526. 

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

    527. 

  527.         

    528. 

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

    529. 

  529.         getid3_lib :: CopyTagsToComments($ThisFileInfo);

    530. 

  530.         

    531. 

  531.         if (file_exists($filename))

    532. 

  532.         {

    533. 

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

    534. 

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

    535. 

  535.         }

    536. 

  536.         

    537. 

  537.         if (empty($ThisFileInfo['fileformat']))

    538. 

  538.         {

    539. 

  539.             

    540. 

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

    541. 

  541.         

    542. 

  542.         }

    543. 

  543.         else

    544. 

  544.         {

    545. 

  545.             

    546. 

  546.             if (! empty($ThisFileInfo['error']))

    547. 

  547.             {

    548. 

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

    549. 

  549.             }

    550. 

  550.             elseif (! empty($ThisFileInfo['warning']))

    551. 

  551.             {

    552. 

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

    553. 

  553.             }

    554. 

  554.             else

    555. 

  555.             {

    556. 

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

    557. 

  557.             }

    558. 

  558.             

    559. 

  559.             $this_track_track = '';

    560. 

  560.             if (! empty($ThisFileInfo['comments']['track']))

    561. 

  561.             {

    562. 

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

    563. 

  563.                 {

    564. 

  564.                     if (strlen($value) > strlen($this_track_track))

    565. 

  565.                     {

    566. 

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

    567. 

  567.                     }

    568. 

  568.                 }

    569. 

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

    570. 

  570.                 {

    571. 

  571.                     // change "1/5"->"01/05", "3/12"->"03/12", etc
    572. 

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

    573. 

  573.                 }

    574. 

  574.             }

    575. 

  575.             

    576. 

  576.             $this_track_remix = '';

    577. 

  577.             $this_track_title = '';

    578. 

  578.             if (! empty($ThisFileInfo['comments']['title']))

    579. 

  579.             {

    580. 

  580.                 foreach ($ThisFileInfo['comments']['title'] as $possible_title)

    581. 

  581.                 {

    582. 

  582.                     if (strlen($possible_title) > strlen($this_track_title))

    583. 

  583.                     {

    584. 

  584.                         $this_track_title = $possible_title;

    585. 

  585.                     }

    586. 

  586.                 }

    587. 

  587.             }

    588. 

  588.             

    589. 

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

    590. 

  590.             foreach ($ParenthesesPairs as $pair)

    591. 

  591.             {

    592. 

  592.                 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))

    593. 

  593.                 {

    594. 

  594.                     $this_track_title = $matches[1][0];

    595. 

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

    596. 

  596.                 }

    597. 

  597.             }

    598. 

  598.             

    599. 

  599.             if (! empty($_REQUEST['rescanerrors']))

    600. 

  600.             {

    601. 

  601.                 

    602. 

  602.                 $SQLquery = 'UPDATE `' . GETID3_DB_TABLE . '` SET ';

    603. 

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

    604. 

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

    605. 

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

    606. 

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

    607. 

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

    608. 

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

    609. 

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

    610. 

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

    611. 

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

    612. 

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

    613. 

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

    614. 

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

    615. 

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

    616. 

  616.                 

    617. 

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

    618. 

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

    619. 

  619.                 

    620. 

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

    621. 

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

    622. 

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

    623. 

  623.                 

    624. 

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

    625. 

  625.                 

    626. 

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

    627. 

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

    628. 

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

    629. 

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

    630. 

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

    631. 

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

    632. 

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

    633. 

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

    634. 

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

    635. 

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

    636. 

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

    637. 

  637.             

    638. 

  638.             }

    639. 

  639.             elseif (! empty($_REQUEST['scan']) || ! empty($_REQUEST['newscan']))

    640. 

  640.             {

    641. 

  641.                 

    642. 

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

    643. 

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

    644. 

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

    645. 

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

    646. 

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

    647. 

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

    648. 

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

    649. 

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

    650. 

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

    651. 

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

    652. 

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

    653. 

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

    654. 

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

    655. 

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

    656. 

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

    657. 

  657.                 

    658. 

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

    659. 

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

    660. 

  660.                 

    661. 

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

    662. 

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

    663. 

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

    664. 

  664.                 

    665. 

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

    666. 

  666.                 

    667. 

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

    668. 

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

    669. 

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

    670. 

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

    671. 

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

    672. 

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

    673. 

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

    674. 

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

    675. 

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

    676. 

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

    677. 

  677.             

    678. 

  678.             }

    679. 

  679.             flush();

    680. 

  680.             safe_mysql_query($SQLquery);

    681. 

  681.         }

    682. 

  682.     

    683. 

  683.     }

    684. 

  684.     

    685. 

  685.     $SQLquery = 'OPTIMIZE TABLE `' . GETID3_DB_TABLE . '`';

    686. 

  686.     safe_mysql_query($SQLquery);

    687. 

  687.     

    688. 

  688.     echo '<hr>Done scanning!<hr>';

    689. 

  689. 

    690. 

  690. }

    691. 

  691. elseif (! empty($_REQUEST['missingtrackvolume']))

    692. 

  692. {

    693. 

  693.     

    694. 

  694.     $MissingTrackVolumeFilesScanned = 0;

    695. 

  695.     $MissingTrackVolumeFilesAdjusted = 0;

    696. 

  696.     $MissingTrackVolumeFilesDeleted = 0;

    697. 

  697.     $SQLquery = 'SELECT `filename`';

    698. 

  698.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    699. 

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

    700. 

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

    701. 

  701.     $result = safe_mysql_query($SQLquery);

    702. 

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

    703. 

  703.     while ($row = mysql_fetch_array($result))

    704. 

  704.     {

    705. 

  705.         set_time_limit(30);

    706. 

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

    707. 

  707.         flush();

    708. 

  708.         if (file_exists($row['filename']))

    709. 

  709.         {

    710. 

  710.             

    711. 

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

    712. 

  712.             if (! empty($ThisFileInfo['replay_gain']['track']['volume']))

    713. 

  713.             {

    714. 

  714.                 $MissingTrackVolumeFilesAdjusted ++;

    715. 

  715.                 $SQLquery = 'UPDATE `' . GETID3_DB_TABLE . '`';

    716. 

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

    717. 

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

    718. 

  718.                 safe_mysql_query($SQLquery);

    719. 

  719.             }

    720. 

  720.         

    721. 

  721.         }

    722. 

  722.         else

    723. 

  723.         {

    724. 

  724.             

    725. 

  725.             $MissingTrackVolumeFilesDeleted ++;

    726. 

  726.             $SQLquery = 'DELETE FROM `' . GETID3_DB_TABLE . '`';

    727. 

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

    728. 

  728.             safe_mysql_query($SQLquery);

    729. 

  729.         

    730. 

  730.         }

    731. 

  731.     }

    732. 

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

    733. 

  733.     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>';

    734. 

  734. 

    735. 

  735. }

    736. 

  736. elseif (! empty($_REQUEST['deadfilescheck']))

    737. 

  737. {

    738. 

  738.     

    739. 

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

    740. 

  740.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    741. 

  741.     $SQLquery .= ' GROUP BY `filename`';

    742. 

  742.     $SQLquery .= ' ORDER BY `num` DESC';

    743. 

  743.     $result = safe_mysql_query($SQLquery);

    744. 

  744.     $DupesDeleted = 0;

    745. 

  745.     while ($row = mysql_fetch_array($result))

    746. 

  746.     {

    747. 

  747.         set_time_limit(30);

    748. 

  748.         if ($row['num'] <= 1)

    749. 

  749.         {

    750. 

  750.             break;

    751. 

  751.         }

    752. 

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

    753. 

  753.         $SQLquery = 'DELETE FROM `' . GETID3_DB_TABLE . '`';

    754. 

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

    755. 

  755.         safe_mysql_query($SQLquery);

    756. 

  756.         $DupesDeleted ++;

    757. 

  757.     }

    758. 

  758.     if ($DupesDeleted > 0)

    759. 

  759.     {

    760. 

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

    761. 

  761.     }

    762. 

  762.     

    763. 

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

    764. 

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

    765. 

  765.     $SQLquery .= ' ORDER BY `filename` ASC';

    766. 

  766.     $result = safe_mysql_query($SQLquery);

    767. 

  767.     $totalchecked = 0;

    768. 

  768.     $totalremoved = 0;

    769. 

  769.     $previousdir = '';

    770. 

  770.     while ($row = mysql_fetch_array($result))

    771. 

  771.     {

    772. 

  772.         $totalchecked ++;

    773. 

  773.         set_time_limit(30);

    774. 

  774.         $reason = '';

    775. 

  775.         if (! file_exists($row['filename']))

    776. 

  776.         {

    777. 

  777.             $reason = 'deleted';

    778. 

  778.         }

    779. 

  779.         elseif (filesize($row['filename']) != $row['filesize'])

    780. 

  780.         {

    781. 

  781.             $reason = 'filesize changed';

    782. 

  782.         }

    783. 

  783.         elseif (filemtime($row['filename']) != $row['LastModified'])

    784. 

  784.         {

    785. 

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

    786. 

  786.             {

    787. 

  787.                 // off by exactly one hour == daylight savings time
    788. 

  788.                 $reason = 'last-modified time changed';

    789. 

  789.             }

    790. 

  790.         }

    791. 

  791.         

    792. 

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

    793. 

  793.         if ($reason)

    794. 

  794.         {

    795. 

  795.             

    796. 

  796.             $totalremoved ++;

    797. 

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

    798. 

  798.             flush();

    799. 

  799.             $SQLquery = 'DELETE FROM `' . GETID3_DB_TABLE . '`';

    800. 

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

    801. 

  801.             safe_mysql_query($SQLquery);

    802. 

  802.         

    803. 

  803.         }

    804. 

  804.         elseif ($thisdir != $previousdir)

    805. 

  805.         {

    806. 

  806.             

    807. 

  807.             echo '. ';

    808. 

  808.             flush();

    809. 

  809.         

    810. 

  810.         }

    811. 

  811.         $previousdir = $thisdir;

    812. 

  812.     }

    813. 

  813.     

    814. 

  814.     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>';

    815. 

  815. 

    816. 

  816. }

    817. 

  817. elseif (! empty($_REQUEST['encodedbydistribution']))

    818. 

  818. {

    819. 

  819.     

    820. 

  820.     if (! empty($_REQUEST['m3u']))

    821. 

  821.     {

    822. 

  822.         

    823. 

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

    824. 

  824.         echo '#EXTM3U' . "\n";

    825. 

  825.         

    826. 

  826.         $SQLquery = 'SELECT `filename`, `comments_id3v2`';

    827. 

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

    828. 

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

    829. 

  829.         $result = mysql_query($SQLquery);

    830. 

  830.         $NonBlankEncodedBy = '';

    831. 

  831.         $BlankEncodedBy = '';

    832. 

  832.         while ($row = mysql_fetch_array($result))

    833. 

  833.         {

    834. 

  834.             set_time_limit(30);

    835. 

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

    836. 

  836.             if (isset($CommentArray['encoded_by'][0]))

    837. 

  837.             {

    838. 

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

    839. 

  839.             }

    840. 

  840.             else

    841. 

  841.             {

    842. 

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

    843. 

  843.             }

    844. 

  844.         }

    845. 

  845.         echo $NonBlankEncodedBy;

    846. 

  846.         echo $BlankEncodedBy;

    847. 

  847.         exit();

    848. 

  848.     

    849. 

  849.     }

    850. 

  850.     elseif (! empty($_REQUEST['showfiles']))

    851. 

  851.     {

    852. 

  852.         

    853. 

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

    854. 

  854.         echo '<table border="1">';

    855. 

  855.         

    856. 

  856.         $SQLquery = 'SELECT `filename`, `comments_id3v2`';

    857. 

  857.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    858. 

  858.         $result = mysql_query($SQLquery);

    859. 

  859.         while ($row = mysql_fetch_array($result))

    860. 

  860.         {

    861. 

  861.             set_time_limit(30);

    862. 

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

    863. 

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

    864. 

  864.             {

    865. 

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

    866. 

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

    867. 

  867.             }

    868. 

  868.         }

    869. 

  869.         echo '</table>';

    870. 

  870.     

    871. 

  871.     }

    872. 

  872.     else

    873. 

  873.     {

    874. 

  874.         

    875. 

  875.         $SQLquery = 'SELECT `encoder_options`, `comments_id3v2`';

    876. 

  876.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    877. 

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

    878. 

  878.         $result = mysql_query($SQLquery);

    879. 

  879.         $EncodedBy = array();

    880. 

  880.         while ($row = mysql_fetch_array($result))

    881. 

  881.         {

    882. 

  882.             set_time_limit(30);

    883. 

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

    884. 

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

    885. 

  885.             {

    886. 

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

    887. 

  887.             }

    888. 

  888.             else

    889. 

  889.             {

    890. 

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

    891. 

  891.             }

    892. 

  892.         }

    893. 

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

    894. 

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

    895. 

  895.         foreach ($EncodedBy as $key => $value)

    896. 

  896.         {

    897. 

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

    898. 

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

    899. 

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

    900. 

  900.             arsort($value);

    901. 

  901.             foreach ($value as $string => $count)

    902. 

  902.             {

    903. 

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

    904. 

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

    905. 

  905.             }

    906. 

  906.             echo '</table></td></tr>';

    907. 

  907.         }

    908. 

  908.         echo '</table>';

    909. 

  909.     

    910. 

  910.     }

    911. 

  911. 

    912. 

  912. }

    913. 

  913. elseif (! empty($_REQUEST['audiobitrates']))

    914. 

  914. {

    915. 

  915.     

    916. 

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

    917. 

  917.     $BitrateDistribution = array();

    918. 

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

    919. 

  919.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    920. 

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

    921. 

  921.     $SQLquery .= ' GROUP BY `RoundBitrate`';

    922. 

  922.     $result = safe_mysql_query($SQLquery);

    923. 

  923.     while ($row = mysql_fetch_array($result))

    924. 

  924.     {

    925. 

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

  926.     }

    927. 

  927.     

    928. 

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

    929. 

  929.     echo '<tr><th>Bitrate</th><th>Count</th></tr>';

    930. 

  930.     foreach ($BitrateDistribution as $Bitrate => $Count)

    931. 

  931.     {

    932. 

  932.         echo '<tr>';

    933. 

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

    934. 

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

    935. 

  935.         echo '</tr>';

    936. 

  936.     }

    937. 

  937.     echo '</table>';

    938. 

  938. 

    939. 

  939. }

    940. 

  940. elseif (! empty($_REQUEST['emptygenres']))

    941. 

  941. {

    942. 

  942.     

    943. 

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

    944. 

  944.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    945. 

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

    946. 

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

    947. 

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

    948. 

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

    949. 

  949.     $result = safe_mysql_query($SQLquery);

    950. 

  950.     

    951. 

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

    952. 

  952.     {

    953. 

  953.         

    954. 

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

    955. 

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

    956. 

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

    957. 

  957.         {

    958. 

  958.             if (! in_array($row['fileformat'], $IgnoreNoTagFormats))

    959. 

  959.             {

    960. 

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

    961. 

  961.             }

    962. 

  962.         }

    963. 

  963.         exit();

    964. 

  964.     

    965. 

  965.     }

    966. 

  966.     else

    967. 

  967.     {

    968. 

  968.         

    969. 

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

    970. 

  970.         $EmptyGenreCounter = 0;

    971. 

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

    972. 

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

    973. 

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

    974. 

  974.         {

    975. 

  975.             if (! in_array($row['fileformat'], $IgnoreNoTagFormats))

    976. 

  976.             {

    977. 

  977.                 $EmptyGenreCounter ++;

    978. 

  978.                 echo '<tr>';

    979. 

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

    980. 

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

    981. 

  981.                 echo '</tr>';

    982. 

  982.             }

    983. 

  983.         }

    984. 

  984.         echo '</table>';

    985. 

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

    986. 

  986.     

    987. 

  987.     }

    988. 

  988. 

    989. 

  989. }

    990. 

  990. elseif (! empty($_REQUEST['nonemptycomments']))

    991. 

  991. {

    992. 

  992.     

    993. 

  993.     $SQLquery = 'SELECT `filename`, `comment`';

    994. 

  994.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    995. 

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

    996. 

  996.     $SQLquery .= ' ORDER BY `comment` ASC';

    997. 

  997.     $result = safe_mysql_query($SQLquery);

    998. 

  998.     

    999. 

  999.     if (! empty($_REQUEST['m3u']))

    1000. 

  1000.     {

    1001. 

  1001.         

    1002. 

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

    1003. 

  1003.         echo '#EXTM3U' . "\n";

    1004. 

  1004.         while ($row = mysql_fetch_array($result))

    1005. 

  1005.         {

    1006. 

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

    1007. 

  1007.         }

    1008. 

  1008.         exit();

    1009. 

  1009.     

    1010. 

  1010.     }

    1011. 

  1011.     else

    1012. 

  1012.     {

    1013. 

  1013.         

    1014. 

  1014.         $NonEmptyCommentsCounter = 0;

    1015. 

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

    1016. 

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

    1017. 

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

    1018. 

  1018.         while ($row = mysql_fetch_array($result))

    1019. 

  1019.         {

    1020. 

  1020.             $NonEmptyCommentsCounter ++;

    1021. 

  1021.             echo '<tr>';

    1022. 

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

    1023. 

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

    1024. 

  1024.             if (strlen(trim($row['comment'])) > 0)

    1025. 

  1025.             {

    1026. 

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

    1027. 

  1027.             }

    1028. 

  1028.             else

    1029. 

  1029.             {

    1030. 

  1030.                 echo '<td><i>space</i></td>';

    1031. 

  1031.             }

    1032. 

  1032.             echo '</tr>';

    1033. 

  1033.         }

    1034. 

  1034.         echo '</table>';

    1035. 

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

    1036. 

  1036.     

    1037. 

  1037.     }

    1038. 

  1038. 

    1039. 

  1039. }

    1040. 

  1040. elseif (! empty($_REQUEST['trackzero']))

    1041. 

  1041. {

    1042. 

  1042.     

    1043. 

  1043.     $SQLquery = 'SELECT `filename`, `track`';

    1044. 

  1044.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1045. 

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

    1046. 

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

    1047. 

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

    1048. 

  1048.     $SQLquery .= ' ORDER BY `filename` ASC';

    1049. 

  1049.     $result = safe_mysql_query($SQLquery);

    1050. 

  1050.     

    1051. 

  1051.     if (! empty($_REQUEST['m3u']))

    1052. 

  1052.     {

    1053. 

  1053.         

    1054. 

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

    1055. 

  1055.         echo '#EXTM3U' . "\n";

    1056. 

  1056.         while ($row = mysql_fetch_array($result))

    1057. 

  1057.         {

    1058. 

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

    1059. 

  1059.             {

    1060. 

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

    1061. 

  1061.             }

    1062. 

  1062.         }

    1063. 

  1063.         exit();

    1064. 

  1064.     

    1065. 

  1065.     }

    1066. 

  1066.     else

    1067. 

  1067.     {

    1068. 

  1068.         

    1069. 

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

    1070. 

  1070.         $TrackZeroCounter = 0;

    1071. 

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

    1072. 

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

    1073. 

  1073.         while ($row = mysql_fetch_array($result))

    1074. 

  1074.         {

    1075. 

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

    1076. 

  1076.             {

    1077. 

  1077.                 $TrackZeroCounter ++;

    1078. 

  1078.                 echo '<tr>';

    1079. 

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

    1080. 

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

    1081. 

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

    1082. 

  1082.                 echo '</tr>';

    1083. 

  1083.             }

    1084. 

  1084.         }

    1085. 

  1085.         echo '</table>';

    1086. 

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

    1087. 

  1087.     

    1088. 

  1088.     }

    1089. 

  1089. 

    1090. 

  1090. }

    1091. 

  1091. elseif (! empty($_REQUEST['titlefeat']))

    1092. 

  1092. {

    1093. 

  1093.     

    1094. 

  1094.     $SQLquery = 'SELECT `filename`, `title`';

    1095. 

  1095.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1096. 

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

    1097. 

  1097.     $SQLquery .= ' ORDER BY `filename` ASC';

    1098. 

  1098.     $result = safe_mysql_query($SQLquery);

    1099. 

  1099.     

    1100. 

  1100.     if (! empty($_REQUEST['m3u']))

    1101. 

  1101.     {

    1102. 

  1102.         

    1103. 

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

    1104. 

  1104.         echo '#EXTM3U' . "\n";

    1105. 

  1105.         while ($row = mysql_fetch_array($result))

    1106. 

  1106.         {

    1107. 

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

    1108. 

  1108.         }

    1109. 

  1109.         exit();

    1110. 

  1110.     

    1111. 

  1111.     }

    1112. 

  1112.     else

    1113. 

  1113.     {

    1114. 

  1114.         

    1115. 

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

    1116. 

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

    1117. 

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

    1118. 

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

    1119. 

  1119.         while ($row = mysql_fetch_array($result))

    1120. 

  1120.         {

    1121. 

  1121.             echo '<tr>';

    1122. 

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

    1123. 

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

    1124. 

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

    1125. 

  1125.             echo '</tr>';

    1126. 

  1126.         }

    1127. 

  1127.         echo '</table>';

    1128. 

  1128.     

    1129. 

  1129.     }

    1130. 

  1130. 

    1131. 

  1131. }

    1132. 

  1132. elseif (! empty($_REQUEST['tracknoalbum']))

    1133. 

  1133. {

    1134. 

  1134.     

    1135. 

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

    1136. 

  1136.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1137. 

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

    1138. 

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

    1139. 

  1139.     $SQLquery .= ' ORDER BY `filename` ASC';

    1140. 

  1140.     $result = safe_mysql_query($SQLquery);

    1141. 

  1141.     

    1142. 

  1142.     if (! empty($_REQUEST['m3u']))

    1143. 

  1143.     {

    1144. 

  1144.         

    1145. 

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

    1146. 

  1146.         echo '#EXTM3U' . "\n";

    1147. 

  1147.         while ($row = mysql_fetch_array($result))

    1148. 

  1148.         {

    1149. 

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

    1150. 

  1150.         }

    1151. 

  1151.         exit();

    1152. 

  1152.     

    1153. 

  1153.     }

    1154. 

  1154.     else

    1155. 

  1155.     {

    1156. 

  1156.         

    1157. 

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

    1158. 

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

    1159. 

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

    1160. 

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

    1161. 

  1161.         while ($row = mysql_fetch_array($result))

    1162. 

  1162.         {

    1163. 

  1163.             echo '<tr>';

    1164. 

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

    1165. 

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

    1166. 

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

    1167. 

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

    1168. 

  1168.             echo '</tr>';

    1169. 

  1169.         }

    1170. 

  1170.         echo '</table>';

    1171. 

  1171.     

    1172. 

  1172.     }

    1173. 

  1173. 

    1174. 

  1174. }

    1175. 

  1175. elseif (! empty($_REQUEST['synchronizetagsfrom']) && ! empty($_REQUEST['filename']))

    1176. 

  1176. {

    1177. 

  1177.     

    1178. 

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

    1179. 

  1179.     $errors = array();

    1180. 

  1180.     if (SynchronizeAllTags($_REQUEST['filename'], $_REQUEST['synchronizetagsfrom'], 'A12', $errors))

    1181. 

  1181.     {

    1182. 

  1182.         echo '<li>Sucessfully wrote tags</li>';

    1183. 

  1183.     }

    1184. 

  1184.     else

    1185. 

  1185.     {

    1186. 

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

    1187. 

  1187.     }

    1188. 

  1188.     echo '</ul>';

    1189. 

  1189. 

    1190. 

  1190. }

    1191. 

  1191. elseif (! empty($_REQUEST['unsynchronizedtags']))

    1192. 

  1192. {

    1193. 

  1193.     

    1194. 

  1194.     $NotOKfiles = 0;

    1195. 

  1195.     $Autofixedfiles = 0;

    1196. 

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

    1197. 

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

    1198. 

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

    1199. 

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

    1200. 

  1200.     {

    1201. 

  1201.         $TagsToCompare['id3v2'] = true;

    1202. 

  1202.     }

    1203. 

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

    1204. 

  1204.     {

    1205. 

  1205.         $TagsToCompare['ape'] = true;

    1206. 

  1206.     }

    1207. 

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

    1208. 

  1208.     {

    1209. 

  1209.         $TagsToCompare['lyrics3'] = true;

    1210. 

  1210.     }

    1211. 

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

    1212. 

  1212.     {

    1213. 

  1213.         $TagsToCompare['id3v1'] = true;

    1214. 

  1214.     }

    1215. 

  1215.     

    1216. 

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

    1217. 

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

    1218. 

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

    1219. 

  1219.     echo '<tr>';

    1220. 

  1220.     echo '<th>View</th>';

    1221. 

  1221.     echo '<th>Filename</th>';

    1222. 

  1222.     echo '<th>Combined</th>';

    1223. 

  1223.     if ($TagsToCompare['id3v2'])

    1224. 

  1224.     {

    1225. 

  1225.         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>';

    1226. 

  1226.     }

    1227. 

  1227.     if ($TagsToCompare['ape'])

    1228. 

  1228.     {

    1229. 

  1229.         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>';

    1230. 

  1230.     }

    1231. 

  1231.     if ($TagsToCompare['lyrics3'])

    1232. 

  1232.     {

    1233. 

  1233.         echo '<th>Lyrics3</th>';

    1234. 

  1234.     }

    1235. 

  1235.     if ($TagsToCompare['id3v1'])

    1236. 

  1236.     {

    1237. 

  1237.         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>';

    1238. 

  1238.     }

    1239. 

  1239.     echo '</tr>';

    1240. 

  1240.     

    1241. 

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

    1242. 

  1242.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1243. 

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

    1244. 

  1244.     $SQLquery .= ' ORDER BY `filename` ASC';

    1245. 

  1245.     $result = safe_mysql_query($SQLquery);

    1246. 

  1246.     $lastdir = '';

    1247. 

  1247.     while ($row = mysql_fetch_array($result))

    1248. 

  1248.     {

    1249. 

  1249.         set_time_limit(30);

    1250. 

  1250.         if ($lastdir != dirname($row['filename']))

    1251. 

  1251.         {

    1252. 

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

    1253. 

  1253.             flush();

    1254. 

  1254.         }

    1255. 

  1255.         

    1256. 

  1256.         $FileOK = true;

    1257. 

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

    1258. 

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

    1259. 

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

    1260. 

  1260.         

    1261. 

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

    1262. 

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

    1263. 

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

    1264. 

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

    1265. 

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

    1266. 

  1266.         

    1267. 

  1267.         if (isset($Comments['ape']['tracknumber']))

    1268. 

  1268.         {

    1269. 

  1269.             $Comments['ape']['track'] = $Comments['ape']['tracknumber'];

    1270. 

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

    1271. 

  1271.         }

    1272. 

  1272.         if (isset($Comments['ape']['track_number']))

    1273. 

  1273.         {

    1274. 

  1274.             $Comments['ape']['track'] = $Comments['ape']['track_number'];

    1275. 

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

    1276. 

  1276.         }

    1277. 

  1277.         if (isset($Comments['id3v2']['track_number']))

    1278. 

  1278.         {

    1279. 

  1279.             $Comments['id3v2']['track'] = $Comments['id3v2']['track_number'];

    1280. 

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

    1281. 

  1281.         }

    1282. 

  1282.         if (! empty($Comments['all']['track']))

    1283. 

  1283.         {

    1284. 

  1284.             $besttrack = '';

    1285. 

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

    1286. 

  1286.             {

    1287. 

  1287.                 if (strlen($value) > strlen($besttrack))

    1288. 

  1288.                 {

    1289. 

  1289.                     $besttrack = $value;

    1290. 

  1290.                 }

    1291. 

  1291.             }

    1292. 

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

    1293. 

  1293.         }

    1294. 

  1294.         

    1295. 

  1295.         $ThisLine = '<tr>';

    1296. 

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

    1297. 

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

    1298. 

  1298.         $tagvalues = '';

    1299. 

  1299.         foreach ($FieldsToCompare as $fieldname)

    1300. 

  1300.         {

    1301. 

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

    1302. 

  1302.         }

    1303. 

  1303.         $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>';

    1304. 

  1304.         foreach ($TagsToCompare as $tagtype => $CompareThisTagType)

    1305. 

  1305.         {

    1306. 

  1306.             if ($CompareThisTagType)

    1307. 

  1307.             {

    1308. 

  1308.                 $tagvalues = '';

    1309. 

  1309.                 foreach ($FieldsToCompare as $fieldname)

    1310. 

  1310.                 {

    1311. 

  1311.                     

    1312. 

  1312.                     if ($tagtype == 'id3v1')

    1313. 

  1313.                     {

    1314. 

  1314.                         

    1315. 

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

    1316. 

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

    1317. 

  1317.                         {

    1318. 

  1318.                             

    1319. 

  1319.                             // non-standard genres can never match, so just ignore
    1320. 

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

    1321. 

  1321.                         

    1322. 

  1322.                         }

    1323. 

  1323.                         elseif ($fieldname == 'comment')

    1324. 

  1324.                         {

    1325. 

  1325.                             

    1326. 

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

    1327. 

  1327.                             {

    1328. 

  1328.                                 //echo __LINE__.'<br>';
    1329. 

  1329.                                 //echo '<pre>';
    1330. 

  1330.                                 //var_dump($tagtype);
    1331. 

  1331.                                 //var_dump($fieldname);
    1332. 

  1332.                                 //echo '<pre>';
    1333. 

  1333.                                 //exit;
    1334. 

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

    1335. 

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

    1336. 

  1336.                                 {

    1337. 

  1337.                                     $SemiMatched[$tagtype] = true;

    1338. 

  1338.                                 }

    1339. 

  1339.                                 else

    1340. 

  1340.                                 {

    1341. 

  1341.                                     $Mismatched[$tagtype] = true;

    1342. 

  1342.                                 }

    1343. 

  1343.                                 $FileOK = false;

    1344. 

  1344.                             }

    1345. 

  1345.                             else

    1346. 

  1346.                             {

    1347. 

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

    1348. 

  1348.                             }

    1349. 

  1349.                         

    1350. 

  1350.                         }

    1351. 

  1351.                         elseif ($fieldname == 'track')

    1352. 

  1352.                         {

    1353. 

  1353.                             

    1354. 

  1354.                             // intval('01/20') == intval('1')
    1355. 

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

    1356. 

  1356.                             {

    1357. 

  1357.                                 //echo __LINE__.'<br>';
    1358. 

  1358.                                 //echo '<pre>';
    1359. 

  1359.                                 //var_dump($tagtype);
    1360. 

  1360.                                 //var_dump($fieldname);
    1361. 

  1361.                                 //echo '<pre>';
    1362. 

  1362.                                 //exit;
    1363. 

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

    1364. 

  1364.                                 $Mismatched[$tagtype] = true;

    1365. 

  1365.                                 $FileOK = false;

    1366. 

  1366.                             }

    1367. 

  1367.                             else

    1368. 

  1368.                             {

    1369. 

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

    1370. 

  1370.                             }

    1371. 

  1371.                         

    1372. 

  1372.                         }

    1373. 

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

    1374. 

  1374.                         {

    1375. 

  1375.                             

    1376. 

  1376.                             //echo __LINE__.'<br>';
    1377. 

  1377.                             //echo '<pre>';
    1378. 

  1378.                             //var_dump($tagtype);
    1379. 

  1379.                             //var_dump($fieldname);
    1380. 

  1380.                             //echo '<pre>';
    1381. 

  1381.                             //exit;
    1382. 

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

    1383. 

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

    1384. 

  1384.                             {

    1385. 

  1385.                                 $SemiMatched[$tagtype] = true;

    1386. 

  1386.                             }

    1387. 

  1387.                             else

    1388. 

  1388.                             {

    1389. 

  1389.                                 $Mismatched[$tagtype] = true;

    1390. 

  1390.                             }

    1391. 

  1391.                             $FileOK = false;

    1392. 

  1392.                             if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0)

    1393. 

  1393.                             {

    1394. 

  1394.                                 $EmptyTags[$tagtype] = false;

    1395. 

  1395.                             }

    1396. 

  1396.                         

    1397. 

  1397.                         }

    1398. 

  1398.                         else

    1399. 

  1399.                         {

    1400. 

  1400.                             

    1401. 

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

    1402. 

  1402.                             if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0)

    1403. 

  1403.                             {

    1404. 

  1404.                                 $EmptyTags[$tagtype] = false;

    1405. 

  1405.                             }

    1406. 

  1406.                         

    1407. 

  1407.                         }

    1408. 

  1408.                     

    1409. 

  1409.                     }

    1410. 

  1410.                     elseif (($tagtype == 'ape') && ($fieldname == 'year'))

    1411. 

  1411.                     {

    1412. 

  1412.                         

    1413. 

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

    1414. 

  1414.                         {

    1415. 

  1415.                             

    1416. 

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

    1417. 

  1417.                             $Mismatched[$tagtype] = true;

    1418. 

  1418.                             $FileOK = false;

    1419. 

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

    1420. 

  1420.                             {

    1421. 

  1421.                                 $EmptyTags[$tagtype] = false;

    1422. 

  1422.                             }

    1423. 

  1423.                         

    1424. 

  1424.                         }

    1425. 

  1425.                         else

    1426. 

  1426.                         {

    1427. 

  1427.                             

    1428. 

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

    1429. 

  1429.                             if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0)

    1430. 

  1430.                             {

    1431. 

  1431.                                 $EmptyTags[$tagtype] = false;

    1432. 

  1432.                             }

    1433. 

  1433.                         

    1434. 

  1434.                         }

    1435. 

  1435.                     

    1436. 

  1436.                     }

    1437. 

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

    1438. 

  1438.                     {

    1439. 

  1439.                         

    1440. 

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

    1441. 

  1441.                         if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0)

    1442. 

  1442.                         {

    1443. 

  1443.                             $EmptyTags[$tagtype] = false;

    1444. 

  1444.                         }

    1445. 

  1445.                     

    1446. 

  1446.                     }

    1447. 

  1447.                     elseif (@$Comments[$tagtype][$fieldname][0] != @$Comments['all'][$fieldname][0])

    1448. 

  1448.                     {

    1449. 

  1449.                         

    1450. 

  1450.                         //echo __LINE__.'<br>';
    1451. 

  1451.                         //echo '<pre>';
    1452. 

  1452.                         //var_dump($tagtype);
    1453. 

  1453.                         //var_dump($fieldname);
    1454. 

  1454.                         //var_dump($Comments[$tagtype][$fieldname][0]);
    1455. 

  1455.                         //var_dump($Comments['all'][$fieldname][0]);
    1456. 

  1456.                         //echo '<pre>';
    1457. 

  1457.                         //exit;
    1458. 

  1458.                         $skiptracknumberfield = false;

    1459. 

  1459.                         switch ($fieldname)

    1460. 

  1460.                         {

    1461. 

  1461.                             case 'track' :

    1462. 

  1462.                             case 'tracknumber' :

    1463. 

  1463.                             case 'track_number' :

    1464. 

  1464.                                 if (intval(@$Comments[$tagtype][$fieldname][0]) == intval(@$Comments['all'][$fieldname][0]))

    1465. 

  1465.                                 {

    1466. 

  1466.                                     $skiptracknumberfield = true;

    1467. 

  1467.                                 }

    1468. 

  1468.                                 break;

    1469. 

  1469.                         }

    1470. 

  1470.                         if (! $skiptracknumberfield)

    1471. 

  1471.                         {

    1472. 

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

    1473. 

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

    1474. 

  1474.                             {

    1475. 

  1475.                                 $SemiMatched[$tagtype] = true;

    1476. 

  1476.                             }

    1477. 

  1477.                             else

    1478. 

  1478.                             {

    1479. 

  1479.                                 $Mismatched[$tagtype] = true;

    1480. 

  1480.                             }

    1481. 

  1481.                             $FileOK = false;

    1482. 

  1482.                             if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0)

    1483. 

  1483.                             {

    1484. 

  1484.                                 $EmptyTags[$tagtype] = false;

    1485. 

  1485.                             }

    1486. 

  1486.                         }

    1487. 

  1487.                     

    1488. 

  1488.                     }

    1489. 

  1489.                     else

    1490. 

  1490.                     {

    1491. 

  1491.                         

    1492. 

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

    1493. 

  1493.                         if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0)

    1494. 

  1494.                         {

    1495. 

  1495.                             $EmptyTags[$tagtype] = false;

    1496. 

  1496.                         }

    1497. 

  1497.                     

    1498. 

  1498.                     }

    1499. 

  1499.                 }

    1500. 

  1500.                 

    1501. 

  1501.                 if ($EmptyTags[$tagtype])

    1502. 

  1502.                 {

    1503. 

  1503.                     $FileOK = false;

    1504. 

  1504.                     $ThisLine .= '<td bgcolor="#0099cc">';

    1505. 

  1505.                 }

    1506. 

  1506.                 elseif ($SemiMatched[$tagtype])

    1507. 

  1507.                 {

    1508. 

  1508.                     $ThisLine .= '<td bgcolor="#ff9999">';

    1509. 

  1509.                 }

    1510. 

  1510.                 elseif ($Mismatched[$tagtype])

    1511. 

  1511.                 {

    1512. 

  1512.                     $ThisLine .= '<td bgcolor="#ff0000">';

    1513. 

  1513.                 }

    1514. 

  1514.                 else

    1515. 

  1515.                 {

    1516. 

  1516.                     $ThisLine .= '<td bgcolor="#00cc00">';

    1517. 

  1517.                 }

    1518. 

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

    1519. 

  1519.                 $ThisLine .= '</td>';

    1520. 

  1520.             }

    1521. 

  1521.         }

    1522. 

  1522.         $ThisLine .= '</tr>';

    1523. 

  1523.         

    1524. 

  1524.         if (! $FileOK)

    1525. 

  1525.         {

    1526. 

  1526.             $NotOKfiles ++;

    1527. 

  1527.             

    1528. 

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

    1529. 

  1529.             flush();

    1530. 

  1530.             

    1531. 

  1531.             if (! empty($_REQUEST['autofix']))

    1532. 

  1532.             {

    1533. 

  1533.                 

    1534. 

  1534.                 $AnyMismatched = false;

    1535. 

  1535.                 foreach ($Mismatched as $key => $value)

    1536. 

  1536.                 {

    1537. 

  1537.                     if ($value && ($EmptyTags["$key"] === false))

    1538. 

  1538.                     {

    1539. 

  1539.                         $AnyMismatched = true;

    1540. 

  1540.                     }

    1541. 

  1541.                 }

    1542. 

  1542.                 if ($AnyMismatched && empty($_REQUEST['autofixforcesource']))

    1543. 

  1543.                 {

    1544. 

  1544.                     

    1545. 

  1545.                     echo $ThisLine;

    1546. 

  1546.                 

    1547. 

  1547.                 }

    1548. 

  1548.                 else

    1549. 

  1549.                 {

    1550. 

  1550.                     

    1551. 

  1551.                     $TagsToSynch = '';

    1552. 

  1552.                     foreach ($EmptyTags as $key => $value)

    1553. 

  1553.                     {

    1554. 

  1554.                         if ($value)

    1555. 

  1555.                         {

    1556. 

  1556.                             switch ($key)

    1557. 

  1557.                             {

    1558. 

  1558.                                 case 'id3v1' :

    1559. 

  1559.                                     $TagsToSynch .= '1';

    1560. 

  1560.                                     break;

    1561. 

  1561.                                 case 'id3v2' :

    1562. 

  1562.                                     $TagsToSynch .= '2';

    1563. 

  1563.                                     break;

    1564. 

  1564.                                 case 'ape' :

    1565. 

  1565.                                     $TagsToSynch .= 'A';

    1566. 

  1566.                                     break;

    1567. 

  1567.                             }

    1568. 

  1568.                         }

    1569. 

  1569.                     }

    1570. 

  1570.                     

    1571. 

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

    1572. 

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

    1573. 

  1573.                     

    1574. 

  1574.                     $errors = array();

    1575. 

  1575.                     if (SynchronizeAllTags($row['filename'], $autofixforcesource, $TagsToSynch, $errors))

    1576. 

  1576.                     {

    1577. 

  1577.                         $Autofixedfiles ++;

    1578. 

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

    1579. 

  1579.                     }

    1580. 

  1580.                     else

    1581. 

  1581.                     {

    1582. 

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

    1583. 

  1583.                     }

    1584. 

  1584.                     echo '<td>&nbsp;</th>';

    1585. 

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

    1586. 

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

    1587. 

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

    1588. 

  1588.                     echo '</table></td></tr>';

    1589. 

  1589.                 }

    1590. 

  1590.             

    1591. 

  1591.             }

    1592. 

  1592.             else

    1593. 

  1593.             {

    1594. 

  1594.                 

    1595. 

  1595.                 echo $ThisLine;

    1596. 

  1596.             

    1597. 

  1597.             }

    1598. 

  1598.         }

    1599. 

  1599.     }

    1600. 

  1600.     

    1601. 

  1601.     echo '</table><br>';

    1602. 

  1602.     echo '<script type="text/javascript">if (document.getElementById("Autofixing")) document.getElementById("Autofixing").innerHTML = "";</script>';

    1603. 

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

    1604. 

  1604. 

    1605. 

  1605. }

    1606. 

  1606. elseif (! empty($_REQUEST['filenamepattern']))

    1607. 

  1607. {

    1608. 

  1608.     

    1609. 

  1609.     $patterns['A'] = 'artist';

    1610. 

  1610.     $patterns['T'] = 'title';

    1611. 

  1611.     $patterns['M'] = 'album';

    1612. 

  1612.     $patterns['N'] = 'track';

    1613. 

  1613.     $patterns['G'] = 'genre';

    1614. 

  1614.     $patterns['R'] = 'remix';

    1615. 

  1615.     

    1616. 

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

    1617. 

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

  1618.     foreach ($FieldsToUse as $FieldID)

    1619. 

  1619.     {

    1620. 

  1620.         $FieldNames[] = $patterns["$FieldID"];

    1621. 

  1621.     }

    1622. 

  1622.     

    1623. 

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

    1624. 

  1624.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1625. 

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

    1626. 

  1626.     $SQLquery .= ' ORDER BY `filename` ASC';

    1627. 

  1627.     $result = safe_mysql_query($SQLquery);

    1628. 

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

    1629. 

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

    1630. 

  1630.     echo '<tr><th>view</th><th>Why</th><td><b>Actual filename</b><br>(click to play/edit file)</td><td><b>Correct filename (based on tags)</b>' . (! @$_REQUEST['autofix'] ? '<br>(click to rename file to this)' : '') . '</td></tr>';

    1631. 

  1631.     $nonmatchingfilenames = 0;

    1632. 

  1632.     $Pattern = $_REQUEST['filenamepattern'];

    1633. 

  1633.     $PatternLength = strlen($Pattern);

    1634. 

  1634.     while ($row = mysql_fetch_array($result))

    1635. 

  1635.     {

    1636. 

  1636.         set_time_limit(10);

    1637. 

  1637.         $PatternFilename = '';

    1638. 

  1638.         for($i = 0; $i < $PatternLength; $i ++)

    1639. 

  1639.         {

    1640. 

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

    1641. 

  1641.             {

    1642. 

  1642.                 $PatternFilename .= trim(strtr($row[$patterns[$Pattern{$i}]], ':\\*<>|', ';-����'), ' ');

    1643. 

  1643.             }

    1644. 

  1644.             else

    1645. 

  1645.             {

    1646. 

  1646.                 $PatternFilename .= $Pattern{$i};

    1647. 

  1647.             }

    1648. 

  1648.         }

    1649. 

  1649.         

    1650. 

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

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

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

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

    1654. 

  1654.         $PatternFilename = str_replace('/', '�', $PatternFilename);

    1655. 

  1655.         

    1656. 

  1656.         $PatternFilename = str_replace('?', '�', $PatternFilename);

    1657. 

  1657.         $PatternFilename = str_replace(' "', ' �', $PatternFilename);

    1658. 

  1658.         $PatternFilename = str_replace('("', '(�', $PatternFilename);

    1659. 

  1659.         $PatternFilename = str_replace('-"', '-�', $PatternFilename);

    1660. 

  1660.         $PatternFilename = str_replace('" ', '� ', $PatternFilename . ' ');

    1661. 

  1661.         $PatternFilename = str_replace('"', '�', $PatternFilename);

    1662. 

  1662.         $PatternFilename = str_replace('  ', ' ', $PatternFilename);

    1663. 

  1663.         

    1664. 

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

    1665. 

  1665.         foreach ($ParenthesesPairs as $pair)

    1666. 

  1666.         {

    1667. 

  1667.             

    1668. 

  1668.             // multiple remixes are stored tab-seperated in the database.
    1669. 

  1669.             // change "{2000 Version\tSomebody Remix}" into "{2000 Version} {Somebody Remix}"
    1670. 

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

    1671. 

  1671.             {

    1672. 

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

    1673. 

  1673.             }

    1674. 

  1674.             

    1675. 

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

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

    1677. 

  1677.             

    1678. 

  1678.             // "[01]  - Title With No Artist.mp3"  ==>  "[01] Title With No Artist.mp3"
    1679. 

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

    1680. 

  1680.         

    1681. 

  1681.         }

    1682. 

  1682.         

    1683. 

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

  1684.         $PatternFilename = trim($PatternFilename, ' -');

    1685. 

  1685.         

    1686. 

  1686.         if (! $PatternFilename)

    1687. 

  1687.         {

    1688. 

  1688.             // no tags to create a filename from -- skip this file
    1689. 

  1689.             continue;

    1690. 

  1690.         }

    1691. 

  1691.         $PatternFilename .= '.' . $row['fileformat'];

    1692. 

  1692.         

    1693. 

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

    1694. 

  1694.         if ($ActualFilename != $PatternFilename)

    1695. 

  1695.         {

    1696. 

  1696.             

    1697. 

  1697.             $NotMatchedReasons = '';

    1698. 

  1698.             if (strtolower($ActualFilename) === strtolower($PatternFilename))

    1699. 

  1699.             {

    1700. 

  1700.                 $NotMatchedReasons .= 'Aa ';

    1701. 

  1701.             }

    1702. 

  1702.             elseif (RemoveAccents($ActualFilename) === RemoveAccents($PatternFilename))

    1703. 

  1703.             {

    1704. 

  1704.                 $NotMatchedReasons .= '�e ';

    1705. 

  1705.             }

    1706. 

  1706.             

    1707. 

  1707.             $actualExt = '.' . fileextension($ActualFilename);

    1708. 

  1708.             $patternExt = '.' . fileextension($PatternFilename);

    1709. 

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

    1710. 

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

    1711. 

  1711.             

    1712. 

  1712.             if (strpos($PatternFilenameNoExt, $ActualFilenameNoExt) !== false)

    1713. 

  1713.             {

    1714. 

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

    1715. 

  1715.             }

    1716. 

  1716.             else

    1717. 

  1717.             {

    1718. 

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

    1719. 

  1719.                 for($DifferenceOffset = 0; $DifferenceOffset < $ShortestNameLength; $DifferenceOffset ++)

    1720. 

  1720.                 {

    1721. 

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

    1722. 

  1722.                     {

    1723. 

  1723.                         break;

    1724. 

  1724.                     }

    1725. 

  1725.                 }

    1726. 

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

    1727. 

  1727.             }

    1728. 

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

    1729. 

  1729.             

    1730. 

  1730.             echo '<tr>';

    1731. 

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

    1732. 

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

    1733. 

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

    1734. 

  1734.             

    1735. 

  1735.             if (@$_REQUEST['autofix'])

    1736. 

  1736.             {

    1737. 

  1737.                 

    1738. 

  1738.                 $results = '';

    1739. 

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

    1740. 

  1740.                 {

    1741. 

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

    1742. 

  1742.                 }

    1743. 

  1743.                 else

    1744. 

  1744.                 {

    1745. 

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

    1746. 

  1746.                 }

    1747. 

  1747.                 echo '<b>' . $DifferenceBoldedName . '</b></td>';

    1748. 

  1748.             

    1749. 

  1749.             }

    1750. 

  1750.             else

    1751. 

  1751.             {

    1752. 

  1752.                 

    1753. 

  1753.                 echo '<td><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?filenamepattern=' . urlencode($_REQUEST['filenamepattern']) . '&renamefilefrom=' . urlencode($row['filename']) . '&renamefileto=' . urlencode(dirname($row['filename']) . '/' . $PatternFilename)) . '" title="' . FixTextFields(basename($row['filename'])) . "\n" . FixTextFields(basename($PatternFilename)) . '" TARGET="renamewindow">';

    1754. 

  1754.                 echo '<b>' . $DifferenceBoldedName . '</b></a></td>';

    1755. 

  1755.             

    1756. 

  1756.             }

    1757. 

  1757.             echo '</tr>';

    1758. 

  1758.             

    1759. 

  1759.             $nonmatchingfilenames ++;

    1760. 

  1760.         }

    1761. 

  1761.     }

    1762. 

  1762.     echo '</table><br>';

    1763. 

  1763.     echo 'Found ' . number_format($nonmatchingfilenames) . ' files that do not match naming pattern<br>';

    1764. 

  1764. 

    1765. 

  1765. }

    1766. 

  1766. elseif (! empty($_REQUEST['encoderoptionsdistribution']))

    1767. 

  1767. {

    1768. 

  1768.     

    1769. 

  1769.     if (isset($_REQUEST['showtagfiles']))

    1770. 

  1770.     {

    1771. 

  1771.         $SQLquery = 'SELECT `filename`, `encoder_options` FROM `' . GETID3_DB_TABLE . '`';

    1772. 

  1772.         $SQLquery .= ' WHERE (`encoder_options` LIKE "' . mysql_escape_string($_REQUEST['showtagfiles']) . '")';

    1773. 

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

    1774. 

  1774.         $SQLquery .= ' ORDER BY `filename` ASC';

    1775. 

  1775.         $result = safe_mysql_query($SQLquery);

    1776. 

  1776.         

    1777. 

  1777.         if (! empty($_REQUEST['m3u']))

    1778. 

  1778.         {

    1779. 

  1779.             

    1780. 

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

    1781. 

  1781.             echo '#EXTM3U' . "\n";

    1782. 

  1782.             while ($row = mysql_fetch_array($result))

    1783. 

  1783.             {

    1784. 

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

    1785. 

  1785.             }

    1786. 

  1786.             exit();

    1787. 

  1787.         

    1788. 

  1788.         }

    1789. 

  1789.         else

    1790. 

  1790.         {

    1791. 

  1791.             

    1792. 

  1792.             echo '<a href="' . htmlentities($_SERVER['PHP_SELF'] . '?encoderoptionsdistribution=1') . '">Show all Encoder Options</a><hr>';

    1793. 

  1793.             echo 'Files with Encoder Options <b>' . $_REQUEST['showtagfiles'] . '</b>:<br>';

    1794. 

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

    1795. 

  1795.             while ($row = mysql_fetch_array($result))

    1796. 

  1796.             {

    1797. 

  1797.                 echo '<tr>';

    1798. 

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

    1799. 

  1799.                 echo '<td>' . $row['encoder_options'] . '</td>';

    1800. 

  1800.                 echo '</tr>';

    1801. 

  1801.             }

    1802. 

  1802.             echo '</table>';

    1803. 

  1803.         

    1804. 

  1804.         }

    1805. 

  1805.     

    1806. 

  1806.     }

    1807. 

  1807.     elseif (! isset($_REQUEST['m3u']))

    1808. 

  1808.     {

    1809. 

  1809.         

    1810. 

  1810.         $SQLquery = 'SELECT `encoder_options`, COUNT(*) AS `num` FROM `' . GETID3_DB_TABLE . '`';

    1811. 

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

    1812. 

  1812.         $SQLquery .= ' GROUP BY `encoder_options`';

    1813. 

  1813.         $SQLquery .= ' ORDER BY (`encoder_options` LIKE "LAME%") DESC, (`encoder_options` LIKE "CBR%") DESC, `num` DESC, `encoder_options` ASC';

    1814. 

  1814.         $result = safe_mysql_query($SQLquery);

    1815. 

  1815.         echo 'Files with Encoder Options:<br>';

    1816. 

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

    1817. 

  1817.         echo '<tr><th>Encoder Options</th><th>Count</th><th>M3U</th></tr>';

    1818. 

  1818.         while ($row = mysql_fetch_array($result))

    1819. 

  1819.         {

    1820. 

  1820.             echo '<tr>';

    1821. 

  1821.             echo '<td>' . $row['encoder_options'] . '</td>';

    1822. 

  1822.             echo '<TD ALIGN="RIGHT"><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?encoderoptionsdistribution=1&showtagfiles=' . ($row['encoder_options'] ? urlencode($row['encoder_options']) : '')) . '">' . number_format($row['num']) . '</a></td>';

    1823. 

  1823.             echo '<TD ALIGN="RIGHT"><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?encoderoptionsdistribution=1&showtagfiles=' . ($row['encoder_options'] ? urlencode($row['encoder_options']) : '') . '&m3u=.m3u') . '">m3u</a></td>';

    1824. 

  1824.             echo '</tr>';

    1825. 

  1825.         }

    1826. 

  1826.         echo '</table><hr>';

    1827. 

  1827.     

    1828. 

  1828.     }

    1829. 

  1829. 

    1830. 

  1830. }

    1831. 

  1831. elseif (! empty($_REQUEST['tagtypes']))

    1832. 

  1832. {

    1833. 

  1833.     

    1834. 

  1834.     if (! isset($_REQUEST['m3u']))

    1835. 

  1835.     {

    1836. 

  1836.         $SQLquery = 'SELECT `tags`, COUNT(*) AS `num` FROM `' . GETID3_DB_TABLE . '`';

    1837. 

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

    1838. 

  1838.         $SQLquery .= ' GROUP BY `tags`';

    1839. 

  1839.         $SQLquery .= ' ORDER BY `num` DESC';

    1840. 

  1840.         $result = safe_mysql_query($SQLquery);

    1841. 

  1841.         echo 'Files with tags:<br>';

    1842. 

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

    1843. 

  1843.         echo '<tr><th>Tags</th><th>Count</th><th>M3U</th></tr>';

    1844. 

  1844.         while ($row = mysql_fetch_array($result))

    1845. 

  1845.         {

    1846. 

  1846.             echo '<tr>';

    1847. 

  1847.             echo '<td>' . $row['tags'] . '</td>';

    1848. 

  1848.             echo '<TD ALIGN="RIGHT"><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?tagtypes=1&showtagfiles=' . ($row['tags'] ? urlencode($row['tags']) : '')) . '">' . number_format($row['num']) . '</a></td>';

    1849. 

  1849.             echo '<TD ALIGN="RIGHT"><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?tagtypes=1&showtagfiles=' . ($row['tags'] ? urlencode($row['tags']) : '') . '&m3u=.m3u') . '">m3u</a></td>';

    1850. 

  1850.             echo '</tr>';

    1851. 

  1851.         }

    1852. 

  1852.         echo '</table><hr>';

    1853. 

  1853.     }

    1854. 

  1854.     

    1855. 

  1855.     if (isset($_REQUEST['showtagfiles']))

    1856. 

  1856.     {

    1857. 

  1857.         $SQLquery = 'SELECT `filename`, `tags` FROM `' . GETID3_DB_TABLE . '`';

    1858. 

  1858.         $SQLquery .= ' WHERE (`tags` LIKE "' . mysql_escape_string($_REQUEST['showtagfiles']) . '")';

    1859. 

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

    1860. 

  1860.         $SQLquery .= ' ORDER BY `filename` ASC';

    1861. 

  1861.         $result = safe_mysql_query($SQLquery);

    1862. 

  1862.         

    1863. 

  1863.         if (! empty($_REQUEST['m3u']))

    1864. 

  1864.         {

    1865. 

  1865.             

    1866. 

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

    1867. 

  1867.             echo '#EXTM3U' . "\n";

    1868. 

  1868.             while ($row = mysql_fetch_array($result))

    1869. 

  1869.             {

    1870. 

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

    1871. 

  1871.             }

    1872. 

  1872.             exit();

    1873. 

  1873.         

    1874. 

  1874.         }

    1875. 

  1875.         else

    1876. 

  1876.         {

    1877. 

  1877.             

    1878. 

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

    1879. 

  1879.             while ($row = mysql_fetch_array($result))

    1880. 

  1880.             {

    1881. 

  1881.                 echo '<tr>';

    1882. 

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

    1883. 

  1883.                 echo '<td>' . $row['tags'] . '</td>';

    1884. 

  1884.                 echo '</tr>';

    1885. 

  1885.             }

    1886. 

  1886.             echo '</table>';

    1887. 

  1887.         

    1888. 

  1888.         }

    1889. 

  1889.     }

    1890. 

  1890. 

    1891. 

  1891. }

    1892. 

  1892. elseif (! empty($_REQUEST['md5datadupes']))

    1893. 

  1893. {

    1894. 

  1894.     

    1895. 

  1895.     $OtherFormats = '';

    1896. 

  1896.     $AVFormats = '';

    1897. 

  1897.     

    1898. 

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

    1899. 

  1899.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1900. 

  1900.     $SQLquery .= ' WHERE (`md5_data` <> "")';

    1901. 

  1901.     $SQLquery .= ' GROUP BY `md5_data`';

    1902. 

  1902.     $SQLquery .= ' ORDER BY `num` DESC';

    1903. 

  1903.     $result = safe_mysql_query($SQLquery);

    1904. 

  1904.     while (($row = mysql_fetch_array($result)) && ($row['num'] > 1))

    1905. 

  1905.     {

    1906. 

  1906.         set_time_limit(30);

    1907. 

  1907.         

    1908. 

  1908.         $filenames = array();

    1909. 

  1909.         $tags = array();

    1910. 

  1910.         $md5_data = array();

    1911. 

  1911.         $SQLquery = 'SELECT `fileformat`, `filename`, `tags`';

    1912. 

  1912.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1913. 

  1913.         $SQLquery .= ' WHERE (`md5_data` = "' . mysql_escape_string($row['md5_data']) . '")';

    1914. 

  1914.         $SQLquery .= ' ORDER BY `filename` ASC';

    1915. 

  1915.         $result2 = safe_mysql_query($SQLquery);

    1916. 

  1916.         while ($row2 = mysql_fetch_array($result2))

    1917. 

  1917.         {

    1918. 

  1918.             $thisfileformat = $row2['fileformat'];

    1919. 

  1919.             $filenames[] = $row2['filename'];

    1920. 

  1920.             $tags[] = $row2['tags'];

    1921. 

  1921.             $md5_data[] = $row['md5_data'];

    1922. 

  1922.         }

    1923. 

  1923.         

    1924. 

  1924.         $thisline = '<tr>';

    1925. 

  1925.         $thisline .= '<TD VALIGN="TOP" style="font-family: monospace;">' . implode('<br>', $md5_data) . '</td>';

    1926. 

  1926.         $thisline .= '<TD VALIGN="TOP" NOWRAP>' . implode('<br>', $tags) . '</td>';

    1927. 

  1927.         $thisline .= '<TD VALIGN="TOP">' . implode('<br>', $filenames) . '</td>';

    1928. 

  1928.         $thisline .= '</tr>';

    1929. 

  1929.         

    1930. 

  1930.         if (in_array($thisfileformat, $IgnoreNoTagFormats))

    1931. 

  1931.         {

    1932. 

  1932.             $OtherFormats .= $thisline;

    1933. 

  1933.         }

    1934. 

  1934.         else

    1935. 

  1935.         {

    1936. 

  1936.             $AVFormats .= $thisline;

    1937. 

  1937.         }

    1938. 

  1938.     }

    1939. 

  1939.     echo 'Duplicated MD5_DATA (Audio/Video files):<table border="1" cellspacing="0" cellpadding="2">';

    1940. 

  1940.     echo $AVFormats . '</table><hr>';

    1941. 

  1941.     echo 'Duplicated MD5_DATA (Other files):<table border="1" cellspacing="0" cellpadding="2">';

    1942. 

  1942.     echo $OtherFormats . '</table><hr>';

    1943. 

  1943. 

    1944. 

  1944. }

    1945. 

  1945. elseif (! empty($_REQUEST['artisttitledupes']))

    1946. 

  1946. {

    1947. 

  1947.     

    1948. 

  1948.     if (isset($_REQUEST['m3uartist']) && isset($_REQUEST['m3utitle']))

    1949. 

  1949.     {

    1950. 

  1950.         

    1951. 

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

    1952. 

  1952.         echo '#EXTM3U' . "\n";

    1953. 

  1953.         $SQLquery = 'SELECT `filename`';

    1954. 

  1954.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1955. 

  1955.         $SQLquery .= ' WHERE (`artist` = "' . mysql_escape_string($_REQUEST['m3uartist']) . '")';

    1956. 

  1956.         $SQLquery .= ' AND (`title` = "' . mysql_escape_string($_REQUEST['m3utitle']) . '")';

    1957. 

  1957.         $SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';

    1958. 

  1958.         $result = safe_mysql_query($SQLquery);

    1959. 

  1959.         while ($row = mysql_fetch_array($result))

    1960. 

  1960.         {

    1961. 

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

    1962. 

  1962.         }

    1963. 

  1963.         exit();

    1964. 

  1964.     

    1965. 

  1965.     }

    1966. 

  1966.     

    1967. 

  1967.     $SQLquery = 'SELECT `artist`, `title`, `filename`, COUNT(*) AS `num`';

    1968. 

  1968.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1969. 

  1969.     $SQLquery .= ' WHERE (`artist` <> "")';

    1970. 

  1970.     $SQLquery .= ' AND (`title` <> "")';

    1971. 

  1971.     $SQLquery .= ' GROUP BY `artist`, `title`' . (@$_REQUEST['samemix'] ? ', `remix`' : '');

    1972. 

  1972.     $SQLquery .= ' ORDER BY `num` DESC, `artist` ASC, `title` ASC, `playtime_seconds` ASC, `remix` ASC';

    1973. 

  1973.     $result = safe_mysql_query($SQLquery);

    1974. 

  1974.     $uniquetitles = 0;

    1975. 

  1975.     $uniquefiles = 0;

    1976. 

  1976.     

    1977. 

  1977.     if (! empty($_REQUEST['m3u']))

    1978. 

  1978.     {

    1979. 

  1979.         

    1980. 

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

    1981. 

  1981.         echo '#EXTM3U' . "\n";

    1982. 

  1982.         while (($row = mysql_fetch_array($result)) && ($row['num'] > 1))

    1983. 

  1983.         {

    1984. 

  1984.             $SQLquery = 'SELECT `filename`';

    1985. 

  1985.             $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    1986. 

  1986.             $SQLquery .= ' WHERE (`artist` = "' . mysql_escape_string($row['artist']) . '")';

    1987. 

  1987.             $SQLquery .= ' AND (`title` = "' . mysql_escape_string($row['title']) . '")';

    1988. 

  1988.             if (@$_REQUEST['samemix'])

    1989. 

  1989.             {

    1990. 

  1990.                 $SQLquery .= ' AND (`remix` = "' . mysql_escape_string($row['remix']) . '")';

    1991. 

  1991.             }

    1992. 

  1992.             $SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';

    1993. 

  1993.             $result2 = safe_mysql_query($SQLquery);

    1994. 

  1994.             while ($row2 = mysql_fetch_array($result2))

    1995. 

  1995.             {

    1996. 

  1996.                 echo WindowsShareSlashTranslate($row2['filename']) . "\n";

    1997. 

  1997.             }

    1998. 

  1998.         }

    1999. 

  1999.         exit();

    2000. 

  2000.     

    2001. 

  2001.     }

    2002. 

  2002.     else

    2003. 

  2003.     {

    2004. 

  2004.         

    2005. 

  2005.         echo 'Duplicated aritst + title: (<a href="' . htmlentities($_SERVER['PHP_SELF'] . '?artisttitledupes=1&samemix=1') . '">Identical Mix/Version only</a>)<br>';

    2006. 

  2006.         echo '(<a href="' . htmlentities($_SERVER['PHP_SELF'] . '?artisttitledupes=1&m3u=.m3u') . '">.m3u version</a>)<br>';

    2007. 

  2007.         echo '<table border="1" cellspacing="0" cellpadding="2">';

    2008. 

  2008.         echo '<tr><th colspan="3">&nbsp;</th><th>Artist</th><th>Title</th><th>Version</th><th>&nbsp;</th><th>&nbsp;</th><th>Filename</th></tr>';

    2009. 

  2009.         

    2010. 

  2010.         while (($row = mysql_fetch_array($result)) && ($row['num'] > 1))

    2011. 

  2011.         {

    2012. 

  2012.             $uniquetitles ++;

    2013. 

  2013.             set_time_limit(30);

    2014. 

  2014.             

    2015. 

  2015.             $filenames = array();

    2016. 

  2016.             $artists = array();

    2017. 

  2017.             $titles = array();

    2018. 

  2018.             $remixes = array();

    2019. 

  2019.             $bitrates = array();

    2020. 

  2020.             $playtimes = array();

    2021. 

  2021.             $SQLquery = 'SELECT `filename`, `artist`, `title`, `remix`, `audio_bitrate`, `vbr_method`, `playtime_seconds`, `encoder_options`';

    2022. 

  2022.             $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2023. 

  2023.             $SQLquery .= ' WHERE (`artist` = "' . mysql_escape_string($row['artist']) . '")';

    2024. 

  2024.             $SQLquery .= ' AND (`title` = "' . mysql_escape_string($row['title']) . '")';

    2025. 

  2025.             $SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';

    2026. 

  2026.             $result2 = safe_mysql_query($SQLquery);

    2027. 

  2027.             while ($row2 = mysql_fetch_array($result2))

    2028. 

  2028.             {

    2029. 

  2029.                 $uniquefiles ++;

    2030. 

  2030.                 $filenames[] = $row2['filename'];

    2031. 

  2031.                 $artists[] = $row2['artist'];

    2032. 

  2032.                 $titles[] = $row2['title'];

    2033. 

  2033.                 $remixes[] = $row2['remix'];

    2034. 

  2034.                 if ($row2['vbr_method'])

    2035. 

  2035.                 {

    2036. 

  2036.                     $bitrates[] = '<B' . ($row2['encoder_options'] ? ' style="text-decoration: underline; cursor: help;" title="' . $row2['encoder_options'] : '') . '">' . BitrateText($row2['audio_bitrate'] / 1000) . '</b>';

    2037. 

  2037.                 }

    2038. 

  2038.                 else

    2039. 

  2039.                 {

    2040. 

  2040.                     $bitrates[] = BitrateText($row2['audio_bitrate'] / 1000);

    2041. 

  2041.                 }

    2042. 

  2042.                 $playtimes[] = getid3_lib :: PlaytimeString($row2['playtime_seconds']);

    2043. 

  2043.             }

    2044. 

  2044.             

    2045. 

  2045.             echo '<tr>';

    2046. 

  2046.             echo '<TD NOWRAP VALIGN="TOP">';

    2047. 

  2047.             foreach ($filenames as $file)

    2048. 

  2048.             {

    2049. 

  2049.                 echo '<a href="' . htmlentities('demo.browse.php?deletefile=' . urlencode($file) . '&noalert=1') . '" onClick="return confirm(\'Are you sure you want to delete ' . addslashes($file) . '? \n(this action cannot be un-done)\');" title="Permanently delete ' . "\n" . FixTextFields($file) . "\n" . '" TARGET="deletedupewindow">delete</a><br>';

    2050. 

  2050.             }

    2051. 

  2051.             echo '</td>';

    2052. 

  2052.             echo '<TD NOWRAP VALIGN="TOP">';

    2053. 

  2053.             foreach ($filenames as $file)

    2054. 

  2054.             {

    2055. 

  2055.                 echo '<a href="' . htmlentities($_SERVER['PHP_SELF'] . '?m3ufilename=' . urlencode($file)) . '">play</a><br>';

    2056. 

  2056.             }

    2057. 

  2057.             echo '</td>';

    2058. 

  2058.             echo '<TD VALIGN="MIDDLE" ALIGN="CENTER" ><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?artisttitledupes=1&m3uartist=' . urlencode($artists[0]) . '&m3utitle=' . urlencode($titles[0])) . '">play all</a></td>';

    2059. 

  2059.             echo '<TD VALIGN="TOP" NOWRAP>' . implode('<br>', $artists) . '</td>';

    2060. 

  2060.             echo '<TD VALIGN="TOP" NOWRAP>' . implode('<br>', $titles) . '</td>';

    2061. 

  2061.             echo '<TD VALIGN="TOP" NOWRAP>' . implode('<br>', $remixes) . '</td>';

    2062. 

  2062.             echo '<TD VALIGN="TOP" NOWRAP ALIGN="RIGHT">' . implode('<br>', $bitrates) . '</td>';

    2063. 

  2063.             echo '<TD VALIGN="TOP" NOWRAP ALIGN="RIGHT">' . implode('<br>', $playtimes) . '</td>';

    2064. 

  2064.             

    2065. 

  2065.             echo '<TD VALIGN="TOP" NOWRAP ALIGN="LEFT"><table border="0" cellspacing="0" cellpadding="0">';

    2066. 

  2066.             foreach ($filenames as $file)

    2067. 

  2067.             {

    2068. 

  2068.                 echo '<tr><TD NOWRAP ALIGN="RIGHT"><a href="' . htmlentities('demo.browse.php?filename=' . rawurlencode($file)) . '"><span style="color: #339966;">' . dirname($file) . '/</span>' . basename($file) . '</a></td></tr>';

    2069. 

  2069.             }

    2070. 

  2070.             echo '</table></td>';

    2071. 

  2071.             

    2072. 

  2072.             echo '</tr>';

    2073. 

  2073.         }

    2074. 

  2074.     

    2075. 

  2075.     }

    2076. 

  2076.     echo '</table>';

    2077. 

  2077.     echo number_format($uniquefiles) . ' files with ' . number_format($uniquetitles) . ' unique <i>aritst + title</i><br>';

    2078. 

  2078.     echo '<hr>';

    2079. 

  2079. 

    2080. 

  2080. }

    2081. 

  2081. elseif (! empty($_REQUEST['filetypelist']))

    2082. 

  2082. {

    2083. 

  2083.     

    2084. 

  2084.     list($fileformat, $audioformat) = explode('|', $_REQUEST['filetypelist']);

    2085. 

  2085.     $SQLquery = 'SELECT `filename`, `fileformat`, `audio_dataformat`';

    2086. 

  2086.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2087. 

  2087.     $SQLquery .= ' WHERE (`fileformat` = "' . mysql_escape_string($fileformat) . '")';

    2088. 

  2088.     $SQLquery .= ' AND (`audio_dataformat` = "' . mysql_escape_string($audioformat) . '")';

    2089. 

  2089.     $SQLquery .= ' ORDER BY `filename` ASC';

    2090. 

  2090.     $result = safe_mysql_query($SQLquery);

    2091. 

  2091.     echo 'Files of format <b>' . $fileformat . '.' . $audioformat . '</b>:<table border="1" cellspacing="0" cellpadding="4">';

    2092. 

  2092.     echo '<tr><th>file</th><th>audio</th><th>filename</th></tr>';

    2093. 

  2093.     while ($row = mysql_fetch_array($result))

    2094. 

  2094.     {

    2095. 

  2095.         echo '<tr>';

    2096. 

  2096.         echo '<td>' . $row['fileformat'] . '</td>';

    2097. 

  2097.         echo '<td>' . $row['audio_dataformat'] . '</td>';

    2098. 

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

    2099. 

  2099.         echo '</tr>';

    2100. 

  2100.     }

    2101. 

  2101.     echo '</table><hr>';

    2102. 

  2102. 

    2103. 

  2103. }

    2104. 

  2104. elseif (! empty($_REQUEST['trackinalbum']))

    2105. 

  2105. {

    2106. 

  2106.     

    2107. 

  2107.     $SQLquery = 'SELECT `filename`, `album`';

    2108. 

  2108.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2109. 

  2109.     $SQLquery .= ' WHERE (`album` LIKE "% [%")';

    2110. 

  2110.     $SQLquery .= ' ORDER BY `album` ASC, `filename` ASC';

    2111. 

  2111.     $result = safe_mysql_query($SQLquery);

    2112. 

  2112.     if (! empty($_REQUEST['m3u']))

    2113. 

  2113.     {

    2114. 

  2114.         

    2115. 

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

    2116. 

  2116.         echo '#EXTM3U' . "\n";

    2117. 

  2117.         while ($row = mysql_fetch_array($result))

    2118. 

  2118.         {

    2119. 

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

    2120. 

  2120.         }

    2121. 

  2121.         exit();

    2122. 

  2122.     

    2123. 

  2123.     }

    2124. 

  2124.     elseif (! empty($_REQUEST['autofix']))

    2125. 

  2125.     {

    2126. 

  2126.         

    2127. 

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

    2128. 

  2128.         getid3_lib :: IncludeDependency(GETID3_INCLUDEPATH . 'module.tag.id3v2.php', __FILE__, true);

    2129. 

  2129.         

    2130. 

  2130.         while ($row = mysql_fetch_array($result))

    2131. 

  2131.         {

    2132. 

  2132.             set_time_limit(30);

    2133. 

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

    2134. 

  2134.             getid3_lib :: CopyTagsToComments($ThisFileInfo);

    2135. 

  2135.             

    2136. 

  2136.             if (! empty($ThisFileInfo['tags']))

    2137. 

  2137.             {

    2138. 

  2138.                 

    2139. 

  2139.                 $Album = trim(str_replace(strstr($ThisFileInfo['comments']['album'][0], ' ['), '', $ThisFileInfo['comments']['album'][0]));

    2140. 

  2140.                 $Track = (string) intval(str_replace(' [', '', str_replace(']', '', strstr($ThisFileInfo['comments']['album'][0], ' ['))));

    2141. 

  2141.                 if ($Track == '0')

    2142. 

  2142.                 {

    2143. 

  2143.                     $Track = '';

    2144. 

  2144.                 }

    2145. 

  2145.                 if ($Album && $Track)

    2146. 

  2146.                 {

    2147. 

  2147.                     echo '<hr>' . FixTextFields($row['filename']) . '<br>';

    2148. 

  2148.                     echo '<i>' . $Album . '</i> (track #' . $Track . ')<br>';

    2149. 

  2149.                     echo '<b>ID3v2:</b> ' . (RemoveID3v2($row['filename'], false) ? 'removed' : 'REMOVAL FAILED!') . ', ';

    2150. 

  2150.                     echo '<b>ID3v1:</b> ' . (WriteID3v1($row['filename'], @$ThisFileInfo['comments']['title'][0], @$ThisFileInfo['comments']['artist'][0], $Album, @$ThisFileInfo['comments']['year'][0], @$ThisFileInfo['comments']['comment'][0], @$ThisFileInfo['comments']['genreid'][0], $Track, false) ? 'updated' : 'UPDATE FAILED') . '<br>';

    2151. 

  2151.                 }

    2152. 

  2152.                 else

    2153. 

  2153.                 {

    2154. 

  2154.                     echo ' . ';

    2155. 

  2155.                 }

    2156. 

  2156.             

    2157. 

  2157.             }

    2158. 

  2158.             else

    2159. 

  2159.             {

    2160. 

  2160.                 

    2161. 

  2161.                 echo '<hr>FAILED<br>' . FixTextFields($row['filename']) . '<hr>';

    2162. 

  2162.             

    2163. 

  2163.             }

    2164. 

  2164.             flush();

    2165. 

  2165.         }

    2166. 

  2166.     

    2167. 

  2167.     }

    2168. 

  2168.     else

    2169. 

  2169.     {

    2170. 

  2170.         

    2171. 

  2171.         echo '<b>' . number_format(mysql_num_rows($result)) . '</b> files with <b>[??]</b>-format track numbers in album field:<br>';

    2172. 

  2172.         if (mysql_num_rows($result) > 0)

    2173. 

  2173.         {

    2174. 

  2174.             echo '(<a href="' . htmlentities($_SERVER['PHP_SELF'] . '?trackinalbum=1&m3u=.m3u') . '">.m3u version</a>)<br>';

    2175. 

  2175.             echo '<a href="' . htmlentities($_SERVER['PHP_SELF'] . '?trackinalbum=1&autofix=1') . '">Try to auto-fix</a><br>';

    2176. 

  2176.             echo '<table border="1" cellspacing="0" cellpadding="4">';

    2177. 

  2177.             while ($row = mysql_fetch_array($result))

    2178. 

  2178.             {

    2179. 

  2179.                 echo '<tr>';

    2180. 

  2180.                 echo '<td>' . $row['album'] . '</td>';

    2181. 

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

    2182. 

  2182.                 echo '</tr>';

    2183. 

  2183.             }

    2184. 

  2184.             echo '</table>';

    2185. 

  2185.         }

    2186. 

  2186.         echo '<hr>';

    2187. 

  2187.     

    2188. 

  2188.     }

    2189. 

  2189. 

    2190. 

  2190. }

    2191. 

  2191. elseif (! empty($_REQUEST['fileextensions']))

    2192. 

  2192. {

    2193. 

  2193.     

    2194. 

  2194.     $SQLquery = 'SELECT `filename`, `fileformat`, `audio_dataformat`, `video_dataformat`, `tags`';

    2195. 

  2195.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2196. 

  2196.     $SQLquery .= ' ORDER BY `filename` ASC';

    2197. 

  2197.     $result = safe_mysql_query($SQLquery);

    2198. 

  2198.     $invalidextensionfiles = 0;

    2199. 

  2199.     $invalidextensionline = '<table border="1" cellspacing="0" cellpadding="4">';

    2200. 

  2200.     $invalidextensionline .= '<tr><th>file</th><th>audio</th><th>video</th><th>tags</th><th>actual</th><th>correct</th><th>filename</th></tr>';

    2201. 

  2201.     while ($row = mysql_fetch_array($result))

    2202. 

  2202.     {

    2203. 

  2203.         set_time_limit(30);

    2204. 

  2204.         

    2205. 

  2205.         $acceptableextensions = AcceptableExtensions($row['fileformat'], $row['audio_dataformat'], $row['video_dataformat']);

    2206. 

  2206.         $actualextension = strtolower(fileextension($row['filename']));

    2207. 

  2207.         if ($acceptableextensions && ! in_array($actualextension, $acceptableextensions))

    2208. 

  2208.         {

    2209. 

  2209.             $invalidextensionfiles ++;

    2210. 

  2210.             

    2211. 

  2211.             $invalidextensionline .= '<tr>';

    2212. 

  2212.             $invalidextensionline .= '<td>' . $row['fileformat'] . '</td>';

    2213. 

  2213.             $invalidextensionline .= '<td>' . $row['audio_dataformat'] . '</td>';

    2214. 

  2214.             $invalidextensionline .= '<td>' . $row['video_dataformat'] . '</td>';

    2215. 

  2215.             $invalidextensionline .= '<td>' . $row['tags'] . '</td>';

    2216. 

  2216.             $invalidextensionline .= '<td>' . $actualextension . '</td>';

    2217. 

  2217.             $invalidextensionline .= '<td>' . implode('; ', $acceptableextensions) . '</td>';

    2218. 

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

    2219. 

  2219.             $invalidextensionline .= '</tr>';

    2220. 

  2220.         }

    2221. 

  2221.     }

    2222. 

  2222.     $invalidextensionline .= '</table><hr>';

    2223. 

  2223.     echo number_format($invalidextensionfiles) . ' files with incorrect filename extension:<br>';

    2224. 

  2224.     echo $invalidextensionline;

    2225. 

  2225. 

    2226. 

  2226. }

    2227. 

  2227. elseif (isset($_REQUEST['genredistribution']))

    2228. 

  2228. {

    2229. 

  2229.     

    2230. 

  2230.     if (! empty($_REQUEST['m3u']))

    2231. 

  2231.     {

    2232. 

  2232.         

    2233. 

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

    2234. 

  2234.         echo '#EXTM3U' . "\n";

    2235. 

  2235.         $SQLquery = 'SELECT `filename`';

    2236. 

  2236.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2237. 

  2237.         $SQLquery .= ' WHERE (BINARY `genre` = "' . $_REQUEST['genredistribution'] . '")';

    2238. 

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

    2239. 

  2239.         $SQLquery .= ' ORDER BY `filename` ASC';

    2240. 

  2240.         $result = safe_mysql_query($SQLquery);

    2241. 

  2241.         while ($row = mysql_fetch_array($result))

    2242. 

  2242.         {

    2243. 

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

    2244. 

  2244.         }

    2245. 

  2245.         exit();

    2246. 

  2246.     

    2247. 

  2247.     }

    2248. 

  2248.     else

    2249. 

  2249.     {

    2250. 

  2250.         

    2251. 

  2251.         if ($_REQUEST['genredistribution'] == '%')

    2252. 

  2252.         {

    2253. 

  2253.             

    2254. 

  2254.             $SQLquery = 'SELECT COUNT(*) AS `num`, `genre`';

    2255. 

  2255.             $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2256. 

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

    2257. 

  2257.             $SQLquery .= ' GROUP BY `genre`';

    2258. 

  2258.             $SQLquery .= ' ORDER BY `num` DESC';

    2259. 

  2259.             $result = safe_mysql_query($SQLquery);

    2260. 

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

    2261. 

  2261.             echo '<table border="1" cellspacing="0" cellpadding="4">';

    2262. 

  2262.             echo '<tr><th>Count</th><th>Genre</th><th>m3u</th></tr>';

    2263. 

  2263.             while ($row = mysql_fetch_array($result))

    2264. 

  2264.             {

    2265. 

  2265.                 $GenreID = getid3_id3v1 :: LookupGenreID($row['genre']);

    2266. 

  2266.                 if (is_numeric($GenreID))

    2267. 

  2267.                 {

    2268. 

  2268.                     echo '<tr bgcolor="#00FF00;">';

    2269. 

  2269.                 }

    2270. 

  2270.                 else

    2271. 

  2271.                 {

    2272. 

  2272.                     echo '<tr bgcolor="#FF9999;">';

    2273. 

  2273.                 }

    2274. 

  2274.                 echo '<td><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?genredistribution=' . urlencode($row['genre'])) . '">' . number_format($row['num']) . '</a></td>';

    2275. 

  2275.                 echo '<td nowrap>' . str_replace("\t", '<br>', $row['genre']) . '</td>';

    2276. 

  2276.                 echo '<td><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?m3u=.m3u&genredistribution=' . urlencode($row['genre'])) . '">.m3u</a></td>';

    2277. 

  2277.                 echo '</tr>';

    2278. 

  2278.             }

    2279. 

  2279.             echo '</table><hr>';

    2280. 

  2280.         

    2281. 

  2281.         }

    2282. 

  2282.         else

    2283. 

  2283.         {

    2284. 

  2284.             

    2285. 

  2285.             $SQLquery = 'SELECT `filename`, `genre`';

    2286. 

  2286.             $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2287. 

  2287.             $SQLquery .= ' WHERE (`genre` LIKE "' . mysql_escape_string($_REQUEST['genredistribution']) . '")';

    2288. 

  2288.             $SQLquery .= ' ORDER BY `filename` ASC';

    2289. 

  2289.             $result = safe_mysql_query($SQLquery);

    2290. 

  2290.             echo '<a href="' . htmlentities($_SERVER['PHP_SELF'] . '?genredistribution=' . urlencode('%')) . '">All Genres</a><br>';

    2291. 

  2291.             echo '<table border="1" cellspacing="0" cellpadding="4">';

    2292. 

  2292.             echo '<tr><th>Genre</th><th>m3u</th><th>Filename</th></tr>';

    2293. 

  2293.             while ($row = mysql_fetch_array($result))

    2294. 

  2294.             {

    2295. 

  2295.                 echo '<tr>';

    2296. 

  2296.                 echo '<TD NOWRAP>' . str_replace("\t", '<br>', $row['genre']) . '</td>';

    2297. 

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

    2298. 

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

    2299. 

  2299.                 echo '</tr>';

    2300. 

  2300.             }

    2301. 

  2301.             echo '</table><hr>';

    2302. 

  2302.         

    2303. 

  2303.         }

    2304. 

  2304.     

    2305. 

  2305.     }

    2306. 

  2306. 

    2307. 

  2307. }

    2308. 

  2308. elseif (! empty($_REQUEST['formatdistribution']))

    2309. 

  2309. {

    2310. 

  2310.     

    2311. 

  2311.     $SQLquery = 'SELECT `fileformat`, `audio_dataformat`, COUNT(*) AS `num`';

    2312. 

  2312.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2313. 

  2313.     $SQLquery .= ' GROUP BY `fileformat`, `audio_dataformat`';

    2314. 

  2314.     $SQLquery .= ' ORDER BY `num` DESC';

    2315. 

  2315.     $result = safe_mysql_query($SQLquery);

    2316. 

  2316.     echo 'File format distribution:<table border="1" cellspacing="0" cellpadding="4">';

    2317. 

  2317.     echo '<tr><th>Number</th><th>Format</th></tr>';

    2318. 

  2318.     while ($row = mysql_fetch_array($result))

    2319. 

  2319.     {

    2320. 

  2320.         echo '<tr>';

    2321. 

  2321.         echo '<TD ALIGN="RIGHT">' . number_format($row['num']) . '</td>';

    2322. 

  2322.         echo '<td><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?filetypelist=' . $row['fileformat'] . '|' . $row['audio_dataformat']) . '">' . ($row['fileformat'] ? $row['fileformat'] : '<i>unknown</i>') . (($row['audio_dataformat'] && ($row['audio_dataformat'] != $row['fileformat'])) ? '.' . $row['audio_dataformat'] : '') . '</a></td>';

    2323. 

  2323.         echo '</tr>';

    2324. 

  2324.     }

    2325. 

  2325.     echo '</table><hr>';

    2326. 

  2326. 

    2327. 

  2327. }

    2328. 

  2328. elseif (! empty($_REQUEST['errorswarnings']))

    2329. 

  2329. {

    2330. 

  2330.     

    2331. 

  2331.     $SQLquery = 'SELECT `filename`, `error`, `warning`';

    2332. 

  2332.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2333. 

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

    2334. 

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

    2335. 

  2335.     $SQLquery .= ' ORDER BY `filename` ASC';

    2336. 

  2336.     $result = safe_mysql_query($SQLquery);

    2337. 

  2337.     

    2338. 

  2338.     if (! empty($_REQUEST['m3u']))

    2339. 

  2339.     {

    2340. 

  2340.         

    2341. 

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

    2342. 

  2342.         echo '#EXTM3U' . "\n";

    2343. 

  2343.         while ($row = mysql_fetch_array($result))

    2344. 

  2344.         {

    2345. 

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

    2346. 

  2346.         }

    2347. 

  2347.         exit();

    2348. 

  2348.     

    2349. 

  2349.     }

    2350. 

  2350.     else

    2351. 

  2351.     {

    2352. 

  2352.         

    2353. 

  2353.         echo number_format(mysql_num_rows($result)) . ' files with errors or warnings:<br>';

    2354. 

  2354.         echo '(<a href="' . htmlentities($_SERVER['PHP_SELF'] . '?errorswarnings=1&m3u=.m3u') . '">.m3u version</a>)<br>';

    2355. 

  2355.         echo '<table border="1" cellspacing="0" cellpadding="4">';

    2356. 

  2356.         echo '<tr><th>Filename</th><th>Error</th><th>Warning</th></tr>';

    2357. 

  2357.         while ($row = mysql_fetch_array($result))

    2358. 

  2358.         {

    2359. 

  2359.             echo '<tr>';

    2360. 

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

    2361. 

  2361.             echo '<td>' . (! empty($row['error']) ? '<li>' . str_replace("\t", '<li>', FixTextFields($row['error'])) . '</li>' : '&nbsp;') . '</td>';

    2362. 

  2362.             echo '<td>' . (! empty($row['warning']) ? '<li>' . str_replace("\t", '<li>', FixTextFields($row['warning'])) . '</li>' : '&nbsp;') . '</td>';

    2363. 

  2363.             echo '</tr>';

    2364. 

  2364.         }

    2365. 

  2365.     }

    2366. 

  2366.     echo '</table><hr>';

    2367. 

  2367. 

    2368. 

  2368. }

    2369. 

  2369. elseif (! empty($_REQUEST['fixid3v1padding']))

    2370. 

  2370. {

    2371. 

  2371.     

    2372. 

  2372.     getid3_lib :: IncludeDependency(GETID3_INCLUDEPATH . 'write.id3v1.php', __FILE__, true);

    2373. 

  2373.     $id3v1_writer = new getid3_write_id3v1();

    2374. 

  2374.     

    2375. 

  2375.     $SQLquery = 'SELECT `filename`, `error`, `warning`';

    2376. 

  2376.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2377. 

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

    2378. 

  2378.     $SQLquery .= ' AND (`warning` <> "")';

    2379. 

  2379.     $SQLquery .= ' ORDER BY `filename` ASC';

    2380. 

  2380.     $result = safe_mysql_query($SQLquery);

    2381. 

  2381.     $totaltofix = mysql_num_rows($result);

    2382. 

  2382.     $rowcounter = 0;

    2383. 

  2383.     while ($row = mysql_fetch_array($result))

    2384. 

  2384.     {

    2385. 

  2385.         set_time_limit(30);

    2386. 

  2386.         if (strpos($row['warning'], 'Some ID3v1 fields do not use NULL characters for padding') !== false)

    2387. 

  2387.         {

    2388. 

  2388.             set_time_limit(30);

    2389. 

  2389.             $id3v1_writer->filename = $row['filename'];

    2390. 

  2390.             echo ($id3v1_writer->FixID3v1Padding() ? '<span style="color: #009900;">fixed - ' : '<span style="color: #FF0000;">error - ');

    2391. 

  2391.         }

    2392. 

  2392.         else

    2393. 

  2393.         {

    2394. 

  2394.             echo '<span style="color: #0000FF;">No error? - ';

    2395. 

  2395.         }

    2396. 

  2396.         echo '[' . ++ $rowcounter . ' / ' . $totaltofix . '] ';

    2397. 

  2397.         echo FixTextFields($row['filename']) . '</span><br>';

    2398. 

  2398.         flush();

    2399. 

  2399.     }

    2400. 

  2400. 

    2401. 

  2401. }

    2402. 

  2402. elseif (! empty($_REQUEST['vbrmethod']))

    2403. 

  2403. {

    2404. 

  2404.     

    2405. 

  2405.     if ($_REQUEST['vbrmethod'] == '1')

    2406. 

  2406.     {

    2407. 

  2407.         

    2408. 

  2408.         $SQLquery = 'SELECT COUNT(*) AS `num`, `vbr_method`';

    2409. 

  2409.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2410. 

  2410.         $SQLquery .= ' GROUP BY `vbr_method`';

    2411. 

  2411.         $SQLquery .= ' ORDER BY `vbr_method`';

    2412. 

  2412.         $result = safe_mysql_query($SQLquery);

    2413. 

  2413.         echo 'VBR methods:<table border="1" cellspacing="0" cellpadding="4">';

    2414. 

  2414.         echo '<tr><th>Count</th><th>VBR Method</th></tr>';

    2415. 

  2415.         while ($row = mysql_fetch_array($result))

    2416. 

  2416.         {

    2417. 

  2417.             echo '<tr>';

    2418. 

  2418.             echo '<TD ALIGN="RIGHT">' . FixTextFields(number_format($row['num'])) . '</td>';

    2419. 

  2419.             if ($row['vbr_method'])

    2420. 

  2420.             {

    2421. 

  2421.                 echo '<td><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?vbrmethod=' . $row['vbr_method']) . '">' . FixTextFields($row['vbr_method']) . '</a></td>';

    2422. 

  2422.             }

    2423. 

  2423.             else

    2424. 

  2424.             {

    2425. 

  2425.                 echo '<td><i>CBR</i></td>';

    2426. 

  2426.             }

    2427. 

  2427.             echo '</tr>';

    2428. 

  2428.         }

    2429. 

  2429.         echo '</table>';

    2430. 

  2430.     

    2431. 

  2431.     }

    2432. 

  2432.     else

    2433. 

  2433.     {

    2434. 

  2434.         

    2435. 

  2435.         $SQLquery = 'SELECT `filename`';

    2436. 

  2436.         $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2437. 

  2437.         $SQLquery .= ' WHERE (`vbr_method` = "' . mysql_escape_string($_REQUEST['vbrmethod']) . '")';

    2438. 

  2438.         $result = safe_mysql_query($SQLquery);

    2439. 

  2439.         echo number_format(mysql_num_rows($result)) . ' files with VBR_method of "' . $_REQUEST['vbrmethod'] . '":<table border="1" cellspacing="0" cellpadding="3">';

    2440. 

  2440.         while ($row = mysql_fetch_array($result))

    2441. 

  2441.         {

    2442. 

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

    2443. 

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

    2444. 

  2444.         }

    2445. 

  2445.         echo '</table>';

    2446. 

  2446.     

    2447. 

  2447.     }

    2448. 

  2448.     echo '<hr>';

    2449. 

  2449. 

    2450. 

  2450. }

    2451. 

  2451. elseif (! empty($_REQUEST['correctcase']))

    2452. 

  2452. {

    2453. 

  2453.     

    2454. 

  2454.     $SQLquery = 'SELECT `filename`, `fileformat`';

    2455. 

  2455.     $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2456. 

  2456.     $SQLquery .= ' WHERE (`fileformat` <> "")';

    2457. 

  2457.     $SQLquery .= ' ORDER BY `filename` ASC';

    2458. 

  2458.     $result = safe_mysql_query($SQLquery);

    2459. 

  2459.     echo 'Copy and paste the following into a DOS batch file. You may have to run this script more than once to catch all the changes (remember to scan for deleted/changed files and rescan directory between scans)<hr>';

    2460. 

  2460.     echo '<PRE>';

    2461. 

  2461.     $lastdir = '';

    2462. 

  2462.     while ($row = mysql_fetch_array($result))

    2463. 

  2463.     {

    2464. 

  2464.         set_time_limit(30);

    2465. 

  2465.         $CleanedFilename = CleanUpFileName($row['filename']);

    2466. 

  2466.         if ($row['filename'] != $CleanedFilename)

    2467. 

  2467.         {

    2468. 

  2468.             if (strtolower($lastdir) != strtolower(str_replace('/', '\\', dirname($row['filename']))))

    2469. 

  2469.             {

    2470. 

  2470.                 $lastdir = str_replace('/', '\\', dirname($row['filename']));

    2471. 

  2471.                 echo 'cd "' . $lastdir . '"' . "\n";

    2472. 

  2472.             }

    2473. 

  2473.             echo 'ren "' . basename($row['filename']) . '" "' . basename(CleanUpFileName($row['filename'])) . '"' . "\n";

    2474. 

  2474.         }

    2475. 

  2475.     }

    2476. 

  2476.     echo '</PRE>';

    2477. 

  2477.     echo '<hr>';

    2478. 

  2478. 

    2479. 

  2479. }

    2480. 

  2480. 

    2481. 

  2481. function CleanUpFileName($filename)

    2482. 

  2482. {

    2483. 

  2483.     $DirectoryName = dirname($filename);

    2484. 

  2484.     $FileExtension = fileextension(basename($filename));

    2485. 

  2485.     $BaseFilename = basename($filename, '.' . $FileExtension);

    2486. 

  2486.     

    2487. 

  2487.     $BaseFilename = strtolower($BaseFilename);

    2488. 

  2488.     $BaseFilename = str_replace('_', ' ', $BaseFilename);

    2489. 

  2489.     //$BaseFilename = str_replace('-', ' - ', $BaseFilename);
    2490. 

  2490.     $BaseFilename = str_replace('(', ' (', $BaseFilename);

    2491. 

  2491.     $BaseFilename = str_replace('( ', '(', $BaseFilename);

    2492. 

  2492.     $BaseFilename = str_replace(')', ') ', $BaseFilename);

    2493. 

  2493.     $BaseFilename = str_replace(' )', ')', $BaseFilename);

    2494. 

  2494.     $BaseFilename = str_replace(' \'\'', ' �', $BaseFilename);

    2495. 

  2495.     $BaseFilename = str_replace('\'\' ', '� ', $BaseFilename);

    2496. 

  2496.     $BaseFilename = str_replace(' vs ', ' vs. ', $BaseFilename);

    2497. 

  2497.     while (strstr($BaseFilename, '  ') !== false)

    2498. 

  2498.     {

    2499. 

  2499.         $BaseFilename = str_replace('  ', ' ', $BaseFilename);

    2500. 

  2500.     }

    2501. 

  2501.     $BaseFilename = trim($BaseFilename);

    2502. 

  2502.     

    2503. 

  2503.     return $DirectoryName . '/' . BetterUCwords($BaseFilename) . '.' . strtolower($FileExtension);

    2504. 

  2504. }

    2505. 

  2505. 

    2506. 

  2506. function BetterUCwords($string)

    2507. 

  2507. {

    2508. 

  2508.     $stringlength = strlen($string);

    2509. 

  2509.     

    2510. 

  2510.     $string{0} = strtoupper($string{0});

    2511. 

  2511.     for($i = 1; $i < $stringlength; $i ++)

    2512. 

  2512.     {

    2513. 

  2513.         if (($string{$i - 1} == '\'') && ($i > 1) && (($string{$i - 2} == 'O') || ($string{$i - 2} == ' ')))

    2514. 

  2514.         {

    2515. 

  2515.             // O'Clock, 'Em
    2516. 

  2516.             $string{$i} = strtoupper($string{$i});

    2517. 

  2517.         }

    2518. 

  2518.         elseif (ereg('^[\'A-Za-z0-9�-�]$', $string{$i - 1}))

    2519. 

  2519.         {

    2520. 

  2520.             $string{$i} = strtolower($string{$i});

    2521. 

  2521.         }

    2522. 

  2522.         else

    2523. 

  2523.         {

    2524. 

  2524.             $string{$i} = strtoupper($string{$i});

    2525. 

  2525.         }

    2526. 

  2526.     }

    2527. 

  2527.     

    2528. 

  2528.     static $LowerCaseWords = array('vs.', 'feat.');

    2529. 

  2529.     static $UpperCaseWords = array('DJ', 'USA', 'II', 'MC', 'CD', 'TV', '\'N\'');

    2530. 

  2530.     

    2531. 

  2531.     $OutputListOfWords = array();

    2532. 

  2532.     $ListOfWords = explode(' ', $string);

    2533. 

  2533.     foreach ($ListOfWords as $ThisWord)

    2534. 

  2534.     {

    2535. 

  2535.         if (in_array(strtolower(str_replace('(', '', $ThisWord)), $LowerCaseWords))

    2536. 

  2536.         {

    2537. 

  2537.             $ThisWord = strtolower($ThisWord);

    2538. 

  2538.         }

    2539. 

  2539.         elseif (in_array(strtoupper(str_replace('(', '', $ThisWord)), $UpperCaseWords))

    2540. 

  2540.         {

    2541. 

  2541.             $ThisWord = strtoupper($ThisWord);

    2542. 

  2542.         }

    2543. 

  2543.         elseif ((substr($ThisWord, 0, 2) == 'Mc') && (strlen($ThisWord) > 2))

    2544. 

  2544.         {

    2545. 

  2545.             $ThisWord{2} = strtoupper($ThisWord{2});

    2546. 

  2546.         }

    2547. 

  2547.         elseif ((substr($ThisWord, 0, 3) == 'Mac') && (strlen($ThisWord) > 3))

    2548. 

  2548.         {

    2549. 

  2549.             $ThisWord{3} = strtoupper($ThisWord{3});

    2550. 

  2550.         }

    2551. 

  2551.         $OutputListOfWords[] = $ThisWord;

    2552. 

  2552.     }

    2553. 

  2553.     $UCstring = implode(' ', $OutputListOfWords);

    2554. 

  2554.     $UCstring = str_replace(' From �', ' from �', $UCstring);

    2555. 

  2555.     $UCstring = str_replace(' \'n\' ', ' \'N\' ', $UCstring);

    2556. 

  2556.     

    2557. 

  2557.     return $UCstring;

    2558. 

  2558. }

    2559. 

  2559. 

    2560. 

  2560. echo '<hr><form action="' . FixTextFields($_SERVER['PHP_SELF']) . '">';

    2561. 

  2561. echo '<b>Warning:</b> Scanning a new directory will erase all previous entries in the database!<br>';

    2562. 

  2562. echo 'Directory: <input type="text" name="scan" size="50" value="' . FixTextFields(! empty($_REQUEST['scan']) ? $_REQUEST['scan'] : '') . '"> ';

    2563. 

  2563. echo '<input type="submit" value="Go" onClick="return confirm(\'Are you sure you want to erase all entries in the database and start scanning again?\');">';

    2564. 

  2564. echo '</form>';

    2565. 

  2565. echo '<hr><form action="' . FixTextFields($_SERVER['PHP_SELF']) . '">';

    2566. 

  2566. echo 'Re-scanning a new directory will only add new, previously unscanned files into the list (and not erase the database).<br>';

    2567. 

  2567. echo 'Directory: <input type="text" name="newscan" size="50" value="' . FixTextFields(! empty($_REQUEST['newscan']) ? $_REQUEST['newscan'] : '') . '"> ';

    2568. 

  2568. echo '<input type="SUBMIT" value="Go">';

    2569. 

  2569. echo '</form><hr>';

    2570. 

  2570. echo '<ul>';

    2571. 

  2571. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?deadfilescheck=1') . '">Remove deleted or changed files from database</a></li>';

    2572. 

  2572. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?md5datadupes=1') . '">List files with identical MD5_DATA values</a></li>';

    2573. 

  2573. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?artisttitledupes=1') . '">List files with identical artist + title</a> (<a href="' . $_SERVER['PHP_SELF'] . '?artisttitledupes=1&samemix=1">same mix only</a>)</li>';

    2574. 

  2574. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?fileextensions=1') . '">File with incorrect file extension</a></li>';

    2575. 

  2575. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?formatdistribution=1') . '">File Format Distribution</a></li>';

    2576. 

  2576. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?audiobitrates=1') . '">Audio Bitrate Distribution</a></li>';

    2577. 

  2577. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?vbrmethod=1') . '">VBR_Method Distribution</a></li>';

    2578. 

  2578. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?tagtypes=1') . '">Tag Type Distribution</a></li>';

    2579. 

  2579. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?genredistribution=' . urlencode('%')) . '">Genre Distribution</a></li>';

    2580. 

  2580. //echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?missingtrackvolume=1').'">Scan for missing track volume information (update database from pre-v1.7.0b5)</a></li>';
    2581. 

  2581. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?encoderoptionsdistribution=1') . '">Encoder Options Distribution</a></li>';

    2582. 

  2582. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?encodedbydistribution=' . urlencode('%')) . '">Encoded By (ID3v2) Distribution</a></li>';

    2583. 

  2583. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?trackinalbum=1') . '">Track number in Album field</a></li>';

    2584. 

  2584. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?tracknoalbum=1') . '">Track number, but no Album</a></li>';

    2585. 

  2585. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?titlefeat=1') . '">"feat." in Title field</a></li>';

    2586. 

  2586. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?emptygenres=1') . '">Blank genres</a></li>';

    2587. 

  2587. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?trackzero=1') . '">Track "zero"</a></li>';

    2588. 

  2588. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?nonemptycomments=1') . '">non-empty comments</a></li>';

    2589. 

  2589. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?unsynchronizedtags=2A1') . '">Tags that are not synchronized</a> (<a href="' . $_SERVER['PHP_SELF'] . '?unsynchronizedtags=2A1&autofix=1">autofix</a>)</li>';

    2590. 

  2590. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?filenamepattern=' . urlencode('[N] A - T {R}')) . '">Filenames that don\'t match pattern</a> (<a href="?filenamepattern=' . urlencode('[N] A - T {R}') . '&autofix=1">auto-fix</a>)</li>';

    2591. 

  2591. //echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?filenamepattern='.urlencode('A - T')).'">Filenames that don\'t match pattern</a></li>';
    2592. 

  2592. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?correctcase=1') . '">Correct filename case (Win/DOS)</a></li>';

    2593. 

  2593. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?fixid3v1padding=1') . '">Fix ID3v1 invalid padding</a></li>';

    2594. 

  2594. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?errorswarnings=1') . '">Files with Errors and/or Warnings</a></li>';

    2595. 

  2595. echo '<li><a href="' . htmlentities($_SERVER['PHP_SELF'] . '?rescanerrors=1') . '">Re-scan only files with Errors and/or Warnings</a></li>';

    2596. 

  2596. echo '</ul>';

    2597. 

  2597. 

    2598. 

  2598. $SQLquery = 'SELECT COUNT(*) AS `TotalFiles`, SUM(`playtime_seconds`) AS `TotalPlaytime`, SUM(`filesize`) AS `TotalFilesize`, AVG(`playtime_seconds`) AS `AvgPlaytime`, AVG(`filesize`) AS `AvgFilesize`, AVG(`audio_bitrate` + `video_bitrate`) AS `AvgBitrate`';

    2599. 

  2599. $SQLquery .= ' FROM `' . GETID3_DB_TABLE . '`';

    2600. 

  2600. $result = mysql_query($SQLquery);

    2601. 

  2601. if ($row = mysql_fetch_array($result))

    2602. 

  2602. {

    2603. 

  2603.     echo '<hr><b>Currently in the database:</b><TABLE>';

    2604. 

  2604.     echo '<tr><TH ALIGN="LEFT">Total Files</th><td>' . number_format($row['TotalFiles']) . '</td></tr>';

    2605. 

  2605.     echo '<tr><TH ALIGN="LEFT">Total Filesize</th><td>' . number_format($row['TotalFilesize'] / 1048576) . ' MB</td></tr>';

    2606. 

  2606.     echo '<tr><TH ALIGN="LEFT">Total Playtime</th><td>' . number_format($row['TotalPlaytime'] / 3600, 1) . ' hours</td></tr>';

    2607. 

  2607.     echo '<tr><TH ALIGN="LEFT">Average Filesize</th><td>' . number_format($row['AvgFilesize'] / 1048576, 1) . ' MB</td></tr>';

    2608. 

  2608.     echo '<tr><TH ALIGN="LEFT">Average Playtime</th><td>' . getid3_lib :: PlaytimeString($row['AvgPlaytime']) . '</td></tr>';

    2609. 

  2609.     echo '<tr><TH ALIGN="LEFT">Average Bitrate</th><td>' . BitrateText($row['AvgBitrate'] / 1000, 1) . '</td></tr>';

    2610. 

  2610.     echo '</table>';

    2611. 

  2611. }

    2612. 

  2612. 

    2613. 

  2613. ?>
    2614. 

  2614. </BODY>
    2615. 

  2615. </HTML>
    2616.