PHP CORE_database::Execute方法代码示例

 function add($VAR)
 {
     $type = "add";
     $this->method["{$type}"] = explode(",", $this->method["{$type}"]);
     $db = new CORE_database();
     $group_id = $db->add($VAR, $this, $type);
     # add the new group to the account_group table:
     $db =& DB();
     $record_id = $db->GenID(AGILE_DB_PREFIX . 'account_group_id');
     $sql = "INSERT INTO " . AGILE_DB_PREFIX . "account_group SET\n\t\t\t\tid\t\t\t= " . $db->qstr($record_id) . ",\n\t\t\t\tsite_id \t= " . $db->qstr(DEFAULT_SITE) . ", \n\t\t\t\tdate_orig\t= " . $db->qstr(time()) . ",\n\t\t\t\tdate_expire = " . $db->qstr('0') . ",\n\t\t\t\tgroup_id\t= " . $db->qstr($group_id) . ",\n\t\t\t\taccount_id\t= " . $db->qstr(SESS_ACCOUNT) . ",\n\t\t\t\tactive\t\t= " . $db->qstr(1);
     $result = $db->Execute($sql);
     if ($result === false) {
         global $C_debug;
         $C_debug->error('list.inc.php', 'select_groups', $db->ErrorMsg());
         return;
     }
     # update the current user's authentication so the newly added group appears
     # as available to them
     global $C_auth;
     $C_auth->auth_update();
     return;
 }

 function update($VAR)
 {
     if ($VAR['setup_currency_id'] != DEFAULT_CURRENCY) {
         $curr = true;
     } else {
         $curr = false;
     }
     # make sure the index.php file is not included at the end:
     if (!empty($VAR['setup_ssl_url'])) {
         $VAR['setup_ssl_url'] = eregi_replace('index.php', '', $VAR['setup_ssl_url']);
     }
     if (!empty($VAR['setup_nonssl_url'])) {
         $VAR['setup_nonssl_url'] = eregi_replace('index.php', '', $VAR['setup_nonssl_url']);
     }
     # Validate trailing slash is on the end of the URL:
     if (!empty($VAR['setup_ssl_url']) && !ereg('/$', $VAR['setup_ssl_url'])) {
         $VAR['setup_ssl_url'] .= '/';
     }
     # Validate trailing slash is on the end of the URL:
     if (!empty($VAR['setup_nonssl_url']) && !ereg('/$', $VAR['setup_nonssl_url'])) {
         $VAR['setup_nonssl_url'] .= '/';
     }
     $type = "update";
     $this->method["{$type}"] = explode(",", $this->method["{$type}"]);
     $db = new CORE_database();
     $rs = $db->update($VAR, $this, $type);
     if ($rs && $curr) {
         /* Start: Update all sessions & accounts */
         $db =& DB();
         $sql = "UPDATE " . AGILE_DB_PREFIX . "session \n\t\t\t\t\tSET\n\t\t\t\t\tcurrency_id = " . $db->qstr($VAR['setup_currency_id']) . "\n\t\t\t\t\tWHERE\n\t\t\t\t\tsite_id \t= " . $db->qstr(DEFAULT_SITE) . " AND\n\t\t\t\t\tcurrency_id != " . $db->qstr($VAR['setup_currency_id']);
         $rs = $db->Execute($sql);
         $sql = "UPDATE " . AGILE_DB_PREFIX . "account \n\t\t\t\t\tSET\n\t\t\t\t\tcurrency_id = " . $db->qstr($VAR['setup_currency_id']) . "\n\t\t\t\t\tWHERE\n\t\t\t\t\tsite_id \t= " . $db->qstr(DEFAULT_SITE) . " AND\n\t\t\t\t\tcurrency_id != " . $db->qstr($VAR['setup_currency_id']);
         $rs = $db->Execute($sql);
         /* End: SQL Insert Statement */
     }
     # Clear out the cache entry
     if (defined("AGILE_CORE_CACHE_DIR") && AGILE_CORE_CACHE_DIR != '') {
         $tfile = AGILE_CORE_CACHE_DIR . "core-setup";
         if (file_exists($tfile)) {
             unlink(AGILE_CORE_CACHE_DIR . "core-setup");
         }
     }
 }

    function update($VAR)
    {
        global $C_list, $C_debug;
        if (!$this->checkLimits()) {
            return false;
        }
        // check account limits
        // validate the tax_id
        global $VAR;
        require_once PATH_MODULES . 'tax/tax.inc.php';
        $taxObj = new tax();
        $tax_arr = @$VAR['account_admin_tax_id'];
        if (is_array($tax_arr)) {
            foreach ($tax_arr as $country_id => $tax_id) {
                if ($country_id == $VAR['account_admin_country_id']) {
                    $exempt = @$VAR["account_tax_id_exempt"][$country_id];
                    if (!($txRs = $taxObj->TaxIdsValidate($country_id, $tax_id, $exempt))) {
                        $this->validated = false;
                        global $C_translate;
                        $this->val_error[] = array('field' => 'account_admin_tax_id', 'field_trans' => $taxObj->errField, 'error' => $C_translate->translate('validate_general', "", ""));
                    }
                    if ($exempt) {
                        $VAR['account_admin_tax_id'] = false;
                    } else {
                        $VAR['account_admin_tax_id'] = $tax_id;
                    }
                }
            }
        }
        ####################################################################
        ### Get required static_Vars and validate them... return an array
        ### w/ ALL errors...
        ####################################################################
        require_once PATH_CORE . 'static_var.inc.php';
        $static_var = new CORE_static_var();
        if (!isset($this->val_error)) {
            $this->val_error = false;
        }
        $all_error = $static_var->validate_form('account', $this->val_error);
        if ($all_error != false && gettype($all_error) == 'array') {
            $this->validated = false;
        } else {
            $this->validated = true;
        }
        ####################################################################
        # If validation was failed, skip the db insert &
        # set the errors & origonal fields as Smarty objects,
        # and change the page to be loaded.
        ####################################################################
        if (!$this->validated) {
            global $smarty;
            # set the errors as a Smarty Object
            $smarty->assign('form_validation', $all_error);
            # set the page to be loaded
            if (!defined("FORCE_PAGE")) {
                define('FORCE_PAGE', $VAR['_page_current']);
            }
            return;
        }
        ### Get the old username ( for db mapping )
        $db =& DB();
        $sql = 'SELECT username FROM ' . AGILE_DB_PREFIX . 'account WHERE
					site_id     = ' . $db->qstr(DEFAULT_SITE) . ' AND
					id          = ' . $db->qstr($VAR['account_admin_id']);
        $result = $db->Execute($sql);
        if ($result->RecordCount() > 0) {
            $old_username = $result->fields['username'];
        }
        ### Update the password:
        $update_password = false;
        if (!empty($VAR['_password'])) {
            $VAR['account_admin_password'] = $VAR['_password'];
            /* check if new password is ok */
            if ($C_list->is_installed('account_password_history')) {
                include_once PATH_MODULES . 'account_password_history/account_password_history.inc.php';
                $accountHistory = new account_password_history();
                if (!$accountHistory->getIsPasswordOk($VAR['account_admin_id'], $VAR['account_admin_password'], false)) {
                    $C_debug->alert("The password you have selected has been used recently and cannot be used again at this time for security purposes.");
                    unset($VAR['account_admin_password']);
                } else {
                    $update_password = true;
                }
            }
        }
        ### Update the record
        $type = "update";
        $this->method["{$type}"] = explode(",", $this->method["{$type}"]);
        $db = new CORE_database();
        $ok = $db->update($VAR, $this, $type);
        if ($ok) {
            /* password logging class */
            if ($update_password && is_object($accountHistory)) {
                $accountHistory->setNewPassword($VAR['account_admin_id'], $VAR["account_admin_password"], false);
            }
            ### Update the static vars:
            $static_var->update($VAR, 'account', $VAR['account_admin_id']);
            ### Do any db_mapping
            if ($C_list->is_installed('db_mapping')) {
                include_once PATH_MODULES . 'db_mapping/db_mapping.inc.php';
                $db_map = new db_mapping();
//.........这里部分代码省略.........

 function add($VAR)
 {
     # defaults for 'recurring' product
     if ($VAR["product_price_type"] == "1") {
         $VAR['product_price_recurr_default'] = "1";
         $VAR['product_price_recurr_type'] = "0";
         $VAR['product_price_recurr_week'] = "1";
         $VAR['product_price_recurr_weekday'] = "1";
         # Set default recurring prices: (monthly only)
         $db =& DB();
         $sql = 'SELECT id FROM ' . AGILE_DB_PREFIX . 'group WHERE
                         site_id             = ' . $db->qstr(DEFAULT_SITE) . ' AND
                         pricing		        = ' . $db->qstr('1');
         $rs = $db->Execute($sql);
         while (!$rs->EOF) {
             $i = $rs->fields['id'];
             $recur_price[0][$i]['price_base'] = '';
             $recur_price[0][$i]['price_setup'] = '';
             @($recur_price[1][$i]['price_base'] = $VAR['product_price_base']);
             @($recur_price[1][$i]['price_setup'] = $VAR['product_price_setup']);
             $recur_price[2][$i]['price_base'] = '';
             $recur_price[2][$i]['price_setup'] = '';
             $recur_price[3][$i]['price_base'] = '';
             $recur_price[3][$i]['price_setup'] = '';
             $recur_price[4][$i]['price_base'] = '';
             $recur_price[4][$i]['price_setup'] = '';
             $recur_price[5][$i]['price_base'] = '';
             $recur_price[5][$i]['price_setup'] = '';
             $rs->MoveNext();
         }
         $recur_price[0]['show'] = "0";
         $recur_price[1]['show'] = "1";
         $recur_price[2]['show'] = "0";
         $recur_price[3]['show'] = "0";
         $recur_price[4]['show'] = "0";
         $recur_price[5]['show'] = "0";
         @($VAR['product_price_group'] = $recur_price);
     }
     # Defaults for product groups:
     $VAR['product_group_avail'] = array('0');
     $this->product_construct();
     $type = "add";
     $this->method["{$type}"] = explode(",", $this->method["{$type}"]);
     $db = new CORE_database();
     $result = $db->add($VAR, $this, $type);
     # Create a translate record for this product:
     if ($result) {
         $db =& DB();
         $id = $db->GenID(AGILE_DB_PREFIX . 'product_translate_id');
         $sql = 'INSERT INTO ' . AGILE_DB_PREFIX . 'product_translate SET
                         site_id             = ' . $db->qstr(DEFAULT_SITE) . ',
                         id                  = ' . $db->qstr($id) . ',
                         product_id          = ' . $db->qstr($result) . ',
                         language_id         = ' . $db->qstr(DEFAULT_LANGUAGE) . ',
                         name                = ' . $db->qstr(@$VAR["translate_name"]) . ',
                         description_short   = ' . $db->qstr(@$VAR["translate_description_short"]) . ',
                         description_full    = ' . $db->qstr(@$VAR["translate_description_full"]);
         $db->Execute($sql);
     }
 }

 function add($VAR)
 {
     $type = "add";
     $this->method["{$type}"] = split(",", $this->method["{$type}"]);
     $db = new CORE_database();
     $id = $db->add($VAR, $this, $type);
     if ($id && !empty($VAR['faq_question'])) {
         # Insert translation
         $db =& DB();
         $idx = $db->GenID(AGILE_DB_PREFIX . 'faq_translate_id');
         $sql = "INSERT INTO\t" . AGILE_DB_PREFIX . "faq_translate\n\t\t\t\t\tSET\n\t\t\t\t\tsite_id = " . DEFAULT_SITE . ",\n\t\t\t\t\tid = {$idx},\n\t\t\t\t\tfaq_id = {$id},\n\t\t\t\t\tdate_orig = " . time() . ",\n\t\t\t\t\tdate_last = " . time() . ",\n\t\t\t\t\tlanguage_id = '" . DEFAULT_LANGUAGE . "',\n\t\t\t\t\tanswer = " . $db->qstr(@$VAR['faq_answer']) . ",\n\t\t\t\t\tquestion = " . $db->qstr(@$VAR['faq_question']);
         $db->Execute($sql);
     }
 }

 function delete($VAR)
 {
     $this->associated_DELETE[] = array('table' => 'invoice_commission', 'field' => 'affiliate_commission_id');
     $db = new CORE_database();
     $db->mass_delete($VAR, $this, "");
     # Delete all associated discounts:
     if (isset($VAR['id'])) {
         $id = $VAR['id'];
         for ($i = 0; $i < count($id); $i++) {
             if ($id[$i] != '') {
                 $q = '%Affiliate Commission ID ' . $id[$i] . '%';
                 $db =& DB();
                 $sql = "DELETE FROM " . AGILE_DB_PREFIX . "discount WHERE\n\t\t\t\t\t\t   notes     LIKE " . $db->qstr($q) . " AND\n\t\t\t\t\t\t   site_id    = " . $db->qstr(DEFAULT_SITE);
                 $result = $db->Execute($sql);
             }
         }
     } else {
         $id = $VAR['delete_id'];
         $q = '%Affiliate Commission ID ' . $id . '%';
         $db =& DB();
         $sql = "DELETE FROM " . AGILE_DB_PREFIX . "discount WHERE\n\t\t\t\tnotes     LIKE " . $db->qstr($q) . " AND\n\t\t\t\tsite_id    = " . $db->qstr(DEFAULT_SITE);
         $result = $db->Execute($sql);
     }
 }

//.........这里部分代码省略.........
            if (!defined("FORCE_PAGE")) {
                define('FORCE_PAGE', $VAR['_page_current']);
            }
            return;
        }
        ### Change password
        $password_changed = false;
        if (isset($VAR['account_password']) && $VAR['account_password'] != "") {
            if (isset($VAR['confirm_password']) && $VAR['account_password'] == $VAR['confirm_password']) {
                $password = $VAR['account_password'];
                unset($VAR['account_password']);
                @($VAR["account_password"] = $password);
                ### Alert: the password has been changed!
                global $C_debug, $C_translate;
                $C_debug->alert($C_translate->translate('password_changed', 'account', ''));
                $password_changed = true;
                /* check if new password is ok */
                global $C_list;
                if ($C_list->is_installed('account_password_history')) {
                    include_once PATH_MODULES . 'account_password_history/account_password_history.inc.php';
                    $accountHistory = new account_password_history();
                    if (!$accountHistory->getIsPasswordOk(SESS_ACCOUNT, $VAR['account_password'], false)) {
                        $C_debug->alert("The password you have selected has been used recently and cannot be used again at this time for security purposes.");
                        unset($VAR["account_password"]);
                        $password_changed = false;
                    }
                }
            } else {
                ### ERROR: The passwords provided do not match!
                global $C_debug, $C_translate;
                $C_debug->alert($C_translate->translate('password_change_match', 'account', ''));
                unset($VAR["account_password"]);
            }
        } else {
            unset($VAR["account_password"]);
        }
        ### Change theme
        if (isset($VAR['tid']) && $VAR['tid'] != "") {
            @($VAR["account_theme_id"] = $VAR['tid']);
        }
        ### Change Language
        if (isset($VAR['lid']) && $VAR['lid'] != "") {
            @($VAR["account_language_id"] = $VAR['lid']);
        }
        ### Change country
        if (isset($VAR['cid']) && $VAR['cid'] != "") {
            @($VAR["account_country_id"] = $VAR['cid']);
        }
        ### Change currency
        if (isset($VAR['cyid']) && $VAR['cyid'] != "") {
            @($VAR["account_currency_id"] = $VAR['cyid']);
        }
        ### Get the old username ( for db mapping )
        $db =& DB();
        $sql = 'SELECT username FROM ' . AGILE_DB_PREFIX . 'account WHERE
					site_id     = ' . $db->qstr(DEFAULT_SITE) . ' AND
					id          = ' . $db->qstr(SESS_ACCOUNT);
        $result = $db->Execute($sql);
        if ($result->RecordCount() > 0) {
            $old_username = $result->fields['username'];
        }
        ### Update the record
        $this->account_construct();
        $type = "update";
        $this->method["{$type}"] = split(",", $this->method["{$type}"]);
        $db = new CORE_database();
        $db->update($VAR, $this, $type);
        /* password logging class */
        if ($password_changed && is_object($accountHistory)) {
            $accountHistory->setNewPassword(SESS_ACCOUNT, $VAR['account_password'], false);
        }
        ### Update the static vars:
        $static_var->update($VAR, 'account', SESS_ACCOUNT);
        ### Do any db_mapping
        global $C_list;
        if ($C_list->is_installed('db_mapping')) {
            include_once PATH_MODULES . 'db_mapping/db_mapping.inc.php';
            $db_map = new db_mapping();
            if (!empty($password)) {
                $db_map->plaintext_password = $password;
            } else {
                $db_map->plaintext_password = false;
            }
            $db_map->account_edit(SESS_ACCOUNT, $old_username);
        }
        /* update groups for subaccount */
        if ($issubaccount) {
            $db =& DB();
            $db->Execute(sqlDelete($db, "account_group", "group_id>2 and \n\t\t\t\t(service_id is null or service_id=0 or service_id='') \n\t\t\t\tand account_id=" . $db->qstr($VAR['account_id'])));
            if (!empty($VAR['groups'])) {
                global $C_auth;
                foreach ($VAR['groups'] as $gid => $val) {
                    if ($gid == $val && $C_auth->auth_group_by_id($gid)) {
                        $fields = array('account_id' => $VAR['account_id'], 'group_id' => $gid, 'active' => 1, 'date_orig' => time());
                        $db->Execute(sqlInsert($db, "account_group", $fields));
                    }
                }
            }
        }
    }

    function add($VAR)
    {
        global $C_translate, $C_debug;
        $VAR['htaccess_dir_htaccess'] = '# Error!';
        $this->validated = true;
        ### Change the path...
        if (isset($VAR['htaccess_dir_path']) && $VAR['htaccess_dir_path'] != '') {
            # trim whitspaces
            $VAR['htaccess_dir_path'] = trim($VAR['htaccess_dir_path']);
            # replace all forward slashes with back slashes
            $VAR['htaccess_dir_path'] = ereg_replace('\\\\', '/', $VAR['htaccess_dir_path']);
            # add the final trailing slash if missing
            if (!ereg('[/]$', $VAR['htaccess_dir_path'])) {
                $VAR['htaccess_dir_path'] = $VAR['htaccess_dir_path'] . '/';
            }
        }
        if (isset($VAR['htaccess_dir_path']) && $VAR['htaccess_dir_path'] != '') {
            ################################################################
            ### VERIFY LOCAL PATH & WRITABILITY!
            @($filename = $VAR['htaccess_dir_path'] . '.htaccess');
            @($id = $VAR['htaccess_dir_htaccess_id']);
            $db =& DB();
            $sql = 'SELECT name FROM ' . AGILE_DB_PREFIX . 'htaccess WHERE
						   site_id     = ' . $db->qstr(DEFAULT_SITE) . ' AND
						   id          = ' . $db->qstr($id);
            $result = $db->Execute($sql);
            @($name = $result->fields['name']);
            ### Check path
            $path = $VAR['htaccess_dir_path'];
            if (is_dir($path)) {
                ### Check if is writable!
                if (!is_writable($path)) {
                    ## Path not writable!
                    $this->validated = false;
                    $this->val_error[] = array('field' => 'none', 'field_trans' => $C_translate->translate('error', 'core', ""), 'error' => $C_translate->translate('path_auth', 'htaccess_dir', ""));
                }
            } else {
                ### Path broken!
                $this->validated = false;
                $this->val_error[] = array('field' => 'none', 'field_trans' => $C_translate->translate('error', 'core', ""), 'error' => $C_translate->translate('path_broke', 'htaccess_dir', ""));
            }
        }
        ####################################################################
        ### If validation was failed, skip the db insert &
        ### set the errors & origonal fields as Smarty objects,
        ### and change the page to be loaded.
        ####################################################################
        if (!$this->validated) {
            global $smarty;
            # set the errors as a Smarty Object
            $smarty->assign('form_validation', $this->val_error);
            # set the page to be loaded
            if (!defined("FORCE_PAGE")) {
                define('FORCE_PAGE', $VAR['_page_current']);
            }
            return;
        }
        ####################################################################
        ### Create the record/verify fields
        $type = "add";
        $this->method["{$type}"] = explode(",", $this->method["{$type}"]);
        $db = new CORE_database();
        $dir_id = $db->add($VAR, $this, $type);
        ####################################################################
        ### Create the .htaccess file
        if (isset($dir_id) && $dir_id > 0) {
            ### GENERATE THE EXCLUDE LIST
            $exclude_list = $this->exclude_list();
            ### GENERATE THE .HTACCESS FILE
            $nl = "\n";
            $data = $this->htaccess_extra . 'RewriteEngine on' . $nl;
            if (empty($VAR['htaccess_dir_recursive'])) {
                $data .= 'RewriteRule   ^(.*)/.*$      -                  [L]' . $nl;
            }
            $data .= 'RewriteRule ' . $exclude_list . '$ htaccess_index.php?_HTACCESS_ID=' . $id . '&_HTACCESS_DIR_ID=' . $dir_id;
            ### Update the db record
            $db =& DB();
            $sql = "UPDATE " . AGILE_DB_PREFIX . "htaccess_dir SET\n\t\t\t\t   htaccess = " . $db->qstr($data) . " WHERE\n\t\t\t\t   id       = " . $db->qstr($dir_id) . " AND\n\t\t\t\t   site_id  = " . $db->qstr(DEFAULT_SITE);
            $result = $db->Execute($sql);
            ### WRITE THE LOCAL .HTACCESS FILE
            $fp = fopen($filename, "w+");
            fwrite($fp, $data);
            fclose($fp);
            ### WRITE THE htaccess_index.php FILE
            $php_filename = $VAR['htaccess_dir_path'] . 'htaccess_index.php';
            $data = $this->create_php();
            $fp = fopen($php_filename, "w+");
            fwrite($fp, $data);
            fclose($fp);
        }
    }

    function view($VAR)
    {
        global $smarty;
        $this->construct();
        $type = "view";
        $this->method["{$type}"] = split(",", $this->method["{$type}"]);
        $db = new CORE_database();
        $db->view($VAR, $this, $type);
        ### Define the group mapping....
        $id = @$VAR['id'];
        ### Get the variables for this map plugin:
        $db =& DB();
        $sql = 'SELECT * FROM ' . AGILE_DB_PREFIX . 'db_mapping WHERE
			  id      = ' . $db->qstr(@$VAR["id"]) . ' AND
			  site_id = ' . $db->qstr(DEFAULT_SITE);
        $result = $db->Execute($sql);
        ### error reporting:
        if ($result === false) {
            global $C_debug;
            $C_debug->error('db_mapping.inc.php', 'view', $db->ErrorMsg());
            return;
        }
        $file = $result->fields['map_file'];
        $group_map = $result->fields['group_map'];
        if ($group_map != '') {
            $group_map = unserialize($group_map);
        } else {
            $group_map = array();
        }
        if ($file != '') {
            include_once PATH_PLUGINS . 'db_mapping/' . $file . '.php';
            eval('$_MAP = new map_' . strtoupper($file) . ';');
            ### If this map type is 'db' groups based:
            if ($_MAP->map['group_type'] == 'db' || $_MAP->map['group_type'] == 'db-status') {
                ### Connect to the DB & get the groups:
                $dbm = new db_mapping();
                $db = $dbm->DB_connect($id, 'false');
                eval('@$db_prefix = DB2_PREFIX' . strtoupper($file) . ';');
                $sql = "SELECT * FROM " . $db_prefix . "" . $_MAP->map['group_map']['table'] . "\n\t\t\t\t\t\t\t ORDER BY      " . $_MAP->map['group_map']['name'];
                $db2 = $db->Execute($sql);
                if ($db2 === false) {
                    global $C_debug;
                    $C_debug->error('db_mapping.inc.php', 'view', $db->ErrorMsg());
                    $smarty->assign('db_mapping_result', $db->ErrorMsg());
                    return;
                }
                ### get the remote groups...
                if ($db2->RecordCount() > 0) {
                    $i = 0;
                    while (!$db2->EOF) {
                        $smart[$i]['id'] = $db2->fields[$_MAP->map['group_map']['id']];
                        $smart[$i]['name'] = $db2->fields[$_MAP->map['group_map']['name']];
                        $db2->MoveNext();
                        $i++;
                    }
                    ### Get the local groups:
                    $db =& DB();
                    $sql = 'SELECT * FROM ' . AGILE_DB_PREFIX . 'group WHERE
							site_id = ' . $db->qstr(DEFAULT_SITE) . '
							ORDER BY name';
                    $groups = $db->Execute($sql);
                    if ($groups === false) {
                        global $C_debug;
                        $C_debug->error('db_mapping.inc.php', 'view', $db->ErrorMsg());
                        return;
                    }
                    if ($groups->RecordCount() > 0) {
                        $i = 0;
                        while (!$groups->EOF) {
                            $id = $groups->fields['id'];
                            $smartgr[$i]['id'] = $groups->fields['id'];
                            $smartgr[$i]['name'] = $groups->fields['name'];
                            for ($ii = 0; $ii < count($smart); $ii++) {
                                $rid = $smart[$ii]['id'];
                                $name = $smart[$ii]['name'];
                                $checked = false;
                                if (isset($group_map[$id][$rid]) && $group_map[$id][$rid] != false) {
                                    $checked = true;
                                }
                                $smartgr[$i]['remote'][$ii]['id'] = $rid;
                                $smartgr[$i]['remote'][$ii]['name'] = $name;
                                $smartgr[$i]['remote'][$ii]['check'] = $checked;
                            }
                            $groups->MoveNext();
                            $i++;
                        }
                        ### Define smarty vars
                        $smarty->assign('db_mapping_result', false);
                        $smarty->assign('db_mapping_template', 'db_mapping:group_map_' . $_MAP->map['group_type']);
                        $smarty->assign('db_mapping_groups', $smartgr);
                    } else {
                        global $C_translate;
                        $message = $C_translate->translate('no_local_groups', 'db_mapping', '');
                        $smarty->assign('db_mapping_result', $message);
                    }
                } else {
                    global $C_translate;
                    $message = $C_translate->translate('no_remote_groups', 'db_mapping', '');
                    $smarty->assign('db_mapping_result', $message);
                }
//.........这里部分代码省略.........

 function update($VAR)
 {
     $type = "update";
     $this->method["{$type}"] = explode(",", $this->method["{$type}"]);
     $db = new CORE_database();
     $db->update($VAR, $this, $type);
     # update the voip_sip table fields
     $db =& DB();
     $rs = $db->Execute(sqlSelect($db, "voip_did", "did", "id=::" . $VAR['id'] . "::"));
     #echo "<pre>".print_r($VAR,true)."</pre>";
     $f[0]['username'] = $VAR['sip_username'];
     $f[1]['secret'] = $VAR['sip_secret'];
     $f[2]['qualify'] = $VAR['sip_qualify'];
     $f[3]['mailbox'] = $VAR['sip_mailbox'];
     $f[4]['incominglimit'] = $VAR['sip_incominglimit'];
     $f[5]['dtmfmode'] = $VAR['sip_dtmfmode'];
     $f[6]['canreinvite'] = $VAR['sip_canreinvite'];
     $f[7]['callerid'] = $VAR['sip_callerid'];
     $f[8]['nat'] = $VAR['sip_nat'];
     for ($i = 0; $i < 9; $i++) {
         #echo "<pre>".print_r($f[$i],true)."</pre>";
         $k = key($f[$i]);
         $v = $f[$i][$k];
         if (empty($v)) {
             $sql = "DELETE FROM " . AGILE_DB_PREFIX . "voip_sip WHERE sip=" . $db->qstr($rs->fields['did']) . " and keyword=" . $db->qstr($k) . " and site_id=" . DEFAULT_SITE;
         } else {
             $rs2 = $db->Execute(sqlSelect($db, "voip_sip", "id", "sip=::" . $rs->fields['did'] . ":: AND keyword=::" . $k . "::"));
             if ($rs2 && $rs2->fields[0] > 0) {
                 $sql = "UPDATE " . AGILE_DB_PREFIX . "voip_sip SET data=" . $db->qstr($v) . " WHERE sip=" . $db->qstr($rs->fields['did']) . " and keyword=" . $db->qstr($k) . " and site_id=" . DEFAULT_SITE;
             } else {
                 $flds['data'] = $v;
                 $flds['keyword'] = $k;
                 $flds['sip'] = $rs->fields['did'];
                 $sql = sqlInsert($db, "voip_sip", $flds);
                 # $sql = "INSERT INTO ".AGILE_DB_PREFIX."voip_sip SET data=".$db->qstr($v)." WHERE sip=".$db->qstr($rs->fields['did'])." and keyword=".$db->qstr($k)." and site_id=".DEFAULT_SITE;
             }
         }
         if (!$db->Execute($sql)) {
             echo $db->ErrorMsg();
         }
     }
 }