Jump to content
brigadiar

JReviews PaidListing and AcyMailing

Recommended Posts

brigadiar

Hi there, want to tell you about how to sort users with Paid Plans in AcyMailing

1. Download AcyMailing filter plugin

2. Create Smart-NewsLetter , choose Advanced Query , paste this code if you sort by:

 

email

SELECT User.email AS `email`
FROM #__content AS Listing 
LEFT JOIN #__users AS User ON User.id = Listing.created_by 
WHERE 
(Listing.id IN (SELECT DISTINCT listing_id FROM #__jreviews_paid_orders WHERE order_active = 1 and plan_id IN (4,5,6)))

4,5,6 - it's your paidListing ID's

 

or

 

UserName

SELECT User.name AS `name`
FROM #__content AS Listing 
LEFT JOIN #__users AS User ON User.id = Listing.created_by 
WHERE 
(Listing.id IN (SELECT DISTINCT listing_id FROM #__jreviews_paid_orders WHERE order_active = 1 and plan_id IN (4,5,6)))

3. If you want to exclude these users from the rest of the mailing list you need:

  - create Mass action filter

- paste code above

- unsubscribe this users from "Global list" or sign to another list.

       - click Save

 

4. If you want to exclude these users automatically you need to set up CRON

read this

 

 

share your experience here  8) 

Share this post


Link to post
JAN44

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
IvorJ

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Jreviews Addict

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Ant

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Jreviews Addict

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
JAN44

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Jreviews Addict

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Please refer to our Privacy Policy.