function sponsorship_cache_row($p_sponsorship_id, $p_trigger_errors = true) { global $g_cache_sponsorships; $c_sponsorship_id = db_prepare_int($p_sponsorship_id); $t_sponsorship_table = config_get('mantis_sponsorship_table'); if (isset($g_cache_sponsorships[$c_sponsorship_id])) { return $g_cache_sponsorships[$c_sponsorship_id]; } $query = "SELECT *\r\n\t\t\t\t FROM {$t_sponsorship_table}\r\n\t\t\t\t WHERE id='{$c_sponsorship_id}'"; $result = db_query($query); if (0 == db_num_rows($result)) { $g_cache_sponsorships[$c_sponsorship_id] = false; if ($p_trigger_errors) { error_parameters($p_sponsorship_id); trigger_error(ERROR_SPONSORSHIP_NOT_FOUND, ERROR); } else { return false; } } $row = db_fetch_array($result); $row['date_submitted'] = db_unixtimestamp($row['date_submitted']); $row['last_updated'] = db_unixtimestamp($row['last_updated']); $g_cache_sponsorships[$c_sponsorship_id] = $row; return $row; }
function bug_get_bugnote_stats($p_bug_id) { global $g_cache_bug; $c_bug_id = db_prepare_int($p_bug_id); if (!is_null($g_cache_bug[$c_bug_id]['_stats'])) { if ($g_cache_bug[$c_bug_id]['_stats'] === false) { return false; } else { $t_stats['last_modified'] = db_unixtimestamp($g_cache_bug[$c_bug_id]['_stats']['last_modified']); $t_stats['count'] = $g_cache_bug[$c_bug_id]['_stats']['count']; } return $t_stats; } $t_bugnote_table = config_get('mantis_bugnote_table'); $query = "SELECT last_modified\n\t\t\t\t FROM {$t_bugnote_table}\n\t\t\t\t WHERE bug_id='{$c_bug_id}'\n\t\t\t\t ORDER BY last_modified DESC"; $result = db_query($query); $row = db_fetch_array($result); if (false === $row) { return false; } $t_stats['last_modified'] = db_unixtimestamp($row['last_modified']); $t_stats['count'] = db_num_rows($result); return $t_stats; }
function install_date_migrate($p_data) { // $p_data[0] = tablename, [1] id column, [2] = old column, [3] = new column # Disable query logging even if enabled in config, due to possibility of mass spam $t_log_queries = install_set_log_queries(); $t_table = $p_data[0]; $t_id_column = $p_data[1]; if (is_array($p_data[2])) { $t_old_column = implode(',', $p_data[2]); $t_date_array = true; $t_cnt_fields = count($p_data[2]); $t_pairs = array(); foreach ($p_data[3] as $var) { array_push($t_pairs, "{$var}=" . db_param()); } $t_new_column = implode(',', $t_pairs); $query = "SELECT {$t_id_column}, {$t_old_column} FROM {$t_table}"; $t_first_column = true; # In order to handle large databases where we may timeout during the upgrade, we don't # start form the beginning everytime. Here we will only pickup rows where at least one # of the datetime fields wasn't upgraded yet and upgrade them all. foreach ($p_data[3] as $t_new_column_name) { if ($t_first_column) { $t_first_column = false; $query .= ' WHERE '; } else { $query .= ' OR '; } $query .= "{$t_new_column_name} = 1"; } } else { $t_old_column = $p_data[2]; $t_new_column = $p_data[3] . "=" . db_param(); $t_date_array = false; # The check for timestamp being = 1 is to make sure the field wasn't upgraded # already in a previous run - see bug #12601 for more details. $t_new_column_name = $p_data[3]; $query = "SELECT {$t_id_column}, {$t_old_column} FROM {$t_table} WHERE {$t_new_column_name} = 1"; } $t_result = db_query_bound($query); while ($row = db_fetch_array($t_result)) { $t_id = (int) $row[$t_id_column]; if ($t_date_array) { for ($i = 0; $i < $t_cnt_fields; $i++) { $t_old_value = $row[$p_data[2][$i]]; $t_new_value[$i] = db_unixtimestamp($t_old_value); if ($t_new_value[$i] < 100000) { $t_new_value[$i] = 1; } } $t_values = $t_new_value; $t_values[] = $t_id; } else { $t_old_value = $row[$t_old_column]; $t_new_value = db_unixtimestamp($t_old_value); if ($t_new_value < 100000) { $t_new_value = 1; } $t_values = array($t_new_value, $t_id); } $query = "UPDATE {$t_table} SET {$t_new_column}\n\t\t\t\t\tWHERE {$t_id_column}=" . db_param(); db_query_bound($query, $t_values); } # Re-enable query logging if we disabled it install_set_log_queries($t_log_queries); # return 2 because that's what ADOdb/DataDict does when things happen properly return 2; }
function email_queue_row_to_object($p_row) { # typically this function takes as an input the result of db_fetch_array() which can be false. if ($p_row === false) { return false; } $t_row = $p_row; $t_row['submitted'] = db_unixtimestamp($t_row['submitted']); $t_row['metadata'] = unserialize($t_row['metadata']); $t_email_data = new EmailData(); $t_row_keys = array_keys($t_row); $t_vars = get_object_vars($t_email_data); # Check each variable in the class foreach ($t_vars as $t_var => $t_value) { # If we got a field from the DB with the same name if (in_array($t_var, $t_row_keys, true)) { # Store that value in the object $t_email_data->{$t_var} = $t_row[$t_var]; } } return $t_email_data; }
if (OFF == config_get('enable_project_documentation')) { access_denied(); } access_ensure_project_level(config_get('view_proj_doc_threshold'), $v_project_id); break; } # flush output buffer to protect download @ob_end_clean(); # Make sure that IE can download the attachments under https. header('Pragma: public'); header('Content-Type: ' . $v_file_type); header('Content-Length: ' . $v_filesize); # Added Quotes (") around file name. header('Content-Disposition: attachment; filename="' . file_get_display_name($v_filename) . '"'); header('Content-Description: Download Data'); header('Last-Modified: ' . gmdate('D, d M Y H:i:s \\G\\M\\T', db_unixtimestamp($v_date_added))); # To fix an IE bug which causes problems when downloading # attached files via HTTPS, we disable the "Pragma: no-cache" # command when IE is used over HTTPS. global $g_allow_file_cache; if (isset($_SERVER["HTTPS"]) && "on" == $_SERVER["HTTPS"] && preg_match("/MSIE/", $_SERVER["HTTP_USER_AGENT"])) { # Suppress "Pragma: no-cache" header. } else { if (!isset($g_allow_file_cache)) { header('Pragma: no-cache'); } } header('Expires: ' . gmdate('D, d M Y H:i:s \\G\\M\\T', time())); # dump file content to the connection. switch (config_get('file_upload_method')) { case DISK:
<tr> <td class="print"> <?php echo print_user($v3_reporter_id); ?> </td> </tr> <tr> <td class="print"> <?php echo $v3_date_submitted; ?> <?php if (db_unixtimestamp($v3_date_submitted) != db_unixtimestamp($v3_last_modified)) { echo '<br />(' . lang_get('edited_on') . ' ' . $v3_last_modified . ')'; } ?> </td> </tr> </table> </td> <td class="nopad" valign="top" width="85%"> <table class="hide" cellspacing="1"> <tr> <td class="print"> <?php switch ($v3_note_type) { case REMINDER: echo '<div class="italic">' . lang_get('reminder_sent_to') . ': ';
function create_cumulative_bydate() { $t_clo_val = CLOSED; $t_res_val = config_get('bug_resolved_status_threshold'); $t_bug_table = config_get('mantis_bug_table'); $t_history_table = config_get('mantis_bug_history_table'); $t_project_id = helper_get_current_project(); $t_user_id = auth_get_current_user_id(); $specific_where = helper_project_specific_where($t_project_id, $t_user_id); # Get all the submitted dates $query = "SELECT date_submitted\n\t\t\t\tFROM {$t_bug_table}\n\t\t\t\tWHERE {$specific_where}\n\t\t\t\tORDER BY date_submitted"; $result = db_query($query); $bug_count = db_num_rows($result); for ($i = 0; $i < $bug_count; $i++) { $row = db_fetch_array($result); # rationalise the timestamp to a day to reduce the amount of data $t_date = db_unixtimestamp($row['date_submitted']); $t_date = (int) ($t_date / 86400); if (isset($metrics[$t_date])) { $metrics[$t_date][0]++; } else { $metrics[$t_date] = array(1, 0, 0); } } ### Get all the dates where a transition from not resolved to resolved may have happened # also, get the last updated date for the bug as this may be all the information we have $query = "SELECT {$t_bug_table}.id, last_updated, date_modified, new_value, old_value\n\t\t\tFROM {$t_bug_table} LEFT JOIN {$t_history_table}\n\t\t\tON {$t_bug_table}.id = {$t_history_table}.bug_id\n\t\t\tWHERE {$specific_where}\n\t\t\t\t\t\tAND {$t_bug_table}.status >= '{$t_res_val}'\n\t\t\t\t\t\tAND ( ( {$t_history_table}.new_value >= '{$t_res_val}'\n\t\t\t\t\t\t\t\tAND {$t_history_table}.field_name = 'status' )\n\t\t\t\t\t\tOR {$t_history_table}.id is NULL )\n\t\t\tORDER BY {$t_bug_table}.id, date_modified ASC"; $result = db_query($query); $bug_count = db_num_rows($result); $t_last_id = 0; for ($i = 0; $i < $bug_count; $i++) { $row = db_fetch_array($result); $t_id = $row['id']; # if h_last_updated is NULL, there were no appropriate history records # (i.e. pre 0.18 data), use last_updated from bug table instead if (NULL == $row['date_modified']) { $t_date = db_unixtimestamp($row['last_updated']); } else { if ($t_res_val > $row['old_value']) { $t_date = db_unixtimestamp($row['date_modified']); } } if ($t_id != $t_last_id) { if (0 != $t_last_id) { # rationalise the timestamp to a day to reduce the amount of data $t_date_index = (int) ($t_last_date / 86400); if (isset($metrics[$t_date_index])) { $metrics[$t_date_index][1]++; } else { $metrics[$t_date_index] = array(0, 1, 0); } } $t_last_id = $t_id; } $t_last_date = $t_date; } ksort($metrics); $metrics_count = count($metrics); $t_last_opened = 0; $t_last_resolved = 0; foreach ($metrics as $i => $vals) { $t_date = $i * 86400; $t_metrics[$t_date][0] = $t_last_opened = $metrics[$i][0] + $t_last_opened; $t_metrics[$t_date][1] = $t_last_resolved = $metrics[$i][1] + $t_last_resolved; $t_metrics[$t_date][2] = $t_metrics[$t_date][0] - $t_metrics[$t_date][1]; } return $t_metrics; }
# will look up the most recent 'resolved' status change and return it as well $query = "SELECT b.id, b.date_submitted, b.last_updated, MAX(h.date_modified) as hist_update, b.status \n FROM {$t_bug_table} b LEFT JOIN {$t_history_table} h \n ON b.id = h.bug_id AND h.type=0 AND h.field_name='status' AND h.new_value='{$t_resolved}' \n WHERE b.status >='{$t_resolved}' AND {$specific_where}\n GROUP BY b.id, b.status, b.date_submitted, b.last_updated \n ORDER BY b.id ASC"; $result = db_query($query); $bug_count = db_num_rows($result); $t_bug_id = 0; $t_largest_diff = 0; $t_total_time = 0; for ($i = 0; $i < $bug_count; $i++) { $row = db_fetch_array($result); $t_date_submitted = db_unixtimestamp($row['date_submitted']); $t_id = $row['id']; $t_status = $row['status']; if ($row['hist_update'] !== NULL) { $t_last_updated = db_unixtimestamp($row['hist_update']); } else { $t_last_updated = db_unixtimestamp($row['last_updated']); } if ($t_last_updated < $t_date_submitted) { $t_last_updated = 0; $t_date_submitted = 0; } $t_diff = $t_last_updated - $t_date_submitted; $t_total_time = $t_total_time + $t_diff; if ($t_diff > $t_largest_diff) { $t_largest_diff = $t_diff; $t_bug_id = $row['id']; } } if ($bug_count < 1) { $bug_count = 1; }
function string_get_bugnote_view_link($p_bug_id, $p_bugnote_id, $p_user_id = null, $p_detail_info = true, $p_fqdn = false) { if (bug_exists($p_bug_id) && bugnote_exists($p_bugnote_id)) { $t_link = '<a href="'; if ($p_fqdn) { $t_link .= config_get('path'); } $t_link .= string_get_bugnote_view_url($p_bug_id, $p_bugnote_id, $p_user_id) . '"'; if ($p_detail_info) { $t_reporter = string_attribute(user_get_name(bugnote_get_field($p_bugnote_id, 'reporter_id'))); $t_update_date = string_attribute(date(config_get('normal_date_format'), db_unixtimestamp(bugnote_get_field($p_bugnote_id, 'last_modified')))); $t_link .= ' title="[' . $t_update_date . '] ' . $t_reporter . '"'; } $t_link .= '>' . lang_get('bugnote') . ': ' . bugnote_format_id($p_bugnote_id) . '</a>'; } else { $t_link = lang_get('bugnote') . ': ' . bugnote_format_id($p_bugnote_id); } return $t_link; }
function news_get_limited_rows($p_offset, $p_project_id = null) { if ($p_project_id === null) { $p_project_id = helper_get_current_project(); } $c_offset = db_prepare_int($p_offset); $t_projects = current_user_get_all_accessible_subprojects($p_project_id); $t_projects[] = $p_project_id; if (ALL_PROJECTS != $p_project_id) { $t_projects[] = ALL_PROJECTS; } $t_projects = array_map('db_prepare_int', $t_projects); $t_news_table = config_get('mantis_news_table'); $t_news_view_limit = config_get('news_view_limit'); $t_news_view_limit_days = config_get('news_view_limit_days'); switch (config_get('news_limit_method')) { case 0: # BY_LIMIT - Select the news posts $query = "SELECT *\n\t\t\t\t\t\tFROM {$t_news_table}"; if (1 == count($t_projects)) { $c_project_id = $t_projects[0]; $query .= " WHERE project_id='{$c_project_id}'"; } else { $query .= ' WHERE project_id IN (' . join($t_projects, ',') . ')'; } $query .= ' ORDER BY announcement DESC, id DESC'; $result = db_query($query, $t_news_view_limit, $c_offset); break; case 1: # BY_DATE - Select the news posts $query = "SELECT *\n\t\t\t\t\t\tFROM {$t_news_table}"; if (1 == count($t_projects)) { $c_project_id = $t_projects[0]; $query .= " WHERE project_id='{$c_project_id}'"; } else { $query .= ' WHERE project_id IN (' . join($t_projects, ',') . ')'; } $query .= " AND " . db_helper_compare_days(db_now(), 'date_posted', "< {$t_news_view_limit_days}") . " OR announcement = 1\n\t\t\t\t\t\tORDER BY announcement DESC, id DESC"; $result = db_query($query, $t_news_view_limit, $c_offset); break; } # end switch $t_row_count = db_num_rows($result); $t_rows = array(); for ($i = 0; $i < $t_row_count; $i++) { $row = db_fetch_array($result); $row['date_posted'] = db_unixtimestamp($row['date_posted']); array_push($t_rows, $row); } return $t_rows; }
echo lang_get('bug_notes_title'); ?> </td> </tr> <?php for ($i = 0; $i < $num_notes; $i++) { # prefix all bugnote data with v3_ $row = db_fetch_array($result); extract($row, EXTR_PREFIX_ALL, 'v3'); if (db_unixtimestamp($v3_date_submitted) != db_unixtimestamp($v3_last_modified)) { $t_bugnote_modified = true; } else { $t_bugnote_modified = false; } $v3_date_submitted = date(config_get('normal_date_format'), db_unixtimestamp($v3_date_submitted)); $v3_last_modified = date(config_get('normal_date_format'), db_unixtimestamp($v3_last_modified)); # grab the bugnote text and id and prefix with v3_ $query = "SELECT note\n\t\t\t\tFROM {$t_bugnote_text_table}\n\t\t\t\tWHERE id='{$v3_bugnote_text_id}'"; $result2 = db_query($query); $row = db_fetch_array($result2); $v3_note = $row['note']; $v3_note = string_display_links($v3_note); $t_bugnote_id_formatted = bugnote_format_id($v3_id); if (VS_PRIVATE == $v3_view_state) { $t_bugnote_css = 'bugnote-private'; $t_bugnote_note_css = 'bugnote-note-private'; } else { $t_bugnote_css = 'bugnote-public'; $t_bugnote_note_css = 'bugnote-note-public'; } ?>
function bugnote_get_all_bugnotes($p_bug_id, $p_user_bugnote_order, $p_user_bugnote_limit) { global $g_cache_bugnotes; if (!isset($g_cache_bugnotes)) { $g_cache_bugnotes = array(); } # the cache should be aware of the sorting order if (!isset($g_cache_bugnotes[$p_bug_id][$p_user_bugnote_order])) { $c_bug_id = db_prepare_int($p_bug_id); $t_bugnote_table = config_get('mantis_bugnote_table'); $t_bugnote_text_table = config_get('mantis_bugnote_text_table'); if (0 == $p_user_bugnote_limit) { ## Show all bugnotes $t_bugnote_limit = -1; $t_bugnote_offset = -1; } else { ## Use offset only if order is ASC to get the last bugnotes if ('ASC' == $p_user_bugnote_order) { $result = db_query("SELECT COUNT(*) AS row_count FROM {$t_bugnote_table} WHERE bug_id = '{$c_bug_id}'"); $row = db_fetch_array($result); $t_bugnote_offset = $row['row_count'] - $p_user_bugnote_limit; } else { $t_bugnote_offset = -1; } $t_bugnote_limit = $p_user_bugnote_limit; } # sort by bugnote id which should be more accurate than submit date, since two bugnotes # may be submitted at the same time if submitted using a script (eg: MantisConnect). $query = "SELECT b.*, t.note\r\n\t\t\t \tFROM {$t_bugnote_table} b\r\n\t\t\t \tLEFT JOIN {$t_bugnote_text_table} t ON b.bugnote_text_id = t.id\r\n\t\t\t \tWHERE b.bug_id = '{$c_bug_id}'\r\n\t\t\t \tORDER BY b.id {$p_user_bugnote_order}"; $t_bugnotes = array(); # BUILD bugnotes array $result = db_query($query, $t_bugnote_limit, $t_bugnote_offset); $count = db_num_rows($result); for ($i = 0; $i < $count; $i++) { $row = db_fetch_array($result); $t_bugnote = new BugnoteData(); $t_bugnote->id = $row['id']; $t_bugnote->bug_id = $row['bug_id']; $t_bugnote->note = $row['note']; $t_bugnote->view_state = $row['view_state']; $t_bugnote->reporter_id = $row['reporter_id']; $t_bugnote->date_submitted = db_unixtimestamp($row['date_submitted']); $t_bugnote->last_modified = db_unixtimestamp($row['last_modified']); $t_bugnote->note_type = $row['note_type']; $t_bugnote->note_attr = $row['note_attr']; $t_bugnote->time_tracking = $row['time_tracking']; $t_bugnotes[] = $t_bugnote; } $g_cache_bugnotes[$p_bug_id][$p_user_bugnote_order] = $t_bugnotes; } return $g_cache_bugnotes[$p_bug_id][$p_user_bugnote_order]; }
?> </td> <td class="right"> <?php print_doc_menu('proj_doc_page.php'); ?> </td> </tr> <?php for ($i = 0; $i < $num_files; $i++) { $row = db_fetch_array($result); extract($row, EXTR_PREFIX_ALL, 'v'); $v_filesize = number_format($v_filesize); $v_title = string_display($v_title); $v_description = string_display_links($v_description); $v_date_added = date(config_get('normal_date_format'), db_unixtimestamp($v_date_added)); ?> <tr valign="top" <?php echo helper_alternate_class($i); ?> > <td> <?php $t_href = '<a href="file_download.php?file_id=' . $v_id . '&type=doc">'; echo $t_href; print_file_icon($v_filename); echo '</a> ' . $t_href . $v_title . '</a> (' . $v_filesize . ' bytes)'; ?> <br /> <span class="small"> <?php
/** * Get the attachments of an issue. * * @param integer $p_issue_id The id of the issue to retrieve the attachments for * @return Array that represents an AttachmentData structure */ function mci_issue_get_attachments($p_issue_id) { $t_attachment_rows = bug_get_attachments($p_issue_id); $t_result = array(); foreach ($t_attachment_rows as $t_attachment_row) { $t_attachment = array(); $t_attachment['id'] = $t_attachment_row['id']; $t_attachment['filename'] = $t_attachment_row['filename']; $t_attachment['size'] = $t_attachment_row['filesize']; $t_attachment['content_type'] = $t_attachment_row['file_type']; $t_attachment['date_submitted'] = timestamp_to_iso8601(db_unixtimestamp($t_attachment_row['date_added'])); $t_attachment['download_url'] = mci_get_mantis_path() . 'file_download.php?file_id=' . $t_attachment_row['id'] . '&type=bug'; $t_result[] = $t_attachment; } return $t_result; }
/** * Format date for display */ function string_format_complete_date($p_date) { $t_timestamp = db_unixtimestamp($p_date); return date(config_get('complete_date_format'), $t_timestamp); }
# (e.g., bug is CLOSED, not RESOLVED). The linkage to the history field # will look up the most recent 'resolved' status change and return it as well $query = "SELECT b.id, b.date_submitted, b.last_updated, MAX(h.date_modified) as hist_update, b.status \n FROM {$t_bug_table} b LEFT JOIN {$t_history_table} h \n ON b.id = h.bug_id AND h.type=0 AND h.field_name='status' AND h.new_value='{$t_resolved}' \n WHERE b.status >='{$t_resolved}' \n GROUP BY b.id, b.status, b.date_submitted, b.last_updated \n ORDER BY b.id ASC"; $result = db_query($query); $bug_count = db_num_rows($result); $t_bug_id = 0; $t_largest_diff = 0; $t_total_time = 0; for ($i = 0; $i < $bug_count; $i++) { $row = db_fetch_array($result); $t_date_submitted = db_unixtimestamp($row['date_submitted']); $t_last_updated = db_unixtimestamp($row['last_updated']); $t_id = $row['id']; $t_status = $row['status']; if ($row['hist_update'] !== NULL) { $t_last_updated = db_unixtimestamp($row['hist_update']); } if ($t_last_updated < $t_date_submitted) { $t_last_updated = 0; $t_date_submitted = 0; } $t_diff = $t_last_updated - $t_date_submitted; $t_total_time = $t_total_time + $t_diff; if ($t_diff > $t_largest_diff) { $t_largest_diff = $t_diff; $t_bug_id = $row['id']; } } if ($bug_count < 1) { $bug_count = 1; }
function version_get_all_rows_with_subs($p_project_id, $p_released = null) { $t_project_where = helper_project_specific_where($p_project_id); if ($p_released === null) { $t_released_where = ''; } else { $c_released = db_prepare_int($p_released); $t_released_where = "AND ( released = {$c_released} )"; } $t_project_version_table = config_get('mantis_project_version_table'); $query = "SELECT *\r\n\t\t\t\t FROM {$t_project_version_table}\r\n\t\t\t\t WHERE {$t_project_where} {$t_released_where}\r\n\t\t\t\t ORDER BY date_order DESC"; $result = db_query($query); $count = db_num_rows($result); $rows = array(); for ($i = 0; $i < $count; $i++) { $row = db_fetch_array($result); $row['date_order'] = db_unixtimestamp($row['date_order']); $rows[] = $row; } return $rows; }
function email_collect_recipients($p_bug_id, $p_notify_type) { $c_bug_id = db_prepare_int($p_bug_id); $t_recipients = array(); # add Reporter if (ON == email_notify_flag($p_notify_type, 'reporter')) { $t_reporter_id = bug_get_field($p_bug_id, 'reporter_id'); $t_recipients[$t_reporter_id] = true; log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, add reporter={$t_reporter_id}"); } # add Handler if (ON == email_notify_flag($p_notify_type, 'handler')) { $t_handler_id = bug_get_field($p_bug_id, 'handler_id'); if ($t_handler_id > 0) { $t_recipients[$t_handler_id] = true; log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, add handler={$t_handler_id}"); } } $t_project_id = bug_get_field($p_bug_id, 'project_id'); # add users monitoring the bug $t_bug_monitor_table = config_get('mantis_bug_monitor_table'); if (ON == email_notify_flag($p_notify_type, 'monitor')) { $query = "SELECT DISTINCT user_id\n\t\t\t\t\t FROM {$t_bug_monitor_table}\n\t\t\t\t\t WHERE bug_id={$c_bug_id}"; $result = db_query($query); $count = db_num_rows($result); for ($i = 0; $i < $count; $i++) { $t_user_id = db_result($result, $i); $t_recipients[$t_user_id] = true; log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, add monitor={$t_user_id}"); } } # add users who contributed bugnotes $t_bugnote_id = bugnote_get_latest_id($p_bug_id); $t_bugnote_view = bugnote_get_field($t_bugnote_id, 'view_state'); $t_bugnote_date = db_unixtimestamp(bugnote_get_field($t_bugnote_id, 'last_modified')); $t_bug_date = bug_get_field($p_bug_id, 'last_updated'); $t_bugnote_table = config_get('mantis_bugnote_table'); if (ON == email_notify_flag($p_notify_type, 'bugnotes')) { $query = "SELECT DISTINCT reporter_id\n\t\t\t\t\t FROM {$t_bugnote_table}\n\t\t\t\t\t WHERE bug_id = {$c_bug_id}"; $result = db_query($query); $count = db_num_rows($result); for ($i = 0; $i < $count; $i++) { $t_user_id = db_result($result, $i); $t_recipients[$t_user_id] = true; log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, add note author={$t_user_id}"); } } # add project users who meet the thresholds $t_bug_is_private = bug_get_field($p_bug_id, 'view_state') == VS_PRIVATE; $t_threshold_min = email_notify_flag($p_notify_type, 'threshold_min'); $t_threshold_max = email_notify_flag($p_notify_type, 'threshold_max'); $t_threshold_users = project_get_all_user_rows($t_project_id, $t_threshold_min); foreach ($t_threshold_users as $t_user) { if ($t_user['access_level'] <= $t_threshold_max) { if (!$t_bug_is_private || access_compare_level($t_user['access_level'], config_get('private_bug_threshold'))) { $t_recipients[$t_user['id']] = true; log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, add project user="******"bug={$p_bug_id}, drop {$t_id} (own)"); continue; } # Eliminate users who don't exist anymore or who are disabled if (!user_exists($t_id) || !user_is_enabled($t_id)) { log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, drop {$t_id} (disabled)"); continue; } # Exclude users who have this notification type turned off if ($t_pref_field) { $t_notify = user_pref_get_pref($t_id, $t_pref_field); if (OFF == $t_notify) { log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, drop {$t_id} (pref {$t_pref_field} off)"); continue; } else { # Users can define the severity of an issue before they are emailed for # each type of notification $t_min_sev_pref_field = $t_pref_field . '_min_severity'; $t_min_sev_notify = user_pref_get_pref($t_id, $t_min_sev_pref_field); $t_bug_severity = bug_get_field($p_bug_id, 'severity'); if ($t_bug_severity < $t_min_sev_notify) { log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, drop {$t_id} (pref threshold)"); continue; } } } # check that user can see bugnotes if the last update included a bugnote if ($t_bug_date == $t_bugnote_date) { if (!access_has_bugnote_level(VIEWER, $t_bugnote_id, $t_id)) { log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, drop {$t_id} (access level)"); continue; } } # Finally, let's get their emails, if they've set one $t_email = user_get_email($t_id); if (is_blank($t_email)) { log_event(LOG_EMAIL_RECIPIENT, "bug={$p_bug_id}, drop {$t_id} (no email)"); } else { # @@@ we could check the emails for validity again but I think # it would be too slow $t_final_recipients[$t_id] = $t_email; } } return $t_final_recipients; }
} else { $t_data[$t_ptr][$t_row['status']] = 1; $t_view_status[$t_row['status']] = isset($t_status_arr[$t_row['status']]) ? $t_status_arr[$t_row['status']] : '@' . $t_row['status'] . '@'; } $t_bug[] = $t_row['id']; } // get the history for these bugs over the interval required to offset the data // type = 0 and field=status are status changes // type = 1 are new bugs $t_select = 'SELECT bug_id, type, old_value, new_value, date_modified FROM ' . $t_bug_hist_table . ' WHERE bug_id in (' . implode(',', $t_bug) . ') and ( (type=' . NORMAL_TYPE . ' and field_name=\'status\') or type=' . NEW_BUG . ' ) and date_modified >= \'' . db_date($t_start) . '\'' . ' order by date_modified DESC'; $t_result = db_query($t_select); $t_row = db_fetch_array($t_result); for ($t_now = time() - $t_incr; $t_now >= $t_start; $t_now -= $t_incr) { // walk through the data points and use the data retrieved to update counts while ($t_row !== false && db_unixtimestamp($t_row['date_modified']) >= $t_now) { switch ($t_row['type']) { case 0: // updated bug if (isset($t_data[$t_ptr][$t_row['new_value']])) { if ($t_data[$t_ptr][$t_row['new_value']] > 0) { $t_data[$t_ptr][$t_row['new_value']]--; } } else { $t_data[$t_ptr][$t_row['new_value']] = 0; $t_view_status[$t_row['new_value']] = isset($t_status_arr[$t_row['new_value']]) ? $t_status_arr[$t_row['new_value']] : '@' . $t_row['new_value'] . '@'; } if (isset($t_data[$t_ptr][$t_row['old_value']])) { $t_data[$t_ptr][$t_row['old_value']]++; } else { $t_data[$t_ptr][$t_row['old_value']] = 1;
$query = "SELECT COUNT(*)\r\n\t\t\t\tFROM mantis_bug_table\r\n\t\t\t\tWHERE last_updated<='{$p_date}' AND\r\n\t\t\t\t\tstatus='90' AND\r\n\t\t\t\t\tproject_id='{$t_project_id}'"; $result = db_query($query); return db_result($result, 0, 0); } # -- start -- $t_project_id = helper_get_current_project(); $query = "SELECT status, date_submitted, last_updated\r\n\t\t\tFROM mantis_bug_table\r\n\t\t\tWHERE project_id='{$t_project_id}' AND\r\n\t\t\t\t\tdate_submitted>='{$g_start_date}'\r\n\t\t\tORDER BY date_submitted ASC"; $result = db_query($query); $bug_count = db_num_rows($result); $data_date_arr = array(); while ($row = db_fetch_array($result)) { extract($row); if ($status < 80) { $date_str = date('m/d/Y', db_unixtimestamp($date_submitted)); } else { $date_str = date('m/d/Y', db_unixtimestamp($last_updated)); } $data_date_arr[] = $date_str; } $counter = 0; while ($row = db_fetch_array($result)) { extract($row); } $data_date_arr_temp = array_unique($data_date_arr); $data_date_arr = array(); foreach ($data_date_arr_temp as $key => $val) { $data_date_arr[] = $val; } usort($data_date_arr, 'tmpcmp'); # total up open $data_open_count_arr = array();
html_set_rss_link($t_rss_link); } html_page_top1(); html_page_top2(); if (!current_user_is_anonymous()) { echo '<div class="quick-summary-left">'; echo lang_get('open_and_assigned_to_me') . ': '; echo '<a class="subtle" href="view_all_set.php?type=1&handler_id=' . auth_get_current_user_id() . '&hide_status=' . RESOLVED . '">' . current_user_get_assigned_open_bug_count() . '</a>'; echo '</div>'; echo '<div class="quick-summary-right">'; echo lang_get('open_and_reported_to_me') . ': '; echo '<a class="subtle" href="view_all_set.php?type=1&reporter_id=' . auth_get_current_user_id() . '&hide_status=' . RESOLVED . '">' . current_user_get_reported_open_bug_count() . '</a>'; echo '</div>'; echo '<div class="quick-summary-left">'; echo lang_get('last_visit') . ': '; echo print_date(config_get('normal_date_format'), db_unixtimestamp(current_user_get_field('last_visit'))); echo '</div>'; } echo '<br />'; echo '<br />'; echo '<br />'; $t_news_rows = news_get_limited_rows($f_offset, $t_project_id); $t_news_count = count($t_news_rows); # Loop through results for ($i = 0; $i < $t_news_count; $i++) { $t_row = $t_news_rows[$i]; # only show VS_PRIVATE posts to configured threshold and above if (VS_PRIVATE == $t_row['view_state'] && !access_has_project_level(config_get('private_news_threshold'))) { continue; } print_news_entry_from_row($t_row);
function filter_get_bug_rows(&$p_page_number, &$p_per_page, &$p_page_count, &$p_bug_count, $p_custom_filter = null, $p_project_id = null, $p_user_id = null, $p_show_sticky = null) { log_event(LOG_FILTERING, 'FILTERING: START NEW FILTER QUERY'); $t_bug_table = config_get('mantis_bug_table'); $t_bug_text_table = config_get('mantis_bug_text_table'); $t_bugnote_table = config_get('mantis_bugnote_table'); $t_custom_field_string_table = config_get('mantis_custom_field_string_table'); $t_bugnote_text_table = config_get('mantis_bugnote_text_table'); $t_project_table = config_get('mantis_project_table'); $t_bug_monitor_table = config_get('mantis_bug_monitor_table'); $t_limit_reporters = config_get('limit_reporters'); $t_bug_relationship_table = config_get('mantis_bug_relationship_table'); $t_report_bug_threshold = config_get('report_bug_threshold'); $t_current_user_id = auth_get_current_user_id(); if (null === $p_user_id) { $t_user_id = $t_current_user_id; } else { $t_user_id = $p_user_id; } $c_user_id = db_prepare_int($t_user_id); if (null === $p_project_id) { # @@@ If project_id is not specified, then use the project id(s) in the filter if set, otherwise, use current project. $t_project_id = helper_get_current_project(); } else { $t_project_id = $p_project_id; } if ($p_custom_filter === null) { # Prefer current_user_get_bug_filter() over user_get_filter() when applicable since it supports # cookies set by previous version of the code. if ($t_user_id == $t_current_user_id) { $t_filter = current_user_get_bug_filter(); } else { $t_filter = user_get_bug_filter($t_user_id, $t_project_id); } } else { $t_filter = $p_custom_filter; } $t_filter = filter_ensure_valid_filter($t_filter); if (false === $t_filter) { return false; # signify a need to create a cookie #@@@ error instead? } $t_view_type = $t_filter['_view_type']; $t_where_clauses = array("{$t_project_table}.enabled = 1", "{$t_project_table}.id = {$t_bug_table}.project_id"); $t_select_clauses = array("{$t_bug_table}.*"); $t_join_clauses = array(); $t_from_clauses = array(); // normalize the project filtering into an array $t_project_ids if ('simple' == $t_view_type) { log_event(LOG_FILTERING, 'FILTERING: Simple Filter'); $t_project_ids = array($t_project_id); $t_include_sub_projects = true; } else { log_event(LOG_FILTERING, 'FILTERING: Advanced Filter'); if (!is_array($t_filter['project_id'])) { $t_project_ids = array(db_prepare_int($t_filter['project_id'])); } else { $t_project_ids = array_map('db_prepare_int', $t_filter['project_id']); } $t_include_sub_projects = count($t_project_ids) == 1 && $t_project_ids[0] == META_FILTER_CURRENT; } log_event(LOG_FILTERING, 'FILTERING: project_ids = ' . implode(',', $t_project_ids)); log_event(LOG_FILTERING, 'FILTERING: include sub-projects = ' . ($t_include_sub_projects ? '1' : '0')); // if the array has ALL_PROJECTS, then reset the array to only contain ALL_PROJECTS. // replace META_FILTER_CURRENT with the actualy current project id. $t_all_projects_found = false; $t_new_project_ids = array(); foreach ($t_project_ids as $t_pid) { if ($t_pid == META_FILTER_CURRENT) { $t_pid = $t_project_id; } if ($t_pid == ALL_PROJECTS) { $t_all_projects_found = true; log_event(LOG_FILTERING, 'FILTERING: all projects selected'); break; } // filter out inaccessible projects. if (!access_has_project_level(VIEWER, $t_pid, $t_user_id)) { continue; } $t_new_project_ids[] = $t_pid; } $t_projects_query_required = true; if ($t_all_projects_found) { if (user_is_administrator($t_user_id)) { log_event(LOG_FILTERING, 'FILTERING: all projects + administrator, hence no project filter.'); $t_projects_query_required = false; } else { $t_project_ids = user_get_accessible_projects($t_user_id); } } else { $t_project_ids = $t_new_project_ids; } if ($t_projects_query_required) { // expand project ids to include sub-projects if ($t_include_sub_projects) { $t_top_project_ids = $t_project_ids; foreach ($t_top_project_ids as $t_pid) { log_event(LOG_FILTERING, 'FILTERING: Getting sub-projects for project id ' . $t_pid); $t_project_ids = array_merge($t_project_ids, user_get_all_accessible_subprojects($t_user_id, $t_pid)); } $t_project_ids = array_unique($t_project_ids); } // if no projects are accessible, then return an empty array. if (count($t_project_ids) == 0) { log_event(LOG_FILTERING, 'FILTERING: no accessible projects'); return array(); } log_event(LOG_FILTERING, 'FILTERING: project_ids after including sub-projects = ' . implode(',', $t_project_ids)); // this array is to be populated with project ids for which we only want to show public issues. This is due to the limited // access of the current user. $t_public_only_project_ids = array(); // this array is populated with project ids that the current user has full access to. $t_private_and_public_project_ids = array(); $t_access_required_to_view_private_bugs = config_get('private_bug_threshold'); foreach ($t_project_ids as $t_pid) { if (access_has_project_level($t_access_required_to_view_private_bugs, $t_pid, $t_user_id)) { $t_private_and_public_project_ids[] = $t_pid; } else { $t_public_only_project_ids[] = $t_pid; } } log_event(LOG_FILTERING, 'FILTERING: project_ids (with public/private access) = ' . implode(',', $t_private_and_public_project_ids)); log_event(LOG_FILTERING, 'FILTERING: project_ids (with public access) = ' . implode(',', $t_public_only_project_ids)); $t_count_private_and_public_project_ids = count($t_private_and_public_project_ids); if ($t_count_private_and_public_project_ids == 1) { $t_private_and_public_query = "( {$t_bug_table}.project_id = " . $t_private_and_public_project_ids[0] . " )"; } else { if ($t_count_private_and_public_project_ids > 1) { $t_private_and_public_query = "( {$t_bug_table}.project_id in (" . implode(', ', $t_private_and_public_project_ids) . ") )"; } else { $t_private_and_public_query = null; } } $t_count_public_only_project_ids = count($t_public_only_project_ids); $t_public_view_state_check = "( ( {$t_bug_table}.view_state = " . VS_PUBLIC . " ) OR ( {$t_bug_table}.reporter_id = {$t_user_id} ) )"; if ($t_count_public_only_project_ids == 1) { $t_public_only_query = "( ( {$t_bug_table}.project_id = " . $t_public_only_project_ids[0] . " ) AND {$t_public_view_state_check} )"; } else { if ($t_count_public_only_project_ids > 1) { $t_public_only_query = "( ( {$t_bug_table}.project_id in (" . implode(', ', $t_public_only_project_ids) . ") ) AND {$t_public_view_state_check} )"; } else { $t_public_only_query = null; } } // both queries can't be null, so we either have one of them or both. if ($t_private_and_public_query === null) { $t_project_query = $t_public_only_query; } else { if ($t_public_only_query === null) { $t_project_query = $t_private_and_public_query; } else { $t_project_query = "( {$t_public_only_query} OR {$t_private_and_public_query} )"; } } log_event(LOG_FILTERING, 'FILTERING: project query = ' . $t_project_query); array_push($t_where_clauses, $t_project_query); } # view state $t_view_state = db_prepare_int($t_filter['view_state']); if ($t_filter['view_state'] !== META_FILTER_ANY && !is_blank($t_filter['view_state'])) { $t_view_state_query = "({$t_bug_table}.view_state='{$t_view_state}')"; log_event(LOG_FILTERING, 'FILTERING: view_state query = ' . $t_view_state_query); array_push($t_where_clauses, $t_view_state_query); } else { log_event(LOG_FILTERING, 'FILTERING: no view_state query'); } # reporter $t_any_found = false; foreach ($t_filter['reporter_id'] as $t_filter_member) { if (META_FILTER_ANY === $t_filter_member || 0 === $t_filter_member) { $t_any_found = true; } } if (count($t_filter['reporter_id']) == 0) { $t_any_found = true; } if (!$t_any_found) { $t_clauses = array(); foreach ($t_filter['reporter_id'] as $t_filter_member) { if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, "0"); } else { $c_reporter_id = db_prepare_int($t_filter_member); if (META_FILTER_MYSELF == $c_reporter_id) { array_push($t_clauses, $c_user_id); } else { array_push($t_clauses, $c_reporter_id); } } } if (1 < count($t_clauses)) { $t_reporter_query = "( {$t_bug_table}.reporter_id in (" . implode(', ', $t_clauses) . ") )"; } else { $t_reporter_query = "( {$t_bug_table}.reporter_id={$t_clauses['0']} )"; } log_event(LOG_FILTERING, 'FILTERING: reporter query = ' . $t_reporter_query); array_push($t_where_clauses, $t_reporter_query); } else { log_event(LOG_FILTERING, 'FILTERING: no reporter query'); } # limit reporter # @@@ thraxisp - access_has_project_level checks greater than or equal to, # this assumed that there aren't any holes above REPORTER where the limit would apply # if (ON === $t_limit_reporters && !access_has_project_level(REPORTER + 1, $t_project_id, $t_user_id)) { $c_reporter_id = $c_user_id; array_push($t_where_clauses, "({$t_bug_table}.reporter_id='{$c_reporter_id}')"); } # handler $t_any_found = false; foreach ($t_filter['handler_id'] as $t_filter_member) { if (META_FILTER_ANY === $t_filter_member || 0 === $t_filter_member) { $t_any_found = true; } } if (count($t_filter['handler_id']) == 0) { $t_any_found = true; } if (!$t_any_found) { $t_clauses = array(); foreach ($t_filter['handler_id'] as $t_filter_member) { if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, 0); } else { $c_handler_id = db_prepare_int($t_filter_member); if (META_FILTER_MYSELF == $c_handler_id) { array_push($t_clauses, $c_user_id); } else { array_push($t_clauses, $c_handler_id); } } } if (1 < count($t_clauses)) { $t_handler_query = "( {$t_bug_table}.handler_id in (" . implode(', ', $t_clauses) . ") )"; } else { $t_handler_query = "( {$t_bug_table}.handler_id={$t_clauses['0']} )"; } log_event(LOG_FILTERING, 'FILTERING: handler query = ' . $t_handler_query); array_push($t_where_clauses, $t_handler_query); } else { log_event(LOG_FILTERING, 'FILTERING: no handler query'); } # category if (!_filter_is_any($t_filter['show_category'])) { $t_clauses = array(); foreach ($t_filter['show_category'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, "''"); } else { $c_show_category = db_prepare_string($t_filter_member); array_push($t_clauses, "'{$c_show_category}'"); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.category in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.category={$t_clauses['0']} )"); } } # severity $t_any_found = false; foreach ($t_filter['show_severity'] as $t_filter_member) { if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) { $t_any_found = true; } } if (count($t_filter['show_severity']) == 0) { $t_any_found = true; } if (!$t_any_found) { $t_clauses = array(); foreach ($t_filter['show_severity'] as $t_filter_member) { $c_show_severity = db_prepare_int($t_filter_member); array_push($t_clauses, $c_show_severity); } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.severity in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.severity={$t_clauses['0']} )"); } } # show / hide status # take a list of all available statuses then remove the ones that we want hidden, then make sure # the ones we want shown are still available $t_status_arr = explode_enum_string(config_get('status_enum_string')); $t_available_statuses = array(); $t_desired_statuses = array(); foreach ($t_status_arr as $t_this_status) { $t_this_status_arr = explode_enum_arr($t_this_status); $t_available_statuses[] = $t_this_status_arr[0]; } if ('simple' == $t_filter['_view_type']) { # simple filtering: if showing any, restrict by the hide status value, otherwise ignore the hide $t_any_found = false; $t_this_status = $t_filter['show_status'][0]; $t_this_hide_status = $t_filter['hide_status'][0]; if (META_FILTER_ANY == $t_this_status || is_blank($t_this_status) || 0 === $t_this_status) { $t_any_found = true; } if ($t_any_found) { foreach ($t_available_statuses as $t_this_available_status) { if ($t_this_hide_status > $t_this_available_status) { $t_desired_statuses[] = $t_this_available_status; } } } else { $t_desired_statuses[] = $t_this_status; } } else { # advanced filtering: ignore the hide $t_any_found = false; foreach ($t_filter['show_status'] as $t_this_status) { $t_desired_statuses[] = $t_this_status; if (META_FILTER_ANY == $t_this_status || is_blank($t_this_status) || 0 === $t_this_status) { $t_any_found = true; } } if ($t_any_found) { $t_desired_statuses = array(); } } if (count($t_desired_statuses) > 0) { $t_clauses = array(); foreach ($t_desired_statuses as $t_filter_member) { $c_show_status = db_prepare_int($t_filter_member); array_push($t_clauses, $c_show_status); } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.status in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.status={$t_clauses['0']} )"); } } # resolution $t_any_found = false; foreach ($t_filter['show_resolution'] as $t_filter_member) { if (META_FILTER_ANY == $t_filter_member) { $t_any_found = true; } } if (count($t_filter['show_resolution']) == 0) { $t_any_found = true; } if (!$t_any_found) { $t_clauses = array(); foreach ($t_filter['show_resolution'] as $t_filter_member) { $c_show_resolution = db_prepare_int($t_filter_member); array_push($t_clauses, $c_show_resolution); } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.resolution in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.resolution={$t_clauses['0']} )"); } } # priority $t_any_found = false; foreach ($t_filter['show_priority'] as $t_filter_member) { if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) { $t_any_found = true; } } if (count($t_filter['show_priority']) == 0) { $t_any_found = true; } if (!$t_any_found) { $t_clauses = array(); foreach ($t_filter['show_priority'] as $t_filter_member) { $c_show_priority = db_prepare_int($t_filter_member); array_push($t_clauses, $c_show_priority); } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.priority in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.priority={$t_clauses['0']} )"); } } # product build $t_any_found = false; foreach ($t_filter['show_build'] as $t_filter_member) { if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) { $t_any_found = true; } } if (count($t_filter['show_build']) == 0) { $t_any_found = true; } if (!$t_any_found) { $t_clauses = array(); foreach ($t_filter['show_build'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, "''"); } else { $c_show_build = db_prepare_string($t_filter_member); array_push($t_clauses, "'{$c_show_build}'"); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.build in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.build={$t_clauses['0']} )"); } } # product version if (!_filter_is_any($t_filter['show_version'])) { $t_clauses = array(); foreach ($t_filter['show_version'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, "''"); } else { $c_show_version = db_prepare_string($t_filter_member); array_push($t_clauses, "'{$c_show_version}'"); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.version in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.version={$t_clauses['0']} )"); } } # profile if (!_filter_is_any($t_filter['show_profile'])) { $t_clauses = array(); foreach ($t_filter['show_profile'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, "0"); } else { $c_show_profile = db_prepare_int($t_filter_member); array_push($t_clauses, "{$c_show_profile}"); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.profile_id in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.profile_id={$t_clauses['0']} )"); } } # platform if (!_filter_is_any($t_filter['platform'])) { $t_clauses = array(); foreach ($t_filter['platform'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, ''); } else { $c_platform = db_prepare_string($t_filter_member); array_push($t_clauses, "'{$c_platform}'"); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.platform in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.platform = {$t_clauses['0']} )"); } } # os if (!_filter_is_any($t_filter['os'])) { $t_clauses = array(); foreach ($t_filter['os'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, ''); } else { $c_os = db_prepare_string($t_filter_member); array_push($t_clauses, "'{$c_os}'"); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.os in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.os = {$t_clauses['0']} )"); } } # os_build if (!_filter_is_any($t_filter['os_build'])) { $t_clauses = array(); foreach ($t_filter['os_build'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, ''); } else { $c_os_build = db_prepare_string($t_filter_member); array_push($t_clauses, "'{$c_os_build}'"); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.os_build in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.os_build = {$t_clauses['0']} )"); } } # date filter if ('on' == $t_filter['do_filter_by_date'] && is_numeric($t_filter['start_month']) && is_numeric($t_filter['start_day']) && is_numeric($t_filter['start_year']) && is_numeric($t_filter['end_month']) && is_numeric($t_filter['end_day']) && is_numeric($t_filter['end_year'])) { $t_start_string = db_prepare_string($t_filter['start_year'] . "-" . $t_filter['start_month'] . "-" . $t_filter['start_day'] . " 00:00:00"); $t_end_string = db_prepare_string($t_filter['end_year'] . "-" . $t_filter['end_month'] . "-" . $t_filter['end_day'] . " 23:59:59"); array_push($t_where_clauses, "({$t_bug_table}.date_submitted BETWEEN '{$t_start_string}' AND '{$t_end_string}' )"); } # fixed in version if (!_filter_is_any($t_filter['fixed_in_version'])) { $t_clauses = array(); foreach ($t_filter['fixed_in_version'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, "''"); } else { $c_fixed_in_version = db_prepare_string($t_filter_member); array_push($t_clauses, "'{$c_fixed_in_version}'"); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.fixed_in_version in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.fixed_in_version={$t_clauses['0']} )"); } } # target version if (!_filter_is_any($t_filter['target_version'])) { $t_clauses = array(); foreach ($t_filter['target_version'] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { array_push($t_clauses, "''"); } else { $c_target_version = db_prepare_string($t_filter_member); array_push($t_clauses, "'{$c_target_version}'"); } } #echo var_dump( $t_clauses ); exit; if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_bug_table}.target_version in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_bug_table}.target_version={$t_clauses['0']} )"); } } # users monitoring a bug $t_any_found = false; foreach ($t_filter['user_monitor'] as $t_filter_member) { if (META_FILTER_ANY == $t_filter_member || 0 === $t_filter_member) { $t_any_found = true; } } if (count($t_filter['user_monitor']) == 0) { $t_any_found = true; } if (!$t_any_found) { $t_clauses = array(); $t_table_name = 'user_monitor'; array_push($t_from_clauses, $t_bug_monitor_table); array_push($t_join_clauses, "LEFT JOIN {$t_bug_monitor_table} {$t_table_name} ON {$t_table_name}.bug_id = {$t_bug_table}.id"); foreach ($t_filter['user_monitor'] as $t_filter_member) { $c_user_monitor = db_prepare_int($t_filter_member); if (META_FILTER_MYSELF == $c_user_monitor) { array_push($t_clauses, $c_user_id); } else { array_push($t_clauses, $c_user_monitor); } } if (1 < count($t_clauses)) { array_push($t_where_clauses, "( {$t_table_name}.user_id in (" . implode(', ', $t_clauses) . ") )"); } else { array_push($t_where_clauses, "( {$t_table_name}.user_id={$t_clauses['0']} )"); } } # bug relationship $t_any_found = false; $c_rel_type = $t_filter['relationship_type']; $c_rel_bug = $t_filter['relationship_bug']; if (-1 == $c_rel_type || 0 == $c_rel_bug) { $t_any_found = true; } if (!$t_any_found) { # use the complementary type $t_comp_type = relationship_get_complementary_type($c_rel_type); $t_clauses = array(); $t_table_name = 'relationship'; array_push($t_from_clauses, $t_bug_relationship_table); array_push($t_join_clauses, "LEFT JOIN {$t_bug_relationship_table} {$t_table_name} ON {$t_table_name}.destination_bug_id = {$t_bug_table}.id"); array_push($t_join_clauses, "LEFT JOIN {$t_bug_relationship_table} {$t_table_name}2 ON {$t_table_name}2.source_bug_id = {$t_bug_table}.id"); // get reverse relationships array_push($t_clauses, "({$t_table_name}.relationship_type='{$t_comp_type}' AND {$t_table_name}.source_bug_id='{$c_rel_bug}')"); array_push($t_clauses, "({$t_table_name}" . "2.relationship_type='{$c_rel_type}' AND {$t_table_name}" . "2.destination_bug_id='{$c_rel_bug}')"); array_push($t_where_clauses, '(' . implode(' OR ', $t_clauses) . ')'); } # tags $c_tag_string = trim($t_filter['tag_string']); if (!is_blank($c_tag_string)) { $t_tags = tag_parse_filters($c_tag_string); if (count($t_tags)) { $t_tags_all = array(); $t_tags_any = array(); $t_tags_none = array(); foreach ($t_tags as $t_tag_row) { switch ($t_tag_row['filter']) { case 1: $t_tags_all[] = $t_tag_row; break; case 0: $t_tags_any[] = $t_tag_row; break; case -1: $t_tags_none[] = $t_tag_row; break; } } if (0 < $t_filter['tag_select'] && tag_exists($t_filter['tag_select'])) { $t_tags_any[] = tag_get($t_filter['tag_select']); } $t_bug_tag_table = config_get('mantis_bug_tag_table'); if (count($t_tags_all)) { $t_clauses = array(); foreach ($t_tags_all as $t_tag_row) { array_push($t_clauses, "{$t_bug_table}.id IN ( SELECT bug_id FROM {$t_bug_tag_table} WHERE {$t_bug_tag_table}.tag_id = {$t_tag_row['id']} )"); } array_push($t_where_clauses, '(' . implode(' AND ', $t_clauses) . ')'); } if (count($t_tags_any)) { $t_clauses = array(); foreach ($t_tags_any as $t_tag_row) { array_push($t_clauses, "{$t_bug_tag_table}.tag_id = {$t_tag_row['id']}"); } array_push($t_where_clauses, "{$t_bug_table}.id IN ( SELECT bug_id FROM {$t_bug_tag_table} WHERE ( " . implode(' OR ', $t_clauses) . ') )'); } if (count($t_tags_none)) { $t_clauses = array(); foreach ($t_tags_none as $t_tag_row) { array_push($t_clauses, "{$t_bug_tag_table}.tag_id = {$t_tag_row['id']}"); } array_push($t_where_clauses, "{$t_bug_table}.id NOT IN ( SELECT bug_id FROM {$t_bug_tag_table} WHERE ( " . implode(' OR ', $t_clauses) . ') )'); } } } # custom field filters if (ON == config_get('filter_by_custom_fields')) { # custom field filtering # @@@ At the moment this gets the linked fields relating to the current project # It should get the ones relating to the project in the filter or all projects # if multiple projects. $t_custom_fields = custom_field_get_linked_ids($t_project_id); foreach ($t_custom_fields as $t_cfid) { $t_custom_where_clause = ''; # Ignore all custom filters that are not set, or that are set to '' or "any" $t_any_found = false; foreach ($t_filter['custom_fields'][$t_cfid] as $t_filter_member) { if (META_FILTER_ANY == $t_filter_member && is_numeric($t_filter_member)) { $t_any_found = true; } } if (!isset($t_filter['custom_fields'][$t_cfid])) { $t_any_found = true; } if (!$t_any_found) { $t_def = custom_field_get_definition($t_cfid); $t_table_name = $t_custom_field_string_table . '_' . $t_cfid; # We need to filter each joined table or the result query will explode in dimensions # Each custom field will result in a exponential growth like Number_of_Issues^Number_of_Custom_Fields # and only after this process ends (if it is able to) the result query will be filtered # by the WHERE clause and by the DISTINCT clause $t_cf_join_clause = "LEFT JOIN {$t_custom_field_string_table} {$t_table_name} ON {$t_table_name}.bug_id = {$t_bug_table}.id AND {$t_table_name}.field_id = {$t_cfid} "; if ($t_def['type'] == CUSTOM_FIELD_TYPE_DATE) { switch ($t_filter['custom_fields'][$t_cfid][0]) { case CUSTOM_FIELD_DATE_ANY: break; case CUSTOM_FIELD_DATE_NONE: array_push($t_join_clauses, $t_cf_join_clause); $t_custom_where_clause = '(( ' . $t_table_name . '.bug_id is null) OR ( ' . $t_table_name . '.value = 0)'; break; case CUSTOM_FIELD_DATE_BEFORE: array_push($t_join_clauses, $t_cf_join_clause); $t_custom_where_clause = '(( ' . $t_table_name . '.value != 0 AND (' . $t_table_name . '.value+0) < ' . $t_filter['custom_fields'][$t_cfid][2] . ')'; break; case CUSTOM_FIELD_DATE_AFTER: array_push($t_join_clauses, $t_cf_join_clause); $t_custom_where_clause = '( (' . $t_table_name . '.value+0) > ' . ($t_filter['custom_fields'][$t_cfid][1] + 1); break; default: array_push($t_join_clauses, $t_cf_join_clause); $t_custom_where_clause = '( (' . $t_table_name . '.value+0) BETWEEN ' . $t_filter['custom_fields'][$t_cfid][1] . ' AND ' . $t_filter['custom_fields'][$t_cfid][2]; break; } } else { array_push($t_join_clauses, $t_cf_join_clause); $t_filter_array = array(); foreach ($t_filter['custom_fields'][$t_cfid] as $t_filter_member) { $t_filter_member = stripslashes($t_filter_member); if (META_FILTER_NONE == $t_filter_member) { # coerce filter value if selecting META_FILTER_NONE so it will match empty fields $t_filter_member = ''; # but also add those _not_ present in the custom field string table array_push($t_filter_array, "{$t_bug_table}.id NOT IN (SELECT bug_id FROM {$t_custom_field_string_table} WHERE field_id={$t_cfid})"); } switch ($t_def['type']) { case CUSTOM_FIELD_TYPE_MULTILIST: case CUSTOM_FIELD_TYPE_CHECKBOX: array_push($t_filter_array, db_helper_like("{$t_table_name}.value", '%|' . db_prepare_string($t_filter_member) . '|%')); break; default: array_push($t_filter_array, "{$t_table_name}.value = '" . db_prepare_string($t_filter_member) . "'"); } } $t_custom_where_clause .= '(' . implode(' OR ', $t_filter_array); } if (!is_blank($t_custom_where_clause)) { array_push($t_where_clauses, $t_custom_where_clause . ')'); } } } } $t_textsearch_where_clause = ''; $t_textsearch_wherejoin_clause = ''; # Simple Text Search - Thanks to Alan Knowles if (!is_blank($t_filter['search'])) { $c_search = db_prepare_string($t_filter['search']); $c_search_int = db_prepare_int($t_filter['search']); $t_textsearch_where_clause = '(' . db_helper_like('summary', "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.description", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.steps_to_reproduce", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.additional_information", "%{$c_search}%") . " OR ( {$t_bug_table}.id = '{$c_search_int}' ) )"; $t_textsearch_wherejoin_clause = '(' . db_helper_like('summary', "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.description", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.steps_to_reproduce", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_text_table}.additional_information", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bug_table}.id", "%{$c_search}%") . ' OR ' . db_helper_like("{$t_bugnote_text_table}.note", "%{$c_search}%") . ' )'; array_push($t_where_clauses, "({$t_bug_text_table}.id = {$t_bug_table}.bug_text_id)"); $t_from_clauses = array($t_bug_text_table, $t_project_table, $t_bug_table); } else { $t_from_clauses = array($t_project_table, $t_bug_table); } $t_select = implode(', ', array_unique($t_select_clauses)); $t_from = 'FROM ' . implode(', ', array_unique($t_from_clauses)); $t_join = implode(' ', $t_join_clauses); if (count($t_where_clauses) > 0) { $t_where = 'WHERE ' . implode(' AND ', $t_where_clauses); } else { $t_where = ''; } # Possibly do two passes. First time, grab the IDs of issues that match the filters. Second time, grab the IDs of issues that # have bugnotes that match the text search if necessary. $t_id_array = array(); for ($i = 0; $i < 2; $i++) { $t_id_where = $t_where; $t_id_join = $t_join; if ($i == 0) { if (!is_blank($t_id_where) && !is_blank($t_textsearch_where_clause)) { $t_id_where = $t_id_where . ' AND ' . $t_textsearch_where_clause; } } else { if (!is_blank($t_textsearch_wherejoin_clause)) { $t_id_where = $t_id_where . ' AND ' . $t_textsearch_wherejoin_clause; $t_id_join = $t_id_join . " INNER JOIN {$t_bugnote_table} ON {$t_bugnote_table}.bug_id = {$t_bug_table}.id"; $t_id_join = $t_id_join . " INNER JOIN {$t_bugnote_text_table} ON {$t_bugnote_text_table}.id = {$t_bugnote_table}.bugnote_text_id"; } } $query = "SELECT DISTINCT {$t_bug_table}.id AS id\r\n\t\t\t\t\t\t{$t_from}\r\n\t\t\t\t\t\t{$t_id_join}\r\n\t\t\t\t\t\t{$t_id_where}"; if ($i == 0 || !is_blank($t_textsearch_wherejoin_clause)) { $result = db_query($query); $row_count = db_num_rows($result); for ($j = 0; $j < $row_count; $j++) { $row = db_fetch_array($result); $t_id_array[] = db_prepare_int($row['id']); } } } $t_id_array = array_unique($t_id_array); # Get the total number of bugs that meet the criteria. $bug_count = count($t_id_array); $rows = array(); if ($bug_count > 0) { $t_where = "WHERE {$t_bug_table}.id in (" . implode(", ", $t_id_array) . ")"; } else { return $rows; } $t_from = 'FROM ' . $t_bug_table; # write the value back in case the caller wants to know $p_bug_count = $bug_count; if (null === $p_per_page) { $p_per_page = (int) $t_filter['per_page']; } else { if (-1 == $p_per_page) { $p_per_page = $bug_count; } } # Guard against silly values of $f_per_page. if (0 == $p_per_page) { $p_per_page = $bug_count; // 0 - means show all } $p_per_page = (int) abs($p_per_page); # Use $bug_count and $p_per_page to determine how many pages # to split this list up into. # For the sake of consistency have at least one page, even if it # is empty. $t_page_count = ceil($bug_count / $p_per_page); if ($t_page_count < 1) { $t_page_count = 1; } # write the value back in case the caller wants to know $p_page_count = $t_page_count; # Make sure $p_page_number isn't past the last page. if ($p_page_number > $t_page_count) { $p_page_number = $t_page_count; } # Make sure $p_page_number isn't before the first page if ($p_page_number < 1) { $p_page_number = 1; } # Now add the rest of the criteria i.e. sorting, limit. # if sort is blank then default the sort and direction. This is to fix the # symptoms of #3953. Note that even if the main problem is fixed, we may # have to keep this code for a while to handle filters saved with this blank field. if (is_blank($t_filter['sort'])) { $t_filter['sort'] = 'last_updated'; $t_filter['dir'] = 'DESC'; } $t_order_array = array(); $t_sort_fields = split(',', $t_filter['sort']); $t_dir_fields = split(',', $t_filter['dir']); if ('on' == $t_filter['sticky_issues'] && NULL !== $p_show_sticky) { $t_order_array[] = "sticky DESC"; } $t_join = ''; for ($i = 0; $i < count($t_sort_fields); $i++) { $c_sort = db_prepare_string($t_sort_fields[$i]); if (!in_array($t_sort_fields[$i], array_slice($t_sort_fields, $i + 1))) { # if sorting by a custom field if (strpos($c_sort, 'custom_') === 0) { $t_custom_field = substr($c_sort, strlen('custom_')); $t_custom_field_id = custom_field_get_id_from_name($t_custom_field); $t_join .= " LEFT JOIN {$t_custom_field_string_table} ON ( ( {$t_custom_field_string_table}.bug_id = {$t_bug_table}.id ) AND ( {$t_custom_field_string_table}.field_id = {$t_custom_field_id} ) )"; $c_sort = "{$t_custom_field_string_table}.value"; $t_select_clauses[] = "{$t_custom_field_string_table}.value"; } if ('DESC' == $t_dir_fields[$i]) { $c_dir = 'DESC'; } else { $c_dir = 'ASC'; } $t_order_array[] = "{$c_sort} {$c_dir}"; } } # add basic sorting if necessary if (!in_array('last_updated', $t_sort_fields)) { $t_order_array[] = 'last_updated DESC'; } if (!in_array('date_submitted', $t_sort_fields)) { $t_order_array[] = 'date_submitted DESC'; } $t_order = " ORDER BY " . implode(', ', $t_order_array); $t_select = implode(', ', array_unique($t_select_clauses)); $query2 = "SELECT DISTINCT {$t_select}\r\n\t\t\t\t\t{$t_from}\r\n\t\t\t\t\t{$t_join}\r\n\t\t\t\t\t{$t_where}\r\n\t\t\t\t\t{$t_order}"; # Figure out the offset into the db query # # for example page number 1, per page 5: # t_offset = 0 # for example page number 2, per page 5: # t_offset = 5 $c_per_page = db_prepare_int($p_per_page); $c_page_number = db_prepare_int($p_page_number); $t_offset = ($c_page_number - 1) * $c_per_page; # perform query $result2 = db_query($query2, $c_per_page, $t_offset); $row_count = db_num_rows($result2); $t_id_array_lastmod = array(); for ($i = 0; $i < $row_count; $i++) { $row = db_fetch_array($result2); $t_id_array_lastmod[] = db_prepare_int($row['id']); $row['date_submitted'] = db_unixtimestamp($row['date_submitted']); $row['last_updated'] = db_unixtimestamp($row['last_updated']); array_push($rows, $row); } $t_id_array_lastmod = array_unique($t_id_array_lastmod); // paulr: it should be impossible for t_id_array_lastmod to be array(): // that would imply that $t_id_array is null which aborts this function early //if ( count( $t_id_array_lastmod ) > 0 ) { $t_where = "WHERE {$t_bugnote_table}.bug_id in (" . implode(", ", $t_id_array_lastmod) . ")"; $query3 = "SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM {$t_bugnote_table} {$t_where} GROUP BY bug_id"; # perform query $result3 = db_query($query3); $row_count = db_num_rows($result3); for ($i = 0; $i < $row_count; $i++) { $row = db_fetch_array($result3); $t_stats[$row['bug_id']] = $row; } foreach ($rows as $row) { if (!isset($t_stats[$row['id']])) { bug_cache_database_result($row, false); } else { bug_cache_database_result($row, $t_stats[$row['id']]); } } return $rows; }
} else { $t_restriction = ''; } $t_bugnote_table = config_get('mantis_bugnote_table'); $t_bugnote_text_table = config_get('mantis_bugnote_text_table'); $t_bugnote_order = current_user_get_pref('bugnote_order'); $query6 = "SELECT *\r\n\t\t\t\tFROM {$t_bugnote_table}\r\n\t\t\t\tWHERE bug_id='{$v_id}' {$t_restriction}\r\n\t\t\t\tORDER BY date_submitted {$t_bugnote_order}"; $result6 = db_query($query6); $num_notes = db_num_rows($result6); # save the index, and use an own bugnote_index $bugnote_index = $name_index; for ($k = 0; $k < $num_notes; $k++) { # prefix all bugnote data with v3_ $row = db_fetch_array($result6); extract($row, EXTR_PREFIX_ALL, 'v3'); $v3_date_submitted = date(config_get('normal_date_format'), db_unixtimestamp($v3_date_submitted)); # grab the bugnote text and id and prefix with v3_ $query6 = "SELECT note, id\r\n\t\t\t\t\tFROM {$t_bugnote_text_table}\r\n\t\t\t\t\tWHERE id='{$v3_bugnote_text_id}'"; $result7 = db_query($query6); $v3_note = db_result($result7, 0, 0); $v3_bugnote_text_id = db_result($result7, 0, 1); $t_note = ''; switch ($v3_note_type) { case REMINDER: $t_note .= lang_get('reminder_sent_to') . ': '; $v3_note_attr = substr($v3_note_attr, 1, strlen($v3_note_attr) - 2); $t_to = array(); foreach (explode('|', $v3_note_attr) as $t_recipient) { $t_to[] = prepare_user_name($t_recipient); } $t_note .= implode(', ', $t_to) . '|';
function history_get_raw_events_array($p_bug_id, $p_user_id = null) { $t_mantis_bug_history_table = config_get('mantis_bug_history_table'); $t_mantis_user_table = config_get('mantis_user_table'); $t_history_order = config_get('history_order'); $c_bug_id = db_prepare_int($p_bug_id); $t_user_id = null === $p_user_id ? auth_get_current_user_id() : $p_user_id; $t_roadmap_view_access_level = config_get('roadmap_view_threshold'); # grab history and display by date_modified then field_name # @@@ by MASC I guess it's better by id then by field_name. When we have more history lines with the same # date, it's better to respect the storing order otherwise we should risk to mix different information # I give you an example. We create a child of a bug with different custom fields. In the history of the child # bug we will find the line related to the relationship mixed with the custom fields (the history is creted # for the new bug with the same timestamp...) $query = "SELECT *\n\t\t\t\tFROM {$t_mantis_bug_history_table}\n\t\t\t\tWHERE bug_id='{$c_bug_id}'\n\t\t\t\tORDER BY date_modified {$t_history_order},id"; $result = db_query($query); $raw_history_count = db_num_rows($result); $raw_history = array(); $t_private_bugnote_threshold = config_get('private_bugnote_threshold'); $t_private_bugnote_visible = access_has_bug_level(config_get('private_bugnote_threshold'), $p_bug_id, $t_user_id); for ($i = 0, $j = 0; $i < $raw_history_count; ++$i) { $row = db_fetch_array($result); extract($row, EXTR_PREFIX_ALL, 'v'); // check that the item should be visible to the user // custom fields - we are passing 32 here to notify the API that the custom field name is truncated by the history column from 64 to 32 characters. $t_field_id = custom_field_get_id_from_name($v_field_name, 32); if (false !== $t_field_id && !custom_field_has_read_access($t_field_id, $p_bug_id, $t_user_id)) { continue; } if ($v_field_name == 'target_version' && !access_has_bug_level($t_roadmap_view_access_level, $p_bug_id, $t_user_id)) { continue; } // bugnotes if ($t_user_id != $v_user_id) { // bypass if user originated note if ($v_type == BUGNOTE_ADDED || $v_type == BUGNOTE_UPDATED || $v_type == BUGNOTE_DELETED) { if (!$t_private_bugnote_visible && bugnote_get_field($v_old_value, 'view_state') == VS_PRIVATE) { continue; } } if ($v_type == BUGNOTE_STATE_CHANGED) { if (!$t_private_bugnote_visible && bugnote_get_field($v_new_value, 'view_state') == VS_PRIVATE) { continue; } } } // tags if ($v_type == TAG_ATTACHED || $v_type == TAG_DETACHED || $v_type == TAG_RENAMED) { if (!access_has_global_level(config_get('tag_view_threshold'))) { continue; } } $raw_history[$j]['date'] = db_unixtimestamp($v_date_modified); $raw_history[$j]['userid'] = $v_user_id; # user_get_name handles deleted users, and username vs realname $raw_history[$j]['username'] = user_get_name($v_user_id); $raw_history[$j]['field'] = $v_field_name; $raw_history[$j]['type'] = $v_type; $raw_history[$j]['old_value'] = $v_old_value; $raw_history[$j]['new_value'] = $v_new_value; $j++; } # end for loop return $raw_history; }
<td> <?php print_manage_user_sort_link('manage_user_page.php', lang_get('last_visit'), 'last_visit', $c_dir, $c_sort, $c_hide); ?> <?php print_sort_icon($c_dir, $c_sort, 'last_visit'); ?> </td> </tr> <?php for ($i = 0; $i < $user_count; $i++) { # prefix user data with u_ $row = db_fetch_array($result); extract($row, EXTR_PREFIX_ALL, 'u'); $u_date_created = date(config_get('normal_date_format'), db_unixtimestamp($u_date_created)); $u_last_visit = date(config_get('normal_date_format'), db_unixtimestamp($u_last_visit)); ?> <tr <?php echo helper_alternate_class($i); ?> > <td> <a href="manage_user_edit_page.php?user_id=<?php echo $u_id; ?> "><?php echo string_display($u_username); ?> </a> </td> <td><?php
echo get_enum_element('severity', $v_severity); ?> </td> <td class="print"> <?php echo get_enum_element('reproducibility', $v_reproducibility); ?> </td> <td class="print"> <?php print_date(config_get('normal_date_format'), db_unixtimestamp($v_date_submitted)); ?> </td> <td class="print"> <?php print_date(config_get('normal_date_format'), db_unixtimestamp($v_last_updated)); ?> </td> </tr> <tr> <td class="print-spacer" colspan="6"> <hr size="1" /> </td> </tr> <tr class="print"> <td class="print-category"> <?php echo lang_get('reporter'); ?> : </td>
/** * Get the attachments that belong to the specified project. * * @param string $p_username The name of the user trying to access the versions. * @param string $p_password The password of the user. * @param integer $p_project_id The id of the project to retrieve the attachments for. * @return Array representing a ProjectAttachmentDataArray structure. */ function mc_project_get_attachments($p_username, $p_password, $p_project_id) { $t_user_id = mci_check_login($p_username, $p_password); if ($t_user_id === false) { return new soap_fault('Client', '', 'Access Denied'); } # Check if project documentation feature is enabled. if (OFF == config_get('enable_project_documentation') || !file_is_uploading_enabled()) { return new soap_fault('Client', '', 'Access Denied'); } if (!project_exists($p_project_id)) { return new soap_fault('Client', '', "Project '{$p_project_id}' does not exist."); } if (!mci_has_readonly_access($t_user_id, $p_project_id)) { return new soap_fault('Client', '', 'Access Denied'); } $t_project_file_table = config_get('mantis_project_file_table'); $t_project_table = config_get('mantis_project_table'); $t_project_user_list_table = config_get('mantis_project_user_list_table'); $t_user_table = config_get('mantis_user_table'); $t_pub = VS_PUBLIC; $t_priv = VS_PRIVATE; $t_admin = ADMINISTRATOR; if ($p_project_id == ALL_PROJECTS) { # Select all the projects that the user has access to $t_projects = user_get_accessible_projects($t_user_id); } else { # Select the specific project $t_projects = array($p_project_id); } $t_projects[] = ALL_PROJECTS; # add ALL_PROJECTS to the list of projects to fetch $t_reqd_access = config_get('view_proj_doc_threshold'); if (is_array($t_reqd_access)) { if (1 == count($t_reqd_access)) { $t_access_clause = "= " . array_shift($t_reqd_access) . " "; } else { $t_access_clause = "IN (" . implode(',', $t_reqd_access) . ")"; } } else { $t_access_clause = ">= {$t_reqd_access} "; } $query = "SELECT pft.id, pft.project_id, pft.filename, pft.file_type, pft.filesize, pft.title, pft.description, pft.date_added\r\n\t\t\t\t\tFROM {$t_project_file_table} pft\r\n\t\t\t\t\t\tLEFT JOIN {$t_project_table} pt ON pft.project_id = pt.id\r\n\t\t\t\t\t\tLEFT JOIN {$t_project_user_list_table} pult \r\n\t\t\t\t\t\t\tON pft.project_id = pult.project_id AND pult.user_id = {$t_user_id}\r\n\t\t\t\t\t\tLEFT JOIN {$t_user_table} ut ON ut.id = {$t_user_id}\r\n\t\t\t\t\tWHERE pft.project_id in (" . implode(',', $t_projects) . ") AND\r\n\t\t\t\t\t\t( ( ( pt.view_state = {$t_pub} OR pt.view_state is null ) AND pult.user_id is null AND ut.access_level {$t_access_clause} ) OR\r\n\t\t\t\t\t\t\t( ( pult.user_id = {$t_user_id} ) AND ( pult.access_level {$t_access_clause} ) ) OR\r\n\t\t\t\t\t\t\t( ut.access_level = {$t_admin} ) )\r\n\t\t\t\t\tORDER BY pt.name ASC, pft.title ASC"; $result = db_query($query); $num_files = db_num_rows($result); $t_result = array(); for ($i = 0; $i < $num_files; $i++) { $row = db_fetch_array($result); extract($row, EXTR_PREFIX_ALL, 'v'); $t_attachment = array(); $t_attachment['id'] = $v_id; $t_attachment['filename'] = $v_filename; $t_attachment['title'] = $v_title; $t_attachment['description'] = $v_description; $t_attachment['size'] = $v_filesize; $t_attachment['content_type'] = $v_file_type; $t_attachment['date_submitted'] = timestamp_to_iso8601(db_unixtimestamp($v_date_added)); $t_attachment['download_url'] = mci_get_mantis_path() . 'file_download.php?file_id=' . $v_id . '&type=doc'; $t_result[] = $t_attachment; } return $t_result; }
/** * Migrate the legacy date format. * @param array $p_data Array: [0] = tablename, [1] id column, [2] = old column, [3] = new column. * @return integer */ function install_date_migrate(array $p_data) { # $p_data[0] = tablename, [1] id column, [2] = old column, [3] = new column # Disable query logging even if enabled in config, due to possibility of mass spam $t_log_queries = install_set_log_queries(); $t_table = $p_data[0]; $t_id_column = $p_data[1]; $t_date_array = is_array($p_data[2]); if ($t_date_array) { $t_old_column = implode(',', $p_data[2]); $t_cnt_fields = count($p_data[2]); $t_query = 'SELECT ' . $t_id_column . ', ' . $t_old_column . ' FROM ' . $t_table; $t_first_column = true; # In order to handle large databases where we may timeout during the upgrade, we don't # start from the beginning everytime. Here we will only pickup rows where at least one # of the datetime fields wasn't upgraded yet and upgrade them all. foreach ($p_data[3] as $t_new_column_name) { if ($t_first_column) { $t_first_column = false; $t_query .= ' WHERE '; } else { $t_query .= ' OR '; } $t_query .= $t_new_column_name . ' = 1'; } } else { $t_old_column = $p_data[2]; # The check for timestamp being = 1 is to make sure the field wasn't upgraded # already in a previous run - see bug #12601 for more details. $t_new_column_name = $p_data[3]; $t_query = 'SELECT ' . $t_id_column . ', ' . $t_old_column . ' FROM ' . $t_table . ' WHERE ' . $t_new_column_name . ' = 1'; } $t_result = db_query($t_query); if (db_num_rows($t_result) > 0) { # Build the update query if ($t_date_array) { $t_pairs = array(); foreach ($p_data[3] as $t_var) { array_push($t_pairs, $t_var . '=' . db_param()); } $t_new_column = implode(',', $t_pairs); } else { $t_new_column = $p_data[3] . '=' . db_param(); } $t_query = 'UPDATE ' . $t_table . ' SET ' . $t_new_column . ' WHERE ' . $t_id_column . '=' . db_param(); while ($t_row = db_fetch_array($t_result)) { $t_id = (int) $t_row[$t_id_column]; if ($t_date_array) { for ($i = 0; $i < $t_cnt_fields; $i++) { $t_old_value = $t_row[$p_data[2][$i]]; if (is_numeric($t_old_value)) { return 1; # Fatal: conversion may have already been run. If it has been run, proceeding will wipe timestamps from db } $t_new_value[$i] = db_unixtimestamp($t_old_value); if ($t_new_value[$i] < 100000) { $t_new_value[$i] = 1; } } $t_values = $t_new_value; $t_values[] = $t_id; } else { $t_old_value = $t_row[$t_old_column]; if (is_numeric($t_old_value)) { return 1; # Fatal: conversion may have already been run. If it has been run, proceeding will wipe timestamps from db } $t_new_value = db_unixtimestamp($t_old_value); if ($t_new_value < 100000) { $t_new_value = 1; } $t_values = array($t_new_value, $t_id); } db_query($t_query, $t_values); } } # Re-enable query logging if we disabled it install_set_log_queries($t_log_queries); # return 2 because that's what ADOdb/DataDict does when things happen properly return 2; }
} else { echo '<select ', helper_get_tab_index(), ' name="user_id">'; print_user_option_list($t_tag_row['user_id'], ALL_PROJECTS, config_get('tag_create_threshold')); echo '</select>'; } } else { echo user_get_name($t_tag_row['user_id']); } ?> </td> <td><?php echo print_date(config_get('normal_date_format'), db_unixtimestamp($t_tag_row['date_created'])); ?> </td> <td><?php echo print_date(config_get('normal_date_format'), db_unixtimestamp($t_tag_row['date_updated'])); ?> </td> </tr> <!-- spacer --> <tr class="spacer"> <td colspan="5"></td> </tr> <!-- Description --> <tr <?php echo helper_alternate_class(); ?> > <td class="category"><?php
function file_list_attachments($p_bug_id) { $t_attachment_rows = bug_get_attachments($p_bug_id); $num_files = sizeof($t_attachment_rows); if ($num_files === 0) { return; } $t_can_download = file_can_download_bug_attachments($p_bug_id); $t_can_delete = file_can_delete_bug_attachments($p_bug_id); $image_previewed = false; for ($i = 0; $i < $num_files; $i++) { $row = $t_attachment_rows[$i]; extract($row, EXTR_PREFIX_ALL, 'v'); $t_file_display_name = file_get_display_name($v_filename); $t_filesize = number_format($v_filesize); $t_date_added = date(config_get('normal_date_format'), db_unixtimestamp($v_date_added)); if ($image_previewed) { $image_previewed = false; print '<br />'; } if ($t_can_download) { $t_href_start = "<a href=\"file_download.php?file_id={$v_id}&type=bug\">"; $t_href_end = '</a>'; $t_href_clicket = " [<a href=\"file_download.php?file_id={$v_id}&type=bug\" target=\"_blank\">^</a>]"; } else { $t_href_start = ''; $t_href_end = ''; $t_href_clicket = ''; } print $t_href_start; print_file_icon($t_file_display_name); print $t_href_end . '</a> ' . $t_href_start . $t_file_display_name . $t_href_end . "{$t_href_clicket} ({$t_filesize} bytes) <span class=\"italic\">{$t_date_added}</span>"; if ($t_can_delete) { print " [<a class=\"small\" href=\"bug_file_delete.php?file_id={$v_id}\">" . lang_get('delete_link') . '</a>]'; } if (FTP == config_get('file_upload_method') && file_exists($v_diskfile)) { print ' (' . lang_get('cached') . ')'; } if ($t_can_download && $v_filesize <= config_get('preview_attachments_inline_max_size') && $v_filesize != 0 && in_array(strtolower(file_get_extension($t_file_display_name)), array('png', 'jpg', 'jpeg', 'gif', 'bmp'), true)) { print "<br /><img src=\"file_download.php?file_id={$v_id}&type=bug\" />"; $image_previewed = true; } if ($i != $num_files - 1) { print '<br />'; } } }