favorites.php

   1 <?php include ("config.php");
   2 function getcapt($boardid)
   3 {
   4         return mysql_result (mysql_query ("SELECT caption FROM boards WHERE boardid = '$boardid'"), 0);
   5 }
   6 function getuserid($username)
   7 {
   8         return mysql_result (mysql_query ("SELECT userid FROM users WHERE username = '$username'"), 0);
   9 }
  10 function getclan($username)
  11 {
  12         return mysql_result (mysql_query ("SELECT faction FROM users WHERE username = '$username'"), 0);
  13 }
  14 function getlevel($uname)
  15 {
  16         return mysql_result (mysql_query ("SELECT level FROM users WHERE username='$uname'"), 0);
  17 }
  18 function topcount($boardid)
  19 {
  20         return mysql_result (mysql_query ("SELECT COUNT(topicid) FROM topics WHERE boardnum = '$boardid' AND active = '1'"), 0);
  21 }
  22 function boardname($boardid)
  23 {
  24         return mysql_result (mysql_query ("SELECT boardname FROM boards WHERE boardid = $boardid"), 0);
  25 }
  26 function mescount($boardid)
  27 {
  28         return mysql_result (mysql_query ("SELECT COUNT(messageid) FROM messages WHERE mesboard = '$boardid'"), 0);
  29 }
  30
  31 echo "<table width=100%>";
  32 $username = auth();
  33 if (!$username)
  34 {
  35         echo "<tr><td bgcolor=".$titlecolor."><font face=arial><center><a href=login.php>Log in</a></center></font></td></tr>";
  36 }
  37
  38 $userid = getuserid($uname);
  39 if (isset($_GET['delfav']))
  40 {
  41         $myrow = mysql_fetch_array(mysql_query("SELECT * FROM favorites WHERE fid='{$_GET['delfav']}'"));
  42         if ($myrow["fuser"] == $userid)
  43         {
  44                 $result = mysql_query("DELETE FROM favorites WHERE fid='{$_GET['delfav']}'");
  45                 $delfav2 = 1;
  46         }
  47 }
  48 if ($username)
  49 {
  50         $myrow = mysql_fetch_array (mysql_query ("SELECT * FROM users WHERE username='$uname'"));
  51         echo "<tr bgcolor=".$titlecolor." align=center><td><a href=user.php>".$myrow["username"]." (".$myrow["level"].")</a>: <a href=index.php>Board List</a> | <a href=logout.php>Log out</a></td></tr>";
  52 }
  53 if (!empty($delfav2))
  54 {
  55         echo '<tr bgcolor='.$systemnotcolor.'><td align="center">Favorite Deleted</td></tr>';
  56 }
  57
  58 echo "</table>
  59 <table width=100%><tr align=center><td bgcolor=".$titlecolor.">Your Favorite Boards</td></tr>
  60 </table><table width=100% cellpadding=0 cellspacing=2 border=0>
  61 <tr bgcolor=".$firstcolor."><td>Remove</td><td>Board Name</td><td>Topics</td><td>Posts</td></tr>";
  62 $result = mysql_query("SELECT * FROM favorites WHERE fuser = '$userid'");
  63 while ($myrow = mysql_fetch_array($result))
  64 {
  65         $topics = topcount($myrow["fboard"]);
  66         $messages = mescount($myrow["fboard"]);
  67         $caption = getcapt($myrow["fboard"]);
  68         echo "<tr bgcolor=".$firstcolor."><td><a href=favorites.php?delfav=".$myrow["fid"].">(Remove)</a></td><td width=75%><a href=topiclist.php?board=".$myrow["fboard"].">".stripslashes(boardname($myrow["fboard"]))."</a><br><small>".stripslashes($caption)."</small></td><td>".$topics."</td><td>".$messages."</td></tr>";
  69 }
  70 echo "</table>";
  71 ?>