diff options
| author | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
|---|---|---|
| committer | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
| commit | 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch) | |
| tree | 39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/db_qbe.php | |
| parent | 5afd237bbd22028b85532b8c0b3fcead49a00764 (diff) | |
| download | ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.gz ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.bz2 ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.zip | |
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/db_qbe.php')
| -rw-r--r-- | srcs/phpmyadmin/db_qbe.php | 192 |
1 files changed, 0 insertions, 192 deletions
diff --git a/srcs/phpmyadmin/db_qbe.php b/srcs/phpmyadmin/db_qbe.php deleted file mode 100644 index 0ebae09..0000000 --- a/srcs/phpmyadmin/db_qbe.php +++ /dev/null @@ -1,192 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * query by example the whole database - * - * @package PhpMyAdmin - */ -declare(strict_types=1); - -use PhpMyAdmin\Database\Qbe; -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Message; -use PhpMyAdmin\Relation; -use PhpMyAdmin\Response; -use PhpMyAdmin\SavedSearches; -use PhpMyAdmin\Sql; -use PhpMyAdmin\Template; -use PhpMyAdmin\Url; -use PhpMyAdmin\Util; - -if (! defined('ROOT_PATH')) { - define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR); -} - -global $db, $pmaThemeImage, $url_query; - -require_once ROOT_PATH . 'libraries/common.inc.php'; - -/** @var Response $response */ -$response = $containerBuilder->get(Response::class); - -/** @var DatabaseInterface $dbi */ -$dbi = $containerBuilder->get(DatabaseInterface::class); - -/** @var Relation $relation */ -$relation = $containerBuilder->get('relation'); -/** @var Template $template */ -$template = $containerBuilder->get('template'); - -// Gets the relation settings -$cfgRelation = $relation->getRelationsParam(); - -$savedSearchList = []; -$savedSearch = null; -$currentSearchId = null; -if ($cfgRelation['savedsearcheswork']) { - $header = $response->getHeader(); - $scripts = $header->getScripts(); - $scripts->addFile('database/qbe.js'); - - //Get saved search list. - $savedSearch = new SavedSearches($GLOBALS, $relation); - $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) - ->setDbname($db); - - if (! empty($_POST['searchId'])) { - $savedSearch->setId($_POST['searchId']); - } - - //Action field is sent. - if (isset($_POST['action'])) { - $savedSearch->setSearchName($_POST['searchName']); - if ('create' === $_POST['action']) { - $saveResult = $savedSearch->setId(null) - ->setCriterias($_POST) - ->save(); - } elseif ('update' === $_POST['action']) { - $saveResult = $savedSearch->setCriterias($_POST) - ->save(); - } elseif ('delete' === $_POST['action']) { - $deleteResult = $savedSearch->delete(); - //After deletion, reset search. - $savedSearch = new SavedSearches($GLOBALS, $relation); - $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) - ->setDbname($db); - $_POST = []; - } elseif ('load' === $_POST['action']) { - if (empty($_POST['searchId'])) { - //when not loading a search, reset the object. - $savedSearch = new SavedSearches($GLOBALS, $relation); - $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) - ->setDbname($db); - $_POST = []; - } else { - $loadResult = $savedSearch->load(); - } - } - //Else, it's an "update query" - } - - $savedSearchList = $savedSearch->getList(); - $currentSearchId = $savedSearch->getId(); -} - -/** - * A query has been submitted -> (maybe) execute it - */ -$message_to_display = false; -if (isset($_POST['submit_sql']) && ! empty($sql_query)) { - if (0 !== stripos($sql_query, "SELECT")) { - $message_to_display = true; - } else { - $goto = 'db_sql.php'; - $sql = new Sql(); - $sql->executeQueryAndSendQueryResponse( - null, // analyzed_sql_results - false, // is_gotofile - $_POST['db'], // db - null, // table - false, // find_real_end - null, // sql_query_for_bookmark - null, // extra_data - null, // message_to_show - null, // message - null, // sql_data - $goto, // goto - $pmaThemeImage, // pmaThemeImage - null, // disp_query - null, // disp_message - null, // query_type - $sql_query, // sql_query - null, // selectedTables - null // complete_query - ); - } -} - -$sub_part = '_qbe'; -require ROOT_PATH . 'libraries/db_common.inc.php'; -$url_query .= '&goto=db_qbe.php'; -$url_params['goto'] = 'db_qbe.php'; - -list( - $tables, - $num_tables, - $total_num_tables, - $sub_part, - $is_show_stats, - $db_is_system_schema, - $tooltip_truename, - $tooltip_aliasname, - $pos -) = Util::getDbInfo($db, $sub_part === null ? '' : $sub_part); - -if ($message_to_display) { - Message::error( - __('You have to choose at least one column to display!') - ) - ->display(); -} -unset($message_to_display); - -// create new qbe search instance -$db_qbe = new Qbe($relation, $template, $dbi, $db, $savedSearchList, $savedSearch); - -$secondaryTabs = [ - 'multi' => [ - 'link' => 'db_multi_table_query.php', - 'text' => __('Multi-table query'), - ], - 'qbe' => [ - 'link' => 'db_qbe.php', - 'text' => __('Query by example'), - ], -]; -$response->addHTML( - $template->render('secondary_tabs', [ - 'url_params' => $url_params, - 'sub_tabs' => $secondaryTabs, - ]) -); - -$url = 'db_designer.php' . Url::getCommon( - array_merge( - $url_params, - ['query' => 1] - ) -); -$response->addHTML( - Message::notice( - sprintf( - __('Switch to %svisual builder%s'), - '<a href="' . $url . '">', - '</a>' - ) - ) -); - -/** - * Displays the Query by example form - */ -$response->addHTML($db_qbe->getSelectionForm()); |
