<?php
//////////////////////////////////
//// START CaRP CONFIGURATION ////
//////////////////////////////////

require_once '/home/www/myaccount/xxxmy_path_to_carp/carp/carp.php';
/*** Setup Code ***/
CarpConf('cache-method','mysql');
CarpConf('mysql-connect',1);
CarpConf('mysql-database','xxxxx');
CarpConf('mysql-username','xxxxx');
CarpConf('mysql-password','xxxxx');
/*** End Setup Code ***/

/*** Load Plugins ***/
CarpLoadPlugin('mysql.php');
/*** End Load Plugins ***/
// Add any desired configuration settings before CarpCacheShow
// using "CarpConf" and other functions

/*** CarpConf ***/
//CarpConf('encodingin','ISO-8859-1');
CarpConf('encodingout','UTF-8');
CarpConf('corder','');
CarpConf('iorder','image,link,author,desc');
CarpConf('cacheinterval',720);
CarpConf('maxitems',15);
CarpConf('linktarget',1);
CarpConf('aidesc','');
CarpConf('ai','<br clear="all" /> <br />');
CarpConf('biimage','<div style="float:left;margin-right:5px;">');
CarpConf('aiimage','</div>');
/*** End CarpConf ***/


/*** RSS Feeds to get ***/

// 1st Feed
CarpCacheShow('http://www.myfeedurl.com/xxx');

// 2nd Feed: Amazon US
$q='Enter_your_Amazon_search_term_here';
//$MaxItems=3;
$OneReview=1;
$MaxReviewLength=400;
$SearchIndex='Books';
$xslt='http://www.mydomain.com/xxx/Amazon.xsl';
$AccessKeyId='xxxxx';
$AssociateTag='xxxxx';
$country='US';

$countries=array(
	'US'=>'xml-us.amznxslt.com',
	'DE'=>'xml-de.amznxslt.com',
	'FR'=>'xml-fr.amznxslt.com',
	'CA'=>'xml-ca.amznxslt.com',
	'JP'=>'xml-jp.amznxslt.com',
	'UK'=>'xml-uk.amznxslt.com'
);

if (!($MaxItems+=0)) $MaxItems=10;
if (!($OneReview+=0)) $OneReview=1;
$MaxReviewLength+=0;
if (!isset($SearchIndex)) $SearchIndex='Books';
$amazonquery='http://'.$countries[$country].'/onca/xml?Service=AWSECommerceService'.
	'&Operation=ItemSearch&ResponseGroup=Small,Reviews,Images,Offers'.
	"&AWSAccessKeyId=$AccessKeyId&AssociateTag=$AssociateTag".
	"&Sort=salesrank&Style=".urlencode($xslt)."&Keywords=".urlencode($q).
	"&SearchIndex=".urlencode($SearchIndex).
	($OneReview?'&CaRPOneReview=1':'').
	($MaxReviewLength?"&CaRPMaxReviewLength=$MaxReviewLength":'');
if (1) echo "<p>$amazonquery</p>";
CarpCacheShow($amazonquery);

/////////////////////////////////
//// STOP CaRP CONFIGURATION ////
/////////////////////////////////




//////////////////////////////
//// START PROCESS SCRIPT ////
//////////////////////////////

//DB configruation for private script
$dbuser = 'xxxxx';
$dbpwd = 'xxxxx';
$dbname = 'xxxxx';
$dbhost = 'localhost';
mysql_connect($dbhost,$dbuser,$dbpwd);
@mysql_select_db($dbname) or die( "Unable to select database");

//Adds by Google: if you want to use it, delete the outcomments
/*
$googleads = '<p>
[align=center]<script type="text/javascript"><!--
google_ad_client = "pub-123myid";
google_ad_width = 336;
google_ad_height = 280;
google_ad_format = "336x280_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "EFEFEF";
google_color_bg = "EFEFEF";
google_color_link = "496D9F";
google_color_text = "000000";
google_color_url = "008000";
google_ui_features = "rc:0";
//-->
</script>
<script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>[/align]
</p>';
*/
$googleads = ''; // outcomment this line if you want to use Googleads. I prefer to have the Googleads in the footer of the News.

