← All changes | class/class-mainwp-db-backup.php +521 -518 5.0 → 6.2.1 View file →

		@@ -8,574 +8,577 @@
8	8	*/
9	9
10	10	namespace MainWP\Dashboard;
11	11
	12	+// Exit if accessed directly.
	13	+if ( ! defined( 'ABSPATH' ) ) {
	14	+ exit;
	15	+}
	16	+
12	17	/**
13	18	* Class MainWP_DB_Backup
14	19	*
15	20	* @package MainWP\Dashboard
16	21	*/
17		-class MainWP_DB_Backup extends MainWP_DB {
18		- // phpcs:disable WordPress.DB.RestrictedFunctions, WordPress.DB.PreparedSQL.NotPrepared -- unprepared SQL ok, accessing the database directly to custom database functions.
	22	+class MainWP_DB_Backup extends MainWP_DB { // phpcs:ignore Generic.Classes.OpeningBraceSameLine.ContentAfterBrace -- NOSONAR.
	23	+ // phpcs:disable WordPress.DB.RestrictedFunctions, WordPress.DB.PreparedSQL.NotPrepared -- unprepared SQL ok, accessing the database directly to custom database functions.
19	24
20		- /**
21		- * Instance variable class.
22		- *
23		- * @static
24		- * @var (self|null) $instance Instance of MainWP_DB_Backup or null.
25		- */
26		- private static $instance = null;
	25	+ /**
	26	+ * Instance variable class.
	27	+ *
	28	+ * @static
	29	+ * @var (self|null) $instance Instance of MainWP_DB_Backup or null.
	30	+ */
	31	+ private static $instance = null;
27	32
28		- /**
29		- * Method instance()
30		- *
31		- * Create public static instance.
32		- *
33		- * @static
34		- * @return MainWP_DB
35		- */
36		- public static function instance() {
37		- if ( null === self::$instance ) {
38		- self::$instance = new self();
39		- }
40		- return self::$instance;
41		- }
	33	+ /**
	34	+ * Method instance()
	35	+ *
	36	+ * Create public static instance.
	37	+ *
	38	+ * @static
	39	+ * @return MainWP_DB
	40	+ */
	41	+ public static function instance() {
	42	+ if ( null === static::$instance ) {
	43	+ static::$instance = new self();
	44	+ }
	45	+ return static::$instance;
	46	+ }
42	47
43		- /**
44		- * Method get_website_backup_settings()
45		- *
46		- * Get Child Site backup settings.
47		- *
48		- * @param mixed $websiteid Child Site ID.
49		- *
50		- * @return object|null Database query result for Child Site backup settings or null on failure
51		- *
52		- * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
53		- */
54		- public function get_website_backup_settings( $websiteid ) {
55		- if ( ! MainWP_Utility::ctype_digit( $websiteid ) ) {
56		- return null;
57		- }
	48	+ /**
	49	+ * Method get_website_backup_settings()
	50	+ *
	51	+ * Get Child Site backup settings.
	52	+ *
	53	+ * @param mixed $websiteid Child Site ID.
	54	+ *
	55	+ * @return object|null Database query result for Child Site backup settings or null on failure
	56	+ *
	57	+ * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
	58	+ */
	59	+ public function get_website_backup_settings( $websiteid ) {
	60	+ if ( ! MainWP_Utility::ctype_digit( $websiteid ) ) {
	61	+ return null;
	62	+ }
58	63
59		- return $this->get_row_result( $this->wpdb->prepare( 'SELECT * FROM ' . $this->table_name( 'wp_settings_backup' ) . ' WHERE wpid = %d ', $websiteid ) );
60		- }
	64	+ return $this->get_row_result( $this->wpdb->prepare( 'SELECT * FROM ' . $this->table_name( 'wp_settings_backup' ) . ' WHERE wpid = %d ', $websiteid ) );
	65	+ }
61	66
62		- /**
63		- * Method update_backup_task_progress()
64		- *
65		- * Update backup tasuk progress.
66		- *
67		- * @param mixed $task_id Task ID.
68		- * @param mixed $wp_id Child Site ID.
69		- * @param mixed $values Values to update.
70		- *
71		- * @return mixed get_backup_task_progres().
72		- */
73		- public function update_backup_task_progress( $task_id, $wp_id, $values ) {
74		- $this->wpdb->update(
75		- $this->table_name( 'wp_backup_progress' ),
76		- $values,
77		- array(
78		- 'task_id' => $task_id,
79		- 'wp_id' => $wp_id,
80		- )
81		- );
	67	+ /**
	68	+ * Method update_backup_task_progress()
	69	+ *
	70	+ * Update backup tasuk progress.
	71	+ *
	72	+ * @param mixed $task_id Task ID.
	73	+ * @param mixed $wp_id Child Site ID.
	74	+ * @param mixed $values Values to update.
	75	+ *
	76	+ * @return mixed get_backup_task_progres().
	77	+ */
	78	+ public function update_backup_task_progress( $task_id, $wp_id, $values ) {
	79	+ $this->wpdb->update(
	80	+ $this->table_name( 'wp_backup_progress' ),
	81	+ $values,
	82	+ array(
	83	+ 'task_id' => $task_id,
	84	+ 'wp_id' => $wp_id,
	85	+ )
	86	+ );
82	87
83		- return $this->get_backup_task_progress( $task_id, $wp_id );
84		- }
	88	+ return $this->get_backup_task_progress( $task_id, $wp_id );
	89	+ }
85	90
86		- /**
87		- * Method add_backup_task_progress()
88		- *
89		- * Add backup task progress.
90		- *
91		- * @param mixed $task_id Task ID.
92		- * @param mixed $wp_id Child Site ID.
93		- * @param mixed $information Task info to add.
94		- *
95		- * @return (array|null) $this->get_backup_task_progress() or null on failure
96		- */
97		- public function add_backup_task_progress( $task_id, $wp_id, $information ) {
98		- $values = array(
99		- 'task_id' => $task_id,
100		- 'wp_id' => $wp_id,
101		- 'dtsFetched' => time(),
102		- 'fetchResult' => wp_json_encode( $information ),
103		- 'removedFiles' => 0,
104		- 'downloadedDB' => '',
105		- 'downloadedFULL' => '',
106		- );
	91	+ /**
	92	+ * Method add_backup_task_progress()
	93	+ *
	94	+ * Add backup task progress.
	95	+ *
	96	+ * @param mixed $task_id Task ID.
	97	+ * @param mixed $wp_id Child Site ID.
	98	+ * @param mixed $information Task info to add.
	99	+ *
	100	+ * @return (array|null) $this->get_backup_task_progress() or null on failure
	101	+ */
	102	+ public function add_backup_task_progress( $task_id, $wp_id, $information ) {
	103	+ $values = array(
	104	+ 'task_id' => $task_id,
	105	+ 'wp_id' => $wp_id,
	106	+ 'dtsFetched' => time(),
	107	+ 'fetchResult' => wp_json_encode( $information ),
	108	+ 'removedFiles' => 0,
	109	+ 'downloadedDB' => '',
	110	+ 'downloadedFULL' => '',
	111	+ );
107	112
108		- if ( $this->wpdb->insert( $this->table_name( 'wp_backup_progress' ), $values ) ) {
109		- return $this->get_backup_task_progress( $task_id, $wp_id );
110		- }
	113	+ if ( $this->wpdb->insert( $this->table_name( 'wp_backup_progress' ), $values ) ) {
	114	+ return $this->get_backup_task_progress( $task_id, $wp_id );
	115	+ }
111	116
112		- return null;
113		- }
	117	+ return null;
	118	+ }
114	119
115		- /**
116		- * Method get_backup_task_progress()
117		- *
118		- * Get backup task progress.
119		- *
120		- * @param mixed $task_id Task ID.
121		- * @param mixed $wp_id Child Site ID.
122		- *
123		- * @return (array|null) Backup Progress or null on failer.
124		- */
125		- public function get_backup_task_progress( $task_id, $wp_id ) {
126		- $progress = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT * FROM ' . $this->table_name( 'wp_backup_progress' ) . ' WHERE task_id= %d AND wp_id = %d ', $task_id, $wp_id ) );
	120	+ /**
	121	+ * Method get_backup_task_progress()
	122	+ *
	123	+ * Get backup task progress.
	124	+ *
	125	+ * @param mixed $task_id Task ID.
	126	+ * @param mixed $wp_id Child Site ID.
	127	+ *
	128	+ * @return (array|null) Backup Progress or null on failer.
	129	+ */
	130	+ public function get_backup_task_progress( $task_id, $wp_id ) {
	131	+ $progress = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT * FROM ' . esc_sql( $this->table_name( 'wp_backup_progress' ) ) . ' WHERE task_id= %d AND wp_id = %d ', $task_id, $wp_id ) );
127	132
128		- if ( '' !== $progress->fetchResult ) {
129		- $progress->fetchResult = json_decode( $progress->fetchResult, true );
130		- }
	133	+ if ( $progress && '' !== $progress->fetchResult ) {
	134	+ $progress->fetchResult = json_decode( $progress->fetchResult, true );
	135	+ }
131	136
132		- return $progress;
133		- }
	137	+ return $progress;
	138	+ }
134	139
135		- /**
136		- * Method backup_full_task_running()
137		- *
138		- * Check if full backup task is running.
139		- *
140		- * @param mixed $wp_id Child Site ID.
141		- *
142		- * @return boolean true|false.
143		- */
144		- public function backup_full_task_running( $wp_id ) {
	140	+ /**
	141	+ * Method backup_full_task_running()
	142	+ *
	143	+ * Check if full backup task is running.
	144	+ *
	145	+ * @param mixed $wp_id Child Site ID.
	146	+ *
	147	+ * @return boolean true|false.
	148	+ */
	149	+ public function backup_full_task_running( $wp_id ) { // phpcs:ignore -- NOSONAR - complex.
145	150
146		- if ( ! get_option( 'mainwp_enableLegacyBackupFeature' ) ) {
147		- return false;
148		- }
	151	+ if ( ! get_option( 'mainwp_enableLegacyBackupFeature' ) ) {
	152	+ return false;
	153	+ }
149	154
150		- $progresses = $this->wpdb->get_results( $this->wpdb->prepare( 'SELECT * FROM ' . $this->table_name( 'wp_backup_progress' ) . ' WHERE wp_id = %d AND dtsFetched > %d ', $wp_id, time() - ( 30 * 60 ) ) );
151		- if ( is_array( $progresses ) ) {
152		- foreach ( $progresses as $progress ) {
153		- if ( empty( $progress->downloadedDBComplete ) && empty( $progress->downloadedFULLComplete ) ) {
154		- $task = $this->get_backup_task_by_id( $progress->task_id );
155		- if ( $task ) {
156		- if ( ( 'full' === $task->type ) && ! $task->paused ) {
157		- return true;
158		- }
159		- }
160		- }
161		- }
162		- }
163		- return false;
164		- }
	155	+ $progresses = $this->wpdb->get_results( $this->wpdb->prepare( 'SELECT * FROM ' . esc_sql( $this->table_name( 'wp_backup_progress' ) ) . ' WHERE wp_id = %d AND dtsFetched > %d ', $wp_id, time() - ( 30 * 60 ) ) );
	156	+ if ( is_array( $progresses ) ) {
	157	+ foreach ( $progresses as $progress ) {
	158	+ if ( empty( $progress->downloadedDBComplete ) && empty( $progress->downloadedFULLComplete ) ) {
	159	+ $task = $this->get_backup_task_by_id( $progress->task_id );
	160	+ if ( $task && ( 'full' === $task->type ) && ! $task->paused ) {
	161	+ return true;
	162	+ }
	163	+ }
	164	+ }
	165	+ }
	166	+ return false;
	167	+ }
165	168
166		- /**
167		- * Method remove_backup_task()
168		- *
169		- * Remove backup task.
170		- *
171		- * @param mixed $id Task ID.
172		- *
173		- * @return void
174		- */
175		- public function remove_backup_task( $id ) {
176		- $this->wpdb->query( $this->wpdb->prepare( 'DELETE FROM ' . $this->table_name( 'wp_backup' ) . ' WHERE id = %d', $id ) );
177		- }
	169	+ /**
	170	+ * Method remove_backup_task()
	171	+ *
	172	+ * Remove backup task.
	173	+ *
	174	+ * @param mixed $id Task ID.
	175	+ *
	176	+ * @return void
	177	+ */
	178	+ public function remove_backup_task( $id ) {
	179	+ $this->wpdb->query( $this->wpdb->prepare( 'DELETE FROM ' . esc_sql( $this->table_name( 'wp_backup' ) ) . ' WHERE id = %d', $id ) );
	180	+ }
178	181
179		- /**
180		- * Method get_backup_task_by_id()
181		- *
182		- * Get backup task by id.
183		- *
184		- * @param mixed $id Task ID.
185		- *
186		- * @return (object|null) Database query result for Backup Task or null on failure
187		- */
188		- public function get_backup_task_by_id( $id ) {
189		- return $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT * FROM ' . $this->table_name( 'wp_backup' ) . ' WHERE id= %d ', $id ) );
190		- }
	182	+ /**
	183	+ * Method get_backup_task_by_id()
	184	+ *
	185	+ * Get backup task by id.
	186	+ *
	187	+ * @param mixed $id Task ID.
	188	+ *
	189	+ * @return (object|null) Database query result for Backup Task or null on failure
	190	+ */
	191	+ public function get_backup_task_by_id( $id ) {
	192	+ return $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT * FROM ' . esc_sql( $this->table_name( 'wp_backup' ) ) . ' WHERE id= %d ', $id ) );
	193	+ }
191	194
192		- /**
193		- * Method get_backup_tasks_for_user()
194		- *
195		- * Get backup tasks for current user.
196		- *
197		- * @param string $orderBy Task order.
198		- *
199		- * @return object|null Database query result for backup tasks for current user or null on failer.
200		- *
201		- * @uses \MainWP\Dashboard\MainWP_System::is_single_user()
202		- */
203		- public function get_backup_tasks_for_user( $orderBy = 'name' ) {
204		- if ( MainWP_System::instance()->is_single_user() ) {
205		- return $this->get_backup_tasks( null, $orderBy );
206		- }
	195	+ /**
	196	+ * Method get_backup_tasks_for_user()
	197	+ *
	198	+ * Get backup tasks for current user.
	199	+ *
	200	+ * @param string $orderBy Task order.
	201	+ *
	202	+ * @return object|null Database query result for backup tasks for current user or null on failer.
	203	+ *
	204	+ * @uses \MainWP\Dashboard\MainWP_System::is_single_user()
	205	+ */
	206	+ public function get_backup_tasks_for_user( $orderBy = 'name' ) {
	207	+ if ( MainWP_System::instance()->is_single_user() ) {
	208	+ return $this->get_backup_tasks( null, $orderBy );
	209	+ }
207	210
208		- /**
209		- * Current user global.
210		- *
211		- * @global string
212		- */
213		- global $current_user;
	211	+ /**
	212	+ * Current user global.
	213	+ *
	214	+ * @global string
	215	+ */
	216	+ global $current_user;
214	217
215		- return $this->get_backup_tasks( $current_user->ID, $orderBy );
216		- }
	218	+ return $this->get_backup_tasks( $current_user->ID, $orderBy );
	219	+ }
217	220
218		- /**
219		- * Method get_backup_tasks()
220		- *
221		- * Get backup tasks for current user.
222		- *
223		- * @param null $userid Current user ID.
224		- * @param string $orderBy Task order.
225		- *
226		- * @return (object|null) Database query result for backup tasks for current user or null on failer.
227		- */
228		- public function get_backup_tasks( $userid = null, $orderBy = null ) {
229		- return $this->wpdb->get_results( 'SELECT * FROM ' . $this->table_name( 'wp_backup' ) . ' WHERE ' . ( null === $userid ? '' : 'userid= ' . $userid . ' AND ' ) . ' template = 0 ' . ( null !== $orderBy ? 'ORDER BY ' . $orderBy : '' ), OBJECT );
230		- }
	221	+ /**
	222	+ * Method get_backup_tasks()
	223	+ *
	224	+ * Get backup tasks for current user.
	225	+ *
	226	+ * @param null $userid Current user ID.
	227	+ * @param string $orderBy Task order.
	228	+ *
	229	+ * @return (object|null) Database query result for backup tasks for current user or null on failer.
	230	+ */
	231	+ public function get_backup_tasks( $userid = null, $orderBy = null ) {
	232	+ return $this->wpdb->get_results( 'SELECT * FROM ' . esc_sql( $this->table_name( 'wp_backup' ) ) . ' WHERE ' . ( null === $userid ? '' : 'userid= ' . absint( $userid ) . ' AND ' ) . ' template = 0 ' . ( null !== $orderBy ? 'ORDER BY ' . esc_sql( $orderBy ) : '' ), OBJECT );
	233	+ }
231	234
232		- /**
233		- * Method add_backup_task()
234		- *
235		- * Add backup task.
236		- *
237		- * @param mixed $userid Current user ID.
238		- * @param mixed $name Name of backup.
239		- * @param mixed $schedule Backup schedual.
240		- * @param mixed $type Type of backup, full|db.
241		- * @param mixed $exclude Files or directories to exclude.
242		- * @param mixed $sites Child Sites to backup.
243		- * @param mixed $groups Groups to backup.
244		- * @param mixed $subfolder Folder the backups are going into.
245		- * @param mixed $filename Filename of the backups.
246		- * @param mixed $template Backup template.
247		- * @param mixed $excludebackup Backup files to exclude.
248		- * @param mixed $excludecache Cache files to exclude.
249		- * @param mixed $excludenonwp Non-wp files to exclude.
250		- * @param mixed $excludezip Archives to exclude.
251		- * @param mixed $archiveFormat Format to store backups in.
252		- * @param mixed $maximumFileDescriptorsOverride Overide maximum file descriptors.
253		- * @param mixed $maximumFileDescriptorsAuto Auto maximum file discriptors.
254		- * @param mixed $maximumFileDescriptors Maximum file descriptors.
255		- * @param mixed $loadFilesBeforeZip Load files before Zip.
256		- *
257		- * @return int|false The number of rows added, or false on error.
258		- *
259		- * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
260		- * @uses \MainWP\Dashboard\MainWP_Utility::remove_preslash_spaces()
261		- */
262		- public function add_backup_task(
263		- $userid,
264		- $name,
265		- $schedule,
266		- $type,
267		- $exclude,
268		- $sites,
269		- $groups,
270		- $subfolder,
271		- $filename,
272		- $template,
273		- $excludebackup,
274		- $excludecache,
275		- $excludenonwp,
276		- $excludezip,
277		- $archiveFormat,
278		- $maximumFileDescriptorsOverride,
279		- $maximumFileDescriptorsAuto,
280		- $maximumFileDescriptors,
281		- $loadFilesBeforeZip
282		- ) {
	235	+ /**
	236	+ * Method add_backup_task()
	237	+ *
	238	+ * Add backup task.
	239	+ *
	240	+ * @param mixed $userid Current user ID.
	241	+ * @param mixed $name Name of backup.
	242	+ * @param mixed $schedule Backup schedual.
	243	+ * @param mixed $type Type of backup, full|db.
	244	+ * @param mixed $exclude Files or directories to exclude.
	245	+ * @param mixed $sites Child Sites to backup.
	246	+ * @param mixed $groups Groups to backup.
	247	+ * @param mixed $subfolder Folder the backups are going into.
	248	+ * @param mixed $filename Filename of the backups.
	249	+ * @param mixed $template Backup template.
	250	+ * @param mixed $excludebackup Backup files to exclude.
	251	+ * @param mixed $excludecache Cache files to exclude.
	252	+ * @param mixed $excludenonwp Non-wp files to exclude.
	253	+ * @param mixed $excludezip Archives to exclude.
	254	+ * @param mixed $archiveFormat Format to store backups in.
	255	+ * @param mixed $maximumFileDescriptorsOverride Overide maximum file descriptors.
	256	+ * @param mixed $maximumFileDescriptorsAuto Auto maximum file discriptors.
	257	+ * @param mixed $maximumFileDescriptors Maximum file descriptors.
	258	+ * @param mixed $loadFilesBeforeZip Load files before Zip.
	259	+ *
	260	+ * @return int|false The number of rows added, or false on error.
	261	+ *
	262	+ * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
	263	+ * @uses \MainWP\Dashboard\MainWP_Utility::remove_preslash_spaces()
	264	+ */
	265	+ public function add_backup_task(
	266	+ $userid,
	267	+ $name,
	268	+ $schedule,
	269	+ $type,
	270	+ $exclude,
	271	+ $sites,
	272	+ $groups,
	273	+ $subfolder,
	274	+ $filename,
	275	+ $template,
	276	+ $excludebackup,
	277	+ $excludecache,
	278	+ $excludenonwp,
	279	+ $excludezip,
	280	+ $archiveFormat,
	281	+ $maximumFileDescriptorsOverride,
	282	+ $maximumFileDescriptorsAuto,
	283	+ $maximumFileDescriptors,
	284	+ $loadFilesBeforeZip
	285	+ ) {
283	286
284		- // to fix null value.
285		- if ( empty( $exclude ) ) {
286		- $exclude = '';
287		- }
	287	+ // to fix null value.
	288	+ if ( empty( $exclude ) ) {
	289	+ $exclude = '';
	290	+ }
288	291
289		- if ( MainWP_Utility::ctype_digit( $userid ) ) {
290		- $values = array(
291		- 'userid' => $userid,
292		- 'name' => $name,
293		- 'schedule' => $schedule,
294		- 'type' => $type,
295		- 'exclude' => $exclude,
296		- 'sites' => $sites,
297		- 'groups' => $groups,
298		- 'last' => 0,
299		- 'last_run' => 0,
300		- 'last_run_manually' => 0,
301		- 'completed_sites' => '',
302		- 'completed' => 0,
303		- 'backup_errors' => '',
304		- 'subfolder' => MainWP_Utility::remove_preslash_spaces( $subfolder ),
305		- 'filename' => $filename,
306		- 'paused' => 0,
307		- 'template' => $template,
308		- 'excludebackup' => $excludebackup,
309		- 'excludecache' => $excludecache,
310		- 'excludenonwp' => $excludenonwp,
311		- 'excludezip' => $excludezip,
312		- 'archiveFormat' => $archiveFormat,
313		- 'loadFilesBeforeZip' => $loadFilesBeforeZip,
314		- 'maximumFileDescriptorsOverride' => $maximumFileDescriptorsOverride,
315		- 'maximumFileDescriptorsAuto' => $maximumFileDescriptorsAuto,
316		- 'maximumFileDescriptors' => $maximumFileDescriptors,
317		- );
	292	+ if ( MainWP_Utility::ctype_digit( $userid ) ) {
	293	+ $values = array(
	294	+ 'userid' => $userid,
	295	+ 'name' => $name,
	296	+ 'schedule' => $schedule,
	297	+ 'type' => $type,
	298	+ 'exclude' => $exclude,
	299	+ 'sites' => $sites,
	300	+ 'groups' => $groups,
	301	+ 'last' => 0,
	302	+ 'last_run' => 0,
	303	+ 'last_run_manually' => 0,
	304	+ 'completed_sites' => '',
	305	+ 'completed' => 0,
	306	+ 'backup_errors' => '',
	307	+ 'subfolder' => MainWP_Utility::remove_preslash_spaces( $subfolder ),
	308	+ 'filename' => $filename,
	309	+ 'paused' => 0,
	310	+ 'template' => $template,
	311	+ 'excludebackup' => $excludebackup,
	312	+ 'excludecache' => $excludecache,
	313	+ 'excludenonwp' => $excludenonwp,
	314	+ 'excludezip' => $excludezip,
	315	+ 'archiveFormat' => $archiveFormat,
	316	+ 'loadFilesBeforeZip' => $loadFilesBeforeZip,
	317	+ 'maximumFileDescriptorsOverride' => $maximumFileDescriptorsOverride,
	318	+ 'maximumFileDescriptorsAuto' => $maximumFileDescriptorsAuto,
	319	+ 'maximumFileDescriptors' => $maximumFileDescriptors,
	320	+ );
318	321
319		- if ( $this->wpdb->insert( $this->table_name( 'wp_backup' ), $values ) ) {
320		- return $this->get_backup_task_by_id( $this->wpdb->insert_id );
321		- }
322		- }
	322	+ if ( $this->wpdb->insert( $this->table_name( 'wp_backup' ), $values ) ) {
	323	+ return $this->get_backup_task_by_id( $this->wpdb->insert_id );
	324	+ }
	325	+ }
323	326
324		- return false;
325		- }
	327	+ return false;
	328	+ }
326	329
327		- /**
328		- * Method update_backup_task()
329		- *
330		- * Update backup task.
331		- *
332		- * @param mixed $id task id.
333		- * @param mixed $userid Current user ID.
334		- * @param mixed $name Name of backup.
335		- * @param mixed $schedule Backup schedual.
336		- * @param mixed $type Type of backup, full|db.
337		- * @param mixed $exclude Files or directories to exclude.
338		- * @param mixed $sites Child Sites to backup.
339		- * @param mixed $groups Groups to backup.
340		- * @param mixed $subfolder Folder the backups are going into.
341		- * @param mixed $filename Filename of the backups.
342		- * @param mixed $excludebackup Backup files to exclude.
343		- * @param mixed $excludecache Cache files to exclude.
344		- * @param mixed $excludenonwp Non-wp files to exclude.
345		- * @param mixed $excludezip Archives to exclude.
346		- * @param mixed $archiveFormat Format to store backups in.
347		- * @param mixed $maximumFileDescriptorsOverride Overide maximum file descriptors.
348		- * @param mixed $maximumFileDescriptorsAuto Auto maximum file discriptors.
349		- * @param mixed $maximumFileDescriptors Maximum file descriptors.
350		- * @param mixed $loadFilesBeforeZip Load files before Zip.
351		- *
352		- * @return int|false The number of rows updated, or false on error.
353		- *
354		- * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
355		- * @uses \MainWP\Dashboard\MainWP_Utility::remove_preslash_spaces()
356		- */
357		- public function update_backup_task(
358		- $id,
359		- $userid,
360		- $name,
361		- $schedule,
362		- $type,
363		- $exclude,
364		- $sites,
365		- $groups,
366		- $subfolder,
367		- $filename,
368		- $excludebackup,
369		- $excludecache,
370		- $excludenonwp,
371		- $excludezip,
372		- $archiveFormat,
373		- $maximumFileDescriptorsOverride,
374		- $maximumFileDescriptorsAuto,
375		- $maximumFileDescriptors,
376		- $loadFilesBeforeZip
377		- ) {
	330	+ /**
	331	+ * Method update_backup_task()
	332	+ *
	333	+ * Update backup task.
	334	+ *
	335	+ * @param mixed $id task id.
	336	+ * @param mixed $userid Current user ID.
	337	+ * @param mixed $name Name of backup.
	338	+ * @param mixed $schedule Backup schedual.
	339	+ * @param mixed $type Type of backup, full|db.
	340	+ * @param mixed $exclude Files or directories to exclude.
	341	+ * @param mixed $sites Child Sites to backup.
	342	+ * @param mixed $groups Groups to backup.
	343	+ * @param mixed $subfolder Folder the backups are going into.
	344	+ * @param mixed $filename Filename of the backups.
	345	+ * @param mixed $excludebackup Backup files to exclude.
	346	+ * @param mixed $excludecache Cache files to exclude.
	347	+ * @param mixed $excludenonwp Non-wp files to exclude.
	348	+ * @param mixed $excludezip Archives to exclude.
	349	+ * @param mixed $archiveFormat Format to store backups in.
	350	+ * @param mixed $maximumFileDescriptorsOverride Overide maximum file descriptors.
	351	+ * @param mixed $maximumFileDescriptorsAuto Auto maximum file discriptors.
	352	+ * @param mixed $maximumFileDescriptors Maximum file descriptors.
	353	+ * @param mixed $loadFilesBeforeZip Load files before Zip.
	354	+ *
	355	+ * @return int|false The number of rows updated, or false on error.
	356	+ *
	357	+ * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
	358	+ * @uses \MainWP\Dashboard\MainWP_Utility::remove_preslash_spaces()
	359	+ */
	360	+ public function update_backup_task(
	361	+ $id,
	362	+ $userid,
	363	+ $name,
	364	+ $schedule,
	365	+ $type,
	366	+ $exclude,
	367	+ $sites,
	368	+ $groups,
	369	+ $subfolder,
	370	+ $filename,
	371	+ $excludebackup,
	372	+ $excludecache,
	373	+ $excludenonwp,
	374	+ $excludezip,
	375	+ $archiveFormat,
	376	+ $maximumFileDescriptorsOverride,
	377	+ $maximumFileDescriptorsAuto,
	378	+ $maximumFileDescriptors,
	379	+ $loadFilesBeforeZip
	380	+ ) {
378	381
379		- if ( MainWP_Utility::ctype_digit( $userid ) && MainWP_Utility::ctype_digit( $id ) ) {
380		- return $this->wpdb->update(
381		- $this->table_name( 'wp_backup' ),
382		- array(
383		- 'userid' => $userid,
384		- 'name' => $name,
385		- 'schedule' => $schedule,
386		- 'type' => $type,
387		- 'exclude' => $exclude,
388		- 'sites' => $sites,
389		- 'groups' => $groups,
390		- 'subfolder' => MainWP_Utility::remove_preslash_spaces( $subfolder ),
391		- 'filename' => $filename,
392		- 'excludebackup' => $excludebackup,
393		- 'excludecache' => $excludecache,
394		- 'excludenonwp' => $excludenonwp,
395		- 'excludezip' => $excludezip,
396		- 'archiveFormat' => $archiveFormat,
397		- 'loadFilesBeforeZip' => $loadFilesBeforeZip,
398		- 'maximumFileDescriptorsOverride' => $maximumFileDescriptorsOverride,
399		- 'maximumFileDescriptorsAuto' => $maximumFileDescriptorsAuto,
400		- 'maximumFileDescriptors' => $maximumFileDescriptors,
401		- ),
402		- array( 'id' => $id )
403		- );
404		- }
	382	+ if ( MainWP_Utility::ctype_digit( $userid ) && MainWP_Utility::ctype_digit( $id ) ) {
	383	+ return $this->wpdb->update(
	384	+ $this->table_name( 'wp_backup' ),
	385	+ array(
	386	+ 'userid' => $userid,
	387	+ 'name' => $name,
	388	+ 'schedule' => $schedule,
	389	+ 'type' => $type,
	390	+ 'exclude' => $exclude,
	391	+ 'sites' => $sites,
	392	+ 'groups' => $groups,
	393	+ 'subfolder' => MainWP_Utility::remove_preslash_spaces( $subfolder ),
	394	+ 'filename' => $filename,
	395	+ 'excludebackup' => $excludebackup,
	396	+ 'excludecache' => $excludecache,
	397	+ 'excludenonwp' => $excludenonwp,
	398	+ 'excludezip' => $excludezip,
	399	+ 'archiveFormat' => $archiveFormat,
	400	+ 'loadFilesBeforeZip' => $loadFilesBeforeZip,
	401	+ 'maximumFileDescriptorsOverride' => $maximumFileDescriptorsOverride,
	402	+ 'maximumFileDescriptorsAuto' => $maximumFileDescriptorsAuto,
	403	+ 'maximumFileDescriptors' => $maximumFileDescriptors,
	404	+ ),
	405	+ array( 'id' => $id )
	406	+ );
	407	+ }
405	408
406		- return false;
407		- }
	409	+ return false;
	410	+ }
408	411
409		- /**
410		- * Method update_backup_task_with_values()
411		- *
412		- * Update backup task with values.
413		- *
414		- * @param mixed $id Task ID.
415		- * @param mixed $values values to update.
416		- *
417		- * @return (int|false) The number of rows updated, or false on error.
418		- */
419		- public function update_backup_task_with_values( $id, $values ) {
420		- if ( ! is_array( $values ) ) {
421		- return false;
422		- }
	412	+ /**
	413	+ * Method update_backup_task_with_values()
	414	+ *
	415	+ * Update backup task with values.
	416	+ *
	417	+ * @param mixed $id Task ID.
	418	+ * @param mixed $values values to update.
	419	+ *
	420	+ * @return (int|false) The number of rows updated, or false on error.
	421	+ */
	422	+ public function update_backup_task_with_values( $id, $values ) {
	423	+ if ( ! is_array( $values ) ) {
	424	+ return false;
	425	+ }
423	426
424		- return $this->wpdb->update( $this->table_name( 'wp_backup' ), $values, array( 'id' => $id ) );
425		- }
	427	+ return $this->wpdb->update( $this->table_name( 'wp_backup' ), $values, array( 'id' => $id ) );
	428	+ }
426	429
427		- /**
428		- * Method update_backup_run()
429		- *
430		- * Update backup run.
431		- *
432		- * @param mixed $id Task ID.
433		- *
434		- * @return int|false The number of rows updated, or false on error.
435		- *
436		- * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
437		- */
438		- public function update_backup_run( $id ) {
439		- if ( MainWP_Utility::ctype_digit( $id ) ) {
440		- return $this->wpdb->update(
441		- $this->table_name( 'wp_backup' ),
442		- array(
443		- 'last_run' => time(),
444		- 'last' => time(),
445		- 'completed_sites' => wp_json_encode( array() ),
446		- ),
447		- array( 'id' => $id )
448		- );
449		- }
	430	+ /**
	431	+ * Method update_backup_run()
	432	+ *
	433	+ * Update backup run.
	434	+ *
	435	+ * @param mixed $id Task ID.
	436	+ *
	437	+ * @return int|false The number of rows updated, or false on error.
	438	+ *
	439	+ * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
	440	+ */
	441	+ public function update_backup_run( $id ) {
	442	+ if ( MainWP_Utility::ctype_digit( $id ) ) {
	443	+ return $this->wpdb->update(
	444	+ $this->table_name( 'wp_backup' ),
	445	+ array(
	446	+ 'last_run' => time(),
	447	+ 'last' => time(),
	448	+ 'completed_sites' => wp_json_encode( array() ),
	449	+ ),
	450	+ array( 'id' => $id )
	451	+ );
	452	+ }
450	453
451		- return false;
452		- }
	454	+ return false;
	455	+ }
453	456
454		- /**
455		- * Method update_backup_run_manually()
456		- *
457		- * Update backup run manually.
458		- *
459		- * @param mixed $id Task ID.
460		- *
461		- * @return int|false The number of rows updated, or false on error.
462		- *
463		- * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
464		- */
465		- public function update_backup_run_manually( $id ) {
466		- if ( MainWP_Utility::ctype_digit( $id ) ) {
467		- return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'last_run_manually' => time() ), array( 'id' => $id ) );
468		- }
	457	+ /**
	458	+ * Method update_backup_run_manually()
	459	+ *
	460	+ * Update backup run manually.
	461	+ *
	462	+ * @param mixed $id Task ID.
	463	+ *
	464	+ * @return int|false The number of rows updated, or false on error.
	465	+ *
	466	+ * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
	467	+ */
	468	+ public function update_backup_run_manually( $id ) {
	469	+ if ( MainWP_Utility::ctype_digit( $id ) ) {
	470	+ return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'last_run_manually' => time() ), array( 'id' => $id ) );
	471	+ }
