Akenatehm
-
Posts
262 -
Joined
-
Last visited
Never
Everything posted by Akenatehm
-
Ok. mysql_insert_id is working. But it is still showing that same error.
-
Does Anyone??
-
I used. and If ...Else function. Here's my code: functions.php <?php function mysqlcheck($query) { if (!$query) { die('MySQL Check Error with ' . mysql_error()); } } ?> register.php <?php session_start(); if (isset($_POST['submit'])) { if($_POST['password'] == $_POST['confirmpassword']) { include 'connect.php'; include 'functions.php'; connect(); $username = $_POST['username']; $checkuser = mysql_query("SELECT * FROM accounts WHERE username = '$username'"); mysqlcheck($checkuser); if(mysql_num_rows($checkuser) > 0) { $error = '<font color="red"> User Already Exists </font>'; } else { $activationkey = mt_rand() . mt_rand() . mt_rand() . mt_rand() . mt_rand(); $username = $_POST['username']; $password = $_POST['password']; $email = $_POST['email']; $password = md5($password); $adduser = mysql_query("INSERT INTO accounts (username, password, email, activationkey, last_online) VALUES ('$username' , '$password' , '$email', '$activationkey', '0')"); mysqlcheck($adduser); $findplayerid = mysql_query("SELECT playerid FROM accounts WHERE username = '$username'"); mysqlcheck($findplayerid); $transferplayerid = mysql_fetch_assoc($findplayerid); $playerid = $transferplayerid['playerid']; $createresourcesuser = mysql_query("INSERT INTO resources (playerid,gold,wood,stone) VALUES('$playerid','200','200','200')"); mysqlcheck($createresourceuser); $result = '<font color="green">User Added Succesfully </font>'; } } else { $result = '<font color="red"> Passwords Do Not Match </font>'; } } ?> <html> <head> <title>Registration - Fall of The Empire</title> <?php include 'page_elements.php'; abovenav(); navbar(); ?> <div class="cbtop" align="center"> <img src="images/register.png" width="171" height="25" alt="Register" class="welcome" align="right"> </div> <br><br> <div class="middle"><hr><br> <br> <table width="300px" align="right"> <form action="<?php echo "$PHP_SELF";?>" method="POST"> <tr> <td> <font color="white"> Username: </font> </td> <td> <input type="text" name="username"> </td> </tr> <tr> <td> <font color="white"> Email </font> </td> <td> <input type="text" name="email"> </td> </tr> <tr> <td> <font color="white"> Password: </font> </td> <td> <input type="password" name="password"> </td> </tr> <tr> <td> <font color="white"> Confirm Password: </font> </td> <td> <input type="password" name="confirmpassword"> </td> </tr> <tr> <td> <br> </td> <td> </td> <tr> <td> </td> <td align="right" style="padding-right:8px"> <input type="submit" name="submit" value="Register"align="right"> </td> </tr> <tr> <td> <br> </td> <td> </td> <tr> <td> </td> <td><?php echo $result; ?> </td> </tr> </form> </table> <?php footer(); ?> </body> </html> and it is still showing up with: Do you have any idea why its doing that?
-
I see. I've fixed that. Is there any way to stop a certain amount of code from being executed if something happens?
-
$createresourceuser is a variable in the createresourcesuser() function in functions.php . Is it not possible to check a function with another?
-
Ok, i've fixed those. Now I get this stupid thing: Saying that there is no error and that it is just syaing it... anyone know how to get rid of this?
-
Ok Sweet. I fixed that. But now I am getting this: Any idea how i can get rid of it and make it display the error I already have ?
-
Hey Guys, I thought I'd give creating my own functions a go. I thought I'd try and clean up my code so it doesn't look so messy so I put most of my common functions in a file called functions.php and using include 'functions.php'; I would call on them as needed. But there seems to be a problem with MySQL resources and interchanging them between different functions. I get the following error: On a registration page. Here's functions.php: <?php function mysqlcheck($query) { if (!$query) { die('MySQL Check Error with ' . mysql_error()); } } function userexists() { if(mysql_num_rows($checkuser) > 0) { $error = '<font color="red"> User Already Exists </font>'; } } function activationkey() { $activationKey = mt_rand() . mt_rand() . mt_rand() . mt_rand() . mt_rand(); } function getplayerid($username) { $findplayerid = mysql_query("SELECT playerid FROM accounts WHERE username = '$username'"); } function createresourceuser($playerid) { $createresourcesuser = mysql_query("INSERT INTO resources (playerid,gold,wood,stone) VALUES('$playerid','200','200','200')"); } ?> and register.php: <?php session_start(); if (isset($_POST['submit'])) { if($_POST['password'] == $_POST['confirmpassword']) { include 'connect.php'; include 'functions.php'; connect(); $username = $_POST['username']; $checkuser = mysql_query("SELECT * FROM accounts WHERE username = '$username'"); mysqlcheck("$checkuser"); userexists(); $activationkey = activationkey(); $username = $_POST['username']; $password = $_POST['password']; $email = $_POST['email']; $password = md5($password); $adduser = mysql_query("INSERT INTO accounts (username, password, email, activationkey, last_online) VALUES ('$username' , '$password' , '$email', '$activationkey', '0')"); mysqlcheck($adduser); getplayerid($username); mysqlcheck($findplayerid); $transferplayerid = mysql_fetch_assoc($findplayerid); $playerid = $transferplayerid['playerid']; createresourceuser($playerid); mysqlcheck($createresourceuser); $result = '<font color="green">User Added Succesfully </font>'; } else { $result = '<font color="red"> Passwords Do Not Match </font>'; } } ?> <html> <head> <title>Registration - Fall of The Empire</title> <link rel="stylesheet" href="styles.css" type="text/css"/> </head> <body bgcolor="272d31"> <div align="center" class="header"> <img src="images/logo.png" width="473" height="227" alt="Logo"> </div> <br> <center> <div class="main"> <div class="navbar"> <img src="images/nav_top.png" width="232" height="46" alt="Nav Top"><br> <a href="index.php"><img src="images/nav_home.png" width="232" height="33" alt="Nav Home" border="0"></a><br> <a href="news.php"><img src="images/nav_news.png" width="232" height="32" alt="Nav News" border="0"></a><br> <a href="about.php"><img src="images/nav_about.png" width="232" height="23" alt="Nav About" border="0"></a><br> <a href="login.php"><img src="images/nav_login.png" width="232" height="32" alt="Nav Login" border="0"></a><br> <a href="register.php"><img src="images/nav_register.png" width="232" height="25" alt="Nav Register" border="0"></a><br> <a href="contactus.php"><img src="images/nav_bottom.png" width="232" height="179" alt="Nav Bottom" border="0"><br></a> </div> <div class="cbtop" align="center"> <img src="images/register.png" width="171" height="25" alt="Register" class="welcome" align="right"> </div> <br><br> <div class="middle"><hr><br> <br> <table width="300px" align="right"> <form action="<?php echo $PHP_SELF; ?>" method="POST"> <tr> <td> <font color="white"> Username: </font> </td> <td> <input type="text" name="username"> </td> </tr> <tr> <td> <font color="white"> Email </font> </td> <td> <input type="text" name="email"> </td> </tr> <tr> <td> <font color="white"> Password: </font> </td> <td> <input type="password" name="password"> </td> </tr> <tr> <td> <font color="white"> Confirm Password: </font> </td> <td> <input type="password" name="confirmpassword"> </td> </tr> <tr> <td> <br> </td> <td> </td> <tr> <td> </td> <td align="right" style="padding-right:8px"> <input type="submit" name="submit" value="Register"align="right"> </td> </tr> </form> </table> <p><?php echo $result; ?></p> <p class="heading" align="right"><br><br><br><br><br><br><br><br><br><br></p> <div class="cbbottom" align="center"> <img src="images/bottom.png" width="486" height="25" alt="Bottom" align="center"> </div> </div> <br> </div> </div> </center> </body> </html> Any help, would be greatly appreciated.
-
Anyone?
-
[SOLVED] Error Inserting Correct Details into Database With Script
Akenatehm replied to Akenatehm's topic in PHP Coding Help
Anyone? -
Nothing happened.
-
[SOLVED] Error Inserting Correct Details into Database With Script
Akenatehm replied to Akenatehm's topic in PHP Coding Help
I did that and still nothing happens.. -
Sorry about that. Here goes... <?php if (isset($_COOKIE['username'])) //Trying to check if session exists { $username = $_COOKIE['username']; // Sets variables of their username and pass $pass = $_COOKIE['pass']; $pass = md5($pass); $checkcookie = mysql_query("SELECT * FROM accounts WHERE username = '$username'") or die(mysql_error()); // MySQL query selects username from DB. if (!$checkcookie) { die('MySQL Error' . mysql_error()); } else { $filterresults = mysql_fetch_assoc($checkcookie); $theirusername = $filterresults['username']; // Sets variables of what the query returned as their username and pass. $theirpass = $filterresults['password']; if($username != $theirusername | $pass != $theirpass) //Checks if the username and password in cookie are the same as in db { echo "Incorrect Something"; if (isset($_POST['submit'])) //IF they submit the login form { if($_POST['password']) { $dbhost = "localhost"; $dbuser = "user"; $dbpass = "pass"; $dbname = "game"; $connect = mysql_connect($dbhost,$dbuser,$dbpass); if (!$connect) { die('MySQL Error ' . mysql_error()); } else { $selectdb = mysql_select_db($dbname); if (!$selectdb) { die('MySQL Error ' . mysql_error()); } else { $username = $_POST['username']; // Sets username and pass from form. $pass = $_POST['pass']; $pass = md5($pass); $checkuser = mysql_query("SELECT * FROM accounts WHERE username = '$username'") or die(mysql_error()); //Checks if username exists if (!$checkuser) { die('MySQL Error' . mysql_error()); } else { $filterresults = mysql_fetch_assoc($checkuser); // Sets username and pass from query. $theirusername = $filterresults['username']; $theirpass = $filterresults['pass']; if($username != $theirusername | $pass != $theirpass) // Checks if username and pass are correct. { $error = "Incorrect Username or Password"; } else { session_start(); //Starts session with username and pass of what they put in the form. $_SESSION["username"] = $username; $_SESSION["pass"] = $pass; echo "session created"; } } } } } } } else{ header("Location:gameindex.php"); //Sends them to gameindex.php if cookie exists and is ok. } } } ?> //HTML form.. <html> <head> <title>Login - Fall of The Empire</title> <link rel="stylesheet" href="styles.css" type="text/css"/> </head> <body bgcolor="272d31"> <div align="center" class="header"> <img src="images/logo.png" width="473" height="227" alt="Logo"> </div> <br> <center> <div class="main"> <div class="navbar"> <img src="images/nav_top.png" width="232" height="46" alt="Nav Top"><br> <a href="index.php"><img src="images/nav_home.png" width="232" height="33" alt="Nav Home" border="0"></a><br> <a href="news.php"><img src="images/nav_news.png" width="232" height="32" alt="Nav News" border="0"></a><br> <a href="about.php"><img src="images/nav_about.png" width="232" height="23" alt="Nav About" border="0"></a><br> <a href="login.php"><img src="images/nav_login.png" width="232" height="32" alt="Nav Login" border="0"></a><br> <a href="register.php"><img src="images/nav_register.png" width="232" height="25" alt="Nav Register" border="0"></a><br> <a href="contactus.php"><img src="images/nav_bottom.png" width="232" height="179" alt="Nav Bottom" border="0"><br></a> </div> <div class="cb"> <img src="images/login.png" align="right" class="welcome"> <br> <br> <br> <br> <table width="300px" align="right"> <form action="<?php echo $PHP_SELF; ?>" method="POST"> <tr> <td> <font color="white"> Username: </font> </td> <td> <input type="text" name="username"> </td> </tr> <tr> <td> <font color="white"> Password: </font> </td> <td> <input type="password" name="password"> </td> </tr> <tr> <td> <br> </td> <td> </td> <tr> <td> </td> <td align="right" style="padding-right:8px"> <input type="submit" name="submit" value="Login"align="right"> </td> </tr> </form> </table> <p><?php echo $error; ?></p> </div> </div> </center> </body> </html>
-
Hey Guys, I am havin trouble with this script: <?php if (isset($_COOKIE['username'])) { $username = $_COOKIE['username']; $pass = $_COOKIE['pass']; $pass = ($pass); $checkcookie = mysql_query("SELECT * FROM accounts WHERE username = '$username'") or die(mysql_error()); if (!$checkcookie) { die('MySQL Error' . mysql_error()); } else { $filterresults = mysql_fetch_assoc($checkcookie); $theirusername = $filtertheirusername['username']; $theirpass = $filtertheirusername['pass']; if($username != $theirusername | $pass != $theirpass) { echo "Incorrect Something"; if (isset($_POST['submit'])) { if($_POST['password']) { $dbhost = "localhost"; $dbuser = "user"; $dbpass = "pass"; $dbname = "game"; $connect = mysql_connect($dbhost,$dbuser,$dbpass); if (!$connect) { die('MySQL Error ' . mysql_error()); } else { $selectdb = mysql_select_db($dbname); if (!$selectdb) { die('MySQL Error ' . mysql_error()); } else { $username = $_POST['username']; $pass = $_POST['pass']; $pass = md5($pass); $checkuser = mysql_query("SELECT * FROM accounts WHERE username = '$username'") or die(mysql_error()); echo "Check user failed"; if (!$checkuser) { die('MySQL Error' . mysql_error()); } else { $filterresults = mysql_fetch_assoc($checkuser); $theirusername = $filtertheirusername['username']; $theirpass = $filtertheirusername['pass']; if($username != $theirusername | $pass != $theirpass) { $error = "Incorrect Username or Password"; } else { session_start(); $_SESSION["username"] = $username; $_SESSION["pass"] = $pass; echo "session created"; } } } } } } } else{ header("Location:gameindex.php"); } } } ?> <html> <head> <title>Login - Fall of The Empire</title> <link rel="stylesheet" href="styles.css" type="text/css"/> </head> <body bgcolor="272d31"> <div align="center" class="header"> <img src="images/logo.png" width="473" height="227" alt="Logo"> </div> <br> <center> <div class="main"> <div class="navbar"> <img src="images/nav_top.png" width="232" height="46" alt="Nav Top"><br> <a href="index.php"><img src="images/nav_home.png" width="232" height="33" alt="Nav Home" border="0"></a><br> <a href="news.php"><img src="images/nav_news.png" width="232" height="32" alt="Nav News" border="0"></a><br> <a href="about.php"><img src="images/nav_about.png" width="232" height="23" alt="Nav About" border="0"></a><br> <a href="login.php"><img src="images/nav_login.png" width="232" height="32" alt="Nav Login" border="0"></a><br> <a href="register.php"><img src="images/nav_register.png" width="232" height="25" alt="Nav Register" border="0"></a><br> <a href="contactus.php"><img src="images/nav_bottom.png" width="232" height="179" alt="Nav Bottom" border="0"><br></a> </div> <div class="cb"> <img src="images/login.png" align="right" class="welcome"> <br> <br> <br> <br> <table width="300px" align="right"> <form action="<?php echo $PHP_SELF; ?>" method="POST"> <tr> <td> <font color="white"> Username: </font> </td> <td> <input type="text" name="username"> </td> </tr> <tr> <td> <font color="white"> Password: </font> </td> <td> <input type="password" name="password"> </td> </tr> <tr> <td> <br> </td> <td> </td> <tr> <td> </td> <td align="right" style="padding-right:8px"> <input type="submit" name="submit" value="Login"align="right"> </td> </tr> </form> </table> <p><?php echo $error; ?></p> </div> </div> </center> </body> </html> The script does nothing but refresh the page. I am sure that what I am trying to do will be clear so I won't waste time explaining it. Help would be appreciated.!
-
[SOLVED] Error Inserting Correct Details into Database With Script
Akenatehm replied to Akenatehm's topic in PHP Coding Help
I had there and someone told me to take it out. I added it back. It's still not being added to the db. -
Hey Guys, This script: #!/usr/bin/php -q <?php session_start(); $dbhost = "localhost"; $dbuser = "user"; $dbpass = "pass"; $dbname = "game"; $username = $_SESSION['username']; $connect = mysql_connect($dbhost,$dbuser,$dbpass); $selectdb = mysql_select_db($dbname); if (!$connect | !$selectdb) { die('MySQL Error ' . mysql_error()); } else { $selectplayerid = mysql_query("SELECT playerid FROM accounts"); if (!$selectplayerid) { die("MySQL Error: " . mysql_error()); } $filterplayerid = mysql_fetch_assoc($selectplayerid); $num= mysql_num_rows($selectplayerid); $i=0; while($i<$num) { $playerid = $filterplayerid['playerid']; $getmineinfo = mysql_query("SELECT * FROM userbuildings WHERE playerid = '$playerid' AND buildingid = 1"); if(!$getmineinfo) { die("MySQL Error: " . mysql_error()); } else { $filtermineinfo = mysql_fetch_assoc($getmineinfo); $buildinglevel = $filtermineinfo['level']; $gatherers = $filtermineinfo['gatherers']; $amount = $buildinglevel * $gatherers / 4; $increasegold = mysql_query("UPDATE resources SET gold = gold + '$amount'") or die(mysql_error()); } mysql_query($selectplayerid); $i++; } } ?> Doesn't insert any data into the gold field at all. I had it going before but it inserted the same amount of gold into everyone. I messed around with it and now it doesn't work at all. There seems to be no errors outputting from it.
-
ok its working. tyvm for ur help!
-
I get:
-
Hey Guys, I need a bit of help. Here's my code: <?php session_start(); $dbhost = "localhost"; $dbuser = "user"; $dbpass = "pass"; $dbname = "game"; $connect = mysql_connect($dbhost,$dbuser,$dbpass); $selectdb = mysql_select_db($dbname); if (!$connect | !$selectdb) { die('MySQL Error ' . mysql_error()); } $selectplayerid = mysql_query("SELECT playerid FROM accounts"); if (!$selectplayerid) { die("MySQL Error: " . mysql_error()); } else { $num= mysql_num_rows($selectplayerid); $playerid = $filterplayerid['playerid']; $i=0; while($i<$num) { $filterplayerid = mysql_fetch_assoc($selectplayerid); $getmineinfo = mysql_query("SELECT * FROM userbuildings WHERE playerid = '$playerid' AND buildingid = 1"); if(!$getmineinfo) { die("MySQL Error: " . mysql_error()); } else { $filtermineinfo = mysql_fetch_assoc($getmineinfo); $buildinglevel = $filtermineinfo['level']; $gatherers = $filtermineinfo['gatherers']; $increasegold = mysql_query("UPDATE resources SET gold = gold + 5 WHERE username = '$username'"); } mysql_query($selectplayerid); $i++; } } ?> and it is not adding gold to the resource table in the DB. There seem to be no syntax errors but probably just the way I have written it. Help wud be great.!
-
[SOLVED] Checking if Username Already Exists in the DB
Akenatehm replied to Akenatehm's topic in PHP Coding Help
Omg i cant believe it was something as stupid as that...thanks for ur help. -
[SOLVED] Checking if Username Already Exists in the DB
Akenatehm replied to Akenatehm's topic in PHP Coding Help
Ok, it worked now. But I still have the problem that PHP doesnt know when to say that the username already exists... -
[SOLVED] Checking if Username Already Exists in the DB
Akenatehm replied to Akenatehm's topic in PHP Coding Help
Also. When I try to create the new table it says: -
[SOLVED] Checking if Username Already Exists in the DB
Akenatehm replied to Akenatehm's topic in PHP Coding Help
Ok. Now that i have done this. What will it do? -
[SOLVED] Checking if Username Already Exists in the DB
Akenatehm replied to Akenatehm's topic in PHP Coding Help
Is this what you need: CREATE TABLE `accounts` ( `playerid` int(11) NOT NULL AUTO_INCREMENT, `username` text NOT NULL, `password` text NOT NULL, `last_login` varchar(255) NOT NULL, PRIMARY KEY (`playerid`) ) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 -
Hey Guys, I am trying to fix this script: <?php if (isset($_POST['submit'])) { if($_POST['password'] == $_POST['confirmpassword']) { $password = 'Ok'; $dbhost = "localhost"; $dbuser = "username"; $dbpass = "pass"; $dbname = "game"; $connect = mysql_connect($dbhost,$dbuser,$dbpass); if (!$connect) { die('MySQL Error ' . mysql_error()); } else { $selectdb = mysql_select_db($dbname); if (!$selectdb) { die('MySQL Error ' . mysql_error()); } else { $checkuser = mysql_query("SELECT * FROM accounts WHERE username = '$username'"); if (!$checkuser) { die('MySQL Error' . mysql_error()); } else { if(mysql_num_rows($checkuser) > '1') { $error = '<font color="red"> User Already Exists </font>'; } else { $username = $_POST['username']; $password = $_POST['password']; $password = md5($password); $adduser = mysql_query("INSERT INTO accounts (username, password, last_login) VALUES ('$username' , '$password' , '0')"); if (!$adduser) { die('MySQL Error ' . mysql_error()); } else { $error = '<font color="green">User Added Succesfully </font>'; } } } } } } else { $error = '<font color="red"> Passwords Do Not Match </font>'; } } ?> <html> <head> <title> Game Registration </title> <link rel="stylesheet" href="styles.css" type="text/css"> </head> <body> <center> <table width="300px"> <form action="<?php echo $PHP_SELF; ?>" method="POST"> <tr> <td> Username: </td> <td> <input type="text" name="username"> </td> </tr> <tr> <td> Email </td> <td> <input type="text" name="email"> </td> </tr> <tr> <td> Password: </td> <td> <input type="password" name="password"> </td> </tr> <tr> <td> Confirm Password: </td> <td> <input type="password" name="confirmpassword"> </td> </tr> <tr> <td> </td> <td> <input type="submit" name="submit" value="Register"> </td> </tr> </form> </table> <p><?php echo $error; ?></p> </center> </body> </html> Which is outputting: Even when the user already exists in the Database. It just keeps adding the same username over and over. Help would be great.