function policy_domain() { $page = CurrentPageName(); $tpl = new templates(); $t = time(); $q = new amavisdb(); $boot = new boostrap_form(); $email = $_GET["policy-domain"]; $sql = "SELECT id,policy_name FROM policy WHERE ou='{$_SESSION["ou"]}' ORDER BY policy_name"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo "<p class=text-error>{$q->mysql_error}<br>{$sql}<hr></p>"; } $policies[0] = "{default}"; while ($ligne = mysql_fetch_assoc($results)) { $policies[$ligne["id"]] = $ligne["policy_name"]; } $email_id = $q->emailid_from_email("@{$email}"); $policy_id = $q->policyid_from_mail("@{$email}"); $boot->set_hidden("policy_domain", $email); $boot->set_hidden("email_id", $email_id); $boot->set_list("policy_id", "{policy}", $policies, $policy_id); $boot->set_button("{apply}"); $boot->set_CallBack("YahooWin2Hide"); $boot->set_RefreshSearchs(); echo $boot->Compile(); }
function wbl_search() { $amavis = new amavisdb(); $boot = new boostrap_form(); $page = CurrentPageName(); $tpl = new templates(); $searchstring = string_to_flexquery("wbl-search"); $user = new user($_SESSION["uid"]); $mails = $user->HASH_ALL_MAILS; while (list($b, $email) = each($mails)) { $rid = $amavis->emailid_from_email($email); $f[] = "(rid={$rid})"; } if (!$amavis->TABLE_EXISTS("wblist")) { $sql = "CREATE TABLE IF NOT EXISTS wblist (rid integer unsigned NOT NULL,sid integer unsigned NOT NULL,wb varchar(10) NOT NULL,PRIMARY KEY (rid,sid));"; $amavis->QUERY_SQL($sql); if (!$q->ok) { echo "<p class=text-error>{$amavis->mysql_error}<hr><code>{$sql}</code></p>"; return; } } $table = "(SELECT * FROM `wblist` WHERE (" . @implode(" OR ", $f) . ") ) as t"; $table = "(SELECT `mailaddr`.email,`users`.email as rcpt, `t`.* FROM {$table},`mailaddr`,`wblist` ,`users`\n\tWHERE \n\t`mailaddr`.id=`t`.sid AND \n\t`users`.id=`t`.rid AND\n\tt.wb='{$_GET["type"]}') as y"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY email"; $results = $amavis->QUERY_SQL($sql); if (!$amavis->ok) { echo "<p class=text-error>{$amavis->mysql_error}<hr><code>{$sql}</code></p>"; } while ($ligne = mysql_fetch_assoc($results)) { $jshost = "Loadjs('{$page}?wbl-js=yes&rid={$ligne["rid"]}&sid={$ligne["sid"]}&type={$_GET["type"]}');"; $link = $boot->trswitch($jshost); $tr[] = "\n\t\t<tr id='{$id}'>\n\t\t<td {$link}><i class='icon-globe'></i> {$ligne["email"]}</a></td>\n\t\t<td {$link}><i class='icon-globe'></i> {$ligne["rcpt"]}</a></td>\n\t\t<td style='text-align:center'>{$delete}</td>\n\t\t</tr>"; } echo $tpl->_ENGINE_parse_body("\n\t<table class='table table-bordered table-hover'><thead><tr>\n\t\t\t<th>{sender}</th>\n\t\t\t<th>{email}</th>\n\t\t\t\n\t\t\t<th> </th></tr></thead><tbody>") . @implode("\n", $tr) . " </tbody></table>"; }