forward SaveUser(playerid);
public SaveUser(playerid)
{
        new Query[250]; format(Query, sizeof(Query), "INSERT INTO `users` WHERE `Money` = %d, `Score` = %d, `username` = '%s', `Ip` = '%s'",
        PlayerInfo[playerid][Money], GetPlayerScore(playerid), GetName(playerid), GetIp(playerid));
        mysql_query(Query);
}

stock InitMysqlConnection()
{
        mysql_init(LOG_ONLY_ERRORS, 1);
        mysql_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DB);
}

stock GetName(playerid)
{
        new pName[MAX_PLAYER_NAME];
        GetPlayerName(playerid, pName, sizeof(pName));
        return pName;
}
stock GetIp(playerid)
{
        new Ip;
        GetPlayerIp(playerid, Ip, sizeof(Ip));
        return Ip;
}

stock CheckUser(playerid)
{
    new Query[200]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';",GetName(playerid));
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows()) return 1;
    return 0;
}

stock SavePlayerInfo(playerid)
{
    new Query[400]; format(Query, sizeof(Query), "INSERT INTO `users` WHERE `Money` = %d, `Username` = '%s', `Ip` = '%s'", PlayerInfo[playerid][Money], GetName(playerid), PlayerInfo[playerid][Ip], GetIp(playerid));
    mysql_query(Query);
}


stock LoginUser(playerid)
{
    new Query[200]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';",GetName(playerid));
    mysql_query(Query);
    mysql_store_result();
    if(mysql_fetch_row(Query,"|")) {
        sscanf(Query, "p<|>e<is[25]s[50]s[8]iiiiiiiiiiiiis[100]iii>", PlayerInfo[playerid]);
    }
    PlayerInfo[playerid][LoggedIn] = 1;
    GivePlayerMoney(playerid, PlayerInfo[playerid][Money]);
    SetPlayerScore(playerid, PlayerInfo[playerid][Score]);
    SendClientMessage(playerid, cYELLOW, "You have successfully logged in.");
}

stock CheckUserLogin(playerid, password[])
{
    new Query[200]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s' AND password = MD5('%s');",GetName(playerid), password);
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows()) return 1;
    return 0;
}

stock CreateUser(playerid, password[])
{
    new Query[200]; format(Query, sizeof(Query), "INSERT INTO users (ID, Username, Password, Ip) VALUES (NULL, '%s', MD5('%s'), '%s', '%s');",GetName(playerid), password, PlayerInfo[playerid][PlayerIP], GetIp(playerid));
    mysql_query(Query);
    SendClientMessage(playerid, cYELLOW, "Account created, you should be logged in any second now.");
    LoginUser(playerid);
}