Author |
Topic |
golfmann
Junior Member
United States
450 Posts |
Posted - 21 April 2005 : 20:07:56
|
ok, when we try and post we get this:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'dbrecordarr(...)'
/forum/inc_ipgate.asp, line 87
BTW it worked fine until the latest ipban was inserted yesterday...
Also the auto cookies has been a problem with banning some "good" posters that by luck had AOL ip's similar to a "bad" banned member... Seemed the ip check precision stopped after 3 places : ie: 111.222.333.xxx
Hope that's clear |
|
gpctexas
Junior Member
320 Posts |
Posted - 21 April 2005 : 21:47:10
|
How did the you enter the ip ban? whole ip or subnet? you can edit the ban and add a 0 ex 123.123.123.0 and see if that works. I'll will research something I think I just caught and post the results.
edit:
locate this part of the code if using 2.4
if dbrecordarr(2) < 0 or dbrecordarr(2) > 255 then
dbrecordarr(2) = 0
end if
if dbrecordarr(3) < 0 or dbrecordarr(3) > 255 then
dbrecordarr(3) = 0
end if
if dbrecordarr(2) = "" then
dbrecordarr(2) = 0
end if
if dbrecordarr(3) = "" then
dbrecordarr(3) = 0
end if
and change it to this
if dbrecordarr(2) = "" then
dbrecordarr(2) = 0
end if
if dbrecordarr(3) = "" then
dbrecordarr(3) = 0
end if
if dbrecordarr(2) < 0 or dbrecordarr(2) > 255 then
dbrecordarr(2) = 0
end if
if dbrecordarr(3) < 0 or dbrecordarr(3) > 255 then
dbrecordarr(3) = 0
end if
|
ipgate 2.4.4 RC3 http://www.gpctexas.net/ipgate_v244.zip |
Edited by - gpctexas on 21 April 2005 23:43:59 |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 27 April 2005 : 09:01:28
|
ok thanks! Will try that.
(I got busy and forgot about this) THANK you and thanks for your mod! Good stuff! (Has saved a LOT of problems)... |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 05 May 2005 : 21:03:56
|
Finally got around to trying the above... NOW get this on a post: Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
/forum/inc_ipgate.asp, line 364
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 05 May 2005 : 21:10:48
|
I need soem info to try and track this down,
how are you subnet bans setup? 123.456.789. or 123.456.789.0 or 123.456. or 123.456.0.0 etc lemme know, one of the last 2 subnets is missing some error checking, need to figure out which ones so it can be coded to make sure there are 0 instead of null or characters.
|
ipgate 2.4.4 RC3 http://www.gpctexas.net/ipgate_v244.zip |
|
|
gpctexas
Junior Member
320 Posts |
Posted - 05 May 2005 : 22:45:18
|
code updated to address your error, hopefully. Error checking added to make sure a numerical value of 0-255 exists in the 3rd and 4th octets of the ip address in the database record.
Code was also updated to address accidental bans. After looking at the new code implemented, I think it was possible where an ipaddress ban would convert into a 1st and 2nd octet ban and ban everyone that matched them.
file updated and is in the 2.4 zip on my site http://www.gpctexas.net/ipgate_v24.zip |
ipgate 2.4.4 RC3 http://www.gpctexas.net/ipgate_v244.zip |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 05 May 2005 : 23:42:23
|
Great! Maybe that was the problem with our AOL people getting banned... I will download and redo.
Thank you SO much!
Gmann |
|
|
gpctexas
Junior Member
320 Posts |
Posted - 06 May 2005 : 12:56:45
|
I found another bug, will update the zip later today. The bug deals with banning usernames, they wont happen atm.
open inc_ipgate.asp
locate 'start matching record to current username if lcase(trim(dbrecord)) = lcase(trim(strDBNTUsername)) then FoundName = 1
change to
'start matching record to current username if lcase(trim(rs1("IPLIST_MEMBERID"))) = lcase(trim(strDBNTUsername)) then FoundName = 1
edit: Zip updated with more bug fixes and some more added error checking. Should address everything mentioned and handle invalid ip addresses. |
ipgate 2.4.4 RC3 http://www.gpctexas.net/ipgate_v244.zip |
Edited by - gpctexas on 06 May 2005 15:53:17 |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 06 May 2005 : 20:47:07
|
ok downloaded again... got this: Microsoft VBScript compilation error '800a0411'
Name redefined
/forum/inc_ipgate.asp, line 112
dim tempdbname
Are there maybe other asp's I need to upload/upgrade? |
|
|
gpctexas
Junior Member
320 Posts |
Posted - 06 May 2005 : 23:48:10
|
doh thought I got all my debug info out, zip reupdated with error removed :) |
ipgate 2.4.4 RC3 http://www.gpctexas.net/ipgate_v244.zip |
Edited by - gpctexas on 06 May 2005 23:48:50 |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 08 May 2005 : 09:15:14
|
ok will try again :) |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 08 May 2005 : 09:18:09
|
Have you made any changes on the auto ban cookie octets to third? Many AOL accounts match 1st and second and get the boot!
But I will try again on that too... |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 08 May 2005 : 09:26:33
|
Got this: Microsoft VBScript runtime error '800a000d'
Type mismatch: 'dbrecordarr(...)'
/forum/inc_ipgate.asp, line 92
Am I the only one trying this? (I'd like to know if it's just me, the beta tester from hell) lol
|
|
|
gpctexas
Junior Member
320 Posts |
Posted - 08 May 2005 : 13:13:54
|
lemme try some stuff, I will get back, dont know what my server isnt generating any errors.
try this, I casted a few things as integers to see if it was the prob
http://www.gpctexas.net/inc_ipgate.txt rename to .asp :)
I did some tweaking on my test server. I am finally getting the error you are getting and removed the code that was causing trouble. When I find some more time, I will add the error checking that was causing the error to the admin page. You should redownload to get new instructions that I forgot to added to the zip to be able to use new logs page. |
ipgate 2.4.4 RC3 http://www.gpctexas.net/ipgate_v244.zip |
Edited by - gpctexas on 08 May 2005 19:37:31 |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 09 May 2005 : 20:39:42
|
ok, that seems to be workng fine. (I'm afraid to turn on the auto banning though, which I REALLY like and need)
I will redownload now
Thanks again and let me know if you come up with some way we can use auto. |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 09 May 2005 : 20:55:42
|
Love the record logs!
BIG improvement!
Thanks! |
|
|
Topic |
|