Changeset 534576

Timestamp:

04/21/2012 10:15:26 PM (14 years ago)

Author:

froman118

Message:

 

Location:

my-page-order/trunk

Files:

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

my-page-order/trunk/mypageorder.php

@@ -4 +4 @@
 Plugin URI: http://www.geekyweekly.com/mypageorder
 Description: My Page Order allows you to set the order of pages through a drag and drop interface. The default method of setting the order page by page is extremely clumsy, especially with a large number of pages.
-Version: 3.3.1
+Version: 3.3.2
 Author: Andrew Charlton
 Author URI: http://www.geekyweekly.com
@@ -53 +53 @@
 
 if (isset($_POST['btnReturnParent'])) { 
-    $parentsParent = $wpdb->get_row("SELECT post_parent FROM $wpdb->posts WHERE ID = " . $_POST['hdnParentID'], ARRAY_N);
+    $parentsParent = $wpdb->get_row( $wpdb->prepare("SELECT post_parent FROM $wpdb->posts WHERE ID = %d ", $_POST['hdnParentID'] ), ARRAY_N);
     $parentID = $parentsParent[0];
-}
-
-if(isset($_GET['hideNote'])) {
-    update_option('mypageorder_hideNote', '1');
 }
 
@@ -72 +68 @@
 <form name="frmMyPageOrder" method="post" action="">
     <h2><?php _e('My Page Order', 'mypageorder') ?></h2>
-    <?php 
-    echo $success;
-    if (get_option("mypageorder_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.','mypageorder'); ?> <a href="http://geekyweekly.com/gifts-and-donations"><?php _e('Donate', 'mypageorder'); ?></a>&nbsp;&nbsp;<small><a href="<?php echo mypageorder_getTarget(); ?>&hideNote=true"><?php _e('No thanks, hide this', 'mypageorder'); ?></a></small></p></strong>
-        </div>
-    <?php
-    }
-    ?>
+    <?php echo $success; ?>
     
     <p><?php _e('Choose a page from the drop down to order its subpages or order the pages on this level by dragging and dropping them into the desired order.', 'mypageorder') ?></p>
@@ -201 +188 @@
         {
             $str = str_replace("id_", "", $IDs[$i]);
-            $wpdb->query("UPDATE $wpdb->posts SET menu_order = '$i' WHERE id ='$str'");
+            $wpdb->query($wpdb->prepare("UPDATE $wpdb->posts SET menu_order = %d WHERE id = %d ", $i, $str));
         }
 
@@ -218 +205 @@
     foreach($results as $row)
     {
-        $postCount=$wpdb->get_row("SELECT count(*) as postsCount FROM $wpdb->posts WHERE post_parent = $row->ID and post_type = 'page' AND post_status != 'trash' AND post_status != 'auto-draft' ", ARRAY_N);
+        $postCount=$wpdb->get_row($wpdb->prepare("SELECT count(*) as postsCount FROM $wpdb->posts WHERE post_parent = %d and post_type = 'page' AND post_status != 'trash' AND post_status != 'auto-draft' ", $row->ID) , ARRAY_N);
         if($postCount[0] > 0)
             $subPageStr = $subPageStr."<option value='$row->ID'>".__($row->post_title)."</option>";
@@ -228 +215 @@
 {
     global $wpdb;
-    return $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_parent = $parentID and post_type = 'page' AND post_status != 'trash' AND post_status != 'auto-draft' ORDER BY menu_order ASC");
+    return $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->posts WHERE post_parent = %d and post_type = 'page' AND post_status != 'trash' AND post_status != 'auto-draft' ORDER BY menu_order ASC", $parentID) );
 }
 

my-page-order/trunk/readme.txt

@@ -4 +4 @@
 Tags: page, 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 Page Order allows you to set the order of pages through a drag and drop interface.