| Author | 
                
                  Topic   | 
                  | 
              
              
                | 
                 aspwiz 
                Junior Member 
                   
                 
                
                250 Posts  | 
                
                  
                    
                      
                       Posted - 11 August 2003 :  19:28:33
                        
                        
                      
  | 
                     
                    
                       Ok, maybe I am barking up the wrong tree on both counts here as there may already be mods for this.
  I need:
  1.  Ability for MODERATORS and ADMINS ONLY to subscribe at forum level.... 2. A mod giving easy access to all unanswered posts.
  If moderators and admins can subscribe at forum level, they can be notified of new posts in their forums via email.... what we DONT want however is normal users being able to subscribe at this level because our bandwidth would go through the ceiling.
  Are there any mods for either of these?
  Can anyone point me in the right direction.
  | 
                     
                   
                 | 
              
              
                | 
                 Dave. 
                Senior Member 
                     
                 
                
                USA 
                1037 Posts  | 
                
                  
                    
                      
                       Posted - 11 August 2003 :  23:16:25
                        
                      
  | 
                     
                    
                       #2 is already done (If I understand you correctly):
  Look in the forum where you want to see all unanswered posts.  Scroll to the near bottom of the page.  Use this:
  Showing topics x - xx of xxx, sorted by [number of replies] in  [ascending] order, from  [the last xx days] [go] | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 aspwiz 
                Junior Member 
                   
                 
                
                250 Posts  | 
                
                  
                    
                      
                       Posted - 12 August 2003 :  05:59:34
                        
                        
                      
  | 
                     
                    
                       Hi.. thanx Dave, but I really wanted to see all unanswered topics at board level not just forum level.
  I wanted a link to say view all unanswered posts.
  Cheers,
  Rob | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 OneWayMule 
                Dev. Team Member & Support Moderator 
                      
                 
                
                Austria 
                4969 Posts  | 
                
                  
                 | 
              
              
                | 
                 aspwiz 
                Junior Member 
                   
                 
                
                250 Posts  | 
                
                  
                    
                      
                       Posted - 12 August 2003 :  07:09:38
                        
                        
                      
  | 
                     
                    
                       well.... oneway... oh mister MOD creator of old??  are you doing anything right now??     | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 brduran 
                New Member 
                  
                 
                
                Canada 
                98 Posts  | 
                
                  
                    
                      
                       Posted - 13 August 2003 :  19:06:09
                        
                        
                      
  | 
                     
                    
                       If you click on 'Active Topics', then where 'Active Topics Since' select 'Last 2 Months', then go to the address bar and after 'http://.../active.asp' ad the following: ?id=unanswered
  You'll get all the unanswered topics for the last two months in one window.
 
  | 
                     
                    
                         Bernardo Duran www.teknician.com
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 aspwiz 
                Junior Member 
                   
                 
                
                250 Posts  | 
                
                  
                    
                      
                       Posted - 14 August 2003 :  08:10:40
                        
                        
                      
  | 
                     
                    
                       brduran.... this does not work for me....
  I just get all posts returned... answered, or not.
  Rob | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 davemaxwell 
                Access 2000 Support Moderator 
                      
                 
                
                USA 
                3020 Posts  | 
                
                  
                    
                      
                       Posted - 14 August 2003 :  08:39:05
                        
                        
                      
  | 
                     
                    
                       The EASIEST way to see all the topics that haven't been replied to would be to make a copy of active.asp and change this line(about line 281):
  "AND (T.T_LAST_POST > '" & lastDate & "'"
  to "AND (T.T_REPLIES = 0"
  To be clean, you'd want to take out the time-based checks since they're unneeded, but you get the basic idea. | 
                     
                    
                        Dave Maxwell Barbershop Harmony Freak | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 brduran 
                New Member 
                  
                 
                
                Canada 
                98 Posts  | 
                
                  
                 | 
              
              
                | 
                 brduran 
                New Member 
                  
                 
                
                Canada 
                98 Posts  | 
                
                  
                    
                      
                       Posted - 21 August 2003 :  15:06:28
                        
                        
                      
  | 
                     
                    
                       quote: The EASIEST way to see all the topics that haven't been replied to would be to make a copy of active.asp and change this line(about line 281):
  "AND (T.T_LAST_POST > '" & lastDate & "'"
  to "AND (T.T_REPLIES = 0"
  To be clean, you'd want to take out the time-based checks since they're unneeded, but you get the basic idea.
  It works really well, thank you davemaxwell!
 
  | 
                     
                    
                         Bernardo Duran www.teknician.com
 
  | 
                     
                    
                       Edited by - brduran on 21 August 2003  15:07:05 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                |   | 
                
                  Topic   | 
                  |