updated mail module

tbrehm

2007-05-23 22e7f9de84d631f97588c9acaf1f05c860eda088

updated mail module

 interface/lib/app.inc.php

@@ -170,6 +170,9 @@
                $this->tpl->setVar('app_title',$conf["app_title"]);
                $this->tpl->setVar('delete_confirmation',$this->lng('delete_confirmation'));
                $this->tpl->setVar('app_module',$_SESSION["s"]["module"]["name"]);
                if($_SESSION["s"]["user"]["typ"] == 'admin') {
                    $this->tpl->setVar('is_admin',1);
                }

          }


 interface/lib/classes/tform_actions.inc.php

@@ -1,521 +1,534 @@
<?php



/*

Copyright (c) 2005, Till Brehm, projektfarm Gmbh

All rights reserved.



Redistribution and use in source and binary forms, with or without modification,

are permitted provided that the following conditions are met:



    * Redistributions of source code must retain the above copyright notice,

      this list of conditions and the following disclaimer.

    * Redistributions in binary form must reproduce the above copyright notice,

      this list of conditions and the following disclaimer in the documentation

      and/or other materials provided with the distribution.

    * Neither the name of ISPConfig nor the names of its contributors

      may be used to endorse or promote products derived from this software without

      specific prior written permission.



THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND

ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.

IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,

INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,

BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,

DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY

OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING

NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,

EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

*/



/**

* Action framework for the tform library.

*

* @author Till Brehm <t.brehm@scrigo.org>

* @copyright Copyright &copy; 2005, Till Brehm

*/



class tform_actions {



        var $id;

        var $activeTab;

        var $dataRecord;

        var $plugins = array();



        function onLoad() {

                global $app, $conf, $tform_def_file;



                // Loading template classes and initialize template

                if(!is_object($app->tpl)) $app->uses('tpl');

                if(!is_object($app->tform)) $app->uses('tform');



                $app->tpl->newTemplate("tabbed_form.tpl.htm");



                // Load table definition from file

                $app->tform->loadFormDef($tform_def_file);

				
                // Importing ID

                $this->id = intval($_REQUEST["id"]);

				
                // show print version of the form

                if($_GET["print_form"] == 1) {

                    $this->onPrintForm();

                }

				
                // send this form by email

                if($_GET["send_form_by_mail"] == 1) {

                    $this->onMailSendForm();

                }



                if(count($_POST) > 1) {

                        $this->dataRecord = $_POST;

                        $this->onSubmit();

                } else {

                        $this->onShow();

                }

        }



        /**

        * Function called on page submit

        */



        function onSubmit() {

                global $app, $conf;



                // Calling the action functions

                if($this->id > 0) {

                        $this->onUpdate();

                } else {

                        $this->onInsert();

                }

        }



        /**

        * Function called on data update

        */



