From a564a95ab40eb1c9cc7de142db60aedb3e749176 Mon Sep 17 00:00:00 2001
From: Michael Save <savetheinternet@tinyboard.org>
Date: Thu, 12 Apr 2012 21:56:01 +1000
Subject: Improved Tinyboard anti-bot/spam filter. See large comment in
 inc/config.php for details.

---
 install.php | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

(limited to 'install.php')

diff --git a/install.php b/install.php
index 3cd8a5b7..f67d4cb0 100644
--- a/install.php
+++ b/install.php
@@ -1,7 +1,7 @@
 <?php
 
 // Installation/upgrade file	
-define('VERSION', 'v0.9.6-dev-1');
+define('VERSION', 'v0.9.6-dev-2');
 
 require 'inc/functions.php';
 
@@ -174,6 +174,17 @@ if(file_exists($config['has_installed'])) {
 				CHANGE  `uri`  `uri` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 				CHANGE  `title`  `title` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 				CHANGE  `subtitle`  `subtitle` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL") or error(db_error());
+		case 'v0.9.6-dev-1':
+			query("CREATE TABLE IF NOT EXISTS `antispam` (
+				  `board` varchar(255) NOT NULL,
+				  `thread` int(11) DEFAULT NULL,
+				  `hash` bigint(20) NOT NULL,
+				  `created` int(11) NOT NULL,
+				  `expires` int(11) DEFAULT NULL,
+				  `passed` smallint(6) NOT NULL,
+				  PRIMARY KEY (`hash`),
+				  KEY `board` (`board`,`thread`)
+				) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
 		case false:
 			// Update version number
 			file_write($config['has_installed'], VERSION);
-- 
cgit v1.3