Indie-Resource.com

Code: Select all

$playerinfo="SELECT * from player where name='bryan'";

Code: Select all

mysql_error();

Code: Select all

$sql = mysql_query("SELECT * FROM players WHERE name='$player'") or die("Could not select from players" . mysql_error());

Code: Select all

<?php
include 'connect.php';
?>
<div id="div2">
<link href="style.css" rel="stylesheet" type="text/css"/>

<?php
$playerinfo="SELECT * from player where name='$player'";
$playerinfo2=mysql_query($playerinfo) or die((mysql_error()));
$playerinfo3=mysql_fetch_array($playerinfo2);

$player = $playerinfo3['name'];
$playerhealth = $playerinfo3['health'];
$playertech = $playerinfo3['tech'];
$playerenergy = $playerinfo3['energy'];
$playermaxhealth = $playerinfo3['maxhealth'];
$playermaxtech = $playerinfo3['maxtech'];
$playermaxenergy = $playerinfo3['maxenergy'];
$playermoney = $playerinfo3['credit'];

echo "<table border='1' cellspacing='0' bordercolor=green><tr><td bgcolor='000000'>";
echo "<font color='000000'>" . "&nbsp&nbsp&nbsp&nbsp" . "</font><font size='4'><font color='ffffff'><b> " . $playerhealth . "</font><font color='ffff99'> / " . $playermaxhealth . "<font color='000000'>" . "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</font></font>";
echo "<font color='ffffff'>" . $playertech . "</font><font color='ffff99'>/" . $playermaxtech . "<font color='000000'>" . "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</font></font>";
echo "<font color='ffffff'>" . $playerenergy . "<font color='ffff99'>/" . $playermaxenergy . "<font color='000000'>" . "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</font></font>";
echo "<font color='ffffff'>$" . $playermoney . "</b></font></font><font color='000000'>" . "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<br>";
echo "<font color='000000'>" . "&nbsp&nbsp&nbsp&nbsp&nbsp" . "<font size='1'><font color='ffff99'><b>HEALTH</font>";
echo "<font color='000000'>" . "______________" . "<font size='1'><font color='ffff99'><b>TECH</font>";
echo "<font color='000000'>" . "____________" . "<font size='1'><font color='ffff99'><b>ENERGY</font>";
echo "<font color='000000'>" . "__________" . "<font size='1'><font color='ffff99'><b>CREDIT</font>";
echo "</td></tr></table>";

?>
</div>

<div id= "experiencebar">

<?php
echo "<img src='images/barback.PNG'>";

?>
</div>

<div id= "experience">

<?php
$width = ($playerinfo3['experience'] / $playerinfo3['experienceneeded']) * 105;
echo "<img src='images/redliquid.gif' width='$width' height='19' >";
?>
</div>

Code: Select all

<?php
include 'connect.php';
session_start();
?>
<div id="div2">
<link href="style.css" rel="stylesheet" type="text/css"/>

<?php
if (isset($_SESSION['player']))
{
  $player=$_SESSION['player'];
}
else
{
  echo "Not Logged in <br><br> <A href='login.php'>Login</a>";
  exit;
}

Code: Select all

<?php
include 'connect.php';
?>

<?php
$player=$_POST['player'];
$password=$_POST['password'];
$pass2=$_POST['pass2'];
$player=strip_tags($player);
$email=$_POST['email'];
$email=strip_tags($email);
$classchoice=$_POST['classchoice'];

if ($email == "")
{
echo "You didn't enter a email address!<br>";
echo " <A href='register.php'>Go back</a>";
exit;
}
if ($password==$pass2)
{

$isplayer="SELECT * from player where name='$player'";
$isplayer2=mysql_query($isplayer) or die("Could not query players table");
$isplayer3=mysql_fetch_array($isplayer2);

if(!$_POST['password'] || !$_POST['pass2'])
{
print "You did not enter a password<br>";
echo " <A href='register.php'>Go back</a>";
exit;
}
else if($isplayer3 || strlen($player)>21 || strlen($player)<1)
{
print "There is already a player of that name or the name you specified is over 16 letters or less than 1 letter";
echo " <A href='register.php'>Go back</a><br>";
exit;
}
else
{
$isaddress="SELECT * from player where email='$email'";
$isaddress2=mysql_query($isaddress) or die("not able to query for password");
$isaddress3=mysql_fetch_array($isaddress2);
if($isaddress3)
{
print "There is already a player with that e-mail address";
echo " <A href='register.php'>Go back</a><br>";
exit;
}
else
{
$password=md5($password);

 //////////////////////////////new for video 9//////////////
 $classquery="SELECT * from class where class='$classchoice'";
  $classquery2=mysql_query($classquery) or die("Could not query classes" . mysql_error());
  $classquery3=mysql_fetch_array($classquery2);

$SQL = "INSERT into player(id, name, password, email, level, experience, class, health, maxhealth, tech, maxtech, energy, maxenergy, attack, defence, credit, experienceneeded) VALUES ('','$player','$password','$email','1','0','$classquery3[class]','$classquery3[health]','$classquery3[maxhealth]','$classquery3[tech]','$classquery3[maxtech]','$classquery3[maxenergy]','$classquery3[attack]','$classquery3[defense]','0','30')";
mysql_query($SQL) or die ("Could not register." . mysql_error());

print "Thank you for registering!";

}
}
}

else
{
print "Your password didn't match or you did not enter a password";
echo " <A href='register.php'>Go back</a><br>";
exit;
}
 echo " <A href='login.php'>Login Page</a><br>";
?>

Code: Select all

<?php
include_once 'connect.php';
session_start();

if (isset($_POST['submit']))
{
   $player=$_POST['player'];
   $password=$_POST['password'];
   $player=strip_tags($player);
   $password=strip_tags($password);
   $password=md5($password);

   $query = "select name,password from player where name='$player' and '$password'";
   $result = mysql_query($query) or die("Could not query players");
   $result2 = mysql_fetch_array($result);
   if ($result2)
   {
      $_SESSION['player']=$player;

      echo "<big>Logged in successfully<br>";
      echo "<a href='home.php'>Continue</a></big>";
   }
   else
   {
    echo "<big>Wrong username or password.<a href='login.php'>Try Again</a></big>";
   }
}
?>