25 if (! defined(
'CSRFCHECK_WITH_TOKEN')) {
26 define(
'CSRFCHECK_WITH_TOKEN',
'1');
29 require
'../../main.inc.php';
32 $langs->loadLangs(array(
"other",
"admin"));
38 $radio_dump =
GETPOST(
'radio_dump');
39 $showpass =
GETPOST(
'showpass');
50 $help_url =
'EN:Restores|FR:Restaurations|ES:Restauraciones';
54 <script
type=
"text/javascript">
55 jQuery(document).ready(
function() {
56 jQuery(
"#mysql_options").<?php echo $radio_dump ==
'mysql_options' ?
'show()' :
'hide()'; ?>;
57 jQuery(
"#postgresql_options").<?php echo $radio_dump ==
'postgresql_options' ?
'show()' :
'hide()'; ?>;
59 jQuery(
"#radio_dump_mysql").click(
function() {
60 jQuery(
"#mysql_options").show();
62 jQuery(
"#radio_dump_postgresql").click(
function() {
63 jQuery(
"#postgresql_options").show();
66 if ($label ==
'MySQL') {
67 print
'jQuery("#radio_dump_mysql").click();';
69 if ($label ==
'PostgreSQL') {
70 print
'jQuery("#radio_dump_postgresql").click();';
79 print
'<div class="center">';
80 print $langs->trans(
"RestoreDesc", DOL_DATA_ROOT);
86 <legend style=
"font-size: 3em">1</legend>
88 print
'<span class="opacitymedium">';
89 print $langs->trans(
"RestoreDesc2", DOL_DATA_ROOT).
'<br><br>';
97 <legend style=
"font-size: 3em">2</legend>
99 print
'<span class="opacitymedium">';
100 print $langs->trans(
"RestoreDesc3", $dolibarr_main_db_name).
'<br><br>';
104 <?php print $langs->trans(
"DatabaseName").
' : <b>'.$dolibarr_main_db_name.
'</b>'; ?><br><br>
106 <table
class=
"centpercent"><tr><td
class=
"tdtop">
108 <?php
if ($conf->use_javascript_ajax) { ?>
109 <div
id=
"div_container_exportoptions">
110 <fieldset
id=
"exportoptions">
111 <legend><?php echo $langs->trans(
"ImportMethod"); ?></legend>
113 if (in_array($type, array(
'mysql',
'mysqli'))) {
115 <div
class=
"formelementrow">
116 <input
type=
"radio" name=
"what" value=
"mysql" id=
"radio_dump_mysql"<?php echo ($radio_dump ==
'mysql_options' ?
' checked' :
''); ?> />
117 <label
for=
"radio_dump_mysql">MySQL (mysql)</label>
120 } elseif (in_array($type, array(
'pgsql'))) {
122 <div
class=
"formelementrow">
123 <input
type=
"radio" name=
"what" value=
"mysql" id=
"radio_dump_postgresql"<?php echo ($radio_dump ==
'postgresql_options' ?
' checked' :
''); ?> />
124 <label
for=
"radio_dump_postgresql">PostgreSQL Restore (pg_restore or psql)</label>
128 print
'No method available with database '.$label;
135 </td><td
class=
"tdtop">
138 <div
id=
"div_container_sub_exportoptions" >
140 if (in_array($type, array(
'mysql',
'mysqli'))) {
141 print
'<fieldset id="mysql_options">';
142 print
'<legend>'.$langs->trans(
'RestoreMySQL').
'</legend>';
143 print
'<div class="formelementrow centpercent">';
145 $command = $db->getPathOfRestore();
146 if (preg_match(
"/\s/", $command)) {
147 $command = $command = escapeshellarg($command);
150 $param = $dolibarr_main_db_name;
151 $param .=
" -h ".$dolibarr_main_db_host;
152 if (!empty($dolibarr_main_db_port)) {
153 $param .=
" -P ".$dolibarr_main_db_port;
155 $param .=
" -u ".$dolibarr_main_db_user;
156 $paramcrypted = $param;
157 $paramclear = $param;
158 if (!empty($dolibarr_main_db_pass)) {
159 $paramcrypted .=
" -p".preg_replace(
'/./i',
'*', $dolibarr_main_db_pass);
160 $paramclear .=
" -p".$dolibarr_main_db_pass;
163 echo $langs->trans(
"ImportMySqlDesc");
165 print
'<textarea rows="1" id="restorecommand" class="centpercent">'.$langs->trans(
"ImportMySqlCommand", $command, ($showpass ? $paramclear : $paramcrypted)).
'</textarea><br>';
168 if (empty($_GET[
"showpass"]) && $dolibarr_main_db_pass) {
169 print
'<br><a href="'.$_SERVER[
"PHP_SELF"].
'?showpass=1&radio_dump=mysql_options">'.$langs->trans(
"UnHidePassword").
'</a>';
174 } elseif (in_array($type, array(
'pgsql'))) {
175 print
'<fieldset id="postgresql_options">';
176 print
'<legend>Restore PostgreSQL</legend>';
177 print
'<div class="formelementrow">';
179 $command = $db->getPathOfRestore();
180 if (preg_match(
"/\s/", $command)) {
181 $command = $command = escapeshellarg($command);
184 $param =
" -d ".$dolibarr_main_db_name;
185 $param .=
" -h ".$dolibarr_main_db_host;
186 if (!empty($dolibarr_main_db_port)) {
187 $param .=
" -p ".$dolibarr_main_db_port;
189 $param .=
" -U ".$dolibarr_main_db_user;
190 $paramcrypted = $param;
191 $paramclear = $param;
197 $paramcrypted .=
" -W";
198 $paramclear .=
" -W";
200 $paramcrypted .=
" -f";
201 $paramclear .=
" -f";
203 echo $langs->trans(
"ImportPostgreSqlDesc");
205 print
'<textarea rows="1" id="restorecommand" class="centpercent">'.$langs->trans(
"ImportPostgreSqlCommand", $command, ($showpass ? $paramclear : $paramcrypted)).
'</textarea><br>';
219 print
'</td></tr></table>';