        function onUpdate() {

                global $app, $conf;



                $ext_where = '';

                $sql = $app->tform->getSQL($this->dataRecord,$app->tform->getCurrentTab(),'UPDATE',$this->id,$ext_where);

                if($app->tform->errorMessage == '') {



                        if(!empty($sql)) {

                                $app->db->query($sql);

                            if($app->db->errorMessage != '') die($app->db->errorMessage);

                        }

						
                        // loading plugins

                        $next_tab = $app->tform->getCurrentTab();

                        $this->loadPlugins($next_tab);



                        // Call plugin

                        foreach($this->plugins as $plugin) {

                                $plugin->onInsert();

                        }



                        $this->onAfterUpdate();



                        if($_REQUEST["next_tab"] == '') {

                           $list_name = $_SESSION["s"]["form"]["return_to"];

                           // When a list is embedded inside of a form

						   
                           //if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {

                           if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {

                                $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];

                                $_SESSION["s"]["form"]["return_to"] = '';

                                session_write_close();

                                header($redirect);

                        // When a returnto variable is set

                        } elseif ($_SESSION["s"]["form"]["return_to_url"] != '') {

                            $redirect = $_SESSION["s"]["form"]["return_to_url"];

                            $_SESSION["s"]["form"]["return_to_url"] = '';

                            session_write_close();

                            header("Location: ".$redirect);

                            exit;

                        // Use the default list of the form

                        } else {

                            header("Location: ".$app->tform->formDef['list_default']);

                        }

                        exit;

                    } else {

                                $this->onShow();

                        }

                } else {

                        $this->onError();

                }

        }



        /**

        * Function called on data insert

        */



        function onInsert() {

                global $app, $conf;



                $ext_where = '';

                $sql = $app->tform->getSQL($this->dataRecord,$app->tform->getCurrentTab(),'INSERT',$this->id,$ext_where);

                if($app->tform->errorMessage == '') {

                        $app->db->query($sql);

                        if($app->db->errorMessage != '') die($app->db->errorMessage);

                        $this->id = $app->db->insertID();

						
                        // loading plugins

                        $next_tab = $app->tform->getCurrentTab();

                        $this->loadPlugins($next_tab);

						
                        // Call plugin

                        foreach($this->plugins as $plugin) {

                                $plugin->onInsert();

                        }



                        $this->onAfterInsert();

						


                     if($_REQUEST["next_tab"] == '') {

                         $list_name = $_SESSION["s"]["form"]["return_to"];

                         // if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {

                         if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {

                            $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];

                            $_SESSION["s"]["form"]["return_to"] = '';

                            session_write_close();

                            header($redirect);

                            exit;

                        } elseif ($_SESSION["s"]["form"]["return_to_url"] != '') {

                            $_SESSION["s"]["form"]["return_to_url"] = '';

                            session_write_close();

                            header("Location: ".$_SESSION["s"]["form"]["return_to_url"]);

                            exit;

                        } else {

                                header("Location: ".$app->tform->formDef['list_default']);

                        }

                        exit;

                    } else {

                            $this->onShow();

                        }

                } else {

                        $this->onError();

                }

        }



                function onAfterUpdate() {

                        global $app, $conf;

                }



                function onAfterInsert() {

                        global $app, $conf;

                }





        /**

        * Function called on data insert or update error

        */



        function onError() {

                global $app, $conf;



                $app->tpl->setVar("error","<b>".$app->lng('Error').":</b><br>".$app->tform->errorMessage);

                $app->tpl->setVar($this->dataRecord);

                $this->onShow();

        }



        /**

        * Function called on data delete

        */



        function onDelete() {

                global $app, $conf,$list_def_file,$tform_def_file;



                include_once($list_def_file);



                // Loading tform framework

                if(!is_object($app->tform)) $app->uses('tform');



                // Load table definition from file

                $app->tform->loadFormDef($tform_def_file);



                // importing ID

                $this->id = intval($_REQUEST["id"]);



                if($this->id > 0) {



                        // checking permissions

                        if($app->tform->formDef['auth'] == 'yes') {

                                if($app->tform->checkPerm($this->id,'d') == false) $app->error($app->lng('error_no_delete_permission'));

                        }



                        $record_old = $app->db->queryOneRecord("SELECT * FROM ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);



                        // Saving record to datalog when db_history enabled

                        if($form["db_history"] == 'yes') {

                                $diffrec = array();



                                foreach($record_old as $key => $val) {

                                        // Record has changed

                                        $diffrec[$key] = array('old' => $val,

                                                                                           'new' => '');

                                }



                                $diffstr = $app->db->quote(serialize($diffrec));

                                $username = $app->db->quote($_SESSION["s"]["user"]["username"]);

                                $dbidx = $app->tform->formDef['db_table_idx'].":".$this->id;

                                $sql = "INSERT INTO sys_datalog (dbtable,dbidx,action,tstamp,user,data) VALUES ('".$app->tform->formDef['db_table']."','$dbidx','d','".time()."','$username','$diffstr')";

                                $app->db->query($sql);

                        }



                        $app->db->query("DELETE FROM ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);

						
                        // loading plugins

                        $next_tab = $app->tform->getCurrentTab();

                        $this->loadPlugins($next_tab);

						
						
                        // Call plugin

                        foreach($this->plugins as $plugin) {

                                $plugin->onDelete();

                        }

                }



                        //header("Location: ".$liste["file"]."?PHPSESSID=".$_SESSION["s"]["id"]);

                 $list_name = $_SESSION["s"]["form"]["return_to"];

                 if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {

                        $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];

                        $_SESSION["s"]["form"]["return_to"] = '';

                        session_write_close();

                        header($redirect);

                } else {

                    header("Location: ".$liste["file"]);

                }

                exit;



        }

		
        /**

        * Function to print the form content

        */

		
        function onPrintForm() {

            global $app, $conf;

			
            if($app->tform->formDef['template_print'] == '') die('No print template available.');

			
            $app->tpl->newTemplate("print.tpl.htm");

            $app->tpl->setInclude("content_tpl",$app->tform->formDef['template_print']);



            if($app->tform->formDef['auth'] == 'no') {

                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;

            } else {

                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');

            }

            if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));

			
            $record["datum"] = date("d.m.Y");

			
            $app->tpl->setVar($app->tform->wordbook);



            $app->tpl->setVar($record);

            $app->tpl_defaults();

            $app->tpl->pparse();

            exit;

			
        }

		
        /**

        * Function to print the form content

        */

		
        function onMailSendForm() {

            global $app, $conf;

			
            if($app->tform->formDef['template_mailsend'] == '') die('No print template available.');

			
            if($_POST["email"] == '' && $_POST["sender"] == '') {

                // Zeige Formular zum versenden an.

                $app->tpl->newTemplate("form.tpl.htm");

                $app->tpl->setInclude("content_tpl",$app->tform->formDef['template_mailsend']);

                $app->tpl->setVar('show_form',1);

                $app->tpl->setVar("form_action",$app->tform->formDef['action'].'?send_form_by_mail=1');

                $app->tpl->setVar("id",$this->id);

                $app->tpl_defaults();

                $app->tpl->pparse();

                exit;

            } else {

                $app->tpl->newTemplate("mail.tpl.htm");

                $app->tpl->setInclude("content_tpl",$app->tform->formDef['template_mailsend']);

                $app->tpl->setVar('show_mail',1);

                if($app->tform->formDef['auth'] == 'no') {

                    $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;

                } else {

                    $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');

                }

                if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));

			
                $record["datum"] = date("d.m.Y");

                $record["mailmessage"] = $_POST["message"];

			
                $app->tpl->setVar($app->tform->wordbook);



                $app->tpl->setVar($record);

                $app->tpl_defaults();

				
                $email_message = $app->tpl->grab();

                $email = $_POST["email"];

                $sender = $_POST["sender"];

				
                $headers  = "MIME-Version: 1.0\n";

                $headers .= "Content-type: text/html; charset=iso-8859-1\n";

                $headers .= "From: $sender\n";

				
                if (!ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$', $sender)) {

                    $sender = 'noreply@iprguard.de';

                  }

				
                if (ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$', $email)) {

                    mail($email, 'Domainrecherche Statement '.$record["domain"], $email_message, $headers);

                  }

                echo "<p>&nbsp;</p><p>Email wurde versand.</p>";

                exit;

            }

			
			


            if($app->tform->formDef['auth'] == 'no') {

                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;

            } else {

                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');

            }

            if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));

			
            $record["datum"] = date("d.m.Y");

			
            $app->tpl->setVar($app->tform->wordbook);



            $app->tpl->setVar($record);

            $app->tpl_defaults();

            $app->tpl->pparse();

            exit;

			
        }



        /**

        * Function called on page show

        */



        function onShow() {

                global $app, $conf;



                // Which tab do we render

                $this->active_tab = $app->tform->getNextTab();



                if($this->id > 0) {

                        $this->onShowEdit();

                } else {

                        $this->onShowNew();

                }



                // make Form and Tabs

                $app->tform->showForm();



                // Setting default values

                $app->tpl_defaults();

				
                // Show the navigation bar of the form

                if($app->tform->formDef['navibar'] == 'yes') {

                    $navibar = '';

                    if($app->tform->formDef['template_print'] != '') {

                        $navibar .= '<a href="'.$app->tform->formDef['action'].'?id='.$this->id.'&print_form=1" target="_blank"><img src="../themes/iprg/icons/printer.png" border="0" alt="Drucken" /></a> &nbsp;';

                    }

                    if($app->tform->formDef['template_mailsend'] != '') {

                        $navibar .= "<a href=\"#\" onClick=\"window.open('".$app->tform->formDef['action'].'?id='.$this->id."&send_form_by_mail=1','send','width=370,height=240')\"><img src=\"../themes/iprg/icons/mail.png\" border=\"0\" alt=\"Als E-Mail versenden\" /></a>";

                    }

                    $app->tpl->setVar('form_navibar',$navibar);

                }

				
				
                // loading plugins

                $this->loadPlugins($this->active_tab);



                // Calling the Plugin onShow Events and set the data in the

                // plugins placeholder in the template

                foreach($this->plugins as $plugin_name => $plugin) {

                        $app->tpl->setVar($plugin_name,$plugin->onShow());

                }



                // Parse the templates and send output to the browser

                $this->onShowEnd();



        }



        /**

        * Function called on new record

        */



        function onShowNew() {

                global $app, $conf;



                if($app->tform->errorMessage == '') {

                        $record = array();

                        $record = $app->tform->getHTML($record, $app->tform->formDef['tab_default'],'NEW');

                } else {

                        $record = $app->tform->getHTML($app->tform->encode($_POST,$this->active_tab),$this->active_tab,'EDIT');

                }



                $app->tpl->setVar($record);

        }



        /**

        * Function called on edit record

        */



        function onShowEdit() {

                global $app, $conf;



                // bestehenden Datensatz anzeigen

                if($app->tform->errorMessage == '') {

                        if($app->tform->formDef['auth'] == 'no') {

                                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;

                        } else {

                                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');

                        }

                        if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));

                } else {

                        $record = $app->tform->encode($_POST,$this->active_tab);

                }



                $this->dataRecord = $record;



                // Userdaten umwandeln

                $record = $app->tform->getHTML($record, $this->active_tab,'EDIT');

                $record['id'] = $this->id;



                $app->tpl->setVar($record);

        }



        function onShowEnd() {

                global $app, $conf;



                // Template parsen

                $app->tpl->pparse();

        }

		
        function loadPlugins($next_tab) {

            global $app;

            if(is_array($app->tform->formDef["tabs"][$next_tab]["plugins"])) {

                 $app->load('plugin_base');

                 foreach($app->tform->formDef["tabs"][$next_tab]["plugins"] as $plugin_name => $plugin_settings) {

                      $plugin_class = $plugin_settings["class"];

                      $app->load($plugin_class);

                      $this->plugins[$plugin_name] = new $plugin_class;

                      $this->plugins[$plugin_name]->setOptions($plugin_name,$plugin_settings['options']);

                      // Make the data of the form easily accessible for the plugib

                      $this->plugins[$plugin_name]->form = $this;

                      $this->plugins[$plugin_name]->onLoad();

                  }

             }

        }





}



