IPGate 2.4.3 beta and 2.3 - Posted (21552 Views)
gpctexas
Junior Member
gpctexas
Posts: 320
320
Introducing ipgate 2.4.3 beta with new ip function and the long awaited paginated logs page! After almost loosing several weeks worth of work when my old host decided to run away, I decided to go ahead and add the paginated log I was working on before I really lost the code.. I was able to get the paginated code slated for the next release of ipgate into this version. I have then since put the next major release on hold but I'm releasing this interim release.
Improvments in ipgate 2.4.3
-A large number of bans should no longer slow the forum down. -Paginated logs page, be sure to set # of records per pages in settings. -improved ip/subnet banning and error checking a whole ip ban should no longer ban its subnet
-minor tweaks to admin page to reflect updated changes. -cookie autobanning can now be set in the user changeable area of inc_ipgate.asp

download here http://www.gpctexas.net/ipgate_v24.zip

screenshot: http://www.gpctexas.net/ipgate.JPG



########Everything below is standard and not changed######
smileedited 9-12-2004 to reflect code finalized.
Note: This is a current for current ipgate users. IPGate 2.3.0 is currently available http://www.gpctexas.net/ipgate_v23.zip
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=194

Features/improvements of ipgate 2.3.0
Ban by username, ipaddress, and ipaddress subnet

-You can ban by either means above. If you decide to use a browser cookie, a cookie will be placed on the users computer which flags them by their status. If that user switches names or ip address, the cookie flags them and bans them. If their ip address or username is different, a new ban record is inserted to auto ban the new username and ip address. At this time, no on off switch available for the new auto ban feature.

-You can add a list of banned pages that all users whos status is set to blocked access, can not access.
-Cookies will expire based on the end date you specify when you ban someone. Once a cookie is on their machine they are flagged until the cookie expires. A cookie expire option has been added to help alieviate accidental range bans. Remember to expire a cookie for a week before deleting a ban.
-You can log all ips or only those specified to watch in the database.
-Admin ban prevention improved

-Works with Access, MS SQL, and My SQL

-a few bugs were fixed in the admin page

-inc_ipgate.asp code cleaned up

-a looping bug was fixed pertaining to ipgate user message.
to upgrade from ver 2.2.8 just copy inc_ipgate.asp and admin_ipgate.asp to your forum or test forum directory. <
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip
Last edited by gpctexas on 08 May 2005, 04:33
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
AnonJr
Forum Moderator
AnonJr
Posts: 5768
5768
Originally posted by Desmomax
Hallo gpctexas! hope you can help me as well... i have installed your IPGate 2.4.3 Beta 2, i received an email from a user that every time he try to enter the result is this error:

Errore di run-time di Microsoft VBScript error '800a000d'

Tipo non corrispondente: '[string: "15, 192.168.200.15, "]'

/myforum/inc_ipgate.asp, line 377

the error line of inc_ipgate is:
num = Int(Mid(DottedIP, PrevPos + 1, pos - PrevPos - 1))

Looks like some problem with his Ip , i receive many other visit (around 200 each day) without any problem..
many thanx

Massimiliano

If memory serves, this stems from an issue with the string of routing addresses being reported. I know there was a bug report and a fix for the problems it was causing in the base code, but I don't know if it was addressed in this MOD. I seem to think it was, and that there was some code floating around for those that run into this problem.
If you can find the original bug report's thread, there's a detailed discussion on the whys and what-fors.
(Just figured I'd pull this issue up a little since it likely got lost when the next reply hit the next page...)<
Last edited by AnonJr on 17 April 2008, 15:30
Posted
gpctexas
Junior Member
gpctexas
Posts: 320
320
That fix was implemented to the 2.4.4 mod<
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip
Last edited by gpctexas on 17 April 2008, 19:11
Posted
palmdoc
Starting Member
palmdoc
Posts: 23
23
Is IPGate hackable? I just had a Userban overcome and when I checked the End ban date it was changed to 70/51/2000 !!<
Posted
gpctexas
Junior Member
gpctexas
Posts: 320
320
There are no known vulnerabilities with the mod that I am aware of.<
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip
Posted
NiteOwl
Junior Member
NiteOwl
Posts: 403
403
HI I am doing a completely new install, to SNiTZ 3.4.05 on a MySQL4 database, after running the dbs file I have these errors:

Code:

Net IPGate Mod v2.4 New Install

Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_IPLIST( IPLIST_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLIST_MEMBERID varchar(32) NULL DEFAULT 0, IPLIST_STARTIP varchar(32) NULL , IPLIST_STARTDATE varchar(32) NULL , IPLIST_ENDDATE varchar(32) NULL , IPLIST_COMMENT varchar(255) NULL , IPLIST_STATUS varchar(8) NULL , IPLIST_DBPAGEKEY varchar(32) NULL ,KEY FORUM_IPLIST_IPLIST_ID(IPLIST_ID))
CREATE TABLE FORUM_IPLIST( IPLIST_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLIST_MEMBERID varchar(32) NULL DEFAULT 0, IPLIST_STARTIP varchar(32) NULL , IPLIST_STARTDATE varchar(32) NULL , IPLIST_ENDDATE varchar(32) NULL , IPLIST_COMMENT varchar(255) NULL , IPLIST_STATUS varchar(8) NULL , IPLIST_DBPAGEKEY varchar(32) NULL ,KEY FORUM_IPLIST_IPLIST_ID(IPLIST_ID))
-2147217871 | Invalid default value for 'IPLIST_ID'

Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_PAGEKEYS( PAGEKEYS_ID INT (11) DEFAULT '' NOT NULL auto_increment , PAGEKEYS_PAGEKEY varchar(32) NULL ,KEY FORUM_PAGEKEYS_PAGEKEYS_ID(PAGEKEYS_ID))
CREATE TABLE FORUM_PAGEKEYS( PAGEKEYS_ID INT (11) DEFAULT '' NOT NULL auto_increment , PAGEKEYS_PAGEKEY varchar(32) NULL ,KEY FORUM_PAGEKEYS_PAGEKEYS_ID(PAGEKEYS_ID))
-2147217871 | Invalid default value for 'PAGEKEYS_ID'

Adding new records..
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
-2147217865 | Table 'cimare_prod.FORUM_PAGEKEYS' doesn't exist

Dropping Table..

Table does not exist
Creating table(s)...
CREATE TABLE FORUM_IPLOG( IPLOG_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLOG_MEMBERID varchar(32) NULL DEFAULT 0, IPLOG_IP varchar(32) NULL , IPLOG_PATHINFO varchar(255) NULL , IPLOG_DATE varchar(32) NULL ,KEY FORUM_IPLOG_IPLOG_ID(IPLOG_ID))
CREATE TABLE FORUM_IPLOG( IPLOG_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLOG_MEMBERID varchar(32) NULL DEFAULT 0, IPLOG_IP varchar(32) NULL , IPLOG_PATHINFO varchar(255) NULL , IPLOG_DATE varchar(32) NULL ,KEY FORUM_IPLOG_IPLOG_ID(IPLOG_ID))
-2147217871 | Invalid default value for 'IPLOG_ID'

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 banned from these forums')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELKMSG','Forums are currently locked')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATENOACMSG','You do not have access to the requested page')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEWARNMSG','Your or another persons activity is being logged')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEVER','Ver 2.4')
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 ('STRIPGATECSS','0')