469	472
470		- return false;
471		- }
	473	+ return false;
	474	+ }
472	475
473		- /**
474		- * Method update_backup_completed()
475		- *
476		- * Update backup completed()
477		- *
478		- * @param mixed $id Task ID.
479		- *
480		- * @return int|false The number of rows updated, or false on error.
481		- *
482		- * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
483		- */
484		- public function update_backup_completed( $id ) {
485		- if ( MainWP_Utility::ctype_digit( $id ) ) {
486		- return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'completed' => time() ), array( 'id' => $id ) );
487		- }
	476	+ /**
	477	+ * Method update_backup_completed()
	478	+ *
	479	+ * Update backup completed()
	480	+ *
	481	+ * @param mixed $id Task ID.
	482	+ *
	483	+ * @return int|false The number of rows updated, or false on error.
	484	+ *
	485	+ * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
	486	+ */
	487	+ public function update_backup_completed( $id ) {
	488	+ if ( MainWP_Utility::ctype_digit( $id ) ) {
	489	+ return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'completed' => time() ), array( 'id' => $id ) );
	490	+ }
488	491
489		- return false;
490		- }
	492	+ return false;
	493	+ }
491	494
492		- /**
493		- * Method update_backup_errors()
494		- *
495		- * Update backup errors.
496		- *
497		- * @param mixed $id Task ID.
498		- * @param mixed $errors Backup errors.
499		- *
500		- * @return int|false The number of rows updated, or false on error.
501		- *
502		- * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
503		- */
504		- public function update_backup_errors( $id, $errors ) {
505		- if ( MainWP_Utility::ctype_digit( $id ) ) {
506		- if ( '' === $errors ) {
507		- return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'backup_errors' => '' ), array( 'id' => $id ) );
508		- } else {
509		- $task = $this->get_backup_task_by_id( $id );
	495	+ /**
	496	+ * Method update_backup_errors()
	497	+ *
	498	+ * Update backup errors.
	499	+ *
	500	+ * @param mixed $id Task ID.
	501	+ * @param mixed $errors Backup errors.
	502	+ *
	503	+ * @return int|false The number of rows updated, or false on error.
	504	+ *
	505	+ * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
	506	+ */
	507	+ public function update_backup_errors( $id, $errors ) {
	508	+ if ( MainWP_Utility::ctype_digit( $id ) ) {
	509	+ if ( '' === $errors ) {
	510	+ return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'backup_errors' => '' ), array( 'id' => $id ) );
	511	+ } else {
	512	+ $task = $this->get_backup_task_by_id( $id );
510	513
511		- return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'backup_errors' => $task->backup_errors . $errors ), array( 'id' => $id ) );
512		- }
513		- }
	514	+ return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'backup_errors' => $task->backup_errors . $errors ), array( 'id' => $id ) );
	515	+ }
	516	+ }
