public function index()
{
$this->view->js_link[] = $this->make_link('js', SITE_ASSETS, 'pages/sidebar_search.js');
$this->view->js_link[] = $this->make_link('js', SITE_ASSETS, 'pages/common.js');
// alapbeállítások lekérdezése
$this->view->settings = $this->munkak_model->get_settings();
// 3 legfrissebb munka
$this->view->latest_jobs = $this->munkak_model->jobs_query(3);
$this->view->title = 'Munka diákoknak | Multijob Iskolaszövetkezet.';
$this->view->description = 'Munka diákoknak a Multijob Iskolaszövetkezetnél. Diákmunka az ország több területén.';
$this->view->keywords = 'diákmunka, alkalmi munka, multijob';
// paginator
include LIBS . '/pagine_class.php';
// paginátor objektum létrehozása (paraméter neve, limit)
$pagine = new Paginator('oldal', 9);
// adatok lekérdezése limittel
$this->view->jobs_data = $this->munkak_model->jobs_filter_query($pagine->get_limit(), $pagine->get_offset());
// szűrési feltételeknek megfelelő összes rekord száma
$filter_count = $this->munkak_model->jobs_filter_count_query();
$pagine->set_total($filter_count);
// lapozó linkek
$this->view->pagine_links = $pagine->page_links($this->registry->uri_path);
//$this->view->debug(true);
$this->view->render('munkak/tpl_munkak');
}
public function cat($slug)
{
$pages = new Paginator('10', 'page');
$pages->set_total(count($this->_model->getcatposttotal($slug)));
$data['posts'] = $this->_model->getcatposts($slug, $pages->get_limit());
$data['page_links'] = $pages->page_links();
$data['cats'] = $this->_model->getcats();
$data['title'] = $data['posts'][0]->catTitle;
View::rendertemplate('header', $data);
View::render('blog/cats', $data);
View::rendertemplate('footer', $data);
}
<table>
<tr>
<th>ID</th>
<th>Pseudo</th>
<th>PID</th>
<th>Email</th>
<th style="text-align: center;">Inscription</th>
<th style="text-align: center;">Action</th>
</tr>
<?php
try {
$pages = new Paginator('10', 'p');
$stmt = $db->query('SELECT memberID FROM blog_members');
//pass number of records to
$pages->set_total($stmt->rowCount());
$stmt = $db->query('SELECT memberID,username,pid,email,memberDate FROM blog_members ORDER BY memberID DESC ' . $pages->get_limit());
while ($row = $stmt->fetch()) {
echo '<tr>';
echo '<td>' . $row['memberID'] . '</td>';
echo '<td style="width: 20%;">' . $row['username'] . '</td>';
echo '<td style="font-size: 10px;">' . $row['pid'] . '</td>';
echo '<td style="font-size: 11px;">' . $row['email'] . '</td>';
sscanf($row['memberDate'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde);
echo '<td style="font-size: 10px; text-align: center;">' . $jour . '-' . $mois . '-' . $annee . '</td>';
?>
<td style="text-align: center;">
<a style="text-decoration: none;" href="edit-user.php?id=<?php
echo $row['memberID'];
?>
"><input type="button" class="button" value="Edit." /></a>
</div>
<h1 id="blogheader">The Jungle Times Blog <small>Posts in "<?php
echo $row['catTitle'];
?>
"</small></h1>
<div id="main" class="row">
<div id="posts" class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="row">
<?php
try {
$pages = new Paginator('12', 'p');
$stmt = $db->prepare('SELECT blog_posts.postID FROM blog_posts, blog_cat_cats WHERE blog_posts.postID = blog_cat_cats.postID AND blog_cat_cats.catID = :catID');
$stmt->execute(array(':catID' => $row['catID']));
//pass number of records to
$pages->set_total($stmt->rowCount());
$stmt = $db->prepare('SELECT blog_posts.postID, blog_posts.postTitle, blog_posts.postAuthor, blog_posts.postSlug, blog_posts.postImage, blog_posts.postDescription, blog_posts.postDate FROM blog_posts, blog_cat_cats WHERE blog_posts.postID = blog_cat_cats.postID AND blog_cat_cats.catID = :catID ORDER BY postID DESC ' . $pages->get_limit());
$stmt->execute(array(':catID' => $row['catID']));
$adCount = 3;
while ($row = $stmt->fetch()) {
echo '<div class="postsOuter col-lg-3 col-md-6 col-sm-6 col-xs-12">';
echo '<div class="posts">';
echo '<h2><a href="' . $row['postSlug'] . '">' . $row['postTitle'] . '</a></h2>';
echo '<h4>By <strong>' . $row['postAuthor'] . '</strong> | ' . date('F d, Y', strtotime($row['postDate'])) . ' <br/>';
$stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_cat_cats WHERE blog_cats.catID = blog_cat_cats.catID AND blog_cat_cats.postID = :postID');
$stmt2->execute(array(':postID' => $row['postID']));
$catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC);
$links = array();
if (!empty($catRow)) {
echo 'Tags: ';
} else {
echo ' ';
<br /><br />
<?php
try {
//collect month and year data
$month = htmlentities($_GET['month']);
$year = htmlentities($_GET['year']);
//set from and to dates
$from = date('Y-m-01 00:00:00', strtotime("{$year}-{$month}"));
$to = date('Y-m-31 23:59:59', strtotime("{$year}-{$month}"));
$pages = new Paginator('10', 'p');
$stmt = $db->prepare('SELECT postID FROM blog_posts_seo WHERE postDate >= :from AND postDate <= :to');
$stmt->execute(array(':from' => $from, ':to' => $to));
//pass number of records to
$pages->set_total($stmt->rowCount());
$stmt = $db->prepare('SELECT postID, postTitle, postSlug, postDesc, postDate FROM blog_posts_seo WHERE postDate >= :from AND postDate <= :to ORDER BY postID DESC ' . $pages->get_limit());
$stmt->execute(array(':from' => $from, ':to' => $to));
while ($row = $stmt->fetch()) {
echo '<br /><div><fieldset>';
echo '<span style="font-weight: bold; font-size: 12pt;"><a style="text-decoration: none;" href="' . $row['postSlug'] . '">' . $row['postTitle'] . '</a></span>';
echo '<br />Posté le ' . date('j M Y', strtotime($row['postDate'])) . ', dans ';
$stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_post_cats WHERE blog_cats.catID = blog_post_cats.catID AND blog_post_cats.postID = :postID');
$stmt2->execute(array(':postID' => $row['postID']));
$catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC);
$links = array();
foreach ($catRow as $cat) {
$links[] = "<a href='c-" . $cat['catSlug'] . "'>" . $cat['catTitle'] . "</a>";
}
echo implode(", ", $links);
echo '</div></fieldset>';
}
$stmt = $db->prepare('SELECT blog_posts_seo.postID FROM blog_posts_seo, blog_post_cats WHERE blog_posts_seo.postID = blog_post_cats.postID AND blog_post_cats.catID = :catID');
$stmt->execute(array(':catID' => $row['catID']));
//pass number of records to
$pages->set_total($stmt->rowCount());
$stmt = $db->prepare('
SELECT
blog_posts_seo.postID, blog_posts_seo.postTitle, blog_posts_seo.postSlug, blog_posts_seo.postDesc, blog_posts_seo.postDate
FROM
blog_posts_seo,
blog_post_cats
WHERE
blog_posts_seo.postID = blog_post_cats.postID
AND blog_post_cats.catID = :catID
ORDER BY
postID DESC
' . $pages->get_limit());
$stmt->execute(array(':catID' => $row['catID']));
while ($row = $stmt->fetch()) {
echo '<div>';
echo '<h1><a href="' . $row['postSlug'] . '">' . $row['postTitle'] . '</a></h1>';
echo '<p>Posted on ' . date('jS M Y H:i:s', strtotime($row['postDate'])) . ' in ';
$stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_post_cats WHERE blog_cats.catID = blog_post_cats.catID AND blog_post_cats.postID = :postID');
$stmt2->execute(array(':postID' => $row['postID']));
$catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC);
$links = array();
foreach ($catRow as $cat) {
$links[] = "<a href='c-" . $cat['catSlug'] . "'>" . $cat['catTitle'] . "</a>";
}
echo implode(", ", $links);
echo '</p>';
echo '<p>' . $row['postDesc'] . '</p>';
try {
// On affiche 15 membres par page
$pages = new Paginator('10', 'p');
$stmt = $db->query('SELECT memberID FROM blog_members');
$pages->set_total($stmt->rowCount());
if (isset($_GET['tri'])) {
$tri = htmlentities($_GET['tri']);
} else {
$tri = 'memberID';
}
if (isset($_GET['ordre'])) {
$ordre = htmlentities($_GET['ordre']);
} else {
$ordre = 'DESC';
}
$stmt = $db->query('SELECT * FROM blog_members,xbt_users WHERE blog_members.memberID=xbt_users.uid AND blog_members.username != "visiteur" ORDER BY ' . $tri . ' ' . $ordre . ' ' . $pages->get_limit());
while ($row = $stmt->fetch()) {
// On affiche des couleurs de row alternées
//$tablerow = ++$i % 2 ? 'tableRow1':'tableRow2';
//$x++;
//$tablerow = ($x%2 == 0)? 'tableRow1': 'tableRow2';
//echo '<tr class="'.$tablerow.'">';
echo '<tr>';
if (!empty($row['avatar'])) {
echo '<td style="font-weight: bold; font-size: 14px;"><img src="' . SITEURL . '/images/avatars/' . $row['avatar'] . '" alt="' . $row['username'] . '" style="float: left; margin-right: 5px; width: 30px; height: 30px;" /><a href="admin/profil.php?membre=' . $row['username'] . '">' . $row['username'] . '</a></td>';
} else {
echo '<td style="font-weight: bold; font-size: 14px;"><img src="' . SITEURL . '/images/avatars/avatar.png" alt="' . $row['username'] . '" style="float: left; margin-right: 5px; width: 30px; height: 30px;" /><a href="admin/profil.php?membre=' . $row['username'] . '">' . $row['username'] . '</a></td>';
}
sscanf($row['memberDate'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde);
echo '<td style="font-size: 12px;">' . $jour . '-' . $mois . '-' . $annee . ' à ' . $heure . ':' . $minute . ':' . $seconde . '</td>';
echo '<td style="text-align: center;">' . makesize($row['uploaded']) . '</td>';
echo '<h3>Catégorie ' . $_GET['action'] . '.</h3>';
}
?>
<table>
<tr>
<th>Titre</th>
<th>Action</th>
</tr>
<?php
try {
$pages = new Paginator('10', 'p');
$stmt = $db->query('SELECT catID FROM blog_cats');
//pass number of records to
$pages->set_total($stmt->rowCount());
$stmt = $db->query('SELECT catID, catTitle, catSlug FROM blog_cats ORDER BY catTitle ASC ' . $pages->get_limit());
while ($row = $stmt->fetch()) {
echo '<tr>';
echo '<td style="width: 80%;">' . $row['catTitle'] . '</td>';
?>
<td>
<a style="text-decoration: none;" href="edit-category.php?id=<?php
echo $row['catID'];
?>
"><input type="button" class="button" value="Edit."></a> |
<a style="text-decoration: none;" href="javascript:delcat('<?php
echo $row['catID'];
?>
','<?php
echo $row['catSlug'];
function displayView($view, $id = 0)
{
$tpl_vars = array();
switch ($view) {
case 'about':
break;
case 'config':
$dev_infos = $this->_getPocheVersion('dev');
$dev = trim($dev_infos[0]);
$check_time_dev = date('d-M-Y H:i', $dev_infos[1]);
$prod_infos = $this->_getPocheVersion('prod');
$prod = trim($prod_infos[0]);
$check_time_prod = date('d-M-Y H:i', $prod_infos[1]);
$compare_dev = version_compare(POCHE, $dev);
$compare_prod = version_compare(POCHE, $prod);
$themes = $this->tpl->getInstalledThemes();
$languages = $this->language->getInstalledLanguages();
$token = $this->user->getConfigValue('token');
$http_auth = isset($_SERVER['PHP_AUTH_USER']) || isset($_SERVER['REMOTE_USER']) ? true : false;
$only_user = $this->store->listUsers() > 1 ? false : true;
$tpl_vars = array('themes' => $themes, 'languages' => $languages, 'dev' => $dev, 'prod' => $prod, 'check_time_dev' => $check_time_dev, 'check_time_prod' => $check_time_prod, 'compare_dev' => $compare_dev, 'compare_prod' => $compare_prod, 'token' => $token, 'user_id' => $this->user->getId(), 'http_auth' => $http_auth, 'only_user' => $only_user);
Tools::logm('config view');
break;
case 'edit-tags':
# tags
$entry = $this->store->retrieveOneById($id, $this->user->getId());
if (!$entry) {
$this->messages->add('e', _('Article not found!'));
Tools::logm('error : article not found');
Tools::redirect();
}
$tags = $this->store->retrieveTagsByEntry($id);
$tpl_vars = array('entry_id' => $id, 'tags' => $tags, 'entry' => $entry);
break;
case 'tags':
$token = $this->user->getConfigValue('token');
//if term is set - search tags for this term
$term = Tools::checkVar('term');
$tags = $this->store->retrieveAllTags($this->user->getId(), $term);
if (Tools::isAjaxRequest()) {
$result = array();
foreach ($tags as $tag) {
$result[] = $tag['value'];
}
echo json_encode($result);
exit;
}
$tpl_vars = array('token' => $token, 'user_id' => $this->user->getId(), 'tags' => $tags);
break;
case 'search':
if (isset($_GET['search'])) {
$search = filter_var($_GET['search'], FILTER_SANITIZE_STRING);
$tpl_vars['entries'] = $this->store->search($search, $this->user->getId());
$count = count($tpl_vars['entries']);
$this->pagination->set_total($count);
$page_links = str_replace(array('previous', 'next'), array(_('previous'), _('next')), $this->pagination->page_links('?view=' . $view . '?search=' . $search . '&sort=' . $_SESSION['sort'] . '&'));
$tpl_vars['page_links'] = $page_links;
$tpl_vars['nb_results'] = $count;
$tpl_vars['searchterm'] = $search;
}
break;
case 'view':
$entry = $this->store->retrieveOneById($id, $this->user->getId());
if ($entry != NULL) {
Tools::logm('view link #' . $id);
$content = $entry['content'];
if (function_exists('tidy_parse_string')) {
$tidy = tidy_parse_string($content, array('indent' => true, 'show-body-only' => true), 'UTF8');
$tidy->cleanRepair();
$content = $tidy->value;
}
# flattr checking
$flattr = NULL;
if (FLATTR) {
$flattr = new FlattrItem();
$flattr->checkItem($entry['url'], $entry['id']);
}
# tags
$tags = $this->store->retrieveTagsByEntry($entry['id']);
$tpl_vars = array('entry' => $entry, 'content' => $content, 'flattr' => $flattr, 'tags' => $tags);
} else {
Tools::logm('error in view call : entry is null');
}
break;
default:
# home, favorites, archive and tag views
$tpl_vars = array('entries' => '', 'page_links' => '', 'nb_results' => '', 'listmode' => isset($_COOKIE['listmode']) ? true : false);
//if id is given - we retrieve entries by tag: id is tag id
if ($id) {
$tpl_vars['tag'] = $this->store->retrieveTag($id, $this->user->getId());
$tpl_vars['id'] = intval($id);
}
$count = $this->store->getEntriesByViewCount($view, $this->user->getId(), $id);
if ($count > 0) {
$this->pagination->set_total($count);
$page_links = str_replace(array('previous', 'next'), array(_('previous'), _('next')), $this->pagination->page_links('?view=' . $view . '&sort=' . $_SESSION['sort'] . ($id ? '&id=' . $id : '') . '&'));
$tpl_vars['entries'] = $this->store->getEntriesByView($view, $this->user->getId(), $this->pagination->get_limit(), $id);
$tpl_vars['page_links'] = $page_links;
$tpl_vars['nb_results'] = $count;
}
Tools::logm('display ' . $view . ' view');
break;
}
return $tpl_vars;
}
//echo $pages->page_links('?membre='.$row['username'].'&');
echo $pages->page_links('?membre=' . $row['username'] . '&tri=' . $tri . '&ordre=' . $ordre . '&');
echo '</div>';
?>
<br />
<!-- Messages internes -->
<?php
$pages = new Paginator('5', 'm');
$stmt = $db->prepare('SELECT messages_id FROM blog_messages WHERE messages_id_destinataire = :destinataire');
$stmt->execute(array(':destinataire' => $row['memberID']));
$pages->set_total($stmt->rowCount());
// on prépare une requete SQL cherchant le titre, la date, l'expéditeur des messages pour le membre connecté
$stmt = $db->prepare('SELECT blog_messages.messages_titre, blog_messages.messages_date, blog_members.username as expediteur, blog_messages.messages_id as id_message FROM blog_messages, blog_members WHERE blog_messages.messages_id_destinataire = :id_destinataire AND blog_messages.messages_id_expediteur = blog_members.memberID ORDER BY blog_messages.messages_date DESC ' . $pages->get_limit());
$stmt->execute(array(':id_destinataire' => $row['memberID']));
?>
<table>
<tr>
<td colspan="5">
<h3 id="messages">Vos messages :
<a style="text-decoration: none;" href="<?php
echo SITEURL;
?>
/messages_envoyer.php"><input type="button" class="button" value="Envoyer un message à un membre" /></a>
</h3>
</td>
</tr>
<tr>
</div>
<?php
}
*/
?>
<br />
<div><h2>Les derniers torrents</h2></div>
<?php
try {
$pages = new Paginator('7', 'p');
$stmt = $db->query('SELECT postID FROM blog_posts_seo');
//pass number of records to
$pages->set_total($stmt->rowCount());
$stmt = $db->query('SELECT postID,postTitle,postAuthor,postSlug,postDesc,postDate,postImage,postViews FROM blog_posts_seo ORDER BY postID DESC ' . $pages->get_limit());
while ($row = $stmt->fetch()) {
echo '<fieldset>';
echo '<div style="margin-top: 10px;">';
echo '<span style="font-size: 17px; font-weight: bold; padding: 5px 0 0 10px;"><a style="text-decoration: none; color: black;" href="' . stripslashes(htmlspecialchars($row['postSlug'])) . '">' . stripslashes(htmlspecialchars($row['postTitle'])) . '</a></span><br />';
sscanf($row['postDate'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde);
echo '<span style="font-size: 7pt; padding: 5px 0 0 10px;">';
echo '<img src="images/date.png" style="vertical-align: bottom; margin-top: 5px;" alt="Date" /> ' . $jour . '-' . $mois . '-' . $annee . ' <img src="images/meta-separator.png" style="margin-left: 4px; margin-right: 4px;" alt="" /> <img src="images/author.png" style="vertical-align: bottom;" alt="Auteur" />';
echo '<a style="text-decoration: none;" href="' . SITEURL . '/admin/profil.php?membre=' . stripslashes(htmlspecialchars($row['postAuthor'])) . '">' . stripslashes(htmlspecialchars($row['postAuthor'])) . '</a>';
$stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_post_cats WHERE blog_cats.catID = blog_post_cats.catID AND blog_post_cats.postID = :postID');
$stmt2->execute(array(':postID' => $row['postID']));
$catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC);
$links = array();
foreach ($catRow as $cat) {
$links[] = "<a style=\"text-decoration: none;\" href='c-" . htmlspecialchars($cat['catSlug']) . "'>" . htmlspecialchars($cat['catTitle']) . "</a>";
}
function displayView($view, $id = 0)
{
$tpl_vars = array();
switch ($view) {
case 'about':
break;
case 'config':
$dev_infos = $this->_getPocheVersion('dev');
$dev = trim($dev_infos[0]);
$check_time_dev = date('d-M-Y H:i', $dev_infos[1]);
$prod_infos = $this->_getPocheVersion('prod');
$prod = trim($prod_infos[0]);
$check_time_prod = date('d-M-Y H:i', $prod_infos[1]);
$compare_dev = version_compare(POCHE, $dev);
$compare_prod = version_compare(POCHE, $prod);
$themes = $this->tpl->getInstalledThemes();
$languages = $this->language->getInstalledLanguages();
$token = $this->user->getConfigValue('token');
$http_auth = isset($_SERVER['REMOTE_USER']);
$only_user = $this->store->listUsers() > 1 ? false : true;
$https = substr(Tools::getPocheUrl(), 0, 5) == 'https';
$tpl_vars = array('themes' => $themes, 'languages' => $languages, 'dev' => $dev, 'prod' => $prod, 'check_time_dev' => $check_time_dev, 'check_time_prod' => $check_time_prod, 'compare_dev' => $compare_dev, 'compare_prod' => $compare_prod, 'token' => $token, 'user_id' => $this->user->getId(), 'http_auth' => $http_auth, 'only_user' => $only_user, 'https' => $https);
Tools::logm('config view');
break;
case 'edit-tags':
# tags
$entry = $this->store->retrieveOneById($id, $this->user->getId());
if (!$entry) {
$this->messages->add('e', _('Article not found!'));
Tools::logm('error : article not found');
Tools::redirect();
}
$tags = $this->store->retrieveTagsByEntry($id);
$all_tags = $this->store->retrieveAllTags($this->user->getId());
$maximus = 0;
foreach ($all_tags as $eachtag) {
// search for the most times a tag is present
if ($eachtag["entriescount"] > $maximus) {
$maximus = $eachtag["entriescount"];
}
}
foreach ($all_tags as $key => $eachtag) {
// get the percentage of presence of each tag
$percent = floor($eachtag["entriescount"] / $maximus * 100);
if ($percent < 20) {
// assign a css class, depending on the number of entries count
$cssclass = 'smallesttag';
} elseif ($percent >= 20 and $percent < 40) {
$cssclass = 'smalltag';
} elseif ($percent >= 40 and $percent < 60) {
$cssclass = 'mediumtag';
} elseif ($percent >= 60 and $percent < 80) {
$cssclass = 'largetag';
} else {
$cssclass = 'largesttag';
}
$all_tags[$key]['cssclass'] = $cssclass;
}
$tpl_vars = array('entry_id' => $id, 'tags' => $tags, 'alltags' => $all_tags, 'entry' => $entry);
break;
case 'tags':
$token = $this->user->getConfigValue('token');
//if term is set - search tags for this term
$term = Tools::checkVar('term');
$tags = $this->store->retrieveAllTags($this->user->getId(), $term);
if (Tools::isAjaxRequest()) {
$result = array();
foreach ($tags as $tag) {
$result[] = $tag['value'];
}
echo json_encode($result);
exit;
}
$tpl_vars = array('token' => $token, 'user_id' => $this->user->getId(), 'tags' => $tags);
break;
case 'search':
if (isset($_GET['search'])) {
$search = filter_var($_GET['search'], FILTER_SANITIZE_STRING);
$tpl_vars['entries'] = $this->store->search($search, $this->user->getId());
$count = count($tpl_vars['entries']);
$this->pagination->set_total($count);
$page_links = str_replace(array('previous', 'next'), array(_('previous'), _('next')), $this->pagination->page_links('?view=' . $view . '?search=' . $search . '&sort=' . $_SESSION['sort'] . '&'));
$tpl_vars['page_links'] = $page_links;
$tpl_vars['nb_results'] = $count;
$tpl_vars['searchterm'] = $search;
}
break;
case 'view':
$entry = $this->store->retrieveOneById($id, $this->user->getId());
if ($entry != NULL) {
Tools::logm('view link #' . $id);
$content = $entry['content'];
if (function_exists('tidy_parse_string')) {
$tidy = tidy_parse_string($content, array('indent' => true, 'show-body-only' => true), 'UTF8');
$tidy->cleanRepair();
$content = $tidy->value;
}
# flattr checking
$flattr = NULL;
if (FLATTR) {
$flattr = new FlattrItem();
$flattr->checkItem($entry['url'], $entry['id']);
}
# previous and next
$previous = FALSE;
$previous_id = $this->store->getPreviousArticle($id, $this->user->getId());
$next = FALSE;
$next_id = $this->store->getNextArticle($id, $this->user->getId());
if ($this->store->retrieveOneById($previous_id, $this->user->getId())) {
$previous = TRUE;
}
if ($this->store->retrieveOneById($next_id, $this->user->getId())) {
$next = TRUE;
}
$navigate = array('previous' => $previous, 'previousid' => $previous_id, 'next' => $next, 'nextid' => $next_id);
# tags
$tags = $this->store->retrieveTagsByEntry($entry['id']);
$tpl_vars = array('entry' => $entry, 'content' => $content, 'flattr' => $flattr, 'tags' => $tags, 'navigate' => $navigate);
} else {
Tools::logm('error in view call : entry is null');
}
break;
default:
# home, favorites, archive and tag views
$tpl_vars = array('entries' => '', 'page_links' => '', 'nb_results' => '', 'listmode' => isset($_COOKIE['listmode']) ? true : false, 'view' => $view);
//if id is given - we retrieve entries by tag: id is tag id
if ($id) {
$tpl_vars['tag'] = $this->store->retrieveTag($id, $this->user->getId());
$tpl_vars['id'] = intval($id);
}
$count = $this->store->getEntriesByViewCount($view, $this->user->getId(), $id);
if ($count && $count > 0) {
$this->pagination->set_total($count);
$page_links = str_replace(array('previous', 'next'), array(_('previous'), _('next')), $this->pagination->page_links('?view=' . $view . '&sort=' . $_SESSION['sort'] . ($id ? '&id=' . $id : '') . '&'));
$tpl_vars['entries'] = $this->store->getEntriesByView($view, $this->user->getId(), $this->pagination->get_limit(), $id);
$tpl_vars['page_links'] = $page_links;
$tpl_vars['nb_results'] = $count;
}
Tools::logm('display ' . $view . ' view');
break;
}
return $tpl_vars;
}
</h1>
<h2>days until Auburn Basketball<br/><em>November 13, 2015 vs UAB</em></h2>
</div>
</div>
</div>
<div id="wrapper" class="container-fluid">
<div id="main" class="row">
<div id="posts-outer" class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="row">
<?php
try {
$pages = new Paginator('12', 'p');
$stmt = $db->query('SELECT postID FROM blog_posts');
//pass number of records to
$pages->set_total($stmt->rowCount());
$stmt = $db->query('SELECT postID, postAuthor, postTitle, postImage, postSlug, postDescription, postDate FROM blog_posts ORDER BY postID DESC ' . $pages->get_limit());
$adCount = 3;
while ($row = $stmt->fetch()) {
echo '<div class="postsOuter col-lg-3 col-md-6 col-sm-6 col-xs-12">';
echo '<div class="posts">';
echo '<h2><a href="' . $row['postSlug'] . '">' . $row['postTitle'] . '</a></h2>';
echo '<h4>By <strong>' . $row['postAuthor'] . '</strong> | ' . date('F d, Y', strtotime($row['postDate'])) . ' <br/>';
$stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_cat_cats WHERE blog_cats.catID = blog_cat_cats.catID AND blog_cat_cats.postID = :postID');
$stmt2->execute(array(':postID' => $row['postID']));
$catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC);
$links = array();
if (!empty($catRow)) {
echo 'Tags: ';
} else {
echo ' ';
}
echo '<h3>Licence ' . $_GET['action'] . '.</h3>';
}
?>
<table>
<tr>
<th>Titre</th>
<th>Action</th>
</tr>
<?php
try {
$pages = new Paginator('10', 'p');
$stmt = $db->query('SELECT licenceID FROM blog_licences');
//pass number of records to
$pages->set_total($stmt->rowCount());
$stmt = $db->query('SELECT licenceID, licenceTitle, licenceSlug FROM blog_licences ORDER BY licenceTitle ASC ' . $pages->get_limit());
while ($row = $stmt->fetch()) {
echo '<tr>';
echo '<td style="width: 80%;">' . $row['licenceTitle'] . '</td>';
?>
<td>
<a style="text-decoration: none;" href="edit-licence.php?id=<?php
echo $row['licenceID'];
?>
"><input type="button" class="button" value="Edit."</a> |
<a style="text-decoration: none;" href="javascript:dellicence('<?php
echo $row['licenceID'];
?>
','<?php
echo $row['licenceSlug'];
