/**
* This file is a part of MyWebSQL package
*
* @file: modules/indexes.php
* @author Samnan ur Rehman
* @copyright (c) 2008-2012 Samnan ur Rehman
* @web http://mywebsql.net
* @license http://mywebsql.net/license
*/
function processRequest(&$db)
{
$action = v($_REQUEST["id"]);
include BASE_PATH . "/lib/tableeditor.php";
$editor = new tableEditor($db);
$editor->setName(v($_REQUEST["name"]));
$editor->loadTable(true, true, false);
if ($action == "alter") {
$result = alterTableIndexes($db, v($_REQUEST["query"]), $editor);
$formatted_query = preg_replace("/[\\n|\\r]?[\\n]+/", "<br>", htmlspecialchars($editor->getSql()));
if ($result) {
print '<div id="result">1</div><div id="message">' . '<div class="message ui-state-default">The command executed successfully.</div>' . '<div class="sql-text ui-state-default">' . $formatted_query . '</div>' . '</div>';
} else {
print '<div id="result">0</div><div id="message">' . '<div class="message ui-state-error">Error occured while executing the query:</div>' . '<div class="sql-text ui-state-error">' . $formatted_query . '</div>' . '<div class="message ui-state-highlight">' . htmlspecialchars($db->getError()) . '</div>' . '</div>';
}
} else {
displayIndexesForm($db, $editor);
}
}
/**
* This file is a part of MyWebSQL package
*
* @file: modules/enginetype.php
* @author Samnan ur Rehman
* @copyright (c) 2008-2014 Samnan ur Rehman
* @web http://mywebsql.net
* @license http://mywebsql.net/license
*/
function processRequest(&$db)
{
$action = v($_REQUEST["id"]);
include BASE_PATH . "/lib/tableeditor.php";
$editor = new tableEditor($db);
$editor->setName(v($_REQUEST["name"]));
$editor->loadTable(false, false, true);
$message = '';
if ($action == "alter") {
$result = alterTableEngine($db, v($_REQUEST["enginetype"]), $editor);
$formatted_query = preg_replace("/[\\n|\\r]?[\\n]+/", "<br>", htmlspecialchars($editor->getSql()));
if ($result) {
$message = '<div id="message">' . '<div class="message ui-state-default">' . __('The command executed successfully') . '.</div>' . '</div>';
} else {
$message = '<div id="message">' . '<div class="message ui-state-error">' . __('Error occurred while executing the query') . ':</div>' . '<div class="message ui-state-highlight">' . htmlspecialchars($db->getError()) . '</div>' . '<div class="sql-text ui-state-error">' . $formatted_query . '</div>' . '</div>';
}
}
$props = $editor->getProperties();
include BASE_PATH . '/lib/html.php';
$engines = html::arrayToOptions($db->getEngines(), $props->engine, true);
$replace = array('TABLE_NAME' => htmlspecialchars($editor->getName()), 'ENGINE' => $engines, 'MESSAGE' => $message);
echo view('enginetype', $replace);
}