Ajuda [MySQL]
#8

Troca:
pawn Код:
public OnPlayerConnect(playerid)
{
    new escname[24], query[128];
    mysql_real_escape_string(GetName(playerid),escname);
    format(query,sizeof(query),"SELECT user FROM pinfo WHERE user = '%s'", escname); // Sу precisa usar as aspas simples quando for formatar o nome %s
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows()) {
        ShowPlayerDialog(playerid,2,1,"Login","Login","Login","Sair");
    }
    else {
        ShowPlayerDialog(playerid,1,1,"Registro","Registro","Registrar","Sair");
    }
    mysql_free_result();
    return 1;
}
para
pawn Код:
public OnPlayerConnect(playerid)
{
    new escname[24], query[128];
    mysql_real_escape_string(GetName(playerid),escname);
    format(query,sizeof(query),"SELECT * FROM pinfo WHERE user = '%s'", escname); // Sу precisa usar as aspas simples quando for formatar o nome %s
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows()) {
        ShowPlayerDialog(playerid,2,1,"Login","Login","Login","Sair");
    }
    else {
        ShowPlayerDialog(playerid,1,1,"Registro","Registro","Registrar","Sair");
    }
    mysql_free_result();
    return 1;
}
Reply


Messages In This Thread
Ajuda [MySQL] - by Jason` - 18.01.2012, 01:26
Re: Ajuda [MySQL] - by Jason` - 18.01.2012, 02:37
Re: Ajuda [MySQL] - by Ricop522 - 18.01.2012, 02:52
Re: Ajuda [MySQL] - by Jason` - 18.01.2012, 03:43
Re: Ajuda [MySQL] - by BlackCoder - 18.01.2012, 08:03
Re: Ajuda [MySQL] - by Ricop522 - 18.01.2012, 10:58
Re: Ajuda [MySQL] - by Jason` - 18.01.2012, 14:10
Re: Ajuda [MySQL] - by Ricop522 - 18.01.2012, 15:07
Re: Ajuda [MySQL] - by Jason` - 18.01.2012, 15:17

Forum Jump:


Users browsing this thread: 1 Guest(s)