/staffaktivnost

CMD:staffaktivnost(playerid, params[])
{
    if(Igrac[ playerid ][pAdminNivo] >= 4) {
        new rows, info[2048], Igrac_Ime[ 24 ], data[ 4 ], zlogin[ 25 ], vrsrv, hns, minns, id;
        //Provjera Admina
        mysql_format(baza_konekcija, DB_Query, sizeof(DB_Query), "SELECT ID_yuBb, VremenaNaServeru_yuBb, ProslaSedmica_yuBb, SedmicnaAktivnost_yuBb, ZLogin_yuBb, Nick_yuBb, AdminNivo_yuBb, DanAktivnost_yuBb FROM korisnici WHERE AdminNivo_yuBb > 0 ORDER BY AdminNivo_yuBb DESC");
        new Cache:rezjedan = mysql_query(baza_konekcija, DB_Query);
        cache_get_row_count(rows);
        for (new i; i != rows; i++)
        {
            cache_get_value(i, "Nick_yuBb", Igrac_Ime, 24);
            cache_get_value_int(i,"AdminNivo_yuBb", data[ 0 ]);
            cache_get_value_int(i,"VremenaNaServeru_yuBb", vrsrv);
            hns = vrsrv / 3600;
            minns = (vrsrv / 60) - (hns * 60) ;
            cache_get_value_int(i,"DanAktivnost_yuBb", data[ 1 ]);
            cache_get_value_int(i,"SedmicnaAktivnost_yuBb", data[ 2 ]);
            cache_get_value_int(i,"ProslaSedmica_yuBb", data[ 3 ]);
            cache_get_value(i,"ZLogin_yuBb", zlogin, 25);
            if(IgracKonektovan(Igrac_Ime)) {
                id = GetPlayerID(Igrac_Ime);
                hns = Igrac[id][pVremenaNaServeru] / 3600;
                minns = (Igrac[id][pVremenaNaServeru] / 60) - (hns * 60) ;
                format(info, sizeof info, "%s{F3FF02}%s    {F81414}Admin Nivo: %d    {FFAF00}Odigrano: %dh%dmin    {A833FF}Ovu sedmicu: %dh%dmin    {D8A4FF}Proslu sedmicu: %dh%dmin    {00C0FF}Na zadnji dan: %d min (%s)\n", info,
                Igrac_Ime,
                Igrac[id][pAdminNivo],
                hns,minns,
                Igrac[id][pSedmicnaAktivnost] / 3600, (Igrac[id][pSedmicnaAktivnost] / 60) - ((Igrac[id][pSedmicnaAktivnost] / 3600) * 60),
                Igrac[id][pProslaSedmica] / 3600, (Igrac[id][pProslaSedmica] / 60) - ((Igrac[id][pProslaSedmica] / 3600) * 60),
                Igrac[id][pDanAktivnost]/60,
                Igrac[id][pZLogin]);
            }
            else {
                format(info, sizeof info, "%s{F3FF02}%s    {F81414}Admin Nivo: %d    {FFAF00}Odigrano: %dh%dmin    {A833FF}Ovu sedmicu: %dh%dmin    {D8A4FF}Proslu sedmicu: %dh%dmin    {00C0FF}Na zadnji dan: %d min (%s)\n", info,
                Igrac_Ime,
                data[ 0 ],
                hns,minns,
                data[ 2 ] / 3600, (data[ 2 ] / 60) - ((data[ 2 ]/3600) * 60),
                data[ 3 ] / 3600, (data[ 3 ] / 60) - ((data[ 3 ]/3600) * 60),
                data[ 1 ]/60,
                zlogin);
            }
        }
        cache_delete(rezjedan);
        //Provjera GXa
        mysql_format(baza_konekcija, DB_Query, sizeof(DB_Query), "SELECT ID_yuBb, VremenaNaServeru_yuBb, ProslaSedmica_yuBb, SedmicnaAktivnost_yuBb, ZLogin_yuBb, Nick_yuBb, GameXpert_yuBb, DanAktivnost_yuBb FROM korisnici WHERE GameXpert_yuBb > 0 ORDER BY GameXpert_yuBb DESC");
        new Cache:rezdva = mysql_query(baza_konekcija, DB_Query);
        cache_get_row_count(rows);
        for (new i; i != rows; i++)
        {
            cache_get_value(i, "Nick_yuBb", Igrac_Ime, 24);
            cache_get_value_int(i,"GameXpert_yuBb", data[ 0 ]);
            cache_get_value_int(i,"VremenaNaServeru_yuBb", vrsrv);
            hns = vrsrv / 3600;
            minns = (vrsrv / 60) - (hns * 60) ;
            cache_get_value_int(i,"DanAktivnost_yuBb", data[ 1 ]);
            cache_get_value_int(i,"SedmicnaAktivnost_yuBb", data[ 2 ]);
            cache_get_value_int(i,"ProslaSedmica_yuBb", data[ 3 ]);
            cache_get_value(i,"ZLogin_yuBb", zlogin, 25);
            if(IgracKonektovan(Igrac_Ime)) {
                id = GetPlayerID(Igrac_Ime);
                hns = Igrac[id][pVremenaNaServeru] / 3600;
                minns = (Igrac[id][pVremenaNaServeru] / 60) - (hns * 60) ;
                format(info, sizeof info, "%s{F3FF02}%s    {A6ED7B}GXpert Nivo: %d    {FFAF00}Odigrano: %dh%dmin    {A833FF}Ovu sedmicu: %dh%dmin    {D8A4FF}Proslu sedmicu: %dh%dmin    {00C0FF}Na zadnji dan: %d min (%s)\n", info,
                Igrac_Ime,
                Igrac[id][pGameXpert],
                hns,minns,
                Igrac[id][pSedmicnaAktivnost] / 3600, (Igrac[id][pSedmicnaAktivnost] / 60) - ((Igrac[id][pSedmicnaAktivnost] / 3600) * 60),
                Igrac[id][pProslaSedmica] / 3600, (Igrac[id][pProslaSedmica] / 60) - ((Igrac[id][pProslaSedmica] / 3600) * 60),
                Igrac[id][pDanAktivnost]/60,
                Igrac[id][pZLogin]);
            }
            else {
                format(info, sizeof info, "%s{F3FF02}%s    {A6ED7B}GXpert Nivo: %d    {FFAF00}Odigrano: %dh%dmin    {A833FF}Ovu sedmicu: %dh%dmin    {D8A4FF}Proslu sedmicu: %dh%dmin    {00C0FF}Na zadnji dan: %d min (%s)\n", info,
                Igrac_Ime,
                data[ 0 ],
                hns,minns,
                data[ 2 ] / 3600, (data[ 2 ] / 60) - ((data[ 2 ]/3600) * 60),
                data[ 3 ] / 3600, (data[ 3 ] / 60) - ((data[ 3 ]/3600) * 60),
                data[ 1 ]/60,
                zlogin);
            }
        }
        cache_delete(rezdva);
        //
        AC_ShowPlayerDialog( playerid, 9999, DIALOG_STYLE_MSGBOX, "[YUB] Aktivnost - Admin Team", info, "Zatvori", "" );
    }
    return 1;
}