function getButtons() { // should maybe but a 'light init' of buttons? $selection = $this->data["selection"]; $buttonsArray = array(); if (count($selection) == 0) { return $buttonsArray; } $table = maxUtils::get_buttons_table_name(); $query_selection = $selection; $selectstring = implode($query_selection, ","); $sql = "SELECT DISTINCT * FROM {$table} WHERE id in (" . $selectstring . ")"; global $wpdb; $results = $wpdb->get_results($sql, ARRAY_A); $data_array = array(); foreach ($results as $result) { $data_array[$result['id']] = $result; } foreach ($selection as $button_id) { $button = MB()->getClass("button"); // performance: bypass the set ( = query ) for every button //$button->set($button_id); $data = isset($data_array[$button_id]) ? $data_array[$button_id] : array(); if (count($data) > 0) { maxButtons::buttonLoad(array("button_id" => $button_id)); // central registration - from button $button->setupData($data); } maxButtons::forceNextID(); $buttonsArray[] = $button; } return $buttonsArray; }
function check_charset() { global $maxbuttons_installed_version; global $wpdb; $check = "SHOW FULL COLUMNS FROM " . maxUtils::get_buttons_table_name(); $charset = $wpdb->query($check); return $charset; }
function getButtonCount($args = array()) { $defaults = array("status" => "publish"); $args = wp_parse_args($args, $defaults); $sql = "SELECT count(id) FROM " . maxUtils::get_buttons_table_name() . " WHERE status = '%s'"; $sql = $this->wpdb->prepare($sql, $args["status"]); $result = $this->wpdb->get_var($sql); return $result; }
<?php defined('ABSPATH') or die('No direct access permitted'); /*if(is_admin()) { wp_enqueue_style('font-awesome', '//maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css', '', '4.0.1', false); } */ if (isset($_POST['alter_charset'])) { global $maxbuttons_installed_version; global $wpdb; $table_name = maxUtils::get_buttons_table_name(); $sql = "ALTER TABLE " . $table_name . " CONVERT TO CHARACTER SET utf8"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; $wpdb->query($sql); $response = 'CHARSET now utf_8 COLLATE utf8_general_ci'; } else { $response = ''; } if (isset($_POST["reset_cache"])) { $button = new maxButton(); $button->reset_cache(); } if (isset($_POST["remigrate"])) { $install = MB()->getClass("install"); $install::create_database_table(); $install::migrate(); } if (isset($_POST["replace"]) && check_admin_referer('mb_bulk_edit', 'bulk_edit')) { $search = $_POST["search"]; $replace = $_POST["replace"]; $field = $_POST["replace_field"]; $button = new maxButton();
public static function upgradeUTF() { require_once ABSPATH . 'wp-admin/includes/upgrade.php'; if (!function_exists('maybe_convert_table_to_utf8mb4')) { return; } // Versions before 4.2.0 $table_name = maxUtils::get_buttons_table_name(); $collection_table_name = maxUtils::get_collection_table_name(); maybe_convert_table_to_utf8mb4($table_name); maybe_convert_table_to_utf8mb4($collection_table_name); }
public function reset_cache() { global $wpdb; $fields = array("cache" => null); $where = array(1 => 1); //$where_format = array('%d'); $sql = "UPDATE " . maxUtils::get_buttons_table_name() . " SET cache = NULL "; $wpdb->query($sql); }
public function check_database($blocks) { maxUtils::addTime("Check database"); $sql = "SELECT id,name,status,cache"; foreach ($blocks as $block => $class) { $sql .= ", {$block}"; } $sql .= " from " . maxUtils::get_buttons_table_name() . " limit 1"; global $wpdb; $wpdb->hide_errors(); $result = $wpdb->get_results($sql); // check this query for errors. If there is an error, one or more database fields are missing. Fix that. if (isset($wpdb->last_error) && $wpdb->last_error != '') { $install = $this->getClass("install"); $install::create_database_table(); $install::migrate(); } maxUtils::addTime("End check database"); }