define('BASE_PATH', dirname(__FILE__));

header("Content-Type: text/html;charset=utf-8");

header("X-Frame-Options: SAMEORIGIN");

include_once(BASE_PATH . "/lib/session.php");

Session::init();

date_default_timezone_set('UTC');

include(BASE_PATH . '/modules/configuration.php');

initConfiguration();

// buffer unless we are in the download module (it will handle the buffering itself)

if (v($_REQUEST["type"]) != "dl") {

include_once(BASE_PATH . "/lib/output.php");

Output::buffer();

} else {

$_REQUEST["type"] = 'download';

}

if (defined("TRACE_FILEPATH") && TRACE_FILEPATH && defined("TRACE_MESSAGES") && TRACE_MESSAGES)

ini_set("error_log", TRACE_FILEPATH);

include_once(BASE_PATH . "/lib/util.php");

require( BASE_PATH . '/modules/auth.php');

$auth_module = new MyWebSQL_Authentication();

if (!$auth_module->authenticate()) {

if (v($_REQUEST["q"]) == "wrkfrm")

echo view('session_expired');

else {

include(BASE_PATH . "/modules/splash.php");

$form = view( 'auth', array(

'LOGINID' => htmlspecialchars( $auth_module->getUserName() ),

'SERVER_NAME' => htmlspecialchars( $auth_module->getCustomServer() ),

'SERVER_TYPE' => htmlspecialchars( $auth_module->getCustomServerType() ),

) );

echo getSplashScreen($auth_module->getError(), $form);

}

Output::flush();

exit();

}

unset($auth_module);

$_db_info = getDBClass();

include_once($_db_info[0]);

$_db_class = $_db_info[1];

$DB = new $_db_class();

unset($_db_info);

unset($_db_class);

if (v($_REQUEST["db"]) && ( Session::get('db', 'name') != v($_REQUEST["db"]) ) ) {

Session::set('db', 'changed', true);

Session::set('db', 'name', $_REQUEST["db"]);

if (v($_GET["x"]) == 1)

echo '<div id="results">1</div>'; // success

else

header('Location: '.EXTERNAL_PATH);

exit;

}

// after this, we need the user set options to be visible everywhere

include_once(BASE_PATH . "/lib/options.php");

if (v($_REQUEST["q"]) == "wrkfrm") {

if (!$DB->connect(DB_HOST, DB_USER, DB_PASS, getDbName() ))

die(showDBError());

execute_request($DB);

$DB->disconnect();

include_once(BASE_PATH . "/lib/output.php");

Output::flush();

exit();

}

include(BASE_PATH . "/lib/html.php");

include(BASE_PATH. "/lib/interface.php");

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset='utf-8';" />

<title>MyWebSQL</title>

<link rel="stylesheet" type="text/css" href="cache.php?css=theme,default" />

<link rel="SHORTCUT ICON" href="favicon.ico" />

<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1, user-scalable=no, minimal-ui">

<meta name="apple-mobile-web-app-capable" content="yes">

<meta name="apple-mobile-web-app-status-bar-style" content="black">

<link rel="stylesheet" type="text/css" href="cache.php?css=menu,treeview,results,context,alerts" />

<script type="text/javascript" language="javascript" src="cache.php?script=jquery,mobile,<?php echo $DB->name(); ?>"></script>

<!--[if lt IE 8]>

<script type="text/javascript" language="javascript" src="cache.php?script=json2"></script>

<![endif]-->

</head>

<body class="mainbody">

if (!$DB->connect(DB_HOST,DB_USER,DB_PASS,getDbName())) {

include(BASE_PATH . "/modules/splash.php");

die(getSplashScreen(showDBError()));

}

if (Session::get('session', 'init') != '1') {

// session just started, so we load information here

Session::set('db', 'user', $DB->getCurrentUser(), true);

Session::set('session', 'init', 1);

}

$KEY_CODES = getKeyCodes();

<div id="editToolbar">

<div class="tb-header ui-widget-header"><span class="fname"></span></div>

<div class="tb-row">Type: <span class="ftype"></span></div>

