statify / inc / statify_cron.class.php

statify_cron.class.php in Statify 1.4.1, at inc/statify_cron.class.php

43 lines 539 B

Raw Download Zip

1	<?php
2
3
4	/* Quit */
5	defined('ABSPATH') OR exit;
6
7
8	/**
9	* Statify_Cron
10	*
11	* @since 1.4.0
12	*/
13
14	class Statify_Cron extends Statify
15	{
16
17
18	/**
19	* Cleanup obsolete DB values
20	*
21	* @since 0.3.0
22	* @change 1.4.0
23	*/
24
25	public static function cleanup_data()
26	{
27	/* Global */
28	global $wpdb;
29
30	/* Remove items */
31	$wpdb->query(
32	$wpdb->prepare(
33	"DELETE FROM `$wpdb->statify` WHERE created <= SUBDATE(CURDATE(), %d)",
34	(int)self::$_options['days']
35	)
36	);
37
38	/* Optimize DB */
39	$wpdb->query(
40	"OPTIMIZE TABLE `$wpdb->statify`"
41	);
42	}
43	}