Problem in mysql plugin

[EviLpRo]

hello !

i'm download mysql plugin,
I tried to build a Registration and Logging
Now that's the problem:

Even if the user exists, he shows him the dialogue of the registration
Here's the code:

public OnPlayerConnect(playerid)
{
    format(String,256,"SELECT COUNT * FROM Users WHERE Nick='%s'",GetName(playerid));
    new exists = mysql_query(String);
    if(mysql_num_rows(exists) == 0)
    {
        format(String,256,"{ffffff}.Proffesional DeathMeath áøåê äáà ìùøú \n .àéðê øùåí ìîòøëú, òì îðú ìäøùí åìäðåú îäîåã ëîä ùéåúø äðê öøéê ìäøùí \n.òì îðú ìäøùí äëðñ àú ñéñîúê:",GetName(playerid),GetHColor(c_yellow));
        ShowPlayerDialog(playerid,RegDialog,DIALOG_STYLE_INPUT,"\t\t\t\t{ffffff}äøùîä ìùøú",String,"äøùí","");
    }
    else
    {
        LoginsErrors[playerid] = 0;
        format(String,256,"{ffffff}/Proffesional DeathMatch áøåê äáà ìùøú \n .ùí äîùúîù ìê øùåí, àðä äúçáø ìîòøëú áá÷ùä",GetName(playerid),GetHColor(c_yellow));
        ShowPlayerDialog(playerid,LogDialog,DIALOG_STYLE_INPUT,"\t\t\t\t{ffffff}äúçáøåú ìùøú",String,"äúçáø","");
    }
    return 1;
}

What's the problem?

[[NoV]LaZ]

Delete the exists variable, it doesn't help you. mysql_query returns 1 on success and 0 on failure and mysql_num_rows has an optional parameter, which is the connection handle returned by mysql_connect. So, in the end, you should be doing something like:

public OnPlayerConnect(playerid)
{
    format(String,256,"SELECT COUNT * FROM Users WHERE Nick='%s'",GetName(playerid));
    mysql_query(String);
    if(mysql_num_rows() == 0)
    {
        format(String,256,"{ffffff}.Proffesional DeathMeath áøåê äáà ìùøú \n .àéðê øùåí ìîòøëú, òì îðú ìäøùí åìäðåú îäîåã ëîä ùéåúø äðê öøéê ìäøùí \n.òì îðú ìäøùí äëðñ àú ñéñîúê:",GetName(playerid),GetHColor(c_yellow));
        ShowPlayerDialog(playerid,RegDialog,DIALOG_STYLE_INPUT,"\t\t\t\t{ffffff}äøùîä ìùøú",String,"äøùí","");
    }
    else
    {
        LoginsErrors[playerid] = 0;
        format(String,256,"{ffffff}/Proffesional DeathMatch áøåê äáà ìùøú \n .ùí äîùúîù ìê øùåí, àðä äúçáø ìîòøëú áá÷ùä",GetName(playerid),GetHColor(c_yellow));
        ShowPlayerDialog(playerid,LogDialog,DIALOG_STYLE_INPUT,"\t\t\t\t{ffffff}äúçáøåú ìùøú",String,"äúçáø","");
    }
    return 1;
}

[EviLpRo]

thank you very much !!