RSS Problem

[werushka]

In my web site i have rss.php it is working fine but the special characters does not show right some characters I can not see and some characters I see as ?.

I checkt the DB and it seems that everything is fine there...

 

What am I doing wrong?

 

Really appreciate any feed back.

[p2grace]

This is because those characters were copied from Microsoft Word or some other program with unique special characters.  Simply retype those characters in (or use the html substitute) and that should fix your problem.

[werushka]

Thanks for you reply.

 

Actually in rss.php there are no special characters. In my web site there are special characters like headline have special characters and sows allright on the web site. But unfortunitally if the use wants to click on RSS icon to keep an eye of the headlines s/he can do it but in tht case the special characters are noe shown correctly.

 

Hope I a clearer.

[p2grace]

Try coping all of the text in the rss feed into textpad or something then copying it back.  You need to make sure that all of the special formatting is removed.

[werushka]

Try coping all of the text in the rss feed into textpad or something then copying it back.  You need to make sure that all of the special formatting is removed.

 

Ok this is what I done I have removed all the special charaters from rss.php and than I have copied all selected text into texpad than pasted it than copied again and pasted in the rss.php on the server from plesk file management utility.

 

But it does not work...there is a trick on doing it but I don't know how.

[werushka]

OK i saved as UTF-8 and I am seeing the feed as just text and on top of the page i see this .

[werushka]

Can anyone please help me I need to know how to save this file.

[p2grace]

Could you try showing us the rss file, seeing it might help

[werushka]

<?php
// The source code packaged with this file is Free Software, Copyright (C) 2005 by
// Ricardo Galli <gallir at uib dot es>.
// It's licensed under the AFFERO GENERAL PUBLIC LICENSE unless stated otherwise.
// You can get copies of the licenses here:
// 		http://www.affero.org/oagpl.html
// AFFERO GENERAL PUBLIC LICENSE is also included in the file called "COPYING".

include_once('Smarty.class.php');
$main_smarty = new Smarty;

include('config.php');
include(mnminclude.'link.php');
include(mnminclude.'html1.php');
include(mnminclude.'search.php');
include_once(mnminclude.'smartyvariables.php');

if(!empty($_REQUEST['rows']))
$rows = $_REQUEST['rows'];
else $rows = 40;

if(!empty($_REQUEST['time'])) {
// Prepare for times
if(!($time = check_integer('time')))
	die;
$sql = "SELECT link_id, count(*) as votes FROM " . table_votes . ", " . table_links . " WHERE  ";
if ($time > 0) {
	$from = time()-$time;
	$sql .= "vote_date > FROM_UNIXTIME($from) AND ";
}
$sql .= "vote_link_id=link_id  AND link_status != 'discard' GROUP BY vote_link_id  ORDER BY votes DESC LIMIT $rows";

$last_modified = time();
$title = $main_smarty->get_config_vars('PLIGG_Visual_RSS_Recent') . ' ' . txt_time_diff($from);
$link_date = "";

} else {
// All the others
$tmpsearch = new Search;
if(isset($_REQUEST['search'])){
	$tmpsearch->searchTerm = sanitize($_REQUEST['search'], 3);
} else {
	$tmpsearch->searchTerm = '';
}
$search = $tmpsearch->get_search_clause();
// The link_status to search
if(!empty($_REQUEST['status'])) {
	$status = $_REQUEST['status'];
} else {
	// By default it searches on all
	if($search) $status = 'published';
	else $status = 'published';
}

switch ($status) {
	case 'published':
		$order_field = 'link_published_date';
		$link_date = 'published_date';
		$title = " / " . $main_smarty->get_config_vars("PLIGG_Visual_Published_News");
		break;
	case 'queued':
		$title = " / " . $main_smarty->get_config_vars("PLIGG_Visual_Pligg_Queued");
		$order_field = 'link_date';
		$link_date = "date";
		break;
	case 'all':
		$title = "";
		$order_field = 'link_date';
		$link_date = "date";
		break;
	default:
		$main_smarty->assign('tpl_center', '404error');
		$main_smarty->display($the_template . '/pligg.tpl');
		die();
		break;
}

if($status == 'all') {
	$from_where = "FROM " . table_links . " WHERE link_status!='discard' ";
} else {
	$from_where = "FROM " . table_links . " WHERE link_status='$status' ";
}
if(($cat=check_integer('category'))) {
	$from_where .= " AND link_category=$cat ";
	$category_name = $db->get_var("SELECT category_name FROM " . table_categories . " WHERE category_id = $cat AND category_lang='$dblang'");
	$title .= " / " . htmlspecialchars($category_name);
}

// This doesn't seem to work -kb
if($search) {
	$from_where .= $search;
	$title = htmlspecialchars($_REQUEST['search']);
}

$order_by = " ORDER BY $order_field DESC ";
$last_modified = $db->get_var("SELECT UNIX_TIMESTAMP(max($order_field)) links $from_where");
$sql = "SELECT link_id $from_where $order_by LIMIT $rows";
}

