MySQL changing password
#1

Hi, I want to change my SHA1 password hashing like my register form one.

Can you help?

pawno code

PHP код:
strcat(Query,"INSERT INTO `users` (Username,Password,IP) VALUES ('%s', sha1('%s'),'%s')"); 

register.php

PHP код:
<?php
// Include config file
require_once 'config.php';
 
// Define variables and initialize with empty values
$username $password $confirm_password "";
$username_err $password_err $confirm_password_err "";
 
// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){
 
    
// Validate username
    
if(empty(trim($_POST["username"]))){
        
$username_err "Please enter a username.";
    } else{
        
// Prepare a select statement
        
$sql "SELECT id FROM users WHERE username = ?";
        
        if(
$stmt mysqli_prepare($link$sql)){
            
// Bind variables to the prepared statement as parameters
            
mysqli_stmt_bind_param($stmt"s"$param_username);
            
            
// Set parameters
            
$param_username trim($_POST["username"]);
            
            
// Attempt to execute the prepared statement
            
if(mysqli_stmt_execute($stmt)){
                
/* store result */
                
mysqli_stmt_store_result($stmt);
                
                if(
mysqli_stmt_num_rows($stmt) == 1){
                    
$username_err "This username is already taken.";
                } else{
                    
$username trim($_POST["username"]);
                }
            } else{
                echo 
"Oops! Something went wrong. Please try again later.";
            }
        }
         
        
// Close statement
        
mysqli_stmt_close($stmt);
    }
    
    
// Validate password
    
if(empty(trim($_POST['password']))){
        
$password_err "Please enter a password.";     
    } elseif(
strlen(trim($_POST['password'])) < 6){
        
$password_err "Password must have atleast 6 characters.";
    } else{
        
$password trim($_POST['password']);
    }
    
    
// Validate confirm password
    
if(empty(trim($_POST["confirm_password"]))){
        
$confirm_password_err 'Please confirm password.';     
    } else{
        
$confirm_password trim($_POST['confirm_password']);
        if(
$password != $confirm_password){
            
$confirm_password_err 'Password did not match.';
        }
    }
    
    
// Check input errors before inserting in database
    
if(empty($username_err) && empty($password_err) && empty($confirm_password_err)){
        
        
// Prepare an insert statement
        
$sql "INSERT INTO users (username, password) VALUES (?, ?)";
         
        if(
$stmt mysqli_prepare($link$sql)){
            
// Bind variables to the prepared statement as parameters
            
mysqli_stmt_bind_param($stmt"ss"$param_username$param_password);
            
            
// Set parameters
            
$param_username $username;
            
$param_password password_hash($passwordPASSWORD_DEFAULT); // Creates a password hash
            
            // Attempt to execute the prepared statement
            
if(mysqli_stmt_execute($stmt)){
                
// Redirect to login page
                
header("location: login.php");
            } else{
                echo 
"Something went wrong. Please try again later.";
            }
        }
         
        
// Close statement
        
mysqli_stmt_close($stmt);
    }
    
    
// Close connection
    
mysqli_close($link);
}
?>
Reply
#2

That's a PHP code, not PAWN, and you already know that it has nothing to do with SA-MP PAWN coding. Therefore what you could do is to search on how to hash passwords using sha1 encryption in PHP and just change the on encryption line of your code.

https://stackoverflow.com/questions/...-password-hash
Reply
#3

Actually it's a pawn code for my register system in samp
Reply
#4

Quote:
Originally Posted by Zeus666
Посмотреть сообщение
Actually it's a pawn code for my register system in samp
I'm pretty sure PAWN has nothing to do with PHP? As you said it's a PHP code for your register system in sa-mp which is written in PHP.
Reply
#5

Indeed. This has nothing to do with pawn.
You just have to create a form same as your login form but instead of getting stuff from the table. You have to update the password if the password matches the users password. This is not hard to create at all. I suggest you search for a PHP forum.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)