Order pages asc

[cx.git] / cx / lib / posts.php

diff --git a/cx/lib/posts.php b/cx/lib/posts.php
index 64374333e6636212486f084cd7c838c6016a2b96..8ce6e6bf6a9ad923fe879f4cfac6e45807c56b34 100644 (file)
--- a/cx/lib/posts.php
+++ b/cx/lib/posts.php
@@ -19,6 +19,7 @@ class Post {
        public $title;
        public $slug;
        public $date;
        public $title;
        public $slug;
        public $date;

+       public $is_page;

        public $is_draft;
        public $data;
        public $html_content;
        public $is_draft;
        public $data;
        public $html_content;


@@ -29,6 +30,7 @@ class Post {
                $this->title = $dict['post_title'];
                $this->slug = $dict['post_slug'];
                $this->date = $dict['post_date'];
                $this->title = $dict['post_title'];
                $this->slug = $dict['post_slug'];
                $this->date = $dict['post_date'];

+               $this->is_page = $dict['post_is_page'];

                $this->is_draft = $dict['post_is_draft'];
                $this->data = $dict['post_data'];
                $this->html_content = cx_markdown_generate_html($this->data);
                $this->is_draft = $dict['post_is_draft'];
                $this->data = $dict['post_data'];
                $this->html_content = cx_markdown_generate_html($this->data);


@@ -244,7 +246,7 @@ function cx_pages_get() {
                FROM posts
                WHERE post_is_page == TRUE
                AND post_is_draft == FALSE
                FROM posts
                WHERE post_is_page == TRUE
                AND post_is_draft == FALSE

-               ORDER BY post_creation_time DESC;';
+               ORDER BY post_creation_time ASC;';

 
        foreach (cx_db_query($sql) as $post) {
                $p = new Post($post);
 
        foreach (cx_db_query($sql) as $post) {
                $p = new Post($post);