[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.8_to_1.3.9.php,1.3,1.4

[dhaun at geeklog.net]

Update of /usr/cvs/geeklog/geeklog-1.3/sql/updates
In directory geeklog_prod:/tmp/cvs-serv21793/updates

Modified Files:
	mysql_1.3.8_to_1.3.9.php 
Log Message:
Remove the option to stay logged in for 1 year.


Index: mysql_1.3.8_to_1.3.9.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/sql/updates/mysql_1.3.8_to_1.3.9.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mysql_1.3.8_to_1.3.9.php	11 Jan 2004 21:23:07 -0000	1.3
--- mysql_1.3.8_to_1.3.9.php	2 Feb 2004 19:03:33 -0000	1.4
***************
*** 22,28 ****
--- 22,36 ----
  ) TYPE=MyISAM";
  
+ // remove unused entry (moved to 'syndication' table)
  $_SQL[] = "DELETE FROM {$_TABLES['vars']} WHERE name = 'rdf_sids'";
  
+ // extend max. length of static page IDs to 40 characters
  $_SQL[] = "ALTER TABLE {$_TABLES['staticpage']} CHANGE sp_id sp_id VARCHAR(40) NOT NULL";
+ 
+ // change "remember me" option to 1 Month for those who had it at 1 Year
+ $_SQL[] = "UPDATE {$_TABLES['users']} SET cookietimeout = 2678400 WHERE cookietimeout = 31536000";
+ 
+ // remove '1 Year' option
+ $_SQL[] = "DELETE FROM {$_TABLES['cookiecodes']} WHERE cc_value = 31536000";
  
  ?>