function sola_nl_activate() { sola_nl_handle_db(); $blogname = get_option("blogname"); $sig = __("This mail was created using the Sola Newsletters WordPress Plugin and was sent from", "sola") . " {$blogname}.\r\n<a href='http://solaplugins.com/plugins/sola-newsletters/' target='_BLANK'>solaplugins.com</a>"; $admin_email = get_option('admin_email'); add_option("sola_nl_email_note", $admin_email); add_option("sola_nl_notifications", "1"); add_option("sola_nl_sig", "{$sig}"); add_option("sola_nl_unsubscribe", __("Unsubscribe", "sola")); add_option("sola_nl_browser_text", __("Not Displaying? View In Browser", "sola")); add_option("sola_nl_sent_from", "{$admin_email}"); add_option("sola_nl_sent_from_name", "{$blogname}"); add_option("sola_nl_reply_to", "{$admin_email}"); add_option("sola_nl_reply_to_name", $blogname); add_option("sola_nl_send_method", "1"); add_option("sola_nl_host", ''); add_option("sola_nl_username"); add_option("sola_nl_password", ''); add_option("sola_nl_port", ''); add_option("sola_nl_sign_up_title", "Newsletter"); add_option("sola_nl_sign_up_btn", "Subscribe"); add_option("sola_currently_sending", "no"); $array = serialize(array(0 => 1)); add_option("sola_nl_sign_up_lists", $array); add_option("sola_nl_encryption", ""); add_option("sola_nl_utm_source", "newsletter"); add_option("sola_nl_utm_medium", "email"); $content = __("Thank you for signing up to our newsletter.", "sola"); $page_id = sola_nl_create_page('nl-confirm-signup', 'Newsletter Sign Up Confirmation', $content); add_option("sola_nl_confirm_page", "{$page_id}"); $content = __("We're sad to see you go.", "sola"); $page_id = sola_nl_create_page('nl-unsubscribe-page', 'Newsletter Unsubscription', $content); add_option("sola_nl_unsubscribe_page", "{$page_id}"); add_option("sola_nl_social_links", array("twitter" => "", "facebook" => "", "pinterest" => "", "linkedin" => "", "google-plus" => "")); add_option("sola_nl_hosting_provider", 0); add_option("sola_nl_send_limit_qty", 20); add_option("sola_nl_send_delay", 1000); add_option("sola_nl_send_limit_time", 600); $confirmation_subject = __("Thank You For Subscribing", "sola"); add_option("sola_nl_confirm_subject", $confirmation_subject); $confirmation_mail = __("Hey [sub_name]!\n\rThank you for signing up to our newsletter.\n\rPlease click on this [confirm_link]link[/confirm_link] to activate your subscription.\n\rKind Regards\n\r", "sola"); add_option("sola_nl_confirm_mail", $confirmation_mail); $confirmation_thank_you = __("Thank You for signing up. You will receive a confirmation mail shortly."); add_option("sola_nl_confirm_thank_you", $confirmation_thank_you); $sola_cron_timestamp = wp_next_scheduled('sola_cron_send_hook'); if ($sola_cron_timestamp == false) { wp_schedule_event(time(), 'every_minute', 'sola_cron_send_hook'); } add_option("solag_nl_first_time", true); add_option("sola_nl_enable_link_tracking", 1); add_option("sola_nl_use_list", 0); }
function sola_nl_update_control() { global $sola_nl_version; if (get_option('sola_nl_first_time') === false) { if (get_option("sola_nl_version") != $sola_nl_version) { sola_nl_handle_db(); if (get_option("sola_nl_confirm_subject") == "") { $confirmation_subject = __("Thank You For Subscribing", "sola"); add_option("sola_nl_confirm_subject", $confirmation_subject); } if (get_option("sola_nl_confirm_thank_you") == "") { $confirmation_thank_you = __("Thank You for signing up. You will receive a confirmation mail shortly.", 'sola'); add_option("sola_nl_confirm_thank_you", $confirmation_thank_you); } if (get_option("sola_nl_browser_text") == "") { add_option("sola_nl_browser_text", __("Not Displaying? View In Browser", "sola")); } /* Link tracking check */ if (get_option('sola_nl_enable_link_tracking') == "") { add_option('sola_nl_enable_link_tracking', 1); } if (get_option('sola_nl_use_list') == "") { add_option('sola_nl_use_list', 0); } if (get_option("sola_nl_send_delay") == "") { add_option("sola_nl_send_delay", 1000000); } update_option("sola_nl_version", $sola_nl_version); /* Version 3.0 updates */ global $wpdb; global $sola_nl_camp_tbl; /* Type Column Check */ $sql = " SHOW COLUMNS FROM {$sola_nl_camp_tbl} WHERE `Field` = 'type'"; $results = $wpdb->get_results($sql); if (!$results) { $sql = "\n ALTER TABLE `{$sola_nl_camp_tbl}` ADD `type` tinyint(1) NOT NULL ;\n "; $wpdb->query($sql); } /* Action Column Check */ $sql = " SHOW COLUMNS FROM {$sola_nl_camp_tbl} WHERE `Field` = 'action'"; $results = $wpdb->get_results($sql); if (!$results) { $sql = "\n ALTER TABLE `{$sola_nl_camp_tbl}` ADD `action` tinyint(1) NOT NULL ;\n "; $wpdb->query($sql); } /* Automatic Data Column Check */ $sql = " SHOW COLUMNS FROM {$sola_nl_camp_tbl} WHERE `Field` = 'automatic_data'"; $results = $wpdb->get_results($sql); if (!$results) { $sql = "\n ALTER TABLE `{$sola_nl_camp_tbl}` ADD `automatic_data` LONGTEXT NOT NULL ;\n "; $wpdb->query($sql); } } } }