ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => Development, Suggestions => Topic started by: chufford on April 06, 2005, 02:14:01 pm

Title: BUG: User Selection - All Lists
Post by: chufford on April 06, 2005, 02:14:01 pm

Trying to make a User Selection rule to send to all users on all lists and filtering duplicates.

Make a User Selection rule of "Active - All Lists" and leave the next popup to "- More".
Click the "Show Query" button.
I see:
"SELECT * FROM lm_users WHERE (1 and cnf = '1') group by email;

54455 users matched"
Then Click "Save Selection"

Then click "Send An Email" and use the selection rule built above. This should email to all users, but instead, it finds 0 users. Below is the debug info:
tolist=rs1
not-numeric - to ruleset
tors=1
CMD=SELECT email,id FROM lm_users WHERE (list = '0' and cnf = '1') group by email
num_rows=0
Done!

Note that it puts in a list = 0 which causes no users to be found.

---

PS. Could you please include the date and time of the last update in the Members area next to the Download ListMail links? Since we don't have incrementing version numbers, it would be a way to know when/if you have posted changes since the last time we downloaded the package. Thanks.

Title: BUG: User Selection - All Lists
Post by: DW on April 06, 2005, 02:43:02 pm

This is very serious - I'm checking into it.  I will further consider how to best keep users informed of updates.

Regards

Title: BUG: User Selection - All Lists
Post by: DW on April 06, 2005, 02:52:31 pm

In selfunc.php we must add a statement.

After this (line 392):

Code: [Select]

 while(list($xrsub,$xcond,$xstat,$xlist,$xqtype,$xfield,$xq,$xqdate)=@mysql_fetch_row($rsrows)){
   $xnr++;
Add:

Code: [Select]

if($xlist=='0') $xlist = 'all';
Thanks for the heads up - the files have been updated.