diff options
| author | PayBas <contact@paybas.com> | 2014-04-14 15:48:17 +0200 |
|---|---|---|
| committer | PayBas <contact@paybas.com> | 2014-09-15 14:43:38 +0200 |
| commit | ae63843647d309d2deb2863189699212e9a3aa27 (patch) | |
| tree | 6af15dcf23f0366aa7ff68312c1c643fabc4965a /phpBB/includes/acp | |
| parent | 265c621c9ede226cf50140057c5184245d4bf779 (diff) | |
| download | forums-ae63843647d309d2deb2863189699212e9a3aa27.tar forums-ae63843647d309d2deb2863189699212e9a3aa27.tar.gz forums-ae63843647d309d2deb2863189699212e9a3aa27.tar.bz2 forums-ae63843647d309d2deb2863189699212e9a3aa27.tar.xz forums-ae63843647d309d2deb2863189699212e9a3aa27.zip | |
[ticket/12408] Simplified queries
PHPBB3-12408
Diffstat (limited to 'phpBB/includes/acp')
| -rw-r--r-- | phpBB/includes/acp/acp_board.php | 22 |
1 files changed, 7 insertions, 15 deletions
diff --git a/phpBB/includes/acp/acp_board.php b/phpBB/includes/acp/acp_board.php index cd3d2aa8ff..fd09cab94c 100644 --- a/phpBB/includes/acp/acp_board.php +++ b/phpBB/includes/acp/acp_board.php @@ -930,21 +930,13 @@ class acp_board $style = false; - $sql_array = array( - 'SELECT' => 'u.user_style', - 'FROM' => array( - USERS_TABLE => 'u', - ), - 'WHERE' => 'u.user_id = ' . ANONYMOUS, - ); - - $sql = $db->sql_build_query('SELECT', $sql_array); + $sql = 'SELECT u.user_style + FROM ' . USERS_TABLE . ' u + WHERE u.user_id = ' . ANONYMOUS; $result = $db->sql_query_limit($sql, 1); - while ($row = $db->sql_fetchrow($result)) - { - $style = (isset($row['user_style'])) ? $row['user_style'] : false; - } + $style = (int) $db->sql_fetchfield('user_style'); + $db->sql_freeresult($result); return $style; } @@ -961,8 +953,8 @@ class acp_board ); $sql = 'UPDATE ' . USERS_TABLE . ' - SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' - WHERE user_id = ' . ANONYMOUS; + SET user_style = ' . $style_id . ' + WHERE user_id = ' . ANONYMOUS; $db->sql_query($sql); } |