Location: PHPKode > projects > PBBoard > PBBoard_v2.1.4/Upload/engine/systems/search.class.php
<?php

/**
 * PowerBB Engine - The Engine Helps You To Create Bulletin Board System.
 */
 
/**
 * @package 	: 	PowerBBSearch
 * @author 		: 	Mohammed Q. Hussain <hide@address.com>
 * @updated 	: 	17/07/2008 12:13:54 AM 
 */
 
class PowerBBSearch
{
	var $Engine;
	
	function PowerBBSearch($Engine)
	{
		$this->Engine = $Engine;
	}
	
	function Search($param)
	{
 		if (!isset($param)
 			or !is_array($param))
 		{
 			$param = array();
 		}
 		
      	if ($param['section'] == 'all')
        {
			if (empty($param['username'])
				and !empty($param['keyword']))
            {
				$search_query = $this->Engine->DB->sql_query("SELECT * FROM " . $this->Engine->table['subject'] . " WHERE sec_subject<>'1' AND delete_topic<>'1' AND (text LIKE '%" . $param['keyword'] . "%' OR title LIKE '%" . $param['keyword'] . "%')");
       		}

       		if (!empty($param['username'])
       			and !empty($param['keyword']))
            {
        		$search_query = $this->Engine->DB->sql_query("SELECT * FROM " . $this->Engine->table['subject'] . " WHERE writer='" . $param['username'] . "' AND delete_topic<>'1' AND sec_subject<>'1' AND (text LIKE '%" . $param['keyword'] . "%' OR title LIKE '%" . $param['keyword'] . "%')");
       		}

      	 	if (!empty($param['username'])
      	 		and empty($param['keyword']))
            {
        		$search_query = $this->Engine->DB->sql_query("SELECT * FROM " . $this->Engine->table['subject'] . " WHERE writer='" . $param['username'] . "' AND delete_topic<>'1' AND sec_subject<>'1'");
       		}
      	}
      	else
        {
       		$s_id = $param['section'];

       		if (empty($param['username'])
       			and !empty($param['keyword']))
            {
        		$search_query = $this->Engine->DB->sql_query("SELECT * FROM " . $this->Engine->table['subject'] . " WHERE section='" . $s_id . "' AND delete_topic<>'1' AND sec_subject<>'1' AND (text LIKE '%" . $param['keyword'] . "%' OR title LIKE '%" . $param['keyword'] . "%')");
       		}

       		if (!empty($param['username'])
       			and !empty($param['keyword']))
            {
        		$search_query = $this->Engine->DB->sql_query("SELECT * FROM " . $this->Engine->table['subject'] . " WHERE section='" . $s_id . "' AND writer='" . $param['username'] . "' AND delete_topic<>'1' AND sec_subject<>'1' AND (text LIKE '%" . $param['keyword'] . "%' OR title LIKE '%" . $param['keyword'] . "%')");
       		}

       		if (!empty($param['username'])
       			and empty($param['keyword']))
            {
        		$search_query = $this->Engine->DB->sql_query("SELECT * FROM " . $this->Engine->table['subject'] . " WHERE writer='" . $param['username'] . "' AND delete_topic<>'1' AND section='" . $s_id . "' AND sec_subject<>'1'");
       		}
      	}

		$rows = $this->Engine->records->GetList($search_query,$param);
      	
      	return (is_array($rows)) ? $rows : false;
 	}
}
 
 ?>
Return current item: PBBoard