<?php

/*
Copyright (c) 2005, Till Brehm, projektfarm Gmbh
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

    * Redistributions of source code must retain the above copyright notice,
      this list of conditions and the following disclaimer.
    * Redistributions in binary form must reproduce the above copyright notice,
      this list of conditions and the following disclaimer in the documentation
      and/or other materials provided with the distribution.
    * Neither the name of ISPConfig nor the names of its contributors
      may be used to endorse or promote products derived from this software without
      specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/

/**
* Action framework for the tform library.
*
* @author Till Brehm <t.brehm@scrigo.org>
* @copyright Copyright &copy; 2005, Till Brehm
*/

class tform_actions {

        var $id;
        var $activeTab;
        var $dataRecord;
        var $plugins = array();

        function onLoad() {
                global $app, $conf, $tform_def_file;

                // Loading template classes and initialize template
                if(!is_object($app->tpl)) $app->uses('tpl');
                if(!is_object($app->tform)) $app->uses('tform');

                $app->tpl->newTemplate("tabbed_form.tpl.htm");

                // Load table definition from file
                $app->tform->loadFormDef($tform_def_file);
				
                // Importing ID
                $this->id = intval($_REQUEST["id"]);
				
                // show print version of the form
                if($_GET["print_form"] == 1) {
                    $this->onPrintForm();
                }
				
                // send this form by email
                if($_GET["send_form_by_mail"] == 1) {
                    $this->onMailSendForm();
                }

                if(count($_POST) > 1) {
                        $this->dataRecord = $_POST;
                        $this->onSubmit();
                } else {
                        $this->onShow();
                }
        }

