SA-MP Forums Archive
[Help] With strcmp in a MySql login script! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [Help] With strcmp in a MySql login script! (/showthread.php?tid=143143)


[Help] With strcmp in a MySql login script! - kariok - 21.04.2010

I'm trying to make this script works for a few days by myself. I dont have many knowledge over arrays so i cant figure out how to do it.
Please help meeeahh!

Quote:

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if (dialogid == login)
{
new query[256];
format(query,sizeof(query),"SELECT `senha` FROM `usuario` WHERE `login` = '%s'",PlayerName(playerid));
mysql_query(query);
mysql_store_result();
PlayerStatistics[playerid][PASSWORD] = mysql_fetch_int();
if(strcmp( inputtext, PlayerStatistics[ playerid ][ PASSWORD ], true ) == 0 ) {
Logged[playerid]==1;
printf("[Login]: O usuario `%s` fez login com sucesso!",PlayerName(playerid));
SendClientMessage(playerid, COR_INFO, "You've been succesfully authed.");
new welcome[256];
format(welcome,sizeof(welcome),"Welcome back '%s' ",PlayerName(playerid));
SendClientMessage(playerid, COR_INFO, welcome);
}
else
{
new welcome[256];
format(welcome,sizeof(welcome),"Bad, bad password. Password entered: '%s' ",inputtext);
SendClientMessage(playerid, COR_BRANCO, welcome);
SendClientMessage( playerid, COR_BRANCO, "Bad, bad password. To avoid lammers you will be automatically disconnected." );
SetTimer("kicklogin", 10000, false);
}
return 0;
}
return 0;
}
I think the problem is in the red part. Im using the a_mysql.inc plugin, that one that almost everyone has.
In the password entered answer, it comes the right one. And in the MySql log:

Quote:

[13:16:25] ---------------------------

[13:16:25] MySQL Debugging activated (04/21/10)

[13:16:25] ---------------------------

[13:16:25]

[13:16:56] >> mysql_query( Connection handle: 1 )

[13:16:56] CMySQLHandler::Query(SELECT `login` FROM `usuario` WHERE `login` = 'Lucca_Xavier') - Successfully executed.

[13:16:56] >> mysql_store_result( Connection handle: 1 )

[13:16:56] CMySQLHandler::StoreResult() - Result was stored.

[13:16:56] >> mysql_num_rows( Connection handle: 1 )

[13:16:56] CMySQLHandler::NumRows() - Returned 1 rows(s)

[13:16:59] >> mysql_query( Connection handle: 1 )

[13:16:59] CMySQLHandler::Query(SELECT `senha` FROM `usuario` WHERE `login` = 'Lucca_Xavier') - Successfully executed.

[13:16:59] >> mysql_store_result( Connection handle: 1 )

[13:16:59] CMySQLHandler::StoreResult() - Result was stored.

[13:16:59] >> mysql_fetch_int( Connection handle: 1 )

[13:16:59] CMySQLHandler::FetchRow() - Return: MYPASSWORD!


Re: [Help] With strcmp in a MySql login script! - kariok - 23.04.2010

just bumping it, i really need an answer.
I can think about remunerating who can solve this for me trough paypal....

Re: [Help] With strcmp in a MySql login script! - Calgon - 23.04.2010

You're trying to load the password as an integer, that won't work. Load it as a STRING.

Re: [Help] With strcmp in a MySql login script! - kariok - 24.04.2010

how can i use the password as a string instead of an integer value?!

Re: [Help] With strcmp in a MySql login script! - Calgon - 24.04.2010

Quote:
Originally Posted by kariok
how can i use the password as a string instead of an integer value?!
mysql_fetch_string()

Not only that, you're not getting any specific field.

I'll update this for you and this shall work.

There's also NO need for a 256-cell string.

This may not work as the field names may be different for you, so make sure you change it all up if you need to.

pawn Код:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
  if (dialogid == login)
  {
        new query[ 128 ], EscapedPass[ 128 ];
        
        mysql_real_escape_string( inputtext, EscapedPass );
        
        format(query,sizeof(query), "SELECT * FROM `usuario` WHERE `login` = '%s' AND `password` = '%s'", PlayerName( playerid ), EscapedPass );
        mysql_query( query );
        mysql_store_result();
        
        if( mysql_num_rows() >= 1 )
        {
          // Success.
        }
        else
        {
          // Failed.
        }
        
        mysql_free_result();
    }
    
    return 1;
}