0.8.1a
[gfh.git] / favorites.php
blobe1920d05fde8fdab8a099154d05710412bc95df5
1 <?php include ("config.php");
2 function getcapt($boardid)
4 return mysql_result (mysql_query ("SELECT caption FROM boards WHERE boardid = '$boardid'"), 0);
6 function getuserid($username)
8 return mysql_result (mysql_query ("SELECT userid FROM users WHERE username = '$username'"), 0);
10 function getclan($username)
12 return mysql_result (mysql_query ("SELECT faction FROM users WHERE username = '$username'"), 0);
14 function getlevel($uname)
16 return mysql_result (mysql_query ("SELECT level FROM users WHERE username='$uname'"), 0);
18 function topcount($boardid)
20 return mysql_result (mysql_query ("SELECT COUNT(topicid) FROM topics WHERE boardnum = '$boardid' AND active = '1'"), 0);
22 function boardname($boardid)
24 return mysql_result (mysql_query ("SELECT boardname FROM boards WHERE boardid = $boardid"), 0);
26 function mescount($boardid)
28 return mysql_result (mysql_query ("SELECT COUNT(messageid) FROM messages WHERE mesboard = '$boardid'"), 0);
31 echo "<table width=100%>";
32 $username = auth();
33 if (!$username)
35 echo "<tr><td bgcolor=".$titlecolor."><font face=arial><center><a href=login.php>Log in</a></center></font></td></tr>";
38 $userid = getuserid($uname);
39 if (isset($_GET['delfav']))
41 $myrow = mysql_fetch_array(mysql_query("SELECT * FROM favorites WHERE fid='{$_GET['delfav']}'"));
42 if ($myrow["fuser"] == $userid)
44 $result = mysql_query("DELETE FROM favorites WHERE fid='{$_GET['delfav']}'");
45 $delfav2 = 1;
48 if ($username)
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>";
53 if (!empty($delfav2))
55 echo '<tr bgcolor='.$systemnotcolor.'><td align="center">Favorite Deleted</td></tr>';
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))
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>";
70 echo "</table>";