Completed
Push — master ( 593857...cd1c2d )
by Michael
29s queued 20s
created
upgrade/upd-2.0.15-to-2.0.16/index.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -30,7 +30,7 @@  discard block
 block discarded – undo
30 30
     {
31 31
         $xoops = Xoops::getInstance();
32 32
         $db = $xoops->db();
33
-        $value = getDbValue($db, 'config', 'conf_id', "`conf_name` = 'ldap_use_TLS' AND `conf_catid` = " . XOOPS_CONF_AUTH);
33
+        $value = getDbValue($db, 'config', 'conf_id', "`conf_name` = 'ldap_use_TLS' AND `conf_catid` = ".XOOPS_CONF_AUTH);
34 34
         return (bool)($value);
35 35
     }
36 36
 
@@ -55,7 +55,7 @@  discard block
 block discarded – undo
55 55
         );
56 56
         foreach ($data as $name => $values) {
57 57
             if (!getDbValue($db, 'config', 'conf_id', "`conf_modid`=0 AND `conf_catid`=7 AND `conf_name`='$name'")) {
58
-                $this->query("INSERT INTO `$table` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) " . "VALUES ( 0,7,'$name',$values)");
58
+                $this->query("INSERT INTO `$table` (conf_modid,conf_catid,conf_name,conf_title,conf_value,conf_desc,conf_formtype,conf_valuetype,conf_order) "."VALUES ( 0,7,'$name',$values)");
59 59
             }
60 60
         }
61 61
         return true;
Please login to merge, or discard this patch.
upgrade/login.php 2 patches
Spacing   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -23,12 +23,12 @@  discard block
 block discarded – undo
23 23
 } else {
24 24
     $xoops = Xoops::getInstance();
25 25
     $myts = MyTextsanitizer::getInstance();
26
-    $uname = !isset($_POST['uname']) ? '' : $myts->addSlashes( trim($_POST['uname']) );
27
-    $pass = !isset($_POST['pass']) ? '' : $myts->addSlashes( trim($_POST['pass']) );
26
+    $uname = !isset($_POST['uname']) ? '' : $myts->addSlashes(trim($_POST['uname']));
27
+    $pass = !isset($_POST['pass']) ? '' : $myts->addSlashes(trim($_POST['pass']));
28 28
 
29 29
     $member_handler = $xoops->getHandlerMember();
30 30
 
31
-    if (!@include_once XOOPS_ROOT_PATH.'/language/' . $upgrade_language . '/auth.php') {
31
+    if (!@include_once XOOPS_ROOT_PATH.'/language/'.$upgrade_language.'/auth.php') {
32 32
         include_once XOOPS_ROOT_PATH.'/language/english/auth.php';
33 33
     }
34 34
     $xoopsAuth = Xoops_Auth_Factory::getAuthConnection($uname);
@@ -48,7 +48,7 @@  discard block
 block discarded – undo
48 48
             $groups = $user->getGroups();
49 49
             if (in_array(XOOPS_GROUP_ADMIN, $groups) || array_intersect($groups, $xoopsConfig['closesite_okgrp'])) {
50 50
                 $isAllowed = true;
51
-            }  else {
51
+            } else {
52 52
                 $isAllowed = false;
53 53
             }
54 54
         }
@@ -69,14 +69,14 @@  discard block
 block discarded – undo
69 69
 
70 70
         // Set cookie for rememberme
71 71
         if ($xoops->getConfig('usercookie')) {
72
-            if ( !empty($_POST["rememberme"]) ) {
73
-                setcookie($xoops->getConfig('usercookie'), $_SESSION['xoopsUserId'], time() + 31536000, '/',  '', 0);
72
+            if (!empty($_POST["rememberme"])) {
73
+                setcookie($xoops->getConfig('usercookie'), $_SESSION['xoopsUserId'], time() + 31536000, '/', '', 0);
74 74
             } else {
75
-                setcookie($xoops->getConfig('usercookie'), 0, -1, '/',  '', 0);
75
+                setcookie($xoops->getConfig('usercookie'), 0, -1, '/', '', 0);
76 76
             }
77 77
         }
78 78
     }
79 79
 
80
-    header("location: " . XOOPS_URL . "/upgrade/index.php");
80
+    header("location: ".XOOPS_URL."/upgrade/index.php");
81 81
     exit();
82 82
 }
83 83
\ No newline at end of file
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -48,7 +48,7 @@
 block discarded – undo
48 48
             $groups = $user->getGroups();
49 49
             if (in_array(XOOPS_GROUP_ADMIN, $groups) || array_intersect($groups, $xoopsConfig['closesite_okgrp'])) {
50 50
                 $isAllowed = true;
51
-            }  else {
51
+            } else {
52 52
                 $isAllowed = false;
53 53
             }
54 54
         }
Please login to merge, or discard this patch.
upgrade/abstract.php 1 patch
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -60,7 +60,9 @@
 block discarded – undo
60 60
         $tasks = $_SESSION['xoops_upgrade'][$step];
61 61
         foreach ($tasks as $task) {
62 62
             $res = $this->{"apply_{$task}"}();
63
-            if (!$res) return false;
63
+            if (!$res) {
64
+                return false;
65
+            }
64 66
             array_shift($_SESSION['xoops_upgrade'][$step]);
65 67
         }
66 68
         return true;
Please login to merge, or discard this patch.
upgrade/cnt-2.2.x-to-2.3.0/language/english.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -4,7 +4,7 @@
 block discarded – undo
4 4
 // _CHARSET : UTF-8
5 5
 // Translator: XOOPS Translation Team
6 6
 
