messages.inc.php

   1 <?php
   2 $page = isset ($_GET['page']) ? intval ($_GET['page']) : 1;
   3 $pages = ($page-1) * 50;
   4 $msg_count = $pages;
   5
   6 $number_of_items = mysql_result (mysql_query ('SELECT COUNT(*) FROM `msgmeta` WHERE '.$list_criteria), 0);
   7
   8 $pagelist = '';
   9 $optional = isset ($optional) ? $optional : '';
  10 if ($number_of_items > 50)
  11         $pagelist = pagelist ($optional);
  12
  13 echo $pagelist.'
  14 ';
  15
  16 $message_list = mysql_query ('SELECT `messageid`, `postedby`, `messsec`, `active`, `messbody`, `aurachng`, `mesboard`, `topic`, `postedip`
  17 FROM `msgmeta`, `messages`
  18 WHERE `msgid` = `messageid`
  19 AND '.$list_criteria.' LIMIT '.$pages.', 50');
  20
  21 while ($message = mysql_fetch_row ($message_list))
  22 {
  23         if (isset ($show_titles))
  24         {
  25                 $titles = mysql_fetch_row (mysql_query ('SELECT `boards`.`boardname`, `topics`.`topicname`
  26 FROM `boards`, `topics`
  27 WHERE `boards`.`boardid` = '.$message[6].'
  28 AND `topics`.`topicid` = '.$message[7]));
  29
  30                 echo '<div class="c3" style="margin-top: 2px">
  31 Board: <a href="viewboard?b='.$message[6].'">'.$titles[0].'</a> | Topic: <a href="viewtopic?b='.$message[6].';t='.$message[7].'">'.$titles[1].'</a>
  32 </div>
  33 ';
  34         }
  35         echo '<div class="c2" id="m'.++$msg_count.'">From: '.userlink ($message[1]).' ('.mysql_result (mysql_query ('SELECT `level` FROM `users` WHERE `userid` = '.$message[1].' LIMIT 1'), 0).') | Posted: '.date2 ($message[2]).
  36         ' | <a href="message?m='.$message[0].urlpath(1).'">Message Options</a>';
  37         if ($message[5] < 0)
  38                 echo ' | '.$cfg['img'][1].' '.$message[5].' '.$cfg['bds']['aura'];
  39         elseif ($message[5] > 0)
  40                 echo ' | '.$cfg['img'][0].' '.$message[5].' '.$cfg['bds']['aura'];
  41         if ($userinfo['level'] >= MOD)
  42         {
  43                 switch ($message[3])
  44                 {
  45                         case 'modded': // modded
  46                                 echo ' | '.$cfg['img'][2];
  47                                 break;
  48                         case 'deleted': // deleted
  49                                 echo ' | '.$cfg['img'][3];
  50                                 break;
  51                         default:
  52                                 break;
  53                 }
  54                 echo ' | <a href="ipinfo?ip='.$message[8].urlpath(1).'">'.$message[8].'</a>';
  55         }
  56         echo ' | <a href="#m'.$msg_count.'">#'.$msg_count.'</a></div>
  57 <div class="c1">';
  58         if ($userinfo['level'] >= MOD || $myrow[3] == 'active')
  59                 echo $message[4];
  60         elseif ($message[3] == 'deleted')
  61                 echo '[Message deleted by poster]';
  62         elseif ($message[3] == 'modded')
  63                 echo '[Message deleted by moderator]';
  64         echo '</div>
  65 ';
  66 }
  67
  68 echo $pagelist;
  69 ?>