$sContent .= ' </tr>' . "\n";
$sContent .= ' <tr>' . "\n";
$sContent .= ' <td>' . i18n("Search in", $plugin_name) . '</td>' . "\n";
$sContent .= ' <td>' . $oSelSearchIn->render() . '</td>' . "\n";
$sContent .= ' </tr>' . "\n";
$sContent .= ' <tr>' . "\n";
$sContent .= ' <td> </td>' . "\n";
$sContent .= ' <td>' . $oBtnApply->render() . '</td>' . "\n";
$sContent .= ' </tr>' . "\n";
$sContent .= ' </table>' . "\n";
$sContent .= '</form>' . "\n";
$sContent .= '</div>' . "\n";
// To template
$sLink = "listoptionsgroup";
$oListOptionsRow = new cFoldingRow("79efc1fc-111d-11dc-8314-0800200c9a66", i18n("List options", $plugin_name), $sLink, false);
$oListOptionsRow->setContentData($sContent);
$oTpl->set('s', 'LISTOPTIONLINKGROUP', $sLink);
######################################
# 4.3 Recipient groups: Paging
######################################
$oPagerLink = new cHTMLLink();
$oPagerLink->setLink("main.php");
$oPagerLink->setTargetFrame('left_bottom');
$oPagerLink->setCustom("elemperpage", $iItemsPerPage);
$oPagerLink->setCustom("filter", "");
$oPagerLink->setCustom("sortby", "name");
$oPagerLink->setCustom("sortorder", "ASC");
$oPagerLink->setCustom("searchin", "--all--");
$oPagerLink->setCustom("frame", "2");
$oPagerLink->setCustom("area", "recipientgroups");
$oPagerLink->enableAutomaticParameterAppend();
$sContent .= ' </tr>' . chr(10);
$sContent .= ' <tr>' . chr(10);
$sContent .= ' <td>' . i18n("Search for", $plugin_name) . '</td>' . chr(10);
$sContent .= ' <td>' . $oTxtFilter->render() . '</td>' . chr(10);
$sContent .= ' </tr>' . chr(10);
$sContent .= ' <tr>' . chr(10);
$sContent .= ' <td>' . i18n("Search in", $plugin_name) . '</td>' . chr(10);
$sContent .= ' <td>' . $oSelSearchIn->render() . '</td>' . chr(10);
$sContent .= ' </tr>' . chr(10);
$sContent .= ' <tr>' . chr(10);
$sContent .= ' <td> </td>' . chr(10);
$sContent .= ' <td>' . $oSubmit->render() . '</td>' . chr(10);
$sContent .= ' </tr>' . chr(10);
$sContent .= ' </table>' . chr(10);
$sContent .= '</div>' . chr(10);
$oOutsiderListOptionRow->setContentData($sContent);
// TODO: Try to enhance genericdb to get this working with the usual objects...
$oOutsiders = new RecipientCollection();
# This requires mySQL V4.1, at least...
# TODO: Add mySQL server version switch
#$sSQL = "idclient = '".$client."' AND idlang = '".$lang."' AND ".
# "idnewsrcp NOT IN (SELECT idnewsrcp FROM ".$cfg["tab"]["news_groupmembers"]." WHERE idnewsgroup = '".$_REQUEST["idrecipientgroup"]."')";
// TODO: This works with every mySQL version but may be problematic, if a group
// contains a lot of members (e.g. Oracle can't handle more than 1000 items in the brackets)
$sSQL = "idclient = '" . $client . "' AND idlang = '" . $lang . "' AND " . "idnewsrcp NOT IN ('" . implode("','", $aInsiders) . "')";
if ($_REQUEST["outsider_filter"] != "") {
$sSQLSearchIn = "";
if ($_REQUEST["outsider_searchin"] == "--all--" || $_REQUEST["outsider_searchin"] == "") {
foreach ($aFields as $sKey => $aData) {
if (strpos($aData["type"], "search") !== false) {
if ($sSQLSearchIn !== "") {
