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'];