(moved from Support Requests)

I've been working on the post_thanks hack and have (almost) successfully transformed it into a point system that gives the user the option to give more than one thank (point) per day. Unfortunately I'm not sure how to create a system using the TIMENOW function where you reset the number in, let's say, post_thanks_thanks_already to 25.

So I just want this number to be 25 at midnight on the dot, to put this simply. Kudos to anyone who can help me!

So you want to set everyone's post_thanks_thanks_already to 25 at midnight? I'm sorry, I don't seem to get it :p

Basically I've created a points system where people can thank items only 25 times a day, and also thank a post more than once. This gets displayed in points.

For example instead of the thanks button, you get 1-10. These links all work and give 1 to 10.



BUT I don't want people to thank things millions and millions of times a day. So I set the number of thanks used daily to 25.

My question is that I want to use the timenow function and post_thanks_thanks_already to have a fixed amount that is set at the same point each day.

This may look stupid but i've tried something like...

That's quickly jotted up... if I complete this idea I will post this here on vbhackers. Do you think you can help me?

Sorry I meant post_thanks_already :Z

Well, you could add a new table called 'thankstoday', with the rows userid, threadid and numberthanks. Then add a cronjob which clears that table every night at 00:00.

Okay, this is where I'm lost... could you show me an example of a cronjob that clears at a set time? It's the set time thing I'm having trouble with.

Here's a nice howto on how to make cronjobs. Simply add a query to clear the table, and add it as a cronjob. Set that cronjob to run at 23:59 and you're done

Do you have a tables creating tutorial? I've got some idea but I just want to get this right, that's all.

What you can do is go into phpmyadmin get a test db and then add a table and set it all up then press create and phpmyadmin will show you the query it ran to do that. You can that put that query wherever you want eg. a product xml file