public function getTasksByKeyword($keyword, $type) { $tasks = array(); $keyid = Keywords::getKeyID($keyword, $type); #FB::info('Type '.$type.' Keyword '.$keyword.' Keyid '.$keyid, 'getTasksByKeyword'); $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 `key_relations` \n\t\t\t\tINNER JOIN `tasks`\n\t\t\t\tON `tasks`.`id` = `key_relations`.`task`\n\t\t\t\tWHERE `key_relations`.`keyword` = " . $keyid . " AND `key_relations`.`user` = " . Site::$user . "\n\t\t\t\tORDER BY `key_relations`.`id` DESC;"; $result = Site::$db->query($sql); #FB::error($result->num_rows, 'SQL'); if ($result->num_rows > 0) { while ($task = $result->fetch_object()) { $item = TaskerHelper::getTaskArray($task); #FB::info($item, 'ListsHelper'); $tasks[] = $item; } } $this->lists[$keyid]['list'] = array('id' => $keyid, 'name' => $keyword); $this->lists[$keyid]['tasks'] = $tasks; }