prefix}amazon_lists WHERE name = '%s';";
$wpdb->query( $wpdb->prepare($query, $list) );
}
public function addListItem()
{
if(!isset($_POST['list']) || !isset($_POST['asins']))
exit;
$list = $_POST['list'];
$asins = $_POST['asins'];
$asins = explode(',', $asins);
if(!is_array($asins) || count($asins) == 0)
exit;
$in = array();
foreach($asins as $asin)
$in[] = '\'' . trim($asin) . '\'';
$in = implode(', ', $in);
global $wpdb;
$query = "SELECT asin FROM {$wpdb->prefix}amazon_lists WHERE name = '$list' AND asin IN($in);";
$existing = $wpdb->get_col($query);
$asins = array_diff($asins, $existing);
$inserted = array();
AmazonLib::addToList($list, $asins, $inserted);
if(count($inserted) == 0)
exit;
AmazonLib::drawListTableRows($list, $inserted);
exit;
}
public function removeListItem()
{
if(!isset($_POST['list']) || !isset($_POST['asin']))
exit;
AmazonLib::removeListItem($_POST['list'], $_POST['asin']);
exit;
}
public function search()
{
global $amazon_tools, $amazon_locale;
check_ajax_referer('amazon_tools_nonce', 'security');
$query = $_POST['search'];
$count = $_POST['count'];
$count = is_numeric($count) && $count > 0 ? $count : 3;
update_option('amazon_quick_search_count', $count);
if($query == '')
{
echo 'Search field cannot be blank';
exit;
}
$query = str_replace(' ', '%20', $query);
$asins = AmazonLib::quickSearch($query, $amazon_locale);
if(!is_array($asins) || count($asins) == 0)
{
echo "The search '$query' did not match any products.";
exit;
}
$asins = implode(',', array_slice($asins, 0, $count));
ob_start();
?>
[amazon_i foreach=""]
[/amazon_i]
