Get information for mysql
#11

now when i use /login my server crash after 5 secs :S

Here is my code

pawn Код:
if(!strcmp(cmdtext, "/login", true, 6))
    {
    if(cmdtext[9] == 0)
        {
      SendClientMessage(playerid, COLOR_GREY, "Utiliza: /login [password]");
      return 1;
    }
    else
    {
        if(logueado == 1)
        {
        SendClientMessage(playerid, COLOR_YELLOW, "Ya estas logueado");
        }
            else
            {
            new name[128];
            new query[128];
            new pass = cmdtext[7];
            GetPlayerName(playerid, name, sizeof(name));
                format(query, sizeof(query),"SELECT Whatever FROM `table` WHERE Username = '%s' AND Password = '%s'", name, pass);
                samp_mysql_query(query);
                samp_mysql_store_result();
                if(samp_mysql_num_rows() > 0)
                {
                logueado = 1;
                    SendClientMessage(playerid, COLOR_GREEN, "________________________________________________________");
                SendClientMessage(playerid, COLOR_YELLOW, "Has sido logueado correctamente.");
                SendClientMessage(playerid, COLOR_GREEN, "________________________________________________________");
                }
                else
                {
                if(intentos == 3)
                {
                    SendClientMessage(playerid, COLOR_GREEN, "________________________________________________________");
                    SendClientMessage(playerid, COLOR_YELLOW, "Limites de intentos por contraseсa. Has sido Kickeado.");
                    SendClientMessage(playerid, COLOR_GREEN, "________________________________________________________");
                        Kick(playerid);
                }
                else
                {
                    intentos = intentos +1;
                    SendClientMessage(playerid, COLOR_GREEN, "_________________________________________");
                    SendClientMessage(playerid, COLOR_YELLOW, "Contraseсa incorrecta.");
                    SendClientMessage(playerid, COLOR_GREEN, "_________________________________________");
                }
                }
            }
        }
    return 1;
  }
Reply


Messages In This Thread
Get information for mysql - by Zafire1410 - 23.08.2009, 20:56
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 21:00
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 21:00
Re: Get information for mysql - by Joe Staff - 23.08.2009, 21:11
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 21:11
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 21:28
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 21:32
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 21:45
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 21:50
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 21:51
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:04
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 22:04
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:12
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:13
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:15
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 22:17
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:20
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:22
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:25
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 22:26
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:30
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:34
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:36
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:46
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:53
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 23:01
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 23:03
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 23:08
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 23:16
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 23:18

Forum Jump:


Users browsing this thread: 1 Guest(s)