<?php $sql = " select distinct blog_article_id,blog_article.title,blog.name,\n blog_article.post_time, blog.slug as blog_slug,\n market.slug as market_slug, blog_article_tag.iorder, blog_article.content,\n blog_article.media_item_id, person.fname, person.lname, person.username\n from blog_article_tag\n left join blog_article on blog_article_id=blog_article.id\n left join blog on blog_article.blog_id = blog.id\n left join blog_website on blog.id=blog_website.blog_id\n left join market on blog_article.market_id=market.id\n left join person on blog_article.author__person_id=person.id\n where blog_website.status='A'\n and blog_website.website_id={$website_id}\n and lower(blog_article_tag.name) ilike lower('{$current_tag}')\n and blog_article_tag.active=1 and blog_article.active=1\n and blog_article.status='A'\n order by blog_article.post_time desc,blog_article_tag.iorder asc\n limit {$limit}\n offset {$offset}"; $rs = sql($sql); echo "<div id='tag-blog-article-results'>"; if ($rs->EOF) { $last_page = true; include 'noresult.php'; } else { $articles = array(); while (!$rs->EOF) { $articles[] = $rs->fields; $rs->MoveNext(); } $last_page = count($articles) <= $num_per_page; while (count($articles) > $num_per_page) { array_pop($articles); } blog::listing(NULL, NULL, NULL, $articles); } echo "</div>";
/** * controller * * @author Dac Chartrand <*****@*****.**> * @license http://www.fsf.org/licensing/licenses/gpl-3.0.html */ function sux($action, $params = null) { switch ($action) { case 'admin': // -------------------------------------------------------------------- // Admin // -------------------------------------------------------------------- $admin = new blogAdmin(); if ($admin->formValidate($_POST)) { $admin->formProcess($_POST); $admin->formSuccess(); } else { $admin->formBuild($_POST); } break; case 'edit': // -------------------------------------------------------------------- // Edit // -------------------------------------------------------------------- $id = !empty($params[0]) ? $params[0] : null; $edit = new blogEdit($id); if ($edit->formValidate($_POST)) { $edit->formProcess($_POST); $edit->formSuccess(); } else { $edit->formBuild($_POST); } break; case 'bookmarks': // -------------------------------------------------------------------- // Scan for bookmarks // -------------------------------------------------------------------- if (empty($params[0]) || !filter_var($params[0], FILTER_VALIDATE_INT)) { suxFunct::redirect(suxFunct::makeUrl('/blog')); } $bm = new blogBookmarks($params[0]); if ($bm->formValidate($_POST)) { $bm->formProcess($_POST); $bm->formSuccess(); } else { $bm->formBuild($_POST); } break; case 'reply': // -------------------------------------------------------------------- // Reply // -------------------------------------------------------------------- if (empty($params[0]) || !filter_var($params[0], FILTER_VALIDATE_INT)) { suxFunct::redirect(suxFunct::makeUrl('/blog')); } $reply = new blogReply($params[0]); if ($reply->formValidate($_POST)) { $reply->formProcess($_POST); $reply->formSuccess(); } else { $reply->formBuild($_POST); } break; case 'view': // -------------------------------------------------------------------- // View // -------------------------------------------------------------------- if (empty($params[0]) || !filter_var($params[0], FILTER_VALIDATE_INT)) { suxFunct::redirect(suxFunct::makeUrl('/blog')); } $blog = new blog(); $blog->view($params[0]); break; case 'author': // -------------------------------------------------------------------- // Author // -------------------------------------------------------------------- if (empty($params[0])) { suxFunct::redirect(suxFunct::makeUrl('/blog')); } $blog = new blog(); $blog->author($params[0]); break; case 'tag': // -------------------------------------------------------------------- // Tag // -------------------------------------------------------------------- if (empty($params[0])) { suxFunct::redirect(suxFunct::makeUrl('/blog')); } $blog = new blog(); if ($params[0] == 'cloud') { $blog->tagcloud(); } else { $blog->tag($params[0]); } break; case 'category': // -------------------------------------------------------------------- // Category // -------------------------------------------------------------------- if (empty($params[0])) { suxFunct::redirect(suxFunct::makeUrl('/blog')); } $blog = new blog(); $blog->category($params[0]); break; case 'month': // -------------------------------------------------------------------- // Month // -------------------------------------------------------------------- $date = !empty($params[0]) ? $params[0] : date('Y-m-d'); $blog = new blog(); $blog->month($date); break; case 'rss': // -------------------------------------------------------------------- // RSS // -------------------------------------------------------------------- $blog = new blog(); $blog->rss(); break; default: // -------------------------------------------------------------------- // Default // -------------------------------------------------------------------- $blog = new blog(); $blog->listing(); break; } }