<?PHP

/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_LDU]
File=plugins/extended/arama/arama.php
Version=801
Updated=2005-oct-10
Type=Plugin
Author=Neocrome
Description=
[END_LDU]

[BEGIN_LDU_EXTPLUGIN]
Code=arama
Part=main
File=arama
Hooks=standalone
Tags=
Minlevel=0
Order=10
[END_LDU_EXTPLUGIN]

==================== */

if (!defined('LDU_CODE') || !defined('LDU_PLUG')) { die('Wrong URL.'); }

$cfg_maxwords = 4;
$cfg_maxitems = 100;
$cfg_maxlen = 40;

$sq = cv('sq','P','STX');
$pre = cv('pre','G','STX');
$a = cv('a','G','STX');

$frm = cv('frm','G','BOL');
$use = cv('use','G','BOL');
$pag = cv('pag','G','BOL');
$lnk = cv('lnk','G','BOL');
$evn = cv('evn','G','BOL');
$nws = cv('nws','G','BOL');

$searchin_frm = cv('searchin_frm','P','BOL');
$searchin_use = cv('searchin_use','P','BOL');
$searchin_pag = cv('searchin_pag','P','BOL');
$searchin_lnk = cv('searchin_lnk','P','BOL');
$searchin_evn = cv('searchin_evn','P','BOL');
$searchin_nws = cv('searchin_nws','P','BOL');

If ($frm+$use+$pag+$lnk+$evn+$searchin_frm+$searchin_use+$searchin_pag+$searchin_lnk+$searchin_evn+$searchin_nws==0)
{
$frm = 1;
$use = 1;
$pag = 1;
$lnk = 1;
$evn = 1;
$nws = 1;
}

$prechecked_frm = ($frm || $searchin_frm) ? "checked=\"checked\"": '';
$prechecked_use = ($use || $searchin_use) ? "checked=\"checked\"": '';
$prechecked_pag = ($pag || $searchin_pag) ? "checked=\"checked\"": '';
$prechecked_lnk = ($lnk || $searchin_lnk) ? "checked=\"checked\"": '';
$prechecked_evn = ($evn || $searchin_evn) ? "checked=\"checked\"": '';
$prechecked_nws = ($nws || $searchin_nws) ? "checked=\"checked\"": '';
$sq = (!empty($pre)) ? $pre : $sq;

$plugin_title = $L['Search'];

