The secure CMS.

Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 07:34 am EST

Geeklog Forums

export email adress

 New Topic  Post Reply
 03/13/06 04:21am (Read 2,585 times)  

streamer

Anonymous
hello,
I find out that the Mail Utility within Geeklog is really slow when I send out mass emails to all users, thus I would like to export all email adresses from the whole user database. How can I do this? Is there any SQL command that reads out all adresses?

thank you for your help
 Quote
 03/13/06 04:36am  
Status: offline

kr

Forum User
Newbie
Registered: 03/02/06
Posts: 4
Location:Germany
Hi streamer,

getting all email addresses out of the database is really simple...

Just try this sql statement:
Text Formatted Code

SELECT email FROM `gl_users` WHERE email != 'NULL';


 
 Quote
 03/13/06 04:53am  

streamer

Anonymous
perfect! thx for your fast help, kr!!
 Quote
 03/13/06 07:45am  
Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
On the other hand it would be nice to understand IF and why geeklog is slow and what could be done against that.
 Quote
 03/13/06 02:21pm  
Status: offline

beewee

Forum User
Full Member
Registered: 08/05/03
Posts: 969
Location:The Netherlands, where else?
Especially Geeklog.net, which is awfully slow the last months..
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote
 03/13/06 02:52pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by streamer: I would like to export all email adresses from the whole user database.

phpMyAdmin can also export to CSV format, which may come in handy here.

bye, Dirk
 Quote
 New Topic  Post Reply
All times are EST. The time is now 07:34 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content