trAvis - MANAGER
Edit File: postfix-distgroups-add.php
<?php # Postfix distribution group add # Copyright (C) 2009-2011, AllWorldIT # Copyright (C) 2008, LinuxRulz # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License along # with this program; if not, write to the Free Software Foundation, Inc., # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. include_once("includes/header.php"); include_once("includes/footer.php"); include_once("includes/db.php"); $db = connect_postfix_db(); printHeader(array( "Tabs" => array( "Back to groups" => "postfix-distgroups-main.php", ), )); if ($_POST['frmaction'] == "add") { ?> <p class="pageheader">Add Distribution Group</p> <?php ?> <form method="post" action="postfix-distgroups-add.php"> <div> <input type="hidden" name="frmaction" value="add2" /> <input type="hidden" name="postfix_group_id" value="<?php echo $_POST['postfix_group_id'] ?>" /> </div> <table class="entry"> <tr> <td class="entrytitle">Mail Address</td> <td> <input type="text" name="postfix_group_address" /> @ <select name="postfix_transport_id"> <?php $sql = "SELECT ID, DomainName FROM ${DB_TABLE_PREFIX}transports WHERE Disabled = 0 ORDER BY DomainName"; $res = $db->query($sql); while ($row = $res->fetchObject()) { ?> <option value="<?php echo $row->id ?>"> <?php echo $row->domainname ?> </option> <?php } $res->closeCursor(); ?> </select> </td> </tr> <tr> <td class="entrytitle">Comment</td> <td><textarea name="postfix_group_comment"></textarea></td> </tr> <tr> <td colspan="2"> <input type="submit" /> </td> </tr> </table> </form> <?php # Check we have all params } elseif ($_POST['frmaction'] == "add2") { ?> <p class="pageheader">Distribution Group Add Results</p> <?php # Prepare statement $stmt = $db->prepare("SELECT ID, DomainName, Type, Transport, Disabled FROM ${DB_TABLE_PREFIX}transports WHERE ID = ?"); $res = $stmt->execute(array($_POST['postfix_transport_id'])); $row = $stmt->fetchObject(); $mailbox = $_POST['postfix_group_address'] . '@' . $row->domainname; $stmt = $db->prepare("INSERT INTO ${DB_TABLE_PREFIX}distribution_groups (TransportID,Address,MailAddress,Comment,Disabled) VALUES (?,?,?,?,0)"); $res = $stmt->execute(array( $row->id, $_POST['postfix_group_address'], $mailbox, $_POST['postfix_group_comment'] )); if ($res) { ?> <div class="notice">Distribution group created</div> <?php } else { ?> <div class="warning">Failed to create distribution group</div> <div class="warning"><?php print_r($stmt->errorInfo()) ?></div> <?php } } else { ?> <div class="warning">Invalid invocation</div> <?php } printFooter(); # vim: ts=4 ?>