if ($a=='arama')
{
if (strlen($sq)<3)
{
$plugin_body .= "<p>".$L['plu_querytooshort']."</p>";
unset ($searchin_frm, $prechecked_use, $prechecked_pag, $prechecked_lnk, $prechecked_evn, $a);
}

$sq = ldu_addslashes($sq);

$words = explode(" ", $sq);
$words_count = count($words);

if ($words_count > $cfg_maxwords)
{
$plugin_body .= "<p>".$L['plu_toomanywords']." ".$cfg_maxwords."</p>";
$a = '';
}

$sqlsearch = implode("%", $words);
$sqlsearch = "%".$sqlsearch."%";

if ($searchin_frm && !$cfg['disableforums'])
{
$frm_sub = cv('frm_sub','P','ARR');

if ($frm_sub[0]==9999)
{ $sqlsections = ''; }
       else
        {
foreach($frm_sub as $i => $k)
    { $sections1[] = "s.fs_id='".$k."'"; }
$sqlsections = "AND (".implode(' OR ', $sections1).")";
}

$sql = ldu_mysql_query("SELECT p.fp_id, t.ft_title, t.ft_id, s.fs_id, s.fs_title
FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s
WHERE s.fs_minlevel<='".$usr['level']."'
AND (p.fp_text LIKE '$sqlsearch' OR t.ft_title LIKE '$sqlsearch')
AND p.fp_topicid=t.ft_id
AND p.fp_sectionid=s.fs_id $sqlsections
GROUP BY t.ft_id ORDER BY fp_id DESC
LIMIT $cfg_maxitems");

$items = mysql_num_rows($sql);
$plugin_body .= "<h4>".$L['Forums']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>";

while ($row = mysql_fetch_array($sql))
{
$plugin_body .= "<a href=\"forums.php?m=topics&amp;s=".$row['fs_id']."\">".stripslashes($row['fs_title'])."</a> ".$cfg['separator']." <a href=\"forums.php?m=posts&amp;p=".$row['fp_id']."#".$row['fp_id']."\">".stripslashes($row['ft_title'])."</a><br />";
}
$sections++;
}

if ($searchin_use)
{
$use_sub = cv('use_sub','P','INT');
$sqlrows = "user_id, user_name";
$sqltarget = "user_name";

$sql = ldu_mysql_query("SELECT $sqlrows FROM $db_users WHERE $sqltarget LIKE '$sqlsearch' AND user_level<60 ORDER BY user_name ASC LIMIT $cfg_maxitems");

$items = mysql_num_rows($sql);
$plugin_body .= "<h4>".$L['Users']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>";

while ($row = mysql_fetch_array($sql))
{
$plugin_body .= ldu_build_user($row['user_id'],$row['user_name']);

switch($use_sub)
{
case '1':
$plugin_body .= " (".ldu_build_website($row['user_website']).")";
break;

case '2':
$plugin_body .= " (".ldu_cc(stripslashes($row['user_location'])).")";
break;

case '3':
$plugin_body .= " (".ldu_cc(stripslashes($row['user_occupation'])).")";
break;

default:
//
break;
}

$plugin_body .= "<br />";
}
$sections++;
}

if ($searchin_nws && !$cfg['disablenews'])
{
$nws_sub = cv('nws_sub','P','ARR');

if ($nws_sub[0]=='all')
{ $sqlsections = ''; }
       else
        {
        $sub = array();
foreach($nws_sub as $i => $k)
    { $sub[] = "news_cat='".$k."'"; }
$sqlsections = "AND (".implode(' OR ', $sub).")";
}

        $sql  = ldu_mysql_query("SELECT news_id, news_title, news_cat from $db_news n, $db_structure s
    WHERE (n.news_text LIKE '$sqlsearch' OR n.news_title LIKE '$sqlsearch')
        AND n.news_state='0'
        AND n.news_cat=s.structure_code
        AND n.news_cat NOT LIKE 'system'
        AND s.structure_minlevel<='".$usr['level']."' $sqlsections
        ORDER by news_cat ASC, news_title ASC
        LIMIT $cfg_maxitems");

$items = mysql_num_rows($sql);
$plugin_body .= "<h4>".$L['News']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>";

while ($row = mysql_fetch_array($sql))
{
$plugin_body .= "<a href=\"index.php?c=".$row['news_cat']."\">".$ldu_cat[$row['news_cat']]['tpath']."</a>";
$plugin_body .= " ".$cfg['separator']." "."<a href=\"index.php?m=haber&amp;id=".$row['news_id']."\">";
$plugin_body .= ldu_cc(ldu_cutstring(stripslashes($row['news_title']),$cfg_maxlen))."</a><br />";
}
$sections++;
}


if ($searchin_pag && !$cfg['disablepages'])
{
$pag_sub = cv('pag_sub','P','ARR');

if ($pag_sub[0]=='all')
{ $sqlsections = ''; }
       else
        {
        $sub = array();
foreach($pag_sub as $i => $k)
    { $sub[] = "page_cat='".$k."'"; }
$sqlsections = "AND (".implode(' OR ', $sub).")";
}

        $sql  = ldu_mysql_query("SELECT page_id, page_title, page_cat from $db_pages p, $db_structure s
    WHERE (p.page_text LIKE '$sqlsearch' OR p.page_title LIKE '$sqlsearch'
        OR p.page_desc LIKE '$sqlsearch')
        AND p.page_state='0'
        AND p.page_cat=s.structure_code
        AND p.page_cat NOT LIKE 'system'
        AND s.structure_minlevel<='".$usr['level']."' $sqlsections
        ORDER by page_cat ASC, page_title ASC
        LIMIT $cfg_maxitems");

$items = mysql_num_rows($sql);
$plugin_body .= "<h4>".$L['Pages']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>";

while ($row = mysql_fetch_array($sql))
{
$plugin_body .= "<a href=\"list.php?c=".$row['page_cat']."\">".$ldu_cat[$row['page_cat']]['tpath']."</a>";
$plugin_body .= " ".$cfg['separator']." "."<a href=\"page.php?id=".$row['page_id']."\">";
$plugin_body .= ldu_cc(ldu_cutstring(stripslashes($row['page_title']),$cfg_maxlen))."</a><br />";
}
$sections++;
}

if ($searchin_lnk && !$cfg['disablelinks'])
{
$lnk_sub = cv('lnk_sub','P','ARR');

if ($lnk_sub[0]=='all')
{ $sqlsections = ''; }
       else
        {
        $sub = array();
foreach($lnk_sub as $i => $k)
    { $sub[] = "link_cat='".$k."'"; }
$sqlsections = "AND (".implode(' OR ', $sub).")";
}

        $sql  = ldu_mysql_query("SELECT link_id, link_title, link_desc, link_cat from $db_links l, $db_structure s
    WHERE (l.link_title LIKE '$sqlsearch' OR l.link_desc LIKE '$sqlsearch')
        AND l.link_state='0'
        AND l.link_cat=s.structure_code
        AND l.link_cat NOT LIKE 'system'
        AND s.structure_minlevel<='".$usr['level']."' $sqlsections
        ORDER by link_cat
        LIMIT $cfg_maxitems");

$items = mysql_num_rows($sql);
$plugin_body .= "<h4>".$L['Links']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>";

while ($row = mysql_fetch_array($sql))
{
$plugin_body .= "<a href=\"links.php?c=".$row['link_cat']."\">".$ldu_cat[$row['link_cat']]['tpath']."</a>";
$plugin_body .= " ".$cfg['separator']." "."<a href=\"links.php?a=jump&id=".$row['link_id']."\">";
$plugin_body .= ldu_cc(ldu_cutstring(stripslashes($row['link_title']),$cfg_maxlen))."</a> (";
$plugin_body .= ldu_cc(ldu_cutstring(stripslashes($row['link_desc']),$cfg_maxlen)).")<br />";
}
$sections++;
}

if ($searchin_evn && !$cfg['disableevents'])
{
$evn_sub = cv('evn_sub','P','ARR');

if ($evn_sub[0]=='all')
{ $sqlsections = ''; }
       else
        {
        $sub = array();
foreach($evn_sub as $i => $k)
    { $sub[] = "event_cat='".$k."'"; }
$sqlsections = "AND (".implode(' OR ', $sub).")";
}

        $sql  = ldu_mysql_query("SELECT event_id, event_title, event_cat from $db_events e, $db_structure s
    WHERE (e.event_title LIKE '$sqlsearch' OR e.event_text LIKE '$sqlsearch')
        AND e.event_state='0'
        AND e.event_cat=s.structure_code
        AND e.event_cat NOT LIKE 'system'
        AND s.structure_minlevel<='".$usr['level']."' $sqlsections
        ORDER by event_cat
        LIMIT $cfg_maxitems");

$items = mysql_num_rows($sql);
$plugin_body .= "<h4>".$L['Events']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>";

while ($row = mysql_fetch_array($sql))
{
$plugin_body .= "<a href=\"events.php?c=".$row["event_cat"]."\">".$ldu_cat[$row['event_cat']]['tpath']."</a>";
$plugin_body .= " ".$cfg['separator']." "."<a href=\"events.php?m=details&amp;id=".$row['event_id']."\">";
$plugin_body .= ldu_cc(ldu_cutstring(stripslashes($row['event_title']),$cfg_maxlen))."</a><br />";
}
$sections++;
}
}

$plugin_body .= "<form id=\"search\" action=\"gonder.php?e=arama&a=arama\" method=\"post\"><p>".$L['plu_searchin1'];
$plugin_body .= "<input type=\"text\" class=\"text\" name=\"sq\" value=\"".stripslashes($sq)."\" size=\"16\" maxlength=\"32\" />";
$plugin_body .= $L['plu_searchin2']." &nbsp; <a href=\"gonder.php?e=arama\">".$L['Refresh']."</a></p>";
$plugin_body .= "<table class=\"cells\">";

if (!$cfg['disableforums'])
{
$plugin_body .= "<tr><td>".$L['plu_sections']."</td>";
$plugin_body .= "<td>".$L['plu_options']."</td></tr>";

$sql1 = ldu_mysql_query("SELECT fs_id,fs_title,fs_category FROM $db_forum_sections WHERE fs_minlevel<='".$usr['level']."' ORDER by fs_order,fs_title");

$plugin_body .= "<tr><td><input type=\"checkbox\" class=\"checkbox\" name=\"searchin_frm\" $prechecked_frm value=\"1\" /> ";
$plugin_body .= $L['Forums']."</td><td><select multiple name=\"frm_sub[]\" size=\"5\">";
$plugin_body .= "<option value=\"9999\" selected=\"selected\">".$L['plu_allsections']."</option>";

while ($row1 = mysql_fetch_array($sql1))
{
$fs_category = ldu_cutstring(stripslashes($row1['fs_category']), $cfg_maxlen);
$fs_title = ldu_cutstring(stripslashes($row1['fs_title']), $cfg_maxlen);
$plugin_body .= "<option value=\"".$row1["fs_id"]."\">".$fs_category." > ".$fs_title."</option>";
}

$plugin_body .= "</select></td></tr>";
}

if (!$cfg['disablenews'])
{
reset($ldu_cat);

$plugin_body .= "<tr><td><input type=\"checkbox\" class=\"checkbox\" name=\"searchin_nws\" $prechecked_nws value=\"1\" /> ";
$plugin_body .= $L['News']."</td><td><select multiple name=\"nws_sub[]\" size=\"5\">";
$plugin_body .= "<option value=\"all\" selected=\"selected\">".$L['plu_allcategories']."</option>";

while (list($i,$x) = each($ldu_cat))
{
if ($i!='all' && $i!='system' && $x['news'])
{
$selected = ($i == $check) ? "selected=\"selected\"" : '';
$plugin_body .= "<option value=\"".$i."\" $selected> ".$x['tpath']."</option>";
}
}

$plugin_body .= "</select></td></tr>";
}

if (!$cfg['disablepages'])
{
reset($ldu_cat);

$plugin_body .= "<tr><td><input type=\"checkbox\" class=\"checkbox\" name=\"searchin_pag\" $prechecked_pag value=\"1\" /> ";
$plugin_body .= $L['Pages']."</td><td><select multiple name=\"pag_sub[]\" size=\"5\">";
$plugin_body .= "<option value=\"all\" selected=\"selected\">".$L['plu_allcategories']."</option>";

while (list($i,$x) = each($ldu_cat))
{
if ($i!='all' && $i!='system' && $x['pages'])
{
$selected = ($i == $check) ? "selected=\"selected\"" : '';
$plugin_body .= "<option value=\"".$i."\" $selected> ".$x['tpath']."</option>";
}
}

$plugin_body .= "</select></td></tr>";
}

if (!$cfg['disablelinks'])
{
reset($ldu_cat);

$plugin_body .= "<tr><td><input type=\"checkbox\" class=\"checkbox\" name=\"searchin_lnk\" $prechecked_lnk value=\"1\" /> ";
$plugin_body .= $L['Links']."</td><td><select multiple name=\"lnk_sub[]\" size=\"5\">";
$plugin_body .= "<option value=\"all\" selected=\"selected\">".$L['plu_allcategories']."</option>";

while (list($i,$x) = each($ldu_cat))
{
if ($i!='all' && $i!='system' && $x['links'])
{
$selected = ($i == $check) ? "selected=\"selected\"" : '';
$plugin_body .= "<option value=\"".$i."\" $selected> ".$x['tpath']."</option>";
}
}

$plugin_body .= "</select></td></tr>";
}

if (!$cfg['disableevents'])
{
reset($ldu_cat);

$plugin_body .= "<tr><td><input type=\"checkbox\" class=\"checkbox\" name=\"searchin_evn\" $prechecked_evn value=\"1\" /> ";
$plugin_body .= $L['Events']."</td><td><select multiple name=\"evn_sub[]\" size=\"5\">";
$plugin_body .= "<option value=\"all\" selected=\"selected\">".$L['plu_allcategories']."</option>";

while (list($i,$x) = each($ldu_cat))
{
if ($i!='all' && $i!='system' && $x['events'])
{
$selected = ($i == $check) ? "selected=\"selected\"" : '';
$plugin_body .= "<option value=\"".$i."\" $selected> ".$x['tpath']."</option>";
}
}

$plugin_body .= "</select></td></tr>";
}

$plugin_body .= "<tr><td><input type=\"checkbox\" class=\"checkbox\" name=\"searchin_use\" $prechecked_use value=\"1\" /> ";
$plugin_body .= $L['Users']."</td><td>&nbsp;</td></tr>";

$plugin_body .= "</table><br /></select><input type=\"submit\" class=\"submit\" value=\"".$L['Search']."\" /></form>";

?>