function CallBestPlayerActive() {
    new string[128];
    mysql_format(SQL,string, sizeof(string),"SELECT name,ConnectedTime FROM users ORDER BY ConnectedTime DESC LIMIT 1");
    mysql_tquery(SQL,string,"BestPlayerActive","");
    return 1;
}

function BestPlayerActive() {
    new name[32]; cache_get_field_content(0,"name",name);
    new string[256];
    new id = GetPlayerID(name);
    if(IsPlayerConnected(id)) {
        format(string, sizeof(string), "%s are ce le mai multe ore jucate de pe server! Acesta detine %0.2f ore jucate!", GetName(id), PlayerInfo[id][pConnectTime]);
        SCMTA(COLOR_LIGHTRED, string);
        SCM(id, COLOR_YELLOW, "Deoarece esti cel mai activ jucator de pe server ti-a fost acordat gradul de NO LIFER.");
        SCM(id, COLOR_YELLOW, "Mentine suma de ore jucate cat mai mare, altfel vei pierde gradul.");
        PlayerInfo[id][pSefuActivilor] = 1;
        Update(id, pSefuActivilorx);
        PlayerInfo[id][pObtained1Pus] = 0;
        PlayerInfo[id][pObtained2Pus] = 0;
        PlayerInfo[id][pObtained3Pus] = 0;
        PlayerInfo[id][pObtained4Pus] = 1;
        Update(id, pObtained1Pusx);
        Update(id, pObtained2Pusx);
        Update(id, pObtained3Pusx);
        Update(id, pObtained4Pusx);
        if(IsValidDynamic3DTextLabel(YTScris[id])) DestroyDynamic3DTextLabel(YTScris[id]);
        if(IsValidDynamic3DTextLabel(VipScris[id])) DestroyDynamic3DTextLabel(VipScris[id]);
        if(IsValidDynamic3DTextLabel(BaniScris[id])) DestroyDynamic3DTextLabel(BaniScris[id]);
        if(IsValidDynamic3DTextLabel(ActivScris[id])) DestroyDynamic3DTextLabel(ActivScris[id]);
        AttachVipTags(id);
    }
    else  {
        format(string, sizeof(string), "Offline: %s are ce le mai multe ore jucate de pe server! Acesta detine %0.2f ore jucate!", GetName(id), PlayerInfo[id][pConnectTime]);
        SCMTA(COLOR_LIGHTRED, string);
    }
    new query[128];
    format(query, sizeof(query),"UPDATE users SET `SefuActivilor`='0' WHERE `SefuActivilor`='1'");
    mysql_query(SQL,query);

    format(query,sizeof(query),"UPDATE users SET `SefuActivilor`='1' WHERE `ID`='%d'",PlayerInfo[id][pSQLID]);
    mysql_query(SQL, query);
    return 1;
}

function CallBestPlayerMoney() {
    new string[128];
    mysql_format(SQL,string, sizeof(string),"SELECT name,Bank FROM users ORDER BY Bank DESC LIMIT 1");
    mysql_tquery(SQL,string,"BestPlayerMoney","");
    return 1;
}

function BestPlayerMoney() {
    new name[32]; cache_get_field_content(0,"name",name);
    new string[256];
    new id = GetPlayerID(name);
    if(IsPlayerConnected(id)) {
        format(string, sizeof(string), "%s este cel mai bogat jucator de pe server! Acesta detine $%s in banca!", GetName(id), FormatNumber(PlayerInfo[id][pAccount]));
        SCMTA(COLOR_LIGHTRED, string);
        SCM(id, COLOR_YELLOW, "Deoarece esti cel mai bogat jucator de pe server ti-a fost acordat gradul de SEFU LA BANI.");
        SCM(id, COLOR_YELLOW, "Mentine suma de bani in banca cat mai mare, altfel vei pierde gradul.");
        PlayerInfo[id][pSefuBaniilor] = 1;
        Update(id, pSefuBaniilorx);
        PlayerInfo[id][pObtained1Pus] = 0;
        PlayerInfo[id][pObtained2Pus] = 0;
        PlayerInfo[id][pObtained3Pus] = 1;
        PlayerInfo[id][pObtained4Pus] = 0;
        Update(id, pObtained1Pusx);
        Update(id, pObtained2Pusx);
        Update(id, pObtained3Pusx);
        Update(id, pObtained4Pusx);
        if(IsValidDynamic3DTextLabel(YTScris[id])) DestroyDynamic3DTextLabel(YTScris[id]);
        if(IsValidDynamic3DTextLabel(VipScris[id])) DestroyDynamic3DTextLabel(VipScris[id]);
        if(IsValidDynamic3DTextLabel(BaniScris[id])) DestroyDynamic3DTextLabel(BaniScris[id]);
        if(IsValidDynamic3DTextLabel(ActivScris[id])) DestroyDynamic3DTextLabel(ActivScris[id]);
        AttachVipTags(id);
    }
    else {
        format(string, sizeof(string), "Offline: %s este cel mai bogat jucator de pe server! Acesta detine $%s in banca!", GetName(id), FormatNumber(PlayerInfo[id][pAccount]));
        SCMTA(COLOR_LIGHTRED, string);
    }
    new query[128];
    format(query, sizeof(query),"UPDATE users SET `SefuBaniilor`='0' WHERE `SefuBaniilor`='1'");
    mysql_query(SQL,query);

    format(query,sizeof(query),"UPDATE users SET `SefuBaniilor`='1' WHERE `ID`='%d'",PlayerInfo[id][pSQLID]);
    mysql_query(SQL, query);
    return 1;
}