Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- header('Content-Type: application/csv');
- header('Content-Disposition: attachment; filename=member_export.csv');
- header('Pragma: no-cache');
- ?>
- {!--
- Exports the EE members in CSV format. This is only accessible to admins and editors.
- Does not export members in the banned or guests groups.
- --}
- {exp:ajw_export
- sql="SELECT exp_members.member_id AS member_id, exp_member_groups.group_title AS 'group', screen_name, email, m_field_id_12 AS address_city, m_field_id_15 AS address_country,m_field_id_10 AS address_line_1, m_field_id_11 AS address_line_2,m_field_id_13 AS address_state,m_field_id_14 AS address_zip,m_field_id_16 AS import_contributions,m_field_id_2 AS receive_promotions, FROM_UNIXTIME(join_date) AS join_date FROM exp_members, exp_member_data, exp_member_groups WHERE exp_member_data.member_id = exp_members.member_id AND exp_members.group_id = exp_member_groups.group_id AND exp_members.group_id NOT IN (2,3)"
- format="csv"
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement