".$L['plu_querytooshort']."

"; unset($a); } else { $sq = sed_sql_prep($sq); $words = explode(" ", $sq); $words_count = count($words); if ($words_count>$cfg_maxwords) { $plugin_body .= "

".$L['plu_toomanywords']." ".$cfg_maxwords."

"; unset($a); } } } if ($a=='search') { $sqlsearch = implode("%", $words); $sqlsearch = "%".$sqlsearch."%"; if (!$cfg['disable_page']) { $pag_sub = sed_import('pag_sub','P','ARR'); if (!is_array($pag_sub) || $pag_sub[0]=='all') { $sqlsections = ''; } else { $sub = array(); foreach($pag_sub as $i => $k) { $sub[] = "page_cat='".sed_sql_prep($k)."'"; } $sqlsections = "AND (".implode(' OR ', $sub).")"; } $pagsql = "(p.page_title LIKE '".$sqlsearch."' OR p.page_text LIKE '".sed_sql_prep($sqlsearch)."') AND "; $sql = sed_sql_query("SELECT page_id, page_ownerid, page_title, page_cat, page_date from $db_pages p, $db_structure s WHERE $pagsql (p.page_title LIKE '".$sqlsearch."' OR p.page_text LIKE '".sed_sql_prep($sqlsearch)."') AND p.page_cat=s.structure_code AND p.page_cat NOT LIKE 'system' $sqlsections2 $sqlsections ORDER by page_date DESC LIMIT $cfg_maxitems"); $items = sed_sql_numrows($sql); $plugin_body .= "

".$L['Pages'].", ".$L['plu_found']." ".$items." ".$L['plu_match'].":

"; if ($items>0) { $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; while ($row = sed_sql_fetchassoc($sql)) { if (sed_auth('page', $row['page_cat'], 'R')) { $ownername = sed_sql_fetchassoc(sed_sql_query("SELECT user_name FROM $db_users WHERE user_id='".$row['page_ownerid']."'")); $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; } } $plugin_body .= "
".$L['Category']."".$L['Page']."".$L['Date']."".$L['Owner']."
".$sed_cat[$row['page_cat']]['tpath']."".sed_cc($row['page_title'])."".@date($cfg['dateformat'], $row['page_date'] + $usr['timezone'] * 3600)."".sed_build_user($row['page_ownerid'], $ownername['user_name'])."
"; } } if (!$cfg['disable_forums']) { $frm_sub = sed_import('frm_sub','P','ARR'); if (!is_array($frm_sub) || $frm_sub[0]==9999) { $sqlsections = ''; } else { foreach($frm_sub as $i => $k) { $sections1[] = "s.fs_id='".sed_sql_prep($k)."'"; } $sqlsections = "AND (".implode(' OR ', $sections1).")"; } $sql = sed_sql_query("SELECT p.fp_id, t.ft_firstposterid, t.ft_firstpostername, t.ft_title, t.ft_id, t.ft_updated, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s WHERE 1 AND (p.fp_text LIKE '".sed_sql_prep($sqlsearch)."' OR t.ft_title LIKE '".sed_sql_prep($sqlsearch)."') AND p.fp_topicid=t.ft_id $frm_reply AND p.fp_sectionid=s.fs_id $sqlsections GROUP BY t.ft_id ORDER BY ft_updated DESC LIMIT $cfg_maxitems"); $items = sed_sql_numrows($sql); $plugin_body .= "

".$L['Forums'].", ".$L['plu_found']." ".$items." ".$L['plu_match']." :

"; if ($items>0) { $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; while ($row = sed_sql_fetchassoc($sql)) { if (sed_auth('forums', $row['fs_id'], 'R')) { $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; } } $plugin_body .= "
".$L['Section']."".$L['Topic']."".$L['Date']."".$L['Poster']."
".sed_build_forums($row['fs_id'], $row['fs_title'], $row['fs_category'], TRUE)."".sed_cc($row['ft_title'])."".@date($cfg['dateformat'], $row['ft_updated'] + $usr['timezone'] * 3600)."".sed_build_user($row['ft_firstposterid'],$row['ft_firstpostername'])."
"; } } } $plugin_body .= "

 

"; $plugin_body .= "
"; $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; if (!$cfg['disable_page']) { $plugin_body .= ""; $plugin_body .= ""; $plugin_body .= ""; } $plugin_body .= ""; $plugin_body .= "
".$L['plu_searchin']." :
".$L['Pages']."
".$L['Forums']."
"; ?>