1725
Xoops 2.5.9
attempting to fix oledrions bug: "Oledrion\Utility::getEmailsFromGroup" is returning empty
The emails are for the vendor to be notified of sale.
// grp_sold is config var == 1 (Administrator group)
$db = XoopsDatabaseFactory::getDatabaseConnection();
$grp_sold_user_ids = []; // Array of user ID's to send emails to
$sql = 'SELECT uid FROM ' . $db->prefix('groups_users_link') . ' WHERE groupid=' . (int)$grp_sold;
$result_sql = $db->query($sql);
if ($result_sql) {
while ($myrow = $db->fetchArray($result_sql)) {
$grp_sold_user_ids[] = $myrow['uid'];
}
}
file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "implode: " . implode(',', $grp_sold_user_ids) . "n", FILE_APPEND | LOCK_EX);
$sql = 'SELECT email FROM ' . $db->prefix('users') . ' WHERE uid IN (' . implode(',', $grp_sold_user_ids) . ')';
$admin_emails = [];
$result_sql = $db->query($sql);
if ($result_sql) {
while ($myrow = $db->fetchArray($result_sql)) {
$admin_emails[] = $myrow['email'];
}
}
What I am seeing:
$grp_sold_user_ids tests as array, print_r($grp_sold_user_ids); evaluates to 1
implode(',', $grp_sold_user_ids); // returns null should be 1
implode(',', array(1,2,3); //returns 1,2,3 - OK
implode(',', array(1); //returns 1 - OK
Anyone?
Thanks, Bill
