<?php
require("global.php");
require_once(PHP168_PATH."inc/class.inc.php");
$Guidedb=new Guide_DB;

$keyword=str_replace("%","\%",$keyword);
$keyword=trim($keyword);
$rows=20;


if( ($_GET[type]||$_POST[type]) && !$keyword )
{
	showerr("關鍵字不能為空");
}


if( $_GET[keyword] || $_POST[keyword] )
{
	if(!$type)
	{
		$type='title';
	}
	if(!$lfjid)
	{
		showerr("請先登錄!");
	}
	if($type!='title'&&$type!='id'&&$type!='username'&&$type!='content')
	{
		$type='title';
	}

	if($_COOKIE[searchTime])
	{
		showerr("3秒鐘內(nèi),請不要重復提交查詢");
	}
	setcookie("searchTime",1,$timestamp+3);

	$SQL='';


	if($type=='title')
	{
		$SQL=" BINARY title LIKE '%$keyword%' ";
	}
	elseif($type=='id')
	{
		$SQL=" id = '$keyword' ";
	}
	elseif($type=='username')
	{
		$SQL="BINARY username LIKE '%$keyword%'";
	}
	elseif($type=='content')
	{
		$SQL="BINARY content LIKE '%$keyword%'";
	}
	$_SQL="";
	if($fid){
		$_SQL=" AND fid='$fid' ";
	}

	if($page<1)
	{
		$page=1;
	}
	$min=($page-1)*$rows;

	$query = $db->query("SELECT * FROM {$pre}mv_video WHERE $SQL $_SQL ORDER BY id DESC LIMIT $min,$rows");
	while($rs = $db->fetch_array($query))
	{
		$rs[posttime] = date("Y-m-d",$rs[posttime]);
		$listdb[] = $rs;
	}
	
	if(!$listdb)
	{
		showerr("很抱歉,沒有找到你要查詢的內(nèi)容");
	}

	$showpage=getpage("{$pre}mv_video","WHERE $SQL $_SQL","search.php?fid=$fid&type=$type&keyword=".urlencode($_POST[keyword]).urlencode($_GET[keyword])."",$rows);
	$typedb[$type]=' selected ';
}
$sort_fid=$Guidedb->Select("{$pre}mv_sort","fid",$fid);
require("head.php");
require(getTpl("search"));
require("foot.php");

?>