wups, wasnt cleaning up the playlist of objects with no votes

1 files changed, 11 insertions, 1 deletions

diff --git a/lib/class/tmp_playlist.class.php b/lib/class/tmp_playlist.class.php
index a262f3e8..4172583a 100644
--- a/lib/class/tmp_playlist.class.php
+++ b/lib/class/tmp_playlist.class.php
@@ -240,7 +240,7 @@ class tmpPlaylist {
 
 	/**
 	 * prune_tracks
-	 * This prunes tracks that don't have playlists
+	 * This prunes tracks that don't have playlists or don't have votes 
 	 */
 	function prune_tracks() { 
 
@@ -249,6 +249,13 @@ class tmpPlaylist {
 			"WHERE tmp_playlist.id IS NULL";
 		$db_results = mysql_query($sql,dbh());
 
+		$sql = "DELETE FROM tmp_playlist_data USING tmp_playlist_data " . 
+			"LEFT JOIN user_vote ON tmp_playlist_data.id=user_vote.object_id " . 
+			"WHERE user_vote.object_id IS NULL";
+		$db_results = mysql_query($sql,dbh());
+
+		return true; 
+
 	} // prune_tracks
 
 	/**
@@ -390,6 +397,9 @@ class tmpPlaylist {
 			"WHERE user='$user_id' AND tmp_playlist_data.object_id='$object_id' " . 
 			"AND tmp_playlist_data.tmp_playlist='" . sql_escape($this->id) . "'";
 		$db_results = mysql_query($sql,dbh());
+		
+		/* Clean up anything that has no votes */
+		$this->prune_tracks();
 
 		return true;