Project

General

Profile

1
<?php
2

    
3
// $Id: search.php 563 2008-01-18 23:13:42Z Ruebenwurzel $
4

    
5
/*
6

    
7
 Website Baker Project <http://www.websitebaker.org/>
8
 Copyright (C) 2004-2008, Ryan Djurovich
9

    
10
 Website Baker is free software; you can redistribute it and/or modify
11
 it under the terms of the GNU General Public License as published by
12
 the Free Software Foundation; either version 2 of the License, or
13
 (at your option) any later version.
14

    
15
 Website Baker is distributed in the hope that it will be useful,
16
 but WITHOUT ANY WARRANTY; without even the implied warranty of
17
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18
 GNU General Public License for more details.
19

    
20
 You should have received a copy of the GNU General Public License
21
 along with Website Baker; if not, write to the Free Software
22
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
23

    
24
*/
25

    
26
function news_search($func_vars) {
27
	extract($func_vars, EXTR_PREFIX_ALL, 'func');
28

    
29
	// how many lines of excerpt we want to have at most
30
	$max_excerpt_num = $func_default_max_excerpt;
31
	// do we want excerpt from comments?
32
	$excerpt_from_comments = true; // TODO: make this configurable
33
	$divider = ".";
34
	$result = false;
35

    
36
	// fetch all active news-posts (from active groups) in this section.
37
	$table_posts = TABLE_PREFIX."mod_news_posts";
38
	$table_groups = TABLE_PREFIX."mod_news_groups";
39
	$query = $func_database->query("
40
		SELECT p.post_id, p.title, p.content_short, p.content_long, p.link, p.posted_when, p.posted_by
41
		FROM $table_posts AS p LEFT OUTER JOIN $table_groups AS g ON p.group_id = g.group_id
42
		WHERE p.section_id='$func_section_id' AND p.active = '1' AND ( g.active IS NULL OR g.active = '1' )
43
		ORDER BY p.post_id DESC
44
	");
45
	// now call print_excerpt() for every single post
46
	if($query->numRows() > 0) {
47
		while($res = $query->fetchRow()) {
48
			$text = $res['title'].$divider.$res['content_short'].$divider.$res['content_long'].$divider;
49
			// fetch comments and add to $text
50
			if($excerpt_from_comments) {
51
				$table = TABLE_PREFIX."mod_news_comments";
52
				$commentquery = $func_database->query("
53
					SELECT title, comment
54
					FROM $table
55
					WHERE post_id='{$res['post_id']}'
56
					ORDER BY commented_when ASC
57
				");
58
				if($commentquery->numRows() > 0) {
59
					while($c_res = $commentquery->fetchRow()) {
60
						$text .= $c_res['title'].$divider.$c_res['comment'].$divider;
61
					}
62
				}
63
			}
64
			$mod_vars = array(
65
				'page_link' => $res['link'], // use direct link to news-item
66
				'page_link_target' => "",
67
				'page_title' => $func_page_title,
68
				'page_description' => $res['title'], // use news-title as description
69
				'page_modified_when' => $res['posted_when'],
70
				'page_modified_by' => $res['posted_by'],
71
				'text' => $text,
72
				'max_excerpt_num' => $max_excerpt_num
73
			);
74
			if(print_excerpt2($mod_vars, $func_vars)) {
75
				$result = true;
76
			}
77
		}
78
	}
79
	
80
	// now fetch group-titles - ignore those without (active) postings
81
	$table_groups = TABLE_PREFIX."mod_news_groups";
82
	$table_posts = TABLE_PREFIX."mod_news_posts";
83
	$query = $func_database->query("
84
		SELECT DISTINCT g.title, g.group_id
85
		FROM $table_groups AS g INNER JOIN $table_posts AS p ON g.group_id = p.group_id
86
		WHERE g.section_id='$func_section_id' AND g.active = '1' AND p.active = '1'
87
	");
88
	// now call print_excerpt() for every single group, too
89
	if($query->numRows() > 0) {
90
		while($res = $query->fetchRow()) {
91
			$mod_vars = array(
92
				'page_link' => $func_page_link,
93
				'page_link_target' => "&g=".$res['group_id'],
94
				'page_title' => $func_page_title,
95
				'page_description' => $func_page_description,
96
				'page_modified_when' => $func_page_modified_when,
97
				'page_modified_by' => $func_page_modified_by,
98
				'text' => $res['title'].$divider,
99
				'max_excerpt_num' => $max_excerpt_num
100
			);
101
			if(print_excerpt2($mod_vars, $func_vars)) {
102
				$result = true;
103
			}
104
		}
105
	}
106
	return $result;
107
}
108

    
109
?>
(29-29/32)