× Help Forum English

[ROADMAP] Automatic email reminders (CRON job)

Inizio
Indietro
1
Avanti
Fine

Richard
Autore della discussione
New Member

Di più

10 Anni 11 Mesi fa - 10 Anni 11 Mesi fa #6412 da Richard

[ROADMAP] Automatic email reminders (CRON job) è stato creato da 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.

Ultima Modifica 10 Anni 11 Mesi fa da Lyr!C. Motivo: [ROADMAP]

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

10 Anni 11 Mesi fa #6436 da Lyr!C

Risposta da Lyr!C al 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) .

Si prega Accedi o Crea un account a partecipare alla conversazione.

Richard
Autore della discussione
New Member

Di più

10 Anni 11 Mesi fa #6467 da Richard

Risposta da Richard al 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.

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

10 Anni 11 Mesi fa #6468 da Lyr!C

Risposta da Lyr!C al 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

Si prega Accedi o Crea un account a partecipare alla conversazione.

Richard
Autore della discussione
New Member

Di più

10 Anni 11 Mesi fa #6469 da Richard

Risposta da Richard al 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.

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

10 Anni 11 Mesi fa #6470 da Lyr!C

Risposta da Lyr!C al topic Automatic email reminders (CRON job)

Richard ha scritto: 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();