joingame.php

   1 <?
   2 include "con.inc";
   3 function auth($userid, $password) {
   4 $sql="SELECT username FROM users WHERE username='$userid' AND userpass='$password'";
   5 $result=mysql_query($sql);
   6 if(!mysql_num_rows($result)) return 0;
   7 else {
   8 $query_data=mysql_fetch_row($result);
   9 return $query_data[0];
  10 }
  11 }
  12 $username=auth($uname,$pword);
  13 if (!$username)
  14 {
  15 echo "You are not <a href=login.php>logged in</a>.";
  16 exit;
  17 }
  18 $joined=rand(1,3);
  19 $sql="SELECT * FROM users WHERE username='$uname'";
  20 $result=mysql_query($sql);
  21 $myrow=mysql_fetch_array($result);
  22 if ($myrow["cookies"]<=9)
  23 {
  24 echo "You must have 10 aura to join the game.";
  25 exit;
  26 }
  27 if ($myrow["faction"]!=0)
  28 {
  29 echo "You have already joined a clan.";
  30 exit;
  31 }
  32 if ($joined==1)
  33 {
  34 $clan="Hideyoshi";
  35 }
  36 if ($joined==2)
  37 {
  38 $clan="Rikyu";
  39 }
  40 if ($joined==3)
  41 {
  42 $clan="Tateishi";
  43 }
  44 $sql="UPDATE users SET money='20' WHERE username='$uname'";
  45 $result=mysql_query($sql);
  46 $sql="UPDATE users SET faction='$joined' WHERE username='$uname'";
  47 $result=mysql_query($sql);
  48 $sql="UPDATE users SET turns='50' WHERE username='$uname'";
  49 $result=mysql_query($sql);
  50 $sql="UPDATE users SET attack='10' WHERE username='$uname'";
  51 $result=mysql_query($sql);
  52 echo "You have joined the ".$clan." Clan";
  53 ?>