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); }
static function getCollectionbyName($name) { //$collection = new maxCollection(); global $wpdb; $sql = "select collection_id from " . maxUtils::get_collection_table_name() . " where collection_key = 'collection_name' and collection_value = %s "; $sql = $wpdb->prepare($sql, $name); $result = $wpdb->get_row($sql, ARRAY_A); // find first if (count($result) > 0) { if (isset($result["collection_id"])) { $usecol = self::getCollectionByID($result["collection_id"]); return $usecol; } } return false; }
function get_meta($collection_id, $collection_key = '') { global $wpdb; $table = maxUtils::get_collection_table_name(); $prepare = array($collection_id); $sql = "SELECT * from {$table} where collection_id = %d "; if ($collection_key != '') { $sql .= " and collection_key = %s "; array_push($prepare, $collection_key); } $sql = $wpdb->prepare($sql, $prepare); $results = $wpdb->get_results($sql, ARRAY_A); $result_array = array(); // format array by field name = values to feed blocks and others. if (!is_null($results)) { $nr = array(); foreach ($results as $row) { $key = $row["collection_key"]; /* A field can be either plain text or JSON */ if (json_decode($row["collection_value"])) { $value = json_decode($row["collection_value"], true); } else { $value = $row["collection_value"]; } $result_array[$key] = $value; //$row["collection_value"] = unserialize($row["collection_value"]); } return $result_array; } else { return false; } }