Learn VBA & Macros in 1 Week!

PHP - Browser Game Map

Full Excel VBA Course - Beginner to Expert

Browser Game Map	View Content

View Content

I have just did this php code for the high-low game but the $tries variable always goes down to 0 when I refresh..Can someone help me to return the $tries to browser with the url? Thank you

<html>
   <?php $tries = 0 ?>
   <body>
           <form action="http://195.251.218.44/code/workspace/fin19178/2021/ergasia2/askisi2.php" method="post">
               Make a guess: <input type="number"    name="number" id="number" required>
               <input type="submit" value="Guess">
           </form>

   </body>
</html>

<?php function High_Low($guess){
   $tries += 1;
   $hidden_number= 74;
   if ($guess < $hidden_number) {
       return "Give me a higher number!";
} elseif ($guess > $hidden_number) {
       return "Give me a lower number!";
} else {
       return "Congratulations,You have found it in:" . $tries . " tries!"; }
   }
?>
<?php echo High_Low($_POST["number"]); ?>

Random Number Game

Similar Tutorials

View Content

Hello,
I am trying to create a simple game random number guessing game in PHP.
Currently, I have an HTML page with a form on it where the user enters a number.
Then when the user clicks the submit button on the form, their number is passed onto the second page.
On the second page, I have some PHP code that generates a random number between 1 and 20, then it checks to see if the two numbers are the same.
If they are the same, it says correct.
If the guess is higher, it says so.
If the guess is lower, it says so.
I also made it display a form to re-guess the number (if the initial guess was incorrect).

The problem I have is when the user attempts to re-guess the number. Whenever the user attempts to enter a new guess, the random number changes.
I want to make it so that the random number stays the same as it is.
Any help?

Here is the Code for the first HTML page:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpNumberGame</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>

<div id="main"></div>

<div id="enterNumber">
<form action="result.php" method="post">
Enter a number: <input type="text" name="inputnumber" /><br />
<input type="submit" value="Guess" />
</form>
</div>

</body>
</html>

Here is the code for the second page:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>result</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div id="main"></div>

<div id="enterNumber">

<?php
$number_actual = rand (1,20);
$number_guess = $_REQUEST["inputnumber"];
         echo "You chose: " . $number_guess . "<br />";
echo "The random number is: " . $number_actual . "<br />";
if ($number_guess==$number_actual)
echo "You guessed <b>Correctly!</b>";
elseif ($number_guess<$number_actual)
{
echo "You are too <b>Low</b>!";
echo "<br />";
echo "<br />";
echo "Try guessing again...";
echo "<form>
<input type='text' name='inputnumber' />
<input type='submit' value='Guess' />
  </form>";
}
elseif ($number_guess>$number_actual)
{
echo "You are too <b>High</b>!";
echo "<br />";
echo "<br />";
echo "Try guessing again...";
echo "<form>
<input type='text' name='inputnumber' />
<input type='submit' value='Guess' />
  </form>";
}
?>
</div>

</body>
</html>

Here is what I have so far on my website, you can see it he
http://joshkautz.com/phpNumberGame/phpNumberGame.html

I think I included everything necessary for people to give input, if not please let me know and I will give more information!
Do I need to redo things completely?
Any advice would be greatly appreciated.
Thanks a ton!

Game Playing System

Similar Tutorials

View Content

so i have an idea for a system that basicly shows a swf, how to play, and description all managed by sql.

the url would be like: "www.example.com/play.php?id=531"

my sql table would be like this:

___________________
id name swfname description howto
1 example ex1.swf destroy your enemies with your gun mouse to aim, click to shoot
2 example2 ex2.swf race your friends with this new game! Arrow keys to move. Space to use powerup.
________________

I need help creating a system that looks at the id provided in the url, then grabs the information in the sql and broadcasts the swf, and posts the title up top and the description and howto below.

anyone have any idea how to do this?

Game Trading Application

Similar Tutorials

View Content

Hello

I am making a game trading web application for class.

