Register Date - Printable Version

Register Date - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Register Date (/showthread.php?tid=575293)

Register Date - Joe70701 - 25.05.2015

Hi, I want help with my register date.
Well, The register date is inserted into the database normally, all of the date appears, like 25/05/2015.

But when I test it in a command in game, Only the year appears.

My code:

pawn Код:

COMMAND:regdate(playerid, params[])
{
        new rstring[120];
        format(rstring, sizeof(rstring), "Your register date is %d", pInfo[playerid][RegisteredOn]);
        SendClientMessage(playerid, -1, rstring);
        return 1;
}

The INSERT INTO query:

pawn Код:

mysql_format(mysql, query, sizeof(query), "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX` ,`PosY`, `PosZ`, `Score`, `Infections`, `RegisteredOn`, `Kills`, `Deaths`) VALUES ('%e', '%s', '%s', 0, 0, 0, 0.0, 0.0, 0.0, 0, 0, NOW(), 0, 0)", Name[playerid], pInfo[playerid][Password], IP[playerid]);
                        //Now let's create a new row and insert player's information in it
                        mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);

Re: Register Date - Vince - 25.05.2015

You must use the string specifier. Not everything with a number in it can be formatted as a number. I would also suggest looking at Unix timestamps. There's a tutorial on these forums somewhere.

Re: Register Date - Ghazal - 25.05.2015

I have the same problem, to save time and threads, I am posting here.
Vince, Can you give example?

Re: Register Date - Konstantinos - 25.05.2015

https://dev.mysql.com/doc/refman/5.5...l#function_now
https://dev.mysql.com/doc/refman/5.5...on_date-format

The type of the field "Timestamp" and set it default value as define NOW(). When registering, it will insert the current timestamp itself. When loading use DATE_FORMAT(field_name, format_here)

The formats can be found in the link above.

Re: Register Date - Ghazal - 25.05.2015

Quote:

Originally Posted by Konstantinos

https://dev.mysql.com/doc/refman/5.5...l#function_now
https://dev.mysql.com/doc/refman/5.5...on_date-format

The type of the field "Timestamp" and set it default value as define NOW(). When registering, it will insert the current timestamp itself. When loading use DATE_FORMAT(field_name, format_here)

The formats can be found in the link above.

I changed the format into TIMESTAMP in MySQL, I don't understand what do you mean by

Quote:

When loading use DATE_FORMAT(field_name, format_here)

Re: Register Date - Konstantinos - 25.05.2015

DATE_FORMAT can be used in queries to select the date and time with a format you apply. For example:

PHP код:



"SELECT DATE_FORMAT(register_date,'%W, %e %M %Y %r') AS date_time FROM players WHERE Name='Maro06';"

That would return (let's say register_date has the timestamp of few seconds ago): Monday, 25 May 2015 06:57:35 PM

Keep in mind that you'll have to use % sign twice in format or mysql_format functions (PAWN).

Re: Register Date - Ghazal - 25.05.2015

Quote:

Originally Posted by Konstantinos

DATE_FORMAT can be used in queries to select the date and time with a format you apply. For example:

PHP код:



"SELECT DATE_FORMAT(register_date,'%W, %e %M %Y %r') AS date_time FROM players WHERE Name='Maro06';"

I am sorry but I am really confused.

Can someone tell me where to put this and how?

Re: Register Date - Konstantinos - 25.05.2015

DATE_FORMAT is optional. The reason I mentioned it is because in my country and most countries, the date/time formats differ.

You can still load the registered date field (which is saved as TIMESTAMP) as a string with cache_get_row function. It's just that the format will be YEAR-MONTH-DAY HOURS:MINUTES:SECONDS

Re: Register Date - Ghazal - 25.05.2015

Quote:

Originally Posted by Konstantinos

DATE_FORMAT is optional. The reason I mentioned it is because in my country and most countries, the date/time formats differ.

You can still load the registered date field (which is saved as TIMESTAMP) as a string with cache_get_row function. It's just that the format will be YEAR-MONTH-DAY HOURS:MINUTES:SECONDS

Can you just edit the codes in the thread and ill understand?

Re: Register Date - Konstantinos - 25.05.2015

Quote:

Originally Posted by Maro06

Can you just edit the codes in the thread and ill understand?

Just load the player's data including the RegisteredOn or however that field of yours is named and store it to your variable using cache_get_row function (it's pretty much the same way you load any data).