Index: trunk/CHANGELOG
===================================================================
--- trunk/CHANGELOG (revision 561)
+++ trunk/CHANGELOG (revision 562)
@@ -13,6 +13,7 @@
------------------------------------- 2.7.0 -------------------------------------
18-Jan-2008 Matthias Gallas
+! Updated news modul with features from the advanced news modul
! Updated form modul with features from the advanced form modul
# Fixed hardcoded /pages issue in intro page feature
+ Added example .htaccess to parse .html files, fixed bug in changeset 555
Index: trunk/wb/upgrade-script.php
===================================================================
--- trunk/wb/upgrade-script.php (revision 561)
+++ trunk/wb/upgrade-script.php (revision 562)
@@ -198,12 +198,12 @@
}
+$database = new database(DB_URL);
+
//******************************************************************************
-//The following lines upgrades the form modul from 2.6.x to the andvanced version from 2.7.x
+//Start of upgrade script for the form modul
//******************************************************************************
-$database = new database(DB_URL);
-
echo "
Adding new field to database table mod_form_settings
";
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_form_settings` ADD `success_email_subject` VARCHAR(255) NOT NULL AFTER `success_message`")) {
@@ -296,9 +296,104 @@
//End of upgrade script for the form modul
//******************************************************************************
+//******************************************************************************
+//Start of upgrade script for the news modul
+//******************************************************************************
+
+echo "
Adding new field to database table mod_news_posts
";
+if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_news_posts` ADD `published_when` INT NOT NULL AFTER `commenting`")) {
+ echo 'Database Field published_when added successfully
';
+}
+echo mysql_error().'
';
+
+// UPDATING DATA INTO FIELDS
+echo "
";
+
+// These are the default setting
+$header = '';
+$post_loop = '
+| [TITLE] |
+[MODI_TIME], [MODI_DATE] |
+
+
+|
+[SHORT]
+[TEXT_READ_MORE]
+ |
+
';
+$post_header = addslashes('
+');
+$post_footer = '
Last changed: [MODI_DATE] at [MODI_TIME]
+Back';
+$comments_header = addslashes('
+Comments
+');
+
+// Insert default settings into database
+$query_dates = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_settings where section_id != 0 and page_id != 0");
+while($result = $query_dates->fetchRow()) {
+
+ echo "Add default settings data to database for news section_id= ".$result['section_id']."
";
+ $section_id = $result['section_id'];
+
+ if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `header` = '$header' WHERE `section_id` = $section_id")) {
+ echo 'Database data header added successfully
';
+ }
+ echo mysql_error().'
';
+
+ if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_loop` = '$post_loop' WHERE `section_id` = $section_id")) {
+ echo 'Database data post_loop added successfully
';
+ }
+ echo mysql_error().'
';
+
+ if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_header` = '$post_header' WHERE `section_id` = $section_id")) {
+ echo 'Database data post_header added successfully
';
+ }
+ echo mysql_error().'
';
+
+ if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_footer` = '$post_footer' WHERE `section_id` = $section_id")) {
+ echo 'Database data post_footer added successfully
';
+ }
+ echo mysql_error().'
';
+
+ if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_header` = '$comments_header' WHERE `section_id` = $section_id")) {
+ echo 'Database data comments_header added successfully
';
+ }
+ echo mysql_error().'
';
+
+}
+
+// MIGRATING FIELD DATES to POSTED_WHEN
+echo "Copying field posted_when value to published_when
";
+$query_dates = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts where section_id != 0 and page_id != 0");
+
+while($result = $query_dates->fetchRow()) {
+ $pid = $result['post_id'];
+ $NEW_DATE = $result['posted_when'];
+ if($database->query("UPDATE `".TABLE_PREFIX."mod_news_posts` SET `published_when` = '$NEW_DATE' WHERE `post_id` = $pid")) {
+ echo 'Copying posted_when value to published_when successfully
';
+ }
+ echo mysql_error().'
';
+}
+
+//******************************************************************************
+//End of upgrade script for the news modul
+//******************************************************************************
+
echo "
Done
";
?>
-