Double entries into db problem.

Hi ppl.
I have a problem with my script because when i run get_content.php after i see double entries into mysql db.
I want this script get a new xml entries but not double old ones!
Can someone check my script and try find error please?
Thank you.

<?php session_start();

ini_set("max_execution_time",0);

require_once('init.php');

require_once("includes/config.php");

require_once("function.php");

//get all XML links...

$catid = $_GET['catid'];

$resultLink = get_all_Links($catid);

global $catidglobal;

$catidglobal = $catid;

foreach ($resultLink as $key => $value)

{

//echo "Key: $key; Value: $value<br>\n";

$feid = 0;

$curr_url = $value;

$getfeedid_qry = "select id from ".$prefix."feeds where url='".trim($curr_url)."' AND DATE_FORMAT(timestamp,'%Y-%m-%d-%h:%i') < DATE_FORMAT(subdate(now(), interval 1 MINUTE),'%Y-%m-%d-%h:%i')";

$getfeedid_res = mysql_query($getfeedid_qry);

$getfeedid_num = mysql_num_rows($getfeedid_res);

if($getfeedid_num>0)

{

while($getfeedid_row = mysql_fetch_assoc($getfeedid_res))

{

$getfeedid_arr[$feid] = $getfeedid_row['id'];

$feid++;

}

$getfeedid_str = @implode(",",$getfeedid_arr);

$delqry1 = "delete from ".$prefix."feeds where id IN (".$getfeedid_str.");";

@mysql_query($delqry1);

$delqry2 = "delete from ".$prefix."feeds_select where feed_id IN (".$getfeedid_str.");";

@mysql_query($delqry2);

$delqry3 = "delete from ".$prefix."items where feed_id IN (".$getfeedid_str.");";

@mysql_query($delqry3);

$delqry4 = "delete from ".$prefix."items_select where feed_id IN (".$getfeedid_str.");";

@mysql_query($delqry4);

}

ob_start();

{

$url = $value;

if(!empty($url))

{

RF_FeedSelect::_subscribe($url, $public);

}

$rss_result_html = ob_get_contents();

ob_clean();

if(!empty($opml))

{

if(!$content_array = file($opml))

{

echo "Cannot open $opml<br>";

//return false;

}

else

{

$content = implode("", $content_array);

$feeds = ref_opml_to_array($content);

foreach($feeds as $feed)

{

RF_FeedSelect::_subscribe($feed, $public);

echo '<hr size="1">';

flush();

}//for...

}//else...

}//if...

$opml_result_html = ob_get_contents();

ob_clean();

if($_FILES['opml_file']['tmp_name'])

{

if(!$content_array = file($_FILES['opml_file']['tmp_name']))

{

echo "Cannot open uploaded file<br>";

//return false;

}

else

{

$content = implode("", $content_array);

$feeds = ref_opml_to_array($content);

foreach($feeds as $feed)

{

RF_FeedSelect::_subscribe($feed, $public);

echo '<hr size="1">';

flush();

}//for ...

}//else ...

}//if ...

$file_result_html = ob_get_contents();

ob_clean();

}

ob_end_clean();

//update parse flag to ='1'

$sqlupdate ="update ".$prefix."xmllinks set isparsed='1' where link='$url'";

mysql_query($sqlupdate);

}//end of main foreach loop...

?>

<script language="JavaScript">

parent.window.location.href="done.php";

</script>
Click to expand...

Log in or Sign up

Double entries into db problem.

maar3amt Active Member

Log in or Sign up

Double entries into db problem.

maar3amt Active Member

Useful Searches