MySQL UCP
#1

Hello, So I basically, I took another Cops and Robbers script's UCP (California Cops and Robbers) and thought that I would use it for my Cops and Robbers server (the CCNR script was further developed from the script I'm using). So here is the default "check.php" that checks the login.

Код:
 <?php
	session_start();
	include "koneksi.php";
	if(isset($_SESSION['playername']))
	{
		go('index.php', 'You already logged in.');
	}
	if(!isset($_POST['username'], $_POST['password']))
	{
		go('index.php', 'Please fillout all required forms.');
	}
	else
	{
		$query = $koneksi->prepare("SELECT `level`,`name` from `player` where `name` = ? and `password` = ?");
		$query->execute(array($_POST['username'], strtoupper(hash("whirlpool", $_POST['password']))));
		if($query->rowCount() > 0)
		{
			$data = $query->fetch();
			go('index.php', 'Succesfully logged in.');
			$_SESSION['playername'] = $data['name'];
			$_SESSION['playerlevel'] = $data['level'];
		}
		else
		{
			go('index.php', 'Wrong username or password.');
		}
	}
And here I modified it because the rows had different names of the script I'm using, Then it looks like this. But then I keep getting "Wrong username or password"

Код:
<?php
	session_start();
	include "koneksi.php";
	if(isset($_SESSION['playername']))
	{
		go('index.php', 'You already logged in.');
	}
	if(!isset($_POST['username'], $_POST['password']))
	{
		go('index.php', 'Please fillout all required forms.');
	}
	else
	{
		$query = $koneksi->prepare("SELECT `playerLevel`,`playerName` from `playerdata` where `name` = ? and `password` = ?");
		$query->execute(array($_POST['username'], strtoupper(hash("whirlpool", $_POST['password']))));
		if($query->rowCount() > 0)
		{
			$data = $query->fetch();
			go('index.php', 'Succesfully logged in.');
			$_SESSION['playername'] = $data['name'];
			$_SESSION['playerlevel'] = $data['level'];
		}
		else
		{
			go('index.php', 'Wrong username or password.');
		}
	}
Reply
#2

Bump
Reply
#3

Try this code:

PHP код:
<?php
    session_start
();
    include 
"koneksi.php";
    
    if(isset(
$_SESSION['playername']))
    {
        
go('index.php''You already logged in.');
    }
    if(!isset(
$_POST['username'], $_POST['password']))
    {
        
go('index.php''Please fillout all required forms.');
    }
    else
    {
        
$username mysql_real_escape_string($_POST['username']);
        
$password mysql_real_escape_string($_POST['password']);
        
        
$hashedpw strtoupper(hash("whirlpool"$_POST['password']));
        
        
$check get_row("SELECT `playerLevel`,`playerName` from `playerdata` where `name` = '$username' and password = '$hashedpw'");
        if(isset(
$check['playerLevel']))
        {
            
go('index.php''Succesfully logged in.');
            
            
$_SESSION['playername'] = $check['name'];
            
$_SESSION['playerlevel'] = $check['level'];
        }
        else
        {
            
go('index.php''Wrong username or password.');
        }
    }
    
?>
Reply
#4

I get this error when logging in, doesn't show "Wrong username or password."

Код:
( ! ) Deprecated: mysql_real_escape_string(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in G:\wamp\www\check.php on line 15
Call Stack
#	Time	Memory	Function	Location
1	0.0557	251296	{main}( )	..\check.php:0
2	0.2266	262832	mysql_real_escape_string ( )	..\check.php:15

( ! ) Fatal error: Call to undefined function get_row() in G:\wamp\www\check.php on line 20
Call Stack
#	Time	Memory	Function	Location
1	0.0557	251296	{main}( )	..\check.php:0
Reply
#5

Quote:
Originally Posted by Melktert
Посмотреть сообщение
I get this error when logging in, doesn't show "Wrong username or password."

Код:
( ! ) Deprecated: mysql_real_escape_string(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in G:\wamp\www\check.php on line 15
Call Stack
#	Time	Memory	Function	Location
1	0.0557	251296	{main}( )	..\check.php:0
2	0.2266	262832	mysql_real_escape_string ( )	..\check.php:15

( ! ) Fatal error: Call to undefined function get_row() in G:\wamp\www\check.php on line 20
Call Stack
#	Time	Memory	Function	Location
1	0.0557	251296	{main}( )	..\check.php:0
Replace this thing

PHP код:
        $username mysql_real_escape_string($_POST['username']);
        
$password mysql_real_escape_string($_POST['password']); 
with this one

PHP код:
$username $_POST['username'];
 
$password $_POST['password']; 
For get_row() error, put this thing somewhere after the opening <?php thing at the top



PHP код:
function get_row($q)
{
     
$pq mysql_query($q);
     if(
$pq === FALSE) {
    die(
mysql_error()); // better error handling
}
     
     
$p mysql_fetch_array($pq); // fetching the array
     
return $p;

Reply
#6

Код:
( ! ) Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in G:\wamp\www\check.php on line 5
Call Stack
#	Time	Memory	Function	Location
1	0.0020	254024	{main}( )	..\check.php:0
2	0.0205	265264	get_row( )	..\check.php:32
3	0.0205	265312	mysql_query ( )	..\check.php:5
No database selected
Reply
#7

Quote:
Originally Posted by Melktert
Посмотреть сообщение
Код:
( ! ) Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in G:\wamp\www\check.php on line 5
Call Stack
#	Time	Memory	Function	Location
1	0.0020	254024	{main}( )	..\check.php:0
2	0.0205	265264	get_row( )	..\check.php:32
3	0.0205	265312	mysql_query ( )	..\check.php:5
No database selected
Show me the full page of "koneksi.php"
Reply
#8

mysql_ function is deprecated and afaik, already removed on PHP 7.
You can hide that error by adding
error_reporting(0); or error_reporting(E_ALL &~ E_DEPRECATED);
at top of your script.
Reply
#9

Quote:
Originally Posted by X337
Посмотреть сообщение
mysql_ function is deprecated and afaik, already removed on PHP 7.
You can hide that error by adding
error_reporting(0); or error_reporting(E_ALL &~ E_DEPRECATED);
at top of your script.
He could do this but is not really recommended for using. Best way for him is fixing that error.
Reply
#10

Quote:
Originally Posted by buburuzu19
Посмотреть сообщение
He could do this but is not really recommended for using. Best way for him is fixing that error.
The only way to fix that error, is just using mysqli or PDO.
So there's no way to fix that error, except using mysqli, PDO, or hide deprecated warning.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)