} else { $tpl->assign_block_vars('CONNECTION_ERROR', array('MSG' => SQLError('', $connectMsg, true))); $dbDetect = false; } if (false !== $dbDetect) { $saveButton = str_replace('\'', '\\\'', $lang['L_SAVEANDCONTINUE']); $tpl->assign_block_vars('CONTINUE', array('SAVE_AND_CONTINUE' => $saveButton)); $tpl->assign_block_vars('OK', array()); $tpl->assign_block_vars('CONNECTION_OK', array('RESULT' => $dbDetect)); if (count($databases) == 0) { $tpl->assign_block_vars('CONNECTION_OK_BUT_NO_DB', array()); } } } $tpl->assign_vars(array('SESSION_ID' => session_id(), 'DB_HOST' => $config['dbhost'], 'DB_USER' => $config['dbuser'], 'DB_PASS' => $config['dbpass'], 'DB_MANUAL' => $config['dbmanual'], 'ICON_OK' => $icon['ok'])); $tpl->pparse('show'); } $_SESSION['config'] = $config; $_SESSION['databases'] = $databases; // Step 4: normally not visible - save checked config-params and redirect to // start page of MySQLDumper if ($phase == 3) { // save configuration with checked db-parameters $configSaved = saveConfig(); if (!$configSaved) { // Ouch, although we checked everything before we now couldn't save // the config -> should never happen echo '<h6>MySQLDumper - ' . $lang['L_CONFBASIC'] . '</h6>'; echo '<p class="warnung">Fatal Error: couldn\'t save configuration!!</p>'; } else { // Everything is done - redirect to start screen of MySQLDumper
$dbindex = intval($_GET['dbindex']); $databases['db_selected_index'] = $dbindex; $databases['db_actual'] = $databases['Name'][$dbindex]; SelectDB($dbindex); WriteParams(0); } if (isset($databases['Name']) && count($databases['Name']) > 0) { $tpl->assign_block_vars('MAINTENANCE', array()); $tpl->assign_vars(array('DB_ACTUAL' => $databases['db_actual'], 'DB_SELECTED_INDEX' => $databases['db_selected_index'])); } $tpl->assign_var('GET_FILELIST', get_config_filelist()); if (isset($databases['Name']) && count($databases['Name']) > 0) { $tpl->assign_block_vars('DB_LIST', array()); $datenbanken = count($databases['Name']); for ($i = 0; $i < $datenbanken; $i++) { $selected = $i == $databases['db_selected_index'] ? ' selected' : ''; $tpl->assign_block_vars('DB_LIST.DB_ROW', array('ID' => $i, 'NAME' => $databases['Name'][$i], 'SELECTED' => $selected)); } } else { $tpl->assign_block_vars('NO_DB_FOUND', array()); } $tpl->assign_var('PIC_CACHE', PicCache()); if (!isset($databases['Name']) || count($databases['Name']) < 1) { $tpl->assign_block_vars('DB_NAME_TRUE', array()); } else { $tpl->assign_block_vars('DB_NAME_FALSE', array()); } $tpl->pparse('header'); $tpl->pparse('content'); $tpl->pparse('footer'); ob_end_flush();
include './inc/runtime.php'; include './inc/mysql.php'; include './inc/functions/functions_global.php'; include './lib/template.php'; include './inc/functions/functions_restore.php'; include './lib/json.php'; obstart(true); include './inc/functions/functions_sql.php'; $tplSqlbrowserTableShowTabledataEntry = new MSDTemplate(); $tplSqlbrowserTableShowTabledataEntry->set_filenames(array('tpl_sqlbrowser_table_show_tabledata' => './tpl/sqlbrowser/table/edit_field.tpl')); /* * Fetch and check _GET variables */ $validModes = array('new'); $db = isset($_GET['db']) ? base64_decode($_GET['db']) : $config['db_actual']; $tablename = isset($_GET['tablename']) ? base64_decode($_GET['tablename']) : ''; $fieldname = isset($_GET['fieldname']) ? base64_decode($_GET['fieldname']) : ''; $rowKey = isset($_GET['key']) ? base64_decode($_GET['key']) : ''; $mode = 'new'; if (isset($_GET['do']) && in_array($_GET['do'], $validModes)) { $mode = $_GET['do']; } $tableInfos = getExtendedFieldInfo($db, $tablename); $tplSqlbrowserTableShowTabledataEntry->assign_vars(array('MODE' => $mode)); $row = array(); if ($mode == 'EDIT') { //TODO implement :) } $tplSqlbrowserTableShowTabledataEntry->assign_block_vars('FOOTER_' . $mode, array()); $tplSqlbrowserTableShowTabledataEntry->pparse('tpl_sqlbrowser_table_show_tabledata'); obend(true);
$query = "SELECT * FROM `{$tablename}` WHERE {$rowKey}"; $row = $dbo->query($query, MsdDbFactory::ARRAY_ASSOC); if (false === $row || !isset($row[0])) { //TODO clean error handling echo "<h2>Keine Datensätze gefunden!</h2>"; obend(true); exit; } elseif (count($row) > 1) { // TODO clean error handling echo "<h2>Mehrere Datensätze gefunden!</h2>"; } $row = $row[0]; } elseif ($mode == 'NEW') { foreach ($tableInfos as $key => $val) { if (isset($val['field'])) { $row[$val['field']] = ''; } } } foreach ($row as $key => $value) { $keyComment = ''; if (isset($tableInfos[$key]['comment'])) { $keyComment = $tableInfos[$key]['comment']; } $templateVars = array('NAME' => htmlspecialchars($key), 'KEY' => base64_encode($key), 'KEY_COMMENT' => Html::getJsQuote($keyComment), 'VALUE' => htmlspecialchars($value)); $tplSqlbrowserTableShowTabledataEntry->assign_block_vars('FIELD_' . ($mode == 'VIEW' ? 'VIEW' : 'EDIT'), $templateVars); } $templateVars = array('RECORD_KEY' => base64_encode($rowKey)); $tplSqlbrowserTableShowTabledataEntry->assign_block_vars('FOOTER_' . $mode, $templateVars); $tplSqlbrowserTableShowTabledataEntry->pparse('tplSqlbrowserTableShowTabledataEntry'); obend(true);
$i++; } } $maxOffset = floor($entriesTotal / $entriesShown); if ($maxOffset * $entriesShown == $entriesTotal) { $maxOffset--; } $offsetForeward = $offset < $maxOffset ? $offset + 1 : 0; $offsetBackward = $offset > 0 ? $offset - 1 : $maxOffset; if ($revers == 0) { $entryTo = ($offset + 1) * $entriesShown; if ($entryTo > $entriesTotal) { $entryTo = $entriesTotal; } $pagination = sprintf($lang['L_SHOWING_ENTRY_X_TO_Y_OF_Z'], String::formatNumber($offset * $entriesShown + 1), String::formatNumber($entryTo), String::formatNumber($entriesTotal)); } else { $total = $maxOffset * $entriesShown; $entryFrom = $entriesTotal - $offset * $entriesShown; if ($entryFrom > $entriesTotal) { $entryFrom = $entriesTotal; } $entryTo = $entriesTotal - ($offset + 1) * $entriesShown + 1; if ($entryTo < 1) { $entryTo = 1; } $pagination = sprintf($lang['L_SHOWING_ENTRY_X_TO_Y_OF_Z'], String::formatNumber($entryFrom), String::formatNumber($entryTo), String::formatNumber($entriesTotal)); } $tplLog->assign_vars(array('OFFSET_FOREWARD' => $offsetForeward, 'OFFSET_BACKWARD' => $offsetBackward, 'PAGINATION_ENTRIES' => $pagination)); } $tplLog->pparse('tplLog'); obend(true);