| Author |
 Topic  |
|
Munkey
Starting Member
27 Posts |
 Posted - 25 April 2003 : 23:20:12
|
| As Chuck stated, this mod works well, except the Banning ranges, which would help alot. Alex, if you could get ranges to work, your mod would be pretty much done and dandy. |
 |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 29 April 2003 : 05:24:06
|
quote:
Originally posted by gpctexas
I had to do a lot of fixing to make mine work.
had to follow and make sure every problem in this topic (All 8 pages) had all the fixes applied.
Link to mine that works http://www.gpctexas.net/inc_ipgate.txt
rename txt to asp
Hi gptexas,
Is it possible for you to post a link to your edited mod? Are there more changes then in the inc_ipgate.txt file you provided above?
Cheers
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 29 April 2003 : 10:53:29
|
The fixes I did were to follow every fix and problem that was in this thread. Sorry about If I mislead. I can zip up all the files and put up a link on what I have done later today. I don't think I did anything else to make it work. I have not been able to test range banning yet.
http://www.gpctexas.net/forum/links_goto.asp?id=100
|
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
Edited by - gpctexas on 29 April 2003 12:42:00 |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 29 April 2003 : 13:45:52
|
I think I just found something in inc_ipgate.asp
locate the code (There are 2 places for it)
StrSql = StrSql & " OR '" & userip & "' NOT LIKE '%" & IPLIST_STARTIP & "%'" 'find matching ranges
and remove the word NOT and a % to where the lines now look like this
StrSql = StrSql & " OR '" & userip & "' LIKE '%" & IPLIST_STARTIP & "%'" 'find matching ranges
NOT LIKE will never match to a current user's IP to a bd entry, but LIKE will.
updated file is here http://www.gpctexas.net/inc_ipgate.txt
I tested this with a range of ips and then tried accessing the forums with a computer that had an ip banned in that range. I got a banned message. , but I don't think it works correctly.
Anyone else to test lemme know, My initial quick tests worked, but I was on a corp lan.
bad fix 
I also found admin_ipgate.asp problems where the page key wasn't getting saved when you add a new record.
updated 4-30-2003
admin_ipgate.asp
fixed above problem ^
also fixed the add feature from logs screen to prefill the form fields in the log admin area.
added a needed admin.ipgate.asp link to the bottom of the page.
http://www.gpctexas.net/admin_ipgate.txt rename to .asp
http://www.gpctexas.net/ipgate_v080beta_refreshed.zip updated mod as a whole.
Updated in a newer post
|
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
Edited by - gpctexas on 01 May 2003 22:56:17 |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 29 April 2003 : 17:01:51
|
quote:
Originally posted by gpctexas
The fixes I did were to follow every fix and problem that was in this thread. Sorry about If I mislead. I can zip up all the files and put up a link on what I have done later today. I don't think I did anything else to make it work. I have not been able to test range banning yet.
http://www.gpctexas.net/forum/links_goto.asp?id=100
OK and Thanks, gpctexas!
I will try to implement the mod this weekend. I really need to keep some people away from my forum. The problem - I guess - is that if I ban a range or even a singel IP, I will ban many more people from the forum - people with the same ISP provider, or....?
Cheers
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
Edited by - tomasalsbro on 29 April 2003 17:02:36 |
|
|
|
Munkey
Starting Member
27 Posts |
Posted - 01 May 2003 : 04:54:03
|
quote:
Originally posted by gpctexas
I think I just found something in inc_ipgate.asp
locate the code (There are 2 places for it)
StrSql = StrSql & " OR '" & userip & "' NOT LIKE '%" & IPLIST_STARTIP & "%'" 'find matching ranges
and remove the word NOT and a % to where the lines now look like this
StrSql = StrSql & " OR '" & userip & "' LIKE '%" & IPLIST_STARTIP & "%'" 'find matching ranges
NOT LIKE will never match to a current user's IP to a bd entry, but LIKE will.
updated file is here http://www.gpctexas.net/inc_ipgate.txt
I tested this with a range of ips and then tried accessing the forums with a computer that had an ip banned in that range. I got a banned message., but I don't think it works correctly.
That pretty much bans everyones IP and renders the forum useless 
I'd reccomend nobody using that fix  |
|
|
|
cyclingdude
New Member
68 Posts |
Posted - 01 May 2003 : 07:42:47
|
I just tried this latest patch and it banned every visitor to my forum. It put cookies on their machines. Even me and I have Admin access!!!
Now nobody can get in and I don't know how to reverse it!
Can someone please help me form a plan of action to remedy this problem? I've already removed IP gate all together. What should I do now? |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 01 May 2003 : 09:32:01
|
remove IP gate, clear your cookies, maybe cache too, temprary internet files? Shouldn't be nothing more than deleting the cookie though. Did you delete the inc_ipgate.asp from the inc_header.asp, if not delete that include from the inc_header.asp file?
WWS |
coaster crazy |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 01 May 2003 : 12:59:11
|
I just fixed a few things redownload and replace admin_ipgate.asp and inc_ipgate.asp
I believe I nailed the ranges. Both files are required for fix!
The orig author had the field necessary but wasn't using it.
I did comment I thought that the previous fix wasn't working right the sql looked funny. Most important, experiment on a test forum first.
I changed a lot of stuff in 2 files.
You can specify a starting ip range plus an ending ip range in the admin_ipgate.asp. inc_ipgate.asp then checks for the users ip address to be within that range. The range can be as big a gap as necessary as long as both are complete ip addresses..
the sql that changed in inc_ipgate.asp (2 places for this!)
StrSql = "SELECT IPLIST_STARTDATE, IPLIST_ENDDATE, IPLIST_STATUS, IPLIST_DBPAGEKEY, IPLIST_STARTIP, IPLIST_END_IP "
StrSql = StrSql & "FROM " & strTablePrefix & "IPLIST"
StrSql = StrSql & " WHERE ('" & userip & "' = IPLIST_STARTIP" 'find matching ips
StrSql = StrSql & " OR '" & userhost & "' = IPLIST_STARTIP" 'find matching hosts
StrSql = StrSql & " OR '" & strDBNTUserName & "' = IPLIST_MEMBERID" 'find matching members
StrSql = StrSql & " OR (('" & userip & "' >= IPLIST_STARTIP) AND ('" & userip & "' <= IPLIST_END_IP)))" 'find matching ranges
StrSql = StrSql & " AND ('" & userdate & "' >= IPLIST_STARTDATE"
StrSql = StrSql & " AND '" & userdate & "' <= IPLIST_ENDDATE )"
plus you need the new admin_ipgate.asp which supports adding info to the IPLIST_END_IP field in the table.
I have this working on my site. |
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
Edited by - gpctexas on 02 May 2003 10:36:36 |
|
|
|
OpenIntro
Junior Member
USA
126 Posts |
Posted - 02 May 2003 : 04:03:21
|
I just downloaded the new fixes (never installed before) and followed the directions to install. Uploaded everything and made the changes to config.asp and when I load my forums....it is giving me this error:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/kamikazeeshots/forum/inc_ipgate.asp, line 120
Line 120 in this file is:
rs1.Open StrSql, strConnString
Any idea why I am getting this and how to fix it? Would be MUCH appreciated! I am looking forward to banning a few people! lol.... |
Let's All Do Kamikaze Shots!
http://www.kamikazeshots.com
http://www.kamikazeshots.com/forum
*DO YOUR CLICKS!*
http://dailyclicks.kamikazeshots.com |
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 02 May 2003 : 09:24:58
|
check your iplist table and see if there is a field named END_IP. Did the dbs setup show any errors?
I checked the dbs files and the field END_IP wasn't there so I added it. I must have had an older mod in first.
rezipped as ipgate_v082beta.zip |
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
Edited by - gpctexas on 02 May 2003 10:38:14 |
|
|
|
OpenIntro
Junior Member
USA
126 Posts |
Posted - 02 May 2003 : 13:16:19
|
I am getting one error when I run the database setup still....
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEBAN','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELCK','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATECOK','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEMET','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEMSG','You are not allowed access to the page requested.')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELOG','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATETYP','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEEXP','15')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEEXP','15')
-2147467259 | The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. |
Let's All Do Kamikaze Shots!
http://www.kamikazeshots.com
http://www.kamikazeshots.com/forum
*DO YOUR CLICKS!*
http://dailyclicks.kamikazeshots.com |
Edited by - OpenIntro on 02 May 2003 13:16:35 |
|
|
|
OpenIntro
Junior Member
USA
126 Posts |
Posted - 02 May 2003 : 13:21:23
|
But I have added the code in inc_header.asp and I am not getting the error anymore with these new files. So maybe it worked?! I'm off to test the bans :)
Question though, is line 235 in inc_header.asp the corect place to put:
%>
<!--#INCLUDE FILE="inc_ipgate.asp"-->
<%
That's what it says in the readme, but I think there had been some discussion about it. |
Let's All Do Kamikaze Shots!
http://www.kamikazeshots.com
http://www.kamikazeshots.com/forum
*DO YOUR CLICKS!*
http://dailyclicks.kamikazeshots.com |
|
|
|
OpenIntro
Junior Member
USA
126 Posts |
Posted - 02 May 2003 : 13:24:10
|
Spoke too soon! 
When I go into Admin Options and click on IPGate, I immediately get this error:
Response object error 'ASP 0156 : 80004005'
Header Error
/kamikazeeshots/forum/config.asp, line 43
The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.
Line 43 in config.asp is: Response.Buffer = true
Any ideas? I made the changes to config.asp already? |
Let's All Do Kamikaze Shots!
http://www.kamikazeshots.com
http://www.kamikazeshots.com/forum
*DO YOUR CLICKS!*
http://dailyclicks.kamikazeshots.com |
|
|
|
Chuck McB
Junior Member
WooYay
196 Posts |
Posted - 02 May 2003 : 15:49:22
|
| OpenIntro, the 'Header Error' has been covered already, check back a page or two or post to the MOD Implementation forum. |
|
|
|
Topic |
|
Topic Locked
