[gabitzu4ever]

Hello, I have a little problem in MySQL is unique players when they connect to the server, GTA crashes in OnPlayerConnect no dialog is no Login / Register. The script is:

pawn Код:

new pnamee[24];
    new qstr[512];
    GetPlayerName(playerid, pnamee, sizeof(pnamee));
    format(qstr,sizeof(qstr),"SELECT * FROM `users` WHERE `name`='%s' LIMIT 1",pnamee);
    mysql_query(qstr);
    mysql_store_result();
    if(mysql_num_rows())
    {
        gPlayerAccount[playerid] = 1;
        SendClientMessage(playerid, COLOR_LIGHTBLUE, "{EE5555}SERVER:{00FF00} Zonek SA:MP RPG Officil Server");

    }
    else
    {
        gPlayerAccount[playerid] = 0;
        SendClientMessage(playerid, COLOR_LIGHTBLUE, "{EE5555}SERVER:{00FF00} Zonek SA:MP RPG Officil Server");

    }
    mysql_free_result();

[juraska]

You didn't indicate num row

if(mysql_num_rows())
should be if(mysql_num_rows()=='value')

Код:

new pnamee[24];
    new qstr[512];
    GetPlayerName(playerid, pnamee, sizeof(pnamee));
    format(qstr,sizeof(qstr),"SELECT * FROM `users` WHERE `name`='%s' LIMIT 1",pnamee);
    mysql_query(qstr);
    mysql_store_result();
    if(mysql_num_rows()!=0)
    {
        gPlayerAccount[playerid] = 1;
        SendClientMessage(playerid, COLOR_LIGHTBLUE, "{EE5555}SERVER:{00FF00} Zonek SA:MP RPG Officil Server");

    }
    else
    {
        gPlayerAccount[playerid] = 0;
        SendClientMessage(playerid, COLOR_LIGHTBLUE, "{EE5555}SERVER:{00FF00} Zonek SA:MP RPG Officil Server");

    }
    mysql_free_result();

[Jordiee]

Are you using VX-RP 2?

[gabitzu4ever]

Quote:

Originally Posted by Jordiee Are you using VX-RP 2?

no, is my gamemode