File Manager
/ wp-content
Search
Upload
New Item
Settings
File "db5.php"
Full path: /home1/epichome/public_html/wp-content/db5.php
File size: 60.67 B (60.67 KB bytes)
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
/home/pharmacy/public_html/wp-content/plugins/maxbuttons/classes/installation.php
<?php
declare(strict_types=1);
namespace MaxButtons;
defined('ABSPATH') or die('No direct access permitted');
class maxInstall
{
public static function activation_hook($network_wide) {
if ($network_wide) {
static::call_function_for_each_site( array('self','activate_plugin') );
}
else {
static::activate_plugin();
}
}
public static function deactivation_hook($network_wide) {
if ($network_wide) {
static::call_function_for_each_site( array('self','deactivate_plugin') );
}
else {
static::deactivate_plugin();
}
}
public static function hasAddOn($addon)
{
switch($addon)
{
case 'socialshare':
if (defined('MBSOCIAL_ROOT_FILE'))
{
return true;
}
break;
}
return false;
}
// This should be done - once! Removed in time as well.
public static function check_database()
{
$version = MAXBUTTONS_VERSION_NUM;
$installed_version = MB()->get_installed_version();
if ($version !== $installed_version)
{
$table = maxUtils::get_table_name();
self::activate_plugin(); // always run the DBdelta on version mismatch.
}
}
public static function activate_plugin($gocreate = true)
{
static::create_database_table();
static::migrate();
static::upgradeUTF();
static::updateFA();
static::migrateResponsive();
$button = MB()->getClass('button');
$button->reset_cache(); //refresh cache
update_option(MAXBUTTONS_VERSION_KEY, MAXBUTTONS_VERSION_NUM);
$created = get_option("MBFREE_CREATED");
if ($created == '' && $gocreate)
{ update_option("MBFREE_CREATED", time());
update_option("MBFREE_HOMEURL", home_url());
}
}
/** MOVE Button Database records from FA4 to FA5 */
public static function updateFA()
{
global $wpdb;
$table_name = maxUtils::get_table_name();
$sql = ' SHOW COLUMNS FROM ' . $table_name . ' LIKE "icon"';
$result = $wpdb->get_results($sql, ARRAY_A);
// when the icon field does not exist. Otherwise this causes an activate notice.
if (count($result) == 0)
return;
$conversion_path = MB()->get_plugin_path() . '/assets/libraries/font-awesome-5/shims.json';
$conversion_array = json_decode(file_get_contents($conversion_path), true);
$sql = 'select id, icon from ' . maxUtils::get_table_name();
$result = $wpdb->get_results($sql, ARRAY_A);
if (count($result) == 0)
return;
foreach($result as $item)
{
$button_id = $item['id'];
if (! $button_id > 0)
{ continue; }
// procedure from setupdata by button class
$icondata = maybe_unserialize($item['icon']);
if ( false === $icondata) // unserialize failed?
{
return;
}
if (! is_array($icondata) && ! is_null($icondata) )
{
$icondata = json_decode($icondata, true);
if (isset($icondata['fa_icon_value']) && strlen($icondata['fa_icon_value']) > 0)
{
$fa_icon = $icondata['fa_icon_value'];
$fa_icon = str_replace('fa-', '', $fa_icon); // remove the prefix
// don't convert converted icons.
if (strpos($fa_icon, 'fas') === false && strpos($fa_icon, 'fab') === false && strpos($fa_icon,'far') === false)
{
$new_fa_icon = self::searchNewFA($fa_icon, $conversion_array);
$icondata['fa_icon_value'] = $new_fa_icon;
$wpdb->update(maxUtils::get_table_name(), array('icon' => json_encode($icondata)), array('id' => $button_id) );
}
}
}
}
}
/** Convert Font Awesome 4 to Font Awesome 5 via the conversion shims array
* @param $old The old value, without the fa- prefix
* @param $conversion_array The loaded FA5 shims library
*/
public static function searchNewFA($old, $conversion_array)
{
$new = false;
foreach($conversion_array as $key => $items)
{
if ($items[0] == $old)
{
$new = (strlen($items[1]) > 0) ? $items[1] : 'fas'; // if not set, fas is the set
$new .= ' fa-';
$new .= (strlen($items[2]) > 0) ? $items[2] : $old ;
}
}
if (! $new)
{
$new = 'fas fa-'. $old;
}
return $new;
}
/** Move data from old version database to new version
*
* Check if new database table is empty ( aka new ) to prevent migrating the same data multiple times then copy all rows from old table to the new one.
*/
public static function migrate()
{
global $wpdb;
$old_table = maxUtils::get_table_name(true);
$table = maxUtils::get_table_name();
if (! self::maxbuttons_database_table_exists($old_table))
{
return;
}
$sql = "SELECT id from $table";
$result = $wpdb->get_results($sql, ARRAY_A);
if(count($result) > 0) return; // don't do this if table already has data.
$sql = "SELECT * FROM $old_table";
$rows = $wpdb->get_results($sql, ARRAY_A);
if (count($rows) == 0 ) // no button in all table; all is good.
return true;
foreach($rows as $row)
{
$data = static::convertOldFields($row);
$id = $data["id"];
global $wpdb;
$wpdb->insert($table, array("id" => $id));
//$data = apply_filters("mb-migration-data",$data, $row);
$button = MB()->getClass('button');
$button->set($id);
$button->save($data);
}
}
/** Import fields from the old database format ( pre version 3.0 ) */
public static function convertOldFields($row)
{
$data = array();
$data["id"] = (isset($row["id"])) ? $row["id"] : -1;
$data["name"] = $row["name"];
$data["status"] = isset($row["status"]) ? $row["status"] : 'publish'; // happens with downloadable packs.
$data["description"] = $row["description"];
$data["url"] = $row["url"];
$data["text"] = $row["text"];
$data["new_window"] = (isset($row["new_window"]) && $row["new_window"] != "") ? 1 : 0;
$data["nofollow"] = (isset($row["nofollow"]) && $row["nofollow"] != "") ? 1 : 0;
$data["font"] = $row["text_font_family"];
$data["font_size"] = $row["text_font_size"];
$data["font_style"] = $row["text_font_style"];
$data["font_weight"] = $row["text_font_weight"];
$data["text_shadow_offset_left"] = $row["text_shadow_offset_left"];
$data["text_shadow_offset_top"] = $row["text_shadow_offset_top"];
$data["text_shadow_width"] = $row["text_shadow_width"];
$data["padding_top"] = $row["text_padding_top"];
$data["padding_right"] = $row["text_padding_right"];
$data["padding_bottom"] = $row["text_padding_bottom"];
$data["padding_left"] = $row["text_padding_left"];
$data["radius_top_left"] = $row["border_radius_top_left"];
$data["radius_top_right"] = $row["border_radius_top_right"];
$data["radius_bottom_left"] = $row["border_radius_bottom_left"];
$data["radius_bottom_right"] = $row["border_radius_bottom_right"];
$data["border_style"] = $row["border_style"];
$data["border_width"] = $row["border_width"];
$data["box_shadow_offset_left"] = $row["box_shadow_offset_left"];
$data["box_shadow_offset_top"] = $row["box_shadow_offset_top"];
$data["box_shadow_width"] = $row["box_shadow_width"];
$data["text_color"] = $row["text_color"];
$data["text_shadow_color"] = $row["text_shadow_color"];
$data["gradient_start_color"] = $row["gradient_start_color"];
$data["gradient_end_color"] = $row["gradient_end_color"];
$data["border_color"] = $row["border_color"];
$data["box_shadow_color"] = $row["box_shadow_color"];
$data["text_color_hover"] = $row["text_color_hover"];
$data["text_shadow_color_hover"] = $row["text_shadow_color_hover"];
$data["gradient_start_color_hover"] = $row["gradient_start_color_hover"];
$data["gradient_end_color_hover"] = $row["gradient_end_color_hover"];
$data["border_color_hover"] = $row["border_color_hover"];
$data["box_shadow_color_hover"] = $row["box_shadow_color_hover"];
$data["gradient_stop"] = (isset($row["gradient_stop"])) ? $row["gradient_stop"] : 45;
$data["gradient_start_opacity"] = (isset($row["gradient_start_opacity"])) ? $row["gradient_start_opacity"] : 100;
$data["gradient_end_opacity"] = (isset($row["gradient_end_opacity"])) ? $row["gradient_end_opacity"] : 100;
$data["gradient_start_opacity_hover"] = (isset($row["gradient_start_opacity_hover"])) ? $row["gradient_start_opacity_hover"] : 100;
$data["gradient_end_opacity_hover"] = (isset($row["gradient_end_opacity_hover"])) ? $row["gradient_end_opacity_hover"] : 100;
$data["container_enabled"] = (isset($row["container_enabled"]) && $row["container_enabled"] != "") ? 1 : 0;
$data["container_center_div_wrap"] = (isset($row["container_center_div_wrap_enabled"]) && $row["container_center_div_wrap_enabled"] != "") ? 1 : 0;
$data["container_width"] = isset($row["container_width"]) ? $row["container_width"] : '';
$data["container_margin_top"] = isset($row["container_margin_top"]) ? $row["container_margin_top"] : '';
$data["container_margin_right"] = isset($row["container_margin_right"]) ? $row["container_margin_right"] : '';
$data["container_margin_bottom"] = isset($row["container_margin_bottom"]) ? $row["container_margin_right"] : '';
$data["container_margin_left"] = isset($row["container_margin_left"]) ? $row["container_margin_left"] : '';
$data["container_alignment"] = isset($row["container_alignment"]) ? $row["container_alignment"] : '';
$data["status"] = (isset($row["status"])) ? $row["status"] : 'publish';
$data["external_css"] = (isset($row["external_css"]) && $row["external_css"] != "") ? 1: 0;
$data["important_css"] = (isset($row["important_css"]) && $row["important_css"] != "") ? 1 : 0;
// icon
$data["use_fa_icon"] = (isset($row["use_font_awesome_icon"]) && $row["use_font_awesome_icon"] != '') ? 1 : 0;
$data["fa_icon_value"] = (isset($row["font_awesome_icon"])) ? $row["font_awesome_icon"] : '';
$data["fa_icon_size"] = (isset($row["font_awesome_icon_size"])) ? $row["font_awesome_icon_size"] : '';
$data["icon_url"] = (isset($row["icon_url"])) ? $row["icon_url"] : '';
$data["icon_alt"] = (isset($row["icon_alt"])) ? $row["icon_alt"] : '';
$data["icon_position"] = (isset($row["icon_position"])) ? $row["icon_position"] : '';
$data["icon_padding_top"] = (isset($row["icon_padding_top"])) ? $row["icon_padding_top"] : '';
$data["icon_padding_bottom"] = (isset($row["icon_padding_bottom"])) ? $row["icon_padding_bottom"] : '';
$data["icon_padding_left"] = (isset($row["icon_padding_left"])) ? $row["icon_padding_left"] : '';
$data["icon_padding_right"] = (isset($row["icon_padding_right"]))? $row["icon_padding_right"] : '';
// dimension
$data["button_width"] = (isset($row["width"])) ? $row["width"] : '';
$data["button_height"] = (isset($row["height"])) ? $row["height"] : '';
// colorPro
$data["icon_color"] = (isset($row["icon_color"])) ? $row["icon_color"] : '';
$data["icon_color_hover"] = (isset($row["icon_color_hover"])) ? $row["icon_color_hover"] : '';
// textPro
$data["text2"] = $row["text2"];
$data["font2"] = $row["text2_font_family"];
$data["font_size2"] = $row["text2_font_size"];
$data["font_style2"] = $row["text2_font_style"];
$data["font_weight2"] = $row["text2_font_weight"];
$data["padding_top2"] = $row["text2_padding_top"];
$data["padding_right2"] = $row["text2_padding_right"];
$data["padding_bottom2"] = $row["text2_padding_bottom"];
$data["padding_left2"] = $row["text2_padding_left"];
$data["text_align"] = (isset($row["text_align"])) ? $row["text_align"] : '';
$data["text_align2"] = (isset($row["text2_align"])) ? $row["text2_align"] : '';
// here old / new Pro Database fields.
return $data;
}
// Movements version < 8.0 to 8.0 >
public static function migrateResponsive()
{
global $wpdb;
$table = maxUtils::get_table_name();
$sql = "SELECT id, responsive from $table";
$results = $wpdb->get_results($sql, ARRAY_A);
$fieldMap = array(
'button_width' => array('dimension', 'button_width'), // check to add px to this val or not.
'button_width_unit' => array('dimension', 'button_size_unit_width'), // px must be converted to pixel, % prob. to percent!
'button_height' => array('dimension', 'button_height'),
'button_height_unit' => array('dimension', 'button_size_unit_height'), // see above
'container_width' => array('container','container_width'),
'container_float' => array('container','container_alignment' ),
'container_width_unit' => array('container', 'container_width_unit'),
'font_size' => array('text', 'font_size'),
);
// The name of the sizes and it's min-width, max-width.
$sizeNames = array(
'phone' => array(0, 480),
'phone_land' => array(321, 480),
'phone_portrait' => array(0, 320),
'ipad' => array(768, 1024),
'medium_phone' => array(480, 768),
'ipad_land' => array(768, 1024),
'ipad_portrait' => array(768, 1024),
'desktop' => array(1224,0),
'large_desktop' => array(1824,0),
//custom
);
foreach ($results as $row)
{
$id = $row['id'];
$responsive_data = $row['responsive'];
if (is_null($responsive_data))
{
continue;
}
$respdata = json_decode($row['responsive'], true);
if (isset($respdata['auto_responsive']))
unset($respdata['auto_responsive']);
// perhaps have some data?
if (! isset($respdata['media_query']))
{
continue; // no responsive data.
}
elseif (count($respdata['media_query']) == 0)
{
continue; // nope
}
else
{
$mediaq = $respdata['media_query'];
if (isset($mediaq['auto_responsive']))
unset($mediaq['auto_responsive']);
$button = new maxButton();
$button->set($id);
$button_data = $button->get();
$screens = $button->getResponsiveScreens();
if (isset($screens['new']))
unset($screens['new']);
if (isset($screens['default']))
unset($screens['default']);
// screens. loop the sizes.
$responsive = array();
foreach($mediaq as $qsize => $qdata)
{
$fielddata = $qdata;
if (count($fielddata) == 1) // seems there is an extra dimension here.
$fielddata = array_shift($qdata);
$next_id = count($screens) + 1;
$screen = new Screen('rs' . $next_id, array('name' => $qsize) );
$responsive['screens'][] = $screen->id;
// find qsize, add screen, width, height.
if (isset($sizeNames[$qsize]))
{
list($minwidth, $maxwidth) = $sizeNames[$qsize];
}
else // not set, must be custom, use custom_midiwdh
{
$minwidth = isset($fielddata['mq_custom_minwidth']) ? $fielddata['mq_custom_minwidth'] : 0;
$maxwidth = isset($fielddata['mq_custom_maxwidth']) ? $fielddata['mq_custom_maxwidth'] : 0;
}
$responsive[$screen->getFieldID('min_width')] = $minwidth;
$responsive[$screen->getFieldID('max_width')] = $maxwidth;
$responsive[$screen->getFieldID('screen_name')] = $qsize;
if (isset($fielddata['mq_hide']) && $fielddata['mq_hide'] == 'none')
{
$responsive[$screen->getFieldID('hide_screen')] = 1;
}
$button_data['responsive'] = $responsive;
// convert fields.
foreach($fielddata as $fname => $fvalue)
{
if ($fvalue === '')
continue;
$fname = str_replace('mq_', '', $fname);
if (isset($fieldMap[$fname]))
{
list($block, $field) = $fieldMap[$fname];
if (strpos($fname, '_unit') >= 0)
{
if ($fvalue == 'px')
$fvalue = 'pixel';
elseif($fvalue == '%')
$fvalue = 'percent';
}
if ($fname == 'container_float')
{
switch($fvalue)
{
case 'left':
$fvalue ='float: left';
break;
case 'right':
$fvalue ='float: right';
break;
case 'none':
$fvalue ='float: none';
break;
}
}
// echo "$fname set, doing $block and $field for $fvalue <BR>";
$button_data[$block][$screen->getFieldID($field)] = $fvalue;
}
}
$screens[] = $screen;
}
// doing responsive
}
// ok ok
foreach($button_data as $block_name => $block_data)
{
if (is_array($block_data)) // id, document_id returned are not data blocks
$button->setData($block_name, $block_data);
}
$button_data['name'] = $button->getName();
$button_data['status'] = $button->getStatus();
$button_data['updated'] = $button->getUpdated(false);
$button->update($button_data);
} // button
}
public static function deactivate_plugin()
{
delete_option(MAXBUTTONS_VERSION_KEY);
}
public static function maxbuttons_database_table_exists($table_name) {
global $wpdb;
$dbaseTable = $wpdb->get_var("SHOW TABLES LIKE '$table_name'");
if (is_null($dbaseTable))
return false;
else
return strtolower($dbaseTable) == strtolower($table_name);
}
public static function create_database_table() {
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
$table_name = maxUtils::get_table_name();
$button = MB()->getClass('button');
$blocks = $button->getBlocks();
// IMPORTANT: There MUST be two spaces between the PRIMARY KEY keywords
// and the column name, and the column name MUST be in parenthesis.
$sql = "CREATE TABLE " . $table_name . " (
id int(14) NOT NULL AUTO_INCREMENT,
name varchar(100) NULL,
status varchar(10) default 'publish' NOT NULL,
cache text,
";
foreach($blocks as $block)
{
$block_name = $block->get_name();
$sql .= "" . $block_name . " TEXT NULL, \n ";
}
$sql .= "updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
created TIMESTAMP DEFAULT 0 NOT NULL,
PRIMARY KEY (id) )";
$result = dbDelta($sql); // always dbdelta
// Reset the cache if there were any left from before
$button->reset_cache();
// Collection table
$collection_table_name = maxUtils::get_collection_table_name();
$sql = "CREATE TABLE " . $collection_table_name . " (
meta_id int(11) NOT NULL AUTO_INCREMENT,
collection_id int(11) NOT NULL,
collection_key varchar(255),
collection_value text,
PRIMARY KEY (meta_id) )
";
dbDelta($sql);
$collection_trans_table = maxUtils::get_coltrans_table_name();
$sql = "CREATE TABLE " . $collection_trans_table . " (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(1000),
value varchar(255),
expire int(11),
PRIMARY KEY (id) )";
$res = dbDelta($sql);
}
/** Attempt to upgrade UTF table to UTFmb4 - see this article https://make.wordpress.org/core/2015/04/02/the-utf8mb4-upgrade/
*/
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_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);
}
/** Routine for activation for WPMU - All blogs */
public static function call_function_for_each_site($function) {
global $wpdb;
// Hold this so we can switch back to it
$root_blog = $wpdb->blogid;
// Get all the blogs/sites in the network and invoke the function for each one
$blog_ids = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs");
foreach ($blog_ids as $blog_id) {
switch_to_blog($blog_id);
call_user_func($function);
}
// Now switch back to the root blog
switch_to_blog($root_blog);
}
} // class
