Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Display list autoresponders in order of send out
  • ive just noticed that list auto responders, based on dates display in the order in which you add them.

    i know this is because the db auto selects them by id.

    i just added a responder to send after 2 days, but i already have responders set for 7 days.

    now the 2 day responder still shows after the 7 day one because i added it after the first one.

    its a simple fix and would make it much easier and less confusing if it ordered them by date from, and not by id.

  • 5 Comments
  • Vote Up0Vote Down derekbeauderekbeau
    Posts: 1Sendy user

    Just installed Sendy and this is the first thing I needed to modify for myself. Here's what I did...

    Edit autoresponders-emails.php and change this line:

    $q = 'SELECT * FROM ares_emails WHERE ares_id = '.mysqli_real_escape_string($mysqli, $_GET['a']);

    to this:

    $q = 'SELECT *, CONVERT(SUBSTRING_INDEX(SUBSTR(time_condition, 2), " ", 1),UNSIGNED INTEGER) AS delay FROM ares_emails WHERE ares_id = '.mysqli_real_escape_string($mysqli, $_GET['a'].' ORDER BY delay ASC');

    The limitation here is that this orders by the integer only; it does not take into account what type of delay it is (day/month/etc). But that is sufficient for what I need, and better, in my opinion, than ordering by ID.

  • Vote Up0Vote Down GowthamGowtham
    Posts: 9Sendy user

    Is this option implemented in the new version or we have to modify ?

  • Any news on this feature?

  • Vote Up0Vote Down airauairau
    Posts: 3Sendy user

    Would love to see this feature implemented!

  • Yep. Please add this :)