Here are the requirements:
You must be able to register and log in, you must be able to list games you have to trade and games you want, you must be able to search users that want games you have and users that have games you want, you must be able to accept and make trades, on trade finalization screen you must be able to rate user 1-5, view the users shipping address, and leave a comment on the users page.

You do not have to be able to view other users pages, but on your home page you must be able to view your average rating.

I am the most advanced programmer in my group so this has been a little tough.

I have a login page and a registration page, I have a user home page, a add games page, a view feedback/ratings page, and a my games page where you can delete games.

What I'm stuck on is the page that allows you to search users by games they want and games you want, and the trade finalization page.
On the search page I would like to combine the functionality of searching for users with games you want and games they want with the ability to make a trade offer. The way we have it drawn up is using radio buttons to select either show people with games I want and show people wanting my games. When one is selected it will populate a list of usersnames in a drop down menu that fit whichever choice was made. We drew up four list boxes that populate lists when we select a user name, one box populates the games they have, one populates the games they want, one populates the games I have and one populates games I want. We want to be able to select game titles and move them to a list box of games I want and another to a list box of games willing to trade, lastly a submit offer button.
We are debating on if this is the best set up given the requirements needing to be met. I think there is more here than what we need, we have 1 week to do this and I am doing all the programming so I am looking for the easiest way to search users that want games I have/have games I want and display the results giving me the option to select games to trade and make an offer.
We are also arguing on if we have to use JavaScript to do this or if it can all be done within php.

The trade finalization page would have a drop down menu where you select the user name of completed trades and upon selection lists will be populated of games they gave, games I gave and the address to send the game. It will also have a form where we can rate the user and leave a comment.

This page I need help with cause again we disagree on having to use JavaScript or not.

We are using phpMyAdmin and the db tables we have a
tblgame - list of games I have added
tblgamestatuscode - gives game a code that determines if it is wanted, to trade, or traded
tblmember - member registration
tblplatform - platform the game is on (Xbox, Xbox 360, Playstation2, Playstation3, PC, and Wii)
tbltransaction - date traded and a status change code
tbltransactiondetail - gameID and trans ID
tbltransactionparty - memberID, transID, rating, comments, status change accepted

We are also using adodb.

Please help if you can. I will gladly give more information if needed.

Number Guessing Game In Php

Similar Tutorials

View Content

Hi! I was assigned to create a simple php game as a part of my grade, but i got stuck. I'm not really a php expert and this isnt really working. I managed to get some of the code/game working, but it's pointless imo. I'm looking for someone who would take 3 mins and fix this code for me. The game is called "Random number guessing game." From the title you can see that the game is not really complicated. Code:

<html>
<head>
<title></title>
</head>
<body>


<h1> Ugani Random!</h1>


<? php
if(isset($_POST['submit']))
$x = $_POST['x'];
$num = $_POST['num'];


$x = rand(1, 10)
if($num<$x)
{
echo " Your number is higher! "<br />
}


if($num==$x)
{
echo " Correct! Press Reset to try again! "<br />
}


if($num>$x)
{
echo " Your number is lower! "<br />
}


?>


<p>
<form>
<input type="number" name="quantity"> <br />
<button type="submit" value="<? echo $x?>">Submit</button>
<button type="reset" value="<? echo $num?>">Reset</button>
</form>
</p>


</body>
</html>

Making A Game: Learning By Doing

Similar Tutorials

View Content

Hi
I'm attempting to learn more advanced PHP, such as OOP and the integration of XML, by making a browser-based version of the old Richard Garfield card game "Netrunner". I have a few years experience with pretty basic (bordering on intermediate) PHP. I've done some very basic coding for the game with PHP forms and I've researched some OOP (classes, objects, methods, etc.) but I'm not finding the beginner tutorials that I need. Everything I find has terminology and code that is beyond me. Does anyone have any book or website suggestions for me? I've tried the PHP online manual, but even that throws in advanced stuff all over the place. My goal is to better learn how to use PHP (because I've already put time into it) to create browser based games.
Many thanks,
Andy

Guessing Game Php With Sessions

