[Despacito]

I'm trying to show register date in /stats.

This is what i did in /stats command:

pawn Код:

format(temp, sizeof(temp), ""WHITE"Register Date: "GREEN"%s\n\n",Player[playerid][RegisterDate]);
    strcat(info, temp);

Register date is saved without a single problem, it shows in RegisterDate row in mysql, i have trouble just with showing it. Because when i do stats, i get "Register Date: " (blank)

This is how i save it when a player creates an account:

pawn Код:

new query[128];
    format(query, sizeof(query), "UPDATE `notyourbusiness` SET `RegisterDate` = '%s' WHERE `user` = '%s'", ReturnDate(), Player[playerid][Name]);
    mysql_tquery(g_SQL, query);

ReturnDate:

pawn Код:

ReturnDate()
{
    static
        date[36];

    getdate(date[2], date[1], date[0]);
    gettime(date[3], date[4], date[5]);

    format(date, sizeof(date), "%02d/%02d/%d, %02d:%02d", date[0], date[1], date[2], date[3], date[4]);
    return date;
}

[Despacito]

Bump.

[Logic_]

Simply save it as a string and load it

PHP код:

getdate(year, month, day);
format(string, sizeof(string), "%02d/%02d/%d", day, month, year); 


[Despacito]

What? Makes no sense since im already saving and loading it. I just wanna show it in /stats command.

[ShihabSoft]

Show us the code, where you populate this Player[playerid][RegisterDate].

[Despacito]

pawn Код:

new query[128];
    format(query, sizeof(query), "UPDATE `players` SET `RegisterDate` = '%s' WHERE `username` = '%s'", ReturnDate(), Player[playerid][Name]);
    mysql_tquery(g_SQL, query);

The return date function is on first post.

[Despacito]

bump