Mysql problem
#6

Let me try something.
_____________________
EDIT:
This line gives me doubts:
pawn Код:
mysql_fetch_field("password", pPassword[playerid])
I think its parameters are:
pawn Код:
mysql_fetch_field(value, destination[]);

//---Example:
new save_here[40];
mysql_fetch_field(2, save_here);
I mean, you're using it wrong.

Are you using BlueG's MySQL plugin?

Try with this:
pawn Код:
new query[128], data[256];
GetPlayerName(playerid, pPseudo[playerid], sizeof(pPseudo[]));
format(query,128, "SELECT * FROM members WHERE pseudo = '%s' LIMIT 1", pseudo[playerid]);
mysql_query(query), mysql_store_result();
if(mysql_num_rows())
{
    new sConnexion[128];
    format(sConnexion, sizeof(sConnexion), "{009FFB}Hello, {0032FB}%s !\n\n{009FFB}Please enter your password :", pPseudo[playerid]);
    ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Connexion", sConnexion, "Connexion", "Exit");
} else {
    //Register dialog here.
}
Reply


Messages In This Thread
Mysql problem - by Urefeu - 02.07.2012, 17:04
Respuesta: Mysql problem - by [DOG]irinel1996 - 02.07.2012, 17:13
Re: Mysql problem - by Urefeu - 02.07.2012, 18:42
Re: Mysql problem - by Urefeu - 02.07.2012, 20:28
Re: Mysql problem - by Urefeu - 03.07.2012, 14:19
Respuesta: Mysql problem - by [DOG]irinel1996 - 03.07.2012, 14:46
Re: Mysql problem - by Urefeu - 03.07.2012, 15:46
Respuesta: Mysql problem - by [DOG]irinel1996 - 03.07.2012, 16:59
Re: Mysql problem - by Urefeu - 03.07.2012, 17:02
Re: Mysql problem - by Urefeu - 03.07.2012, 17:11

Forum Jump:


Users browsing this thread: 1 Guest(s)