[geeklog-cvs] geeklog-1.3/public_html/admin/install install.php,1.47,1.48

[geeklog-cvs-admin at lists.geeklog.net]

Update of /usr/cvs/geeklog/geeklog-1.3/public_html/admin/install
In directory internal.geeklog.net:/tmp/cvs-serv13046/public_html/admin/install

Modified Files:
	install.php 
Log Message:
Changes for an improved Static Pages editor and more flexibility positioning Static Pages on the frontpage.


Index: install.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/public_html/admin/install/install.php,v
retrieving revision 1.47
retrieving revision 1.48
diff -C2 -d -r1.47 -r1.48
*** install.php	24 Mar 2003 17:42:17 -0000	1.47
--- install.php	30 May 2003 12:24:32 -0000	1.48
***************
*** 414,418 ****
                      . "ADD COLUMN perm_anon tinyint(1) unsigned DEFAULT '2',"
                      . "ADD COLUMN sp_php tinyint(1) unsigned DEFAULT '0',"
!                     . "ADD COLUMN sp_nf tinyint(1) unsigned DEFAULT '0'");
                  DB_query ("INSERT INTO {$_TABLES['features']} (ft_name, ft_descr) VALUES ('staticpages.PHP','Ability to use PHP in static pages')");
                  $php_id = DB_insertId ();
--- 414,421 ----
                      . "ADD COLUMN perm_anon tinyint(1) unsigned DEFAULT '2',"
                      . "ADD COLUMN sp_php tinyint(1) unsigned DEFAULT '0',"
!                     . "ADD COLUMN sp_nf tinyint(1) unsigned DEFAULT '0',"
!                     . "ADD COLUMN sp_centerblock tinyint(1) unsigned NOT NULL default '0',"
!                     . "ADD COLUMN sp_tid varchar(20) NOT NULL default 'none',"
!                     . "ADD COLUMN sp_where tinyint(1) unsigned NOT NULL default '1'");
                  DB_query ("INSERT INTO {$_TABLES['features']} (ft_name, ft_descr) VALUES ('staticpages.PHP','Ability to use PHP in static pages')");
                  $php_id = DB_insertId ();
***************
*** 423,427 ****
                      . "DROP COLUMN sp_pos,"
                      . "DROP COLUMN sp_search_keywords,"
!                     . "ADD COLUMN sp_nf tinyint(1) unsigned DEFAULT '0'");
              }
  
--- 426,433 ----
                      . "DROP COLUMN sp_pos,"
                      . "DROP COLUMN sp_search_keywords,"
!                     . "ADD COLUMN sp_nf tinyint(1) unsigned DEFAULT '0',"
!                     . "ADD COLUMN sp_centerblock tinyint(1) unsigned NOT NULL default '0',"
!                     . "ADD COLUMN sp_tid varchar(20) NOT NULL default 'none',"
!                     . "ADD COLUMN sp_where tinyint(1) unsigned NOT NULL default '1'");
              }
  
***************
*** 442,445 ****
--- 448,461 ----
                          $A = DB_fetchArray ($result);
                          DB_query ("UPDATE {$_TABLES['staticpage']} SET owner_id = '{$A['sp_uid']}' WHERE sp_uid = '{$A['sp_uid']}'");
+                     }
+                 }
+ 
+                 $result = DB_query ("SELECT sp_label FROM {$_TABLES['staticpage']} WHERE sp_title = 'Frontpage'");
+                 if (DB_numRows ($result) > 0) {
+                     $A = DB_fetchArray ($result);
+                     if ($A['sp_label'] == 'nonews') {
+                         DB_query ("UPDATE {$_TABLES['staticpage']} SET sp_centerblock = 1, sp_where = 0 WHERE sp_title = 'Frontpage'");
+                     } else {
+                         DB_query ("UPDATE {$_TABLES['staticpage']} SET sp_centerblock = 1 WHERE sp_title = 'Frontpage'");
                      }
                  }