getAll(); $smarty = PFASmarty::getInstance(); $q = safeget('q'); $smarty->assign('q', ''); // do not run this search stuff for an admin who has no domains associated. if (!empty($q) && !empty($list_domains)) { $params = ['q' => "%$q%"]; $domain_filter = db_in_clause('domain', $list_domains, $params); $table_alias = table_by_key('alias'); $table_domain = table_by_key('domain'); $table_mailbox = table_by_key('mailbox'); $aliases = db_query_all("SELECT * FROM $table_alias WHERE address LIKE :q AND $domain_filter ORDER BY address ASC LIMIT 15", $params); $mailboxes = db_query_all("SELECT * FROM $table_mailbox WHERE username LIKE :q AND $domain_filter ORDER BY username ASC LIMIT 15", $params); $domains = db_query_all("SELECT * FROM $table_domain WHERE domain LIKE :q AND $domain_filter AND domain != 'ALL' ORDER BY domain ASC LIMIT 15", $params); $smarty->assign('q', $q); $smarty->assign('mailboxes', $mailboxes); $smarty->assign('aliases', $aliases); $smarty->assign('domains', $domains); } $smarty->assign('smarty_template', 'main'); $smarty->display('index.tpl'); /* vim: set expandtab softtabstop=4 tabstop=4 shiftwidth=4: */