Changeset 507109

Timestamp:

02/18/2012 10:05:14 PM (14 years ago)

Author:

Evil Genius

Message:

re-write of the question sorter

File:

• tf-faq/trunk/faq-actions.php (modified) (1 diff)

tf-faq/trunk/faq-actions.php

@@ -2 +2 @@
 global $wpdb;
 
-/***** change the faq order *****/
+/*** sort the questions ***/
 
-if(isset($_GET['direction']) and isset($_GET['order-id'])) {
+if(isset($_GET['direction'])) {
 
-    $this_question = faq_get_question($_GET['order-id']);
+    $direction = ($_GET['direction'] == 'down') ? array('<', 'DESC') : array('>', 'ASC');
+    $id = intval($_GET['order-id']);
+    $category = intval($_GET['cat']);
 
-    /*** determine change id ***/
-    if($_GET['direction'] == 'down') {
-        $change_id_sql = "SELECT id FROM ".$wpdb->prefix."faq_questions WHERE id<".$this_question->id." AND category='".$this_question->category."' ORDER BY id DESC LIMIT 0,1";
-    } else {
-        $change_id_sql = "SELECT id FROM ".$wpdb->prefix."faq_questions WHERE id>".$this_question->id." AND category='".$this_question->category."' ORDER BY id ASC LIMIT 0,1";
-    }
-    $change_id = $wpdb->get_results($change_id_sql);
-    $change_id = $change_id[0]->id;
+$sort_sql = "SELECT id FROM ".$wpdb->prefix."faq_questions WHERE id".$direction[0].$id." AND category='".$category."' ORDER BY id ".$direction[1]." LIMIT 0,1";
+$sort_id = $wpdb->get_results($sort_sql);
+$sort_id = $sort_id[0]->id;
 
-    //change the questions
-    $temp = $wpdb->query("UPDATE ".$wpdb->prefix."faq_questions SET id='".(0-$change_id)."' WHERE id='".$change_id."'");
-    $new = $wpdb->query("UPDATE ".$wpdb->prefix."faq_questions SET id='".$change_id."' WHERE id='".$this_question->id."'");
-    $final = $wpdb->query("UPDATE ".$wpdb->prefix."faq_questions SET id='".$this_question->id."' WHERE id='".(0-$change_id)."'");
-}
+$temp = $wpdb->update( $wpdb->prefix.'faq_questions', array('id' => (0-$sort_id)) , array('id' => $sort_id)  );
+$new = $wpdb->update( $wpdb->prefix.'faq_questions', array('id' => absint($sort_id)), array('id' => $id) );
+$final = $wpdb->update( $wpdb->prefix.'faq_questions', array('id' => absint($id)), array('id' => (0-$sort_id)) );
+
+}   /***    end if(isset($_GET['direction']))   ***/
+
+/*** end sort the questions ***/
 
 /*****  process the changes in questions    *****/