1 files changed, 16 insertions, 0 deletions
diff --git a/modules/gallery/helpers/item.php b/modules/gallery/helpers/item.php
index f6181f8a..1fd9ef16 100644
--- a/modules/gallery/helpers/item.php
+++ b/modules/gallery/helpers/item.php
@@ -173,4 +173,20 @@ class item_Core {
   static function root() {
     return model_cache::get("item", 1);
   }
+
+  /**
+   * Return a query to get a random Item_Model, with optional filters
+   *
+   * @param array   (optional) where tuple
+   */
+  static function random_query($where=null) {
+    // Pick a random number and find the item that's got nearest smaller number.
+    // This approach works best when the random numbers in the system are roughly evenly
+    // distributed so this is going to be more efficient with larger data sets.
+    return ORM::factory("item")
+      ->viewable()
+      ->where("rand_key", "<", ((float)mt_rand()) / (float)mt_getrandmax())
+      ->merge_where($where)
+      ->order_by("rand_key", "DESC");
+  }
 }
 \ No newline at end of file