get_row("SELECT * FROM ".$wpdb->prefix."alfie_colindex WHERE col_id = '".$col_id."'");
if($type=="single")
{
$wpdb->query("DELETE FROM ".$wpdb->prefix."alfie_producten WHERE col_id='".$col_id."'");
$teller = 0;
$arrSaveValues = updateSingleFeed($row->colindex,$row->source_url);
foreach($arrSaveValues as $productdata)
{
mysql_query("INSERT INTO ".$wpdb->prefix."alfie_producten (col_id,productnaam,prijs,omschrijving,imageurl,producturl)
VALUES ( '".$col_id ."',
'".santinizeInput($productdata["productnaam"])."',
'".santinizeInput($productdata["prijs"])."',
'".santinizeInput($productdata["omschrijving"])."',
'".santinizeInput($productdata["imageurl"])."',
'".santinizeInput($productdata["producturl"])."')") or die (mysql_error());
$teller++;
}
if($teller!=0)
{
echo ' The feed '.$row->naam.' is UPDATED with '.$teller.' new rows!
';
$wpdb->query("UPDATE wp_alfie_colindex SET datum = NOW() WHERE col_id='".$col_id."'");
}
}
if($type=="match")
{
$colindex = $row->colindex;
$col_url = $row->source_url;
include 'updatematchfeed.php';
}
if($type=="searchfilt")
{
// verwijder oude data
$wpdb->query("DELETE FROM ".$wpdb->prefix."alfie_searchproduct WHERE id = '".$col_id."'");
$colindex = $row->colindex;
$source_url = $row->source_url;
include 'savesearchfilter.php';
$wpdb->query("UPDATE wp_alfie_colindex SET datum = NOW() WHERE col_id='".$col_id."'");
echo ' The feed '.$row->naam.' is UPDATED with '.$teller.' new rows!
';
}
}
if(isset($_GET['delete']))
{
if($wpdb->query("DELETE FROM ".$wpdb->prefix."alfie_colindex WHERE col_id = '".intval($_GET['delete'])."'"))
{
$wpdb->query("DELETE FROM ".$wpdb->prefix."alfie_producten WHERE col_id = '".intval($_GET['delete'])."'");
$wpdb->query("DELETE FROM ".$wpdb->prefix."alfie_reactions WHERE colid='".intval($_GET['delete'])."'");
$wpdb->query("DELETE FROM ".$wpdb->prefix."alfie_searchproduct WHERE id='".intval($_GET['delete'])."'");
wp_redirect("admin.php?page=alfie-manage");
ob_end_flush();
exit;
} else {
echo "Unknown error, something went wrong with the query!
";
}
} else {
$manage_query = $wpdb->get_results(
"
SELECT *
FROM ".$wpdb->prefix."alfie_colindex
");
if(count($manage_query)==0)
{
echo ' No feeds added yet! Please add some feeds.
';
} else {
?>
Manage your imported feeds here.
Over here you can manage your feeds. Press Update to refresh the products with the latest products.
You also see "create short tag". You can copy this tag in your post, and voila! You have the fetched products.
| Feed Name |
Type Feed |
Short Tag |
Last update |
Update |
Delete |
| naam;?> |
type;?> |
type=="single") { echo "[alfie_single_product id=\"".$elems->col_id."\"]"; }
if($elems->type=="match") { echo "[alfie_matchfeed id=\"".$elems->col_id."\"]";}
if($elems->type=="searchfilt") { echo "[alfie_search_filter id=\"".$elems->col_id."\"]";}
?>
|
datum;?> |
Update now |
Delete |