From 8aa6fd30f5a9e5e9e573eced947f2bd0486f1a7e Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Fri, 24 Nov 2006 06:51:15 +0000 Subject: new dealies and stuff --- lib/class/flag.class.php | 24 +++++++++++++++++++++++- 1 file changed, 23 insertions(+), 1 deletion(-) (limited to 'lib/class') diff --git a/lib/class/flag.class.php b/lib/class/flag.class.php index fe2f3047..05d51583 100644 --- a/lib/class/flag.class.php +++ b/lib/class/flag.class.php @@ -142,6 +142,28 @@ class Flag { } // get_flagged + /** + * get_approved + * This returns an array of approved flagged songs + */ + function get_approved() { + + $sql = "SELECT id FROM flagged WHERE approved='1'"; + $db_results = mysql_query($sql,dbh()); + + + /* Default the results array */ + $results = array(); + + /* While it */ + while ($r = mysql_fetch_assoc($db_results)) { + $results[] = $r['id']; + } + + return $results; + + } // get_approved + /** * add * This adds a flag entry for an item, it takes an id, a type, the flag type @@ -179,7 +201,7 @@ class Flag { return true; - } // reject + } // delete_flag /** * approve -- cgit