//======= Stocks========
stock GetName(playerid)
{
    new pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, sizeof(pName));
    return pName;
}

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), "UPDATE `users` SET `Money` = %d WHERE `Username` = '%s'", PlayerInfo[playerid][Money], GetName(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.");
    GetPlayerIp(playerid, PlayerInfo[playerid][PlayerIP], 11);
}

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, PlayerIP) VALUES (NULL, '%s', MD5('%s'), '%s');",GetName(playerid), password, PlayerInfo[playerid][PlayerIP]);
    mysql_query(Query);
    SendClientMessage(playerid, cYELLOW, "Account created, you should be logged in any second now.");
    LoginUser(playerid);
}