Lines Matching refs:SQLquery
115 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
116 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $from).'")';
117 mysqli_query_safe($con, $SQLquery);
159 function mysqli_query_safe($con, $SQLquery) { argument
161 if ($SQLquery === null) {
165 $result = mysqli_query($con, $SQLquery);
168 …tmlentities(mysqli_error($con)).'</div><hr size="1"><pre>'.htmlentities($SQLquery).'</pre></div>');
210 $SQLquery = 'DROP TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
211 mysqli_query_safe($con, $SQLquery);
215 $SQLquery = "CREATE TABLE `".mysqli_real_escape_string($con, GETID3_DB_TABLE)."` ("; variable
216 $SQLquery .= " `ID` int(11) unsigned NOT NULL auto_increment,";
217 $SQLquery .= " `filename` text NOT NULL,";
218 $SQLquery .= " `last_modified` int(11) NOT NULL default '0',";
219 $SQLquery .= " `md5_file` varchar(32) NOT NULL default '',";
220 $SQLquery .= " `md5_data` varchar(32) NOT NULL default '',";
221 $SQLquery .= " `md5_data_source` varchar(32) NOT NULL default '',";
222 $SQLquery .= " `filesize` int(10) unsigned NOT NULL default '0',";
223 $SQLquery .= " `fileformat` varchar(255) NOT NULL default '',";
224 $SQLquery .= " `audio_dataformat` varchar(255) NOT NULL default '',";
225 $SQLquery .= " `video_dataformat` varchar(255) NOT NULL default '',";
226 $SQLquery .= " `audio_bitrate` float NOT NULL default '0',";
227 $SQLquery .= " `video_bitrate` float NOT NULL default '0',";
228 $SQLquery .= " `playtime_seconds` varchar(255) NOT NULL default '',";
229 $SQLquery .= " `tags` varchar(255) NOT NULL default '',";
230 $SQLquery .= " `artist` varchar(255) NOT NULL default '',";
231 $SQLquery .= " `title` varchar(255) NOT NULL default '',";
232 $SQLquery .= " `remix` varchar(255) NOT NULL default '',";
233 $SQLquery .= " `album` varchar(255) NOT NULL default '',";
234 $SQLquery .= " `genre` varchar(255) NOT NULL default '',";
235 $SQLquery .= " `comment` text NOT NULL,";
236 $SQLquery .= " `track` varchar(7) NOT NULL default '',";
237 $SQLquery .= " `comments_all` longtext NOT NULL,";
238 $SQLquery .= " `comments_id3v2` longtext NOT NULL,";
239 $SQLquery .= " `comments_ape` longtext NOT NULL,";
240 $SQLquery .= " `comments_lyrics3` longtext NOT NULL,";
241 $SQLquery .= " `comments_id3v1` text NOT NULL,";
242 $SQLquery .= " `warning` longtext NOT NULL,";
243 $SQLquery .= " `error` longtext NOT NULL,";
244 $SQLquery .= " `track_volume` float NOT NULL default '0',";
245 $SQLquery .= " `encoder_options` varchar(255) NOT NULL default '',";
246 $SQLquery .= " `vbr_method` varchar(255) NOT NULL default '',";
247 $SQLquery .= " PRIMARY KEY (`ID`)";
248 $SQLquery .= ")";
249 mysqli_query_safe($con, $SQLquery);
308 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
309 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $filename).'")';
310 mysqli_query_safe($con, $SQLquery);
347 $SQLquery = 'DELETE from `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
348 $SQLquery .= ' WHERE (`fileformat` = "")';
349 mysqli_query_safe($con, $SQLquery);
359 $SQLquery = 'SELECT `filename`'; variable
360 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
361 $SQLquery .= ' WHERE (`error` <> "")';
362 $SQLquery .= ' OR (`warning` <> "")';
363 $SQLquery .= ' ORDER BY `filename` ASC';
364 $result = mysqli_query_safe($con, $SQLquery);
369 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
370 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
371 mysqli_query_safe($con, $SQLquery);
384 $SQLquery = 'SELECT COUNT(*) AS `num`, `filename`'; variable
385 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
386 $SQLquery .= ' GROUP BY `filename`';
387 $SQLquery .= ' HAVING (`num` > 1)';
388 $SQLquery .= ' ORDER BY `num` DESC';
389 $result = mysqli_query_safe($con, $SQLquery);
393 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
394 $SQLquery .= ' WHERE `filename` LIKE "'.mysqli_real_escape_string($con, $row['filename']).'"';
395 mysqli_query_safe($con, $SQLquery);
405 $SQLquery = 'SELECT `filename`'; variable
406 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
407 $SQLquery .= ' ORDER BY `filename` ASC';
408 $result = mysqli_query_safe($con, $SQLquery);
522 $SQLquery = 'UPDATE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` SET '; variable
523 …$SQLquery .= ' `last_modified` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['file…
524 …$SQLquery .= ', `md5_file` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_…
525 …$SQLquery .= ', `md5_data` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_…
526 …$SQLquery .= ', `md5_data_source` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_…
527 …$SQLquery .= ', `filesize` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['file…
528 …$SQLquery .= ', `fileformat` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['file…
529 …$SQLquery .= ', `audio_dataformat` = "'.mysqli_real_escape_string($con, !empty($ThisFileInfo['audi…
530 …$SQLquery .= ', `video_dataformat` = "'.mysqli_real_escape_string($con, !empty($ThisFileInfo['vide…
531 …$SQLquery .= ', `vbr_method` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['mpeg…
532 …$SQLquery .= ', `audio_bitrate` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['audi…
533 …$SQLquery .= ', `video_bitrate` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['vide…
534 …$SQLquery .= ', `playtime_seconds` = "'.mysqli_real_escape_string($con, !empty($ThisFileInfo['play…
535 …$SQLquery .= ', `track_volume` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['repl…
536 …$SQLquery .= ', `comments_all` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
537 …$SQLquery .= ', `comments_id3v2` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
538 …$SQLquery .= ', `comments_ape` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
539 …$SQLquery .= ', `comments_lyrics3` = "'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
540 …$SQLquery .= ', `comments_id3v1` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
541 …$SQLquery .= ', `warning` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['warn…
542 …$SQLquery .= ', `error` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['erro…
543 …$SQLquery .= ', `album` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
544 …$SQLquery .= ', `genre` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
545 …$SQLquery .= ', `comment` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
546 …$SQLquery .= ', `artist` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['comm…
547 …$SQLquery .= ', `tags` = "'. mysqli_real_escape_string($con, !empty($ThisFileInfo['tags…
548 …$SQLquery .= ', `encoder_options` = "'. mysqli_real_escape_string($con, trim((!empty($ThisFileInfo…
549 $SQLquery .= ', `title` = "'. mysqli_real_escape_string($con, $this_track_title).'"';
550 $SQLquery .= ', `remix` = "'. mysqli_real_escape_string($con, $this_track_remix).'"';
551 $SQLquery .= ', `track` = "'. mysqli_real_escape_string($con, $this_track_track).'"';
552 …$SQLquery .= ' WHERE (`filename` = "'. mysqli_real_escape_string($con, isset($ThisFileInfo['filena…
557 …$SQLquery = 'INSERT INTO `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'` (`filename`, `las… variable
558 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['filenamepath'] …
559 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['file_modified_time'] …
560 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_file'] …
561 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_data'] …
562 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['md5_data_source'] …
563 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['filesize'] …
564 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['fileformat'] …
565 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['audio']['dataformat'] …
566 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['video']['dataformat'] …
567 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['audio']['bitrate'] …
568 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['video']['bitrate'] …
569 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['playtime_seconds'] …
571 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags'] …
572 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments']['artist'] …
573 $SQLquery .= '"'.mysqli_real_escape_string($con, $this_track_title).'", ';
574 $SQLquery .= '"'.mysqli_real_escape_string($con, $this_track_remix).'", ';
575 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments']['album'] …
576 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments']['genre'] …
577 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments']['comment'] …
578 $SQLquery .= '"'.mysqli_real_escape_string($con, $this_track_track).'", ';
579 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['comments'] …
580 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags']['id3v2'] …
581 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags']['ape'] …
582 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags']['lyrics3'] …
583 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['tags']['id3v1'] …
584 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['warning'] …
585 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['error'] …
586 …$SQLquery .= '"'.mysqli_real_escape_string($con, trim((!empty($ThisFileInfo['audio']['encoder']) ?…
587 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['mpeg']['audio']['LAME']) ? …
588 …$SQLquery .= '"'.mysqli_real_escape_string($con, !empty($ThisFileInfo['replay_gain']['track']['vol…
592 mysqli_query_safe($con, $SQLquery);
597 $SQLquery = 'OPTIMIZE TABLE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
598 mysqli_query_safe($con, $SQLquery);
607 $SQLquery = 'SELECT `filename`'; variable
608 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
609 $SQLquery .= ' WHERE (`track_volume` = 0)';
610 $SQLquery .= ' AND (`audio_bitrate` > 0)';
611 $result = mysqli_query_safe($con, $SQLquery);
622 $SQLquery = 'UPDATE `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
623 $SQLquery .= ' SET `track_volume` = "'.$ThisFileInfo['replay_gain']['track']['volume'].'"';
624 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
625 mysqli_query_safe($con, $SQLquery);
631 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
632 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
633 mysqli_query_safe($con, $SQLquery);
642 $SQLquery = 'SELECT COUNT(*) AS `num`, `filename`'; variable
643 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
644 $SQLquery .= ' GROUP BY `filename`';
645 $SQLquery .= ' ORDER BY `num` DESC';
646 $result = mysqli_query_safe($con, $SQLquery);
654 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
655 $SQLquery .= ' WHERE `filename` LIKE "'.mysqli_real_escape_string($con, $row['filename']).'"';
656 mysqli_query_safe($con, $SQLquery);
663 $SQLquery = 'SELECT `filename`, `filesize`, `last_modified`'; variable
664 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
665 $SQLquery .= ' ORDER BY `filename` ASC';
666 $result = mysqli_query_safe($con, $SQLquery);
691 $SQLquery = 'DELETE FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`'; variable
692 $SQLquery .= ' WHERE (`filename` = "'.mysqli_real_escape_string($con, $row['filename']).'")';
693 mysqli_query_safe($con, $SQLquery);
713 $SQLquery = 'SELECT `filename`, `comments_id3v2`'; variable
714 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
715 …$SQLquery .= ' WHERE (`encoder_options` = "'.mysqli_real_escape_string($con, $_REQUEST['encodedbyd…
716 $result = mysqli_query_safe($con, $SQLquery);
737 $SQLquery = 'SELECT `filename`, `comments_id3v2`'; variable
738 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
739 $result = mysqli_query_safe($con, $SQLquery);
752 $SQLquery = 'SELECT `encoder_options`, `comments_id3v2`'; variable
753 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
754 …$SQLquery .= ' ORDER BY (`encoder_options` LIKE "LAME%") DESC, (`encoder_options` LIKE "CBR%") DES…
755 $result = mysqli_query_safe($con, $SQLquery);
789 $SQLquery = 'SELECT ROUND(audio_bitrate / 1000) AS `RoundBitrate`, COUNT(*) AS `num`'; variable
790 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
791 $SQLquery .= ' WHERE (`audio_bitrate` > 0)';
792 $SQLquery .= ' GROUP BY `RoundBitrate`';
793 $result = mysqli_query_safe($con, $SQLquery);
816 $SQLquery = 'SELECT `fileformat`, `filename`, `genre`'; variable
817 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
818 $SQLquery .= ' WHERE (`genre` = "")';
819 $SQLquery .= ' OR (`genre` = "Unknown")';
820 $SQLquery .= ' OR (`genre` = "Other")';
821 $SQLquery .= ' ORDER BY `filename` ASC';
822 $result = mysqli_query_safe($con, $SQLquery);
857 $SQLquery = 'SELECT `filename`, `comment`'; variable
858 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
859 $SQLquery .= ' WHERE (`comment` <> "")';
860 $SQLquery .= ' ORDER BY `comment` ASC';
861 $result = mysqli_query_safe($con, $SQLquery);
897 $SQLquery = 'SELECT `filename`, `track`'; variable
898 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
899 $SQLquery .= ' WHERE (`track` <> "")';
900 $SQLquery .= ' AND ((`track` < "1")';
901 $SQLquery .= ' OR (`track` > "99"))';
902 $SQLquery .= ' ORDER BY `filename` ASC';
903 $result = mysqli_query_safe($con, $SQLquery);
940 $SQLquery = 'SELECT `filename`, `title`'; variable
941 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
942 $SQLquery .= ' WHERE (`title` LIKE "%feat.%")';
943 $SQLquery .= ' ORDER BY `filename` ASC';
944 $result = mysqli_query_safe($con, $SQLquery);
975 $SQLquery = 'SELECT `filename`, `track`, `album`'; variable
976 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
977 $SQLquery .= ' WHERE (`track` <> "")';
978 $SQLquery .= ' AND (`album` = "")';
979 $SQLquery .= ' ORDER BY `filename` ASC';
980 $result = mysqli_query_safe($con, $SQLquery);
1063 …$SQLquery = 'SELECT `filename`, `comments_all`, `comments_id3v2`, `comments_ape`, `comments_lyric… variable
1064 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1065 $SQLquery .= ' WHERE (`fileformat` = "mp3")';
1066 $SQLquery .= ' ORDER BY `filename` ASC';
1067 $result = mysqli_query_safe($con, $SQLquery);
1343 $SQLquery = 'SELECT `filename`, `fileformat`, '.implode(', ', $FieldNames); variable
1344 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1345 …$SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreN…
1346 $SQLquery .= ' ORDER BY `filename` ASC';
1347 $result = mysqli_query_safe($con, $SQLquery);
1470 …$SQLquery = 'SELECT `filename`, `encoder_options` FROM `'.mysqli_real_escape_string($con, GETID3_… variable
1471 …$SQLquery .= ' WHERE (`encoder_options` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['showtag…
1472 …$SQLquery .= ' AND (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoT…
1473 $SQLquery .= ' ORDER BY `filename` ASC';
1474 $result = mysqli_query_safe($con, $SQLquery);
1502 …$SQLquery = 'SELECT `encoder_options`, COUNT(*) AS `num` FROM `'.mysqli_real_escape_string($con, … variable
1503 …$SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreN…
1504 $SQLquery .= ' GROUP BY `encoder_options`';
1505 …$SQLquery .= ' ORDER BY (`encoder_options` LIKE "LAME%") DESC, (`encoder_options` LIKE "CBR%") DES…
1506 $result = mysqli_query_safe($con, $SQLquery);
1524 …$SQLquery = 'SELECT `tags`, COUNT(*) AS `num` FROM `'.mysqli_real_escape_string($con, GETID3_DB_T… variable
1525 …$SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreN…
1526 $SQLquery .= ' GROUP BY `tags`';
1527 $SQLquery .= ' ORDER BY `num` DESC';
1528 $result = mysqli_query_safe($con, $SQLquery);
1543 …$SQLquery = 'SELECT `filename`, `tags` FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'… variable
1544 …$SQLquery .= ' WHERE (`tags` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['showtagfiles']).'"…
1545 …$SQLquery .= ' AND (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoT…
1546 $SQLquery .= ' ORDER BY `filename` ASC';
1547 $result = mysqli_query_safe($con, $SQLquery);
1578 $SQLquery = 'SELECT `md5_data`, `filename`, COUNT(*) AS `num`'; variable
1579 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1580 $SQLquery .= ' WHERE (`md5_data` <> "")';
1581 $SQLquery .= ' GROUP BY `md5_data`';
1582 $SQLquery .= ' ORDER BY `num` DESC';
1583 $result = mysqli_query_safe($con, $SQLquery);
1590 $SQLquery = 'SELECT `fileformat`, `filename`, `tags`'; variable
1591 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1592 $SQLquery .= ' WHERE (`md5_data` = "'.mysqli_real_escape_string($con, $row['md5_data']).'")';
1593 $SQLquery .= ' ORDER BY `filename` ASC';
1594 $result2 = mysqli_query_safe($con, $SQLquery);
1626 $SQLquery = 'SELECT `filename`'; variable
1627 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1628 $SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $_REQUEST['m3uartist']).'")';
1629 $SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $_REQUEST['m3utitle']).'")';
1630 $SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';
1631 $result = mysqli_query_safe($con, $SQLquery);
1639 $SQLquery = 'SELECT `artist`, `title`, `filename`, COUNT(*) AS `num`'; variable
1640 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1641 $SQLquery .= ' WHERE (`artist` <> "")';
1642 $SQLquery .= ' AND (`title` <> "")';
1643 $SQLquery .= ' GROUP BY `artist`, `title`'.(!empty($_REQUEST['samemix']) ? ', `remix`' : '');
1644 …$SQLquery .= ' ORDER BY `num` DESC, `artist` ASC, `title` ASC, `playtime_seconds` ASC, `remix` ASC…
1645 $result = mysqli_query_safe($con, $SQLquery);
1654 $SQLquery = 'SELECT `filename`'; variable
1655 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
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']).'")';
1661 $SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';
1662 $result2 = mysqli_query_safe($con, $SQLquery);
1686 …$SQLquery = 'SELECT `filename`, `artist`, `title`, `remix`, `audio_bitrate`, `vbr_method`, `playt… variable
1687 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1688 $SQLquery .= ' WHERE (`artist` = "'.mysqli_real_escape_string($con, $row['artist']).'")';
1689 $SQLquery .= ' AND (`title` = "'.mysqli_real_escape_string($con, $row['title']).'")';
1690 $SQLquery .= ' ORDER BY `playtime_seconds` ASC, `remix` ASC, `filename` ASC';
1691 $result2 = mysqli_query_safe($con, $SQLquery);
1741 $SQLquery = 'SELECT `filename`, `fileformat`, `audio_dataformat`'; variable
1742 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1743 $SQLquery .= ' WHERE (`fileformat` = "'.mysqli_real_escape_string($con, $fileformat).'")';
1744 $SQLquery .= ' AND (`audio_dataformat` = "'.mysqli_real_escape_string($con, $audioformat).'")';
1745 $SQLquery .= ' ORDER BY `filename` ASC';
1746 $result = mysqli_query_safe($con, $SQLquery);
1760 $SQLquery = 'SELECT `filename`, `album`'; variable
1761 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1762 $SQLquery .= ' WHERE (`album` LIKE "% [%")';
1763 $SQLquery .= ' ORDER BY `album` ASC, `filename` ASC';
1764 $result = mysqli_query_safe($con, $SQLquery);
1834 $SQLquery = 'SELECT `filename`, `fileformat`, `audio_dataformat`, `video_dataformat`, `tags`'; variable
1835 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1836 $SQLquery .= ' ORDER BY `filename` ASC';
1837 $result = mysqli_query_safe($con, $SQLquery);
1870 $SQLquery = 'SELECT `filename`'; variable
1871 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1872 $SQLquery .= ' WHERE (BINARY `genre` = "'.$_REQUEST['genredistribution'].'")';
1873 …$SQLquery .= ' AND (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreNoT…
1874 $SQLquery .= ' ORDER BY `filename` ASC';
1875 $result = mysqli_query_safe($con, $SQLquery);
1885 $SQLquery = 'SELECT COUNT(*) AS `num`, `genre`'; variable
1886 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1887 …$SQLquery .= ' WHERE (`fileformat` NOT LIKE "'.implode('") AND (`fileformat` NOT LIKE "', $IgnoreN…
1888 $SQLquery .= ' GROUP BY `genre`';
1889 $SQLquery .= ' ORDER BY `num` DESC';
1890 $result = mysqli_query_safe($con, $SQLquery);
1910 $SQLquery = 'SELECT `filename`, `genre`'; variable
1911 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1912 …$SQLquery .= ' WHERE (`genre` LIKE "'.mysqli_real_escape_string($con, $_REQUEST['genredistribution…
1913 $SQLquery .= ' ORDER BY `filename` ASC';
1914 $result = mysqli_query_safe($con, $SQLquery);
1934 $SQLquery = 'SELECT `fileformat`, `audio_dataformat`, COUNT(*) AS `num`'; variable
1935 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1936 $SQLquery .= ' GROUP BY `fileformat`, `audio_dataformat`';
1937 $SQLquery .= ' ORDER BY `num` DESC';
1938 $result = mysqli_query_safe($con, $SQLquery);
1951 $SQLquery = 'SELECT `filename`, `error`, `warning`'; variable
1952 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1953 $SQLquery .= ' WHERE (`error` <> "")';
1954 $SQLquery .= ' OR (`warning` <> "")';
1955 $SQLquery .= ' ORDER BY `filename` ASC';
1956 $result = mysqli_query_safe($con, $SQLquery);
1988 $SQLquery = 'SELECT `filename`, `error`, `warning`'; variable
1989 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
1990 $SQLquery .= ' WHERE (`fileformat` = "mp3")';
1991 $SQLquery .= ' AND (`warning` <> "")';
1992 $SQLquery .= ' ORDER BY `filename` ASC';
1993 $result = mysqli_query_safe($con, $SQLquery);
2014 $SQLquery = 'SELECT COUNT(*) AS `num`, `vbr_method`'; variable
2015 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
2016 $SQLquery .= ' GROUP BY `vbr_method`';
2017 $SQLquery .= ' ORDER BY `vbr_method`';
2018 $result = mysqli_query_safe($con, $SQLquery);
2035 $SQLquery = 'SELECT `filename`'; variable
2036 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
2037 …$SQLquery .= ' WHERE (`vbr_method` = "'.mysqli_real_escape_string($con, $_REQUEST['vbrmethod']).'"…
2038 $result = mysqli_query_safe($con, $SQLquery);
2051 $SQLquery = 'SELECT `filename`, `fileformat`'; variable
2052 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
2053 $SQLquery .= ' WHERE (`fileformat` <> "")';
2054 $SQLquery .= ' ORDER BY `filename` ASC';
2055 $result = mysqli_query_safe($con, $SQLquery);
2177 $SQLquery = 'SELECT COUNT(*) AS `TotalFiles`, SUM(`playtime_seconds`) AS `TotalPlaytime`, SUM(`fil… variable
2178 $SQLquery .= ' FROM `'.mysqli_real_escape_string($con, GETID3_DB_TABLE).'`';
2179 $result = mysqli_query_safe($con, $SQLquery);