table_options = $wpdb->prefix . "amazonfeed_options"; $this->table_cache = $wpdb->prefix . "amazonfeed_cache"; // Default REST Parameters (can be over-ridden) $this->params = array( 'Operation' => 'ItemSearch', 'SearchIndex' => 'Books', 'ResponseGroup' => 'Small,Images' ); // Load Options $this->options = get_option('amazonFeedOptions'); // If we're ready to run live, activate the controls. if( isset($this->options['ServicePath']) AND isset($this->options['AWSAccessKeyId']) AND isset($this->options['AssociateTag']) AND isset($this->options['DefaultTags']) AND isset($this->options['DefaultSearchField']) AND isset($this->options['MaxResults']) AND isset($this->options['Version']) ) { $this->live = true; } } function unInstall() { global $wpdb; $sql = "DROP TABLE `" . $this->table_cache . "`;"; $wpdb->query($sql); delete_option('amazonFeedOptions'); } function checkInstall() { global $wpdb; // Plugin options are not installed, implying that the plugin itself has not yet been installed either. if(!$this->options['Version']) { $this->admin_alert("Previous installation not found. Installing necessary tables now."); $sql = "CREATE TABLE IF NOT EXISTS `" . $this->table_cache . "` ( `keyword` varchar(255) NOT NULL, `timestamp` bigint(20) unsigned zerofill NOT NULL, `data` longblob NOT NULL, PRIMARY KEY (`keyword`) );"; $result = $wpdb->query($sql); if($result === false) { $this->admin_alert("Failed to create table."); return(false); } $this->options = array( 'ServicePath' => 'http://ecs.amazonaws.com/onca/xml?Service=AWSECommerceService', 'AWSAccessKeyId' => '', 'AssociateTag' => '', 'SearchFrom' => 'categories', 'DefaultTags' => '', 'TitleText' => '

Related Reading:

', 'DefaultSearchField'=> 'Keywords', 'MaxResults' => 5, 'ShowImages' => true, 'CacheExpiry' => 60*24, 'AllowTip' => true, 'Version' => $this->version ); update_option('amazonFeedOptions', $this->options); } elseif($this->options['Version'] < $this->version) { $this->admin_alert("Database version is less than plugin version"); } } // Allow showing an alert to the user when necessary. function admin_alert($msg = '') { if($msg) echo "

$msg

"; } function debug($msg = '') { # echo "

"; print_r($msg); echo "