Similar Tutorials

View Content

I am supposed to create a guessing game in PHP that uses sessions to store a random number between 0 and 100, along with the number of guesses the user has attempted. Each time the user guesses wrong, display the number of times the user has guessed. And a give up link that displays the generated number for the current game. I have been working on this for a week and I can't figure it out. Any help would be appreciated.
Here's my code thus far:
game.php
Code: [Select]
<?php
session_start();
if (!isset($_SESSION["randNum"])) {

    $_SESSION["randNum"]=rand(1,100);
}
$randNum=intval($_SESSION["randNum"]);
?>

<html>
<body>
<center><form action="game_check.php" method="POST">
Guess a number 1-100:<input type="text" name="userGuess"/>
<input type="submit" value="Guess"/>

</form></center>
<center><form action="game.php">
<input type="submit" value="Restart"/>
</form></center>
</body>
</html>game_check.php
Code: [Select]
<?php
session_start();
$_SESSION["randNum"] = $_POST["randNum"];
$userGuess=$_POST["userGuess"];

if (isset($randNum)) {
    if ($userGuess<$randNum) {
            echo "<center>You guessed too low!</center>";
        }
    if ($userGuess>$randNum) {
            echo "<center>You guessed too high!</center>";
        }
    if ($userGuess==$randNum) {
            echo "<center>Congratulations You're right!!!</center>";
                         unset($_SESSION["randNum"]);
    }
}
else {
    echo "Uh oh";
}

?>

Text-based Rpg Game Help

Similar Tutorials

View Content

I have a little experience in coding php and am wanting to code a browser-based RPG. (One of the click the link games). I know how to code the login, registration, player list, lost password, etc., but I have no idea where to start with coding the attack, throwing in random chance, strength, agility and so forth; stores, items, money, and so on and so on. Can someone help me?

Putting Guilds In My Game

Similar Tutorials

View Content

OK so i am having a little trouble putting guilds in my game, everything shows up but when you go to create a new guild it say can not update player stats, but it shows up that the guild has been created in the top guild list, it just doesnt let you use it here is the script could someone tell me if they see a problem

Code: [Select]
<?php
require 'connect.php';
include 'header.php';
include 'headin.php';
?>
<script type="text/javascript">
function stats()
{
var no=document.getElementById("Name")
var option=no.options[no.selectedIndex].value
var y="guild.php?stats=1&&guild="+option
window.open(y,"_blank","toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=no, width=400, height=500")
}

function redirect()
{
window.location="./guild.php"
}
</script>
<?php
if(!isset($_COOKIE['member_id']))
  die('Not logged in, please <a href=login.php>login</a>');
$Player=$_COOKIE['member_id'];
$Option=$_POST['option'];
$Create=$_POST['create'];
$Join=$_POST['join'];
$Submit=$_POST['submit'];
$Tax=$_POST['tax'];
$Guild=$_GET['guild'];
$Deny=$_GET['deny'];
$Add=$_GET['add'];
$Stats=$_GET['stats'];
$Kick=$_GET['kick'];
$Kickname=$_GET['kickname'];
$Addname=$_GET['addname'];
$Abandon=$_POST['abandon'];
$Coleader=$_GET['coleader'];
if(isset($Abandon))
  $Option="Abandon";
if($Option=="")
  $Option=$_GET['option'];
