示例#1
0
     $dbsource['cname'] = lang('current_system');
     $dbsource['dbname'] = $dbname;
 } else {
     $dbsource = $dbsources[$dsid];
     $dbsource['dbpw'] && ($dbsource['dbpw'] = authcode($dbsource['dbpw'], 'DECODE', md5($authkey)));
     if (empty($dbsource['cname']) || empty($dbsource['dbhost']) || empty($dbsource['dbuser']) || empty($dbsource['dbname'])) {
         amessage('dbdatamis');
     }
     $ndb = new cls_mysql();
     if (!$ndb->connect($dbsource['dbhost'], $dbsource['dbuser'], $dbsource['dbpw'], $dbsource['dbname'], 0, false, $dbsource['dbcharset'])) {
         amessage('dbconerr');
     }
 }
 $dbtables = array('' => lang('select_table'));
 $query = $ndb->query("SHOW TABLES FROM {$dbsource['dbname']}");
 while ($v = $ndb->fetch_row($query)) {
     $dbtables[$v[0]] = $v[0];
 }
 $dsidsarr = array(0 => lang('current_system'));
 foreach ($dbsources as $k => $v) {
     $dsidsarr[$k] = $v['cname'];
 }
 $filterbox = lang('choose_db_src') . '  :  ';
 $filterbox .= "<select style=\"vertical-align: middle;\" name=\"dsid\" onchange=\"redirect('?entry=dbsources&action=viewconfigs&dsid=' + this.options[this.selectedIndex].value);\">";
 foreach ($dsidsarr as $k => $v) {
     $filterbox .= "<option value=\"{$k}\"" . ($dsid == $k ? ' selected' : '') . ">{$v}</option>";
 }
 $filterbox .= "</select>";
 $filterbox .= '&nbsp; &nbsp; &nbsp; ' . lang('choose_table') . '&nbsp; &nbsp;';
 $filterbox .= "<select style=\"vertical-align: middle;\" name=\"dbtable\" onchange=\"redirect('?entry=dbsources&action=viewconfigs&dsid={$dsid}&dbtable=' + this.options[this.selectedIndex].value);\">";
 foreach ($dbtables as $k => $v) {