home » zplus/freepost.git
ID: 4265120ddc72d54e10bef4675fe2e1b77c428e1f
30 lines — 629B — View raw


<?php

require_once 'session.php';
require_once 'database.php';
require_once 'date.php';
require_once 'twig.php';

// Open database connection
$db = new Database();
$db->connect();

// Retrieve list of posts
if (isset ($_GET['new']))
    $posts = $db->get_new_posts();
else
    $posts = $db->get_hot_posts();

// Retrieve a list of user votes for the posts
$IDs = array();

foreach ($posts as $post)
    $IDs[] = $post['id'];

$votes = $db->get_posts_votes (implode (',', $IDs), Session::get_userid ());

// Render template
echo $twig->render (
    'index.twig',
    array(
        'posts' => $posts,
        'votes' => $votes));