YCMD:setstatus(playerid, params[], help)
{
    if(PlayerInfo[playerid][pLeader] == 0) return SCM(playerid, COLOR_GREY, "Nu esti lider de factiune!");
    switch(DynamicFactions[PlayerInfo[playerid][pLeader]][fApp])
    {
        case 0:
        {
            SCM(playerid, COLOR_WHITE, "Acum, factiunea ta, recruteaza membrii.");
            DynamicFactions[PlayerInfo[playerid][pLeader]][fApp] = 1;
        }
        case 1:
        {
            SCM(playerid, COLOR_WHITE, "Acum, factiunea ta, nu mai recruteaza membrii.");
            DynamicFactions[PlayerInfo[playerid][pLeader]][fApp] = 0;
        }
    }

    new query[180];
    format(query, sizeof(query), "UPDATE `factions` SET `App`= %d WHERE `ID`= %d ", DynamicFactions[PlayerInfo[playerid][pLeader]][fApp], PlayerInfo[playerid][pLeader]);
    mysql_tquery(SQL, query, "", "");
    return 1;
}



YCMD:asellhouse(playerid, params[], help)
{
    new house, string[180], query[180];
    if(sscanf(params, "d", house)) return SCM(playerid, COLOR_GREY, "USAGE: {FFFFFF}/asellhouse <House ID>");
    if(PlayerInfo[playerid][pAdmin] < 5) return SCM(playerid, COLOR_GREY, "Nu ai nivelul necesar de admin pentru a face asta.");
    foreach(Player, i) {
        if(IsPlayerConnected(i) && PlayerInfo[i][pHouse] == house) {
            PlayerInfo[i][pHouse] = 999;
            PlayerInfo[i][pRented] = -1;
            Update(i, pHousex);
        }
    }
    HouseInfo[house][hHel] = 0;
    HouseInfo[house][hArm] = 0;
    HouseInfo[house][hLock] = 0;
    HouseInfo[house][hOwned] = 0;
    HouseInfo[house][hValue] = 0;
    format(query,sizeof(query),"UPDATE `houses` SET `Hel`='0',`Arm`='0',`Lockk`='0',`Owned`='0',`Owner`='The State',`Value`='0' WHERE `ID`='%d'",house);
    mysql_tquery(SQL,query, "", "");
    format(query,sizeof(query),"UPDATE users SET `House`='999' WHERE `name`='%s'",HouseInfo[house][hOwner]);
    mysql_tquery(SQL,query, "", "");
    strmid(HouseInfo[house][hOwner], "The State", 0, strlen("The State"), 255);
    PlayerPlaySound(playerid, 1052, 0.0, 0.0, 0.0);
    format(string, sizeof(string), "* Casa %d a fost vandut cu succes la stat!", house);
    SCM(playerid, COLOR_YELLOW, string);
    UpdateLabel(1, house);
    return 1;
}

YCMD:buyhouse(playerid, params[], help) {
    new id, szQuery[256], newmoneys, moneys, string[180], houseIndex;

    for(houseIndex = 1; houseIndex < sizeof(HouseInfo); houseIndex++)
    {
        if(PlayerToPoint(2.0, playerid, HouseInfo[houseIndex][hEntrancex], HouseInfo[houseIndex][hEntrancey], HouseInfo[houseIndex][hEntrancez]))
        {
            break;
        }
    }

    if(HouseInfo[houseIndex][hOwned] == 1) return SCM(playerid, -1, "Casa are deja propietar");

    if(PlayerInfo[playerid][pLevel] < HouseInfo[houseIndex][hLevel])
    {
        format(string, sizeof(string), "Ai nevoie de nivel %d pentru a cumpara.", HouseInfo[houseIndex][hLevel]);
        SCM(playerid, COLOR_WHITE, string);
        return 1;
    }
    if(PlayerInfo[playerid][pHouse] != 999 && strcmp(GetName(playerid), HouseInfo[PlayerInfo[playerid][pHouse]][hOwner], true) == 0) return SCM(playerid, COLOR_WHITE, "Ai deja o casa.");
    if(GetPlayerCash(playerid) < HouseInfo[houseIndex][hValue]) return SCM(playerid, COLOR_GREY, "Nu ai destui bani pentru a cumpara aceasta casa.");
    id = GetPlayerID(HouseInfo[houseIndex][hOwner]);
    if(id != INVALID_PLAYER_ID)
    {
        PlayerInfo[id][pHouse] = 999;
        Update(id, pHousex);
        PlayerInfo[id][pAccount] += HouseInfo[houseIndex][hValue];
        format(string, sizeof(string), "* %s ti-a cumparat casa pentru {19CF2E}$%s{239931}. Banii au fost transferati in contul tau bancar.", GetName(playerid), FormatNumber(HouseInfo[houseIndex][hValue]));
        SCM(id, 0x239931FF, string);
        format(szQuery,sizeof(szQuery),"UPDATE users SET `Bank`='%d' WHERE `ID`='%d'",PlayerInfo[id][pAccount],PlayerInfo[id][pSQLID]);
        mysql_tquery(SQL,szQuery, "", "");
    }
    else
    {
        format(szQuery, sizeof(szQuery), "SELECT `Bank` FROM `users` WHERE `name` = '%s'", HouseInfo[houseIndex][hOwner]);
        new Cache: result = mysql_query(SQL, szQuery);
        if(cache_get_row_count() != 0) {
            cache_get_field_content_int(0, "Bank", moneys);
            newmoneys = moneys + HouseInfo[houseIndex][hValue];
        }
        cache_delete(result);
        format(szQuery, sizeof(szQuery), "UPDATE `users` SET `Bank` = '%d', `House` = '999' WHERE `name` = '%s'", newmoneys, HouseInfo[houseIndex][hOwner]);
        mysql_tquery(SQL, szQuery, "", "");
    }

    InHouse[playerid] = houseIndex;
    PlayerInfo[playerid][pHouse] = HouseInfo[houseIndex][hID];
    PlayerInfo[playerid][pRented] = -1;
    HouseInfo[houseIndex][hOwned] = 1;
    format(HouseInfo[houseIndex][hOwner], 256, GetName(playerid));
    GivePlayerCash(playerid,-HouseInfo[houseIndex][hValue]);
    SetPlayerInterior(playerid,HouseInfo[houseIndex][hInterior]);
    SetPlayerPosEx(playerid,HouseInfo[houseIndex][hExitx],HouseInfo[houseIndex][hExity],HouseInfo[houseIndex][hExitz]);
    SetPlayerVirtualWorld(playerid,HouseInfo[houseIndex][hVirtual]);
    PlayerInfo[playerid][pInt] = HouseInfo[houseIndex][hInterior];
    PlayerInfo[playerid][pLocal] = houseIndex;
    HouseInfo[houseIndex][hValue] = 0;
    SCM(playerid, COLOR_MONEY, "Felicitari! Ti-ai cumparat aceasta casa.");
    Update(playerid,pCashx);
    Update(playerid,pHousex);
    format(szQuery, sizeof(szQuery),"UPDATE `houses` SET `Owned`='1',`Owner`='%s',`Value`='0' WHERE `ID`='%d'",GetName(playerid),HouseInfo[houseIndex][hID]);
    mysql_tquery(SQL,szQuery, "", "");
    UpdateLabel(1, houseIndex);
    finishAchievement(playerid, 3);


    return 1;
}