        /**
        * Function called on page submit
        */

        function onSubmit() {
                global $app, $conf;

                // Calling the action functions
                if($this->id > 0) {
                        $this->onUpdate();
                } else {
                        $this->onInsert();
                }
        }

        /**
        * Function called on data update
        */

        function onUpdate() {
                global $app, $conf;
				
                $this->onBeforeUpdate();

                $ext_where = '';
                $sql = $app->tform->getSQL($this->dataRecord,$app->tform->getCurrentTab(),'UPDATE',$this->id,$ext_where);
                if($app->tform->errorMessage == '') {

                        if(!empty($sql)) {
                                $app->db->query($sql);
                            if($app->db->errorMessage != '') die($app->db->errorMessage);
                        }
						
                        // loading plugins
                        $next_tab = $app->tform->getCurrentTab();
                        $this->loadPlugins($next_tab);

                        // Call plugin
                        foreach($this->plugins as $plugin) {
                                $plugin->onInsert();
                        }

                        $this->onAfterUpdate();

                        if($_REQUEST["next_tab"] == '') {
                           $list_name = $_SESSION["s"]["form"]["return_to"];
                           // When a list is embedded inside of a form
						   
                           //if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
                           if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
                                $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
                                $_SESSION["s"]["form"]["return_to"] = '';
                                session_write_close();
                                header($redirect);
                        // When a returnto variable is set
                        } elseif ($_SESSION["s"]["form"]["return_to_url"] != '') {
                            $redirect = $_SESSION["s"]["form"]["return_to_url"];
                            $_SESSION["s"]["form"]["return_to_url"] = '';
                            session_write_close();
                            header("Location: ".$redirect);
                            exit;
                        // Use the default list of the form
                        } else {
                            header("Location: ".$app->tform->formDef['list_default']);
                        }
                        exit;
                    } else {
                                $this->onShow();
                        }
                } else {
                        $this->onError();
                }
        }

        /**
        * Function called on data insert
        */

        function onInsert() {
                global $app, $conf;
				
                $this->onBeforeInsert();

                $ext_where = '';
                $sql = $app->tform->getSQL($this->dataRecord,$app->tform->getCurrentTab(),'INSERT',$this->id,$ext_where);
                if($app->tform->errorMessage == '') {
                        $app->db->query($sql);
                        if($app->db->errorMessage != '') die($app->db->errorMessage);
                        $this->id = $app->db->insertID();
						
                        // loading plugins
                        $next_tab = $app->tform->getCurrentTab();
                        $this->loadPlugins($next_tab);
						
                        // Call plugin
                        foreach($this->plugins as $plugin) {
                                $plugin->onInsert();
                        }

                        $this->onAfterInsert();
						

                     if($_REQUEST["next_tab"] == '') {
                         $list_name = $_SESSION["s"]["form"]["return_to"];
                         // if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
                         if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
                            $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
                            $_SESSION["s"]["form"]["return_to"] = '';
                            session_write_close();
                            header($redirect);
                            exit;
                        } elseif ($_SESSION["s"]["form"]["return_to_url"] != '') {
                            $_SESSION["s"]["form"]["return_to_url"] = '';
                            session_write_close();
                            header("Location: ".$_SESSION["s"]["form"]["return_to_url"]);
                            exit;
                        } else {
                                header("Location: ".$app->tform->formDef['list_default']);
                        }
                        exit;
                    } else {
                            $this->onShow();
                        }
                } else {
                        $this->onError();
                }
        }

        function onBeforeUpdate() {
            global $app, $conf;
        }

        function onBeforeInsert() {
            global $app, $conf;
        }
		
        function onAfterUpdate() {
            global $app, $conf;
        }

        function onAfterInsert() {
            global $app, $conf;
        }


        /**
        * Function called on data insert or update error
        */

        function onError() {
                global $app, $conf;

                $app->tpl->setVar("error","<b>".$app->lng('Error').":</b><br>".$app->tform->errorMessage);
                $app->tpl->setVar($this->dataRecord);
                $this->onShow();
        }

        /**
        * Function called on data delete
        */

        function onDelete() {
                global $app, $conf,$list_def_file,$tform_def_file;

                include_once($list_def_file);

                // Loading tform framework
                if(!is_object($app->tform)) $app->uses('tform');

                // Load table definition from file
                $app->tform->loadFormDef($tform_def_file);

                // importing ID
                $this->id = intval($_REQUEST["id"]);

                if($this->id > 0) {

                        // checking permissions
                        if($app->tform->formDef['auth'] == 'yes') {
                                if($app->tform->checkPerm($this->id,'d') == false) $app->error($app->lng('error_no_delete_permission'));
                        }

                        $record_old = $app->db->queryOneRecord("SELECT * FROM ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);

                        // Saving record to datalog when db_history enabled
                        if($form["db_history"] == 'yes') {
                                $diffrec = array();

                                foreach($record_old as $key => $val) {
                                        // Record has changed
                                        $diffrec[$key] = array('old' => $val,
                                                                                           'new' => '');
                                }

                                $diffstr = $app->db->quote(serialize($diffrec));
                                $username = $app->db->quote($_SESSION["s"]["user"]["username"]);
                                $dbidx = $app->tform->formDef['db_table_idx'].":".$this->id;
                                $sql = "INSERT INTO sys_datalog (dbtable,dbidx,action,tstamp,user,data) VALUES ('".$app->tform->formDef['db_table']."','$dbidx','d','".time()."','$username','$diffstr')";
                                $app->db->query($sql);
                        }

                        $app->db->query("DELETE FROM ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);
						
                        // loading plugins
                        $next_tab = $app->tform->getCurrentTab();
                        $this->loadPlugins($next_tab);
						
						
                        // Call plugin
                        foreach($this->plugins as $plugin) {
                                $plugin->onDelete();
                        }
                }

                        //header("Location: ".$liste["file"]."?PHPSESSID=".$_SESSION["s"]["id"]);
                 $list_name = $_SESSION["s"]["form"]["return_to"];
                 if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
                        $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
                        $_SESSION["s"]["form"]["return_to"] = '';
                        session_write_close();
                        header($redirect);
                } else {
                    header("Location: ".$liste["file"]);
                }
                exit;

        }
		
        /**
        * Function to print the form content
        */
		
        function onPrintForm() {
            global $app, $conf;
			
            if($app->tform->formDef['template_print'] == '') die('No print template available.');
			
            $app->tpl->newTemplate("print.tpl.htm");
            $app->tpl->setInclude("content_tpl",$app->tform->formDef['template_print']);

            if($app->tform->formDef['auth'] == 'no') {
                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
            } else {
                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');
            }
            if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
			
            $record["datum"] = date("d.m.Y");
			
            $app->tpl->setVar($app->tform->wordbook);

            $app->tpl->setVar($record);
            $app->tpl_defaults();
            $app->tpl->pparse();
            exit;
			
        }
		
        /**
        * Function to print the form content
        */
		
        function onMailSendForm() {
            global $app, $conf;
			
            if($app->tform->formDef['template_mailsend'] == '') die('No print template available.');
			
            if($_POST["email"] == '' && $_POST["sender"] == '') {
                // Zeige Formular zum versenden an.
                $app->tpl->newTemplate("form.tpl.htm");
                $app->tpl->setInclude("content_tpl",$app->tform->formDef['template_mailsend']);
                $app->tpl->setVar('show_form',1);
                $app->tpl->setVar("form_action",$app->tform->formDef['action'].'?send_form_by_mail=1');
                $app->tpl->setVar("id",$this->id);
                $app->tpl_defaults();
                $app->tpl->pparse();
                exit;
            } else {
                $app->tpl->newTemplate("mail.tpl.htm");
                $app->tpl->setInclude("content_tpl",$app->tform->formDef['template_mailsend']);
                $app->tpl->setVar('show_mail',1);
                if($app->tform->formDef['auth'] == 'no') {
                    $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
                } else {
                    $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');
                }
                if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
			
                $record["datum"] = date("d.m.Y");
                $record["mailmessage"] = $_POST["message"];
			
                $app->tpl->setVar($app->tform->wordbook);

                $app->tpl->setVar($record);
                $app->tpl_defaults();
				
                $email_message = $app->tpl->grab();
                $email = $_POST["email"];
                $sender = $_POST["sender"];
				
                $headers  = "MIME-Version: 1.0\n";
                $headers .= "Content-type: text/html; charset=iso-8859-1\n";
                $headers .= "From: $sender\n";
				
                if (!ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$', $sender)) {
                    $sender = 'noreply@iprguard.de';
                  }
				
                if (ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$', $email)) {
                    mail($email, 'Domainrecherche Statement '.$record["domain"], $email_message, $headers);
                  }
                echo "<p>&nbsp;</p><p>Email wurde versand.</p>";
                exit;
            }
			
			

            if($app->tform->formDef['auth'] == 'no') {
                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
            } else {
                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');
            }
            if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
			
            $record["datum"] = date("d.m.Y");
			
            $app->tpl->setVar($app->tform->wordbook);

            $app->tpl->setVar($record);
            $app->tpl_defaults();
            $app->tpl->pparse();
            exit;
			
        }

        /**
        * Function called on page show
        */

        function onShow() {
                global $app, $conf;

                // Which tab do we render
                $this->active_tab = $app->tform->getNextTab();

                if($this->id > 0) {
                        $this->onShowEdit();
                } else {
                        $this->onShowNew();
                }

                // make Form and Tabs
                $app->tform->showForm();

                // Setting default values
                $app->tpl_defaults();
				
                // Show the navigation bar of the form
                if($app->tform->formDef['navibar'] == 'yes') {
                    $navibar = '';
                    if($app->tform->formDef['template_print'] != '') {
                        $navibar .= '<a href="'.$app->tform->formDef['action'].'?id='.$this->id.'&print_form=1" target="_blank"><img src="../themes/iprg/icons/printer.png" border="0" alt="Drucken" /></a> &nbsp;';
                    }
                    if($app->tform->formDef['template_mailsend'] != '') {
                        $navibar .= "<a href=\"#\" onClick=\"window.open('".$app->tform->formDef['action'].'?id='.$this->id."&send_form_by_mail=1','send','width=370,height=240')\"><img src=\"../themes/iprg/icons/mail.png\" border=\"0\" alt=\"Als E-Mail versenden\" /></a>";
                    }
                    $app->tpl->setVar('form_navibar',$navibar);
                }
				
				
                // loading plugins
                $this->loadPlugins($this->active_tab);

                // Calling the Plugin onShow Events and set the data in the
                // plugins placeholder in the template
                foreach($this->plugins as $plugin_name => $plugin) {
                        $app->tpl->setVar($plugin_name,$plugin->onShow());
                }

                // Parse the templates and send output to the browser
                $this->onShowEnd();

        }

        /**
        * Function called on new record
        */

        function onShowNew() {
                global $app, $conf;

                if($app->tform->errorMessage == '') {
                        $record = array();
                        $record = $app->tform->getHTML($record, $app->tform->formDef['tab_default'],'NEW');
                } else {
                        $record = $app->tform->getHTML($app->tform->encode($_POST,$this->active_tab),$this->active_tab,'EDIT');
                }

                $app->tpl->setVar($record);
        }

        /**
        * Function called on edit record
        */

        function onShowEdit() {
                global $app, $conf;

                // bestehenden Datensatz anzeigen
                if($app->tform->errorMessage == '') {
                        if($app->tform->formDef['auth'] == 'no') {
                                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
                        } else {
                                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');
                        }
                        if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
                } else {
                        // $record = $app->tform->encode($_POST,$this->active_tab);
                        $record = $app->tform->encode($this->dataRecord,$this->active_tab);
                }

                $this->dataRecord = $record;

                // Userdaten umwandeln
                $record = $app->tform->getHTML($record, $this->active_tab,'EDIT');
                $record['id'] = $this->id;

                $app->tpl->setVar($record);
        }

        function onShowEnd() {
                global $app, $conf;

                // Template parsen
                $app->tpl->pparse();
        }
		
        function loadPlugins($next_tab) {
            global $app;
            if(is_array($app->tform->formDef["tabs"][$next_tab]["plugins"])) {
                 $app->load('plugin_base');
                 foreach($app->tform->formDef["tabs"][$next_tab]["plugins"] as $plugin_name => $plugin_settings) {
                      $plugin_class = $plugin_settings["class"];
                      $app->load($plugin_class);
                      $this->plugins[$plugin_name] = new $plugin_class;
                      $this->plugins[$plugin_name]->setOptions($plugin_name,$plugin_settings['options']);
                      // Make the data of the form easily accessible for the plugib
                      $this->plugins[$plugin_name]->form = $this;
                      $this->plugins[$plugin_name]->onLoad();
                  }
             }
        }


}

