<?
/* ========================================================================================
 * WMNews Version 0.3
 *    Another PHP & MySQL driven News Publishing system
 *
 * Filename		: search.php
 * Description	: Part of WMNews, news search engine
 * Last Updated	: Thursday, November 20, 2003 12:37:44 PM
 * Latest Version	: http://wartamikael.org/PHPScripts/
 *
 * Copyright (c) 2001-2003 Rudy S. Ingga (toekangweb@wartamikael.org). All rights reserved.
 *
 * This program is free software; you can redistribute it and/or modify 
 * it under the terms of the GNU General Public License as published by 
 * the Free Software Foundation; either version 2 of the License, or 
 * (at your option) any later version. 
 *
 * This program is distributed in the hope that it will be useful, 
 * but WITHOUT ANY WARRANTY; without even the implied warranty of 
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 
 * GNU General Public License for more details. 
 * 
 * You should have received a copy of the GNU General Public License 
 * along with this program; if not, write to the Free Software 
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA 
 * ========================================================================================
 */

/* ----------------------------------------- *
 * Tables, configuration and library we need *
 * ----------------------------------------- */
$article_catfile = "WMNCat";
$article_file = "WMNArticle";
$members_file = "WMLMembers";

if(!isset($config)){ include("config/config.php"); }
if(!isset($lib_lib)){ include("libs/lib-wmlib.php"); }
if(!isset($lib_user)){ include("libs/lib-wmuser.php"); }
if(!isset($lib_news)){ include("libs/lib-wmnews.php"); }

/* ----------------------- */
function GetCat($ArtPCat=0){
/* ----------------------- */
	global $article_catfile, $db;
	$return = "WHERE ArtCat = '" . $ArtPCat . "'";
	$CatID = $ArtPCat;
	$get_cats = mysql_query("SELECT * FROM $article_catfile WHERE ArtPCat = '$ArtPCat' ORDER BY ArtDesc ASC", $db);
	if(mysql_num_rows($get_cats) != "0"){
		while($get_rows = mysql_fetch_array($get_cats)){
			$CatID .= "," . $get_rows['ArtCat'];
			$CatID .= GetSubCat($get_rows['ArtCat']);
		}
	}
	return "(" . $CatID . ")";
}

/* ------------------------ */
function GetSubCat($ArtPCat){
/* ------------------------ */
	global $article_catfile, $db;
	$SubCatID = "";
	$get_subcats = mysql_query("SELECT * FROM $article_catfile WHERE ArtPCat = '$ArtPCat' ORDER BY ArtDesc ASC", $db);
	if(mysql_num_rows($get_subcats) != "0"){
		while($get_subrows = mysql_fetch_array($get_subcats)){
			$SubCatID .= "," . $get_subrows['ArtCat'];
			$SubCatID .= GetSubCat($get_subrows['ArtCat']);
		}
		return $SubCatID;
	}
}

$page_title = $T_SRC_JDL;