"; } // Main data loader. function request_data($new_params = array()) { // Update the options with anything passed on the function. $params = array_merge($this->params, $new_params); // Create the request $request = $this->options['ServicePath'] . "&AWSAccessKeyId=" . $this->options['AWSAccessKeyId'] . "&AssociateTag=" . $this->options['AssociateTag']; // Iterate through the parameters adding to the request. foreach($params as $key=>$param) { if($param != "") $request .= "&" . urlencode($key) . "=" . urlencode($param); } $this->debug("Running Request: $request
"); $xml_data = file_get_contents($request); if($xml_data) return($xml_data); } // Load related reading either from database table, or from Amazon.com function load($keyword) { global $wpdb; $keyword = addslashes($keyword); $sql = "SELECT * FROM " . $this->table_cache . " WHERE `keyword` = '" . $keyword . "' LIMIT 0,1"; $data = $wpdb->get_row($sql, ARRAY_A); if($data !== false AND $data['keyword'] != "") { $data['keyword'] = stripslashes($data['keyword']); $data['data'] = stripslashes($data['data']); return($data); } } // Save related reading to cache when necessary function save($keyword, $xml) { global $wpdb; $keyword = trim(addslashes($keyword)); $data = trim(addslashes($xml)); $timestamp = time() + ($this->options['CacheExpiry']*60); $sql = "SELECT * FROM " . $this->table_cache . " WHERE `keyword` = '" . $keyword . "' LIMIT 0,1"; $existing_data = $wpdb->get_row($sql, ARRAY_A); if($existing_data['keyword'] != "") $sql = "UPDATE " . $this->table_cache . " SET `timestamp` = '$timestamp', `data` = '$data' WHERE `keyword` = '" . $keyword . "' LIMIT 1;"; else $sql = "INSERT INTO " . $this->table_cache . " (`keyword`, `timestamp`, `data`) VALUES ('$keyword', '$timestamp', '$data');"; $results = $wpdb->query($sql); return; } // Specific search functions function search($search_keywords, $searchResults=false, $searchField=false, $searchIndex=false) { global $wpdb; $this->debug("Searching For: $search_keywords
\n"); if($searchResults == false) $searchResults = $this->options['MaxResults']; if($searchField == false) $searchField = $this->options['DefaultSearchField']; if($searchIndex == false) $searchIndex = $this->params['SearchIndex']; $keywords = explode(",", $search_keywords); $tmp_items = array(); foreach($keywords as $word) { if(trim($word) != "") { $data = $this->load(trim($word)); if($data['data'] != "" AND $data['timestamp'] > time()) { $xml_data = $data['data']; } else { $new_params = array( 'SearchIndex' => $searchIndex, $searchField => trim($word) ); $xml_data = $this->request_data($new_params); $this->save($word, $xml_data); } $xml = simplexml_load_string($xml_data); $counter = 0; foreach($xml->Items->Item as $item) { $tmp_items[] = $item; } } } $items = array(); $counter = 0; while($counter++ < count($tmp_items)*2) { $rand = rand(0, count($tmp_items)-1); $tmp_item = $tmp_items[$rand]; $id = $tmp_item->ASIN; if(!$items["$id"]) $items["$id"] = $tmp_item; if(count($items) >= $searchResults) break; } return($items); } function display($keywords, $echo = true) { $items = $this->search($keywords); $numBooks = count($items); if($numBooks == 0 AND $keywords != $this->options['DefaultTags']) { $items = $this->search($this->options['DefaultTags']); $numBooks = count($items); } if($numBooks > 0) { // Allow for tipping the author, if enabled if($this->options['AllowTip'] == true) { $tip_random_number = rand(1, $numBooks); } $result = "

" . stripslashes($this->options['TitleText']) . "\n"; $counter = 0; foreach($items as $item) { $result .= "

"; $counter++; $image = $item->SmallImage->URL; $title = $item->ItemAttributes->Title; $link = urldecode($item->DetailPageURL); // Do the tip if($this->options['AllowTip'] == true AND $counter == $tip_random_number) { $link = str_replace($this->options['AssociateTag'], 'warkensoftpro-20', $link); } if($this->options['ShowImages'] == true) $image_html = "

\n "; else $image_html = ""; $result .= "$image_html$title\n"; $result .= "

"; } $result .= "