?>

 interface/web/client/client_edit.php

@@ -100,7 +100,9 @@
        // password changed
        if($this->dataRecord["password"] != '') {
            $password = addslashes($this->dataRecord["password"]);
            $client_id = $this->id;
            $sql = "UPDATE sys_user SET passwort = md5('$password') WHERE client_id = $client_id";
            $app->db->query($sql);
        }
        
        

 interface/web/mail/lib/lang/en_mail_domain.lng

@@ -8,5 +8,6 @@
$wb["domain_error_empty"] = 'Domain is empty.';
$wb["domain_error_unique"] = 'Duplicate Domain.';
$wb["domain_error_regex"] = 'Invalid domain name.';
$wb["client_txt"] = 'Client';

?>

 interface/web/mail/lib/lang/en_mail_user.lng

@@ -17,4 +17,6 @@
$wb["maildir_txt"] = 'maildir';
$wb["postfix_txt"] = 'Enable Receiving';
$wb["access_txt"] = 'Enable Access';
$wb["limit_mailbox_txt"] = 'The max. number of mailboxes for your account is reached.';
$wb["limit_mailquota_txt"] = 'The max space for mailboxes is reached. The max. available space in MB is';
?>

 interface/web/mail/mail_domain_edit.php

@@ -1,56 +1,104 @@
<?php