if(isset($Option))
{
  if($Option=='Create a guild')
  {
  ?>
<p>It costs 1,000,000 gold to create a Guild.<br /><br /></p>
<form method="post" action="guild.php">
Name:<input class="text" type="text" name="name" />
<input class="button" name="create" type="submit" value="submit" />
</form>
<?php
  }
  elseif($Option=='Join a guild')
  {
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "<select class=\"select\" name='Name' id='Name' length='20' id='blah'>";
    $Guild="SELECT * from Guilds order by ID asc";
    $Guild2=mysql_query($Guild) or die("Could not select Guilds");
    while ($Guild3=mysql_fetch_array($Guild2))
    {
      $Name=str_replace(" ","%20",$Guild3['Name']);
      print "<option value=\"$Name\">$Guild3[Name]</option>";
    }
    print "</select><br />";
    print "<input class=\"button\" type='Submit' name='join' value='Join' /> ";
    ?><input class=button type="button" onclick="stats()" value="Stats" /></form> <?php
  }
elseif($Option=='Raise your guilds tax')
  {
        $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    if($Guild['Tax']>90){
    mysql_query("UPDATE Guilds SET Tax='90' WHERE Name='$Name'");
    }
    if($Guild['Owner']==$User['Playername'] || $Guild['Coleader']==$User['Playername']){
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "Amount: <input type=text class=\"select\" name='tax' id='tax' length='3' id='tax'>";
    print "<br /><br>";
    print "<input class=\"button\" type='Submit' name='submit' value='Raise' /></form> ";

}else{
echo"You may not edit your Guild Tax, since you are not a leader or co-leader.";
exit;
}
  }
  elseif($Option=='Guild stats')
  {

    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Guild1="SELECT * from Guilds where Name='$User[Guild]'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    $Query="SELECT * from Users where Guild='$Guild[Name]' order by Level desc";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    if($Guild['Name']!="")
    {
      print "<table class=\"table\" align=\"center\"><tr><td>";
      $AttackPower=number_format(pow($Guild['AttackPower']+10, 5));
      $DefenceStance=number_format(pow($Guild['DefenceStance']+10, 5));
      $Agility=number_format(pow($Guild['Agility']+10, 5));
      $Gold=pow($Guild['Gold']+12,3)*4;
      $Gold=number_format($Gold);
      $Exp=pow($Guild['Exp']+9, 4)+500;
      $Exp=number_format($Exp);
      $Itemfind=number_format(pow($Guild['Itemfind']+10, 5));
      $Itemquality=number_format(pow($Guild['Itemquality']+10, 5));
      print "Guild Name: $Guild[Name]<br />Guild Owner: $Guild[Owner]<br />Guild Co-Owner: $Guild[Coleader]<br />Guild Bank: $Guild[Bank]<br />Guild Tax: $Guild[Tax]%<br />Last Guild Battle: $Guild[LastFight]<br />Battles won: $Guild[Won]<br />Battles Lost: $Guild[Lost]<br />";

if($Guild['Owner']==$User['Playername'] || $Guild['Coleader']==$User['Playername'] || $User['Admin']==1){
echo "<form class=\"form\" method=\"post\" action=\"guildbonus.php\">";
      echo "Attack Power:".$Guild['AttackPower']."% <input class=\"button\" type='Submit' name='AttackPower' value='Increase' /> $AttackPower gold<br />";
      echo "Defence Stance:".$Guild['DefenceStance']."% <input class=\"button\" type='Submit' name='DefenceStance' value='Increase' /> $DefenceStance gold<br />";
      echo "Agility:".$Guild['Agility']."% <input class=\"button\" type='Submit' name='Agility' value='Increase' /> $Agility gold<br />";
      echo"Exp:".$Guild['Exp']."% <input class=\"button\" type='Submit' name='Exp' value='Increase' /> $Exp gold<br />";
      echo "Gold:".$Guild['Gold']."% <input class=\"button\" type='Submit' name='Gold' value='Increase' /> $Gold gold<br />";
      echo "Item Find:".$Guild['Itemfind']."% <input class=\"button\" type='Submit' name='Itemfind' value='Increase' /> $Itemfind gold<br />";
      echo "Item Quality:".$Guild['Itemquality']."% <input class=\"button\" type='Submit' name='Itemquality' value='Increase' /> $Itemquality gold<br />";
}else{
echo "<form class=\"form\" method=\"post\" action=\"guildbonus.php\">";
      echo "Attack Power:".$Guild['AttackPower']."% <br />";
      echo "Defence Stance:".$Guild['DefenceStance']."% <br />";
      echo "Agility:".$Guild['Agility']."% <br />";
      echo "Experience".$Guild['Exp']."% <br />";
      echo "Gold:".$Guild['Gold']."% <br />";
      echo "Item Find:".$Guild['Itemfind']."% <br />";
      echo "Item Quality:".$Guild['Itemquality']."% <br />";
}
      print "Donate:<input class=\"text\" type=\"text\" name=\"Amount\" value=\"$User[Gold]\" /><input class=\"button\" type='Submit' name='Donate' value='Donate' /></form><br />";
      if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
    print"<a href=\"attackguild.php\">Attack Other Guilds</a><br><br>";
    }
      if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1")
      {
        $Name=str_replace(" ","%20",$Guild['Name']);
        echo "<a href=\"guild.php?coleader=1&&Guild=$Name\">Assign coleader</a><br />";
      }
      print "</td></tr></table>";
    }
    else
      echo "You are not in a guild, below is a listing of all people not in a guild.";
    print "<table class=\"table\" align=\"right\"><tr><td>";
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "<table><tr><td>";
    print "Members:<br />To kick a member out the guild must pay half of what the User has donated.<br><br><table id=\"table\"><tr><td>Player</td><td>Level</td><td>Donated</td>";
     if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
      print "<td>Kick</td>";
     }
    print "</tr>";
    while($topplayer3=mysql_fetch_array($Query2))
    {
      print "<tr><td>$topplayer3[Playername]</td><td>$topplayer3[Level]</td><td>$topplayer3[GuildDonate]</td>";
       if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
      print "<td><a href=\"guild.php?kick=$topplayer3[ID]&&kickname=$Guild[ID]\">Kick</a></td>";
     }
      print "</tr>";
    }
    print "</table></form></td><td></td><td>";
    if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1")
    {
      $Name = $Guild['Name'];
      $Guild['Name' ]= str_replace(" ","%20",$Guild['Name']);
      $Query = mysql_query("select * from Users where Applied='$Name'");
      print "Requests:<br /><table id=\"table\"><tr><td>Name</td><td>Level</td><td>Accept?</td><td>Deny?</td></tr>";
      while($joinee = mysql_fetch_array($Query))
      {
        echo "<tr><td>$joinee[Playername]</td>";
        echo "<td>$joinee[Level]</td>";
        echo "<td><a href=\"guild.php?add=$joinee[ID]&&addname=$Guild[Name]\">Accept</a></td><td><a href=\"guild.php?deny=$joinee[ID]\">Deny</a></td></tr>";
      }
      print "</table>";
      print "</td></tr></table>";
    }
    print "</td></tr></table><br />";

  }
  elseif($Option=='Leave guild')
  {
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    if($Guild['Owner']==$User['Playername'])
    {
      echo "Are you sure you want to abandon and delete your guild?";
      echo "<form action=\"guild.php\" method=\"post\"><input type=\"hidden\" value=\"$Guild[Name]\" name=\"Guild\" /><input class=\"button\" type=\"submit\" name=\"abandon\" value=\"yes\" /><input class=\"button\" type=\"button\" value=\"no\" onclick=\"redirect()\" /></form>";
    }
    else
    {
      mysql_query("UPDATE Users SET GuildDonate='0' WHERE ID='$Player'");
      mysql_query("Update Users set Guild='' where ID='$Player'") or die("Could not update player stats");
      mysql_query("update Guilds set Members=Members-'1' where Name='$Guild[Name]'") or die("Could not decrease number of members");
      print "You have left the guild.";
    }
  }
  elseif($Option=="Abandon")
  {
    $Guild=$_POST['Guild'];
    $Query="Select * from Users where Guild='$Guild'";
    $Query2=mysql_query($Query) or die("Zomg");
    while($User=mysql_fetch_array($Query2))
    {
      $ID=$User['ID'];
      $Update="Update Users set Guild='' where ID='$ID'";
      mysql_query($Update) or die("No clan update.");
    }
    $Query="Delete from Guilds where Name='$Guild'";
    mysql_query($Query) or die("Can't delete guild.");
    echo "Clan deleted.";
  }
}
elseif(isset($Kick))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Querty="SELECT * from Users where ID='$Kick'";
    $Querty2=mysql_query($Querty) or die("Could not get user stats");
    $Kicking=mysql_fetch_array($Querty2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    $KickAmount=$Kicking['GuildDonate']/2;

   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot kick users because you are not the leader or coleader of this guild!";
   exit;
   }
   elseif($Kicking['Playername']==$Guild['Owner']){
   echo"You may not kick out the creator of this guild!";
   exit;
   }
   elseif($KickAmount>$Guild['Bank']){
   echo"You do not have enough gold to kick this player out. To kick out a member you must be able to pay half of what they have donated.";
   exit;
   }
   else{
mysql_query("UPDATE Guilds SET Bank=Bank-'$KickAmount' WHERE ID='$Kickname'");
mysql_query("UPDATE Guilds SET Members=Members-'1' WHERE Name='$Guild[Name]'");
mysql_query("UPDATE Users SET Gold=Gold'$KickAmount' WHERE ID='$Kick'");
mysql_query("UPDATE Users SET GuildDonate='0' WHERE ID='$Kick'");
mysql_query("UPDATE Users SET Guild='' WHERE ID='$Kick'");
echo"Player kicked from your guild! <a href='guild.php'>Back</a>";
   }
}
elseif(isset($Submit))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);