if($term){
	$where = "";
	$term = trim($term);
	if($keyphrase == "key"){
		$termexpl = explode(" ", $term);
		$where = "(";
		while(list($k,$v) = each($termexpl)){
			if($cs == "1"){
				if($where != "("){ $where .= " OR "; }
				$where .= "$article_file.ArtTitle LIKE '%$v%' OR $article_file.ArtLead LIKE '%$v%' OR $article_file.ArtMsg LIKE '%$v%' OR $members_file.MbName LIKE '%$v%'";
			}else{
				if($cj == "1"){
					if($where != "("){ $where .= " OR "; }
					$where .= "($article_file.ArtTitle LIKE '%$v%')";
				}
				if($cl == "1"){
					if($where != "("){ $where .= " OR "; }
					$where .= "($article_file.ArtLead LIKE '%$v%')";
				}
				if($ci == "1"){
					if($where != "("){ $where .= " OR "; }
					$where .= "($article_file.ArtMsg LIKE '%$v%')";
				}
				if($ca == "1"){
					if($where != "("){ $where .= " OR "; }
					$where .= "($members_file.MbName LIKE '%$v%')";
				}
			}
		}
		$where .= ")";
	}else{
		if($cs == "1"){
			$where .= "($article_file.ArtTitle LIKE '%$term%' OR $article_file.ArtLead LIKE '%$term%' OR $article_file.ArtMsg LIKE '%$term%' OR $members_file.MbName LIKE '%$term%')";
		}else{
			if($cj == "1"){
				if($where != ""){ $where .= " OR "; }
				$where .= "($article_file.ArtTitle LIKE '%$term%')";
			}
			if($cl == "1"){
				if($where != ""){ $where .= " OR "; }
				$where .= "($article_file.ArtLead LIKE '%$term%')";
			}
			if($ci == "1"){
				if($where != ""){ $where .= " OR "; }
				$where .= "($article_file.ArtMsg LIKE '%$term%')";
			}
			if($ca == "1"){
				if($where != ""){ $where .= " OR "; }
				$where .= "($members_file.MbName LIKE '%$term%')";
			}
		}
	}
	if(!isset($pos)){$pos=0;}
	if(!isset($perpage)){$perpage=$step;}
	$temp_pos = $pos;
/*
	if(isset($ArtCat)){
		if($ArtCat > 0){$where .= " AND $article_file.ArtCat='$ArtCat'";}
	}else{
		$ArtCat = 0;
	}
*/
	/* If not set category, set main category as default. Get related sub categories */
	if(!isset($ArtCat)){ $ArtCat = 0; }
	$InCat = GetCat($ArtCat);

	/* Search Category */
	$query = "SELECT COUNT(ArtCat) AS Total FROM $article_catfile WHERE (ArtCat IN $InCat AND (ArtDesc LIKE '%$term%' OR ArtExpl LIKE '%$term%'))";
	$get_countcat = mysql_query($query, $db);
	$countcat_row = @mysql_fetch_array($get_countcat);
	$numrec_cat = $countcat_row[Total];
	if(!isset($g_column) || $g_column < 1){
		$g_column = 1;
	}
	$td_width = round(100/$g_column,0) . "%";
	$i = 0;
	if($numrec_cat > 0){
$output = <<<EOF
		<table width="100%" cellpadding="1" cellspacing="0" border="0">
			<tr><td width="100%">
				<table width="100%" border="0" cellspacing="1" cellpadding="5">
					<tr><td width="100%" bgcolor="$grey" class="judul" colspan="$g_column">$T_CATEGORY:&nbsp;<font color="$linkcol">$term</font></td></tr>
EOF;
		$query = "SELECT * FROM $article_catfile WHERE (ArtCat IN $InCat AND (ArtDesc LIKE '%$term%' OR ArtExpl LIKE '%$term%')) ORDER BY ArtDesc ASC";
		$get_cats = mysql_query($query, $db);
		while($get_rows = mysql_fetch_array($get_cats)){
			$i++;
			if($i % $g_column == 1){
				$output .= "\n<tr>";
			}
			$img_to_show_thumb = "";
			if($get_rows[ArtThumb] != ""){
				if(file_exists("$base_imgpath/$get_rows[ArtThumb]")){
					$img_to_show_thumb = "<img src=\"$base_url_images/$get_rows[ArtThumb]\" border=\"0\" hspace=\"5\" vspace=\"0\" align=\"left\">";
				}
			}
			$output .= "<td width=\"$td_width\" valign=\"top\">";
			$output .= $img_to_show_thumb . "<a href=\"wmview.php?ArtCat=" . $get_rows[ArtCat] . "\"><span class=\"title\">" . $get_rows[ArtDesc] . "</span></a><br>$get_rows[ArtExpl]";
			$output .= "</td>";
			if($i % $g_column == 0){
				$output .= "</tr>";
			}
		}
		if($i % $g_column != 0){
			while($i % $g_column != 0){
				$output .= "<td width=\"$td_width\">&nbsp;</td>";
				$i++;
			}
			$output .= "</tr>";
		}
		$output .= "</table></td></tr></table>";
	}

	/* Search News */
	$where .= " AND ($article_file.ArtCat IN $InCat)";
	$get_count = mysql_query("SELECT COUNT(ArtID) AS Total FROM $article_file LEFT JOIN $members_file ON ($members_file.MbID = $article_file.ArtPostBy) WHERE $where",$db);
	$count_row = @mysql_fetch_array($get_count);
	$numrec = $count_row[Total];
	$numpage = intval($numrec/$perpage);
	if($numrec % $perpage){ $numpage++; }
$output .= <<<EOF
	<table width="100%" cellpadding="1" cellspacing="0" border="0">
		<tr><td width="100%">
			<table width="100%" border="0" cellspacing="1" cellpadding="5">
				<tr><td width="100%" bgcolor="$grey" class="judul" colspan="3">$T_SRC_RST&nbsp;<font color="$linkcol">$term</font></td></tr>
EOF;
	if($numrec > 0){
		$query = "SELECT * FROM $article_file LEFT JOIN $article_catfile ON ($article_catfile.ArtCat=$article_file.ArtCat) LEFT JOIN $members_file ON ($members_file.MbID=$article_file.ArtPostBy) WHERE $where ORDER BY $article_file.ArtTitle ASC LIMIT $pos,$perpage";
		$get_news = mysql_query($query,$db);
		$i = 0;
		while($get_rows = mysql_fetch_array($get_news)){
			$pretty_time = pretty_time($get_rows[ArtDate],1);
			if($get_rows[MbEmail] != ""){
				$u_realname = "<a href=\"mailto:$get_rows[MbEmail]\">$get_rows[MbName]</a>";
			}else{
				$u_realname = $get_rows[MbName];
			}
			$CatStructure = GetParrentCat($get_rows['ArtCat'],"wmview.php",1);
			if(($i%2) == "1"){
				$bgcolor = $botrowcol;
			}else{
				$bgcolor = $ctrrowcol;
			}
$output .= <<<EOF
			<tr>
				<td bgcolor="$bgcolor" width="1%" valign="top">&#149;</td>
				<td bgcolor="$bgcolor" width="60%" valign="top"><a href="$base_url/wmview.php?ArtID=$get_rows[ArtID]&term=$term">$get_rows[ArtTitle]</a></td>
				<td bgcolor="$bgcolor" width="39%" valign="top" class="title"><a href="$base_url/wmview.php?ArtCat=$get_rows[ArtCat]">$get_rows[ArtDesc]</a></td>
			</tr>
EOF;
			$i++;
		}
	}else{
$output .= <<<EOF
		<tr>
			<td width="1%" valign="top">&#149;</td>
			<td width="99%" valign="top" class="errmsg" colspan="2">$T_SRC_NFO</td>
		</tr>
EOF;
	}
	$output .= "</table></td></tr></table>";
}