Value(s) updated successfully

This is the dbs file provided:
Code:

Net IPGate Mod v2.4 New Install [DROP] IPLIST [END] [CREATE] IPLIST IPLIST_ID IPLIST_MEMBERID#varchar(32)#NULL#0 IPLIST_STARTIP#varchar(32)#NULL# IPLIST_STARTDATE#varchar(32)#NULL# IPLIST_ENDDATE#varchar(32)#NULL# IPLIST_COMMENT#varchar(255)#NULL# IPLIST_STATUS#varchar(8)#NULL# IPLIST_DBPAGEKEY#varchar(32)#NULL# [END] [DROP] PAGEKEYS [END] [CREATE] PAGEKEYS PAGEKEYS_ID PAGEKEYS_PAGEKEY#varchar(32)#NULL# [END] [INSERT] PAGEKEYS (PAGEKEYS_PAGEKEY)#('post.asp') [END] [DROP] IPLOG [END] [CREATE] IPLOG IPLOG_ID IPLOG_MEMBERID#varchar(32)#NULL#0 IPLOG_IP#varchar(32)#NULL# IPLOG_PATHINFO#varchar(255)#NULL# IPLOG_DATE#varchar(32)#NULL# [END] [INSERT] CONFIG_NEW (C_VARIABLE,C_VALUE)#('STRIPGATEBAN','1') (C_VARIABLE,C_VALUE)#('STRIPGATELCK','0') (C_VARIABLE,C_VALUE)#('STRIPGATECOK','0') (C_VARIABLE,C_VALUE)#('STRIPGATEMET','0') (C_VARIABLE,C_VALUE)#('STRIPGATEMSG','You are banned from these forums') (C_VARIABLE,C_VALUE)#('STRIPGATELKMSG','Forums are currently locked') (C_VARIABLE,C_VALUE)#('STRIPGATENOACMSG','You do not have access to the requested page') (C_VARIABLE,C_VALUE)#('STRIPGATEWARNMSG','Your or another persons activity is being logged') (C_VARIABLE,C_VALUE)#('STRIPGATEVER','Ver 2.4') (C_VARIABLE,C_VALUE)#('STRIPGATELOG','1') (C_VARIABLE,C_VALUE)#('STRIPGATETYP','0') (C_VARIABLE,C_VALUE)#('STRIPGATEEXP','15') (C_VARIABLE,C_VALUE)#('STRIPGATECSS','0') [END]
And I am getting this error aven after running setup.asp

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
Table 'cimare_prod.FORUM_IPLIST' doesn't exist
/forum/inc_ipgate.asp, line 81
Any Ideas what I can do to fix this, should I manually add a column?

*** I see this fellow has the same problem:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=65275&SearchTerms=Invalid,default,value,for,'IPLIST_ID'

-=NiteOwl=-
<
Last edited by NiteOwl on 20 April 2008, 16:53
Posted
NiteOwl
Junior Member
NiteOwl
Posts: 403
403
ahhh, here is the fix, I kept reading the different posts and did not clue in that I need to change 2 of the base SNiTZ files, now all works.
As posted by Davio here
On line 275 in the admin_mod_dbsetup.asp file, remove the following code in red:
strSql = strSql & idFieldName &" INT (11) DEFAULT '' NOT NULL auto_increment "
And do the same thing for line 307 in the admin_mod_dbsetup2.asp file. Then run the DBS files again.
-=NiteOwl=-<
Last edited by NiteOwl on 21 April 2008, 05:10
Posted
gpspassion
Junior Member
gpspassion
Posts: 260
260
Any thoughts on using IPGate as an anti-scraping (someone downloading all the pages of the forums) tool? Thanks!
You Must enter a message