Login System
#1

Hello,

I've some issues with my login system.

pawn Код:
public OnQueryFinish(query[], resultid, extraid, connectionHandle)
{
    mysql_store_result();
    new type = resultid;
    new playerid = extraid;
    if(type == QUERY_LOGIN)
    {
        if(mysql_num_rows() != 0)
        {
            new str[256]; new data[20][256];
            mysql_fetch_row_format(str);
            explode(data,str,"|");
            PlayerInfo[playerid][pId] = strval(data[0]);
            PlayerInfo[playerid][pNiveau] = strval(data[3]);
            PlayerInfo[playerid][pExp] = strval(data[4]);
            PlayerInfo[playerid][pBan] = strval(data[5]);
            format(PlayerInfo[playerid][pBraison],256,"%s",data[6]);
            PlayerInfo[playerid][pAge] = strval(data[7]);
            PlayerInfo[playerid][pSexe] = strval(data[8]);
            PlayerInfo[playerid][pSpawnX] = strval(data[9]);
            PlayerInfo[playerid][pSpawnY] = strval(data[10]);
            PlayerInfo[playerid][pSpawnZ] = strval(data[11]);
            PlayerInfo[playerid][pSpawnVw] = strval(data[12]);
            PlayerInfo[playerid][pSpawnInt] = strval(data[13]);
            PlayerInfo[playerid][pArgent] = strval(data[14]);
            PlayerInfo[playerid][pBanque] = strval(data[15]);
            PlayerInfo[playerid][pAdmin] = strval(data[16]);
            format(PlayerInfo[playerid][pMail],256,"%s",data[17]);
            PlayerInfo[playerid][pSkin] = strval(data[18]);
            PlayerInfo[playerid][pTutoriel] = strval(data[19]);
            mysql_free_result();
            Spawn(playerid);
        }
        else
        {
       
            format(str, sizeof(str),"Mot de passe invalide.");
            TextDrawSetString(errormsg1[playerid],str);

        }
    }
pawn Код:
public Login(playerid,pass[])
{
    new EscapedText[60]; new Query[1000];
    mysql_real_escape_string(pass, EscapedText);
    format(Query,sizeof(Query),"SELECT * FROM comptes WHERE nom = '%s' AND `password` = '%s'",pName,EscapedText);
    mysql_query(Query,QUERY_LOGIN,playerid);
    return 1;
}
When I put my password, nothing happend.

Thanks in advance.
Reply


Messages In This Thread
Login System - by PakPak - 17.07.2013, 18:51
Re: Login System - by gtakillerIV - 17.07.2013, 19:04
Re: Login System - by Vince - 17.07.2013, 19:13
Re : Login System - by PakPak - 17.07.2013, 22:13
Re: Login System - by gtakillerIV - 17.07.2013, 22:15
Re : Login System - by PakPak - 17.07.2013, 22:21
Re : Login System - by PakPak - 17.07.2013, 22:26
Re : Login System - by PakPak - 18.07.2013, 05:34

Forum Jump:


Users browsing this thread: 1 Guest(s)