The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
How do I generate a mailing list with username and email? I would like to select all users that meet a certain criteria (from the userfield table) and then create a csv file with their username;emailaddress.
Is this possible within the admincp? If not, how would I go about doing it? Thanks, -Chris vbulletin 3.5.2 |
#2
|
|||
|
|||
![]()
>> Admincp >> Users >> Send Email to Users >> that's it!
and btw, this is not a hack, when you need help with the current vBulletin, go to http://vbulletin.com/forum/ for support! |
#3
|
|||
|
|||
![]()
No, thats *not* what I want. I want a CSV file with a username and a email address. I am not trying to immediately send an email to these people. I am trying to import the list into another newlsetter program.
Thanks, -Chris |
#4
|
|||
|
|||
![]()
I attached a file of a quick little script to do this for you..
Put emaillist.php in your forum's home directory. Add a template to the style you use on your forum called "email_listbit" and add the following to that new email_listbit template: Code:
$email_list[username],$email_list[email]<br> This is just a quick script I wrote for you nothing fancy, only works for someone whose in the administrator group (group id 6). Hope this helps. Joel |
#5
|
|||
|
|||
![]()
Joel, thanks for taking the time to do that for me. However, I really need it to be able to select a certain criteria in the userfield table. I'm trying create multiple (4) mailing lists based on this data.
Is there any way you could modify the script to do that? If it helps, the field in the table userfield that criteria im using is field10 and the data in field10 that I'm looking for is 'US History' (without the 's) Thanks again, -Chris |
#6
|
|||
|
|||
![]()
You said there was 4 different criteria to query for, you only gave me one. What are the other 3?
It's a quick edit, just let me know. |
#7
|
|||
|
|||
![]()
US History
US Government and Politics Psychology European History Economics so make that 5 actually, sorry -Chris |
#8
|
|||
|
|||
![]()
Ok here's a modified version. I didn't need your criteria, as I was thinking for whatever strange reason...
It'll have a form, in fact, you'll need to add another template: email_list with the following in it: Code:
<form action="emaillist.php" method="post"> Field Number: <input type="text" name="fieldnum" value="10"><br /> What to search for: <input type="text" name="input" value=""><br /> <input type="submit"> </form> $email_bits Replace emaillist.php that I attached, overwrite the old one. Type in the field number (default is 10 for you) and then type in the search field the string you want to look for. It will be case senstive in the search string. Joel |
#9
|
|||
|
|||
![]()
I hate to sound like an idiot, but how do I access the script? I tried to open the url but all i got was a blank page. Should i be trying to open it another way? I am logged in as the admin user.
Thanks again for doing this, you dont know how much I appreciate it! -Chris |
#10
|
|||
|
|||
![]()
Did you add the two templates (email_list and email_listbit) to your template style?
To access it www.yoursite.com/forum/emaillist.php should do it. I may not be able to help you more on this until tomorrow. Joel |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|