Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 IPGate 2.4.3 beta and 2.3

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
gpctexas Posted - 10 August 2004 : 16:29:54
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######
edited 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.
<
15   L A T E S T    R E P L I E S    (Newest First)
gpspassion Posted - 21 October 2010 : 16:16:39
Any thoughts on using IPGate as an anti-scraping (someone downloading all the pages of the forums) tool? Thanks!
NiteOwl Posted - 21 April 2008 : 05:09:46
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=-<
NiteOwl Posted - 20 April 2008 : 16:05:22
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:


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:

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=-
<
gpctexas Posted - 18 April 2008 : 22:34:10
There are no known vulnerabilities with the mod that I am aware of.<
palmdoc Posted - 17 April 2008 : 21:21:27
Is IPGate hackable? I just had a Userban overcome and when I checked the End ban date it was changed to 70/51/2000 !!<
gpctexas Posted - 17 April 2008 : 19:09:43
That fix was implemented to the 2.4.4 mod<
AnonJr Posted - 17 April 2008 : 15:29:19
quote:
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...)<
gpctexas Posted - 16 April 2008 : 20:09:52
make sure you edited config.asp and the inc_header.asp right. Check and make sure you didnt accidently delete varaible etc from config.asp when adding ipgate vars. IPGate does not interfere with any of the email functions<
palmdoc Posted - 15 April 2008 : 20:58:52
Hi has anyone experienced a problem with IPGate whereby Registration activation email does not go out to the user? I notice after installing IPGate that users do not get the email (I tested this myself). Otherwise forum email (subscriptions, lost password) works.
<
Desmomax Posted - 15 April 2007 : 13:39:09
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
<
gpctexas Posted - 08 April 2007 : 14:52:26
Change your cookie name near the top of inc_ipgate.asp and see if it clears up. also while you are there,
locate
useautoban = 1
change to
useautoban = 0
That setting whem set to 1 would generate the message if someone closely match an ip and automatically add them into the db.

Also see if anyone is setup as "watched" in admin_ipgate.asp


If that doesn't work, you can remove the section in inc_ipgate.asp
locate
case "watched"
%>
<table border="0" width="100%" id="table1" style="border-collapse: collapse">
<tr>
<td align="center" <% if strIPGateCss = 1 then response.write(forumcss) else response.write(forumnocss) end if %>>
<% if strIPGateCss = 0 then response.write(fontnocss)%>
<b>Message: <%=StrIPGateWarnMsg%></b>
<% if strIPGatecCss = 0 then response.write ("</font>") %>
</td>
</tr>
</table>
<%
and remove it<
bozan74 Posted - 08 April 2007 : 04:49:23
No more error message!

But, i have a question: when a user connect to the forum, and don't log-in, there is always this message in the top of the homepage:

Message: Your or another persons activity is being logged

Why does it appear? is there a way to make it disappear?<
gpctexas Posted - 07 April 2007 : 17:25:42
I will eventually find this :)
try

in inc_ipgate.asp
locate
call writethecookie ("Banned", ChkDate(rs1("IPLIST_ENDDATE"), " " ,true))
replace with
call writethecookie ("Banned", StrToDate(rs1("IPLIST_ENDDATE")))

locate

call writethecookie ("Watched", ChkDate(rs1("IPLIST_ENDDATE"), " " ,true))
replace with
call writethecookie ("Watched", StrToDate(rs1("IPLIST_ENDDATE")))

locate

call writethecookie ("Blocked", ChkDate(rs1("IPLIST_ENDDATE"), " " ,true))
replace with
call writethecookie ("Blocked", StrToDate(rs1("IPLIST_ENDDATE")))
<
gpctexas Posted - 07 April 2007 : 16:28:30
then it is a the date format then, undo the previous test and I will dig somemore.<
bozan74 Posted - 07 April 2007 : 04:39:15
I've done these change, but the problem remain:

Type mismatch: 'Response.Cookies(...).Expires'

<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000 Version 3.4.07