function export_members_to_csv()
{
global $wpdb;
if (isset($_POST['wp_emember_export'])) {
$filename = "member_list_" . date("Y-m-d_H-i", time());
header('Content-Encoding: UTF-8');
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Description: File Transfer");
header('Content-Type: text/csv; charset=utf-8');
header("Content-disposition: attachment; filename=" . $filename . ".csv");
$output = apply_filters('emember_export_csv', '');
if (!empty($output)) {
header("Content-Length: " . strlen($output));
echo "";
echo $output;
exit;
}
ob_start();
$output_buffer = fopen("php://output", 'w');
$emember_config = Emember_Config::getInstance();
$wpememmeta = new WPEmemberMeta();
$member_meta_tbl = $wpememmeta->get_table('member_meta');
$customer_field_indices = array();
$member_table = $wpememmeta->get_table('member');
$ret_member_db = $wpdb->get_results("SELECT * FROM {$member_table} ORDER BY member_id DESC", OBJECT);
$header = array("User name", "First Name", "Last Name", "Street", "City", "State", "ZIP", "Country", "Email", "Phone", "Membership Start", "Membership Expiry", "Member Since", "Membership Level", "Account State", "Last Accessed", "Last Accessed From IP", "Gender", "Referrer", "Reg Code", "Txn ID", "Subscr ID", "Company");
if ($emember_config->getValue('eMember_custom_field')) {
$custom_fields = get_option('emember_custom_field_type');
$custom_names = $custom_fields['emember_field_name'];
$custom_types = $custom_fields['emember_field_type'];
$custom_extras = $custom_fields['emember_field_extra'];
if (count($custom_names) > 0) {
foreach ($custom_names as $i => $name) {
$name = stripslashes($name);
$customer_field_indices[$i] = emember_escape_custom_field($name);
array_push($header, $name);
}
}
}
fputcsv($output_buffer, $header);
$membership_levels = Emember_Level_Collection::get_instance();
$order = array('user_name', 'first_name', 'last_name', 'address_street', 'address_city', 'address_state', 'address_zipcode', 'country', 'email', 'phone', 'subscription_starts', 'expiry_date', 'member_since', 'alias', 'account_state', 'last_accessed', 'last_accessed_from_ip', 'gender', 'referrer', 'reg_code', 'txn_id', 'subscr_id', 'company_name');
foreach ($ret_member_db as $result) {
$level = $membership_levels->get_levels($result->membership_level);
$data = array();
foreach ($order as $key) {
switch ($key) {
case 'alias':
$value = empty($level) || is_array($level) ? '' : escape_csv_value(stripslashes($level->get('alias')));
break;
case 'expiry_date':
$value = emember_get_expiry_by_member_id($result->member_id);
$value = escape_csv_value(stripslashes($value));
break;
default:
$value = escape_csv_value(stripslashes($result->{$key}));
break;
}
array_push($data, $value);
}
if ($emember_config->getValue('eMember_custom_field')) {
$custom_values = $wpdb->get_col("select meta_value from " . $member_meta_tbl . ' WHERE user_id=' . $result->member_id . ' AND meta_key="custom_field"');
$custom_values = unserialize(isset($custom_values[0]) ? $custom_values[0] : "");
foreach ($customer_field_indices as $i => $n) {
$v = isset($custom_values[$n]) ? $custom_values[$n] : "";
if ($custom_types[$i] == 'dropdown') {
$m = explode(",", stripslashes($custom_extras[$i]));
$e = array();
foreach ($m as $k) {
$k = explode("=>", $k);
$e[$k[0]] = $k[1];
}
$v = isset($e[$v]) ? $e[$v] : "";
}
$value = escape_csv_value(stripslashes($v));
array_push($data, $value);
}
}
fputcsv($output_buffer, $data);
}
fclose($output_buffer);
$output = ob_get_clean();
header("Content-Length: " . strlen($output));
echo "";
echo $output;
exit;
}
}
$counter = $counter + 1;
}
$breadcrumbs[$categoryId]['breadcrumb'] = $breadcrumbdesc;
}
//Determine File Delimiter
$filedelim = ',';
if (isset($_GET['filedelim'])) {
$filedelim = $_GET['filedelim'];
}
//Build CSV Header
$row = '';
$row[] = escape_csv_value("id");
$row[] = escape_csv_value("parentId");
$row[] = escape_csv_value("name");
$row[] = escape_csv_value("url");
$row[] = escape_csv_value("thumbnailURL");
$row[] = escape_csv_value("breadcrumb");
$header = join($filedelim, $row) . "\n";
//Build CSV Data
$data = '';
foreach ($categories as $category) {
$row = '';
$row[] = escape_csv_value($category['id']);
$row[] = escape_csv_value($category['parentId']);
$row[] = escape_csv_value($category['name']);
$row[] = escape_csv_value($category['url']);
$row[] = escape_csv_value($category['thumbnailURL']);
$row[] = escape_csv_value($breadcrumbs[strval($category['id'])]['breadcrumb']);
$data .= join($filedelim, $row) . "\n";
}
echo $header . $data;
$results = mysql_query($sql);
$numberFields = mysql_num_fields($results);
$keys = "";
for ($i = 0; $i < $numberFields; $i++) {
$keys[] = mysql_field_name($results, $i);
// Create array of the names for the loop of data below
$head[] = escape_csv_value(mysql_field_name($results, $i));
// Create and escape the headers for each column, this is the field name in the database
}
$contents_checkins_lifetime = "id,last_name,first_name,company,sign_in_method,sign_in,time,location_id,plan_code\n";
if (mysql_num_rows($results) > 0) {
//while ($row = mysql_fetch_assoc($results)) {
while ($info = mysql_fetch_object($results)) {
foreach ($keys as $fieldName) {
// Loop through the array of headers as we fetch the data
$item[] = escape_csv_value($info->{$fieldName});
}
// End loop
$contents_checkins_lifetime .= join(',', $item) . "\n";
// Create a new row of data and append it to the last row
$item = '';
// Clear the contents of the $row variable to start a new row
//$contents_checkins .= implode(",",$row);
//$contents_checkins .="\n";
// write line of csv file
}
// end while
$msg .= "Checkins Lifetime successful\n";
} else {
$contents_checkins_lifetime .= "no checkins Lifetime,";
$msg .= "Checkins Today Lifetime (No Results)\n";
mysql_select_db(DB_NAME, $con);
// gather list of all accounts in the system
try {
if (isset($_GET['start'])) {
$start = $_GET['start'];
} else {
$start = 0;
}
$end = $start + 25;
$sql = "select * from v_user_data_dump LIMIT {$start}, {$end}";
$results = mysql_query($sql);
$numberFields = mysql_num_fields($results);
for ($i = 0; $i < $numberFields; $i++) {
$keys[] = mysql_field_name($results, $i);
// Create array of the names for the loop of data below
$head[] = escape_csv_value(mysql_field_name($results, $i));
// Create and escape the headers for each column, this is the field name in the database
}
$contents_users = "id,company_id,name,rfid,wp_users_id,date_added,membership_status,referrer,twitter,behance,membership_id,plan_code,plan_state,quantity,activated_at,expires_at,canceled_at,current_period_started_at,current_period_ends_at,address\n";
if (mysql_num_rows($results) > 0) {
echo '<style type="text/css"> td { text-align:center; }</style>';
echo '<div style="margin:0 auto; width:940px; padding:0 20px 20px 20px; margin-top:100px;">';
echo '<table style="width:100%;">' . "\n";
echo '<tr>
<th>Subscriber name</th>
<th>Membership Plan</th>
<th>Recurly Balance</th>
</tr>';
//while ($row = mysql_fetch_assoc($results)) {
while ($info = mysql_fetch_object($results)) {
#print_r($info);
