From d0060968b77c39bdf8abffb071c971c166b59edb Mon Sep 17 00:00:00 2001
From: Nicolas BERNSTEIN <alexis211@gmail.com>
Date: Sat, 17 Sep 2011 16:48:29 +0200
Subject: First commit.

---
 lib/notes/index.php | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 lib/notes/index.php

(limited to 'lib/notes/index.php')

diff --git a/lib/notes/index.php b/lib/notes/index.php
new file mode 100644
index 0000000..3c81f46
--- /dev/null
+++ b/lib/notes/index.php
@@ -0,0 +1,9 @@
+<?php
+
+$users = array();
+$n = sql("SELECT account.id AS id, login AS name, COUNT(notes.id) AS nbNotes FROM account ".
+	"LEFT JOIN notes ON notes.owner = account.id ".
+	"WHERE notes.public != 0 AND notes.id != 0 ".
+	"GROUP BY account.id ORDER BY nbNotes DESC");
+while ($nn = mysql_fetch_assoc($n)) $users[] = $nn;
+require("tpl/notes/index.php");
-- 
cgit v1.2.3