25.05.2015, 14:11
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:
The INSERT INTO query:
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);