if($Tax<0 || $Tax>90){
echo"Do you want people leaving your guild?";
exit;
}else{
mysql_query("Update Guilds set Tax='$Tax' where Name='$Name'");
echo "Tax set to $Tax!";
}
}
elseif(isset($Create))
{
  if(isset($_POST['name']))
  {
    $Name=$_POST['name'];
    $Player=$_COOKIE['member_id'];
    $Query=mysql_query("select * from Users where ID='$Player'") or die("Could not query Users");
    $User=mysql_fetch_array($Query);
    $check="SELECT * from Guilds where Name='$Name'";
    $check2=mysql_query($check) or die("Could not query guilds");
    while($check3=mysql_fetch_array($check2))
    {
      $Clan=$check3['Name'];
    }
    if($Clan)
       print "Sorry there is already a guild of that name.";
    elseif($User['Guild'] != "")
      echo "You have to leave your clan before you can create your own.";
    elseif($User['Gold']>=1000000)
    {
      $Query="INSERT into Guilds(Name, Owner) VALUES ('$Name', '$User[Playername]')";
      mysql_query($Query) or die("could not create clan");
      $Update="Update Users set Guild='$Name', Applied='', Gold=Gold-'1000000' where ID='$Player'";
      mysql_query($Update) or die("Could not update player stats");
      print "Clan created.";
    }
    else
      print "You do not have enough gold.";
  }
}

