<?php
define('ROOT', '..');
include ROOT . '/lib/include.php';
$searchFeedId = $accessInfo['action'];
$searchType = 'user';
if(is_numeric($searchFeedId)) {
$user = User::getById($searchFeedId);
$searchKeyword = $user['loginid'];
$searchExtraValue = $searchFeedId;
} else {
$searchKeyword = $searchFeedId;
$user = User::getByloginId($searchKeyword);
$searchExtraValue = Feed::getIdListByOwner($user['id']);
}
include ROOT . '/lib/begin.php';
$customQuery = $event->on('Query.feedItems', '');
$pageCount = $skinConfig->postList; // ÆäÀÌÁö°¹¼ö
list($posts, $totalFeedItems) = FeedItem::getFeedItems($searchType, $searchKeyword, $searchExtraValue, $page, $pageCount, false, 0, $customQuery);
$paging = Func::makePaging($page, $pageCount, $totalFeedItems);
include ROOT . '/lib/piece/message.php';
include ROOT . '/lib/piece/postlist.php';
include ROOT . '/lib/end.php';
?>
function getFeedItemsQuery($searchType, $searchKeyword, $searchExtraValue,$viewDelete = false,$owner = 0) {
global $db, $database, $config;
$sQuery = '';
if (($searchType=='tag' || $searchType=='tag+group_category') && !Validator::is_empty($searchKeyword)) {
$tagIds = array();
$tags = explode(',',$searchKeyword);
if($tagResult = $db->queryAll('SELECT id FROM '.$database['prefix'].'Tags WHERE name IN ('.Func::implode_string(',',$tags).')')) {
foreach($tagResult as $tagItem) array_push($tagIds, $tagItem['id']);
}
if (empty($tagIds)) {
return array(null,0);
} else {
if($searchType == 'tag') {
$sQuery = ' LEFT JOIN '.$database['prefix'].'TagRelations r ON (r.item = i.id AND (r.type = "feed")) WHERE r.tag IN ('.implode(',',$tagIds).')';
} else if($searchType == 'tag+group_category') {
$sQuery = ' LEFT JOIN '.$database['prefix'].'TagRelations r ON (r.item = i.id AND (r.type = "feed" || r.type = "group_category")) WHERE r.tag IN ('.implode(',',$tagIds).')';
}
}
} else if ($searchType=='blogURL' && !Validator::is_empty($searchKeyword)){
$searchKeyword = UTF8::bring($searchKeyword);
$searchFeedId = $searchExtraValue;
if(empty($searchFeedId)) {
$searchFeedId = Feed::blogURL2Id('http://'.str_replace('http://', '', $searchKeyword));
}
if(!empty($searchFeedId)) {
$sQuery = ' WHERE i.feed = '.$searchFeedId;
} else {
$sQuery = ' WHERE 1=0 ';
}
} else if ($searchType=='user' && !Validator::is_empty($searchKeyword)){
$searchKeyword = UTF8::bring($searchKeyword);
$searchFeedId = $searchExtraValue;
if(empty($searchFeedId)) {
if(is_numeric($searchKeyword)) {
$user = User::getById($searchKeyword);
} else {
$user = User::getByloginId($searchKeyword);
}
$searchFeedId = Feed::getIdListByOwner($user['id']);
}
if(!empty($searchFeedId)) {
$sQuery = ' WHERE i.feed IN ('.implode(",",$searchFeedId).')';
} else {
$sQuery = ' WHERE 1=0 ';
}
} else if ($searchType=='author' && !Validator::is_empty($searchKeyword)){
$searchKeyword = UTF8::bring($searchKeyword);
if(!empty($searchKeyword)) {
$sQuery = ' WHERE i.author = "' . $searchKeyword . '"';
} else {
$sQuery = ' WHERE 1=0 ';
}
} else if ($searchType=='title+description' && !Validator::is_empty($searchKeyword)){
$searchKeyword = UTF8::bring($searchKeyword);
$keyword = $db->escape($searchKeyword);
$sQuery = ' WHERE i.description LIKE "%'.$keyword.'%"';
} else if ($searchType=='title' && !Validator::is_empty($searchKeyword)){
$searchKeyword = UTF8::bring($searchKeyword);
$keyword = $db->escape($searchKeyword);
$sQuery = ' WHERE i.title LIKE "%'.$keyword.'%"';
} else if ($searchType=='description' && !Validator::is_empty($searchKeyword)){
$searchKeyword = UTF8::bring($searchKeyword);
$keyword = $db->escape($searchKeyword);
$sQuery = ' WHERE i.description LIKE "%'.$keyword.'%"';
} else if ($searchType=='focus'){
$sQuery = ' WHERE i.focus = "'.$searchKeyword.'"';
} else if ($searchType=='group') {
requireComponent('Bloglounge.Data.Groups');
if(!empty($searchExtraValue)) {
$tagId = $db->pick('SELECT id FROM '.$database['prefix'].'Tags WHERE name="'.$db->escape(urldecode($searchExtraValue)).'"');
if($tagId) {
$tagId = $tagId[0];
$sQuery = ' LEFT JOIN '.$database['prefix'].'TagRelations r ON (r.item = i.id AND r.type = "group_category") ';
}
}
if(!is_numeric($searchKeyword)) {
$group = Group::getByName($searchKeyword);
$searchKeyword = $group['id'];
}
if($searchKeyword) {
$feedIds = Group::getFeedIdList($searchKeyword);
$sQuery .= ' WHERE i.feed IN (' . implode(',',$feedIds) .')';
if($tagId) {
$sQuery .= ' AND r.tag="'.$tagId.'"';
}
}
} else if ($searchType=='category') {
requireComponent('Bloglounge.Data.Category');
if(is_numeric($searchKeyword)) {
$category = Category::getById($searchKeyword);
} else {
$category = Category::getByName($searchKeyword);
}
if($category) {
$sQuery = ' WHERE c.category = ' . $category['id'];
}
} else if ($searchType == 'archive' && !Validator::is_empty($searchKeyword)) {
if(is_array($searchExtraValue) && array_key_exists('start',$searchExtraValue) && array_key_exists('end',$searchExtraValue)) {
$tStart = $searchExtraValue['start'];
$tEnd = $searchExtraValue['end'] + 86400;
} else {
$tStart = $searchExtraValue;
$tEnd = $tStart + 86400;
}
$tQuery = ' WHERE i.written > '.$tStart.' AND i.written < '.$tEnd.' ';
if (strpos($sQuery, 'WHERE') !== false) {
$sQuery = str_replace('WHERE ', $tQuery.' AND (', $sQuery);
$sQuery .= ')';
} else {
$sQuery .= $tQuery;
}
} else {
if (!Validator::is_empty($searchKeyword)) {
$searchKeyword = UTF8::bring($searchKeyword);
$keyword = $db->escape($searchKeyword);
if(empty($searchExtraValue)) { // all : title, description, tags, permlink
$sQuery = ' WHERE i.author LIKE "%'.$keyword.'%" OR i.title LIKE "%'.$keyword.'%" OR i.description LIKE "%'.$keyword.'%" OR i.tags LIKE "%'.$keyword.'%" OR i.permalink LIKE "%'.$keyword.'%"';
} else { // custom
$sQuery = ' WHERE ' . $searchExtraValue;
}
}
}
// boomDownReactor, boomDownReactorLimit : 리액터가 숨기기일때 쿼리에서 제외 파트 추가 ( 특정수만큼 붐다운(비추천)한글은 제외하거나 특정기능..
if(isset($config)) {
if (($config->boomDownReactor == 'hide') && ($config->boomDownReactLimit > 0)) {
$bQuery = ' WHERE (i.boomDown <= '.$config->boomDownReactLimit.') ';
if (strpos($sQuery, 'WHERE') !== false) {
$sQuery = str_replace('WHERE ', $bQuery.' AND (', $sQuery);
$sQuery .= ')';
} else {
$sQuery .= $bQuery;
}
}
}
if(empty($owner)) {
if($viewDelete) {
// 공개된 블로그만 뽑기 + 삭제된 글 보이기
if(!isAdmin()) {
$bQuery = ' WHERE (i.visibility = "d") AND (i.feedVisibility = "y") ';
} else {
$bQuery = ' WHERE (i.visibility = "d") ';
}
} else {
// 공개된 블로그만 뽑기
if(!isAdmin()) {
$bQuery = ' WHERE (i.visibility = "y") AND (i.feedVisibility = "y") ';
} else {
$bQuery = ' WHERE (i.visibility != "d") ';
}
}
} else {
if($viewDelete) {
// 공개된 블로그만 뽑기
// if(!isAdmin()) {
// $bQuery = ' WHERE (i.visibility = "d") AND (i.feedVisibility = "y") AND (f.owner = ' . $owner . ')';
// } else {
$bQuery = ' WHERE (i.visibility = "d") AND (f.owner = ' . $owner . ')';
// }
} else {
// 공개된 블로그만 뽑기
// if(!isAdmin()) {
// $bQuery = ' WHERE (i.visibility = "y") AND (i.feedVisibility = "y") AND (f.owner = ' . $owner . ')';
// } else {
$bQuery = ' WHERE (i.visibility != "d") AND (f.owner = ' . $owner . ')';
// }
}
}
if($viewDelete) {
if(strpos($sQuery, 'Feeds f') === false ) {
$bQuery = ' LEFT JOIN '.$database['prefix'].'Feeds f ON (f.id = i.feed) ' . $bQuery;
}
}
if (strpos($sQuery, 'WHERE') !== false) {
$sQuery = str_replace('WHERE ', $bQuery.' AND (', $sQuery);
$sQuery .= ')';
} else {
$sQuery .= $bQuery;
}
return $sQuery;
}