Quote:
Originally Posted by godman2
Here the good ... only register.php download change Account and pass... and have fun!
|
"localhost", 'user' => "sa", 'pass' => "server" ); echo "
"; if($_POST['activ'] == '1') { $con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']); $result1 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_id = '".$_POST['accname']."'",$con); $result2 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_id = '".$_POST['accname']."'",$con); $result3 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_mail = '".$_POST['accmail']."'",$con); $row1 = mssql_num_rows($result1); $row2 = mssql_num_rows($result2); $row3 = mssql_num_rows($result3); $dk_time=strftime("%y%m%d%H%M%S"); list($usec1, $sec1) = explode(" ",microtime()); $dk_user_no=$dk_time.substr($usec1,2,2); if(empty($_POST['accname']) || empty($_POST['accpass1']) || empty($_POST['accpass2'])|| empty($_POST['accname']) || empty($_POST['accmail'])) { echo "
You didnt fill in all fieldsGo Back"; } elseif($row1 > '0' || $row2 > '0') { echo "
This Account name already exists.Go Back"; } elseif($row3 > '0') { echo "
This E-Mail is already in use.Go Back"; } elseif($_POST['accpass1'] != $_POST['accpass2']) { echo "
The passwords did not matchGo Back"; } elseif($_POST['accpass1'] == $_POST['accname']) { echo "
Account name and password are the same.Go Back"; } elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $_POST['accname'])) { echo "
Enter a account name only with 0-9 , a-z and A-Z.Go Back"; } elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $_POST['accpass1'])) { echo "
Enter a password only with 0-9 , a-z and A-Z.Go Back"; } elseif(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$_POST['accmail'])) { echo "
Your e-Mail is not correct.Go Back"; } elseif(strlen($_POST['accname']) < 3 || strlen($_POST['accname']) > 15) { echo "
The Accountname must at least 3 indications long and may maximally 15 indications long.Go Back"; } elseif(strlen($_POST['accpass1']) < 3 || strlen($_POST['accpass1']) > 15) { echo "
The Password must at least 3 indications long and may maximally 15 indications long.Go Back"; } else { $accpass = md5($_POST['accpass1']); mssql_query("INSERT INTO account.dbo.USER_PROFILE (user_no,user_id,user_pwd,resident_no,user_type,lo gin_flag,login_tag,ipt_time,login_time,logout_time ,user_ip_addr,server_id) VALUES ('$dk_user_no','".$_POST['accname']."','".$accpass."','801011000000','1','0','Y','".$ date."',null,null,null,'000')",$con); mssql_query("INSERT INTO account.dbo.Tbl_user (user_no,user_id,user_pwd,user_mail,user_answer,us er_question) VALUES ('$dk_user_no','".$_POST['accname']."','".$_POST['accpass1']."','".$_POST['accmail']."','0','0')",$con); echo "
The account was successfully created. Have fun !
"; echo "
Here is your login info again:
"; echo "
Your account name is: ".$_POST['accname']."
"; echo "
Your password is: ".$_POST['accpass1']."
"; echo "DO NOT LOOSE THIS INFO, YOU MAY WRITE IS DOWN AND HIDE IT"; } } else { $con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']); $result1 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE",$con); $row1 = mssql_num_rows($result1); echo "
This time we have ".$row1." Registed Accounts on our Server
Join us.
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
Your Account Info
Account Name
Password
Again pass.
Other account info
Email
"; echo "
"; } echo "
"; ?>