function w3c_validator_site_result_sets_page in W3C Validator 6

Page callback that displays all validation sets.

Return value

void

1 string reference to 'w3c_validator_site_result_sets_page'

w3c_validator_site_menu in ./w3c_validator_site.module

Implementation of hook_menu().

File

./w3c_validator_site.pages.inc, line 141

Page callbacks for the w3c site validator module.

Code

function w3c_validator_site_result_sets_page() {
  $output = '';
  if (db_result(db_query("SELECT COUNT(*) FROM {validator_results_sets}"))) {
    $output .= drupal_get_form('w3c_validator_site_clean_results');
  }
  $sql = "SELECT * FROM {validator_results_sets} ORDER BY rsid DESC";
  $result = pager_query($sql, 30);
  $headers = array(
    t('Date'),
    t('Validation result'),
    t('URL count'),
    t('Invalid results'),
  );
  $rows = array();
  while ($row = db_fetch_object($result)) {
    $page_count = db_result(db_query("SELECT COUNT(*) FROM {validator_results_url} WHERE rsid = %d", $row->rsid));
    $invalid_page_count = db_result(db_query("SELECT COUNT(*) FROM {validator_results_url} WHERE rsid = %d AND validity = 0", $row->rsid));
    $rows[] = array(
      'data' => array(
        l(format_date($row->date), 'admin/content/validator/results/' . $row->rsid),
        $row->global_validate == 1 ? t('Valid') : t('Not valid'),
        $page_count,
        $invalid_page_count,
      ),
      'class' => $row->global_validate ? 'ok' : 'error',
    );
  }
  $output .= theme('table', $headers, $rows, array(
    'class' => 'system-status-report',
  ));
  $output .= theme('pager');
  return $output;
}