Display list autoresponders in order of send out

no12pixels

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.

derekbeau

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.

Gowtham

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

daniavorszky

Any news on this feature?

airau

Would love to see this feature implemented!

samsebepan

Yep. Please add this

danfitmedia

+1 for this feature too

steve_g

Definitely need this feature. Ordering by the ID is just silly.

kilianvalkhof

I would really appreciate this feature as well, +1

mathijsvdbeek

+1 for me also.