| Author | 
                
                  Topic   | 
                
              
              
                | 
                 DHT 
                Starting Member 
                 
                 
                
                37 Posts  | 
                
                  
                    
                      
                       Posted - 27 May 2001 :  20:24:18
                        
                      
  | 
                     
                    
                       I hope this one is easier to setup than Davio's version :)
  You need insert only 2 lines into the file that you want to block. I setup this Mod to block Users want to Post or Reply only.  But you can setup it in other features as you like.
  A little bit trouble that when you add line <% end if %> at the end page, you must test this line should go before or after line <!--#INCLUDE FILE="inc_footer.asp" -->. I don't know why ! But it works.
  You can block a class C by using * .  For Ex: 255.255.255.*
  The Admin Configuration is easier to maintain.
  Hope you enjoy this Mod.
  Download Mod at : http://www.vnvntest.com/BanIPMod.zip
 
 
  | 
                     
                   
                 | 
              
              
                | 
                 Classicmotorcycling 
                Development Team Leader 
                      
                 
                
                Australia 
                2085 Posts  | 
                
                  
                    
                      
                       Posted - 29 May 2001 :  09:13:45
                        
                      
  | 
                     
                    
                       Put this on, real simple to add, just a bit of coding incorrect in the admin_config_banIP.asp file. Refers to admin_config_ipbanned.asp where it needs this admin_config_banIP.asp. It is located in 2 places. Thought that you might like to know.
 
 quote:
  I hope this one is easier to setup than Davio's version :)
  You need insert only 2 lines into the file that you want to block. I setup this Mod to block Users want to Post or Reply only.  But you can setup it in other features as you like.
  A little bit trouble that when you add line <% end if %> at the end page, you must test this line should go before or after line <!--#INCLUDE FILE="inc_footer.asp" -->. I don't know why ! But it works.
  You can block a class C by using * .  For Ex: 255.255.255.*
  The Admin Configuration is easier to maintain.
  Hope you enjoy this Mod.
  Download Mod at : http://www.vnvntest.com/BanIPMod.zip
 
   
 
  
  Regards,
  Webmaster @ Classic Motor Cycling Classic Motor Cycling | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 DHT 
                Starting Member 
                 
                 
                
                37 Posts  | 
                
                  
                    
                      
                       Posted - 29 May 2001 :  13:32:15
                        
                      
  | 
                     
                    
                       Ooppss! Sorry for that mess up :) It already fixed.
  Thank you.
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 krillin47 
                Starting Member 
                 
                 
                
                USA 
                20 Posts  | 
                
                  
                    
                      
                       Posted - 01 June 2001 :  11:28:15
                        
                      
  | 
                     
                    
                       I'm getting this message everytime I try to go to post a message
 
 quote: ADODB.Recordset error '800a0bb9' 
  The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. 
  /inc_banIP.asp, line 14 
 
  
  If anyone can help me, that would be great.
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 DHT 
                Starting Member 
                 
                 
                
                37 Posts  | 
                
                  
                    
                      
                       Posted - 01 June 2001 :  18:32:10
                        
                      
  | 
                     
                    
                       In the Post.asp file, you need to add line <!--#INCLUDE FILE="inc_banIP.asp" --> after line <!--#INCLUDE FILE="inc_top.asp" -->
  In my sample Post.asp, I move line <!--#INCLUDE FILE="inc_top.asp" --> to the top.  In the original asp, you must roll down few lines to get it.
 
 
  Edited by - DHT on 01 June 2001  18:37:05 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 krillin47 
                Starting Member 
                 
                 
                
                USA 
                20 Posts  | 
                
                  
                    
                      
                       Posted - 01 June 2001 :  21:25:37
                        
                      
  | 
                     
                    
                       quote:
  In the Post.asp file, you need to add line <!--#INCLUDE FILE="inc_banIP.asp" --> after line <!--#INCLUDE FILE="inc_top.asp" -->
  In my sample Post.asp, I move line <!--#INCLUDE FILE="inc_top.asp" --> to the top.  In the original asp, you must roll down few lines to get it.
 
 
  Edited by - DHT on 01 June 2001  18:37:05
 
  
  I did that and it came up with this
 
 quote:
  Microsoft VBScript compilation error '800a0411' 
  Name redefined 
  /inc_top.asp, line 39 
  dim mLev, strLoginStatus ----^
 
  
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 krillin47 
                Starting Member 
                 
                 
                
                USA 
                20 Posts  | 
                
                  
                    
                      
                       Posted - 01 June 2001 :  21:31:17
                        
                      
  | 
                     
                    
                       well I figured out that problem, but I have this one now.
   quote:
  ADODB.Recordset error '800a0bb9' 
  The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. 
  /inc_banIP.asp, line 14 
 
  
  and this is what I have on line 13 and 14 of that file.
 
 quote:
  set rsIP =  Server.Createobject("ADODB.recordset") rsIP.open "SELECT *  FROM FORUM_BANNED", my_Conn
 
  
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 DHT 
                Starting Member 
                 
                 
                
                37 Posts  | 
                
                  
                    
                      
                       Posted - 01 June 2001 :  23:51:27
                        
                      
  | 
                     
                    
                       There are two reasons may have from your error:  - Database (= my_Conn) has not exist. - or table FORUM_BANNED has not exist.
  my_Conn is defined in inc_top.asp; that's why you have to add after include file=inc_top.asp
  Can you check the table FORUM_BANNED exists  in the database or not ?  I tested this mod with Access database only !
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 hawkster 
                Starting Member 
                 
                 
                
                4 Posts  | 
                
                  
                    
                      
                       Posted - 05 June 2001 :  14:38:11
                        
                      
  | 
                     
                    
                       I get this error when I run the mod_dbsetup.asp
 
  Banned Mod
  Creating table(s)... CREATE TABLE FORUM_BANNED( B_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , B_IP#varchar (20)#NULL# NOT NULL , B_REASON#varchar(200)#NULL# NOT NULL ) -2147217900 | Syntax error in field definition.
  --------------------------------------------------------------------------------
 
  
  Where did I screw up?
 
 
 
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 DHT 
                Starting Member 
                 
                 
                
                37 Posts  | 
                
                  
                    
                      
                       Posted - 05 June 2001 :  21:30:37
                        
                      
  | 
                     
                    
                       I guess you're using the different version of mod_dbsetup with the one I have.  Try to download the one I'm using now: http://www.vnvntest.com/mod_dbsetup.zip
  How about you add dirrectly table FORUM_BANNED into database ?  If you use Access Database, it's simple to add.
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 krillin47 
                Starting Member 
                 
                 
                
                USA 
                20 Posts  | 
                
                  
                    
                      
                       Posted - 06 June 2001 :  00:38:23
                        
                      
  | 
                     
                    
                       if that doesn't work, try downloading this file, and putting it into the directory, and then running the mod_dbsetup.asp page
  http://www.not-found.net/bannedIP.dbs
  I Edited the dbs file, and got it to work, for some reason when it has the # in the file it doesn't work, so I put ; instead of #.
  Edited by - krillin47 on 06 June 2001  00:39:15 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 hawkster 
                Starting Member 
                 
                 
                
                4 Posts  | 
                
                  
                    
                      
                       Posted - 06 June 2001 :  08:36:44
                        
                      
  | 
                     
                    
                       quote:
  I guess you're using the different version of mod_dbsetup with the one I have.  Try to download the one I'm using now: http://www.vnvntest.com/mod_dbsetup.zip
  How about you add dirrectly table FORUM_BANNED into database ?  If you use Access Database, it's simple to add.
   
 
  
  This didn't work.  Got an error saying "Page cannot be displayed"
 
 
 quote:
  if that doesn't work, try downloading this file, and putting it into the directory, and then running the mod_dbsetup.asp page
  http://www.not-found.net/bannedIP.dbs
  I Edited the dbs file, and got it to work, for some reason when it has the # in the file it doesn't work, so I put ; instead of #.
  Edited by - krillin47 on 06 June 2001  00:39:15
 
  
  Now, this worked!  Thanks a lot.
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 hawkster 
                Starting Member 
                 
                 
                
                4 Posts  | 
                
                  
                    
                      
                       Posted - 06 June 2001 :  08:38:03
                        
                      
  | 
                     
                    
                       quote:
  I guess you're using the different version of mod_dbsetup with the one I have.  Try to download the one I'm using now: http://www.vnvntest.com/mod_dbsetup.zip
  How about you add dirrectly table FORUM_BANNED into database ?  If you use Access Database, it's simple to add.
   
 
  
  This didn't work.  Got an error saying "Page cannot be displayed"
 
 
 quote:
  if that doesn't work, try downloading this file, and putting it into the directory, and then running the mod_dbsetup.asp page
  http://www.not-found.net/bannedIP.dbs
  I Edited the dbs file, and got it to work, for some reason when it has the # in the file it doesn't work, so I put ; instead of #.
  Edited by - krillin47 on 06 June 2001  00:39:15
 
  
  Now, this worked!  Thanks a lot.
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 krillin47 
                Starting Member 
                 
                 
                
                USA 
                20 Posts  | 
                
                  
                    
                      
                       Posted - 06 June 2001 :  21:01:54
                        
                      
  | 
                     
                    
                       No Problem.  I was just messing around, and it was bugging me that I couldn't get it to work, so I looked into the files that I had, and made the file how the ones that worked did.  Glad I could help.
  kRiLLiN47
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 IoNPhLuX 
                Starting Member 
                 
                 
                
                6 Posts  | 
                
                  
                    
                      
                       Posted - 24 June 2001 :  23:18:22
                        
                      
  | 
                     
                    
                       I made some changes!!
  In the Inc_Top.asp At the bottom include this line: <!--#INCLUDE FILE="inc_banIP.asp"--> Make sure you remove the other stuff DHT did adding all the include files in all the files you want protected.
  Open inc_banip.asp, Underneath Else Put: End If
  And there you go, it will protect everything. If you have a problem email me and i will help you out!
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 IoNPhLuX 
                Starting Member 
                 
                 
                
                6 Posts  | 
                
                  
                    
                      
                       Posted - 24 June 2001 :  23:33:22
                        
                      
  | 
                     
                    
                       Ok Oops
  In admin_config_banip.asp <!--#INCLUDE FILE="inc_top.asp"--> Change To: <!--#INCLUDE FILE="inc_top-BanMod.asp"-->
  And then open inc_top.asp then where we added the <!--#INCLUDE FILE="inc_banip.asp"--> Delete it! Then Save As: inc_top-BanMod.asp
  If you don't make this change you will get this: Microsoft VBScript compilation error '800a0411' 
  Name redefined 
  admin_config_banIP.asp, line 45 
  Dim rsIP ----^
 
  Edited by - IoNPhLuX on 24 June 2001  23:35:41
  Edited by - IoNPhLuX on 24 June 2001  23:36:55 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                
                
                  Topic   | 
                  |