getAllUsergroups(); $form_content .= ''; $form_content .= '

' . _NOTIFICATIONS_GROUP_DIFF_TYPE . '

'; $form_content .= ''; $form_content .= ''; $form_content .= ''; $form_content .= ''; $form_content .= ''; $form_content .= ''; $form_content .= '

'; $form_content .= '
'; $form_content .= ''._SELECT_ALL.''; $form_content .= '

'; $form_content .= ''; $form_content .= '
'; $form_content .= '
'; $form_content .= ''; $form_content .= '

'; $form_content .= '
'; $form_content .= ''._SELECT_ALL.''; $form_content .= '

'; break; case 'recipients': $groups = "'". str_replace(",", "','", $notification->diffusion_properties) . "'"; $query = "SELECT distinct us.*" . " FROM usergroup_content ug " . " LEFT JOIN users us ON us.user_id = ug.user_id" . " WHERE ug.group_id in (".$groups.")"; $dbRecipients = new dbquery(); $dbRecipients->connect(); $dbRecipients->query($query); $recipients = array(); while($recipient = $dbRecipients->fetch_object()) { $recipients[] = $recipient; } break; case 'attach': $groups = "'". str_replace(",", "','", $notification->attachfor_properties) . "'"; $query = "SELECT user_id" . " FROM usergroup_content" . " WHERE group_id in (".$groups.")" . " AND user_id = '".$user_id."'"; $attach = false; $dbAttach = new dbquery(); $dbAttach->connect(); $dbAttach->query($query); if($dbAttach->nb_result() > 0) { $attach = true; } break; }