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>";
}
