} 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);
