<?php
/*------------------------------------------------------------------------*/
// Product: PHP MELODY - MUSIC VIDEO CMS
// Version: 1.1
// Released: 14th OCTOBER 2007
// Copyright: (c) 2004-2007. All rights reserved.
/*------------------------------------------------------------------------*/
require('config.php');
require_once('include/functions.php');
function degis($str) {
  $str = ereg_replace('ç', 'c', $str);
  $str = ereg_replace('ğ', 'g', $str);
  $str = ereg_replace('&amp;#287;', 'g', $str);
  $str = ereg_replace('ı', 'i', $str);
  $str = ereg_replace('&amp;#305;', 'i', $str);
  $str = ereg_replace('ö', 'o', $str);
  $str = ereg_replace('ş', 's', $str);
    $str = ereg_replace('&amp;#351;', 's', $str);
  $str = ereg_replace('ü', 'u', $str);
  $str = ereg_replace('Ç', 'C', $str);
  $str = ereg_replace('Ğ', 'G', $str);
  $str = ereg_replace('İ', 'I', $str);
   $str = ereg_replace('&amp;#304;', 'I', $str);
  $str = ereg_replace('Ö', 'O', $str);
  $str = ereg_replace('Ş', 'S', $str);
  $str = ereg_replace('Ü', 'U', $str);
  return $str;
} 
$rssVersion = 2.0;
$cat = $_GET['c'];

if(empty($cat)) {
$query = "SELECT * FROM pm_videos ORDER BY added DESC LIMIT 10";
}
elseif(!empty($cat) && is_numeric($cat)) { 
$query = "SELECT * FROM pm_videos WHERE category = '".$cat."' ORDER BY added DESC limit 10";
}
function clean_feed($input) {
	$original = array("<", ">", "&", '"');
	$replaced = array("&lt;", "&gt;", "&amp;", "&quot;");
	$newinput = str_replace($original, $replaced, $input);
	return $newinput;
}
function generateFeed ( $homeURL, $title, $version = '2.0', $query) {
// a little check for the arguments thrown in.
if (func_num_args() < 2)
exit ("Insufficant Parameters");
// only select the columns you need, thus reducing the work the DBMS has to do.
// execute the query
$results = mysql_query ($query) or exit(mysql_error());

// check for the number of rows returned before doing any further actions.
if (mysql_num_rows ($results) == 0){
exit("Nothing to show.");
}
else {
$rss = "";
// tell the browser we want xml output by setting the following header.
header("Content-Type: text/xml; charset=iso-8859-9");
$rss .= "<rss version=\"0.92\">\r\n";
$rss .= "<channel>\r\n";
$rss .= "<title>" . ucwords($title) . " - RSS Feed</title>\r\n";
$rss .= "<link>" . $homeURL . "</link>\r\n";

while ($row = mysql_fetch_array($results)){
	$date = date('Y-m-d', $row['added']);
	$rss .= "<item>\r\n";
	$rss .= "<title>" . degis(clean_feed($row['video_title'])) . " by " . degis(clean_feed($row['artist'])) . "</title>\r\n";
	$rss .= "<description>" . degis(clean_feed($row['video_title'])) . " muzik video by " . degis(clean_feed($row['artist'])) . " added on ".$date."</description>\r\n";
	$rss .= "<link>"._URL."/musicvideo.php?vid=".$row['uniq_id']."</link>\r\n";
	$rss .= "</item>\r\n\r\n";
}

$rss .= "</channel>\r\n";
$rss .= "</rss>\r\n";

echo $rss;
}
}
// call the function with all our settings from the top of the script
generateFeed( _URL , _SITENAME, $rssVersion, $query );

?>