1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
|
<?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 ''
)" . $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(16) 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);
}
}
|