RSS feed info

[cashbagg]

I'm wondering if I can display only RSS feeds from the larger tube sites as the only video content?

I'm just starting out and have no videos hosted. Is this an option?

[symtab]

Hi,

This feature is not available by default in clipshare.

[hazem]

copy the code in rss

Code:

<?php

include("include/dbconfig.php");
include("include/config.php");

if ($_GET[type] == "new")
{
$query = "SELECT A.*,B.UID,B.username FROM video A, signup B WHERE A.UID=B.UID AND A.type = 'public' and A.active='1' ORDER BY A.VID desc LIMIT 20";
$titel = "[Newest videos]";
$url = $config['BASE_URL']."/rss/new/";
}
elseif ($_GET[type] == "views")
{
$query = "SELECT A.*,B.UID,B.username FROM video A, signup B WHERE A.UID=B.UID AND A.type = 'public' and A.active='1' ORDER BY A.viewnumber desc LIMIT 20";
$titel = "[Most Viewed videos]";
$url = $config['BASE_URL']."/rss/views/";
}
elseif ($_GET[type] == "comments")
{
$query = "SELECT A.*,B.UID,B.username FROM video A, signup B WHERE A.UID=B.UID AND A.type = 'public' and A.active='1' ORDER BY A.com_num desc LIMIT 20";
$titel = "[Most Commented videos]";
$url = $config['BASE_URL']."/rss/comments/";
}

else
{
$query = "SELECT A.*,B.UID,B.username FROM video A, signup B WHERE A.UID=B.UID AND A.type = 'public' and A.active='1' ORDER BY A.VID desc LIMIT 20";
$titel = "[Newest videos]";
$url = $config['BASE_URL']."/rss/new/";
}


header("Content-Type: text/xml");
header("Expires: 0");
print "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n";
print "<rss version=\"2.0\" xmlns:media=\"http://search.yahoo.com/mrss \">\n";
print "<channel>\n";
print "<title>".$config['site_name']." - ".$titel."</title>\n";
print "<link>".$url."</link>\n";
print "<description>".$titel."</description>\n";
print "<copyright>Copyright (c) 2006-2007 by ".$config['site_name']." - All rights reserved.</copyright>\n";
print "<image>\n";
print "<title>".$config['site_name']."</title>\n";
print "<link>".$config['BASE_URL']."/</link>\n";
print "</image>\n";

$db=mysql_connect ($DBHOST,$DBUSER,$DBPASSWORD) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($DBNAME);

$num_rows = mysql_num_rows(mysql_query("select * from video"));

$result = mysql_query($query) or die ('Query Error: ' . mysql_error());
while ($results = mysql_fetch_array($result))
{
$photo = $config['BASE_URL']."/thumb/1_".$results['VID'].".jpg";
$video = $config['BASE_URL']."/view_video.php?viewkey=".$results['vkey'];
$description = $results['description'];
$description = str_replace ("&amp","",htmlspecialchars(stripslashes($descript ion)));
$photo = str_replace ("&amp","&amp",htmlspecialchars(stripslashes($phot o)));
$results[username] = str_replace ("&amp","&amp",htmlspecialchars(stripslashes($resu lts[username])));
$results[keyword] = str_replace ("&amp","&amp",htmlspecialchars(stripslashes($resu lts[keyword])));

print "<item>\n";
print " <title>".$results['title']."</title>\n";
print " <link>".$video."</link>\n";
print " <description>\n";
print " <![CDATA[";
print "<img src=\"$photo\" align=\"right\" border=\"0\" width=\"174\" height=\"130\" vspace=\"4\" hspace=\"4\" /><br /><br />
<p>".$description."</p><p>".$key."</p>
<p><b>Watch here:</b> <a href=\"".$video."\">".$video."</a></p>
<p>Added by: <a href=\"$config[BASE_URL]/uprofile.php?UID=".$results[UID]."\">".$results[username]."</a><br/>
Tags: ";

$tok = strtok($results[keyword], " ");
while ($tok !== false)
{
print "<a href=\"$config[BASE_URL]/search_result.php?search_id=".$tok."\">".$tok."</a> ";
$tok = strtok(" ");
}
print "<br />Date: ".$results[adddate]."<br/></p><br /><hr>";
print " ]]>\n";
print " </description>\n";
print " <author>".$results[username]."</author>\n";
print "</item>\n";
}
mysql_close();
print "</channel>";
print "</rss>";
?>

[guynuked]

I have the latest CS, is this rss modification still good? Is it validated?

[opal]

Well when i click rss and select for example latest 20 i see them, but if i click on video titl it move to site and says that video dont exist... lol ?

Bad httacces. Fixed allready. And seo links must be on.