[mod] Export Users without Blacklisted or Unconfirmed users

[WinstonN]

Hi guys,

Hope you are all having a wonderful day!
I have seen many problems and complaints from users that want to export users but they don't want the blacklisted or unconfirmed users in this export file, the csv.

I have made a small hack that will allow for this:

The file I edited was admin/export.php
Round about line 38 you will see this:

Code: Select all

case 'all':
    if ($list) {
      $querytables = $GLOBALS['tables']['user'].' user'.', '.$GLOBALS['tables']['listuser'].' listuser';
      $subselect = ' and listuser.userid = user.id ';
    } else {
      $querytables = $GLOBALS['tables']['user'].' user';
      $subselect = '';
    }


I then changed this line

Code: Select all

$subselect = '';


to

Code: Select all

$subselect = ' and user.blacklisted = 0 and user.confirmed = 1 ';


This then exports a clean list with ONLY confirmed and non blacklisted users

I will refine this a little later on to provide you with a tick box to export only blacklisted or un confirmed users.

Please let me know if this works for you,
Happy days to you fine peeps!

Wins

[maryline]

This works for me !

Now I need to export only blacklisted people...
I didn't check in the forum if it exists already.
But thanks for your hack

(sorry for my english, i'm french !)

[Guest]

Anybody knows how to export only "unconfirmed" users?

I REALLY need this, because i'm cleaning out my database.

I've tried with 'unconfirmed = 0'; but that doesn't work.

Help guys.. PLEASE!

[vancoovur]

I'm guessing you would change

Code: Select all

$subselect = ' and user.blacklisted = 0 and user.confirmed = 1 ';

To

Code: Select all

$subselect = ' and user.confirmed = 0 ';

although I haven't tried this.

[ThorstenAlbrecht]

Please let me know if this works for you,
Happy days to you fine peeps!

Thank you, very useful because export of blacklisted or unconfirmed users does not make any sense at all.

Thorsten

[ThorstenAlbrecht]

I just like to add something: If you want to export the users of a certain list (and not all users), you have to modify one more line in the same case statement:

in export.php:
original: (2.10.10)

Code: Select all

  case 'all':
    if ($list) {
      $querytables = $GLOBALS['tables']['user'].' user'.', '.$GLOBALS['tables']['listuser'].' listuser';
      $subselect = ' and listuser.userid = user.id ';
    } else {
      $querytables = $GLOBALS['tables']['user'].' user';

         $subselect = '';
    }


modified code

Code: Select all

  case 'all':
    if ($list) {
      $querytables = $GLOBALS['tables']['user'].' user'.', '.$GLOBALS['tables']['listuser'].' listuser';
//      $subselect = ' and listuser.userid = user.id ';
      $subselect = ' and listuser.userid = user.id  and user.blacklisted = 0 and user.confirmed = 1 ';
    } else {
      $querytables = $GLOBALS['tables']['user'].' user';

//         $subselect = '';
      $subselect = ' and user.blacklisted = 0 and user.confirmed = 1 ';
    }


Thorsten