failed_postings.php

   1 <?php
   2
   3 require('includes/header.php');
   4 update_activity('failed_postings');
   5 $page_title = 'Failed postings';
   6
   7 $items_per_page = ITEMS_PER_PAGE;
   8 $stmt = $link->prepare('SELECT time, uid, reason, headline, body FROM failed_postings ORDER BY time DESC LIMIT ?');
   9 $stmt->bind_param('i', $items_per_page);
  10 $stmt->execute();
  11 $stmt->bind_result($fail_time, $fail_uid, $fail_reason, $fail_headline, $fail_body);
  12
  13 $table = new table();
  14
  15 $columns = array
  16 (
  17         'Error message',
  18         'Poster',
  19         'Age ▼'
  20 );
  21 if( ! $moderator && ! $administrator)
  22 {
  23         array_splice($columns, 1, 1);
  24 }
  25
  26 $table->define_columns($columns, 'Error message');
  27
  28 while($stmt->fetch())
  29 {
  30         if(strlen($fail_body) > 600)
  31         {
  32                 $fail_body = substr($fail_body, 0, 600) . ' …';
  33         }
  34
  35         $tooltip = '';
  36         if(empty($fail_headline))
  37         {
  38                 $tooltip = $fail_body;
  39         }
  40         else if( ! empty($fail_body))
  41         {
  42                 $tooltip = 'Headline: ' . $fail_headline . ' Body: ' . $fail_body;
  43         }
  44
  45         $fail_reasons = unserialize($fail_reason);
  46         $error_message = '<ul class="error_message';
  47         if( ! empty($tooltip))
  48         {
  49                 $error_message .= ' help';
  50         }
  51         $error_message .= '" title="' . htmlspecialchars($tooltip) . '">';
  52         foreach($fail_reasons as $reason)
  53         {
  54                 $error_message .= '<li>' . $reason . '</li>';
  55         }
  56         $error_message .= '</ul>';
  57
  58         $values = array
  59         (
  60                 $error_message,
  61                 '<a href="/profile/' . $fail_uid . '">' . $fail_uid . '</a>',
  62                 '<span class="help" title="' . format_date($fail_time) . '">' . calculate_age($fail_time) . '</span>'
  63         );
  64         if( ! $moderator && ! $administrator)
  65         {
  66                 array_splice($values, 1, 1);
  67         }
  68
  69         $table->row($values);
  70 }
  71 $stmt->close();
  72 echo $table->output('failed postings');
  73
  74 require('includes/footer.php');
  75
  76 ?>