254 while ($row = mysqli_fetch_array($result)) {  variable
255 	$ExistingTableFields[$row['Field']] = $row;
365 		while ($row = mysqli_fetch_array($result)) {  variable
367 			if (!file_exists($row['filename'])) {
368 				echo '<b>File missing: '.$row['filename'].'</b><br>';
370 				$SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
373 				$FilesInDir[] = $row['filename'];
391 		while ($row = mysqli_fetch_array($result)) {  variable
394 			$SQLquery .= ' WHERE `filename` LIKE "'.mysqli_real_escape_string($con, $row['filename']).'"';
409 			while ($row = mysqli_fetch_array($result)) {  variable
411 				$AlreadyInDatabase[] = $row['filename'];
613 	while ($row = mysqli_fetch_array($result)) {  variable
617 		if (file_exists($row['filename'])) {
619 			$ThisFileInfo = $getID3->analyze($row['filename']);
624 				$SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
632 			$SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
648 	while ($row = mysqli_fetch_array($result)) {  variable
650 		if ($row['num'] <= 1) {
653 		echo '<br>'.htmlentities($row['filename']).' (<font color="#FF9999">duplicate</font>)';
655 		$SQLquery .= ' WHERE `filename` LIKE "'.mysqli_real_escape_string($con, $row['filename']).'"';
670 	while ($row = mysqli_fetch_array($result)) {  variable
674 		if (!file_exists($row['filename'])) {
676 		} elseif (filesize($row['filename']) != $row['filesize']) {
678 		} elseif (filemtime($row['filename']) != $row['last_modified']) {
679 			if (abs(filemtime($row['filename']) - $row['last_modified']) != 3600) {
685 		$thisdir = dirname($row['filename']);
689 			echo '<br>'.htmlentities($row['filename']).' (<font color="#FF9999">'.$reason.'</font>)';
692 			$SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
719 		while ($row = mysqli_fetch_array($result)) {  variable
721 			$CommentArray = unserialize($row['comments_id3v2']);
723 				$NonBlankEncodedBy .= WindowsShareSlashTranslate($row['filename'])."\n";
725 				$BlankEncodedBy    .= WindowsShareSlashTranslate($row['filename'])."\n";
740 		while ($row = mysqli_fetch_array($result)) {  variable
742 			$CommentArray = unserialize($row['comments_id3v2']);
744 …echo '<tr><td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filenam…
745 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
757 		while ($row = mysqli_fetch_array($result)) {  variable
759 			$CommentArray = unserialize($row['comments_id3v2']);
761 				if (isset($EncodedBy[$row['encoder_options']][$CommentArray['encoded_by'][0]])) {
762 					$EncodedBy[$row['encoder_options']][$CommentArray['encoded_by'][0]]++;
764 					$EncodedBy[$row['encoder_options']][$CommentArray['encoded_by'][0]] = 1;
794 	while ($row = mysqli_fetch_array($result)) {  variable
795 		$this_bitrate = getid3_mp3::ClosestStandardMP3Bitrate($row['RoundBitrate'] * 1000);
797 			$BitrateDistribution[$this_bitrate] += $row['num'];
799 			$BitrateDistribution[$this_bitrate]  = $row['num'];
828 		while ($row = mysqli_fetch_array($result)) {  variable
829 			if (!in_array($row['fileformat'], $IgnoreNoTagFormats)) {
830 				echo WindowsShareSlashTranslate($row['filename'])."\n";
841 		while ($row = mysqli_fetch_array($result)) {  variable
842 			if (!in_array($row['fileformat'], $IgnoreNoTagFormats)) {
845 …echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])…
846 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
867 		while ($row = mysqli_fetch_array($result)) {  variable
868 			echo WindowsShareSlashTranslate($row['filename'])."\n";
878 		while ($row = mysqli_fetch_array($result)) {  variable
881 …echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])…
882 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
883 			if (strlen(trim($row['comment'])) > 0) {
884 				echo '<td>'.htmlentities($row['comment']).'</td>';
909 		while ($row = mysqli_fetch_array($result)) {  variable
910 …if ((strlen($row['track_number']) > 0) && ($row['track_number'] < 1) || ($row['track_number'] > 99…
911 				echo WindowsShareSlashTranslate($row['filename'])."\n";
922 		while ($row = mysqli_fetch_array($result)) {  variable
923 …if ((strlen($row['track_number']) > 0) && ($row['track_number'] < 1) || ($row['track_number'] > 99…
926 …echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])…
927 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
928 				echo '<td>'.htmlentities($row['track_number']).'</td>';
950 		while ($row = mysqli_fetch_array($result)) {  variable
951 			echo WindowsShareSlashTranslate($row['filename'])."\n";
961 		while ($row = mysqli_fetch_array($result)) {  variable
963 …echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])…
964 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
965 			echo '<td>'.preg_replace('#(feat\. .*)#i', '<b>\\1</b>', htmlentities($row['title'])).'</td>';
986 		while ($row = mysqli_fetch_array($result)) {  variable
987 			echo WindowsShareSlashTranslate($row['filename'])."\n";
997 		while ($row = mysqli_fetch_array($result)) {  variable
999 …echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])…
1000 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1001 			echo '<td>'.htmlentities($row['track_number']).'</td>';
1002 			echo '<td>'.htmlentities($row['album']).'</td>';
1070 	while ($row = mysqli_fetch_array($result)) {  variable
1072 		if ($lastdir != dirname($row['filename'])) {
1085 			if ($unserialized = unserialize($row['comments_'.$field])) {
1111 …$ThisLine .= '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename'…
1112 …s($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1117 …ities($_SERVER['PHP_SELF'].'?synchronizetagsfrom=all&filename='.urlencode($row['filename'])).'" ti…
1256 …ERVER['PHP_SELF'].'?synchronizetagsfrom='.$tagtype.'&filename='.urlencode($row['filename'])).'" ti…
1265 …xing")) document.getElementById("Autofixing").innerHTML = "'.htmlentities($row['filename'], ENT_QU…
1303 					if (SynchronizeAllTags($row['filename'], $autofixforcesource, $TagsToSynch, $errors)) {
1310 …?m3ufilename='.urlencode($row['filename'])).'" title="'.htmlentities(implode("\n", $errors), ENT_Q…
1354 	while ($row = mysqli_fetch_array($result)) {  variable
1359 				$PatternFilename .= trim(strtr($row[$patterns[$Pattern[$i]]], ':\\*<>|', ';-¤«»¦'), ' ');
1404 		$PatternFilename .= '.'.$row['fileformat'];
1406 		$ActualFilename = basename($row['filename']);
1437 …echo '<td><a href="'.htmlentities('demo.browse.php?filename='.rawurlencode($row['filename'])).'">v…
1439 …echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])…
1444 …if (RenameFileFromTo($row['filename'], dirname($row['filename']).'/'.$PatternFilename, $results)) {
1454 …urlencode($row['filename']).'&renamefileto='.urlencode(dirname($row['filename']).'/'.$PatternFilen…
1480 			while ($row = mysqli_fetch_array($result)) {  variable
1481 				echo WindowsShareSlashTranslate($row['filename'])."\n";
1490 			while ($row = mysqli_fetch_array($result)) {  variable
1492 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1493 				echo '<td>'.$row['encoder_options'].'</td>';
1510 		while ($row = mysqli_fetch_array($result)) {  variable
1512 			echo '<td>'.$row['encoder_options'].'</td>';
1513 …istribution=1&showtagfiles='.($row['encoder_options'] ? urlencode($row['encoder_options']) : '')).…
1514 …P_SELF'].'?encoderoptionsdistribution=1&showtagfiles='.($row['encoder_options'] ? urlencode($row['…
1532 		while ($row = mysqli_fetch_array($result)) {  variable
1534 			echo '<td>'.$row['tags'].'</td>';
1535 …'PHP_SELF'].'?tagtypes=1&showtagfiles='.($row['tags'] ? urlencode($row['tags']) : '')).'">'.number…
1536 …mlentities($_SERVER['PHP_SELF'].'?tagtypes=1&showtagfiles='.($row['tags'] ? urlencode($row['tags']…
1553 			while ($row = mysqli_fetch_array($result)) {  variable
1554 				echo WindowsShareSlashTranslate($row['filename'])."\n";
1561 			while ($row = mysqli_fetch_array($result)) {  variable
1563 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1564 				echo '<td>'.$row['tags'].'</td>';
1584 	while (($row = mysqli_fetch_array($result)) && ($row['num'] > 1)) {  variable
1592 		$SQLquery .= ' WHERE (`md5_data` = "'.mysqli_real_escape_string($con, $row['md5_data']).'")';
1599 			$md5_data[]  = $row['md5_data'];
1632 		while ($row = mysqli_fetch_array($result)) {  variable
1633 			echo WindowsShareSlashTranslate($row['filename'])."\n";
1653 		while (($row = mysqli_fetch_array($result)) && ($row['num'] > 1)) {  variable
1656 			$SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $row['artist']).'")';
1657 			$SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $row['title']).'")';
1659 				$SQLquery .= ' AND (`remix` = "'.mysqli_real_escape_string($con, $row['remix']).'")';
1676 		while (($row = mysqli_fetch_array($result)) && ($row['num'] > 1)) {  variable
1688 			$SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $row['artist']).'")';
1689 			$SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $row['title']).'")';
1749 	while ($row = mysqli_fetch_array($result)) {  variable
1751 		echo '<td>'.$row['fileformat'].'</td>';
1752 		echo '<td>'.$row['audio_dataformat'].'</td>';
1753 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1769 		while ($row = mysqli_fetch_array($result)) {  variable
1770 			echo WindowsShareSlashTranslate($row['filename'])."\n";
1779 		while ($row = mysqli_fetch_array($result)) {  variable
1792 					echo '<hr>'.htmlentities($row['filename']).'<br>';
1794 …	echo '<b>ID3v2:</b> '.(RemoveID3v2($row['filename'], false) ? 'removed' : 'REMOVAL FAILED!').', ';
1800 …echo '<b>ID3v1:</b> '.(WriteID3v1($row['filename'], $WriteID3v1_title, $WriteID3v1_artist, $Album,…
1807 				echo '<hr>FAILED<br>'.htmlentities($row['filename']).'<hr>';
1820 			while ($row = mysqli_fetch_array($result)) {  variable
1822 				echo '<td>'.$row['album'].'</td>';
1823 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1841 	while ($row = mysqli_fetch_array($result)) {  variable
1844 …$acceptableextensions = AcceptableExtensions($row['fileformat'], $row['audio_dataformat'], $row['v…
1845 		$actualextension      = strtolower(fileextension($row['filename']));
1850 			$invalidextensionline .= '<td>'.$row['fileformat'].'</td>';
1851 			$invalidextensionline .= '<td>'.$row['audio_dataformat'].'</td>';
1852 			$invalidextensionline .= '<td>'.$row['video_dataformat'].'</td>';
1853 			$invalidextensionline .= '<td>'.$row['tags'].'</td>';
1856 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1876 		while ($row = mysqli_fetch_array($result)) {  variable
1877 			echo WindowsShareSlashTranslate($row['filename'])."\n";
1894 			while ($row = mysqli_fetch_array($result)) {  variable
1895 				$GenreID = getid3_id3v1::LookupGenreID($row['genre']);
1901 …es($_SERVER['PHP_SELF'].'?genredistribution='.urlencode($row['genre'])).'">'.number_format($row['n…
1902 				echo '<td nowrap>'.str_replace("\t", '<br>', $row['genre']).'</td>';
1903 …tmlentities($_SERVER['PHP_SELF'].'?m3u=.m3u&genredistribution='.urlencode($row['genre'])).'">.m3u<…
1918 			while ($row = mysqli_fetch_array($result)) {  variable
1920 				echo '<TD NOWRAP>'.str_replace("\t", '<br>', $row['genre']).'</td>';
1921 …echo '<td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filename'])…
1922 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1941 	while ($row = mysqli_fetch_array($result)) {  variable
1943 		echo '<TD ALIGN="RIGHT">'.number_format($row['num']).'</td>';
1944 …row['fileformat'].'|'.$row['audio_dataformat']).'">'.($row['fileformat'] ? $row['fileformat'] : '<…
1962 		while ($row = mysqli_fetch_array($result)) {  variable
1963 			echo WindowsShareSlashTranslate($row['filename'])."\n";
1973 		while ($row = mysqli_fetch_array($result)) {  variable
1975 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
1976 …echo '<td>'.(!empty($row['error'])   ? '<li>'.str_replace("\t", '<li>', htmlentities($row['error']…
1977 …echo '<td>'.(!empty($row['warning']) ? '<li>'.str_replace("\t", '<li>', htmlentities($row['warning…
1996 	while ($row = mysqli_fetch_array($result)) {  variable
1998 …if (strpos($row['warning'], 'Some ID3v1 fields do not use NULL characters for padding') !== false)…
2000 			$id3v1_writer->filename = $row['filename'];
2006 		echo htmlentities($row['filename']).'</span><br>';
2021 		while ($row = mysqli_fetch_array($result)) {  variable
2023 			echo '<TD ALIGN="RIGHT">'.htmlentities(number_format($row['num'])).'</td>';
2024 			if ($row['vbr_method']) {
2025 ….htmlentities($_SERVER['PHP_SELF'].'?vbrmethod='.$row['vbr_method'], ENT_QUOTES).'">'.htmlentities…
2040 		while ($row = mysqli_fetch_array($result)) {  variable
2041 …echo '<tr><td><a href="'.htmlentities($_SERVER['PHP_SELF'].'?m3ufilename='.urlencode($row['filenam…
2042 …ntities('demo.browse.php?filename='.rawurlencode($row['filename']), ENT_QUOTES).'">'.htmlentities(…
2059 	while ($row = mysqli_fetch_array($result)) {  variable
2061 		$CleanedFilename = CleanUpFileName($row['filename']);
2062 		if ($row['filename'] != $CleanedFilename) {
2063 			if (strtolower($lastdir) != strtolower(str_replace('/', '\\', dirname($row['filename'])))) {
2064 				$lastdir = str_replace('/', '\\', dirname($row['filename']));
2067 …echo 'ren "'.basename($row['filename']).'" "'.basename(CleanUpFileName($row['filename'])).'"'."\n";
2180 if ($row = mysqli_fetch_array($result)) {  variable
2186 	echo '<tr><th align="left">Total Files</th><td>'.number_format($row['TotalFiles']).'</td></tr>';
2187 …echo '<tr><th align="left">Total Filesize</th><td>'.number_format($row['TotalFilesize'] / 1048576)…
2188 …echo '<tr><th align="left">Total Playtime</th><td>'.number_format($row['TotalPlaytime'] / 3600, 1)…
2189 …echo '<tr><th align="left">Average Filesize</th><td>'.number_format($row['AvgFilesize'] / 1048576,…
2190 …echo '<tr><th align="left">Average Playtime</th><td>'.getid3_lib::PlaytimeString($row['AvgPlaytime…
2191 …echo '<tr><th align="left">Average Bitrate</th><td>'.BitrateText($row['AvgBitrate'] / 1000, 1).'</…