yp-update-majingy.php

<?php 
 
// Inclusions 
include_once(dirname(__FILE__).'/../inc/prepend.php'); 
 
ini_set('memory_limit', '192M'); 
 
define('XML_OUTPUT', dirname(__FILE__).'/../xml/yp.xml'); 
 
// Database connection 
$db = DirXiphOrgDBC::getInstance();

// 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` 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);                                                                                                                                                                                 $xml = $tpl->fetch('yp.xml.tpl');
                                                                                                                                                                                                                      // Write data
$temp_filename = XML_OUTPUT.'.tmp.'. sha1(uniqid(rand(), true));                                                                                                                                                      echo $temp_filename."\n";                                                                                                                                                                                             $fp = fopen($temp_filename, 'w');
$l = fwrite($fp, $xml);
fclose($fp);
if ($l == strlen($xml))
{
    if (rename($temp_filename, XML_OUTPUT))
    {  
        echo "OK.\n";
        exit();
    }
}
 
echo "KO.\n";
 
?>