elseif(isset($Join))
{
  if(isset($_POST['Name']))
  {
    $Name=$_POST['Name'];
    $Player=$_COOKIE['member_id'];
    $Name=str_replace("%20"," ",$Name);
    $Query=mysql_query("SELECT * FROM Guilds where Name='$Name'") or die("Could not fetch guild stats");
    $Guild=mysql_fetch_array($Query);
    $Query=mysql_query("Select * from Users where ID='$Player'");
    $User=mysql_fetch_array($Query);
    if($User['Guild'] != "")
      echo "Leave your other guild first before you join a new one.<br /><a href=\"guild.php\">Go back</a>";
    elseif($Guild[Members]==15){
    echo "Guild is full, sorry, go pick another. <a href=fight.php>Go</a>";
    }else
    {
      mysql_query("update Users set Applied='$Name' where ID='$Player'");
      if($Guild['Members'] >= 15)
        echo "You are accepted, but the guild is currently full. you may have to wait an extended amount of time before you are accepted.";
      else
        echo "You applied for the clan. Now wait until either the owner or the coleader accepts you.";
    }
  }
}
elseif(isset($Deny)){
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);

   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot deny users because you are not the leader or coleader of this guild!";
   exit;
   }else{
    $Update="Update Users set Applied='' where ID='$Deny'";
    mysql_query($Update) or die("Could not update player stats");
    print "Player denied.<br /><a href=\"guild.php\">Go back</a>";
   }

}
elseif(isset($Add))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);

   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot add users because you are not the leader or coleader of this guild!";
   exit;
   }else{

  $Addname=str_replace("%20"," ",$Addname);
  $Query=mysql_query("SELECT * from Guilds where Name='$Addname'") or die("Could not get guild stats");
  $Guild=mysql_fetch_array($Query);
  if($Guild['Members'] <= 15)
  {
    $Query2=mysql_query("SELECT * FROM Users where ID='$Add'") or die("Could not get player stats");
    $User=mysql_fetch_array($Query2);
    mysql_query("Update Guilds set Members=Members+'1' where Name='$Addname'") or die("Could not update guilds");
    $Update="Update Users set Guild='$Addname', Applied='' where ID='$Add'";
    mysql_query($Update) or die("Could not update player stats");
    print "Player accepted.<br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
  }
  else
    print "Clan is full, cannot accept player.<br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
  }
}
elseif(isset($Guild))
{
  $Query="SELECT * from Guilds where Name='$Guild'";
  $Query2=mysql_query($Query) or die("Could not get guild stats");
  $Guild=mysql_fetch_array($Query2);
  $Query3="SELECT * from Users where Guild='$Guild[Name]'";
  $Query4=mysql_query($Query3) or die("Could not get user stats");
  print "Guild name: $Guild[Name]<br />Guild Owner: $Guild[Owner]<br />Clan bank: $Guild[Bank]<br />";
  echo "Exp:".number_format($Guild['Exp'])."%<br />";
  echo "Gold:".number_format($Guild['Gold'])."%<br />";
  print "Members:<br /><table id=\"table\"><tr><td>Player</td><td>Level</td></tr>";
  while($topplayer3=mysql_fetch_array($Query4))
  {
    print "<tr><td>$topplayer3[Playername]</td><td>$topplayer3[Level]</td></tr>";
  }
  print "</table>";
}
elseif($Coleader==1)
{
  $Guild=str_replace("%20"," ",$_GET['Guild']);
  $Query="SELECT * from Users where Guild='$Guild' order by Level desc";
  $Query2=mysql_query($Query) or die("Could not get user stats");
  $Guild1="SELECT * from Guilds where Name='$Guild'";
  $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
  $Guild=mysql_fetch_array($Guild2);
  print "<table><tr><td>";
  print "Members:<br /><table id=\"table\"><tr><td>Player</td><td>Level</td></tr>";
  while($Member=mysql_fetch_array($Query2))
  {
    if($Member['Playername']!=$Guild['Owner'])
    {
      $Name=str_replace(" ","%20",$Member['Playername']);
      $Guild=str_replace(" ","%20",$_GET['Guild']);
      print "<tr><td><a href=\"guild.php?coleader=$Name&&Guild=$Guild\">$Member[Playername]<a></td><td>$Member[Level]</td></tr>";
    }
  }
  print "</table><br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
}
elseif($Coleader)
{
  $Name=str_replace("%20"," ",$Coleader);
  $Guild=$_GET['Guild'];
  $Query="Update Guilds set Coleader='$Name' where Name='$Guild'";
  mysql_query($Query) or die("Could not set coleader.");
  echo "Coleader assigned. <a href=\"guild.php?option=Guild%20stats\">Go back</a>";
}
else
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Guild1="SELECT * from Guilds where Name='$User[Guild]'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);

print"<form method=\"post\" action=\"guild.php\">";
print"<select class=\"select\" name=\"option\">";

if($Guild['Name']!=""){

print"<option>Guild stats</option>";
print"<option>Raise your guilds tax</option>";
print"<option>Leave guild</option>";

}else{

print"<option>Create a guild</option>";
print"<option>Join a guild</option>";

}

print"</select>";
print"<input class=\"button\" type=\"submit\" value=\"submit\" name=\"guild\">";
print"</form>";
print"</body>";
}
?>