phpBB.de

Code: Alles auswählen

 
			case 'friendssearch':
                	        $friends_id_ary = array();
                	        
                                $sql = 'SELECT zebra_id
                                        FROM ' . ZEBRA_TABLE . '
                                        WHERE user_id = ' . $user->data['user_id'] . '
                                                AND friend = 1';
                                $result = $db->sql_query($sql);
                                
                                while ($row = $db->sql_fetchrow($result))
                                {
                                        $friends_id_ary[] = $row['zebra_id'];
                                }
                                
                                if (!sizeof($friends_id_ary))
                                {
                                        trigger_error('NO_FRIENDS');
                                }
                                			
				$l_search_title = $user->lang['SEARCH_FRIENDS'];
						
				$show_results = 'posts';
				$sort_key = 't';
				$sort_dir = 'd';
				$sort_by_sql['t'] = 'p.post_time';
				$sql_sort = 'ORDER BY ' . $sort_by_sql[$sort_key] . (($sort_dir == 'a') ? ' ASC' : ' DESC');

				gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);
				$s_sort_key = $s_sort_dir = $u_sort_param = $s_limit_days = '';
                                
				$sql = 'SELECT p.post_id
					FROM ' . POSTS_TABLE . ' p
					WHERE ' . $db->sql_in_set('p.poster_id', $friends_id_ary) . "
						$m_approve_fid_sql
						" . ((sizeof($ex_fid_ary)) ? ' AND ' . $db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '') . "
					$sql_sort";
				$field = 'post_id';				
			break;
			

Code: Alles auswählen

                                if (!sizeof($friends_id_ary))
                                {
                                        trigger_error('NO_FRIENDS');
                                }

Code: Alles auswählen

$friends_id_ary[] = $user->data['user_id'];

Code: Alles auswählen

			case 'egosearch':
				$l_search_title = $user->lang['SEARCH_SELF'];
			break;

Code: Alles auswählen

			case 'egosearch':
            $self_id_ary[] = $user->data['user_id'];
				$l_search_title = $user->lang['SEARCH_SELF'];
			break;

Code: Alles auswählen

               WHERE ' . $db->sql_in_set('p.poster_id', $friends_id_ary) . "

Code: Alles auswählen

               AND p.topic_id = 2