123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286 |
- <?php
- /**
- * Description of BInstallation
- *
- * @author nur
- */
- class SwpmInstallation {
- /*
- * This function is capable of handing both single site or multi-site install and upgrade all in one.
- */
- static function run_safe_installer() {
- global $wpdb;
- //Do this if multi-site setup
- if (function_exists('is_multisite') && is_multisite()) {
- // check if it is a network activation - if so, run the activation function for each blog id
- if (isset($_GET['networkwide']) && ($_GET['networkwide'] == 1)) {
- $old_blog = $wpdb->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);
- SwpmInstallation::installer();
- SwpmInstallation::initdb();
- }
- switch_to_blog($old_blog);
- return;
- }
- }
- //Do this if single site standard install
- SwpmInstallation::installer();
- SwpmInstallation::initdb();
- }
- public static function installer() {
- global $wpdb;
- require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
- $charset_collate = '';
- if (!empty($wpdb->charset)) {
- $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
- } else {
- $charset_collate = "DEFAULT CHARSET=utf8";
- }
- if (!empty($wpdb->collate)) {
- $charset_collate .= " COLLATE $wpdb->collate";
- }
- $sql = "CREATE TABLE " . $wpdb->prefix . "swpm_members_tbl (
- member_id int(12) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- user_name varchar(255) NOT NULL,
- first_name varchar(64) DEFAULT '',
- last_name varchar(64) DEFAULT '',
- password varchar(255) NOT NULL,
- member_since date NOT NULL DEFAULT '0000-00-00',
- membership_level smallint(6) NOT NULL,
- more_membership_levels VARCHAR(100) DEFAULT NULL,
- account_state enum('active','inactive','activation_required','expired','pending','unsubscribed') DEFAULT 'pending',
- last_accessed datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- last_accessed_from_ip varchar(128) NOT NULL,
- email varchar(255) DEFAULT NULL,
- phone varchar(64) DEFAULT NULL,
- address_street varchar(255) DEFAULT NULL,
- address_city varchar(255) DEFAULT NULL,
- address_state varchar(255) DEFAULT NULL,
- address_zipcode varchar(255) DEFAULT NULL,
- home_page varchar(255) DEFAULT NULL,
- country varchar(255) DEFAULT NULL,
- gender enum('male','female','not specified') DEFAULT 'not specified',
- referrer varchar(255) DEFAULT NULL,
- extra_info text,
- reg_code varchar(255) DEFAULT NULL,
- subscription_starts date DEFAULT NULL,
- initial_membership_level smallint(6) DEFAULT NULL,
- txn_id varchar(255) DEFAULT '',
- subscr_id varchar(255) DEFAULT '',
- company_name varchar(255) DEFAULT '',
- notes text DEFAULT NULL,
- flags int(11) DEFAULT '0',
- profile_image varchar(255) DEFAULT '',
- birth_place varchar(255) DEFAULT NULL,
- birth_date date NOT NULL DEFAULT '0000-00-00',
- )" . $charset_collate . ";";
- dbDelta($sql);
- $sql = "CREATE TABLE " . $wpdb->prefix . "swpm_membership_tbl (
- id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- alias varchar(127) NOT NULL,
- role varchar(255) NOT NULL DEFAULT 'subscriber',
- permissions tinyint(4) NOT NULL DEFAULT '0',
- subscription_period varchar(11) NOT NULL DEFAULT '-1',
- subscription_duration_type tinyint NOT NULL default 0,
- subscription_unit VARCHAR(20) NULL,
- loginredirect_page text NULL,
- category_list longtext,
- page_list longtext,
- post_list longtext,
- comment_list longtext,
- attachment_list longtext,
- custom_post_list longtext,
- disable_bookmark_list longtext,
- options longtext,
- protect_older_posts tinyint(1) NOT NULL DEFAULT '0',
- campaign_name varchar(255) NOT NULL DEFAULT ''
- )" . $charset_collate . " AUTO_INCREMENT=1 ;";
- dbDelta($sql);
- $sql = "SELECT * FROM " . $wpdb->prefix . "swpm_membership_tbl WHERE id = 1";
- $results = $wpdb->get_row($sql);
- if (is_null($results)) {
- $sql = "INSERT INTO " . $wpdb->prefix . "swpm_membership_tbl (
- id ,
- alias ,
- role ,
- permissions ,
- subscription_period ,
- subscription_unit,
- loginredirect_page,
- category_list ,
- page_list ,
- post_list ,
- comment_list,
- disable_bookmark_list,
- options,
- campaign_name
- )VALUES (1 , 'Content Protection', 'administrator', '15', '0',NULL,NULL, NULL , NULL , NULL , NULL,NULL,NULL,'');";
- $wpdb->query($sql);
- }
- $sql = "UPDATE " . $wpdb->prefix . "swpm_membership_tbl SET subscription_duration_type = 1 WHERE subscription_unit='days' AND subscription_duration_type = 0";
- $wpdb->query($sql);
- $sql = "UPDATE " . $wpdb->prefix . "swpm_membership_tbl SET subscription_duration_type = 2 WHERE subscription_unit='weeks' AND subscription_duration_type = 0";
- $wpdb->query($sql);
- $sql = "UPDATE " . $wpdb->prefix . "swpm_membership_tbl SET subscription_duration_type = 3 WHERE subscription_unit='months' AND subscription_duration_type = 0";
- $wpdb->query($sql);
- $sql = "UPDATE " . $wpdb->prefix . "swpm_membership_tbl SET subscription_duration_type = 4 WHERE subscription_unit='years' AND subscription_duration_type = 0";
- $wpdb->query($sql);
- $sql = "CREATE TABLE " . $wpdb->prefix . "swpm_membership_meta_tbl (
- id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
- level_id int(11) NOT NULL,
- meta_key varchar(255) NOT NULL,
- meta_label varchar(255) NULL,
- meta_value text,
- meta_type varchar(255) NOT NULL DEFAULT 'text',
- meta_default text,
- meta_context varchar(255) NOT NULL DEFAULT 'default',
- KEY level_id (level_id)
- )" . $charset_collate . " AUTO_INCREMENT=1;";
- dbDelta($sql);
- $sql = "CREATE TABLE " . $wpdb->prefix . "swpm_payments_tbl (
- id int(12) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- email varchar(255) DEFAULT NULL,
- first_name varchar(64) DEFAULT '',
- last_name varchar(64) DEFAULT '',
- member_id varchar(16) DEFAULT '',
- membership_level varchar(64) DEFAULT '',
- txn_date date NOT NULL default '0000-00-00',
- txn_id varchar(255) NOT NULL default '',
- subscr_id varchar(255) NOT NULL default '',
- reference varchar(255) NOT NULL default '',
- payment_amount varchar(32) NOT NULL default '',
- gateway varchar(32) DEFAULT '',
- status varchar(255) DEFAULT '',
- ip_address varchar(128) default ''
- )" . $charset_collate . ";";
- dbDelta($sql);
- //Save the current DB version
- update_option("swpm_db_version", SIMPLE_WP_MEMBERSHIP_DB_VER);
- }
- public static function initdb() {
- $settings = SwpmSettings::get_instance();
- $installed_version = $settings->get_value('swpm-active-version');
- //Set other default settings values
- $reg_prompt_email_subject = "Complete your registration";
- $reg_prompt_email_body = "Dear {first_name} {last_name}" .
- "\n\nThank you for joining us!" .
- "\n\nPlease complete your registration by visiting the following link:" .
- "\n\n{reg_link}" .
- "\n\nThank You";
- $reg_email_subject = "Your registration is complete";
- $reg_email_body = "Dear {first_name} {last_name}\n\n" .
- "Your registration is now complete!\n\n" .
- "Registration details:\n" .
- "Username: {user_name}\n" .
- "Password: {password}\n\n" .
- "Please login to the member area at the following URL:\n\n" .
- "{login_link}\n\n" .
- "Thank You";
- $reg_email_subject_admin = "Notification of New Member Registration";
- $reg_email_body_admin = "A new member has completed the registration.\n\n" .
- "Username: {user_name}\n" .
- "Email: {email}\n\n" .
- "Please login to the admin dashboard to view details of this user.\n\n" .
- "You can customize this email message from the Email Settings menu of the plugin.\n\n" .
- "Thank You";
- $upgrade_email_subject = "Subject for email sent after account upgrade";
- $upgrade_email_body = "Dear {first_name} {last_name}" .
- "\n\nYour Account Has Been Upgraded." .
- "\n\nThank You";
- $reset_email_subject = get_bloginfo('name') . ": New Password";
- $reset_email_body = "Dear {first_name} {last_name}" .
- "\n\nHere is your new password:" .
- "\n\nUsername: {user_name}" .
- "\nPassword: {password}" .
- "\n\nYou can change the password from the edit profile section of the site (after you log into the site)" .
- "\n\nThank You";
- $status_change_email_subject = "Account Updated!";
- $status_change_email_body = "Dear {first_name} {last_name}," .
- "\n\nYour account status has been updated!" .
- " Please login to the member area at the following URL:" .
- "\n\n {login_link}" .
- "\n\nThank You";
- $bulk_activate_email_subject = "Account Activated!";
- $bulk_activate_email_body = "Hi," .
- "\n\nYour account has been activated!" .
- "\n\nYou can now login to the member area." .
- "\n\nThank You";
- $email_activation_mail_subject = "Action Required to Activate Your Account";
- $email_activation_mail_body = "Dear {first_name}" .
- "\n\nThank you for registering. To activate your account, please click on the following link (this will confirm your email address):" .
- "\n\n{activation_link}" .
- "\n\nThank You";
- $curr_email_act_mail_subj = $settings->get_value('email-activation-mail-subject', false);
- if ($curr_email_act_mail_subj === false) {
- $settings->set_value('email-activation-mail-subject', stripslashes($email_activation_mail_subject));
- }
- $curr_email_act_mail_body = $settings->get_value('email-activation-mail-body', false);
- if ($curr_email_act_mail_body === false) {
- $settings->set_value('email-activation-mail-body', stripslashes($email_activation_mail_body));
- }
- if (empty($installed_version)) {
- //Do fresh install tasks
- //Create the mandatory pages (if they are not there)
- SwpmMiscUtils::create_mandatory_wp_pages();
- //End of page creation
- $example_from_address = 'hello@' . SwpmMiscUtils::get_home_url_without_http_and_www();
- $senders_email_address = get_bloginfo('name') . " <" . $example_from_address . ">";
- $settings->set_value('reg-complete-mail-subject', stripslashes($reg_email_subject))
- ->set_value('reg-complete-mail-body', stripslashes($reg_email_body))
- ->set_value('reg-prompt-complete-mail-subject', stripslashes($reg_prompt_email_subject))
- ->set_value('reg-prompt-complete-mail-body', stripslashes($reg_prompt_email_body))
- ->set_value('upgrade-complete-mail-subject', stripslashes($upgrade_email_subject))
- ->set_value('upgrade-complete-mail-body', stripslashes($upgrade_email_body))
- ->set_value('reset-mail-subject', stripslashes($reset_email_subject))
- ->set_value('reset-mail-body', stripslashes($reset_email_body))
- ->set_value('account-change-email-subject', stripslashes($status_change_email_subject))
- ->set_value('account-change-email-body', stripslashes($status_change_email_body))
- ->set_value('email-from', $senders_email_address);
- $settings->set_value('reg-complete-mail-subject-admin', stripslashes($reg_email_subject_admin));
- $settings->set_value('reg-complete-mail-body-admin', stripslashes($reg_email_body_admin));
- $settings->set_value('bulk-activate-notify-mail-subject', stripslashes($bulk_activate_email_subject));
- $settings->set_value('bulk-activate-notify-mail-body', stripslashes($bulk_activate_email_body));
- }
- if (version_compare($installed_version, SIMPLE_WP_MEMBERSHIP_VER) == -1) {
- //Do upgrade tasks
- }
- $settings->set_value('swpm-active-version', SIMPLE_WP_MEMBERSHIP_VER)->save(); //save everything.
- //Generate and save a swpm private key for this site
- $unique_id = uniqid('', true);
- add_option('swpm_private_key_one', $unique_id);
- }
- }
|