Albetros Source Register successful but not in db

[Drake68]

When i register it says register seccessful but dont show in db? i trying App Server 2.6.0 Xampp 7.7.1 and Xampp 7.1.1 Any ideas

[turk55]

did you try to read the FAQ ?

[Drake68]

Yeah its just on his old source of Hellmouth. I went threw every page to get to the last page of him saying this is no longer needed. lol

[pro4never]

I'm confused... are you using albetros or hellmouth? (don't use hellmouth fyi)


What are you using to register an account? Make sure you are letting the database handle auto incrementing the UID. All you need to enter is the other fields.

[Drake68]

Im using the one you made a guide for 5517 heres my register page...

<?php
$hostname_localhost = "localhost";
$database_localhost = "presarioco";
$username_localhost = "root";
$password_localhost = "****";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

<div align="center" style="height:600px;">
<?php $currentPage = $_SERVER["PHP_SELF"];
$colname_verify = "-1";
if (isset($_GET['verify'])) {
$colname_verify = $_GET['verify'];

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_localhost, $localhost);
$query_verify = sprintf("SELECT * FROM accounts WHERE emailver = %s", GetSQLValueString($colname_verify, "text"));
$verify = mysql_query($query_verify, $localhost) or die(mysql_error());
$row_verify = mysql_fetch_assoc($verify);
$totalRows_verify = mysql_num_rows($verify);
if($totalRows_verify == 1) {
	mysql_query("UPDATE accounts SET emailver = '' , emailstatus = 1 WHERE emailver = '".$_GET['verify']."'");
	echo 'Thank You for verifying your email address with our Game Server.';
}
?>





<?php } else { ?>
<form method="post" autocomplete='off'>
		<br />
      <input name="account" type="text" class="input" id="unfocused" value="Account Name..." onclick="if (account.value == 'Account Name...') { account.value='' }" onfocus="account.id='focused'" onblur="account.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
        <br />
      <input name="password" type="password" class="input" id="unfocused" value="password..." onclick="if (password.value == 'Password...') { password.value='' }" onfocus="password.id='focused'" onblur="password.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
        <br />
        Re-type Password<br />
        <input name="passwordchk" type="password" class="input" id="unfocused" value="password..." onclick="if (passwordchk.value == 'password...') { passwordchk.value='' }" onfocus="passwordchk.id='focused'" onblur="passwordchk.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
        <br />
      <input name="email" type="text" class="input" id="unfocused" value="Email..." onclick="if (email.value == 'Email...') { email.value='' }" onfocus="email.id='focused'" onblur="email.id='unfocused'" style="margin-bottom: 7px;" maxlength="41"/>
        <br />
      <select name="secquestion" class="input" id="secquestion" style="margin-bottom:7px;">
        <option value="" selected="selected">-Select Secret Question-</option>
        <option value="What is the first name of your favorite uncle?" >What is the first name of your favorite uncle?</option>                   
        <option value="Where did you meet your spouse?" >Where did you meet your spouse?</option>        <option value="What is your oldest cousins name?" >What is your oldest cousins name?</option>                   
        <option value="What is your youngest childs nickname?" >What is your youngest childs nickname?</option>                   
        <option value="What is your oldest childs nickname?" >What is your oldest childs nickname?</option>                   
        <option value="What is the first name of your oldest niece?" >What is the first name of your oldest niece?</option>                   
        <option value="What is the first name of your oldest nephew?" >What is the first name of your oldest nephew?</option>                   
         <option value="What is the first name of your favorite aunt?" >What is the first name of your favorite aunt?</option>                   
         <option value="Where did you spend your honeymoon?" >Where did you spend your honeymoon?</option></select>
         <br />
      <input name="answer" type="text" class="input" id="unfocused" value="Answer..." onclick="if (answer.value == 'Answer...') { answer.value='' }" onfocus="answer.id='focused'" onblur="answer.id='unfocused'" style="margin-bottom: 7px;" maxlength="22"/>
         <br />
      <input name="register" type="submit" class="enter" id="register" value="Submit" />
        <?php

function isValidEmail($value){
$pattern = "/^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/";
return preg_match($pattern, $value);
}
error_reporting(0);
if(isset($_POST['register']))
{
	if(!empty($_POST['account']) && !empty($_POST['password']) && !empty($_POST['email']) && !empty($_POST['secquestion']) && !empty($_POST['answer']) && !empty($_POST['secquestion']))
	{
        if(strlen($_POST['account']) < 23 && strlen($_POST['account']) > 3 && strlen($_POST['password']) < 23 && strlen($_POST['password']) > 3 && $_POST['password'] == $_POST['passwordchk'])
		{
			if(isValidEmail($_POST['email']) && strlen($_POST['email']) < 41)
			{
				if(strlen($_POST['answer']) < 22 && $_POST['secquestion'] != '')
				{
					$check = mysql_query("SELECT * FROM accounts WHERE Username = '".$_POST['account']."'");
					if(mysql_num_rows($check) != '0') 
					{
						die("<br /><center>Username <i>'".$_POST['account']."'</i> is already registered, please use another name.</center>");
					}
					else
					{
						$emailver = substr(str_shuffle(str_repeat('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789',20)),0,20);
						mysql_query("INSERT INTO accounts (Username, Password, Email, question, answer, emailver) VALUES ('".$_POST['account']."', '".$_POST['password']."', '".$_POST['email']."', '".$_POST['secquestion']."', '".$_POST['answer']."', '".$emailver."')");
						echo("<br /><center>Username <i>'".$_POST['account']."'</i> successfully created, make sure to verify your email</center>");

						/* Email Message to sender */
						
						$to      = $_POST['email'];
						$subject = 'Verify your HellmouthCo Account Now';
						$message = "Welcome to Hellmouth: Game Account Verify

Please keep this e-mail for your records. Your account information is as
follows:

----------------------------

Username: " .$_POST['account']. "

----------------------------

Your password has been securely stored in our database and cannot be
retrieved. In the event that it is forgotten, you will be able to reset it
using the email address associated with your account.

Please visit the following link in order to activate your account:												

http://www.hellmouthco.com/testingreg.php?verify=" .$emailver. 
" 
Thank you for registering.

-- 
The Hellmouth Team";

$headers = 'From: ' . "\r\n" .
	'Reply-To: ' . "\r\n" .
	'X-Mailer: PHP/' . phpversion();	
						mail($to, $subject, $message, $headers);
/* End */
						
					}
				}
				else
				{
					die("<br /><center>The answer provided for the question was to long, please try again.</center>");
				}
			}
			else
			{
				die("<br /><center>Email Address is either to long, or not setup right, please try again.</center>");
			}
		}
		else
		{
			die("<br /><center>You're Lengths for Username and or Password is to long/short, or failed to pass password check</center>");
		}
	}
	else
	{
		die("<br /><center>One or more fields missing, please try again.</center>");
	}
}
?>
</form>
<?php } ?>
</div>
</div>

<?php
mysql_free_result($verify);
?>

I looked in navicat and auto incrementing is checked.

[BioHazarxPaul]

hmm its not working interesting, we never really had any issues with it when it was setup on our website...

[Drake68]

Fixed. Just had to recode a new register page thanks guys!

#close