function badbehavior_overview in Bad Behavior 6.2

Same name and namespace in other branches

1. 5.2 badbehavior.module \badbehavior_overview()
2. 6 badbehavior.admin.inc \badbehavior_overview()
3. 7.2 badbehavior.admin.inc \badbehavior_overview()

Builds the log table seen in the /admin/reports/badbehavior/ page.

Return value

string The actual table in HTML format

1 string reference to 'badbehavior_overview'

badbehavior_menu in ./badbehavior.module

Implements hook_menu().

File

./badbehavior.admin.inc, line 14

Admin page callbacks for the badbehavior module.

Code

function badbehavior_overview() {
  if (!badbehavior_load_includes(array(
    'responses',
  ))) {
    return 'Bad Behavior is not installed correctly. See the README.txt for installation details.';
  }
  $header = array(
    array(
      'data' => t('Response'),
    ),
    array(
      'data' => t('Reason'),
    ),
    array(
      'data' => t('Date'),
      'field' => 'w.date',
      'sort' => 'desc',
    ),
    array(
      'data' => t('IP'),
      'field' => 'w.ip',
    ),
    array(
      'data' => t('Agent'),
      'field' => 'w.user_agent',
      'colspan' => 2,
    ),
  );
  $logtype = variable_get('badbehavior_logging', 1);
  if ($logtype == 'verbose') {
    $sql = 'SELECT w.* FROM {bad_behavior_log} w ' . tablesort_sql($header);
  }
  elseif ($logtype == '1') {
    $sql = "SELECT w.* FROM {bad_behavior_log} w WHERE w.key <> '00000000' " . tablesort_sql($header);
  }
  else {
    $sql = '';
  }
  if ($sql) {
    $result = pager_query($sql, 50);
    while ($behave = db_fetch_object($result)) {
      $response = bb2_get_response($behave->key);
      $behave->localdate = bb2_convertdate($behave->date);
      $rows[] = array(
        'data' => array(
          $response['response'],
          $response['log'],
          $behave->localdate,
          $behave->ip,
          $behave->user_agent,
          l(t('details'), "admin/reports/badbehavior/event/{$behave->id}"),
        ),
      );
    }
  }
  if (empty($rows)) {
    $rows[] = array(
      array(
        'data' => t('No log messages available.'),
        'colspan' => '6',
      ),
    );
  }
  $output = theme('table', $header, $rows) . theme('pager', NULL, 50, 0);
  return $output;
}