blogid;
// Get all blog ids
$blogids = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs");
foreach ($blogids as $blog_id) {
switch_to_blog($blog_id);
xyz_ihs_install();
}
switch_to_blog($old_blog);
return;
}
}
xyz_ihs_install();
}
function xyz_ihs_install(){
global $wpdb;
$pluginName = 'xyz-wp-insert-code-snippet/xyz-wp-insert-code-snippet.php';
if (is_plugin_active($pluginName)) {
wp_die( "The plugin Insert HTML Snippet cannot be activated unless the premium version of this plugin is deactivated. Back to Plugin Installation." );
}
if ( version_compare( PHP_VERSION, '7.0.0', '<' ) ) {
wp_die(
sprintf(
'This plugin requires PHP version 7.0 or higher. You are using PHP %s. Go back to Plugins page.',
PHP_VERSION,
esc_url( admin_url( 'plugins.php' ) )
)
);
}
if(get_option('xyz_ihs_sort_order')=='')
{
add_option('xyz_ihs_sort_order','desc');
}
if(get_option('xyz_ihs_sort_field_name')=='')
{
add_option('xyz_ihs_sort_field_name','id');
}
$xyz_ihs_installed_date = get_option('xyz_ihs_installed_date');
if ($xyz_ihs_installed_date=="") {
$xyz_ihs_installed_date = time();
update_option('xyz_ihs_installed_date', $xyz_ihs_installed_date);
}
if(get_option('xyz_credit_link') == "")
{
add_option("xyz_credit_link",0);
}
if(get_option('xyz_ihs_dismiss')=='')
{
add_option('xyz_ihs_dismiss',0);
}
if(get_option('xyz_ihs_premium_version_ads')==""){
add_option('xyz_ihs_premium_version_ads',1);
}
add_option('xyz_ihs_limit',20);
add_option('xyz_ihs_exec_in_editor','0');
$charset_collate = $wpdb->get_charset_collate();
$queryInsertHtml = "CREATE TABLE IF NOT EXISTS ".$wpdb->prefix."xyz_ihs_short_code (
`id` int NOT NULL AUTO_INCREMENT,
`title` varchar(1000) NOT NULL,
`description` TEXT NULL ,
`content` longtext NOT NULL,
`short_code` varchar(2000) NOT NULL,
`status` int NOT NULL,
PRIMARY KEY (`id`)
)ENGINE=InnoDB ".$charset_collate." AUTO_INCREMENT=1";
$wpdb->query($queryInsertHtml);
$tblcolums = $wpdb->get_col("SHOW COLUMNS FROM ".$wpdb->prefix."xyz_ihs_short_code");
if(!(in_array("insertionMethod", $tblcolums)))
$wpdb->query("ALTER TABLE ".$wpdb->prefix."xyz_ihs_short_code ADD insertionMethod int NOT NULL default 2");
if(!(in_array("insertionLocation", $tblcolums)))
$wpdb->query("ALTER TABLE ".$wpdb->prefix."xyz_ihs_short_code ADD insertionLocation int NOT NULL default 0");
if(!(in_array("insertionLocationType", $tblcolums)))
$wpdb->query("ALTER TABLE ".$wpdb->prefix."xyz_ihs_short_code ADD insertionLocationType int NOT NULL default 0");
if(!(in_array("description", $tblcolums)))
$wpdb->query("ALTER TABLE ".$wpdb->prefix."xyz_ihs_short_code ADD description TEXT NULL ");
$table_name = $wpdb->prefix . 'xyz_ihs_usage';
$charset_collate = $wpdb->get_charset_collate();
$sql = "CREATE TABLE {$table_name} (
post_id BIGINT(20) UNSIGNED NOT NULL,
snippet_id BIGINT(20) UNSIGNED NOT NULL,
post_type VARCHAR(20) NOT NULL,
PRIMARY KEY (post_id, snippet_id),
KEY post_id (post_id),
KEY snippet_id (snippet_id)
) {$charset_collate};";
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
dbDelta($sql);
// Set sync flag only if not already set
if (get_option('xyz_ihs_sync_needed') === false) {
add_option('xyz_ihs_sync_needed', 1);
}
//Show Snippet Usage Details
add_option('xyz_ihs_show_snippet_usage',1);//default enable
}
register_activation_hook( XYZ_INSERT_HTML_PLUGIN_FILE ,'xyz_ihs_network_install');