No regular expressions were active.
1 |
|
<?php
|
|
1 |
|
<?php
|
2 |
|
|
|
2 |
|
|
3 |
|
/*********
**********
**********
**********
**********
**********
**********
******
|
|
3 |
|
/*********
**********
**********
**********
**********
**********
**********
******
|
4 |
|
*
D
olphin Sma
rt Communi
ty Builder
|
|
4 |
|
*
D
olphin Sma
rt Communi
ty Builder
|
5 |
|
*
---------
--------
|
|
5 |
|
*
---------
--------
|
6 |
|
* begi
n
: M
on Mar 23
2006
|
|
6 |
|
* begi
n
: M
on Mar 23
2006
|
7 |
|
* copy
right
: (
C) 2006 Bo
onEx Group
|
|
7 |
|
* copy
right
: (
C) 2006 Bo
onEx Group
|
8 |
|
* webs
ite
: h
ttp://www.
boonex.com
/
|
|
8 |
|
* webs
ite
: h
ttp://www.
boonex.com
/
|
9 |
|
* This fil
e is part
of Dolphin
- Smart C
ommunity B
uilder
|
|
9 |
|
* This fil
e is part
of Dolphin
- Smart C
ommunity B
uilder
|
10 |
|
*
|
|
10 |
|
*
|
11 |
|
* Dolphin
is free so
ftware. Th
is work is
licensed
under a Cr
eative Com
mons Attri
bution 3.0
License.
|
|
11 |
|
* Dolphin
is free so
ftware. Th
is work is
licensed
under a Cr
eative Com
mons Attri
bution 3.0
License.
|
12 |
|
* http://c
reativecom
mons.org/l
icenses/by
/3.0/
|
|
12 |
|
* http://c
reativecom
mons.org/l
icenses/by
/3.0/
|
13 |
|
*
|
|
13 |
|
*
|
14 |
|
* Dolphin
is distrib
uted in th
e hope tha
t it will
be useful,
but WITHO
UT ANY WAR
RANTY;
|
|
14 |
|
* Dolphin
is distrib
uted in th
e hope tha
t it will
be useful,
but WITHO
UT ANY WAR
RANTY;
|
15 |
|
* without
even the i
mplied war
ranty of
MERCHANTAB
ILITY or F
ITNESS FOR
A PARTICU
LAR PURPOS
E.
|
|
15 |
|
* without
even the i
mplied war
ranty of
MERCHANTAB
ILITY or F
ITNESS FOR
A PARTICU
LAR PURPOS
E.
|
16 |
|
* See the
Creative C
ommons Att
ribution 3
.0 License
for more
details.
|
|
16 |
|
* See the
Creative C
ommons Att
ribution 3
.0 License
for more
details.
|
17 |
|
* You shou
ld have re
ceived a c
opy of the
Creative
Commons At
tribution
3.0 Licens
e along wi
th Dolphin
,
|
|
17 |
|
* You shou
ld have re
ceived a c
opy of the
Creative
Commons At
tribution
3.0 Licens
e along wi
th Dolphin
,
|
18 |
|
* see lice
nse.txt fi
le; if not
, write to
marketing
@boonex.co
m
|
|
18 |
|
* see lice
nse.txt fi
le; if not
, write to
marketing
@boonex.co
m
|
19 |
|
**********
**********
**********
**********
**********
**********
**********
*****/
|
|
19 |
|
**********
**********
**********
**********
**********
**********
**********
*****/
|
20 |
|
|
|
20 |
|
|
21 |
|
require_on
ce( '../in
c/header.i
nc.php' );
|
|
21 |
|
require_on
ce( '../in
c/header.i
nc.php' );
|
22 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'd
esign.inc.
php' );
|
|
22 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'd
esign.inc.
php' );
|
23 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'a
dmin_desig
n.inc.php'
);
|
|
23 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'a
dmin_desig
n.inc.php'
);
|
24 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_CLASSES
. 'BxDolDa
tabaseBack
up.php');
|
|
24 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_CLASSES
. 'BxDolDa
tabaseBack
up.php');
|
25 |
|
|
|
25 |
|
|
26 |
|
$logged['a
dmin']
=
member_aut
h(
1
);
|
|
26 |
|
$logged['a
dmin']
=
member_aut
h(
1
,
true,
true
);
|
27 |
|
|
|
27 |
|
|
28 |
|
$_page['he
ader'] = "
Database t
ools";
|
|
28 |
|
$_page['he
ader'] = "
Database t
ools";
|
29 |
|
$_page['he
ader_text'
] = "Manag
e Database
";
|
|
29 |
|
$_page['he
ader_text'
] = "Manag
e Database
";
|
30 |
|
|
|
30 |
|
|
31 |
|
set_time_l
imit( 3600
0 );
|
|
31 |
|
set_time_l
imit( 3600
0 );
|
32 |
|
|
|
32 |
|
|
33 |
|
$status_te
xt .= '';
|
|
33 |
|
$status_te
xt .= '';
|
34 |
|
if (isset(
$_POST['Ta
blesBackup
'])) { ##B
lock of ta
ble backup
create
|
|
34 |
|
if (isset(
$_POST['Ta
blesBackup
'])) { ##B
lock of ta
ble backup
create
|
35 |
|
//
echo "For:
Tables To
ols". $_PO
ST['tbl_op
'] . ' Tab
le - ' . $
_POST['tbl
'] . ' Sho
w param -
' . $_POST
['savetype
'] ;
|
|
35 |
|
//
echo "For:
Tables To
ols". $_PO
ST['tbl_op
'] . ' Tab
le - ' . $
_POST['tbl
'] . ' Sho
w param -
' . $_POST
['savetype
'] ;
|
36 |
|
|
|
36 |
|
|
37 |
|
$O
utPutType
= preg_re
place("/[^
0-9]/", ''
, $_POST['
tbl_op']);
|
|
37 |
|
$O
utPutType
= preg_re
place("/[^
0-9]/", ''
, $_POST['
tbl_op']);
|
38 |
|
$o
NewBackup
= new BxDo
lDatabaseB
ackup();
|
|
38 |
|
$o
NewBackup
= new BxDo
lDatabaseB
ackup();
|
39 |
|
$o
NewBackup
-> _getTab
leStruct($
_POST['tbl
'], $OutP
utType);
|
|
39 |
|
$o
NewBackup
-> _getTab
leStruct($
_POST['tbl
'], $OutP
utType);
|
40 |
|
|
|
40 |
|
|
41 |
|
if
($_POST['
savetype']
== 'clien
t') {
|
|
41 |
|
if
($_POST['
savetype']
== 'clien
t') {
|
42 |
|
$sql
file = dat
e("Y-m-d_H
:i:s").'_'
.$_POST['t
bl'].'.sql
';
|
|
42 |
|
$sql
file = dat
e("Y-m-d_H
:i:s").'_'
.$_POST['t
bl'].'.sql
';
|
43 |
|
head
er("Conten
t-Type: te
xt/plain")
;
|
|
43 |
|
head
er("Conten
t-Type: te
xt/plain")
;
|
44 |
|
head
er("Conten
t-Disposit
ion: attac
hment;file
name=\"".$
sqlfile."\
"");
|
|
44 |
|
head
er("Conten
t-Disposit
ion: attac
hment;file
name=\"".$
sqlfile."\
"");
|
45 |
|
echo
$oNewBack
up -> sInp
uts;
|
|
45 |
|
echo
$oNewBack
up -> sInp
uts;
|
46 |
|
exit
();
|
|
46 |
|
exit
();
|
47 |
|
}
|
|
47 |
|
}
|
48 |
|
if
($_POST['
savetype']
== 'serve
r') {
|
|
48 |
|
if
($_POST['
savetype']
== 'serve
r') {
|
49 |
|
$sqlfile =
$dir['roo
t'].'backu
p/'.date("
Y-m-d_H-i-
s").'_'.$_
POST['tbl'
].'.sql';
|
|
49 |
|
$sqlfile =
$dir['roo
t'].'backu
p/'.date("
Y-m-d_H-i-
s").'_'.$_
POST['tbl'
].'.sql';
|
50 |
|
$file = fo
pen($sqlfi
le, 'w');
|
|
50 |
|
$file = fo
pen($sqlfi
le, 'w');
|
51 |
|
fputs($fil
e, $oNewBa
ckup -> sI
nputs);
|
|
51 |
|
fputs($fil
e, $oNewBa
ckup -> sI
nputs);
|
52 |
|
$status_te
xt .= "<hr
size=1 />
<font colo
r='green'>
<center>Da
ta succefu
lly dumped
into file
<b>{$sqlf
ile}</b></
center></f
ont>\n";
|
|
52 |
|
$status_te
xt .= "<hr
size=1 />
<font colo
r='green'>
<center>Da
ta succefu
lly dumped
into file
<b>{$sqlf
ile}</b></
center></f
ont>\n";
|
53 |
|
fclose($fi
le);
|
|
53 |
|
fclose($fi
le);
|
54 |
|
}
|
|
54 |
|
}
|
55 |
|
if
($_POST['
savetype']
== 'show'
) {
|
|
55 |
|
if
($_POST['
savetype']
== 'show'
) {
|
56 |
|
$sta
tus_text =
"<center>
<textarea
cols='100'
rows='30'
name='con
tent' styl
e='font-fa
mily: Aria
l; font-si
ze: 11px'
readonly='
readonly'>
" . $oNewB
ackup -> s
Inputs ."<
/textarea>
</center>"
;
|
|
56 |
|
$sta
tus_text =
"<center>
<textarea
cols='100'
rows='30'
name='con
tent' styl
e='font-fa
mily: Aria
l; font-si
ze: 11px'
readonly='
readonly'>
" . $oNewB
ackup -> s
Inputs ."<
/textarea>
</center>"
;
|
57 |
|
}
|
|
57 |
|
}
|
58 |
|
|
|
58 |
|
|
59 |
|
}
|
|
59 |
|
}
|
60 |
|
|
|
60 |
|
|
61 |
|
if (isset(
$_POST['Da
tabasesBac
kup'])) {
|
|
61 |
|
if (isset(
$_POST['Da
tabasesBac
kup'])) {
|
62 |
|
$O
utPutType
= preg_re
place("/[^
0-9]/", ''
, $_POST['
db_op']);
|
|
62 |
|
$O
utPutType
= preg_re
place("/[^
0-9]/", ''
, $_POST['
db_op']);
|
63 |
|
$o
NewBackup
= new BxDo
lDatabaseB
ackup();
|
|
63 |
|
$o
NewBackup
= new BxDo
lDatabaseB
ackup();
|
64 |
|
$o
NewBackup
-> _getAl
lTables($O
utPutType)
;
|
|
64 |
|
$o
NewBackup
-> _getAl
lTables($O
utPutType)
;
|
65 |
|
|
|
65 |
|
|
66 |
|
if
($_POST['
savetype']
== 'show'
) {
|
|
66 |
|
if
($_POST['
savetype']
== 'show'
) {
|
67 |
|
$sta
tus_text =
"<center>
<textarea
cols='100'
rows='30'
name='con
tent' styl
e='font-fa
mily: Aria
l; font-si
ze: 11px'
readonly='
readonly'>
" . $oNewB
ackup -> s
Inputs ."<
/textarea>
</center>"
;
|
|
67 |
|
$sta
tus_text =
"<center>
<textarea
cols='100'
rows='30'
name='con
tent' styl
e='font-fa
mily: Aria
l; font-si
ze: 11px'
readonly='
readonly'>
" . $oNewB
ackup -> s
Inputs ."<
/textarea>
</center>"
;
|
68 |
|
}
|
|
68 |
|
}
|
69 |
|
if
($_POST['
savetype']
== 'serve
r') {
|
|
69 |
|
if
($_POST['
savetype']
== 'serve
r') {
|
70 |
|
$sqlfile =
$dir['roo
t'].'backu
p/'.date("
Y-m-d_H-i-
s").'_all.
sql';
|
|
70 |
|
$sqlfile =
$dir['roo
t'].'backu
p/'.date("
Y-m-d_H-i-
s").'_all.
sql';
|
71 |
|
$file = fo
pen($sqlfi
le, 'w');
|
|
71 |
|
$file = fo
pen($sqlfi
le, 'w');
|
72 |
|
fputs($fil
e, $oNewBa
ckup -> sI
nputs);
|
|
72 |
|
fputs($fil
e, $oNewBa
ckup -> sI
nputs);
|
73 |
|
$status_te
xt .= "<hr
size=1 />
<font colo
r='green'>
<center>Da
ta succefu
lly dumped
into file
<b>{$sqlf
ile}</b></
center></f
ont>\n";
|
|
73 |
|
$status_te
xt .= "<hr
size=1 />
<font colo
r='green'>
<center>Da
ta succefu
lly dumped
into file
<b>{$sqlf
ile}</b></
center></f
ont>\n";
|
74 |
|
fclose($fi
le);
|
|
74 |
|
fclose($fi
le);
|
75 |
|
}
|
|
75 |
|
}
|
76 |
|
if
($_POST['
savetype']
== 'clien
t') {
|
|
76 |
|
if
($_POST['
savetype']
== 'clien
t') {
|
77 |
|
$sql
file = dat
e("Y-m-d_H
:i:s").'_a
ll.sql';
|
|
77 |
|
$sql
file = dat
e("Y-m-d_H
:i:s").'_a
ll.sql';
|
78 |
|
head
er("Conten
t-Type: te
xt/plain")
;
|
|
78 |
|
head
er("Conten
t-Type: te
xt/plain")
;
|
79 |
|
head
er("Conten
t-Disposit
ion: attac
hment;file
name=\"".$
sqlfile."\
"");
|
|
79 |
|
head
er("Conten
t-Disposit
ion: attac
hment;file
name=\"".$
sqlfile."\
"");
|
80 |
|
echo
$oNewBack
up -> sInp
uts;
|
|
80 |
|
echo
$oNewBack
up -> sInp
uts;
|
81 |
|
exit
();
|
|
81 |
|
exit
();
|
82 |
|
}
|
|
82 |
|
}
|
83 |
|
}
|
|
83 |
|
}
|
84 |
|
|
|
84 |
|
|
85 |
|
if (isset
($_POST['D
atabasesRe
store']))
{
|
|
85 |
|
if (isset
($_POST['D
atabasesRe
store']))
{
|
86 |
|
if ($_
POST['save
type'] ==
'delete')
{
|
|
86 |
|
if ($_
POST['save
type'] ==
'delete')
{
|
87 |
|
if
(is_file($
dir['root'
].'backup/
'.$_POST['
dump_file'
])) {
|
|
87 |
|
if
(is_file($
dir['root'
].'backup/
'.$_POST['
dump_file'
])) {
|
88 |
|
@unlink($
dir['root'
].'backup/
'.$_POST['
dump_file'
]);
|
|
88 |
|
@unlink($
dir['root'
].'backup/
'.$_POST['
dump_file'
]);
|
89 |
|
$status_t
ext .= "<h
r size=1 /
><font col
or='green'
><center>D
ump file
succefully
deleted <
b>{$sqlfil
e}</b></ce
nter></fon
t>\n";
|
|
89 |
|
$status_t
ext .= "<h
r size=1 /
><font col
or='green'
><center>D
ump file
succefully
deleted <
b>{$sqlfil
e}</b></ce
nter></fon
t>\n";
|
90 |
|
}
|
|
90 |
|
}
|
91 |
|
el
se $status
_text .= "
<hr size=1
/><font c
olor='red'
><center>P
lease sele
ct dump fi
le <b>{$s
qlfile}</b
></center>
</font>\n"
;
|
|
91 |
|
el
se $status
_text .= "
<hr size=1
/><font c
olor='red'
><center>P
lease sele
ct dump fi
le <b>{$s
qlfile}</b
></center>
</font>\n"
;
|
92 |
|
}
|
|
92 |
|
}
|
93 |
|
if ($_
POST['save
type'] ==
'restore')
{
|
|
93 |
|
if ($_
POST['save
type'] ==
'restore')
{
|
94 |
|
|
|
94 |
|
|
95 |
|
if
(is_file($
dir['root'
].'backup/
'.$_POST['
dump_file'
])) {
|
|
95 |
|
if
(is_file($
dir['root'
].'backup/
'.$_POST['
dump_file'
])) {
|
96 |
|
$oNe
wBackup =
new BxDolD
atabaseBac
kup();
|
|
96 |
|
$oNe
wBackup =
new BxDolD
atabaseBac
kup();
|
97 |
|
$oNe
wBackup ->
_restore
FromDumpFi
le($dir['r
oot'].'bac
kup/'.$_PO
ST['dump_f
ile']);
|
|
97 |
|
$oNe
wBackup ->
_restore
FromDumpFi
le($dir['r
oot'].'bac
kup/'.$_PO
ST['dump_f
ile']);
|
98 |
|
$sta
tus_text .
= "<hr siz
e=1 /><fon
t color='g
reen'><cen
ter>Data s
uccefully
restored f
rom server
dump</cen
ter></font
>\n";
|
|
98 |
|
$sta
tus_text .
= "<hr siz
e=1 /><fon
t color='g
reen'><cen
ter>Data s
uccefully
restored f
rom server
dump</cen
ter></font
>\n";
|
99 |
|
}
|
|
99 |
|
}
|
100 |
|
e
lse $stat
us_text .=
"<hr size
=1 /><font
color='re
d'><center
>Please se
lect dump
file <b>{
$sqlfile}<
/b></cente
r></font>\
n";
|
|
100 |
|
e
lse $stat
us_text .=
"<hr size
=1 /><font
color='re
d'><center
>Please se
lect dump
file <b>{
$sqlfile}<
/b></cente
r></font>\
n";
|
101 |
|
|
|
101 |
|
|
102 |
|
}
|
|
102 |
|
}
|
103 |
|
}
|
|
103 |
|
}
|
104 |
|
|
|
104 |
|
|
105 |
|
if (isset(
$_FILES['s
qlfile']))
{
|
|
105 |
|
if (isset(
$_FILES['s
qlfile']))
{
|
106 |
|
if (
preg_match
("/.sql/",
$_FILES['
sqlfile'][
'name']))
{ #it is c
orrect
|
|
106 |
|
if (
preg_match
("/.sql/",
$_FILES['
sqlfile'][
'name']))
{ #it is c
orrect
|
107 |
|
$oNewBacku
p = new Bx
DolDatabas
eBackup();
|
|
107 |
|
$oNewBacku
p = new Bx
DolDatabas
eBackup();
|
108 |
|
$oNewBacku
p -> _r
estoreFrom
DumpFile($
_FILES['sq
lfile']['t
mp_name']
);
|
|
108 |
|
$oNewBacku
p -> _r
estoreFrom
DumpFile($
_FILES['sq
lfile']['t
mp_name']
);
|
109 |
|
@unlink($_
FILES['sql
file']['tm
p_name']);
|
|
109 |
|
@unlink($_
FILES['sql
file']['tm
p_name']);
|
110 |
|
$status_te
xt .= "<hr
size=1 />
<font colo
r='green'>
<center>Da
ta succefu
lly restor
ed from yo
ur PS </ce
nter></fon
t>\n";
|
|
110 |
|
$status_te
xt .= "<hr
size=1 />
<font colo
r='green'>
<center>Da
ta succefu
lly restor
ed from yo
ur PS </ce
nter></fon
t>\n";
|
111 |
|
}
|
|
111 |
|
}
|
112 |
|
else
$status_t
ext .= "<h
r size=1 /
><font col
or='red'><
center>Ple
ase select
correct d
ump file (
only *.sql
)</center>
</font>\n"
;
|
|
112 |
|
else
$status_t
ext .= "<h
r size=1 /
><font col
or='red'><
center>Ple
ase select
correct d
ump file (
only *.sql
)</center>
</font>\n"
;
|
113 |
|
}
|
|
113 |
|
}
|
114 |
|
|
|
114 |
|
|
115 |
|
TopCodeAdm
in();
|
|
115 |
|
TopCodeAdm
in();
|
116 |
|
|
|
116 |
|
|
117 |
|
ContentBlo
ckHead('Ta
bles backu
p tools');
|
|
117 |
|
ContentBlo
ckHead('Ta
bles backu
p tools');
|
118 |
|
?>
|
|
118 |
|
?>
|
119 |
|
|
|
119 |
|
|
120 |
|
<center>
|
|
120 |
|
<center>
|
121 |
|
|
|
121 |
|
|
122 |
|
<form styl
e="padding
: 0px; mar
gin: 0px;"
method="p
ost" actio
n="<?= $_S
ERVER['PHP
_SELF'] ?>
">
|
|
122 |
|
<form styl
e="padding
: 0px; mar
gin: 0px;"
method="p
ost" actio
n="<?= $_S
ERVER['PHP
_SELF'] ?>
">
|
123 |
|
<input
type="hid
den" name=
"TablesBac
kup" value
="YES" />
|
|
123 |
|
<input
type="hid
den" name=
"TablesBac
kup" value
="YES" />
|
124 |
|
<table
width="10
0%" border
="0" cells
pacing="2"
cellpaddi
ng="3" cla
ss="text">
|
|
124 |
|
<table
width="10
0%" border
="0" cells
pacing="2"
cellpaddi
ng="3" cla
ss="text">
|
125 |
|
<t
r>
|
|
125 |
|
<t
r>
|
126 |
|
<td alig
n="center"
colspan="
2">Choose
operation
and table:
</td>
|
|
126 |
|
<td alig
n="center"
colspan="
2">Choose
operation
and table:
</td>
|
127 |
|
</
tr>
|
|
127 |
|
</
tr>
|
128 |
|
<t
r class="t
able">
|
|
128 |
|
<t
r class="t
able">
|
129 |
|
<td alig
n="right"
width="50%
">
|
|
129 |
|
<td alig
n="right"
width="50%
">
|
130 |
|
<sel
ect name="
tbl_op">
|
|
130 |
|
<sel
ect name="
tbl_op">
|
131 |
|
<option va
lue="2">Ba
ckup struc
ture and c
ontent</op
tion>
|
|
131 |
|
<option va
lue="2">Ba
ckup struc
ture and c
ontent</op
tion>
|
132 |
|
<option va
lue="0">Ba
ckup struc
ture only<
/option>
|
|
132 |
|
<option va
lue="0">Ba
ckup struc
ture only<
/option>
|
133 |
|
<option va
lue="1">Ba
ckup conte
nt only</o
ption>
|
|
133 |
|
<option va
lue="1">Ba
ckup conte
nt only</o
ption>
|
134 |
|
</se
lect>
|
|
134 |
|
</se
lect>
|
135 |
|
</td>
|
|
135 |
|
</td>
|
136 |
|
<td alig
n="left" w
idth="50%"
>
|
|
136 |
|
<td alig
n="left" w
idth="50%"
>
|
137 |
|
<sel
ect name="
tbl">
|
|
137 |
|
<sel
ect name="
tbl">
|
138 |
|
<?ph
p
|
|
138 |
|
<?ph
p
|
139 |
|
$tbl
s = db_lis
t_tables()
; ##Draw a
viable tab
les in Dat
abase
|
|
139 |
|
$tbl
s = db_lis
t_tables()
; ##Draw a
viable tab
les in Dat
abase
|
140 |
|
whil
e ($tbl =
mysql_fetc
h_row($tbl
s)) echo "
<option va
lue=\"{$tb
l['0']}\">
{$tbl['0']
}</option>
";
|
|
140 |
|
whil
e ($tbl =
mysql_fetc
h_row($tbl
s)) echo "
<option va
lue=\"{$tb
l['0']}\">
{$tbl['0']
}</option>
";
|
141 |
|
?>
|
|
141 |
|
?>
|
142 |
|
</se
lect>
|
|
142 |
|
</se
lect>
|
143 |
|
</td>
|
|
143 |
|
</td>
|
144 |
|
</
tr>
|
|
144 |
|
</
tr>
|
145 |
|
<t
r class="t
able">
|
|
145 |
|
<t
r class="t
able">
|
146 |
|
<td cols
pan="2" al
ign="cente
r" width="
50%">
|
|
146 |
|
<td cols
pan="2" al
ign="cente
r" width="
50%">
|
147 |
|
<inp
ut type="r
adio" name
="savetype
" value="s
erver" id=
"table_sav
etype_serv
er" checke
d="checked
" style="v
ertical-al
ign: middl
e" /><labe
l for="tab
le_savetyp
e_server">
Save to se
rver</labe
l>
|
|
147 |
|
<inp
ut type="r
adio" name
="savetype
" value="s
erver" id=
"table_sav
etype_serv
er" checke
d="checked
" style="v
ertical-al
ign: middl
e" /><labe
l for="tab
le_savetyp
e_server">
Save to se
rver</labe
l>
|
148 |
|
<inp
ut type="r
adio" name
="savetype
" value="c
lient" id=
"table_sav
etype_clie
nt" style=
"vertical-
align: mid
dle" /><la
bel for="t
able_savet
ype_client
">Save to
your PC</l
abel> 
;
|
|
148 |
|
<inp
ut type="r
adio" name
="savetype
" value="c
lient" id=
"table_sav
etype_clie
nt" style=
"vertical-
align: mid
dle" /><la
bel for="t
able_savet
ype_client
">Save to
your PC</l
abel> 
;
|
149 |
|
<inp
ut type="r
adio" name
="savetype
" value="s
how" id="t
able_savet
ype_show"
style="ver
tical-alig
n: middle"
/><label
for="table
_savetype_
show">Show
on the sc
reen</labe
l>
|
|
149 |
|
<inp
ut type="r
adio" name
="savetype
" value="s
how" id="t
able_savet
ype_show"
style="ver
tical-alig
n: middle"
/><label
for="table
_savetype_
show">Show
on the sc
reen</labe
l>
|
150 |
|
</td>
|
|
150 |
|
</td>
|
151 |
|
</
tr>
|
|
151 |
|
</
tr>
|
152 |
|
<t
r>
|
|
152 |
|
<t
r>
|
153 |
|
<t
d colspan=
"2" align=
"center"><
input type
="submit"
value="Bac
kup table"
class="no
" /></td>
|
|
153 |
|
<t
d colspan=
"2" align=
"center"><
input type
="submit"
value="Bac
kup table"
class="no
" /></td>
|
154 |
|
</
tr>
|
|
154 |
|
</
tr>
|
155 |
|
|
|
155 |
|
|
156 |
|
<?
php
|
|
156 |
|
<?
php
|
157 |
|
if
($status_
text and i
sset($_POS
T['TablesB
ackup']))
{
|
|
157 |
|
if
($status_
text and i
sset($_POS
T['TablesB
ackup']))
{
|
158 |
|
?>
|
|
158 |
|
?>
|
159 |
|
<t
r>
|
|
159 |
|
<t
r>
|
160 |
|
<td cols
pan="2"><?
= $status_
text ?></t
d>
|
|
160 |
|
<td cols
pan="2"><?
= $status_
text ?></t
d>
|
161 |
|
</
tr>
|
|
161 |
|
</
tr>
|
162 |
|
<?
|
|
162 |
|
<?
|
163 |
|
}
|
|
163 |
|
}
|
164 |
|
?>
|
|
164 |
|
?>
|
165 |
|
|
|
165 |
|
|
166 |
|
</tabl
e>
|
|
166 |
|
</tabl
e>
|
167 |
|
</form>
|
|
167 |
|
</form>
|
168 |
|
|
|
168 |
|
|
169 |
|
</center>
|
|
169 |
|
</center>
|
170 |
|
|
|
170 |
|
|
171 |
|
|
|
171 |
|
|
172 |
|
<?php
|
|
172 |
|
<?php
|
173 |
|
ContentBlo
ckFoot();
|
|
173 |
|
ContentBlo
ckFoot();
|
174 |
|
ContentBlo
ckHead('Da
tabase bac
kup tools'
);
|
|
174 |
|
ContentBlo
ckHead('Da
tabase bac
kup tools'
);
|
175 |
|
?>
|
|
175 |
|
?>
|
176 |
|
|
|
176 |
|
|
177 |
|
<center>
|
|
177 |
|
<center>
|
178 |
|
<form styl
e="padding
: 0px; mar
gin: 0px;"
method="p
ost" actio
n="<?= $_
SERVER['PH
P_SELF'] ?
>">
|
|
178 |
|
<form styl
e="padding
: 0px; mar
gin: 0px;"
method="p
ost" actio
n="<?= $_
SERVER['PH
P_SELF'] ?
>">
|
179 |
|
<input
type="hid
den" name=
"Databases
Backup" va
lue="YES"
/>
|
|
179 |
|
<input
type="hid
den" name=
"Databases
Backup" va
lue="YES"
/>
|
180 |
|
<table wid
th="100%"
cellspacin
g="2" cell
padding="3
" class="t
ext">
|
|
180 |
|
<table wid
th="100%"
cellspacin
g="2" cell
padding="3
" class="t
ext">
|
181 |
|
<tr>
|
|
181 |
|
<tr>
|
182 |
|
<t
d align="r
ight" widt
h="50%">Ch
oose opera
tion:</td>
|
|
182 |
|
<t
d align="r
ight" widt
h="50%">Ch
oose opera
tion:</td>
|
183 |
|
<t
d align="l
eft" width
="50%">
|
|
183 |
|
<t
d align="l
eft" width
="50%">
|
184 |
|
<select
name="db_o
p">
|
|
184 |
|
<select
name="db_o
p">
|
185 |
|
<opt
ion value=
"2">Backup
structure
and conte
nt</option
>
|
|
185 |
|
<opt
ion value=
"2">Backup
structure
and conte
nt</option
>
|
186 |
|
<opt
ion value=
"0">Backup
structure
only</opt
ion>
|
|
186 |
|
<opt
ion value=
"0">Backup
structure
only</opt
ion>
|
187 |
|
</select
>
|
|
187 |
|
</select
>
|
188 |
|
</
td>
|
|
188 |
|
</
td>
|
189 |
|
</tr>
|
|
189 |
|
</tr>
|
190 |
|
<tr cl
ass="table
">
|
|
190 |
|
<tr cl
ass="table
">
|
191 |
|
<t
d colspan=
"2" align=
"center" w
idth="50%"
>
|
|
191 |
|
<t
d colspan=
"2" align=
"center" w
idth="50%"
>
|
192 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="serve
r" id="db_
savetype_s
erver" che
cked="chec
ked" style
="vertical
-align: mi
ddle" /><l
abel for="
db_savetyp
e_server">
Save to se
rver</labe
l>
|
|
192 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="serve
r" id="db_
savetype_s
erver" che
cked="chec
ked" style
="vertical
-align: mi
ddle" /><l
abel for="
db_savetyp
e_server">
Save to se
rver</labe
l>
|
193 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="clien
t" id="db_
savetype_c
lient" sty
le="vertic
al-align:
middle" />
<label for
="db_savet
ype_client
">Save to
your PC</l
abel> 
;
|
|
193 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="clien
t" id="db_
savetype_c
lient" sty
le="vertic
al-align:
middle" />
<label for
="db_savet
ype_client
">Save to
your PC</l
abel> 
;
|
194 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="show"
id="db_sa
vetype_sho
w" style="
vertical-a
lign: midd
le" /><lab
el for="db
_savetype_
show">Show
on the sc
reen</labe
l>
|
|
194 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="show"
id="db_sa
vetype_sho
w" style="
vertical-a
lign: midd
le" /><lab
el for="db
_savetype_
show">Show
on the sc
reen</labe
l>
|
195 |
|
</
td>
|
|
195 |
|
</
td>
|
196 |
|
</tr>
|
|
196 |
|
</tr>
|
197 |
|
<tr>
|
|
197 |
|
<tr>
|
198 |
|
<t
d colspan=
"2" align=
"center">
|
|
198 |
|
<t
d colspan=
"2" align=
"center">
|
199 |
|
<input t
ype="submi
t" value="
Backup dat
abase" cla
ss="no" />
|
|
199 |
|
<input t
ype="submi
t" value="
Backup dat
abase" cla
ss="no" />
|
200 |
|
</
td>
|
|
200 |
|
</
td>
|
201 |
|
</tr>
|
|
201 |
|
</tr>
|
202 |
|
<?
|
|
202 |
|
<?
|
203 |
|
if ($s
tatus_text
and isset
($_POST['D
atabasesBa
ckup'])) {
|
|
203 |
|
if ($s
tatus_text
and isset
($_POST['D
atabasesBa
ckup'])) {
|
204 |
|
?>
|
|
204 |
|
?>
|
205 |
|
<tr>
|
|
205 |
|
<tr>
|
206 |
|
<t
d colspan=
"2"><?= $s
tatus_text
?></td>
|
|
206 |
|
<t
d colspan=
"2"><?= $s
tatus_text
?></td>
|
207 |
|
</tr>
|
|
207 |
|
</tr>
|
208 |
|
<?
|
|
208 |
|
<?
|
209 |
|
}
|
|
209 |
|
}
|
210 |
|
?>
|
|
210 |
|
?>
|
211 |
|
</table>
|
|
211 |
|
</table>
|
212 |
|
</form>
|
|
212 |
|
</form>
|
213 |
|
</center>
|
|
213 |
|
</center>
|
214 |
|
|
|
214 |
|
|
215 |
|
<?php
|
|
215 |
|
<?php
|
216 |
|
ContentBl
ockFoot();
|
|
216 |
|
ContentBl
ockFoot();
|
217 |
|
ContentBl
ockHead('D
atabase Re
store');
|
|
217 |
|
ContentBl
ockHead('D
atabase Re
store');
|
218 |
|
?>
|
|
218 |
|
?>
|
219 |
|
|
|
219 |
|
|
220 |
|
<center>
|
|
220 |
|
<center>
|
221 |
|
<table wid
th="100%"
border="0"
cellspaci
ng="2" cel
lpadding="
3" class="
text">
|
|
221 |
|
<table wid
th="100%"
border="0"
cellspaci
ng="2" cel
lpadding="
3" class="
text">
|
222 |
|
<form
style="pad
ding: 0px;
margin: 0
px;" metho
d="post" a
ction="<?=
$_SERVER
['PHP_SELF
'] ?>">
|
|
222 |
|
<form
style="pad
ding: 0px;
margin: 0
px;" metho
d="post" a
ction="<?=
$_SERVER
['PHP_SELF
'] ?>">
|
223 |
|
<tr>
|
|
223 |
|
<tr>
|
224 |
|
<t
d align="c
enter">
|
|
224 |
|
<t
d align="c
enter">
|
225 |
|
Select d
ump file:
|
|
225 |
|
Select d
ump file:
|
226 |
|
<select
name="dump
_file">
|
|
226 |
|
<select
name="dump
_file">
|
227 |
|
|
|
227 |
|
|
228 |
|
<?php
|
|
228 |
|
<?php
|
229 |
|
if ( $ha
ndle = @op
endir($dir
['root'].'
backup/')
) {
|
|
229 |
|
if ( $ha
ndle = @op
endir($dir
['root'].'
backup/')
) {
|
230 |
|
whil
e ( $file
= readdir(
$handle) )
{
|
|
230 |
|
whil
e ( $file
= readdir(
$handle) )
{
|
231 |
|
if ( preg_
match("/.s
ql/", $fil
e) )
|
|
231 |
|
if ( preg_
match("/.s
ql/", $fil
e) )
|
232 |
|
echo "
<option>{$
file}</opt
ion>";
|
|
232 |
|
echo "
<option>{$
file}</opt
ion>";
|
233 |
|
}
|
|
233 |
|
}
|
234 |
|
}
|
|
234 |
|
}
|
235 |
|
?>
|
|
235 |
|
?>
|
236 |
|
|
|
236 |
|
|
237 |
|
</select
>
|
|
237 |
|
</select
>
|
238 |
|
</
td>
|
|
238 |
|
</
td>
|
239 |
|
</tr>
|
|
239 |
|
</tr>
|
240 |
|
<tr cl
ass="table
">
|
|
240 |
|
<tr cl
ass="table
">
|
241 |
|
<t
d colspan=
"2" align=
"center" w
idth="50%"
>
|
|
241 |
|
<t
d colspan=
"2" align=
"center" w
idth="50%"
>
|
242 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="resto
re" id="db
_restore"
checked="c
hecked" st
yle="verti
cal-align:
middle" /
><label fo
r="db_rest
ore">Resto
re data fr
om dump</l
abel> 
;
|
|
242 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="resto
re" id="db
_restore"
checked="c
hecked" st
yle="verti
cal-align:
middle" /
><label fo
r="db_rest
ore">Resto
re data fr
om dump</l
abel> 
;
|
243 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="delet
e" id="db_
delete" st
yle="verti
cal-align:
middle" /
><label fo
r="db_dele
te">Delete
dump from
server</l
abel> 
;
|
|
243 |
|
<input t
ype="radio
" name="sa
vetype" va
lue="delet
e" id="db_
delete" st
yle="verti
cal-align:
middle" /
><label fo
r="db_dele
te">Delete
dump from
server</l
abel> 
;
|
244 |
|
</
td>
|
|
244 |
|
</
td>
|
245 |
|
</tr>
|
|
245 |
|
</tr>
|
246 |
|
<tr cl
ass="table
">
|
|
246 |
|
<tr cl
ass="table
">
|
247 |
|
<t
d align="c
enter" col
span="2">
|
|
247 |
|
<t
d align="c
enter" col
span="2">
|
248 |
|
<input t
ype="submi
t" value="
Submit" cl
ass="no" /
>
|
|
248 |
|
<input t
ype="submi
t" value="
Submit" cl
ass="no" /
>
|
249 |
|
<input t
ype="hidde
n" name="D
atabasesRe
store" val
ue="YES" /
>
|
|
249 |
|
<input t
ype="hidde
n" name="D
atabasesRe
store" val
ue="YES" /
>
|
250 |
|
</
td>
|
|
250 |
|
</
td>
|
251 |
|
</tr>
|
|
251 |
|
</tr>
|
252 |
|
</form
>
|
|
252 |
|
</form
>
|
253 |
|
<tr cl
ass="table
">
|
|
253 |
|
<tr cl
ass="table
">
|
254 |
|
<t
d colspan=
2>
|
|
254 |
|
<t
d colspan=
2>
|
255 |
|
<hr size
="1" />
|
|
255 |
|
<hr size
="1" />
|
256 |
|
</
td>
|
|
256 |
|
</
td>
|
257 |
|
</tr>
|
|
257 |
|
</tr>
|
258 |
|
<tr cl
ass="panel
">
|
|
258 |
|
<tr cl
ass="panel
">
|
259 |
|
<t
d colspan=
"2" align=
"center"><
font size=
"2px"><b>D
atabase Re
store from
your PC</
b></font><
/td>
|
|
259 |
|
<t
d colspan=
"2" align=
"center"><
font size=
"2px"><b>D
atabase Re
store from
your PC</
b></font><
/td>
|
260 |
|
</tr>
|
|
260 |
|
</tr>
|
261 |
|
<tr cl
ass="table
">
|
|
261 |
|
<tr cl
ass="table
">
|
262 |
|
<t
d colspan=
"2" align=
"center">
|
|
262 |
|
<t
d colspan=
"2" align=
"center">
|
263 |
|
<form ac
tion="<?=
$_SERVER['
PHP_SELF']
?>" metho
d="post" e
nctype="mu
ltipart/fo
rm-data">
|
|
263 |
|
<form ac
tion="<?=
$_SERVER['
PHP_SELF']
?>" metho
d="post" e
nctype="mu
ltipart/fo
rm-data">
|
264 |
|
Sele
ct dump fi
le:
|
|
264 |
|
Sele
ct dump fi
le:
|
265 |
|
<inp
ut type="f
ile" name=
"sqlfile"
size="27"
/>
|
|
265 |
|
<inp
ut type="f
ile" name=
"sqlfile"
size="27"
/>
|
266 |
|
<inp
ut type="s
ubmit" val
ue="Send f
iles" />
|
|
266 |
|
<inp
ut type="s
ubmit" val
ue="Send f
iles" />
|
267 |
|
</form>
|
|
267 |
|
</form>
|
268 |
|
</
td>
|
|
268 |
|
</
td>
|
269 |
|
</tr>
|
|
269 |
|
</tr>
|
270 |
|
|
|
270 |
|
|
271 |
|
<?
|
|
271 |
|
<?
|
272 |
|
if ($s
tatus_text
and isset
($_POST['D
atabasesRe
store'])
or isset($
_FILES['sq
lfile']) )
{
|
|
272 |
|
if ($s
tatus_text
and isset
($_POST['D
atabasesRe
store'])
or isset($
_FILES['sq
lfile']) )
{
|
273 |
|
?>
|
|
273 |
|
?>
|
274 |
|
<tr>
|
|
274 |
|
<tr>
|
275 |
|
<t
d colspan=
"2"><?= $s
tatus_text
?></td>
|
|
275 |
|
<t
d colspan=
"2"><?= $s
tatus_text
?></td>
|
276 |
|
</tr>
|
|
276 |
|
</tr>
|
277 |
|
<?
|
|
277 |
|
<?
|
278 |
|
}
|
|
278 |
|
}
|
279 |
|
|
|
279 |
|
|
280 |
|
?>
|
|
280 |
|
?>
|
281 |
|
|
|
281 |
|
|
282 |
|
</table>
|
|
282 |
|
</table>
|
283 |
|
|
|
283 |
|
|
284 |
|
</center>
|
|
284 |
|
</center>
|
285 |
|
<?php
|
|
285 |
|
<?php
|
286 |
|
ContentBlo
ckFoot();
|
|
286 |
|
ContentBlo
ckFoot();
|
287 |
|
BottomCode
();
|
|
287 |
|
BottomCode
();
|
288 |
|
?>
|
|
288 |
|
?>
|