how to make a register page

[games2010]

can anyone give me a link for how to make a register page ? ? a video or steps ? ? ? the old register page post is dead video wont work ...
this is the old post link


Thanks . . .

[.Genome.]

It's pretty simple to make one.

Look up:
- PHP form submission
- mssql commands for php
- SQL commands

php makes your form, php uses mssql, and mssql uses sql syntax. Other than that you should know the database layout and which tables are used in account registration.

[bubalowski]

PM ME i can help you with registration

[Ancient95]

Guys help me i cant make another reg in my dk server... i have only mine and i cant make another pelase help ;s

PM ME PLEASE

[Farius~]

1. Go To And Download.

2. Go To c:/xampp/htcdos

3. create new file with name: register.php

Pasted This Code:

<?php

// fill in your mssql info here
$mssql = array(
        'host' => "localhost",
        'user' => "sa",
        'pass' => "server"
    );

function anti_injection($sql) {
   $sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);
   $sql = trim($sql);
   $sql = strip_tags($sql);
   $sql = addslashes($sql);
   return $sql;
}


echo "<center>";

if($_POST['activ'] == '1') {

        $accname = anti_injection($_POST['accname']);
        $accmail = anti_injection($_POST['accmail']);
        
        $accpass1 = anti_injection($_POST['accpass1']);
        $accpass2 = anti_injection($_POST['accpass2']);
    
        $con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);

        $result1 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_id = '".$accname."'",$con);
        $result2 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_id = '".$accname."'",$con);
        $result3 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_mail = '".$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($accname) || empty($accpass1) || empty($accpass2)|| empty($accname) || empty($accmail)) {
            echo "<br>You didnt fill in all fields<a href='javascript:history.back()'>Go Back</a>";
        } elseif($row1 > '0' || $row2 > '0') {
            echo "<br>This Account name already exists.<a href='javascript:history.back()'>Go Back</a>";
        } elseif($row3 > '0') {
            echo "<br>This E-Mail is already in use.<a href='javascript:history.back()'>Go Back</a>";
        } elseif($accpass1 != $accpass2) {
            echo "<br>The passwords did not match<a href='javascript:history.back()'>Go Back</a>";
        } elseif($accpass1 == $accname) {
            echo "<br>Account name and password are the same.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accname)) {
            echo "<br>Enter a account name only with 0-9 , a-z and A-Z.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accpass1)) {
            echo "<br>Enter a password only with 0-9 , a-z and A-Z.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$accmail)) {
            echo "<br>Your e-Mail is not correct.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(strlen($accname) < 3 || strlen($accname) > 15) {
            echo "<br>The Accountname must at least 3 indications long and may maximally 15 indications long.<a href='javascript:history.back()'>Go Back</a>";
        } elseif(strlen($accpass1) < 3 || strlen($accpass1) > 15) {
            echo "<br>The Password must at least 3 indications long and may maximally 15 indications long.<a href='javascript:history.back()'>Go Back</a>";
        } else {

            $accpass = md5($accpass1);

            mssql_query("INSERT INTO account.dbo.USER_PROFILE (user_no,user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) VALUES ('$dk_user_no','".$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,user_question) VALUES ('$dk_user_no','".$accname."','".$accpass1."','".$accmail."','0','0')",$con);

            echo "<center><b><u>The account was successfully created. Have fun !</b></u></center><br><br>";
            echo "<center>Here is your login info again:</center>";
            echo "<center>Your account name is: <b>".$accname."</b></center>";
            echo "<center>Your password is: <b>".$accpass1."</b></center>";
            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 "<center><b><u>This time we have ".$row1." Registed Accounts on our Server<br>Join us.</b></u></center><br>";
    echo "<form action='".$_SEVER['PHP_SELF']."' method='POST'>";
    echo "<center><table>";
    echo "<tr><td colspan='2' align='center'><b><u>Your Account Info</u></b></td></tr>";
    echo "<tr><td>Account Name</td><td><input type='text' name='accname' maxlength='12'></td></tr>";
    echo "<tr><td>Password</td><td><input type='password' name='accpass1' maxlength='12'></td></tr>";
    echo "<tr><td>Again pass.</td><td><input type='password' name='accpass2' maxlength='12'></td></tr>";
    echo "<tr><td>&nbsp;</td><td>&nbsp;</td></tr>";
    echo "<tr><td colspan='2' align='center'><b><u>Other account info</u></b></td></tr>";
    echo "<tr><td>Email</td><td><input type='text' name='accmail' maxlength='50'></td></tr>";
    echo "<tr><td>&nbsp;</td><td>&nbsp;</td></tr>";
    echo "<tr><td colspan='2' align='center'>
        <input type='hidden' name='activ' value='1'>
        <input type='submit' value='Create Account'></td></tr>";
    echo "</table></center>";
    echo "</form>";

}

echo "</center>";

?>

Remember Config This:

$mssql = array(
        'host' => "localhost",
        'user' => "sa",
        'pass' => "server"

and open yours Browser, and put: localhost/register.php.

[zombeke28]

Can anyone help please, Thank you[IMG=expandable: 1]file:///C:/Users/Click/Pictures/Capture.PNG[/IMG]

Cany anyone help with this error?

2:16:40 AM [Apache] Error: Apache shutdown unexpectedly.
2:16:40 AM [Apache] This may be due to a blocked port, missing dependencies,
2:16:40 AM [Apache] improper privileges, a crash, or a shutdown by another method.
2:16:40 AM [Apache] Press the Logs button to view error logs and check
2:16:40 AM [Apache] the Windows Event Viewer for more clues
2:16:40 AM [Apache] If you need more help, copy and post this
2:16:40 AM [Apache] entire log window on the forums