Thread

{exp:search:search_results disable="member_data|trackbacks" orderby="date" paginate="bottom" limit="30" show_expired="no" show_future_entries="no"}

      {exp:localisation:local_query  local_sql_url_title="content-from-url-title" page_url_title="{url_title}" channel_ids="6,9"} 
      
       
       {exp:query sql="{local_sql_query}" show_future_entries="no" }
           {categories}
     {if category_name == "Videos"} {category_name}
    content
     content
       
    {if:elseif category_name == "Images"} {category_name}
     content
      
     {if:elseif weblog_short_name == "press-releases" AND category_name != "Videos" AND category_name != "Audio" AND category_name != "Images"} {category_name}
      content
      
      
      
     {if:elseif weblog_short_name == "articles" AND category_name != "Videos" AND category_name != "Audio"  AND category_name != "Images"} {category_name}
     
       content
      

    
     {if:elseif weblog_short_name == "press-kits" AND category_name != "Videos" AND category_name != "Audio" AND category_name != "Images"} {category_name}
     content
      


     
     {/if}
    
    
    {/categories}
           {/exp:query}
       
       
      {/exp:localisation:local_query } 
    {/exp:search:search_results}

function local_query(){
  
   global $TMPL;
   global $DB; 
   $url_title = $TMPL->fetch_param('local_sql_url_title');
   $page_url_title = $TMPL->fetch_param('page_url_title');
   $category_url_title = $TMPL->fetch_param('category_url_title');
   $channel_ids = $TMPL->fetch_param('channel_ids');
   $result_limit = $TMPL->fetch_param('result_limit');
   
   /*when we build the SQL string, we may or may not need to set a result limit.  
   The format for the result limit will be "startFromInt,returnRowsInt" (e.g. 0,5 to start at teh beginning and return five rows.
   We still need to add the keyword LIMIT to make this work in SQL
   */
   if(isset($result_limit)){
   if(strlen($result_limit) >= 1){
    $result_limit = " LIMIT ".$result_limit ;
    } 
   }
   
   
   // get sql from channel/weblog
  
   //get weblog_id and entry_id from title table using the local sql title param passed in     
   $title_table_query = "SELECT entry_id, weblog_id from exp_weblog_titles where url_title ='".$DB->escape_str($url_title)."'";
   $title_table_results = $DB->query($title_table_query);
    
   //get the sql from the weblog_data table using using the weblog_id and entry_id from the previous query
    $data_table_query = "SELECT field_id_61 FROM exp_weblog_data WHERE weblog_id =".$title_table_results->row['weblog_id']."  AND entry_id =". $title_table_results->row['entry_id'];
    $data_table_results =  $DB->query($data_table_query);
    
   //Find and replace {cookie} with $_COOKIE['exp_cklocale'] value which is the users locale
   $local_query =  str_replace('{cookie}',$_COOKIE['exp_cklocale'],$data_table_results->row['field_id_61'] );
   
   $local_query =  str_replace('{url_trtitle}',$page_url_title,$local_query );
   
   $local_query =  str_replace('{category_url_title}',$category_url_title,$local_query );
   
   $local_query =  str_replace('{channel_ids}',$channel_ids,$local_query );
   
    $local_query =  str_replace('{result_limit}',$result_limit,$local_query );
   
   
  
   //execute query and return piped ids
  // $local_entry_ids_result = $DB->query($local_query);
     
  $this->locale_sql_query = $local_query;
   
   $tagdata = $TMPL->tagdata;
   
  $tagdata = str_replace('{local_sql_query}', $this->locale_sql_query, $tagdata);
  
   return $this->return_data = $tagdata;
  
 }