1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
<?php
namespace Imagify\ThirdParty\NGG;
defined( 'ABSPATH' ) || die( 'Cheatin’ uh?' );
/**
* Imagify NextGen Gallery DB class.
*
* @since 1.5
* @author Jonathan Buttigieg
*/
class DB extends \Imagify_Abstract_DB {
/**
* Class version.
*
* @var string
*/
const VERSION = '1.1.1';
/**
* The single instance of the class.
*
* @var object
* @since 1.5
* @access protected
*/
protected static $_instance;
/**
* The suffix used in the name of the database table (so, without the wpdb prefix).
*
* @var string
* @since 1.7
* @access protected
*/
protected $table = 'ngg_imagify_data';
/**
* The version of our database table.
*
* @var int
* @since 1.5
* @since 1.7 Not public anymore, now an integer.
* @access protected
*/
protected $table_version = 100;
/**
* Tell if the table is the same for each site of a Multisite.
*
* @var bool
* @since 1.7
* @access protected
*/
protected $table_is_global = false;
/**
* The name of the primary column.
*
* @var string
* @since 1.5
* @since 1.7 Not public anymore.
* @access protected
*/
protected $primary_key = 'pid';
/**
* Get the main Instance.
*
* @since 1.6.5
* @access public
* @author Grégory Viguier
*
* @return object Main instance.
*/
public static function get_instance() {
if ( ! isset( self::$_instance ) ) {
self::$_instance = new self();
}
return self::$_instance;
}
/**
* Whitelist of columns.
*
* @since 1.5
* @access public
* @author Jonathan Buttigieg
*
* @return array
*/
public function get_columns() {
return array(
'data_id' => '%d',
'pid' => '%d',
'optimization_level' => '%s',
'status' => '%s',
'data' => '%s',
);
}
/**
* Default column values.
*
* @since 1.5
* @access public
* @author Jonathan Buttigieg
*
* @return array
*/
public function get_column_defaults() {
return array(
'data_id' => 0,
'pid' => 0,
'optimization_level' => '',
'status' => '',
'data' => array(),
);
}
/**
* Get the query to create the table fields.
*
* @since 1.7
* @access protected
* @author Grégory Viguier
*
* @return string
*/
protected function get_table_schema() {
return "
data_id int(11) unsigned NOT NULL AUTO_INCREMENT,
pid int(11) unsigned NOT NULL default 0,
optimization_level varchar(1) NOT NULL default '',
status varchar(30) NOT NULL default '',
data longtext NOT NULL default '',
PRIMARY KEY (data_id),
KEY pid (pid)";
}
}
|