user.php

   1 <?php include ("config.php");
   2 $sql = "SELECT * FROM users WHERE username='{$_COOKIE['uname']}'";
   3 $result = mysql_query($sql);
   4 $myrow = mysql_fetch_array($result);
   5 function getuselevel($userlevel)
   6 {
   7         $sql = "SELECT * FROM levels WHERE levnum='$userlevel'";
   8         $result = mysql_query($sql);
   9         $myrow = mysql_fetch_array($result);
  10         return stripslashes($myrow["caption"]);
  11 }
  12 function posts($uname)
  13 {
  14         $sql = "SELECT * FROM messages WHERE messby='$uname' AND messbody!='[This message has been deleted by a moderator]'";
  15         $result = mysql_query($sql);
  16         $postnum = mysql_num_rows($result);
  17         return $postnum;
  18 }
  19 function mods($uname)
  20 {
  21         $sql = "SELECT * FROM modded WHERE modby='$uname'";
  22         $result = mysql_query($sql);
  23         $modnum = mysql_num_rows($result);
  24         return $modnum;
  25 }
  26 $posts = posts($_COOKIE['uname']);
  27 $modmess = mods($_COOKIE['uname']);
  28 $userlevel = getuselevel($myrow["level"]);
  29 echo "<body link=blue vlink=blue><table width=100%><tr align=center><td bgcolor=".$titlecolor."><font face=arial><b><a href=user.php>".$myrow["username"]." (".$myrow["level"].")</b></a> | <b><a href=index.php>Board List</b></a>";
  30 if (isset($_GET['board']))
  31         echo " | <b><a href=topiclist.php?board=".$_GET['board'].">Topic List</b></a>";
  32 if (isset($_GET['topic']))
  33 {
  34         echo " | <b><a href=messagelist.php?board=".$_GET['board']."&topic=".$_GET['topic'].">Message List</b></a>";
  35 }
  36 echo " | <b><a href=logout.php>Log Out</b></a></td></tr></table>";
  37 echo "<font color=white face=arial><table width=100% cellpadding=0 cellspacing=2 border=0><tr><td bgcolor=".$secondcolor." width=25%><font face=arial>UserID</td><td bgcolor=".$secondcolor."><font face=arial>".$myrow["userid"]."</td></tr><tr><td bgcolor=".$firstcolor."><font face=arial>Username</td><td bgcolor=".$firstcolor."><font face=arial>".$myrow["username"]."</td></tr><td bgcolor=".$secondcolor."><font face=arial>User Level</td><td bgcolor=".$secondcolor."><font face=arial>".$userlevel."</td></tr><td bgcolor=".$firstcolor."><font face=arial>Posted Messages</td><td bgcolor=".$firstcolor."><font face=arial>".$posts."</td></tr><td bgcolor=".$secondcolor."><font face=arial>Moderated Messages</td><td bgcolor=".$secondcolor."><font face=arial>".$modmess."</td></tr><tr><td bgcolor=".$firstcolor."><font face=arial>Aura</td><td bgcolor=".$firstcolor."><font face=arial>".$myrow["cookies"]."</td></tr><tr><td bgcolor=".$secondcolor."><font face=arial>Register Date</td><td bgcolor=".$secondcolor."><font face=arial>".$myrow["regdate"]."</td></tr><tr><td bgcolor=".$firstcolor."><font face=arial>Last Activity Date</td><td bgcolor=".$firstcolor."><font face=arial>".$myrow["lastactivity"]."</td></tr><tr><td bgcolor=".$secondcolor."><font face=arial>Personal Email Address</td><td bgcolor=".$secondcolor."><font face=arial>".$myrow["email2"]."</td></tr>";
  38 /*
  39 if ($myrow["faction"]!=0)
  40 {
  41 echo "<tr><td bgcolor=".$secondcolor."><font face=arial>Money</td><td bgcolor=".$secondcolor."><font face=arial>".$myrow["money"]."</td></tr><tr><td bgcolor=".$firstcolor."><font face=arial>Turns</td><td bgcolor=".$firstcolor."><font face=arial>".$myrow["turns"]."</td></tr><tr><td bgcolor=".$secondcolor."><font face=arial>Attack Power</td><td bgcolor=".$secondcolor."><font face=arial>".$myrow["attack"]."</td></tr>";
  42 }
  43 */
  44 echo "</table>";
  45 if ($myrow["level"] == 0)
  46 {
  47         echo "<br><br><center><a href=resendpass.php><font color=blue>Resend your registration key</a></center>";
  48         exit;
  49 }
  50 echo "</body><br><br><center><a href=chngpass.php><font color=blue>Change your password</a>";
  51 echo "<br><a href=moddedmes.php><font color=blue>View your modded messages</a>";
  52 echo "<br><a href=viewposts.php><font color=blue>View your posts</a>";
  53 echo "<br><a href=highest20.php><font color=blue>View the top 20 users</a>";
  54 echo "<br><a href=lowest20.php><font color=blue>View the lowest 20</a>";
  55 echo "<br><a href=pref.php><font color=blue>Edit Your Preferances</a>";
  56 echo "<br><a href=http://rhn.skwerl.net/boards/mods><font color=blue>Contribue Moderations</a>";
  57 echo "<br><br><B><font color=black>Search For a Message</b><br><br><form method=post action=messagesearch.php><input type=text name=query><br><br><input type=submit name=submit value=Search></form>";
  58 echo "<br><br><b><font color=black>Search For a Topic</b><br><br><form method=post action=topicsearch.php><input type=text name=query><br><br><input type=submit name=submit value=Search></form>"
  59 /*
  60 echo "<br><br><font color=black face=arial><b><font color=black>Game Controls</b><br>";
  61 if ($myrow["faction"]!=0)
  62 {
  63 echo "<br><a href=attack.php><font color=blue>Attack a User</a>";
  64 echo "<br><a href=train.php><font color=blue>Train Yourself</a>";
  65 echo "<br><a href=upgrade.php><font color=blue>Upgrade Your Attack Power</a>";
  66 echo "<br><a href=spy.php><font color=blue>Spy on a Clan</a>";
  67 echo "<br><a href=tradeaura.php><font color=blue>Trade your arua for Money</a>";
  68 echo "<br><a href=pillage.php><font color=blue>Pillage for Money</a>";
  69 echo "<br><a href=reset.php><font color=blue>Reset your Account</a>";
  70 }
  71 if ($myrow["faction"]==0)
  72 {
  73 echo "<br><a href=joingame.php><font color=blue>Join the Game</a>";
  74 }
  75 */
  76 ?>