Added 'safe_mode' (php.ini setting).

[ctracker.git] / libs / lib_updates.php

diff --git a/libs/lib_updates.php b/libs/lib_updates.php
index 86cfc76876aa6e8016e1bb318b8d45fc166322e0..a0ea51d2e79739891b530f92c6127b65e0d8e94d 100644 (file)
--- a/libs/lib_updates.php
+++ b/libs/lib_updates.php
@@ -4,7 +4,7 @@
  *
  * @author             Roland Haeder <webmaster@ship-simu.org>
  * @version            3.0.0
- * @copyright  Copyright (c) 2009, 2010 Cracker Tracker Team
+ * @copyright  Copyright (c) 2009 - 2011 Cracker Tracker Team
  * @license            GNU GPL 3.0 or any newer version
  * @link               http://www.ship-simu.org
  *
@@ -43,7 +43,7 @@ UNIQUE KEY (`ctracker_ticket_remote_addr`)
 `ctracker_ticket_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `ctracker_data_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY ( `ctracker_ticket_data_id` ),
-UNIQUE KEY `ctracker_ticket_data` ( `ctracker_ticket_id`,`ctracker_data_id` ),
+UNIQUE KEY `ctracker_ticket_data` ( `ctracker_ticket_id`, `ctracker_data_id` ),
 INDEX ( `ctracker_data_id` ),
 FOREIGN KEY ( `ctracker_ticket_id` ) REFERENCES `' . $GLOBALS['ctracker_dbname'] . '`.`ctracker_ticket` (
 `ctracker_ticket`
@@ -52,7 +52,26 @@ FOREIGN KEY ( `ctracker_data_id` ) REFERENCES `' . $GLOBALS['ctracker_dbname'] .
 `id`
 ) ON DELETE CASCADE
 ) TYPE=InnoDB',
-               )
+               ),
+
+               // NULL for missing values
+               1 => array(
+                       "ALTER TABLE `ctracker_data` CHANGE `script_name` `script_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Full script name'",
+                       "UPDATE `ctracker_data` SET `script_name`=NULL WHERE `script_name`=''",
+                       "ALTER TABLE `ctracker_data` CHANGE `server_name` `server_name` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Server''s host name'",
+                       "UPDATE `ctracker_data` SET `server_name`=NULL WHERE `server_name`=''",
+               ),
+
+               // Also store proxy address
+               2 => array(
+                       'ALTER TABLE `ctracker_data` ADD `proxy_addr` VARCHAR(15) NULL DEFAULT NULL',
+                       '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 )',
+               ),
        );
 }