<?php

function csere($text)
{
   $win = array ("<", ">", '"', '&');
   $iso = array ("&lt;", "&gt;", "&quot;", "&amp;");
   return str_replace($win, $iso, $text);
}

  require_once 'rss_generator.inc.php';

  $rss_channel = new rssGenerator_channel();
  $rss_channel->title = 'Friss videók';
  $rss_channel->link = 'http://video.keresom.hu';
  $rss_channel->description = 'A legújabb videók a hazai videó megosztó portálokról';
  $rss_channel->language = 'hu-hu';
  $rss_channel->generator = 'Feed Generator';
//  $rss_channel->managingEditor = 'webmaster@keresom.hu';
 // $rss_channel->webMaster = 'webmaster@keresom.hu';


include("../inc/connect.php");

/*

$database="keresom_video3";
	$mysql_user = "pokocska";
	$mysql_password = "pokalom"; 
	$mysql_host = "localhost";
	$mysql_table_prefix = "";


	$success = mysql_connect ($mysql_host, $mysql_user, $mysql_password);
	if (!$success)
		die ("<b>Cannot connect to database, check if username, password and host are correct.</b>");
    $success = mysql_select_db ($database);
	if (!$success) {
		print "<b>Cannot choose database, check if database name is correct.";
		die();
	}
mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');
*/

/*

function video( $tabla) {
$sql_min = "select max(kulcs) AS kicsi  from $tabla group by oldal";
$mineredm = mysql_query($sql_min) or die(mysql_query());
while ($vid = mysql_fetch_object($mineredm)) {
$kival[] = $vid->kicsi;
}
$sql = "select kep, leiras, link from $tabla where kulcs='$kival[0]' or kulcs='$kival[1]' or kulcs='$kival[2]' or kulcs='$kival[3]' or kulcs='$kival[4]' or kulcs='$kival[5]' order by kulcs asc";
$eredm = mysql_query($sql) or die(mysql_query());
return $eredm;
}
*/

function video( $tabla) {
$sql_min = "select max(kulcs) AS kicsi  from $tabla group by oldal";
$mineredm = mysql_query($sql_min) or die(mysql_query());
while ($vid = mysql_fetch_object($mineredm)) {
$kival[] = $vid->kicsi;
//$kival[] = $vid->kicsi2;
}
$sql = "select kep, leiras, link from $tabla where kulcs='$kival[0]' or kulcs='$kival[1]' or kulcs='$kival[2]' or kulcs='$kival[3]' or kulcs='$kival[4]' or kulcs='$kival[5]' or kulcs='$kival[6]' or kulcs='$kival[7]' or kulcs='$kival[8]' or kulcs='$kival[9]' or kulcs='$kival[10]' or kulcs='$kival[11]' order by rand() limit 10";
//print $sql;
$eredm = mysql_query($sql) or die(mysql_error());
return $eredm;
}


$adatb = video('video_friss');
while ($vid = mysql_fetch_object($adatb)) {
	  
	  $item = new rssGenerator_item();
	  $item->title = csere($vid->leiras);
	  $item->description = "&lt;a href=&quot;".$vid->link."&quot; target=&quot;_blank&quot;&gt;&lt;img src=&quot;".$vid->kep."&quot; width=&quot;120&quot; height=&quot;90&quot; &gt;&lt;/a&gt;";
	  $item->link = "$vid->link";
	  $item->pubDate = date('r');
	  $rss_channel->items[] = $item;

}


  $rss_feed = new rssGenerator_rss();
  $rss_feed->encoding = 'utf-8';
  $rss_feed->version = '2.0';


  header('Content-Type: text/xml; charset=utf-8');
  echo $rss_feed->createFeed($rss_channel);


mysql_close();


?>