summaryrefslogtreecommitdiff
path: root/index.php
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2001-03-24 17:04:11 +0000
committerDries Buytaert <dries@buytaert.net>2001-03-24 17:04:11 +0000
commit68f2112b4d291edef3b8065ee1bf7a5379e72c6f (patch)
tree15c64525e6a514d7f4458fb24905c58e44e77f52 /index.php
parent10aaea33428ef0757dbc92780f9a755d6d79a90d (diff)
downloadbrdo-68f2112b4d291edef3b8065ee1bf7a5379e72c6f.tar.gz
brdo-68f2112b4d291edef3b8065ee1bf7a5379e72c6f.tar.bz2
- nodified index.php:
the index page will only display stories for now but this will/can change in the near future - all other files now thinks in terms of nodes, rather then stories
Diffstat (limited to 'index.php')
-rw-r--r--index.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/index.php b/index.php
index bd1d6e22c..885fee9f7 100644
--- a/index.php
+++ b/index.php
@@ -3,13 +3,13 @@
include_once "includes/common.inc";
// Initialize/pre-process variables:
-$number = ($user->stories) ? $user->stories : 10;
+$number = ($user->nodes) ? $user->nodes : 10;
$date = ($date > 0) ? $date : time();
// Perform query:
-$result = db_query("SELECT stories.*, users.userid, COUNT(comments.lid) AS comments FROM stories LEFT JOIN comments ON stories.id = comments.lid LEFT JOIN users ON stories.author = users.id WHERE stories.status = 2 ". ($section ? "AND section = '$section' " : "") ."AND stories.timestamp <= $date GROUP BY stories.id ORDER BY stories.timestamp DESC LIMIT $number");
+$result = db_query("SELECT n.*, s.*, u.userid, COUNT(c.lid) AS comments FROM nodes n LEFT JOIN story s ON n.nid = s.node LEFT JOIN comments c ON n.nid = c.lid LEFT JOIN users u ON n.author = u.id WHERE n.status = 2 AND n.type = 'story' ". ($section ? "AND s.section = '$section' " : "") ."AND n.timestamp <= $date GROUP BY n.nid ORDER BY n.timestamp DESC LIMIT $number");
-// Display stories:
+// Display nodes:
$theme->header();
while ($story = db_fetch_object($result)) $theme->story($story);
$theme->footer();