Cronjob + Mysql

Cronjob + Mysql
I need a cronjob script/php to be made.
It must do the following:

Every midnight, it connects to my SQL table.
It checks table Deposits. Searches for active deposits. When it finds an active deposit, it credits deposit amount/365 to user balance in another table.
It also checks deposit expiration date. If it’s today, then it moves the deposit data from the table to table Expireds. If it past today, then send admin a mail with warning and do not credit

The script must be done as a sample, and I’ll integrate it into my own table.
I’m not going to give sample DB or DB access because this is an already running site.

Bids under $20 please.

Leave a Reply

Your email address will not be published. Required fields are marked *