/*

Copyright (c) 2005, Till Brehm, projektfarm Gmbh

All rights reserved.



Redistribution and use in source and binary forms, with or without modification,

are permitted provided that the following conditions are met:



    * Redistributions of source code must retain the above copyright notice,

      this list of conditions and the following disclaimer.

    * Redistributions in binary form must reproduce the above copyright notice,

      this list of conditions and the following disclaimer in the documentation

      and/or other materials provided with the distribution.

    * Neither the name of ISPConfig nor the names of its contributors

      may be used to endorse or promote products derived from this software without

      specific prior written permission.



THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND

ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.

IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,

INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,

BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,

DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY

OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING

NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,

EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

*/





/******************************************

* Begin Form configuration

******************************************/



$tform_def_file = "form/mail_domain.tform.php";



/******************************************

* End Form configuration

******************************************/



require_once('../../lib/config.inc.php');

require_once('../../lib/app.inc.php');



// Checking module permissions

if(!stristr($_SESSION["s"]["user"]["modules"],$_SESSION["s"]["module"]["name"])) {

    header("Location: ../index.php");

    exit;

}



// Loading classes

$app->uses('tpl,tform,tform_actions');



// let tform_actions handle the page

$app->tform_actions->onLoad();



<?php
/*
Copyright (c) 2005, Till Brehm, projektfarm Gmbh
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

    * Redistributions of source code must retain the above copyright notice,
      this list of conditions and the following disclaimer.
    * Redistributions in binary form must reproduce the above copyright notice,
      this list of conditions and the following disclaimer in the documentation
      and/or other materials provided with the distribution.
    * Neither the name of ISPConfig nor the names of its contributors
      may be used to endorse or promote products derived from this software without
      specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/


/******************************************
* Begin Form configuration
******************************************/

