Changeset 158509

Timestamp:

09/28/2009 05:06:58 AM (16 years ago)

Author:

littlejon

Message:

Commit for version 1.2 release of LJ Longtail SEO

Location:

lj-longtail-seo/trunk

Files:

• lj-longtail-seo.php (modified) (9 diffs)
• readme.txt (modified) (2 diffs)

lj-longtail-seo/trunk/lj-longtail-seo.php

@@ -5 +5 @@
 Description: LJ Longtail SEO is a tool that detects search engine visits and uses this information to display a list of links based on second page search results
 Author: Jon Smith
-Version: 1.0
+Version: 1.2
 Author URI: http://www.thelazysysadmin.net/
 */
@@ -12 +12 @@
 
   private $dbversion = "1.75";
-  private $pluginversion = "1.0";
+  private $pluginversion = "1.2";
 
   private $defaults = array
@@ -26 +26 @@
     add_action('LJLongtailSEO_cron_hook', array(&$this, 'cron'));
     add_action('admin_menu', array(&$this, 'admin_menu'));
+    add_action('plugins_loaded', array(&$this, 'plugins_loaded'));
 
     add_filter("wp_head", array(&$this, "checkreferrer"));
-
-    register_sidebar_widget("LJ Longtail SEO", array(&$this, "widget"));
-    register_widget_control("LJ Longtail SEO", array(&$this, "widget_control"));
 
     register_activation_hook(__FILE__, array(&$this, 'db_install'));
@@ -39 +37 @@
     if ( function_exists('add_options_page') )
       add_options_page(__('LJ Longtail SEO Configuration'), __('LJ Longtail SEO'), 8, __FILE__, array(&$this, 'config'));
+  }
+  
+  function plugins_loaded() {
+    register_sidebar_widget("LJ Longtail SEO", array(&$this, "widget"));
+    register_widget_control("LJ Longtail SEO", array(&$this, "widget_control"));
   }
 
@@ -162 +165 @@
     echo "<h3>".$options['widget-title']."</h3>\n";
 
-    $dbresults = $wpdb->get_results($wpdb->prepare("SELECT postid, query, serppage, count(query) AS num, archive FROM $table_name GROUP BY postid, query, serppage HAVING serppage != -1 AND serppage != 1 AND postid != 0 AND archive = 0 ORDER BY serppage, num DESC LIMIT 0, %d;", $options['widget-numitems']), ARRAY_A);
+    $dbresults = $wpdb->get_results($wpdb->prepare("SELECT avg(id) AS relage, postid, query, serppage, count(query) AS num, archive FROM $table_name GROUP BY postid, query, serppage HAVING serppage != -1 AND serppage != 1 AND postid != 0 AND archive = 0 ORDER BY serppage, num DESC, relage LIMIT 0, %d;", $options['widget-numitems']), ARRAY_A);
     
     if (count($dbresults) > 0) {
@@ -330 +333 @@
   <th scope="col" id="postfound" class="manage-column column-postfound" style="">Post Found</th>
   <th scope="col" id="hits" class="manage-column column-hits" style="">Hits</th>
+  <th scope="col" id="ageweight" class="manage-column column-ageweight" style="">Age Weighting</th>
   </tr>
   </thead>
@@ -338 +342 @@
   <th scope="col" id="postfound" class="manage-column column-postfound" style="">Post Found</th>
   <th scope="col" id="hits" class="manage-column column-hits" style="">Hits</th>
+  <th scope="col" id="ageweight" class="manage-column column-ageweight" style="">Age Weighting</th>
   </tr>
   </tfoot>
@@ -344 +349 @@
 <?php
   
-  $results = $wpdb->get_results($wpdb->prepare("SELECT postid, query, serppage, count(query) AS num, archive FROM $table_name GROUP BY postid, query, serppage HAVING serppage != -1 AND serppage != 1 AND postid != 0 AND archive = 0 ORDER BY serppage, num DESC LIMIT 0, %d;", $options['widget-numitems']), ARRAY_A);
+  $results = $wpdb->get_results($wpdb->prepare("SELECT avg(id) AS relage, postid, query, serppage, count(query) AS num, archive FROM $table_name GROUP BY postid, query, serppage HAVING serppage != -1 AND serppage != 1 AND postid != 0 AND archive = 0 ORDER BY serppage, num DESC, relage LIMIT 0, %d;", $options['widget-numitems']), ARRAY_A);
 
   if (count($results) > 0) {
@@ -353 +358 @@
       <td class="text column-postfound"><?php echo get_the_title($result['postid']); ?></td>
       <td class="text column-hits"><?php echo $result['num']; ?></td>
+      <td class="text column-hits"><?php echo sprintf("%d", $result['relage']); ?></td>
     </tr>
 <?php 

lj-longtail-seo/trunk/readme.txt

@@ -1 +1 @@
 === Plugin Name ===
 Contributors: littlejon
-Tags: serp, position, longtail, results, google, bing, yahoo, SEO, widget, sidebar
-Requires at least: 2.7
+Tags: serp, position, longtail, long tail, results, google, bing, yahoo, SEO, widget, sidebar
+Requires at least: 2.5
 Tested up to: 2.8.4
 Donate link: http://www.thelazysysadmin.net/software/appreciation/
-Stable tag: 1.0
+Stable tag: 1.2
 
 LJ Longtail SEO is a tool that detects search engine visits and uses this information to display a list of links based on second page search results
@@ -48 +48 @@
 == Changelog ==
 
+= 1.2 =
+
+* Added backwards compatiblity down to Wordpress 2.5
+
+= 1.1 =
+
+* Added age weighting to the Widget results page. This will help stabilise the results and allow for graceful aging. The figure shown on the admin page is purely relative (it is based on the average id of the database records, as such this value will continue getting higher and higher but yet still remain relevant to the results being shown)
+
 = 1.0 =