514	517
515		- return false;
516		- }
	518	+ return false;
	519	+ }
517	520
518		- /**
519		- * Method update_completed_sites()
520		- *
521		- * Update completed sites.
522		- *
523		- * @param mixed $id Task ID.
524		- * @param mixed $completedSites Completed sites.
525		- *
526		- * @return int|false The number of rows updated, or false on error.
527		- *
528		- * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
529		- */
530		- public function update_completed_sites( $id, $completedSites ) {
531		- if ( MainWP_Utility::ctype_digit( $id ) ) {
532		- return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'completed_sites' => wp_json_encode( $completedSites ) ), array( 'id' => $id ) );
533		- }
	521	+ /**
	522	+ * Method update_completed_sites()
	523	+ *
	524	+ * Update completed sites.
	525	+ *
	526	+ * @param mixed $id Task ID.
	527	+ * @param mixed $completedSites Completed sites.
	528	+ *
	529	+ * @return int|false The number of rows updated, or false on error.
	530	+ *
	531	+ * @uses \MainWP\Dashboard\MainWP_Utility::ctype_digit()
	532	+ */
	533	+ public function update_completed_sites( $id, $completedSites ) {
	534	+ if ( MainWP_Utility::ctype_digit( $id ) ) {
	535	+ return $this->wpdb->update( $this->table_name( 'wp_backup' ), array( 'completed_sites' => wp_json_encode( $completedSites ) ), array( 'id' => $id ) );
	536	+ }
534	537
535		- return false;
536		- }
	538	+ return false;
	539	+ }
