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

/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

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

    

  1. <?php

    2. 

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

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

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

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

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

  7. //                                                             //
    8. 

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

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

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

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

  12. //                                                            ///
    13. 

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

  14. 

    15. 

  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 …
    1125.

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