Jump to content

Heeelp plz cron jobs notification solution!


mavveton12

Recommended Posts

Im trying to create a simple cron jobs file

 

to send out an mail to accounts with low funds

 

 

SELECT Account.accountId FROM Account, Account_Ad_Fund WHERE Account_Ad_Fund.amount < Account.adFundNotificationThreshold AND Account_Ad_Fund.accountId = Account.accountId

 

 

// Find all accountIds with low funds and notification active

// List all funds, by accountId

// List fundnotificationdata by accountId

 

 

I just need the right push what im trying to do next.

 

how to write the code to perform this task, anybody im trying hade to learn php pleeease!!! im open for any solution

 

 

foreach account

if adfundnotificicationdata exists

if adfund is lower than threshold && current notificationdata is higher than threshold

sendmail...

update notificationdata...

else

insert new data...

*/

 

}

}

Link to comment
Share on other sites

how to write the code to perform this task

 

With your computer and keyboard.

 

::)

 

You haven't written any code. Or at least you haven't showed it to us. You have the logic, now write the code. When you have an actual problem we can help. 

Edited by Jessica
Link to comment
Share on other sites

With your computer and keyboard.

 

::)

 

You haven't written any code. Or at least you haven't showed it to us. You have the logic, now write the code. When you have an actual problem we can help.

 

 

:D Im working on it, and i will let you know no need to be sarcastic :D

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.