1 <?php
2 // 
3 // Postfix Admin 
4 // by Mischa Peters <mischa at high5 dot net>
5 // Copyright (c) 2002 - 2005 High5!
6 // License Info: http://www.postfixadmin.com/?file=LICENSE.TXT
7 //
8 // File: search.php
9 //
10 // Template File: search.tpl
11 //
12 // Template Variables:
13 //
14 // tAlias
15 // tMailbox
16 //
17 // Form POST \ GET Variables:
18 //
19 // fSearch
20 //
21 require ("./variables.inc.php");
22 require ("./config.inc.php");
23 require ("./functions.inc.php");
24 include ("./languages/" . check_language () . ".lang");
25 
26 $SESSID_USERNAME = check_session();
27 
28 $tAlias = array();
29 $tMailbox = array();
30 
31 if ($_SERVER['REQUEST_METHOD'] == "GET")
32 {
33    if (isset ($_GET['search'])) $fSearch = escape_string ($_GET['search']);
34 
35    if ($CONF['alias_control'] == "YES")
36    {
37       $query = "SELECT alias.address,alias.goto,alias.modified,alias.domain FROM alias WHERE alias.address LIKE '%$fSearch%' OR alias.goto LIKE '%$fSearch%' ORDER BY alias.address";
38    }
39    else
40    {
41       $query = "SELECT alias.address,alias.goto,alias.modified,alias.domain FROM alias LEFT JOIN mailbox ON alias.address=mailbox.username WHERE alias.address LIKE '%$fSearch%' AND mailbox.maildir IS NULL ORDER BY alias.address";
42    }
43 
44    $result = db_query ("$query");
45    
46    if ($result['rows'] > 0)
47    {
48       while ($row = db_array ($result['result']))
49       {
50          if (check_owner ($SESSID_USERNAME, $row['domain']))
51          {
52             $tAlias[] = $row;
53          }
54       }
55    }
56 
57    $result = db_query ("SELECT * FROM mailbox WHERE username LIKE '%$fSearch%' ORDER BY username");
58    if ($result['rows'] > 0)
59    {
60       while ($row = db_array ($result['result']))
61       {
62          if (check_owner ($SESSID_USERNAME, $row['domain']))
63          {
64             $tMailbox[] = $row;
65          }
66       }
67    }
68 
69    include ("./templates/header.tpl");
70    include ("./templates/menu.tpl");
71    include ("./templates/search.tpl");
72    include ("./templates/footer.tpl");
73 }
74 
75 if ($_SERVER['REQUEST_METHOD'] == "POST")
76 {
77    if (isset ($_POST['search'])) $fSearch = escape_string ($_POST['search']);
78 
79    if ($CONF['alias_control'] == "YES")
80    {
81       $query = "SELECT alias.address,alias.goto,alias.modified,alias.domain FROM alias WHERE alias.address LIKE '%$fSearch%' OR alias.goto LIKE '%$fSearch%' ORDER BY alias.address";
82    }
83    else
84    {
85       $query = "SELECT alias.address,alias.goto,alias.modified,alias.domain FROM alias LEFT JOIN mailbox ON alias.address=mailbox.username WHERE alias.address LIKE '%$fSearch%' AND mailbox.maildir IS NULL ORDER BY alias.address";
86    }
87 
88    $result = db_query ("$query");
89    
90    if ($result['rows'] > 0)
91    {
92       while ($row = db_array ($result['result']))
93       {
94          if (check_owner ($SESSID_USERNAME, $row['domain']))
95          {
96             $tAlias[] = $row;
97          }
98       }
99    }
100 
101    $result = db_query ("SELECT * FROM mailbox WHERE username LIKE '%$fSearch%' ORDER BY username");
102    if ($result['rows'] > 0)
103    {
104       while ($row = db_array ($result['result']))
105       {
106          if (check_owner ($SESSID_USERNAME, $row['domain']))
107          {
108             $tMailbox[] = $row;
109          }
110       }
111    }
112 
113    include ("./templates/header.tpl");
114    include ("./templates/menu.tpl");
115    include ("./templates/search.tpl");
116    include ("./templates/footer.tpl");
117 }
118 ?>