$tform_def_file = "form/mail_domain.tform.php";

/******************************************
* End Form configuration
******************************************/

require_once('../../lib/config.inc.php');
require_once('../../lib/app.inc.php');

// Checking module permissions
if(!stristr($_SESSION["s"]["user"]["modules"],$_SESSION["s"]["module"]["name"])) {
    header("Location: ../index.php");
    exit;
}

// Loading classes
$app->uses('tpl,tform,tform_actions');
$app->load('tform_actions');

class page_action extends tform_actions {

    function onShowEnd() {
        global $app, $conf;
		
        if($_SESSION["s"]["user"]["typ"] == 'admin') {
            // Getting Domains of the user
            $sql = "SELECT groupid, name FROM sys_group WHERE client_id > 0";
            $clients = $app->db->queryAllRecords($sql);
            $client_select = "<option value='0'></option>";
            if(is_array($clients)) {
                foreach( $clients as $client) {
                    $selected = ($client["groupid"] == $this->dataRecord["sys_groupid"])?'SELECTED':'';
                    $client_select .= "<option value='$client[groupid]' $selected>$client[name]</option>\r\n";
                }
            }
        $app->tpl->setVar("client_group_id",$client_select);
        }
		
        parent::onShowEnd();
    }
	
    function onSubmit() {
        if($_SESSION["s"]["user"]["typ"] != 'admin') unset($this->dataRecord["client_group_id"]);
        parent::onSubmit();
    }
	
    function onAfterInsert() {
        global $app, $conf;
		
        if($_SESSION["s"]["user"]["typ"] == 'admin' && isset($this->dataRecord["client_group_id"])) {
            $client_group_id = intval($this->dataRecord["client_group_id"]);
            $app->db->query("UPDATE mail_domain SET sys_groupid = $client_group_id WHERE domain_id = ".$this->id);
        }
    }
	
    function onAfterUpdate() {
        global $app, $conf;
		
        if($_SESSION["s"]["user"]["typ"] == 'admin' && isset($this->dataRecord["client_group_id"])) {
            $client_group_id = intval($this->dataRecord["client_group_id"]);
            $app->db->query("UPDATE mail_domain SET sys_groupid = $client_group_id WHERE domain_id = ".$this->id);
        }
    }
	
}

$page = new page_action;
$page->onLoad();

?>

 interface/web/mail/mail_user_edit.php

@@ -53,6 +53,29 @@

