Viewing file: site.php (5.47 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php include_once dirname(__FILE__) . '/config/variables.php'; include_once dirname(__FILE__) . '/config/authsite.php'; include_once dirname(__FILE__) . '/config/functions.php'; include_once dirname(__FILE__) . '/config/httpheaders.php';
if (isset($_GET['LETTER'])) { $letter = strtolower($_GET['LETTER']); } else { $letter = ''; } if (!isset($_POST['searchfor'])) { $_POST['searchfor'] = ''; } ?> <html> <head> <title><?php echo _('Virtual Exim') . ': ' . _('Manage Sites'); ?></title> <link rel="stylesheet" href="style.css" type="text/css"> </head> <?php include dirname(__FILE__) . '/config/header.php'; ?> <div id="menu"> <a href="siteadd.php?type=alias"><?php echo _('Add alias domain'); ?></a><br> <a href="siteadd.php?type=local"><?php echo _('Add local domain'); ?></a><br> <a href="siteadd.php?type=relay"><?php echo _('Add relay domain'); ?></a><br> <a href='sitepassword.php'><?php echo _('Site Password'); ?></a><br> <br><a href="logout.php"><?php echo _('Logout'); ?></a><br> </div> <div id="Content"> <?php alpha_menu($alphadomains); ?> <form name="search" method="post" action="site.php"> <?php echo _('Search'); ?>: <input type="text" size="20" name="searchfor" value="<?php echo $_POST['searchfor']; ?>" class="textfield"> <input type="submit" name="search" value="<?php echo _('search'); ?>"> </form> <table> <tr> <th></th> <th><?php echo _('Local domains'); ?></th> <th><?php echo _('Admin account'); ?></th> <th><?php echo _('Total admins'); ?></th> </tr> <?php $query = "SELECT MIN(localpart) AS localpart, domain, domains.domain_id, count(*) AS count FROM users, domains WHERE users.domain_id = domains.domain_id AND domain !='admin' AND admin=1"; if ($alphadomains AND $letter != '') $query .= " AND lower(domain) LIKE lower('$letter%')"; elseif ($_POST['searchfor'] != '') $query .= " AND domain LIKE '%" . $_POST['searchfor'] . "%' "; $query .= " GROUP BY domains.domain, domains.domain_id ORDER BY domain"; $result = $db->query($query); if ($result->numRows()) { while ($row = $result->fetchRow()) { ?> <tr> <td> <a href="sitedelete.php?domain_id=<?php echo $row['domain_id']; ?>&domain=<?php echo $row['domain']; ?>"> <img class="trash" title="Delete <?php $row['domain']; ?>" src="images/trashcan.gif" alt="trashcan"> </a> </td> <td> <a href="sitechange.php?domain_id=<?php echo $row['domain_id']; ?>&domain=<?php echo $row['domain']; ?>"><?php echo $row['domain']; ?></a> </td> <?php if ($row['count'] == 1) { ?> <td><?php echo $row['localpart'] . '@' . $row['domain']; ?></td> <?php } else { ?> <td><?php echo _('Multiple admins'); ?></td> <?php } ?> <td><?php echo $row['count']; ?></td> </tr> <?php } } ?> <tr><td></td></tr> <tr> <td colspan="3"> <b><?php echo _('WARNING') ?>:</b> <?php echo _('Deleting a domain will delete all user accounts in that domain permanently!'); ?> </td> </tr> <tr><td></td></tr> <tr> <th></th> <th><?php echo _('Relay domains'); ?></th> </tr> <?php $query = "SELECT domain,domain_id FROM domains WHERE domain !='admin' AND type='relay' ORDER BY domain"; $result = $db->query($query); if ($result->numRows()) { while ($row = $result->fetchRow()) { ?> <tr> <td> <a href="sitedelete.php?domain_id=<?php echo $row['domain_id']; ?>&domain=<?php echo $row['domain']; ?>&type=relay"> <img class="trash" title="<?php echo _('Delete') . $row['domain']; ?>" src="images/trashcan.gif" alt="trashcan"> </a> </td> <td><?php echo $row['domain']; ?></td> </tr> <?php } } ?> <tr> <th></th> <th><?php echo _('Aliased domains'); ?></th> </tr> <?php $query = "SELECT alias,domain FROM domainalias,domains WHERE domainalias.domain_id = domains.domain_id"; $result = $db->query($query); if ($result->numRows()) { while ($row = $result->fetchRow()) { ?> <tr> <td> <a href="sitedelete.php?domain_id=<?php echo $row['domain_id']; ?>&domain=<?php echo $row['alias']; ?>&type=alias"> <img class="trash" title="<?php echo _('Delete') . $row['alias']; ?>" src="images/trashcan.gif" alt="trashcan"> </a> </td> <td colspan="3"> <?php echo $row['alias'] . '->' . $row['domain']; ?> </td> </tr> <?php } } ?> </table> </div> </body> </html> <!-- Layout and CSS tricks obtained from http://www.bluerobot.com/web/layouts/ -->
|