mysql login
#1

Hey, sometimes when i login nothing happends i dont know why..

pawn Код:
//-------------------------------[Login]--------------------------------------------------------------------------
    if (strcmp(cmd, "/login", true) ==0 )
    {
        new tmppass[64];
        GetPlayerName(playerid, playername, 26);
        if (gPlayerLogged[playerid] == 1)
        {
            SendClientMessage(playerid, COLOR_WHITE, "SERVER: You are already logged in.");
            return 1;
        }
        tmp = strtok(cmdtext, idx);
        if(!strlen(tmp))
        {
            SendClientMessage(playerid, COLOR_GRAD2, "USAGE: /login [password]");
            return 1;
        }
        if(MySQLCheckAccount(playername)==0)
        {
          SendClientMessage(playerid, COLOR_WHITE, "SERVER: You dont own an account.");
          return 1;
        }
        strmid(tmppass, tmp, 0, strlen(cmdtext), 255);
        Encript(tmppass);
        if (gdebug){printf("DEBUG enterd %s", tmppass);}
        OnPlayerLogin(playerid,tmppass);
        return 1;
    }
pawn Код:
//-------------------------------[OnPlayerLogin]--------------------------------------------------------------------------
public OnPlayerLogin(playerid,const string[])
{
    if (gdebug >= 1){printf("DEBUG OnPlayerLogin(%d) (%s)", playerid,string);}
    new string2[64];
    new string3[64];
    new tmp2[128];
    new playername2[26];
    GetPlayerName(playerid, playername2, 26);
    MySQLFetchAcctSingle(PlayerInfo[playerid][pSQLID], "password", PlayerInfo[playerid][pPassword]);
    if(strcmp(PlayerInfo[playerid][pPassword],string, true ) == 0 )
    {
        new Data[1024];
        new Field[64];
        new rcnt = 1;
        MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
        samp_mysql_strtok(Field, "|", Data);
        while (samp_mysql_strtok(Field, "|", "")==1)
        {
            if(rcnt == 1) PlayerInfo[playerid][pAdmin] = strval(Field);
            if(rcnt == 4) PlayerInfo[playerid][pLevel] = strval(Field);
            if(rcnt == 5) PlayerInfo[playerid][pExp] = strval(Field);
            if(rcnt == 6) PlayerInfo[playerid][pDrugs] = strval(Field);
            if(rcnt == 7) PlayerInfo[playerid][pCash] = strval(Field);
            if(rcnt == 8) PlayerInfo[playerid][pAccount] = strval(Field);
            if(rcnt == 9) PlayerInfo[playerid][pJRank] = strval(Field);
            if(rcnt == 10) PlayerInfo[playerid][pModel] = strval(Field);
            if(rcnt == 12) PlayerInfo[playerid][pRank] = strval(Field);
            if(rcnt == 13) PlayerInfo[playerid][pTeam] = strval(Field);
            if(rcnt == 14) PlayerInfo[playerid][gPupgrade] = strval(Field);
            if(rcnt == 15) PlayerInfo[playerid][pKills] = strval(Field);
            if(rcnt == 16) PlayerInfo[playerid][pCB] = strval(Field);
            if(rcnt == 17) PlayerInfo[playerid][pHW] = strval(Field);
            if(rcnt == 18) PlayerInfo[playerid][pSR] = strval(Field);
            if(rcnt == 19) PlayerInfo[playerid][pWA] = strval(Field);
            if(rcnt == 20) PlayerInfo[playerid][pPEN] = strval(Field);
            if(rcnt == 21) PlayerInfo[playerid][pGun1] = strval(Field);
            if(rcnt == 22) PlayerInfo[playerid][pGun2] = strval(Field);
            if(rcnt == 23) PlayerInfo[playerid][pGun3] = strval(Field);
            if(rcnt == 24) PlayerInfo[playerid][pGun4] = strval(Field);
            if(rcnt == 25) PlayerInfo[playerid][pGun5] = strval(Field);
            if(rcnt == 26) PlayerInfo[playerid][pGun6] = strval(Field);
            if(rcnt == 27) PlayerInfo[playerid][pGun7] = strval(Field);
            if(rcnt == 28) PlayerInfo[playerid][pAmmo1] = strval(Field);
            if(rcnt == 29) PlayerInfo[playerid][pAmmo2] = strval(Field);
            if(rcnt == 30) PlayerInfo[playerid][pAmmo3] = strval(Field);
            if(rcnt == 31) PlayerInfo[playerid][pAmmo4] = strval(Field);
            if(rcnt == 32) PlayerInfo[playerid][pAmmo5] = strval(Field);
            if(rcnt == 33) PlayerInfo[playerid][pAmmo6] = strval(Field);
            if(rcnt == 34) PlayerInfo[playerid][pAmmo7] = strval(Field);
            if(rcnt == 35) PlayerInfo[playerid][pSHealth] = strval(Field);
            if(rcnt == 36) PlayerInfo[playerid][pLicenseA] = strval(Field);
            if(rcnt == 37) PlayerInfo[playerid][pLicenseB] = strval(Field);
            if(rcnt == 38) PlayerInfo[playerid][pLicenseC] = strval(Field);
            if(rcnt == 39) PlayerInfo[playerid][pInt] = strval(Field);
            if(rcnt == 40) PlayerInfo[playerid][pLocal] = strval(Field);
            if(rcnt == 41) PlayerInfo[playerid][pPnumber] = strval(Field);
            if(rcnt == 42) PlayerInfo[playerid][pPhousekey] = strval(Field);
            if(rcnt == 43) PlayerInfo[playerid][pPbiskey] = strval(Field);
            if(rcnt == 44) PlayerInfo[playerid][pDuty] = strval(Field);
            if(rcnt == 45) PlayerInfo[playerid][pWarnL] = strval(Field);
            if(rcnt == 46) PlayerInfo[playerid][pSArmour] = strval(Field);
            if(rcnt == 47) PlayerInfo[playerid][pJailed] = strval(Field);
            if(rcnt == 48) PlayerInfo[playerid][pStored] = strval(Field);
            if(rcnt == 49) PlayerInfo[playerid][pIP] = strval(Field);
            rcnt++;
        }
        samp_mysql_free_result();
    }
    else
    {
      SendClientMessage(playerid, COLOR_WHITE, "SERVER: Password does not match your name");
      return 1;
    }
Reply


Messages In This Thread
mysql login - by Think - 25.03.2009, 16:59
Re: mysql login - by jat1801 - 25.03.2009, 17:58
Re: mysql login - by tom_jonez - 25.03.2009, 19:13
Re: mysql login - by Think - 25.03.2009, 19:44
Re: mysql login - by Think - 25.03.2009, 21:32
Re: mysql login - by Luka P. - 26.03.2009, 14:16
Re: mysql login - by Think - 26.03.2009, 15:08
Re: mysql login - by Luka P. - 26.03.2009, 16:58
Re: mysql login - by MenaceX^ - 26.03.2009, 17:00
Re: mysql login - by Think - 26.03.2009, 17:53

Forum Jump:


Users browsing this thread: 1 Guest(s)