Email List of Users from a phpBB v 3 forum

[RMcGirr83]

Many times, people ask "How can I get an email list of all the users on my forum?".

So I decided to write up a script. Part of the code was taken from [url=http://www.sixstringmods.co.uk/viewtopic.php?f=20&t=230]my pal Kenny's site[/url] (who, btw, is scared to death of gaming with me on the 360 cuz I pwn Scottish people ) and I have modified it a bit.

The mod will display a list of users to the founder of the board only and it looks like the attached

Noname.jpg

If you notice over by the pagination there is a link that states "Export as CSV list". If you click on it, the script will allow you to open the list in a csv file as per the attached.

csv_excel.jpg

which you can then mess around with to import into your email client program if you like.

This is for a prosilver based style only, there is no subsilver2 file (sorry subsilver2 lovers).

Anyway, take the attached zip and upload the files into your forum, then browse to the php file, eg

Code: Select all

http://rmcgirr83.org/list.php

and csv away.

email_list.zip

Enjoy the mod!!

[Chalong]

This is similar to djchrisnet's [removed]

[kevinviet]

thank you very much, I need this

[Oyabun1]

Love this and very simple to install.

Do have an issue with the csv file though. On my Win XP system when I download the csv file I’m assuming the filename should be: "sitename_e-mail_date.csv", but what I’m getting is a file called only the first word of the site name and with no file extension. If I add the extension “.csv” to it then it opens normally as a csv file and contains the expected data. Don't know what is going wrong there.

I also added a link to the list.php in the footer of the forum I put it on which I can add the instructions for here if you think it worthwhile.

[RMcGirr83]

What is the name of the site?

[douggg]

I'm new to PHPBB and mods. Can I get some instruction on how to install and how to use it?

Thanks

[RMcGirr83]

Unzip the file, then upload the files found under "root" into the root of your forum. So if your forum was at, say, http://somesite.com/forum, you would upload the files into the "forum" directory of your site keeping the directory structure.

You may also find these links to be helpful.

[url=http://www.phpbb.com/kb/article/how-to-install-mods/]Knowledge Base - How to Install MODs[/url]

[url=http://www.phpbb.com/kb/article/how-to-install-a-modx-modification/]Knowledge Base - How to install a MODX Modification[/url]

[Oyabun1]

What is the name of the site?

Samurai Kids, so the downloaded file is just Samurai, nothing else and no extension.

[RMcGirr83]

There is a space in the name?

Try replacing this in list.php

Code: Select all

        header("Content-disposition:  attachment; filename=" . $config['sitename'] . "_Email_List_" .date("Y-m-d").".csv");

with this

Code: Select all

        header("Content-disposition:  attachment; filename=" . str_replace(" ", "_", $config['sitename']) . '_' . $user->lang['EMAIL'] . 's_' . date("Y-m-d").".csv");

Download updated.

[Oyabun1]

Thanks. That fixed it. :woot:

[Blackwolf_Oz]

Very late to post after the last user...but what a fantastic find!!!!
Now if.....( when says all here ) the forum crashes....I now have all emails saved

Thanks so much for all the great mods RMcGirr83 :rock:

[Ooopsie]

This is similar to djchrisnet's [removed]

Hi Chalong! Wie?

I checked out the MOD you pointed to. These two MODS are not even close. The German version you pointed to adds 5 files to your system.

Rich's adds ONE file. Nix in the ACP and is simple for everybody (they are both simple actually) but I personally prefer not adding more files than need be.

They are both good MODS but I believe in K.I.S.S. (Keep It Simple Stupid).

Thanks for sharing the other MOD with us.

PS: I may be slightly partial to Rich's MODS. I KNOW they work and if not, Rich takes care of it ASAP.

[Oyabun1]

I checked out the MOD you pointed to. These two MODS are not even close.

They are similar in that they both produce a listing of members' email addresses, although methods and features to achieve that may differ.

However, given that Chalong's post was more than a year ago, not sure a lot will be gained by discussing it now.

[Ooopsie]

I know how old the post was... It was just a statement and something that I missed... I just wanted to point it out. It gets boring some time ya' know...

Thanks though.

EDIT: Oh geeeeezzz... I thought it said March 2011...

[UnknownTBeast]

Works great with 3.0.9!

Question though, as I was able to change the display setting on how many users are displayed in the list.php file, is there a similar change I could make so that it ignores users in a particular group name? We have an "Idiot" group for those who constantly break the rules and what not, and I want to send mass email, but excluding them.