function seed_cspv4_emaillist_database_add_subscriber()
{
require_once SEED_CSPV4_PLUGIN_PATH . 'lib/nameparse.php';
// Get Settings
global $seed_cspv4, $seed_cspv4_post_result;
extract($seed_cspv4);
$o = $seed_cspv4;
// Record reference
$ref = '-1';
if (!empty($_REQUEST['ref'])) {
$ref = intval($_REQUEST['ref'], 36) - 1000;
}
$name = '';
if (!empty($_REQUEST['name'])) {
$name = $_REQUEST['name'];
}
$email = strtolower($_REQUEST['email']);
$fname = '';
$lname = '';
if (!empty($name)) {
$name = seed_cspv4_parse_name($name);
$fname = $name['first'];
$lname = $name['last'];
}
// Record user in DB if they do not exist
global $wpdb;
$tablename = $wpdb->prefix . SEED_CSPV4_TABLENAME;
$sql = "SELECT * FROM {$tablename} WHERE email = %s";
$safe_sql = $wpdb->prepare($sql, $email);
$select_result = $wpdb->get_row($safe_sql);
if (empty($select_result->email) || $select_result->email != $email) {
$values = array('email' => $email, 'referrer' => $ref, 'ip' => seed_cspv4_get_ip(), 'fname' => $fname, 'lname' => $lname);
$format_values = array('%s', '%d', '%s', '%s', '%s');
$insert_result = $wpdb->insert($tablename, $values, $format_values);
// Record ref
if (!empty($ref)) {
$sql = "UPDATE {$tablename} SET conversions = conversions + 1 WHERE id = %d";
$safe_sql = $wpdb->prepare($sql, $ref);
$update_result = $wpdb->get_var($safe_sql);
}
}
if (isset($insert_result) && $insert_result != false) {
// Send notice if a new subscriber.
if ($emaillist == 'database' && !empty($database_notifications)) {
$message = home_url() . __(" You have a new email subscriber: ", 'seedprod') . $fname . ' ' . $lname . ' ' . $email;
$mresult = '';
if (empty($database_notifications_emails)) {
$mresult = wp_mail(get_option('admin_email'), home_url() . __(' : New Email Subscriber', 'seedprod'), $message);
} else {
$mresult = wp_mail($database_notifications_emails, home_url() . __(' : New Email Subscriber', 'seedprod'), $message);
}
}
//var_dump($mresult);
if (empty($seed_cspv4_post_result['status'])) {
$seed_cspv4_post_result['status'] = '200';
}
$ref = $wpdb->insert_id + 1000;
$seed_cspv4_post_result['ref'] = base_convert($ref, 10, 36);
$seed_cspv4_post_result['ref_url'] = seed_cspv4_ref_link();
} else {
// Subscriber already exist show stats
$seed_cspv4_post_result['status'] = '200';
$seed_cspv4_post_result['msg'] = $txt_already_subscribed_msg;
$seed_cspv4_post_result['msg_class'] = 'alert-info';
$ref = $select_result->id + 1000;
$seed_cspv4_post_result['ref'] = base_convert($ref, 10, 36);
$seed_cspv4_post_result['clicks'] = '0';
if (!empty($select_result->clicks)) {
$seed_cspv4_post_result['clicks'] = $select_result->clicks;
}
$seed_cspv4_post_result['subscribers'] = '0';
if (!empty($select_result->conversions)) {
$seed_cspv4_post_result['subscribers'] = $select_result->conversions;
}
// Conditional Stats
$rf_url = '';
$rf_stats = '';
if ($enable_reflink && !empty($seed_cspv4_post_result['ref'])) {
$rf_url = "<br><br>" . $txt_stats_referral_url . '<br>' . seed_cspv4_ref_link();
$rf_stats = '<br><br>' . $txt_stats_referral_stats . '<br>' . $txt_stats_referral_clicks . ': ' . $seed_cspv4_post_result['clicks'] . '<br>' . $txt_stats_referral_subscribers . ': ' . $seed_cspv4_post_result['subscribers'];
$seed_cspv4_post_result['msg'] .= $rf_url . $rf_stats;
}
}
}
function seed_cspv4_socialshares($echo = true)
{
global $seed_cspv4, $seed_cspv4_post_result;
$seed_cspv4 = get_option('seed_cspv4');
extract($seed_cspv4);
$is_post = false;
if (!empty($seed_cspv4_post_result['status']) && $seed_cspv4_post_result['status'] == '200') {
$is_post = true;
}
$output = '';
if ($is_post || $show_sharebutton_on_front) {
$ref_link = seed_cspv4_ref_link();
if (!empty($share_buttons)) {
if (isset($share_buttons['facebook']) && $share_buttons['facebook'] == '1' || isset($share_buttons['facebook_send']) && $share_buttons['facebook_send'] == '1') {
$output .= '
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.4";
fjs.parentNode.insertBefore(js, fjs);
}(document, \'script\', \'facebook-jssdk\'));</script>
';
}
$output .= '<ul id="cspv4-sharebuttons">';
if (isset($share_buttons['twitter']) && $share_buttons['twitter'] == '1') {
$output .= '<li id="share_twitter"><a id="twitter-tweet-btn" class="twitter-share-button" data-url="' . $ref_link . '" data-text="' . esc_attr($tweet_text) . '" data-count="none">Tweet</a>';
$output .= '<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script></li>';
}
if (isset($share_buttons['facebook']) && $share_buttons['facebook'] == '1') {
$output .= '<li id="share_facebook"><div class="fb-share-button" data-href="' . $ref_link . '" data-type="button"></div></li>';
}
if (isset($share_buttons['facebook_send']) && $share_buttons['facebook_send'] == '1') {
$output .= '<span id="share_facebook_send"><div class="fb-send" data-href="' . $ref_link . '" data-layout="button_count"></div></span>';
}
if ($share_buttons['googleplus'] == '1') {
$output .= '<li id="share_googleplus"><div class="g-plusone" data-size="medium" data-annotation="none" data-href="' . $ref_link . '"></div>';
$output .= '<script type="text/javascript">
(function() {
var po = document.createElement(\'script\'); po.type = \'text/javascript\'; po.async = true;
po.src = \'https://apis.google.com/js/platform.js\';
var s = document.getElementsByTagName(\'script\')[0]; s.parentNode.insertBefore(po, s);
})();
</script></li>';
}
if (isset($share_buttons['linkedin']) && $share_buttons['linkedin'] == '1') {
$output .= '<li id="share_linkedin"><script src="//platform.linkedin.com/in.js" type="text/javascript"></script>';
$output .= '<script type="IN/Share" data-url="' . $ref_link . '"></script></li>';
}
if (isset($share_buttons['pinterest']) && $share_buttons['pinterest'] == '1') {
$output .= '<li id="share_pinterest"><a href="http://pinterest.com/pin/create/button/?url=' . urlencode($ref_link) . '&media=' . esc_url($pinterest_thumbnail['url']) . '&description=' . esc_attr($seo_description) . '" class="pin-it-button" count-layout="horizontal"><img border="0" src="//assets.pinterest.com/images/PinExt.png" title="Pin It" /></a>';
$output .= '<script type="text/javascript" src="//assets.pinterest.com/js/pinit.js"></script></li>';
}
// if($share_buttons['stumbledupon'] == '1'){
// $output .= '<li id="share_stumbledupon"><su:badge layout="3"></su:badge>';
// $output .= '<script type="text/javascript">
// (function() {
// var li = document.createElement(\'script\'); li.type = \'text/javascript\'; li.async = true;
// li.src = \'https://platform.stumbleupon.com/1/widgets.js\';
// var s = document.getElementsByTagName(\'script\')[0]; s.parentNode.insertBefore(li, s);
// })();
// </script></li>';
// }
if (isset($share_buttons['tumblr']) && $share_buttons['tumblr'] == '1') {
$output .= '<li id="share_tumblr">';
$output .= '<a href="http://www.tumblr.com/share/link?url=' . urlencode($ref_link) . '" title="Share on Tumblr" style="display:inline-block; text-indent:-9999px; overflow:hidden; width:81px; height:20px; background:url(\'//platform.tumblr.com/v1/share_1.png\') top left no-repeat transparent;">Share on Tumblr</a><script type="text/javascript" src="//platform.tumblr.com/v1/share.js"></script></li>';
}
$output .= '</ul>';
}
}
$output = apply_filters('seed_cspv4_socialshares', $output);
if ($echo) {
echo $output;
} else {
return $output;
}
}
