Add your API keys for displaying reviews
get_results("SELECT * FROM {$wpdb->prefix}bb_apis WHERE api_name = 'amazon'", ARRAY_A);
$amazon = $amazon[0];
$goodreads = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}bb_apis WHERE api_name = 'goodreads'", ARRAY_A);
$goodreads = $goodreads[0];
if((!empty($amazon) || !empty($goodreads)) && !isset($_REQUEST['btbe_api'])) {
$_REQUEST['amazon_assoc'] = @$amazon['assoc'];
$_REQUEST['amazon_access'] = @$amazon['access_key'];
$_REQUEST['amazon_secret'] = @$amazon['secret'];
$_REQUEST['goodreads_key'] = @$goodreads['access_key'];
}
if(@$_REQUEST['btbe_api'] == 1) {
global $wpdb;
$new_amazon = array(
'api_name' => 'amazon',
'assoc' => esc_sql(@$_REQUEST['amazon_assoc']),
'access_key' => esc_sql(@$_REQUEST['amazon_access']),
'secret' => esc_sql(@$_REQUEST['amazon_secret']),
);
$new_goodreads = array(
'api_name' => 'goodreads',
'assoc' => '',
'access_key' => esc_sql(@$_REQUEST['goodreads_key']),
'secret' => '',
);
if(!empty($amazon)) {
$wpdb->update($wpdb->prefix.'bb_apis', $new_amazon, array('id' => esc_sql($amazon['id'])), array('%s','%s','%s','%s'));
}
else {
$wpdb->insert( $wpdb->prefix.'bb_apis', $new_amazon );
}
if(!empty($goodreads)) {
$wpdb->update($wpdb->prefix.'bb_apis', $new_goodreads, array('id' => esc_sql($goodreads['id'])), array('%s','%s','%s','%s'));
}
else {
$wpdb->insert( $wpdb->prefix.'bb_apis', $new_goodreads );
}
$btbe_message = 'API keys saved! return to the Book List?';
}
?>