/**
* Execute mySQL code
*
* This function is used to execute an arbitrary SQL query
* <br>Example:
* <code>
* $result = eF_execute('SELECT * FROM users WHERE id = 1');
* </code>
*
* @param string $sql the SQL query
* @return mixed The result, formed in a MySQL resource
* @version 1.0
* @deprecated
*/
function eF_executeNew($sql)
{
$thisQuery = microtime(true);
$result = $GLOBALS['db']->Execute($sql);
if (!$result && G_DEBUG) {
eF_printMessage(_PROBLEMQUERYINGDATABASE . ": '" . $sql . "'<br> " . $GLOBALS['db']->ErrorMsg());
}
logProcess($thisQuery, $sql);
return $result;
}
$smarty->assign("T_CREATEFOLDER_MESSAGE_TYPE", 'failure');
}
}
$smarty->assign("T_DIRECTORY", $dir);
} else {
if (isset($_GET['files'])) {
$image_files = explode(";", str_replace('\\\\', '\\', urldecode($_GET['files'])));
for ($i = 0; $i < sizeof($image_files); $i++) {
$copy_string[$i] = '<input type ="text" value="' . $image_files[$i] . '" size="40"/> » ';
}
$message = _COPYNAMESFROMLEFTTORIGHTTOSAVEIMAGES;
}
isset($image_files) ? $size = sizeof($image_files) : ($size = 10);
if (isset($_POST['submit'])) {
if (!eF_checkParameter($_POST['to_dir'], 'directory')) {
eF_printMessage(_INVALIDNAME);
exit;
}
if ($_SESSION['s_type'] == "professor") {
$target_dir = G_LESSONSPATH . $_POST['to_dir'];
} elseif ($_SESSION['s_type'] == "administrator") {
$target_dir = G_ADMINPATH . $_POST['to_dir'];
}
list($ok, $upload_messages, $upload_messages_type, $filename) = eF_handleUploads('fileupload', $target_dir);
$smarty->assign("T_UPLOAD_MESSAGES", $upload_messages);
$smarty->assign("T_UPLOAD_MESSAGES_TYPE", $upload_messages_type);
}
$smarty->assign("T_MESSAGE", $message);
$smarty->assign("T_DIRECTORY", $dir);
$smarty->assign("T_FILES", $files);
$smarty->assign("T_LESSONS_ID", $_SESSION['s_lessons_ID']);
