[Release][Website Avalon No Bugged]

[.Arrogunz™]

Originally Posted by glossypvp

And by the way OPTool is made by me.

Brah.. We all know it xD

[glossypvp]

That's the sad fact that not everyone know it. For example when levin bought the optool from u, he didn't even know who is glossy, and who made the optool.

And the other sad factj now everyone know it, and still trading with it, and 0 money goes to me. Gaining money with someone else's work, YEP, It's all I ever wanted

[stotterer09]

Originally Posted by glossypvp

That's the sad fact that not everyone know it. For example when levin bought the optool from u, he didn't even know who is glossy, and who made the optool.

And the other sad factj now everyone know it, and still trading with it, and 0 money goes to me. Gaining money with someone else's work, YEP, It's all I ever wanted

I know that feelin bro^^

[glossypvp]

Originally Posted by stotterer09

I know that feelin bro^^

Should I finally release the optool? So kids like levin can't sell it anymore.

[.Arrogunz™]

Originally Posted by glossypvp

Should I finally release the optool? So kids like levin can't sell it anymore.

Do it, with tut I still dont know how to use it xDD Just errors *-*

[TinLevin]

Originally Posted by glossypvp

That's the sad fact that not everyone know it. For example when levin bought the optool from u, he didn't even know who is glossy, and who made the optool.

And the other sad factj now everyone know it, and still trading with it, and 0 money goes to me. Gaining money with someone else's work, YEP, It's all I ever wanted

I'm know that tool is created by you. and I did not give him any money!

Originally Posted by .Arrogunz™

Do it, with tut I still dont know how to use it xDD Just errors *-*

I fixed the errors and I think now you should sell shiny. Because he created the tool!
only he can sell the tool

[Weom]

- Register script:

PHP Code:

// Process the POST data.
if(isset($_POST) && !empty($_POST)){
    // Validate user name.
    if(empty($username)){
        $errors[] = 'Please provide a user name.';
    }else if(strlen($username) < 3 || strlen($username) > 16){
        $errors[] = 'User name must be between 3 and 16 characters in length.';
    }else if(ctype_alnum($username) === false){
        $errors[] = 'User name must consist of numbers and letters only.';
    }else{
        
        // Check if username already exists in the database.
        $sql = "SELECT szUserID FROM TGLOBAL_GSP.dbo.TACCOUNT WHERE szUserID = ?";
        $stmt = odbc_prepare($GLOBALS['dbConn'],$sql);
        $args = array($username);
        if(!odbc_execute($stmt,$args)){
            $errors[] = 'Failed to determine if this username already exists in the database.';
        }elseif($row = odbc_fetch_array($stmt)){
            $errors[] = 'User name already exists, please choose a different user name.';
        }
    }
    
    // Validate user password.
    if(empty($password)){
        $errors[] = 'Please provide a password.';
    }else if(strlen($password) < 3 || strlen($password) > 16){
        $errors[] = 'Password must be between 3 and 16 characters in length.';
    }else if($password != $password2){
        $errors[] = 'Passwords do not match.';
    }
    
    // Validate reCAPTCHA.  This is to prevent someone botting account creation.
    $response = recaptcha_check_answer($recaptcha_private_key,$_SERVER['REMOTE_ADDR'],$_POST['recaptcha_challenge_field'],$_POST['recaptcha_response_field']);
    if(!$response->is_valid){
        if($response->error == 'incorrect-captcha-sol'){
            $errors['recaptcha'] = 'Incorrect answer to reCAPTCHA';
        }else{
            $errors['recaptcha'] = $response->error;
        }
    }
    
    // Persist the new account to the database if no previous errors occured.
    if(count($errors) == 0){        
        $Salt = md5($password);        
        $sql = "INSERT INTO TGLOBAL_GSP.dbo.TACCOUNT
                (szUserID,szPasswd,bCheck)
                VALUES (?,'$Salt',1)";
        $stmt = odbc_prepare($GLOBALS['dbConn'],$sql);
        $args = array($username,$password,$user_ip);
        if(odbc_execute($stmt,$args)){
            $success = htmlentities("Account {$username} successfully created!");
        }else{
            // This means the insert statement is probably not valid for your database.  Fix the query or fix your database, your choice ;)
            $errors[] = 'Failed to create a new account, please try again later';
        }
    }
} 


Your script:

PHP Code:

// Process the POST data.
if(isset($_POST) && !empty($_POST)){
    // Validate user name.
    if(empty($username)){
        $errors[] = 'Please provide a user name.';
    }else if(strlen($username) < 6 || strlen($username) > 16){
        $errors[] = 'User name must be between 6 and 16 characters in length.';
    }else if(ctype_alnum($username) === false){
        $errors[] = 'User name must consist of numbers and letters only.';
    }else{
        
        // Check if username already exists in the database.
        $sql = "SELECT szUserID FROM TGLOBAL_GSP.dbo.TACCOUNT WHERE szUserID = ?";
        $stmt = odbc_prepare($GLOBALS['dbConn'],$sql);
        $args = array($username);
        if(!odbc_execute($stmt,$args)){
            $errors[] = 'Failed to determine if this username already exists in the database.';
        }elseif($row = odbc_fetch_array($stmt)){
            $errors[] = 'User name already exists, please choose a different user name.';
        }
    }
    
    // Validate user password.
    if(empty($password)){
        $errors[] = 'Please provide a password.';
    }else if(strlen($password) < 6 || strlen($password) > 16){
        $errors[] = 'Password must be between 6 and 16 characters in length.';
    }else if($password != $password2){
        $errors[] = 'Passwords do not match.';
    }
        
    // Persist the new account to the database if no previous errors occured.
    if(count($errors) == 0){        
        $Salt = ($password);        
        $sql = "INSERT INTO TGLOBAL_GSP.dbo.TACCOUNT
                ( szUserID,szPasswd,bCheck)
                VALUES (?,'$Salt',1)";
        $stmt = odbc_prepare($GLOBALS['dbConn'],$sql);
        $args = array($username,$password,$user_ip);
        if(odbc_execute($stmt,$args)){
            $success = htmlentities("Account {$username} successfully created!");
        }else{
            // This means the insert statement is probably not valid for your database.  Fix the query or fix your database, your choice ;)
            $errors[] = 'Failed to create a new account, please try again later';
        }
    }
} 


[julianjl]

And the db ???

[TinLevin]

Originally Posted by julianjl

And the db ???

Website not created by me.
I just I published to help people

[.Arrogunz™]

Originally Posted by TinLevin

Don't is my work O.o
I just published to help people

[Ib3s]

Originally Posted by TinLevin

Don't is my work O.o
I just published to help people

wow, such english

[TinLevin]

Originally Posted by Ib3s

wow, such english

what ?