<div class="tb-row">[ <?php echo str_replace('{{KEY}}', $KEY_CODES['KEYCODE_SETNULL'][1], __('Press {{KEY}} to set NULL')); ?> ]</div>

</div>

<div id="inplace-text">

<div class="tb-row"><textarea rows="4" cols="20"></textarea></div>

</div>

<div class="ui-layout-north">

<div id="main_header">

<a target="_blank" href="<?php echo PROJECT_SITEURL;?>"><img src="img/logo.png" class="logo" alt="MyWebSQL" width="45" height="38" border="0" /></a>

<div class="title">

<div class="main">MyWebSQL</div>

<div class="version"><?php echo __('version') . ' ' . APP_VERSION; ?></div>

</div>

<div class="info">

<span class="server"><?php echo htmlspecialchars(Session::get('auth', 'server_name', true)); ?></span> - <?php echo htmlspecialchars(Session::get('db', 'version_comment')); ?>&nbsp;<?php echo htmlspecialchars(Session::get('db', 'version_full')); ?><br />

<?php echo str_replace('{{USER}}', htmlspecialchars(Session::get('db', 'user', true)), __('Logged in as: {{USER}}')); ?>

</div>

<div class="updates ui-state-active"></div>

</div>

<div id="toolbarHolder">

echo getMenuBarHTML();

</div>

</div>

<div class="ui-layout-west">

<div id="db_combo" class="ui-state-default">

<?php $db_list = printDbList($DB); ?>

</div>

<div id="object_list" class="ui-state-default">

<?php echo getDatabaseTreeHTML($DB, $db_list); ?>

</div>

<div id="object-filter" class="ui-state-default">

<input type="text" id="object-filter-text" size="5" placeholder="Type to filter object list" data-placeholder="<?php echo __('Type to filter object list'); ?>" autocomplete="1" />

</div>

</div>

<div class="ui-layout-center">

<div id="screenContent" class="ui-layout-data-center">

<ul>

<li><a href="#tab-results" id="headerResults"><?php echo __('Results'); ?></a></li>

<li><a href="#tab-messages" id="headerMessages"><?php echo __('Messages'); ?></a></li>

<li><a href="#tab-info" id="headerInfo"><?php echo __('Information'); ?></a></li>

<li><a href="#tab-history" id="headerHistory"><?php echo __('History'); ?></a></li>

</ul>

<div id="screen-pane-buttons">

<button id="sp-results-maximize" title="<?php echo __('Maximize/Restore Results Pane'); ?>"></button>

</div>

<div class="ui-layout-content ui-corner-bottom">

<div id="tab-results">

<div id="results-div"><div class="message" style="text-align:center"><?php echo __('There are no results to show in this view'); ?></div></div>

<div id="rec_pager">

<table width="100%" border="0" cellpadding="0" cellspacing="0" class="ui-state-default">

<tr>

<td id="recordCounter" class="footer" nowrap="nowrap">&nbsp;</td>

<td id="timeCounter" class="footer" nowrap="nowrap">&nbsp;</td>

<td id="modifyFlag" class="footer" nowrap="nowrap"><!--button id="nav_refresh">Refresh results</button--></td>

<td id="messageContainer" class="footer" nowrap="nowrap"><?php echo __('Please wait'); ?> ...</td>

<td id="pagingContainer" class="footer" nowrap="nowrap"></td>

</tr>

</table>

</div>

</div>

<div id="tab-messages">

<div id="messages-div"></div>

</div>

<div id="tab-info" class="ui-widget">

<div id="info-div"></div>

</div>

<div id="tab-history">

<table id="sql-history" width="100%"><tbody><tr><td></td></tr></tbody></table>

</div>

</div>

</div>

<div id="sql-editor-pane" class="ui-layout-data-south">

<ul>

<li><a href="#editor_container"><?php echo __('SQL Editor'); ?></a></li>

<li><a href="#editor_container2"><?php echo __('SQL Editor'); ?> 2</a></li>

<li><a href="#editor_container3"><?php echo __('SQL Editor'); ?> 3</a></li>

</ul>

<div id="editor_container">

<textarea class="sql-editor" id="commandEditor" name="commandEditor" rows="5" cols="40"></textarea>

