| Products |
Advertiser |
Filtername |
Branche |
Install |
Shortcode |
getAcceptedFilters()) {
wp_redirect("/wp-admin/admin.php?page=alfie-config");
}
foreach ($puck->getAcceptedFilters() as $key=>$values):
$installed = null;
$number_of_products = $wpdb->get_var("SELECT COUNT(s_id) FROM ".$wpdb->prefix."alfieliate_products WHERE s_id ='".(int) $values->s_id."'");
?>
|
N/A
|
webshop_name[0];?> |
description[0];?>
|
category[0];?> |
|
[displayproducts id="'.$values->s_id.'"]';
} else {
echo 'N/A';
} ?>
|
getAcceptedFilters() as $key=>$values):
$installed = null;
$number_of_products = $wpdb->get_var("SELECT COUNT(s_id) FROM ".$wpdb->prefix."alfieliate_products WHERE s_id ='".(int) $values->s_id."'");
if($values->match_id[0] == $match_id):
?>
|
N/A
|
webshop_name[0];?> |
description[0];?> |
category[0];?> |
|
[displayproducts id="'.$values->s_id.'"]';
} else {
echo 'N/A';
} ?>
|
COPY THIS SHORTCODE:
query("DELETE FROM ".$wpdb->prefix."alfieliate_products WHERE s_id='".$s_id."' AND allow_update ='1'");
$get_products = $puck->getproducts($s_id);
foreach($get_products as $values) {
$sql = "INSERT INTO
".$wpdb->prefix."alfieliate_products
(identifier,feed_id,s_id,prim_id,
product_name,price,description,imageurl,
producturl,internal_id,ean,pricerange,
webshop_name,webshop_logo,label_id)
VALUES(
'".(isset($values->identifier) ? $values->identifier : '')."',
'".(isset($values->feed_id) ? $values->feed_id : '')."',
'".(isset($values->s_id) ? $values->s_id : '')."',
'".(isset($values->prim_id) ? $values->prim_id : '')."',
'".(isset($values->productname) ? trim(strip_tags($values->productname)) : '')."',
'".str_replace(",",".",$values->price)."',
'".(isset($values->description) ? trim(strip_tags($values->description)) : '')."',
'".(isset($values->imageurl) ? $values->imageurl : '')."',
'".(isset($values->producturl) ? $values->producturl : '')."',
'".(isset($values->internal_id) ? $values->internal_id : '')."',
'".(isset($values->ean) ? $values->ean : '')."',
'".(isset($values->pricerange) ? $values->pricerange : '')."',
'".(isset($values->webshop_name) ? $values->webshop_name : '')."',
'".(isset($values->webshop_logo) ? $values->webshop_logo : '')."',
'".(isset($values->label_id) ? $values->label_id : '')."'
)";
$wpdb->query($sql);
}
if($match_id != 0 ) {
wp_redirect("/wp-admin/admin.php?page=alfie-feed-plugin&match_id={$match_id}&msg=1");
} else {
wp_redirect("/wp-admin/admin.php?page=alfie-feed-plugin&msg=1");
}
}
if(isset($_GET['del'])) {
$s_id = (int) $_GET['del'];
$wpdb->query("DELETE FROM ".$wpdb->prefix."alfieliate_products WHERE s_id='".$s_id."'");
if($match_id != 0 ) {
wp_redirect("/wp-admin/admin.php?page=alfie-feed-plugin&match_id={$match_id}");
} else {
wp_redirect("/wp-admin/admin.php?page=alfie-feed-plugin");
}
}