Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 28 May 2010, 19:48
Gnappy Gnappy is offline
 
Join Date: Sep 2003
Extract email addresses from DB

Hello guys,
I need to improve my newsletter system due the vb default one is very painful...
So the first step is obtain and collect all the users email addresses from my DB. I thought there was a "simply hack" to do this but after many googling and searching here on vb.org I found NOTHING.

I know I could get them from the DB but for particular reasons I cannot connect to the sql server by remote and, of course, I am not skilled enough to make a query that does a simple list(ehh lol )..

Can someone help me? Any kind of help will be very appreciated!

--------------- Added 28 May 2010 at 19:55 ---------------

I think a query like this could work but my problem of remote connection still exists, so..


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Last edited by Gnappy; 28 May 2010 at 19:55. Reason: Auto-Merged DoublePost
Reply With Quote
  #2  
Old 28 May 2010, 19:55
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by Gnappy View Post
Hello guys,
I need to improve my newsletter system due the vb default one is very painful...
So the first step is obtain and collect all the users email addresses from my DB. I thought there was a "simply hack" to do this but after many googling and searching here on vb.org I found NOTHING.

I know I could get them from the DB but for particular reasons I cannot connect to the sql server by remote and, of course, I am not skilled enough to make a query that does a simple list(ehh lol )..

Can someone help me? Any kind of help will be very appreciated!
Do you want only the email addresses or the usernames associated with those email addresses as well?

Anyway, to get only the emails run this query at the SQL tab at your phpmyadmin:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

To get the email addresses and the usernames associated with those email addresses, run this query instead:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

If your db tables have prefix, include that as in well in the query.
__________________
My mods.
Reply With Quote
  #3  
Old 28 May 2010, 20:06
Gnappy Gnappy is offline
 
Join Date: Sep 2003
Thanks borbole for your assistance!

To be honest I had already found this kind of solution(at the upper link) but I was concentrated to have the remote mysql access(denied for some reasons).... My solution was clear and veryvery easy:
run that query via acp(Maintenance --> Execute SQL Query)

By the way thanks borbole, I hope this will help others with the same issue
Reply With Quote
  #4  
Old 28 May 2010, 20:14
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Glad to hear that you got it solved. I forgot totally about the option to run queries from the acp.
__________________
My mods.
Reply With Quote
  #5  
Old 09 Oct 2010, 21:34
terracore terracore is offline
 
Join Date: Dec 2007
Thanks guys for the posts/thread. It solved my problem.
Reply With Quote
  #6  
Old 23 Mar 2011, 23:37
Gnappy Gnappy is offline
 
Join Date: Sep 2003
Hi guys,
sorry for bump again this thread (started by me ) but I have a question..

I wanna extract from my db just users that have activated its account by email.
I thought to run a query like this:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

or a code like this:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This code is NOT correct but is just to explain my idea, if it's correct..

Sadly I don't know the vbulletin DB diagram (also googled a lot), can someone help me?

Thanks in advance!

--------------- Added 24 Mar 2011 at 07:55 ---------------

Up!


It is very strange that none is interested to extract usename and emails fro the DB to make newsletter with an external software. The common documentation about this is strongly poor...

Last edited by Gnappy; 24 Mar 2011 at 07:55. Reason: Auto-Merged DoublePost
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Administrative and Maintenance Tools Email Rules - Require that users' email addresses match a regular expression Analogpoint vBulletin 3.8 Add-ons 15 03 May 2013 14:26



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:20.

Layout Options | Width: Wide Color: