/**
* Get all of the lists associated with this user.
*
* @return array
* @access public
*/
public function getLists()
{
$lists = array();
// Make sure at least "My Favorites" always exists
$list = new User_list();
$list->user_id = $this->id;
if (!$list->find(true)) {
$list->title = "My Favorites";
if (!$list->find(true)) {
$list->insert();
}
}
$sql = 'SELECT "user_list".*, COUNT("user_resource"."id") AS cnt ' . 'FROM "user_list" LEFT JOIN "user_resource" ' . 'ON "user_list"."id" = "user_resource"."list_id" ' . 'WHERE "user_list"."user_id" = ' . "'" . $this->escape($this->id) . "' " . 'GROUP BY "user_list"."id", "user_list"."user_id", ' . '"user_list"."title", "user_list"."description", ' . '"user_list"."created", "user_list"."public" ' . 'ORDER BY "user_list"."created"';
$list = new User_list();
$list->query($sql);
if ($list->N) {
while ($list->fetch()) {
$lists[] = clone $list;
}
}
return $lists;
}
function getLists()
{
require_once 'User_list.php';
$lists = array();
$sql = "SELECT user_list.*, COUNT(user_resource.id) AS cnt FROM user_list " . "LEFT JOIN user_resource ON user_list.id = user_resource.list_id " . "WHERE user_list.user_id = '{$this->id}' " . "GROUP BY user_list.id, user_list.user_id, user_list.title, " . "user_list.description, user_list.created, user_list.public " . "ORDER BY user_list.title";
$list = new User_list();
$list->query($sql);
if ($list->N) {
while ($list->fetch()) {
$lists[] = clone $list;
}
}
return $lists;
}
