X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=libs%2Flib_updates.php;h=fd34fcc6c4159f32a70e8973b25d3a6d3c812867;hb=ee616bf74be728a09f61774d9d0c41eafdeefd0d;hp=a0ea51d2e79739891b530f92c6127b65e0d8e94d;hpb=f04c12e110290e17545ee05dcfa058feba6cbb82;p=ctracker.git

diff --git a/libs/lib_updates.php b/libs/lib_updates.php
index a0ea51d..fd34fcc 100644
--- a/libs/lib_updates.php
+++ b/libs/lib_updates.php
@@ -2,11 +2,11 @@
 /**
  * Automatic database updates
  *
- * @author		Roland Haeder <webmaster@ship-simu.org>
+ * @author		Roland Haeder <webmaster@shipsimu.org>
  * @version		3.0.0
  * @copyright	Copyright (c) 2009 - 2011 Cracker Tracker Team
  * @license		GNU GPL 3.0 or any newer version
- * @link		http://www.ship-simu.org
+ * @link		http://www.shipsimu.org
  *
  * This program is free software: you can redistribute it and/or modify
  * it under the terms of the GNU General Public License as published by
@@ -64,13 +64,39 @@ FOREIGN KEY ( `ctracker_data_id` ) REFERENCES `' . $GLOBALS['ctracker_dbname'] .
 
 		// Also store proxy address
 		2 => array(
-			'ALTER TABLE `ctracker_data` ADD `proxy_addr` VARCHAR(15) NULL DEFAULT NULL',
+			'ALTER TABLE `ctracker_data` ADD `proxy_addr` VARCHAR(15) NULL DEFAULT NULL AFTER `remote_addr`',
 			'ALTER TABLE `ctracker_ticket` ADD `ctracker_ticket_proxy_addr` VARCHAR(15) NULL DEFAULT NULL',
 		),
 
 		// Better key for always repeating query
 		4 => array(
-			'ALTER TABLE `ctracker`.`ctracker_data` ADD INDEX `remote_proxy_last` ( `remote_addr`, `proxy_addr`, `last_attempt` DESC )',
+			'ALTER TABLE `ctracker_data` ADD INDEX `remote_proxy_last` ( `remote_addr`, `proxy_addr`, `last_attempt` DESC )',
+		),
+
+		// HTTP request method
+		5 => array(
+			"ALTER TABLE `ctracker_data` ADD `request_method` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'HTTP request method' AFTER `referer`, ADD INDEX ( `request_method` )",
+		),
+
+		// Index on count
+		6 => array(
+			'ALTER TABLE `ctracker_data` ADD INDEX `count` (`count`)',
+		),
+
+		// Log also UA after check
+		7 => array(
+			"ALTER TABLE `ctracker_data`
+			ADD `check_ua` tinytext COLLATE 'utf8_general_ci' NULL COMMENT 'User agent after check' AFTER `post_data`,
+			CHANGE `check_worm` `check_get` tinytext COLLATE 'utf8_general_ci' NOT NULL COMMENT 'GET data after check' AFTER `check_ua`,
+			CHANGE `check_post` `check_post` tinytext COLLATE 'utf8_general_ci' NOT NULL COMMENT 'POST data after check' AFTER `check_worm`",
+		),
+
+		// View for request methods
+		8 => array(
+			'CREATE VIEW `view_most_request_methods` AS
+			SELECT SQL_CALC_FOUND_ROWS COUNT(`id`) AS `total_rows`, `request_method`
+			FROM `ctracker_data`
+			GROUP BY `request_method`'
 		),
 	);
 }
@@ -83,6 +109,3 @@ function runCrackerTrackerUpdates ($update) {
 		runCrackerTrackerSql($sql, __FUNCTION__, __LINE__);
 	} // END - foreach
 }
-
-// [EOF]
-?>