Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Need help with email.php Details »»
Need help with email.php
Version: , by Parker Clack Parker Clack is offline
Developer Last Online: Nov 2013 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 04-23-2002 Last Update: Never Installs: 0
 
No support by the author.

In admin/email.php you can generate a mailing list but I would also like for a text file to be written at the same time it is creating the list.

The fetch array is:

$users=$DB_site->query("SELECT email FROM user WHERE $condition AND adminemail=1");
while ($user=$DB_site->fetch_array($users)) {

echo $user[email].$septext;

flush();

}

}

What could I put in here so that it captures all the $user[email]
and writes it to a text file with today's date?

Thanks,
Parker

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 04-23-2002, 04:19 PM
Sparkz's Avatar
Sparkz Sparkz is offline
 
Join Date: Nov 2001
Posts: 544
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
$users=$DB_site->query("SELECT email FROM user WHERE $condition AND adminemail=1");

unset (
$mailinglist);
while (
$user=$DB_site->fetch_array($users)) {
  echo 
$user[email].$septext;
  
$mailinglist .= $user[email].$septext;
  
flush(); 
}

$mailpath "/path/to/dir/writable/by/webserver/";
$mailpath .= date('Y-m-d'time()) . ".txt";

writetofile ($mailpath$mailinglist); 
This should work - in theory.
writetofile() is a function in adminfunctions.php, which I have never used before. I just noticed while browsing the file.

Another possible way could be:

PHP Code:
$users=$DB_site->query("SELECT email FROM user WHERE $condition AND adminemail=1");

$mailpath "/path/to/dir/writable/by/webserver/";
$mailpath .= date('Y-m-d'time()) . ".txt";

$fp fopen($mailpath'w');

unset (
$mailinglist);
while (
$user=$DB_site->fetch_array($users)) {
  echo 
$user[email].$septext;
  
$buf $user[email].$septext;
  
fputs ($fp$buf);
  
flush(); 
}
fclose ($mailpath); 
Both of these are untested, they are just suggestions as usual.
Reply With Quote
  #3  
Old 04-23-2002, 05:35 PM
Parker Clack Parker Clack is offline
 
Join Date: Oct 2001
Posts: 351
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sparkz:

The second example works great. The only problem is that the line breaks are put into the .txt file as <br>. What would you recommend using to put a line break between each email address in the resultant .txt file?

Parker
Reply With Quote
  #4  
Old 04-23-2002, 06:04 PM
Sparkz's Avatar
Sparkz Sparkz is offline
 
Join Date: Nov 2001
Posts: 544
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:

$users
=$DB_site->query("SELECT email FROM user WHERE $condition AND adminemail=1");

$mailpath "/path/to/dir/writable/by/webserver/";
$mailpath .= date('Y-m-d'time()) . ".txt";

$fp fopen($mailpath'w');

unset (
$mailinglist);
while (
$user=$DB_site->fetch_array($users)) {
  echo 
$user[email].$septext;
  
$buf $user[email] . "\n";
  
fputs ($fp$buf);
  
flush(); 
}
fclose ($mailpath); 
Try this...
Reply With Quote
  #5  
Old 04-23-2002, 07:25 PM
Parker Clack Parker Clack is offline
 
Join Date: Oct 2001
Posts: 351
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sparkz:

Thanks. That is so weird because I had tried adding the /n but it didn't work. Now it does though.

Thanks again.

Parker
Reply With Quote
  #6  
Old 04-23-2002, 07:34 PM
Sparkz's Avatar
Sparkz Sparkz is offline
 
Join Date: Nov 2001
Posts: 544
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, /n wouldn't work, but \n would
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 03:11 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04290 seconds
  • Memory Usage 2,264KB
  • Queries Executed 21 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (5)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete