Changeset 534578

Timestamp:

04/21/2012 10:19:39 PM (14 years ago)

Author:

froman118

Message:

 

Location:

my-category-order/trunk

Files:

• mycategoryorder.php (modified) (6 diffs)
• readme.txt (modified) (1 diff)

my-category-order/trunk/mycategoryorder.php

@@ -4 +4 @@
 Plugin URI: http://www.geekyweekly.com/mycategoryorder
 Description: My Category Order allows you to set the order in which categories will appear in the sidebar. Uses a drag and drop interface for ordering. Adds a widget with additional options for easy installation on widgetized themes.
-Version: 3.3.1
+Version: 3.3.2
 Author: Andrew Charlton
 Author URI: http://www.geekyweekly.com
@@ -70 +70 @@
 
     if (isset($_POST['btnReturnParent'])) { 
-        $parentsParent = $wpdb->get_row("SELECT parent FROM $wpdb->term_taxonomy WHERE term_id = " . $_POST['hdnParentID'], ARRAY_N);
+        $parentsParent = $wpdb->get_row($wpdb->prepare("SELECT parent FROM $wpdb->term_taxonomy WHERE term_id = %d ", $_POST['hdnParentID']) , ARRAY_N);
         $parentID = $parentsParent[0];
     }
         
-    if(isset($_GET['hideNote']))
-        update_option('mycategoryorder_hideNote', '1');
-
     $success = "";
     if (isset($_POST['btnOrderCats'])) { 
@@ -89 +86 @@
         <h2><?php _e('My Category Order','mycategoryorder'); ?></h2>
     <?php 
-    
-    echo $success; 
-    
-    if (get_option("mycategoryorder_hideNote") != "1")
-        {   ?>
-            <div class="updated">
-                <strong><p><?php _e('If you like my plugin please consider donating. Every little bit helps me provide support and continue development.','mycategoryorder'); ?> <a href="http://geekyweekly.com/gifts-and-donations"><?php _e('Donate', 'mycategoryorder'); ?></a>&nbsp;&nbsp;<small><a href="<?php echo mycategoryorder_getTarget(); ?>&hideNote=true"><?php _e('No thanks, hide this', 'mycategoryorder'); ?></a></small></p></strong>
-            </div>
-        <?php
-        }?>
+        echo $success; 
+    ?>
 
     <p><?php _e('Choose a category from the drop down to order subcategories in that category or order the categories on this level by dragging and dropping them into the desired order.','mycategoryorder'); ?></p>
@@ -201 +190 @@
     
     $subCatStr = "";
-    $results=$wpdb->get_results("SELECT t.term_id, t.name FROM $wpdb->term_taxonomy tt, $wpdb->terms t, $wpdb->term_taxonomy tt2 WHERE tt.parent = $parentID AND tt.taxonomy = 'category' AND t.term_id = tt.term_id AND tt2.parent = tt.term_id GROUP BY t.term_id, t.name HAVING COUNT(*) > 0 ORDER BY t.term_order ASC");
+    $results=$wpdb->get_results($wpdb->prepare("SELECT t.term_id, t.name FROM $wpdb->term_taxonomy tt, $wpdb->terms t, $wpdb->term_taxonomy tt2 WHERE tt.parent = %d AND tt.taxonomy = 'category' AND t.term_id = tt.term_id AND tt2.parent = tt.term_id GROUP BY t.term_id, t.name HAVING COUNT(*) > 0 ORDER BY t.term_order ASC", $parentID));
     foreach($results as $row)
     {
@@ -222 +211 @@
         {
             $str = str_replace("id_", "", $IDs[$i]);
-            $wpdb->query("UPDATE $wpdb->terms SET term_order = '$i' WHERE term_id ='$str'");
+            $wpdb->query($wpdb->prepare("UPDATE $wpdb->terms SET term_order = %d WHERE term_id = %d ", $i, $str));
         }
 
@@ -234 +223 @@
 {
     global $wpdb;
-    return $wpdb->get_results("SELECT * FROM $wpdb->terms t inner join $wpdb->term_taxonomy tt on t.term_id = tt.term_id WHERE taxonomy = 'category' and parent = $parentID ORDER BY term_order ASC");
+    return $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->terms t inner join $wpdb->term_taxonomy tt on t.term_id = tt.term_id WHERE taxonomy = 'category' and parent = %d ORDER BY term_order ASC", $parentID));
 }
 

my-category-order/trunk/readme.txt

@@ -4 +4 @@
 Tags: categories, category, order, sidebar, widget
 Requires at least: 2.8
-Tested up to: 3.3.1
-Stable tag: 3.3.1
+Tested up to: 3.3.2
+Stable tag: 3.3.2
 
 My Category Order allows you to set the order in which categories will appear in the sidebar.