$news_queue = '0'; // 1 moves all the news into the queue, 0 moves them directly into the news


$globreplacestract = '1'; // I had difficulties with accents in German, French and Italian. I don't know if it's utf-8, but it works fine for me with this general replacings.
$globreplacestrfrom = array('&#39;', '&agrave;', '&aacute;', '&acirc;', '&aelig;', '&ccedil;', '&egrave;', '&eacute;', '&ecirc;', '&euml;', '&Agrave;', '&Aacute;', '&Acirc;', '&AElig;', '&Ccedil;', '&Egrave;', '&Eacute;', '&Ecirc;', '&Euml;');
$globreplacestrto = array('\'', 'à', 'á', 'â', 'æ', 'ç', 'è', 'é', 'ê', 'ë', 'À', 'Á', 'Â', 'Æ', 'Ç', 'È', 'É', 'Ê', 'Ë');


//////////////////////
// Single RSS feeds //
//////////////////////

// 1st Feed
$feedid = '123'; //set feed_id
$feedlanguage = 'english'; //set feed_language in DF tables
$feedtopic = '123'; //set topic id in DF tables
$feedcategory = '123'; //set category id in DF tables
$sourcestract = '1'; //1 turns the "source" line on, 0 turns it off.
$sourcestrstart = 'News by: '; //initial string of the "source" line.
$sourcestrlink = 'http://www.LinkToTheFeedWebsite.com'; //link to the "source".
$sourcestrname = 'Feedname'; //name of the "source" link.
$sourcestrend = '<br />'; //end of the source string
$authorstract = '1'; //1 turns the "author" line on, 0 turns it off.
$authorstrstart = 'Source:'; // initial string of the "author" line.
$authorstrend = '<br /><br />'; //end of "author" string
$getstorystract = '1'; //1 turns the "Get the full story" line on, 0 turns it off.
$getstorystrstart = 'Get the full text '; //initial string of the "Get the full story" line.
$getstorystrend = 'here'; //linked final string of the "Get the full story" line.
$truncateact = '1'; //1 truncate the content, 0 turns it off.
$truncatewhen = '450'; //truncate content if longer then this value
$truncateto = '400'; //truncate the length of the content to this value
$replacestract = '1'; //1 turns the replacement of strings on
$replacestrfrom = array('replace1', 'replace2', 'replace3', 'replace4'); //expand the list of strings to replace from
$replacestrto = array('to1', 'to2', 'to3', 'to4');  //expand the list of strings to which you like to replace
$replregexpact = '1'; //1 turns the replacement of POSIX regular expressions on 
$replregexparray = array(
	array(
		'pattern' => '(pattern 1)', //POSIX pattern 1
		'replacement' => 'replaceto1' //POSIX replacement 1
	), 
	array(
		'pattern' => '(pattern 2a)+(.)*(pattern 2b)', //POSIX pattern 2
		'replacement' => 'replaceto2' //POSIX replacement 2
	), 
	array(
		'pattern' => '(pattern 3)',  //POSIX pattern 3
		'replacement' => 'replaceto3' //POSIX replacement 3
	), 
	array(
		'pattern' => '(pattern 4)',  //POSIX pattern 4
		'replacement' => 'replaceto4'	//POSIX replacement 4
	)
); //-> expand this array to add more POSIX patterns

include 'rss_update.inc';


