1#@!#!123s

: / home / ltfsolutionsco / www / wp-content / plugins / email-newsletter / export /
Filename : export-subscriber-show.php
back
<?php if(preg_match('#' . basename(__FILE__) . '#', $_SERVER['PHP_SELF'])) { die('You are not allowed to call this page directly.'); } ?>
<script language="javascript" src="<?php echo get_option('siteurl'); ?>/wp-content/plugins/email-newsletter/export/export-setting.js"></script>
<?php
if (!session_id())
{
    session_start();
}

$_SESSION['exportcsv'] = "YES"; 

$cnt_subscriber = 0;
$cnt_users = 0;
$cnt_comment_author = 0;
$cnt_subscriber = $wpdb->get_var("select count(DISTINCT eemail_email_sub) from " . WP_eemail_TABLE_SUB);
$cnt_users = $wpdb->get_var("select count(DISTINCT user_email) from ". $wpdb->prefix . "users");
$cnt_comment_author = $wpdb->get_var("SELECT count(DISTINCT comment_author_email) from ". $wpdb->prefix . "comments WHERE comment_author_email <> ''");
if(strtoupper($wpdb->get_var("show tables like '". WP_eemail_TABLE_SCF . "'")) == strtoupper(WP_eemail_TABLE_SCF))  
{
	$cnt_contact_form = $wpdb->get_var("select count(DISTINCT gCF_email) from " . WP_eemail_TABLE_SCF);
}
else
{
	$cnt_contact_form = "NA";
}
?>

<div class="wrap">
  <div id="icon-plugins" class="icon32"></div>
  <h2><?php _e(WP_eemail_TITLE, 'email-newsletter'); ?></h2>
  <h3><?php _e('Export email address in csv format', 'email-newsletter'); ?></h3>
  <div class="tool-box">
  <form name="frm_emailnewsletter" method="post">
  <table width="100%" class="widefat" id="straymanage">
    <thead>
      <tr>
        <th width="3%" class="check-column" scope="col"><input type="checkbox" name="eemail_group_item[]" /></th>
        <th width="5%" scope="col"><?php _e('Sno', 'email-newsletter'); ?></th>
        <th scope="col"><?php _e('Export option', 'email-newsletter'); ?></th>
		<th width="10%" scope="col"><?php _e('Total email', 'email-newsletter'); ?></th>
        <th width="10%" scope="col"><?php _e('Action', 'email-newsletter'); ?></th>
      </tr>
    </thead>
    <tfoot>
      <tr>
        <th width="3%" class="check-column" scope="col"><input type="checkbox" name="eemail_group_item[]" /></th>
        <th width="5%" scope="col"><?php _e('Sno', 'email-newsletter'); ?></th>
        <th scope="col"><?php _e('Export option', 'email-newsletter'); ?></th>
		<th width="10%" scope="col"><?php _e('Total email', 'email-newsletter'); ?></th>
        <th width="10%" scope="col"><?php _e('Action', 'email-newsletter'); ?></th>
      </tr>
    </tfoot>
    <tbody>
      <tr>
        <td><input type="checkbox" value="" name="eemail_group_item[]"></td>
        <td>1</td>
        <td><?php _e('Subscriber email address', 'email-newsletter'); ?></td>
		<td><?php echo $cnt_subscriber; ?></td>
        <td><a onClick="javascript:exportcsv('<?php echo $_SERVER["REQUEST_URI"]; ?>', 'view_subscriber')" href="javascript:void(0);"><?php _e('Click to export csv', 'email-newsletter'); ?></a> </td>
      </tr>
      <tr class="alternate">
        <td><input type="checkbox" value="" name="eemail_group_item[]"></td>
        <td>2</td>
        <td><?php _e('Registered email address', 'email-newsletter'); ?></td>
		<td><?php echo $cnt_users; ?></td>
        <td><a onClick="javascript:exportcsv('<?php echo $_SERVER["REQUEST_URI"]; ?>', 'registered_user')" href="javascript:void(0);"><?php _e('Click to export csv', 'email-newsletter'); ?></a> </td>
      </tr>
      <tr>
        <td><input type="checkbox" value="" name="eemail_group_item[]"></td>
        <td>3</td>
        <td><?php _e('Comments author email address', 'email-newsletter'); ?></td>
		<td><?php echo $cnt_comment_author; ?></td>
        <td><a onClick="javascript:exportcsv('<?php echo $_SERVER["REQUEST_URI"]; ?>', 'commentposed_user')" href="javascript:void(0);"><?php _e('Click to export csv', 'email-newsletter'); ?></a> </td>
      </tr>
      <tr class="alternate">
        <td><input type="checkbox" value="" name="eemail_group_item[]"></td>
        <td>4</td>
        <td><?php _e('Contact form email address', 'email-newsletter'); ?></td>
		<td><?php echo $cnt_contact_form; ?></td>
        <td>
		<?php if($cnt_contact_form <> 'NA') { ?>
		<a onClick="javascript:exportcsv('<?php echo $_SERVER["REQUEST_URI"]; ?>', 'contact_user')" href="javascript:void(0);"><?php _e('Click to export csv', 'email-newsletter'); ?></a> 
		<?php } else { echo $cnt_contact_form; } ?>
		</td>
      </tr>
    </tbody>
  </table>
  </form>
  <div class="tablenav">
	  <h2>
		<a class="button add-new-h2" href="<?php echo get_option('siteurl'); ?>/wp-admin/admin.php?page=view-subscriber&amp;ac=add"><?php _e('Add Email', 'email-newsletter'); ?></a> 
		<a class="button add-new-h2" href="<?php echo get_option('siteurl'); ?>/wp-admin/admin.php?page=view-subscriber&amp;ac=add"><?php _e('Import Email', 'email-newsletter'); ?></a> 
		<a class="button add-new-h2" target="_blank" href="<?php echo WP_eemail_FAV; ?>"><?php _e('Help', 'email-newsletter'); ?></a>
	  </h2>
  </div>
  <div style="height:10px;"></div>
  <p class="description"><?php echo WP_eemail_LINK; ?></p>
  </div>
</div>
Name	Size	Last Modified	Owner	Permissions
.htaccess	0.193 KB	June 03 2023 12:20:40	ltfsolutionsco	0644
export-setting.js	0.196 KB	April 20 2016 8:23:49	ltfsolutionsco	0755
export-setting.php	0.013 KB	April 20 2016 8:23:49	ltfsolutionsco	0755
export-subscriber-show.php	4.927 KB	April 20 2016 8:23:49	ltfsolutionsco	0755
index.html	0.043 KB	April 20 2016 8:23:49	ltfsolutionsco	0755
2017 © D7net \| D704T team