[CoachCarter]

Hey guys haven't been here for a while. I need a little help.

I am trying to create Donate system with Join and Expire dates and that's why I created "DonatJoinDate" "DonatExpireDate" in the Account saving table, but the problem is I can't Insert dates inside them I just don't know how.

Here is mysql database photo of that variables:


I want to make "DonatExpireDate" to be 30 days from "DonatJoinDate". I think I need this type of code:

Код:

format(query,256,"UPDATE accounts SET DonatJoinDate='%e' WHERE DonatExpireDate='%s'",newpass,PlayerName(playerid));
mysql_tquery(handlesql, query);

And also how can I detect if the expire date has come during the player spawn, like if(Expiredate >= Gettime) Removedonat(playerid);