diff options
author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2005-06-11 17:08:15 +0000 |
---|---|---|
committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2005-06-11 17:08:15 +0000 |
commit | 68235f4dbea45ae7f5b916b854e17411d64089f8 (patch) | |
tree | 224490f04180bf149477c3f8c822ab33a4f49f5a /modules/id3/demos | |
parent | c21ed04b59d16faa6ac040543fcfa1c6c084b88c (diff) | |
download | ampache-68235f4dbea45ae7f5b916b854e17411d64089f8.tar.gz ampache-68235f4dbea45ae7f5b916b854e17411d64089f8.tar.bz2 ampache-68235f4dbea45ae7f5b916b854e17411d64089f8.zip |
remove demo getid3() files
Diffstat (limited to 'modules/id3/demos')
-rw-r--r-- | modules/id3/demos/demo.audioinfo.class.php | 319 | ||||
-rw-r--r-- | modules/id3/demos/demo.browse.php | 626 | ||||
-rw-r--r-- | modules/id3/demos/demo.cache.dbm.php | 29 | ||||
-rw-r--r-- | modules/id3/demos/demo.cache.mysql.php | 29 | ||||
-rw-r--r-- | modules/id3/demos/demo.joinmp3.php | 96 | ||||
-rw-r--r-- | modules/id3/demos/demo.mimeonly.php | 53 | ||||
-rw-r--r-- | modules/id3/demos/demo.mysql.php | 1825 | ||||
-rw-r--r-- | modules/id3/demos/demo.simple.php | 53 | ||||
-rw-r--r-- | modules/id3/demos/demo.write.php | 254 | ||||
-rw-r--r-- | modules/id3/demos/index.php | 1 |
10 files changed, 0 insertions, 3285 deletions
diff --git a/modules/id3/demos/demo.audioinfo.class.php b/modules/id3/demos/demo.audioinfo.class.php deleted file mode 100644 index d38ec198..00000000 --- a/modules/id3/demos/demo.audioinfo.class.php +++ /dev/null @@ -1,319 +0,0 @@ -<?php - -// +----------------------------------------------------------------------+ -// | PHP version 4.1.0 | -// +----------------------------------------------------------------------+ -// | Placed in public domain by Allan Hansen, 2002. Share and enjoy! | -// +----------------------------------------------------------------------+ -// | /demo/demo.audioinfo.class.php | -// | | -// | Example wrapper class to extract information from audio files | -// | through getID3(). | -// | | -// | getID3() returns a lot of information. Much of this information is | -// | not needed for the end-application. It is also possible that some | -// | users want to extract specific info. Modifying getID3() files is a | -// | bad idea, as modifications needs to be done to future versions of | -// | getID3(). | -// | | -// | Modify this wrapper class instead. This example extracts certain | -// | fields only and adds a new root value - encoder_options if possible. | -// | It also checks for mp3 files with wave headers. | -// +----------------------------------------------------------------------+ -// | Example code: | -// | $au = new AudioInfo(); | -// | print_r($au->Info('file.flac'); | -// +----------------------------------------------------------------------+ -// | Authors: Allan Hansen <ahØartemis*dk> | -// +----------------------------------------------------------------------+ -// - - - -/** -* getID3() settings -*/ - -require_once('../getid3/getid3.php'); - - - - -/** -* Class for extracting information from audio files with getID3(). -*/ - -class AudioInfo { - - /** - * Private variables - */ - var $result = NULL; - var $info = NULL; - - - - - /** - * Constructor - */ - - function AudioInfo() { - - // Initialize getID3 engine - $this->getID3 = new getID3; - $this->getID3->option_md5_data = true; - $this->getID3->option_md5_data_source = true; - $this->getID3->encoding = 'UTF-8'; - } - - - - - /** - * Extract information - only public function - * - * @access public - * @param string file Audio file to extract info from. - */ - - function Info($file) { - - // Analyze file - $this->info = $this->getID3->analyze($file); - - // Exit here on error - if (isset($this->info['error'])) { - return array ('error' => $this->info['error']); - } - - // Init wrapper object - $this->result = array (); - $this->result['format_name'] = @$this->info['fileformat'].'/'.@$this->info['audio']['dataformat'].(isset($this->info['video']['dataformat']) ? '/'.@$this->info['video']['dataformat'] : ''); - $this->result['encoder_version'] = @$this->info['audio']['encoder']; - $this->result['encoder_options'] = @$this->info['audio']['encoder_options']; - $this->result['bitrate_mode'] = @$this->info['audio']['bitrate_mode']; - $this->result['channels'] = @$this->info['audio']['channels']; - $this->result['sample_rate'] = @$this->info['audio']['sample_rate']; - $this->result['bits_per_sample'] = @$this->info['audio']['bits_per_sample']; - $this->result['playing_time'] = @$this->info['playtime_seconds']; - $this->result['avg_bit_rate'] = @$this->info['audio']['bitrate']; - $this->result['tags'] = @$this->info['tags']; - $this->result['comments'] = @$this->info['comments']; - $this->result['warning'] = @$this->info['warning']; - $this->result['md5'] = @$this->info['md5_data']; - - // Post getID3() data handling based on file format - $method = @$this->info['fileformat'].'Info'; - if (@$this->info['fileformat'] && method_exists($this, $method)) { - $this->$method(); - } - - return $this->result; - } - - - - - /** - * post-getID3() data handling for AAC files. - * - * @access private - */ - - function aacInfo() { - $this->result['format_name'] = 'AAC'; - } - - - - - /** - * post-getID3() data handling for Wave files. - * - * @access private - */ - - function riffInfo() { - if ($this->info['audio']['dataformat'] == 'wav') { - - $this->result['format_name'] = 'Wave'; - - } else if (ereg('^mp[1-3]$', $this->info['audio']['dataformat'])) { - - $this->result['format_name'] = strtoupper($this->info['audio']['dataformat']); - - } else { - - $this->result['format_name'] = 'riff/'.$this->info['audio']['dataformat']; - - } - } - - - - - /** - * * post-getID3() data handling for FLAC files. - * - * @access private - */ - - function flacInfo() { - $this->result['format_name'] = 'FLAC'; - } - - - - - - /** - * post-getID3() data handling for Monkey's Audio files. - * - * @access private - */ - - function macInfo() { - $this->result['format_name'] = 'Monkey\'s Audio'; - } - - - - - - /** - * post-getID3() data handling for Lossless Audio files. - * - * @access private - */ - - function laInfo() { - $this->result['format_name'] = 'La'; - } - - - - - - /** - * post-getID3() data handling for Ogg Vorbis files. - * - * @access private - */ - - function oggInfo() { - if ($this->info['audio']['dataformat'] == 'vorbis') { - - $this->result['format_name'] = 'Ogg Vorbis'; - - } else if ($this->info['audio']['dataformat'] == 'flac') { - - $this->result['format_name'] = 'Ogg FLAC'; - - } else if ($this->info['audio']['dataformat'] == 'speex') { - - $this->result['format_name'] = 'Ogg Speex'; - - } else { - - $this->result['format_name'] = 'Ogg '.$this->info['audio']['dataformat']; - - } - } - - - - - /** - * post-getID3() data handling for Musepack files. - * - * @access private - */ - - function mpcInfo() { - $this->result['format_name'] = 'Musepack'; - } - - - - - /** - * post-getID3() data handling for MPEG files. - * - * @access private - */ - - function mp3Info() { - $this->result['format_name'] = 'MP3'; - } - - - - - /** - * post-getID3() data handling for MPEG files. - * - * @access private - */ - - function mp2Info() { - $this->result['format_name'] = 'MP2'; - } - - - - - - /** - * post-getID3() data handling for MPEG files. - * - * @access private - */ - - function mp1Info() { - $this->result['format_name'] = 'MP1'; - } - - - - - /** - * post-getID3() data handling for WMA files. - * - * @access private - */ - - function asfInfo() { - $this->result['format_name'] = strtoupper($this->info['audio']['dataformat']); - } - - - - /** - * post-getID3() data handling for Real files. - * - * @access private - */ - - function realInfo() { - $this->result['format_name'] = 'Real'; - } - - - - - - /** - * post-getID3() data handling for VQF files. - * - * @access private - */ - - function vqfInfo() { - $this->result['format_name'] = 'VQF'; - } - -} - - -?>
\ No newline at end of file diff --git a/modules/id3/demos/demo.browse.php b/modules/id3/demos/demo.browse.php deleted file mode 100644 index b0cdc85f..00000000 --- a/modules/id3/demos/demo.browse.php +++ /dev/null @@ -1,626 +0,0 @@ -<HTML> -<HEAD> -<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"/> -<TITLE>getID3() - Sample file browser</TITLE> -</HEAD> -<BODY> -<?php -///////////////////////////////////////////////////////////////// -/// getID3() by James Heinrich <info@getid3.org> // -// available at http://getid3.sourceforge.net // -// or http://www.getid3.org // -///////////////////////////////////////////////////////////////// -// // -// /demo/demo.browse.php - part of getID3() // -// Sample script for browsing/scanning files and displaying // -// information returned by getID3() // -// See readme.txt for more details // -// /// -///////////////////////////////////////////////////////////////// - - -require_once('../getid3/getid3.php'); - -// Initialize getID3 engine -$getID3 = new getID3; - - -$getID3checkColor_Head = 'CCCCDD'; -$getID3checkColor_DirectoryLight = 'EEBBBB'; -$getID3checkColor_DirectoryDark = 'FFCCCC'; -$getID3checkColor_FileLight = 'EEEEEE'; -$getID3checkColor_FileDark = 'DDDDDD'; -$getID3checkColor_UnknownLight = 'CCCCFF'; -$getID3checkColor_UnknownDark = 'BBBBDD'; - - - -if (!function_exists('getmicrotime')) { - function getmicrotime() { - list($usec, $sec) = explode(' ', microtime()); - return ((float) $usec + (float) $sec); - } -} - - - -ob_start(); -echo '<HTML><HEAD>'; -echo '<TITLE>getID3() - /demo/demo.browse.php (sample script)</TITLE>'; -echo '<STYLE>BODY,TD,TH { font-family: sans-serif; font-size: 9pt; }</STYLE>'; -echo '</HEAD><BODY>'; - -if (isset($_REQUEST['deletefile'])) { - if (file_exists($_REQUEST['deletefile'])) { - if (unlink($_REQUEST['deletefile'])) { - $deletefilemessage = 'Successfully deleted '.addslashes($_REQUEST['deletefile']); - } else { - $deletefilemessage = 'FAILED to delete '.addslashes($_REQUEST['deletefile']).' - error deleting file'; - } - } else { - $deletefilemessage = 'FAILED to delete '.addslashes($_REQUEST['deletefile']).' - file does not exist'; - } - if (isset($_REQUEST['noalert'])) { - echo '<B><FONT COLOR="'.(($deletefilemessage{0} == 'F') ? '#FF0000' : '#008000').'">'.$deletefilemessage.'</FONT></B><HR>'; - } else { - echo '<SCRIPT LANGUAGE="JavaScript">alert("'.$deletefilemessage.'");</SCRIPT>'; - } -} - - -if (isset($_REQUEST['filename'])) { - if (!file_exists($_REQUEST['filename'])) { - die($_REQUEST['filename'].' does not exist'); - } - $starttime = getmicrotime(); - $AutoGetHashes = (bool) (filesize($_REQUEST['filename']) < 52428800); // auto-get md5_data, md5_file, sha1_data, sha1_file if filesize < 50MB - - $getID3->option_md5_data = $AutoGetHashes; - $getID3->option_sha1_data = $AutoGetHashes; - $ThisFileInfo = $getID3->analyze($_REQUEST['filename']); - if ($AutoGetHashes) { - $ThisFileInfo['md5_file'] = getid3_lib::md5_file($_REQUEST['filename']); - $ThisFileInfo['sha1_file'] = getid3_lib::sha1_file($_REQUEST['filename']); - } - - - getid3_lib::CopyTagsToComments($ThisFileInfo); - - $listdirectory = dirname(getid3_lib::SafeStripSlashes($_REQUEST['filename'])); - $listdirectory = realpath($listdirectory); // get rid of /../../ references - - if (GETID3_OS_ISWINDOWS) { - // this mostly just gives a consistant look to Windows and *nix filesystems - // (windows uses \ as directory seperator, *nix uses /) - $listdirectory = str_replace('\\', '/', $listdirectory.'/'); - } - - if (strstr($_REQUEST['filename'], 'http://') || strstr($_REQUEST['filename'], 'ftp://')) { - echo '<I>Cannot browse remote filesystems</I><BR>'; - } else { - echo 'Browse: <A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.urlencode($listdirectory).'">'.$listdirectory.'</A><BR>'; - } - - echo table_var_dump($ThisFileInfo); - $endtime = getmicrotime(); - echo 'File parsed in '.number_format($endtime - $starttime, 3).' seconds.<BR>'; - -} else { - - $listdirectory = (isset($_REQUEST['listdirectory']) ? getid3_lib::SafeStripSlashes($_REQUEST['listdirectory']) : '.'); - $listdirectory = realpath($listdirectory); // get rid of /../../ references - $currentfulldir = $listdirectory.'/'; - - if (GETID3_OS_ISWINDOWS) { - // this mostly just gives a consistant look to Windows and *nix filesystems - // (windows uses \ as directory seperator, *nix uses /) - $currentfulldir = str_replace('\\', '/', $listdirectory.'/'); - } - - if ($handle = @opendir($listdirectory)) { - - echo str_repeat(' ', 300); // IE buffers the first 300 or so chars, making this progressive display useless - fill the buffer with spaces - echo 'Processing'; - - $starttime = getmicrotime(); - - $TotalScannedUnknownFiles = 0; - $TotalScannedKnownFiles = 0; - $TotalScannedPlaytimeFiles = 0; - $TotalScannedBitrateFiles = 0; - $TotalScannedFilesize = 0; - $TotalScannedPlaytime = 0; - $TotalScannedBitrate = 0; - $FilesWithWarnings = 0; - $FilesWithErrors = 0; - - while ($file = readdir($handle)) { - set_time_limit(30); // allocate another 30 seconds to process this file - should go much quicker than this unless intense processing (like bitrate histogram analysis) is enabled - echo ' .'; // progress indicator dot - flush(); // make sure the dot is shown, otherwise it's useless - $currentfilename = $listdirectory.'/'.$file; - - // symbolic-link-resolution enhancements by davidbullockØtech-center*com - $TargetObject = realpath($currentfilename); // Find actual file path, resolve if it's a symbolic link - $TargetObjectType = filetype($TargetObject); // Check file type without examining extension - - if($TargetObjectType == 'dir') { - switch ($file) { - case '..': - $ParentDir = realpath($file.'/..').'/'; - if (GETID3_OS_ISWINDOWS) { - $ParentDir = str_replace('\\', '/', $ParentDir); - } - $DirectoryContents[$currentfulldir]['dir'][$file]['filename'] = $ParentDir; - break; - - case '.': - // ignore - break; - - default: - $DirectoryContents[$currentfulldir]['dir'][$file]['filename'] = $file; - break; - } - - } elseif ($TargetObjectType == 'file') { - - $getID3->option_md5_data = isset($_REQUEST['ShowMD5']); - $fileinformation = $getID3->analyze($currentfilename); - - getid3_lib::CopyTagsToComments($fileinformation); - - $TotalScannedFilesize += @$fileinformation['filesize']; - - if (isset($_REQUEST['ShowMD5'])) { - $fileinformation['md5_file'] = md5($currentfilename); - } - - if (!empty($fileinformation['fileformat'])) { - $DirectoryContents[$currentfulldir]['known'][$file] = $fileinformation; - $TotalScannedPlaytime += @$fileinformation['playtime_seconds']; - $TotalScannedBitrate += @$fileinformation['bitrate']; - $TotalScannedKnownFiles++; - } else { - $DirectoryContents[$currentfulldir]['other'][$file] = $fileinformation; - $DirectoryContents[$currentfulldir]['other'][$file]['playtime_string'] = '-'; - $TotalScannedUnknownFiles++; - } - if (isset($fileinformation['playtime_seconds']) && ($fileinformation['playtime_seconds'] > 0)) { - $TotalScannedPlaytimeFiles++; - } - if (isset($fileinformation['bitrate']) && ($fileinformation['bitrate'] > 0)) { - $TotalScannedBitrateFiles++; - } - } - } - $endtime = getmicrotime(); - closedir($handle); - echo 'done<BR>'; - echo 'Directory scanned in '.number_format($endtime - $starttime, 2).' seconds.<BR>'; - flush(); - - $columnsintable = 14; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - - echo '<TR BGCOLOR="#'.$getID3checkColor_Head.'"><TH COLSPAN="'.$columnsintable.'">Files in '.$currentfulldir.'</TH></TR>'; - $rowcounter = 0; - foreach ($DirectoryContents as $dirname => $val) { - if (is_array($DirectoryContents[$dirname]['dir'])) { - uksort($DirectoryContents[$dirname]['dir'], 'MoreNaturalSort'); - foreach ($DirectoryContents[$dirname]['dir'] as $filename => $fileinfo) { - echo '<TR BGCOLOR="#'.(($rowcounter++ % 2) ? $getID3checkColor_DirectoryDark : $getID3checkColor_DirectoryLight).'">'; - if ($filename == '..') { - echo '<TD COLSPAN="'.$columnsintable.'">Parent directory: <A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.urlencode($dirname.$filename).'"><B>'; - if (GETID3_OS_ISWINDOWS) { - echo str_replace('\\', '/', realpath($dirname.$filename)); - } else { - echo realpath($dirname.$filename); - } - echo '/</B></A></TD>'; - } else { - echo '<TD COLSPAN="'.$columnsintable.'"><A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.urlencode($dirname.$filename).'"><B>'.FixTextFields($filename).'</B></A></TD>'; - } - echo '</TR>'; - } - } - - echo '<TR BGCOLOR="#'.$getID3checkColor_Head.'">'; - echo '<TH>Filename</TH>'; - echo '<TH>File Size</TH>'; - echo '<TH>Format</TH>'; - echo '<TH>Playtime</TH>'; - echo '<TH>Bitrate</TH>'; - echo '<TH>Artist</TH>'; - echo '<TH>Title</TH>'; - if (isset($_REQUEST['ShowMD5'])) { - echo '<TH>MD5 File (File) (<A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.rawurlencode(isset($_REQUEST['listdirectory']) ? $_REQUEST['listdirectory'] : '.').'">disable</A>)</TH>'; - echo '<TH>MD5 Data (File) (<A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.rawurlencode(isset($_REQUEST['listdirectory']) ? $_REQUEST['listdirectory'] : '.').'">disable</A>)</TH>'; - echo '<TH>MD5 Data (Source) (<A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.rawurlencode(isset($_REQUEST['listdirectory']) ? $_REQUEST['listdirectory'] : '.').'">disable</A>)</TH>'; - } else { - echo '<TH COLSPAN="3">MD5 Data (<A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.rawurlencode(isset($_REQUEST['listdirectory']) ? $_REQUEST['listdirectory'] : '.').'&ShowMD5=1">enable</A>)</TH>'; - } - echo '<TH>Tags</TH>'; - echo '<TH>Errors & Warnings</TH>'; - echo '<TH>Edit</TH>'; - echo '<TH>Delete</TH>'; - echo '</TR>'; - - if (isset($DirectoryContents[$dirname]['known']) && is_array($DirectoryContents[$dirname]['known'])) { - uksort($DirectoryContents[$dirname]['known'], 'MoreNaturalSort'); - foreach ($DirectoryContents[$dirname]['known'] as $filename => $fileinfo) { -//var_dump($fileinfo); - echo '<TR BGCOLOR="#'.(($rowcounter++ % 2) ? $getID3checkColor_FileDark : $getID3checkColor_FileLight).'">'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?filename='.urlencode($dirname.$filename).'" TITLE="View detailed analysis">'.FixTextFields(getid3_lib::SafeStripSlashes($filename)).'</A></TD>'; - echo '<TD ALIGN="RIGHT"> '.number_format($fileinfo['filesize']).'</TD>'; - echo '<TD ALIGN="RIGHT"> '.NiceDisplayFiletypeFormat($fileinfo).'</TD>'; - echo '<TD ALIGN="RIGHT"> '.(isset($fileinfo['playtime_string']) ? $fileinfo['playtime_string'] : '-').'</TD>'; - echo '<TD ALIGN="RIGHT"> '.(isset($fileinfo['bitrate']) ? BitrateText($fileinfo['bitrate'] / 1000, 0, ((@$fileinfo['audio']['bitrate_mode'] == 'vbr') ? true : false)) : '-').'</TD>'; - echo '<TD ALIGN="LEFT"> '.(isset($fileinfo['comments_html']['artist']) ? implode('<BR>', $fileinfo['comments_html']['artist']) : '').'</TD>'; - echo '<TD ALIGN="LEFT"> '.(isset($fileinfo['comments_html']['title']) ? implode('<BR>', $fileinfo['comments_html']['title']) : '').'</TD>'; - if (isset($_REQUEST['ShowMD5'])) { - echo '<TD ALIGN="LEFT"><TT>'.(isset($fileinfo['md5_file']) ? $fileinfo['md5_file'] : ' ').'</TT></TD>'; - echo '<TD ALIGN="LEFT"><TT>'.(isset($fileinfo['md5_data']) ? $fileinfo['md5_data'] : ' ').'</TT></TD>'; - echo '<TD ALIGN="LEFT"><TT>'.(isset($fileinfo['md5_data_source']) ? $fileinfo['md5_data_source'] : ' ').'</TT></TD>'; - } else { - echo '<TD ALIGN="CENTER" COLSPAN="3">-</TD>'; - } - echo '<TD ALIGN="LEFT"> '.@implode(', ', array_keys($fileinfo['tags'])).'</TD>'; - - echo '<TD ALIGN="LEFT"> '; - if (!empty($fileinfo['warning'])) { - $FilesWithWarnings++; - echo '<A HREF="javascript:alert(\''.FixTextFields(implode('\\n', $fileinfo['warning'])).'\');" TITLE="'.FixTextFields(implode("\n", $fileinfo['warning'])).'">warning</A><BR>'; - } - if (!empty($fileinfo['error'])) { - $FilesWithErrors++; - echo '<A HREF="javascript:alert(\''.FixTextFields(implode('\\n', $fileinfo['error'])).'\');" TITLE="'.FixTextFields(implode("\n", $fileinfo['error'])).'">error</A><BR>'; - } - echo '</TD>'; - - echo '<TD ALIGN="LEFT"> '; - switch (@$fileinfo['fileformat']) { - case 'mp3': - case 'mp2': - case 'mp1': - case 'flac': - case 'mpc': - echo '<A HREF="demo.write.php?Filename='.urlencode($dirname.$filename).'" TITLE="Edit tags">edit tags</A>'; - break; - case 'ogg': - switch (@$fileinfo['audio']['dataformat']) { - case 'vorbis': - echo '<A HREF="demo.write.php?Filename='.urlencode($dirname.$filename).'" TITLE="Edit tags">edit tags</A>'; - break; - } - break; - default: - break; - } - echo '</TD>'; - echo '<TD ALIGN="LEFT"> <A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.urlencode($listdirectory).'&deletefile='.urlencode($dirname.$filename).'" onClick="return confirm(\'Are you sure you want to delete '.addslashes($dirname.$filename).'? \n(this action cannot be un-done)\');" TITLE="Permanently delete '."\n".FixTextFields($filename)."\n".' from'."\n".' '.FixTextFields($dirname).'">delete</A></TD>'; - echo '</TR>'; - } - } - - if (isset($DirectoryContents[$dirname]['other']) && is_array($DirectoryContents[$dirname]['other'])) { - uksort($DirectoryContents[$dirname]['other'], 'MoreNaturalSort'); - foreach ($DirectoryContents[$dirname]['other'] as $filename => $fileinfo) { - echo '<TR BGCOLOR="#'.(($rowcounter++ % 2) ? $getID3checkColor_UnknownDark : $getID3checkColor_UnknownLight).'">'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?filename='.urlencode($dirname.$filename).'"><I>'.$filename.'</I></A></TD>'; - echo '<TD ALIGN="RIGHT"> '.(isset($fileinfo['filesize']) ? number_format($fileinfo['filesize']) : '-').'</TD>'; - echo '<TD ALIGN="RIGHT"> '.NiceDisplayFiletypeFormat($fileinfo).'</TD>'; - echo '<TD ALIGN="RIGHT"> '.(isset($fileinfo['playtime_string']) ? $fileinfo['playtime_string'] : '-').'</TD>'; - echo '<TD ALIGN="RIGHT"> '.(isset($fileinfo['bitrate']) ? BitrateText($fileinfo['bitrate'] / 1000) : '-').'</TD>'; - echo '<TD ALIGN="LEFT"> </TD>'; // Artist - echo '<TD ALIGN="LEFT"> </TD>'; // Title - echo '<TD ALIGN="LEFT" COLSPAN="3"> </TD>'; // MD5_data - echo '<TD ALIGN="LEFT"> </TD>'; // Tags - echo '<TD ALIGN="LEFT"> </TD>'; // Warning/Error - echo '<TD ALIGN="LEFT"> </TD>'; // Edit - echo '<TD ALIGN="LEFT"> <A HREF="'.$_SERVER['PHP_SELF'].'?listdirectory='.urlencode($listdirectory).'&deletefile='.urlencode($dirname.$filename).'" onClick="return confirm(\'Are you sure you want to delete '.addslashes($dirname.$filename).'? \n(this action cannot be un-done)\');" TITLE="Permanently delete '.addslashes($dirname.$filename).'">delete</A></TD>'; - echo '</TR>'; - } - } - - echo '<TR BGCOLOR="#'.$getID3checkColor_Head.'">'; - echo '<TD><B>Average:</B></TD>'; - echo '<TD ALIGN="RIGHT">'.number_format($TotalScannedFilesize / max($TotalScannedKnownFiles, 1)).'</TD>'; - echo '<TD> </TD>'; - echo '<TD ALIGN="RIGHT">'.getid3_lib::PlaytimeString($TotalScannedPlaytime / max($TotalScannedPlaytimeFiles, 1)).'</TD>'; - echo '<TD ALIGN="RIGHT">'.BitrateText(round(($TotalScannedBitrate / 1000) / max($TotalScannedBitrateFiles, 1))).'</TD>'; - echo '<TD ROWSPAN="2" COLSPAN="'.($columnsintable - 5).'"><TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2"><TR><TH ALIGN="RIGHT">Identified Files:</TH><TD ALIGN="RIGHT">'.number_format($TotalScannedKnownFiles).'</TD><TD> </TD><TH ALIGN="RIGHT">Errors:</TH><TD ALIGN="RIGHT">'.number_format($FilesWithErrors).'</TD></TR><TR><TH ALIGN="RIGHT">Unknown Files:</TH><TD ALIGN="RIGHT">'.number_format($TotalScannedUnknownFiles).'</TD><TD> </TD><TH ALIGN="RIGHT">Warnings:</TH><TD ALIGN="RIGHT">'.number_format($FilesWithWarnings).'</TD></TR></TABLE>'; - echo '</TR>'; - echo '<TR BGCOLOR="#'.$getID3checkColor_Head.'">'; - echo '<TD><B>Total:</B></TD>'; - echo '<TD ALIGN="RIGHT">'.number_format($TotalScannedFilesize).'</TD>'; - echo '<TD> </TD>'; - echo '<TD ALIGN="RIGHT">'.getid3_lib::PlaytimeString($TotalScannedPlaytime).'</TD>'; - echo '<TD> </TD>'; - echo '</TR>'; - } - echo '</TABLE>'; - } else { - echo '<B>ERROR: Could not open directory: <U>'.$currentfulldir.'</U></B><BR>'; - } -} -echo PoweredBygetID3(); -echo '</BODY></HTML>'; -ob_end_flush(); - - - - - - - - -function RemoveAccents($string) { - // return strtr($string, 'ŠŒŽšœžŸ¥µÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýÿ', 'SOZsozYYuAAAAAAACEEEEIIIIDNOOOOOOUUUUYsaaaaaaaceeeeiiiionoooooouuuuyy'); - // Revised version by markstewardØhotmail*com - return strtr(strtr($string, 'ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝàáâãäåçèéêëìíîïñòóôõöøùúûüýÿ', 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy'), array('Þ' => 'TH', 'þ' => 'th', 'Ð' => 'DH', 'ð' => 'dh', 'ß' => 'ss', 'Œ' => 'OE', 'œ' => 'oe', 'Æ' => 'AE', 'æ' => 'ae', 'µ' => 'u')); -} - - -function BitrateColor($bitrate, $BitrateMaxScale=768) { - // $BitrateMaxScale is bitrate of maximum-quality color (bright green) - // below this is gradient, above is solid green - - $bitrate *= (256 / $BitrateMaxScale); // scale from 1-[768]kbps to 1-256 - $bitrate = round(min(max($bitrate, 1), 256)); - $bitrate--; // scale from 1-256kbps to 0-255kbps - - $Rcomponent = max(255 - ($bitrate * 2), 0); - $Gcomponent = max(($bitrate * 2) - 255, 0); - if ($bitrate > 127) { - $Bcomponent = max((255 - $bitrate) * 2, 0); - } else { - $Bcomponent = max($bitrate * 2, 0); - } - 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); -} - -function BitrateText($bitrate, $decimals=0, $vbr=false) { - return '<SPAN STYLE="color: #'.BitrateColor($bitrate).($vbr ? '; font-weight: bold;' : '').'">'.number_format($bitrate, $decimals).' kbps</SPAN>'; -} - -function FixTextFields($text) { - $text = getid3_lib::SafeStripSlashes($text); - $text = htmlentities($text, ENT_QUOTES); - return $text; -} - - -function string_var_dump($variable) { - ob_start(); - var_dump($variable); - $dumpedvariable = ob_get_contents(); - ob_end_clean(); - return $dumpedvariable; -} - - -function table_var_dump($variable) { - $returnstring = ''; - switch (gettype($variable)) { - case 'array': - $returnstring .= '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="2">'; - foreach ($variable as $key => $value) { - $returnstring .= '<TR><TD VALIGN="TOP"><B>'.str_replace("\x00", ' ', $key).'</B></TD>'; - $returnstring .= '<TD VALIGN="TOP">'.gettype($value); - if (is_array($value)) { - $returnstring .= ' ('.count($value).')'; - } elseif (is_string($value)) { - $returnstring .= ' ('.strlen($value).')'; - } - if (($key == 'data') && isset($variable['image_mime']) && isset($variable['dataoffset'])) { - $imagechunkcheck = getid3_lib::GetDataImageSize($value); - $DumpedImageSRC = (!empty($_REQUEST['filename']) ? $_REQUEST['filename'] : '.getid3').'.'.$variable['dataoffset'].'.'.getid3_lib::ImageTypesLookup($imagechunkcheck[2]); - if ($tempimagefile = fopen($DumpedImageSRC, 'wb')) { - fwrite($tempimagefile, $value); - fclose($tempimagefile); - } - $returnstring .= '</TD><TD><IMG SRC="'.$DumpedImageSRC.'" WIDTH="'.$imagechunkcheck[0].'" HEIGHT="'.$imagechunkcheck[1].'"></TD></TR>'; - } else { - $returnstring .= '</TD><TD>'.table_var_dump($value).'</TD></TR>'; - } - } - $returnstring .= '</TABLE>'; - break; - - case 'boolean': - $returnstring .= ($variable ? 'TRUE' : 'FALSE'); - break; - - case 'integer': - case 'double': - case 'float': - $returnstring .= $variable; - break; - - case 'object': - case 'null': - $returnstring .= string_var_dump($variable); - break; - - case 'string': - $variable = str_replace("\x00", ' ', $variable); - $varlen = strlen($variable); - for ($i = 0; $i < $varlen; $i++) { - if (ereg('['."\x0A\x0D".' -;0-9A-Za-z]', $variable{$i})) { - $returnstring .= $variable{$i}; - } else { - $returnstring .= '&#'.str_pad(ord($variable{$i}), 3, '0', STR_PAD_LEFT).';'; - } - } - $returnstring = nl2br($returnstring); - break; - - default: - $imagechunkcheck = getid3_lib::GetDataImageSize($variable); - if (($imagechunkcheck[2] >= 1) && ($imagechunkcheck[2] <= 3)) { - $returnstring .= '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="2">'; - $returnstring .= '<TR><TD><B>type</B></TD><TD>'.getid3_lib::ImageTypesLookup($imagechunkcheck[2]).'</TD></TR>'; - $returnstring .= '<TR><TD><B>width</B></TD><TD>'.number_format($imagechunkcheck[0]).' px</TD></TR>'; - $returnstring .= '<TR><TD><B>height</B></TD><TD>'.number_format($imagechunkcheck[1]).' px</TD></TR>'; - $returnstring .= '<TR><TD><B>size</B></TD><TD>'.number_format(strlen($variable)).' bytes</TD></TR></TABLE>'; - } else { - $returnstring .= nl2br(htmlspecialchars(str_replace("\x00", ' ', $variable))); - } - break; - } - return $returnstring; -} - - -function NiceDisplayFiletypeFormat(&$fileinfo) { - - if (empty($fileinfo['fileformat'])) { - return '-'; - } - - $output = $fileinfo['fileformat']; - if (empty($fileinfo['video']['dataformat']) && empty($fileinfo['audio']['dataformat'])) { - return $output; // 'gif' - } - if (empty($fileinfo['video']['dataformat']) && !empty($fileinfo['audio']['dataformat'])) { - if ($fileinfo['fileformat'] == $fileinfo['audio']['dataformat']) { - return $output; // 'mp3' - } - $output .= '.'.$fileinfo['audio']['dataformat']; // 'ogg.flac' - return $output; - } - if (!empty($fileinfo['video']['dataformat']) && empty($fileinfo['audio']['dataformat'])) { - if ($fileinfo['fileformat'] == $fileinfo['video']['dataformat']) { - return $output; // 'mpeg' - } - $output .= '.'.$fileinfo['video']['dataformat']; // 'riff.avi' - return $output; - } - if ($fileinfo['video']['dataformat'] == $fileinfo['audio']['dataformat']) { - if ($fileinfo['fileformat'] == $fileinfo['video']['dataformat']) { - return $output; // 'real' - } - $output .= '.'.$fileinfo['video']['dataformat']; // any examples? - return $output; - } - $output .= '.'.$fileinfo['video']['dataformat']; - $output .= '.'.$fileinfo['audio']['dataformat']; // asf.wmv.wma - return $output; - -} - -/* not needed Allan Hansen -function ListOfAssumeFormatExtensions() { - // These values should almost never get used - the only use for them - // is to possibly help getID3() correctly identify a file that has - // garbage data at the beginning of the file, but a correct filename - // extension. - - //$AssumeFormatExtensions[<filename extension>] = <file format>; - - $AssumeFormatExtensions['aac'] = 'aac'; - $AssumeFormatExtensions['iff'] = 'aiff'; - $AssumeFormatExtensions['aif'] = 'aiff'; - $AssumeFormatExtensions['aifc'] = 'aiff'; - $AssumeFormatExtensions['iff'] = 'aiff'; - $AssumeFormatExtensions['aiff'] = 'aiff'; - $AssumeFormatExtensions['wmv'] = 'asf'; - $AssumeFormatExtensions['wma'] = 'asf'; - $AssumeFormatExtensions['asf'] = 'asf'; - $AssumeFormatExtensions['au'] = 'au'; - $AssumeFormatExtensions['bmp'] = 'bmp'; - $AssumeFormatExtensions['mod'] = 'bonk'; - $AssumeFormatExtensions['bonk'] = 'bonk'; - $AssumeFormatExtensions['flac'] = 'flac'; - $AssumeFormatExtensions['gif'] = 'gif'; - $AssumeFormatExtensions['iso'] = 'iso'; - $AssumeFormatExtensions['jpeg'] = 'jpg'; - $AssumeFormatExtensions['jpg'] = 'jpg'; - $AssumeFormatExtensions['la'] = 'la'; - $AssumeFormatExtensions['pac'] = 'lpac'; - $AssumeFormatExtensions['mac'] = 'mac'; - $AssumeFormatExtensions['ape'] = 'mac'; - $AssumeFormatExtensions['mid'] = 'midi'; - $AssumeFormatExtensions['midi'] = 'midi'; - $AssumeFormatExtensions['mid'] = 'midi'; - $AssumeFormatExtensions['xm'] = 'mod'; - $AssumeFormatExtensions['it'] = 'mod'; - $AssumeFormatExtensions['s3m'] = 'mod'; - $AssumeFormatExtensions['mp3'] = 'mp3'; - $AssumeFormatExtensions['mp2'] = 'mp3'; - $AssumeFormatExtensions['mp1'] = 'mp3'; - $AssumeFormatExtensions['mpc'] = 'mpc'; - $AssumeFormatExtensions['mpg'] = 'mpeg'; - $AssumeFormatExtensions['mpeg'] = 'mpeg'; - $AssumeFormatExtensions['nsv'] = 'nsv'; - $AssumeFormatExtensions['ofr'] = 'ofr'; - $AssumeFormatExtensions['spx'] = 'ogg'; - $AssumeFormatExtensions['ogg'] = 'ogg'; - $AssumeFormatExtensions['png'] = 'png'; - $AssumeFormatExtensions['mov'] = 'quicktime'; - $AssumeFormatExtensions['qt'] = 'quicktime'; - $AssumeFormatExtensions['rar'] = 'rar'; - $AssumeFormatExtensions['ra'] = 'real'; - $AssumeFormatExtensions['ram'] = 'real'; - $AssumeFormatExtensions['rm'] = 'real'; - $AssumeFormatExtensions['wav'] = 'riff'; - $AssumeFormatExtensions['wv'] = 'riff'; - $AssumeFormatExtensions['vox'] = 'riff'; - $AssumeFormatExtensions['cda'] = 'riff'; - $AssumeFormatExtensions['xvid'] = 'riff'; - $AssumeFormatExtensions['avi'] = 'riff'; - $AssumeFormatExtensions['divx'] = 'riff'; - $AssumeFormatExtensions['avi'] = 'riff'; - $AssumeFormatExtensions['wav'] = 'riff'; - $AssumeFormatExtensions['rka'] = 'rkau'; - $AssumeFormatExtensions['swf'] = 'swf'; - $AssumeFormatExtensions['sz'] = 'szip'; - $AssumeFormatExtensions['voc'] = 'voc'; - $AssumeFormatExtensions['vqf'] = 'vqf'; - $AssumeFormatExtensions['zip'] = 'zip'; - - return $AssumeFormatExtensions; -} -*/ - - -function MoreNaturalSort($ar1, $ar2) { - if ($ar1 === $ar2) { - return 0; - } - $len1 = strlen($ar1); - $len2 = strlen($ar2); - $shortest = min($len1, $len2); - if (substr($ar1, 0, $shortest) === substr($ar2, 0, $shortest)) { - // the shorter argument is the beginning of the longer one, like "str" and "string" - if ($len1 < $len2) { - return -1; - } elseif ($len1 > $len2) { - return 1; - } - return 0; - } - $ar1 = RemoveAccents(strtolower(trim($ar1))); - $ar2 = RemoveAccents(strtolower(trim($ar2))); - $translatearray = array('\''=>'', '"'=>'', '_'=>' ', '('=>'', ')'=>'', '-'=>' ', ' '=>' ', '.'=>'', ','=>''); - foreach ($translatearray as $key => $val) { - $ar1 = str_replace($key, $val, $ar1); - $ar2 = str_replace($key, $val, $ar2); - } - - if ($ar1 < $ar2) { - return -1; - } elseif ($ar1 > $ar2) { - return 1; - } - return 0; -} - -function PoweredBygetID3($string='<BR><HR NOSHADE><DIV STYLE="font-size: 8pt; font-face: sans-serif;">Powered by <A HREF="http://getid3.sourceforge.net" TARGET="_blank"><B>getID3() v<!--GETID3VER--></B><BR>http://getid3.sourceforge.net</A></DIV>') { - return str_replace('<!--GETID3VER-->', GETID3_VERSION, $string); -} - -?> -</BODY> -</HTML>
\ No newline at end of file diff --git a/modules/id3/demos/demo.cache.dbm.php b/modules/id3/demos/demo.cache.dbm.php deleted file mode 100644 index acaaa0f3..00000000 --- a/modules/id3/demos/demo.cache.dbm.php +++ /dev/null @@ -1,29 +0,0 @@ -<?php -///////////////////////////////////////////////////////////////// -/// getID3() by James Heinrich <info@getid3.org> // -// available at http://getid3.sourceforge.net // -// or http://www.getid3.org // -///////////////////////////////////////////////////////////////// -// // -// /demo/demo.cache.dbm.php - part of getID3() // -// Sample script demonstrating the use of the DBM caching // -// extension for getID3() // -// See readme.txt for more details // -// /// -///////////////////////////////////////////////////////////////// - -require_once('../getid3/getid3.php'); -getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'extension.cache.dbm.php', __FILE__, true); - -$getID3 = new getID3_cached_dbm('db3', '/zimweb/test/test.dbm', '/zimweb/test/test.lock'); - -$r = $getID3->analyze('/path/to/files/filename.mp3'); - -echo '<pre>'; -var_dump($r); -echo '</pre>'; - -// uncomment to clear cache -// $getID3->clear_cache(); - -?>
\ No newline at end of file diff --git a/modules/id3/demos/demo.cache.mysql.php b/modules/id3/demos/demo.cache.mysql.php deleted file mode 100644 index 537b2f0c..00000000 --- a/modules/id3/demos/demo.cache.mysql.php +++ /dev/null @@ -1,29 +0,0 @@ -<?php -///////////////////////////////////////////////////////////////// -/// getID3() by James Heinrich <info@getid3.org> // -// available at http://getid3.sourceforge.net // -// or http://www.getid3.org // -///////////////////////////////////////////////////////////////// -// // -// /demo/demo.cache.mysql.php - part of getID3() // -// Sample script demonstrating the use of the DBM caching // -// extension for getID3() // -// See readme.txt for more details // -// /// -///////////////////////////////////////////////////////////////// - -require_once('../getid3/getid3.php'); -getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'extension.cache.mysql.php', __FILE__, true); - -$getID3 = new getID3_cached_mysql('localhost', 'database', 'username', 'password'); - -$r = $getID3->analyze('/path/to/files/filename.mp3'); - -echo '<pre>'; -var_dump($r); -echo '</pre>'; - -// uncomment to clear cache -//$getID3->clear_cache(); - -?>
\ No newline at end of file diff --git a/modules/id3/demos/demo.joinmp3.php b/modules/id3/demos/demo.joinmp3.php deleted file mode 100644 index 976884f9..00000000 --- a/modules/id3/demos/demo.joinmp3.php +++ /dev/null @@ -1,96 +0,0 @@ -<?php -///////////////////////////////////////////////////////////////// -/// getID3() by James Heinrich <info@getid3.org> // -// available at http://getid3.sourceforge.net // -// or http://www.getid3.org // -///////////////////////////////////////////////////////////////// -// // -// /demo/demo.joinmp3.php - part of getID3() // -// Sample script for splicing two or more MP3s together into // -// one file. Does not attempt to fix VBR header frames. // -// See readme.txt for more details // -// /// -///////////////////////////////////////////////////////////////// - - -// sample usage: -// $FilenameOut = 'combined.mp3'; -// $FilenamesIn[] = 'file1.mp3'; -// $FilenamesIn[] = 'file2.mp3'; -// $FilenamesIn[] = 'file3.mp3'; -// -// if (CombineMultipleMP3sTo($FilenameOut, $FilenamesIn)) { -// echo 'Successfully copied '.implode(' + ', $FilenamesIn).' to '.$FilenameOut; -// } else { -// echo 'Failed to copy '.implode(' + ', $FilenamesIn).' to '.$FilenameOut; -// } - -function CombineMultipleMP3sTo($FilenameOut, $FilenamesIn) { - - foreach ($FilenamesIn as $nextinputfilename) { - if (!is_readable($nextinputfilename)) { - echo 'Cannot read "'.$nextinputfilename.'"<BR>'; - return false; - } - } - if (!is_writeable($FilenameOut)) { - echo 'Cannot write "'.$FilenameOut.'"<BR>'; - return false; - } - - require_once('../getid3/getid3.php'); - if ($fp_output = @fopen($FilenameOut, 'wb')) { - - // Initialize getID3 engine - $getID3 = new getID3; - foreach ($FilenamesIn as $nextinputfilename) { - - $CurrentFileInfo = $getID3->analyze($nextinputfilename); - if ($CurrentFileInfo['fileformat'] == 'mp3') { - - if ($fp_source = @fopen($nextinputfilename, 'rb')) { - - $CurrentOutputPosition = ftell($fp_output); - - // copy audio data from first file - fseek($fp_source, $CurrentFileInfo['avdataoffset'], SEEK_SET); - while (!feof($fp_source) && (ftell($fp_source) < $CurrentFileInfo['avdataend'])) { - fwrite($fp_output, fread($fp_source, 32768)); - } - fclose($fp_source); - - // trim post-audio data (if any) copied from first file that we don't need or want - $EndOfFileOffset = $CurrentOutputPosition + ($CurrentFileInfo['avdataend'] - $CurrentFileInfo['avdataoffset']); - fseek($fp_output, $EndOfFileOffset, SEEK_SET); - ftruncate($fp_output, $EndOfFileOffset); - - } else { - - echo 'failed to open '.$nextinputfilename.' for reading'; - fclose($fp_output); - return false; - - } - - } else { - - echo $nextinputfilename.' is not MP3 format'; - fclose($fp_output); - return false; - - } - - } - - } else { - - echo 'failed to open '.$FilenameOut.' for writing'; - return false; - - } - - fclose($fp_output); - return true; -} - -?>
\ No newline at end of file diff --git a/modules/id3/demos/demo.mimeonly.php b/modules/id3/demos/demo.mimeonly.php deleted file mode 100644 index dd6dec6f..00000000 --- a/modules/id3/demos/demo.mimeonly.php +++ /dev/null @@ -1,53 +0,0 @@ -<?php -///////////////////////////////////////////////////////////////// -/// getID3() by James Heinrich <info@getid3.org> // -// available at http://getid3.sourceforge.net // -// or http://www.getid3.org // -///////////////////////////////////////////////////////////////// -// // -// /demo/demo.mimeonly.php - part of getID3() // -// Sample script for scanning a single file and returning only // -// the MIME information // -// See readme.txt for more details // -// /// -///////////////////////////////////////////////////////////////// - -echo '<HTML><HEAD><STYLE>BODY, TD, TH { font-family: sans-serif; font-size: 10pt; }</STYLE></HEAD><BODY>'; - -if (!empty($_REQUEST['filename'])) { - - echo 'The file "'.$_REQUEST['filename'].'" has a MIME type of "'.GetMIMEtype($_REQUEST['filename']).'"'; - -} else { - - echo 'Usage: <TT>'.$_SERVER['PHP_SELF'].'?filename=<I>filename.ext</I></TT>'; - -} - - -function GetMIMEtype($filename) { - // include getID3() library (can be in a different directory if full path is specified) - require_once('../getid3/getid3.php'); - // Initialize getID3 engine - $getID3 = new getID3; - - $DeterminedMIMEtype = ''; - if ($fp = fopen($filename, 'rb')) { - $ThisFileInfo = array('avdataoffset'=>0, 'avdataend'=>0); - - getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v2.php', __FILE__, true); - $tag = new getid3_id3v2($fp, $ThisFileInfo); - - fseek($fp, $ThisFileInfo['avdataoffset'], SEEK_SET); - $formattest = fread($fp, 16); // 16 bytes is sufficient for any format except ISO CD-image - fclose($fp); - - $DeterminedFormatInfo = $getID3->GetFileFormat($formattest); - $DeterminedMIMEtype = $DeterminedFormatInfo['mime_type']; - } - return $DeterminedMIMEtype; -} - -?> -</BODY> -</HTML>
\ No newline at end of file diff --git a/modules/id3/demos/demo.mysql.php b/modules/id3/demos/demo.mysql.php deleted file mode 100644 index f44c62ad..00000000 --- a/modules/id3/demos/demo.mysql.php +++ /dev/null @@ -1,1825 +0,0 @@ -<?php -///////////////////////////////////////////////////////////////// -/// getID3() by James Heinrich <info@getid3.org> // -// available at http://getid3.sourceforge.net // -// or http://www.getid3.org // -///////////////////////////////////////////////////////////////// -// // -// /demo/demo.mysql.php - part of getID3() // -// Sample script for recursively scanning directories and // -// storing the results in a database // -// See readme.txt for more details // -// /// -///////////////////////////////////////////////////////////////// - -// OPTIONS: -$getid3_demo_mysql_encoding = 'ISO-8859-1'; -$getid3_demo_mysql_md5_data = false; // All data hashes are by far the slowest part of scanning -$getid3_demo_mysql_md5_file = false; - - -if (!@mysql_connect('localhost', 'getid3', 'getid3')) { - die('Could not connect to MySQL host: <BLOCKQUOTE STYLE="background-color: #FF9933; padding: 10px;">'.mysql_error().'</BLOCKQUOTE>'); -} -if (!@mysql_select_db('getid3')) { - die('Could not select database: <BLOCKQUOTE STYLE="background-color: #FF9933; padding: 10px;">'.mysql_error().'</BLOCKQUOTE>'); -} - -if (!@include_once('../getid3/getid3.php')) { - die('Cannot open '.realpath('../getid3/getid3.php')); -} -// Initialize getID3 engine -$getID3 = new getID3; -$getID3->option_md5_data = $getid3_demo_mysql_md5_data; -$getID3->encoding = $getid3_demo_mysql_encoding; - - -function RemoveAccents($string) { - // Revised version by markstewardØhotmail*com - return strtr(strtr($string, 'ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝàáâãäåçèéêëìíîïñòóôõöøùúûüýÿ', 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy'), array('Þ' => 'TH', 'þ' => 'th', 'Ð' => 'DH', 'ð' => 'dh', 'ß' => 'ss', 'Œ' => 'OE', 'œ' => 'oe', 'Æ' => 'AE', 'æ' => 'ae', 'µ' => 'u')); -} - -function FixTextFields($text) { - $text = getid3_lib::SafeStripSlashes($text); - $text = htmlentities($text, ENT_QUOTES); - return $text; -} - -function BitrateColor($bitrate, $BitrateMaxScale=768) { - // $BitrateMaxScale is bitrate of maximum-quality color (bright green) - // below this is gradient, above is solid green - - $bitrate *= (256 / $BitrateMaxScale); // scale from 1-[768]kbps to 1-256 - $bitrate = round(min(max($bitrate, 1), 256)); - $bitrate--; // scale from 1-256kbps to 0-255kbps - - $Rcomponent = max(255 - ($bitrate * 2), 0); - $Gcomponent = max(($bitrate * 2) - 255, 0); - if ($bitrate > 127) { - $Bcomponent = max((255 - $bitrate) * 2, 0); - } else { - $Bcomponent = max($bitrate * 2, 0); - } - 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); -} - -function BitrateText($bitrate, $decimals=0) { - return '<SPAN STYLE="color: #'.BitrateColor($bitrate).'">'.number_format($bitrate, $decimals).' kbps</SPAN>'; -} - -function fileextension($filename, $numextensions=1) { - if (strstr($filename, '.')) { - $reversedfilename = strrev($filename); - $offset = 0; - for ($i = 0; $i < $numextensions; $i++) { - $offset = strpos($reversedfilename, '.', $offset + 1); - if ($offset === false) { - return ''; - } - } - return strrev(substr($reversedfilename, 0, $offset)); - } - return ''; -} - -if (!empty($_REQUEST['renamefilefrom']) && !empty($_REQUEST['renamefileto'])) { - - if ($_REQUEST['renamefilefrom'] === $_REQUEST['renamefileto']) { - $results = '<SPAN STYLE="color: #FF0000;"><B>Source and Destination filenames identical</B><BR>FAILED to rename'; - } elseif (!file_exists($_REQUEST['renamefilefrom'])) { - $results = '<SPAN STYLE="color: #FF0000;"><B>Source file does not exist</B><BR>FAILED to rename'; - } elseif (file_exists($_REQUEST['renamefileto']) && (strtolower($_REQUEST['renamefilefrom']) !== strtolower($_REQUEST['renamefileto']))) { - $results = '<SPAN STYLE="color: #FF0000;"><B>Destination file already exists</B><BR>FAILED to rename'; - } elseif (@rename($_REQUEST['renamefilefrom'], $_REQUEST['renamefileto'])) { - $SQLquery = 'DELETE FROM `files` WHERE (filename = "'.mysql_escape_string($_REQUEST['renamefilefrom']).'")'; - safe_mysql_query($SQLquery); - $results = '<SPAN STYLE="color: #008000;">Successfully renamed'; - } else { - $results = '<BR><SPAN STYLE="color: #FF0000;">FAILED to rename'; - } - $results .= ' from:<BR><I>'.$_REQUEST['renamefilefrom'].'</I><BR>to:<BR><I>'.$_REQUEST['renamefileto'].'</I></SPAN><HR>'; - echo $results; - exit; - -} elseif (!empty($_REQUEST['m3ufilename'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - echo WindowsShareSlashTranslate($_REQUEST['m3ufilename'])."\n"; - exit; - -} elseif (!isset($_REQUEST['m3u']) && !isset($_REQUEST['m3uartist']) && !isset($_REQUEST['m3utitle'])) { - - 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>'; - -} - - -function WindowsShareSlashTranslate($filename) { - if (substr($filename, 0, 2) == '//') { - return str_replace('/', '\\', $filename); - } - return $filename; -} - -function safe_mysql_query($SQLquery) { - $result = @mysql_query($SQLquery); - if (mysql_error()) { - die('<FONT COLOR="red">'.mysql_error().'</FONT><HR><TT>'.$SQLquery.'</TT>'); - } - return $result; -} - -function mysql_table_exists($tablename) { - return (bool) mysql_query('DESCRIBE '.$tablename); -} - -function AcceptableExtensions($fileformat, $audio_dataformat='', $video_dataformat='') { - static $AcceptableExtensionsAudio = array(); - if (empty($AcceptableExtensionsAudio)) { - $AcceptableExtensionsAudio['mp3']['mp3'] = array('mp3'); - $AcceptableExtensionsAudio['mp2']['mp2'] = array('mp2'); - $AcceptableExtensionsAudio['mp1']['mp1'] = array('mp1'); - $AcceptableExtensionsAudio['asf']['asf'] = array('asf'); - $AcceptableExtensionsAudio['asf']['wma'] = array('wma'); - $AcceptableExtensionsAudio['riff']['mp3'] = array('wav'); - $AcceptableExtensionsAudio['riff']['wav'] = array('wav'); - } - static $AcceptableExtensionsVideo = array(); - if (empty($AcceptableExtensionsVideo)) { - $AcceptableExtensionsVideo['mp3']['mp3'] = array('mp3'); - $AcceptableExtensionsVideo['mp2']['mp2'] = array('mp2'); - $AcceptableExtensionsVideo['mp1']['mp1'] = array('mp1'); - $AcceptableExtensionsVideo['asf']['asf'] = array('asf'); - $AcceptableExtensionsVideo['asf']['wmv'] = array('wmv'); - $AcceptableExtensionsVideo['gif']['gif'] = array('gif'); - $AcceptableExtensionsVideo['jpg']['jpg'] = array('jpg'); - $AcceptableExtensionsVideo['png']['png'] = array('png'); - $AcceptableExtensionsVideo['bmp']['bmp'] = array('bmp'); - } - if (!empty($video_dataformat)) { - return (isset($AcceptableExtensionsVideo[$fileformat][$video_dataformat]) ? $AcceptableExtensionsVideo[$fileformat][$video_dataformat] : array()); - } else { - return (isset($AcceptableExtensionsAudio[$fileformat][$audio_dataformat]) ? $AcceptableExtensionsAudio[$fileformat][$audio_dataformat] : array()); - } -} - - -if (!empty($_REQUEST['scan'])) { - if (mysql_table_exists('files')) { - $SQLquery = 'DROP TABLE files'; - safe_mysql_query($SQLquery); - } -} -if (!mysql_table_exists('files')) { - $SQLquery = 'CREATE TABLE `files` ('; - $SQLquery .= ' `ID` mediumint(8) unsigned NOT NULL auto_increment,'; - $SQLquery .= ' `filename` text NOT NULL,'; - $SQLquery .= ' `LastModified` text NOT NULL,'; - $SQLquery .= ' `md5_file` varchar(32) NOT NULL default "",'; - $SQLquery .= ' `md5_data` varchar(32) NOT NULL default "",'; - $SQLquery .= ' `md5_data_source` varchar(32) NOT NULL default "",'; - $SQLquery .= ' `filesize` int(10) unsigned NOT NULL default "0",'; - $SQLquery .= ' `fileformat` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `audio_dataformat` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `video_dataformat` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `audio_bitrate` float NOT NULL default "0",'; - $SQLquery .= ' `video_bitrate` float NOT NULL default "0",'; - $SQLquery .= ' `playtime_seconds` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `tags` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `artist` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `title` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `album` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `genre` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `comment` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `track` varchar(7) NOT NULL default "",'; - $SQLquery .= ' `comments_all` text NOT NULL,'; - $SQLquery .= ' `comments_id3v2` text NOT NULL,'; - $SQLquery .= ' `comments_ape` text NOT NULL,'; - $SQLquery .= ' `comments_lyrics3` text NOT NULL,'; - $SQLquery .= ' `comments_id3v1` text NOT NULL,'; - $SQLquery .= ' `warning` text NOT NULL,'; - $SQLquery .= ' `error` text NOT NULL,'; - $SQLquery .= ' `track_volume` float NOT NULL default "0",'; - $SQLquery .= ' `encoder_options` varchar(255) NOT NULL default "",'; - $SQLquery .= ' `vbr_method` varchar(255) NOT NULL default "",'; - $SQLquery .= ' PRIMARY KEY (`ID`)'; - $SQLquery .= ') TYPE=MyISAM;'; - - safe_mysql_query($SQLquery); -} - -$ExistingTableFields = array(); -$result = mysql_query('DESCRIBE `files`'); -while ($row = mysql_fetch_array($result)) { - $ExistingTableFields[$row['Field']] = $row; -} -if (!isset($ExistingTableFields['encoder_options'])) { // Added in 1.7.0b2 - echo '<B>adding field `encoder_options`</B><BR>'; - mysql_query('ALTER TABLE `files` ADD `encoder_options` VARCHAR(255) DEFAULT "" NOT NULL AFTER `error`'); - mysql_query('OPTIMIZE TABLE `files`'); -} -if (isset($ExistingTableFields['track']) && ($ExistingTableFields['track']['Type'] != 'varchar(7)')) { // Changed in 1.7.0b2 - echo '<B>changing field `track` to VARCHAR(7)</B><BR>'; - mysql_query('ALTER TABLE `files` CHANGE `track` `track` VARCHAR(7) DEFAULT "" NOT NULL'); - mysql_query('OPTIMIZE TABLE `files`'); -} -if (!isset($ExistingTableFields['track_volume'])) { // Added in 1.7.0b5 - 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>'; - echo '<B>adding field `track_volume`</B><BR>'; - mysql_query('ALTER TABLE `files` ADD `track_volume` FLOAT NOT NULL AFTER `error`'); - mysql_query('OPTIMIZE TABLE `files`'); -} - - -function SynchronizeAllTags($filename, $synchronizefrom='all', $synchronizeto='A12', &$errors) { - global $getID3; - - set_time_limit(30); - - $ThisFileInfo = $getID3->analyze($filename); - getid3_lib::CopyTagsToComments($ThisFileInfo); - - if ($synchronizefrom == 'all') { - $SourceArray = $ThisFileInfo['comments']; - } elseif (!empty($ThisFileInfo['tags'][$synchronizefrom])) { - $SourceArray = $ThisFileInfo['tags'][$synchronizefrom]; - } else { - die('ERROR: $ThisFileInfo[tags]['.$synchronizefrom.'] does not exist'); - } - - $SQLquery = 'DELETE FROM `files` WHERE (filename = "'.mysql_escape_string($filename).'")'; - safe_mysql_query($SQLquery); - - - $TagFormatsToWrite = array(); - if ((strpos($synchronizeto, '2') !== false) && ($synchronizefrom != 'id3v2')) { - $TagFormatsToWrite[] = 'id3v2.3'; - } - if ((strpos($synchronizeto, 'A') !== false) && ($synchronizefrom != 'ape')) { - $TagFormatsToWrite[] = 'ape'; - } - if ((strpos($synchronizeto, 'L') !== false) && ($synchronizefrom != 'lyrics3')) { - $TagFormatsToWrite[] = 'lyrics3'; - } - if ((strpos($synchronizeto, '1') !== false) && ($synchronizefrom != 'id3v1')) { - $TagFormatsToWrite[] = 'id3v1'; - } - - getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'write.php', __FILE__, true); - $tagwriter = new getid3_writetags; - $tagwriter->filename = $filename; - $tagwriter->tagformats = $TagFormatsToWrite; - $tagwriter->overwrite_tags = true; - $tagwriter->tag_encoding = $getID3->encoding; - $tagwriter->tag_data = $SourceArray; - - if ($tagwriter->WriteTags()) { - $errors = $tagwriter->errors; - return true; - } - $errors = $tagwriter->errors; - return false; -} - -$IgnoreNoTagFormats = array('', 'png', 'jpg', 'gif', 'bmp', 'swf', 'zip', 'mid', 'mod', 'xm', 'it', 's3m'); - -if (!empty($_REQUEST['scan']) || !empty($_REQUEST['newscan']) || !empty($_REQUEST['rescanerrors'])) { - - $SQLquery = 'DELETE from `files` WHERE (fileformat = "")'; - safe_mysql_query($SQLquery); - - $FilesInDir = array(); - - if (!empty($_REQUEST['rescanerrors'])) { - - echo '<A HREF="'.$_SERVER['PHP_SELF'].'">abort</A><HR>'; - - echo 'Re-scanning all media files already in database that had errors and/or warnings in last scan<HR>'; - - $SQLquery = 'SELECT filename FROM `files` WHERE (error <> "") OR (warning <> "") ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - while ($row = mysql_fetch_array($result)) { - - if (!file_exists($row['filename'])) { - echo '<B>File missing: '.$row['filename'].'</B><BR>'; - $SQLquery = 'DELETE FROM `files` WHERE (filename = "'.mysql_escape_string($row['filename']).'")'; - safe_mysql_query($SQLquery); - } else { - $FilesInDir[] = $row['filename']; - } - - } - - } elseif (!empty($_REQUEST['scan']) || !empty($_REQUEST['newscan'])) { - - echo '<A HREF="'.$_SERVER['PHP_SELF'].'">abort</A><HR>'; - - echo 'Scanning all media files in <B>'.str_replace('\\', '/', realpath(!empty($_REQUEST['scan']) ? $_REQUEST['scan'] : $_REQUEST['newscan'])).'</B> (and subdirectories)<HR>'; - - $SQLquery = 'SELECT COUNT(*) AS num, filename'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' GROUP BY filename'; - $SQLquery .= ' ORDER BY num DESC'; - $result = safe_mysql_query($SQLquery); - $DupesDeleted = 0; - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - if ($row['num'] <= 1) { - break; - } - $SQLquery = 'DELETE FROM `files` WHERE filename LIKE "'.mysql_escape_string($row['filename']).'"'; - safe_mysql_query($SQLquery); - $DupesDeleted++; - } - if ($DupesDeleted > 0) { - echo 'Deleted <B>'.number_format($DupesDeleted).'</B> duplicate filenames<HR>'; - } - - if (!empty($_REQUEST['newscan'])) { - $AlreadyInDatabase = array(); - set_time_limit(60); - $SQLquery = 'SELECT filename FROM `files` ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - while ($row = mysql_fetch_array($result)) { - //$AlreadyInDatabase[] = strtolower($row['filename']); - $AlreadyInDatabase[] = $row['filename']; - } - } - - $DirectoriesToScan = array(realpath(!empty($_REQUEST['scan']) ? $_REQUEST['scan'] : $_REQUEST['newscan'])); - $DirectoriesScanned = array(); - while (count($DirectoriesToScan) > 0) { - foreach ($DirectoriesToScan as $DirectoryKey => $startingdir) { - if ($dir = @opendir($startingdir)) { - set_time_limit(30); - echo '<B>'.str_replace('\\', '/', $startingdir).'</B><BR>'; - flush(); - while (($file = readdir($dir)) !== false) { - if (($file != '.') && ($file != '..')) { - $RealPathName = realpath($startingdir.'/'.$file); - if (is_dir($RealPathName)) { - if (!in_array($RealPathName, $DirectoriesScanned) && !in_array($RealPathName, $DirectoriesToScan)) { - $DirectoriesToScan[] = $RealPathName; - } - } else if (is_file($RealPathName)) { - if (!empty($_REQUEST['newscan'])) { - //if (!in_array(strtolower(str_replace('\\', '/', $RealPathName)), $AlreadyInDatabase)) { - if (!in_array(str_replace('\\', '/', $RealPathName), $AlreadyInDatabase)) { - $FilesInDir[] = $RealPathName; - } else { - } - } elseif (!empty($_REQUEST['scan'])) { - $FilesInDir[] = $RealPathName; - } - } - } - } - closedir($dir); - } else { - echo '<FONT COLOR="RED">Failed to open directory <B>'.$startingdir.'</B></FONT><BR><BR>'; - } - $DirectoriesScanned[] = $startingdir; - unset($DirectoriesToScan[$DirectoryKey]); - } - } - echo '<I>List of files to scan complete (added '.number_format(count($FilesInDir)).' files to scan)</I><HR>'; - flush(); - } - - $FilesInDir = array_unique($FilesInDir); - sort($FilesInDir); - - $starttime = time(); - $rowcounter = 0; - $totaltoprocess = count($FilesInDir); - - foreach ($FilesInDir as $filename) { - set_time_limit(300); - - echo '<BR>'.date('H:i:s').' ['.number_format(++$rowcounter).' / '.number_format($totaltoprocess).'] '.str_replace('\\', '/', $filename); - - $ThisFileInfo = $getID3->analyze($filename); - getid3_lib::CopyTagsToComments($ThisFileInfo); - - if (file_exists($filename)) { - $ThisFileInfo['file_modified_time'] = filemtime($filename); - $ThisFileInfo['md5_file'] = ($getid3_demo_mysql_md5_file ? md5_file($filename) : ''); - } - - if (empty($ThisFileInfo['fileformat'])) { - - echo ' (<SPAN STYLE="color: #990099;">unknown file type</SPAN>)'; - - } else { - - if (!empty($ThisFileInfo['error'])) { - echo ' (<SPAN STYLE="color: #FF0000;">errors</SPAN>)'; - } elseif (!empty($ThisFileInfo['warning'])) { - echo ' (<SPAN STYLE="color: #FF9999;">warnings</SPAN>)'; - } else { - echo ' (<SPAN STYLE="color: #009900;">OK</SPAN>)'; - } - - if (!empty($_REQUEST['rescanerrors'])) { - - $SQLquery = 'UPDATE `files` SET '; - $SQLquery .= 'LastModified = "'.mysql_escape_string(@$ThisFileInfo['file_modified_time']).'", '; - $SQLquery .= 'md5_file = "'.mysql_escape_string(@$ThisFileInfo['md5_file']).'", '; - $SQLquery .= 'md5_data = "'.mysql_escape_string(@$ThisFileInfo['md5_data']).'", '; - $SQLquery .= 'md5_data_source = "'.mysql_escape_string(@$ThisFileInfo['md5_data_source']).'", '; - $SQLquery .= 'filesize = "'.mysql_escape_string(@$ThisFileInfo['filesize']).'", '; - $SQLquery .= 'fileformat = "'.mysql_escape_string(@$ThisFileInfo['fileformat']).'", '; - $SQLquery .= 'audio_dataformat = "'.mysql_escape_string(@$ThisFileInfo['audio']['dataformat']).'", '; - $SQLquery .= 'video_dataformat = "'.mysql_escape_string(@$ThisFileInfo['video']['dataformat']).'", '; - $SQLquery .= 'audio_bitrate = "'.mysql_escape_string(@$ThisFileInfo['audio']['bitrate']).'", '; - $SQLquery .= 'video_bitrate = "'.mysql_escape_string(@$ThisFileInfo['video']['bitrate']).'", '; - $SQLquery .= 'playtime_seconds = "'.mysql_escape_string(@$ThisFileInfo['playtime_seconds']).'", '; - $SQLquery .= 'tags = "'.mysql_escape_string(@implode("\t", @array_keys(@$ThisFileInfo['tags']))).'", '; - $SQLquery .= 'artist = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['artist'])).'", '; - $SQLquery .= 'title = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['title'])).'", '; - $SQLquery .= 'album = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['album'])).'", '; - $SQLquery .= 'genre = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['genre'])).'", '; - $SQLquery .= 'comment = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['comment'])).'", '; - $SQLquery .= 'track = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['track'])).'", '; - $SQLquery .= 'comments_all = "'.mysql_escape_string(@serialize(@$ThisFileInfo['comments'])).'", '; - $SQLquery .= 'comments_id3v2 = "'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['id3v2'])).'", '; - $SQLquery .= 'comments_ape = "'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['ape'])).'", '; - $SQLquery .= 'comments_lyrics3 = "'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['lyrics3'])).'", '; - $SQLquery .= 'comments_id3v1 = "'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['id3v1'])).'", '; - $SQLquery .= 'warning = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['warning'])).'", '; - $SQLquery .= 'error = "'.mysql_escape_string(@implode("\t", @$ThisFileInfo['error'])).'", '; - $SQLquery .= 'encoder_options = "'.mysql_escape_string(trim(@$ThisFileInfo['audio']['encoder'].' '.@$ThisFileInfo['audio']['encoder_options'])).'", '; - $SQLquery .= 'vbr_method = "'.mysql_escape_string(@$ThisFileInfo['mpeg']['audio']['VBR_method']).'", '; - $SQLquery .= 'track_volume = "'.mysql_escape_string(@$ThisFileInfo['replay_gain']['track']['volume']).'" '; - $SQLquery .= 'WHERE (filename = "'.mysql_escape_string(@$ThisFileInfo['filenamepath']).'")'; - - } elseif (!empty($_REQUEST['scan']) || !empty($_REQUEST['newscan'])) { - - $SQLquery = 'INSERT INTO `files` (filename, LastModified, md5_file, md5_data, md5_data_source, filesize, fileformat, audio_dataformat, video_dataformat, audio_bitrate, video_bitrate, playtime_seconds, tags, artist, title, album, genre, comment, track, comments_all, comments_id3v2, comments_ape, comments_lyrics3, comments_id3v1, warning, error, encoder_options, vbr_method, track_volume) VALUES ('; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['filenamepath']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['file_modified_time']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['md5_file']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['md5_data']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['md5_data_source']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['filesize']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['fileformat']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['audio']['dataformat']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['video']['dataformat']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['audio']['bitrate']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['video']['bitrate']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['playtime_seconds']).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @array_keys(@$ThisFileInfo['tags']))).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['artist'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['title'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['album'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['genre'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['comment'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['comments']['track'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['comments'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['id3v2'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['ape'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['lyrics3'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@serialize(@$ThisFileInfo['tags']['id3v1'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['warning'])).'", '; - $SQLquery .= '"'.mysql_escape_string(@implode("\t", @$ThisFileInfo['error'])).'", '; - $SQLquery .= '"'.mysql_escape_string(trim(@$ThisFileInfo['audio']['encoder'].' '.@$ThisFileInfo['audio']['encoder_options'])).'", '; - $SQLquery .= '"'.mysql_escape_string(!empty($ThisFileInfo['mpeg']['audio']['LAME']) ? 'LAME' : @$ThisFileInfo['mpeg']['audio']['VBR_method']).'", '; - $SQLquery .= '"'.mysql_escape_string(@$ThisFileInfo['replay_gain']['track']['volume']).'")'; - - } - flush(); - safe_mysql_query($SQLquery); - } - - } - - $SQLquery = 'OPTIMIZE TABLE `files`'; - safe_mysql_query($SQLquery); - - echo '<HR>Done scanning!<HR>'; - -} elseif (!empty($_REQUEST['missingtrackvolume'])) { - - $MissingTrackVolumeFilesScanned = 0; - $MissingTrackVolumeFilesAdjusted = 0; - $MissingTrackVolumeFilesDeleted = 0; - $SQLquery = 'SELECT filename'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (track_volume = "0")'; - $SQLquery .= ' AND (audio_bitrate > "0")'; - $result = safe_mysql_query($SQLquery); - echo 'Scanning <SPAN ID="missingtrackvolumeNowScanning">0</SPAN> / '.number_format(mysql_num_rows($result)).' files for track volume information:<HR>'; - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - echo '<SCRIPT>missingtrackvolumeNowScanning.innerHTML="'.number_format($MissingTrackVolumeFilesScanned++).'"</SCRIPT>. '; - flush(); - if (file_exists($row['filename'])) { - - $ThisFileInfo = $getID3->analyze($row['filename']); - if (!empty($ThisFileInfo['replay_gain']['track']['volume'])) { - $MissingTrackVolumeFilesAdjusted++; - $SQLquery = 'UPDATE `files`'; - $SQLquery .= ' SET track_volume = "'.$ThisFileInfo['replay_gain']['track']['volume'].'"'; - $SQLquery .= ' WHERE (filename = "'.mysql_escape_string($row['filename']).'")'; - safe_mysql_query($SQLquery); - } - - } else { - - $MissingTrackVolumeFilesDeleted++; - $SQLquery = 'DELETE FROM `files`'; - $SQLquery .= ' WHERE (filename = "'.mysql_escape_string($row['filename']).'")'; - safe_mysql_query($SQLquery); - - } - } - echo '<HR>Scanned '.number_format($MissingTrackVolumeFilesScanned).' files with no track volume information.<BR>'; - 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>'; - -} elseif (!empty($_REQUEST['deadfilescheck'])) { - - $SQLquery = 'SELECT COUNT(*) AS num, filename'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' GROUP BY filename'; - $SQLquery .= ' ORDER BY num DESC'; - $result = safe_mysql_query($SQLquery); - $DupesDeleted = 0; - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - if ($row['num'] <= 1) { - break; - } - echo FixTextFields($row['filename']).'<BR>'; - $SQLquery = 'DELETE FROM `files` WHERE filename LIKE "'.mysql_escape_string($row['filename']).'"'; - safe_mysql_query($SQLquery); - $DupesDeleted++; - } - if ($DupesDeleted > 0) { - echo '<HR>Deleted <B>'.number_format($DupesDeleted).'</B> duplicate filenames<HR>'; - } - - $SQLquery = 'SELECT filename, filesize, LastModified FROM `files` ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - $totalchecked = 0; - $totalremoved = 0; - while ($row = mysql_fetch_array($result)) { - $totalchecked++; - set_time_limit(30); - if (!file_exists($row['filename']) || ($row['LastModified'] != filemtime($row['filename'])) || (filesize($row['filename']) != $row['filesize'])) { - $totalremoved++; - echo FixTextFields($row['filename']).'<BR>'; - flush(); - $SQLquery = 'DELETE FROM `files` WHERE (filename = "'.mysql_escape_string($row['filename']).'")'; - safe_mysql_query($SQLquery); - } - } - - 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>'; - -} elseif (!empty($_REQUEST['encodedbydistribution'])) { - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - - $SQLquery = 'SELECT filename, comments_id3v2 FROM `files` WHERE (encoder_options = "'.mysql_escape_string($_REQUEST['encodedbydistribution']).'")'; - $result = mysql_query($SQLquery); - $NonBlankEncodedBy = ''; - $BlankEncodedBy = ''; - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - $CommentArray = unserialize($row['comments_id3v2']); - if (isset($CommentArray['encoded_by'][0])) { - $NonBlankEncodedBy .= WindowsShareSlashTranslate($row['filename'])."\n"; - } else { - $BlankEncodedBy .= WindowsShareSlashTranslate($row['filename'])."\n"; - } - } - echo $NonBlankEncodedBy; - echo $BlankEncodedBy; - exit; - - } elseif (!empty($_REQUEST['showfiles'])) { - - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%').'">show all</A><BR>'; - echo '<TABLE BORDER="1">'; - - $SQLquery = 'SELECT filename, comments_id3v2 FROM `files`'; - $result = mysql_query($SQLquery); - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - $CommentArray = unserialize($row['comments_id3v2']); - if (($_REQUEST['encodedbydistribution'] == '%') || (!empty($CommentArray['encoded_by'][0]) && ($_REQUEST['encodedbydistribution'] == $CommentArray['encoded_by'][0]))) { - echo '<TR><TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</A></TD>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD></TR>'; - } - } - echo '</TABLE>'; - - } else { - - $SQLquery = 'SELECT encoder_options, comments_id3v2 FROM `files` ORDER BY (encoder_options LIKE "LAME%") DESC, (encoder_options LIKE "CBR%") DESC'; - $result = mysql_query($SQLquery); - $EncodedBy = array(); - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - $CommentArray = unserialize($row['comments_id3v2']); - if (isset($EncodedBy[$row['encoder_options']][@$CommentArray['encoded_by'][0]])) { - $EncodedBy[$row['encoder_options']][@$CommentArray['encoded_by'][0]]++; - } else { - $EncodedBy[$row['encoder_options']][@$CommentArray['encoded_by'][0]] = 1; - } - } - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%').'&m3u=1">.m3u version</A><BR>'; - echo '<TABLE BORDER="1"><TR><TH>m3u</TH><TH>Encoder Options</TH><TH>Encoded By (ID3v2)</TH></TR>'; - foreach ($EncodedBy as $key => $value) { - echo '<TR><TD VALIGN="TOP"><A HREF="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode($key).'&showfiles=1&m3u=1">m3u</A></TD>'; - echo '<TD VALIGN="TOP"><B>'.$key.'</B></TD>'; - echo '<TD><TABLE BORDER="0" WIDTH="100%">'; - arsort($value); - foreach ($value as $string => $count) { - echo '<TR><TD ALIGN="RIGHT" WIDTH="50"><I>'.number_format($count).'</I></TD><TD> </TD>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode($string).'&showfiles=1">'.$string.'</A></TD></TR>'; - } - echo '</TABLE></TD></TR>'; - } - echo '</TABLE>'; - - } - -} elseif (!empty($_REQUEST['audiobitrates'])) { - - getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.audio.mp3.php', __FILE__, true); - $BitrateDistribution = array(); - $SQLquery = 'SELECT ROUND(audio_bitrate / 1000) AS RoundBitrate, COUNT(*) AS num'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (audio_bitrate > 0)'; - $SQLquery .= ' GROUP BY RoundBitrate'; - $result = safe_mysql_query($SQLquery); - while ($row = mysql_fetch_array($result)) { - @$BitrateDistribution[getid3_mp3::ClosestStandardMP3Bitrate($row['RoundBitrate'] * 1000)] += $row['num']; // safe_inc - } - - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - echo '<TR><TH>Bitrate</TH><TH>Count</TH></TR>'; - foreach ($BitrateDistribution as $Bitrate => $Count) { - echo '<TR>'; - echo '<TD ALIGN="RIGHT">'.round($Bitrate / 1000).' kbps</TD>'; - echo '<TD ALIGN="RIGHT">'.number_format($Count).'</TD>'; - echo '</TR>'; - } - echo '</TABLE>'; - - -} elseif (!empty($_REQUEST['emptygenres'])) { - - $SQLquery = 'SELECT fileformat, filename, genre FROM `files` WHERE (genre = "") OR (genre = "Unknown") OR (genre = "Other") ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - while ($row = mysql_fetch_array($result)) { - if (!in_array($row['fileformat'], $IgnoreNoTagFormats)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - } - exit; - - } else { - - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?emptygenres='.urlencode($_REQUEST['emptygenres']).'&m3u=1">.m3u version</A><BR>'; - $EmptyGenreCounter = 0; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - echo '<TR><TH>m3u</TH><TH>filename</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - if (!in_array($row['fileformat'], $IgnoreNoTagFormats)) { - $EmptyGenreCounter++; - echo '<TR>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</A></TD>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '</TR>'; - } - } - echo '</TABLE>'; - echo '<B>'.number_format($EmptyGenreCounter).'</B> files with empty genres'; - - } - -} elseif (!empty($_REQUEST['nonemptycomments'])) { - - $SQLquery = 'SELECT filename, comment FROM `files` WHERE (comment <> "") ORDER BY comment ASC'; - $result = safe_mysql_query($SQLquery); - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - while ($row = mysql_fetch_array($result)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - exit; - - } else { - - $NonEmptyCommentsCounter = 0; - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?nonemptycomments='.urlencode($_REQUEST['nonemptycomments']).'&m3u=1">.m3u version</A><BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - echo '<TR><TH>m3u</TH><TH>filename</TH><TH>comments</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - $NonEmptyCommentsCounter++; - echo '<TR>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</A></TD>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - if (strlen(trim($row['comment'])) > 0) { - echo '<TD>'.FixTextFields($row['comment']).'</TD>'; - } else { - echo '<TD><I>space</I></TD>'; - } - echo '</TR>'; - } - echo '</TABLE>'; - echo '<B>'.number_format($NonEmptyCommentsCounter).'</B> files with non-empty comments'; - - } - -} elseif (!empty($_REQUEST['trackzero'])) { - - $SQLquery = 'SELECT filename, track FROM `files` WHERE (track <> "") AND ((track < "1") OR (track > "99")) ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - while ($row = mysql_fetch_array($result)) { - if ((strlen($row['track']) > 0) && ($row['track'] < 1) || ($row['track'] > 99)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - } - exit; - - } else { - - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?trackzero='.urlencode($_REQUEST['trackzero']).'&m3u=1">.m3u version</A><BR>'; - $TrackZeroCounter = 0; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - echo '<TR><TH>m3u</TH><TH>filename</TH><TH>track</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - if ((strlen($row['track']) > 0) && ($row['track'] < 1) || ($row['track'] > 99)) { - $TrackZeroCounter++; - echo '<TR>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</A></TD>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '<TD>'.FixTextFields($row['track']).'</TD>'; - echo '</TR>'; - } - } - echo '</TABLE>'; - echo '<B>'.number_format($TrackZeroCounter).'</B> files with track "zero"'; - - } - - -} elseif (!empty($_REQUEST['synchronizetagsfrom']) && !empty($_REQUEST['filename'])) { - - echo 'Applying new tags from <B>'.$_REQUEST['synchronizetagsfrom'].'</B> in <B>'.FixTextFields($_REQUEST['filename']).'</B><UL>'; - $errors = array(); - if (SynchronizeAllTags($_REQUEST['filename'], $_REQUEST['synchronizetagsfrom'], 'A12', $errors)) { - echo '<LI>Sucessfully wrote tags</LI>'; - } else { - echo '<LI>Tag writing had errors: <UL><LI>'.implode('</LI><LI>', $errors).'</LI></UL></LI>'; - } - echo '</UL>'; - - -} elseif (!empty($_REQUEST['unsynchronizedtags'])) { - - $NotOKfiles = 0; - $FieldsToCompare = array('title', 'artist', 'album', 'year', 'genre', 'comment', 'track'); - $TagsToCompare = array('id3v2'=>false, 'ape'=>false, 'lyrics3'=>false, 'id3v1'=>false); - $ID3v1FieldLengths = array('title'=>30, 'artist'=>30, 'album'=>30, 'year'=>4, 'genre'=>99, 'comment'=>28); - if (strpos($_REQUEST['unsynchronizedtags'], '2') !== false) { - $TagsToCompare['id3v2'] = true; - } - if (strpos($_REQUEST['unsynchronizedtags'], 'A') !== false) { - $TagsToCompare['ape'] = true; - } - if (strpos($_REQUEST['unsynchronizedtags'], 'L') !== false) { - $TagsToCompare['lyrics3'] = true; - } - if (strpos($_REQUEST['unsynchronizedtags'], '1') !== false) { - $TagsToCompare['id3v1'] = true; - } - - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1">Auto-fix empty tags</A><BR><BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - echo '<TR>'; - echo '<TH>View</TH>'; - echo '<TH>Filename</TH>'; - echo '<TH>Combined</TH>'; - if ($TagsToCompare['id3v2']) { - echo '<TH>ID3v2</TH>'; - } - if ($TagsToCompare['ape']) { - echo '<TH>APE</TH>'; - } - if ($TagsToCompare['lyrics3']) { - echo '<TH>Lyrics3</TH>'; - } - if ($TagsToCompare['id3v1']) { - echo '<TH>ID3v1</TH>'; - } - echo '</TR>'; - - $SQLquery = 'SELECT filename, comments_all, comments_id3v2, comments_ape, comments_lyrics3, comments_id3v1'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (fileformat = "mp3")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - while ($row = mysql_fetch_array($result)) { - - set_time_limit(30); - - $FileOK = true; - $Mismatched = array('id3v2'=>false, 'ape'=>false, 'lyrics3'=>false, 'id3v1'=>false); - $SemiMatched = array('id3v2'=>false, 'ape'=>false, 'lyrics3'=>false, 'id3v1'=>false); - $EmptyTags = array('id3v2'=>true, 'ape'=>true, 'lyrics3'=>true, 'id3v1'=>true); - - $Comments['all'] = @unserialize($row['comments_all']); - $Comments['id3v2'] = @unserialize($row['comments_id3v2']); - $Comments['ape'] = @unserialize($row['comments_ape']); - $Comments['lyrics3'] = @unserialize($row['comments_lyrics3']); - $Comments['id3v1'] = @unserialize($row['comments_id3v1']); - - if (isset($Comments['ape']['tracknumber'])) { - $Comments['ape']['track'] = $Comments['ape']['tracknumber']; - unset($Comments['ape']['tracknumber']); - } - - - $FileOK = true; - - $ThisLine = '<TR>'; - $ThisLine .= '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">view</A></TD>'; - $ThisLine .= '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - $tagvalues = ''; - foreach ($FieldsToCompare as $fieldname) { - $tagvalues .= $fieldname.' = '.@implode("\n", @$Comments['all'][$fieldname])."\n"; - } - $ThisLine .= '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?synchronizetagsfrom=all&filename='.urlencode($row['filename']).'" TITLE="'.htmlentities(rtrim($tagvalues, "\n"), ENT_QUOTES).'" TARGET="retagwindow">all</A></TD>'; - foreach ($TagsToCompare as $tagtype => $CompareThisTagType) { - if ($CompareThisTagType) { - $tagvalues = ''; - $tagempty = true; - foreach ($FieldsToCompare as $fieldname) { - - if ($tagtype == 'id3v1') { - - getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v1.php', __FILE__, true); - if (($fieldname == 'genre') && !getid3_id3v1::LookupGenreID(@$Comments['all'][$fieldname][0])) { - // non-standard genres can never match, so just ignore - $tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n"; - } elseif ($fieldname == 'comment') { - if (rtrim(substr(@$Comments[$tagtype][$fieldname][0], 0, 28)) != rtrim(substr(@$Comments['all'][$fieldname][0], 0, 28))) { - $tagvalues .= $fieldname.' = [['.@$Comments[$tagtype][$fieldname][0].']]'."\n"; - if (trim(strtolower(RemoveAccents(substr(@$Comments[$tagtype][$fieldname][0], 0, 28)))) == trim(strtolower(RemoveAccents(substr(@$Comments['all'][$fieldname][0], 0, 28))))) { - $SemiMatched[$tagtype] = true; - } else { - $Mismatched[$tagtype] = true; - } - $FileOK = false; - } else { - $tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n"; - } - } elseif (rtrim(substr(@$Comments[$tagtype][$fieldname][0], 0, 30)) != rtrim(substr(@$Comments['all'][$fieldname][0], 0, 30))) { - $tagvalues .= $fieldname.' = [['.@$Comments[$tagtype][$fieldname][0].']]'."\n"; - if (strtolower(RemoveAccents(trim(substr(@$Comments[$tagtype][$fieldname][0], 0, 30)))) == strtolower(RemoveAccents(trim(substr(@$Comments['all'][$fieldname][0], 0, 30))))) { - $SemiMatched[$tagtype] = true; - } else { - $Mismatched[$tagtype] = true; - } - $FileOK = false; - if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) { - $EmptyTags[$tagtype] = false; - } - } else { - $tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n"; - if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) { - $EmptyTags[$tagtype] = false; - } - } - - } elseif (($tagtype == 'ape') && ($fieldname == 'year')) { - - if ((@$Comments['ape']['date'][0] != @$Comments['all']['year'][0]) && (@$Comments['ape']['year'][0] != @$Comments['all']['year'][0])) { - $tagvalues .= $fieldname.' = [['.@$Comments['ape']['date'][0].']]'."\n"; - $Mismatched[$tagtype] = true; - $FileOK = false; - if (strlen(trim(@$Comments['ape']['date'][0])) > 0) { - $EmptyTags[$tagtype] = false; - } - } else { - $tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n"; - if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) { - $EmptyTags[$tagtype] = false; - } - } - - } elseif (($fieldname == 'genre') && in_array($Comments[$tagtype][$fieldname][0], $Comments['all'][$fieldname])) { - - $tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n"; - if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) { - $EmptyTags[$tagtype] = false; - } - - } elseif (@$Comments[$tagtype][$fieldname][0] != @$Comments['all'][$fieldname][0]) { - - $tagvalues .= $fieldname.' = [['.@$Comments[$tagtype][$fieldname][0].']]'."\n"; - if (trim(strtolower(RemoveAccents(@$Comments[$tagtype][$fieldname][0]))) == trim(strtolower(RemoveAccents(@$Comments['all'][$fieldname][0])))) { - $SemiMatched[$tagtype] = true; - } else { - $Mismatched[$tagtype] = true; - } - $FileOK = false; - if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) { - $EmptyTags[$tagtype] = false; - } - - } else { - - $tagvalues .= $fieldname.' = '.@$Comments[$tagtype][$fieldname][0]."\n"; - if (strlen(trim(@$Comments[$tagtype][$fieldname][0])) > 0) { - $EmptyTags[$tagtype] = false; - } - - } - } - - if ($EmptyTags[$tagtype]) { - $ThisLine .= '<TD BGCOLOR="#0099CC">'; - } elseif ($SemiMatched[$tagtype]) { - $ThisLine .= '<TD BGCOLOR="#FF9999">'; - } elseif ($Mismatched[$tagtype]) { - $ThisLine .= '<TD BGCOLOR="#FF0000">'; - } else { - $ThisLine .= '<TD BGCOLOR="#00CC00">'; - } - $ThisLine .= '<A HREF="'.$_SERVER['PHP_SELF'].'?synchronizetagsfrom='.$tagtype.'&filename='.urlencode($row['filename']).'" TITLE="'.htmlentities(rtrim($tagvalues, "\n"), ENT_QUOTES).'" TARGET="retagwindow">'.$tagtype.'</A>'; - $ThisLine .= '</TD>'; - } - } - $ThisLine .= '</TR>'; - - if (!$FileOK) { - $NotOKfiles++; - - if (!empty($_REQUEST['autofix'])) { - - $AnyMismatched = false; - foreach ($Mismatched as $key => $value) { - if ($value && ($EmptyTags["$key"] === false)) { - $AnyMismatched = true; - } - } - if ($AnyMismatched) { - - echo $ThisLine; - - } else { - - $TagsToSynch = ''; - foreach ($EmptyTags as $key => $value) { - if ($value) { - switch ($key) { - case 'id3v1': - $TagsToSynch .= '1'; - break; - case 'id3v2': - $TagsToSynch .= '2'; - break; - case 'ape': - $TagsToSynch .= 'A'; - break; - } - } - } - $errors = array(); - if (SynchronizeAllTags($row['filename'], 'all', $TagsToSynch, $errors)) { - echo '<TR BGCOLOR="#00CC00">'; - } else { - echo '<TR BGCOLOR="#FF0000">'; - } - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'" TITLE="'.FixTextFields(implode("\n", $errors)).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '<TD><TABLE BORDER="0">'; - echo '<TR><TD><B>'.$TagsToSynch.'</B></TD></TR>'; - echo '</TABLE></TD></TR>'; - } - - } else { - - echo $ThisLine; - - } - } - } - - echo '</TABLE><BR>'; - echo 'Found <B>'.number_format($NotOKfiles).'</B> files with unsynchronzed tags'; - -} elseif (!empty($_REQUEST['filenamepattern'])) { - - $patterns['A'] = 'artist'; - $patterns['T'] = 'title'; - $patterns['M'] = 'album'; - $patterns['N'] = 'track'; - $patterns['G'] = 'genre'; - - $FieldsToUse = explode(' ', wordwrap(eregi_replace('[^A-Z]', '', $_REQUEST['filenamepattern']), 1, ' ', 1)); - foreach ($FieldsToUse as $FieldID) { - $FieldNames[] = $patterns["$FieldID"]; - } - - $SQLquery = 'SELECT filename, fileformat, '.implode(', ', $FieldNames); - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (fileformat NOT LIKE "'.implode('") AND (fileformat NOT LIKE "', $IgnoreNoTagFormats).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - echo 'Files that do not match naming pattern:<BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - 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><BR>(click to rename file to this)</TD></TR>'; - $nonmatchingfilenames = 0; - $Pattern = $_REQUEST['filenamepattern']; - $PatternLength = strlen($Pattern); - while ($row = mysql_fetch_array($result)) { - set_time_limit(10); - $PatternFilename = ''; - for ($i = 0; $i < $PatternLength; $i++) { - if (isset($patterns[$Pattern{$i}])) { - $PatternFilename .= trim(strtr($row[$patterns[$Pattern{$i}]], ':\\/*<>|', ';-~-[] '), ' '); - } else { - $PatternFilename .= $Pattern{$i}; - } - } - - // Replace "~" with "-" if characters immediately before and after are both numbers - // "/" has been replaced with "~" above which is good for multi-song medley dividers, - // but for things like 24/7, 7/8, etc it looks better if it's 24-7, 7-8, etc. - $tildepos = 0; - while ($tildepos = strpos($PatternFilename, '~', $tildepos)) { - if (ereg('[0-9]~[0-9]', substr($PatternFilename, $tildepos - 1, 3))) { - $PatternFilename{$tildepos} = '-'; - } else { - $tildepos++; - } - } - - // get rid of leading & trailing spaces if end items (artist or title for example) are missing - $PatternFilename = str_replace(' "', ' “', $PatternFilename); - $PatternFilename = str_replace('("', '(“', $PatternFilename); - $PatternFilename = str_replace('-"', '-“', $PatternFilename); - $PatternFilename = str_replace('" ', '” ', $PatternFilename.' '); - $PatternFilename = str_replace('"', '”', $PatternFilename); - $PatternFilename = str_replace('?', '', $PatternFilename); - $PatternFilename = str_replace(' ', ' ', $PatternFilename); - $PatternFilename = trim($PatternFilename, ' -'); - $PatternFilename .= '.'.$row['fileformat']; - $ActualFilename = basename($row['filename']); - if ($ActualFilename != $PatternFilename) { - - $NotMatchedReasons = ''; - if (strtolower($ActualFilename) === strtolower($PatternFilename)) { - $NotMatchedReasons .= 'Aa '; - } elseif (RemoveAccents($ActualFilename) === RemoveAccents($PatternFilename)) { - $NotMatchedReasons .= 'ée '; - } - $ShortestName = min(strlen($ActualFilename), strlen($PatternFilename)); - for ($DifferenceOffset = 0; $DifferenceOffset < $ShortestName; $DifferenceOffset++) { - if ($ActualFilename{$DifferenceOffset} !== $PatternFilename{$DifferenceOffset}) { - break; - } - } - echo '<TR>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">view</A></TD>'; - echo '<TD> '.$NotMatchedReasons.'</TD>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">'.FixTextFields($ActualFilename).'</A></TD>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?filenamepattern='.urlencode($_REQUEST['filenamepattern']).'&renamefilefrom='.urlencode($row['filename']).'&renamefileto='.urlencode(dirname($row['filename']).'/'.$PatternFilename).'" TITLE="'.FixTextFields(basename($row['filename']))."\n".FixTextFields(basename($PatternFilename)).'" TARGET="renamewindow">'.substr($PatternFilename, 0, $DifferenceOffset).'<B>'.substr($PatternFilename, $DifferenceOffset).'</B></A></TD>'; - echo '</TR>'; - - $nonmatchingfilenames++; - } - } - echo '</TABLE><BR>'; - echo 'Found '.number_format($nonmatchingfilenames).' files that do not match naming pattern<BR>'; - - -} elseif (!empty($_REQUEST['encoderoptionsdistribution'])) { - - if (isset($_REQUEST['showtagfiles'])) { - $SQLquery = 'SELECT filename, encoder_options FROM `files`'; - $SQLquery .= ' WHERE (encoder_options LIKE "'.mysql_escape_string($_REQUEST['showtagfiles']).'")'; - $SQLquery .= ' AND (fileformat NOT LIKE "'.implode('") AND (fileformat NOT LIKE "', $IgnoreNoTagFormats).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - while ($row = mysql_fetch_array($result)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - exit; - - } else { - - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1">Show all Encoder Options</A><HR>'; - echo 'Files with Encoder Options <B>'.$_REQUEST['showtagfiles'].'</B>:<BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '<TD>'.$row['encoder_options'].'</TD>'; - echo '</TR>'; - } - echo '</TABLE>'; - - } - - } elseif (!isset($_REQUEST['m3u'])) { - - $SQLquery = 'SELECT encoder_options, COUNT(*) AS num FROM `files`'; - $SQLquery .= ' WHERE (fileformat NOT LIKE "'.implode('") AND (fileformat NOT LIKE "', $IgnoreNoTagFormats).'")'; - $SQLquery .= ' GROUP BY encoder_options'; - $SQLquery .= ' ORDER BY (encoder_options LIKE "LAME%") DESC, (encoder_options LIKE "CBR%") DESC, num DESC, encoder_options ASC'; - $result = safe_mysql_query($SQLquery); - echo 'Files with Encoder Options:<BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - echo '<TR><TH>Encoder Options</TH><TH>Count</TH><TH>M3U</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD>'.$row['encoder_options'].'</TD>'; - echo '<TD ALIGN="RIGHT"><A HREF="'.$_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1&showtagfiles='.($row['encoder_options'] ? urlencode($row['encoder_options']) : '').'">'.number_format($row['num']).'</A></TD>'; - echo '<TD ALIGN="RIGHT"><A HREF="'.$_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1&showtagfiles='.($row['encoder_options'] ? urlencode($row['encoder_options']) : '').'&m3u=.m3u">m3u</A></TD>'; - echo '</TR>'; - } - echo '</TABLE><HR>'; - - } - -} elseif (!empty($_REQUEST['tagtypes'])) { - - if (!isset($_REQUEST['m3u'])) { - $SQLquery = 'SELECT tags, COUNT(*) AS num FROM `files`'; - $SQLquery .= ' WHERE (fileformat NOT LIKE "'.implode('") AND (fileformat NOT LIKE "', $IgnoreNoTagFormats).'")'; - $SQLquery .= ' GROUP BY tags'; - $SQLquery .= ' ORDER BY num DESC'; - $result = safe_mysql_query($SQLquery); - echo 'Files with tags:<BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - echo '<TR><TH>Tags</TH><TH>Count</TH><TH>M3U</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD>'.$row['tags'].'</TD>'; - echo '<TD ALIGN="RIGHT"><A HREF="'.$_SERVER['PHP_SELF'].'?tagtypes=1&showtagfiles='.($row['tags'] ? urlencode($row['tags']) : '').'">'.number_format($row['num']).'</A></TD>'; - echo '<TD ALIGN="RIGHT"><A HREF="'.$_SERVER['PHP_SELF'].'?tagtypes=1&showtagfiles='.($row['tags'] ? urlencode($row['tags']) : '').'&m3u=.m3u">m3u</A></TD>'; - echo '</TR>'; - } - echo '</TABLE><HR>'; - } - - if (isset($_REQUEST['showtagfiles'])) { - $SQLquery = 'SELECT filename, tags FROM `files`'; - $SQLquery .= ' WHERE (tags LIKE "'.mysql_escape_string($_REQUEST['showtagfiles']).'")'; - $SQLquery .= ' AND (fileformat NOT LIKE "'.implode('") AND (fileformat NOT LIKE "', $IgnoreNoTagFormats).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - while ($row = mysql_fetch_array($result)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - exit; - - } else { - - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '<TD>'.$row['tags'].'</TD>'; - echo '</TR>'; - } - echo '</TABLE>'; - - } - } - - -} elseif (!empty($_REQUEST['md5datadupes'])) { - - $OtherFormats = ''; - $AVFormats = ''; - - $SQLquery = 'SELECT md5_data, filename, COUNT(*) AS num'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (md5_data <> "")'; - $SQLquery .= ' GROUP BY md5_data'; - $SQLquery .= ' ORDER BY num DESC'; - $result = safe_mysql_query($SQLquery); - while (($row = mysql_fetch_array($result)) && ($row['num'] > 1)) { - set_time_limit(30); - - $filenames = array(); - $tags = array(); - $md5_data = array(); - $SQLquery = 'SELECT fileformat, filename, tags FROM `files`'; - $SQLquery .= ' WHERE (md5_data = "'.mysql_escape_string($row['md5_data']).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result2 = safe_mysql_query($SQLquery); - while ($row2 = mysql_fetch_array($result2)) { - $thisfileformat = $row2['fileformat']; - $filenames[] = $row2['filename']; - $tags[] = $row2['tags']; - $md5_data[] = $row['md5_data']; - } - - $thisline = '<TR>'; - $thisline .= '<TD VALIGN="TOP" STYLE="font-family: monospace;">'.implode('<BR>', $md5_data).'</TD>'; - $thisline .= '<TD VALIGN="TOP" NOWRAP>'.implode('<BR>', $tags).'</TD>'; - $thisline .= '<TD VALIGN="TOP">'.implode('<BR>', $filenames).'</TD>'; - $thisline .= '</TR>'; - - if (in_array($thisfileformat, $IgnoreNoTagFormats)) { - $OtherFormats .= $thisline; - } else { - $AVFormats .= $thisline; - } - } - echo 'Duplicated MD5_DATA (Audio/Video files):<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="2">'; - echo $AVFormats.'</TABLE><HR>'; - echo 'Duplicated MD5_DATA (Other files):<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="2">'; - echo $OtherFormats.'</TABLE><HR>'; - - -} elseif (!empty($_REQUEST['artisttitledupes'])) { - - if (isset($_REQUEST['m3uartist']) && isset($_REQUEST['m3utitle'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - $SQLquery = 'SELECT filename FROM `files`'; - $SQLquery .= ' WHERE (artist = "'.mysql_escape_string($_REQUEST['m3uartist']).'")'; - $SQLquery .= ' AND (title = "'.mysql_escape_string($_REQUEST['m3utitle']).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - while ($row = mysql_fetch_array($result)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - exit; - - } - - $SQLquery = 'SELECT artist, title, filename, COUNT(*) AS num FROM `files`'; - $SQLquery .= ' WHERE (artist <> "")'; - $SQLquery .= ' AND (title <> "")'; - $SQLquery .= ' GROUP BY artist, title'; - $SQLquery .= ' ORDER BY num DESC, artist ASC, title ASC'; - $result = safe_mysql_query($SQLquery); - $uniquetitles = 0; - $uniquefiles = 0; - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - while (($row = mysql_fetch_array($result)) && ($row['num'] > 1)) { - $SQLquery = 'SELECT filename FROM `files`'; - $SQLquery .= ' WHERE (artist = "'.mysql_escape_string($row['artist']).'")'; - $SQLquery .= ' AND (title = "'.mysql_escape_string($row['title']).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result2 = safe_mysql_query($SQLquery); - while ($row2 = mysql_fetch_array($result2)) { - echo WindowsShareSlashTranslate($row2['filename'])."\n"; - } - } - exit; - - } else { - - echo 'Duplicated aritst + title:<BR>'; - echo '(<A HREF="'.$_SERVER['PHP_SELF'].'?artisttitledupes=1&m3u=.m3u">.m3u version</A>)<BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="2">'; - - while (($row = mysql_fetch_array($result)) && ($row['num'] > 1)) { - $uniquetitles++; - set_time_limit(30); - - $filenames = array(); - $artists = array(); - $titles = array(); - $bitrates = array(); - $playtimes = array(); - $SQLquery = 'SELECT filename, artist, title, audio_bitrate, vbr_method, playtime_seconds, encoder_options FROM `files`'; - $SQLquery .= ' WHERE (artist = "'.mysql_escape_string($row['artist']).'")'; - $SQLquery .= ' AND (title = "'.mysql_escape_string($row['title']).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result2 = safe_mysql_query($SQLquery); - while ($row2 = mysql_fetch_array($result2)) { - $uniquefiles++; - $filenames[] = $row2['filename']; - $artists[] = $row2['artist']; - $titles[] = $row2['title']; - if ($row2['vbr_method']) { - $bitrates[] = '<B'.($row2['encoder_options'] ? ' STYLE="text-decoration: underline; cursor: help;" TITLE="'.$row2['encoder_options'] : '').'">'.BitrateText($row2['audio_bitrate'] / 1000).'</B>'; - } else { - $bitrates[] = BitrateText($row2['audio_bitrate'] / 1000); - } - $playtimes[] = getid3_lib::PlaytimeString($row2['playtime_seconds']); - } - - echo '<TR>'; - echo '<TD NOWRAP VALIGN="TOP">'; - foreach ($filenames as $file) { - echo '<A HREF="demo.browse.php?deletefile='.urlencode($file).'&noalert=1" onClick="return confirm(\'Are you sure you want to delete '.addslashes($file).'? \n(this action cannot be un-done)\');" TITLE="Permanently delete '."\n".FixTextFields($file)."\n".'" TARGET="deletedupewindow">delete</A><BR>'; - } - echo '</TD>'; - echo '<TD NOWRAP VALIGN="TOP">'; - foreach ($filenames as $file) { - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($file).'">play</A><BR>'; - } - echo '</TD>'; - echo '<TD VALIGN="MIDDLE" ALIGN="CENTER" ><A HREF="'.$_SERVER['PHP_SELF'].'?artisttitledupes=1&m3uartist='.urlencode($artists[0]).'&m3utitle='.urlencode($titles[0]).'">play all</A></TD>'; - echo '<TD VALIGN="TOP" NOWRAP>'.implode('<BR>', $artists).'</TD>'; - echo '<TD VALIGN="TOP" NOWRAP>'.implode('<BR>', $titles).'</TD>'; - echo '<TD VALIGN="TOP" NOWRAP ALIGN="RIGHT">'.implode('<BR>', $bitrates).'</TD>'; - echo '<TD VALIGN="TOP" NOWRAP ALIGN="RIGHT">'.implode('<BR>', $playtimes).'</TD>'; - - echo '<TD VALIGN="TOP" NOWRAP ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">'; - foreach ($filenames as $file) { - echo '<TR><TD NOWRAP ALIGN="RIGHT"><A HREF="demo.browse.php?filename='.rawurlencode($file).'"><SPAN STYLE="color: #339966;">'.dirname($file).'/</SPAN>'.basename($file).'</A></TD></TR>'; - } - echo '</TABLE></TD>'; - - echo '</TR>'; - } - - } - echo '</TABLE>'; - echo number_format($uniquefiles).' files with '.number_format($uniquetitles).' unique <I>aritst + title</I><BR>'; - echo '<HR>'; - -} elseif (!empty($_REQUEST['filetypelist'])) { - - list($fileformat, $audioformat) = explode('|', $_REQUEST['filetypelist']); - $SQLquery = 'SELECT filename, fileformat, audio_dataformat'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (fileformat = "'.mysql_escape_string($fileformat).'")'; - $SQLquery .= ' AND (audio_dataformat = "'.mysql_escape_string($audioformat).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - echo 'Files of format <B>'.$fileformat.'.'.$audioformat.'</B>:<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="4">'; - echo '<TR><TH>file</TH><TH>audio</TH><TH>filename</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD>'.$row['fileformat'].'</TD>'; - echo '<TD>'.$row['audio_dataformat'].'</TD>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '</TR>'; - } - echo '</TABLE><HR>'; - -} elseif (!empty($_REQUEST['trackinalbum'])) { - - $SQLquery = 'SELECT filename, album'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (album LIKE "% [%")'; - $SQLquery .= ' ORDER BY album ASC, filename ASC'; - $result = safe_mysql_query($SQLquery); - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - while ($row = mysql_fetch_array($result)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - exit; - - } elseif (!empty($_REQUEST['autofix'])) { - - getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v1.php', __FILE__, true); - getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v2.php', __FILE__, true); - - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - $ThisFileInfo = $getID3->analyze($filename); - getid3_lib::CopyTagsToComments($ThisFileInfo); - - if (!empty($ThisFileInfo['tags'])) { - - $Album = trim(str_replace(strstr($ThisFileInfo['comments']['album'][0], ' ['), '', $ThisFileInfo['comments']['album'][0])); - $Track = (string) intval(str_replace(' [', '', str_replace(']', '', strstr($ThisFileInfo['comments']['album'][0], ' [')))); - if ($Track == '0') { - $Track = ''; - } - if ($Album && $Track) { - echo '<HR>'.FixTextFields($row['filename']).'<BR>'; - echo '<I>'.$Album.'</I> (track #'.$Track.')<BR>'; - echo '<B>ID3v2:</B> '.(RemoveID3v2($row['filename'], false) ? 'removed' : 'REMOVAL FAILED!').', '; - 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>'; - } else { - echo ' . '; - } - - } else { - - echo '<HR>FAILED<BR>'.FixTextFields($row['filename']).'<HR>'; - - } - flush(); - } - - } else { - - echo '<B>'.number_format(mysql_num_rows($result)).'</B> files with <B>[??]</B>-format track numbers in album field:<BR>'; - if (mysql_num_rows($result) > 0) { - echo '(<A HREF="'.$_SERVER['PHP_SELF'].'?trackinalbum=1&m3u=.m3u">.m3u version</A>)<BR>'; - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?trackinalbum=1&autofix=1">Try to auto-fix</A><BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="4">'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD>'.$row['album'].'</TD>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '</TR>'; - } - echo '</TABLE>'; - } - echo '<HR>'; - - } - -} elseif (!empty($_REQUEST['fileextensions'])) { - - $SQLquery = 'SELECT filename, fileformat, audio_dataformat, video_dataformat, tags'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - $invalidextensionfiles = 0; - $invalidextensionline = '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="4">'; - $invalidextensionline .= '<TR><TH>file</TH><TH>audio</TH><TH>video</TH><TH>tags</TH><TH>actual</TH><TH>correct</TH><TH>filename</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - - $acceptableextensions = AcceptableExtensions($row['fileformat'], $row['audio_dataformat'], $row['video_dataformat']); - $actualextension = strtolower(fileextension($row['filename'])); - if ($acceptableextensions && !in_array($actualextension, $acceptableextensions)) { - $invalidextensionfiles++; - - $invalidextensionline .= '<TR>'; - $invalidextensionline .= '<TD>'.$row['fileformat'].'</TD>'; - $invalidextensionline .= '<TD>'.$row['audio_dataformat'].'</TD>'; - $invalidextensionline .= '<TD>'.$row['video_dataformat'].'</TD>'; - $invalidextensionline .= '<TD>'.$row['tags'].'</TD>'; - $invalidextensionline .= '<TD>'.$actualextension.'</TD>'; - $invalidextensionline .= '<TD>'.implode('; ', $acceptableextensions).'</TD>'; - $invalidextensionline .= '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - $invalidextensionline .= '</TR>'; - } - } - $invalidextensionline .= '</TABLE><HR>'; - echo number_format($invalidextensionfiles).' files with incorrect filename extension:<BR>'; - echo $invalidextensionline; - -} elseif (isset($_REQUEST['genredistribution'])) { - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - $SQLquery = 'SELECT filename'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (BINARY genre = "'.$_REQUEST['genredistribution'].'")'; - $SQLquery .= ' AND (fileformat NOT LIKE "'.implode('") AND (fileformat NOT LIKE "', $IgnoreNoTagFormats).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - while ($row = mysql_fetch_array($result)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - exit; - - } else { - - if ($_REQUEST['genredistribution'] == '%') { - - $SQLquery = 'SELECT COUNT(*) AS num, genre'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (fileformat NOT LIKE "'.implode('") AND (fileformat NOT LIKE "', $IgnoreNoTagFormats).'")'; - $SQLquery .= ' GROUP BY genre'; - $SQLquery .= ' ORDER BY num DESC'; - $result = safe_mysql_query($SQLquery); - getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'module.tag.id3v1.php', __FILE__, true); - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="4">'; - echo '<TR><TH>Count</TH><TH>Genre</TH><TH>m3u</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - $GenreID = getid3_id3v1::LookupGenreID($row['genre']); - if (is_numeric($GenreID)) { - echo '<TR BGCOLOR="#00FF00;">'; - } else { - echo '<TR BGCOLOR="#FF9999;">'; - } - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?genredistribution='.urlencode($row['genre']).'">'.number_format($row['num']).'</A></TD>'; - echo '<TD NOWRAP>'.str_replace("\t", '<BR>', $row['genre']).'</TD>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3u=.m3u&genredistribution='.urlencode($row['genre']).'">.m3u</A></TD>'; - echo '</TR>'; - } - echo '</TABLE><HR>'; - - } else { - - $SQLquery = 'SELECT filename, genre'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (genre LIKE "'.mysql_escape_string($_REQUEST['genredistribution']).'")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - echo '<A HREF="'.$_SERVER['PHP_SELF'].'?genredistribution='.urlencode('%').'">All Genres</A><BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="4">'; - echo '<TR><TH>Genre</TH><TH>m3u</TH><TH>Filename</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD NOWRAP>'.str_replace("\t", '<BR>', $row['genre']).'</TD>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</A></TD>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '</TR>'; - } - echo '</TABLE><HR>'; - - } - - - } - -} elseif (!empty($_REQUEST['formatdistribution'])) { - - $SQLquery = 'SELECT fileformat, audio_dataformat, COUNT(*) AS num'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' GROUP BY fileformat, audio_dataformat'; - $SQLquery .= ' ORDER BY num DESC'; - $result = safe_mysql_query($SQLquery); - echo 'File format distribution:<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="4">'; - echo '<TR><TH>Number</TH><TH>Format</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD ALIGN="RIGHT">'.number_format($row['num']).'</TD>'; - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?filetypelist='.$row['fileformat'].'|'.$row['audio_dataformat'].'">'.($row['fileformat'] ? $row['fileformat'] : '<I>unknown</I>').(($row['audio_dataformat'] && ($row['audio_dataformat'] != $row['fileformat'])) ? '.'.$row['audio_dataformat'] : '').'</A></TD>'; - echo '</TR>'; - } - echo '</TABLE><HR>'; - -} elseif (!empty($_REQUEST['errorswarnings'])) { - - $SQLquery = 'SELECT filename, error, warning'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (error <> "")'; - $SQLquery .= ' OR (warning <> "")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - - if (!empty($_REQUEST['m3u'])) { - - header('Content-type: audio/x-mpegurl'); - echo '#EXTM3U'."\n"; - while ($row = mysql_fetch_array($result)) { - echo WindowsShareSlashTranslate($row['filename'])."\n"; - } - exit; - - } else { - - echo number_format(mysql_num_rows($result)).' files with errors or warnings:<BR>'; - echo '(<A HREF="'.$_SERVER['PHP_SELF'].'?errorswarnings=1&m3u=.m3u">.m3u version</A>)<BR>'; - echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="4">'; - echo '<TR><TH>Filename</TH><TH>Error</TH><TH>Warning</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD>'; - echo '<TD>'.(!empty($row['error']) ? '<LI>'.str_replace("\t", '<LI>', FixTextFields($row['error'])).'</LI>' : ' ').'</TD>'; - echo '<TD>'.(!empty($row['warning']) ? '<LI>'.str_replace("\t", '<LI>', FixTextFields($row['warning'])).'</LI>' : ' ').'</TD>'; - echo '</TR>'; - } - } - echo '</TABLE><HR>'; - -} elseif (!empty($_REQUEST['fixid3v1padding'])) { - - getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'write.id3v1.php', __FILE__, true); - $id3v1_writer = new getid3_write_id3v1; - - $SQLquery = 'SELECT filename, error, warning'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (fileformat = "mp3")'; - $SQLquery .= ' AND ((error <> "")'; - $SQLquery .= ' OR (warning <> ""))'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - $totaltofix = mysql_num_rows($result); - $rowcounter = 0; - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - if (strpos($row['warning'], 'Some ID3v1 fields do not use NULL characters for padding') !== false) { - set_time_limit(30); - $id3v1_writer->filename = $row['filename']; - echo ($id3v1_writer->FixID3v1Padding() ? '<SPAN STYLE="color: #009900;">fixed - ' : '<SPAN STYLE="color: #FF0000;">error - '); - } else { - echo '<SPAN STYLE="color: #0000FF;">No error? - '; - } - echo '['.++$rowcounter.' / '.$totaltofix.'] '; - echo FixTextFields($row['filename']).'</SPAN><BR>'; - flush(); - } - -} elseif (!empty($_REQUEST['vbrmethod'])) { - - if ($_REQUEST['vbrmethod'] == '1') { - - $SQLquery = 'SELECT COUNT(*) AS num, vbr_method'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' GROUP BY vbr_method'; - $SQLquery .= ' ORDER BY vbr_method'; - $result = safe_mysql_query($SQLquery); - echo 'VBR methods:<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="4">'; - echo '<TR><TH>Count</TH><TH>VBR Method</TH></TR>'; - while ($row = mysql_fetch_array($result)) { - echo '<TR>'; - echo '<TD ALIGN="RIGHT">'.FixTextFields(number_format($row['num'])).'</TD>'; - if ($row['vbr_method']) { - echo '<TD><A HREF="'.$_SERVER['PHP_SELF'].'?vbrmethod='.$row['vbr_method'].'">'.FixTextFields($row['vbr_method']).'</A></TD>'; - } else { - echo '<TD><I>CBR</I></TD>'; - } - echo '</TR>'; - } - echo '</TABLE>'; - - } else { - - $SQLquery = 'SELECT filename'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (vbr_method = "'.mysql_escape_string($_REQUEST['vbrmethod']).'")'; - $result = safe_mysql_query($SQLquery); - echo number_format(mysql_num_rows($result)).' files with VBR_method of "'.$_REQUEST['vbrmethod'].'":<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; - while ($row = mysql_fetch_array($result)) { - echo '<TR><TD><A HREF="'.$_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']).'">m3u</A></TD>'; - echo '<TD><A HREF="demo.browse.php?filename='.rawurlencode($row['filename']).'">'.FixTextFields($row['filename']).'</A></TD></TR>'; - } - echo '</TABLE>'; - - } - echo '<HR>'; - -} elseif (!empty($_REQUEST['correctcase'])) { - - $SQLquery = 'SELECT filename, fileformat'; - $SQLquery .= ' FROM `files`'; - $SQLquery .= ' WHERE (fileformat <> "")'; - $SQLquery .= ' ORDER BY filename ASC'; - $result = safe_mysql_query($SQLquery); - 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>'; - echo '<PRE>'; - $lastdir = ''; - while ($row = mysql_fetch_array($result)) { - set_time_limit(30); - $CleanedFilename = CleanUpFileName($row['filename']); - if ($row['filename'] != $CleanedFilename) { - if (strtolower($lastdir) != strtolower(str_replace('/', '\\', dirname($row['filename'])))) { - $lastdir = str_replace('/', '\\', dirname($row['filename'])); - echo 'cd "'.$lastdir.'"'."\n"; - } - echo 'ren "'.basename($row['filename']).'" "'.basename(CleanUpFileName($row['filename'])).'"'."\n"; - } - } - echo '</PRE>'; - echo '<HR>'; - -} - -function CleanUpFileName($filename) { - $DirectoryName = dirname($filename); - $FileExtension = fileextension(basename($filename)); - $BaseFilename = basename($filename, '.'.$FileExtension); - - $BaseFilename = strtolower($BaseFilename); - $BaseFilename = str_replace('_', ' ', $BaseFilename); - //$BaseFilename = str_replace('-', ' - ', $BaseFilename); - $BaseFilename = str_replace('(', ' (', $BaseFilename); - $BaseFilename = str_replace('( ', '(', $BaseFilename); - $BaseFilename = str_replace(')', ') ', $BaseFilename); - $BaseFilename = str_replace(' )', ')', $BaseFilename); - $BaseFilename = str_replace(' \'\'', ' “', $BaseFilename); - $BaseFilename = str_replace('\'\' ', '” ', $BaseFilename); - $BaseFilename = str_replace(' vs ', ' vs. ', $BaseFilename); - while (strstr($BaseFilename, ' ') !== false) { - $BaseFilename = str_replace(' ', ' ', $BaseFilename); - } - $BaseFilename = trim($BaseFilename); - - return $DirectoryName.'/'.BetterUCwords($BaseFilename).'.'.strtolower($FileExtension); -} - -function BetterUCwords($string) { - $stringlength = strlen($string); - - $string{0} = strtoupper($string{0}); - for ($i = 1; $i < $stringlength; $i++) { - if (($string{$i - 1} == '\'') && ($i > 1) && (($string{$i - 2} == 'O') || ($string{$i - 2} == ' '))) { - // O'Clock, 'Em - $string{$i} = strtoupper($string{$i}); - } elseif (ereg('^[\'A-Za-z0-9À-ÿ]$', $string{$i - 1})) { - $string{$i} = strtolower($string{$i}); - } else { - $string{$i} = strtoupper($string{$i}); - } - } - - static $LowerCaseWords = array('vs.', 'feat.'); - static $UpperCaseWords = array('DJ', 'USA', 'II', 'MC', 'CD', 'TV', '\'N\''); - - $OutputListOfWords = array(); - $ListOfWords = explode(' ', $string); - foreach ($ListOfWords as $ThisWord) { - if (in_array(strtolower(str_replace('(', '', $ThisWord)), $LowerCaseWords)) { - $ThisWord = strtolower($ThisWord); - } elseif (in_array(strtoupper(str_replace('(', '', $ThisWord)), $UpperCaseWords)) { - $ThisWord = strtoupper($ThisWord); - } elseif ((substr($ThisWord, 0, 2) == 'Mc') && (strlen($ThisWord) > 2)) { - $ThisWord{2} = strtoupper($ThisWord{2}); - } elseif ((substr($ThisWord, 0, 3) == 'Mac') && (strlen($ThisWord) > 3)) { - $ThisWord{3} = strtoupper($ThisWord{3}); - } - $OutputListOfWords[] = $ThisWord; - } - $UCstring = implode(' ', $OutputListOfWords); - $UCstring = str_replace(' From “', ' from “', $UCstring); - $UCstring = str_replace(' \'n\' ', ' \'N\' ', $UCstring); - - return $UCstring; -} - - - -echo '<HR><FORM ACTION="'.FixTextFields($_SERVER['PHP_SELF']).'">'; -echo '<B>Warning:</B> Scanning a new directory will erase all previous entries in the database!<BR>'; -echo 'Directory: <INPUT TYPE="TEXT" NAME="scan" VALUE="'.FixTextFields(!empty($_REQUEST['scan']) ? $_REQUEST['scan'] : '').'"> '; -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?\');">'; -echo '</FORM>'; -echo '<HR><FORM ACTION="'.FixTextFields($_SERVER['PHP_SELF']).'">'; -echo 'Re-scanning a new directory will only add new, previously unscanned files into the list (and not erase the database).<BR>'; -echo 'Directory: <INPUT TYPE="TEXT" NAME="newscan" VALUE="'.FixTextFields(!empty($_REQUEST['newscan']) ? $_REQUEST['newscan'] : '').'"> '; -echo '<INPUT TYPE="SUBMIT" VALUE="Go">'; -echo '</FORM><HR>'; -echo '<UL>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?deadfilescheck=1">Remove deleted or changed files from database</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?md5datadupes=1">List files with identical MD5_DATA values</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?artisttitledupes=1">List files with identical artist + title</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?fileextensions=1">File with incorrect file extension</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?formatdistribution=1">File Format Distribution</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?audiobitrates=1">Audio Bitrate Distribution</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?vbrmethod=1">VBR_Method Distribution</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?tagtypes=1">Tag Type Distribution</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?genredistribution='.urlencode('%').'">Genre Distribution</A></LI>'; -//echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?missingtrackvolume=1">Scan for missing track volume information (update database from pre-v1.7.0b5)</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1">Encoder Options Distribution</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%').'">Encoded By (ID3v2) Distribution</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?trackinalbum=1">Track number in Album field</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?emptygenres=1">Blank genres</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?trackzero=1">Track "zero"</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?nonemptycomments=1">non-empty comments</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?unsynchronizedtags=2A1">Tags that are not synchronized</A> (<A HREF="'.$_SERVER['PHP_SELF'].'?unsynchronizedtags=2A1&autofix=1">autofix</A>)</LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?filenamepattern='.urlencode('A - T').'">Filenames that don\'t match pattern</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?correctcase=1">Correct filename case (Win/DOS)</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?fixid3v1padding=1">Fix ID3v1 invalid padding</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?errorswarnings=1">Files with Errors and/or Warnings</A></LI>'; -echo '<LI><A HREF="'.$_SERVER['PHP_SELF'].'?rescanerrors=1">Re-scan only files with Errors and/or Warnings</A></LI>'; -echo '</UL>'; - -$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 FROM `files`'; -$result = mysql_query($SQLquery); -if ($row = mysql_fetch_array($result)) { - echo '<HR><B>Currently in the database:</B><TABLE>'; - echo '<TR><TH ALIGN="LEFT">Total Files</TH><TD>'.number_format($row['TotalFiles']).'</TD></TR>'; - echo '<TR><TH ALIGN="LEFT">Total Filesize</TH><TD>'.number_format($row['TotalFilesize'] / 1048576).' MB</TD></TR>'; - echo '<TR><TH ALIGN="LEFT">Total Playtime</TH><TD>'.number_format($row['TotalPlaytime'] / 3600, 1).' hours</TD></TR>'; - echo '<TR><TH ALIGN="LEFT">Average Filesize</TH><TD>'.number_format($row['AvgFilesize'] / 1048576, 1).' MB</TD></TR>'; - echo '<TR><TH ALIGN="LEFT">Average Playtime</TH><TD>'.getid3_lib::PlaytimeString($row['AvgPlaytime']).'</TD></TR>'; - echo '<TR><TH ALIGN="LEFT">Average Bitrate</TH><TD>'.BitrateText($row['AvgBitrate'] / 1000, 1).'</TD></TR>'; - echo '</TABLE>'; -} - -?> -</BODY> -</HTML>
\ No newline at end of file diff --git a/modules/id3/demos/demo.simple.php b/modules/id3/demos/demo.simple.php deleted file mode 100644 index db937f1e..00000000 --- a/modules/id3/demos/demo.simple.php +++ /dev/null @@ -1,53 +0,0 @@ -<?php -///////////////////////////////////////////////////////////////// -/// getID3() by James Heinrich <info@getid3.org> // -// available at http://getid3.sourceforge.net // -// or http://www.getid3.org // -///////////////////////////////////////////////////////////////// -// // -// /demo/demo.simple.php - part of getID3() // -// Sample script for scanning a single directory and // -// displaying a few pieces of information for each file // -// See readme.txt for more details // -// /// -///////////////////////////////////////////////////////////////// - -echo '<HTML><HEAD>'; -echo '<TITLE>getID3() - /demo/demo.simple.php (sample script)</TITLE>'; -echo '<STYLE>BODY,TD,TH { font-family: sans-serif; font-size: 9pt; }</STYLE>'; -echo '</HEAD><BODY>'; - - -// include getID3() library (can be in a different directory if full path is specified) -require_once('../getid3/getid3.php'); - -// Initialize getID3 engine -$getID3 = new getID3; - -$DirectoryToScan = '/change/to/directory/you/want/to/scan'; // change to whatever directory you want to scan -$dir = opendir($DirectoryToScan); -echo '<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="3">'; -echo '<TR><TH>Filename</TH><TH>Artist</TH><TH>Title</TH><TH>Bitrate</TH><TH>Playtime</TH></TR>'; -while (($file = readdir($dir)) !== false) { - $FullFileName = realpath($DirectoryToScan.'/'.$file); - if (is_file($FullFileName)) { - set_time_limit(30); - - $ThisFileInfo = $getID3->analyze($FullFileName); - - getid3_lib::CopyTagsToComments($ThisFileInfo); - - // output desired information in whatever format you want - echo '<TR>'; - echo '<TD>'.$ThisFileInfo['filenamepath'].'</TD>'; - echo '<TD>'.(!empty($ThisFileInfo['comments_html']['artist']) ? implode('<BR>', $ThisFileInfo['comments_html']['artist']) : ' ').'</TD>'; - echo '<TD>'.(!empty($ThisFileInfo['comments_html']['title']) ? implode('<BR>', $ThisFileInfo['comments_html']['title']) : ' ').'</TD>'; - echo '<TD ALIGN="RIGHT">'.(!empty($ThisFileInfo['audio']['bitrate']) ? round($ThisFileInfo['audio']['bitrate'] / 1000).' kbps' : ' ').'</TD>'; - echo '<TD ALIGN="RIGHT">'.(!empty($ThisFileInfo['playtime_string']) ? $ThisFileInfo['playtime_string'] : ' ').'</TD>'; - echo '</TR>'; - } -} - -?> -</BODY> -</HTML>
\ No newline at end of file diff --git a/modules/id3/demos/demo.write.php b/modules/id3/demos/demo.write.php deleted file mode 100644 index 40a6e630..00000000 --- a/modules/id3/demos/demo.write.php +++ /dev/null @@ -1,254 +0,0 @@ -<HTML> -<HEAD> -<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"/> -<TITLE>getID3() - Sample tag writer</TITLE> -</HEAD> -<BODY> -<?php -///////////////////////////////////////////////////////////////// -/// getID3() by James Heinrich <info@getid3.org> // -// available at http://getid3.sourceforge.net // -// or http://www.getid3.org // -///////////////////////////////////////////////////////////////// -// // -// /demo/demo.write.php - part of getID3() // -// sample script for demonstrating writing ID3v1 and ID3v2 // -// tags for MP3, or Ogg comment tags for Ogg Vorbis // -// See readme.txt for more details // -// /// -///////////////////////////////////////////////////////////////// - -require_once('../getid3/getid3.php'); -// Initialize getID3 engine -$getID3 = new getID3; - -getid3_lib::IncludeDependency(GETID3_INCLUDEPATH.'write.php', __FILE__, true); - - -function FixTextFields($text) { - return htmlentities(getid3_lib::SafeStripSlashes($text), ENT_QUOTES); -} - -$Filename = (isset($_REQUEST['Filename']) ? getid3_lib::SafeStripSlashes($_REQUEST['Filename']) : ''); - - - -if (isset($_POST['WriteTags'])) { - - $TagFormatsToWrite = (isset($_POST['TagFormatsToWrite']) ? $_POST['TagFormatsToWrite'] : array()); - if (!empty($TagFormatsToWrite)) { - echo 'starting to write tag(s)<BR>'; - - $tagwriter = new getid3_writetags; - $tagwriter->filename = $Filename; - $tagwriter->tagformats = $TagFormatsToWrite; - $tagwriter->overwrite_tags = true; - $tagwriter->tag_encoding = 'UTF-8'; // this is set in the META tag at the top of this file - - $commonkeysarray = array('Title', 'Artist', 'Album', 'Year', 'Comment'); - foreach ($commonkeysarray as $key) { - if (!empty($_POST[$key])) { - $TagData[strtolower($key)][] = getid3_lib::SafeStripSlashes($_POST[$key]); - } - } - if (!empty($_POST['Genre'])) { - $TagData['genre'][] = getid3_lib::SafeStripSlashes($_POST['Genre']); - } - if (!empty($_POST['GenreOther'])) { - $TagData['genre'][] = getid3_lib::SafeStripSlashes($_POST['GenreOther']); - } - if (!empty($_POST['Track'])) { - $TagData['track'][] = getid3_lib::SafeStripSlashes($_POST['Track'].(!empty($_POST['TracksTotal']) ? '/'.$_POST['TracksTotal'] : '')); - } - - if (!empty($_FILES['userfile']['tmp_name'])) { - if (in_array('id3v2.4', $tagwriter->tagformats) || in_array('id3v2.3', $tagwriter->tagformats) || in_array('id3v2.2', $tagwriter->tagformats)) { - if (is_uploaded_file($_FILES['userfile']['tmp_name'])) { - if ($fd = @fopen($_FILES['userfile']['tmp_name'], 'rb')) { - $APICdata = fread($fd, filesize($_FILES['userfile']['tmp_name'])); - fclose ($fd); - - list($APIC_width, $APIC_height, $APIC_imageTypeID) = GetImageSize($_FILES['userfile']['tmp_name']); - $imagetypes = array(1=>'gif', 2=>'jpeg', 3=>'png'); - if (isset($imagetypes[$APIC_imageTypeID])) { - - $TagData['attached_picture'][0]['data'] = $APICdata; - $TagData['attached_picture'][0]['picturetypeid'] = $_POST['APICpictureType']; - $TagData['attached_picture'][0]['description'] = $_FILES['userfile']['name']; - $TagData['attached_picture'][0]['mime'] = 'image/'.$imagetypes[$APIC_imageTypeID]; - - } else { - echo '<B>invalid image format (only GIF, JPEG, PNG)</B><BR>'; - } - } else { - echo '<B>cannot open '.$_FILES['userfile']['tmp_name'].'</B><BR>'; - } - } else { - echo '<B>!is_uploaded_file('.$_FILES['userfile']['tmp_name'].')</B><BR>'; - } - } else { - echo '<B>WARNING:</B> Can only embed images for ID3v2<BR>'; - } - } - - $tagwriter->tag_data = $TagData; - if ($tagwriter->WriteTags()) { - echo 'Successfully wrote tags<BR>'; - if (!empty($tagwriter->warnings)) { - echo 'There were some warnings:<BLOCKQUOTE STYLE="background-color:#FFCC33; padding: 10px;">'.implode('<BR><BR>', $tagwriter->warnings).'</BLOCKQUOTE>'; - } - } else { - echo 'Failed to write tags!<BLOCKQUOTE STYLE="background-color:#FF9999; padding: 10px;">'.implode('<BR><BR>', $tagwriter->errors).'</BLOCKQUOTE>'; - } - - } else { - - echo 'WARNING: no tag formats selected for writing - nothing written'; - - } - echo '<HR>'; - -} - -echo '<H4>Sample tag editor/writer</H4>'; -echo '<A HREF="demo.check.php?listdirectory='.rawurlencode(realpath(dirname($Filename))).'">Browse current directory</A><BR>'; -if (!empty($Filename)) { - echo '<A HREF="'.$_SERVER['PHP_SELF'].'">Start Over</A><BR><BR>'; - echo '<TABLE BORDER="3" CELLSPACING="0" CELLPADDING="4"><FORM ACTION="'.$_SERVER['PHP_SELF'].'" METHOD="POST" ENCTYPE="multipart/form-data">'; - echo '<TR><TD ALIGN="RIGHT"><B>Filename: </B></TD><TD><INPUT TYPE="HIDDEN" NAME="Filename" VALUE="'.FixTextFields($Filename).'"><A HREF="demo.check.php?filename='.rawurlencode($Filename).'" TARGET="_blank">'.$Filename.'</A></TD></TR>'; - if (file_exists($Filename)) { - - // Initialize getID3 engine - $getID3 = new getID3; - $OldThisFileInfo = $getID3->analyze($Filename); - getid3_lib::CopyTagsToComments($OldThisFileInfo); - - switch ($OldThisFileInfo['fileformat']) { - case 'mp3': - case 'mp2': - case 'mp1': - $ValidTagTypes = array('id3v1', 'id3v2.3', 'ape'); - break; - - case 'mpc': - $ValidTagTypes = array('ape'); - break; - - case 'ogg': - if (@$OldThisFileInfo['audio']['dataformat'] == 'flac') { - //$ValidTagTypes = array('metaflac'); - // metaflac doesn't (yet) work with OggFLAC files - $ValidTagTypes = array(); - } else { - $ValidTagTypes = array('vorbiscomment'); - } - break; - - case 'flac': - $ValidTagTypes = array('metaflac'); - break; - - default: - $ValidTagTypes = array(); - break; - } - echo '<TR><TD ALIGN="RIGHT"><B>Title</B></TD> <TD><INPUT TYPE="TEXT" SIZE="40" NAME="Title" VALUE="'.FixTextFields(isset($OldThisFileInfo['comments']['title']) ? @implode(', ', $OldThisFileInfo['comments']['title']) : '').'"></TD></TR>'; - echo '<TR><TD ALIGN="RIGHT"><B>Artist</B></TD><TD><INPUT TYPE="TEXT" SIZE="40" NAME="Artist" VALUE="'.FixTextFields(isset($OldThisFileInfo['comments']['artist']) ? @implode(', ', $OldThisFileInfo['comments']['artist']) : '').'"></TD></TR>'; - echo '<TR><TD ALIGN="RIGHT"><B>Album</B></TD> <TD><INPUT TYPE="TEXT" SIZE="40" NAME="Album" VALUE="'.FixTextFields(isset($OldThisFileInfo['comments']['album']) ? @implode(', ', $OldThisFileInfo['comments']['album']) : '').'"></TD></TR>'; - echo '<TR><TD ALIGN="RIGHT"><B>Year</B></TD> <TD><INPUT TYPE="TEXT" SIZE="4" NAME="Year" VALUE="'.FixTextFields(isset($OldThisFileInfo['comments']['year']) ? @implode(', ', $OldThisFileInfo['comments']['year']) : '').'"></TD></TR>'; - - $TracksTotal = ''; - $TrackNumber = ''; - if (!empty($OldThisFileInfo['comments']['tracknumber']) && is_array($OldThisFileInfo['comments']['tracknumber'])) { - $RawTrackNumberArray = $OldThisFileInfo['comments']['tracknumber']; - } elseif (!empty($OldThisFileInfo['comments']['track']) && is_array($OldThisFileInfo['comments']['track'])) { - $RawTrackNumberArray = $OldThisFileInfo['comments']['track']; - } else { - $RawTrackNumberArray = array(); - } - foreach ($RawTrackNumberArray as $key => $value) { - if (strlen($value) > strlen($TrackNumber)) { - // ID3v1 may store track as "3" but ID3v2/APE would store as "03/16" - $TrackNumber = $value; - } - } - if (strstr($TrackNumber, '/')) { - list($TrackNumber, $TracksTotal) = explode('/', $TrackNumber); - } - echo '<TR><TD ALIGN="RIGHT"><B>Track</B></TD><TD><INPUT TYPE="TEXT" SIZE="2" NAME="Track" VALUE="'.FixTextFields($TrackNumber).'"> of <INPUT TYPE="TEXT" SIZE="2" NAME="TracksTotal" VALUE="'.FixTextFields($TracksTotal).'"></TD></TR>'; - - $ArrayOfGenresTemp = getid3_id3v1::ArrayOfGenres(); // get the array of genres - foreach ($ArrayOfGenresTemp as $key => $value) { // change keys to match displayed value - $ArrayOfGenres[$value] = $value; - } - unset($ArrayOfGenresTemp); // remove temporary array - unset($ArrayOfGenres['Cover']); // take off these special cases - unset($ArrayOfGenres['Remix']); - unset($ArrayOfGenres['Unknown']); - $ArrayOfGenres[''] = '- Unknown -'; // Add special cases back in with renamed key/value - $ArrayOfGenres['Cover'] = '-Cover-'; - $ArrayOfGenres['Remix'] = '-Remix-'; - asort($ArrayOfGenres); // sort into alphabetical order - echo '<TR><TD ALIGN="RIGHT"><B>Genre</B></TD><TD><SELECT NAME="Genre">'; - $AllGenresArray = (!empty($OldThisFileInfo['comments']['genre']) ? $OldThisFileInfo['comments']['genre'] : array()); - foreach ($ArrayOfGenres as $key => $value) { - echo '<OPTION VALUE="'.$key.'"'; - if (in_array($key, $AllGenresArray)) { - echo ' SELECTED'; - unset($AllGenresArray[array_search($key, $AllGenresArray)]); - sort($AllGenresArray); - } - echo '>'.$value.'</OPTION>'; - //echo '<OPTION VALUE="'.FixTextFields($value).'"'.((@$OldThisFileInfo['comments']['genre'][0] == $value) ? ' SELECTED' : '').'>'.$value.'</OPTION>'; - } - echo '</SELECT><INPUT TYPE="TEXT" NAME="GenreOther" SIZE="10" VALUE="'.FixTextFields(@$AllGenresArray[0]).'"></TD></TR>'; - - echo '<TR><TD ALIGN="RIGHT"><B>Write Tags</B></TD><TD>'; - foreach ($ValidTagTypes as $ValidTagType) { - echo '<INPUT TYPE="CHECKBOX" NAME="TagFormatsToWrite[]" VALUE="'.$ValidTagType.'"'; - if (count($ValidTagTypes) == 1) { - echo ' CHECKED'; - } else { - switch ($ValidTagType) { - case 'id3v2.2': - case 'id3v2.3': - case 'id3v2.4': - if (isset($OldThisFileInfo['tags']['id3v2'])) { - echo ' CHECKED'; - } - break; - default: - if (isset($OldThisFileInfo['tags'][$ValidTagType])) { - echo ' CHECKED'; - } - break; - } - } - echo '>'.$ValidTagType.'<BR>'; - } - echo '</TD></TR>'; - - echo '<TR><TD ALIGN="RIGHT"><B>Comment</B></TD><TD><TEXTAREA COLS="30" ROWS="3" NAME="Comment" WRAP="VIRTUAL">'.(isset($OldThisFileInfo['comments']['comment']) ? @implode("\n", $OldThisFileInfo['comments']['comment']) : '').'</TEXTAREA></TD></TR>'; - - echo '<TR><TD ALIGN="RIGHT"><B>Picture</B><BR>(ID3v2 only)</TD><TD><INPUT TYPE="FILE" NAME="userfile" ACCEPT="image/jpeg, image/gif, image/png"><BR>'; - echo '<SELECT NAME="APICpictureType">'; - $APICtypes = getid3_id3v2::APICPictureTypeLookup('', true); - foreach ($APICtypes as $key => $value) { - echo '<OPTION VALUE="'.FixTextFields($key).'">'.FixTextFields($value).'</OPTION>'; - } - echo '</SELECT></TD></TR>'; - echo '<TR><TD ALIGN="CENTER" COLSPAN="2"><INPUT TYPE="SUBMIT" NAME="WriteTags" VALUE="Save Changes"> '; - echo '<INPUT TYPE="RESET" VALUE="Reset"></TD></TR>'; - - } else { - - echo '<TR><TD ALIGN="RIGHT"><B>Error</B></TD><TD>'.FixTextFields($Filename).' does not exist</TD></TR>'; - - } - echo '</FORM></TABLE>'; - -} - -?> -</BODY> -</HTML>
\ No newline at end of file diff --git a/modules/id3/demos/index.php b/modules/id3/demos/index.php deleted file mode 100644 index 13783f0d..00000000 --- a/modules/id3/demos/index.php +++ /dev/null @@ -1 +0,0 @@ -In this directory are a number of examples of how to use <A HREF="http://www.getid3.org">getID3()</A> - if you don't know what to run, take a look at <A HREF="demo.browse.php">demo.browse.php</A>
\ No newline at end of file |