[spamipolito]

Hi Guys. I have a problem with a new admin system.

I have these data:


admin_vencimiento = expiration date
admin_horavencimiento = expiration hour

Load data and convert with unixtime

PHP Code:

            new szDate[12], szDay[3], szMonth[3], szYear[5]

            mysql_read_result( mysql_fieldnametonum( "admin_vencimiento" ), szDate, 11 )
            replace_all(szDate, charsmax(szDate), "/", " ")
            parse(szDate, szDay, 2, szMonth, 2, szYear, 4);


            new szHours[9], szHour[3], szMinute[3], szSecond[3]

            mysql_read_result( mysql_fieldnametonum( "admin_horavencimiento" ), szHours, 8 )
            replace_all(szHours, charsmax(szHours), ":", " ")
            parse(szHours, szHour, 2, szMinute, 2, szSecond, 2);

            server_print("Admin Expiration Date Convert: %d", TimeToUnix(str_to_num(szYear), str_to_num(szMonth), str_to_num(szDay), str_to_num(szHour), str_to_num(szMinute), 0, UT_TIMEZONE_SERVER)) 


Printing timestamp with console server:

Admin Expiration Date Convert: 1595691840

Convert timestamp (1595691840) with page:


This is real expiration hour:


Sorry for my bad english, i am from argentina

[krisztian2]

You have to divide this unix value with 86400. That, you get day format.

[spamipolito]

Originally Posted by krisztian2 You have to divide this unix value with 86400. That, you get day format.

That makes no sense. TimeToUnix convert date day/hour to timestamp.

PHP Code:

stock TimeToUnix( const iYear , const iMonth , const iDay , const iHour , const iMinute , const iSecond , TimeZones:tzTimeZone=UT_TIMEZONE_UTC)
{
    new i , iTimeStamp;

    for ( i = 1970 ; i < iYear ; i++ )
        iTimeStamp += YearSeconds[ IsLeapYear(i) ];

    for ( i = 1 ; i < iMonth ; i++ )
        iTimeStamp += SecondsInMonth( iYear , i );

    iTimeStamp += ( ( iDay - 1 ) * DaySeconds );
    iTimeStamp += ( iHour * HourSeconds );
    iTimeStamp += ( iMinute * MinuteSeconds );
    iTimeStamp += iSecond;

    if ( tzTimeZone == UT_TIMEZONE_SERVER )
        tzTimeZone = GetTimeZone();
        
    return ( iTimeStamp + TimeZoneOffset[ tzTimeZone ] );
} 


Solved:

PHP Code:


UT_TIMEZONE_SERVER
// --->
UT_TIMEZONE_ART