| Author | 
                
                  Topic   | 
                
              
              
                | 
                 Kerry 
                Average Member 
                    
                 
                
                USA 
                553 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  11:18:22
                        
                        
                      
  | 
                     
                    
                       Emails all / selected users from Admin panel. (Based on 3.1sr4)
  http://www.cantonweb.com/admin_emaillist.txt (* Do a 'save as')
  I had a client deseperate for this feature (was due for proofing this morning) and I *think* it's working ok - could use any brave souls interested in testing it out.
  Also, this may be replicating other work in progress, but it looked like it was still a day or two off. If you need this mod, be sure to check out what else is posted.
  Ideally it should have paging and a search feature, but I'm not there yet.
  Installation / Use: 1) Replace admin_emaillist.asp 2) Go to email list in Admin panel 3) Do not spam  
  ...that's about it. Post any suggestions, bugs or mods!
  -Kerry
  Additional note:
  This mod relies on all users having an email address in M_EMAIL (FORUM_MEMBERS table). If your default install has the default Admin account, be sure that it is assigned an email address or the script may timeout when trying to send.
  *As of 1-18-01 11:10pm EST the above note does not apply to this MOD. -If you downloaded BEFORE this, see below for fix or redownload this file.
  *File updated 1-19-01 11:25pm EST - for changes see below
  *File re-released 1-25-01 - for changes see: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=4211&FORUM_ID=25&CAT_ID=1&Topic_Title=MOD%3A+Email+List+%26+Message+Manager+%28opt%2Din+%2F+out%29&Forum_Title=DEV+Design+Requests+W%2FCode+%28v4%29
  Edited by - kerry on 25 January 2001  09:54:41 | 
                     
                   
                 | 
              
              
                | 
                 StockholmStudent 
                Junior Member 
                   
                 
                
                Sweden 
                329 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  12:49:30
                        
                        
                      
  | 
                     
                    
                       well, sorry to say this, but that MOD SUCKED! I tested it, marked my user at my forum, and sent some messages. When I chekced my e-mail box, I had gotten lots of lots of angry letters of sending strange posts.
  The wrong things: 1) it ALWAYS posts to ALL the members 2) It double-posts, it posts 2 times, 2 letters of each, so they will get 2 of them. Very bad!
  Dont DL! Fix i tfirst!  
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kerry 
                Average Member 
                    
                 
                
                USA 
                553 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  13:00:45
                        
                        
                      
  | 
                     
                    
                       Stockholmstudent,
  I can't replicate your problem here, so give me some more info.
  What version are you running? And is it a standard release or a modified release (HuwR's or Richard Kisner's)?
  Also, just as a side note - when I asked people to test it I should have been more clear and pointed out that it is ALWAYS unwise to test any mass-mail program on a live community.
  I'd appreciate anyone else's test results (*see above disclaimer).
  -Kerry
  Edited by - kerry on 18 January 2001  16:45:57 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 RichardKinser 
                Snitz Forums Admin 
                      
                 
                
                USA 
                16655 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  13:14:24
                        
                      
  | 
                     
                    
                       StockholmStudent,
  Your comments were totally uncalled for.  Nobody is making you download these modifications.  If you have problems with them then communicate those problems in the appropriate manner. | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StockholmStudent 
                Junior Member 
                   
                 
                
                Sweden 
                329 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  13:19:30
                        
                        
                      
  | 
                     
                    
                       quote:
  Stockholmstudent,
  I can't replicate it here with, so give me some more info.
  What version are you running? And is it a standard release or a modified release (HuwR's or Richard Kisner's)?
  Also, just as a side note - when I asked people to test it I should have been more clear and pointed out that it is ALWAYS unwise to test any mass-mail program on a live community.
  I'd appreciate anyone else's test results (*see above disclaimer).
  -Kerry
   
 
  
  I havent said that YOU have done wrong. I just made it VERY clear that this wasn't working. I used the mod above. Only that.
  Another better version somewhere?
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kerry 
                Average Member 
                    
                 
                
                USA 
                553 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  13:29:04
                        
                        
                      
  | 
                     
                    
                       StockholmStudent,
  I'll be glad to help you get something working, but I need the info I asked for in the above post. Because it's working perfectly here, I need to look for differences that might make your version malfunction. It is possible that you are using one of HuwR's or Richard's releases and as a result the code may need altered to be compatible - but I need to know these things before I can be of any help.
  -Kerry
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StockholmStudent 
                Junior Member 
                   
                 
                
                Sweden 
                329 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  14:09:57
                        
                        
                      
  | 
                     
                    
                       quote:
  StockholmStudent,
  I'll be glad to help you get something working, but I need the info I asked for in the above post. Because it's working perfectly here, I need to look for differences that might make your version malfunction. It is possible that you are using one of HuwR's or Richard's releases and as a result the code may need altered to be compatible - but I need to know these things before I can be of any help.
  -Kerry
   
 
  
  AS I'VE ALREADY TOLD YOU, I DL'd the link mesioned above, and got it workin. But it e-mail 2 examples of every version to the usres, even if I only ckilcked "send message" on etime. It also e-mail it to EVERY USER IN THE LIST, not ONLY ME, as I had selected by pushing at a box and getting a cross inside it, and pushing "send to selected users"!
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 RichardKinser 
                Snitz Forums Admin 
                      
                 
                
                USA 
                16655 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  14:18:25
                        
                      
  | 
                     
                    
                      |  Kerry, I installed this on my forum and it works exactly like it is supposed to.  It is only sending 1 e-mail and only to the people I have selected. | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kerry 
                Average Member 
                    
                 
                
                USA 
                553 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  14:44:56
                        
                        
                      
  | 
                     
                    
                       I just used it in HuwR's release also without any problem (had only tried it on the official release before).
  StockholmStudent,
  I'm wondering if possibly another MOD in your forum is creating a conflict. -If so, it would be best if he removed this file and go back to the original until a similar mod is released that works with your particular forum.
  -Kerry
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kerry 
                Average Member 
                    
                 
                
                USA 
                553 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  15:26:54
                        
                        
                      
  | 
                     
                    
                       Additional note:
  This mod relies on all users having an email address in M_EMAIL (FORUM_MEMBERS table). If your default install has the default Admin account, be sure that it is assigned an email address or the script may timeout when trying to send.
  -Kerry
  (*Adding to first post)
  Edited by - kerry on 18 January 2001  15:27:44 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kerry 
                Average Member 
                    
                 
                
                USA 
                553 Posts  | 
                
                  
                    
                      
                       Posted - 18 January 2001 :  23:24:46
                        
                        
                      
  | 
                     
                    
                       Fix for blank M_EMAIL field issue mentioned above.
  Around line 95 you'll find:
    strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_STATUS = " & 1
  
  Directly below it add:
    strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_EMAIL <> " & "''"  
  Or downlaod the updated file  
  -Kerry
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kal Corp 
                Average Member 
                    
                 
                
                USA 
                878 Posts  | 
                
                  
                    
                      
                       Posted - 19 January 2001 :  11:18:01
                        
                        
                      
  | 
                     
                    
                       This worked great for me 
  Thanks  Kerry    
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kenno 
                Average Member 
                    
                 
                
                Cambodia 
                846 Posts  | 
                
                  
                    
                      
                       Posted - 19 January 2001 :  23:08:32
                        
                        
                      
  | 
                     
                    
                       quote:
  Kerry, I installed this on my forum and it works exactly like it is supposed to.  It is only sending 1 e-mail and only to the people I have selected.
 
  
  It looks so cool, though I haven't tested it yet. So good job, Kerry. Anyway, which email component can I use with cfm-resources.com? Do you know about that Richard? I've been trying:
  ASPMail:  installed!  ASPQMail:  installed!  CDONTS:  installed!  Chili!Mail:  installed! 
  ... but I didn't get any messages.
 
 
  ÷§÷ Kenno ÷§÷ | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 RichardKinser 
                Snitz Forums Admin 
                      
                 
                
                USA 
                16655 Posts  | 
                
                  
                    
                      
                       Posted - 19 January 2001 :  23:14:59
                        
                      
  | 
                     
                    
                       Are you using:  mail.cfm-resources.net ?
  I'm actually using SA-SMTPMail with cfm-resources.com  I never got any e-mails when using ASPMail. | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kenno 
                Average Member 
                    
                 
                
                Cambodia 
                846 Posts  | 
                
                  
                    
                      
                       Posted - 19 January 2001 :  23:44:06
                        
                        
                      
  | 
                     
                    
                       Yes, I used "mail.cfm-resources.net". I've changed to SMTPMail, and using mail.cfm-resources.com server, but I got the error this time. Is SA-SMTPMail different from SMTPMail? Do I need to add any other codes?
  ÷§÷ Kenno ÷§÷ | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kerry 
                Average Member 
                    
                 
                
                USA 
                553 Posts  | 
                
                  
                    
                      
                       Posted - 19 January 2001 :  23:47:02
                        
                        
                      
  | 
                     
                    
                       Updated
  A few changes to the file above:
  Improved sorting for rank, last post date, no-posters, no-post for last 6 months, no-post for last year, etc...
  -Kerry
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                
                
                  Topic   | 
                  |