Jump to content

JReviews PaidListing and AcyMailing


brigadiar

Recommended Posts

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) 

Link to comment
  • 2 weeks later...
  • 8 months later...
×
×
  • Create New...