function printDbList(&$db)
{
$dblist = getDbList($db);
// if there is one database for the given userid, let's select it to cut out one extra step
if (!Session::get('db', 'name')) {
$stDb = 0;
$selDb = "";
$stDbList = $db->getStandardDbList();
foreach ($dblist as $dbname) {
if (in_array($dbname, $stDbList)) {
$stDb++;
} else {
$selDb = $dbname;
}
}
if (count($dblist) == $stDb + 1) {
Session::set('db', 'name', $selDb);
$db->selectDb(Session::get('db', 'name'));
}
}
// --- end of automatic selection logic
if (getDbName()) {
$folder = $db->name();
echo view(array($folder . '/dblist', 'dblist'), array(), $dblist);
} else {
print '<span>' . __('Select a database to begin') . '.</span>';
}
return $dblist;
}
/**
* This file is a part of MyWebSQL package
*
* @file: modules/describe.php
* @author Samnan ur Rehman
* @copyright (c) 2008-2014 Samnan ur Rehman
* @web http://mywebsql.net
* @license http://mywebsql.net/license
*/
function processRequest(&$db)
{
if (getDbName() == '' || !isset($_REQUEST['name'])) {
echo view('invalid_request');
return;
}
if ($db->getTableDescription($_REQUEST['name'])) {
createSimpleGrid($db, __('Table Description') . ': [' . htmlspecialchars(getDbName()) . ']');
}
}
/**
* This file is a part of MyWebSQL package
*
* @file: modules/infodb.php
* @author Samnan ur Rehman
* @copyright (c) 2008-2012 Samnan ur Rehman
* @web http://mywebsql.net
* @license http://mywebsql.net/license
*/
function processRequest(&$db)
{
if (getDbName() == '') {
echo view('invalid_request');
return;
}
if ($db->queryTableStatus()) {
createSimpleGrid($db, __('Database summary') . ': [' . htmlspecialchars(getDbName()) . ']');
}
}
function getDatabaseTreeHTML(&$db, $dblist = array())
{
$folder = $db->name();
if (getDbName()) {
$objects = $db->getObjectList(true);
// sort the object listing based on user preferences
$sort = Options::get('ui-tables-sort');
if ($sort && count($objects['tables']) > 1) {
$objects['tables'] = sortTableListing($objects['tables'], $sort);
}
return view(array($folder . '/objtree', 'objtree'), array(), $objects);
}
return view(array($folder . '/dbtree', 'dbtree'), array(), $dblist);
}
/**
* This file is a part of MyWebSQL package
*
* @file: modules/infoserver.php
* @author Samnan ur Rehman
* @copyright (c) 2008-2014 Samnan ur Rehman
* @web http://mywebsql.net
* @license http://mywebsql.net/license
*/
function processRequest(&$db)
{
if (!$db->hasServer()) {
echo view('infoserverless', array());
return;
}
if ($db->queryVariables()) {
$folder = $db->name();
include find_view(array($folder . '/templates/variables', 'templates/variables'));
$vars = parseVariables($db);
$replace = $vars + array('JS' => '');
if (getDbName() == '') {
// no database selected, hide menus that belong to a db only
$replace['JS'] = 'parent.$("#main-menu").find(".db").hide();';
}
echo view(array($folder . '/infoserver', 'infoserver'), $replace);
}
}
<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'));
<?php
/**
* This file is a part of MyWebSQL package
*
* @file: modules/info.php
* @author Samnan ur Rehman
* @copyright (c) 2008-2014 Samnan ur Rehman
* @web http://mywebsql.net
* @license http://mywebsql.net/license
*/
if (getDbName() != '') {
include 'infodb.php';
} else {
include 'infoserver.php';
}
public function getPrefix()
{
global $dbname, $table_prefix;
return '`' . $this - getDbName() . '`.' . $table_prefix;
}
if (isOK($response)) {
printImageArrayResult($response, " ---- GETTING ITEM FAILED ---- ", " ---- GETTING ITEM SUCCESSFULLY COMPLETED ---- ");
} else {
echo $response->getMessage();
}
break;
case "getTrackingDatas":
echo "Getting trackables..." . PHP_EOL;
$email = getEMail();
$password = getPassword();
$dbName = getDbName();
$response = getTrackingDatas($email, $password, $dbName);
if (isOK($response)) {
printImageArrayResult($response, " ---- GETTING TRACKABLES FAILED ---- ", " ---- GETTING TRACKABLES SUCCESSFULLY COMPLETED ---- ", "trackable");
} else {
echo $response->getMessage();
}
break;
case "getStats":
echo "Getting Stats..." . PHP_EOL;
$email = getEMail();
$password = getPassword();
$dbName = getDbName();
$response = getStats($email, $password, $dbName);
if (isOK($response)) {
printResult($response, " ---- GETTING STATS FAILED ---- ", " ---- GETTING STATS SUCCESSFULLY COMPLETED ---- ", true);
} else {
echo $response->getMessage();
}
break;
}
