);
$name = stripslashes($_GET['accountname']);
$email = stripslashes($_GET['email']);
$pw = stripslashes($_GET['password']);
$cpw = stripslashes($_GET['repassword']);
$sql_email_check = mssql_query("SELECT mail_addr FROM MEMB_INFO WHERE mail_addr='$email'");
$sql_username_check = mssql_query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='$login'");
$email_check = mssql_num_rows($sql_email_check);
$username_check = mssql_num_rows($sql_username_check);
if (($email_check > 0) || ($username_check > 0) )
{
echo "<font color='red' size='5'> Error:</font><br />";
if (empty($login) || empty($name) || empty($email) || empty($pw) || empty($cpw))
{
echo "<h2>Hay dien day du thong tin.</h2>";
**elseif($email_check > 0){
echo "<h2>'$email' da co nguoi su dung!</h2><br />";
$Error=1;
**
elseif ($username_check > 0)
{
echo "<h2>'$login' da co nguoi su dung.</h2><br />";
$Error=1;
**elseif ($pw != $cpw)
{
echo "<br /><h2>Mat khau khong trung nhau.</h2>"; $Error=1;
**
**
else
{
//$msquery1 = "SET IDENTITY_INSERT MEMB_INFO ON";
$msquery2 = "INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code) VALUES ('$login',CONVERT(varbinary(16),'0x00'),'$name','1','$email','01/01/2006','01/01/2006','01/01/2006','01/01/2006','1','0','1')";
//$msresults= mssql_query($msquery1);
$msresults= mssql_query($msquery2);
// Executando procedure para atualizar senha
$a= "exec Encripta '".$pw."','".$login."'";
$b=mssql_query($a);
echo "<p align='center'>Accounts successfully created.</p> <br><p align='left'>
Login ID: $login<br>
Name: $name <br>
E-mail: $email<br>
ID Number: $idnumb<br>
Password: $pw<br>
Question: $sques<br>";
**
?>
