Changeset 2840:8777e1372db4

Timestamp:

12/14/14 10:20:18 (11 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

2.7

Message:

Copy nb_post_per_page to nb_post_for_home during Dotclear upgrade, should fixes #2013

File:

• inc/dbschema/upgrade.php (modified) (1 diff)

inc/dbschema/upgrade.php

@@ -406 +406 @@
                }
 
+               if (version_compare($version,'2.7','<='))
+               {
+                    # Some new settings should be initialized, 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\')';
+
+                    $strReqCount = 'SELECT count(1) FROM '.$core->prefix.'setting';
+                    $strReqCount .= ' WHERE setting_id = \'%s\'';
+                    $strReqCount .= ' AND setting_ns = \'system\'';
+                    $strReqCount .= ' AND blog_id IS NULL';
+
+                    $strReqSelect = 'SELECT setting_value FROM '.$core->prefix.'setting';
+                    $strReqSelect .= ' WHERE setting_id = \'%s\'';
+                    $strReqSelect .= ' AND setting_ns = \'system\'';
+                    $strReqSelect .= ' AND blog_id IS NULL';
+
+                    # Add nb of posts for home (first page), copying nb of posts on every page
+                    $rs = $core->con->select(sprintf($strReqCount,'nb_post_for_home'));
+                    if ($rs->f(0)==0) {
+                         $rs = $core->con->select(sprintf($strReqSelect,'nb_post_per_page'));
+                         $strReq = sprintf($strReqFormat,'nb_post_for_home',$rs->f(0),'Nb of posts on home (first page only)');
+                         $core->con->execute($strReq);
+                    }
+               }
+
                $core->setVersion('core',DC_VERSION);
                $core->blogDefaults();