$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 .= ' ' . lang('choose_table') . ' '; $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) {