rte_events.lib.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637
  1. <?php
  2. /* vim: set expandtab sw=4 ts=4 sts=4: */
  3. /**
  4. * Functions for event management.
  5. *
  6. * @package PhpMyAdmin
  7. */
  8. if (! defined('PHPMYADMIN')) {
  9. exit;
  10. }
  11. /**
  12. * Sets required globals
  13. *
  14. * @return void
  15. */
  16. function PMA_EVN_setGlobals()
  17. {
  18. global $event_status, $event_type, $event_interval;
  19. $event_status = array(
  20. 'query' => array('ENABLE',
  21. 'DISABLE',
  22. 'DISABLE ON SLAVE'),
  23. 'display' => array('ENABLED',
  24. 'DISABLED',
  25. 'SLAVESIDE_DISABLED')
  26. );
  27. $event_type = array('RECURRING',
  28. 'ONE TIME');
  29. $event_interval = array('YEAR',
  30. 'QUARTER',
  31. 'MONTH',
  32. 'DAY',
  33. 'HOUR',
  34. 'MINUTE',
  35. 'WEEK',
  36. 'SECOND',
  37. 'YEAR_MONTH',
  38. 'DAY_HOUR',
  39. 'DAY_MINUTE',
  40. 'DAY_SECOND',
  41. 'HOUR_MINUTE',
  42. 'HOUR_SECOND',
  43. 'MINUTE_SECOND');
  44. }
  45. /**
  46. * Main function for the events functionality
  47. *
  48. * @return void
  49. */
  50. function PMA_EVN_main()
  51. {
  52. global $db;
  53. PMA_EVN_setGlobals();
  54. /**
  55. * Process all requests
  56. */
  57. PMA_EVN_handleEditor();
  58. PMA_EVN_handleExport();
  59. /**
  60. * Display a list of available events
  61. */
  62. $columns = "`EVENT_NAME`, `EVENT_TYPE`, `STATUS`";
  63. $where = "EVENT_SCHEMA='" . PMA_Util::sqlAddSlashes($db) . "'";
  64. $query = "SELECT $columns FROM `INFORMATION_SCHEMA`.`EVENTS` "
  65. . "WHERE $where ORDER BY `EVENT_NAME` ASC;";
  66. $items = PMA_DBI_fetch_result($query);
  67. echo PMA_RTE_getList('event', $items);
  68. /**
  69. * Display a link for adding a new event, if
  70. * the user has the privileges and a link to
  71. * toggle the state of the event scheduler.
  72. */
  73. echo PMA_EVN_getFooterLinks();
  74. } // end PMA_EVN_main()
  75. /**
  76. * Handles editor requests for adding or editing an item
  77. *
  78. * @return void
  79. */
  80. function PMA_EVN_handleEditor()
  81. {
  82. global $_REQUEST, $_POST, $errors, $db;
  83. if (! empty($_REQUEST['editor_process_add'])
  84. || ! empty($_REQUEST['editor_process_edit'])
  85. ) {
  86. $sql_query = '';
  87. $item_query = PMA_EVN_getQueryFromRequest();
  88. if (! count($errors)) { // set by PMA_RTN_getQueryFromRequest()
  89. // Execute the created query
  90. if (! empty($_REQUEST['editor_process_edit'])) {
  91. // Backup the old trigger, in case something goes wrong
  92. $create_item = PMA_DBI_get_definition(
  93. $db,
  94. 'EVENT',
  95. $_REQUEST['item_original_name']
  96. );
  97. $drop_item = "DROP EVENT "
  98. . PMA_Util::backquote($_REQUEST['item_original_name']) . ";\n";
  99. $result = PMA_DBI_try_query($drop_item);
  100. if (! $result) {
  101. $errors[] = sprintf(
  102. __('The following query has failed: "%s"'),
  103. htmlspecialchars($drop_item)
  104. )
  105. . '<br />'
  106. . __('MySQL said: ') . PMA_DBI_getError(null);
  107. } else {
  108. $result = PMA_DBI_try_query($item_query);
  109. if (! $result) {
  110. $errors[] = sprintf(
  111. __('The following query has failed: "%s"'),
  112. htmlspecialchars($item_query)
  113. )
  114. . '<br />'
  115. . __('MySQL said: ') . PMA_DBI_getError(null);
  116. // We dropped the old item, but were unable to create
  117. // the new one. Try to restore the backup query
  118. $result = PMA_DBI_try_query($create_item);
  119. if (! $result) {
  120. // OMG, this is really bad! We dropped the query,
  121. // failed to create a new one
  122. // and now even the backup query does not execute!
  123. // This should not happen, but we better handle
  124. // this just in case.
  125. $errors[] = __(
  126. 'Sorry, we failed to restore the dropped event.'
  127. )
  128. . '<br />'
  129. . __('The backed up query was:')
  130. . "\"" . htmlspecialchars($create_item) . "\""
  131. . '<br />'
  132. . __('MySQL said: ') . PMA_DBI_getError(null);
  133. }
  134. } else {
  135. $message = PMA_Message::success(
  136. __('Event %1$s has been modified.')
  137. );
  138. $message->addParam(
  139. PMA_Util::backquote($_REQUEST['item_name'])
  140. );
  141. $sql_query = $drop_item . $item_query;
  142. }
  143. }
  144. } else {
  145. // 'Add a new item' mode
  146. $result = PMA_DBI_try_query($item_query);
  147. if (! $result) {
  148. $errors[] = sprintf(
  149. __('The following query has failed: "%s"'),
  150. htmlspecialchars($item_query)
  151. )
  152. . '<br /><br />'
  153. . __('MySQL said: ') . PMA_DBI_getError(null);
  154. } else {
  155. $message = PMA_Message::success(
  156. __('Event %1$s has been created.')
  157. );
  158. $message->addParam(
  159. PMA_Util::backquote($_REQUEST['item_name'])
  160. );
  161. $sql_query = $item_query;
  162. }
  163. }
  164. }
  165. if (count($errors)) {
  166. $message = PMA_Message::error(__('<b>One or more errors have occured while processing your request:</b>'));
  167. $message->addString('<ul>');
  168. foreach ($errors as $string) {
  169. $message->addString('<li>' . $string . '</li>');
  170. }
  171. $message->addString('</ul>');
  172. }
  173. $output = PMA_Util::getMessage($message, $sql_query);
  174. if ($GLOBALS['is_ajax_request']) {
  175. $response = PMA_Response::getInstance();
  176. if ($message->isSuccess()) {
  177. $columns = "`EVENT_NAME`, `EVENT_TYPE`, `STATUS`";
  178. $where = "EVENT_SCHEMA='" . PMA_Util::sqlAddSlashes($db) . "' "
  179. . "AND EVENT_NAME='"
  180. . PMA_Util::sqlAddSlashes($_REQUEST['item_name']) . "'";
  181. $query = "SELECT " . $columns
  182. . " FROM `INFORMATION_SCHEMA`.`EVENTS` WHERE " . $where. ";";
  183. $event = PMA_DBI_fetch_single_row($query);
  184. $response->addJSON(
  185. 'name',
  186. htmlspecialchars(strtoupper($_REQUEST['item_name']))
  187. );
  188. $response->addJSON('new_row', PMA_EVN_getRowForList($event));
  189. $response->addJSON('insert', ! empty($event));
  190. $response->addJSON('message', $output);
  191. } else {
  192. $response->isSuccess(false);
  193. $response->addJSON('message', $message);
  194. }
  195. exit;
  196. }
  197. }
  198. /**
  199. * Display a form used to add/edit a trigger, if necessary
  200. */
  201. if (count($errors)
  202. || (empty($_REQUEST['editor_process_add'])
  203. && empty($_REQUEST['editor_process_edit'])
  204. && (! empty($_REQUEST['add_item'])
  205. || ! empty($_REQUEST['edit_item'])
  206. || ! empty($_REQUEST['item_changetype'])))
  207. ) { // FIXME: this must be simpler than that
  208. $operation = '';
  209. if (! empty($_REQUEST['item_changetype'])) {
  210. $operation = 'change';
  211. }
  212. // Get the data for the form (if any)
  213. if (! empty($_REQUEST['add_item'])) {
  214. $title = PMA_RTE_getWord('add');
  215. $item = PMA_EVN_getDataFromRequest();
  216. $mode = 'add';
  217. } else if (! empty($_REQUEST['edit_item'])) {
  218. $title = __("Edit event");
  219. if (! empty($_REQUEST['item_name'])
  220. && empty($_REQUEST['editor_process_edit'])
  221. && empty($_REQUEST['item_changetype'])
  222. ) {
  223. $item = PMA_EVN_getDataFromName($_REQUEST['item_name']);
  224. if ($item !== false) {
  225. $item['item_original_name'] = $item['item_name'];
  226. }
  227. } else {
  228. $item = PMA_EVN_getDataFromRequest();
  229. }
  230. $mode = 'edit';
  231. }
  232. if ($item !== false) {
  233. // Show form
  234. $editor = PMA_EVN_getEditorForm($mode, $operation, $item);
  235. if ($GLOBALS['is_ajax_request']) {
  236. $response = PMA_Response::getInstance();
  237. $response->addJSON('message', $editor);
  238. $response->addJSON('title', $title);
  239. } else {
  240. echo "\n\n<h2>$title</h2>\n\n$editor";
  241. unset($_POST);
  242. }
  243. exit;
  244. } else {
  245. $message = __('Error in processing request') . ' : ';
  246. $message .= sprintf(
  247. PMA_RTE_getWord('not_found'),
  248. htmlspecialchars(PMA_Util::backquote($_REQUEST['item_name'])),
  249. htmlspecialchars(PMA_Util::backquote($db))
  250. );
  251. $message = PMA_message::error($message);
  252. if ($GLOBALS['is_ajax_request']) {
  253. $response = PMA_Response::getInstance();
  254. $response->isSuccess(false);
  255. $response->addJSON('message', $message);
  256. exit;
  257. } else {
  258. $message->display();
  259. }
  260. }
  261. }
  262. } // end PMA_EVN_handleEditor()
  263. /**
  264. * This function will generate the values that are required to for the editor
  265. *
  266. * @return array Data necessary to create the editor.
  267. */
  268. function PMA_EVN_getDataFromRequest()
  269. {
  270. $retval = array();
  271. $indices = array('item_name',
  272. 'item_original_name',
  273. 'item_status',
  274. 'item_execute_at',
  275. 'item_interval_value',
  276. 'item_interval_field',
  277. 'item_starts',
  278. 'item_ends',
  279. 'item_definition',
  280. 'item_preserve',
  281. 'item_comment',
  282. 'item_definer');
  283. foreach ($indices as $index) {
  284. $retval[$index] = isset($_REQUEST[$index]) ? $_REQUEST[$index] : '';
  285. }
  286. $retval['item_type'] = 'ONE TIME';
  287. $retval['item_type_toggle'] = 'RECURRING';
  288. if (isset($_REQUEST['item_type']) && $_REQUEST['item_type'] == 'RECURRING') {
  289. $retval['item_type'] = 'RECURRING';
  290. $retval['item_type_toggle'] = 'ONE TIME';
  291. }
  292. return $retval;
  293. } // end PMA_EVN_getDataFromRequest()
  294. /**
  295. * This function will generate the values that are required to complete
  296. * the "Edit event" form given the name of a event.
  297. *
  298. * @param string $name The name of the event.
  299. *
  300. * @return array Data necessary to create the editor.
  301. */
  302. function PMA_EVN_getDataFromName($name)
  303. {
  304. global $db;
  305. $retval = array();
  306. $columns = "`EVENT_NAME`, `STATUS`, `EVENT_TYPE`, `EXECUTE_AT`, "
  307. . "`INTERVAL_VALUE`, `INTERVAL_FIELD`, `STARTS`, `ENDS`, "
  308. . "`EVENT_DEFINITION`, `ON_COMPLETION`, `DEFINER`, `EVENT_COMMENT`";
  309. $where = "EVENT_SCHEMA='" . PMA_Util::sqlAddSlashes($db) . "' "
  310. . "AND EVENT_NAME='" . PMA_Util::sqlAddSlashes($name) . "'";
  311. $query = "SELECT $columns FROM `INFORMATION_SCHEMA`.`EVENTS` WHERE $where;";
  312. $item = PMA_DBI_fetch_single_row($query);
  313. if (! $item) {
  314. return false;
  315. }
  316. $retval['item_name'] = $item['EVENT_NAME'];
  317. $retval['item_status'] = $item['STATUS'];
  318. $retval['item_type'] = $item['EVENT_TYPE'];
  319. if ($retval['item_type'] == 'RECURRING') {
  320. $retval['item_type_toggle'] = 'ONE TIME';
  321. } else {
  322. $retval['item_type_toggle'] = 'RECURRING';
  323. }
  324. $retval['item_execute_at'] = $item['EXECUTE_AT'];
  325. $retval['item_interval_value'] = $item['INTERVAL_VALUE'];
  326. $retval['item_interval_field'] = $item['INTERVAL_FIELD'];
  327. $retval['item_starts'] = $item['STARTS'];
  328. $retval['item_ends'] = $item['ENDS'];
  329. $retval['item_preserve'] = '';
  330. if ($item['ON_COMPLETION'] == 'PRESERVE') {
  331. $retval['item_preserve'] = " checked='checked'";
  332. }
  333. $retval['item_definition'] = $item['EVENT_DEFINITION'];
  334. $retval['item_definer'] = $item['DEFINER'];
  335. $retval['item_comment'] = $item['EVENT_COMMENT'];
  336. return $retval;
  337. } // end PMA_EVN_getDataFromName()
  338. /**
  339. * Displays a form used to add/edit an event
  340. *
  341. * @param string $mode If the editor will be used edit an event
  342. * or add a new one: 'edit' or 'add'.
  343. * @param string $operation If the editor was previously invoked with
  344. * JS turned off, this will hold the name of
  345. * the current operation
  346. * @param array $item Data for the event returned by
  347. * PMA_EVN_getDataFromRequest() or
  348. * PMA_EVN_getDataFromName()
  349. *
  350. * @return string HTML code for the editor.
  351. */
  352. function PMA_EVN_getEditorForm($mode, $operation, $item)
  353. {
  354. global $db, $table, $event_status, $event_type, $event_interval;
  355. // Escape special characters
  356. $need_escape = array(
  357. 'item_original_name',
  358. 'item_name',
  359. 'item_type',
  360. 'item_execute_at',
  361. 'item_interval_value',
  362. 'item_starts',
  363. 'item_ends',
  364. 'item_definition',
  365. 'item_definer',
  366. 'item_comment'
  367. );
  368. foreach ($need_escape as $index) {
  369. $item[$index] = htmlentities($item[$index], ENT_QUOTES);
  370. }
  371. $original_data = '';
  372. if ($mode == 'edit') {
  373. $original_data = "<input name='item_original_name' "
  374. . "type='hidden' value='{$item['item_original_name']}'/>\n";
  375. }
  376. // Handle some logic first
  377. if ($operation == 'change') {
  378. if ($item['item_type'] == 'RECURRING') {
  379. $item['item_type'] = 'ONE TIME';
  380. $item['item_type_toggle'] = 'RECURRING';
  381. } else {
  382. $item['item_type'] = 'RECURRING';
  383. $item['item_type_toggle'] = 'ONE TIME';
  384. }
  385. }
  386. if ($item['item_type'] == 'ONE TIME') {
  387. $isrecurring_class = ' hide';
  388. $isonetime_class = '';
  389. } else {
  390. $isrecurring_class = '';
  391. $isonetime_class = ' hide';
  392. }
  393. // Create the output
  394. $retval = "";
  395. $retval .= "<!-- START " . strtoupper($mode) . " EVENT FORM -->\n\n";
  396. $retval .= "<form class='rte_form' action='db_events.php' method='post'>\n";
  397. $retval .= "<input name='{$mode}_item' type='hidden' value='1' />\n";
  398. $retval .= $original_data;
  399. $retval .= PMA_generate_common_hidden_inputs($db, $table) . "\n";
  400. $retval .= "<fieldset>\n";
  401. $retval .= "<legend>" . __('Details') . "</legend>\n";
  402. $retval .= "<table class='rte_table' style='width: 100%'>\n";
  403. $retval .= "<tr>\n";
  404. $retval .= " <td style='width: 20%;'>" . __('Event name') . "</td>\n";
  405. $retval .= " <td><input type='text' name='item_name' \n";
  406. $retval .= " value='{$item['item_name']}'\n";
  407. $retval .= " maxlength='64' /></td>\n";
  408. $retval .= "</tr>\n";
  409. $retval .= "<tr>\n";
  410. $retval .= " <td>" . __('Status') . "</td>\n";
  411. $retval .= " <td>\n";
  412. $retval .= " <select name='item_status'>\n";
  413. foreach ($event_status['display'] as $key => $value) {
  414. $selected = "";
  415. if (! empty($item['item_status']) && $item['item_status'] == $value) {
  416. $selected = " selected='selected'";
  417. }
  418. $retval .= "<option$selected>$value</option>";
  419. }
  420. $retval .= " </select>\n";
  421. $retval .= " </td>\n";
  422. $retval .= "</tr>\n";
  423. $retval .= "<tr>\n";
  424. $retval .= " <td>" . __('Event type') . "</td>\n";
  425. $retval .= " <td>\n";
  426. if ($GLOBALS['is_ajax_request']) {
  427. $retval .= " <select name='item_type'>";
  428. foreach ($event_type as $key => $value) {
  429. $selected = "";
  430. if (! empty($item['item_type']) && $item['item_type'] == $value) {
  431. $selected = " selected='selected'";
  432. }
  433. $retval .= "<option$selected>$value</option>";
  434. }
  435. $retval .= " </select>\n";
  436. } else {
  437. $retval .= " <input name='item_type' type='hidden' \n";
  438. $retval .= " value='{$item['item_type']}' />\n";
  439. $retval .= " <div style='width: 49%; float: left; text-align: center;"
  440. . " font-weight: bold;'>\n";
  441. $retval .= " {$item['item_type']}\n";
  442. $retval .= " </div>\n";
  443. $retval .= " <input style='width: 49%;' type='submit'\n";
  444. $retval .= " name='item_changetype'\n";
  445. $retval .= " value='";
  446. $retval .= sprintf(__('Change to %s'), $item['item_type_toggle']);
  447. $retval .= "' />\n";
  448. }
  449. $retval .= " </td>\n";
  450. $retval .= "</tr>\n";
  451. $retval .= "<tr class='onetime_event_row $isonetime_class'>\n";
  452. $retval .= " <td>" . __('Execute at') . "</td>\n";
  453. $retval .= " <td class='nowrap'>\n";
  454. $retval .= " <input type='text' name='item_execute_at'\n";
  455. $retval .= " value='{$item['item_execute_at']}'\n";
  456. $retval .= " class='datetimefield' />\n";
  457. $retval .= " </td>\n";
  458. $retval .= "</tr>\n";
  459. $retval .= "<tr class='recurring_event_row $isrecurring_class'>\n";
  460. $retval .= " <td>" . __('Execute every') . "</td>\n";
  461. $retval .= " <td>\n";
  462. $retval .= " <input style='width: 49%;' type='text'\n";
  463. $retval .= " name='item_interval_value'\n";
  464. $retval .= " value='{$item['item_interval_value']}' />\n";
  465. $retval .= " <select style='width: 49%;' name='item_interval_field'>";
  466. foreach ($event_interval as $key => $value) {
  467. $selected = "";
  468. if (! empty($item['item_interval_field'])
  469. && $item['item_interval_field'] == $value
  470. ) {
  471. $selected = " selected='selected'";
  472. }
  473. $retval .= "<option$selected>$value</option>";
  474. }
  475. $retval .= " </select>\n";
  476. $retval .= " </td>\n";
  477. $retval .= "</tr>\n";
  478. $retval .= "<tr class='recurring_event_row$isrecurring_class'>\n";
  479. $retval .= " <td>" . _pgettext('Start of recurring event', 'Start');
  480. $retval .= " </td>\n";
  481. $retval .= " <td class='nowrap'>\n";
  482. $retval .= " <input type='text'\n name='item_starts'\n";
  483. $retval .= " value='{$item['item_starts']}'\n";
  484. $retval .= " class='datetimefield' />\n";
  485. $retval .= " </td>\n";
  486. $retval .= "</tr>\n";
  487. $retval .= "<tr class='recurring_event_row$isrecurring_class'>\n";
  488. $retval .= " <td>" . _pgettext('End of recurring event', 'End') . "</td>\n";
  489. $retval .= " <td class='nowrap'>\n";
  490. $retval .= " <input type='text' name='item_ends'\n";
  491. $retval .= " value='{$item['item_ends']}'\n";
  492. $retval .= " class='datetimefield' />\n";
  493. $retval .= " </td>\n";
  494. $retval .= "</tr>\n";
  495. $retval .= "<tr>\n";
  496. $retval .= " <td>" . __('Definition') . "</td>\n";
  497. $retval .= " <td><textarea name='item_definition' rows='15' cols='40'>";
  498. $retval .= $item['item_definition'];
  499. $retval .= "</textarea></td>\n";
  500. $retval .= "</tr>\n";
  501. $retval .= "<tr>\n";
  502. $retval .= " <td>" . __('On completion preserve') . "</td>\n";
  503. $retval .= " <td><input type='checkbox'\n";
  504. $retval .= " name='item_preserve'{$item['item_preserve']} /></td>\n";
  505. $retval .= "</tr>\n";
  506. $retval .= "<tr>\n";
  507. $retval .= " <td>" . __('Definer') . "</td>\n";
  508. $retval .= " <td><input type='text' name='item_definer'\n";
  509. $retval .= " value='{$item['item_definer']}' /></td>\n";
  510. $retval .= "</tr>\n";
  511. $retval .= "<tr>\n";
  512. $retval .= " <td>" . __('Comment') . "</td>\n";
  513. $retval .= " <td><input type='text' name='item_comment' maxlength='64'\n";
  514. $retval .= " value='{$item['item_comment']}' /></td>\n";
  515. $retval .= "</tr>\n";
  516. $retval .= "</table>\n";
  517. $retval .= "</fieldset>\n";
  518. if ($GLOBALS['is_ajax_request']) {
  519. $retval .= "<input type='hidden' name='editor_process_{$mode}'\n";
  520. $retval .= " value='true' />\n";
  521. $retval .= "<input type='hidden' name='ajax_request' value='true' />\n";
  522. } else {
  523. $retval .= "<fieldset class='tblFooters'>\n";
  524. $retval .= " <input type='submit' name='editor_process_{$mode}'\n";
  525. $retval .= " value='" . __('Go') . "' />\n";
  526. $retval .= "</fieldset>\n";
  527. }
  528. $retval .= "</form>\n\n";
  529. $retval .= "<!-- END " . strtoupper($mode) . " EVENT FORM -->\n\n";
  530. return $retval;
  531. } // end PMA_EVN_getEditorForm()
  532. /**
  533. * Composes the query necessary to create an event from an HTTP request.
  534. *
  535. * @return string The CREATE EVENT query.
  536. */
  537. function PMA_EVN_getQueryFromRequest()
  538. {
  539. global $_REQUEST, $errors, $event_status, $event_type, $event_interval;
  540. $query = 'CREATE ';
  541. if (! empty($_REQUEST['item_definer'])) {
  542. if (strpos($_REQUEST['item_definer'], '@') !== false) {
  543. $arr = explode('@', $_REQUEST['item_definer']);
  544. $query .= 'DEFINER=' . PMA_Util::backquote($arr[0]);
  545. $query .= '@' . PMA_Util::backquote($arr[1]) . ' ';
  546. } else {
  547. $errors[] = __('The definer must be in the "username@hostname" format');
  548. }
  549. }
  550. $query .= 'EVENT ';
  551. if (! empty($_REQUEST['item_name'])) {
  552. $query .= PMA_Util::backquote($_REQUEST['item_name']) . ' ';
  553. } else {
  554. $errors[] = __('You must provide an event name');
  555. }
  556. $query .= 'ON SCHEDULE ';
  557. if (! empty($_REQUEST['item_type'])
  558. && in_array($_REQUEST['item_type'], $event_type)
  559. ) {
  560. if ($_REQUEST['item_type'] == 'RECURRING') {
  561. if (! empty($_REQUEST['item_interval_value'])
  562. && !empty($_REQUEST['item_interval_field'])
  563. && in_array($_REQUEST['item_interval_field'], $event_interval)
  564. ) {
  565. $query .= 'EVERY ' . intval($_REQUEST['item_interval_value']) . ' ';
  566. $query .= $_REQUEST['item_interval_field'] . ' ';
  567. } else {
  568. $errors[] = __('You must provide a valid interval value for the event.');
  569. }
  570. if (! empty($_REQUEST['item_starts'])) {
  571. $query .= "STARTS '"
  572. . PMA_Util::sqlAddSlashes($_REQUEST['item_starts']) . "' ";
  573. }
  574. if (! empty($_REQUEST['item_ends'])) {
  575. $query .= "ENDS '"
  576. . PMA_Util::sqlAddSlashes($_REQUEST['item_ends']) . "' ";
  577. }
  578. } else {
  579. if (! empty($_REQUEST['item_execute_at'])) {
  580. $query .= "AT '"
  581. . PMA_Util::sqlAddSlashes($_REQUEST['item_execute_at']) . "' ";
  582. } else {
  583. $errors[] = __('You must provide a valid execution time for the event.');
  584. }
  585. }
  586. } else {
  587. $errors[] = __('You must provide a valid type for the event.');
  588. }
  589. $query .= 'ON COMPLETION ';
  590. if (empty($_REQUEST['item_preserve'])) {
  591. $query .= 'NOT ';
  592. }
  593. $query .= 'PRESERVE ';
  594. if (! empty($_REQUEST['item_status'])) {
  595. foreach ($event_status['display'] as $key => $value) {
  596. if ($value == $_REQUEST['item_status']) {
  597. $query .= $event_status['query'][$key] . ' ';
  598. break;
  599. }
  600. }
  601. }
  602. if (! empty($_REQUEST['item_comment'])) {
  603. $query .= "COMMENT '" . PMA_Util::sqlAddslashes(
  604. $_REQUEST['item_comment']
  605. ) . "' ";
  606. }
  607. $query .= 'DO ';
  608. if (! empty($_REQUEST['item_definition'])) {
  609. $query .= $_REQUEST['item_definition'];
  610. } else {
  611. $errors[] = __('You must provide an event definition.');
  612. }
  613. return $query;
  614. } // end PMA_EVN_getQueryFromRequest()
  615. ?>