"; } if($echo) echo $result; else return($result); } function wp_head() { $filepath = basename(__FILE__); $pluginpath = str_replace("php/$filepath", "", __FILE__); $pluginlocation = get_settings('siteurl') . str_replace(ABSPATH, "/", $pluginpath); $csspath = $pluginlocation . "css/style.css"; ?> ID, '_amazonfeed_disabled', true) == "true" ) return($content); // Check to see if we have custom keywords for the page. $custom_keywords = get_post_meta($post->ID, '_amazonfeed_keywords', true); if(!$custom_keywords) { if($this->options['SearchFrom'] == "categories") $tags = get_the_category(); else $tags = get_the_tags(); if(count($tags) == 0 OR $tags == "") { $keywords = $this->options['DefaultTags']; } else { foreach($tags as $tag) $search_string[] = $tag->name; $keywords = implode(', ', $search_string); } } else $keywords = $custom_keywords; $result = $this->display($keywords, false); $content = "$content\n$result"; return($content); } function wp_admin_init() { // Add admin management pages add_management_page('Amazon Feed Management', 'AmazonFeed', 7, __FILE__, array(&$this, 'wp_admin_options')); } function wp_admin_options() { // Check Installation $this->checkInstall(); // Save admin options if posted. if($_POST) { $post_errors = false; if(eregi("^[a-z0-9\-]+$", $_POST['AWSAccessKeyId'])) $this->options['AWSAccessKeyId'] = $_POST['AWSAccessKeyId']; else { $this->admin_alert("The AWS Access Key you entered was improperly formatted."); $post_errors = true; } if(eregi("^[a-z0-9\-]+$", $_POST['AssociateTag'])) $this->options['AssociateTag'] = $_POST['AssociateTag']; else { $this->admin_alert("The Associate Tag you entered was improperly formatted."); $post_errors = true; } if(eregi("^[a-z]+$", $_POST['SearchFrom']) AND $_POST['SearchFrom'] == 'tags') $this->options['SearchFrom'] = 'tags'; else { $this->options['SearchFrom'] = 'categories'; } if(eregi("^.*$", $_POST['DefaultTags'])) $this->options['DefaultTags'] = $_POST['DefaultTags']; else { $this->admin_alert("The Default Tags you entered was improperly formatted."); $post_errors = true; } if(eregi("^.*$", $_POST['TitleText'])) $this->options['TitleText'] = $_POST['TitleText']; else { $this->admin_alert("The Title Text you entered was improperly formatted."); $post_errors = true; } if(eregi("^[0-9]+$", $_POST['MaxResults']) AND $_POST['MaxResults'] >= 0 AND $_POST['MaxResults'] <= 25) $this->options['MaxResults'] = $_POST['MaxResults']; else { $this->admin_alert("The Max Results must only be a number between 0 and 25."); $post_errors = true; } if(eregi("^[a-z0-9\-]+$", $_POST['ShowImages']) AND $_POST['ShowImages'] == 'yes') $this->options['ShowImages'] = true; else { $this->options['ShowImages'] = false; } if(eregi("^[0-9]+$", $_POST['CacheExpiry']) AND $_POST['CacheExpiry'] >= 1 AND $_POST['CacheExpiry'] <= 43200) $this->options['CacheExpiry'] = $_POST['CacheExpiry']; else { $this->admin_alert("The Cache Expiry Minutes must only be a number between 15 and 43200 (30 days)."); $post_errors = true; } if(eregi("^[a-z0-9\-]+$", $_POST['AllowTip']) AND $_POST['AllowTip'] == 'yes') { if($this->options['AllowTip'] == false) $this->admin_alert("Thank you for your generosity."); $this->options['AllowTip'] = true; } else { $this->options['AllowTip'] = false; } if(!$post_errors) { // Save current options update_option('amazonFeedOptions', $this->options); $this->admin_alert("Options saved!"); } } // Show default admin page ?>

Amazon Feed Management

This is the main admin page for my cool amazon feed plugin.

AWS Access Key: The access key you applied for and received from the Amazon Web Services site.	' />
Associate Tag: Your Amazon associate tag which you received when you signed up as an Amazon associate.	' />
Search Based On: Enter a couple default tags seperated by commas to be used on articles not having any specific tags. (used to find products related to these tags)
Default Tags: Enter a couple default tags seperated by commas to be used on articles not having any specific tags. (used to find products related to these tags)	' />
Title Text: Enter the text you wish to use in the related reading title or leave it as is.	' />
Max Results: How many products would you like to promote on each post? (maximum)	' />
Show Images: Do you wish to show images associated with the related products?	options['ShowImages'] == true) echo "checked"; ?> /> Yes
Cache Expiry Minutes: How many minutes would you like between when related items are refreshed from Amazon.com?	' />
Tip the Developer: If you find this plugin to be useful in helping you to make money with your blog, why not give a "tip" to the developer by allowing him to share a bit of the profit. Allowing this box to be checked, will cause one of the related products to send the Amazon referral on behalf of the developer instead of using your own affiliate ID. In this way you can help to support ongoing development on this plugin.	options['AllowTip'] == true) echo "checked"; ?> /> Yes
Once you have input and saved appropriate values for these options, your site will be able to begin displaying related items on all your blog pages and posts.

Page specific keywords for finding Amazon products:

Disable Amazon related products on this page: ID, '_amazonfeed_disabled', true) == 'true' ) echo "checked"; ?> /> Disabled

Amazon Products Feed