537	540
538		- /**
539		- * Method get_backup_tasks_to_complete()
540		- *
541		- * Get backup tasks to complete.
542		- *
543		- * @return object Backup tasks.
544		- */
545		- public function get_backup_tasks_to_complete() {
546		- return $this->wpdb->get_results( 'SELECT * FROM ' . $this->table_name( 'wp_backup' ) . ' WHERE paused = 0 AND completed < last_run', OBJECT );
547		- }
	541	+ /**
	542	+ * Method get_backup_tasks_to_complete()
	543	+ *
	544	+ * Get backup tasks to complete.
	545	+ *
	546	+ * @return object Backup tasks.
	547	+ */
	548	+ public function get_backup_tasks_to_complete() {
	549	+ return $this->wpdb->get_results( 'SELECT * FROM ' . esc_sql( $this->table_name( 'wp_backup' ) ) . ' WHERE paused = 0 AND completed < last_run', OBJECT );
	550	+ }
548	551
549		- /**
550		- * Method get_backup_tasks_todo_daily()
551		- *
552		- * Get daily backup tasks.
553		- *
554		- * @return object Backup tasks.
555		- */
556		- public function get_backup_tasks_todo_daily() {
557		- return $this->wpdb->get_results( 'SELECT * FROM ' . $this->table_name( 'wp_backup' ) . ' WHERE paused = 0 AND schedule="daily" AND ' . time() . ' - last_run >= ' . ( 60 * 60 * 24 ), OBJECT );
558		- }
	552	+ /**
	553	+ * Method get backup tasks daily.
	554	+ *
	555	+ * Get daily backup tasks.
	556	+ *
	557	+ * @return object Backup tasks.
	558	+ */
	559	+ public function get_backup_tasks_todo_daily() {
	560	+ return $this->wpdb->get_results( 'SELECT * FROM ' . esc_sql( $this->table_name( 'wp_backup' ) ) . ' WHERE paused = 0 AND schedule="daily" AND ' . absint( time() ) . ' - last_run >= ' . ( 60 * 60 * 24 ), OBJECT );
	561	+ }
