/** * Returns a user's play history * * @author Ben Dodson * @since 11/24/09 */ function getPlayHistory($for = false) { $for = jz_db_escape($for); $q = "SELECT n.*,p.user FROM jz_playcounts p,jz_nodes n WHERE p.media_id=n.my_id"; if ($for) { $q .= " AND p.user='******'"; } $q .= " AND n.ptype='track' GROUP BY p.media_id ORDER BY max(date) desc LIMIT 25"; $res = jz_db_object_query($q); // TODO: include user info in result return $res; }
/** * Unhides the element * * @author Ben Dodson * @version 9/18/04 * @since 9/18/04 */ function unhide() { global $sql_type, $sql_pw, $sql_usr, $sql_socket, $sql_db; $path = jz_db_escape($this->getPath("String")); jz_db_simple_query("UPDATE jz_nodes SET hidden='false' WHERE path = '{$path}'"); if ($this->isLeaf()) { jz_db_simple_query("UPDATE jz_tracks SET hidden='false' WHERE path = '{$path}'"); } }