/*
$get_cats = mysql_query("SELECT * FROM $article_catfile ORDER BY ArtDesc ASC",$db);
$catoption = "<select name=\"ArtCat\">";
$catoption .= "<option value=\"0\" selected>$T_SRC_ACA</option>";
while($get_rows=mysql_fetch_array($get_cats)){
	if($ArtCat && $get_rows[ArtCat] == $ArtCat){
		$catoption .= "<option value=\"$get_rows[ArtCat]\" selected>$get_rows[ArtDesc]</option>";
	}else{
		$catoption .= "<option value=\"$get_rows[ArtCat]\">$get_rows[ArtDesc]</option>";
	}
}
$catoption.="</select>";
*/
$catoption = GetTreeCat();
$catoption = preg_replace("/ArtPCat/i", "ArtCat", $catoption);
$pattern = "/" . $T_MAINCATEGORY . "/";
$catoption = preg_replace($pattern, $T_SRC_ACA, $catoption);
$size=20;

$s_perpage = array("10", "25", "50");
$s_perpage_opt = "<select name=\"perpage\">";
while(list($k,$v) = each($s_perpage)){
	if($perpage == $v){
		$s_perpage_opt .= "<option value=\"$v\" selected>$v</option>";
	}else{
		$s_perpage_opt .= "<option value=\"$v\">$v</option>";
	}
}
$s_perpage_opt .= "</select>";

