public function getTasks($list)
{
$tasks = array();
$sql = "SELECT `tasks`.`id`, `tasks`.`text`, `tasks`.`raw_string`, `tasks`.`desc`, `tasks`.`date`, `tasks`.`done`,`tasks`.`date_created`,`tasks`.`date_updated`, `tasks`.`priority`,`tasks`.`hidden`,`tasks`.`replyto`\n\t\t\t\tFROM `lists_tasks` \n\t\t\t\tINNER JOIN `tasks`\n\t\t\t\tON `tasks`.`id` = `lists_tasks`.`task`\n\t\t\t\tWHERE `lists_tasks`.`list` = " . $list . " AND `tasks`.`hidden` != 1\n\t\t\t\tORDER BY `tasks`.`id` DESC;";
$result = Site::$db->query($sql);
while ($task = $result->fetch_object()) {
$item = TaskerHelper::getTaskArray($task);
$tasks[] = $item;
}
return $tasks;
}
