profile.php

   1 <?php
   2
   3 require('includes/header.php');
   4
   5 // If you're not a mod, fuck off.
   6 if( ! $moderator && ! $administrator)
   7 {
   8         add_error('You are not wise enough.', true);
   9 }
  10
  11 // Demand UID.
  12 if( ! isset($_GET['uid']))
  13 {
  14         add_error('No UID specified.', true);
  15 }
  16
  17 // Demand a _valid_ UID, fetch first_seen, IP address, and hostname.
  18 $uid_exists = $link->prepare('SELECT first_seen, ip_address FROM users WHERE uid = ?');
  19 $uid_exists->bind_param('s', $_GET['uid']);
  20 $uid_exists->execute();
  21 $uid_exists->store_result();
  22 if($uid_exists->num_rows < 1)
  23 {
  24         add_error('There is no such user.', true);
  25 }
  26 $uid_exists->bind_result($id_first_seen, $id_ip_address);
  27 $uid_exists->fetch();
  28 $uid_exists->close();
  29
  30 $id_hostname = @gethostbyaddr($id_ip_address);
  31 if($id_hostname === $id_ip_address)
  32 {
  33         $id_hostname = false;
  34 }
  35
  36
  37 // Check if banned.
  38 $check_uid_ban = $link->prepare('SELECT filed FROM uid_bans WHERE uid = ?');
  39 $check_uid_ban->bind_param('s', $_GET['uid']);
  40 $check_uid_ban->execute();
  41 $check_uid_ban->store_result();
  42 if($check_uid_ban->num_rows > 0)
  43 {
  44         $banned = true;
  45 }
  46 $check_uid_ban->close();
  47
  48 // Fetch number of topics and replies.
  49 $query = "SELECT count(*) FROM topics WHERE author = '" . $link->real_escape_string($_GET['uid']) . "';";
  50 $query .= "SELECT count(*) FROM replies WHERE author = '" . $link->real_escape_string($_GET['uid']) . "';";
  51
  52 $link->multi_query($query);
  53 do {
  54         $result = $link->store_result();
  55         while ($row = $result->fetch_row())
  56         {
  57                 $statistics[] = $row[0];
  58         }
  59         $result->free();
  60 } while ($link->next_result());
  61
  62 $id_num_topics = $statistics[0];
  63 $id_num_replies = $statistics[1];
  64
  65 // Now print everything.
  66 $page_title = 'Profile of poster ' . $_GET['uid'];
  67 dummy_form();
  68
  69 echo '<p>First seen <strong class="help" title="' . format_date($id_first_seen) . '">' . calculate_age($id_first_seen) . ' ago</strong> using the IP address <strong><a href="/IP_address/' . $id_ip_address . '">' . $id_ip_address . '</a></strong> (';
  70 //If there's a valid host name ...
  71 if($id_hostname)
  72 {
  73         echo 'host name <strong>' . $id_hostname . '</strong>';
  74 }
  75 else
  76 {
  77         echo 'no valid host name';
  78 }
  79 echo '), has started <strong>' . $id_num_topics . '</strong> existing topic' . ($id_num_topics == 1 ? '' : 's') . ' and posted <strong>' . $id_num_replies . '</strong> existing repl' . ($id_num_replies == 1 ? 'y' : 'ies') . '.</p>';
  80 if($banned)
  81 {
  82         echo '<p>This poster is currently <strong>banned</strong>.';
  83 }
  84 echo '<ul class="menu">';
  85 if( ! $banned)
  86 {
  87         echo '<li><a href="/ban_poster/' . $_GET['uid'] . '" onclick="return submitDummyForm(\'/ban_poster/' . $_GET['uid'] . '\', \'id\', \'' . $_GET['uid'] . '\', \'Really ban this poster?\');">Ban ID</a></li>';
  88 }
  89 else
  90 {
  91         echo '<li><a href="/unban_poster/' . $_GET['uid'] . '" onclick="return submitDummyForm(\'/unban_poster/' . $_GET['uid'] . '\', \'id\', \'' . $_GET['uid'] . '\', \'Really unban this poster?\');">Unban ID</a></li>';
  92 }
  93 echo '<li><a href="/nuke_ID/' . $_GET['uid'] . '" onclick="return submitDummyForm(\'/nuke_ID/' . $_GET['uid'] . '\', \'id\', \'' . $_GET['uid'] . '\', \'Really delete all topics and replies by this poster?\');">Delete all posts</a></li>';
  94 echo '</ul>';
  95
  96 if($id_num_topics > 0)
  97 {
  98         echo '<h4 class="section">Topics</h4>';
  99
 100         $stmt = $link->prepare('SELECT id, time, replies, visits, headline, author_ip FROM topics WHERE author = ? ORDER BY id DESC');
 101         $stmt->bind_param('s', $_GET['uid']);
 102         $stmt->execute();
 103         $stmt->bind_result($topic_id, $topic_time, $topic_replies, $topic_visits, $topic_headline, $topic_ip_address);
 104
 105         $topics = new table();
 106         $columns = array
 107         (
 108                 'Headline',
 109                 'IP address',
 110                 'Replies',
 111                 'Visits',
 112                 'Age ▼'
 113         );
 114         $topics->define_columns($columns, 'Headline');
 115         $topics->add_td_class('Headline', 'topic_headline');
 116
 117         while($stmt->fetch())
 118         {
 119                 $values = array
 120                 (
 121                         '<a href="/topic/' . $topic_id . '">' . htmlspecialchars($topic_headline) . '</a>',
 122                         '<a href="/IP_address/' . $topic_ip_address . '">' . $topic_ip_address . '</a>',
 123                         replies($topic_id, $topic_replies),
 124                         format_number($topic_visits),
 125                         '<span class="help" title="' . format_date($topic_time) . '">' . calculate_age($topic_time) . '</span>'
 126                 );
 127
 128                 $topics->row($values);
 129         }
 130         $stmt->close();
 131         echo $topics->output();
 132 }
 133
 134 if($id_num_replies > 0)
 135 {
 136         echo '<h4 class="section">Replies</h4>';
 137
 138         $stmt = $link->prepare('SELECT replies.id, replies.parent_id, replies.time, replies.body, replies.author_ip, topics.headline, topics.time FROM replies INNER JOIN topics ON replies.parent_id = topics.id WHERE replies.author = ? ORDER BY id DESC');
 139         $stmt->bind_param('s', $_GET['uid']);
 140         $stmt->execute();
 141         $stmt->bind_result($reply_id, $parent_id, $reply_time, $reply_body, $reply_ip_address, $topic_headline, $topic_time);
 142
 143         $replies = new table();
 144         $columns = array
 145         (
 146                 'Reply snippet',
 147                 'Topic',
 148                 'IP address',
 149                 'Age ▼'
 150         );
 151         $replies->define_columns($columns, 'Topic');
 152         $replies->add_td_class('Topic', 'topic_headline');
 153         $replies->add_td_class('Reply snippet', 'reply_body_snippet');
 154
 155         while($stmt->fetch())
 156         {
 157                 $values = array
 158                 (
 159                         '<a href="/topic/' . $parent_id . '#reply_' . $reply_id . '">' . snippet($reply_body) . '</a>',
 160                         '<a href="/topic/' . $parent_id . '">' . htmlspecialchars($topic_headline) . '</a> <span class="help unimportant" title="' . format_date($topic_time) . '">(' . calculate_age($topic_time) . ' old)</span>',
 161                         '<a href="/IP_address/' . $reply_ip_address . '">' . $reply_ip_address . '</a>',
 162                         '<span class="help" title="' . format_date($reply_time) . '">' . calculate_age($reply_time) . '</span>'
 163                 );
 164
 165                 $replies->row($values);
 166         }
 167         $stmt->close();
 168         echo $replies->output();
 169 }
 170
 171 if($trash = show_trash($_GET['uid']))
 172 {
 173         echo '<h4 class="section">Trash</h4>' . $trash;
 174 }
 175
 176 require('includes/footer.php');
 177
 178 ?>