function category($id, $menuId, $fp = null)
{
//validation page type
$categoryName = $categoryDesc = null;
$label = app_param('label');
if ($id > 0) {
$flag = FQuery("pustaka_category", "id={$id}", '', 1);
} else {
if (!empty($label)) {
$label = app_param('label');
$label = str_replace("-", " ", $label);
$label = "AND tags LIKE '%" . $label . "%' ";
}
$flag = true;
}
//if page type is valid
if ($flag) {
$db = new FQuery();
$db->connect();
/************** Parameter Page ***************/
$per_page = 10;
$categoryId = $id;
if (empty($param)) {
$show_panel = 1;
$per_page = 10;
}
if (url_param('feed') == 'rss') {
$per_page = 10;
$pages = url_param('page');
if ($pages != null) {
$link = str_replace("?page={$pages}", "", getUrl());
redirect("{$link}?feed=rss");
}
}
if (isset($label)) {
$per_page = 10;
}
if (empty($per_page)) {
$per_page = 10;
}
//$fp is default page
if (!isset($fp) and !isset($label)) {
$categoryName = oneQuery('pustaka_category', 'id', $categoryId, 'name');
$categoryDesc = oneQuery('pustaka_category', 'id', $categoryId, 'description');
}
$level_access = Level_Access;
//$if category id is not found
if (!$categoryId and !isset($fp) and !isset($label)) {
echo pustaka_Page_Notfound;
} else {
if (isset($categoryName)) {
$whereCat = "AND category = {$categoryId}";
} else {
$whereCat = null;
}
//call paging class
loadPaging();
$paging = new paging();
$rowsPerPage = $per_page;
//paging results
$result = $paging->pagerQuery(FDBPrefix . 'pustaka_file', "*", "status=1 {$whereCat} {$label}", 'id DESC', $rowsPerPage);
$no = 0;
//count rows
$jml = mysql_affected_rows();
while ($qr = mysql_fetch_array($result)) {
/********** File Author ***********/
$author = $qr['author'];
/********** File Category ***********/
$catlink = categoryLink($qr['category']);
$category = oneQuery('pustaka_category', 'id', $qr['category'], 'name');
$category = "<a href='{$catlink}' title='See more {$category}'>{$category}</a>";
/********** pdf Link ***********/
$flink = "?app=pdf&view=item&id={$qr['id']}";
$link = make_permalink($flink, Page_ID);
$title = "<a href='{$link}'>{$qr['title']}</a>";
/********** File Labels ***********/
$labels = labelToLink($qr['tags']);
/********** File Compability ***********/
$this->perrows = $jml;
$this->show_panel = $show_panel;
$this->category[$no] = $category;
$this->catlink[$no] = $catlink;
$this->author[$no] = $author;
$this->title[$no] = $title;
$this->link[$no] = $link;
$this->labels[$no] = $labels;
$this->date[$no] = $qr['year'];
$this->hits[$no] = $qr['hits'];
$this->desc[$no] = $qr['description'];
if (url_param('feed') == 'rss' and url_param('feed') == 'rss' or app_param('label')) {
$this->description[$no] = $qr['description'];
}
if (defined('SEF_URL')) {
$link = link_paging('?');
} else {
if (checkhomepage()) {
$link = "?";
} else {
$link = "?app=pdf&view=category&id={$categoryId}";
$link = make_permalink($link, Page_ID);
$link = $link . "&";
}
}
$no++;
}
if ($no == 0) {
echo "<h1 style='margin:20px auto'>Pustaka Kosong !!!!</h1>";
}
//start paging links
$db->select(FDBPrefix . 'pustaka_file', '*', "status=1 {$whereCat} {$level_access}");
$jml = mysql_affected_rows();
if ($jml > $rowsPerPage) {
$pagelink = $paging->createPaging($link);
} else {
$pagelink = null;
}
//send paging var relsult
$this->pglink = $pagelink;
//if parameter found rss page
if (url_param('feed') == 'rss' and url_param('feed') == 'rss' or app_param('label')) {
$this->catName = $categoryName;
$this->catDesc = $categoryDesc;
}
}
} else {
pustaka_Page_Notfound;
}
}
function item($q, $menuId)
{
/* Call new FQuery */
$db = new FQuery();
$db->connect();
/* Set Access_Level */
$accessLevel = Level_Access;
$q = str_replace("'", "", $q);
$q = str_replace("/", "", $q);
$q = str_replace("\\", "", $q);
$q = str_replace('"', "", $q);
$q = str_replace(' ', " ", $q);
if (empty($q)) {
$q = $_SESSION['search'];
}
/* Call new paging */
loadPaging();
$paging = new paging();
$rowsPerPage = 10;
$keyword = trim($q);
//remove space before and after
$article = explode_query($q, 'article');
$title = explode_query($q, 'title');
$author = explode_query($q, 'author');
$tag = explode_query($q, 'tags');
$condition = "{$article} {$title} {$author} {$tag}";
$user = FQuery('user', "`name` LIKE '%{$q}%'", 'id');
/* Check total article by query */
FQuery('article', "status=1 AND (`author_id` ='{$user}' {$condition}) {$accessLevel}");
$total = mysql_affected_rows();
/* paging query */
$result = $paging->pagerQuery(FDBPrefix . 'article', "*,DATE_FORMAT(date,'%d %M %Y') as date,DATE_FORMAT(date,'%Y-%m-%d %H:%i:%s') as order_date", "status=1 AND (`author_id` ='{$user}' {$condition}) \n\t\t{$accessLevel}", 'order_date DESC', $rowsPerPage);
$no = 0;
$jml = mysql_affected_rows();
while ($qr = mysql_fetch_array($result)) {
//category
$category = oneQuery('article_category', 'id', $qr['category'], 'name');
$catlink = make_permalink("?app=article&view=category&id={$qr['category']}");
//autho
if (!empty($qr['author_id'])) {
if (!empty($qr['author'])) {
$author = $qr['author'];
} else {
$author = oneQuery('user', 'id', $qr['author_id'], 'name');
}
} else {
$author = "Administrator";
}
$strpos = 0;
$article = stripTags($qr['article']);
$article2 = strtolower($article);
$strpos = strpos("{$article2}", "{$q}");
$query = str_replace(", ", ",", $q);
$query = str_replace(" ,", ",", $q);
$query = trim($query);
if (strpos($query, ",")) {
$query = explode(",", $query);
} else {
$query = explode(" ", $q);
}
$i = 0;
$z = '';
$y = '';
foreach ($query as $v) {
$y[$i] = $v;
$i++;
}
for ($n = $i * $i - 1; $n >= 0; $n--) {
}
if ($strpos >= 40) {
$strpos = $strpos - 40;
$article2 = substr("{$article2}", $strpos);
$strpos2 = strpos("{$article2}", " ");
$article = substr("{$article}", $strpos + $strpos2);
$article = "..." . $article;
}
$article = cutWords($article, 35);
$article .= "...";
$link = "?app=article&view=item&id={$qr['id']}";
$link = make_permalink($link, Page_ID);
$qr['title'] = search_match($qr['title'], $q);
$article = search_match($article, $q);
$author = search_match($author, $q);
$category = search_match($category, $q);
$title = "<a href=\"{$link}\">{$qr['title']}</a>";
$readmore = null;
$this->category[$no] = $category;
$this->catlink[$no] = $catlink;
$this->readmore[$no] = $readmore;
$this->author[$no] = $author;
$this->title[$no] = $title;
$this->date[$no] = $qr['date'];
$this->article[$no] = $article;
$this->perrows = $jml;
$this->total = $total;
if (defined('SEF_URL')) {
$link = link_paging('?');
} else {
$link = "?app=article&view=category&id={$categoryId}";
$link = make_permalink($link, Page_ID);
$link = $link . "&";
}
$no++;
}
FQuery('article', "status=1 AND (`author_id` ='{$user}' {$condition}) {$accessLevel}");
$jml = mysql_affected_rows();
if ($jml > $rowsPerPage) {
$pagelink = $paging->createPaging($link);
} else {
$pagelink = null;
}
if (strpos(getUrl(), '?q')) {
$pagelink = str_replace("?page=", "&page=", $pagelink);
}
$this->pglink = $pagelink;
}
function category($id, $fp = null)
{
$db = new FQuery();
$db->connect();
$param = oneQuery('menu', 'id', Page_ID, 'parameter');
$show_panel = mod_param('show_name', $param);
$read_more = mod_param('read_more', $param);
$per_page = mod_param('per_page', $param);
$this->sname = mod_param('show_name', $param);
$this->sgroup = mod_param('show_group', $param);
$this->sgender = mod_param('show_gender', $param);
$this->saddress = mod_param('show_address', $param);
$this->semail = mod_param('show_email', $param);
$this->sjob = mod_param('show_job', $param);
$this->slinks = mod_param('show_links', $param);
$this->sphone = mod_param('show_phone', $param);
$this->sphoto = $sphoto = mod_param('show_photo', $param);
$groupId = app_param('id');
$whereCat = "AND group_id = {$id}";
$sql = $db->select(FDBPrefix . 'contact', '*', 'status = 1 AND group_id=' . $id);
$qr = @mysql_fetch_array($sql);
if (empty($qr['id'])) {
echo "<h3>Opps, Contact group is empty!";
} else {
loadPaging();
$paging = new paging();
$rowsPerPage = $per_page;
$result = $paging->pagerQuery(FDBPrefix . 'contact', "*", "status=1 {$whereCat}", 'id ASC', $rowsPerPage);
$no = 0;
$sum = mysql_affected_rows();
while ($qr = mysql_fetch_array($result)) {
$group = oneQuery('contact_group', 'id', $qr['group_id'], 'name');
$vlink = "?app=contact&view=person&id={$qr['id']}";
$link = make_permalink($vlink, Page_ID);
$title = "<a href=\"{$link}\">{$qr['name']}</a>";
if (empty($read_more)) {
$read_more = "read more...";
}
$readmore = "<a href=\"{$link}\"class='readmore'>{$read_more}</a>";
$comment = FQuery('comment', "link='{$vlink}'AND status=1");
$name = "<a href='{$link}'>{$qr['name']}</a>";
if ($sphoto == 1 and !empty($qr['photo'])) {
$photo = "<img src=\"{$qr['photo']}\" width=\"150px\">";
}
if (!empty($qr['email'])) {
$email = "<a href='mailto:{$qr['email']}' title=\"send mail to {$qr['name']}\">{$qr['email']}</a>";
} else {
$email = "";
}
if (!empty($qr['photo'])) {
$photo = "<img src='{$qr['photo']}' title=\"{$qr['name']}'s contact photo\" />";
}
if (!empty($qr['tw'])) {
$tw = " <a href='http://twitter.com/{$qr['tw']}' title=\"follow {$qr['name']} on twitter\" target='_blank'><img src='" . FUrl . "apps/app_contact/theme/images/tw.png'></a>";
}
if (!empty($qr['fb'])) {
$fb = " <a href='http://facebook.com/{$qr['fb']}' title=\"find {$qr['name']} on facebook\" target='_blank'><img src='" . FUrl . "apps/app_contact/theme/images/fb.png'></a>";
}
if (!empty($qr['web'])) {
$web = " <a href='http://{$qr['web']}' title=\"visit {$qr['name']}'s website\" target='_blank'><img src='" . FUrl . "apps/app_contact/theme/images/web.png'></a>";
}
if (!empty($qr['ym'])) {
$ym = " <a href='ymsgr:sendIM?{$qr['ym']}' title=\"chat with {$qr['name']} via YahooMasangger\"><img src='" . FUrl . "apps/app_contact/theme/images/ym.png'></a>";
}
if (isset($ym) or isset($fb) or isset($tw) or isset($web)) {
$links = $ym . $fb . $tw . $web;
} else {
$links = '';
}
$this->perrows = $sum;
$this->name[$no] = $name;
$this->photo[$no] = $photo;
$this->group[$no] = $group;
$this->gender[$no] = $qr['gender'];
$this->address[$no] = $qr['city'] . ", " . $qr['country'];
$this->email[$no] = @$qr['email'];
$this->job[$no] = $qr['job'];
$this->links[$no] = $links;
$this->phone[$no] = $qr['phone'];
$this->fax[$no] = $qr['fax'];
$this->per_page = $per_page;
$ym = $fb = $tw = $web = null;
//reset $link variable;
if (defined('SEF_URL')) {
$link = link_paging('?');
} else {
$link = "?app=contact&view=group&id={$groupId}";
$link = make_permalink($link, Page_ID);
$link = $link . "&";
}
$no++;
}
$db->select(FDBPrefix . 'contact', '*', "status=1 {$whereCat}");
$jml = mysql_affected_rows();
if ($jml > $rowsPerPage) {
$pagelink = $paging->createPaging($link);
} else {
$pagelink = null;
}
$this->pagelink = $pagelink;
}
}
function category($type, $id = null, $format = null)
{
$link = null;
/* Set global parameter */
$show_panel = menu_param('show_panel', Page_ID);
$show_rss = menu_param('show_rss', Page_ID);
$read_more = menu_param('read_more', Page_ID);
$per_page = menu_param('per_page', Page_ID);
$intro = menu_param('intro', Page_ID);
if (empty($intro)) {
$intro = $per_page;
}
/* Set Access_Level */
$accessLevel = Level_Access;
if ($type == 'archives') {
$where = "status=1";
} else {
if ($type == 'category') {
$catName = categoryInfo('name', $id);
$catDesc = categoryInfo('description', $id);
$catLink = categoryLink($id);
$where = "status=1 AND category = {$id}";
} else {
if ($type == 'featured') {
$where = "status=1 AND featured = 1";
} else {
if ($type == 'tag') {
if (empty($per_page)) {
$per_page = 10;
}
$tag = app_param('tag');
$tag = str_replace("-", " ", $tag);
$where = "status=1 AND tags LIKE '%" . $tag . "%'";
}
}
}
}
if (_FEED_ == 'rss') {
$per_page = 20;
$pages = url_param('page');
if ($pages != null) {
$link = str_replace("?page={$pages}", "", getUrl());
redirect("{$link}?feed=rss");
}
}
loadPaging();
$paging = new paging();
$result = $paging->pagerQuery(FDBPrefix . 'article', "*,\n\t\tDATE_FORMAT(date,'%d %M %Y') as date,\n\t\tDATE_FORMAT(date,'%Y-%m-%d %H:%i:%s') as order_date,\n\t\tDATE_FORMAT(date,'%a, %m %d %Y %H:%i:%s') as time,\n\t\tDATE_FORMAT(date,'%d') as f,\n\t\tDATE_FORMAT(date,'%D') as d,\n\t\tDATE_FORMAT(date,'%b') as b,\n\t\tDATE_FORMAT(date,'%a') as a,\n\t\tDATE_FORMAT(date,'%W') as D,\n\t\tDATE_FORMAT(date,'%m') as n,\n\t\tDATE_FORMAT(date,'%M') as m,\n\t\tDATE_FORMAT(date,'%y') as y,\n\t\tDATE_FORMAT(date,'%Y') as Y,\n\t\tDATE_FORMAT(date,'%h') as h,\n\t\tDATE_FORMAT(date,'%H') as H,\n\t\tDATE_FORMAT(date,'%p') as p,\n\t\tDATE_FORMAT(date,'%i') as i,\n\t\tDATE_FORMAT(date,'%s') as s", "{$where} {$accessLevel}", 'order_date DESC', $per_page);
$no = 0;
$perrows = mysql_affected_rows();
while ($qr = mysql_fetch_array($result)) {
/* Category Details */
$catLinks = categoryLink($qr['category']);
$category = categoryInfo('name', $qr['category']);
$catHref = "<a href='{$catLinks}'>{$category}</a>";
/* Author */
if (empty($qr['author'])) {
$author = userInfo('name', 1);
} else {
$author = $qr['author'];
}
/* Article Links */
$link = "?app=article&view=item&id={$qr['id']}";
$vlink = str_replace("&", "&", $link);
$vlink = make_permalink($vlink);
/* Article Title */
$title = "<a href='{$vlink}'>{$qr['title']}</a>";
$link = make_permalink($link);
/* Article Tags */
$tags = tagToLink($qr['tags']);
/* Article Content */
$article = $qr['article'];
if (checkLocalhost()) {
$article = str_replace(FLocal . "media/", "media/", $article);
$article = str_replace("/media/", FUrl . "media/", $article);
}
$comment = null;
/* Article Comments */
$comm = FQuery('comment', "link='{$link}'AND status=1");
if (FQuery('apps', "folder='app_comment'")) {
$comment = "<a class='send-comment' href='{$link}#comment'>";
if ($comm > 1) {
$comment .= "<span>{$comm}</span> " . Comments;
}
if ($comm == 1) {
$comment .= "<span>{$comm}</span> " . Comment;
}
if ($comm < 1) {
$comment .= Send_Comment;
}
$comment .= "</a>";
}
$scomment = mod_param('show_comment', articleInfo('parameter', $qr['id']));
if (!$scomment) {
$comment = '';
}
/* Read More */
if (empty($read_more)) {
$read_more = Readmore;
}
$readmore = "<a href='{$link}' class='readmore'>{$read_more}</a> {$comment}";
/* Intro limit (read more) */
$content = $article;
/* Blog Style */
if ($format == 'blog' or $type == 'tag' or $format == 'list') {
$image = articleImage($content);
$image = str_replace("/media", "/media/.thumbs", $image);
$imgH = menu_param('imgH', Page_ID);
$imgW = menu_param('imgW', Page_ID);
$this->image[$no] = $image;
$this->imgH = $imgH;
$this->imgW = $imgW;
$content = preg_replace("/<img[^>]+\\>/i", "", $content);
}
$content = articleIntro($content);
$panel = menu_param('panel_format', Page_ID);
$fpanel = "#" . menu_param('panel_format', Page_ID);
$dpanel = str_replace('%rel', "", $fpanel);
if (empty($panel) or !strpos($dpanel, '%')) {
if (siteConfig('lang') == 'id') {
$panel = "<b>%A</b> · %f %m %Y · %c";
} else {
$panel = "%m, %f %Y · <b>%A</b> · %c";
}
}
$panel = str_replace('%A', $author, $panel);
$panel = str_replace('%c', "{$catHref}", $panel);
$panel = str_replace('%h', $qr['hits'], $panel);
$timeRel = dateRelative($qr['H'], $qr['i'], $qr['s'], $qr['n'], $qr['f'], $qr['Y']);
if ($timeRel and strpos($fpanel, '%rel')) {
$panel = str_replace(', ', "", $panel);
$panel = str_replace('%d', "", $panel);
$panel = str_replace('%f', "{$timeRel}", $panel);
$panel = str_replace('%m', "", $panel);
$panel = str_replace('%n', "", $panel);
$panel = str_replace('%y', "", $panel);
$panel = str_replace('%Y', "", $panel);
$panel = str_replace('%H', "", $panel);
$panel = str_replace('%h', "", $panel);
$panel = str_replace('%i', "", $panel);
$panel = str_replace('%s', "", $panel);
$panel = str_replace('%p', "", $panel);
if (strlen($panel) < 3) {
$panel = $timeRel;
}
} else {
if (siteConfig('lang') == 'id') {
$panel = str_replace('%f', $qr['f'], $panel);
} else {
$panel = str_replace('%f', $qr['d'], $panel);
}
$panel = str_replace("%rel", $panel, $panel);
$panel = str_replace('%d', $qr['d'], $panel);
$panel = str_replace('%a', $qr['a'], $panel);
$panel = str_replace('%b', $qr['b'], $panel);
$panel = str_replace('%m', $qr['m'], $panel);
$panel = str_replace('%n', $qr['n'], $panel);
$panel = str_replace('%y', $qr['y'], $panel);
$panel = str_replace('%Y', $qr['Y'], $panel);
$panel = str_replace('%H', $qr['H'], $panel);
$panel = str_replace('%h', $qr['h'], $panel);
$panel = str_replace('%i', $qr['i'], $panel);
$panel = str_replace('%s', $qr['s'], $panel);
$panel = str_replace('%p', $qr['p'], $panel);
}
$panel = str_replace('*', "", $panel);
/* RSS Feed */
$this->perrows = $perrows;
$this->intro = $intro;
$this->show_rss = $show_rss;
$this->show_panel = $show_panel;
$this->panel[$no] = $panel;
$this->category[$no] = $category;
$this->catlink[$no] = $catLinks;
$this->readmore[$no] = $readmore;
$this->comment[$no] = $comment;
$this->author[$no] = $author;
$this->title[$no] = $title;
$this->link[$no] = $link;
$this->tags[$no] = $tags;
$this->ftime[$no] = $qr['time'];
$this->hits[$no] = $qr['hits'];
$this->desc[$no] = clearXMLString("{$content}");
$this->ftitle[$no] = clearXMLString($qr['title']);
$this->content[$no] = $content;
if (defined('SEF_URL')) {
$link = link_paging('?');
if (strpos(getUrl(), '&') > 0) {
$link = link_paging('&');
}
} else {
if (checkhomepage()) {
$link = "?";
} else {
if (!url_param('id')) {
$tag = app_param('tag');
$link = "?app=article&tag={$tag}";
$link = make_permalink($link, Page_ID);
$link = $link . "&";
} else {
$link = "?app=article&view=category&id={$categoryId}";
$link = make_permalink($link, Page_ID);
$link = $link . "&";
}
}
}
$no++;
}
// pageLink
$this->pglink = $paging->createPaging($link);
// rssLink
if ($type == 'tag') {
$tag = str_replace(" ", "-", $tag);
$rssLink = "?app=article&tag={$tag}&feed=rss";
} else {
if ($type == 'category') {
$rssLink = "?app=article&view=category&id={$id}&feed=rss";
} else {
$rssLink = "?app=article&view=archives&feed=rss";
}
}
if (_FEED_ == 'rss') {
$rssLink = make_permalink($rssLink);
$this->rssTitle = @clearXMLString(SiteTitle);
$categoryLink = @clearXMLString($rssLink);
$categoryLink = str_replace(".xml", "", $categoryLink);
$this->rssLink = $categoryLink;
$this->rssDesc = @$categoryDesc;
} else {
$this->rssLink = make_permalink($rssLink);
}
}
