zz

CMD:osetus(playerid, params[])
{
    if(PlayerInfo[playerid][LoggedIn] == 0)
        return SendClientMessage(playerid, -1, ""chat" "COL_NGREEN"[ERROR]: "COL_GREY"You need to be 'Logged In' to use this command.");
    if(PlayerInfo[playerid][usMember] < 7)
        return SendClientMessage(playerid, -1, ""chat" "COL_NGREEN"[ERROR]: "COL_GREY"You need to be 'US Member 7+' to use this command.");
    new oplayer[128], uslevel;
    if(sscanf(params,"s[128]i",oplayer,uslevel))
        return SendClientMessage(playerid, -1, ""chat" "COL_GREY"[Usage]: /osetus "COL_RED"[name] [rank]");
    if(uslevel > 10)
        return SendClientMessage(playerid, -1, ""chat" "COL_NGREEN"[ERROR]: "COL_GREY"US Level must be between [1-10]");
    new
        Cache:Result,
        Query[390]
    ;
    mysql_format(mysql, Query, sizeof Query,"SELECT `usMember` FROM `clans` WHERE `name` = '%e' LIMIT 1",oplayer);
    Result = mysql_query(mysql, Query);
    if(cache_num_rows() > 0)
    {
        new oldlevel;
        oldlevel = cache_get_field_content_int(0, "usMember");
        if(oldlevel == uslevel)
        {
            SendClientMessage(playerid, -1, ""chat" "COL_NGREEN"[ERROR]: "COL_GREY"Player is already on that US level.");
        }
        else
        {
            mysql_format(mysql, Query, sizeof Query, "UPDATE `clans` SET `usMember` = '%d' WHERE `name` = '%e'", uslevel, oplayer);
            mysql_tquery(mysql, Query, "", "");
            new string[128];
            format(string, sizeof string, ""chat" "COL_NBLUE"You've set %s's offline US status to rank "COL_WHITE"%d.", oplayer, uslevel);
            SendClientMessage(playerid, -1, string);
        }
    }
    else
        SendClientMessage(playerid, -1, ""chat" "COL_NGREEN"[ERROR]: "COL_GREY"That name does not exists on the database.");
    cache_delete(Result);
    return 1;
}