From 24547ccec6526fcef3cccb34bc35fb81f31236b3 Mon Sep 17 00:00:00 2001
From: Nicolas BERNSTEIN <alexis211@gmail.com>
Date: Sun, 12 Feb 2012 19:50:55 +0100
Subject: A lot of changes : blogging system essentially.

---
 lib/blog/drafts.php | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 lib/blog/drafts.php

(limited to 'lib/blog/drafts.php')

diff --git a/lib/blog/drafts.php b/lib/blog/drafts.php
new file mode 100644
index 0000000..735b039
--- /dev/null
+++ b/lib/blog/drafts.php
@@ -0,0 +1,19 @@
+<?php
+
+$title = "My posts";
+
+$drafts = array();
+$pub = array();
+
+$r = sql(
+	"SELECT id, title, text_html, draft FROM blog_posts WHERE owner = " . $user['id'] . " ORDER BY date DESC"
+	);
+while ($pp = mysql_fetch_assoc($r)) {
+	if ($pp['draft']) {
+		$drafts[] = $pp;
+	} else {
+		$pub[] = $pp;
+	}
+}
+
+require("tpl/blog/drafts.php");
-- 
cgit v1.2.3