559	562
560		- /**
561		- * Method get_backup_tasks_todo_weekly()
562		- *
563		- * Get weekly backup tasks.
564		- *
565		- * @return object Backup tasks.
566		- */
567		- public function get_backup_tasks_todo_weekly() {
568		- return $this->wpdb->get_results( 'SELECT * FROM ' . $this->table_name( 'wp_backup' ) . ' WHERE paused = 0 AND schedule="weekly" AND ' . time() . ' - last_run >= ' . ( 60 * 60 * 24 * 7 ), OBJECT );
569		- }
	563	+ /**
	564	+ * Method get backup tasks weekly.
	565	+ *
	566	+ * Get weekly backup tasks.
	567	+ *
	568	+ * @return object Backup tasks.
	569	+ */
	570	+ public function get_backup_tasks_todo_weekly() {
	571	+ return $this->wpdb->get_results( 'SELECT * FROM ' . esc_sql( $this->table_name( 'wp_backup' ) ) . ' WHERE paused = 0 AND schedule="weekly" AND ' . absint( time() ) . ' - last_run >= ' . ( 60 * 60 * 24 * 7 ), OBJECT );
	572	+ }
570	573
571		- /**
572		- * Method get_backup_tasks_todo_monthly()
573		- *
574		- * Get monthly backup tasks.
575		- *
576		- * @return object Backup tasks.
577		- */
578		- public function get_backup_tasks_todo_monthly() {
579		- return $this->wpdb->get_results( 'SELECT * FROM ' . $this->table_name( 'wp_backup' ) . ' WHERE paused = 0 AND schedule="monthly" AND ' . time() . ' - last_run >= ' . ( 60 * 60 * 24 * 30 ), OBJECT );
580		- }
	574	+ /**
	575	+ * Method get backup tasks monthly.
	576	+ *
	577	+ * Get monthly backup tasks.
	578	+ *
	579	+ * @return object Backup tasks.
	580	+ */
	581	+ public function get_backup_tasks_todo_monthly() {
	582	+ return $this->wpdb->get_results( 'SELECT * FROM ' . esc_sql( $this->table_name( 'wp_backup' ) ) . ' WHERE paused = 0 AND schedule="monthly" AND ' . absint( time() ) . ' - last_run >= ' . ( 60 * 60 * 24 * 30 ), OBJECT );
	583	+ }
581	584	}