Reply to thread

Message

<blockquote data-quote="MayoMayn" data-source="post: 392808" data-attributes="member: 71840">[PHP] DATE(`daily_time`) &lt;= CURRENT_DATE - INTERVAL 23 HOUR [/PHP]If you want it to be daily [USER=72035]@Sly[/USER], and reset at a new day (00:00) this is how I did it, the reason I made it 23 hours and not 24 hours, depends on the local time of the user and the mysql.And another thing, [USER=51728]@JMS[/USER], there's no reason at all to use &quot;*&quot; when the only think you're fetching from the table is &quot;id&quot;, which will just make the query slower. You don't really need to brag about anything, if you don't even know such simple details.PM me [USER=72035]@Sly[/USER], and I will provide a full daily reward function with sql, with different items based on the probability of receiving them, you will just have to convert it from PDO to mysql_[SPOILER]<a href="http://imgur.com/a/KuWgU" target="_blank">http://imgur.com/a/KuWgU</a>[/SPOILER]</blockquote>

[QUOTE="MayoMayn, post: 392808, member: 71840"] [PHP] DATE(`daily_time`) <= CURRENT_DATE - INTERVAL 23 HOUR [/PHP] If you want it to be daily [USER=72035]@Sly[/USER], and reset at a new day (00:00) this is how I did it, the reason I made it 23 hours and not 24 hours, depends on the local time of the user and the mysql. And another thing, [USER=51728]@JMS[/USER], there's no reason at all to use "[B]*[/B]" when the only think you're fetching from the table is "[B]id[/B]", which will just make the query slower. You don't really need to brag about anything, if you don't even know such simple details. PM me [USER=72035]@Sly[/USER], and I will provide a full daily reward function with sql, with different items based on the probability of receiving them, you will just have to convert it from [B]PDO[/B] to [B]mysql_[/B] [SPOILER] [URL]http://imgur.com/a/KuWgU[/URL] [/SPOILER] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members