"urlencode" fonksiyonu ile arama yaptırdığım terimi sayfaya çekiyorum fakat türkçe karakter hatası ile karşılaşıyorum. Anlayanlar yardımcı olursa çok sevinirim; Kodlar aşağıda:
Yardımcı olacak arkadaşlara şimdiden teşekkürler.
Fonksiyon ile arama terimini yazdırdığım sayfanın kodları:
search_string) ?>
Bu fonksyonun php kaynak kodu:
if( $this->param('posttag') ) {
$tmp = str_replace('/', '', urldecode($this->param('posttag')));
$this->redirect( $C->SITE_URL.'search/tab:tags/s:'.urlencode(trim($tmp)) );
}
$D->search_string = '';
if( $this->param('usertag') ) {
$D->tab = 'users';
$D->search_string = str_replace('/', '', urldecode(trim($this->param('usertag'))));
}elseif( isset($_POST['lookfor']) && !empty($_POST['lookfor']) ) {
$D->search_string = str_replace('/', '', $_POST['lookfor']);
}elseif( $this->param('s') ){
$D->search_string = urldecode(trim($this->param('s')));
$D->search_string = preg_replace('/\s+/us', ' ', $D->search_string);
}
$D->page_title = $this->lang('srch_title_'.$D->tab, array('#SITE_TITLE#'=>$C->SITE_TITLE));
$D->search_title = $this->lang( (empty($D->search_string)?'srch_title2_':'srch_title3_').$D->tab, array('#STRING#'=>htmlspecialchars(str_cut($D->search_string,30))));
$D->num_results = 0;
$D->num_pages = 0;
$D->num_per_page = 0;
$D->pg = 1;
$D->posts_html = '';
$D->users_html = '';
$D->groups_html = '';
if( $D->tab=='users' )
{
$uids = array();
if( !empty($D->search_string) ){
$txt_to_search = str_replace(array('%','_'), array('\%','\_'), $db2->e($D->search_string));
//SEARCH WITH SPHINX
if( $C->SEARCH_ENGINE == 'sphinx' ){
$search = new search_sphinx();
$uids = $search->do_search_members($txt_to_search);
}
//END
//SEARCH WITH MYSQL
else{
$db2->query('SELECT id, username, fullname, position, num_followers, num_posts, avatar FROM users WHERE username LIKE "%'.$txt_to_search.'%" OR fullname LIKE "%'.$txt_to_search.'%" ORDER BY username ASC');
while($o = $db2->fetch_object()) {
$uids[$o->id] = array($o->id, $o->username, $o->fullname, $o->position, $o->num_followers, $o->num_posts, $o->avatar);
}
$db2->query('SELECT id, username, fullname, position, num_followers, num_posts, avatar FROM users WHERE tags REGEXP "(^|\,| )'.(preg_quote($txt_to_search)).'($|\,)" ORDER BY username ASC');
while($o = $db2->fetch_object()) {
$uids[$o->id] = array($o->id, $o->username, $o->fullname, $o->position, $o->num_followers, $o->num_posts, $o->avatar);
}
}
//END
}
$D->num_results = count($uids);
$D->num_pages = ceil($D->num_results / $C->PAGING_NUM_USERS);
$D->pg = $this->param('pg') ? intval($this->param('pg')) : 1;
$D->pg = min($D->pg, $D->num_pages);
$D->pg = max($D->pg, 1);
if( 0 == $D->num_results ) {
$D->noposts_box_title = $this->lang('srch_noresult_users_ttl');
$D->noposts_box_text = $this->lang('srch_noresult_users_txt');
$D->users_html = $this->load_template('noposts_box.php', FALSE);
}
else {
$from = ($D->pg - 1) * $C->PAGING_NUM_USERS;
$tmp = array_slice($uids, $from, $C->PAGING_NUM_USERS, true);
$D->if_follow_user = array();
$user_ids = ( $C->SEARCH_ENGINE == 'sphinx' )? $tmp : array_keys($tmp);
if($this->user->id && count($user_ids)>0 ){
$db2->query('SELECT whom FROM users_followed WHERE whom IN('.implode(',', $user_ids).') AND who="'.$this->user->id.'"');
while($o = $db2->fetch_object()){
if( isset($D->if_follow_user[$o->whom]) ){
continue;
}
$D->if_follow_user[$o->whom] = 1;
}
}
ob_start();
//SHOW SPHINX RESULTS
if( $C->SEARCH_ENGINE == 'sphinx' ){
foreach($tmp as $u) {
$u = $this->network->get_user_by_id($u);
if( ! $u ) { continue; }
$D->u = $u;
$this->load_template('single_user.php');
}
}
//END
//SHOW MYSQL RESULTS
else{
foreach($tmp as $v) {
$D->u = new stdClass;
$D->u->id = $v[0];
$D->u->username = $v[1];
$D->u->fullname = $v[2];
$D->u->position = $v[3];
$D->u->num_followers = $v[4];
$D->u->num_posts = $v[5];
$D->u->avatar = (empty($v[6]))? $C->DEF_AVATAR_USER : $v[6];
$this->load_template('single_user.php');
}
}
//END
$D->paging_url = $C->SITE_URL.'search/tab:users/s:'.urlencode($D->search_string).'/pg:';
if( $D->num_pages > 1 ) {
$this->load_template('paging_users.php');
}
$D->users_html = ob_get_contents();
ob_end_clean();
}
}
elseif( $D->tab=='groups' )
{
$gids = array();
if( !empty($D->search_string) ){
$not_in_groups = array();
if( !$this->user->is_logged || !$this->user->info->is_network_admin ) {
$not_in_groups = array();
$not_in_groups = array_diff( $this->network->get_private_groups_ids(), $this->user->get_my_private_groups_ids() );
}
$txt_to_search = str_replace(array('%','_'), array('\%','\_'), $db2->e($D->search_string));
//SEARCH WITH SPHINX
if( $C->SEARCH_ENGINE == 'sphinx' ){
$search = new search_sphinx();
$gids = $search->do_search_groups($txt_to_search, $not_in_groups);
}
//END
//SEARCH WITH MYSQL
else{
$not_in_groups = (count($not_in_groups)>0)? ' AND id NOT IN('.implode(', ', $not_in_groups).')' : '';
$db2->query('SELECT id, groupname, title, num_followers, num_posts, is_public, about_me, avatar FROM groups WHERE (groupname LIKE "%'.$txt_to_search.'%" OR title LIKE "%'.$txt_to_search.'%") '.$not_in_groups.' ORDER BY title ASC, num_followers DESC');
while($o = $db2->fetch_object()) {
$gids[$o->id] = array($o->id, $o->groupname, $o->title, $o->num_followers, $o->num_posts, $o->is_public, $o->about_me, $o->avatar);
}
}
//END
}
$D->num_results = count($gids);
$D->num_pages = ceil($D->num_results / $C->PAGING_NUM_GROUPS);
$D->pg = $this->param('pg') ? intval($this->param('pg')) : 1;
$D->pg = min($D->pg, $D->num_pages);
$D->pg = max($D->pg, 1);
if( 0 == $D->num_results ) {
$D->noposts_box_title = $this->lang('srch_noresult_groups_ttl');
$D->noposts_box_text = $this->lang('srch_noresult_groups_txt');
$D->groups_html = $this->load_template('noposts_box.php', FALSE);
}
else{
$from = ($D->pg - 1) * $C->PAGING_NUM_GROUPS;
$tmp = array_slice($gids, $from, $C->PAGING_NUM_GROUPS, true);
ob_start();
$D->if_can_leave = array();
$g_admins = array();
$group_ids = ($C->SEARCH_ENGINE == 'mysql')? array_keys($gids) : $gids;
if( $this->user->id && count($group_ids)>0 ){
$db2->query('SELECT * FROM groups_admins WHERE group_id IN('.implode(',', $group_ids).')');
while($o = $db2->fetch_object() ){
if( isset($g_admins[$o->group_id]) ){
if( $o->user_id != $this->user->id ){
$g_admins[$o->group_id] += 1;
}
}else{
$g_admins[$o->group_id] = ($o->user_id == $this->user->id)? 0 : 1;
}
}
foreach($g_admins as $gid => $num_members){
// -1 == TRUE, you can leave
// 1 == FALSE, could not leave
$D->if_can_leave[$gid] = ($num_members>0)? -1 : 1;
}
unset($gmembers);
}
$D->if_follow_group = array();
if($this->user->id && count($group_ids)>0){
$db2->query('SELECT * FROM groups_followed WHERE group_id IN('.implode(',', $group_ids).') AND user_id="'.$this->user->id.'"');
while($o = $db2->fetch_object()){
if( isset($D->if_follow_group[$o->group_id]) ){
continue;
}
$D->if_follow_group[$o->group_id] = 1;
}
}
unset($group_ids);
//SHOW SPHINX RESULTS
if( $C->SEARCH_ENGINE == 'sphinx' ){
foreach($tmp as $g) {
$g = $this->network->get_group_by_id($g);
if( ! $g ) { continue; }
$D->g = $g;
$this->load_template('single_group.php');
}
}
//END
//SHOW MYSQL RESULTS
else{
foreach($tmp as $v) {
$g = new stdClass;
$g->id = $v[0];
$g->groupname = $v[1];
$g->title = $v[2];
$g->num_followers = $v[3];
$g->num_posts = $v[4];
$g->is_public = $v[5];
$g->is_private = ($g->is_public == 0);
$g->about_me = $v[6];
$g->avatar = (empty($v[7]))? $C->DEF_AVATAR_GROUP : $v[7];
$D->g = $g;
$this->load_template('single_group.php');
}
}
//END
$D->paging_url = $C->SITE_URL.'search/tab:group/s:'.urlencode($D->search_string).'/pg:';
if( $D->num_pages > 1 ) {
$this->load_template('paging_groups.php');
}
$D->groups_html = ob_get_contents();
ob_end_clean();
}
}
elseif( $D->tab == 'posts' )
{
if( $this->param('saved') ) {
$tmp = $db2->e(trim($this->param('saved')));
$search_url = $db2->fetch_field('SELECT search_url FROM searches WHERE user_id="'.$this->user->id.'" AND search_key="'.$tmp.'" LIMIT 1');
$this->redirect('http://'.$C->DOMAIN.$search_url);
}
$valid_ptypes = array('link','image','video','file','comments','rss','tweets');
$D->ptypes_choosen = (isset($_POST['ptype']) && is_array($_POST['ptype']))? $_POST['ptype'] : array();
if( $this->param('ptypes') ){
$D->ptypes_choosen = explode(',', $this->param('ptypes'));
}
foreach($D->ptypes_choosen as $k=>$v){
if(!in_array($v, $valid_ptypes)){
unset($D->ptypes_choosen[$k]);
}
}
$D->saved_searches = array();
$D->saved_searches = $this->user->get_saved_searches();
$D->paging_url = $C->SITE_URL.'search';
$D->paging_url .= '/ptypes:'.implode(',', $D->ptypes_choosen);
if( isset($_POST['puser']) || $this->param('puser') ){
$puser = isset($_POST['puser'])? $_POST['puser'] : $this->param('puser');
$puser = preg_replace('/[^a-z0-9-\_]/iu', '', $puser);
$D->paging_url .= (!empty($puser))? '/puser:'.$puser : '';
}else{
$puser = '';
}
if( isset($_POST['pgroup']) || $this->param('pgroup') ){
$pgroup = isset($_POST['pgroup'])? $_POST['pgroup'] : $this->param('pgroup');
$pgroup = preg_replace('/[^ا-یא-תÀ-ÿ一-龥а-яa-z0-9\-\.\s]/iu', '', $pgroup);
$D->paging_url .= (!empty($pgroup))? '/pgroup:'.$pgroup : '';
}else{
$pgroup = '';
}
if( isset($_POST['pdate1']) || $this->param('pdate1') ){
$pdate1 = isset($_POST['pdate1'])? $_POST['pdate1'] : $this->param('pdate1');
if( is_array($pdate1) ){
$pdate1 = trim(implode(',', preg_replace('/[^0-9]/iu','',$pdate1)), ',');
}
if( ! preg_match('/^[0-9]{1,2}\,[0-9]{1,2}\,[0-9]{4}$/', $pdate1) ) { $pdate1 = ''; }
$D->paging_url .= (!empty($pdate1))? '/pdate1:'.$pdate1 : '';
}else{
$pdate1 = '';
}
if( isset($_POST['pdate2']) || $this->param('pdate2') ){
$pdate2 = isset($_POST['pdate2'])? $_POST['pdate2'] : $this->param('pdate2');
if( is_array($pdate2) ){
$pdate2 = trim(implode(',', preg_replace('/[^0-9]/iu','',$pdate2)), ',');
}
if( ! preg_match('/^[0-9]{1,2}\,[0-9]{1,2}\,[0-9]{4}$/', $pdate2) ) { $pdate2 = ''; }
$D->paging_url .= (!empty($pdate2))? '/pdate2:'.$pdate2 : '';
}else{
$pdate2 = '';
}
if( isset($_POST['lookfor']) && !empty($_POST['lookfor']) ){
$D->search_string = str_replace('/', '', $_POST['lookfor']);
$D->search_string = str_replace('%', '', $_POST['lookfor']);
}elseif($this->param('s')){
$D->search_string = urldecode($this->param('s'));
}
$D->paging_url .= '/s:'.$D->search_string;
if(isset($_POST['puser']) || isset($_POST['pgroup']) || isset($_POST['pdate1']) || isset($_POST['pdate2']) || isset($_POST['lookfor']) ){
$this->redirect($D->paging_url);
}
$D->form_user = $puser;
$D->form_group = $pgroup;
$D->box_expanded = (object) array('type'=>FALSE, 'author'=>FALSE, 'group'=>FALSE, 'date'=>FALSE);
if( count($D->ptypes_choosen) != 7 ) {
$D->box_expanded->type = TRUE;
}
if( isset($puser) && ! empty($puser) ) {
$D->box_expanded->author = TRUE;
}
if( isset($pgroup) && ! empty($pgroup) ) {
$D->box_expanded->group = TRUE;
}
if( (isset($pdate1) && ! empty($pdate1)) || (isset($pdate2) && ! empty($pdate2)) ) {
$D->box_expanded->date = TRUE;
}
$D->form_date1 = array('d'=>'', 'm'=>'', 'y'=>'');
$D->form_date2 = array('d'=>'', 'm'=>'', 'y'=>'');
if( isset($pdate1) && ! empty($pdate1) ) {
list($D->form_date1['d'], $D->form_date1['m'], $D->form_date1['y']) = explode(',', $pdate1);
}
if( isset($pdate2) && ! empty($pdate2) ) {
list($D->form_date2['d'], $D->form_date2['m'], $D->form_date2['y']) = explode(',', $pdate2);
}
$D->form_date1_days = array('');
for($i=1; $i<=31; $i++) { $D->form_date1_days[] = $i; }
$D->form_date1_months = array('');
for($i=1; $i<=12; $i++) { $D->form_date1_months[] = $i; }
$D->form_date1_years = array();
$tmp = intval(date('Y'))-10;
if( ! $tmp ) { $tmp = intval(date('Y')); }
for($i=$tmp; $i<=intval(date('Y')); $i++) {
$D->form_date1_years[] = $i;
}
$D->form_date1_years[] = '';
$D->form_date1_years = array_reverse($D->form_date1_years);
$D->form_date2_days = $D->form_date1_days;
$D->form_date2_months = $D->form_date1_months;
$D->form_date2_years = $D->form_date1_years;
$D->can_be_saved = FALSE;
$D->error = FALSE;
$D->errmsg = '';
if( ! empty($D->search_string) ) {
$u = FALSE;
$g = FALSE;
if( !$D->error && !empty($puser) ) {
if( ! $u = $this->network->get_user_by_username($puser) ) {
$D->error = TRUE;
$D->errmsg = $this->lang('srch_noresult_posts_invusr', array('#USERNAME#'=>''.htmlspecialchars($puser).''));
}
}
if( !$D->error && !empty($pgroup) ) {
if( ! $g = $this->network->get_group_by_name($pgroup) ) {
$D->error = TRUE;
$D->errmsg = $this->lang('srch_noresult_posts_invgrp', array('#GROUP#'=>''.htmlspecialchars($pgroup).''));
}
}
if( !$D->error && $g && $g->is_private ) {
if( ! in_array(intval($this->user->id), $this->network->get_group_invited_members($g->id)) ) {
$g = FALSE;
$D->error = TRUE;
$D->errmsg = $this->lang('srch_noresult_posts_invgrp', array('#GROUP#'=>''.htmlspecialchars($pgroup).''));
}
}
$t1 = FALSE;
$t2 = FALSE;
if( !$D->error && (!empty($pdate1) || !empty($pdate2)) ) {
if( ! empty($pdate1) ) {
list($d,$m,$y) = explode(',', $pdate1);
$t1 = mktime(0, 0, 1, $m, $d, $y);
if( $t1 > time() ) {
$D->error = TRUE;
$D->errmsg = $this->lang('srch_noresult_posts_invdt');
}
}
if( ! empty($pdate2) ) {
list($d,$m,$y) = explode(',', $pdate2);
$t2 = mktime(23, 59, 59, $m, $d, $y);
}
if( !$D->error && $t1 && $t2 && $t1>$t2 ) {
$D->error = TRUE;
$D->errmsg = $this->lang('srch_noresult_posts_invdt');
}
}
if( !$D->error ) {
$D->can_be_saved = TRUE;
$D->search_saved = FALSE;
$search_key = md5($D->search_string."\n".serialize($D->ptypes_choosen)."\n".$puser."\n".$pgroup."\n".serialize($pdate1)."\n".serialize($pdate2));
foreach( $D->saved_searches as $k=>$v ){
if($v->search_key == $search_key){
$D->search_saved = $v->id;
}
}
$search_rss = (in_array('rss', $D->ptypes_choosen))? TRUE : FALSE;
$search_tweets = (in_array('tweets', $D->ptypes_choosen))? TRUE : FALSE;
if( !$search_rss && !$search_tweets ) $in_where = ' (user_id<>0) '; //search in everything
elseif( $search_rss && !$search_tweets ) $in_where = '(api_id<>2 AND user_id<>0) ';
elseif( !$search_rss && $search_tweets ) $in_where = '(api_id<>6 AND user_id<>0) ';
else $in_where = ' (api_id<>6 AND api_id<>2 AND user_id<>0) ';//only posts, without rss and tweets
$tmp = str_replace(array('%','_'), array('\%','\_'), $db2->e($D->search_string));
if( $tmp != '#' ) {
$tmp = preg_replace('/^\#/', '', $tmp);
}
$in_where .= ' AND (message LIKE "%'.$tmp.'%"';
if( mb_strlen($D->search_string)>=3 && FALSE!==strpos($D->search_string,' ') ) {
$tmp = preg_replace('/[^ا-یא-תÀ-ÿ一-龥а-яa-z0-9\s]/iu', '', $tmp);
$tmp = $db2->e($tmp);
$tmp = preg_replace('/\s+/iu', ' ', $tmp);
$tmp = preg_replace('/(^|\s)/iu', ' +', $tmp);
$tmp = trim($tmp);
$in_where .= ' OR MATCH(message) AGAINST("'.$tmp.'" IN BOOLEAN MODE)';
}
$search_in_comments = FALSE;
if( array_search('comments', $D->ptypes_choosen) !== FALSE ) {
$search_in_comments = TRUE;
//unset($D->ptypes_choosen[$tmpci]);
//$ptypes = array_values($D->ptypes_choosen);
}
if( $search_in_comments ) {
$in_where2 = '';
$tmp = str_replace(array('%','_'), array('\%','\_'), $db2->e($D->search_string));
if( $tmp != '#' ) {
$tmp = preg_replace('/^\#/', '', $tmp);
}
$in_where2 .= 'message LIKE "%'.$tmp.'%"';
if( mb_strlen($D->search_string)>=3 && FALSE!==strpos($D->search_string,' ') ) {
$tmp = preg_replace('/[^ا-یא-תÀ-ÿ一-龥а-яa-z0-9\s]/iu', '', $tmp);
$tmp = $db2->e($tmp);
$tmp = preg_replace('/\s+/iu', ' ', $tmp);
$tmp = preg_replace('/(^|\s)/iu', ' +', $tmp);
$tmp = trim($tmp);
$in_where2 .= ' OR MATCH(message) AGAINST("'.$tmp.'" IN BOOLEAN MODE)';
}
$tmppids = array();
$db2->query('SELECT post_id FROM posts_comments WHERE '.$in_where2);
while($tmp = $db2->fetch_object()) {
$tmppids[] = $tmp->post_id;
}
if( 1 == count($tmppids) ) {
$in_where .= ' OR id='.reset($tmppids);
}
elseif( 1 < count($tmppids) ) {
$in_where .= ' OR id IN('.implode(', ', $tmppids).')';
}
}
$in_where .= ')';
if( $u ) {
$in_where .= ' AND user_id="'.$u->id.'"';
}
if( $g ) {
$in_where .= ' AND group_id="'.$g->id.'"';
}
else {
$not_in_groups = array();
$without_users = array();
if( !$this->user->is_logged || !$this->user->info->is_network_admin ) {
$not_in_groups = array_diff( $this->network->get_private_groups_ids(), $this->user->get_my_private_groups_ids() );
$in_where .= count($not_in_groups)>0 ? ('AND group_id NOT IN('.implode(', ', $not_in_groups).')') : '';
$without_users = array_diff( $this->network->get_post_protected_user_ids(), $this->user->get_my_post_protected_follower_ids() );
$in_where .= count($without_users)>0 ? (' AND (group_id>0 OR user_id NOT IN('.implode(', ', $without_users).'))') : '';
}
}
if( $t1 && $t2 ) {
$in_where .= ' AND date BETWEEN "'.$t1.'" AND "'.$t2.'"';
}
elseif( $t1 ) {
$in_where .= ' AND date>="'.$t1.'"';
}
elseif( $t2 ) {
$in_where .= ' AND date<="'.$t2.'"';
}
if( count($D->ptypes_choosen) == 0 ) {
$in_where .= ' AND attached=0';
}
elseif( count($D->ptypes_choosen) < 4 ) {
$not_in_att = array();
$tmp = array_flip($D->ptypes_choosen);
if( ! isset($tmp['link']) ) { $not_in_att[] = '"link"'; }
if( ! isset($tmp['image']) ) { $not_in_att[] = '"image"'; }
if( ! isset($tmp['video']) ) { $not_in_att[] = '"videoembed"'; }
if( ! isset($tmp['file']) ) { $not_in_att[] = '"file"'; }
$in_where .= ' AND (attached=0 OR id NOT IN( SELECT DISTINCT post_id FROM posts_attachments WHERE `type`';
if( count($not_in_att) == 1 ) {
$in_where .= '='.reset($not_in_att);
}
else {
$in_where .= ' IN('.implode(', ', $not_in_att).')';
}
$in_where .= ' ))';
}
$total_count = 0;
//COUNT WITH SPHINX
if( $C->SEARCH_ENGINE == 'sphinx' ){
$txt_to_search = str_replace(array('%','_'), array('\%','\_'), $db2->e($D->search_string));
$filters = array();
//$filters['ptypes'] = ( count( $D->ptypes_choosen )>0 )? $D->ptypes_choosen : FALSE; not yet implemented for SPHINX
$filters['puser'] = ( $u )? array( $u->id ) : FALSE;
$filters['pgroup'] = ( $g )? array( $g->id ) : FALSE;
$filters['pdate1'] = ( $t1 )? $t1 : FALSE;
$filters['pdate2'] = ( $t2 )? $t2 : FALSE;
$filters['search_rss'] = $search_rss;
$filters['search_tweets'] = $search_tweets;
$filters['search_comments'] = $search_in_comments;
if( !isset($not_in_groups) ){
$not_in_groups = array();
}
if( !isset($without_users) ){
$without_users = array();
}
$pids = array();
$search = new search_sphinx();
$pids = $search->do_search_posts($txt_to_search, $not_in_groups, $without_users, $filters);
$total_count = count($pids);
}
//END
//COUNT WITH MYSQL
else{
$total_count = $db2->fetch_field('SELECT COUNT(*) FROM posts WHERE '.$in_where);
}
//END
$D->num_results = $total_count;
$tmp_url = trim($_SERVER['REQUEST_URI'], '/');
$tmp_url = preg_replace('/(^|\/)pg\:[^\/]*/iu', '', $tmp_url);
$tmp_url = preg_replace('/(^|\/)from\:[^\/]*/iu', '', $tmp_url);
$tmp_url = preg_replace('/(^|\/)r\:[^\/]*/iu', '', $tmp_url);
$tmp_url = preg_replace('/\/+/', '/', $tmp_url);
$tmp_url = '/'.trim($tmp_url, '/');
$D->ajax_url = str_replace('/search/', '/search/from:ajax/', $tmp_url);
$D->paging_url .= '/pg:';
if( $this->param('from')=='ajax' && isset($_POST['savesearch']) ) {
if( $_POST['savesearch']=='on' && !$D->search_saved ) {
$db2->query('INSERT INTO searches SET user_id="'.$this->user->id.'", search_key="'.$search_key.'", search_string="'.$db2->e($D->search_string).'", search_url="'.$db2->e($tmp_url).'", added_date="'.time().'", total_hits=1, last_results="'.$D->num_results.'" ');
echo 'OK:'.intval($db2->insert_id());
return;
}
elseif( $_POST['savesearch']=='off' && $D->search_saved ) {
$db2->query('DELETE FROM searches WHERE id="'.$D->search_saved.'" LIMIT 1');
echo 'OK:0';
return;
}
echo 'ERROR';
return;
}
if( $D->num_results == 0 ) {
$D->error = TRUE;
$D->errmsg = $this->lang('srch_noresult_posts_def');
}
else {
$D->num_pages = ceil($D->num_results / $C->PAGING_NUM_POSTS);
$D->pg = $this->param('pg') ? intval($this->param('pg')) : 1;
$D->pg = min($D->pg, $D->num_pages);
$D->pg = max($D->pg, 1);
$from = ($D->pg - 1) * $C->PAGING_NUM_POSTS;
//SEARCH WITH SPHINX
if( $C->SEARCH_ENGINE == 'sphinx' ){
$pids = array_slice($pids, $from, $C->PAGING_NUM_POSTS);
$res = $db2->query('SELECT *, "public" AS `type` FROM posts WHERE id IN('.implode(',', $pids).')');
}
//END
//SEARCH WITH MYSQL
else{
$res = $db2->query('SELECT *, "public" AS `type` FROM posts WHERE '.$in_where.' ORDER BY id DESC LIMIT '.$from.', '.$C->PAGING_NUM_POSTS);
}
//END
$tmpposts = array();
$tmpids = array();
$buff = NULL;
$postusrs = array();
while($obj = $db2->fetch_object($res)) {
$buff = new post($obj->type, FALSE, $obj);
if( $buff->error ) {
continue;
}
if( $this->param('from')=='ajax' && $this->param('onlypost')!="" && $this->param('onlypost')!=$buff->post_tmp_id ) {
continue;
}
$D->p = $tmpposts[] = $buff;
$tmpids[] = $buff->post_tmp_id;
$postusrs[] = $buff->post_user->id;
}
unset($buff);
$D->do_not_check_new_comments = TRUE;
$D->if_follow_me = array();
if( count($postusrs)>0 ){
$r = $db2->query('SELECT whom FROM users_followed WHERE whom IN ('.implode(',', $postusrs).') AND who="'.$this->user->id.'"');
while($o = $db2->fetch_object($r)){
if( isset($D->if_follow_me[$o->whom]) ){
continue;
}
$D->if_follow_me[$o->whom] = 1;
}
}
$D->i_follow = array(array($this->network->get_user_follows($this->user->id, FALSE, 'hefollows')->follow_users), 1);
ob_start();
foreach($tmpposts as $tmp) {
$D->p = $tmp;
$D->post_show_slow = FALSE;
if( $this->param('from')=='ajax' && isset($_POST['lastpostdate']) && $D->p->post_date>intval($_POST['lastpostdate']) ) {
$D->post_show_slow = TRUE;
}
if( $this->param('from')=='ajax' && $this->param('onlypost')!="" && $this->param('onlypost')!=$D->p->post_tmp_id ) {
continue;
}
$D->parsedpost_attlink_maxlen = 75;
$D->parsedpost_attfile_maxlen = 71;
if( isset($D->p->post_attached['image']) ) {
$D->parsedpost_attlink_maxlen -= 10;
$D->parsedpost_attfile_maxlen -= 12;
}
if( isset($D->p->post_attached['videoembed']) ) {
$D->parsedpost_attlink_maxlen -= 10;
$D->parsedpost_attfile_maxlen -= 12;
}
$right_post_type = (!$D->p->is_system_post && !$D->p->is_feed_post);
$D->show_my_email = FALSE;
if( isset( $D->if_follow_me[$D->p->post_user->id] ) || $D->p->post_user->id == $this->user->id || $this->user->info->is_network_admin ){
$D->show_my_email = TRUE;
}
$D->protected_profile = FALSE;
if($right_post_type && !$D->show_my_email && $D->p->post_user->is_profile_protected){
$D->protected_profile = TRUE;
}
$D->show_reshared_design = ($D->p->post_resharesnum > 0);
$this->load_template('single_post.php');
}
unset($D->p, $tmp, $tmpposts, $tmpids);
if( $D->num_pages > 1 && !$this->param('onlypost') ) {
$this->load_template('paging_posts.php');
}
$D->posts_html = ob_get_contents();
ob_end_clean();
}
if( $this->param('from') == 'ajax' ) {
echo 'OK:';
echo $D->posts_html;
exit;
}
}
}else{
$D->error = TRUE;
$D->errmsg = $this->lang('srch_noresult_posts_def');
}
}elseif($D->tab == 'tags'){
$D->post_tags = array();
$D->post_tags = $this->network->get_recent_posttags();
$D->saved_searches = array();
$D->saved_searches = $this->user->get_saved_searches();
$D->paging_url = $C->SITE_URL.'search/tab:tags';
if($this->param('s')){
$D->search_string = urldecode($this->param('s'));
}
$D->error = FALSE;
$D->errmsg = '';
if( ! empty($D->search_string) ) {
$tmp = str_replace(array('%','_'), array('\%','\_'), $db2->e($D->search_string));
if( $tmp != '#' ) {
$tmp = preg_replace('/^\#/', '', $tmp);
}
$D->search_string = $tmp;
$in_where = '';
$not_in_groups = array();
$without_users = array();
if( !$this->user->is_logged || !$this->user->info->is_network_admin ) {
$not_in_groups = array_diff( $this->network->get_private_groups_ids(), $this->user->get_my_private_groups_ids() );
$in_where .= count($not_in_groups)>0 ? ('AND p.group_id NOT IN('.implode(', ', $not_in_groups).')') : '';
$without_users = array_diff( $this->network->get_post_protected_user_ids(), $this->user->get_my_post_protected_follower_ids() );
$in_where .= count($without_users)>0 ? (' AND (p.group_id>0 OR p.user_id NOT IN('.implode(', ', $without_users).'))') : '';
}
$total_count = 0;
//COUNT WITH SPHINX
if( $C->SEARCH_ENGINE == 'sphinx' ){
$txt_to_search = str_replace(array('%','_'), array('\%','\_'), $db2->e($D->search_string));
$pids = array();
$search = new search_sphinx();
$pids = $search->do_search_tags($txt_to_search, $not_in_groups);
$total_count = count($pids);
}
//END
//COUNT WITH MYSQL
else{
$total_count = $db2->fetch_field('SELECT COUNT(DISTINCT t.post_id) FROM post_tags t LEFT JOIN posts p ON p.id=t.post_id WHERE t.tag_name="'.$db2->e($D->search_string).'" '.$in_where.' ');
}
//END
$D->num_results = $total_count;
$tmp_url = trim($_SERVER['REQUEST_URI'], '/');
$tmp_url = preg_replace('/(^|\/)pg\:[^\/]*/iu', '', $tmp_url);
$tmp_url = preg_replace('/(^|\/)from\:[^\/]*/iu', '', $tmp_url);
$tmp_url = preg_replace('/(^|\/)r\:[^\/]*/iu', '', $tmp_url);
$tmp_url = preg_replace('/\/+/', '/', $tmp_url);
$tmp_url = '/'.trim($tmp_url, '/');
$D->ajax_url = str_replace('/search/', '/search/from:ajax/', $tmp_url);
$D->paging_url .= '/s:'.$D->search_string.'/pg:';
if( $D->num_results == 0 ) {
$D->error = TRUE;
$D->errmsg = $this->lang('srch_noresult_posts_def');
}
else {
$D->num_pages = ceil($D->num_results / $C->PAGING_NUM_POSTS);
$D->pg = $this->param('pg') ? intval($this->param('pg')) : 1;
$D->pg = min($D->pg, $D->num_pages);
$D->pg = max($D->pg, 1);
$from = ($D->pg - 1) * $C->PAGING_NUM_POSTS;
//SEARCH WITH SPHINX
if( $C->SEARCH_ENGINE == 'sphinx' ){
$pids = array_slice($pids, $from, $C->PAGING_NUM_POSTS);
$res = $db2->query('SELECT *, "public" AS `type` FROM posts WHERE id IN('.implode(',', $pids).')');
}
//END
//SEARCH WITH MYSQL
else{
$res = $db2->query('SELECT *, "public" AS `type` FROM post_tags t LEFT JOIN posts p ON p.id=t.post_id WHERE t.tag_name="'.$db2->e($D->search_string).'" '.$in_where.' GROUP BY t.post_id ORDER BY t.id DESC LIMIT '.$from.', '.$C->PAGING_NUM_POSTS);
}
//END 
