Question about Temp Banning (MySQL)
#9

You'll need this function:

pawn Код:
stock date(timestamp, _form = 0) // originally by pen_TheGun, edited by RealCop228
{
    /*
        ~ convert a Timestamp to a Date.
        ~ 10.07.2009

        date( 1247182451 )  will print >> 09.07.2009-23:34:11
        date( 1247182451, 1) will print >> 09/07/2009, 23:34:11
        date( 1247182451, 2) will print >> July 09, 2009, 23:34:11
        date( 1247182451, 3) will print >> 9 Jul 2009, 23:34
        * by RealCop228: date( 1247182451, 4) will print >> July 09, 2009
        * by RealCop228: date( 1247182451, 5) will print >> 23:34
    */


    new year = 1970, day = 0, month = 0, hour = 0, mins = 00, sec = 0;
    new days_of_month[12] = { 31,28,31,30,31,30,31,31,30,31,30,31 };
    new names_of_month[12][10] = {"January","February","March","April","May","June","July","August","September","October","November","December"};
    new returnstring[32];

    while(timestamp>31622400)
    {
        timestamp -= 31536000;
        if ( ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0) ) timestamp -= 86400;
        year++;
    }

    if ( ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0) )
        days_of_month[1] = 29;
    else
        days_of_month[1] = 28;


    while(timestamp>86400)
    {
        timestamp -= 86400, day++;
        if(day==days_of_month[month]) day=0, month++;
    }

    while(timestamp>60)
    {
        timestamp -= 60, mins++;
        if( mins == 60) mins=00, hour++;
    }

    sec=timestamp;

    switch(_form)
    {
        case 1: format(returnstring, 31, "%02d/%02d/%d %02d:%02d:%02d", day+1, month+1, year, hour, mins, sec);
        case 2: format(returnstring, 31, "%s %02d, %d, %02d:%02d:%02d", names_of_month[month],day+1,year, hour, mins, sec);
        case 3: format(returnstring, 31, "%d %c%c%c %d, %02d:%02d", day+1,names_of_month[month][0],names_of_month[month][1],names_of_month[month][2], year,hour,mins);
        case 4: format(returnstring, 31, "%s %02d, %d", names_of_month[month],day+1,year); // by RealCop228
        case 5: format(returnstring, 31, "%02d:%02d", hour,mins); // by RealCop228
        default: format(returnstring, 31, "%02d.%02d.%d-%02d:%02d:%02d", day+1, month+1, year, hour, mins, sec);
    }
    return returnstring;
}
For your use, you could probably do:

pawn Код:
date(iTimestamp, 2);
That's going to return a string, so probably use that in a format or something.
Reply


Messages In This Thread
Question about Temp Banning (MySQL) - by Dokins - 23.01.2012, 20:51
Re: Question about Temp Banning (MySQL) - by [HiC]TheKiller - 23.01.2012, 21:20
Re: Question about Temp Banning (MySQL) - by Dokins - 23.01.2012, 21:24
Re: Question about Temp Banning (MySQL) - by Scenario - 23.01.2012, 21:28
Re: Question about Temp Banning (MySQL) - by Dokins - 23.01.2012, 21:30
Re: Question about Temp Banning (MySQL) - by Dokins - 23.01.2012, 21:50
Re: Question about Temp Banning (MySQL) - by Scenario - 23.01.2012, 21:51
Re: Question about Temp Banning (MySQL) - by Dokins - 23.01.2012, 21:54
Re: Question about Temp Banning (MySQL) - by Scenario - 23.01.2012, 22:27

Forum Jump:


Users browsing this thread: 1 Guest(s)