source: trunk/www.guidonia.net/wp/wp-content/plugins/odlinks/odl_search.php@ 44

<?php

/*
 * odl_search.php
 * wordpress plugin website directory project
 * @author Mohammad Forgani
 * @copyright Copyright 2008, Oh Jung-Su
 * @version 0.2
 * @link http://www.forgani.com
 */


function odlinksdisplay_search(){
        global $_GET, $_POST, $table_prefix, $wpdb, $PHP_SELF;
        
        $odlinkssettings = get_option('odlinksdata');
        
        $tpl = new ODLTemplate();

        $tpl->assign('odl_images', get_bloginfo('wpurl') . "/wp-content/plugins/odlinks");
        $odl_main_link = odlinkscreate_link("index", array("name"=>"Main"));
        $odl_top_link = odlinkscreate_link("index", array("name"=>$odlinkssettings['page_link_title']));
        $results_limit = 10;
        $tpl->assign('results_limit', $results_limit); 
        $tpl->assign('odl_top_link', $odl_top_link); 
        $tpl->assign('odl_main_link', $odl_main_link); 
        $tpl->assign('odl_wpurl', get_bloginfo('url'));

        $type = $_GET['type'];
        $search_terms = $_GET['search_terms'];
        $tpl->assign('search_terms',$search_terms);

        if(isset($search_terms)){
                $search_terms = stripslashes($_GET['search_terms']);
                $searchwords = addslashes(htmlspecialchars($search_terms));
        }
        
        if(!$searchwords){
                $tpl->assign('odl_search_error', "You didn't search for anything!");
        } else {
                if($type == "links"){
                        $sql ='SELECT * FROM ' . $table_prefix . 'odlinks WHERE MATCH (l_url) AGAINST("'.$searchwords.'" IN BOOLEAN MODE)';
                        $results = $wpdb->get_results($sql);
                        if(!$results){
                                $tpl->assign('odl_search_error', "No posts matched your search terms.");
                        } else {
                                for ($i=0; $i<count($result); $i++){
                                        $row = $result[$i];
                                        $row->fields = round($row->field,3);
                                        $row->title = highlight($row->title,$search_terms);
                                        $row->description = highlight($row->description,$search_terms);
                                        $results[] = $row;
                                }
                                $tpl->assign('search_terms',$search_terms);
                        }
                } elseif($type == "desc"){
                        $sql ='SELECT * FROM ' . $table_prefix. 'odlinks WHERE MATCH (l_title,l_description) AGAINST("'.$searchwords.'" IN BOOLEAN MODE)';
                        $results = $wpdb->get_results($sql);
                        if(!$results){
                                $tpl->assign('odl_search_error', "No posts matched your search terms.");
                        } else {
                                for ($i=0; $i<count($result); $i++){
                                        $row = $result[$i];
                                        $row->title = highlight($row->title,$search_terms);
                                        $row->description = highlight($row->description,$search_terms);
                                        $results[] = $row;
                                }
                                $tpl->assign('search_terms',$search_terms);
                        }
                } else {
                        $sql = 'SELECT * FROM '.$table_prefix.'odpages WHERE MATCH (l_url,l_title,l_description) AGAINST("'.$searchwords.'")';
                        $results = $wpdb->get_results($sql);
                        for ($i=0; $i<count($result); $i++){
                                $row->fields = round($row->field,3);
                                $row->title = highlight($row->title,$search_terms);
                                $row->description = highlight($row->description,$search_terms);
                                $results[] = $row;
                        }
                        $tpl->assign('search_terms',$search_terms);
                }
                
        }
        $tpl->assign('results', $results);
        $odl_search_link=odlinkscreate_link("searchform", array());
        $tpl->assign('odl_search_link', $odl_search_link);
        //$odl_advanced = odlinkscreate_link("searchlink", array("name"=>'Advanced'));
        //$tpl->assign('odl_advanced', $odl_advanced);
        $tpl->display('search.tpl');

}
?>