← All changes | back/Core/wordpress/database.php +0 -184 10.2.2 → 11.1.1 View file →

		@@ -1,184 +1,0 @@
1		-<?php
2		-
3		-function acym_escapeDB($value)
4		-{
5		- if (is_null($value)) {
6		- $value = '';
7		- }
8		-
9		- return "'".esc_sql($value)."'";
10		-}
11		-
12		-function acym_query($query)
13		-{
14		- global $wpdb;
15		- $query = acym_prepareQuery($query);
16		-
17		- $result = $wpdb->query($query);
18		-
19		- return $result === false ? null : $result;
20		-}
21		-
22		-function acym_loadObjectList($query, $key = '', $offset = null, $limit = null): array
23		-{
24		- global $wpdb;
25		- $query = acym_prepareQuery($query);
26		-
27		- if (isset($offset)) {
28		- $query .= ' LIMIT '.intval($offset).','.intval($limit);
29		- }
30		-
31		- $results = $wpdb->get_results($query);
32		- if (empty($key)) {
33		- return empty($results) ? [] : $results;
34		- }
35		-
36		- $sorted = [];
37		- foreach ($results as $oneRes) {
38		- $sorted[$oneRes->$key] = $oneRes;
39		- }
40		-
41		- return $sorted;
42		-}
43		-
44		-function acym_prepareQuery($query)
45		-{
46		- global $wpdb;
47		- $query = str_replace('#__', $wpdb->prefix, $query);
48		- if (is_multisite()) {
49		- $query = str_replace($wpdb->prefix.'users', $wpdb->base_prefix.'users', $query);
50		- $query = str_replace($wpdb->prefix.'usermeta', $wpdb->base_prefix.'usermeta', $query);
51		- }
52		-
53		- return $query;
54		-}
55		-
56		-function acym_loadObject($query)
57		-{
58		- acym_addLimit($query);
59		-
60		- global $wpdb;
61		- $query = acym_prepareQuery($query);
62		-
63		- return $wpdb->get_row($query);
64		-}
65		-
66		-function acym_loadResult($query)
67		-{
68		- global $wpdb;
69		- $query = acym_prepareQuery($query);
70		-
71		- return $wpdb->get_var($query);
72		-}
73		-
74		-function acym_loadResultArray($query)
75		-{
76		- global $wpdb;
77		- $query = acym_prepareQuery($query);
78		-
79		- return $wpdb->get_col($query);
80		-}
81		-
82		-function acym_getEscaped($text, $extra = false)
83		-{
84		- $result = esc_sql($text);
85		- if ($extra) {
86		- $result = addcslashes($result, '%_');
87		- }
88		-
89		- return $result;
90		-}
91		-
92		-function acym_getDBError()
93		-{
94		- global $wpdb;
95		-
96		- return $wpdb->last_error;
97		-}
98		-
99		-function acym_insertObject($table, $element)
100		-{
101		- global $wpdb;
102		- $element = get_object_vars($element);
103		- $table = acym_prepareQuery($table);
104		- $wpdb->insert($table, $element);
105		-
106		- return $wpdb->insert_id;
107		-}
108		-
109		-function acym_updateObject($table, $element, $pkey)
110		-{
111		- global $wpdb;
112		- $element = get_object_vars($element);
113		- $table = acym_prepareQuery($table);
114		-
115		- if (!is_array($pkey)) {
116		- $pkey = [$pkey];
117		- }
118		-
119		- $where = [];
120		- foreach ($pkey as $onePkey) {
121		- $where[$onePkey] = $element[$onePkey];
122		- }
123		-
124		- $nbUpdated = $wpdb->update($table, $element, $where);
125		-
126		- return $nbUpdated !== false;
127		-}
128		-
129		-function acym_getPrefix()
130		-{
131		- global $wpdb;
132		-
133		- return $wpdb->prefix;
134		-}
135		-
136		-function acym_getTableList()
137		-{
138		- global $wpdb;
139		-
140		- return acym_loadResultArray(
141		- 'SELECT table_name FROM information_schema.tables WHERE table_schema = '.acym_escapeDB($wpdb->dbname).' AND table_name LIKE '.acym_escapeDB($wpdb->prefix.'%')
142		- );
143		-}
144		-
145		-function acym_getCMSConfig($varname, $default = null)
146		-{
147		- $map = [
148		- 'offset' => 'timezone_string',
149		- 'list_limit' => 'posts_per_page',
150		- 'sitename' => 'blogname',
151		- 'mailfrom' => 'new_admin_email',
152		- 'feed_email' => 'new_admin_email',
153		- ];
154		-
155		- if (!empty($map[$varname])) {
156		- $varname = $map[$varname];
157		- }
158		- $value = get_option($varname, $default);
159		-
160		- if ($varname == 'timezone_string' && empty($value)) {
161		- $value = acym_getCMSConfig('gmt_offset');
162		-
163		- if (empty($value)) {
164		- $value = 'UTC';
165		- } elseif ($value < 0) {
166		- $value = 'GMT'.$value;
167		- } else {
168		- $value = 'GMT+'.$value;
169		- }
170		- }
171		-
172		- if ($varname == 'posts_per_page') {
173		- $possibilities = [5, 10, 15, 20, 25, 30, 50, 100];
174		- $closest = 5;
175		- foreach ($possibilities as $possibility) {
176		- if (abs($value - $closest) > abs($value - $possibility)) {
177		- $closest = $possibility;
178		- }
179		- }
180		- $value = $closest;
181		- }
182		-
183		- return $value;
184		-}