Snitz Forums 2000

Snitz Forums 2000

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/Code)

Topic/Reply CheckSum

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:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Carefree	Posted - 01 September 2013 : 00:54:10 I wrote this in response to a problem with double posting, thanks to a suggestion by PierreTopping. Basically, this mod adds a checksum value to topics and replies. When a post is made, it compares the checksum values of previous posts by the same member within the last 10 days. If it finds a match, the post is not made. Get your copy at SnitzBitz. Note: The original CRC calculation was created by someone else, but the claimed "copyright" allows incorporation for free into existing code; provided the code is not listed on a website.
15 L A T E S T R E P L I E S (Newest First)
bobby131313	Posted - 14 June 2014 : 20:00:49 You're welcome.
Carefree	Posted - 14 June 2014 : 06:16:57 I modified the SnitzBitz file for the archive table, thanks for pointing it out.
bobby131313	Posted - 13 June 2014 : 22:53:07 You need to add the checksum columns to the archive tables too... [ALTER] A_TOPICS ADD#T_CHKSUM#VARCHAR(16)#NULL# [END] [ALTER] A_REPLY ADD#R_CHKSUM#VARCHAR(16)#NULL# [END]
golfmann	Posted - 07 November 2013 : 17:57:07 I implemented this and like(d) it but it messed up my archiving so I got an error message. Had to take it all out and drop the CHKSUM tables. Now... archiving again. FYI
Carefree	Posted - 05 September 2013 : 01:49:30 quote: Originally posted by Webbo My version did ..... er, nothing OK here's a stand-alone for MySQL. Call it whatever you'd like, save to forum folder and execute. <!--#INCLUDE FILE="config.asp"--> <!--#INCLUDE FILE="inc_header.asp" --> <% On Error Resume Next my_Conn.Execute("ALTER TABLE " & strTablePrefix & "TOPICS MODIFY COLUMN T_CHKSUM VARCHAR(16) NULL") If Err.Number <>0 Then Response.Write Err.Description & "<br />" If Err.Source <> "" Then Response.Write Err.Source & "<br />" If Err.Line > 0 Then Response.Write Err.Line Err.Clear my_Conn.Execute("ALTER TABLE " & strTablePrefix & "REPLY MODIFY COLUMN R_CHKSUM VARCHAR(16) NULL") If Err.Number <>0 Then Response.Write Err.Description & "<br />" If Err.Source <> "" Then Response.Write Err.Source & "<br />" If Err.Line > 0 Then Response.Write Err.Line Err.Clear WriteFooter
golfmann	Posted - 04 September 2013 : 22:58:00 That pesky Blink core?...
HuwR	Posted - 04 September 2013 : 17:00:31 it is a bug in Chrome quote: Jul 23, 2013 Chrome Version : 29.0.1547.22 What steps will reproduce the problem? 1. POST a web form 2. go somewhere else 3. press back What is the expected result? Chrome should show the state after the form was POSTed. What happens instead of that? Chrome rePOSTs unnecessarily repeating the action Please provide any additional information below. Attach a screenshot if possible. This is a regression from the previously good behavior that started with Chrome 29. UserAgentString: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.22 Safari/537.36
Webbo	Posted - 04 September 2013 : 16:18:15 (For information) As well as the Android O/S the duplicate posts issue is also being caused when people use Google Chrome as their browser I've managed to recreate the issue with Google Chrome - after posting and then being returned back to the thread if you click the 'Click to go back...' arrow (<-) GC trys to resend the post if you do the same in Internet Explorer it displays post_info.asp thanking you for your contribution Trying the above out on a php forum GChrome doesn't retain the form field information It appears that because Snitz uses the post_info.asp as an intermediary page it is that page that browsers are returning to when the 'back' button is clicked and the main browsers show the after post message, whereas Google Chrome attempts to reprocess the form information
Webbo	Posted - 04 September 2013 : 16:11:04 Carefree's code returned the following: Dropping Column... ALTER TABLE FORUM_TOPICST_CHKSUM ALTER TABLE FORUM_TOPICST_CHKSUM -2147217865 \| [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Table 'maggot_info.forum_topicst_chksum' doesn't exist -------------------------------------------------------------------------------- Dropping Column... ALTER TABLE FORUM_REPLYR_CHKSUM ALTER TABLE FORUM_REPLYR_CHKSUM -2147217865 \| [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Table 'maggot_info.forum_replyr_chksum' doesn't exist -------------------------------------------------------------------------------- My version did ..... er, nothing
HuwR	Posted - 04 September 2013 : 15:53:47 check what you have against the code carefree posted, they are nothing like each other, you seem to have the TABLE (TOPICS) line missing and have the tablename added to the column line
Webbo	Posted - 04 September 2013 : 13:18:31 That created a table doesn't exist error, however the following worked [ALTER] MODIFY#TOPICS_T_CHKSUM#VARCHAR(16)#NULL# [END] [ALTER] MODIFY#REPLY_R_CHKSUM#VARCHAR(16)#NULL# [END]
Carefree	Posted - 04 September 2013 : 03:02:42 Should probably use mySql's "modify" command. Try this for MySQL: ChkSum v3.4.07 Field Size Change [ALTER] TOPICS MODIFY#T_CHKSUM#VARCHAR(16)#NULL# [END] [ALTER] REPLY MODIFY#R_CHKSUM#VARCHAR(16)#NULL# [END]
Webbo	Posted - 04 September 2013 : 02:35:52 The dbs file returns errors with a MySql database Carefree.... quote: Adding Column T_CHKSUM... ALTER TABLE FORUM_TOPICS ALTER COLUMN T_CHKSUM varchar(16) NULL ALTER TABLE FORUM_TOPICS ALTER COLUMN T_CHKSUM varchar(16) NULL -2147217900 \| [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(16) NULL' at line 1 -------------------------------------------------------------------------------- Adding Column R_CHKSUM... ALTER TABLE FORUM_REPLY ALTER COLUMN R_CHKSUM varchar(16) NULL ALTER TABLE FORUM_REPLY ALTER COLUMN R_CHKSUM varchar(16) NULL -2147217900 \| [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(16) NULL' at line 1
Carefree	Posted - 03 September 2013 : 20:45:47 Sure. Implementing the change to the field size, though, would require you to rerun a dbs file. "post_info.asp" Look for the following line (appx 825): strSql = "SELECT * FROM " & strTablePrefix & "TOPICS WHERE (T_AUTHOR="&MemberID&" AND T_DATE>='" & strDate10 & "' AND T_CHKSUM>'') ORDER BY T_DATE DESC" Change it to say: strSql = "SELECT T_CHKSUM FROM " & strTablePrefix & "TOPICS WHERE (T_AUTHOR="&MemberID&" AND T_DATE>='" & strDate10 & "' AND T_CHKSUM>'') ORDER BY T_DATE DESC" Look for the following line (appx 1076): strSql = "SELECT * FROM " & strTablePrefix & "REPLY WHERE (R_AUTHOR="&MemberID&" AND R_DATE>='" & strDate10 & "' AND R_CHKSUM>'' AND TOPIC_ID=" & Topic_ID & ") ORDER BY R_DATE DESC" Change it to say: strSql = "SELECT R_CHKSUM FROM " & strTablePrefix & "REPLY WHERE (R_AUTHOR="&MemberID&" AND R_DATE>='" & strDate10 & "' AND R_CHKSUM>'' AND TOPIC_ID=" & Topic_ID & ") ORDER BY R_DATE DESC" "dbs_chksum_fieldsize.asp" ChkSum v3.4.07 Field Size Change [ALTER] TOPICS ALTER#T_CHKSUM#VARCHAR(16)#NULL# [END] [ALTER] REPLY ALTER#R_CHKSUM#VARCHAR(16)#NULL# [END]
Webbo	Posted - 03 September 2013 : 16:43:35 Is there any chance you can post the changes above to this thread for those that have already implemented it ?

Snitz Forums 2000

This page was generated in 0.05 seconds.