=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ grep rough audit - static analysis tool v2.8 written by @Wireghoul =================================[justanotherhacker.com]=== php-getid3-2.0.0~beta3/demos/demo.browse.php-108- } else { php-getid3-2.0.0~beta3/demos/demo.browse.php:109: echo 'Browse: <a href="'.htmlentities($_SERVER['PHP_SELF'].'?listdirectory='.urlencode($listdirectory), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'">' . GetID3\Utils::iconv_fallback($FileSystemEncoding, $PageEncoding, $listdirectory) . '</a><br>'; php-getid3-2.0.0~beta3/demos/demo.browse.php-110- } ############################################## php-getid3-2.0.0~beta3/demos/demo.browse.php-223- echo '<td colspan="'.$columnsintable.'">'; php-getid3-2.0.0~beta3/demos/demo.browse.php:224: echo '<form action="'.htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'" method="get">'; php-getid3-2.0.0~beta3/demos/demo.browse.php-225- echo 'Parent directory: '; ############################################## php-getid3-2.0.0~beta3/demos/demo.browse.php-236- $escaped_filename = ($escaped_filename ? $escaped_filename : rawurlencode($filename)); php-getid3-2.0.0~beta3/demos/demo.browse.php:237: echo '<td colspan="'.$columnsintable.'"><a href="'.htmlentities($_SERVER['PHP_SELF'].'?listdirectory='.urlencode($dirname.$filename), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'"><b>'.$escaped_filename.'</b></a></td>'; php-getid3-2.0.0~beta3/demos/demo.browse.php-238- } ############################################## php-getid3-2.0.0~beta3/demos/demo.browse.php-251- if (isset($_REQUEST['ShowMD5']) && GETID3_DEMO_BROWSE_ALLOW_MD5_LINK) { php-getid3-2.0.0~beta3/demos/demo.browse.php:252: echo '<th>MD5 File (File) (<a href="'.htmlentities($_SERVER['PHP_SELF'].'?listdirectory='.rawurlencode(isset($_REQUEST['listdirectory']) ? $_REQUEST['listdirectory'] : '.'), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'">disable</a>)</th>'; php-getid3-2.0.0~beta3/demos/demo.browse.php:253: echo '<th>MD5 Data (File) (<a href="'.htmlentities($_SERVER['PHP_SELF'].'?listdirectory='.rawurlencode(isset($_REQUEST['listdirectory']) ? $_REQUEST['listdirectory'] : '.'), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'">disable</a>)</th>'; php-getid3-2.0.0~beta3/demos/demo.browse.php:254: echo '<th>MD5 Data (Source) (<a href="'.htmlentities($_SERVER['PHP_SELF'].'?listdirectory='.rawurlencode(isset($_REQUEST['listdirectory']) ? $_REQUEST['listdirectory'] : '.'), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'">disable</a>)</th>'; php-getid3-2.0.0~beta3/demos/demo.browse.php-255- } else { php-getid3-2.0.0~beta3/demos/demo.browse.php:256: echo '<th colspan="3">MD5 Data'.(GETID3_DEMO_BROWSE_ALLOW_MD5_LINK ?' (<a href="'.htmlentities($_SERVER['PHP_SELF'].'?listdirectory='.rawurlencode(isset($_REQUEST['listdirectory']) ? $_REQUEST['listdirectory'] : '.').'&ShowMD5=1', ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'">enable</a>)' : '').'</th>'; php-getid3-2.0.0~beta3/demos/demo.browse.php-257- } ############################################## php-getid3-2.0.0~beta3/demos/demo.browse.php-269- $escaped_filename = ($escaped_filename ? $escaped_filename : rawurlencode($filename)); php-getid3-2.0.0~beta3/demos/demo.browse.php:270: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?filename='.urlencode($dirname.$filename), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'" title="View detailed analysis">'.$escaped_filename.'</a></td>'; php-getid3-2.0.0~beta3/demos/demo.browse.php-271- echo '<td align="right"> '.number_format($fileinfo['filesize']).'</td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.browse.php-319- if (GETID3_DEMO_BROWSE_ALLOW_DELETE_LINK) { php-getid3-2.0.0~beta3/demos/demo.browse.php:320: echo '<td align="left"> <a href="'.htmlentities($_SERVER['PHP_SELF'].'?listdirectory='.urlencode($listdirectory).'&deletefile='.urlencode($dirname.$filename), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'" onClick="return confirm(\'Are you sure you want to delete '.addslashes(htmlentities($dirname.$filename)).'? \n(this action cannot be un-done)\');" title="'.htmlentities('Permanently delete '."\n".$filename."\n".' from'."\n".' '.$dirname, ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'">delete</a></td>'; php-getid3-2.0.0~beta3/demos/demo.browse.php-321- } ############################################## php-getid3-2.0.0~beta3/demos/demo.browse.php-331- $escaped_filename = ($escaped_filename ? $escaped_filename : rawurlencode($filename)); php-getid3-2.0.0~beta3/demos/demo.browse.php:332: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?filename='.urlencode($dirname.$filename), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'"><i>'.$escaped_filename.'</i></a></td>'; php-getid3-2.0.0~beta3/demos/demo.browse.php-333- echo '<td align="right"> '.(isset($fileinfo['filesize']) ? number_format($fileinfo['filesize']) : '-').'</td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.browse.php-359- if (GETID3_DEMO_BROWSE_ALLOW_DELETE_LINK) { php-getid3-2.0.0~beta3/demos/demo.browse.php:360: echo '<td align="left"> <a href="'.htmlentities($_SERVER['PHP_SELF'].'?listdirectory='.urlencode($listdirectory).'&deletefile='.urlencode($dirname.$filename), ENT_QUOTES | ENT_SUBSTITUTE, $PageEncoding).'" 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>'; php-getid3-2.0.0~beta3/demos/demo.browse.php-361- } ############################################## php-getid3-2.0.0~beta3/demos/demo.mimeonly.php-27- php-getid3-2.0.0~beta3/demos/demo.mimeonly.php:28: echo 'The file "'.htmlentities($_REQUEST['filename']).'" has a MIME type of "'.htmlentities(GetMIMEtype($_REQUEST['filename'])).'"'; php-getid3-2.0.0~beta3/demos/demo.mimeonly.php-29- ############################################## php-getid3-2.0.0~beta3/demos/demo.mimeonly.php-31- php-getid3-2.0.0~beta3/demos/demo.mimeonly.php:32: echo 'Usage: <span style="font-family: monospace;">'.htmlentities($_SERVER['PHP_SELF']).'?filename=<i>filename.ext</i></span>'; php-getid3-2.0.0~beta3/demos/demo.mimeonly.php-33- ############################################## php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1342- php-getid3-2.0.0~beta3/demos/demo.mp3header.php:1343:echo '<form action="'.htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES).'" method="get">'; php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1344-echo 'Enter 4 hex bytes of MPEG-audio header (ie <I>FF FA 92 44</I>)<BR>'; php-getid3-2.0.0~beta3/demos/demo.mp3header.php:1345:echo '<input type="text" name="HeaderHexBytes" value="'.htmlentities(isset($_POST['HeaderHexBytes']) ? strtoupper($_POST['HeaderHexBytes']) : '', ENT_QUOTES).'" size="11" maxlength="11">'; php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1346-echo '<input type="submit" name="Analyze" value="Analyze"></form>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1348- php-getid3-2.0.0~beta3/demos/demo.mp3header.php:1349:echo '<form action="'.htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES).'" method="get">'; php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1350-echo 'Generate a MPEG-audio 4-byte header from these values:<BR>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1370- foreach ($dataarray as $key => $value) { php-getid3-2.0.0~beta3/demos/demo.mp3header.php:1371: echo '<option'.((isset($_POST["$name"]) && ($_POST["$name"] == $value)) ? ' SELECTED' : '').'>'.$value.'</option>'; php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1372- } ############################################## php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1376-if (isset($_POST['bitrate'])) { php-getid3-2.0.0~beta3/demos/demo.mp3header.php:1377: echo '<tr><th>Frame Length:</th><td>'.(int) MPEGaudioFrameLength($_POST['bitrate'], $_POST['version'], $_POST['layer'], (($_POST['padding'] == 'Y') ? '1' : '0'), $_POST['frequency']).'</td></tr>'; php-getid3-2.0.0~beta3/demos/demo.mp3header.php-1378-} ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-115- ob_end_clean(); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:116: $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:117: $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $from).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-118- mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-141- echo '#EXTM3U'."\n"; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:142: echo WindowsShareSlashTranslate($_REQUEST['m3ufilename'])."\n"; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-143- exit; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-210- if (mysqli_table_exists($con, GETID3_DB_TABLE)) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:211: $SQLquery = 'DROP TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-212- mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-215-if (!mysqli_table_exists($con, GETID3_DB_TABLE)) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:216: $SQLquery = "CREATE TABLE `".mysqli_real_escape_string($con, GETID3_DB_TABLE)."` ("; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-217- $SQLquery .= " `ID` int(11) unsigned NOT NULL auto_increment,"; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-253-$ExistingTableFields = array(); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:254:$result = mysqli_query_safe($con, 'DESCRIBE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php-255-while ($row = mysqli_fetch_array($result)) { ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-259- echo '<b>adding field `encoder_options`</b><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:260: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `encoder_options` VARCHAR(255) default "" NOT NULL AFTER `error`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:261: mysqli_query_safe($con, 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php-262-} ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-264- echo '<b>changing field `track` to VARCHAR(7)</b><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:265: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE `track` `track` VARCHAR(7) default "" NOT NULL'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:266: mysqli_query_safe($con, 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php-267-} ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-270- echo '<b>adding field `track_volume`</b><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:271: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `track_volume` FLOAT NOT NULL AFTER `error`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:272: mysqli_query_safe($con, 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php-273-} ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-275- echo '<b>adding field `encoder_options`, `alternate_name`, `parody`</b><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:276: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `remix` VARCHAR(255) default "" NOT NULL AFTER `title`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:277: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `alternate_name` VARCHAR(255) default "" NOT NULL AFTER `track`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:278: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` ADD `parody` VARCHAR(255) default "" NOT NULL AFTER `alternate_name`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:279: mysqli_query_safe($con, 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php-280-} ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-283- // no need to change id3v1 php-getid3-2.0.0~beta3/demos/demo.mysqli.php:284: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE `comments_all` `comments_all` LONGTEXT NOT NULL'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:285: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE `comments_id3v2` `comments_id3v2` LONGTEXT NOT NULL'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:286: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE `comments_ape` `comments_ape` LONGTEXT NOT NULL'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:287: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE `comments_lyrics3` `comments_lyrics3` LONGTEXT NOT NULL'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:288: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE `warning` `warning` LONGTEXT NOT NULL'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:289: mysqli_query_safe($con, 'ALTER TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` CHANGE `error` `error` LONGTEXT NOT NULL'); php-getid3-2.0.0~beta3/demos/demo.mysqli.php-290-} ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-308- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:309: $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:310: $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $filename).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-311- mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-346- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:347: $SQLquery = 'DELETE from `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-348- $SQLquery .= ' WHERE (`fileformat` = "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-354- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:355: echo '<a href="'.htmlentities($_SERVER['PHP_SELF']).'">abort</a><hr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-356- ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-359- $SQLquery = 'SELECT `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:360: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-361- $SQLquery .= ' WHERE (`error` <> "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-368- echo '<b>File missing: '.$row['filename'].'</b><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:369: $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:370: $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-371- mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-379- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:380: echo '<a href="'.htmlentities($_SERVER['PHP_SELF']).'">abort</a><hr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-381- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:382: echo 'Scanning all media files in <b>'.str_replace('\\', '/', realpath(!empty($_REQUEST['scan']) ? $_REQUEST['scan'] : $_REQUEST['newscan'])).'</b> (and subdirectories)<hr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-383- php-getid3-2.0.0~beta3/demos/demo.mysqli.php-384- $SQLquery = 'SELECT COUNT(*) AS `num`, `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:385: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-386- $SQLquery .= ' GROUP BY `filename`'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-392- set_time_limit(30); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:393: $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-394- $SQLquery .= ' WHERE `filename` LIKE "'.mysqli_real_escape_string($con, $row['filename']).'"'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-405- $SQLquery = 'SELECT `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:406: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-407- $SQLquery .= ' ORDER BY `filename` ASC'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-521- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:522: $SQLquery = 'UPDATE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` SET '; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-523- $SQLquery .= ' `last_modified` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['file_modified_time'] ) ? $ThisFileInfo['file_modified_time'] : '').'"'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-551- $SQLquery .= ', `track` = "'. mysqli_real_escape_string($con, $this_track_track).'"'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:552: $SQLquery .= ' WHERE (`filename` = "'. mysqli_real_escape_string($con, isset($ThisFileInfo['filenamepath']) ? $ThisFileInfo['filenamepath'] : '').'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-553- ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-555- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:556: //$SQLquery = 'INSERT INTO `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` (`filename`, `last_modified`, `md5_file`, `md5_data`, `md5_data_source`, `filesize`, `fileformat`, `audio_dataformat`, `video_dataformat`, `audio_bitrate`, `video_bitrate`, `playtime_seconds`, `artist`, `title`, `remix`, `album`, `genre`, `comment`, `track`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyrics3`, `comments_id3v1`, `warning`, `error`, `encoder_options`, `vbr_method`, `track_volume`) VALUES ('; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:557: $SQLquery = 'INSERT INTO `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` (`filename`, `last_modified`, `md5_file`, `md5_data`, `md5_data_source`, `filesize`, `fileformat`, `audio_dataformat`, `video_dataformat`, `audio_bitrate`, `video_bitrate`, `playtime_seconds`, `tags`, `artist`, `title`, `remix`, `album`, `genre`, `comment`, `track`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyrics3`, `comments_id3v1`, `warning`, `error`, `encoder_options`, `vbr_method`, `track_volume`) VALUES ('; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-558- $SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['filenamepath'] ) ? $ThisFileInfo['filenamepath'] : '').'", '; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-596- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:597: $SQLquery = 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-598- mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-607- $SQLquery = 'SELECT `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:608: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-609- $SQLquery .= ' WHERE (`track_volume` = 0)'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-621- $MissingTrackVolumeFilesAdjusted++; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:622: $SQLquery = 'UPDATE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-623- $SQLquery .= ' SET `track_volume` = "'.$ThisFileInfo['replay_gain']['track']['volume'].'"'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:624: $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-625- mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-630- $MissingTrackVolumeFilesDeleted++; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:631: $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:632: $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-633- mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-642- $SQLquery = 'SELECT COUNT(*) AS `num`, `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:643: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-644- $SQLquery .= ' GROUP BY `filename`'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-653- echo '<br>'.htmlentities($row['filename']).' (<font color="#FF9999">duplicate</font>)'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:654: $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-655- $SQLquery .= ' WHERE `filename` LIKE "'.mysqli_real_escape_string($con, $row['filename']).'"'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-663- $SQLquery = 'SELECT `filename`, `filesize`, `last_modified`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:664: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-665- $SQLquery .= ' ORDER BY `filename` ASC'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-690- flush(); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:691: $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:692: $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-693- mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-713- $SQLquery = 'SELECT `filename`, `comments_id3v2`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:714: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:715: $SQLquery .= ' WHERE (`encoder_options` = "'.mysqli_real_escape_string($con, $_REQUEST['encodedbydistribution']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-716- $result = mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-733- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:734: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%')).'">show all</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-735- echo '<table border="1">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-737- $SQLquery = 'SELECT `filename`, `comments_id3v2`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:738: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-739- $result = mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-743- if (($_REQUEST['encodedbydistribution'] == '%') || (!empty($CommentArray['encoded_by'][0]) && ($_REQUEST['encodedbydistribution'] == $CommentArray['encoded_by'][0]))) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:744: echo '<tr><td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])).'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-745- echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td></tr>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-752- $SQLquery = 'SELECT `encoder_options`, `comments_id3v2`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:753: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-754- $SQLquery .= ' ORDER BY (`encoder_options` LIKE "LAME%") DESC, (`encoder_options` LIKE "CBR%") DESC'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-767- } php-getid3-2.0.0~beta3/demos/demo.mysqli.php:768: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%').'&m3u=1').'">.m3u version</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-769- echo '<table border="1"><tr><th>m3u</th><th>Encoder Options</th><th>Encoded By (ID3v2)</th></tr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-770- foreach ($EncodedBy as $key => $value) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:771: echo '<tr><TD VALIGN="TOP"><a href="'.htmlentities($_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode($key).'&showfiles=1&m3u=1').'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-772- echo '<TD VALIGN="TOP"><b>'.$key.'</b></td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-776- echo '<tr><TD ALIGN="RIGHT" WIDTH="50"><i>'.number_format($count).'</i></td><td> </td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:777: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode($string).'&showfiles=1').'">'.$string.'</a></td></tr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-778- } ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-788- $SQLquery = 'SELECT ROUND(audio_bitrate / 1000) AS `RoundBitrate`, COUNT(*) AS `num`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:789: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-790- $SQLquery .= ' WHERE (`audio_bitrate` > 0)'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-815- $SQLquery = 'SELECT `fileformat`, `filename`, `genre`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:816: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-817- $SQLquery .= ' WHERE (`genre` = "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-835- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:836: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?emptygenres='.urlencode($_REQUEST['emptygenres']).'&m3u=1').'">.m3u version</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-837- $EmptyGenreCounter = 0; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-843- echo '<tr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:844: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']), ENT_QUOTES).'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-845- echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-856- $SQLquery = 'SELECT `filename`, `comment`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:857: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-858- $SQLquery .= ' WHERE (`comment` <> "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-873- $NonEmptyCommentsCounter = 0; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:874: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?nonemptycomments='.urlencode($_REQUEST['nonemptycomments']).'&m3u=1').'">.m3u version</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-875- echo '<table border="1" cellspacing="0" cellpadding="3">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-879- echo '<tr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:880: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']), ENT_QUOTES).'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-881- echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-896- $SQLquery = 'SELECT `filename`, `track`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:897: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-898- $SQLquery .= ' WHERE (`track` <> "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-916- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:917: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?trackzero='.urlencode($_REQUEST['trackzero']).'&m3u=1').'">.m3u version</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-918- $TrackZeroCounter = 0; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-924- echo '<tr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:925: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']), ENT_QUOTES).'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-926- echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-939- $SQLquery = 'SELECT `filename`, `title`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:940: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-941- $SQLquery .= ' WHERE (`title` LIKE "%feat.%")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-956- echo '<b>'.number_format(mysqli_num_rows($result)).'</b> files with "feat." in the title (instead of the artist)<br><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:957: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?titlefeat='.urlencode($_REQUEST['titlefeat']).'&m3u=1').'">.m3u version</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-958- echo '<table border="1" cellspacing="0" cellpadding="3">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-961- echo '<tr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:962: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']), ENT_QUOTES).'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-963- echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-974- $SQLquery = 'SELECT `filename`, `track`, `album`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:975: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-976- $SQLquery .= ' WHERE (`track` <> "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-992- echo '<b>'.number_format(mysqli_num_rows($result)).'</b> files with a track number, but no album<br><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:993: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?tracknoalbum='.urlencode($_REQUEST['tracknoalbum']).'&m3u=1').'">.m3u version</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-994- echo '<table border="1" cellspacing="0" cellpadding="3">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-997- echo '<tr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:998: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']), ENT_QUOTES).'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-999- echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1010- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1011: echo 'Applying new tags from <b>'.$_REQUEST['synchronizetagsfrom'].'</b> in <b>'.htmlentities($_REQUEST['filename']).'</b><ul>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1012- $errors = array(); ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1040- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1041: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1').'">Auto-fix empty tags</a><br><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1042- echo '<div id="Autofixing"></div>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1048- if ($TagsToCompare['id3v2']) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1049: echo '<th><a href="'.htmlentities($_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1&autofixforcesource=id3v2&autofixforcedest=A1').'" title="Auto-fix all tags to match ID3v2 contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match ID3v2?\');">ID3v2</a></th>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1050- } php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1051- if ($TagsToCompare['ape']) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1052: echo '<th><a href="'.htmlentities($_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1&autofixforcesource=ape&autofixforcedest=21').'" title="Auto-fix all tags to match APE contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match APE?\');">APE</a></th>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1053- } ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1057- if ($TagsToCompare['id3v1']) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1058: echo '<th><a href="'.htmlentities($_SERVER['PHP_SELF'].'?unsynchronizedtags='.urlencode($_REQUEST['unsynchronizedtags']).'&autofix=1&autofixforcesource=ape&autofixforcedest=2A').'" title="Auto-fix all tags to match ID3v1 contents" onClick="return confirm(\'Are you SURE you want to synchronize all tags to match ID3v1?\');">ID3v1</a></th>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1059- } ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1062- $SQLquery = 'SELECT `filename`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyrics3`, `comments_id3v1`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1063: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1064- $SQLquery .= ' WHERE (`fileformat` = "mp3")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1307- echo '<td> </th>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1308: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])).'" title="'.htmlentities(implode("\n", $errors), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1309- echo '<td><table border="0">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1341- $SQLquery = 'SELECT `filename`, `fileformat`, '.implode(', ', $FieldNames); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1342: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1343- $SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1345- $result = mysqli_query_safe($con, $SQLquery); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1346: echo 'Files that do not match naming pattern: (<a href="'.htmlentities($_SERVER['PHP_SELF'].'?filenamepattern='.urlencode($_REQUEST['filenamepattern']).'&autofix=1').'">auto-fix</a>)<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1347- echo '<table border="1" cellspacing="0" cellpadding="3">'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1348: 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>'.(empty($_REQUEST['autofix']) ? '<br>(click to rename file to this)' : '').'</td></tr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1349- $nonmatchingfilenames = 0; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1436- echo '<td> '.$NotMatchedReasons.'</td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1437: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($ActualFilename).'</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1438- ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1451- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1452: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?filenamepattern='.urlencode($_REQUEST['filenamepattern']).'&renamefilefrom='.urlencode($row['filename']).'&renamefileto='.urlencode(dirname($row['filename']).'/'.$PatternFilename)).'" title="'.htmlentities(basename($row['filename'])."\n".basename($PatternFilename), ENT_QUOTES).'" target="renamewindow">'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1453- echo '<b>'.$DifferenceBoldedName.'</b></a></td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1467- if (isset($_REQUEST['showtagfiles'])) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1468: $SQLquery = 'SELECT `filename`, `encoder_options` FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1469- $SQLquery .= ' WHERE (`encoder_options` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['showtagfiles']).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1484- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1485: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1').'">Show all Encoder Options</a><hr>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1486: echo 'Files with Encoder Options <b>'.$_REQUEST['showtagfiles'].'</b>:<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1487- echo '<table border="1" cellspacing="0" cellpadding="3">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1499- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1500: $SQLquery = 'SELECT `encoder_options`, COUNT(*) AS `num` FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1501- $SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1510- echo '<td>'.$row['encoder_options'].'</td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1511: echo '<TD ALIGN="RIGHT"><a href="'.htmlentities($_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1&showtagfiles='.($row['encoder_options'] ? urlencode($row['encoder_options']) : '')).'">'.number_format($row['num']).'</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1512: echo '<TD ALIGN="RIGHT"><a href="'.htmlentities($_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1&showtagfiles='.($row['encoder_options'] ? urlencode($row['encoder_options']) : '').'&m3u=.m3u').'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1513- echo '</tr>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1521- if (!isset($_REQUEST['m3u'])) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1522: $SQLquery = 'SELECT `tags`, COUNT(*) AS `num` FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1523- $SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1532- echo '<td>'.$row['tags'].'</td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1533: echo '<td align="right"><a href="'.htmlentities($_SERVER['PHP_SELF'].'?tagtypes=1&showtagfiles='.($row['tags'] ? urlencode($row['tags']) : '')).'">'.number_format($row['num']).'</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1534: echo '<td align="right"><a href="'.htmlentities($_SERVER['PHP_SELF'].'?tagtypes=1&showtagfiles='.($row['tags'] ? urlencode($row['tags']) : '').'&m3u=.m3u').'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1535- echo '</tr>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1540- if (isset($_REQUEST['showtagfiles'])) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1541: $SQLquery = 'SELECT `filename`, `tags` FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1542- $SQLquery .= ' WHERE (`tags` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['showtagfiles']).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1576- $SQLquery = 'SELECT `md5_data`, `filename`, COUNT(*) AS `num`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1577: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1578- $SQLquery .= ' WHERE (`md5_data` <> "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1588- $SQLquery = 'SELECT `fileformat`, `filename`, `tags`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1589: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1590: $SQLquery .= ' WHERE (`md5_data` = "'.mysqli_real_escape_string($con, $row['md5_data']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1591- $SQLquery .= ' ORDER BY `filename` ASC'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1624- $SQLquery = 'SELECT `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1625: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1626: $SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $_REQUEST['m3uartist']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1627- $SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $_REQUEST['m3utitle']).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1637- $SQLquery = 'SELECT `artist`, `title`, `filename`, COUNT(*) AS `num`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1638: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1639- $SQLquery .= ' WHERE (`artist` <> "")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1640- $SQLquery .= ' AND (`title` <> "")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1641: $SQLquery .= ' GROUP BY `artist`, `title`'.(!empty($_REQUEST['samemix']) ? ', `remix`' : ''); php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1642- $SQLquery .= ' ORDER BY `num` DESC, `artist` ASC, `title` ASC, `playtime_seconds` ASC, `remix` ASC'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1652- $SQLquery = 'SELECT `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1653: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1654: $SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $row['artist']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1655- $SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $row['title']).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1668- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1669: echo 'Duplicated aritst + title: (<a href="'.htmlentities($_SERVER['PHP_SELF'].'?artisttitledupes=1&samemix=1').'">Identical Mix/Version only</a>)<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1670: echo '(<a href="'.htmlentities($_SERVER['PHP_SELF'].'?artisttitledupes=1&m3u=.m3u').'">.m3u version</a>)<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1671- echo '<table border="1" cellspacing="0" cellpadding="2">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1684- $SQLquery = 'SELECT `filename`, `artist`, `title`, `remix`, `audio_bitrate`, `vbr_method`, `playtime_seconds`, `encoder_options`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1685: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1686: $SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $row['artist']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1687- $SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $row['title']).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1711- foreach ($filenames as $file) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1712: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($file)).'">play</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1713- } php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1714- echo '</td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1715: echo '<TD VALIGN="MIDDLE" ALIGN="CENTER" ><a href="'.htmlentities($_SERVER['PHP_SELF'].'?artisttitledupes=1&m3uartist='.urlencode($artists[0]).'&m3utitle='.urlencode($titles[0])).'">play all</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1716- echo '<TD VALIGN="TOP" NOWRAP>'.implode('<br>', $artists).'</td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1739- $SQLquery = 'SELECT `filename`, `fileformat`, `audio_dataformat`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1740: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1741: $SQLquery .= ' WHERE (`fileformat` = "'.mysqli_real_escape_string($con, $fileformat).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1742- $SQLquery .= ' AND (`audio_dataformat` = "'.mysqli_real_escape_string($con, $audioformat).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1758- $SQLquery = 'SELECT `filename`, `album`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1759: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1760- $SQLquery .= ' WHERE (`album` LIKE "% [%")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1811- if (mysqli_num_rows($result) > 0) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1812: echo '(<a href="'.htmlentities($_SERVER['PHP_SELF'].'?trackinalbum=1&m3u=.m3u').'">.m3u version</a>)<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1813: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?trackinalbum=1&autofix=1').'">Try to auto-fix</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1814- echo '<table border="1" cellspacing="0" cellpadding="4">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1829- $SQLquery = 'SELECT `filename`, `fileformat`, `audio_dataformat`, `video_dataformat`, `tags`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1830: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1831- $SQLquery .= ' ORDER BY `filename` ASC'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1865- $SQLquery = 'SELECT `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1866: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1867: $SQLquery .= ' WHERE (BINARY `genre` = "'.$_REQUEST['genredistribution'].'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1868- $SQLquery .= ' AND (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1880- $SQLquery = 'SELECT COUNT(*) AS `num`, `genre`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1881: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1882- $SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoTagFormats).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1894- } php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1895: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?genredistribution='.urlencode($row['genre'])).'">'.number_format($row['num']).'</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1896- echo '<td nowrap>'.str_replace("\t", '<br>', $row['genre']).'</td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1897: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3u=.m3u&genredistribution='.urlencode($row['genre'])).'">.m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1898- echo '</tr>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1904- $SQLquery = 'SELECT `filename`, `genre`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1905: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1906- $SQLquery .= ' WHERE (`genre` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['genredistribution']).'")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1908- $result = mysqli_query_safe($con, $SQLquery); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1909: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'].'?genredistribution='.urlencode('%')).'">All Genres</a><br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1910- echo '<table border="1" cellspacing="0" cellpadding="4">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1914- echo '<TD NOWRAP>'.str_replace("\t", '<br>', $row['genre']).'</td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1915: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])).'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1916- echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1928- $SQLquery = 'SELECT `fileformat`, `audio_dataformat`, COUNT(*) AS `num`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1929: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1930- $SQLquery .= ' GROUP BY `fileformat`, `audio_dataformat`'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1937- echo '<TD ALIGN="RIGHT">'.number_format($row['num']).'</td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1938: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?filetypelist='.$row['fileformat'].'|'.$row['audio_dataformat']).'">'.($row['fileformat'] ? $row['fileformat'] : '<i>unknown</i>').(($row['audio_dataformat'] && ($row['audio_dataformat'] != $row['fileformat'])) ? '.'.$row['audio_dataformat'] : '').'</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1939- echo '</tr>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1945- $SQLquery = 'SELECT `filename`, `error`, `warning`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1946: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1947- $SQLquery .= ' WHERE (`error` <> "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1963- echo number_format(mysqli_num_rows($result)).' files with errors or warnings:<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1964: echo '(<a href="'.htmlentities($_SERVER['PHP_SELF'].'?errorswarnings=1&m3u=.m3u').'">.m3u version</a>)<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1965- echo '<table border="1" cellspacing="0" cellpadding="4">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1981- $SQLquery = 'SELECT `filename`, `error`, `warning`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:1982: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-1983- $SQLquery .= ' WHERE (`fileformat` = "mp3")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2007- $SQLquery = 'SELECT COUNT(*) AS `num`, `vbr_method`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2008: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2009- $SQLquery .= ' GROUP BY `vbr_method`'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2017- if ($row['vbr_method']) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2018: echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?vbrmethod='.$row['vbr_method'], ENT_QUOTES).'">'.htmlentities($row['vbr_method']).'</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2019- } else { ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2028- $SQLquery = 'SELECT `filename`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2029: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2030: $SQLquery .= ' WHERE (`vbr_method` = "'.mysqli_real_escape_string($con, $_REQUEST['vbrmethod']).'")'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2031- $result = mysqli_query_safe($con, $SQLquery); php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2032: echo number_format(mysqli_num_rows($result)).' files with VBR_method of "'.$_REQUEST['vbrmethod'].'":<table border="1" cellspacing="0" cellpadding="3">'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2033- while ($row = mysqli_fetch_array($result)) { php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2034: echo '<tr><td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])).'">m3u</a></td>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2035- echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities($row['filename']).'</a></td></tr>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2044- $SQLquery = 'SELECT `filename`, `fileformat`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2045: $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2046- $SQLquery .= ' WHERE (`fileformat` <> "")'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2131- php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2132:echo '<hr><form action="'.htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES).'" method="get">'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2133-echo '<b>Warning:</b> Scanning a new directory will erase all previous entries in the database!<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2134:echo 'Directory: <input type="text" name="scan" size="50" value="'.htmlentities(!empty($_REQUEST['scan']) ? $_REQUEST['scan'] : '', ENT_QUOTES).'"> '; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2135-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?\');">'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2136-echo '</form>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2137:echo '<hr><form action="'.htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES).'" method="get">'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2138-echo 'Re-scanning a new directory will only add new, previously unscanned files into the list (and not erase the database).<br>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2139:echo 'Directory: <input type="text" name="newscan" size="50" value="'.htmlentities(!empty($_REQUEST['newscan']) ? $_REQUEST['newscan'] : '', ENT_QUOTES).'"> '; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2140-echo '<input type="submit" value="Go">'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2142-echo '<ul>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2143:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?deadfilescheck=1').'">Remove deleted or changed files from database</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2144:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?md5datadupes=1').'">List files with identical MD5_DATA values</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2145:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?artisttitledupes=1').'">List files with identical artist + title</a> (<a href="'.$_SERVER['PHP_SELF'].'?artisttitledupes=1&samemix=1">same mix only</a>)</li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2146:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?fileextensions=1').'">File with incorrect file extension</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2147:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?formatdistribution=1').'">File Format Distribution</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2148:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?audiobitrates=1').'">Audio Bitrate Distribution</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2149:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?vbrmethod=1').'">VBR_Method Distribution</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2150:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?tagtypes=1').'">Tag Type Distribution</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2151:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?genredistribution='.urlencode('%')).'">Genre Distribution</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2152://echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?missingtrackvolume=1').'">Scan for missing track volume information (update database from pre-v1.7.0b5)</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2153:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?encoderoptionsdistribution=1').'">Encoder Options Distribution</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2154:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?encodedbydistribution='.urlencode('%')).'">Encoded By (ID3v2) Distribution</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2155:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?trackinalbum=1').'">Track number in Album field</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2156:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?tracknoalbum=1').'">Track number, but no Album</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2157:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?titlefeat=1').'">"feat." in Title field</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2158:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?emptygenres=1').'">Blank genres</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2159:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?trackzero=1').'">Track "zero"</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2160:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?nonemptycomments=1').'">non-empty comments</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2161:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?unsynchronizedtags=2A1').'">Tags that are not synchronized</a> (<a href="'.$_SERVER['PHP_SELF'].'?unsynchronizedtags=2A1&autofix=1">autofix</a>)</li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2162:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?filenamepattern='.urlencode('[N] A - T {R}')).'">Filenames that don\'t match pattern</a> (<a href="?filenamepattern='.urlencode('[N] A - T {R}').'&autofix=1">auto-fix</a>)</li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2163://echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?filenamepattern='.urlencode('A - T')).'">Filenames that don\'t match pattern</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2164:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?correctcase=1').'">Correct filename case (Win/DOS)</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2165:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?fixid3v1padding=1').'">Fix ID3v1 invalid padding</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2166:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?errorswarnings=1').'">Files with Errors and/or Warnings</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2167:echo '<li><a href="'.htmlentities($_SERVER['PHP_SELF'].'?rescanerrors=1').'">Re-scan only files with Errors and/or Warnings</a></li>'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2168-echo '</ul>'; ############################################## php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2170-$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`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php:2171:$SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; php-getid3-2.0.0~beta3/demos/demo.mysqli.php-2172-$result = mysqli_query_safe($con, $SQLquery); ############################################## php-getid3-2.0.0~beta3/demos/demo.write.php-85- } else { php-getid3-2.0.0~beta3/demos/demo.write.php:86: echo '<b>cannot open '.htmlentities($_FILES['userfile']['tmp_name']).'</b><br>'; php-getid3-2.0.0~beta3/demos/demo.write.php-87- } php-getid3-2.0.0~beta3/demos/demo.write.php-88- } else { php-getid3-2.0.0~beta3/demos/demo.write.php:89: echo '<b>!is_uploaded_file('.htmlentities($_FILES['userfile']['tmp_name']).')</b><br>'; php-getid3-2.0.0~beta3/demos/demo.write.php-90- } ############################################## php-getid3-2.0.0~beta3/demos/demo.write.php-118-if (!empty($Filename)) { php-getid3-2.0.0~beta3/demos/demo.write.php:119: echo '<a href="'.htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES).'">Start Over</a><br><br>'; php-getid3-2.0.0~beta3/demos/demo.write.php:120: echo '<form action="'.htmlentities($_SERVER['PHP_SELF'], ENT_QUOTES).'" method="post" enctype="multipart/form-data">'; php-getid3-2.0.0~beta3/demos/demo.write.php-121- echo '<table border="3" cellspacing="0" cellpadding="4">'; ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysql.php-131- $SQLquery = 'SELECT `value`'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php:132: $SQLquery .= ' FROM `'.mysql_real_escape_string($this->table).'`'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php-133- $SQLquery .= ' WHERE (`filename` = \''.mysql_real_escape_string(GetID3::VERSION).'\')'; ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysql.php-136- $SQLquery .= ' AND (`analyzetime` = -1)'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php:137: if ($this->cursor = mysql_query($SQLquery, $this->connection)) { php-getid3-2.0.0~beta3/src/Cache/Mysql.php-138- list($version) = mysql_fetch_array($this->cursor); ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysql.php-153- php-getid3-2.0.0~beta3/src/Cache/Mysql.php:154: $this->cursor = mysql_query('DELETE FROM `'.mysql_real_escape_string($this->table).'`', $this->connection); php-getid3-2.0.0~beta3/src/Cache/Mysql.php:155: $this->cursor = mysql_query('INSERT INTO `'.mysql_real_escape_string($this->table).'` VALUES (\'' . GetID3::VERSION . '\', -1, -1, -1, \'' . GetID3::VERSION . '\')', $this->connection); php-getid3-2.0.0~beta3/src/Cache/Mysql.php-156- } ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysql.php-180- $SQLquery = 'SELECT `value`'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php:181: $SQLquery .= ' FROM `'.mysql_real_escape_string($this->table).'`'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php:182: $SQLquery .= ' WHERE (`filename` = \''.mysql_real_escape_string($filename).'\')'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php-183- $SQLquery .= ' AND (`filesize` = \''.mysql_real_escape_string($filesize).'\')'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php-184- $SQLquery .= ' AND (`filetime` = \''.mysql_real_escape_string($filetime).'\')'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php:185: $this->cursor = mysql_query($SQLquery, $this->connection); php-getid3-2.0.0~beta3/src/Cache/Mysql.php-186- if (mysql_num_rows($this->cursor) > 0) { ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysql.php-197- if (file_exists($filename)) { php-getid3-2.0.0~beta3/src/Cache/Mysql.php:198: $SQLquery = 'INSERT INTO `'.mysql_real_escape_string($this->table).'` (`filename`, `filesize`, `filetime`, `analyzetime`, `value`) VALUES ('; php-getid3-2.0.0~beta3/src/Cache/Mysql.php-199- $SQLquery .= '\''.mysql_real_escape_string($filename).'\''; ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysql.php-203- $SQLquery .= ', \''.mysql_real_escape_string(base64_encode(serialize($analysis))).'\')'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php:204: $this->cursor = mysql_query($SQLquery, $this->connection); php-getid3-2.0.0~beta3/src/Cache/Mysql.php-205- } ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysql.php-217- php-getid3-2.0.0~beta3/src/Cache/Mysql.php:218: $SQLquery = 'CREATE TABLE IF NOT EXISTS `'.mysql_real_escape_string($this->table).'` ('; php-getid3-2.0.0~beta3/src/Cache/Mysql.php-219- $SQLquery .= '`filename` VARCHAR(990) NOT NULL DEFAULT \'\''; ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysql.php-224- $SQLquery .= ', PRIMARY KEY (`filename`, `filesize`, `filetime`))'; php-getid3-2.0.0~beta3/src/Cache/Mysql.php:225: $this->cursor = mysql_query($SQLquery, $this->connection); php-getid3-2.0.0~beta3/src/Cache/Mysql.php-226- echo mysql_error($this->connection); ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-139- $SQLquery = 'SELECT `value`'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:140: $SQLquery .= ' FROM `'.$this->mysqli->real_escape_string($this->table).'`'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:141: $SQLquery .= ' WHERE (`filename` = \''.$this->mysqli->real_escape_string(GetID3::VERSION).'\')'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-142- $SQLquery .= ' AND (`hash` = \'GetID3::VERSION\')'; ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-157- public function clear_cache() { php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:158: $this->mysqli->query('TRUNCATE TABLE `'.$this->mysqli->real_escape_string($this->table).'`'); php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:159: $this->mysqli->query('INSERT INTO `'.$this->mysqli->real_escape_string($this->table).'` (`hash`, `filename`, `filesize`, `filetime`, `analyzetime`, `value`) VALUES (\'GetID3::VERSION\', \''.GetID3::VERSION.'\', -1, -1, -1, \''.GetID3::VERSION.'\')'); php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-160- } ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-169- $SQLquery = 'SHOW COLUMNS'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:170: $SQLquery .= ' FROM `'.$this->mysqli->real_escape_string($this->table).'`'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-171- $SQLquery .= ' LIKE \'hash\''; ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-214- $SQLquery = 'SELECT `value`'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:215: $SQLquery .= ' FROM `'.$this->mysqli->real_escape_string($this->table).'`'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:216: $SQLquery .= ' WHERE (`hash` = \''.$this->mysqli->real_escape_string(md5($filename.$filesize.$filetime)).'\')'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-217- $this->cursor = $this->mysqli->query($SQLquery); ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-229- if (file_exists($filename)) { php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:230: $SQLquery = 'INSERT INTO `'.$this->mysqli->real_escape_string($this->table).'` (`hash`, `filename`, `filesize`, `filetime`, `analyzetime`, `value`) VALUES ('; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-231- $SQLquery .= '\''.$this->mysqli->real_escape_string(md5($filename.$filesize.$filetime)).'\''; ############################################## php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-250- if ($drop) { php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:251: $SQLquery = 'DROP TABLE IF EXISTS `'.$this->mysqli->real_escape_string($this->table).'`'; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-252- $this->mysqli->query($SQLquery); php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-253- } php-getid3-2.0.0~beta3/src/Cache/Mysqli.php:254: $SQLquery = 'CREATE TABLE IF NOT EXISTS `'.$this->mysqli->real_escape_string($this->table).'` ('; php-getid3-2.0.0~beta3/src/Cache/Mysqli.php-255- $SQLquery .= '`hash` CHAR(32) NOT NULL DEFAULT \'\''; ############################################## php-getid3-2.0.0~beta3/src/Cache/Sqlite3.php-165- $sql = $this->getQuery('delete_cache'); php-getid3-2.0.0~beta3/src/Cache/Sqlite3.php:166: $db->exec($sql); php-getid3-2.0.0~beta3/src/Cache/Sqlite3.php-167- $sql = $this->getQuery('set_version'); ############################################## php-getid3-2.0.0~beta3/src/Cache/Sqlite3.php-230- $sql = $this->getQuery('make_table'); php-getid3-2.0.0~beta3/src/Cache/Sqlite3.php:231: return $db->exec($sql); php-getid3-2.0.0~beta3/src/Cache/Sqlite3.php-232- } ############################################## php-getid3-2.0.0~beta3/src/GetID3.php-1410- $commandline = '"' . Utils::getHelperAppDirectory() . 'vorbiscomment.exe" -w -c "'.$empty.'" "'.$file.'" "'.$temp.'"'; php-getid3-2.0.0~beta3/src/GetID3.php:1411: $VorbisCommentError = `$commandline`; php-getid3-2.0.0~beta3/src/GetID3.php-1412- ############################################## php-getid3-2.0.0~beta3/src/GetID3.php-1421- $commandline = 'vorbiscomment -w -c '.escapeshellarg($empty).' '.escapeshellarg($file).' '.escapeshellarg($temp).' 2>&1'; php-getid3-2.0.0~beta3/src/GetID3.php:1422: $VorbisCommentError = `$commandline`; php-getid3-2.0.0~beta3/src/GetID3.php-1423- ############################################## php-getid3-2.0.0~beta3/src/Module/Audio/Shorten.php-147- php-getid3-2.0.0~beta3/src/Module/Audio/Shorten.php:148: $output = `$commandline`; php-getid3-2.0.0~beta3/src/Module/Audio/Shorten.php-149- ############################################## php-getid3-2.0.0~beta3/src/Module/Tag/ID3v2.php-2730- arw Arawak php-getid3-2.0.0~beta3/src/Module/Tag/ID3v2.php:2731: asm Assamese php-getid3-2.0.0~beta3/src/Module/Tag/ID3v2.php-2732- ath Athapascan Languages ############################################## php-getid3-2.0.0~beta3/src/Utils.php-152- $commandline = 'dir /x ' . escapeshellarg(implode(\DIRECTORY_SEPARATOR, $pathParts)); php-getid3-2.0.0~beta3/src/Utils.php:153: $dir_listing = `$commandline`; php-getid3-2.0.0~beta3/src/Utils.php-154- $lines = explode("\n", $dir_listing); ############################################## php-getid3-2.0.0~beta3/src/Utils.php-1846- if (isset($commandline)) { php-getid3-2.0.0~beta3/src/Utils.php:1847: $output = trim(`$commandline`); php-getid3-2.0.0~beta3/src/Utils.php-1848- if (ctype_digit($output)) { ############################################## php-getid3-2.0.0~beta3/src/Write/MetaFlac.php-114- $commandline .= ' '.escapeshellarg($this->filename).' 2>&1'; php-getid3-2.0.0~beta3/src/Write/MetaFlac.php:115: $metaflacError = `$commandline`; php-getid3-2.0.0~beta3/src/Write/MetaFlac.php-116- ############################################## php-getid3-2.0.0~beta3/src/Write/MetaFlac.php-134- $commandline .= ' '.escapeshellarg($this->filename).' 2>&1'; php-getid3-2.0.0~beta3/src/Write/MetaFlac.php:135: $metaflacError = `$commandline`; php-getid3-2.0.0~beta3/src/Write/MetaFlac.php-136- ############################################## php-getid3-2.0.0~beta3/src/Write/MetaFlac.php-168- $commandline = Utils::getHelperAppDirectory() . 'metaflac.exe --remove-all-tags "' . $this->filename . '" 2>&1'; php-getid3-2.0.0~beta3/src/Write/MetaFlac.php:169: $metaflacError = `$commandline`; php-getid3-2.0.0~beta3/src/Write/MetaFlac.php-170- ############################################## php-getid3-2.0.0~beta3/src/Write/MetaFlac.php-184- $commandline = 'metaflac --remove-all-tags "'.$this->filename.'" 2>&1'; php-getid3-2.0.0~beta3/src/Write/MetaFlac.php:185: $metaflacError = `$commandline`; php-getid3-2.0.0~beta3/src/Write/MetaFlac.php-186- ############################################## php-getid3-2.0.0~beta3/src/Write/VorbisComment.php-84- $commandline = Utils::getHelperAppDirectory() . 'vorbiscomment.exe -w --raw -c "' . $tempcommentsfilename . '" "' . $this->filename . '" 2>&1'; php-getid3-2.0.0~beta3/src/Write/VorbisComment.php:85: $VorbiscommentError = `$commandline`; php-getid3-2.0.0~beta3/src/Write/VorbisComment.php-86- ############################################## php-getid3-2.0.0~beta3/src/Write/VorbisComment.php-99- $commandline = 'vorbiscomment -w --raw -c "'.$tempcommentsfilename.'" "'.$this->filename.'" 2>&1'; php-getid3-2.0.0~beta3/src/Write/VorbisComment.php:100: $VorbiscommentError = `$commandline`; php-getid3-2.0.0~beta3/src/Write/VorbisComment.php-101-