[DarkMythHunter]

PHP код:

IRCCMD:topplayers(botid, channel[], user[], host[], params[])
{
    new _query[180], fetchedName[MAX_PLAYER_NAME], lastseen[40], activity, Cache:results;
    results = mysql_query(handle, "SELECT `Username`, `Activity`, `LastLoggedIn` FROM `accounts` ORDER BY `Activity` DESC LIMIT 10");
    IRC_GroupSay(gGroupID, channel, "00,12-----[Top 10 monthly active players]-----");
    for(new Qr, rows = cache_num_rows(); Qr<rows; Qr++)
    {
        cache_get_value_name(Qr, "Username", fetchedName);
        cache_get_value_name_int(Qr, "Activity", activity);
        cache_get_value_name(Qr, "LastLoggedIn", lastseen);
        format(_query, sizeof(_query), "\x020,12 #%d\x02 - Username: \x1D%s\x1D     Last seen at: \x1D%s\x1D     Activity: \x1D%d\x1D minute(s)", Qr+1, fetchedName, lastseen, activity / 60);
        IRC_GroupSay(gGroupID, channel, _query);
    }
    IRC_GroupSay(gGroupID, channel, "00,12-----------------------------------------");
    cache_delete(results);
    return 1;
} 


It currently shows as "minutes" like it divides the time fetched from the database "Activity" which is in seconds, and divide it into 60. What I want is for it to show like: 1 Month, 1 week, 6 days, 1 hour, 13 seconds. Just like that. I'm having problems how to do it, I suppose it needs to use a unix timestamp or idk. Can anyone tell me how?