flush out the democratic mojo, make the cooldown work

1 files changed, 27 insertions, 0 deletions

diff --git a/lib/class/stats.class.php b/lib/class/stats.class.php
index 0c8a69cd..9f5cfdae 100644
--- a/lib/class/stats.class.php
+++ b/lib/class/stats.class.php
@@ -90,6 +90,33 @@ class Stats {
 	} // get_last_song
 
 	/**
+ 	 * get_object_history
+	 * This returns the objects that have happened for $user_id sometime after $time
+	 * used primarly by the democratic cooldown code
+	 */
+	public static function get_object_history($user_id='',$time) { 
+
+		$user_id = $user_id ? $user_id : $GLOBALS['user']->id;
+
+		$user_id = Dba::escape($user_id);
+
+		$time = Dba::escape($time); 
+
+		$sql = "SELECT * FROM `object_count` WHERE `user`='$user_id' AND `object_type`='song' AND `date`>='$time' " . 
+			"ORDER BY `date` DESC"; 
+		$db_results = Dba::query($sql); 
+
+		$results = array(); 
+
+		while ($row = Dba::fetch_assoc($db_results)) { 
+			$results[] = $row['object_id']; 
+		} 
+
+		return $results; 
+
+	} // get_object_history
+
+	/**
  	 * get_top
 	 * This returns the top X for type Y from the
 	 * last conf('stats_threshold') days