"off", 'mailboxmarketing_userid' => "", 'mailboxmarketing_listid' => "", 'mailboxmarketing_email' => "", 'mailboxmarketing_first_name' => "{subscription-name}", 'mailboxmarketing_last_name' => "" ); function __construct() { if (is_admin()) { add_action('ulp_popup_options_integration_show', array(&$this, 'popup_options_show')); add_filter('ulp_popup_options_check', array(&$this, 'popup_options_check'), 10, 1); add_filter('ulp_popup_options_populate', array(&$this, 'popup_options_populate'), 10, 1); add_filter('ulp_popup_options_tabs', array(&$this, 'popup_options_tabs'), 10, 1); } add_action('ulp_subscribe', array(&$this, 'subscribe'), 10, 2); } function popup_options_tabs($_tabs) { if (!array_key_exists("integration", $_tabs)) $_tabs["integration"] = __('Integration', 'ulp'); return $_tabs; } function popup_options_show($_popup_options) { global $ulp, $wpdb; $popup_options = array_merge($this->default_popup_options, $_popup_options); echo '

'.__('Mailbox Marketing Parameters', 'ulp').'

'; if (class_exists('Mailbox_Marketing')) { $current_user = wp_get_current_user(); $user_id = $current_user->ID; $lists = $wpdb->get_results('SELECT id, list_name FROM '.$wpdb->prefix.'mailbox_marketing_lists WHERE user_id = '.intval($user_id).' ORDER BY id DESC', ARRAY_A); if (sizeof($lists) == 0) { echo ' '; } else { echo ' '; } } else { echo ' '; } echo '

'.__('Enable Mailbox Marketing', 'ulp').': '.__('Please', 'ulp').' '.__('create', 'ulp').' '.__('at least one list.', 'ulp').'

'.__('Enable Mailbox Marketing', 'ulp').': '.__('Submit contact details to Mailbox Marketing', 'ulp').'
'.__('Please tick checkbox if you want to submit contact details to Mailbox Marketing.', 'ulp').'

'.__('List ID', 'ulp').': '.__('Select your List ID.', 'ulp').'

'.__('Fields', 'ulp').':

'.__('Please adjust the fields below. You can use the same shortcodes ({subscription-email}, {subscription-name}, etc.) to associate Mailbox Marketing fields with the popup fields.', 'ulp').'

'.__('E-mail', 'ulp').':	'.__('E-mail address.', 'ulp').'
'.__('First name', 'ulp').':	'.__('First name.', 'ulp').'
'.__('Last name', 'ulp').':	'.__('Last name.', 'ulp').'

'.__('Enable Mailbox Marketing', 'ulp').': '.__('Please install and activate Mailbox Marketing plugin.', 'ulp').'

'; } function popup_options_check($_errors) { global $ulp; $errors = array(); $popup_options = array(); foreach ($this->default_popup_options as $key => $value) { if (isset($ulp->postdata['ulp_'.$key])) { $popup_options[$key] = stripslashes(trim($ulp->postdata['ulp_'.$key])); } } if (isset($ulp->postdata["ulp_mailboxmarketing_enable"])) $popup_options['mailboxmarketing_enable'] = "on"; else $popup_options['mailboxmarketing_enable'] = "off"; if ($popup_options['mailboxmarketing_enable'] == 'on') { if (empty($popup_options['mailboxmarketing_listid'])) $errors[] = __('Invalid Mailbox Marketing List ID.', 'ulp'); } return array_merge($_errors, $errors); } function popup_options_populate($_popup_options) { global $ulp; $popup_options = array(); foreach ($this->default_popup_options as $key => $value) { if (isset($ulp->postdata['ulp_'.$key])) { $popup_options[$key] = stripslashes(trim($ulp->postdata['ulp_'.$key])); } } if (isset($ulp->postdata["ulp_mailboxmarketing_enable"])) $popup_options['mailboxmarketing_enable'] = "on"; else $popup_options['mailboxmarketing_enable'] = "off"; return array_merge($_popup_options, $popup_options); } function subscribe($_popup_options, $_subscriber) { global $ulp, $wpdb; if (empty($_subscriber['{subscription-email}'])) return; $popup_options = array_merge($this->default_popup_options, $_popup_options); if (class_exists('Mailbox_Marketing')) { if ($popup_options['mailboxmarketing_enable'] == 'on') { $list = $wpdb->get_results("SELECT id, list_name FROM ".$wpdb->prefix."mailbox_marketing_lists WHERE user_id = '".intval($popup_options['mailboxmarketing_userid'])."' AND id = '".intval($popup_options['mailboxmarketing_listid'])."'", ARRAY_A); if (!empty($list)) { try { $check = $wpdb->get_var("SELECT count(*) FROM ".$wpdb->prefix."mailbox_marketing_list_subscribers WHERE user_id = '".intval($popup_options['mailboxmarketing_userid'])."' AND list_id = '".intval($popup_options['mailboxmarketing_listid'])."' AND email_address = '".esc_sql($_subscriber['{subscription-email}'])."'"); if ($check > 0) { $sql = "UPDATE ".$wpdb->prefix."mailbox_marketing_list_subscribers SET first_name = '".esc_sql(strtr($popup_options['mailboxmarketing_first_name'], $_subscriber))."', last_name = '".esc_sql(strtr($popup_options['mailboxmarketing_last_name'], $_subscriber))."' WHERE user_id = '".intval($popup_options['mailboxmarketing_userid'])."' AND list_id = '".intval($popup_options['mailboxmarketing_listid'])."' AND email_address = '".esc_sql($_subscriber['{subscription-email}'])."'"; } else { $sql = "INSERT INTO ".$wpdb->prefix."mailbox_marketing_list_subscribers ( user_id, list_id, first_name, last_name, email_address) VALUES ( '".intval($popup_options['mailboxmarketing_userid'])."', '".intval($popup_options['mailboxmarketing_listid'])."', '".esc_sql(strtr($popup_options['mailboxmarketing_first_name'], $_subscriber))."', '".esc_sql(strtr($popup_options['mailboxmarketing_last_name'], $_subscriber))."', '".esc_sql($_subscriber['{subscription-email}'])."')"; } $wpdb->query($sql); } catch (Exception $e) { } } } } } } $ulp_mailboxmarketing = new ulp_mailboxmarketing_class(); ?>