// Get the tracked bugs
$request = smcFunc::db_query('', '
SELECT COUNT(DISTINCT t.id_topic)
FROM {db_prefix}topics AS t
INNER JOIN main_messages AS m ON (m.id_msg = t.id_first_msg)
WHERE t.id_board = {int:bugs_board}
AND m.subject REGEXP({string:regex})',
array(
'bugs_board' => 137,
'regex' => '\[[0-9]{4}\]'
));
list ($tracked) = smcFunc::db_fetch_row($request);
smcFunc::db_free_result($request);
// Get the total
$request = smcFunc::db_query('', '
SELECT COUNT(id_topic)
FROM {db_prefix}topics
WHERE id_board = {int:bugs_board}',
array(
'bugs_board' => 137
));
list ($total) = smcFunc::db_fetch_row($request);
smcFunc::db_free_result($request);
// Get the locked
$request = smcFunc::db_query('', '
SELECT COUNT(id_topic)
FROM {db_prefix}topics
WHERE id_board = {int:bugs_board}
and locked = {int:locked}',
array(
'bugs_board' => 137,
'locked' => 1,
));
list ($locked) = smcFunc::db_fetch_row($request);
smcFunc::db_free_result($request);