$cat = '';
}
$limit = appconf('limit');
$q = db_query('SELECT * FROM digger_linkstory
WHERE status = "enabled" ' . $cat . '
ORDER BY posted_on desc, score desc');
if ($q->execute()) {
$total = $q->rows();
$res = $q->fetch($cgi->offset, $limit);
$q->free();
} else {
die($q->error());
}
// has voted?
foreach (array_keys($res) as $k) {
if (digger_has_voted($res[$k]->id)) {
$res[$k]->voted = 'style="display: none"';
}
}
// pager
loader_import('saf.GUI.Pager');
$pg = new Pager($cgi->offset, $limit, $total);
$pg->setUrl(site_prefix() . '/index/digger-app?category=' . $cgi->category);
$pg->getInfo();
// output
if (!empty($cgi->category)) {
page_title(appconf('digger_title') . ' - ' . db_shift('select category from digger_category where id = ?', $cgi->category));
} else {
page_title(appconf('digger_title'));
}
template_simple_register('pager', $pg);
<?php
loader_import('digger.Filters');
loader_import('digger.Functions');
$story = db_fetch_array('SELECT * FROM digger_linkstory
WHERE id=?', $parameters['id']);
$comments = db_fetch_array('SELECT * FROM digger_comments
WHERE story=?', $parameters['id']);
if (digger_has_voted($story[0]->id)) {
$story[0]->voted = 'style="display: none"';
}
page_title($story[0]->title);
echo template_simple('comments.spt', array('story' => $story, 'comments' => $comments, 'banned_score' => appconf('ban_threshold')));
