From 91b592e1751beb9705470a6f77d9ea70cb56deda Mon Sep 17 00:00:00 2001
From: Jehan-Guillaume <jgdr@dalibo.com>
Date: Thu, 12 Feb 2015 12:38:57 +0100
Subject: [PATCH] Add file upload capability to SQL popup window

This feature was accessible only from the main SQL page, but not from
the popup when upsing the top SQL link.
---
 database.php |  4 ++--
 sqledit.php  | 15 +++++++++++++--
 2 files changed, 15 insertions(+), 4 deletions(-)

diff --git a/database.php b/database.php
index db45594f..cdd53c60 100755
--- a/database.php
+++ b/database.php
@@ -599,9 +599,9 @@
 		}
 
 		echo "<p><input type=\"checkbox\" id=\"paginate\" name=\"paginate\"", (isset($_REQUEST['paginate']) ? ' checked="checked"' : ''), " /><label for=\"paginate\">{$lang['strpaginate']}</label></p>\n";
-		echo "<p><input type=\"submit\" name=\"execute\" value=\"{$lang['strexecute']}\" />\n";
+		echo "<p><input type=\"submit\" name=\"execute\" accesskey=\"r\" value=\"{$lang['strexecute']}\" />\n";
 		echo $misc->form;
-		echo "<input type=\"reset\" value=\"{$lang['strreset']}\" /></p>\n";
+		echo "<input type=\"reset\" accesskey=\"q\" value=\"{$lang['strreset']}\" /></p>\n";
 		echo "</form>\n";
 
 		// Default focus
diff --git a/sqledit.php b/sqledit.php
index ac244821..124371d2 100644
--- a/sqledit.php
+++ b/sqledit.php
@@ -104,7 +104,7 @@
 		
 		$misc->printTabs($misc->getNavTabs('popup'), 'sql');
 		
-		echo "<form action=\"sql.php\" method=\"post\" target=\"detail\">\n";
+		echo "<form action=\"sql.php\" method=\"post\" enctype=\"multipart/form-data\" target=\"detail\">\n";
 		_printConnection();
 		echo "\n";
 		if (!isset($_REQUEST['search_path']))
@@ -117,9 +117,20 @@
 		
 		echo "<textarea style=\"width:98%;\" rows=\"10\" cols=\"50\" name=\"query\">",
 			htmlspecialchars($_SESSION['sqlquery']), "</textarea>\n";
+
+		// Check that file uploads are enabled
+		if (ini_get('file_uploads')) {
+			// Don't show upload option if max size of uploads is zero
+			$max_size = $misc->inisizeToBytes(ini_get('upload_max_filesize'));
+			if (is_double($max_size) && $max_size > 0) {
+				echo "<p><input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"{$max_size}\" />\n";
+				echo "<label for=\"script\">{$lang['struploadscript']}</label> <input id=\"script\" name=\"script\" type=\"file\" /></p>\n";
+			}
+		}
+
 		echo "<p><label for=\"paginate\"><input type=\"checkbox\" id=\"paginate\" name=\"paginate\"", (isset($_REQUEST['paginate']) ? ' checked="checked"' : ''), " />&nbsp;{$lang['strpaginate']}</label></p>\n";
 		
-		echo "<p><input type=\"submit\" accesskey=\"r\" value=\"{$lang['strexecute']}\" />\n";
+		echo "<p><input type=\"submit\" name=\"execute\" accesskey=\"r\" value=\"{$lang['strexecute']}\" />\n";
 		echo "<input type=\"reset\" accesskey=\"q\" value=\"{$lang['strreset']}\" /></p>\n";
 		echo "</form>\n";
 		
-- 
2.39.5