</div>

<div id="editor_container2">

<textarea class="sql-editor" id="commandEditor2" name="commandEditor2" rows="5" cols="40"></textarea>

</div>

<div id="editor_container3">

<textarea class="sql-editor" id="commandEditor3" name="commandEditor3" rows="5" cols="40"></textarea>

</div>

<div id="nav_bar">

<button id="nav_queryall"><?php echo __('Query All'); ?></button>

<button id="nav_query"><?php echo __('Query'); ?></button>

<button id="nav_addrec"><?php echo __('Add Record'); ?></button>

<button id="nav_copyrec"><?php echo __('Copy Record(s)'); ?></button>

<button id="nav_delete"><?php echo __('Delete Record(s)'); ?></button>

<button id="nav_update"><?php echo __('Update Record(s)'); ?></button>

<button id="nav_gensql"><?php echo __('Generate SQL'); ?></button>

</div>

<div id="loader">

<img width="60" height="12" id="loaderImg" src="themes/<?php echo THEME_PATH; ?>/images/loading.gif" alt="<?php echo __('Loading'); ?>..." />

</div>

</div>

</div>

<div class="ui-layout-south">

<div id="taskbar" class="ui-state-default">

<button class="min-all" title="<?php echo __('Minimize All'); ?>"><?php echo __('Minimize All'); ?></button>

</div>

</div>

<?php include(BASE_PATH . '/modules/views/dialogs.php'); ?>

<iframe src="javascript:false" name="wrkfrm" id="wrkfrm" frameborder="0" width="0" height="0"></iframe>

<div id="screen-wait" class="ui-widget-overlay">

<div><span><?php echo __('Loading'); ?>...</span><img src="themes/<?php echo THEME_PATH; ?>/images/loading.gif" alt="" /></div>

<div class="compat-notice" style="display:none;margin:200px auto;width:530px;color: #222222;font-family:segoe ui;font-size:13pt;font-weight:bold">

<?php echo __('Your browser appears to be very old and does not support all features required to run MyWebSQL.'); ?><br /><br />

<?php echo __('Try using a newer version of the browser to run this application.'); ?>

</div>

</div>

<script type="text/javascript" language="javascript">

var THEME_PATH = "<?php echo THEME_PATH;?>";

var EXTERNAL_PATH = "<?php echo EXTERNAL_PATH; ?>";

var COOKIE_LIFETIME = <?php echo COOKIE_LIFETIME; ?>; // hours

var MAX_TEXT_LENGTH_DISPLAY = <?php echo MAX_TEXT_LENGTH_DISPLAY; ?>;

var APP_LANGUAGE = "<?php echo LANGUAGE; ?>";

var APP_VERSION = "<?php echo APP_VERSION; ?>";

var DB_DRIVER = "<?php echo Session::get('db', 'driver'); ?>";

var DB_VERSION = <?php echo Session::get('db', 'version'); ?>;

var DB = db_<?php echo $DB->name(); ?>;

var commandEditor = null;

var commandEditor2 = null;

var commandEditor3 = null;

include(BASE_PATH . '/config/updates.php');

if($AUTOUPDATE_CHECK === TRUE && Session::get('updates', 'check') == '' ) {

if (in_array(date('D'), $AUTOUPDATE_DAYS)) {

echo "\n\t$(function() { helpCheckUpdates(); });\n";

}

}

if (Session::get('db', 'changed')) {

echo 'document.getElementById("messageContainer").innerHTML = "Database changed to: '.htmlspecialchars(Session::get('db', 'name')).'";';

Session::del('db', 'changed');

}

else

echo 'document.getElementById("messageContainer").innerHTML = "Connected to: '.htmlspecialchars(DB_HOST).' as '.htmlspecialchars(DB_USER).'";';

</script>

<script type="text/javascript" language="javascript" src="cache.php?script=layout,ui,dialogs,context,alerts,cookies,select,interface,options,treeview,common,taskbar,settings,query,tables,clipboard"></script>

$DB->disconnect();

echo getContextMenusHTML();

updateSqlEditor();

echo getHotkeysHTML();

echo getGeneratedJS();

</body></html>

Output::flush();