function getAcraIssueCount() { $acra_id = $_GET['acra_hash']; $t_acra_issue_table = plugin_table("issue"); $where = getFilterQueryString(); $query = "SELECT count(*) FROM {$t_acra_issue_table} WHERE `report_fingerprint`='" . $acra_id . "'" . $where; $result = db_query_bound($query); $result = db_fetch_array($result); return (int) $result['count(*)']; }
function getAcraIssueList($page_num, $total_count) { global $acra_id; $acra_id = $_GET['acra_hash']; $t_acra_issue_table = plugin_table("issue"); $where = getFilterQueryString(); $query = "SELECT * FROM {$t_acra_issue_table} WHERE `report_fingerprint`='" . $acra_id . "'" . $where . buildOrderString() . buildPageQueryString($page_num, $total_count); $result = db_query_bound($query); $list = array(); while (true) { $row = db_fetch_array($result); if ($row === false) { break; } $list[] = $row; } return $list; }