× Help Forum English

[ROADMAP] Automatic email reminders (CRON job)

Début
Précédent
1
Suivant
Fin

Richard
Auteur du sujet
Nouveau membre

Plus d'informations

il y a 10 ans 11 mois - il y a 10 ans 11 mois #6412 par Richard

[ROADMAP] Automatic email reminders (CRON job) a été créé par 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.

Dernière édition: il y a 10 ans 11 mois par Lyr!C. Raison: [ROADMAP]

Connexion ou Créer un compte pour participer à la conversation.

Lyr!C
Administrateur
Lead Developer

Plus d'informations

il y a 10 ans 11 mois #6436 par Lyr!C

Réponse de Lyr!C sur le sujet 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) .

Connexion ou Créer un compte pour participer à la conversation.

Richard
Auteur du sujet
Nouveau membre

Plus d'informations

il y a 10 ans 11 mois #6467 par Richard

Réponse de Richard sur le sujet 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.

Connexion ou Créer un compte pour participer à la conversation.

Lyr!C
Administrateur
Lead Developer

Plus d'informations

il y a 10 ans 11 mois #6468 par Lyr!C

Réponse de Lyr!C sur le sujet 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

Connexion ou Créer un compte pour participer à la conversation.

Richard
Auteur du sujet
Nouveau membre

Plus d'informations

il y a 10 ans 11 mois #6469 par Richard

Réponse de Richard sur le sujet 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.

Connexion ou Créer un compte pour participer à la conversation.

Lyr!C
Administrateur
Lead Developer

Plus d'informations

il y a 10 ans 11 mois #6470 par Lyr!C

Réponse de Lyr!C sur le sujet Automatic email reminders (CRON job)

Richard écrit: 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();