Changeset 2319:abe2702e1585 for inc/dbschema

Timestamp:

10/09/13 08:37:56 (12 years ago)

Author:

Denis Jean-Chirstian <contact@…>

Branch:

default

Message:

Move ex-daInstaller settings to core and install and upgrade

File:

• inc/dbschema/upgrade.php (modified) (3 diffs)

inc/dbschema/upgrade.php

@@ -361 +361 @@
                     }
 
-                    # add new settings for date and time formats
+                    # Some settings change, prepare db queries
+                    $strReqFormat = 'INSERT INTO '.$core->prefix.'setting';
+                    $strReqFormat .= ' (setting_id,setting_ns,setting_value,setting_type,setting_label)';
+                    $strReqFormat .= ' VALUES(\'%s\',\'system\',\'%s\',\'string\',\'%s\')';
+
+                    $strReqSelect = 'SELECT count(1) FROM '.$core->prefix.'setting';
+                    $strReqSelect .= ' WHERE setting_id = \'%s\'';
+                    $strReqSelect .= ' AND setting_ns = \'system\'';
+                    $strReqSelect .= ' AND blog_id IS NULL';
+
+                    # Add date and time formats
                     $date_formats = array('%Y-%m-%d','%m/%d/%Y','%d/%m/%Y','%Y/%m/%d','%d.%m.%Y','%b %e %Y','%e %b %Y','%Y %b %e',
                     '%a, %Y-%m-%d','%a, %m/%d/%Y','%a, %d/%m/%Y','%a, %Y/%m/%d','%B %e, %Y','%e %B, %Y','%Y, %B %e','%e. %B %Y',
@@ -372 +382 @@
                     }
 
-                    $strReqFormat = 'INSERT INTO '.$core->prefix.'setting';
-                    $strReqFormat .= ' (setting_id,setting_ns,setting_value,setting_type,setting_label)';
-                    $strReqFormat .= ' VALUES(\'%s\',\'system\',\'%s\',\'string\',\'%s\')';
-                    
-                    $strReqSelect = 'SELECT count(1) FROM '.$core->prefix.'setting';
-                    $strReqSelect .= ' WHERE setting_id = \'%s\'';
-                    $strReqSelect .= ' AND setting_ns = \'system\'';
-                    $strReqSelect .= ' AND blog_id IS NULL';
-
                     $rs = $core->con->select(sprintf($strReqSelect,'date_formats'));
                     if ($rs->f(0)==0) {
@@ -390 +391 @@
                          $strReq = sprintf($strReqFormat,'time_formats',serialize($time_formats),'Time formats examples');
                          $core->con->execute($strReq);
+                    }
+
+                    # Add repository URL for themes and plugins as daInstaller move to core
+                    $rs = $core->con->select(sprintf($strReqSelect,'store_plugin_url'));
+                    if ($rs->f(0)==0) {
+                         $strReq = sprintf($strReqFormat,'store_plugin_url','http://update.dotaddict.org/dc2/plugins.xml','Plugins XML feed location');
+                         $core->con->execute($strReq);                      
+                    }
+                    $rs = $core->con->select(sprintf($strReqSelect,'store_theme_url'));
+                    if ($rs->f(0)==0) {
+                         $strReq = sprintf($strReqFormat,'store_theme_url','http://update.dotaddict.org/dc2/themes.xml','Themes XML feed location');
+                         $core->con->execute($strReq);                      
                     }
                }