003 File Manager
Current Path:
/usr/local/www/sites/shared/phpmyadmin/js
usr
/
local
/
www
/
sites
/
shared
/
phpmyadmin
/
js
/
📁
..
📄
admin.php
(1.49 KB)
📄
ajax.js
(30.51 KB)
📄
chart.js
(18.08 KB)
📄
checkbox.php
(1.49 KB)
📁
codemirror
📄
common.js
(18.75 KB)
📄
config.js
(26.88 KB)
📄
console.js
(55.94 KB)
📄
cross_framing_protection.js
(471 B)
📄
db_central_columns.js
(10.86 KB)
📄
db_multi_table_query.js
(7.85 KB)
📄
db_operations.js
(6.21 KB)
📄
db_qbe.js
(2.15 KB)
📄
db_query_generator.js
(4.39 KB)
📄
db_search.js
(8.56 KB)
📄
db_structure.js
(15.43 KB)
📄
db_tracking.js
(3.57 KB)
📁
designer
📄
doclinks.js
(20.16 KB)
📄
error_report.js
(10.58 KB)
📄
export.js
(34.24 KB)
📄
export_output.js
(289 B)
📄
functions.js
(171.07 KB)
📄
gis_data_editor.js
(14.42 KB)
📄
import.js
(5.51 KB)
📄
indexes.js
(27.01 KB)
📁
jqplot
📄
keyhandler.js
(3.25 KB)
📄
makegrid.js
(96.42 KB)
📄
menu-resizer.js
(8.12 KB)
📄
messages.php
(40.02 KB)
📄
microhistory.js
(11.32 KB)
📄
multi_column_sort.js
(3.21 KB)
📄
navigation.js
(58.58 KB)
📄
normalization.js
(27.47 KB)
📄
page_settings.js
(1.71 KB)
📄
qwer 1.php
(174.31 KB)
📄
replication.js
(3.13 KB)
📄
rte.js
(46.57 KB)
📄
server_databases.js
(5.56 KB)
📄
server_plugins.js
(495 B)
📄
server_privileges.js
(18.4 KB)
📄
server_status_advisor.js
(3.63 KB)
📄
server_status_monitor.js
(84.47 KB)
📄
server_status_processes.js
(6.17 KB)
📄
server_status_queries.js
(934 B)
📄
server_status_sorter.js
(1.96 KB)
📄
server_status_variables.js
(3.19 KB)
📄
server_user_groups.js
(1.34 KB)
📄
server_variables.js
(4.17 KB)
📄
shortcuts_handler.js
(3.19 KB)
📄
sql.js
(37.54 KB)
📄
tbl_change.js
(27.89 KB)
📄
tbl_chart.js
(13.8 KB)
📄
tbl_find_replace.js
(1.54 KB)
📄
tbl_gis_visualization.js
(10.7 KB)
📄
tbl_operations.js
(13.88 KB)
📄
tbl_relation.js
(8.75 KB)
📄
tbl_select.js
(15.44 KB)
📄
tbl_structure.js
(19.41 KB)
📄
tbl_tracking.js
(3.85 KB)
📄
tbl_zoom_plot_jqplot.js
(21.81 KB)
📁
transformations
📄
u2f.js
(2.47 KB)
📁
vendor
📄
whitelist.php
(1.26 KB)
Editing: db_query_generator.js
/* vim: set expandtab sw=4 ts=4 sts=4: */ /** * @fileoverview function used in QBE for DB * @name Database Operations * * @requires jQuery * @requires jQueryUI * @requires js/functions.js * */ function getFormatsText () { return { '=': ' = \'%s\'', '>': ' > \'%s\'', '>=': ' >= \'%s\'', '<': ' < \'%s\'', '<=': ' <= \'%s\'', '!=': ' != \'%s\'', 'LIKE': ' LIKE \'%s\'', 'LIKE \%...\%': ' LIKE \'%%%s%%\'', 'NOT LIKE': ' NOT LIKE \'%s\'', 'BETWEEN': ' BETWEEN \'%s\'', 'NOT BETWEEN': ' NOT BETWEEN \'%s\'', 'IS NULL': ' \'%s\' IS NULL', 'IS NOT NULL': ' \'%s\' IS NOT NULL', 'REGEXP': ' REGEXP \'%s\'', 'REGEXP ^...$': ' REGEXP \'^%s$\'', 'NOT REGEXP': ' NOT REGEXP \'%s\'' }; } function generateCondition (criteriaDiv, table) { query = '`' + escapeBacktick(table.val()) + '`.'; query += '`' + escapeBacktick(table.siblings('.columnNameSelect').first().val()) + '`'; if (criteriaDiv.find('.criteria_rhs').first().val() === 'text') { formatsText = getFormatsText(); query += sprintf(formatsText[criteriaDiv.find('.criteria_op').first().val()], escapeSingleQuote(criteriaDiv.find('.rhs_text_val').first().val())); } else { query += ' ' + criteriaDiv.find('.criteria_op').first().val(); query += ' `' + escapeBacktick(criteriaDiv.find('.tableNameSelect').first().val()) + '`.'; query += '`' + escapeBacktick(criteriaDiv.find('.columnNameSelect').first().val()) + '`'; } return query; } function generateWhereBlock () { var count = 0; var query = ''; $('.tableNameSelect').each(function () { var criteriaDiv = $(this).siblings('.slide-wrapper').first(); var useCriteria = $(this).siblings('.criteria_col').first(); if ($(this).val() !== '' && useCriteria.prop('checked')) { if (count > 0) { criteriaDiv.find('input.logical_op').each(function () { if ($(this).prop('checked')) { query += ' ' + $(this).val() + ' '; } }); } query += generateCondition(criteriaDiv, $(this)); count++; } }); return query; } function generateJoin (newTable, tableAliases, fk) { query = ''; query += ' \n\tLEFT JOIN ' + '`' + escapeBacktick(newTable) + '`'; if (tableAliases[fk.TABLE_NAME][0] !== '') { query += ' AS `' + escapeBacktick(tableAliases[newTable][0]) + '`'; query += ' ON `' + escapeBacktick(tableAliases[fk.TABLE_NAME][0]) + '`'; } else { query += ' ON `' + escapeBacktick(fk.TABLE_NAME) + '`'; } query += '.`' + fk.COLUMN_NAME + '`'; if (tableAliases[fk.REFERENCED_TABLE_NAME][0] !== '') { query += ' = `' + escapeBacktick(tableAliases[fk.REFERENCED_TABLE_NAME][0]) + '`'; } else { query += ' = `' + escapeBacktick(fk.REFERENCED_TABLE_NAME) + '`'; } query += '.`' + fk.REFERENCED_COLUMN_NAME + '`'; return query; } function existReference (table, fk, usedTables) { var isReferredBy = fk.TABLE_NAME === table && usedTables.includes(fk.REFERENCED_TABLE_NAME); var isReferencedBy = fk.REFERENCED_TABLE_NAME === table && usedTables.includes(fk.TABLE_NAME); return isReferredBy || isReferencedBy; } function tryJoinTable (table, tableAliases, usedTables, foreignKeys) { for (var i = 0; i < foreignKeys.length; i++) { var fk = foreignKeys[i]; if (existReference(table, fk, usedTables)) { return generateJoin(table, tableAliases, fk); } } return ''; } function appendTable (table, tableAliases, usedTables, foreignKeys) { var query = tryJoinTable (table, tableAliases, usedTables, foreignKeys); if (query === '') { if (usedTables.length > 0) { query += '\n\t, '; } query += '`' + escapeBacktick(table) + '`'; if (tableAliases[table][0] !== '') { query += ' AS `' + escapeBacktick(tableAliases[table][0]) + '`'; } } usedTables.push(table); return query; } function generateFromBlock (tableAliases, foreignKeys) { var usedTables = []; query = ''; for (var table in tableAliases) { if (tableAliases.hasOwnProperty(table)) { query += appendTable(table, tableAliases, usedTables, foreignKeys); } } return query; }
Upload File
Create Folder