index.php

   1 <html>
   2 <?php include ("config.php");
   3
   4 function getclan($username)
   5 {
   6         $sql = "SELECT * FROM users WHERE username='$username'";
   7         $result = mysql_query($sql);
   8         $myrow = mysql_fetch_array($result);
   9         return $myrow["faction"];
  10 }
  11
  12 function getlevel($uname)
  13 {
  14         $sql = "SELECT * FROM users WHERE username='$uname'";
  15         $result = mysql_query($sql);
  16         $myrow = mysql_fetch_array($result);
  17         return $myrow["level"];
  18 }
  19
  20 function topcount($boardid)
  21 {
  22         $sql = "SELECT * FROM topics WHERE boardnum='$boardid' AND active='1'";
  23         $result = mysql_query($sql);
  24         $topiccount = mysql_num_rows($result);
  25         return $topiccount;
  26 }
  27
  28 function mescount($boardid)
  29 {
  30         $sql = "SELECT * FROM messages WHERE mesboard='$boardid'";
  31         $result = mysql_query($sql);
  32         $mescount = mysql_num_rows($result);
  33         return $mescount;
  34 }
  35
  36 function printboards($type, $level, $firstcolor)
  37 {
  38         $result = mysql_query("SELECT * FROM boards WHERE type='$type' ORDER BY theorder ASC");
  39         while ($myrow = mysql_fetch_array($result))
  40         {
  41                 if ($myrow["boardshow"] == 1 || mysql_result (mysql_query ("SELECT COUNT(fboard) FROM favorites WHERE fboard = '{$myrow['boardid']}' AND fuser = {$userid}"), 0))
  42                 {
  43                         if ($myrow["boardlevel"] <= $level)
  44                         {
  45                                 $topics = topcount($myrow["boardid"]);
  46                                 $messages = mescount($myrow["boardid"]);
  47                                 echo "<tr bgcolor=".$firstcolor."><td><a href=topiclist.php?board=".$myrow["boardid"].">".stripslashes($myrow["boardname"])."</a><br><small>".stripslashes($myrow["caption"])."</small></td><td>".$topics."</td><td>".$messages."</td></tr>";
  48                         }
  49                 }
  50         }
  51 }
  52
  53 echo "<center>There are approximately <b>";
  54 readfile("user.txt");
  55 echo "</b> user(s) currently online.</center>
  56 <table width=100%>";
  57 $username = auth();
  58 if (!$username)
  59 {
  60         echo "<tr><td colspan=3 bgcolor=".$titlecolor."><center><a href=login.php>Log in</a></center></td></tr>";
  61         $userlevel = 0;
  62 }
  63 if ($username)
  64 {
  65         $sql = "SELECT * FROM users WHERE username='{$_COOKIE['uname']}'";
  66         $result = mysql_query($sql);
  67         $myrow = mysql_fetch_array($result);
  68         echo "<tr align=center><td colspan=3 bgcolor=".$titlecolor."><a href=user.php>".$myrow["username"]." (".$myrow["level"].")</a></td></tr>";
  69         $userlevel = $myrow["level"];
  70 }
  71 echo "<tr bgcolor=".$titlecolor."><td width=75%>Board Name</td><td>Topics</td><td>Messages</td></tr>";
  72 $result = mysql_query("SELECT * FROM boardcat ORDER BY theorder ASC");
  73 while ($myrow = mysql_fetch_array($result))
  74 {
  75         echo "<tr bgcolor=".$titlecolor." align=center><td colspan=3>".stripslashes($myrow["name"])."</td></tr>";
  76         printboards($myrow["id"], $userlevel, $firstcolor);
  77 }
  78 echo "<tr><td colspan=3 bgcolor=black align=center><a href=favorites.php>Your Favorites</a></td></tr></table>";
  79 /*
  80 echo "<table width=100%><tr><td bgcolor=black><font color=white>Wanna be a <a href=modapp.php>moderator</a>?</td></tr></table>";
  81 */
  82 ?>