Secure cookie key

[nucleus-jp/nucleus-jp-ancient.git] / nucleus / upgrades / upgrade1.0.php

diff --git a/nucleus/upgrades/upgrade1.0.php b/nucleus/upgrades/upgrade1.0.php
index 435889e..a28c739 100755 (executable)
--- a/nucleus/upgrades/upgrade1.0.php
+++ b/nucleus/upgrades/upgrade1.0.php
@@ -1,41 +1,41 @@
-<?php\r
-function upgrade_do10() {\r
-       \r
-if (upgrade_checkinstall(10))\r
-       return "already installed";\r
-\r
-// 1. add mcookiekey to nucleus_member\r
-$query =  'ALTER TABLE '.sql_table('member')\r
-       . " ADD mcookiekey varchar(40) ";\r
-$res = upgrade_query("Adding cookiekey attribute to members",$query);       \r
-\r
-// only do this when the previous query succeeds\r
-if ($res) {\r
-       // 2. for all members: hash their password and also copy it to mcookiekey\r
-       $query = 'SELECT * FROM '.sql_table('member');\r
-       $res = mysql_query($query);\r
-       while ($current = mysql_fetch_object($res)) {\r
-               $hashedpw = md5($current->mpassword);\r
-               $updquery = 'UPDATE '.sql_table('member')." SET mpassword='$hashedpw' WHERE mnumber=" . $current->mnumber;\r
-               upgrade_query("Encrypting password for member " . $current->mnumber,$updquery);\r
-       }\r
-}\r
-\r
-// 3. add extra indices to tables\r
-$query = 'ALTER TABLE '.sql_table('item').' ADD INDEX(iblog, itime);';\r
-upgrade_query("Adding extra index to nucleus_item",$query);\r
-$query = 'ALTER TABLE '.sql_table('comment').' ADD INDEX(citem);';\r
-upgrade_query("Adding extra index to nucleus_comment",$query);\r
-\r
-// 4. add DisableJsTools to config\r
-$query = 'INSERT INTO '.sql_table('config')." VALUES ('DisableJsTools', '0');";\r
-upgrade_query("Adding setting DisableJsTools",$query);\r
-\r
-// 5. Drop primary key in nucleus_actionlog\r
-$query = 'ALTER TABLE '.sql_table('actionlog').' DROP PRIMARY KEY;';\r
-upgrade_query("Dropping primary key for actionlog table",$query);\r
-\r
-}\r
-\r
-\r
+<?php
+function upgrade_do10() {
+       
+if (upgrade_checkinstall(10))
+       return "already installed";
+
+// 1. add mcookiekey to nucleus_member
+$query =  'ALTER TABLE '.sql_table('member')
+       . " ADD mcookiekey varchar(40) ";
+$res = upgrade_query("Adding cookiekey attribute to members",$query);       
+
+// only do this when the previous query succeeds
+if ($res) {
+       // 2. for all members: hash their password and also copy it to mcookiekey
+       $query = 'SELECT * FROM '.sql_table('member');
+       $res = mysql_query($query);
+       while ($current = mysql_fetch_object($res)) {
+               $hashedpw = md5($current->mpassword);
+               $updquery = 'UPDATE '.sql_table('member')." SET mpassword='$hashedpw' WHERE mnumber=" . $current->mnumber;
+               upgrade_query("Encrypting password for member " . $current->mnumber,$updquery);
+       }
+}
+
+// 3. add extra indices to tables
+$query = 'ALTER TABLE '.sql_table('item').' ADD INDEX(iblog, itime);';
+upgrade_query("Adding extra index to nucleus_item",$query);
+$query = 'ALTER TABLE '.sql_table('comment').' ADD INDEX(citem);';
+upgrade_query("Adding extra index to nucleus_comment",$query);
+
+// 4. add DisableJsTools to config
+$query = 'INSERT INTO '.sql_table('config')." VALUES ('DisableJsTools', '0');";
+upgrade_query("Adding setting DisableJsTools",$query);
+
+// 5. Drop primary key in nucleus_actionlog
+$query = 'ALTER TABLE '.sql_table('actionlog').' DROP PRIMARY KEY;';
+upgrade_query("Dropping primary key for actionlog table",$query);
+
+}
+
+
 ?>
\ No newline at end of file