From 4040d0623dc6c88ee7119dd00244b8800c8e4684 Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Sun, 25 Nov 2007 07:21:45 +0000 Subject: fixed the page reloads once and for all, had to revert to iframe for democratic play and localplay, fixed an adding issue with democratic play if the songs were left in your active playlist --- lib/class/playlist.class.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'lib/class/playlist.class.php') diff --git a/lib/class/playlist.class.php b/lib/class/playlist.class.php index f186785f..eb74b163 100644 --- a/lib/class/playlist.class.php +++ b/lib/class/playlist.class.php @@ -146,12 +146,14 @@ class Playlist { * get_random_items * This is the same as before but we randomize the buggers! */ - public function get_random_items() { + public function get_random_items($limit='') { $results = array(); + $limit_sql = $limit ? 'LIMIT ' . intval($limit) : ''; + $sql = "SELECT `object_id`,`object_type`,`dynamic_song` FROM `playlist_data` " . - "WHERE `playlist`='" . Dba::escape($this->id) . "' ORDER BY RAND()"; + "WHERE `playlist`='" . Dba::escape($this->id) . "' ORDER BY RAND() $limit_sql"; $db_results = Dba::query($sql); while ($row = Dba::fetch_assoc($db_results)) { -- cgit