// Amazon US
$feedid = '29';
$feedlanguage = 'english';
$feedtopic = '8';
$feedcategory = '31';
$sourcestract = '1'; 
$sourcestrstart = 'News by: ';
$sourcestrlink = 'http://www.amazon.com/exec/obidos/redirect?tag=YourAmazonID&path=subst/home/home.html';
$sourcestrname = 'Amazon "Amazon Seachrchterm"';
$sourcestrend = '<br /><br />';
$authorstract = '1';
$authorstrstart = 'Author(s):';
$authorstrend = '<br />';
$getstorystract = '1';
$getstorystrstart = 'Get the full text ';
$getstorystrend = 'here';
$truncateact = '1';
$truncatewhen = '450';
$truncateto = '400';
$replacestract = '1';
$replacestrfrom = array('<br /><br /><br /><br />', '<br /><br /> <br /><br />');
$replacestrto = array('<br /><br />', '<br /><br />');
$replregexpact = '0';
$replregexparray = array(
	array(
		'pattern' => '', 
		'replacement' => '' 
	), 
	array(
		'pattern' => '', 
		'replacement' => '' 
	), 
	array(
		'pattern' => '', 
		'replacement' => '' 
	)
);

include 'rss_update.inc';


//close MySQL connection
mysql_close()

/////////////////////////////
//// STOP PRIVATE SCRIPT ////
/////////////////////////////
?>

