/**
* 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}'");
}
}
