PHP db::query_first方法代码示例

 /**
  * Class constructor of diskspace. Gets reference for database connection.
  * Builds self::taxclasses from database values.
  *
  * @param db     Reference to database handler
  *
  * @author Former03 GmbH :: Florian Lippert <flo@syscp.org>
  */
 function __construct($db)
 {
     $this->db = $db;
     $default_taxclass_result = $this->db->query_first('SELECT `classid` FROM `' . TABLE_BILLING_TAXCLASSES . '` WHERE `default` = \'1\' LIMIT 0,1');
     $this->default_taxclass = $default_taxclass_result['classid'];
     $last_taxclass_validfrom = 0;
     $taxclasses_result = $this->db->query('SELECT `taxclass`, `taxrate`, `valid_from` FROM `' . TABLE_BILLING_TAXRATES . '` ORDER BY `valid_from` ASC');
     while ($taxclasses_row = $this->db->fetch_array($taxclasses_result)) {
         if (!isset($this->taxclasses[$taxclasses_row['taxclass']]) || !is_array($this->taxclasses[$taxclasses_row['taxclass']])) {
             $this->taxclasses[$taxclasses_row['taxclass']] = array();
         }
         $this->taxclasses[$taxclasses_row['taxclass']][$taxclasses_row['valid_from']] = $taxclasses_row;
         if (isset($this->taxclasses[$taxclasses_row['taxclass']][$last_taxclass_validfrom]) && is_array($this->taxclasses[$taxclasses_row['taxclass']][$last_taxclass_validfrom]) && $taxclasses_row['valid_from'] != 0) {
             $this->taxclasses[$taxclasses_row['taxclass']][$last_taxclass_validfrom]['valid_to'] = $taxclasses_row['valid_from'];
         }
         $last_taxclass_validfrom = $taxclasses_row['valid_from'];
     }
 }

 /**
  * This is the main invoice collector. It collects all items for a userid and also
  * can fix the invoice and imports all cancelled invoices which should be reinvoiced.
  * For every service category it fires up the collector, fetches data and pushes the
  * rows through the taxcontroller to apply taxes before they finally get stored in
  * self::invoices.
  *
  * @param int   UserId to handle
  * @param bool  Fix invoice
  * @return bool true if everything went okay, false if something went wrong
  *
  * @author Former03 GmbH :: Florian Lippert <flo@syscp.org>
  */
 function collect($userId, $fixInvoice = false)
 {
     $this->userId = $userId;
     $this->user = $this->db->query_first('SELECT * FROM `' . getModeDetails($this->mode, 'TABLE_PANEL_USERS', 'table') . '` WHERE `' . getModeDetails($this->mode, 'TABLE_PANEL_USERS', 'key') . '` = \'' . $this->userId . '\' ');
     if ($this->userId == 0 || !is_array($this->user) || empty($this->user) || $this->user[getModeDetails($this->mode, 'TABLE_PANEL_USERS', 'key')] != $this->userId) {
         return false;
     }
     $taxController = new taxController(&$this->db);
     if ($this->user['calc_tax'] === '1') {
         $taxController->calc_tax = true;
     } else {
         $taxController->calc_tax = false;
     }
     $cancelledInvoices_result = $this->db->query('SELECT * FROM `' . getModeDetails($this->mode, 'TABLE_BILLING_INVOICES', 'table') . '` WHERE `' . getModeDetails($this->mode, 'TABLE_BILLING_INVOICES', 'key') . '` = \'' . $this->userId . '\' AND ( `state` = \'' . CONST_BILLING_INVOICESTATE_CANCELLED_REINVOICE_WITHOUT_CREDIT_NOTE . '\' OR `state` = \'' . CONST_BILLING_INVOICESTATE_CANCELLED_REINVOICE_WITH_CREDIT_NOTE . '\' ) ');
     while ($cancelledInvoices_row = $this->db->fetch_array($cancelledInvoices_result)) {
         $this->importXml($cancelledInvoices_row['xml']);
         $this->cancelledInvoices[$cancelledInvoices_row['id']] = $cancelledInvoices_row;
     }
     if ($fixInvoice === true && !empty($this->cancelledInvoices)) {
         $this->db->query('UPDATE `' . getModeDetails($this->mode, 'TABLE_BILLING_INVOICES', 'table') . '` SET `state` = \'' . CONST_BILLING_INVOICESTATE_CANCELLED_REINVOICED . '\', `state_change` = \'' . time() . '\' WHERE `' . getModeDetails($this->mode, 'TABLE_BILLING_INVOICES', 'key') . '` = \'' . $this->userId . '\' AND ( `state` = \'' . CONST_BILLING_INVOICESTATE_CANCELLED_REINVOICE_WITHOUT_CREDIT_NOTE . '\' OR `state` = \'' . CONST_BILLING_INVOICESTATE_CANCELLED_REINVOICE_WITH_CREDIT_NOTE . '\' ) AND `id` IN ( ' . implode(', ', array_keys($this->cancelledInvoices)) . ' ) ');
     }
     foreach ($this->service_categories as $service_category => $service_category_details) {
         if (!class_exists($service_category_details['category_classname'])) {
             require_once './' . makeCorrectFile($service_category_details['category_classfile']);
         }
         if (class_exists($service_category_details['category_classname'])) {
             $subject = 0;
             $mode = $this->mode;
             $include_setup_fee = false;
             $include_interval_fee = false;
             if ($this->mode === 1 && intval($service_category_details['category_mode']) === 1) {
                 if (isset($this->admin2customers[$this->userId])) {
                     $subject = $this->admin2customers[$this->userId];
                     $mode = 0;
                     // We have to set mode to customer because we are feeding an array of customer ids, so serviceCategory should also work in customer mode
                     if (in_array($service_category_details['id'], $this->adminmode_include_once)) {
                         $include_setup_fee = true;
                     }
                     if (in_array($service_category_details['id'], $this->adminmode_include_period)) {
                         $include_interval_fee = true;
                     }
                 }
             } else {
                 $subject = $this->userId;
                 $include_setup_fee = true;
                 $include_interval_fee = true;
             }
             if ($subject != 0) {
                 $currentServiceCategory = new $service_category_details['category_classname'](&$this->db, $mode, $service_category_details['category_name']);
                 $currentServiceCategory->fetchData($subject);
                 $this->invoice = array_merge($this->invoice, $taxController->applyTaxRate($currentServiceCategory->collect($fixInvoice, $include_setup_fee, $include_interval_fee)));
                 unset($currentServiceCategory);
             }
         }
     }
     return true;
 }

 /**
  * Read client data from database.
  */
 private function _readData()
 {
     if (isset($this->cid) && $this->cid != -1) {
         $_client = $this->db->query_first('SELECT * FROM `' . TABLE_FROXLOR_CLIENTS . '` WHERE `id` = "' . $this->cid . '"');
         foreach ($_client as $field => $value) {
             $this->Set($field, $value, true, true);
         }
         // after we have details about the client,
         // we need its settings too
         $this->_readSettings();
     }
 }

 /**
  * Mail notifications.
  */
 public function sendMail($customerid = -1, $template_subject = null, $default_subject = null, $template_body = null, $default_body = null)
 {
     global $mail;
     // Some checks are to be made here in the future
     if ($customerid != -1) {
         // Get e-mail message for customer
         $usr = $this->db->query_first('SELECT `name`, `firstname`, `email` 
                            FROM `' . TABLE_PANEL_CUSTOMERS . '` 
                            WHERE `customerid` = "' . (int) $customerid . '"');
         $replace_arr = array('FIRSTNAME' => $usr['firstname'], 'NAME' => $usr['name'], 'SUBJECT' => $this->Get('subject', true));
     } else {
         $replace_arr = array('SUBJECT' => $this->Get('subject', true));
     }
     $result = $this->db->query_first('SELECT `value` FROM `' . TABLE_PANEL_TEMPLATES . '` 
                             WHERE `adminid`=\'' . (int) $this->userinfo['adminid'] . '\' 
                             AND `language`=\'' . $this->db->escape($this->userinfo['def_language']) . '\' 
                             AND `templategroup`=\'mails\' 
                             AND `varname`=\'' . $template_subject . '\'');
     $mail_subject = html_entity_decode(replace_variables($result['value'] != '' ? $result['value'] : $default_subject, $replace_arr));
     $result = $this->db->query_first('SELECT `value` FROM `' . TABLE_PANEL_TEMPLATES . '` 
                             WHERE `adminid`=\'' . (int) $this->userinfo['adminid'] . '\' 
                             AND `language`=\'' . $this->db->escape($this->userinfo['def_language']) . '\' 
                             AND `templategroup`=\'mails\' 
                             AND `varname`=\'' . $template_body . '\'');
     $mail_body = html_entity_decode(replace_variables($result['value'] != '' ? $result['value'] : $default_body, $replace_arr));
     if ($customerid != -1) {
         $mail->From = $this->settings['ticket']['noreply_email'];
         $mail->FromName = $this->settings['ticket']['noreply_name'];
         $mail->Subject = $mail_subject;
         $mail->Body = $mail_body;
         $mail->AddAddress($usr['email'], $usr['firstname'] . ' ' . $usr['name']);
         if (!$mail->Send()) {
             standard_error(array('errorsendingmail', $usr['email']));
         }
         $mail->ClearAddresses();
     } else {
         $admin = $this->db->query_first('SELECT `email` FROM `' . TABLE_PANEL_ADMINS . "` WHERE `adminid`='" . (int) $this->userinfo['adminid'] . "'");
         $mail->From = $this->settings['ticket']['noreply_email'];
         $mail->FromName = $this->settings['ticket']['noreply_name'];
         $mail->Subject = $mail_subject;
         $mail->Body = $mail_body;
         $mail->AddAddress($admin['email'], $admin['firstname'] . ' ' . $admin['name']);
         if (!$mail->Send()) {
             standard_error(array('errorsendingmail', $admin['email']));
         }
         $mail->ClearAddresses();
     }
 }

 if (!isset($sql_root[$result['dbserver']]) || !is_array($sql_root[$result['dbserver']])) {
     $result['dbserver'] = 0;
 }
 if (isset($_POST['send']) && $_POST['send'] == 'send') {
     // Only change Password if it is set, do nothing if it is empty! -- PH 2004-11-29
     $password = validate($_POST['mysql_password'], 'password');
     $external_access_val = isset($_POST['mysql_allow_external_access']) ? '1' : '0';
     if (!checkNitradoServiceLimit($userinfo['customerid'], 'mysql', 'allow_external_access')) {
         $external_access_val = '0';
     }
     // External access checkbox
     $db_root = new db($sql_root[$result['dbserver']]['host'], $sql_root[$result['dbserver']]['user'], $sql_root[$result['dbserver']]['password'], '');
     if ($external_access_val == '1') {
         $db_root->query('GRANT ALL PRIVILEGES ON `' . $db_root->escape($result['databasename']) . '`.* TO \'' . $db_root->escape($result['databasename']) . '\'@\'%\'', false, true);
         $db_root->query('GRANT USAGE ON *.* TO \'' . $db_root->escape($result['databasename']) . '\'@\'%\' IDENTIFIED BY \'password\'', false, true);
         $current_password = $db_root->query_first('SELECT password FROM mysql.user WHERE user = \'' . $db_root->escape($result['databasename']) . '\' AND Host = \'localhost\'', false, true);
         $db_root->query('SET PASSWORD FOR `' . $db_root->escape($result['databasename']) . '`@`%` = \'' . $current_password['password'] . '\'', false, true);
     } else {
         $db_root->query('REVOKE ALL PRIVILEGES ON * . * FROM `' . $db_root->escape($result['databasename']) . '`@`%`', false, true);
         $db_root->query('REVOKE ALL PRIVILEGES ON `' . str_replace('_', '\\_', $db_root->escape($result['databasename'])) . '` . * FROM `' . $db_root->escape($result['databasename']) . '`@`%`', false, true);
         $db_root->query('DELETE FROM `mysql`.`user` WHERE `User` = "' . $db_root->escape($result['databasename']) . '" AND `Host` = "%"', false, true);
     }
     $db_root->query('FLUSH PRIVILEGES');
     $db_root->close();
     if ($password != '') {
         // validate password
         $password = validatePassword($password);
         $access_result = $db->query_first('SELECT `allow_external_access` FROM `' . TABLE_PANEL_DATABASES . '` WHERE `customerid`="' . (int) $userinfo['customerid'] . '" AND `id`="' . (int) $id . '"');
         // Begin root-session
         $db_root = new db($sql_root[$result['dbserver']]['host'], $sql_root[$result['dbserver']]['user'], $sql_root[$result['dbserver']]['password'], '');
         foreach (array_map('trim', explode(',', $settings['system']['mysql_access_host'])) as $mysql_access_host) {

 public function right()
 {
     $object_id = intval($this->input['object_id']) ? intval($this->input['object_id']) : 0;
     if (empty($object_id)) {
         return false;
     }
     $db = array('host' => '192.168.60.18', 'user' => 'forapp', 'pass' => 'Hoge@mysql', 'database' => 'm2o_mediaserver', 'charset' => 'utf8', 'pconnect' => '0');
     include_once ROOT_PATH . 'lib/db/db_mysql.class.php';
     $g_db = new db();
     $g_db->connect($db['host'], $db['user'], $db['pass'], $db['database'], $db['charset'], $db['pconnect'], $db['dbprefix']);
     $sql = "select * from " . DB_PREFIX . "right_temp where obj_id=" . $object_id;
     $f = $g_db->query_first($sql);
     $right_info = json_decode($f['content'], 1);
     hg_pre($right_info);
 }

    public function show()
    {
        $progressPath = CACHE_DIR . 'progress.txt';
        $totalPath = CACHE_DIR . 'total.txt';
        if (file_exists($progressPath)) {
            $progress = file_get_contents($progressPath);
        } else {
            file_put_contents($progressPath, 0);
            $sql = 'SELECT COUNT(*) AS total FROM ' . DB_PREFIX . 'member';
            $total = $this->db->query_first($sql);
            $total = $total['total'];
            file_put_contents($totalPath, $total);
            $progress = 0;
        }
        $newlegth = $progress + LENGTH;
        $sql = 'SELECT * FROM ' . DB_PREFIX . 'member where id >' . $progress . ' AND id <= ' . $newlegth . ' order by id asc ';
        $query = $this->db->query($sql);
        $arr = array();
        $ids = array();
        while ($row = $this->db->fetch_array($query)) {
            $ids[] = $row['id'];
            $arr[$row['id']] = array('id' => $row['id'], 'uc_id' => $row['uc_id'], 'member_name' => $row['member_name'], 'nick_name' => $row['nick_name'], 'password' => $row['password'], 'email' => $row['email'], 'appid' => $row['appid'], 'appname' => $row['appname'], 'salt' => $row['salt'], 'mobile' => $row['mobile'], 'avatar' => $row['filename'] ? serialize(array('host' => $row['host'], 'dir' => $row['dir'], 'filepath' => $row['filepath'], 'filename' => $row['filename'])) : '', 'create_time' => $row['create_time'], 'update_time' => $row['update_time'], 'ip' => $row['ip']);
        }
        if (!empty($ids)) {
            $sql = 'SELECT * FROM ' . DB_PREFIX . 'member_bound WHERE member_id IN (' . implode(',', $ids) . ')';
            $query = $this->db->query($sql);
            $bound = array();
            while ($row = $this->db->fetch_array($query)) {
                $arr[$row['member_id']]['avatar_url'] = $row['avatar_url'];
                $arr[$row['member_id']]['platform_id'] = $row['platform_id'];
                $arr[$row['member_id']]['nick_name'] = $row['plat_member_name'];
                $platform_id[] = $row['platform_id'];
            }
        }
        if ($platform_id && $this->settings['App_share']) {
            $platform_id_str = implode(',', $platform_id);
            //$access_plat_token_str .= ',d4cf3e1c11842fc401dac4785fc7cb74,4161492c9e237fc3a6a33b6420fdbb73';
            $this->curl->setSubmitType('post');
            $this->curl->initPostData();
            $this->curl->addRequestData('a', 'get_user_by_id');
            $this->curl->addRequestData('id', $platform_id_str);
            $ret = $this->curl->request('get_user.php');
            $ret = $ret[0];
        }
        if (!empty($arr)) {
            foreach ($arr as $key => $val) {
                if (!empty($ret[$val['platform_id']])) {
                    $arr[$key]['type'] = $this->plat_maps[$ret[$val['platform_id']]['plat_type']]['type'];
                    $arr[$key]['type_name'] = $this->plat_maps[$ret[$val['platform_id']]['plat_type']]['type_name'];
                    $arr[$key]['platform_id'] = $ret[$val['platform_id']]['uid'];
                } else {
                    $arr[$key]['type'] = 'm2o';
                    $arr[$key]['type_name'] = 'M2O';
                }
            }
            $source_db = array('host' => 'localhost', 'user' => 'root', 'pass' => 'hogesoft', 'database' => 'jn_members', 'charset' => 'utf8', 'pconncet' => '0', 'dbprefix' => 'm2o_');
            $sourceDB = new db();
            $sourceDB->connect($source_db['host'], $source_db['user'], $source_db['pass'], $source_db['database'], $source_db['charset'], $source_db['pconnect'], $source_db['dbprefix']);
            foreach ($arr as $key => $val) {
                $sql = 'INSERT INTO ' . DB_PREFIX . 'member (
						guid,
						member_name,
						password, 
						salt,
						type, 
						type_name,
						avatar,
						email,
						status,
						appid,
						appname,
						mobile,
						create_time,
						update_time,
						ip)
						VALUES(
						"' . guid() . '",
						"' . $val['member_name'] . '",
						"' . $val['password'] . '",
						"' . $val['salt'] . '",
						"' . $val['type'] . '",
						"' . $val['type_name'] . '",
						"' . addslashes($val['avatar']) . '",
						"' . $val['email'] . '",
						"1",
						"' . $val['appid'] . '",
						"' . $val['appname'] . '",
						"' . $val['mobile'] . '",
						"' . $val['create_time'] . '",
						"' . $val['update_time'] . '",
						"' . $val['ip'] . '"
						)';
                $sourceDB->query_first($sql);
                $iid = $sourceDB->insert_id();
                if (!$iid) {
                    break;
                }
                $val['platform_id'] = !empty($val['platform_id']) ? $val['platform_id'] : (empty($val['uc_id']) ? $iid : $val['uc_id']);
                $sql = 'INSERT INTO ' . DB_PREFIX . 'member_bind (
						member_id, 
//.........这里部分代码省略.........

     if ($db->link_id == 0) {
         fclose($debugHandler);
         unlink($lockfile);
         $cronlog->logAction(CRON_ACTION, LOG_ERR, 'Database-connection crashed during traffic-cronjob, could not reconnect!');
         die('SysCP can\'t connect to mysqlserver. Exiting...');
     }
     fwrite($debugHandler, 'Database-connection re-established' . "\n");
     unset($sql);
     unset($db->password);
     $cronlog->logAction(CRON_ACTION, LOG_WARNING, 'Database-connection crashed during traffic-cronjob, reconnected!');
 }
 /*
  * FTP-Traffic
  */
 fwrite($debugHandler, 'ftp traffic for ' . $row['loginname'] . ' started...' . "\n");
 $ftptraffic = $db->query_first('SELECT SUM(`up_bytes`) AS `up_bytes_sum`, SUM(`down_bytes`) AS `down_bytes_sum` FROM `' . TABLE_FTP_USERS . "` WHERE `customerid`='" . (int) $row['customerid'] . "'");
 if (!is_array($ftptraffic)) {
     $ftptraffic = array('up_bytes_sum' => 0, 'down_bytes_sum' => 0);
 }
 $db->query('UPDATE `' . TABLE_FTP_USERS . "` SET `up_bytes`='0', `down_bytes`='0' WHERE `customerid`='" . (int) $row['customerid'] . "'");
 /*
  * Mail-Traffic
  */
 $mailtraffic = 0;
 /*
  * Total Traffic
  */
 fwrite($debugHandler, 'total traffic for ' . $row['loginname'] . ' started' . "\n");
 $current_traffic = array();
 $current_traffic['http'] = floatval($httptraffic);
 $current_traffic['ftp_up'] = floatval($ftptraffic['up_bytes_sum'] / 1024);

/**
* <b>****************************************** Mandant ***********************************************</b><br />
* Mandant.<br />
*
*/
define('INITIALIZE_MADNANT', true);
if ($_SESSION['mandant']) {
    $mandant = $_SESSION['mandant']['mandant_id'];
}
if ($_GET['mandant']) {
    $mandant = $_GET['mandant'];
}
if ($mandant == "") {
    $mandant = 2;
}
$mandant = $db->query_first("SELECT * FROM rhs_mandant WHERE mandant_id={$mandant}");
if (!$mandant) {
    $mandant = $db->query_first("SELECT * FROM rhs_mandant WHERE mandant_id=2");
}
/**
* <b>****************************************** Header ***********************************************</b><br />
* Class for GZip Output.<br />
*
*/
require $manu_additional_patch . "./lib/class.headers.php";
$i = 0;
$result = $db->query("SELECT * FROM rhs_download_data ORDER BY create_date DESC LIMIT 6");
while ($row = $db->fetch_array($result)) {
    $row['dl_counter_man'] = $i + 1;
    $overall_download_data[$i] = $row;
    $i++;

 //添加时间
 $begin_time = $_REQUEST['begin_time'] ? strtotime($_REQUEST['begin_time'] . ' 00:00:00') : strtotime(date('Y-m-d', time()));
 $end_time = $_REQUEST['end_time'] ? strtotime($_REQUEST['end_time'] . ' 23:59:59') : strtotime(date('Y-m-d', time()) . ' 23:59:59');
 $db_sql = str_replace('$begin_time', ' ' . $begin_time . ' ', $db_sql);
 $db_sql = str_replace('$end_time', ' ' . $end_time . ' ', $db_sql);
 $tt1 = substr($db_sql, 6, strlen($db_sql));
 $total_sql = substr($db_sql, 0, 6);
 $total_sql .= '  SQL_CALC_FOUND_ROWS  ';
 $db_sql = $total_sql . $tt1;
 $db_sql = stripslashes($db_sql);
 //添加limit限制。默认每页显示30条记录
 $str = strstr($db_sql, 'limit');
 if (!$str) {
     $db_sql .= ' limit ' . $pp . ' , ' . 30;
     $qid = $DB->query($db_sql);
     $total = $DB->query_first('select found_rows() as total');
     //此句要用在query之后
     $perpage = 30;
 } else {
     $tmp = explode(',', $str);
     $perpage = intval(trim($tmp[1]));
     $qid = $DB->query($db_sql);
     $total = $DB->query_first('select found_rows() as total');
     if ($total['total'] > $perpage) {
         $total['total'] = $perpage;
     }
 }
 $total = $total['total'];
 //计算分页
 $page_link = array('totalpages' => $total, 'curpage' => intval($pp), 'perpage' => $perpage, 'pagelink' => '?sql=' . urlencode($_REQUEST['sql']) . '&server=' . $db_choice);
 $p_links = hg_build_pagelinks($page_link);

             $row['region'] = $staaten[$ort['adm0']] . " / " . $laender[$ort['adm0']][$ort['adm1']] . " / " . $ort['ort'];
         } else {
             $row['region'] = $row['land'] . " / " . $row['ort'];
         }
         $einsatz[$i] = $row;
         $smarty->assign("einsatz", $einsatz);
         $i++;
     }
     $smarty->display("database_einsatz.tpl.php");
     $db = new db($sqlhost, $sqluser, $sqlpassword, $sqldb, $phpversion);
     break;
 case "dl":
     $i = 0;
     $result = $db->query("SELECT * FROM rhs_download_cat ORDER BY catorder ASC");
     while ($row = $db->fetch_array($result)) {
         $rowdata = $db->query_first("SELECT count(id) as anzahl FROM rhs_download_data WHERE catid = " . $row['id']);
         $row['anzahl'] = $rowdata['anzahl'];
         $linkref[$i] = $row;
         $smarty->assign("linkref", $linkref);
         $i++;
         $optionhtml .= makeoption($row['id'], $row['catname'], $_GET['ref']);
     }
     $smarty->assign("optionhtml", $optionhtml);
     $smarty->display("database_dl_cat.tpl.php");
     break;
 case "dldetail":
     $i = 0;
     $result = $db->query("SELECT * FROM rhs_download_data WHERE catid = " . $_GET['ref'] . " ORDER BY dlname ASC");
     while ($row = $db->fetch_array($result)) {
         $linkref[$i] = $row;
         $smarty->assign("linkref", $linkref);

 /**
  * Mail notifications
  */
 public function sendMail($customerid = -1, $template_subject = null, $default_subject = null, $template_body = null, $default_body = null)
 {
     global $mail;
     // Some checks are to be made here in the future
     if ($customerid != -1) {
         // Get e-mail message for customer
         $usr = $this->db->query_first('SELECT `name`, `firstname`, `company`, `email`
                            FROM `' . TABLE_PANEL_CUSTOMERS . '` 
                            WHERE `customerid` = "' . (int) $customerid . '"');
         $replace_arr = array('FIRSTNAME' => $usr['firstname'], 'NAME' => $usr['name'], 'COMPANY' => $usr['company'], 'SALUTATION' => getCorrectUserSalutation($usr), 'SUBJECT' => $this->Get('subject', true));
     } else {
         $replace_arr = array('SUBJECT' => $this->Get('subject', true));
     }
     $result = $this->db->query_first('SELECT `value` FROM `' . TABLE_PANEL_TEMPLATES . '`
                             WHERE `adminid`=\'' . (int) $this->userinfo['adminid'] . '\' 
                             AND `language`=\'' . $this->db->escape($this->userinfo['def_language']) . '\' 
                             AND `templategroup`=\'mails\' 
                             AND `varname`=\'' . $template_subject . '\'');
     $mail_subject = html_entity_decode(replace_variables($result['value'] != '' ? $result['value'] : $default_subject, $replace_arr));
     $result = $this->db->query_first('SELECT `value` FROM `' . TABLE_PANEL_TEMPLATES . '`
                             WHERE `adminid`=\'' . (int) $this->userinfo['adminid'] . '\' 
                             AND `language`=\'' . $this->db->escape($this->userinfo['def_language']) . '\' 
                             AND `templategroup`=\'mails\' 
                             AND `varname`=\'' . $template_body . '\'');
     $mail_body = html_entity_decode(replace_variables($result['value'] != '' ? $result['value'] : $default_body, $replace_arr));
     if ($customerid != -1) {
         $_mailerror = false;
         try {
             $mail->SetFrom($this->settings['ticket']['noreply_email'], $this->settings['ticket']['noreply_name']);
             $mail->Subject = $mail_subject;
             $mail->AltBody = $mail_body;
             $mail->MsgHTML(str_replace("\n", "<br />", $mail_body));
             $mail->AddAddress($usr['email'], $usr['firstname'] . ' ' . $usr['name']);
             $mail->Send();
         } catch (phpmailerException $e) {
             $mailerr_msg = $e->errorMessage();
             $_mailerror = true;
         } catch (Exception $e) {
             $mailerr_msg = $e->getMessage();
             $_mailerror = true;
         }
         if ($_mailerror) {
             $rstlog = FroxlorLogger::getInstanceOf(array('loginname' => 'ticket_class'), $this->db, $this->settings);
             $rstlog->logAction(ADM_ACTION, LOG_ERR, "Error sending mail: " . $mailerr_msg);
             standard_error('errorsendingmail', $usr['email']);
         }
         $mail->ClearAddresses();
     } else {
         $admin = $this->db->query_first("SELECT `name`, `email` FROM `" . TABLE_PANEL_ADMINS . "` WHERE `adminid`='" . (int) $this->userinfo['adminid'] . "'");
         $_mailerror = false;
         try {
             $mail->SetFrom($this->settings['ticket']['noreply_email'], $this->settings['ticket']['noreply_name']);
             $mail->Subject = $mail_subject;
             $mail->AltBody = $mail_body;
             $mail->MsgHTML(str_replace("\n", "<br />", $mail_body));
             $mail->AddAddress($admin['email'], $admin['name']);
             $mail->Send();
         } catch (phpmailerException $e) {
             $mailerr_msg = $e->errorMessage();
             $_mailerror = true;
         } catch (Exception $e) {
             $mailerr_msg = $e->getMessage();
             $_mailerror = true;
         }
         if ($_mailerror) {
             $rstlog = FroxlorLogger::getInstanceOf(array('loginname' => 'ticket_class'), $this->db, $this->settings);
             $rstlog->logAction(ADM_ACTION, LOG_ERR, "Error sending mail: " . $mailerr_msg);
             standard_error('errorsendingmail', $admin['email']);
         }
         $mail->ClearAddresses();
     }
 }

     $paging = new paging($userinfo, $db, TABLE_PANEL_DATABASES, $fields, $settings['panel']['paging'], $settings['panel']['natsorting']);
     $result = $db->query("SELECT * FROM `" . TABLE_PANEL_DATABASES . "` WHERE `customerid`='" . (int) $userinfo['customerid'] . "' " . $paging->getSqlWhere(true) . " " . $paging->getSqlOrderBy() . " " . $paging->getSqlLimit());
     $paging->setEntries($db->num_rows($result));
     $sortcode = $paging->getHtmlSortCode($lng);
     $arrowcode = $paging->getHtmlArrowCode($filename . '?page=' . $page . '&s=' . $s);
     $searchcode = $paging->getHtmlSearchCode($lng);
     $pagingcode = $paging->getHtmlPagingCode($filename . '?page=' . $page . '&s=' . $s);
     $i = 0;
     $count = 0;
     $mysqls = '';
     // Begin root-session
     $db_root = new db($sql_root[0]['host'], $sql_root[0]['user'], $sql_root[0]['password'], '');
     while ($row = $db->fetch_array($result)) {
         if ($paging->checkDisplay($i)) {
             $row = htmlentities_array($row);
             $mbdata = $db_root->query_first("SELECT SUM( data_length + index_length) / 1024 / 1024 'MB' FROM information_schema.TABLES WHERE table_schema = '" . $db_root->escape($row['databasename']) . "' GROUP BY table_schema ;");
             $row['size'] = number_format($mbdata['MB'], 3, '.', '');
             eval("\$mysqls.=\"" . getTemplate("mysql/mysqls_database") . "\";");
             $count++;
         }
         $i++;
     }
     $db_root->close();
     // End root-session
     $mysqls_count = $db->num_rows($result);
     eval("echo \"" . getTemplate("mysql/mysqls") . "\";");
 } elseif ($action == 'delete' && $id != 0) {
     $result = $db->query_first('SELECT `id`, `databasename`, `description`, `dbserver` FROM `' . TABLE_PANEL_DATABASES . '` WHERE `customerid`="' . (int) $userinfo['customerid'] . '" AND `id`="' . (int) $id . '"');
     if (isset($result['databasename']) && $result['databasename'] != '') {
         if (!isset($sql_root[$result['dbserver']]) || !is_array($sql_root[$result['dbserver']])) {
             $result['dbserver'] = 0;

    public function show()
    {
        $progressPath = CACHE_DIR . 'progress.txt';
        $totalPath = CACHE_DIR . 'total.txt';
        $is_next = true;
        if (file_exists($progressPath) && file_exists($totalPath)) {
            $progress = file_get_contents($progressPath);
            $total = file_get_contents($totalPath);
        } else {
            file_put_contents($progressPath, 0);
            $sql = 'SELECT max(member_id) as max,min(member_id) as min FROM ' . DB_PREFIX . 'member';
            $max_min = $this->db->query_first($sql);
            file_put_contents($totalPath, $max_min['max']);
            file_put_contents($progressPath, $max_min['min']);
            $progress = $max_min['min'] - 1;
            $total = $max_min['max'];
        }
        $newlegth = intval($progress + LENGTH);
        if ($newlegth > intval($total)) {
            $newlegth = $total;
            $is_next = false;
        }
        $sql = 'SELECT * FROM ' . DB_PREFIX . 'member where ( member_id >' . $progress . ') AND ( member_id <= ' . $newlegth . ') order by member_id asc ';
        $query = $this->db->query($sql);
        $member = array();
        $member_id = array();
        while ($row = $this->db->fetch_array($query)) {
            $member[$row['member_id']] = $row;
            $member_id[] = $row['member_id'];
        }
        if ($member_id) {
            $sql = 'SELECT * FROM ' . DB_PREFIX . 'member_bind where member_id IN (' . implode(',', $member_id) . ') order by member_id asc ';
            $query = $this->db->query($sql);
            $member_bind = array();
            while ($row = $this->db->fetch_array($query)) {
                $member_bind[$row['member_id']][] = $row;
            }
        }
        if (!empty($member)) {
            $source_db = array('host' => 'localhost', 'user' => 'root', 'pass' => 'hogesoft', 'database' => 'jn_members2', 'charset' => 'utf8', 'pconncet' => '0', 'dbprefix' => 'm2o_');
            $_sourceDB = new db();
            $_sourceDB->connect($source_db['host'], $source_db['user'], $source_db['pass'], $source_db['database'], $source_db['charset'], $source_db['pconnect'], $source_db['dbprefix']);
            foreach ($member as $key => $val) {
                $insertData = $val;
                if (!$val['guid']) {
                    $insertData['guid'] = guid();
                }
                $sql = 'SELECT count(*) as total FROM ' . DB_PREFIX . 'member where member_name = \'' . $insertData['member_name'] . '\' AND type = \'' . $insertData['type'] . '\'';
                $isInsert = $_sourceDB->query_first($sql);
                if ($isInsert['total'] > 0) {
                    file_put_contents(CACHE_DIR . 'error_member.txt', var_export($insertData, 1), FILE_APPEND);
                    continue;
                }
                unset($insertData['member_id']);
                $cmd = $replace ? 'REPLACE INTO ' : 'INSERT INTO ';
                $sql = $cmd . DB_PREFIX . 'member SET ' . $this->setField($insertData);
                $_sourceDB->query($sql);
                $iid = $_sourceDB->insert_id();
                if (!$iid) {
                    break;
                }
                $sql = 'INSERT INTO ' . DB_PREFIX . 'member_count (
						u_id
						) 
						VALUES(
						' . $iid . '
						)';
                $_sourceDB->query($sql);
                if ($_member_bind = $member_bind[$val['member_id']]) {
                    foreach ($_member_bind as $k => $v) {
                        $inuc = 0;
                        $v['member_id'] = $iid;
                        if ($v['type'] == 'm2o' && $v['inuc'] == 0) {
                            $v['platform_id'] = $iid;
                        }
                        if ($v['type'] == 'uc') {
                            $inuc = $v['platform_id'];
                        } else {
                            if ($v['inuc'] != 0) {
                                $inuc = $v['inuc'];
                            }
                        }
                        $sql = 'SELECT count(*) as total FROM ' . DB_PREFIX . 'member_bind where member_id = ' . $v['member_id'] . ' AND platform_id = \'' . $v['platform_id'] . '\' AND type = \'' . $v['type'] . '\'';
                        $isInsertBind = $_sourceDB->query_first($sql);
                        if ($isInsertBind['total'] > 0) {
                            file_put_contents(CACHE_DIR . 'error_memberbind.txt', var_export($v, 1), FILE_APPEND);
                            continue;
                        }
                        $cmd = $replace ? 'REPLACE INTO ' : 'INSERT INTO ';
                        $sql = $cmd . DB_PREFIX . 'member_bind SET ' . $this->setField($v);
                        $_sourceDB->query($sql);
                        if ($inuc) {
                            $sql = 'UPDATE ' . DB_PREFIX . 'member_bind SET inuc =\'' . $inuc . '\' WHERE member_id = ' . $iid;
                            $_sourceDB->query($sql);
                        }
                    }
                }
            }
            $_sourceDB->close();
            file_put_contents($progressPath, $newlegth);
//.........这里部分代码省略.........