<?php
//get rssitems
$query = "select * from rssitems where  feed_id = '$feedid' and news_submitted = '0'";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)) {

    //set variables
    $item_id = $row->item_id;
    $feed_id = $row->feed_id;
    $checksum = $row->checksum;
    $title = $row->title;
    $url = $row->url;
    $author = $row->author;
    $posted = $row->posted;
    $updated = $row->updated;
    $descr = $row->descr;
    $imageurl = $row->imageurl;
    $imagehight = $row->imagehight;
    $imagewidth = $row->imagewidth;
    $imagelink = $row->imagelink;
    $imagetitle = $row->imagetitle;
    $guid = $row->guid;
    $new = $row->new;
    $news_submitted = $row->news_submitted;
    
    
    
    $title = stripslashes($title);
    $author = stripslashes($author);
    $descr = stripslashes($descr);
    $imagetitle = stripslashes($imagetitle);
    
    //trim whitespace at the start and at the end of the entry
    $title = trim($title);
    $author = trim($author);
    $descr = trim($descr);
    $imagetitle = trim($imagetitle);
    
    //update title
    if ($globreplacestract == 1) {
		$title = str_replace($globreplacestrfrom, $globreplacestrto, $title);
	}
    
    //update descr
    //replace strings
    if ($globreplacestract == 1) {
		$descr = str_replace($globreplacestrfrom, $globreplacestrto, $descr);
	}
    if ($replacestract == 1) {
		$descr = str_replace($replacestrfrom, $replacestrto, $descr);
	}
	//replace regular expressions
    if ($replregexpact == 1) {
		foreach ($replregexparray as $replrow) {
			$descr = eregi_replace($replrow['pattern'], $replrow['replacement'], $descr);
			$descr = eregi_replace("($author)", '', $descr);
		}
	}
    //truncate descr
    if ($truncateact == 1) {
		if (strlen ($descr) > $truncatewhen) {
			$descr = substr($descr, 0, $truncateto) . '...';
		}
    }
    //add image to descr
    if (!empty($imageurl)) {
        $imageurl = '<a href="' . $url . '" target="_blank" rel="nofollow"><img src="' . $imageurl . '" border="0"></a><br />';
    }
    //add infos to descr
    if ($sourcestract == 1) {
        $sourcestr = '<b>' . $sourcestrstart . '</b><a href="' . $sourcestrlink . '" target="_blank" rel="nofollow"><i>' . $sourcestrname . '</i></a>' . $sourcestrend;
    } else {
        $sourcestr = '';
    }
    if ($authorstract == 1) {
        $authorstr = '<b>' . $authorstrstart . '</b> <i>' . $author . '</i>' . $authorstrend;
    } else {
        $authorstr = '';
    }
    if ($getstorystract == 1) {
        $getstorystr = $getstorystrstart . '<a href="' . $url . '"target="_blank" rel="nofollow">' . $getstorystrend . '</a>!<br /><br />';
    } else {
        $getstorystr = '';
    }
    
    $story = $sourcestr . $imageurl . $authorstr . $descr;
    $storyext = $getstorystr . $googleads;
    
    //replace strings again
    if ($replacestract == 1) {
		$story = str_replace($replacestrfrom, $replacestrto, $story);
	}
	//replace regular expressions again
    /*
    if ($replregexpact == 1) {
		foreach ($replregexparray as $replrow) {
			$story = eregi_replace($replrow['pattern'], $replrow['replacement'], $story);
		}
	}
	*/
    
    //show the updated content
    echo $title . '<br /><br />';
    echo $story . '<br /><br />';
    echo $storyext . '<br /><br /><br /><br />';
    
    //addslashes
    $title = addslashes($title);
    $author = addslashes($author);
    $story = addslashes($story);
    $storyext = addslashes($storyext);
    $imagetitle = addslashes($imagetitle);
    
    // avoid dupplicates
    $title_new = $title;
    $story_new = $story;
    
    $title_new = eregi_replace("[[:space:]](-)[[:space:]](.)*", '', $title_new); //Google pattern
    $title_new = eregi_replace("[[:space:]](\()(.)*(\))$", '', $title_new); //Yahoo! pattern
    
    $query_old = "SELECT * FROM cms_stories WHERE title LIKE '%$title_new%' or hometext = '$story_new'";
    $result_old = mysql_query($query_old);
    while ($row_old = mysql_fetch_object($result_old)) {
        $title_old = $row_old->title;
        $hometext_old = $row_old->hometext;
        
        $title_old = stripslashes($title_old);
        $hometext_old = stripslashes($hometext_old);
        
        $title_old = trim($title_old);
        $hometext_old = trim($hometext_old);
        
        $title_old = addslashes($title_old);
        $hometext_old = addslashes($hometext_old);
        
        $title_old = eregi_replace("[[:space:]](-)[[:space:]](.)*", '', $title_old); //Google pattern
        $title_old = eregi_replace("[[:space:]](\()(.)*(\))$", '', $title_old); //Yahoo! pattern
        
        $title_old = strtolower($title_old); // change string to little letters
        $title_old = ucwords($title_old); // first letters of words in string are big letters
        $title_old = eregi_replace("[^a-zA-Z0-9]", '', $title_old); // remove everything else then a letter or a number
    }
    mysql_free_result($result_old);
    
    $title_new = strtolower($title_new); // change string to little letters
    $title_new = ucwords($title_new); // first letters of words in string are big letters
    $title_new = eregi_replace("[^a-zA-Z0-9]", '', $title_new); // remove everything which is not a letter or a number
    
    if ($title_old == $title_new or $hometext_old == $story_new) {
        echo 'Duplicate "' . $title_new . '" has not been submitted to the News!<br />';
    } else
    {
        //puts item to news queue or directly into the news
        if ($news_queue == 1) {
            $query2 = "INSERT INTO cms_queue (uid, uname, subject, story, storyext, timestamp, topic, alanguage) VALUES ('240','News', '$title', '$story', '$storyext', '$updated', '$feedtopic', '$feedlanguage')";
            mysql_query($query2);
        } else {
            $query2 = "INSERT INTO cms_stories (informant, title, hometext, bodytext, time, topic, catid, alanguage, ihome, acomm) VALUES ('News', '$title', '$story', '$storyext', '$updated', '$feedtopic', '$feedcategory', '$feedlanguage', '1', '1')";
            mysql_query($query2);
        }
        
    }
    echo 'old:' . $title_old . '<br />';
    echo 'new:' . $title_new . '<br />';
    

    
    //set news_submitted to yes
    $query3 = "UPDATE rssitems SET news_submitted = '1' WHERE item_id = '$item_id'";
    mysql_query($query3);
}
mysql_free_result($result);