class page_action extends tform_actions {
    
	
    function onShowNew() {
        global $app, $conf;
		
        // we will check only users, not admins
        if($_SESSION["s"]["user"]["typ"] == 'user') {
			
            // Get the limits of the client
            $client_group_id = $_SESSION["s"]["user"]["default_group"];
            $client = $app->db->queryOneRecord("SELECT limit_mailbox FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
			
            // Check if the user may add another mailbox.
            if($client["limit_mailbox"] >= 0) {
                $tmp = $app->db->queryOneRecord("SELECT count(mailuser_id) as number FROM mail_user WHERE sys_groupid = $client_group_id");
                if($tmp["number"] >= $client["limit_mailbox"]) {
                    $app->error($app->tform->wordbook["limit_mailbox_txt"]);
                }
            }
        }
		
        parent::onShowNew();
    }
	
    function onShowEnd() {
        global $app, $conf;
        
@@ -75,22 +98,54 @@
        // Convert quota from Bytes to MB
        $app->tpl->setVar("quota",$this->dataRecord["quota"] / 1024);
        
		
        parent::onShowEnd();
    }
    
    function onSubmit() {
        global $app, $conf;
        
        // Get the limits of the client
        $client_group_id = $_SESSION["s"]["user"]["default_group"];
        $client = $app->db->queryOneRecord("SELECT limit_mailbox, limit_mailquota FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
		
        // Check if Domain belongs to user
        $domain = $app->db->queryOneRecord("SELECT server_id, domain FROM mail_domain WHERE domain = '".$app->db->quote($_POST["email_domain"])."' AND ".$app->tform->getAuthSQL('r'));
        if($domain["domain"] != $_POST["email_domain"]) $app->tform->errorMessage .= $app->tform->wordbook["no_domain_perm"];
        
        // if its an insert, check for password
        if($this->id == 0 and $_POST["password"] == '') {
            $app->tform->errorMessage .= $app->tform->wordbook["error_no_pwd"]."<br>";
        // if its an insert
        if($this->id == 0) {
			
            // check for password
            if($_POST["password"] == '') {
                $app->tform->errorMessage .= $app->tform->wordbook["error_no_pwd"]."<br>";
            }
			
            // Check if the user may add another mailbox.
            if($client["limit_mailbox"] >= 0) {
                $tmp = $app->db->queryOneRecord("SELECT count(mailuser_id) as number FROM mail_user WHERE sys_groupid = $client_group_id");
                if($tmp["number"] >= $client["limit_mailbox"]) {
                    $app->tform->errorMessage .= $app->tform->wordbook["limit_mailbox_txt"]."<br>";
                }
                unset($tmp);
            }
        } // end if insert
		
        // Check the quota and adjust
        if($client["limit_mailquota"] >= 0) {
            $tmp = $app->db->queryOneRecord("SELECT sum(quota) as mailquota FROM mail_user WHERE mailuser_id != ".intval($this->id)." AND sys_groupid = $client_group_id");
            $mailquota = $tmp["mailquota"] / 1024;
            $new_mailbox_quota = intval($this->dataRecord["quota"]);
            if($mailquota + $new_mailbox_quota > $client["limit_mailquota"]) {
                $max_free_quota = $client["limit_mailquota"] - $mailquota;
                $app->tform->errorMessage .= $app->tform->wordbook["limit_mailquota_txt"].": ".$max_free_quota."<br>";
                // Set the quota field to the max free space
                $this->dataRecord["quota"] = $max_free_quota;
            }
            unset($tmp);
            unset($tmp_quota);
        }
        

        // compose the email field
        $this->dataRecord["email"] = $_POST["email_local_part"]."@".$_POST["email_domain"];
        // Set the server id of the mailbox = server ID of mail domain.
@@ -111,10 +166,27 @@
        $this->dataRecord["homedir"] = $mail_config["homedir_path"];
        $this->dataRecord["uid"] = $mail_config["mailuser_uid"];
        $this->dataRecord["gid"] = $mail_config["mailuser_gid"];

        
        parent::onSubmit();
    }
    
    function onAfterInsert() {
        global $app, $conf;
		
        // Set the domain owner as mailbox owner
        $domain = $app->db->queryOneRecord("SELECT sys_groupid FROM mail_domain WHERE domain = '".$app->db->quote($_POST["email_domain"])."' AND ".$app->tform->getAuthSQL('r'));
        $app->db->query("UPDATE mail_user SET sys_groupid = ".$domain["sys_groupid"]." WHERE mailuser_id = ".$this->id);
    }
	
    function onAfterUpdate() {
        global $app, $conf;
		
        // Set the domain owner as mailbox owner
        $domain = $app->db->queryOneRecord("SELECT sys_groupid FROM mail_domain WHERE domain = '".$app->db->quote($_POST["email_domain"])."' AND ".$app->tform->getAuthSQL('r'));
        $app->db->query("UPDATE mail_user SET sys_groupid = ".$domain["sys_groupid"]." WHERE mailuser_id = ".$this->id);
    }
	
}

$app->tform_actions = new page_action;

 interface/web/mail/templates/mail_domain_edit.htm

@@ -1,4 +1,5 @@
<table width="500" border="0" cellspacing="0" cellpadding="2">
  <tmpl_if name="is_admin">
  <tr>
    <td class="frmText11">{tmpl_var name='server_id_txt'}:</td>
    <td class="frmText11">
@@ -8,6 +9,15 @@
    </td>
  </tr>
  <tr>
    <td class="frmText11">{tmpl_var name='client_txt'}:</td>
    <td class="frmText11">
        <select name="client_group_id" class="text">
            {tmpl_var name='client_group_id'}
        </select>
    </td>
  </tr>
  </tmpl_if>
  <tr>
    <td class="frmText11">{tmpl_var name='domain_txt'}:</td>
    <td class="frmText11"><input name="domain" type="text" class="text" value="{tmpl_var name='domain'}" size="30" maxlength="255"></td>
  </tr>