292 lines
11 KiB
PHP
292 lines
11 KiB
PHP
|
<?php
|
||
|
|
/**
|
||
|
|
* This file is a part of MyWebSQL package
|
||
|
|
* @file: index.php
|
||
|
|
* @author Samnan ur Rehman
|
||
|
|
* @copyright (c) 2008-2014 Samnan ur Rehman
|
||
|
|
* @web http://mywebsql.net
|
||
|
|
* @license http://mywebsql.net/license
|
||
|
|
*/
|
||
|
|
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" />
|
||
|
|
<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">
|
||
|
|
<?php
|
||
|
|
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')); ?> <?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">
|
||
|
|
|
||
|
|
<?php
|
||
|
|
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" data-placeholder="<?php echo __('Type to filter object list'); ?>" />
|
||
|
|
</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"> </td>
|
||
|
|
<td id="timeCounter" class="footer" nowrap="nowrap"> </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;
|
||
|
|
<?php
|
||
|
|
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: '.DB_HOST.' as '.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>
|
||
|
|
<?php
|
||
|
|
$DB->disconnect();
|
||
|
|
|
||
|
|
echo getContextMenusHTML();
|
||
|
|
|
||
|
|
updateSqlEditor();
|
||
|
|
|
||
|
|
echo getHotkeysHTML();
|
||
|
|
|
||
|
|
echo getGeneratedJS();
|
||
|
|
?>
|
||
|
|
</body></html>
|
||
|
|
<?php
|
||
|
|
Output::flush();
|
||
|
|
?>
|