$as_key = "<input type=\"radio\" name=\"keyphrase\" value=\"key\"";
if(isset($keyphrase) && $keyphrase == "key"){
	$as_key .= " checked";
}
$as_key .= ">";

$as_phrase = "<input type=\"radio\" name=\"keyphrase\" value=\"phrase\"";
if((isset($keyphrase) && $keyphrase == "phrase") || !isset($keyphrase)){
	$as_phrase .= " checked";
}
$as_phrase .= ">";

$cj_check = "<input type=\"checkbox\" name=\"cj\" value=\"1\"";
if(isset($cj) && $cj == "1"){
	$cj_check .= " checked";
}
$cj_check .= ">";

$cl_check = "<input type=\"checkbox\" name=\"cl\" value=\"1\"";
if(isset($cl) && $cl == "1"){
	$cl_check .= " checked";
}
$cl_check .= ">";

$ci_check = "<input type=\"checkbox\" name=\"ci\" value=\"1\"";
if(isset($ci) && $ci == "1"){
	$ci_check .= " checked";
}
$ci_check .= ">";

$ca_check = "<input type=\"checkbox\" name=\"ca\" value=\"1\"";
if(isset($ca) && $ca == "1"){
	$ca_check .= " checked";
}
$ca_check .= ">";

$cs_check = "<input type=\"checkbox\" name=\"cs\" value=\"1\"";
if(isset($cs) && $cs == "1"){
	$cs_check .= " checked";
}
$cs_check .= ">";

if(!isset($cj) && !isset($cl) && !isset($ci) && !isset($ca)){
	$cs_check = "<input type=\"checkbox\" name=\"cs\" value=\"1\" checked>";
}

$searchform = <<<EOF
	<table width="100%" border="0" cellspacing="5" cellpadding="3">
		<form method=post action="$PHP_SELF">
		<tr><td width="30%" align="right">$T_SRC_KEY</td><td width="70%"><input type="text" name="term" size="$size" maxlength="50" value="$term" class="kotak">&nbsp;&nbsp;$as_key$T_KEYWORD&nbsp;&nbsp;$as_phrase$T_PHRASE</td></tr>
		<tr><td align="right">$T_SRC_CAT</td><td>$catoption</td></tr>
		<tr><td align="right">$T_SRC_OPT</td><td>$cj_check $T_TITLE &nbsp;&nbsp;$cl_check $T_LEAD &nbsp;&nbsp;$ci_check $T_CONTENT &nbsp;&nbsp;$ca_check $T_AUTHOR &nbsp;&nbsp;$cs_check $T_ALL</td></tr>
		<tr><td align="right">$T_SRC_PPG</td><td><table cellpadding="0" cellspacing="1" border="0"><tr><td>$s_perpage_opt&nbsp;</td><td><input type="image" src="$base_url_themes/$theme/images/wm_search.gif" border="0" align="absmiddle"></td></tr></table></td></tr>
		</form>
	</table>
EOF;

if(!isset($output)){$output="";}
$output = theme_opencenter_box($T_SRC_JDL) . $searchform . $output . theme_closecenter_box();
if($numpage > 1){
	$output .= pagespan("$PHP_SELF?term=$term&perpage=$perpage&cj=$cj&cl=$cl&ci=$ci&ca=$ca&cs=$cs&keyphrase=$keyphrase&ArtCat=$ArtCat", $T_NEWS, $T_WITH_S);
}

/* ------------------------------------ *
 * Push what we got above on the screen *
 * ------------------------------------ */
flush();
include("$base_themepath/$theme/header.php");
include("$base_themepath/$theme/body-inside-open.php");
echo $output;
/*
echo "<!-- IT WOULD BE GREAT IF YOU GIVE US CREDIT :) -->";
echo "<p align=center><span class=\"lead\">Managed by <a href=\"http://wartamikael.org/PHPScripts/?product=WMNews\" target=\"_blank\">WMNews</a>, <a href=\"http://www.php.net\" target=\"_blank\">PHP</a> & <a href=\"http://www.mysql.com\" target=\"_blank\">MySQL</a></span>";
*/
include("$base_themepath/$theme/body-inside-close.php");
include("$base_themepath/$theme/footer.php");

?>