public OnPlayerConnect(playerid)
{
    MoneyGiven[playerid] = -1; // This is the MySQL login system I have
    new pname[24]; //Creates our variables.
    new string[210];
    GetPlayerName(playerid, pname, 24); //Gets the players name
    mysql_store_result(); //We store the result.
    new rows = mysql_num_rows(); //We get how many rows the query returned. // This is the MySQL login system I have
    if(!rows)
    {
        //If the rows are equal to 0. This means that the query did not find
        //anyone under the name we connected under in the database.
        //So here we send the player the register dialog.
        SendClientMessage(playerid, COLOR_LIGHTRED, "Error: Please register an account at http://127.0.0.1 before being able to play!");
        Kick(playerid);
    }
    if(rows == 1)
    {
        //If the rows are equal to 1, this means there is a player already registered
        //so we can initiate the login dialog to the player or check if the players
        //current IP is the same one as in the database.
        format(string, sizeof(string), "Welcome back, %s. Please enter your password below to log in.",  GetName(playerid));
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Login", string, "Confirm", "Quit");
        IsRegistered[playerid] = 1; //Sets the registered variable to 1 (Shows that the player is registered).
    }
    return 1;
}

format(query,sizeof(query),"SELECT `Username` FROM `Accounts` WHERE `Username` = '%s' LIMIT 0 , 30;",name);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
        //do something here
}

#define DIALOG_LOGIN 2

case DIALOG_LOGIN: //Dialog login
        {
            if(!response) //If they click the cancel button
            {
                Kick(playerid);
            }
            if(response) //If the player clicked login
            {
                new query[200], pname[24], escapepass[100];//
                GetPlayerName(playerid, pname, 24); //Gets the players name
                mysql_real_escape_string(inputtext, escapepass); //We escape the inputtext to avoid SQL injections.
                format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
                mysql_query(query);
                mysql_store_result();
                new numrows = mysql_num_rows();
                if(numrows == 1) MySQL_Login(playerid);
                //This means that there is a user in the database with the same
                //password that we typed, we now proceed by using the login function.
                if(!numrows)
                {
                    //This means that the password that the player
                    //typed was incorrect and we will resend the dialog.
                    format(string, sizeof(string), "Welcome back, %s. Please enter your password below to log in.", GetName(playerid));
                    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Login", string, "Confirm", "Quit");
                    SendClientMessage(playerid, COLOR_LIGHTRED, "Error{FFFFFF}: You have entered an incorrect password."); //Sends the client a error message
                }
                mysql_free_result(); //Remember to always free a result if you stored one!
            }
            return 1;
        }

case DIALOG_LOGIN: //Dialog login