[xiph-commits] r18639 - branches/dir.xiph.org/cronjobs

[dm8tbr at svn.xiph.org]

Author: dm8tbr
Date: 2012-10-05 05:44:18 -0700 (Fri, 05 Oct 2012)
New Revision: 18639

Modified:
   branches/dir.xiph.org/cronjobs/generate_xml.php
Log:
Add noise-filter to YP XML output for dir.xiph.org.


Modified: branches/dir.xiph.org/cronjobs/generate_xml.php
===================================================================
--- branches/dir.xiph.org/cronjobs/generate_xml.php	2012-10-01 06:41:38 UTC (rev 18638)
+++ branches/dir.xiph.org/cronjobs/generate_xml.php	2012-10-05 12:44:18 UTC (rev 18639)
@@ -12,7 +12,8 @@
 
 // Get data
 //$query = "SELECT m.`stream_name`, s.`listen_url`, m.`media_type_id`, m.`bitrate`, m.`channels`, m.`samplerate`, GROUP_CONCAT(t.`tag_name` SEPARATOR ' ') AS `genre`, m.`current_song` FROM `mountpoint` AS m INNER JOIN `server` AS s ON m.`id` = s.`mountpoint_id` INNER JOIN `mountpoints_tags` AS mt ON mt.`mountpoint_id` = m.`id` INNER JOIN `tag` AS t ON mt.`tag_id` = t.`id` GROUP BY s.`id` ORDER BY m.`listeners` DESC LIMIT 1000;";
-$query = "SELECT m.`stream_name`, s.`listen_url`, m.`media_type_id`, m.`bitrate`, m.`channels`, m.`samplerate`, GROUP_CONCAT(t.`tag_name` SEPARATOR ' ') AS `genre`, m.`current_song` FROM `mountpoint` AS m INNER JOIN `server` AS s ON m.`id` = s.`mountpoint_id` INNER JOIN `mountpoints_tags` AS mt ON mt.`mountpoint_id` = m.`id` INNER JOIN `tag` AS t ON mt.`tag_id` = t.`id` GROUP BY s.`id` ORDER BY m.`listeners` DESC;";
+//$query = "SELECT m.`stream_name`, s.`listen_url`, m.`media_type_id`, m.`bitrate`, m.`channels`, m.`samplerate`, GROUP_CONCAT(t.`tag_name` SEPARATOR ' ') AS `genre`, m.`current_song` FROM `mountpoint` AS m INNER JOIN `server` AS s ON m.`id` = s.`mountpoint_id` INNER JOIN `mountpoints_tags` AS mt ON mt.`mountpoint_id` = m.`id` INNER JOIN `tag` AS t ON mt.`tag_id` = t.`id` GROUP BY s.`id` ORDER BY m.`listeners` DESC;";
+$query = "SELECT m.`stream_name`, s.`listen_url`, m.`media_type_id`, m.`bitrate`, m.`channels`, m.`samplerate`, GROUP_CONCAT(t.`tag_name` SEPARATOR ' ') AS `genre`, m.`current_song`  FROM `mountpoint` AS m  INNER JOIN `server`  AS s ON m.`id` = s.`mountpoint_id`  INNER JOIN `mountpoints_tags` AS mt ON mt.`mountpoint_id` = m.`id`  INNER JOIN `tag` AS t ON mt.`tag_id` = t.`id` WHERE s.`listeners` >1 OR s.`listen_url` NOT LIKE 'http://%.radionomy.com:80/%' GROUP BY s.`id` ORDER BY m.`listeners` DESC;";
 $res = $db->selectQuery($query)->array_data;
 shuffle($res);
 $tpl->assign_by_ref('streams', $res);