diff options
| -rw-r--r-- | inc/functions.php | 21 | ||||
| -rw-r--r-- | mod.php | 10 |
2 files changed, 31 insertions, 0 deletions
diff --git a/inc/functions.php b/inc/functions.php index 56bb011e..d5295b16 100644 --- a/inc/functions.php +++ b/inc/functions.php @@ -207,17 +207,29 @@ } function openBoard($uri) { + global $config; + if($config['cache']['enabled'] && ($board = cache::get('board_' . $uri))) { + setupBoard($board); + return true; + } + $query = prepare("SELECT * FROM `boards` WHERE `uri` = :uri LIMIT 1"); $query->bindValue(':uri', $uri); $query->execute() or error(db_error($query)); if($board = $query->fetch()) { + if($config['cache']['enabled']) + cache::set('board_' . $uri, $board); setupBoard($board); return true; } else return false; } function boardTitle($uri) { + if($config['cache']['enabled'] && ($board = cache::get('board_' . $uri))) { + return $board['title']; + } + $query = prepare("SELECT `title` FROM `boards` WHERE `uri` = :uri LIMIT 1"); $query->bindValue(':uri', $uri); $query->execute() or error(db_error($query)); @@ -337,8 +349,17 @@ } function listBoards() { + global $config; + + if($config['cache']['enabled'] && ($boards = cache::get('all_boards'))) + return $boards; + $query = query("SELECT * FROM `boards` ORDER BY `uri`") or error(db_error()); $boards = $query->fetchAll(); + + if($config['cache']['enabled']) + cache::set('all_boards', $boards); + return $boards; } @@ -1415,6 +1415,11 @@ $query->bindValue(':id', $board['id'], PDO::PARAM_INT); $query->execute() or error(db_error($query)); + if($config['cache']['enabled']) { + cache::delete('board_' . $board['uri']); + cache::delete('all_boards'); + } + rebuildThemes('boards'); header('Location: ?/', true, $config['redirect_http']); @@ -1431,6 +1436,11 @@ $query->bindValue(':id', $board['id'], PDO::PARAM_INT); $query->execute() or error(db_error($query)); + if($config['cache']['enabled']) { + cache::delete('board_' . $board['uri']); + cache::delete('all_boards'); + } + rebuildThemes('boards'); openBoard($board['uri']); |