From 5cc7bd860fe653db831b20c7937a80ef35221f56 Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Thu, 22 Aug 2013 03:35:57 +1000
Subject: Add cache and gm to pre-installation test. Don't die when we can't
 write to templates/cache.

---
 install.php | 24 +++++++++++++++++++++++-
 1 file changed, 23 insertions(+), 1 deletion(-)

(limited to 'install.php')

diff --git a/install.php b/install.php
index a6937028..8725df6d 100644
--- a/install.php
+++ b/install.php
@@ -512,6 +512,13 @@ if ($step == 0) {
 			'required' => false,
 			'message' => '(Optional) `identify` was not found or executable; command-line ImageMagick image processing cannot be enabled.',
 		),
+		array(
+			'category' => 'Image processing',
+			'name' => '`gm` (command-line GraphicsMagick)',
+			'result' => $can_exec && shell_exec('which gm'),
+			'required' => false,
+			'message' => '(Optional) `gm` was not found or executable; command-line GraphicsMagick (faster than ImageMagick) cannot be enabled.',
+		),
 		array(
 			'category' => 'Image processing',
 			'name' => '`gifsicle` (command-line animted GIF thumbnailing)',
@@ -526,12 +533,27 @@ if ($step == 0) {
 			'required' => true,
 			'message' => 'Tinyboard does not have permission to create directories (boards) here. You will need to <code>chmod</code> (or operating system equivalent) appropriately.'
 		),
+		array(
+			'category' => 'File permissions',
+			'name' => getcwd() . '/templates/cache',
+			'result' => is_writable('templates') && (!is_dir('templates/cache') || is_writable('templates/cache')),
+			'required' => true,
+			'message' => 'You must give Tinyboard permission to create (and write to) the <code>templates/cache</code> directory or performance will be drastically reduced.'
+		),
 		array(
 			'category' => 'File permissions',
 			'name' => getcwd() . '/inc/instance-config.php',
 			'result' => is_writable('inc/instance-config.php'),
 			'required' => false,
-			'message' => 'Tinyboard does not have permission to make changes to inc/instance-config.php. To complete the installation, you will be asked to manually copy and paste code into the file instead.'
+			'message' => 'Tinyboard does not have permission to make changes to <code>inc/instance-config.php</code>. To complete the installation, you will be asked to manually copy and paste code into the file instead.'
+		),
+		array(
+			'category' => 'Misc',
+			'name' => 'Caching available (APC, XCache, Memcached or Redis)',
+			'result' => extension_loaded('apc') || extension_loaded('xcache')
+				|| extension_loaded('memcached') || extension_loaded('redis'),
+			'required' => false,
+			'message' => 'You will not be able to enable the additional caching system, designed to minimize SQL queries and significantly improve performance. <a href="http://php.net/manual/en/book.apc.php">APC</a> is the recommended method of caching, but <a href="http://xcache.lighttpd.net/">XCache</a>, <a href="http://www.php.net/manual/en/intro.memcached.php">Memcached</a> and <a href="http://pecl.php.net/package/redis">Redis</a> are also supported.'
 		),
 		array(
 			'category' => 'Misc',
-- 
cgit v1.3


From 5aaa6887f647a2d16b5db995c434cea4ce98538d Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Wed, 28 Aug 2013 18:02:28 +1000
Subject: Add `ip` index to post tables for faster ?/IP/ (and flood detection,
 etc.)

---
 install.php         | 6 +++++-
 templates/posts.sql | 3 ++-
 2 files changed, 7 insertions(+), 2 deletions(-)

(limited to 'install.php')

diff --git a/install.php b/install.php
index 8725df6d..3054bf10 100644
--- a/install.php
+++ b/install.php
@@ -1,7 +1,7 @@
 <?php
 
 // Installation/upgrade file	
-define('VERSION', 'v0.9.6-dev-12');
+define('VERSION', 'v0.9.6-dev-13');
 
 require 'inc/functions.php';
 
@@ -364,6 +364,10 @@ if (file_exists($config['has_installed'])) {
 					CHANGE  `file`  `file` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ;",
 					$board['uri'])) or error(db_error());
 			}
+		case 'v0.9.6-dev-12':
+			foreach ($boards as &$board) {
+				query(sprintf("ALTER TABLE  ``posts_%s`` ADD INDEX `ip` (`ip`)", $board['uri'])) or error(db_error());
+			}
 		case false:
 			// Update version number
 			file_write($config['has_installed'], VERSION);
diff --git a/templates/posts.sql b/templates/posts.sql
index 4eef3a0d..1e092985 100644
--- a/templates/posts.sql
+++ b/templates/posts.sql
@@ -28,6 +28,7 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` (
    UNIQUE KEY `id` (`id`),
    KEY `thread_id` (`thread`,`id`),
    KEY `time` (`time`),
-   FULLTEXT KEY `body` (`body`)
+   FULLTEXT KEY `body` (`body`),
+   KEY `ip` (`ip`),
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
  
\ No newline at end of file
-- 
cgit v1.3


From 10d59e949aece5d4dd5c1b54d9b26300f792a3db Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Wed, 28 Aug 2013 18:39:45 +1000
Subject: Performance: Add `expires` index to antispm table to make purging old
 hashes a little quicker

---
 install.php | 4 +++-
 install.sql | 3 ++-
 2 files changed, 5 insertions(+), 2 deletions(-)

(limited to 'install.php')

diff --git a/install.php b/install.php
index 3054bf10..35c1ecb7 100644
--- a/install.php
+++ b/install.php
@@ -1,7 +1,7 @@
 <?php
 
 // Installation/upgrade file	
-define('VERSION', 'v0.9.6-dev-13');
+define('VERSION', 'v0.9.6-dev-14');
 
 require 'inc/functions.php';
 
@@ -368,6 +368,8 @@ if (file_exists($config['has_installed'])) {
 			foreach ($boards as &$board) {
 				query(sprintf("ALTER TABLE  ``posts_%s`` ADD INDEX `ip` (`ip`)", $board['uri'])) or error(db_error());
 			}
+		case 'v0.9.6-dev-13':
+			query("ALTER TABLE ``antispam`` ADD INDEX `expires` (`expires`)") or error(db_error());
 		case false:
 			// Update version number
 			file_write($config['has_installed'], VERSION);
diff --git a/install.sql b/install.sql
index db89452b..e52f1f89 100644
--- a/install.sql
+++ b/install.sql
@@ -29,7 +29,8 @@ CREATE TABLE IF NOT EXISTS `antispam` (
   `expires` int(11) DEFAULT NULL,
   `passed` smallint(6) NOT NULL,
   PRIMARY KEY (`hash`),
-  KEY `board` (`board`,`thread`)
+  KEY `board` (`board`,`thread`),
+  KEY `expires` (`expires`)
 ) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin;
 
 -- --------------------------------------------------------
-- 
cgit v1.3