diff options
Diffstat (limited to 'index.php')
-rw-r--r-- | index.php | 8 |
1 files changed, 4 insertions, 4 deletions
@@ -2,20 +2,20 @@ include "includes/common.inc"; -### Security check: +// Security check: if (strstr($number, " ") || strstr($date, " ")) { watchdog("error", "main page: attempt to provide malicious input through URI"); exit(); } -### Initialize/pre-process variables: +// Initialize/pre-process variables: $number = ($user->stories) ? $user->stories : 10; $date = ($date) ? $date : time(); -### Perform query: +// Perform query: $result = db_query("SELECT stories.*, users.userid, COUNT(comments.sid) AS comments FROM stories LEFT JOIN comments ON stories.id = comments.sid LEFT JOIN users ON stories.author = users.id WHERE stories.status = 2 AND stories.timestamp <= $date GROUP BY stories.id ORDER BY stories.timestamp DESC LIMIT $number"); -### Display stories: +// Display stories: $theme->header(); while ($story = db_fetch_object($result)) $theme->abstract($story); $theme->footer(); |