$result->dispose(); } catch (MySQLQuerierException $e) { $tpl->assign_block_vars('line', array()); $tpl->assign_block_vars('line.field', array('FIELD_NAME' => $e->GetMessage(), 'STYLE' => '')); } } elseif (substr($lower_query, 0, 11) == 'insert into' || substr($lower_query, 0, 6) == 'update' || substr($lower_query, 0, 11) == 'delete from' || substr($lower_query, 0, 11) == 'alter table' || substr($lower_query, 0, 8) == 'truncate' || substr($lower_query, 0, 10) == 'drop table') { try { $result = PersistenceContext::get_querier()->inject(str_replace('phpboost_', PREFIX, $query)); $affected_rows = $result->get_affected_rows(); } catch (MySQLQuerierException $e) { $tpl->assign_block_vars('line', array()); $tpl->assign_block_vars('line.field', array('FIELD_NAME' => $e->GetMessage(), 'STYLE' => '')); } } } $tpl->put_all(array('QUERY' => DatabaseService::indent_query($query), 'QUERY_HIGHLIGHT' => DatabaseService::highlight_query(str_replace('phpboost_', PREFIX, $query)), 'L_REQUIRE' => LangLoader::get_message('form.explain_required_fields', 'status-messages-common'), 'L_EXPLAIN_QUERY' => $LANG['db_query_explain'], 'L_CONFIRM_QUERY' => $LANG['db_confirm_query'], 'L_EXECUTE' => $LANG['db_submit_query'], 'L_RESULT' => $LANG['db_query_result'], 'L_EXECUTED_QUERY' => $LANG['db_executed_query'])); } elseif ($action == 'restore') { //Suppression d'un fichier if (!empty($del)) { AppContext::get_session()->csrf_get_protect(); //Protection csrf $file = TextHelper::strprotect($del); $file_path = PATH_TO_ROOT . '/cache/backup/' . $file; //Si le fichier existe if (preg_match('`[^/]+\\.sql$`', $file) && is_file($file_path)) { if (@unlink($file_path)) { AppContext::get_response()->redirect(HOST . DIR . url('/database/admin_database.php?action=restore&error=unlink_success', '', '&')); } else { AppContext::get_response()->redirect(HOST . DIR . url('/database/admin_database.php?action=restore&error=unlink_failure', '', '&')); } } else {