sysnotes.php

   1 <?php
   2 require ('config.php');
   3 require ('extfuncs.inc.php');
   4 $require_login = true;
   5 if ($userinfo['level'] >= MOD && isset ($_GET['user']))
   6 {
   7         $user = intval ($_GET['user']);
   8         $page_name = 'System Notifications for '.mysql_result (mysql_query ('SELECT `username` FROM `users` WHERE `userid` = '.$user), 0);
   9 }
  10 else
  11 {
  12         $user = $userinfo['userid'];
  13         $page_name = 'System Notifications';
  14         mysql_query ('UPDATE `users` SET `viewdisp` = ((`viewdisp` | 128) - 128) WHERE `userid` = '.$user);
  15         mysql_query ('UPDATE `systemnot` SET `active` = 0 WHERE `to` = '.$user);
  16 }
  17 require ('top.inc.php');
  18
  19 if (isset ($_GET['delete']))
  20 {
  21         if ($_GET['delete'] == 'all')
  22                 mysql_query ('DELETE FROM `systemnot` WHERE `to` = '.$userinfo['userid']);
  23         else
  24                 mysql_query ('DELETE FROM `systemnot` WHERE MD5(CONCAT(`to`,`time`)) = \''.mysql_real_escape_string ($_GET['delete']).'\' LIMIT 1');
  25         echo '<div class="alert">Sysnote(s) Deleted.</div>';
  26 }
  27
  28 $result = mysql_query ('SELECT `time`, `from`, `sysbod` FROM `systemnot` WHERE `to` = '.$user.' ORDER BY `time` DESC');
  29 if (mysql_num_rows ($result) == 0)
  30         echo '<div class="alert">You have no system notifications.</div>';
  31
  32 echo '<div class="c3"><a href="?delete=all'.urlpath(1).'">Delete All</a></div>';
  33
  34 while ($myrow = mysql_fetch_row ($result))
  35 {
  36         echo '<div class="c2">Date: '.date2 ($myrow[0]).
  37         ($userinfo['level'] >= MOD ?
  38                 ' | From: '.($myrow[1] > 0 ? userlink ($myrow[1]).' | <a href="sendsys.php?user='.$myrow[1].urlpath(1).'">Reply</a>' : 'System') : '').
  39 ' | <a href="?delete='.md5 ($userinfo['userid'].$myrow[0]).urlpath(1).'">Delete</a></div>
  40 <div class="c1">'.$myrow[2].'</div>
  41 ';
  42 }
  43
  44 require ('foot.php');
  45 ?>