Context Navigation

Changeset 629443

Timestamp:

11/24/2012 04:37:11 PM (13 years ago)

Author:

ashrafweb

Message:

sql new update

Location:

related-posts-list-grid-and-slider-all-in-one

Files:

-                      r628980
+                      r629443
     } else {
         $searches = false;
+    }
+return $searches+$searches;
+    }
+$idslist = "'" . $post->ID. "'";
+if ($mycount > 0) {
+    for ($i = 0; $i < $mycount; $i++) {
+           $idslist = $idslist . ", '" . $searches[$i]->ID. "'";
+    }
+}
+$new_limit = $limit - $mycount;
+$sql = "SELECT ID,post_title,post_date "
+        . "FROM ". "$wpdb->posts "
+        ." WHERE "
+        ."post_type = 'post' and post_status = 'publish' "
+        . "AND (id NOT IN ($idslist)) "
+        ."LIMIT ".$new_limit;
+        $searches2 = $wpdb->get_results($sql);
+$merged_searches = array_merge($searches, $searches2);
+return $merged_searches;
+}
 //------------------------------------------------------------------------

-                      r628980
+                      r629443
     } else {
         $searches = false;
+    }
+return $searches+$searches;
+    }
+$idslist = "'" . $post->ID. "'";
+if ($mycount > 0) {
+    for ($i = 0; $i < $mycount; $i++) {
+           $idslist = $idslist . ", '" . $searches[$i]->ID. "'";
+    }
+}
+$new_limit = $limit - $mycount;
+$sql = "SELECT ID,post_title,post_date "
+        . "FROM ". "$wpdb->posts "
+        ." WHERE "
+        ."post_type = 'post' and post_status = 'publish' "
+        . "AND (id NOT IN ($idslist)) "
+        ."LIMIT ".$new_limit;
+        $searches2 = $wpdb->get_results($sql);
+$merged_searches = array_merge($searches, $searches2);
+return $merged_searches;
+}
 //------------------------------------------------------------------------

Note: See TracChangeset for help on using the changeset viewer.