7
-define("_CONFIRM_UPGRADE_220","
7
+define("_CONFIRM_UPGRADE_220", "
8 8
 The upgrade scripts will migrate data from existent 'profile' module.<br />
9 9
 Please don't uninstall the existent 'profile' module manually, otherwise corresponding data won't be migrated.<br /><br />
10 10
 Once the upgrade process is fully completed please <stong>go to module administration area to updade 'profile' module</strong>, by which profile data will be migrated completely.<br /><br />
Please login to merge, or discard this patch.
upgrade/cnt-2.2.x-to-2.3.0/index.php 2 patches
Indentation   -3 removed lines patch added patch discarded remove patch
@@ -27,7 +27,6 @@  discard block
 block discarded – undo
27 27
 
28 28
     /**
29 29
      * Check if config category already removed
30
-
31 30
      */
32 31
     function check_config()
33 32
     {
@@ -45,7 +44,6 @@  discard block
 block discarded – undo
45 44
 
46 45
     /**
47 46
      * Check if user profile table already converted
48
-
49 47
      */
50 48
     function check_profile()
51 49
     {
@@ -67,7 +65,6 @@  discard block
 block discarded – undo
67 65
 
68 66
     /**
69 67
      * Check if block table already converted
70
-
71 68
      */
72 69
     function check_block()
73 70
     {
Please login to merge, or discard this patch.
Spacing   +121 added lines, -121 removed lines patch added patch discarded remove patch
@@ -32,7 +32,7 @@  discard block
 block discarded – undo
32 32
     function check_config()
33 33
     {
34 34
         $xoops = Xoops::getInstance();
35
-        $sql = "SHOW COLUMNS FROM `" . $xoops->db()->prefix('configcategory') . "` LIKE 'confcat_modid'";
35
+        $sql = "SHOW COLUMNS FROM `".$xoops->db()->prefix('configcategory')."` LIKE 'confcat_modid'";
36 36
         $result = $xoops->db()->queryF($sql);
37 37
         if (!$result) {
38 38
             return true;
@@ -54,7 +54,7 @@  discard block
 block discarded – undo
54 54
         if (!$profile_module = $module_handler->getByDirname('profile')) {
55 55
             return true;
56 56
         }
57
-        $sql = "SHOW COLUMNS FROM " . $xoops->db()->prefix("users") . " LIKE 'posts'";
57
+        $sql = "SHOW COLUMNS FROM ".$xoops->db()->prefix("users")." LIKE 'posts'";
58 58
         $result = $xoops->db()->queryF($sql);
59 59
         if (!$result) {
60 60
             return false;
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
     function check_block()
73 73
     {
74 74
         $xoops = Xoops::getInstance();
75
-        $sql = "SHOW TABLES LIKE '" . $xoops->db()->prefix("block_instance") . "'";
75
+        $sql = "SHOW TABLES LIKE '".$xoops->db()->prefix("block_instance")."'";
76 76
         $result = $xoops->db()->queryF($sql);
77 77
         if (!$result) {
78 78
             return true;
@@ -101,25 +101,25 @@  discard block
 block discarded – undo
101 101
         $result = true;
102 102
 
103 103
         //Set core configuration back to zero for system module
104
-        $xoops->db()->queryF("UPDATE `" . $xoops->db()->prefix('config') . "` SET conf_modid = 0 WHERE conf_modid = 1");
104
+        $xoops->db()->queryF("UPDATE `".$xoops->db()->prefix('config')."` SET conf_modid = 0 WHERE conf_modid = 1");
105 105
 
106 106
         //Change debug modes so there can only be one active at any one time
107
-        $xoops->db()->queryF("UPDATE `" . $xoops->db()->prefix('config') . "` SET conf_formtype = 'select', conf_valuetype = 'int' WHERE conf_name = 'debug_mode'");
107
+        $xoops->db()->queryF("UPDATE `".$xoops->db()->prefix('config')."` SET conf_formtype = 'select', conf_valuetype = 'int' WHERE conf_name = 'debug_mode'");
108 108
 
109 109
         //Reset category ID for non-system configs
110
-        $xoops->db()->queryF("UPDATE `" . $xoops->db()->prefix('config') . "` SET conf_catid = 0 WHERE conf_modid > 1 AND conf_catid > 0");
110
+        $xoops->db()->queryF("UPDATE `".$xoops->db()->prefix('config')."` SET conf_catid = 0 WHERE conf_modid > 1 AND conf_catid > 0");
111 111
 
112 112
         // remove admin theme configuration item
113
-        $xoops->db()->queryF("DELETE FROM `" . $xoops->db()->prefix('config') . "` WHERE conf_name='theme_set_admin'");
113
+        $xoops->db()->queryF("DELETE FROM `".$xoops->db()->prefix('config')."` WHERE conf_name='theme_set_admin'");
114 114
 
115 115
         //Drop non-System config categories
116
-        $xoops->db()->queryF("DELETE FROM `" . $xoops->db()->prefix('configcategory') . "` WHERE confcat_modid > 1");
116
+        $xoops->db()->queryF("DELETE FROM `".$xoops->db()->prefix('configcategory')."` WHERE confcat_modid > 1");
117 117
 
118 118
         //Drop category information fields added in 2.2
119
-        $xoops->db()->queryF("ALTER TABLE `" . $xoops->db()->prefix("configcategory") . "` DROP `confcat_nameid`, DROP `confcat_description`, DROP `confcat_modid`");
119
+        $xoops->db()->queryF("ALTER TABLE `".$xoops->db()->prefix("configcategory")."` DROP `confcat_nameid`, DROP `confcat_description`, DROP `confcat_modid`");
120 120
 
121 121
         // Re-add user configuration category
122
-        $xoops->db()->queryF("INSERT INTO `" . $xoops->db()->prefix("configcategory") . "` (confcat_id, confcat_name, confcat_order) VALUES (2, '_MD_AM_USERSETTINGS', 2)");
122
+        $xoops->db()->queryF("INSERT INTO `".$xoops->db()->prefix("configcategory")."` (confcat_id, confcat_name, confcat_order) VALUES (2, '_MD_AM_USERSETTINGS', 2)");
123 123
 
124 124
         //Rebuild user configuration items
125 125
         //Get values from Profile module
@@ -155,31 +155,31 @@  discard block
 block discarded – undo
155 155
             }
156 156
         }
157 157
 
158
-        $xoops->db()->queryF("INSERT INTO `" .
159
-                $xoops->db()->prefix("config") .
160
-                "` (conf_modid, conf_catid, conf_name, conf_title, conf_value, conf_desc, conf_formtype, conf_valuetype, conf_order) VALUES " .
161
-                " (0, 2, 'minpass', '_MD_AM_MINPASS', " .
162
-                $xoops->db()->quote($profile_config_arr['minpass']) . ", '_MD_AM_MINPASSDSC', 'textbox', 'int', 1)," .
163
-                " (0, 2, 'minuname', '_MD_AM_MINUNAME', " .
164
-                $xoops->db()->quote($profile_config_arr['minuname']) . ", '_MD_AM_MINUNAMEDSC', 'textbox', 'int', 2)," . " (0, 2, 'new_user_notify', '_MD_AM_NEWUNOTIFY', " .
165
-                $xoops->db()->quote($profile_config_arr['new_user_notify']) . ", '_MD_AM_NEWUNOTIFYDSC', 'yesno', 'int', 4)," . " (0, 2, 'new_user_notify_group', '_MD_AM_NOTIFYTO', " .
166
-                $xoops->db()->quote($profile_config_arr['new_user_notify_group']) . ", '_MD_AM_NOTIFYTODSC', 'group', 'int', 6)," . " (0, 2, 'activation_type', '_MD_AM_ACTVTYPE', " .
167
-                $xoops->db()->quote($profile_config_arr['activation_type']) . ", '_MD_AM_ACTVTYPEDSC', 'select', 'int', 8)," . " (0, 2, 'activation_group', '_MD_AM_ACTVGROUP', ".
168
-                $xoops->db()->quote($profile_config_arr['activation_group']) . ", '_MD_AM_ACTVGROUPDSC', 'group', 'int', 10)," . " (0, 2, 'uname_test_level', '_MD_AM_UNAMELVL', " .
169
-                $xoops->db()->quote($profile_config_arr['uname_test_level']) . ", '_MD_AM_UNAMELVLDSC', 'select', 'int', 12)," . " (0, 2, 'avatar_allow_upload', '_MD_AM_AVATARALLOW', " .
170
-                $xoops->db()->quote($profile_config_arr['avatar_allow_upload']) . ", '_MD_AM_AVATARALWDSC', 'yesno', 'int', 14)," . " (0, 2, 'avatar_width', '_MD_AM_AVATARW', " .
171
-                $xoops->db()->quote($profile_config_arr['avatar_width']) . ", '_MD_AM_AVATARWDSC', 'textbox', 'int', 16)," . " (0, 2, 'avatar_height', '_MD_AM_AVATARH', " .
172
-                $xoops->db()->quote($profile_config_arr['avatar_height']) . ", '_MD_AM_AVATARHDSC', 'textbox', 'int', 18)," . " (0, 2, 'avatar_maxsize', '_MD_AM_AVATARMAX', " .
173
-                $xoops->db()->quote($profile_config_arr['avatar_maxsize']) . ", '_MD_AM_AVATARMAXDSC', 'textbox', 'int', 20)," . " (0, 2, 'self_delete', '_MD_AM_SELFDELETE', " .
174
-                $xoops->db()->quote($profile_config_arr['self_delete']) . ", '_MD_AM_SELFDELETEDSC', 'yesno', 'int', 22)," . " (0, 2, 'bad_unames', '_MD_AM_BADUNAMES', " .
175
-                $xoops->db()->quote($profile_config_arr['bad_unames']) . ", '_MD_AM_BADUNAMESDSC', 'textarea', 'array', 24)," . " (0, 2, 'bad_emails', '_MD_AM_BADEMAILS', " .
176
-                $xoops->db()->quote($profile_config_arr['bad_emails']) . ", '_MD_AM_BADEMAILSDSC', 'textarea', 'array', 26)," . " (0, 2, 'maxuname', '_MD_AM_MAXUNAME', " .
177
-                $xoops->db()->quote($profile_config_arr['maxuname']) . ", '_MD_AM_MAXUNAMEDSC', 'textbox', 'int', 3)," . " (0, 2, 'avatar_minposts', '_MD_AM_AVATARMP', " .
178
-                $xoops->db()->quote($profile_config_arr['avatar_minposts']) . ", '_MD_AM_AVATARMPDSC', 'textbox', 'int', 15)," . " (0, 2, 'allow_chgmail', '_MD_AM_ALLWCHGMAIL', " .
179
-                $xoops->db()->quote($profile_config_arr['allow_chgmail']) . ", '_MD_AM_ALLWCHGMAILDSC', 'yesno', 'int', 3)," . " (0, 2, 'reg_dispdsclmr', '_MD_AM_DSPDSCLMR', " .
180
-                $xoops->db()->quote($profile_config_arr['reg_dispdsclmr']) . ", '_MD_AM_DSPDSCLMRDSC', 'yesno', 'int', 30)," . " (0, 2, 'reg_disclaimer', '_MD_AM_REGDSCLMR', " .
181
-                $xoops->db()->quote($profile_config_arr['reg_disclaimer']) . ", '_MD_AM_REGDSCLMRDSC', 'textarea', 'text', 32)," . " (0, 2, 'allow_register', '_MD_AM_ALLOWREG', " .
182
-                $xoops->db()->quote($profile_config_arr['allow_register']) . ", '_MD_AM_ALLOWREGDSC', 'yesno', 'int', 0)");
158
+        $xoops->db()->queryF("INSERT INTO `".
159
+                $xoops->db()->prefix("config").
160
+                "` (conf_modid, conf_catid, conf_name, conf_title, conf_value, conf_desc, conf_formtype, conf_valuetype, conf_order) VALUES ".
161
+                " (0, 2, 'minpass', '_MD_AM_MINPASS', ".
162
+                $xoops->db()->quote($profile_config_arr['minpass']).", '_MD_AM_MINPASSDSC', 'textbox', 'int', 1),".
163
+                " (0, 2, 'minuname', '_MD_AM_MINUNAME', ".
164
+                $xoops->db()->quote($profile_config_arr['minuname']).", '_MD_AM_MINUNAMEDSC', 'textbox', 'int', 2),"." (0, 2, 'new_user_notify', '_MD_AM_NEWUNOTIFY', ".
165
+                $xoops->db()->quote($profile_config_arr['new_user_notify']).", '_MD_AM_NEWUNOTIFYDSC', 'yesno', 'int', 4),"." (0, 2, 'new_user_notify_group', '_MD_AM_NOTIFYTO', ".
166
+                $xoops->db()->quote($profile_config_arr['new_user_notify_group']).", '_MD_AM_NOTIFYTODSC', 'group', 'int', 6),"." (0, 2, 'activation_type', '_MD_AM_ACTVTYPE', ".
167
+                $xoops->db()->quote($profile_config_arr['activation_type']).", '_MD_AM_ACTVTYPEDSC', 'select', 'int', 8),"." (0, 2, 'activation_group', '_MD_AM_ACTVGROUP', ".
168
+                $xoops->db()->quote($profile_config_arr['activation_group']).", '_MD_AM_ACTVGROUPDSC', 'group', 'int', 10),"." (0, 2, 'uname_test_level', '_MD_AM_UNAMELVL', ".
169
+                $xoops->db()->quote($profile_config_arr['uname_test_level']).", '_MD_AM_UNAMELVLDSC', 'select', 'int', 12),"." (0, 2, 'avatar_allow_upload', '_MD_AM_AVATARALLOW', ".
170
+                $xoops->db()->quote($profile_config_arr['avatar_allow_upload']).", '_MD_AM_AVATARALWDSC', 'yesno', 'int', 14),"." (0, 2, 'avatar_width', '_MD_AM_AVATARW', ".
171
+                $xoops->db()->quote($profile_config_arr['avatar_width']).", '_MD_AM_AVATARWDSC', 'textbox', 'int', 16),"." (0, 2, 'avatar_height', '_MD_AM_AVATARH', ".
172
+                $xoops->db()->quote($profile_config_arr['avatar_height']).", '_MD_AM_AVATARHDSC', 'textbox', 'int', 18),"." (0, 2, 'avatar_maxsize', '_MD_AM_AVATARMAX', ".
173
+                $xoops->db()->quote($profile_config_arr['avatar_maxsize']).", '_MD_AM_AVATARMAXDSC', 'textbox', 'int', 20),"." (0, 2, 'self_delete', '_MD_AM_SELFDELETE', ".
174
+                $xoops->db()->quote($profile_config_arr['self_delete']).", '_MD_AM_SELFDELETEDSC', 'yesno', 'int', 22),"." (0, 2, 'bad_unames', '_MD_AM_BADUNAMES', ".
175
+                $xoops->db()->quote($profile_config_arr['bad_unames']).", '_MD_AM_BADUNAMESDSC', 'textarea', 'array', 24),"." (0, 2, 'bad_emails', '_MD_AM_BADEMAILS', ".
176
+                $xoops->db()->quote($profile_config_arr['bad_emails']).", '_MD_AM_BADEMAILSDSC', 'textarea', 'array', 26),"." (0, 2, 'maxuname', '_MD_AM_MAXUNAME', ".
177
+                $xoops->db()->quote($profile_config_arr['maxuname']).", '_MD_AM_MAXUNAMEDSC', 'textbox', 'int', 3),"." (0, 2, 'avatar_minposts', '_MD_AM_AVATARMP', ".
178
+                $xoops->db()->quote($profile_config_arr['avatar_minposts']).", '_MD_AM_AVATARMPDSC', 'textbox', 'int', 15),"." (0, 2, 'allow_chgmail', '_MD_AM_ALLWCHGMAIL', ".
179
+                $xoops->db()->quote($profile_config_arr['allow_chgmail']).", '_MD_AM_ALLWCHGMAILDSC', 'yesno', 'int', 3),"." (0, 2, 'reg_dispdsclmr', '_MD_AM_DSPDSCLMR', ".
180
+                $xoops->db()->quote($profile_config_arr['reg_dispdsclmr']).", '_MD_AM_DSPDSCLMRDSC', 'yesno', 'int', 30),"." (0, 2, 'reg_disclaimer', '_MD_AM_REGDSCLMR', ".
181
+                $xoops->db()->quote($profile_config_arr['reg_disclaimer']).", '_MD_AM_REGDSCLMRDSC', 'textarea', 'text', 32),"." (0, 2, 'allow_register', '_MD_AM_ALLOWREG', ".
182
+                $xoops->db()->quote($profile_config_arr['allow_register']).", '_MD_AM_ALLOWREGDSC', 'yesno', 'int', 0)");
183 183
 
184 184
         //Rebuild user configuration options
185 185
         $criteria = new CriteriaCompo(new Criteria('conf_name', "('activation_type', 'uname_test_level')", "IN"));
@@ -189,14 +189,14 @@  discard block
 block discarded – undo
189 189
         $configs = $config_handler->getConfigs($criteria);
190 190
         $id_activation_type = $configs[0]->getVar("conf_id");
191 191
         $id_uname_test_level = $configs[1]->getVar("conf_id");
192
-        $xoops->db()->queryF("INSERT INTO `" .
193
-                $xoops->db()->prefix("configoption") .
194
-                "` (confop_name, confop_value, conf_id) VALUES " .
195
-                " ('_MD_AM_USERACTV', '0', {$id_activation_type})," .
196
-                " ('_MD_AM_AUTOACTV', '1', {$id_activation_type})," .
197
-                " ('_MD_AM_ADMINACTV', '2', {$id_activation_type})," .
198
-                " ('_MD_AM_STRICT', '0', {$id_uname_test_level})," .
199
-                " ('_MD_AM_MEDIUM', '1', {$id_uname_test_level})," .
192
+        $xoops->db()->queryF("INSERT INTO `".
193
+                $xoops->db()->prefix("configoption").
194
+                "` (confop_name, confop_value, conf_id) VALUES ".
195
+                " ('_MD_AM_USERACTV', '0', {$id_activation_type}),".
196
+                " ('_MD_AM_AUTOACTV', '1', {$id_activation_type}),".
197
+                " ('_MD_AM_ADMINACTV', '2', {$id_activation_type}),".
198
+                " ('_MD_AM_STRICT', '0', {$id_uname_test_level}),".
199
+                " ('_MD_AM_MEDIUM', '1', {$id_uname_test_level}),".
200 200
                 " ('_MD_AM_LIGHT', '2', {$id_uname_test_level})");
201 201
 
202 202
         return $result;
@@ -207,7 +207,7 @@  discard block
 block discarded – undo
207 207
         $xoops = Xoops::getInstance();
208 208
         $xoops->db();
209 209
         // Restore users table
210
-        $xoops->db()->queryF("ALTER TABLE `" . $xoops->db()->prefix("users") . "`
210
+        $xoops->db()->queryF("ALTER TABLE `".$xoops->db()->prefix("users")."`
211 211
               ADD url varchar(100) NOT NULL default '',
212 212
               ADD user_regdate int(10) unsigned NOT NULL default '0',
213 213
               ADD user_icq varchar(15) NOT NULL default '',
@@ -240,18 +240,18 @@  discard block
 block discarded – undo
240 240
             "notify_method", "notify_mode", "user_occ", "bio", "user_intrest", "user_mailok"
241 241
         );
242 242
         foreach ($profile_fields as $field) {
243
-            $xoops->db()->queryF("UPDATE `" .
244
-                    $xoops->db()->prefix("users") . "` u, `" .
245
-                    $xoops->db()->prefix("user_profile") .
243
+            $xoops->db()->queryF("UPDATE `".
244
+                    $xoops->db()->prefix("users")."` u, `".
245
+                    $xoops->db()->prefix("user_profile").
246 246
                     "` p SET u.{$field} = p.{$field} WHERE u.uid=p.profileid");
247 247
         }
248 248
 
249 249
         //Set display name as real name
250
-        $xoops->db()->queryF("UPDATE `" . $xoops->db()->prefix("users") . "` SET name=uname WHERE name=''");
250
+        $xoops->db()->queryF("UPDATE `".$xoops->db()->prefix("users")."` SET name=uname WHERE name=''");
251 251
         //Set loginname as uname
252
-        $xoops->db()->queryF("UPDATE `" . $xoops->db()->prefix("users") . "` SET uname=loginname");
252
+        $xoops->db()->queryF("UPDATE `".$xoops->db()->prefix("users")."` SET uname=loginname");
253 253
         //Drop loginname
254
-        $xoops->db()->queryF("ALTER TABLE `" . $xoops->db()->prefix("users") . "` DROP loginname");
254
+        $xoops->db()->queryF("ALTER TABLE `".$xoops->db()->prefix("users")."` DROP loginname");
255 255
 
256 256
         return true;
257 257
     }
@@ -274,37 +274,37 @@  discard block
 block discarded – undo
274 274
     function apply_block()
275 275
     {
276 276
         $xoops = Xoops::getInstance();
277
-        $xoops->db()->queryF("UPDATE " .
278
-                $xoops->db()->prefix("block_module_link") .
277
+        $xoops->db()->queryF("UPDATE ".
278
+                $xoops->db()->prefix("block_module_link").
279 279
                 " SET module_id = -1, pageid = 0 WHERE module_id < 2 AND pageid = 1");
280 280
 
281 281
         //Change block module link to remove pages
282 282
         //Remove page links for module subpages
283
-        $xoops->db()->queryF("DELETE FROM " .
284
-                $xoops->db()->prefix("block_module_link") .
283
+        $xoops->db()->queryF("DELETE FROM ".
284
+                $xoops->db()->prefix("block_module_link").
285 285
                 " WHERE pageid > 0");
286 286
 
287
-        $sql = "ALTER TABLE `" .
288
-                $xoops->db()->prefix("block_module_link") .
287
+        $sql = "ALTER TABLE `".
288
+                $xoops->db()->prefix("block_module_link").
289 289
                 "` DROP PRIMARY KEY";
290 290
         $xoops->db()->queryF($sql);
291
-        $sql = "ALTER TABLE `" .
292
-                $xoops->db()->prefix("block_module_link") .
291
+        $sql = "ALTER TABLE `".
292
+                $xoops->db()->prefix("block_module_link").
293 293
                 "` DROP pageid";
294 294
         $xoops->db()->queryF($sql);
295
-        $sql = "ALTER IGNORE TABLE `" .
296
-                $xoops->db()->prefix("block_module_link") .
295
+        $sql = "ALTER IGNORE TABLE `".
296
+                $xoops->db()->prefix("block_module_link").
297 297
                 "` ADD PRIMARY KEY (`block_id` , `module_id`)";
298 298
         $xoops->db()->queryF($sql);
299 299
 
300
-        $xoops->db()->queryF("RENAME TABLE `" .
301
-                $xoops->db()->prefix("newblocks") .
302
-                "` TO `" .
303
-                $xoops->db()->prefix("newblocks_bak") .
300
+        $xoops->db()->queryF("RENAME TABLE `".
301
+                $xoops->db()->prefix("newblocks").
302
+                "` TO `".
303
+                $xoops->db()->prefix("newblocks_bak").
304 304
                 "`");
305 305
 
306 306
         // Create new block table
307
-        $sql = "CREATE TABLE " . $xoops->db()->prefix("newblocks") . " (
307
+        $sql = "CREATE TABLE ".$xoops->db()->prefix("newblocks")." (
308 308
               bid mediumint(8) unsigned NOT NULL auto_increment,
309 309
               mid smallint(5) unsigned NOT NULL default '0',
310 310
               func_num tinyint(3) unsigned NOT NULL default '0',
@@ -334,20 +334,20 @@  discard block
 block discarded – undo
334 334
             ";
335 335
         $xoops->db()->queryF($sql);
336 336
 
337
-        $sql = "SELECT MAX(instanceid) FROM " .
337
+        $sql = "SELECT MAX(instanceid) FROM ".
338 338
                 $xoops->db()->prefix('block_instance');
339 339
         $result = $xoops->db()->query($sql);
340 340
         list($MaxInstanceId) = $xoops->db()->fetchRow($result);
341 341
 
342 342
         // Change custom block mid from 1 to 0
343
-        $sql = "UPDATE `" .
344
-                $xoops->db()->prefix("newblocks_bak") .
343
+        $sql = "UPDATE `".
344
+                $xoops->db()->prefix("newblocks_bak").
345 345
                 "` SET mid = 0 WHERE show_func = 'b_system_custom_show'";
346 346
         $result = $xoops->db()->queryF($sql);
347 347
 
348
-        $sql = "SELECT b.*, i.instanceid " . "   FROM " .
349
-                $xoops->db()->prefix('block_instance') . " AS i LEFT JOIN " . $xoops->db()->prefix("newblocks_bak") .
350
-                " AS b ON b.bid = i.bid " . "   GROUP BY b.dirname, b.bid, i.instanceid";
348
+        $sql = "SELECT b.*, i.instanceid "."   FROM ".
349
+                $xoops->db()->prefix('block_instance')." AS i LEFT JOIN ".$xoops->db()->prefix("newblocks_bak").
350
+                " AS b ON b.bid = i.bid "."   GROUP BY b.dirname, b.bid, i.instanceid";
351 351
         $result = $xoops->db()->query($sql);
352 352
         $dirname = '';
353 353
         $bid = 0;
@@ -356,7 +356,7 @@  discard block
 block discarded – undo
356 356
             if ($row['dirname'] != $dirname) {
357 357
                 $dirname = $row['dirname'];
358 358
                 $modversion = array();
359
-                if (!@include XOOPS_ROOT_PATH . '/modules/' . $dirname . '/xoops_version.php') {
359
+                if (!@include XOOPS_ROOT_PATH.'/modules/'.$dirname.'/xoops_version.php') {
360 360
                     continue;
361 361
                 }
362 362
             }
@@ -376,39 +376,39 @@  discard block
 block discarded – undo
376 376
             }
377 377
 
378 378
             // Copy data from block instance table and blocks table
379
-            $sql = "INSERT INTO " .
380
-                    $xoops->db()->prefix("newblocks") .
381
-                    " (bid, mid, options, name, title, side, weight, visible, " .
382
-                    " func_num, " .
383
-                    " block_type, " .
384
-                    " c_type, " .
385
-                    " isactive, dirname, func_file," .
386
-                    " show_func, edit_func, template, bcachetime, last_modified)" .
387
-                    " SELECT " .
388
-                    " i.instanceid, c.mid, i.options, c.name, i.title, i.side, i.weight, i.visible, " .
389
-                    " {$block_key}, " .
390
-                    ($isClone ? " CASE WHEN c.show_func='b_system_custom_show' THEN 'C' ELSE 'D' END," : " CASE WHEN c.show_func='b_system_custom_show' THEN 'C' WHEN c.mid = 1 THEN 'S' ELSE 'M' END,") .
391
-                    " CASE WHEN c.c_type='' THEN 'H' ELSE c.c_type END," .
392
-                    " c.isactive, c.dirname, c.func_file," .
393
-                    " c.show_func, c.edit_func, c.template, i.bcachetime, c.last_modified" .
394
-                    " FROM " . $xoops->db()->prefix("block_instance") .
395
-                    " AS i," .
396
-                    " " .
397
-                    $xoops->db()->prefix("newblocks_bak") .
398
-                    " AS c" .
399
-                    " WHERE i.bid = c.bid" .
400
-                    " AND i.instanceid = " .
379
+            $sql = "INSERT INTO ".
380
+                    $xoops->db()->prefix("newblocks").
381
+                    " (bid, mid, options, name, title, side, weight, visible, ".
382
+                    " func_num, ".
383
+                    " block_type, ".
384
+                    " c_type, ".
385
+                    " isactive, dirname, func_file,".
386
+                    " show_func, edit_func, template, bcachetime, last_modified)".
387
+                    " SELECT ".
388
+                    " i.instanceid, c.mid, i.options, c.name, i.title, i.side, i.weight, i.visible, ".
389
+                    " {$block_key}, ".
390
+                    ($isClone ? " CASE WHEN c.show_func='b_system_custom_show' THEN 'C' ELSE 'D' END," : " CASE WHEN c.show_func='b_system_custom_show' THEN 'C' WHEN c.mid = 1 THEN 'S' ELSE 'M' END,").
391
+                    " CASE WHEN c.c_type='' THEN 'H' ELSE c.c_type END,".
392
+                    " c.isactive, c.dirname, c.func_file,".
393
+                    " c.show_func, c.edit_func, c.template, i.bcachetime, c.last_modified".
394
+                    " FROM ".$xoops->db()->prefix("block_instance").
395
+                    " AS i,".
396
+                    " ".
397
+                    $xoops->db()->prefix("newblocks_bak").
398
+                    " AS c".
399
+                    " WHERE i.bid = c.bid".
400
+                    " AND i.instanceid = ".
401 401
                     $row['instanceid'];
402 402
             $xoops->db()->queryF($sql);
403 403
         }
404 404
 
405
-        $sql = "SELECT b.* " .
406
-                "FROM " .
407
-                $xoops->db()->prefix("newblocks_bak") .
408
-                " AS b LEFT JOIN " .
409
-                $xoops->db()->prefix('block_instance') .
410
-                " AS i ON b.bid = i.bid " .
411
-                " WHERE i.instanceid IS NULL" .
405
+        $sql = "SELECT b.* ".
406
+                "FROM ".
407
+                $xoops->db()->prefix("newblocks_bak").
408
+                " AS b LEFT JOIN ".
409
+                $xoops->db()->prefix('block_instance').
410
+                " AS i ON b.bid = i.bid ".
411
+                " WHERE i.instanceid IS NULL".
412 412
                 " GROUP BY b.dirname, b.bid";
413 413
         $result = $xoops->db()->query($sql);
414 414
         $dirname = '';
@@ -418,7 +418,7 @@  discard block
 block discarded – undo
418 418
             if ($row['dirname'] != $dirname) {
419 419
                 $dirname = $row['dirname'];
420 420
                 $modversion = array();
421
-                if (!@include XOOPS_ROOT_PATH . '/modules/' . $dirname . '/xoops_version.php') {
421
+                if (!@include XOOPS_ROOT_PATH.'/modules/'.$dirname.'/xoops_version.php') {
422 422
                     continue;
423 423
                 }
424 424
             }
@@ -436,41 +436,41 @@  discard block
 block discarded – undo
436 436
             }
437 437
 
438 438
             // Copy data from blocks table
439
-            $sql = "    INSERT INTO " . $xoops->db()
440
-                    ->prefix("newblocks") . "       (bid, mid, options, name, title, side, weight, visible, " . "           func_num, " . "         block_type, " . "           c_type, " . "           isactive, dirname, func_file," . "          show_func, edit_func, template, bcachetime, last_modified)" . " SELECT " . "        bid + {$MaxInstanceId}, mid, options, name, name, 0, 0, 0, " . "        {$block_key}, " . "     CASE WHEN show_func='b_system_custom_show' THEN 'C' WHEN mid = 1 THEN 'S' ELSE 'M' END," . "        CASE WHEN c_type='' THEN 'H' ELSE c_type END," . "      isactive, dirname, func_file," . "      show_func, edit_func, template, 0, last_modified" . "   FROM " . $xoops
441
-                    ->db()->prefix("newblocks_bak") . " WHERE bid = " . $row['bid'];
439
+            $sql = "    INSERT INTO ".$xoops->db()
440
+                    ->prefix("newblocks")."       (bid, mid, options, name, title, side, weight, visible, "."           func_num, "."         block_type, "."           c_type, "."           isactive, dirname, func_file,"."          show_func, edit_func, template, bcachetime, last_modified)"." SELECT "."        bid + {$MaxInstanceId}, mid, options, name, name, 0, 0, 0, "."        {$block_key}, "."     CASE WHEN show_func='b_system_custom_show' THEN 'C' WHEN mid = 1 THEN 'S' ELSE 'M' END,"."        CASE WHEN c_type='' THEN 'H' ELSE c_type END,"."      isactive, dirname, func_file,"."      show_func, edit_func, template, 0, last_modified"."   FROM ".$xoops
441
+                    ->db()->prefix("newblocks_bak")." WHERE bid = ".$row['bid'];
442 442
             $xoops->db()->queryF($sql);
443 443
 
444 444
             // Build block-module link
445
-            $sql = "    INSERT INTO " . $xoops->db()
446
-                    ->prefix("block_module_link") . "       (block_id, module_id)" . "  SELECT " . "        bid + {$MaxInstanceId}, -1" . " FROM " . $xoops
447
-                    ->db()->prefix("newblocks_bak") . " WHERE bid = " . $row['bid'];
445
+            $sql = "    INSERT INTO ".$xoops->db()
446
+                    ->prefix("block_module_link")."       (block_id, module_id)"."  SELECT "."        bid + {$MaxInstanceId}, -1"." FROM ".$xoops
447
+                    ->db()->prefix("newblocks_bak")." WHERE bid = ".$row['bid'];
448 448
             $xoops->db()->queryF($sql);
449 449
         }
450 450
 
451 451
         // Dealing with tables
452
-        $xoops->db()->queryF("DROP TABLE `" . $xoops->db()->prefix("block_instance") . "`;");
453
-        $xoops->db()->queryF("DROP TABLE `" . $xoops->db()->prefix("newblocks_bak") . "`;");
452
+        $xoops->db()->queryF("DROP TABLE `".$xoops->db()->prefix("block_instance")."`;");
453
+        $xoops->db()->queryF("DROP TABLE `".$xoops->db()->prefix("newblocks_bak")."`;");
454 454
 
455 455
         // Deal with custom blocks, convert options to type and content
456
-        $sql = "SELECT bid, options FROM `" . $xoops->db()
457
-                ->prefix("newblocks") . "` WHERE show_func='b_system_custom_show'";
456
+        $sql = "SELECT bid, options FROM `".$xoops->db()
457
+                ->prefix("newblocks")."` WHERE show_func='b_system_custom_show'";
458 458
         $result = $xoops->db()->query($sql);
459 459
         while (false !== (list($bid, $options) = $xoops->db()->fetchRow($result))) {
460 460
             $_options = unserialize($options);
461 461
             $content = $_options[0];
462 462
             $type = $_options[1];
463
-            $xoops->db()->queryF("UPDATE `" . $xoops->db()
464
-                    ->prefix("newblocks") . "` SET c_type = '{$type}', options = '', content = " . $xoops->db()
465
-                    ->quote($content) . " WHERE bid = {$bid}");
463
+            $xoops->db()->queryF("UPDATE `".$xoops->db()
464
+                    ->prefix("newblocks")."` SET c_type = '{$type}', options = '', content = ".$xoops->db()
465
+                    ->quote($content)." WHERE bid = {$bid}");
466 466
         }
467 467
 
468 468
         // Deal with block options, convert array values to "," and "|" delimited
469
-        $sql = "UPDATE `" . $xoops->db()
470
-                ->prefix("newblocks") . "` SET options = '' WHERE show_func <> 'b_system_custom_show' AND ( options = 'a:1:{i:0;s:0:\"\";}' OR options = 'a:0:{}' )";
469
+        $sql = "UPDATE `".$xoops->db()
470
+                ->prefix("newblocks")."` SET options = '' WHERE show_func <> 'b_system_custom_show' AND ( options = 'a:1:{i:0;s:0:\"\";}' OR options = 'a:0:{}' )";
471 471
         $result = $xoops->db()->queryF($sql);
472
-        $sql = "SELECT bid, options FROM `" . $xoops->db()
473
-                ->prefix("newblocks") . "` WHERE show_func <> 'b_system_custom_show' AND options <> ''";
472
+        $sql = "SELECT bid, options FROM `".$xoops->db()
473
+                ->prefix("newblocks")."` WHERE show_func <> 'b_system_custom_show' AND options <> ''";
474 474
         $result = $xoops->db()->query($sql);
475 475
         while (false !== (list($bid, $_options) = $xoops->db()->fetchRow($result))) {
476 476
             $options = unserialize($_options);
@@ -485,8 +485,8 @@  discard block
 block discarded – undo
485 485
                 }
486 486
             }
487 487
             $options = implode('|', $options);
488
-            $sql = "UPDATE `" . $xoops->db()->prefix("newblocks") . "` SET options = " . $xoops->db()
489
-                    ->quote($options) . " WHERE bid = {$bid}";
488
+            $sql = "UPDATE `".$xoops->db()->prefix("newblocks")."` SET options = ".$xoops->db()
489
+                    ->quote($options)." WHERE bid = {$bid}";
490 490
             $xoops->db()->queryF($sql);
491 491
         }
492 492
 
Please login to merge, or discard this patch.
upgrade/upd-2.4.x-to-2.5.0/dbmanager.php 2 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -97,7 +97,7 @@
 block discarded – undo
97 97
                         if (!isset($this->f_tables['insert'][$table])) {
98 98
                             $this->f_tables['insert'][$table] = 1;
99 99
                         } else {
100
-                             $this->f_tables['insert'][$table]++;
100
+                                $this->f_tables['insert'][$table]++;
101 101
                         }
102 102
                     }
103 103
                 } else if ($prefixed_query[1] == 'ALTER TABLE') {
Please login to merge, or discard this patch.
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -17,9 +17,9 @@  discard block
 block discarded – undo
17 17
  * @access      public
18 18
  **/
19 19
 
20
-include_once XOOPS_ROOT_PATH . '/class/database/databasefactory.php';
21
-include_once XOOPS_ROOT_PATH . '/class/database/' . XOOPS_DB_TYPE . 'database.php';
22
-include_once XOOPS_ROOT_PATH . '/class/database/sqlutility.php';
20
+include_once XOOPS_ROOT_PATH.'/class/database/databasefactory.php';
21
+include_once XOOPS_ROOT_PATH.'/class/database/'.XOOPS_DB_TYPE.'database.php';
22
+include_once XOOPS_ROOT_PATH.'/class/database/sqlutility.php';
23 23
 
24 24
 /**
25 25
  * Database manager
@@ -54,7 +54,7 @@  discard block
 block discarded – undo
54 54
     {
55 55
         $this->db->connect(false);
56 56
 
57
-        $result = $this->db->query("CREATE DATABASE " . XOOPS_DB_NAME);
57
+        $result = $this->db->query("CREATE DATABASE ".XOOPS_DB_NAME);
58 58
 
59 59
         return ($result != false) ? true : false;
60 60
     }
@@ -74,7 +74,7 @@  discard block
 block discarded – undo
74 74
             // [0] contains the prefixed query
75 75
             // [4] contains unprefixed table name
76 76
             $prefixed_query = SqlUtility::prefixQuery($piece, $this->db->prefix());
77
-            if ($prefixed_query != false ) {
77
+            if ($prefixed_query != false) {
78 78
                 $table = $this->db->prefix($prefixed_query[4]);
79 79
                 if ($prefixed_query[1] == 'CREATE TABLE') {
80 80
                     if ($this->db->query($prefixed_query[0]) != false) {
@@ -142,7 +142,7 @@  discard block
 block discarded – undo
142 142
 
143 143
     function report()
144 144
     {
145
-        $commands = array( 'create', 'insert', 'alter', 'drop' );
145
+        $commands = array('create', 'insert', 'alter', 'drop');
146 146
         $content = '<ul class="log">';
147 147
         foreach ($commands as $cmd) {
148 148
             if (!@empty($this->s_tables[$cmd])) {
@@ -154,7 +154,7 @@  discard block
 block discarded – undo
154 154
             }
155 155
         }
156 156
         foreach ($commands as $cmd) {
157
-            if (!@empty( $this->f_tables[$cmd])) {
157
+            if (!@empty($this->f_tables[$cmd])) {
158 158
                 foreach ($this->f_tables[$cmd] as $key => $val) {
159 159
                     $content .= '<li class="failure">';
160 160
                     $content .= ($cmd != 'insert') ? sprintf($this->failureStrings[$cmd], $key) : sprintf($this->failureStrings[$cmd], $val, $key);
@@ -188,7 +188,7 @@  discard block
 block discarded – undo
188 188
     {
189 189
         $this->db->connect();
190 190
         $table = $this->db->prefix($table);
191
-        $query = 'INSERT INTO ' . $table . ' '. $query;
191
+        $query = 'INSERT INTO '.$table.' '.$query;
192 192
         if (!$this->db->queryF($query)) {
193 193
             if (!isset($this->f_tables['insert'][$table])) {
194 194
                 $this->f_tables['insert'][$table] = 1;
@@ -216,7 +216,7 @@  discard block
 block discarded – undo
216 216
         $deleted = array();
217 217
         $this->db->connect();
218 218
         foreach ($tables as $key => $val) {
219
-            if (!$this->db->query("DROP TABLE " . $this->db->prefix($key))) {
219
+            if (!$this->db->query("DROP TABLE ".$this->db->prefix($key))) {
220 220
                 $deleted[] = $va;
221 221
             }
222 222
         }
@@ -229,7 +229,7 @@  discard block
 block discarded – undo
229 229
         $ret = false;
230 230
         if ($table != '') {
231 231
             $this->db->connect();
232
-            $sql = 'SELECT COUNT(*) FROM ' . $this->db->prefix($table);
232
+            $sql = 'SELECT COUNT(*) FROM '.$this->db->prefix($table);
233 233
             $ret = (false != $this->db->query($sql)) ? true : false;
234 234
         }
235 235
         return $ret;
Please login to merge, or discard this patch.
upgrade/upd-2.4.x-to-2.5.0/index.php 2 patches
Indentation   -1 removed lines patch added patch discarded remove patch
@@ -24,7 +24,6 @@
 block discarded – undo
24 24
 
25 25
     /**
26 26
      * Check if cpanel config already exists
27
-
28 27
      */
29 28
     function check_config()
30 29
     {
Please login to merge, or discard this patch.
Spacing   +14 added lines, -14 removed lines patch added patch discarded remove patch
@@ -30,7 +30,7 @@  discard block
 block discarded – undo
30 30
     {
31 31
         $xoops = Xoops::getInstance();
32 32
         $db = $xoops->db();
33
-        $sql = "SELECT COUNT(*) FROM `" . $db->prefix('config') . "` WHERE `conf_name` IN ('break1', 'usetips')";
33
+        $sql = "SELECT COUNT(*) FROM `".$db->prefix('config')."` WHERE `conf_name` IN ('break1', 'usetips')";
34 34
         if (!$result = $db->queryF($sql)) {
35 35
             return false;
36 36
         }
@@ -42,7 +42,7 @@  discard block
 block discarded – undo
42 42
     {
43 43
         $xoops = Xoops::getInstance();
44 44
         $db = $xoops->db();
45
-        $sql = "SELECT COUNT(*) FROM `" . $db->prefix('tplfile') . "` WHERE `tpl_file` IN ('system_header.html') AND `tpl_type` = 'admin'";
45
+        $sql = "SELECT COUNT(*) FROM `".$db->prefix('tplfile')."` WHERE `tpl_file` IN ('system_header.html') AND `tpl_type` = 'admin'";
46 46
         if (!$result = $db->queryF($sql)) {
47 47
             return false;
48 48
         }
@@ -56,13 +56,13 @@  discard block
 block discarded – undo
56 56
         $db = $xoops->db();
57 57
         $dbm = new db_manager();
58 58
 
59
-        $sql = "SELECT conf_id FROM `" . $db->prefix('config') . "` WHERE `conf_name` IN ('cpanel')";
59
+        $sql = "SELECT conf_id FROM `".$db->prefix('config')."` WHERE `conf_name` IN ('cpanel')";
60 60
         if (!$result = $db->queryF($sql)) {
61 61
             return false;
62 62
         }
63 63
         $count = $db->fetchRow($result);
64 64
 
65
-        $sql = "UPDATE `" . $db->prefix('config') . "` SET `conf_value` = 'default' WHERE `conf_id` = " . $count[0];
65
+        $sql = "UPDATE `".$db->prefix('config')."` SET `conf_value` = 'default' WHERE `conf_id` = ".$count[0];
66 66
         if (!$result = $db->queryF($sql)) {
67 67
             return false;
68 68
         }
@@ -109,25 +109,25 @@  discard block
 block discarded – undo
109 109
         require_once '../class/xoopslists.php';
110 110
         $editors = XoopsLists::getDirListAsArray('../class/xoopseditor');
111 111
         foreach ($editors as $dir) {
112
-            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('" . $dir . "', '" . $dir . "', $block_id)");
112
+            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('".$dir."', '".$dir."', $block_id)");
113 113
         }
114 114
         foreach ($editors as $dir) {
115
-            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('" . $dir . "', '" . $dir . "', $com_id)");
115
+            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('".$dir."', '".$dir."', $com_id)");
116 116
         }
117 117
         foreach ($editors as $dir) {
118
-            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('" . $dir . "', '" . $dir . "', $main_id)");
118
+            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('".$dir."', '".$dir."', $main_id)");
119 119
         }
120 120
         $icons = XoopsLists::getDirListAsArray('../modules/system/images/icons');
121 121
         foreach ($icons as $dir) {
122
-            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('" . $dir . "', '" . $dir . "', $icon_id)");
122
+            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('".$dir."', '".$dir."', $icon_id)");
123 123
         }
124 124
         $breadcrumb = XoopsLists::getDirListAsArray('../modules/system/images/breadcrumb');
125 125
         foreach ($breadcrumb as $dir) {
126
-            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('" . $dir . "', '" . $dir . "', $bc_id)");
126
+            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('".$dir."', '".$dir."', $bc_id)");
127 127
         }
128 128
         $jqueryui = XoopsLists::getDirListAsArray('../modules/system/css/ui');
129 129
         foreach ($jqueryui as $dir) {
130
-            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('" . $dir . "', '" . $dir . "', $jquery_id)");
130
+            $dbm->insert('configoption', " (confop_name,confop_value,conf_id) VALUES ('".$dir."', '".$dir."', $jquery_id)");
131 131
         }
132 132
 
133 133
         return true;
@@ -142,11 +142,11 @@  discard block
 block discarded – undo
142 142
         $time = time();
143 143
         foreach ($modversion['templates'] as $tplfile) {
144 144
             // Admin templates
145
-            if (isset($tplfile['type']) && $tplfile['type'] == 'admin' && $fp = fopen('../modules/system/templates/admin/' . $tplfile['file'], 'r')) {
146
-                $newtplid = $dbm->insert('tplfile', " VALUES (0, 1, 'system', 'default', '" . addslashes($tplfile['file']) . "', '" . addslashes($tplfile['description']) . "', " . $time . ", " . $time . ", 'admin')");
147
-                $tplsource = fread($fp, filesize('../modules/system/templates/admin/' . $tplfile['file']));
145
+            if (isset($tplfile['type']) && $tplfile['type'] == 'admin' && $fp = fopen('../modules/system/templates/admin/'.$tplfile['file'], 'r')) {
146
+                $newtplid = $dbm->insert('tplfile', " VALUES (0, 1, 'system', 'default', '".addslashes($tplfile['file'])."', '".addslashes($tplfile['description'])."', ".$time.", ".$time.", 'admin')");
147
+                $tplsource = fread($fp, filesize('../modules/system/templates/admin/'.$tplfile['file']));
148 148
                 fclose($fp);
149
-                $dbm->insert('tplsource', " (tpl_id, tpl_source) VALUES (" . $newtplid . ", '" . addslashes($tplsource) . "')");
149
+                $dbm->insert('tplsource', " (tpl_id, tpl_source) VALUES (".$newtplid.", '".addslashes($tplsource)."')");
150 150
             }
151 151
         }
152 152
         return true;
Please login to merge, or discard this patch.
upgrade/check_version.php 2 patches
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch
@@ -24,9 +24,9 @@  discard block
 block discarded – undo
24 24
  * @version     $Id$
25 25
  */
26 26
 
27
-defined( 'XOOPS_ROOT_PATH' ) or die();
27
+defined('XOOPS_ROOT_PATH') or die();
28 28
 
29
-$dirs = getDirList( "." );
29
+$dirs = getDirList(".");
30 30
 
31 31
 $results = array();
32 32
 $files = array();
@@ -35,14 +35,14 @@  discard block
 block discarded – undo
35 35
 $_SESSION['xoops_upgrade'] = array();
36 36
 
37 37
 foreach ($dirs as $dir) {
38
-    if (strpos( $dir, "-to-")) {
38
+    if (strpos($dir, "-to-")) {
39 39
         $upgrader = include_once "{$dir}/index.php";
40 40
         if (is_object($upgrader)) {
41
-            if (!( $results[$dir] = $upgrader->isApplied())) {
41
+            if (!($results[$dir] = $upgrader->isApplied())) {
42 42
                 $_SESSION['xoops_upgrade']['steps'][] = $dir;
43 43
                 $needUpgrade = true;
44
-                if (!empty( $upgrader->usedFiles)) {
45
-                    $files = array_merge( $files, $upgrader->usedFiles );
44
+                if (!empty($upgrader->usedFiles)) {
45
+                    $files = array_merge($files, $upgrader->usedFiles);
46 46
                 }
47 47
             }
48 48
         }
@@ -63,23 +63,23 @@  discard block
 block discarded – undo
63 63
 <?php foreach ($results as $upd => $res) { ?>
64 64
     <tr>
65 65
         <td><?php echo $upd; ?></td>
66
-        <td class="result-<?php echo $res?'y':'x'; ?>"><?php echo $res?'y':'x'; ?></td>
66
+        <td class="result-<?php echo $res ? 'y' : 'x'; ?>"><?php echo $res ? 'y' : 'x'; ?></td>
67 67
     </tr>
68 68
 <?php } ?>
69 69
 </table>
70 70
 <?php
71 71
     if (!$needUpgrade) {
72
-        $update_link = '<a href="' . XOOPS_URL . '/modules/system/admin.php?fct=modulesadmin&amp;op=update&amp;module=system">' . _UPDATE_SYSTEM_MODULE . '</a>';
73
-        echo '<div class="x2-note">' . sprintf(_NO_NEED_UPGRADE, $update_link) . "</div>";
72
+        $update_link = '<a href="'.XOOPS_URL.'/modules/system/admin.php?fct=modulesadmin&amp;op=update&amp;module=system">'._UPDATE_SYSTEM_MODULE.'</a>';
73
+        echo '<div class="x2-note">'.sprintf(_NO_NEED_UPGRADE, $update_link)."</div>";
74 74
         return;
75 75
     } else {
76 76
         if (!empty($files)) {
77
-            echo '<div class="x2-note"><p>' . _NEED_UPGRADE . "<br />" . _SET_FILES_WRITABLE . "</p><ul>";
77
+            echo '<div class="x2-note"><p>'._NEED_UPGRADE."<br />"._SET_FILES_WRITABLE."</p><ul>";
78 78
             foreach ($files as $file) echo "<li>{$file}</li>\n";
79 79
             echo "</ul></div>";
80
-            echo '<a id="link-next" href="index.php">' . _RELOAD . '</a>';
80
+            echo '<a id="link-next" href="index.php">'._RELOAD.'</a>';
81 81
         } else {
82
-            echo '<a id="link-next" href="index.php?action=next">' . _PROCEED_UPGRADE . '</a>';
82
+            echo '<a id="link-next" href="index.php?action=next">'._PROCEED_UPGRADE.'</a>';
83 83
         }
84 84
     }
85 85
 ?>
86 86
\ No newline at end of file
Please login to merge, or discard this patch.
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -75,7 +75,9 @@
 block discarded – undo
75 75
     } else {
76 76
         if (!empty($files)) {
77 77
             echo '<div class="x2-note"><p>' . _NEED_UPGRADE . "<br />" . _SET_FILES_WRITABLE . "</p><ul>";
78
-            foreach ($files as $file) echo "<li>{$file}</li>\n";
78
+            foreach ($files as $file) {
79
+                echo "<li>{$file}</li>\n";
80
+            }
79 81
             echo "</ul></div>";
80 82
             echo '<a id="link-next" href="index.php">' . _RELOAD . '</a>';
81 83
         } else {
Please login to merge, or discard this patch.
upgrade/upd-2.0.18-to-2.3.0/pathcontroller.php 2 patches
Spacing   +44 added lines, -44 removed lines patch added patch discarded remove patch
@@ -46,28 +46,28 @@  discard block
 block discarded – undo
46 46
 
47 47
     function PathStuffController()
48 48
     {
49
-        if ( isset( $_SESSION['settings']['VAR_PATH'] ) ) {
49
+        if (isset($_SESSION['settings']['VAR_PATH'])) {
50 50
             foreach ($this->path_lookup as $req => $sess) {
51 51
                 $this->xoopsPath[$req] = $_SESSION['settings'][$sess];
52 52
             }
53 53
         } else {
54 54
             $path = XOOPS_ROOT_PATH;
55
-            if ( defined("XOOPS_PATH") ) {
55
+            if (defined("XOOPS_PATH")) {
56 56
                 $this->xoopsPath['lib'] = XOOPS_PATH;
57
-            } elseif ( defined("XOOPS_TRUST_PATH") ) {
57
+            } elseif (defined("XOOPS_TRUST_PATH")) {
58 58
                 $this->xoopsPath['lib'] = XOOPS_TRUST_PATH;
59 59
             } else {
60
-                $this->xoopsPath['lib'] = dirname($path) . "/xoops_lib";
61
-                if ( !is_dir($this->xoopsPath['lib'] . "/") ) {
62
-                    $this->xoopsPath['lib'] = $path . "/xoops_lib";
60
+                $this->xoopsPath['lib'] = dirname($path)."/xoops_lib";
61
+                if (!is_dir($this->xoopsPath['lib']."/")) {
62
+                    $this->xoopsPath['lib'] = $path."/xoops_lib";
63 63
                 }
64 64
             }
65
-            if ( defined("XOOPS_VAR_PATH") ) {
65
+            if (defined("XOOPS_VAR_PATH")) {
66 66
                 $this->xoopsPath['data'] = XOOPS_VAR_PATH;
67 67
             } else {
68
-                $this->xoopsPath['data'] = dirname($path) . "/xoops_data";
69
-                if ( !is_dir($this->xoopsPath['data'] . "/") ) {
70
-                    $this->xoopsPath['data'] = $path . "/xoops_data";
68
+                $this->xoopsPath['data'] = dirname($path)."/xoops_data";
69
+                if (!is_dir($this->xoopsPath['data']."/")) {
70
+                    $this->xoopsPath['data'] = $path."/xoops_data";
71 71
                 }
72 72
             }
73 73
         }
@@ -77,11 +77,11 @@  discard block
 block discarded – undo
77 77
     {
78 78
         $this->readRequest();
79 79
         $valid = $this->validate();
80
-        if ( $_SERVER['REQUEST_METHOD'] == 'POST' && @$_POST['task'] == 'path' ) {
80
+        if ($_SERVER['REQUEST_METHOD'] == 'POST' && @$_POST['task'] == 'path') {
81 81
             foreach ($this->path_lookup as $req => $sess) {
82 82
                 $_SESSION['settings'][$sess] = $this->xoopsPath[$req];
83 83
             }
84
-            if ( $valid ) {
84
+            if ($valid) {
85 85
                 return $_SESSION['settings'];
86 86
             } else {
87 87
                 return false;
@@ -91,13 +91,13 @@  discard block
 block discarded – undo
91 91
 
92 92
     function readRequest()
93 93
     {
94
-        if ( $_SERVER['REQUEST_METHOD'] == 'POST' && @$_POST['task'] == 'path' ) {
94
+        if ($_SERVER['REQUEST_METHOD'] == 'POST' && @$_POST['task'] == 'path') {
95 95
             $request = $_POST;
96 96
             foreach ($this->path_lookup as $req => $sess) {
97
-                if ( isset($request[$req]) ) {
98
-                    $request[$req] = str_replace( "\\", "/", trim($request[$req]) );
99
-                    if ( substr( $request[$req], -1 ) == '/' ) {
100
-                        $request[$req] = substr( $request[$req], 0, -1 );
97
+                if (isset($request[$req])) {
98
+                    $request[$req] = str_replace("\\", "/", trim($request[$req]));
99
+                    if (substr($request[$req], -1) == '/') {
100
+                        $request[$req] = substr($request[$req], 0, -1);
101 101
                     }
102 102
                     $this->xoopsPath[$req] = $request[$req];
103 103
                 }
@@ -112,7 +112,7 @@  discard block
 block discarded – undo
112 112
                 $this->checkPermissions($path);
113 113
             }
114 114
         }
115
-        $validPaths = ( array_sum(array_values($this->validPath)) == count(array_keys($this->validPath)) ) ? 1 : 0;
115
+        $validPaths = (array_sum(array_values($this->validPath)) == count(array_keys($this->validPath))) ? 1 : 0;
116 116
         $validPerms = true;
117 117
         foreach ($this->permErrors as $key => $errs) {
118 118
             if (empty($errs)) continue;
@@ -123,22 +123,22 @@  discard block
 block discarded – undo
123 123
                 }
124 124
             }
125 125
         }
126
-        return ( $validPaths && $validPerms );
126
+        return ($validPaths && $validPerms);
127 127
     }
128 128
 
129 129
     function checkPath($PATH = '')
130 130
     {
131 131
         $ret = 1;
132
-        if ( $PATH == 'lib' || empty($PATH) ) {
132
+        if ($PATH == 'lib' || empty($PATH)) {
133 133
             $path = 'lib';
134
-            if ( is_dir( $this->xoopsPath[$path] ) && is_readable( $this->xoopsPath[$path] ) ) {
134
+            if (is_dir($this->xoopsPath[$path]) && is_readable($this->xoopsPath[$path])) {
135 135
                 $this->validPath[$path] = 1;
136 136
             }
137 137
             $ret *= $this->validPath[$path];
138 138
         }
139
-        if ( $PATH == 'data' || empty($PATH) ) {
139
+        if ($PATH == 'data' || empty($PATH)) {
140 140
             $path = 'data';
141
-            if ( is_dir( $this->xoopsPath[$path] ) && is_readable( $this->xoopsPath[$path] ) ) {
141
+            if (is_dir($this->xoopsPath[$path]) && is_readable($this->xoopsPath[$path])) {
142 142
                 $this->validPath[$path] = 1;
143 143
             }
144 144
             $ret *= $this->validPath[$path];
@@ -149,19 +149,19 @@  discard block
 block discarded – undo
149 149
     function setPermission($parent, $path, &$error)
150 150
     {
151 151
         if (is_array($path)) {
152
-            foreach ( array_keys($path) as $item ) {
152
+            foreach (array_keys($path) as $item) {
153 153
                 if (is_string($item)) {
154
-                    $error[$parent . "/" . $item] = $this->makeWritable( $parent . "/" . $item );
154
+                    $error[$parent."/".$item] = $this->makeWritable($parent."/".$item);
155 155
                     if (empty($path[$item])) continue;
156 156
                     foreach ($path[$item] as $child) {
157
-                        $this->setPermission( $parent . "/" . $item, $child, $error );
157
+                        $this->setPermission($parent."/".$item, $child, $error);
158 158
                     }
159 159
                 } else {
160
-                    $error[$parent . "/" . $path[$item]] = $this->makeWritable( $parent . "/" . $path[$item] );
160
+                    $error[$parent."/".$path[$item]] = $this->makeWritable($parent."/".$path[$item]);
161 161
                 }
162 162
             }
163 163
         } else {
164
-            $error[$parent . "/" . $path] = $this->makeWritable( $parent . "/" . $path );
164
+            $error[$parent."/".$path] = $this->makeWritable($parent."/".$path);
165 165
         }
166 166
         return;
167 167
     }
@@ -188,7 +188,7 @@  discard block
 block discarded – undo
188 188
             return true;
189 189
         }
190 190
         $this->setPermission($this->xoopsPath[$path], $paths[$path], $errors[$path]);
191
-        if ( in_array( false, $errors[$path] ) ) {
191
+        if (in_array(false, $errors[$path])) {
192 192
             $this->permErrors[$path] = $errors[$path];
193 193
             return false;
194 194
         }
@@ -203,39 +203,39 @@  discard block
 block discarded – undo
203 203
      * @param bool $recurse
204 204
      * @return false on failure, method (u-ser,g-roup,w-orld) on success
205 205
      */
206
-    function makeWritable( $path, $group = false, $create = true )
206
+    function makeWritable($path, $group = false, $create = true)
207 207
     {
208
-        if ( !file_exists( $path ) ) {
208
+        if (!file_exists($path)) {
209 209
             if (!$create) {
210 210
                 return false;
211 211
             } else {
212 212
                 $perm = 6;
213
-                @mkdir($path, octdec( '0' . $perm . '00' ));
213
+                @mkdir($path, octdec('0'.$perm.'00'));
214 214
             }
215 215
         } else {
216
-            $perm = is_dir( $path ) ? 6 : 7;
216
+            $perm = is_dir($path) ? 6 : 7;
217 217
         }
218
-        if ( !is_writable($path) ) {
218
+        if (!is_writable($path)) {
219 219
             // First try using owner bit
220
-            @chmod( $path, octdec( '0' . $perm . '00' ) );
220
+            @chmod($path, octdec('0'.$perm.'00'));
221 221
             clearstatcache();
222
-            if ( !is_writable( $path ) && $group !== false ) {
222
+            if (!is_writable($path) && $group !== false) {
223 223
                 // If group has been specified, try using the group bit
224
-                @chgrp( $path, $group );
225
-                @chmod( $path, octdec( '0' . $perm . $perm . '0' ) );
224
+                @chgrp($path, $group);
225
+                @chmod($path, octdec('0'.$perm.$perm.'0'));
226 226
             }
227 227
             clearstatcache();
228
-            if ( !is_writable( $path ) ) {
229
-                @chmod( $path, octdec( '0' . $perm . $perm . $perm ) );
228
+            if (!is_writable($path)) {
229
+                @chmod($path, octdec('0'.$perm.$perm.$perm));
230 230
             }
231 231
         }
232 232
         clearstatcache();
233
-        if ( is_writable( $path ) ) {
234
-            $info = stat( $path );
233
+        if (is_writable($path)) {
234
+            $info = stat($path);
235 235
             //echo $path . ' : ' . sprintf( '%o', $info['mode'] ) . '....';
236
-            if ( $info['mode'] & 0002 ) {
236
+            if ($info['mode'] & 0002) {
237 237
                 return 'w';
238
-            } elseif ( $info['mode'] & 0020 ) {
238
+            } elseif ($info['mode'] & 0020) {
239 239
                 return 'g';
240 240
             }
241 241
             return 'u';
Please login to merge, or discard this patch.
Braces   +6 added lines, -2 removed lines patch added patch discarded remove patch
@@ -115,7 +115,9 @@  discard block
 block discarded – undo
115 115
         $validPaths = ( array_sum(array_values($this->validPath)) == count(array_keys($this->validPath)) ) ? 1 : 0;
116 116
         $validPerms = true;
117 117
         foreach ($this->permErrors as $key => $errs) {
118
-            if (empty($errs)) continue;
118
+            if (empty($errs)) {
119
+                continue;
120
+            }
119 121
             foreach ($errs as $path => $status) {
120 122
                 if (empty($status)) {
121 123
                     $validPerms = false;
@@ -152,7 +154,9 @@  discard block
 block discarded – undo
152 154
             foreach ( array_keys($path) as $item ) {
153 155
                 if (is_string($item)) {
154 156
                     $error[$parent . "/" . $item] = $this->makeWritable( $parent . "/" . $item );
155
-                    if (empty($path[$item])) continue;
157
+                    if (empty($path[$item])) {
158
+                        continue;
159
+                    }
156 160
                     foreach ($path[$item] as $child) {
157 161
                         $this->setPermission( $parent . "/" . $item, $child, $error );
158 162
                     }
Please login to merge, or discard this patch.