[ReVo_]

yo,
i make code /login using mysql... if i login server crash
Code

pawn Код:

if (strcmp(cmd,"/login", true) == 0)
    {
      new password[256];
      password = strtok(cmdtext,idx);
      if(PlayerLogIn[playerid]) return SendClientMessage(playerid, COLOR_GREY," Sei giа loggato");
        if(!strlen(password)) return SendClientMessage(playerid, COLOR_GREY," Usa /login (password)");
        new query2[256],resultline[256];
      format(query2,sizeof(query2),"SELECT * FROM users WHERE username='%s'",Nickname[playerid]);
      samp_mysql_query(query2);
      samp_mysql_store_result();
      if(!samp_mysql_fetch_row(resultline)) return SendClientMessage(playerid, COLOR_GREY," Nickname non registrato");
      new tmptemp[256];
      samp_mysql_get_field("password", tmptemp);
        if(strfind(password,tmptemp,true))
        {
          SendClientMessage(playerid, COLOR_GREY," Password non corretta.");
          return 1;
        }
        samp_mysql_get_field("kills", tmptemp);
        Player[playerid][pKills]=strval(tmptemp);
        samp_mysql_get_field("deaths", tmptemp);
        Player[playerid][pDeaths]=strval(tmptemp);
        samp_mysql_get_field("clan", tmptemp);
        Player[playerid][pClan]=strval(tmptemp);
        samp_mysql_get_field("rank", tmptemp);
        Player[playerid][pRank]=strval(tmptemp);
        samp_mysql_get_field("barche", tmptemp);
        Player[playerid][pLicenzaBarche]=strval(tmptemp);
        samp_mysql_get_field("aerei", tmptemp);
        Player[playerid][pLicenzaAerei]=strval(tmptemp);
        samp_mysql_get_field("admin", tmptemp);
        Player[playerid][pAdmin]=strval(tmptemp);
        samp_mysql_get_field("team", tmptemp);
        Player[playerid][pTeam]=strval(tmptemp);
        samp_mysql_get_field("level", tmptemp);
        Player[playerid][pLevel]=strval(tmptemp);
        samp_mysql_get_field("rispetto", tmptemp);
        Player[playerid][pRespect]=strval(tmptemp);
        samp_mysql_get_field("soldi", tmptemp);
        Player[playerid][pMoney]=strval(tmptemp);
           PlayerLogIn[playerid]=1;
        SendClientMessage(playerid, COLOR_GREY," Account loggato con successo");
        return 1;
    }

[ReVo_]

...and register!

pawn Код:

if (strcmp(cmd,"/register", true) == 0)
    {
      new password[256];
      password = strtok(cmdtext,idx);
        if(!strlen(password)) return SendClientMessage(playerid, COLOR_GREY," Usa /register (password)");
        new query[256],resultline[256];
      format(query,sizeof(query),"SELECT * FROM users WHERE username='%s'",Nickname[playerid]);
      samp_mysql_query(query);
      samp_mysql_store_result();
      if(samp_mysql_fetch_row(resultline)) return SendClientMessage(playerid, COLOR_GREY," Nickname giа registrato");
        new string[256];
        format(string, 256,"INSERT INTO `users` (username,password,kills,deaths,clan,rank,barche,aerei,admin,team,level,rispetto,soldi) VALUES ('%s','%s','0','0','0','0','0','0','0','0','0','0','0')",Nickname[playerid],
        password);
        samp_mysql_query(string);
        return 1;
    }

account register on db after server crashed pls help me!

[ReVo_]

register fixed pls help me for login!