Indie-Resource.com

sounds like a DB issue. no caps or anything?

maybe you made "e-mail" instead of "email" i did that first.

Zerk wrote:At this point all I get is "could not register"

I realize this comes from the following line:

Code: Select all

$SQL = "INSERT into player(name, password, email, level, exper, attack, defense, hpoints, maxhp, spoints, maxspoints) VALUES ('$player','$password','$email','1','0','$classquery3[attack]','$classquery3[defense]','$classquery3[hpoints]','$classquery3[hpoints]','$classquery3[spoints]','$classquery3[spoints]')";
mysql_query($SQL) or die("could not register");

but I can't figure out what I have wrong. I've checked my data base for correctness (looks same as halls') many times. If there is nothing wrong with this script, why will it not register?

has to be

hey, when i try logging into my game, after 9b or something

i have to use the 32 length password and i cant use the one i made when i registered

when i try logging in without my 32 length password or something like that, it says "Wrong Username or Password" Go Back

here is my login.php code: here is my authenticate.php code: here is my reguser.php:
<?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 players 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 players 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 classes where name='$classchoice'";
$classquery2=mysql_query($classquery) or die("Could not query classes");
$classquery3=mysql_fetch_array($classquery2);

$SQL = "INSERT into players(name, password, email, level, exper, attack, defense, hpoints, maxhp, spoints, maxspoints) VALUES ('$player','$password','$email','1','0','$classquery3[attack]','$classquery3[defense]','$classquery3[hpoints]','$classquery3[hpoints]','$classquery3[spoints]','$classquery3[spoints]')";
mysql_query($SQL) or die("could not register");

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>";
?>
and register.php
<?php
include 'connect.php';

?>

<form method ="post" action="reguser.php">
Type Username Here: <input type="text" name="player" size="21"><br>
Type Password Here: <input type="text" name="password" size "15"><br>
ReType Password Again: <input type="text" name="pass2" size "15"><br>
Type Email Address: <input type="text" name="email" size "60"><br>

<input type="submit" value="submit">


<?php
print "<select name='classchoice' length='20'>";
$classinfo="SELECT * from classes";
$classinfo2=mysql_query($classinfo) or die("Could not select classes");
while ($classinfo3=mysql_fetch_array($classinfo2))
{
print "<option>$classinfo3[name]</option>";
}
print "</select><br>";
?>
</form>
<?php

print "<center><h3>Class Starting modifiers</h3></center>";
print "<center>";
print "<table border='0' width='70%' cellspacing='20'>";
print "<tr><td width='25%' valign='top'>";
print "</td>";
print "<td valign='top' width='75%'>";
$selectclass="SELECT * from classes";
$selectclass2=mysql_query($selectclass) or die("could not select Classes");
print "<table border='1' bordercolor='black' bgcolor='#ffffff'>";
print "<tr><td><font color='cc0033'>Class<font color='ffffff'>_____________</td><td><font color='cc0033'>Attack<font color='ffffff'>_</font><td><font color='cc0033'>Defense<font color='ffffff'>_</font></td><td><font color='cc0033'>Hit Points<font color='ffffff'>_</font></td><td><font color='cc0033'>Spell Points<font color='ffffff'>_</font></td></tr>";
while($selectclass3=mysql_fetch_array($selectclass2))
{
print "<tr><td>$selectclass3[name]</td><td>$selectclass3[attack]</td><td>$selectclass3[defense]</td><td>$selectclass3[hpoints]</td><td>$selectclass3[spoints]</td></tr>";

}
print "</table>";
print "</td></tr></table>";
print "</center>";


?>

if you guys could help, thank you very much! also, when i do get logged in, (useing length 32 pass) i add stuff to the store, and when im logged in, theres nothing...

so thanks if you help

store.php code: buyitem.php
PLEASE HELP! THANKS

So you are actually having to login by typing your 32-character MD5'd password? That is strange. I read it and thought "This is easy, he isn't MD5'ing the password on the authenticate script", but that obviously isn't the case. I will need more time to look at this, but maybe someone else will figure it out first

ok, thanks

i will wait for some more people

in authenticate.php, change:

$query = "select name,password from players where name='$player' and '$password'";

to:

$query = "select name,password from players where name='$player' and password='$password'";

and see if that makes a difference

With the store issue

Have you created different location? The item can be in one store and not another.
Have you set up levels with you items? Make sure your character is correct level for the item. Make sure that your spelling is the same on all your items, pages, scripts, data bases, and make sure that you check your capitalazation is the same. I put everything in lower case until i get the script to work and then change 1 thing at a time until I know it works. Remember that "Warrior" is not the same as "warrior" in programing. I found that most of my problems were in my data bases and not the script.

Hope this helps

thanks oldrod and thanks kirbie!

Kirbie wrote:With the store issue

Have you created different location? The item can be in one store and not another.
Have you set up levels with you items? Make sure your character is correct level for the item. Make sure that your spelling is the same on all your items, pages, scripts, data bases, and make sure that you check your capitalazation is the same. I put everything in lower case until i get the script to work and then change 1 thing at a time until I know it works. Remember that "Warrior" is not the same as "warrior" in programing. I found that most of my problems were in my data bases and not the script.

Hope this helps

That is a pretty good error check list there