This screen allows you to search the patch database. The patches listed here
are ordered by queue. Click on the patch title to view the patch details or
perform actions on the patches.
The 'Patch ID' search field accepts SQL-like expressions. So it is possible to
also limit the search on e.g. years or months.
The full-text search field accepts MySQL 'MATCH IN BOOLEAN MODE' expressions.
I.e. it is possible to e.g. exclude search terms by prefixing them with a
minus sign.
The file search is using regular expressions.
The votes search field accepts expression in '[+-]username' syntax.
The little circles next to patch titles are part of the buffering system.
Click them to add or remove patches to or from the buffer, respectively.
: SELECT
: p.patch_id AS id,
: p.patch_uid AS uid,
: p.queue_id AS queue_id
: FROM
: patch AS p
: WHERE
: 1
: AND
: p.patch_status = ${mysql::filter.status}
: AND
: p.queue_id = ${mysql::filter.queue}
: AND
: (SELECT count(*) FROM journal_patch AS jp WHERE jp.journal_id = ${mysql::filter.journal} AND jp.patch_id = p.patch_id) > 0
: AND
: p.patch_uid ${filter.buffer ? "" : "NOT"} IN (0
, ${mysql::b})
: AND
: p.patch_votecheckok = ${mysql::filter.votecheck}
: AND
: p.patch_uid like ${mysql::filter.uid}
: AND
: p.user_id_owner = (SELECT user_id FROM user WHERE user_name = ${mysql::filter.owner})
: AND
: MATCH(p.patch_text) AGAINST (${mysql::filter.search} IN BOOLEAN MODE)
: AND
: (
: SELECT
: 1
: FROM
: patch_file
: WHERE
: patch_id = p.patch_id
: AND
: patch_file REGEXP ${mysql::filter.files}
: LIMIT
: 1
: )
[-+]?)(?P.+)/I)
continue;
?>
: AND
: (
: SELECT
: 1
: FROM
: vote JOIN user USING (user_id)
: WHERE
: patch_id = p.patch_id
: AND
: user_name = ${mysql::v_user}
: AND
: vote_type = ${mysql::v_type}
: )
: ORDER BY
: p.queue_id,
: p.patch_id
: LIMIT
: 150
);
var last_queue_id = -1;
?>
:
:
:
:
:
-- Unqueued patches --
:
: ${html_patch(p.uid, 0, 0, 0)}
:
:
:
:
: Found $total_patch_count patches matching your query.
:
: (Searches are automatically stopped after 150 matches.)
: