@@ -23,7 +23,7 @@ discard block |
||
| 23 | 23 | * |
| 24 | 24 | * @return array The truncated array |
| 25 | 25 | */ |
| 26 | -function truncateArray($arr, $max_length=1900) |
|
| 26 | +function truncateArray($arr, $max_length = 1900) |
|
| 27 | 27 | { |
| 28 | 28 | $curr_length = array_sum(array_map("strlen", $arr)); |
| 29 | 29 | if ($curr_length <= $max_length) |
@@ -31,7 +31,7 @@ discard block |
||
| 31 | 31 | else |
| 32 | 32 | { |
| 33 | 33 | // Truncate each element's value to a reasonable length |
| 34 | - $param_max = floor($max_length/count($arr)); |
|
| 34 | + $param_max = floor($max_length / count($arr)); |
|
| 35 | 35 | foreach ($arr as $key => &$value) |
| 36 | 36 | $value = substr($value, 0, $param_max - strlen($key) - 5); |
| 37 | 37 | return $arr; |
@@ -197,7 +197,7 @@ discard block |
||
| 197 | 197 | if (filemtime($boarddir . '/db_last_error.php') === $last_db_error_change) |
| 198 | 198 | { |
| 199 | 199 | // Write the change |
| 200 | - $write_db_change = '<' . '?' . "php\n" . '$db_last_error = ' . time() . ';' . "\n" . '?' . '>'; |
|
| 200 | + $write_db_change = '<' . '?' . "php\n" . '$db_last_error = ' . time() . ';' . "\n" . '?' . '>'; |
|
| 201 | 201 | $written_bytes = file_put_contents($boarddir . '/db_last_error.php', $write_db_change, LOCK_EX); |
| 202 | 202 | |
| 203 | 203 | // survey says ... |
@@ -270,7 +270,7 @@ discard block |
||
| 270 | 270 | ', $txt['debug_language_files'], count($context['debug']['language_files']), ': <em>', implode('</em>, <em>', $context['debug']['language_files']), '</em>.<br> |
| 271 | 271 | ', $txt['debug_stylesheets'], count($context['debug']['sheets']), ': <em>', implode('</em>, <em>', $context['debug']['sheets']), '</em>.<br> |
| 272 | 272 | ', $txt['debug_hooks'], empty($context['debug']['hooks']) ? 0 : count($context['debug']['hooks']) . ' (<a href="javascript:void(0);" onclick="document.getElementById(\'debug_hooks\').style.display = \'inline\'; this.style.display = \'none\'; return false;">', $txt['debug_show'], '</a><span id="debug_hooks" style="display: none;"><em>' . implode('</em>, <em>', $context['debug']['hooks']), '</em></span>)', '<br> |
| 273 | - ',(isset($context['debug']['instances']) ? ($txt['debug_instances'] . (empty($context['debug']['instances']) ? 0 : count($context['debug']['instances'])) . ' (<a href="javascript:void(0);" onclick="document.getElementById(\'debug_instances\').style.display = \'inline\'; this.style.display = \'none\'; return false;">'. $txt['debug_show'] .'</a><span id="debug_instances" style="display: none;"><em>'. implode('</em>, <em>', array_keys($context['debug']['instances'])) .'</em></span>)'. '<br>') : ''),' |
|
| 273 | + ',(isset($context['debug']['instances']) ? ($txt['debug_instances'] . (empty($context['debug']['instances']) ? 0 : count($context['debug']['instances'])) . ' (<a href="javascript:void(0);" onclick="document.getElementById(\'debug_instances\').style.display = \'inline\'; this.style.display = \'none\'; return false;">' . $txt['debug_show'] . '</a><span id="debug_instances" style="display: none;"><em>' . implode('</em>, <em>', array_keys($context['debug']['instances'])) . '</em></span>)' . '<br>') : ''), ' |
|
| 274 | 274 | ', $txt['debug_files_included'], count($files), ' - ', round($total_size / 1024), $txt['debug_kb'], ' (<a href="javascript:void(0);" onclick="document.getElementById(\'debug_include_info\').style.display = \'inline\'; this.style.display = \'none\'; return false;">', $txt['debug_show'], '</a><span id="debug_include_info" style="display: none;"><em>', implode('</em>, <em>', $files), '</em></span>)<br>'; |
| 275 | 275 | |
| 276 | 276 | if (function_exists('memory_get_peak_usage')) |
@@ -13,8 +13,9 @@ discard block |
||
| 13 | 13 | * @version 2.1 Beta 4 |
| 14 | 14 | */ |
| 15 | 15 | |
| 16 | -if (!defined('SMF')) |
|
| 16 | +if (!defined('SMF')) { |
|
| 17 | 17 | die('No direct access...'); |
| 18 | +} |
|
| 18 | 19 | |
| 19 | 20 | /** |
| 20 | 21 | * Truncate the GET array to a specified length |
@@ -26,14 +27,15 @@ discard block |
||
| 26 | 27 | function truncateArray($arr, $max_length=1900) |
| 27 | 28 | { |
| 28 | 29 | $curr_length = array_sum(array_map("strlen", $arr)); |
| 29 | - if ($curr_length <= $max_length) |
|
| 30 | - return $arr; |
|
| 31 | - else |
|
| 30 | + if ($curr_length <= $max_length) { |
|
| 31 | + return $arr; |
|
| 32 | + } else |
|
| 32 | 33 | { |
| 33 | 34 | // Truncate each element's value to a reasonable length |
| 34 | 35 | $param_max = floor($max_length/count($arr)); |
| 35 | - foreach ($arr as $key => &$value) |
|
| 36 | - $value = substr($value, 0, $param_max - strlen($key) - 5); |
|
| 36 | + foreach ($arr as $key => &$value) { |
|
| 37 | + $value = substr($value, 0, $param_max - strlen($key) - 5); |
|
| 38 | + } |
|
| 37 | 39 | return $arr; |
| 38 | 40 | } |
| 39 | 41 | } |
@@ -55,8 +57,9 @@ discard block |
||
| 55 | 57 | // Don't update for every page - this isn't wholly accurate but who cares. |
| 56 | 58 | if ($topic) |
| 57 | 59 | { |
| 58 | - if (isset($_SESSION['last_topic_id']) && $_SESSION['last_topic_id'] == $topic) |
|
| 59 | - $force = false; |
|
| 60 | + if (isset($_SESSION['last_topic_id']) && $_SESSION['last_topic_id'] == $topic) { |
|
| 61 | + $force = false; |
|
| 62 | + } |
|
| 60 | 63 | $_SESSION['last_topic_id'] = $topic; |
| 61 | 64 | } |
| 62 | 65 | } |
@@ -69,22 +72,24 @@ discard block |
||
| 69 | 72 | } |
| 70 | 73 | |
| 71 | 74 | // Don't mark them as online more than every so often. |
| 72 | - if (!empty($_SESSION['log_time']) && $_SESSION['log_time'] >= (time() - 8) && !$force) |
|
| 73 | - return; |
|
| 75 | + if (!empty($_SESSION['log_time']) && $_SESSION['log_time'] >= (time() - 8) && !$force) { |
|
| 76 | + return; |
|
| 77 | + } |
|
| 74 | 78 | |
| 75 | 79 | if (!empty($modSettings['who_enabled'])) |
| 76 | 80 | { |
| 77 | 81 | $encoded_get = truncateArray($_GET) + array('USER_AGENT' => $_SERVER['HTTP_USER_AGENT']); |
| 78 | 82 | |
| 79 | 83 | // In the case of a dlattach action, session_var may not be set. |
| 80 | - if (!isset($context['session_var'])) |
|
| 81 | - $context['session_var'] = $_SESSION['session_var']; |
|
| 84 | + if (!isset($context['session_var'])) { |
|
| 85 | + $context['session_var'] = $_SESSION['session_var']; |
|
| 86 | + } |
|
| 82 | 87 | |
| 83 | 88 | unset($encoded_get['sesc'], $encoded_get[$context['session_var']]); |
| 84 | 89 | $encoded_get = $smcFunc['json_encode']($encoded_get); |
| 90 | + } else { |
|
| 91 | + $encoded_get = ''; |
|
| 85 | 92 | } |
| 86 | - else |
|
| 87 | - $encoded_get = ''; |
|
| 88 | 93 | |
| 89 | 94 | // Guests use 0, members use their session ID. |
| 90 | 95 | $session_id = $user_info['is_guest'] ? 'ip' . $user_info['ip'] : session_id(); |
@@ -124,17 +129,18 @@ discard block |
||
| 124 | 129 | ); |
| 125 | 130 | |
| 126 | 131 | // Guess it got deleted. |
| 127 | - if ($smcFunc['db_affected_rows']() == 0) |
|
| 132 | + if ($smcFunc['db_affected_rows']() == 0) { |
|
| 133 | + $_SESSION['log_time'] = 0; |
|
| 134 | + } |
|
| 135 | + } else { |
|
| 128 | 136 | $_SESSION['log_time'] = 0; |
| 129 | 137 | } |
| 130 | - else |
|
| 131 | - $_SESSION['log_time'] = 0; |
|
| 132 | 138 | |
| 133 | 139 | // Otherwise, we have to delete and insert. |
| 134 | 140 | if (empty($_SESSION['log_time'])) |
| 135 | 141 | { |
| 136 | - if ($do_delete || !empty($user_info['id'])) |
|
| 137 | - $smcFunc['db_query']('', ' |
|
| 142 | + if ($do_delete || !empty($user_info['id'])) { |
|
| 143 | + $smcFunc['db_query']('', ' |
|
| 138 | 144 | DELETE FROM {db_prefix}log_online |
| 139 | 145 | WHERE ' . ($do_delete ? 'log_time < {int:log_time}' : '') . ($do_delete && !empty($user_info['id']) ? ' OR ' : '') . (empty($user_info['id']) ? '' : 'id_member = {int:current_member}'), |
| 140 | 146 | array( |
@@ -142,6 +148,7 @@ discard block |
||
| 142 | 148 | 'log_time' => time() - $modSettings['lastActive'] * 60, |
| 143 | 149 | ) |
| 144 | 150 | ); |
| 151 | + } |
|
| 145 | 152 | |
| 146 | 153 | $smcFunc['db_insert']($do_delete ? 'ignore' : 'replace', |
| 147 | 154 | '{db_prefix}log_online', |
@@ -155,21 +162,24 @@ discard block |
||
| 155 | 162 | $_SESSION['log_time'] = time(); |
| 156 | 163 | |
| 157 | 164 | // Well, they are online now. |
| 158 | - if (empty($_SESSION['timeOnlineUpdated'])) |
|
| 159 | - $_SESSION['timeOnlineUpdated'] = time(); |
|
| 165 | + if (empty($_SESSION['timeOnlineUpdated'])) { |
|
| 166 | + $_SESSION['timeOnlineUpdated'] = time(); |
|
| 167 | + } |
|
| 160 | 168 | |
| 161 | 169 | // Set their login time, if not already done within the last minute. |
| 162 | 170 | if (SMF != 'SSI' && !empty($user_info['last_login']) && $user_info['last_login'] < time() - 60 && (!isset($_REQUEST['action']) || !in_array($_REQUEST['action'], array('.xml', 'login2', 'logintfa')))) |
| 163 | 171 | { |
| 164 | 172 | // Don't count longer than 15 minutes. |
| 165 | - if (time() - $_SESSION['timeOnlineUpdated'] > 60 * 15) |
|
| 166 | - $_SESSION['timeOnlineUpdated'] = time(); |
|
| 173 | + if (time() - $_SESSION['timeOnlineUpdated'] > 60 * 15) { |
|
| 174 | + $_SESSION['timeOnlineUpdated'] = time(); |
|
| 175 | + } |
|
| 167 | 176 | |
| 168 | 177 | $user_settings['total_time_logged_in'] += time() - $_SESSION['timeOnlineUpdated']; |
| 169 | 178 | updateMemberData($user_info['id'], array('last_login' => time(), 'member_ip' => $user_info['ip'], 'member_ip2' => $_SERVER['BAN_CHECK_IP'], 'total_time_logged_in' => $user_settings['total_time_logged_in'])); |
| 170 | 179 | |
| 171 | - if (!empty($modSettings['cache_enable']) && $modSettings['cache_enable'] >= 2) |
|
| 172 | - cache_put_data('user_settings-' . $user_info['id'], $user_settings, 60); |
|
| 180 | + if (!empty($modSettings['cache_enable']) && $modSettings['cache_enable'] >= 2) { |
|
| 181 | + cache_put_data('user_settings-' . $user_info['id'], $user_settings, 60); |
|
| 182 | + } |
|
| 173 | 183 | |
| 174 | 184 | $user_info['total_time_logged_in'] += time() - $_SESSION['timeOnlineUpdated']; |
| 175 | 185 | $_SESSION['timeOnlineUpdated'] = time(); |
@@ -206,8 +216,7 @@ discard block |
||
| 206 | 216 | // Oops. maybe we have no more disk space left, or some other troubles, troubles... |
| 207 | 217 | // Copy the file back and run for your life! |
| 208 | 218 | @copy($boarddir . '/db_last_error_bak.php', $boarddir . '/db_last_error.php'); |
| 209 | - } |
|
| 210 | - else |
|
| 219 | + } else |
|
| 211 | 220 | { |
| 212 | 221 | @touch($boarddir . '/' . 'Settings.php'); |
| 213 | 222 | return true; |
@@ -227,22 +236,27 @@ discard block |
||
| 227 | 236 | global $db_cache, $db_count, $cache_misses, $cache_count_misses, $db_show_debug, $cache_count, $cache_hits, $smcFunc, $txt; |
| 228 | 237 | |
| 229 | 238 | // Add to Settings.php if you want to show the debugging information. |
| 230 | - if (!isset($db_show_debug) || $db_show_debug !== true || (isset($_GET['action']) && $_GET['action'] == 'viewquery')) |
|
| 231 | - return; |
|
| 239 | + if (!isset($db_show_debug) || $db_show_debug !== true || (isset($_GET['action']) && $_GET['action'] == 'viewquery')) { |
|
| 240 | + return; |
|
| 241 | + } |
|
| 232 | 242 | |
| 233 | - if (empty($_SESSION['view_queries'])) |
|
| 234 | - $_SESSION['view_queries'] = 0; |
|
| 235 | - if (empty($context['debug']['language_files'])) |
|
| 236 | - $context['debug']['language_files'] = array(); |
|
| 237 | - if (empty($context['debug']['sheets'])) |
|
| 238 | - $context['debug']['sheets'] = array(); |
|
| 243 | + if (empty($_SESSION['view_queries'])) { |
|
| 244 | + $_SESSION['view_queries'] = 0; |
|
| 245 | + } |
|
| 246 | + if (empty($context['debug']['language_files'])) { |
|
| 247 | + $context['debug']['language_files'] = array(); |
|
| 248 | + } |
|
| 249 | + if (empty($context['debug']['sheets'])) { |
|
| 250 | + $context['debug']['sheets'] = array(); |
|
| 251 | + } |
|
| 239 | 252 | |
| 240 | 253 | $files = get_included_files(); |
| 241 | 254 | $total_size = 0; |
| 242 | 255 | for ($i = 0, $n = count($files); $i < $n; $i++) |
| 243 | 256 | { |
| 244 | - if (file_exists($files[$i])) |
|
| 245 | - $total_size += filesize($files[$i]); |
|
| 257 | + if (file_exists($files[$i])) { |
|
| 258 | + $total_size += filesize($files[$i]); |
|
| 259 | + } |
|
| 246 | 260 | $files[$i] = strtr($files[$i], array($boarddir => '.', $sourcedir => '(Sources)', $cachedir => '(Cache)', $settings['actual_theme_dir'] => '(Current Theme)')); |
| 247 | 261 | } |
| 248 | 262 | |
@@ -251,8 +265,9 @@ discard block |
||
| 251 | 265 | { |
| 252 | 266 | foreach ($db_cache as $q => $qq) |
| 253 | 267 | { |
| 254 | - if (!empty($qq['w'])) |
|
| 255 | - $warnings += count($qq['w']); |
|
| 268 | + if (!empty($qq['w'])) { |
|
| 269 | + $warnings += count($qq['w']); |
|
| 270 | + } |
|
| 256 | 271 | } |
| 257 | 272 | |
| 258 | 273 | $_SESSION['debug'] = &$db_cache; |
@@ -273,12 +288,14 @@ discard block |
||
| 273 | 288 | ',(isset($context['debug']['instances']) ? ($txt['debug_instances'] . (empty($context['debug']['instances']) ? 0 : count($context['debug']['instances'])) . ' (<a href="javascript:void(0);" onclick="document.getElementById(\'debug_instances\').style.display = \'inline\'; this.style.display = \'none\'; return false;">'. $txt['debug_show'] .'</a><span id="debug_instances" style="display: none;"><em>'. implode('</em>, <em>', array_keys($context['debug']['instances'])) .'</em></span>)'. '<br>') : ''),' |
| 274 | 289 | ', $txt['debug_files_included'], count($files), ' - ', round($total_size / 1024), $txt['debug_kb'], ' (<a href="javascript:void(0);" onclick="document.getElementById(\'debug_include_info\').style.display = \'inline\'; this.style.display = \'none\'; return false;">', $txt['debug_show'], '</a><span id="debug_include_info" style="display: none;"><em>', implode('</em>, <em>', $files), '</em></span>)<br>'; |
| 275 | 290 | |
| 276 | - if (function_exists('memory_get_peak_usage')) |
|
| 277 | - echo $txt['debug_memory_use'], ceil(memory_get_peak_usage() / 1024), $txt['debug_kb'], '<br>'; |
|
| 291 | + if (function_exists('memory_get_peak_usage')) { |
|
| 292 | + echo $txt['debug_memory_use'], ceil(memory_get_peak_usage() / 1024), $txt['debug_kb'], '<br>'; |
|
| 293 | + } |
|
| 278 | 294 | |
| 279 | 295 | // What tokens are active? |
| 280 | - if (isset($_SESSION['token'])) |
|
| 281 | - echo $txt['debug_tokens'] . '<em>' . implode(',</em> <em>', array_keys($_SESSION['token'])), '</em>.<br>'; |
|
| 296 | + if (isset($_SESSION['token'])) { |
|
| 297 | + echo $txt['debug_tokens'] . '<em>' . implode(',</em> <em>', array_keys($_SESSION['token'])), '</em>.<br>'; |
|
| 298 | + } |
|
| 282 | 299 | |
| 283 | 300 | if (!empty($modSettings['cache_enable']) && !empty($cache_hits)) |
| 284 | 301 | { |
@@ -292,10 +309,12 @@ discard block |
||
| 292 | 309 | $total_t += $cache_hit['t']; |
| 293 | 310 | $total_s += $cache_hit['s']; |
| 294 | 311 | } |
| 295 | - if (!isset($cache_misses)) |
|
| 296 | - $cache_misses = array(); |
|
| 297 | - foreach ($cache_misses as $missed) |
|
| 298 | - $missed_entries[] = $missed['d'] . ' ' . $missed['k']; |
|
| 312 | + if (!isset($cache_misses)) { |
|
| 313 | + $cache_misses = array(); |
|
| 314 | + } |
|
| 315 | + foreach ($cache_misses as $missed) { |
|
| 316 | + $missed_entries[] = $missed['d'] . ' ' . $missed['k']; |
|
| 317 | + } |
|
| 299 | 318 | |
| 300 | 319 | echo ' |
| 301 | 320 | ', $txt['debug_cache_hits'], $cache_count, ': ', sprintf($txt['debug_cache_seconds_bytes_total'], comma_format($total_t, 5), comma_format($total_s)), ' (<a href="javascript:void(0);" onclick="document.getElementById(\'debug_cache_info\').style.display = \'inline\'; this.style.display = \'none\'; return false;">', $txt['debug_show'], '</a><span id="debug_cache_info" style="display: none;"><em>', implode('</em>, <em>', $entries), '</em></span>)<br> |
@@ -306,38 +325,44 @@ discard block |
||
| 306 | 325 | <a href="', $scripturl, '?action=viewquery" target="_blank">', $warnings == 0 ? sprintf($txt['debug_queries_used'], (int) $db_count) : sprintf($txt['debug_queries_used_and_warnings'], (int) $db_count, $warnings), '</a><br> |
| 307 | 326 | <br>'; |
| 308 | 327 | |
| 309 | - if ($_SESSION['view_queries'] == 1 && !empty($db_cache)) |
|
| 310 | - foreach ($db_cache as $q => $qq) |
|
| 328 | + if ($_SESSION['view_queries'] == 1 && !empty($db_cache)) { |
|
| 329 | + foreach ($db_cache as $q => $qq) |
|
| 311 | 330 | { |
| 312 | 331 | $is_select = strpos(trim($qq['q']), 'SELECT') === 0 || preg_match('~^INSERT(?: IGNORE)? INTO \w+(?:\s+\([^)]+\))?\s+SELECT .+$~s', trim($qq['q'])) != 0; |
| 332 | + } |
|
| 313 | 333 | // Temporary tables created in earlier queries are not explainable. |
| 314 | 334 | if ($is_select) |
| 315 | 335 | { |
| 316 | - foreach (array('log_topics_unread', 'topics_posted_in', 'tmp_log_search_topics', 'tmp_log_search_messages') as $tmp) |
|
| 317 | - if (strpos(trim($qq['q']), $tmp) !== false) |
|
| 336 | + foreach (array('log_topics_unread', 'topics_posted_in', 'tmp_log_search_topics', 'tmp_log_search_messages') as $tmp) { |
|
| 337 | + if (strpos(trim($qq['q']), $tmp) !== false) |
|
| 318 | 338 | { |
| 319 | 339 | $is_select = false; |
| 340 | + } |
|
| 320 | 341 | break; |
| 321 | 342 | } |
| 322 | 343 | } |
| 323 | 344 | // But actual creation of the temporary tables are. |
| 324 | - elseif (preg_match('~^CREATE TEMPORARY TABLE .+?SELECT .+$~s', trim($qq['q'])) != 0) |
|
| 325 | - $is_select = true; |
|
| 345 | + elseif (preg_match('~^CREATE TEMPORARY TABLE .+?SELECT .+$~s', trim($qq['q'])) != 0) { |
|
| 346 | + $is_select = true; |
|
| 347 | + } |
|
| 326 | 348 | |
| 327 | 349 | // Make the filenames look a bit better. |
| 328 | - if (isset($qq['f'])) |
|
| 329 | - $qq['f'] = preg_replace('~^' . preg_quote($boarddir, '~') . '~', '...', $qq['f']); |
|
| 350 | + if (isset($qq['f'])) { |
|
| 351 | + $qq['f'] = preg_replace('~^' . preg_quote($boarddir, '~') . '~', '...', $qq['f']); |
|
| 352 | + } |
|
| 330 | 353 | |
| 331 | 354 | echo ' |
| 332 | 355 | <strong>', $is_select ? '<a href="' . $scripturl . '?action=viewquery;qq=' . ($q + 1) . '#qq' . $q . '" target="_blank" style="text-decoration: none;">' : '', nl2br(str_replace("\t", ' ', $smcFunc['htmlspecialchars'](ltrim($qq['q'], "\n\r")))) . ($is_select ? '</a></strong>' : '</strong>') . '<br> |
| 333 | 356 | '; |
| 334 | - if (!empty($qq['f']) && !empty($qq['l'])) |
|
| 335 | - echo sprintf($txt['debug_query_in_line'], $qq['f'], $qq['l']); |
|
| 357 | + if (!empty($qq['f']) && !empty($qq['l'])) { |
|
| 358 | + echo sprintf($txt['debug_query_in_line'], $qq['f'], $qq['l']); |
|
| 359 | + } |
|
| 336 | 360 | |
| 337 | - if (isset($qq['s'], $qq['t']) && isset($txt['debug_query_which_took_at'])) |
|
| 338 | - echo sprintf($txt['debug_query_which_took_at'], round($qq['t'], 8), round($qq['s'], 8)) . '<br>'; |
|
| 339 | - elseif (isset($qq['t'])) |
|
| 340 | - echo sprintf($txt['debug_query_which_took'], round($qq['t'], 8)) . '<br>'; |
|
| 361 | + if (isset($qq['s'], $qq['t']) && isset($txt['debug_query_which_took_at'])) { |
|
| 362 | + echo sprintf($txt['debug_query_which_took_at'], round($qq['t'], 8), round($qq['s'], 8)) . '<br>'; |
|
| 363 | + } elseif (isset($qq['t'])) { |
|
| 364 | + echo sprintf($txt['debug_query_which_took'], round($qq['t'], 8)) . '<br>'; |
|
| 365 | + } |
|
| 341 | 366 | echo ' |
| 342 | 367 | <br>'; |
| 343 | 368 | } |
@@ -362,12 +387,14 @@ discard block |
||
| 362 | 387 | global $modSettings, $smcFunc; |
| 363 | 388 | static $cache_stats = array(); |
| 364 | 389 | |
| 365 | - if (empty($modSettings['trackStats'])) |
|
| 366 | - return false; |
|
| 367 | - if (!empty($stats)) |
|
| 368 | - return $cache_stats = array_merge($cache_stats, $stats); |
|
| 369 | - elseif (empty($cache_stats)) |
|
| 370 | - return false; |
|
| 390 | + if (empty($modSettings['trackStats'])) { |
|
| 391 | + return false; |
|
| 392 | + } |
|
| 393 | + if (!empty($stats)) { |
|
| 394 | + return $cache_stats = array_merge($cache_stats, $stats); |
|
| 395 | + } elseif (empty($cache_stats)) { |
|
| 396 | + return false; |
|
| 397 | + } |
|
| 371 | 398 | |
| 372 | 399 | $setStringUpdate = ''; |
| 373 | 400 | $insert_keys = array(); |
@@ -380,10 +407,11 @@ discard block |
||
| 380 | 407 | $setStringUpdate .= ' |
| 381 | 408 | ' . $field . ' = ' . ($change === '+' ? $field . ' + 1' : '{int:' . $field . '}') . ','; |
| 382 | 409 | |
| 383 | - if ($change === '+') |
|
| 384 | - $cache_stats[$field] = 1; |
|
| 385 | - else |
|
| 386 | - $update_parameters[$field] = $change; |
|
| 410 | + if ($change === '+') { |
|
| 411 | + $cache_stats[$field] = 1; |
|
| 412 | + } else { |
|
| 413 | + $update_parameters[$field] = $change; |
|
| 414 | + } |
|
| 387 | 415 | $insert_keys[$field] = 'int'; |
| 388 | 416 | } |
| 389 | 417 | |
@@ -447,43 +475,50 @@ discard block |
||
| 447 | 475 | ); |
| 448 | 476 | |
| 449 | 477 | // Make sure this particular log is enabled first... |
| 450 | - if (empty($modSettings['modlog_enabled'])) |
|
| 451 | - unset ($log_types['moderate']); |
|
| 452 | - if (empty($modSettings['userlog_enabled'])) |
|
| 453 | - unset ($log_types['user']); |
|
| 454 | - if (empty($modSettings['adminlog_enabled'])) |
|
| 455 | - unset ($log_types['admin']); |
|
| 478 | + if (empty($modSettings['modlog_enabled'])) { |
|
| 479 | + unset ($log_types['moderate']); |
|
| 480 | + } |
|
| 481 | + if (empty($modSettings['userlog_enabled'])) { |
|
| 482 | + unset ($log_types['user']); |
|
| 483 | + } |
|
| 484 | + if (empty($modSettings['adminlog_enabled'])) { |
|
| 485 | + unset ($log_types['admin']); |
|
| 486 | + } |
|
| 456 | 487 | |
| 457 | 488 | call_integration_hook('integrate_log_types', array(&$log_types)); |
| 458 | 489 | |
| 459 | 490 | foreach ($logs as $log) |
| 460 | 491 | { |
| 461 | - if (!isset($log_types[$log['log_type']])) |
|
| 462 | - return false; |
|
| 492 | + if (!isset($log_types[$log['log_type']])) { |
|
| 493 | + return false; |
|
| 494 | + } |
|
| 463 | 495 | |
| 464 | - if (!is_array($log['extra'])) |
|
| 465 | - trigger_error('logActions(): data is not an array with action \'' . $log['action'] . '\'', E_USER_NOTICE); |
|
| 496 | + if (!is_array($log['extra'])) { |
|
| 497 | + trigger_error('logActions(): data is not an array with action \'' . $log['action'] . '\'', E_USER_NOTICE); |
|
| 498 | + } |
|
| 466 | 499 | |
| 467 | 500 | // Pull out the parts we want to store separately, but also make sure that the data is proper |
| 468 | 501 | if (isset($log['extra']['topic'])) |
| 469 | 502 | { |
| 470 | - if (!is_numeric($log['extra']['topic'])) |
|
| 471 | - trigger_error('logActions(): data\'s topic is not a number', E_USER_NOTICE); |
|
| 503 | + if (!is_numeric($log['extra']['topic'])) { |
|
| 504 | + trigger_error('logActions(): data\'s topic is not a number', E_USER_NOTICE); |
|
| 505 | + } |
|
| 472 | 506 | $topic_id = empty($log['extra']['topic']) ? 0 : (int) $log['extra']['topic']; |
| 473 | 507 | unset($log['extra']['topic']); |
| 508 | + } else { |
|
| 509 | + $topic_id = 0; |
|
| 474 | 510 | } |
| 475 | - else |
|
| 476 | - $topic_id = 0; |
|
| 477 | 511 | |
| 478 | 512 | if (isset($log['extra']['message'])) |
| 479 | 513 | { |
| 480 | - if (!is_numeric($log['extra']['message'])) |
|
| 481 | - trigger_error('logActions(): data\'s message is not a number', E_USER_NOTICE); |
|
| 514 | + if (!is_numeric($log['extra']['message'])) { |
|
| 515 | + trigger_error('logActions(): data\'s message is not a number', E_USER_NOTICE); |
|
| 516 | + } |
|
| 482 | 517 | $msg_id = empty($log['extra']['message']) ? 0 : (int) $log['extra']['message']; |
| 483 | 518 | unset($log['extra']['message']); |
| 519 | + } else { |
|
| 520 | + $msg_id = 0; |
|
| 484 | 521 | } |
| 485 | - else |
|
| 486 | - $msg_id = 0; |
|
| 487 | 522 | |
| 488 | 523 | // @todo cache this? |
| 489 | 524 | // Is there an associated report on this? |
@@ -510,23 +545,26 @@ discard block |
||
| 510 | 545 | $smcFunc['db_free_result']($request); |
| 511 | 546 | } |
| 512 | 547 | |
| 513 | - if (isset($log['extra']['member']) && !is_numeric($log['extra']['member'])) |
|
| 514 | - trigger_error('logActions(): data\'s member is not a number', E_USER_NOTICE); |
|
| 548 | + if (isset($log['extra']['member']) && !is_numeric($log['extra']['member'])) { |
|
| 549 | + trigger_error('logActions(): data\'s member is not a number', E_USER_NOTICE); |
|
| 550 | + } |
|
| 515 | 551 | |
| 516 | 552 | if (isset($log['extra']['board'])) |
| 517 | 553 | { |
| 518 | - if (!is_numeric($log['extra']['board'])) |
|
| 519 | - trigger_error('logActions(): data\'s board is not a number', E_USER_NOTICE); |
|
| 554 | + if (!is_numeric($log['extra']['board'])) { |
|
| 555 | + trigger_error('logActions(): data\'s board is not a number', E_USER_NOTICE); |
|
| 556 | + } |
|
| 520 | 557 | $board_id = empty($log['extra']['board']) ? 0 : (int) $log['extra']['board']; |
| 521 | 558 | unset($log['extra']['board']); |
| 559 | + } else { |
|
| 560 | + $board_id = 0; |
|
| 522 | 561 | } |
| 523 | - else |
|
| 524 | - $board_id = 0; |
|
| 525 | 562 | |
| 526 | 563 | if (isset($log['extra']['board_to'])) |
| 527 | 564 | { |
| 528 | - if (!is_numeric($log['extra']['board_to'])) |
|
| 529 | - trigger_error('logActions(): data\'s board_to is not a number', E_USER_NOTICE); |
|
| 565 | + if (!is_numeric($log['extra']['board_to'])) { |
|
| 566 | + trigger_error('logActions(): data\'s board_to is not a number', E_USER_NOTICE); |
|
| 567 | + } |
|
| 530 | 568 | if (empty($board_id)) |
| 531 | 569 | { |
| 532 | 570 | $board_id = empty($log['extra']['board_to']) ? 0 : (int) $log['extra']['board_to']; |
@@ -534,10 +572,11 @@ discard block |
||
| 534 | 572 | } |
| 535 | 573 | } |
| 536 | 574 | |
| 537 | - if (isset($log['extra']['member_affected'])) |
|
| 538 | - $memID = $log['extra']['member_affected']; |
|
| 539 | - else |
|
| 540 | - $memID = $user_info['id']; |
|
| 575 | + if (isset($log['extra']['member_affected'])) { |
|
| 576 | + $memID = $log['extra']['member_affected']; |
|
| 577 | + } else { |
|
| 578 | + $memID = $user_info['id']; |
|
| 579 | + } |
|
| 541 | 580 | |
| 542 | 581 | $inserts[] = array( |
| 543 | 582 | time(), $log_types[$log['log_type']], $memID, $user_info['ip'], $log['action'], |
@@ -200,22 +200,22 @@ discard block |
||
| 200 | 200 | |
| 201 | 201 | case 'date': |
| 202 | 202 | if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d)$~', $replacement, $date_matches) === 1) |
| 203 | - return sprintf('\'%04d-%02d-%02d\'', $date_matches[1], $date_matches[2], $date_matches[3]).'::date'; |
|
| 203 | + return sprintf('\'%04d-%02d-%02d\'', $date_matches[1], $date_matches[2], $date_matches[3]) . '::date'; |
|
| 204 | 204 | else |
| 205 | 205 | smf_db_error_backtrace('Wrong value type sent to the database. Date expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
| 206 | 206 | break; |
| 207 | 207 | |
| 208 | 208 | case 'time': |
| 209 | 209 | if (preg_match('~^([0-1]?\d|2[0-3]):([0-5]\d):([0-5]\d)$~', $replacement, $time_matches) === 1) |
| 210 | - return sprintf('\'%02d:%02d:%02d\'', $time_matches[1], $time_matches[2], $time_matches[3]).'::time'; |
|
| 210 | + return sprintf('\'%02d:%02d:%02d\'', $time_matches[1], $time_matches[2], $time_matches[3]) . '::time'; |
|
| 211 | 211 | else |
| 212 | 212 | smf_db_error_backtrace('Wrong value type sent to the database. Time expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
| 213 | 213 | break; |
| 214 | 214 | |
| 215 | 215 | case 'datetime': |
| 216 | 216 | if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d) ([0-1]?\d|2[0-3]):([0-5]\d):([0-5]\d)$~', $replacement, $datetime_matches) === 1) |
| 217 | - return 'to_timestamp('. |
|
| 218 | - sprintf('\'%04d-%02d-%02d %02d:%02d:%02d\'', $datetime_matches[1], $datetime_matches[2], $datetime_matches[3], $datetime_matches[4], $datetime_matches[5] ,$datetime_matches[6]). |
|
| 217 | + return 'to_timestamp(' . |
|
| 218 | + sprintf('\'%04d-%02d-%02d %02d:%02d:%02d\'', $datetime_matches[1], $datetime_matches[2], $datetime_matches[3], $datetime_matches[4], $datetime_matches[5], $datetime_matches[6]) . |
|
| 219 | 219 | ',\'YYYY-MM-DD HH24:MI:SS\')'; |
| 220 | 220 | else |
| 221 | 221 | smf_db_error_backtrace('Wrong value type sent to the database. Datetime expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
@@ -767,7 +767,7 @@ discard block |
||
| 767 | 767 | if (!empty($keys) && (count($keys) > 0) && $returnmode > 0) |
| 768 | 768 | { |
| 769 | 769 | // we only take the first key |
| 770 | - $returning = ' RETURNING '.$keys[0]; |
|
| 770 | + $returning = ' RETURNING ' . $keys[0]; |
|
| 771 | 771 | $with_returning = true; |
| 772 | 772 | } |
| 773 | 773 | |
@@ -798,7 +798,7 @@ discard block |
||
| 798 | 798 | INSERT INTO ' . $table . '("' . implode('", "', $indexed_columns) . '") |
| 799 | 799 | VALUES |
| 800 | 800 | ' . implode(', |
| 801 | - ', $insertRows).$replace.$returning, |
|
| 801 | + ', $insertRows) . $replace . $returning, |
|
| 802 | 802 | array( |
| 803 | 803 | 'security_override' => true, |
| 804 | 804 | 'db_error_skip' => $method == 'ignore' || $table === $db_prefix . 'log_errors', |
@@ -811,7 +811,7 @@ discard block |
||
| 811 | 811 | if ($returnmode === 2) |
| 812 | 812 | $return_var = array(); |
| 813 | 813 | |
| 814 | - while(($row = $smcFunc['db_fetch_row']($request)) && $with_returning) |
|
| 814 | + while (($row = $smcFunc['db_fetch_row']($request)) && $with_returning) |
|
| 815 | 815 | { |
| 816 | 816 | if (is_numeric($row[0])) // try to emulate mysql limitation |
| 817 | 817 | { |
@@ -500,7 +500,7 @@ discard block |
||
| 500 | 500 | /** |
| 501 | 501 | * Returns the amount of affected rows for a query. |
| 502 | 502 | * |
| 503 | - * @param mixed $result |
|
| 503 | + * @param resource|null $result |
|
| 504 | 504 | * |
| 505 | 505 | * @return int |
| 506 | 506 | * |
@@ -869,7 +869,7 @@ discard block |
||
| 869 | 869 | * |
| 870 | 870 | * @param string $db_name The database name |
| 871 | 871 | * @param resource $db_connection The database connection |
| 872 | - * @return true Always returns true |
|
| 872 | + * @return boolean Always returns true |
|
| 873 | 873 | */ |
| 874 | 874 | function smf_db_select_db($db_name, $db_connection) |
| 875 | 875 | { |
@@ -13,8 +13,9 @@ discard block |
||
| 13 | 13 | * @version 2.1 Beta 4 |
| 14 | 14 | */ |
| 15 | 15 | |
| 16 | -if (!defined('SMF')) |
|
| 16 | +if (!defined('SMF')) { |
|
| 17 | 17 | die('No direct access...'); |
| 18 | +} |
|
| 18 | 19 | |
| 19 | 20 | /** |
| 20 | 21 | * Maps the implementations in this file (smf_db_function_name) |
@@ -34,8 +35,8 @@ discard block |
||
| 34 | 35 | global $smcFunc; |
| 35 | 36 | |
| 36 | 37 | // Map some database specific functions, only do this once. |
| 37 | - if (!isset($smcFunc['db_fetch_assoc'])) |
|
| 38 | - $smcFunc += array( |
|
| 38 | + if (!isset($smcFunc['db_fetch_assoc'])) { |
|
| 39 | + $smcFunc += array( |
|
| 39 | 40 | 'db_query' => 'smf_db_query', |
| 40 | 41 | 'db_quote' => 'smf_db_quote', |
| 41 | 42 | 'db_insert' => 'smf_db_insert', |
@@ -63,11 +64,13 @@ discard block |
||
| 63 | 64 | 'db_fetch_all' => 'smf_db_fetch_all', |
| 64 | 65 | 'db_error_insert' => 'smf_db_error_insert', |
| 65 | 66 | ); |
| 67 | + } |
|
| 66 | 68 | |
| 67 | - if (!empty($db_options['persist'])) |
|
| 68 | - $connection = @pg_pconnect('host=' . $db_server . ' dbname=' . $db_name . ' user=\'' . $db_user . '\' password=\'' . $db_passwd . '\'' . (empty($db_options['port']) ? '' : ' port=\'' . $db_options['port'] . '\'')); |
|
| 69 | - else |
|
| 70 | - $connection = @pg_connect('host=' . $db_server . ' dbname=' . $db_name . ' user=\'' . $db_user . '\' password=\'' . $db_passwd . '\'' . (empty($db_options['port']) ? '' : ' port=\'' . $db_options['port'] . '\'')); |
|
| 69 | + if (!empty($db_options['persist'])) { |
|
| 70 | + $connection = @pg_pconnect('host=' . $db_server . ' dbname=' . $db_name . ' user=\'' . $db_user . '\' password=\'' . $db_passwd . '\'' . (empty($db_options['port']) ? '' : ' port=\'' . $db_options['port'] . '\'')); |
|
| 71 | + } else { |
|
| 72 | + $connection = @pg_connect('host=' . $db_server . ' dbname=' . $db_name . ' user=\'' . $db_user . '\' password=\'' . $db_passwd . '\'' . (empty($db_options['port']) ? '' : ' port=\'' . $db_options['port'] . '\'')); |
|
| 73 | + } |
|
| 71 | 74 | |
| 72 | 75 | // Something's wrong, show an error if its fatal (which we assume it is) |
| 73 | 76 | if (!$connection) |
@@ -75,8 +78,7 @@ discard block |
||
| 75 | 78 | if (!empty($db_options['non_fatal'])) |
| 76 | 79 | { |
| 77 | 80 | return null; |
| 78 | - } |
|
| 79 | - else |
|
| 81 | + } else |
|
| 80 | 82 | { |
| 81 | 83 | display_db_error(); |
| 82 | 84 | } |
@@ -127,31 +129,38 @@ discard block |
||
| 127 | 129 | |
| 128 | 130 | list ($values, $connection) = $db_callback; |
| 129 | 131 | |
| 130 | - if ($matches[1] === 'db_prefix') |
|
| 131 | - return $db_prefix; |
|
| 132 | + if ($matches[1] === 'db_prefix') { |
|
| 133 | + return $db_prefix; |
|
| 134 | + } |
|
| 132 | 135 | |
| 133 | - if (isset($user_info[$matches[1]]) && strpos($matches[1], 'query_') !== false) |
|
| 134 | - return $user_info[$matches[1]]; |
|
| 136 | + if (isset($user_info[$matches[1]]) && strpos($matches[1], 'query_') !== false) { |
|
| 137 | + return $user_info[$matches[1]]; |
|
| 138 | + } |
|
| 135 | 139 | |
| 136 | - if ($matches[1] === 'empty') |
|
| 137 | - return '\'\''; |
|
| 140 | + if ($matches[1] === 'empty') { |
|
| 141 | + return '\'\''; |
|
| 142 | + } |
|
| 138 | 143 | |
| 139 | - if (!isset($matches[2])) |
|
| 140 | - smf_db_error_backtrace('Invalid value inserted or no type specified.', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 144 | + if (!isset($matches[2])) { |
|
| 145 | + smf_db_error_backtrace('Invalid value inserted or no type specified.', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 146 | + } |
|
| 141 | 147 | |
| 142 | - if ($matches[1] === 'literal') |
|
| 143 | - return '\'' . pg_escape_string($matches[2]) . '\''; |
|
| 148 | + if ($matches[1] === 'literal') { |
|
| 149 | + return '\'' . pg_escape_string($matches[2]) . '\''; |
|
| 150 | + } |
|
| 144 | 151 | |
| 145 | - if (!isset($values[$matches[2]])) |
|
| 146 | - smf_db_error_backtrace('The database value you\'re trying to insert does not exist: ' . (isset($smcFunc['htmlspecialchars']) ? $smcFunc['htmlspecialchars']($matches[2]) : htmlspecialchars($matches[2])), '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 152 | + if (!isset($values[$matches[2]])) { |
|
| 153 | + smf_db_error_backtrace('The database value you\'re trying to insert does not exist: ' . (isset($smcFunc['htmlspecialchars']) ? $smcFunc['htmlspecialchars']($matches[2]) : htmlspecialchars($matches[2])), '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 154 | + } |
|
| 147 | 155 | |
| 148 | 156 | $replacement = $values[$matches[2]]; |
| 149 | 157 | |
| 150 | 158 | switch ($matches[1]) |
| 151 | 159 | { |
| 152 | 160 | case 'int': |
| 153 | - if (!is_numeric($replacement) || (string) $replacement !== (string) (int) $replacement) |
|
| 154 | - smf_db_error_backtrace('Wrong value type sent to the database. Integer expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 161 | + if (!is_numeric($replacement) || (string) $replacement !== (string) (int) $replacement) { |
|
| 162 | + smf_db_error_backtrace('Wrong value type sent to the database. Integer expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 163 | + } |
|
| 155 | 164 | return (string) (int) $replacement; |
| 156 | 165 | break; |
| 157 | 166 | |
@@ -163,65 +172,73 @@ discard block |
||
| 163 | 172 | case 'array_int': |
| 164 | 173 | if (is_array($replacement)) |
| 165 | 174 | { |
| 166 | - if (empty($replacement)) |
|
| 167 | - smf_db_error_backtrace('Database error, given array of integer values is empty. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 175 | + if (empty($replacement)) { |
|
| 176 | + smf_db_error_backtrace('Database error, given array of integer values is empty. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 177 | + } |
|
| 168 | 178 | |
| 169 | 179 | foreach ($replacement as $key => $value) |
| 170 | 180 | { |
| 171 | - if (!is_numeric($value) || (string) $value !== (string) (int) $value) |
|
| 172 | - smf_db_error_backtrace('Wrong value type sent to the database. Array of integers expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 181 | + if (!is_numeric($value) || (string) $value !== (string) (int) $value) { |
|
| 182 | + smf_db_error_backtrace('Wrong value type sent to the database. Array of integers expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 183 | + } |
|
| 173 | 184 | |
| 174 | 185 | $replacement[$key] = (string) (int) $value; |
| 175 | 186 | } |
| 176 | 187 | |
| 177 | 188 | return implode(', ', $replacement); |
| 189 | + } else { |
|
| 190 | + smf_db_error_backtrace('Wrong value type sent to the database. Array of integers expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 178 | 191 | } |
| 179 | - else |
|
| 180 | - smf_db_error_backtrace('Wrong value type sent to the database. Array of integers expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 181 | 192 | |
| 182 | 193 | break; |
| 183 | 194 | |
| 184 | 195 | case 'array_string': |
| 185 | 196 | if (is_array($replacement)) |
| 186 | 197 | { |
| 187 | - if (empty($replacement)) |
|
| 188 | - smf_db_error_backtrace('Database error, given array of string values is empty. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 198 | + if (empty($replacement)) { |
|
| 199 | + smf_db_error_backtrace('Database error, given array of string values is empty. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 200 | + } |
|
| 189 | 201 | |
| 190 | - foreach ($replacement as $key => $value) |
|
| 191 | - $replacement[$key] = sprintf('\'%1$s\'', pg_escape_string($value)); |
|
| 202 | + foreach ($replacement as $key => $value) { |
|
| 203 | + $replacement[$key] = sprintf('\'%1$s\'', pg_escape_string($value)); |
|
| 204 | + } |
|
| 192 | 205 | |
| 193 | 206 | return implode(', ', $replacement); |
| 207 | + } else { |
|
| 208 | + smf_db_error_backtrace('Wrong value type sent to the database. Array of strings expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 194 | 209 | } |
| 195 | - else |
|
| 196 | - smf_db_error_backtrace('Wrong value type sent to the database. Array of strings expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 197 | 210 | break; |
| 198 | 211 | |
| 199 | 212 | case 'date': |
| 200 | - if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d)$~', $replacement, $date_matches) === 1) |
|
| 201 | - return sprintf('\'%04d-%02d-%02d\'', $date_matches[1], $date_matches[2], $date_matches[3]).'::date'; |
|
| 202 | - else |
|
| 203 | - smf_db_error_backtrace('Wrong value type sent to the database. Date expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 213 | + if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d)$~', $replacement, $date_matches) === 1) { |
|
| 214 | + return sprintf('\'%04d-%02d-%02d\'', $date_matches[1], $date_matches[2], $date_matches[3]).'::date'; |
|
| 215 | + } else { |
|
| 216 | + smf_db_error_backtrace('Wrong value type sent to the database. Date expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 217 | + } |
|
| 204 | 218 | break; |
| 205 | 219 | |
| 206 | 220 | case 'time': |
| 207 | - if (preg_match('~^([0-1]?\d|2[0-3]):([0-5]\d):([0-5]\d)$~', $replacement, $time_matches) === 1) |
|
| 208 | - return sprintf('\'%02d:%02d:%02d\'', $time_matches[1], $time_matches[2], $time_matches[3]).'::time'; |
|
| 209 | - else |
|
| 210 | - smf_db_error_backtrace('Wrong value type sent to the database. Time expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 221 | + if (preg_match('~^([0-1]?\d|2[0-3]):([0-5]\d):([0-5]\d)$~', $replacement, $time_matches) === 1) { |
|
| 222 | + return sprintf('\'%02d:%02d:%02d\'', $time_matches[1], $time_matches[2], $time_matches[3]).'::time'; |
|
| 223 | + } else { |
|
| 224 | + smf_db_error_backtrace('Wrong value type sent to the database. Time expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 225 | + } |
|
| 211 | 226 | break; |
| 212 | 227 | |
| 213 | 228 | case 'datetime': |
| 214 | - if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d) ([0-1]?\d|2[0-3]):([0-5]\d):([0-5]\d)$~', $replacement, $datetime_matches) === 1) |
|
| 215 | - return 'to_timestamp('. |
|
| 229 | + if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d) ([0-1]?\d|2[0-3]):([0-5]\d):([0-5]\d)$~', $replacement, $datetime_matches) === 1) { |
|
| 230 | + return 'to_timestamp('. |
|
| 216 | 231 | sprintf('\'%04d-%02d-%02d %02d:%02d:%02d\'', $datetime_matches[1], $datetime_matches[2], $datetime_matches[3], $datetime_matches[4], $datetime_matches[5] ,$datetime_matches[6]). |
| 217 | 232 | ',\'YYYY-MM-DD HH24:MI:SS\')'; |
| 218 | - else |
|
| 219 | - smf_db_error_backtrace('Wrong value type sent to the database. Datetime expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 233 | + } else { |
|
| 234 | + smf_db_error_backtrace('Wrong value type sent to the database. Datetime expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 235 | + } |
|
| 220 | 236 | break; |
| 221 | 237 | |
| 222 | 238 | case 'float': |
| 223 | - if (!is_numeric($replacement)) |
|
| 224 | - smf_db_error_backtrace('Wrong value type sent to the database. Floating point number expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 239 | + if (!is_numeric($replacement)) { |
|
| 240 | + smf_db_error_backtrace('Wrong value type sent to the database. Floating point number expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 241 | + } |
|
| 225 | 242 | return (string) (float) $replacement; |
| 226 | 243 | break; |
| 227 | 244 | |
@@ -234,31 +251,36 @@ discard block |
||
| 234 | 251 | break; |
| 235 | 252 | |
| 236 | 253 | case 'inet': |
| 237 | - if ($replacement == 'null' || $replacement == '') |
|
| 238 | - return 'null'; |
|
| 239 | - if (inet_pton($replacement) === false) |
|
| 240 | - smf_db_error_backtrace('Wrong value type sent to the database. IPv4 or IPv6 expected.(' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 254 | + if ($replacement == 'null' || $replacement == '') { |
|
| 255 | + return 'null'; |
|
| 256 | + } |
|
| 257 | + if (inet_pton($replacement) === false) { |
|
| 258 | + smf_db_error_backtrace('Wrong value type sent to the database. IPv4 or IPv6 expected.(' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 259 | + } |
|
| 241 | 260 | return sprintf('\'%1$s\'::inet', pg_escape_string($replacement)); |
| 242 | 261 | |
| 243 | 262 | case 'array_inet': |
| 244 | 263 | if (is_array($replacement)) |
| 245 | 264 | { |
| 246 | - if (empty($replacement)) |
|
| 247 | - smf_db_error_backtrace('Database error, given array of IPv4 or IPv6 values is empty. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 265 | + if (empty($replacement)) { |
|
| 266 | + smf_db_error_backtrace('Database error, given array of IPv4 or IPv6 values is empty. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 267 | + } |
|
| 248 | 268 | |
| 249 | 269 | foreach ($replacement as $key => $value) |
| 250 | 270 | { |
| 251 | - if ($replacement == 'null' || $replacement == '') |
|
| 252 | - $replacement[$key] = 'null'; |
|
| 253 | - if (!isValidIP($value)) |
|
| 254 | - smf_db_error_backtrace('Wrong value type sent to the database. IPv4 or IPv6 expected.(' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 271 | + if ($replacement == 'null' || $replacement == '') { |
|
| 272 | + $replacement[$key] = 'null'; |
|
| 273 | + } |
|
| 274 | + if (!isValidIP($value)) { |
|
| 275 | + smf_db_error_backtrace('Wrong value type sent to the database. IPv4 or IPv6 expected.(' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 276 | + } |
|
| 255 | 277 | $replacement[$key] = sprintf('\'%1$s\'::inet', pg_escape_string($value)); |
| 256 | 278 | } |
| 257 | 279 | |
| 258 | 280 | return implode(', ', $replacement); |
| 281 | + } else { |
|
| 282 | + smf_db_error_backtrace('Wrong value type sent to the database. Array of IPv4 or IPv6 expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 259 | 283 | } |
| 260 | - else |
|
| 261 | - smf_db_error_backtrace('Wrong value type sent to the database. Array of IPv4 or IPv6 expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 262 | 284 | break; |
| 263 | 285 | |
| 264 | 286 | default: |
@@ -349,14 +371,16 @@ discard block |
||
| 349 | 371 | ), |
| 350 | 372 | ); |
| 351 | 373 | |
| 352 | - if (isset($replacements[$identifier])) |
|
| 353 | - $db_string = preg_replace(array_keys($replacements[$identifier]), array_values($replacements[$identifier]), $db_string); |
|
| 374 | + if (isset($replacements[$identifier])) { |
|
| 375 | + $db_string = preg_replace(array_keys($replacements[$identifier]), array_values($replacements[$identifier]), $db_string); |
|
| 376 | + } |
|
| 354 | 377 | |
| 355 | 378 | // Limits need to be a little different. |
| 356 | 379 | $db_string = preg_replace('~\sLIMIT\s(\d+|{int:.+}),\s*(\d+|{int:.+})\s*$~i', 'LIMIT $2 OFFSET $1', $db_string); |
| 357 | 380 | |
| 358 | - if (trim($db_string) == '') |
|
| 359 | - return false; |
|
| 381 | + if (trim($db_string) == '') { |
|
| 382 | + return false; |
|
| 383 | + } |
|
| 360 | 384 | |
| 361 | 385 | // Comments that are allowed in a query are preg_removed. |
| 362 | 386 | static $allowed_comments_from = array( |
@@ -376,8 +400,9 @@ discard block |
||
| 376 | 400 | $db_count = !isset($db_count) ? 1 : $db_count + 1; |
| 377 | 401 | $db_replace_result = 0; |
| 378 | 402 | |
| 379 | - if (empty($modSettings['disableQueryCheck']) && strpos($db_string, '\'') !== false && empty($db_values['security_override'])) |
|
| 380 | - smf_db_error_backtrace('Hacking attempt...', 'Illegal character (\') used in query...', true, __FILE__, __LINE__); |
|
| 403 | + if (empty($modSettings['disableQueryCheck']) && strpos($db_string, '\'') !== false && empty($db_values['security_override'])) { |
|
| 404 | + smf_db_error_backtrace('Hacking attempt...', 'Illegal character (\') used in query...', true, __FILE__, __LINE__); |
|
| 405 | + } |
|
| 381 | 406 | |
| 382 | 407 | if (empty($db_values['security_override']) && (!empty($db_values) || strpos($db_string, '{db_prefix}') !== false)) |
| 383 | 408 | { |
@@ -398,8 +423,9 @@ discard block |
||
| 398 | 423 | list ($file, $line) = smf_db_error_backtrace('', '', 'return', __FILE__, __LINE__); |
| 399 | 424 | |
| 400 | 425 | // Initialize $db_cache if not already initialized. |
| 401 | - if (!isset($db_cache)) |
|
| 402 | - $db_cache = array(); |
|
| 426 | + if (!isset($db_cache)) { |
|
| 427 | + $db_cache = array(); |
|
| 428 | + } |
|
| 403 | 429 | |
| 404 | 430 | if (!empty($_SESSION['debug_redirect'])) |
| 405 | 431 | { |
@@ -425,17 +451,18 @@ discard block |
||
| 425 | 451 | while (true) |
| 426 | 452 | { |
| 427 | 453 | $pos = strpos($db_string, '\'', $pos + 1); |
| 428 | - if ($pos === false) |
|
| 429 | - break; |
|
| 454 | + if ($pos === false) { |
|
| 455 | + break; |
|
| 456 | + } |
|
| 430 | 457 | $clean .= substr($db_string, $old_pos, $pos - $old_pos); |
| 431 | 458 | |
| 432 | 459 | while (true) |
| 433 | 460 | { |
| 434 | 461 | $pos1 = strpos($db_string, '\'', $pos + 1); |
| 435 | 462 | $pos2 = strpos($db_string, '\\', $pos + 1); |
| 436 | - if ($pos1 === false) |
|
| 437 | - break; |
|
| 438 | - elseif ($pos2 === false || $pos2 > $pos1) |
|
| 463 | + if ($pos1 === false) { |
|
| 464 | + break; |
|
| 465 | + } elseif ($pos2 === false || $pos2 > $pos1) |
|
| 439 | 466 | { |
| 440 | 467 | $pos = $pos1; |
| 441 | 468 | break; |
@@ -451,16 +478,19 @@ discard block |
||
| 451 | 478 | $clean = trim(strtolower(preg_replace($allowed_comments_from, $allowed_comments_to, $clean))); |
| 452 | 479 | |
| 453 | 480 | // Comments? We don't use comments in our queries, we leave 'em outside! |
| 454 | - if (strpos($clean, '/*') > 2 || strpos($clean, '--') !== false || strpos($clean, ';') !== false) |
|
| 455 | - $fail = true; |
|
| 481 | + if (strpos($clean, '/*') > 2 || strpos($clean, '--') !== false || strpos($clean, ';') !== false) { |
|
| 482 | + $fail = true; |
|
| 483 | + } |
|
| 456 | 484 | // Trying to change passwords, slow us down, or something? |
| 457 | - elseif (strpos($clean, 'sleep') !== false && preg_match('~(^|[^a-z])sleep($|[^[_a-z])~s', $clean) != 0) |
|
| 458 | - $fail = true; |
|
| 459 | - elseif (strpos($clean, 'benchmark') !== false && preg_match('~(^|[^a-z])benchmark($|[^[a-z])~s', $clean) != 0) |
|
| 460 | - $fail = true; |
|
| 485 | + elseif (strpos($clean, 'sleep') !== false && preg_match('~(^|[^a-z])sleep($|[^[_a-z])~s', $clean) != 0) { |
|
| 486 | + $fail = true; |
|
| 487 | + } elseif (strpos($clean, 'benchmark') !== false && preg_match('~(^|[^a-z])benchmark($|[^[a-z])~s', $clean) != 0) { |
|
| 488 | + $fail = true; |
|
| 489 | + } |
|
| 461 | 490 | |
| 462 | - if (!empty($fail) && function_exists('log_error')) |
|
| 463 | - smf_db_error_backtrace('Hacking attempt...', 'Hacking attempt...' . "\n" . $db_string, E_USER_ERROR, __FILE__, __LINE__); |
|
| 491 | + if (!empty($fail) && function_exists('log_error')) { |
|
| 492 | + smf_db_error_backtrace('Hacking attempt...', 'Hacking attempt...' . "\n" . $db_string, E_USER_ERROR, __FILE__, __LINE__); |
|
| 493 | + } |
|
| 464 | 494 | } |
| 465 | 495 | |
| 466 | 496 | // Set optimize stuff |
@@ -479,18 +509,21 @@ discard block |
||
| 479 | 509 | |
| 480 | 510 | $db_string = $query_hints_set . $db_string; |
| 481 | 511 | |
| 482 | - if (isset($db_show_debug) && $db_show_debug === true && $db_cache[$db_count]['q'] != '...') |
|
| 483 | - $db_cache[$db_count]['q'] = "\t\t" . $db_string; |
|
| 512 | + if (isset($db_show_debug) && $db_show_debug === true && $db_cache[$db_count]['q'] != '...') { |
|
| 513 | + $db_cache[$db_count]['q'] = "\t\t" . $db_string; |
|
| 514 | + } |
|
| 484 | 515 | } |
| 485 | 516 | |
| 486 | 517 | $db_last_result = @pg_query($connection, $db_string); |
| 487 | 518 | |
| 488 | - if ($db_last_result === false && empty($db_values['db_error_skip'])) |
|
| 489 | - $db_last_result = smf_db_error($db_string, $connection); |
|
| 519 | + if ($db_last_result === false && empty($db_values['db_error_skip'])) { |
|
| 520 | + $db_last_result = smf_db_error($db_string, $connection); |
|
| 521 | + } |
|
| 490 | 522 | |
| 491 | 523 | // Debugging. |
| 492 | - if (isset($db_show_debug) && $db_show_debug === true) |
|
| 493 | - $db_cache[$db_count]['t'] = array_sum(explode(' ', microtime())) - array_sum(explode(' ', $st)); |
|
| 524 | + if (isset($db_show_debug) && $db_show_debug === true) { |
|
| 525 | + $db_cache[$db_count]['t'] = array_sum(explode(' ', microtime())) - array_sum(explode(' ', $st)); |
|
| 526 | + } |
|
| 494 | 527 | |
| 495 | 528 | return $db_last_result; |
| 496 | 529 | } |
@@ -507,10 +540,11 @@ discard block |
||
| 507 | 540 | { |
| 508 | 541 | global $db_last_result, $db_replace_result; |
| 509 | 542 | |
| 510 | - if ($db_replace_result) |
|
| 511 | - return $db_replace_result; |
|
| 512 | - elseif ($result === null && !$db_last_result) |
|
| 513 | - return 0; |
|
| 543 | + if ($db_replace_result) { |
|
| 544 | + return $db_replace_result; |
|
| 545 | + } elseif ($result === null && !$db_last_result) { |
|
| 546 | + return 0; |
|
| 547 | + } |
|
| 514 | 548 | |
| 515 | 549 | return pg_affected_rows($result === null ? $db_last_result : $result); |
| 516 | 550 | } |
@@ -534,8 +568,9 @@ discard block |
||
| 534 | 568 | array( |
| 535 | 569 | ) |
| 536 | 570 | ); |
| 537 | - if (!$request) |
|
| 538 | - return false; |
|
| 571 | + if (!$request) { |
|
| 572 | + return false; |
|
| 573 | + } |
|
| 539 | 574 | list ($lastID) = $smcFunc['db_fetch_row']($request); |
| 540 | 575 | $smcFunc['db_free_result']($request); |
| 541 | 576 | |
@@ -556,12 +591,13 @@ discard block |
||
| 556 | 591 | // Decide which connection to use |
| 557 | 592 | $connection = $connection === null ? $db_connection : $connection; |
| 558 | 593 | |
| 559 | - if ($type == 'begin') |
|
| 560 | - return @pg_query($connection, 'BEGIN'); |
|
| 561 | - elseif ($type == 'rollback') |
|
| 562 | - return @pg_query($connection, 'ROLLBACK'); |
|
| 563 | - elseif ($type == 'commit') |
|
| 564 | - return @pg_query($connection, 'COMMIT'); |
|
| 594 | + if ($type == 'begin') { |
|
| 595 | + return @pg_query($connection, 'BEGIN'); |
|
| 596 | + } elseif ($type == 'rollback') { |
|
| 597 | + return @pg_query($connection, 'ROLLBACK'); |
|
| 598 | + } elseif ($type == 'commit') { |
|
| 599 | + return @pg_query($connection, 'COMMIT'); |
|
| 600 | + } |
|
| 565 | 601 | |
| 566 | 602 | return false; |
| 567 | 603 | } |
@@ -589,19 +625,22 @@ discard block |
||
| 589 | 625 | $query_error = @pg_last_error($connection); |
| 590 | 626 | |
| 591 | 627 | // Log the error. |
| 592 | - if (function_exists('log_error')) |
|
| 593 | - log_error($txt['database_error'] . ': ' . $query_error . (!empty($modSettings['enableErrorQueryLogging']) ? "\n\n" . $db_string : ''), 'database', $file, $line); |
|
| 628 | + if (function_exists('log_error')) { |
|
| 629 | + log_error($txt['database_error'] . ': ' . $query_error . (!empty($modSettings['enableErrorQueryLogging']) ? "\n\n" . $db_string : ''), 'database', $file, $line); |
|
| 630 | + } |
|
| 594 | 631 | |
| 595 | 632 | // Nothing's defined yet... just die with it. |
| 596 | - if (empty($context) || empty($txt)) |
|
| 597 | - die($query_error); |
|
| 633 | + if (empty($context) || empty($txt)) { |
|
| 634 | + die($query_error); |
|
| 635 | + } |
|
| 598 | 636 | |
| 599 | 637 | // Show an error message, if possible. |
| 600 | 638 | $context['error_title'] = $txt['database_error']; |
| 601 | - if (allowedTo('admin_forum')) |
|
| 602 | - $context['error_message'] = nl2br($query_error) . '<br>' . $txt['file'] . ': ' . $file . '<br>' . $txt['line'] . ': ' . $line; |
|
| 603 | - else |
|
| 604 | - $context['error_message'] = $txt['try_again']; |
|
| 639 | + if (allowedTo('admin_forum')) { |
|
| 640 | + $context['error_message'] = nl2br($query_error) . '<br>' . $txt['file'] . ': ' . $file . '<br>' . $txt['line'] . ': ' . $line; |
|
| 641 | + } else { |
|
| 642 | + $context['error_message'] = $txt['try_again']; |
|
| 643 | + } |
|
| 605 | 644 | |
| 606 | 645 | if (allowedTo('admin_forum') && isset($db_show_debug) && $db_show_debug === true) |
| 607 | 646 | { |
@@ -623,12 +662,14 @@ discard block |
||
| 623 | 662 | { |
| 624 | 663 | global $db_row_count; |
| 625 | 664 | |
| 626 | - if ($counter !== false) |
|
| 627 | - return pg_fetch_row($request, $counter); |
|
| 665 | + if ($counter !== false) { |
|
| 666 | + return pg_fetch_row($request, $counter); |
|
| 667 | + } |
|
| 628 | 668 | |
| 629 | 669 | // Reset the row counter... |
| 630 | - if (!isset($db_row_count[(int) $request])) |
|
| 631 | - $db_row_count[(int) $request] = 0; |
|
| 670 | + if (!isset($db_row_count[(int) $request])) { |
|
| 671 | + $db_row_count[(int) $request] = 0; |
|
| 672 | + } |
|
| 632 | 673 | |
| 633 | 674 | // Return the right row. |
| 634 | 675 | return @pg_fetch_row($request, $db_row_count[(int) $request]++); |
@@ -645,12 +686,14 @@ discard block |
||
| 645 | 686 | { |
| 646 | 687 | global $db_row_count; |
| 647 | 688 | |
| 648 | - if ($counter !== false) |
|
| 649 | - return pg_fetch_assoc($request, $counter); |
|
| 689 | + if ($counter !== false) { |
|
| 690 | + return pg_fetch_assoc($request, $counter); |
|
| 691 | + } |
|
| 650 | 692 | |
| 651 | 693 | // Reset the row counter... |
| 652 | - if (!isset($db_row_count[(int) $request])) |
|
| 653 | - $db_row_count[(int) $request] = 0; |
|
| 694 | + if (!isset($db_row_count[(int) $request])) { |
|
| 695 | + $db_row_count[(int) $request] = 0; |
|
| 696 | + } |
|
| 654 | 697 | |
| 655 | 698 | // Return the right row. |
| 656 | 699 | return @pg_fetch_assoc($request, $db_row_count[(int) $request]++); |
@@ -703,11 +746,13 @@ discard block |
||
| 703 | 746 | |
| 704 | 747 | $replace = ''; |
| 705 | 748 | |
| 706 | - if (empty($data)) |
|
| 707 | - return; |
|
| 749 | + if (empty($data)) { |
|
| 750 | + return; |
|
| 751 | + } |
|
| 708 | 752 | |
| 709 | - if (!is_array($data[array_rand($data)])) |
|
| 710 | - $data = array($data); |
|
| 753 | + if (!is_array($data[array_rand($data)])) { |
|
| 754 | + $data = array($data); |
|
| 755 | + } |
|
| 711 | 756 | |
| 712 | 757 | // Replace the prefix holder with the actual prefix. |
| 713 | 758 | $table = str_replace('{db_prefix}', $db_prefix, $table); |
@@ -726,11 +771,13 @@ discard block |
||
| 726 | 771 | //pg 9.5 got replace support |
| 727 | 772 | $pg_version = $smcFunc['db_get_version'](); |
| 728 | 773 | // if we got a Beta Version |
| 729 | - if (stripos($pg_version, 'beta') !== false) |
|
| 730 | - $pg_version = substr($pg_version, 0, stripos($pg_version, 'beta')) . '.0'; |
|
| 774 | + if (stripos($pg_version, 'beta') !== false) { |
|
| 775 | + $pg_version = substr($pg_version, 0, stripos($pg_version, 'beta')) . '.0'; |
|
| 776 | + } |
|
| 731 | 777 | // or RC |
| 732 | - if (stripos($pg_version, 'rc') !== false) |
|
| 733 | - $pg_version = substr($pg_version, 0, stripos($pg_version, 'rc')) . '.0'; |
|
| 778 | + if (stripos($pg_version, 'rc') !== false) { |
|
| 779 | + $pg_version = substr($pg_version, 0, stripos($pg_version, 'rc')) . '.0'; |
|
| 780 | + } |
|
| 734 | 781 | |
| 735 | 782 | $replace_support = (version_compare($pg_version, '9.5.0', '>=') ? true : false); |
| 736 | 783 | } |
@@ -749,32 +796,35 @@ discard block |
||
| 749 | 796 | $key_str .= ($count_pk > 0 ? ',' : ''); |
| 750 | 797 | $key_str .= $columnName; |
| 751 | 798 | $count_pk++; |
| 752 | - } |
|
| 753 | - else if ($method == 'replace') //normal field |
|
| 799 | + } else if ($method == 'replace') { |
|
| 800 | + //normal field |
|
| 754 | 801 | { |
| 755 | 802 | $col_str .= ($count > 0 ? ',' : ''); |
| 803 | + } |
|
| 756 | 804 | $col_str .= $columnName . ' = EXCLUDED.' . $columnName; |
| 757 | 805 | $count++; |
| 758 | 806 | } |
| 759 | 807 | } |
| 760 | - if ($method == 'replace') |
|
| 761 | - $replace = ' ON CONFLICT (' . $key_str . ') DO UPDATE SET ' . $col_str; |
|
| 762 | - else |
|
| 763 | - $replace = ' ON CONFLICT (' . $key_str . ') DO NOTHING'; |
|
| 764 | - } |
|
| 765 | - else if ($method == 'replace') |
|
| 808 | + if ($method == 'replace') { |
|
| 809 | + $replace = ' ON CONFLICT (' . $key_str . ') DO UPDATE SET ' . $col_str; |
|
| 810 | + } else { |
|
| 811 | + $replace = ' ON CONFLICT (' . $key_str . ') DO NOTHING'; |
|
| 812 | + } |
|
| 813 | + } else if ($method == 'replace') |
|
| 766 | 814 | { |
| 767 | 815 | foreach ($columns as $columnName => $type) |
| 768 | 816 | { |
| 769 | 817 | // Are we restricting the length? |
| 770 | - if (strpos($type, 'string-') !== false) |
|
| 771 | - $actualType = sprintf($columnName . ' = SUBSTRING({string:%1$s}, 1, ' . substr($type, 7) . '), ', $count); |
|
| 772 | - else |
|
| 773 | - $actualType = sprintf($columnName . ' = {%1$s:%2$s}, ', $type, $count); |
|
| 818 | + if (strpos($type, 'string-') !== false) { |
|
| 819 | + $actualType = sprintf($columnName . ' = SUBSTRING({string:%1$s}, 1, ' . substr($type, 7) . '), ', $count); |
|
| 820 | + } else { |
|
| 821 | + $actualType = sprintf($columnName . ' = {%1$s:%2$s}, ', $type, $count); |
|
| 822 | + } |
|
| 774 | 823 | |
| 775 | 824 | // A key? That's what we were looking for. |
| 776 | - if (in_array($columnName, $keys)) |
|
| 777 | - $where .= (empty($where) ? '' : ' AND ') . substr($actualType, 0, -2); |
|
| 825 | + if (in_array($columnName, $keys)) { |
|
| 826 | + $where .= (empty($where) ? '' : ' AND ') . substr($actualType, 0, -2); |
|
| 827 | + } |
|
| 778 | 828 | $count++; |
| 779 | 829 | } |
| 780 | 830 | |
@@ -810,10 +860,11 @@ discard block |
||
| 810 | 860 | foreach ($columns as $columnName => $type) |
| 811 | 861 | { |
| 812 | 862 | // Are we restricting the length? |
| 813 | - if (strpos($type, 'string-') !== false) |
|
| 814 | - $insertData .= sprintf('SUBSTRING({string:%1$s}, 1, ' . substr($type, 7) . '), ', $columnName); |
|
| 815 | - else |
|
| 816 | - $insertData .= sprintf('{%1$s:%2$s}, ', $type, $columnName); |
|
| 863 | + if (strpos($type, 'string-') !== false) { |
|
| 864 | + $insertData .= sprintf('SUBSTRING({string:%1$s}, 1, ' . substr($type, 7) . '), ', $columnName); |
|
| 865 | + } else { |
|
| 866 | + $insertData .= sprintf('{%1$s:%2$s}, ', $type, $columnName); |
|
| 867 | + } |
|
| 817 | 868 | } |
| 818 | 869 | $insertData = substr($insertData, 0, -2) . ')'; |
| 819 | 870 | |
@@ -822,8 +873,9 @@ discard block |
||
| 822 | 873 | |
| 823 | 874 | // Here's where the variables are injected to the query. |
| 824 | 875 | $insertRows = array(); |
| 825 | - foreach ($data as $dataRow) |
|
| 826 | - $insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection); |
|
| 876 | + foreach ($data as $dataRow) { |
|
| 877 | + $insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection); |
|
| 878 | + } |
|
| 827 | 879 | |
| 828 | 880 | // Do the insert. |
| 829 | 881 | $request = $smcFunc['db_query']('', ' |
@@ -840,19 +892,21 @@ discard block |
||
| 840 | 892 | |
| 841 | 893 | if ($with_returning && $request !== false) |
| 842 | 894 | { |
| 843 | - if ($returnmode === 2) |
|
| 844 | - $return_var = array(); |
|
| 895 | + if ($returnmode === 2) { |
|
| 896 | + $return_var = array(); |
|
| 897 | + } |
|
| 845 | 898 | |
| 846 | 899 | while(($row = $smcFunc['db_fetch_row']($request)) && $with_returning) |
| 847 | 900 | { |
| 848 | - if (is_numeric($row[0])) // try to emulate mysql limitation |
|
| 901 | + if (is_numeric($row[0])) { |
|
| 902 | + // try to emulate mysql limitation |
|
| 849 | 903 | { |
| 850 | 904 | if ($returnmode === 1) |
| 851 | 905 | $return_var = $row[0]; |
| 852 | - elseif ($returnmode === 2) |
|
| 853 | - $return_var[] = $row[0]; |
|
| 854 | - } |
|
| 855 | - else |
|
| 906 | + } elseif ($returnmode === 2) { |
|
| 907 | + $return_var[] = $row[0]; |
|
| 908 | + } |
|
| 909 | + } else |
|
| 856 | 910 | { |
| 857 | 911 | $with_returning = false; |
| 858 | 912 | trigger_error('trying to returning ID Field which is not a Int field', E_USER_ERROR); |
@@ -861,9 +915,10 @@ discard block |
||
| 861 | 915 | } |
| 862 | 916 | } |
| 863 | 917 | |
| 864 | - if ($with_returning && !empty($return_var)) |
|
| 865 | - return $return_var; |
|
| 866 | -} |
|
| 918 | + if ($with_returning && !empty($return_var)) { |
|
| 919 | + return $return_var; |
|
| 920 | + } |
|
| 921 | + } |
|
| 867 | 922 | |
| 868 | 923 | /** |
| 869 | 924 | * Dummy function really. Doesn't do anything on PostgreSQL. |
@@ -900,8 +955,9 @@ discard block |
||
| 900 | 955 | */ |
| 901 | 956 | function smf_db_error_backtrace($error_message, $log_message = '', $error_type = false, $file = null, $line = null) |
| 902 | 957 | { |
| 903 | - if (empty($log_message)) |
|
| 904 | - $log_message = $error_message; |
|
| 958 | + if (empty($log_message)) { |
|
| 959 | + $log_message = $error_message; |
|
| 960 | + } |
|
| 905 | 961 | |
| 906 | 962 | foreach (debug_backtrace() as $step) |
| 907 | 963 | { |
@@ -920,12 +976,14 @@ discard block |
||
| 920 | 976 | } |
| 921 | 977 | |
| 922 | 978 | // A special case - we want the file and line numbers for debugging. |
| 923 | - if ($error_type == 'return') |
|
| 924 | - return array($file, $line); |
|
| 979 | + if ($error_type == 'return') { |
|
| 980 | + return array($file, $line); |
|
| 981 | + } |
|
| 925 | 982 | |
| 926 | 983 | // Is always a critical error. |
| 927 | - if (function_exists('log_error')) |
|
| 928 | - log_error($log_message, 'critical', $file, $line); |
|
| 984 | + if (function_exists('log_error')) { |
|
| 985 | + log_error($log_message, 'critical', $file, $line); |
|
| 986 | + } |
|
| 929 | 987 | |
| 930 | 988 | if (function_exists('fatal_error')) |
| 931 | 989 | { |
@@ -933,12 +991,12 @@ discard block |
||
| 933 | 991 | |
| 934 | 992 | // Cannot continue... |
| 935 | 993 | exit; |
| 994 | + } elseif ($error_type) { |
|
| 995 | + trigger_error($error_message . ($line !== null ? '<em>(' . basename($file) . '-' . $line . ')</em>' : ''), $error_type); |
|
| 996 | + } else { |
|
| 997 | + trigger_error($error_message . ($line !== null ? '<em>(' . basename($file) . '-' . $line . ')</em>' : '')); |
|
| 998 | + } |
|
| 936 | 999 | } |
| 937 | - elseif ($error_type) |
|
| 938 | - trigger_error($error_message . ($line !== null ? '<em>(' . basename($file) . '-' . $line . ')</em>' : ''), $error_type); |
|
| 939 | - else |
|
| 940 | - trigger_error($error_message . ($line !== null ? '<em>(' . basename($file) . '-' . $line . ')</em>' : '')); |
|
| 941 | -} |
|
| 942 | 1000 | |
| 943 | 1001 | /** |
| 944 | 1002 | * Escape the LIKE wildcards so that they match the character and not the wildcard. |
@@ -955,10 +1013,11 @@ discard block |
||
| 955 | 1013 | '\\' => '\\\\', |
| 956 | 1014 | ); |
| 957 | 1015 | |
| 958 | - if ($translate_human_wildcards) |
|
| 959 | - $replacements += array( |
|
| 1016 | + if ($translate_human_wildcards) { |
|
| 1017 | + $replacements += array( |
|
| 960 | 1018 | '*' => '%', |
| 961 | 1019 | ); |
| 1020 | + } |
|
| 962 | 1021 | |
| 963 | 1022 | return strtr($string, $replacements); |
| 964 | 1023 | } |
@@ -986,11 +1045,12 @@ discard block |
||
| 986 | 1045 | global $db_prefix, $db_connection; |
| 987 | 1046 | static $pg_error_data_prep; |
| 988 | 1047 | |
| 989 | - if (empty($pg_error_data_prep)) |
|
| 990 | - $pg_error_data_prep = pg_prepare($db_connection, 'smf_log_errors', |
|
| 1048 | + if (empty($pg_error_data_prep)) { |
|
| 1049 | + $pg_error_data_prep = pg_prepare($db_connection, 'smf_log_errors', |
|
| 991 | 1050 | 'INSERT INTO ' . $db_prefix . 'log_errors(id_member, log_time, ip, url, message, session, error_type, file, line) |
| 992 | 1051 | VALUES( $1, $2, $3, $4, $5, $6, $7, $8, $9)' |
| 993 | 1052 | ); |
| 1053 | + } |
|
| 994 | 1054 | |
| 995 | 1055 | pg_execute($db_connection, 'smf_log_errors', $error_array); |
| 996 | 1056 | } |
@@ -11,8 +11,9 @@ discard block |
||
| 11 | 11 | * @version 2.1 Beta 4 |
| 12 | 12 | */ |
| 13 | 13 | |
| 14 | -if (!defined('SMF')) |
|
| 14 | +if (!defined('SMF')) { |
|
| 15 | 15 | die('Hacking attempt...'); |
| 16 | +} |
|
| 16 | 17 | |
| 17 | 18 | /** |
| 18 | 19 | * Our Cache API class |
@@ -27,8 +28,9 @@ discard block |
||
| 27 | 28 | { |
| 28 | 29 | $supported = function_exists('zend_shm_cache_fetch') || function_exists('output_cache_get'); |
| 29 | 30 | |
| 30 | - if ($test) |
|
| 31 | - return $supported; |
|
| 31 | + if ($test) { |
|
| 32 | + return $supported; |
|
| 33 | + } |
|
| 32 | 34 | return parent::isSupported() && $supported; |
| 33 | 35 | } |
| 34 | 36 | |
@@ -40,10 +42,11 @@ discard block |
||
| 40 | 42 | $key = $this->prefix . strtr($key, ':/', '-_'); |
| 41 | 43 | |
| 42 | 44 | // Zend's pricey stuff. |
| 43 | - if (function_exists('zend_shm_cache_fetch')) |
|
| 44 | - return zend_shm_cache_fetch('SMF::' . $key); |
|
| 45 | - elseif (function_exists('output_cache_get')) |
|
| 46 | - return output_cache_get($key, $ttl); |
|
| 45 | + if (function_exists('zend_shm_cache_fetch')) { |
|
| 46 | + return zend_shm_cache_fetch('SMF::' . $key); |
|
| 47 | + } elseif (function_exists('output_cache_get')) { |
|
| 48 | + return output_cache_get($key, $ttl); |
|
| 49 | + } |
|
| 47 | 50 | } |
| 48 | 51 | |
| 49 | 52 | /** |
@@ -53,10 +56,11 @@ discard block |
||
| 53 | 56 | { |
| 54 | 57 | $key = $this->prefix . strtr($key, ':/', '-_'); |
| 55 | 58 | |
| 56 | - if (function_exists('zend_shm_cache_store')) |
|
| 57 | - return zend_shm_cache_store('SMF::' . $key, $value, $ttl); |
|
| 58 | - elseif (function_exists('output_cache_put')) |
|
| 59 | - return output_cache_put($key, $value); |
|
| 59 | + if (function_exists('zend_shm_cache_store')) { |
|
| 60 | + return zend_shm_cache_store('SMF::' . $key, $value, $ttl); |
|
| 61 | + } elseif (function_exists('output_cache_put')) { |
|
| 62 | + return output_cache_put($key, $value); |
|
| 63 | + } |
|
| 60 | 64 | } |
| 61 | 65 | |
| 62 | 66 | /** |
@@ -11,8 +11,9 @@ discard block |
||
| 11 | 11 | * @version 2.1 Beta 4 |
| 12 | 12 | */ |
| 13 | 13 | |
| 14 | -if (!defined('SMF')) |
|
| 14 | +if (!defined('SMF')) { |
|
| 15 | 15 | die('Hacking attempt...'); |
| 16 | +} |
|
| 16 | 17 | |
| 17 | 18 | /** |
| 18 | 19 | * Our Cache API class |
@@ -27,8 +28,9 @@ discard block |
||
| 27 | 28 | { |
| 28 | 29 | $supported = function_exists('apc_fetch') && function_exists('apc_store'); |
| 29 | 30 | |
| 30 | - if ($test) |
|
| 31 | - return $supported; |
|
| 31 | + if ($test) { |
|
| 32 | + return $supported; |
|
| 33 | + } |
|
| 32 | 34 | return parent::isSupported() && $supported; |
| 33 | 35 | } |
| 34 | 36 | |
@@ -50,10 +52,11 @@ discard block |
||
| 50 | 52 | $key = $this->prefix . strtr($key, ':/', '-_'); |
| 51 | 53 | |
| 52 | 54 | // An extended key is needed to counteract a bug in APC. |
| 53 | - if ($value === null) |
|
| 54 | - return apc_delete($key . 'smf'); |
|
| 55 | - else |
|
| 56 | - return apc_store($key . 'smf', $value, $ttl); |
|
| 55 | + if ($value === null) { |
|
| 56 | + return apc_delete($key . 'smf'); |
|
| 57 | + } else { |
|
| 58 | + return apc_store($key . 'smf', $value, $ttl); |
|
| 59 | + } |
|
| 57 | 60 | } |
| 58 | 61 | |
| 59 | 62 | /** |
@@ -67,9 +70,9 @@ discard block |
||
| 67 | 70 | // Always returns true. |
| 68 | 71 | apc_clear_cache('user'); |
| 69 | 72 | apc_clear_cache('system'); |
| 73 | + } elseif ($type === 'user') { |
|
| 74 | + apc_clear_cache('user'); |
|
| 70 | 75 | } |
| 71 | - elseif ($type === 'user') |
|
| 72 | - apc_clear_cache('user'); |
|
| 73 | 76 | |
| 74 | 77 | $this->invalidateCache(); |
| 75 | 78 | return true; |
@@ -13,8 +13,9 @@ discard block |
||
| 13 | 13 | * @version 2.1 Beta 4 |
| 14 | 14 | */ |
| 15 | 15 | |
| 16 | -if (!defined('SMF')) |
|
| 16 | +if (!defined('SMF')) { |
|
| 17 | 17 | die('No direct access...'); |
| 18 | +} |
|
| 18 | 19 | |
| 19 | 20 | /** |
| 20 | 21 | * This is a handling function for all things post moderation. |
@@ -39,8 +40,9 @@ discard block |
||
| 39 | 40 | ); |
| 40 | 41 | |
| 41 | 42 | // Pick something valid... |
| 42 | - if (!isset($_REQUEST['sa']) || !isset($subActions[$_REQUEST['sa']])) |
|
| 43 | - $_REQUEST['sa'] = 'replies'; |
|
| 43 | + if (!isset($_REQUEST['sa']) || !isset($subActions[$_REQUEST['sa']])) { |
|
| 44 | + $_REQUEST['sa'] = 'replies'; |
|
| 45 | + } |
|
| 44 | 46 | |
| 45 | 47 | call_integration_hook('integrate_post_moderation', array(&$subActions)); |
| 46 | 48 | |
@@ -68,13 +70,15 @@ discard block |
||
| 68 | 70 | $approve_boards = $approve_boards == array(0) ? $filter_board : array_intersect($approve_boards, $filter_board); |
| 69 | 71 | } |
| 70 | 72 | |
| 71 | - if ($approve_boards == array(0)) |
|
| 72 | - $approve_query = ''; |
|
| 73 | - elseif (!empty($approve_boards)) |
|
| 74 | - $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')'; |
|
| 73 | + if ($approve_boards == array(0)) { |
|
| 74 | + $approve_query = ''; |
|
| 75 | + } elseif (!empty($approve_boards)) { |
|
| 76 | + $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')'; |
|
| 77 | + } |
|
| 75 | 78 | // Nada, zip, etc... |
| 76 | - else |
|
| 77 | - $approve_query = ' AND 1=0'; |
|
| 79 | + else { |
|
| 80 | + $approve_query = ' AND 1=0'; |
|
| 81 | + } |
|
| 78 | 82 | |
| 79 | 83 | // We also need to know where we can delete topics and/or replies to. |
| 80 | 84 | if ($context['current_view'] == 'topics') |
@@ -82,8 +86,7 @@ discard block |
||
| 82 | 86 | $delete_own_boards = boardsAllowedTo('remove_own'); |
| 83 | 87 | $delete_any_boards = boardsAllowedTo('remove_any'); |
| 84 | 88 | $delete_own_replies = array(); |
| 85 | - } |
|
| 86 | - else |
|
| 89 | + } else |
|
| 87 | 90 | { |
| 88 | 91 | $delete_own_boards = boardsAllowedTo('delete_own'); |
| 89 | 92 | $delete_any_boards = boardsAllowedTo('delete_any'); |
@@ -92,21 +95,25 @@ discard block |
||
| 92 | 95 | |
| 93 | 96 | $toAction = array(); |
| 94 | 97 | // Check if we have something to do? |
| 95 | - if (isset($_GET['approve'])) |
|
| 96 | - $toAction[] = (int) $_GET['approve']; |
|
| 98 | + if (isset($_GET['approve'])) { |
|
| 99 | + $toAction[] = (int) $_GET['approve']; |
|
| 100 | + } |
|
| 97 | 101 | // Just a deletion? |
| 98 | - elseif (isset($_GET['delete'])) |
|
| 99 | - $toAction[] = (int) $_GET['delete']; |
|
| 102 | + elseif (isset($_GET['delete'])) { |
|
| 103 | + $toAction[] = (int) $_GET['delete']; |
|
| 104 | + } |
|
| 100 | 105 | // Lots of approvals? |
| 101 | - elseif (isset($_POST['item'])) |
|
| 102 | - foreach ($_POST['item'] as $item) |
|
| 106 | + elseif (isset($_POST['item'])) { |
|
| 107 | + foreach ($_POST['item'] as $item) |
|
| 103 | 108 | $toAction[] = (int) $item; |
| 109 | + } |
|
| 104 | 110 | |
| 105 | 111 | // What are we actually doing. |
| 106 | - if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve')) |
|
| 107 | - $curAction = 'approve'; |
|
| 108 | - elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete')) |
|
| 109 | - $curAction = 'delete'; |
|
| 112 | + if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve')) { |
|
| 113 | + $curAction = 'approve'; |
|
| 114 | + } elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete')) { |
|
| 115 | + $curAction = 'delete'; |
|
| 116 | + } |
|
| 110 | 117 | |
| 111 | 118 | // Right, so we have something to do? |
| 112 | 119 | if (!empty($toAction) && isset($curAction)) |
@@ -135,8 +142,9 @@ discard block |
||
| 135 | 142 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
| 136 | 143 | { |
| 137 | 144 | // If it's not within what our view is ignore it... |
| 138 | - if (($row['id_msg'] == $row['id_first_msg'] && $context['current_view'] != 'topics') || ($row['id_msg'] != $row['id_first_msg'] && $context['current_view'] != 'replies')) |
|
| 139 | - continue; |
|
| 145 | + if (($row['id_msg'] == $row['id_first_msg'] && $context['current_view'] != 'topics') || ($row['id_msg'] != $row['id_first_msg'] && $context['current_view'] != 'replies')) { |
|
| 146 | + continue; |
|
| 147 | + } |
|
| 140 | 148 | |
| 141 | 149 | $can_add = false; |
| 142 | 150 | // If we're approving this is simple. |
@@ -148,18 +156,22 @@ discard block |
||
| 148 | 156 | elseif ($curAction == 'delete') |
| 149 | 157 | { |
| 150 | 158 | // Own post is easy! |
| 151 | - if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards))) |
|
| 152 | - $can_add = true; |
|
| 159 | + if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards))) { |
|
| 160 | + $can_add = true; |
|
| 161 | + } |
|
| 153 | 162 | // Is it a reply to their own topic? |
| 154 | - elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies))) |
|
| 155 | - $can_add = true; |
|
| 163 | + elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies))) { |
|
| 164 | + $can_add = true; |
|
| 165 | + } |
|
| 156 | 166 | // Someone elses? |
| 157 | - elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards))) |
|
| 158 | - $can_add = true; |
|
| 167 | + elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards))) { |
|
| 168 | + $can_add = true; |
|
| 169 | + } |
|
| 159 | 170 | } |
| 160 | 171 | |
| 161 | - if ($can_add) |
|
| 162 | - $anItem = $context['current_view'] == 'topics' ? $row['id_topic'] : $row['id_msg']; |
|
| 172 | + if ($can_add) { |
|
| 173 | + $anItem = $context['current_view'] == 'topics' ? $row['id_topic'] : $row['id_msg']; |
|
| 174 | + } |
|
| 163 | 175 | $toAction[] = $anItem; |
| 164 | 176 | |
| 165 | 177 | // All clear. What have we got now, what, what? |
@@ -177,8 +189,7 @@ discard block |
||
| 177 | 189 | if ($curAction == 'approve') |
| 178 | 190 | { |
| 179 | 191 | approveMessages($toAction, $details, $context['current_view']); |
| 180 | - } |
|
| 181 | - else |
|
| 192 | + } else |
|
| 182 | 193 | { |
| 183 | 194 | removeMessages($toAction, $details, $context['current_view']); |
| 184 | 195 | } |
@@ -265,16 +276,19 @@ discard block |
||
| 265 | 276 | for ($i = 1; $row = $smcFunc['db_fetch_assoc']($request); $i++) |
| 266 | 277 | { |
| 267 | 278 | // Can delete is complicated, let's solve it first... is it their own post? |
| 268 | - if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards))) |
|
| 269 | - $can_delete = true; |
|
| 279 | + if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards))) { |
|
| 280 | + $can_delete = true; |
|
| 281 | + } |
|
| 270 | 282 | // Is it a reply to their own topic? |
| 271 | - elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies))) |
|
| 272 | - $can_delete = true; |
|
| 283 | + elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies))) { |
|
| 284 | + $can_delete = true; |
|
| 285 | + } |
|
| 273 | 286 | // Someone elses? |
| 274 | - elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards))) |
|
| 275 | - $can_delete = true; |
|
| 276 | - else |
|
| 277 | - $can_delete = false; |
|
| 287 | + elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards))) { |
|
| 288 | + $can_delete = true; |
|
| 289 | + } else { |
|
| 290 | + $can_delete = false; |
|
| 291 | + } |
|
| 278 | 292 | |
| 279 | 293 | $context['unapproved_items'][] = array( |
| 280 | 294 | 'id' => $row['id_msg'], |
@@ -323,28 +337,31 @@ discard block |
||
| 323 | 337 | // Once again, permissions are king! |
| 324 | 338 | $approve_boards = boardsAllowedTo('approve_posts'); |
| 325 | 339 | |
| 326 | - if ($approve_boards == array(0)) |
|
| 327 | - $approve_query = ''; |
|
| 328 | - elseif (!empty($approve_boards)) |
|
| 329 | - $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')'; |
|
| 330 | - else |
|
| 331 | - $approve_query = ' AND 1=0'; |
|
| 340 | + if ($approve_boards == array(0)) { |
|
| 341 | + $approve_query = ''; |
|
| 342 | + } elseif (!empty($approve_boards)) { |
|
| 343 | + $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')'; |
|
| 344 | + } else { |
|
| 345 | + $approve_query = ' AND 1=0'; |
|
| 346 | + } |
|
| 332 | 347 | |
| 333 | 348 | // Get together the array of things to act on, if any. |
| 334 | 349 | $attachments = array(); |
| 335 | - if (isset($_GET['approve'])) |
|
| 336 | - $attachments[] = (int) $_GET['approve']; |
|
| 337 | - elseif (isset($_GET['delete'])) |
|
| 338 | - $attachments[] = (int) $_GET['delete']; |
|
| 339 | - elseif (isset($_POST['item'])) |
|
| 340 | - foreach ($_POST['item'] as $item) |
|
| 350 | + if (isset($_GET['approve'])) { |
|
| 351 | + $attachments[] = (int) $_GET['approve']; |
|
| 352 | + } elseif (isset($_GET['delete'])) { |
|
| 353 | + $attachments[] = (int) $_GET['delete']; |
|
| 354 | + } elseif (isset($_POST['item'])) { |
|
| 355 | + foreach ($_POST['item'] as $item) |
|
| 341 | 356 | $attachments[] = (int) $item; |
| 357 | + } |
|
| 342 | 358 | |
| 343 | 359 | // Are we approving or deleting? |
| 344 | - if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve')) |
|
| 345 | - $curAction = 'approve'; |
|
| 346 | - elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete')) |
|
| 347 | - $curAction = 'delete'; |
|
| 360 | + if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve')) { |
|
| 361 | + $curAction = 'approve'; |
|
| 362 | + } elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete')) { |
|
| 363 | + $curAction = 'delete'; |
|
| 364 | + } |
|
| 348 | 365 | |
| 349 | 366 | // Something to do, let's do it! |
| 350 | 367 | if (!empty($attachments) && isset($curAction)) |
@@ -372,17 +389,19 @@ discard block |
||
| 372 | 389 | ) |
| 373 | 390 | ); |
| 374 | 391 | $attachments = array(); |
| 375 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 376 | - $attachments[] = $row['id_attach']; |
|
| 392 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
| 393 | + $attachments[] = $row['id_attach']; |
|
| 394 | + } |
|
| 377 | 395 | $smcFunc['db_free_result']($request); |
| 378 | 396 | |
| 379 | 397 | // Assuming it wasn't all like, proper illegal, we can do the approving. |
| 380 | 398 | if (!empty($attachments)) |
| 381 | 399 | { |
| 382 | - if ($curAction == 'approve') |
|
| 383 | - ApproveAttachments($attachments); |
|
| 384 | - else |
|
| 385 | - removeAttachments(array('id_attach' => $attachments, 'do_logging' => true)); |
|
| 400 | + if ($curAction == 'approve') { |
|
| 401 | + ApproveAttachments($attachments); |
|
| 402 | + } else { |
|
| 403 | + removeAttachments(array('id_attach' => $attachments, 'do_logging' => true)); |
|
| 404 | + } |
|
| 386 | 405 | } |
| 387 | 406 | } |
| 388 | 407 | |
@@ -682,15 +701,16 @@ discard block |
||
| 682 | 701 | { |
| 683 | 702 | approveTopics($topic, !$approved); |
| 684 | 703 | |
| 685 | - if ($starter != $user_info['id']) |
|
| 686 | - logAction(($approved ? 'un' : '') . 'approve_topic', array('topic' => $topic, 'subject' => $subject, 'member' => $starter, 'board' => $board)); |
|
| 687 | - } |
|
| 688 | - else |
|
| 704 | + if ($starter != $user_info['id']) { |
|
| 705 | + logAction(($approved ? 'un' : '') . 'approve_topic', array('topic' => $topic, 'subject' => $subject, 'member' => $starter, 'board' => $board)); |
|
| 706 | + } |
|
| 707 | + } else |
|
| 689 | 708 | { |
| 690 | 709 | approvePosts($_REQUEST['msg'], !$approved); |
| 691 | 710 | |
| 692 | - if ($poster != $user_info['id']) |
|
| 693 | - logAction(($approved ? 'un' : '') . 'approve', array('topic' => $topic, 'subject' => $subject, 'member' => $poster, 'board' => $board)); |
|
| 711 | + if ($poster != $user_info['id']) { |
|
| 712 | + logAction(($approved ? 'un' : '') . 'approve', array('topic' => $topic, 'subject' => $subject, 'member' => $poster, 'board' => $board)); |
|
| 713 | + } |
|
| 694 | 714 | } |
| 695 | 715 | |
| 696 | 716 | redirectexit('topic=' . $topic . '.msg' . $_REQUEST['msg'] . '#msg' . $_REQUEST['msg']); |
@@ -716,8 +736,7 @@ discard block |
||
| 716 | 736 | { |
| 717 | 737 | logAction('approve_topic', array('topic' => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board'])); |
| 718 | 738 | } |
| 719 | - } |
|
| 720 | - else |
|
| 739 | + } else |
|
| 721 | 740 | { |
| 722 | 741 | approvePosts($messages); |
| 723 | 742 | // and tell the world about it again |
@@ -745,8 +764,9 @@ discard block |
||
| 745 | 764 | ) |
| 746 | 765 | ); |
| 747 | 766 | $msgs = array(); |
| 748 | - while ($row = $smcFunc['db_fetch_row']($request)) |
|
| 749 | - $msgs[] = $row[0]; |
|
| 767 | + while ($row = $smcFunc['db_fetch_row']($request)) { |
|
| 768 | + $msgs[] = $row[0]; |
|
| 769 | + } |
|
| 750 | 770 | $smcFunc['db_free_result']($request); |
| 751 | 771 | |
| 752 | 772 | if (!empty($msgs)) |
@@ -765,8 +785,9 @@ discard block |
||
| 765 | 785 | ) |
| 766 | 786 | ); |
| 767 | 787 | $attaches = array(); |
| 768 | - while ($row = $smcFunc['db_fetch_row']($request)) |
|
| 769 | - $attaches[] = $row[0]; |
|
| 788 | + while ($row = $smcFunc['db_fetch_row']($request)) { |
|
| 789 | + $attaches[] = $row[0]; |
|
| 790 | + } |
|
| 770 | 791 | $smcFunc['db_free_result']($request); |
| 771 | 792 | |
| 772 | 793 | if (!empty($attaches)) |
@@ -794,12 +815,12 @@ discard block |
||
| 794 | 815 | { |
| 795 | 816 | removeTopics($messages); |
| 796 | 817 | // and tell the world about it |
| 797 | - foreach ($messages as $topic) |
|
| 798 | - // Note, only log topic ID in native form if it's not gone forever. |
|
| 818 | + foreach ($messages as $topic) { |
|
| 819 | + // Note, only log topic ID in native form if it's not gone forever. |
|
| 799 | 820 | logAction('remove', array( |
| 800 | 821 | (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $messageDetails[$topic]['board'] ? 'topic' : 'old_topic_id') => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board'])); |
| 801 | - } |
|
| 802 | - else |
|
| 822 | + } |
|
| 823 | + } else |
|
| 803 | 824 | { |
| 804 | 825 | foreach ($messages as $post) |
| 805 | 826 | { |
@@ -14,8 +14,9 @@ discard block |
||
| 14 | 14 | * @version 2.1 Beta 4 |
| 15 | 15 | */ |
| 16 | 16 | |
| 17 | -if (!defined('SMF')) |
|
| 17 | +if (!defined('SMF')) { |
|
| 18 | 18 | die('No direct access...'); |
| 19 | +} |
|
| 19 | 20 | |
| 20 | 21 | /** |
| 21 | 22 | * This function shows the board index. |
@@ -34,8 +35,9 @@ discard block |
||
| 34 | 35 | $context['canonical_url'] = $scripturl; |
| 35 | 36 | |
| 36 | 37 | // Do not let search engines index anything if there is a random thing in $_GET. |
| 37 | - if (!empty($_GET)) |
|
| 38 | - $context['robot_no_index'] = true; |
|
| 38 | + if (!empty($_GET)) { |
|
| 39 | + $context['robot_no_index'] = true; |
|
| 40 | + } |
|
| 39 | 41 | |
| 40 | 42 | // Retrieve the categories and boards. |
| 41 | 43 | require_once($sourcedir . '/Subs-BoardIndex.php'); |
@@ -62,11 +64,12 @@ discard block |
||
| 62 | 64 | $context['latest_posts'] = cache_quick_get('boardindex-latest_posts:' . md5($user_info['query_wanna_see_board'] . $user_info['language']), 'Subs-Recent.php', 'cache_getLastPosts', array($latestPostOptions)); |
| 63 | 65 | } |
| 64 | 66 | |
| 65 | - if (!empty($context['latest_posts']) || !empty($context['latest_post'])) |
|
| 66 | - $context['info_center'][] = array( |
|
| 67 | + if (!empty($context['latest_posts']) || !empty($context['latest_post'])) { |
|
| 68 | + $context['info_center'][] = array( |
|
| 67 | 69 | 'tpl' => 'recent', |
| 68 | 70 | 'txt' => 'recent_posts', |
| 69 | 71 | ); |
| 72 | + } |
|
| 70 | 73 | } |
| 71 | 74 | |
| 72 | 75 | // Load the calendar? |
@@ -87,20 +90,22 @@ discard block |
||
| 87 | 90 | // This is used to show the "how-do-I-edit" help. |
| 88 | 91 | $context['calendar_can_edit'] = allowedTo('calendar_edit_any'); |
| 89 | 92 | |
| 90 | - if ($context['show_calendar']) |
|
| 91 | - $context['info_center'][] = array( |
|
| 93 | + if ($context['show_calendar']) { |
|
| 94 | + $context['info_center'][] = array( |
|
| 92 | 95 | 'tpl' => 'calendar', |
| 93 | 96 | 'txt' => $context['calendar_only_today'] ? 'calendar_today' : 'calendar_upcoming', |
| 94 | 97 | ); |
| 98 | + } |
|
| 95 | 99 | } |
| 96 | 100 | |
| 97 | 101 | // And stats. |
| 98 | 102 | $context['show_stats'] = allowedTo('view_stats') && !empty($modSettings['trackStats']); |
| 99 | - if ($settings['show_stats_index']) |
|
| 100 | - $context['info_center'][] = array( |
|
| 103 | + if ($settings['show_stats_index']) { |
|
| 104 | + $context['info_center'][] = array( |
|
| 101 | 105 | 'tpl' => 'stats', |
| 102 | 106 | 'txt' => 'forum_stats', |
| 103 | 107 | ); |
| 108 | + } |
|
| 104 | 109 | |
| 105 | 110 | // Now the online stuff |
| 106 | 111 | require_once($sourcedir . '/Subs-MembersOnline.php'); |
@@ -118,12 +123,14 @@ discard block |
||
| 118 | 123 | ); |
| 119 | 124 | |
| 120 | 125 | // Track most online statistics? (Subs-MembersOnline.php) |
| 121 | - if (!empty($modSettings['trackStats'])) |
|
| 122 | - trackStatsUsersOnline($context['num_guests'] + $context['num_spiders'] + $context['num_users_online']); |
|
| 126 | + if (!empty($modSettings['trackStats'])) { |
|
| 127 | + trackStatsUsersOnline($context['num_guests'] + $context['num_spiders'] + $context['num_users_online']); |
|
| 128 | + } |
|
| 123 | 129 | |
| 124 | 130 | // Are we showing all membergroups on the board index? |
| 125 | - if (!empty($settings['show_group_key'])) |
|
| 126 | - $context['membergroups'] = cache_quick_get('membergroup_list', 'Subs-Membergroups.php', 'cache_getMembergroupList', array()); |
|
| 131 | + if (!empty($settings['show_group_key'])) { |
|
| 132 | + $context['membergroups'] = cache_quick_get('membergroup_list', 'Subs-Membergroups.php', 'cache_getMembergroupList', array()); |
|
| 133 | + } |
|
| 127 | 134 | |
| 128 | 135 | // And back to normality. |
| 129 | 136 | $context['page_title'] = sprintf($txt['forum_index'], $context['forum_name']); |
@@ -14,8 +14,9 @@ discard block |
||
| 14 | 14 | * @version 2.1 Beta 4 |
| 15 | 15 | */ |
| 16 | 16 | |
| 17 | -if (!defined('SMF')) |
|
| 17 | +if (!defined('SMF')) { |
|
| 18 | 18 | die('No direct access...'); |
| 19 | +} |
|
| 19 | 20 | |
| 20 | 21 | /** |
| 21 | 22 | * Mark a board or multiple boards read. |
@@ -28,14 +29,16 @@ discard block |
||
| 28 | 29 | global $user_info, $modSettings, $smcFunc; |
| 29 | 30 | |
| 30 | 31 | // Force $boards to be an array. |
| 31 | - if (!is_array($boards)) |
|
| 32 | - $boards = array($boards); |
|
| 33 | - else |
|
| 34 | - $boards = array_unique($boards); |
|
| 32 | + if (!is_array($boards)) { |
|
| 33 | + $boards = array($boards); |
|
| 34 | + } else { |
|
| 35 | + $boards = array_unique($boards); |
|
| 36 | + } |
|
| 35 | 37 | |
| 36 | 38 | // No boards, nothing to mark as read. |
| 37 | - if (empty($boards)) |
|
| 38 | - return; |
|
| 39 | + if (empty($boards)) { |
|
| 40 | + return; |
|
| 41 | + } |
|
| 39 | 42 | |
| 40 | 43 | // Allow the user to mark a board as unread. |
| 41 | 44 | if ($unread) |
@@ -65,8 +68,9 @@ discard block |
||
| 65 | 68 | else |
| 66 | 69 | { |
| 67 | 70 | $markRead = array(); |
| 68 | - foreach ($boards as $board) |
|
| 69 | - $markRead[] = array($modSettings['maxMsgID'], $user_info['id'], $board); |
|
| 71 | + foreach ($boards as $board) { |
|
| 72 | + $markRead[] = array($modSettings['maxMsgID'], $user_info['id'], $board); |
|
| 73 | + } |
|
| 70 | 74 | |
| 71 | 75 | // Update log_mark_read and log_boards. |
| 72 | 76 | $smcFunc['db_insert']('replace', |
@@ -99,8 +103,9 @@ discard block |
||
| 99 | 103 | list ($lowest_topic) = $smcFunc['db_fetch_row']($result); |
| 100 | 104 | $smcFunc['db_free_result']($result); |
| 101 | 105 | |
| 102 | - if (empty($lowest_topic)) |
|
| 103 | - return; |
|
| 106 | + if (empty($lowest_topic)) { |
|
| 107 | + return; |
|
| 108 | + } |
|
| 104 | 109 | |
| 105 | 110 | // @todo SLOW This query seems to eat it sometimes. |
| 106 | 111 | $result = $smcFunc['db_query']('', ' |
@@ -118,12 +123,13 @@ discard block |
||
| 118 | 123 | ) |
| 119 | 124 | ); |
| 120 | 125 | $topics = array(); |
| 121 | - while ($row = $smcFunc['db_fetch_assoc']($result)) |
|
| 122 | - $topics[] = $row['id_topic']; |
|
| 126 | + while ($row = $smcFunc['db_fetch_assoc']($result)) { |
|
| 127 | + $topics[] = $row['id_topic']; |
|
| 128 | + } |
|
| 123 | 129 | $smcFunc['db_free_result']($result); |
| 124 | 130 | |
| 125 | - if (!empty($topics)) |
|
| 126 | - $smcFunc['db_query']('', ' |
|
| 131 | + if (!empty($topics)) { |
|
| 132 | + $smcFunc['db_query']('', ' |
|
| 127 | 133 | DELETE FROM {db_prefix}log_topics |
| 128 | 134 | WHERE id_member = {int:current_member} |
| 129 | 135 | AND id_topic IN ({array_int:topic_list})', |
@@ -132,7 +138,8 @@ discard block |
||
| 132 | 138 | 'topic_list' => $topics, |
| 133 | 139 | ) |
| 134 | 140 | ); |
| 135 | -} |
|
| 141 | + } |
|
| 142 | + } |
|
| 136 | 143 | |
| 137 | 144 | /** |
| 138 | 145 | * Mark one or more boards as read. |
@@ -157,23 +164,26 @@ discard block |
||
| 157 | 164 | ) |
| 158 | 165 | ); |
| 159 | 166 | $boards = array(); |
| 160 | - while ($row = $smcFunc['db_fetch_assoc']($result)) |
|
| 161 | - $boards[] = $row['id_board']; |
|
| 167 | + while ($row = $smcFunc['db_fetch_assoc']($result)) { |
|
| 168 | + $boards[] = $row['id_board']; |
|
| 169 | + } |
|
| 162 | 170 | $smcFunc['db_free_result']($result); |
| 163 | 171 | |
| 164 | - if (!empty($boards)) |
|
| 165 | - markBoardsRead($boards, isset($_REQUEST['unread'])); |
|
| 172 | + if (!empty($boards)) { |
|
| 173 | + markBoardsRead($boards, isset($_REQUEST['unread'])); |
|
| 174 | + } |
|
| 166 | 175 | |
| 167 | 176 | $_SESSION['id_msg_last_visit'] = $modSettings['maxMsgID']; |
| 168 | - if (!empty($_SESSION['old_url']) && strpos($_SESSION['old_url'], 'action=unread') !== false) |
|
| 169 | - redirectexit('action=unread'); |
|
| 177 | + if (!empty($_SESSION['old_url']) && strpos($_SESSION['old_url'], 'action=unread') !== false) { |
|
| 178 | + redirectexit('action=unread'); |
|
| 179 | + } |
|
| 170 | 180 | |
| 171 | - if (isset($_SESSION['topicseen_cache'])) |
|
| 172 | - $_SESSION['topicseen_cache'] = array(); |
|
| 181 | + if (isset($_SESSION['topicseen_cache'])) { |
|
| 182 | + $_SESSION['topicseen_cache'] = array(); |
|
| 183 | + } |
|
| 173 | 184 | |
| 174 | 185 | redirectexit(); |
| 175 | - } |
|
| 176 | - elseif (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'unreadreplies') |
|
| 186 | + } elseif (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'unreadreplies') |
|
| 177 | 187 | { |
| 178 | 188 | // Make sure all the topics are integers! |
| 179 | 189 | $topics = array_map('intval', explode('-', $_REQUEST['topics'])); |
@@ -189,13 +199,15 @@ discard block |
||
| 189 | 199 | ) |
| 190 | 200 | ); |
| 191 | 201 | $logged_topics = array(); |
| 192 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 193 | - $logged_topics[$row['id_topic']] = $row['unwatched']; |
|
| 202 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
| 203 | + $logged_topics[$row['id_topic']] = $row['unwatched']; |
|
| 204 | + } |
|
| 194 | 205 | $smcFunc['db_free_result']($request); |
| 195 | 206 | |
| 196 | 207 | $markRead = array(); |
| 197 | - foreach ($topics as $id_topic) |
|
| 198 | - $markRead[] = array($modSettings['maxMsgID'], $user_info['id'], $id_topic, (isset($logged_topics[$topic]) ? $logged_topics[$topic] : 0)); |
|
| 208 | + foreach ($topics as $id_topic) { |
|
| 209 | + $markRead[] = array($modSettings['maxMsgID'], $user_info['id'], $id_topic, (isset($logged_topics[$topic]) ? $logged_topics[$topic] : 0)); |
|
| 210 | + } |
|
| 199 | 211 | |
| 200 | 212 | $smcFunc['db_insert']('replace', |
| 201 | 213 | '{db_prefix}log_topics', |
@@ -204,8 +216,9 @@ discard block |
||
| 204 | 216 | array('id_member', 'id_topic') |
| 205 | 217 | ); |
| 206 | 218 | |
| 207 | - if (isset($_SESSION['topicseen_cache'])) |
|
| 208 | - $_SESSION['topicseen_cache'] = array(); |
|
| 219 | + if (isset($_SESSION['topicseen_cache'])) { |
|
| 220 | + $_SESSION['topicseen_cache'] = array(); |
|
| 221 | + } |
|
| 209 | 222 | |
| 210 | 223 | redirectexit('action=unreadreplies'); |
| 211 | 224 | } |
@@ -230,11 +243,13 @@ discard block |
||
| 230 | 243 | if (!empty($_GET['t'])) |
| 231 | 244 | { |
| 232 | 245 | // If they read the whole topic, go back to the beginning. |
| 233 | - if ($_GET['t'] >= $topicinfo['id_last_msg']) |
|
| 234 | - $earlyMsg = 0; |
|
| 246 | + if ($_GET['t'] >= $topicinfo['id_last_msg']) { |
|
| 247 | + $earlyMsg = 0; |
|
| 248 | + } |
|
| 235 | 249 | // If they want to mark the whole thing read, same. |
| 236 | - elseif ($_GET['t'] <= $topicinfo['id_first_msg']) |
|
| 237 | - $earlyMsg = 0; |
|
| 250 | + elseif ($_GET['t'] <= $topicinfo['id_first_msg']) { |
|
| 251 | + $earlyMsg = 0; |
|
| 252 | + } |
|
| 238 | 253 | // Otherwise, get the latest message before the named one. |
| 239 | 254 | else |
| 240 | 255 | { |
@@ -255,9 +270,9 @@ discard block |
||
| 255 | 270 | } |
| 256 | 271 | } |
| 257 | 272 | // Marking read from first page? That's the whole topic. |
| 258 | - elseif ($_REQUEST['start'] == 0) |
|
| 259 | - $earlyMsg = 0; |
|
| 260 | - else |
|
| 273 | + elseif ($_REQUEST['start'] == 0) { |
|
| 274 | + $earlyMsg = 0; |
|
| 275 | + } else |
|
| 261 | 276 | { |
| 262 | 277 | $result = $smcFunc['db_query']('', ' |
| 263 | 278 | SELECT id_msg |
@@ -285,8 +300,7 @@ discard block |
||
| 285 | 300 | ); |
| 286 | 301 | |
| 287 | 302 | redirectexit('board=' . $board . '.0'); |
| 288 | - } |
|
| 289 | - else |
|
| 303 | + } else |
|
| 290 | 304 | { |
| 291 | 305 | $categories = array(); |
| 292 | 306 | $boards = array(); |
@@ -294,17 +308,20 @@ discard block |
||
| 294 | 308 | if (isset($_REQUEST['c'])) |
| 295 | 309 | { |
| 296 | 310 | $_REQUEST['c'] = explode(',', $_REQUEST['c']); |
| 297 | - foreach ($_REQUEST['c'] as $c) |
|
| 298 | - $categories[] = (int) $c; |
|
| 311 | + foreach ($_REQUEST['c'] as $c) { |
|
| 312 | + $categories[] = (int) $c; |
|
| 313 | + } |
|
| 299 | 314 | } |
| 300 | 315 | if (isset($_REQUEST['boards'])) |
| 301 | 316 | { |
| 302 | 317 | $_REQUEST['boards'] = explode(',', $_REQUEST['boards']); |
| 303 | - foreach ($_REQUEST['boards'] as $b) |
|
| 304 | - $boards[] = (int) $b; |
|
| 318 | + foreach ($_REQUEST['boards'] as $b) { |
|
| 319 | + $boards[] = (int) $b; |
|
| 320 | + } |
|
| 321 | + } |
|
| 322 | + if (!empty($board)) { |
|
| 323 | + $boards[] = (int) $board; |
|
| 305 | 324 | } |
| 306 | - if (!empty($board)) |
|
| 307 | - $boards[] = (int) $board; |
|
| 308 | 325 | |
| 309 | 326 | if (isset($_REQUEST['children']) && !empty($boards)) |
| 310 | 327 | { |
@@ -324,9 +341,10 @@ discard block |
||
| 324 | 341 | 'board_list' => $boards, |
| 325 | 342 | ) |
| 326 | 343 | ); |
| 327 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 328 | - if (in_array($row['id_parent'], $boards)) |
|
| 344 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
| 345 | + if (in_array($row['id_parent'], $boards)) |
|
| 329 | 346 | $boards[] = $row['id_board']; |
| 347 | + } |
|
| 330 | 348 | $smcFunc['db_free_result']($request); |
| 331 | 349 | } |
| 332 | 350 | |
@@ -343,8 +361,9 @@ discard block |
||
| 343 | 361 | $clauseParameters['board_list'] = $boards; |
| 344 | 362 | } |
| 345 | 363 | |
| 346 | - if (empty($clauses)) |
|
| 347 | - redirectexit(); |
|
| 364 | + if (empty($clauses)) { |
|
| 365 | + redirectexit(); |
|
| 366 | + } |
|
| 348 | 367 | |
| 349 | 368 | $request = $smcFunc['db_query']('', ' |
| 350 | 369 | SELECT b.id_board |
@@ -355,19 +374,22 @@ discard block |
||
| 355 | 374 | )) |
| 356 | 375 | ); |
| 357 | 376 | $boards = array(); |
| 358 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 359 | - $boards[] = $row['id_board']; |
|
| 377 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
| 378 | + $boards[] = $row['id_board']; |
|
| 379 | + } |
|
| 360 | 380 | $smcFunc['db_free_result']($request); |
| 361 | 381 | |
| 362 | - if (empty($boards)) |
|
| 363 | - redirectexit(); |
|
| 382 | + if (empty($boards)) { |
|
| 383 | + redirectexit(); |
|
| 384 | + } |
|
| 364 | 385 | |
| 365 | 386 | markBoardsRead($boards, isset($_REQUEST['unread'])); |
| 366 | 387 | |
| 367 | 388 | foreach ($boards as $b) |
| 368 | 389 | { |
| 369 | - if (isset($_SESSION['topicseen_cache'][$b])) |
|
| 370 | - $_SESSION['topicseen_cache'][$b] = array(); |
|
| 390 | + if (isset($_SESSION['topicseen_cache'][$b])) { |
|
| 391 | + $_SESSION['topicseen_cache'][$b] = array(); |
|
| 392 | + } |
|
| 371 | 393 | } |
| 372 | 394 | |
| 373 | 395 | if (!isset($_REQUEST['unread'])) |
@@ -385,8 +407,9 @@ discard block |
||
| 385 | 407 | if ($smcFunc['db_num_rows']($result) > 0) |
| 386 | 408 | { |
| 387 | 409 | $logBoardInserts = array(); |
| 388 | - while ($row = $smcFunc['db_fetch_assoc']($result)) |
|
| 389 | - $logBoardInserts[] = array($modSettings['maxMsgID'], $user_info['id'], $row['id_board']); |
|
| 410 | + while ($row = $smcFunc['db_fetch_assoc']($result)) { |
|
| 411 | + $logBoardInserts[] = array($modSettings['maxMsgID'], $user_info['id'], $row['id_board']); |
|
| 412 | + } |
|
| 390 | 413 | |
| 391 | 414 | $smcFunc['db_insert']('replace', |
| 392 | 415 | '{db_prefix}log_boards', |
@@ -397,17 +420,18 @@ discard block |
||
| 397 | 420 | } |
| 398 | 421 | $smcFunc['db_free_result']($result); |
| 399 | 422 | |
| 400 | - if (empty($board)) |
|
| 401 | - redirectexit(); |
|
| 402 | - else |
|
| 403 | - redirectexit('board=' . $board . '.0'); |
|
| 404 | - } |
|
| 405 | - else |
|
| 423 | + if (empty($board)) { |
|
| 424 | + redirectexit(); |
|
| 425 | + } else { |
|
| 426 | + redirectexit('board=' . $board . '.0'); |
|
| 427 | + } |
|
| 428 | + } else |
|
| 406 | 429 | { |
| 407 | - if (empty($board_info['parent'])) |
|
| 408 | - redirectexit(); |
|
| 409 | - else |
|
| 410 | - redirectexit('board=' . $board_info['parent'] . '.0'); |
|
| 430 | + if (empty($board_info['parent'])) { |
|
| 431 | + redirectexit(); |
|
| 432 | + } else { |
|
| 433 | + redirectexit('board=' . $board_info['parent'] . '.0'); |
|
| 434 | + } |
|
| 411 | 435 | } |
| 412 | 436 | } |
| 413 | 437 | } |
@@ -432,11 +456,13 @@ discard block |
||
| 432 | 456 | 'selected_message' => (int) $messageID, |
| 433 | 457 | ) |
| 434 | 458 | ); |
| 435 | - if ($smcFunc['db_num_rows']($result) > 0) |
|
| 436 | - list ($memberID) = $smcFunc['db_fetch_row']($result); |
|
| 459 | + if ($smcFunc['db_num_rows']($result) > 0) { |
|
| 460 | + list ($memberID) = $smcFunc['db_fetch_row']($result); |
|
| 461 | + } |
|
| 437 | 462 | // The message doesn't even exist. |
| 438 | - else |
|
| 439 | - $memberID = 0; |
|
| 463 | + else { |
|
| 464 | + $memberID = 0; |
|
| 465 | + } |
|
| 440 | 466 | $smcFunc['db_free_result']($result); |
| 441 | 467 | |
| 442 | 468 | return (int) $memberID; |
@@ -457,8 +483,9 @@ discard block |
||
| 457 | 483 | getBoardTree(); |
| 458 | 484 | |
| 459 | 485 | // Make sure given boards and categories exist. |
| 460 | - if (!isset($boards[$board_id]) || (isset($boardOptions['target_board']) && !isset($boards[$boardOptions['target_board']])) || (isset($boardOptions['target_category']) && !isset($cat_tree[$boardOptions['target_category']]))) |
|
| 461 | - fatal_lang_error('no_board'); |
|
| 486 | + if (!isset($boards[$board_id]) || (isset($boardOptions['target_board']) && !isset($boards[$boardOptions['target_board']])) || (isset($boardOptions['target_category']) && !isset($cat_tree[$boardOptions['target_category']]))) { |
|
| 487 | + fatal_lang_error('no_board'); |
|
| 488 | + } |
|
| 462 | 489 | |
| 463 | 490 | $id = $board_id; |
| 464 | 491 | call_integration_hook('integrate_pre_modify_board', array($id, &$boardOptions)); |
@@ -486,8 +513,9 @@ discard block |
||
| 486 | 513 | $child_level = 0; |
| 487 | 514 | $id_parent = 0; |
| 488 | 515 | $after = 0; |
| 489 | - foreach ($cat_tree[$id_cat]['children'] as $id_board => $dummy) |
|
| 490 | - $after = max($after, $boards[$id_board]['order']); |
|
| 516 | + foreach ($cat_tree[$id_cat]['children'] as $id_board => $dummy) { |
|
| 517 | + $after = max($after, $boards[$id_board]['order']); |
|
| 518 | + } |
|
| 491 | 519 | } |
| 492 | 520 | |
| 493 | 521 | // Make the board a child of a given board. |
@@ -498,17 +526,19 @@ discard block |
||
| 498 | 526 | $id_parent = $boardOptions['target_board']; |
| 499 | 527 | |
| 500 | 528 | // People can be creative, in many ways... |
| 501 | - if (isChildOf($id_parent, $board_id)) |
|
| 502 | - fatal_lang_error('mboards_parent_own_child_error', false); |
|
| 503 | - elseif ($id_parent == $board_id) |
|
| 504 | - fatal_lang_error('mboards_board_own_child_error', false); |
|
| 529 | + if (isChildOf($id_parent, $board_id)) { |
|
| 530 | + fatal_lang_error('mboards_parent_own_child_error', false); |
|
| 531 | + } elseif ($id_parent == $board_id) { |
|
| 532 | + fatal_lang_error('mboards_board_own_child_error', false); |
|
| 533 | + } |
|
| 505 | 534 | |
| 506 | 535 | $after = $boards[$boardOptions['target_board']]['order']; |
| 507 | 536 | |
| 508 | 537 | // Check if there are already children and (if so) get the max board order. |
| 509 | - if (!empty($boards[$id_parent]['tree']['children']) && empty($boardOptions['move_first_child'])) |
|
| 510 | - foreach ($boards[$id_parent]['tree']['children'] as $childBoard_id => $dummy) |
|
| 538 | + if (!empty($boards[$id_parent]['tree']['children']) && empty($boardOptions['move_first_child'])) { |
|
| 539 | + foreach ($boards[$id_parent]['tree']['children'] as $childBoard_id => $dummy) |
|
| 511 | 540 | $after = max($after, $boards[$childBoard_id]['order']); |
| 541 | + } |
|
| 512 | 542 | } |
| 513 | 543 | |
| 514 | 544 | // Place a board before or after another board, on the same child level. |
@@ -521,8 +551,9 @@ discard block |
||
| 521 | 551 | } |
| 522 | 552 | |
| 523 | 553 | // Oops...? |
| 524 | - else |
|
| 525 | - trigger_error('modifyBoard(): The move_to value \'' . $boardOptions['move_to'] . '\' is incorrect', E_USER_ERROR); |
|
| 554 | + else { |
|
| 555 | + trigger_error('modifyBoard(): The move_to value \'' . $boardOptions['move_to'] . '\' is incorrect', E_USER_ERROR); |
|
| 556 | + } |
|
| 526 | 557 | |
| 527 | 558 | // Get a list of children of this board. |
| 528 | 559 | $childList = array(); |
@@ -531,14 +562,16 @@ discard block |
||
| 531 | 562 | // See if there are changes that affect children. |
| 532 | 563 | $childUpdates = array(); |
| 533 | 564 | $levelDiff = $child_level - $boards[$board_id]['level']; |
| 534 | - if ($levelDiff != 0) |
|
| 535 | - $childUpdates[] = 'child_level = child_level ' . ($levelDiff > 0 ? '+ ' : '') . '{int:level_diff}'; |
|
| 536 | - if ($id_cat != $boards[$board_id]['category']) |
|
| 537 | - $childUpdates[] = 'id_cat = {int:category}'; |
|
| 565 | + if ($levelDiff != 0) { |
|
| 566 | + $childUpdates[] = 'child_level = child_level ' . ($levelDiff > 0 ? '+ ' : '') . '{int:level_diff}'; |
|
| 567 | + } |
|
| 568 | + if ($id_cat != $boards[$board_id]['category']) { |
|
| 569 | + $childUpdates[] = 'id_cat = {int:category}'; |
|
| 570 | + } |
|
| 538 | 571 | |
| 539 | 572 | // Fix the children of this board. |
| 540 | - if (!empty($childList) && !empty($childUpdates)) |
|
| 541 | - $smcFunc['db_query']('', ' |
|
| 573 | + if (!empty($childList) && !empty($childUpdates)) { |
|
| 574 | + $smcFunc['db_query']('', ' |
|
| 542 | 575 | UPDATE {db_prefix}boards |
| 543 | 576 | SET ' . implode(', |
| 544 | 577 | ', $childUpdates) . ' |
@@ -549,6 +582,7 @@ discard block |
||
| 549 | 582 | 'level_diff' => $levelDiff, |
| 550 | 583 | ) |
| 551 | 584 | ); |
| 585 | + } |
|
| 552 | 586 | |
| 553 | 587 | // Make some room for this spot. |
| 554 | 588 | $smcFunc['db_query']('', ' |
@@ -644,8 +678,8 @@ discard block |
||
| 644 | 678 | call_integration_hook('integrate_modify_board', array($id, $boardOptions, &$boardUpdates, &$boardUpdateParameters)); |
| 645 | 679 | |
| 646 | 680 | // Do the updates (if any). |
| 647 | - if (!empty($boardUpdates)) |
|
| 648 | - $smcFunc['db_query']('', ' |
|
| 681 | + if (!empty($boardUpdates)) { |
|
| 682 | + $smcFunc['db_query']('', ' |
|
| 649 | 683 | UPDATE {db_prefix}boards |
| 650 | 684 | SET |
| 651 | 685 | ' . implode(', |
@@ -655,6 +689,7 @@ discard block |
||
| 655 | 689 | 'selected_board' => $board_id, |
| 656 | 690 | )) |
| 657 | 691 | ); |
| 692 | + } |
|
| 658 | 693 | |
| 659 | 694 | // Set moderators of this board. |
| 660 | 695 | if (isset($boardOptions['moderators']) || isset($boardOptions['moderator_string']) || isset($boardOptions['moderator_groups']) || isset($boardOptions['moderator_group_string'])) |
@@ -679,13 +714,15 @@ discard block |
||
| 679 | 714 | { |
| 680 | 715 | $moderators[$k] = trim($moderators[$k]); |
| 681 | 716 | |
| 682 | - if (strlen($moderators[$k]) == 0) |
|
| 683 | - unset($moderators[$k]); |
|
| 717 | + if (strlen($moderators[$k]) == 0) { |
|
| 718 | + unset($moderators[$k]); |
|
| 719 | + } |
|
| 684 | 720 | } |
| 685 | 721 | |
| 686 | 722 | // Find all the id_member's for the member_name's in the list. |
| 687 | - if (empty($boardOptions['moderators'])) |
|
| 688 | - $boardOptions['moderators'] = array(); |
|
| 723 | + if (empty($boardOptions['moderators'])) { |
|
| 724 | + $boardOptions['moderators'] = array(); |
|
| 725 | + } |
|
| 689 | 726 | if (!empty($moderators)) |
| 690 | 727 | { |
| 691 | 728 | $request = $smcFunc['db_query']('', ' |
@@ -698,8 +735,9 @@ discard block |
||
| 698 | 735 | 'limit' => count($moderators), |
| 699 | 736 | ) |
| 700 | 737 | ); |
| 701 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 702 | - $boardOptions['moderators'][] = $row['id_member']; |
|
| 738 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
| 739 | + $boardOptions['moderators'][] = $row['id_member']; |
|
| 740 | + } |
|
| 703 | 741 | $smcFunc['db_free_result']($request); |
| 704 | 742 | } |
| 705 | 743 | } |
@@ -708,8 +746,9 @@ discard block |
||
| 708 | 746 | if (!empty($boardOptions['moderators'])) |
| 709 | 747 | { |
| 710 | 748 | $inserts = array(); |
| 711 | - foreach ($boardOptions['moderators'] as $moderator) |
|
| 712 | - $inserts[] = array($board_id, $moderator); |
|
| 749 | + foreach ($boardOptions['moderators'] as $moderator) { |
|
| 750 | + $inserts[] = array($board_id, $moderator); |
|
| 751 | + } |
|
| 713 | 752 | |
| 714 | 753 | $smcFunc['db_insert']('insert', |
| 715 | 754 | '{db_prefix}moderators', |
@@ -739,14 +778,16 @@ discard block |
||
| 739 | 778 | { |
| 740 | 779 | $moderator_groups[$k] = trim($moderator_groups[$k]); |
| 741 | 780 | |
| 742 | - if (strlen($moderator_groups[$k]) == 0) |
|
| 743 | - unset($moderator_groups[$k]); |
|
| 781 | + if (strlen($moderator_groups[$k]) == 0) { |
|
| 782 | + unset($moderator_groups[$k]); |
|
| 783 | + } |
|
| 744 | 784 | } |
| 745 | 785 | |
| 746 | 786 | /* Find all the id_group's for all the group names in the list |
| 747 | 787 | But skip any invalid ones (invisible/post groups/Administrator/Moderator) */ |
| 748 | - if (empty($boardOptions['moderator_groups'])) |
|
| 749 | - $boardOptions['moderator_groups'] = array(); |
|
| 788 | + if (empty($boardOptions['moderator_groups'])) { |
|
| 789 | + $boardOptions['moderator_groups'] = array(); |
|
| 790 | + } |
|
| 750 | 791 | if (!empty($moderator_groups)) |
| 751 | 792 | { |
| 752 | 793 | $request = $smcFunc['db_query']('', ' |
@@ -777,8 +818,9 @@ discard block |
||
| 777 | 818 | if (!empty($boardOptions['moderator_groups'])) |
| 778 | 819 | { |
| 779 | 820 | $inserts = array(); |
| 780 | - foreach ($boardOptions['moderator_groups'] as $moderator_group) |
|
| 781 | - $inserts[] = array($board_id, $moderator_group); |
|
| 821 | + foreach ($boardOptions['moderator_groups'] as $moderator_group) { |
|
| 822 | + $inserts[] = array($board_id, $moderator_group); |
|
| 823 | + } |
|
| 782 | 824 | |
| 783 | 825 | $smcFunc['db_insert']('insert', |
| 784 | 826 | '{db_prefix}moderator_groups', |
@@ -792,14 +834,16 @@ discard block |
||
| 792 | 834 | updateSettings(array('settings_updated' => time())); |
| 793 | 835 | } |
| 794 | 836 | |
| 795 | - if (isset($boardOptions['move_to'])) |
|
| 796 | - reorderBoards(); |
|
| 837 | + if (isset($boardOptions['move_to'])) { |
|
| 838 | + reorderBoards(); |
|
| 839 | + } |
|
| 797 | 840 | |
| 798 | 841 | clean_cache('data'); |
| 799 | 842 | |
| 800 | - if (empty($boardOptions['dont_log'])) |
|
| 801 | - logAction('edit_board', array('board' => $board_id), 'admin'); |
|
| 802 | -} |
|
| 843 | + if (empty($boardOptions['dont_log'])) { |
|
| 844 | + logAction('edit_board', array('board' => $board_id), 'admin'); |
|
| 845 | + } |
|
| 846 | + } |
|
| 803 | 847 | |
| 804 | 848 | /** |
| 805 | 849 | * Create a new board and set its properties and position. |
@@ -815,11 +859,13 @@ discard block |
||
| 815 | 859 | global $boards, $smcFunc; |
| 816 | 860 | |
| 817 | 861 | // Trigger an error if one of the required values is not set. |
| 818 | - if (!isset($boardOptions['board_name']) || trim($boardOptions['board_name']) == '' || !isset($boardOptions['move_to']) || !isset($boardOptions['target_category'])) |
|
| 819 | - trigger_error('createBoard(): One or more of the required options is not set', E_USER_ERROR); |
|
| 862 | + if (!isset($boardOptions['board_name']) || trim($boardOptions['board_name']) == '' || !isset($boardOptions['move_to']) || !isset($boardOptions['target_category'])) { |
|
| 863 | + trigger_error('createBoard(): One or more of the required options is not set', E_USER_ERROR); |
|
| 864 | + } |
|
| 820 | 865 | |
| 821 | - if (in_array($boardOptions['move_to'], array('child', 'before', 'after')) && !isset($boardOptions['target_board'])) |
|
| 822 | - trigger_error('createBoard(): Target board is not set', E_USER_ERROR); |
|
| 866 | + if (in_array($boardOptions['move_to'], array('child', 'before', 'after')) && !isset($boardOptions['target_board'])) { |
|
| 867 | + trigger_error('createBoard(): Target board is not set', E_USER_ERROR); |
|
| 868 | + } |
|
| 823 | 869 | |
| 824 | 870 | // Set every optional value to its default value. |
| 825 | 871 | $boardOptions += array( |
@@ -853,8 +899,9 @@ discard block |
||
| 853 | 899 | 1 |
| 854 | 900 | ); |
| 855 | 901 | |
| 856 | - if (empty($board_id)) |
|
| 857 | - return 0; |
|
| 902 | + if (empty($board_id)) { |
|
| 903 | + return 0; |
|
| 904 | + } |
|
| 858 | 905 | |
| 859 | 906 | // Change the board according to the given specifications. |
| 860 | 907 | modifyBoard($board_id, $boardOptions); |
@@ -917,8 +964,9 @@ discard block |
||
| 917 | 964 | global $sourcedir, $boards, $smcFunc; |
| 918 | 965 | |
| 919 | 966 | // No boards to delete? Return! |
| 920 | - if (empty($boards_to_remove)) |
|
| 921 | - return; |
|
| 967 | + if (empty($boards_to_remove)) { |
|
| 968 | + return; |
|
| 969 | + } |
|
| 922 | 970 | |
| 923 | 971 | getBoardTree(); |
| 924 | 972 | |
@@ -929,12 +977,14 @@ discard block |
||
| 929 | 977 | { |
| 930 | 978 | // Get a list of the child boards that will also be removed. |
| 931 | 979 | $child_boards_to_remove = array(); |
| 932 | - foreach ($boards_to_remove as $board_to_remove) |
|
| 933 | - recursiveBoards($child_boards_to_remove, $boards[$board_to_remove]['tree']); |
|
| 980 | + foreach ($boards_to_remove as $board_to_remove) { |
|
| 981 | + recursiveBoards($child_boards_to_remove, $boards[$board_to_remove]['tree']); |
|
| 982 | + } |
|
| 934 | 983 | |
| 935 | 984 | // Merge the children with their parents. |
| 936 | - if (!empty($child_boards_to_remove)) |
|
| 937 | - $boards_to_remove = array_unique(array_merge($boards_to_remove, $child_boards_to_remove)); |
|
| 985 | + if (!empty($child_boards_to_remove)) { |
|
| 986 | + $boards_to_remove = array_unique(array_merge($boards_to_remove, $child_boards_to_remove)); |
|
| 987 | + } |
|
| 938 | 988 | } |
| 939 | 989 | // Move the children to a safe home. |
| 940 | 990 | else |
@@ -942,10 +992,11 @@ discard block |
||
| 942 | 992 | foreach ($boards_to_remove as $id_board) |
| 943 | 993 | { |
| 944 | 994 | // @todo Separate category? |
| 945 | - if ($moveChildrenTo === 0) |
|
| 946 | - fixChildren($id_board, 0, 0); |
|
| 947 | - else |
|
| 948 | - fixChildren($id_board, $boards[$moveChildrenTo]['level'] + 1, $moveChildrenTo); |
|
| 995 | + if ($moveChildrenTo === 0) { |
|
| 996 | + fixChildren($id_board, 0, 0); |
|
| 997 | + } else { |
|
| 998 | + fixChildren($id_board, $boards[$moveChildrenTo]['level'] + 1, $moveChildrenTo); |
|
| 999 | + } |
|
| 949 | 1000 | } |
| 950 | 1001 | } |
| 951 | 1002 | |
@@ -959,8 +1010,9 @@ discard block |
||
| 959 | 1010 | ) |
| 960 | 1011 | ); |
| 961 | 1012 | $topics = array(); |
| 962 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 963 | - $topics[] = $row['id_topic']; |
|
| 1013 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
| 1014 | + $topics[] = $row['id_topic']; |
|
| 1015 | + } |
|
| 964 | 1016 | $smcFunc['db_free_result']($request); |
| 965 | 1017 | |
| 966 | 1018 | require_once($sourcedir . '/RemoveTopic.php'); |
@@ -1048,8 +1100,9 @@ discard block |
||
| 1048 | 1100 | clean_cache('data'); |
| 1049 | 1101 | |
| 1050 | 1102 | // Let's do some serious logging. |
| 1051 | - foreach ($boards_to_remove as $id_board) |
|
| 1052 | - logAction('delete_board', array('boardname' => $boards[$id_board]['name']), 'admin'); |
|
| 1103 | + foreach ($boards_to_remove as $id_board) { |
|
| 1104 | + logAction('delete_board', array('boardname' => $boards[$id_board]['name']), 'admin'); |
|
| 1105 | + } |
|
| 1053 | 1106 | |
| 1054 | 1107 | reorderBoards(); |
| 1055 | 1108 | } |
@@ -1068,8 +1121,8 @@ discard block |
||
| 1068 | 1121 | $board_order = 0; |
| 1069 | 1122 | foreach ($cat_tree as $catID => $dummy) |
| 1070 | 1123 | { |
| 1071 | - foreach ($boardList[$catID] as $boardID) |
|
| 1072 | - if ($boards[$boardID]['order'] != ++$board_order) |
|
| 1124 | + foreach ($boardList[$catID] as $boardID) { |
|
| 1125 | + if ($boards[$boardID]['order'] != ++$board_order) |
|
| 1073 | 1126 | $smcFunc['db_query']('', ' |
| 1074 | 1127 | UPDATE {db_prefix}boards |
| 1075 | 1128 | SET board_order = {int:new_order} |
@@ -1079,6 +1132,7 @@ discard block |
||
| 1079 | 1132 | 'selected_board' => $boardID, |
| 1080 | 1133 | ) |
| 1081 | 1134 | ); |
| 1135 | + } |
|
| 1082 | 1136 | } |
| 1083 | 1137 | |
| 1084 | 1138 | // Empty the board order cache |
@@ -1107,8 +1161,9 @@ discard block |
||
| 1107 | 1161 | ) |
| 1108 | 1162 | ); |
| 1109 | 1163 | $children = array(); |
| 1110 | - while ($row = $smcFunc['db_fetch_assoc']($result)) |
|
| 1111 | - $children[] = $row['id_board']; |
|
| 1164 | + while ($row = $smcFunc['db_fetch_assoc']($result)) { |
|
| 1165 | + $children[] = $row['id_board']; |
|
| 1166 | + } |
|
| 1112 | 1167 | $smcFunc['db_free_result']($result); |
| 1113 | 1168 | |
| 1114 | 1169 | // ...and set it to a new parent and child_level. |
@@ -1124,9 +1179,10 @@ discard block |
||
| 1124 | 1179 | ); |
| 1125 | 1180 | |
| 1126 | 1181 | // Recursively fix the children of the children. |
| 1127 | - foreach ($children as $child) |
|
| 1128 | - fixChildren($child, $newLevel + 1, $child); |
|
| 1129 | -} |
|
| 1182 | + foreach ($children as $child) { |
|
| 1183 | + fixChildren($child, $newLevel + 1, $child); |
|
| 1184 | + } |
|
| 1185 | + } |
|
| 1130 | 1186 | |
| 1131 | 1187 | /** |
| 1132 | 1188 | * Tries to load up the entire board order and category very very quickly |
@@ -1143,8 +1199,9 @@ discard block |
||
| 1143 | 1199 | 'boards' => array(), |
| 1144 | 1200 | ); |
| 1145 | 1201 | |
| 1146 | - if (!empty($tree_order['boards'])) |
|
| 1147 | - return $tree_order; |
|
| 1202 | + if (!empty($tree_order['boards'])) { |
|
| 1203 | + return $tree_order; |
|
| 1204 | + } |
|
| 1148 | 1205 | |
| 1149 | 1206 | if (($cached = cache_get_data('board_order', 86400)) !== null) |
| 1150 | 1207 | { |
@@ -1160,8 +1217,9 @@ discard block |
||
| 1160 | 1217 | ); |
| 1161 | 1218 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
| 1162 | 1219 | { |
| 1163 | - if (!in_array($row['id_cat'], $tree_order['cats'])) |
|
| 1164 | - $tree_order['cats'][] = $row['id_cat']; |
|
| 1220 | + if (!in_array($row['id_cat'], $tree_order['cats'])) { |
|
| 1221 | + $tree_order['cats'][] = $row['id_cat']; |
|
| 1222 | + } |
|
| 1165 | 1223 | $tree_order['boards'][] = $row['id_board']; |
| 1166 | 1224 | } |
| 1167 | 1225 | $smcFunc['db_free_result']($request); |
@@ -1181,16 +1239,19 @@ discard block |
||
| 1181 | 1239 | $tree = getTreeOrder(); |
| 1182 | 1240 | |
| 1183 | 1241 | $ordered = array(); |
| 1184 | - foreach ($tree['boards'] as $board) |
|
| 1185 | - if (!empty($boards[$board])) |
|
| 1242 | + foreach ($tree['boards'] as $board) { |
|
| 1243 | + if (!empty($boards[$board])) |
|
| 1186 | 1244 | { |
| 1187 | 1245 | $ordered[$board] = $boards[$board]; |
| 1246 | + } |
|
| 1188 | 1247 | |
| 1189 | - if (is_array($ordered[$board]) && !empty($ordered[$board]['boards'])) |
|
| 1190 | - sortBoards($ordered[$board]['boards']); |
|
| 1248 | + if (is_array($ordered[$board]) && !empty($ordered[$board]['boards'])) { |
|
| 1249 | + sortBoards($ordered[$board]['boards']); |
|
| 1250 | + } |
|
| 1191 | 1251 | |
| 1192 | - if (is_array($ordered[$board]) && !empty($ordered[$board]['children'])) |
|
| 1193 | - sortBoards($ordered[$board]['children']); |
|
| 1252 | + if (is_array($ordered[$board]) && !empty($ordered[$board]['children'])) { |
|
| 1253 | + sortBoards($ordered[$board]['children']); |
|
| 1254 | + } |
|
| 1194 | 1255 | } |
| 1195 | 1256 | |
| 1196 | 1257 | $boards = $ordered; |
@@ -1206,12 +1267,14 @@ discard block |
||
| 1206 | 1267 | $tree = getTreeOrder(); |
| 1207 | 1268 | |
| 1208 | 1269 | $ordered = array(); |
| 1209 | - foreach ($tree['cats'] as $cat) |
|
| 1210 | - if (!empty($categories[$cat])) |
|
| 1270 | + foreach ($tree['cats'] as $cat) { |
|
| 1271 | + if (!empty($categories[$cat])) |
|
| 1211 | 1272 | { |
| 1212 | 1273 | $ordered[$cat] = $categories[$cat]; |
| 1213 | - if (!empty($ordered[$cat]['boards'])) |
|
| 1214 | - sortBoards($ordered[$cat]['boards']); |
|
| 1274 | + } |
|
| 1275 | + if (!empty($ordered[$cat]['boards'])) { |
|
| 1276 | + sortBoards($ordered[$cat]['boards']); |
|
| 1277 | + } |
|
| 1215 | 1278 | } |
| 1216 | 1279 | |
| 1217 | 1280 | $categories = $ordered; |
@@ -1227,8 +1290,9 @@ discard block |
||
| 1227 | 1290 | { |
| 1228 | 1291 | global $smcFunc, $scripturl, $txt; |
| 1229 | 1292 | |
| 1230 | - if (empty($boards)) |
|
| 1231 | - return array(); |
|
| 1293 | + if (empty($boards)) { |
|
| 1294 | + return array(); |
|
| 1295 | + } |
|
| 1232 | 1296 | |
| 1233 | 1297 | $request = $smcFunc['db_query']('', ' |
| 1234 | 1298 | SELECT mem.id_member, mem.real_name, mo.id_board |
@@ -1242,8 +1306,9 @@ discard block |
||
| 1242 | 1306 | $moderators = array(); |
| 1243 | 1307 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
| 1244 | 1308 | { |
| 1245 | - if (empty($moderators[$row['id_board']])) |
|
| 1246 | - $moderators[$row['id_board']] = array(); |
|
| 1309 | + if (empty($moderators[$row['id_board']])) { |
|
| 1310 | + $moderators[$row['id_board']] = array(); |
|
| 1311 | + } |
|
| 1247 | 1312 | |
| 1248 | 1313 | $moderators[$row['id_board']][] = array( |
| 1249 | 1314 | 'id' => $row['id_member'], |
@@ -1267,8 +1332,9 @@ discard block |
||
| 1267 | 1332 | { |
| 1268 | 1333 | global $smcFunc, $scripturl, $txt; |
| 1269 | 1334 | |
| 1270 | - if (empty($boards)) |
|
| 1271 | - return array(); |
|
| 1335 | + if (empty($boards)) { |
|
| 1336 | + return array(); |
|
| 1337 | + } |
|
| 1272 | 1338 | |
| 1273 | 1339 | $request = $smcFunc['db_query']('', ' |
| 1274 | 1340 | SELECT mg.id_group, mg.group_name, bg.id_board |
@@ -1282,8 +1348,9 @@ discard block |
||
| 1282 | 1348 | $groups = array(); |
| 1283 | 1349 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
| 1284 | 1350 | { |
| 1285 | - if (empty($groups[$row['id_board']])) |
|
| 1286 | - $groups[$row['id_board']] = array(); |
|
| 1351 | + if (empty($groups[$row['id_board']])) { |
|
| 1352 | + $groups[$row['id_board']] = array(); |
|
| 1353 | + } |
|
| 1287 | 1354 | |
| 1288 | 1355 | $groups[$row['id_board']][] = array( |
| 1289 | 1356 | 'id' => $row['id_group'], |
@@ -1358,8 +1425,9 @@ discard block |
||
| 1358 | 1425 | |
| 1359 | 1426 | if (!empty($row['id_board'])) |
| 1360 | 1427 | { |
| 1361 | - if ($row['child_level'] != $curLevel) |
|
| 1362 | - $prevBoard = 0; |
|
| 1428 | + if ($row['child_level'] != $curLevel) { |
|
| 1429 | + $prevBoard = 0; |
|
| 1430 | + } |
|
| 1363 | 1431 | |
| 1364 | 1432 | $boards[$row['id_board']] = array( |
| 1365 | 1433 | 'id' => $row['id_board'], |
@@ -1391,16 +1459,16 @@ discard block |
||
| 1391 | 1459 | 'children' => array() |
| 1392 | 1460 | ); |
| 1393 | 1461 | $boards[$row['id_board']]['tree'] = &$cat_tree[$row['id_cat']]['children'][$row['id_board']]; |
| 1394 | - } |
|
| 1395 | - else |
|
| 1462 | + } else |
|
| 1396 | 1463 | { |
| 1397 | 1464 | // Parent doesn't exist! |
| 1398 | - if (!isset($boards[$row['id_parent']]['tree'])) |
|
| 1399 | - fatal_lang_error('no_valid_parent', false, array($row['board_name'])); |
|
| 1465 | + if (!isset($boards[$row['id_parent']]['tree'])) { |
|
| 1466 | + fatal_lang_error('no_valid_parent', false, array($row['board_name'])); |
|
| 1467 | + } |
|
| 1400 | 1468 | |
| 1401 | 1469 | // Wrong childlevel...we can silently fix this... |
| 1402 | - if ($boards[$row['id_parent']]['tree']['node']['level'] != $row['child_level'] - 1) |
|
| 1403 | - $smcFunc['db_query']('', ' |
|
| 1470 | + if ($boards[$row['id_parent']]['tree']['node']['level'] != $row['child_level'] - 1) { |
|
| 1471 | + $smcFunc['db_query']('', ' |
|
| 1404 | 1472 | UPDATE {db_prefix}boards |
| 1405 | 1473 | SET child_level = {int:new_child_level} |
| 1406 | 1474 | WHERE id_board = {int:selected_board}', |
@@ -1409,6 +1477,7 @@ discard block |
||
| 1409 | 1477 | 'selected_board' => $row['id_board'], |
| 1410 | 1478 | ) |
| 1411 | 1479 | ); |
| 1480 | + } |
|
| 1412 | 1481 | |
| 1413 | 1482 | $boards[$row['id_parent']]['tree']['children'][$row['id_board']] = array( |
| 1414 | 1483 | 'node' => &$boards[$row['id_board']], |
@@ -1442,8 +1511,9 @@ discard block |
||
| 1442 | 1511 | */ |
| 1443 | 1512 | function recursiveBoards(&$_boardList, &$_tree) |
| 1444 | 1513 | { |
| 1445 | - if (empty($_tree['children'])) |
|
| 1446 | - return; |
|
| 1514 | + if (empty($_tree['children'])) { |
|
| 1515 | + return; |
|
| 1516 | + } |
|
| 1447 | 1517 | |
| 1448 | 1518 | foreach ($_tree['children'] as $id => $node) |
| 1449 | 1519 | { |
@@ -1462,11 +1532,13 @@ discard block |
||
| 1462 | 1532 | { |
| 1463 | 1533 | global $boards; |
| 1464 | 1534 | |
| 1465 | - if (empty($boards[$child]['parent'])) |
|
| 1466 | - return false; |
|
| 1535 | + if (empty($boards[$child]['parent'])) { |
|
| 1536 | + return false; |
|
| 1537 | + } |
|
| 1467 | 1538 | |
| 1468 | - if ($boards[$child]['parent'] == $parent) |
|
| 1469 | - return true; |
|
| 1539 | + if ($boards[$child]['parent'] == $parent) { |
|
| 1540 | + return true; |
|
| 1541 | + } |
|
| 1470 | 1542 | |
| 1471 | 1543 | return isChildOf($boards[$child]['parent'], $parent); |
| 1472 | 1544 | } |
@@ -16,8 +16,9 @@ discard block |
||
| 16 | 16 | * @version 2.1 Beta 4 |
| 17 | 17 | */ |
| 18 | 18 | |
| 19 | -if (!defined('SMF')) |
|
| 19 | +if (!defined('SMF')) { |
|
| 20 | 20 | die('No direct access...'); |
| 21 | +} |
|
| 21 | 22 | |
| 22 | 23 | |
| 23 | 24 | /** |
@@ -28,14 +29,16 @@ discard block |
||
| 28 | 29 | function sha1_smf($str) |
| 29 | 30 | { |
| 30 | 31 | // If we have mhash loaded in, use it instead! |
| 31 | - if (function_exists('mhash') && defined('MHASH_SHA1')) |
|
| 32 | - return bin2hex(mhash(MHASH_SHA1, $str)); |
|
| 32 | + if (function_exists('mhash') && defined('MHASH_SHA1')) { |
|
| 33 | + return bin2hex(mhash(MHASH_SHA1, $str)); |
|
| 34 | + } |
|
| 33 | 35 | |
| 34 | 36 | $nblk = (strlen($str) + 8 >> 6) + 1; |
| 35 | 37 | $blks = array_pad(array(), $nblk * 16, 0); |
| 36 | 38 | |
| 37 | - for ($i = 0; $i < strlen($str); $i++) |
|
| 38 | - $blks[$i >> 2] |= ord($str{$i}) << (24 - ($i % 4) * 8); |
|
| 39 | + for ($i = 0; $i < strlen($str); $i++) { |
|
| 40 | + $blks[$i >> 2] |= ord($str{$i}) << (24 - ($i % 4) * 8); |
|
| 41 | + } |
|
| 39 | 42 | |
| 40 | 43 | $blks[$i >> 2] |= 0x80 << (24 - ($i % 4) * 8); |
| 41 | 44 | |
@@ -70,10 +73,11 @@ discard block |
||
| 70 | 73 | |
| 71 | 74 | for ($j = 0; $j < 80; $j++) |
| 72 | 75 | { |
| 73 | - if ($j < 16) |
|
| 74 | - $w[$j] = isset($x[$i + $j]) ? $x[$i + $j] : 0; |
|
| 75 | - else |
|
| 76 | - $w[$j] = sha1_rol($w[$j - 3] ^ $w[$j - 8] ^ $w[$j - 14] ^ $w[$j - 16], 1); |
|
| 76 | + if ($j < 16) { |
|
| 77 | + $w[$j] = isset($x[$i + $j]) ? $x[$i + $j] : 0; |
|
| 78 | + } else { |
|
| 79 | + $w[$j] = sha1_rol($w[$j - 3] ^ $w[$j - 8] ^ $w[$j - 14] ^ $w[$j - 16], 1); |
|
| 80 | + } |
|
| 77 | 81 | |
| 78 | 82 | $t = sha1_rol($a, 5) + sha1_ft($j, $b, $c, $d) + $e + $w[$j] + sha1_kt($j); |
| 79 | 83 | $e = $d; |
@@ -103,12 +107,15 @@ discard block |
||
| 103 | 107 | */ |
| 104 | 108 | function sha1_ft($t, $b, $c, $d) |
| 105 | 109 | { |
| 106 | - if ($t < 20) |
|
| 107 | - return ($b & $c) | ((~$b) & $d); |
|
| 108 | - if ($t < 40) |
|
| 109 | - return $b ^ $c ^ $d; |
|
| 110 | - if ($t < 60) |
|
| 111 | - return ($b & $c) | ($b & $d) | ($c & $d); |
|
| 110 | + if ($t < 20) { |
|
| 111 | + return ($b & $c) | ((~$b) & $d); |
|
| 112 | + } |
|
| 113 | + if ($t < 40) { |
|
| 114 | + return $b ^ $c ^ $d; |
|
| 115 | + } |
|
| 116 | + if ($t < 60) { |
|
| 117 | + return ($b & $c) | ($b & $d) | ($c & $d); |
|
| 118 | + } |
|
| 112 | 119 | |
| 113 | 120 | return $b ^ $c ^ $d; |
| 114 | 121 | } |
@@ -132,10 +139,11 @@ discard block |
||
| 132 | 139 | function sha1_rol($num, $cnt) |
| 133 | 140 | { |
| 134 | 141 | // Unfortunately, PHP uses unsigned 32-bit longs only. So we have to kludge it a bit. |
| 135 | - if ($num & 0x80000000) |
|
| 136 | - $a = ($num >> 1 & 0x7fffffff) >> (31 - $cnt); |
|
| 137 | - else |
|
| 138 | - $a = $num >> (32 - $cnt); |
|
| 142 | + if ($num & 0x80000000) { |
|
| 143 | + $a = ($num >> 1 & 0x7fffffff) >> (31 - $cnt); |
|
| 144 | + } else { |
|
| 145 | + $a = $num >> (32 - $cnt); |
|
| 146 | + } |
|
| 139 | 147 | |
| 140 | 148 | return ($num << $cnt) | $a; |
| 141 | 149 | } |
@@ -14,8 +14,9 @@ discard block |
||
| 14 | 14 | * @version 2.1 Beta 4 |
| 15 | 15 | */ |
| 16 | 16 | |
| 17 | -if (!defined('SMF')) |
|
| 17 | +if (!defined('SMF')) { |
|
| 18 | 18 | die('No direct access...'); |
| 19 | +} |
|
| 19 | 20 | |
| 20 | 21 | /** |
| 21 | 22 | * View the forum's error log. |
@@ -30,8 +31,9 @@ discard block |
||
| 30 | 31 | global $scripturl, $txt, $context, $modSettings, $user_profile, $filter, $smcFunc; |
| 31 | 32 | |
| 32 | 33 | // Viewing contents of a file? |
| 33 | - if (isset($_GET['file'])) |
|
| 34 | - return ViewFile(); |
|
| 34 | + if (isset($_GET['file'])) { |
|
| 35 | + return ViewFile(); |
|
| 36 | + } |
|
| 35 | 37 | |
| 36 | 38 | // Check for the administrative permission to do this. |
| 37 | 39 | isAllowedTo('admin_forum'); |
@@ -85,8 +87,8 @@ discard block |
||
| 85 | 87 | ); |
| 86 | 88 | |
| 87 | 89 | // Set up the filtering... |
| 88 | - if (isset($_GET['value'], $_GET['filter']) && isset($filters[$_GET['filter']])) |
|
| 89 | - $filter = array( |
|
| 90 | + if (isset($_GET['value'], $_GET['filter']) && isset($filters[$_GET['filter']])) { |
|
| 91 | + $filter = array( |
|
| 90 | 92 | 'variable' => $_GET['filter'], |
| 91 | 93 | 'value' => array( |
| 92 | 94 | 'sql' => in_array($_GET['filter'], array('message', 'url', 'file')) ? base64_decode(strtr($_GET['value'], array(' ' => '+'))) : $smcFunc['db_escape_wildcard_string']($_GET['value']), |
@@ -94,10 +96,12 @@ discard block |
||
| 94 | 96 | 'href' => ';filter=' . $_GET['filter'] . ';value=' . $_GET['value'], |
| 95 | 97 | 'entity' => $filters[$_GET['filter']]['txt'] |
| 96 | 98 | ); |
| 99 | + } |
|
| 97 | 100 | |
| 98 | 101 | // Deleting, are we? |
| 99 | - if (isset($_POST['delall']) || isset($_POST['delete'])) |
|
| 100 | - deleteErrors(); |
|
| 102 | + if (isset($_POST['delall']) || isset($_POST['delete'])) { |
|
| 103 | + deleteErrors(); |
|
| 104 | + } |
|
| 101 | 105 | |
| 102 | 106 | // Just how many errors are there? |
| 103 | 107 | $result = $smcFunc['db_query']('', ' |
@@ -112,12 +116,14 @@ discard block |
||
| 112 | 116 | $smcFunc['db_free_result']($result); |
| 113 | 117 | |
| 114 | 118 | // If this filter is empty... |
| 115 | - if ($num_errors == 0 && isset($filter)) |
|
| 116 | - redirectexit('action=admin;area=logs;sa=errorlog' . (isset($_REQUEST['desc']) ? ';desc' : '')); |
|
| 119 | + if ($num_errors == 0 && isset($filter)) { |
|
| 120 | + redirectexit('action=admin;area=logs;sa=errorlog' . (isset($_REQUEST['desc']) ? ';desc' : '')); |
|
| 121 | + } |
|
| 117 | 122 | |
| 118 | 123 | // Clean up start. |
| 119 | - if (!isset($_GET['start']) || $_GET['start'] < 0) |
|
| 120 | - $_GET['start'] = 0; |
|
| 124 | + if (!isset($_GET['start']) || $_GET['start'] < 0) { |
|
| 125 | + $_GET['start'] = 0; |
|
| 126 | + } |
|
| 121 | 127 | |
| 122 | 128 | // Do we want to reverse error listing? |
| 123 | 129 | $context['sort_direction'] = isset($_REQUEST['desc']) ? 'down' : 'up'; |
@@ -127,9 +133,9 @@ discard block |
||
| 127 | 133 | $context['start'] = $_GET['start']; |
| 128 | 134 | |
| 129 | 135 | // Update the error count |
| 130 | - if (!isset($filter)) |
|
| 131 | - $context['num_errors'] = $num_errors; |
|
| 132 | - else |
|
| 136 | + if (!isset($filter)) { |
|
| 137 | + $context['num_errors'] = $num_errors; |
|
| 138 | + } else |
|
| 133 | 139 | { |
| 134 | 140 | // We want all errors, not just the number of filtered messages... |
| 135 | 141 | $query = $smcFunc['db_query']('', ' |
@@ -161,8 +167,9 @@ discard block |
||
| 161 | 167 | for ($i = 0; $row = $smcFunc['db_fetch_assoc']($request); $i++) |
| 162 | 168 | { |
| 163 | 169 | $search_message = preg_replace('~<span class="remove">(.+?)</span>~', '%', $smcFunc['db_escape_wildcard_string']($row['message'])); |
| 164 | - if ($search_message == $filter['value']['sql']) |
|
| 165 | - $search_message = $smcFunc['db_escape_wildcard_string']($row['message']); |
|
| 170 | + if ($search_message == $filter['value']['sql']) { |
|
| 171 | + $search_message = $smcFunc['db_escape_wildcard_string']($row['message']); |
|
| 172 | + } |
|
| 166 | 173 | $show_message = strtr(strtr(preg_replace('~<span class="remove">(.+?)</span>~', '$1', $row['message']), array("\r" => '', '<br>' => "\n", '<' => '<', '>' => '>', '"' => '"')), array("\n" => '<br>')); |
| 167 | 174 | |
| 168 | 175 | $context['errors'][$row['id_error']] = array( |
@@ -221,8 +228,9 @@ discard block |
||
| 221 | 228 | 'members' => count($members), |
| 222 | 229 | ) |
| 223 | 230 | ); |
| 224 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 225 | - $members[$row['id_member']] = $row; |
|
| 231 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
| 232 | + $members[$row['id_member']] = $row; |
|
| 233 | + } |
|
| 226 | 234 | $smcFunc['db_free_result']($request); |
| 227 | 235 | |
| 228 | 236 | // This is a guest... |
@@ -254,20 +262,18 @@ discard block |
||
| 254 | 262 | $id = $filter['value']['sql']; |
| 255 | 263 | loadMemberData($id, false, 'minimal'); |
| 256 | 264 | $context['filter']['value']['html'] = '<a href="' . $scripturl . '?action=profile;u=' . $id . '">' . $user_profile[$id]['real_name'] . '</a>'; |
| 257 | - } |
|
| 258 | - elseif ($filter['variable'] == 'url') |
|
| 259 | - $context['filter']['value']['html'] = '\'' . strtr($smcFunc['htmlspecialchars']((substr($filter['value']['sql'], 0, 1) == '?' ? $scripturl : '') . $filter['value']['sql']), array('\_' => '_')) . '\''; |
|
| 260 | - elseif ($filter['variable'] == 'message') |
|
| 265 | + } elseif ($filter['variable'] == 'url') { |
|
| 266 | + $context['filter']['value']['html'] = '\'' . strtr($smcFunc['htmlspecialchars']((substr($filter['value']['sql'], 0, 1) == '?' ? $scripturl : '') . $filter['value']['sql']), array('\_' => '_')) . '\''; |
|
| 267 | + } elseif ($filter['variable'] == 'message') |
|
| 261 | 268 | { |
| 262 | 269 | $context['filter']['value']['html'] = '\'' . strtr($smcFunc['htmlspecialchars']($filter['value']['sql']), array("\n" => '<br>', '<br />' => '<br>', "\t" => ' ', '\_' => '_', '\\%' => '%', '\\\\' => '\\')) . '\''; |
| 263 | 270 | $context['filter']['value']['html'] = preg_replace('~&lt;span class=&quot;remove&quot;&gt;(.+?)&lt;/span&gt;~', '$1', $context['filter']['value']['html']); |
| 264 | - } |
|
| 265 | - elseif ($filter['variable'] == 'error_type') |
|
| 271 | + } elseif ($filter['variable'] == 'error_type') |
|
| 266 | 272 | { |
| 267 | 273 | $context['filter']['value']['html'] = '\'' . strtr($smcFunc['htmlspecialchars']($filter['value']['sql']), array("\n" => '<br>', '<br />' => '<br>', "\t" => ' ', '\_' => '_', '\\%' => '%', '\\\\' => '\\')) . '\''; |
| 274 | + } else { |
|
| 275 | + $context['filter']['value']['html'] = &$filter['value']['sql']; |
|
| 268 | 276 | } |
| 269 | - else |
|
| 270 | - $context['filter']['value']['html'] = &$filter['value']['sql']; |
|
| 271 | 277 | } |
| 272 | 278 | |
| 273 | 279 | $context['error_types'] = array(); |
@@ -308,10 +314,11 @@ discard block |
||
| 308 | 314 | $context['error_types']['all']['label'] .= ' (' . $sum . ')'; |
| 309 | 315 | |
| 310 | 316 | // Finally, work out what is the last tab! |
| 311 | - if (isset($context['error_types'][$sum])) |
|
| 312 | - $context['error_types'][$sum]['is_last'] = true; |
|
| 313 | - else |
|
| 314 | - $context['error_types']['all']['is_last'] = true; |
|
| 317 | + if (isset($context['error_types'][$sum])) { |
|
| 318 | + $context['error_types'][$sum]['is_last'] = true; |
|
| 319 | + } else { |
|
| 320 | + $context['error_types']['all']['is_last'] = true; |
|
| 321 | + } |
|
| 315 | 322 | |
| 316 | 323 | // And this is pretty basic ;). |
| 317 | 324 | $context['page_title'] = $txt['errlog']; |
@@ -337,21 +344,23 @@ discard block |
||
| 337 | 344 | validateToken('admin-el'); |
| 338 | 345 | |
| 339 | 346 | // Delete all or just some? |
| 340 | - if (isset($_POST['delall']) && !isset($filter)) |
|
| 341 | - $smcFunc['db_query']('truncate_table', ' |
|
| 347 | + if (isset($_POST['delall']) && !isset($filter)) { |
|
| 348 | + $smcFunc['db_query']('truncate_table', ' |
|
| 342 | 349 | TRUNCATE {db_prefix}log_errors', |
| 343 | 350 | array( |
| 344 | 351 | ) |
| 345 | 352 | ); |
| 353 | + } |
|
| 346 | 354 | // Deleting all with a filter? |
| 347 | - elseif (isset($_POST['delall']) && isset($filter)) |
|
| 348 | - $smcFunc['db_query']('', ' |
|
| 355 | + elseif (isset($_POST['delall']) && isset($filter)) { |
|
| 356 | + $smcFunc['db_query']('', ' |
|
| 349 | 357 | DELETE FROM {db_prefix}log_errors |
| 350 | 358 | WHERE ' . $filter['variable'] . ' LIKE {string:filter}', |
| 351 | 359 | array( |
| 352 | 360 | 'filter' => $filter['value']['sql'], |
| 353 | 361 | ) |
| 354 | 362 | ); |
| 363 | + } |
|
| 355 | 364 | // Just specific errors? |
| 356 | 365 | elseif (!empty($_POST['delete'])) |
| 357 | 366 | { |
@@ -397,15 +406,17 @@ discard block |
||
| 397 | 406 | $line = isset($_REQUEST['line']) ? (int) $_REQUEST['line'] : 0; |
| 398 | 407 | |
| 399 | 408 | // Make sure the file we are looking for is one they are allowed to look at |
| 400 | - if ($ext != '.php' || (strpos($file, $real_board) === false && strpos($file, $real_source) === false) || ($basename == 'settings.php' || $basename == 'settings_bak.php') || strpos($file, $real_cache) !== false || !is_readable($file)) |
|
| 401 | - fatal_lang_error('error_bad_file', true, array($smcFunc['htmlspecialchars']($file))); |
|
| 409 | + if ($ext != '.php' || (strpos($file, $real_board) === false && strpos($file, $real_source) === false) || ($basename == 'settings.php' || $basename == 'settings_bak.php') || strpos($file, $real_cache) !== false || !is_readable($file)) { |
|
| 410 | + fatal_lang_error('error_bad_file', true, array($smcFunc['htmlspecialchars']($file))); |
|
| 411 | + } |
|
| 402 | 412 | |
| 403 | 413 | // get the min and max lines |
| 404 | 414 | $min = $line - 20 <= 0 ? 1 : $line - 20; |
| 405 | 415 | $max = $line + 21; // One additional line to make everything work out correctly |
| 406 | 416 | |
| 407 | - if ($max <= 0 || $min >= $max) |
|
| 408 | - fatal_lang_error('error_bad_line'); |
|
| 417 | + if ($max <= 0 || $min >= $max) { |
|
| 418 | + fatal_lang_error('error_bad_line'); |
|
| 419 | + } |
|
| 409 | 420 | |
| 410 | 421 | $file_data = explode('<br />', highlight_php_code($smcFunc['htmlspecialchars'](implode('', file($file))))); |
| 411 | 422 | |