mirror of
https://gh.wpcy.net/https://github.com/michelve/software-license-manager.git
synced 2026-07-15 19:03:28 +08:00
36b80696e3
- added: support for email reminder, user will receive an email when license has expired - fixed: a bug where email will be send-out - added: custom fields to woocommece order - added: product type (license) for woocommerce - rebuilt my licenses in my account page - added: until version and current version to api - ui: change styles to match more wp interface
122 lines
No EOL
4.3 KiB
PHP
Executable file
122 lines
No EOL
4.3 KiB
PHP
Executable file
<?php
|
||
/**
|
||
* Runs on Uninstall of Software License Manager
|
||
*
|
||
* @package Software License Manager
|
||
* @author Michel Velis
|
||
* @license GPL-2.0+
|
||
* @link http://epikly.com
|
||
*/
|
||
global $wpdb;
|
||
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
|
||
|
||
//***Installer variables***
|
||
$lic_key_table = SLM_TBL_LICENSE_KEYS;
|
||
$lic_domain_table = SLM_TBL_LIC_DOMAIN;
|
||
$lic_devices_table = SLM_TBL_LIC_DEVICES;
|
||
$lic_log_tbl = SLM_TBL_LIC_LOG;
|
||
$lic_emails_table = SLM_TBL_EMAILS;
|
||
|
||
$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";
|
||
}
|
||
|
||
$lk_tbl_sql = "CREATE TABLE " . $lic_key_table . " (
|
||
id int(12) NOT NULL auto_increment,
|
||
license_key varchar(255) NOT NULL,
|
||
max_allowed_domains int(40) NOT NULL,
|
||
max_allowed_devices int(40) NOT NULL,
|
||
lic_status ENUM('pending', 'active', 'blocked', 'expired') NOT NULL DEFAULT 'pending',
|
||
lic_type ENUM('none', 'subscription', 'lifetime') NOT NULL DEFAULT 'subscription',
|
||
first_name varchar(32) NOT NULL default '',
|
||
last_name varchar(32) NOT NULL default '',
|
||
email varchar(64) NOT NULL,
|
||
company_name varchar(100) NOT NULL default '',
|
||
txn_id varchar(64) NOT NULL default '',
|
||
manual_reset_count varchar(128) NOT NULL default '',
|
||
purchase_id_ varchar(255) NOT NULL default '',
|
||
date_created date NOT NULL DEFAULT '0000-00-00',
|
||
date_activated date NOT NULL DEFAULT '0000-00-00',
|
||
date_renewed date NOT NULL DEFAULT '0000-00-00',
|
||
date_expiry date NOT NULL DEFAULT '0000-00-00',
|
||
reminder_sent varchar(255) NOT NULL default '0',
|
||
reminder_sent_date date NOT NULL DEFAULT '0000-00-00',
|
||
product_ref varchar(255) NOT NULL default '',
|
||
until varchar(255) NOT NULL default '',
|
||
current_ver varchar(255) NOT NULL default '',
|
||
subscr_id varchar(128) NOT NULL default '',
|
||
PRIMARY KEY (id)
|
||
)" . $charset_collate . ";";
|
||
dbDelta($lk_tbl_sql);
|
||
|
||
|
||
|
||
$ld_tbl_sql = "CREATE TABLE " .$lic_domain_table. " (
|
||
id INT NOT NULL AUTO_INCREMENT ,
|
||
lic_key_id INT NOT NULL ,
|
||
lic_key varchar(255) NOT NULL ,
|
||
registered_domain text NOT NULL ,
|
||
registered_devices text NOT NULL ,
|
||
item_reference varchar(255) NOT NULL,
|
||
PRIMARY KEY ( id )
|
||
)" . $charset_collate . ";";
|
||
dbDelta($ld_tbl_sql);
|
||
|
||
|
||
$slm_emails_tbl = "CREATE TABLE " . $lic_emails_table . " (
|
||
id INT NOT NULL AUTO_INCREMENT ,
|
||
lic_key varchar(255) NOT NULL ,
|
||
sent_to varchar(255) NOT NULL ,
|
||
status varchar(255) NOT NULL ,
|
||
sent text NOT NULL ,
|
||
date_sent date NOT NULL DEFAULT '0000-00-00',
|
||
disable_notifications text NOT NULL ,
|
||
PRIMARY KEY ( id )
|
||
)" . $charset_collate . ";";
|
||
dbDelta($slm_emails_tbl);
|
||
|
||
|
||
$log_tbl_sql = "CREATE TABLE " . $lic_log_tbl . " (
|
||
id INT NOT NULL AUTO_INCREMENT ,
|
||
license_key varchar(255) NOT NULL ,
|
||
slm_action varchar(255) NOT NULL ,
|
||
time date NOT NULL DEFAULT '0000-00-00',
|
||
source varchar(255) NOT NULL ,
|
||
PRIMARY KEY ( id )
|
||
)" . $charset_collate . ";";
|
||
dbDelta($log_tbl_sql);
|
||
|
||
$ldv_tbl_sql = "CREATE TABLE " .$lic_devices_table. " (
|
||
id INT NOT NULL AUTO_INCREMENT ,
|
||
lic_key_id INT NOT NULL ,
|
||
lic_key varchar(255) NOT NULL ,
|
||
registered_devices text NOT NULL ,
|
||
registered_domain text NOT NULL ,
|
||
item_reference varchar(255) NOT NULL,
|
||
PRIMARY KEY ( id )
|
||
)" . $charset_collate . ";";
|
||
dbDelta($ldv_tbl_sql);
|
||
|
||
// Add default options
|
||
$options = array(
|
||
'lic_creation_secret' => SLM_Utility::create_secret_keys(),
|
||
'lic_prefix' => 'SLM-',
|
||
'default_max_domains' => '2',
|
||
'default_max_devices' => '2',
|
||
'lic_verification_secret' => SLM_Utility::create_secret_keys(),
|
||
'enable_debug' => '',
|
||
'slm_woo' => '',
|
||
'slm_wpestores' => '',
|
||
'slm_woo_downloads' => '',
|
||
'slm_dl_manager' => '',
|
||
'expiration_reminder_text' => 'Your account has reverted to Basic with limited functionality. Renew today to keep using it on all of your devices and enjoy the valuable features. It’s a smart investment');
|
||
|
||
update_option('slm_plugin_options', $options);
|
||
update_option("slm_db_version", SLM_DB_VERSION); |
