And these are the files you've been looking at. send_email_news_ray.php is the version I just downloaded, but I may have uploaded an incorrect version before as there is a reference to PartnerIDPL in the array. Send_email_news.php is the version with the LodgeID in the array, which I thought was all that is needed here?
And the SQL:
$query_EmailList = "SELECT DISTINCT Email, Firstname, Username, Password
FROM trade_users
INNER JOIN product_likes ON trade_users.UserID = product_likes.UserIDPL
INNER JOIN lodges ON lodges.LodgeID = product_likes.LodgeIDPL
";
$query_EmailList .= " WHERE subscription = 'Gold' AND LodgeID IN (".implode(", ",$WA_lodgeArray).")";
So the news item is added for that LodgeID, the LodgeID is stored it the array. And then the SQL sends an email to every user which is connected to that lodge via the product_likes table.
Were you able to see any emails sending?
