X-Git-Url: https://git.bts.cx/cx.git/blobdiff_plain/90ca6ec629e37ba5f6767a60b65e5bbfa452cee4..8a7cb090b52893c49c169d4ba1419317251bfaaa:/cx/lib/posts.php?ds=sidebyside diff --git a/cx/lib/posts.php b/cx/lib/posts.php index 9fb4e35..3293ace 100644 --- a/cx/lib/posts.php +++ b/cx/lib/posts.php @@ -211,30 +211,43 @@ function cx_posts_find_post($post_id) { return null; } -function cx_posts_find_article_id($post_slug) { +function cx_posts_find_article_id($post_slug, bool $include_drafts = false) { $sql = 'SELECT post_id FROM posts WHERE post_slug == ? - AND post_is_page == FALSE - AND post_is_draft == FALSE - LIMIT 1;'; + AND post_is_page == FALSE'; + + if ($include_drafts == false) { + $sql .= ' AND post_is_draft == FALSE'; + } + + $sql .= ' LIMIT 1'; + + $sql .= ';'; foreach (cx_db_query($sql, $post_slug) as $post) { return $post['post_id']; } return null; + } -function cx_posts_find_page_id($post_slug) { +function cx_posts_find_page_id($post_slug, bool $include_drafts = false) { $sql = 'SELECT post_id FROM posts WHERE post_slug == ? - AND post_is_page == TRUE - AND post_is_draft == FALSE - LIMIT 1;'; + AND post_is_page == TRUE'; + + if ($include_drafts == false) { + $sql .= ' AND post_is_draft == FALSE'; + } + + $sql .= ' LIMIT 1'; + + $sql .= ';'; foreach (cx_db_query($sql, $post_slug) as $post) { return $post['post_id'];