do_rss_header($title);

$link = new Link;
$links = $db->get_col($sql);
if ($links) {
foreach($links as $link_id) {
	$link->id=$link_id;
	$link->read();
	$category_name = $db->get_var("SELECT category_name FROM " . table_categories . " WHERE category_id = $link->category AND category_lang='$dblang'");

	$link->link_summary = str_replace("\n", "<br />", $link->link_summary);
	$link->link_summary = str_replace("’", "'", $link->link_summary);
	$link->link_summary = str_replace("–", "-", $link->link_summary);
	$link->link_summary = str_replace("—", "-", $link->link_summary);
	$link->link_summary = str_replace("“", "\"", $link->link_summary);
	$link->link_summary = str_replace("”", "\"", $link->link_summary);		

	$description = $link->link_summary;
	$description = strip_tags($description);
	$description = htmlspecialchars($description);

	$title = $link->title;
	$title = strip_tags($title);
	$title = htmlspecialchars($title);
	$link->title = str_replace("á", "a", $link->title);
	$link->title = str_replace("é", "e", $link->title);
	$link->title = str_replace("í", "i", $link->title);
	$link->title = str_replace("ó", "o", $link->title);
	$link->title = str_replace("ú", "u", $link->title);
	$link->title = str_replace("ñ", "n", $link->title);
	$link->title = str_replace("Á", "A", $link->title);
	$link->title = str_replace("É", "E", $link->title);
	$link->title = str_replace("Í", "I", $link->title);
	$link->title = str_replace("Ó", "O", $link->title);
	$link->title = str_replace("Ú", "U", $link->title);
	$link->title = str_replace("¿", "", $link->title);
	$link->title = str_replace("Ñ", "N", $link->title);

	echo "<item>\n";
	echo "<title><![CDATA[". onlyreadables(remove_error_creating_chars($title)) . "]]></title>\n";
	echo "<link>".getmyFullurl("storyURL", $link->category_safe_name($link->category), urlencode($link->title_url), $link->id)."</link>\n";
	echo "<comments>".getmyFullurl("storyURL", $link->category_safe_name($link->category), urlencode($link->title_url), $link->id)."</comments>\n";
	if (!empty($link_date))
		echo "<pubDate>".date('D, d M Y H:i:s T', $link->$link_date)."</pubDate>\n";
	else 
		echo "<pubDate>".date('D, d M Y H:i:s T', time())."</pubDate>\n";
	echo "<dc:creator>" . $link->username($link->author) . "</dc:creator>\n";
	echo "<category>" . htmlspecialchars($category_name) . "</category>\n";
	echo "<guid>".getmyFullurl("storyURL", $link->category_safe_name($link->category), urlencode($link->title_url), $link->id)."</guid>\n";
	echo "<description><![CDATA[" . $description . "<br/><br/>".$link->votes." ".$main_smarty->get_config_vars('PLIGG_Visual_RSS_Votes')." ]]></description>\n";
	echo "</item>\n\n";
}
}

do_rss_footer();

function do_rss_header($title) {
global $last_modified, $dblang, $main_smarty;
header('Content-type: text/xml; charset=utf-8', true);
echo '<?phpxml version="1.0" encoding="utf-8"?'.'>' . "\n";
echo '<rss version="2.0" '."\n";
echo 'xmlns:content="http://purl.org/rss/1.0/modules/content/"'."\n";
echo 'xmlns:wfw="http://wellformedweb.org/CommentAPI/"'."\n";
echo 'xmlns:dc="http://purl.org/dc/elements/1.1/"'."\n";
echo '>'. "\n";
echo '<channel>'."\n";
echo '<title>'.htmlspecialchars($main_smarty->get_config_vars("PLIGG_Visual_Name")).$title.'</title>'."\n";
echo '<link>'.my_base_url.my_pligg_base.'</link>'."\n";
echo '<description>'.$main_smarty->get_config_vars("PLIGG_Visual_RSS_Description").' '.$link->votes.' votes</description>'."\n";
echo '<pubDate>'.date('D, d M Y H:i:s T', $last_modified).'</pubDate>'."\n";
echo '<language>'.$dblang.'</language>'."\n";
}

function do_rss_footer() {
echo "</channel>\n</rss>\n";
}

function onlyreadables($string) {
  for ($i=0;$i<strlen($string);$i++) {
   $chr = $string{$i};
   $ord = ord($chr);
   if ($ord<32 or $ord>126) {
     $chr = "~";
     $string{$i} = $chr;
   }
  }
  return str_replace("~", "", $string);
}
?>

[werushka]

i have found out something new, in xml file created the characters show correctly but only if i subscribe to feeds it does not show correctly on browser window.