× Help Forum English

[ROADMAP] Automatic email reminders (CRON job)

Start
Prev
1
Next
End

Richard
Topic Author
New Member

10 years 11 months ago - 10 years 11 months ago #6412 by Richard

[ROADMAP] Automatic email reminders (CRON job) was created by Richard

Hi

I have just been looking at your !Cagenda component for Joomla and wondered if anyone had tried to create a cron job allowing emails to be sent automatically to anyone attending events the night before the event.

If not any hints would be helpful.

Last edit: 10 years 11 months ago by Lyr!C. Reason: [ROADMAP]

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

10 years 11 months ago #6436 by Lyr!C

Replied by Lyr!C on topic Automatic email reminders (CRON job)

Thanks for you post!

As the developper, i won't be able to work on this feature before a few months (and not yet enought skills in CRON job)

So, if someone has skill on CRON job, and has worked on it, he can contact me to propose his code to the community ;-)

Lyr!C

Latest version : iCagenda 3.9.8
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

Please Log in or Create an account to join the conversation.

Richard
Topic Author
New Member

10 years 11 months ago #6467 by Richard

Replied by Richard on topic Automatic email reminders (CRON job)

A CRON job is just a link to a php page that can perform tasks at a set time. When I have written them I have found at times it is difficult to pass parameters on the command line and you must remember that you don't always get output. So it is best to use the error log for messages. Also quite easy to send emails. Main problem is how to access Joomla database without login.

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

10 years 11 months ago #6468 by Lyr!C

Replied by Lyr!C on topic Automatic email reminders (CRON job)

Main problem is how to access Joomla database without login.

Hi!

What do mean by this ? Login where ?
If you want to get data from database, you don't have to login to database, if you're using Joomla Query...

Lyr!C

Please Log in or Create an account to join the conversation.

Richard
Topic Author
New Member

10 years 11 months ago #6469 by Richard

Replied by Richard on topic Automatic email reminders (CRON job)

I have never used Joomla Query. I will investigate. However my main worry is not leaving a program open to the hackers - so would always try to access the database via a login.

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

10 years 11 months ago #6470 by Lyr!C

Replied by Lyr!C on topic Automatic email reminders (CRON job)

Richard wrote: I have never used Joomla Query. I will investigate. However my main worry is not leaving a program open to the hackers - so would always try to access the database via a login.

No need to login, and all process is done by joomla (exemple of a simple query):

// Get the database connector.
$db = JFactory::getDBO();

// Get the query from the database connector.
$query = $db->getQuery(true);

// Build the query programatically (using chaining if desired).
$query->select('u.*')
    // Use the qn alias for the quoteName method to quote table names.
    ->from($db->qn('#__users').' AS u'));

// Tell the database connector what query to run.
$db->setQuery($query);

// Invoke the query or data retrieval helper.
$users = $db->loadObjectList();