triscat

Thanks Tobias for looking in to this. Since I sort of have a work around (placed calendar in a post and searching works for the post), I am not going to try the uninstall/reinstall for a little while. I will let everyone knows how that goes for me.

Also tried one other debugging test that didnt work:
Made a new simple table with some unique words. Then put that table on a new page and did a search for the keywords in that table. Sure enough no results found…. just shows that my original calendar table wasnt causing the error…..

Thanks again,
Mike

FYI: I mentioned in my first post that I had been messing with the calendar page “published” date so that I could make sure the calendar appears on the top of the search results. Maybe a coincidence, but maybe sparks an idea in your head….

Here is a screen shot of that page: http://bustoshow.org/wp-content/uploads/ss4.jpg

Yes it is checked. And I would guess what is happening on my site is what would happen if that box is not checked….The search on the table works, but the direct link universal search does not work (ie http://www.bustoshow.org/?s=Disco+Biscuits). It finds all articles about disco biscuits but it doesnt find the listing in the table.

“the procedure to make it so you can search” – it was a while ago that I did this so dont remember the exact method but it was using what you called “extensions”.

I have a plugin called “wp-table-reloaded-extensions.php” I can see on my WordPress as active. Code is below. Perhaps I also uploaded a file to the FTP site, maybe that file got moved, permissions changed or deleted? Just throwing ideas out there that I am sure you are already thinking about 🙂

Screen shots:
Plugin options: http://bustoshow.org/wp-content/uploads/ss1.jpg
Table options: http://bustoshow.org/wp-content/uploads/ss2.jpg
Installed Plugins: http://bustoshow.org/wp-content/uploads/ss3.jpg

<?php
/*
Plugin Name: WP-Table Reloaded Extensions
Plugin URI: http://tobias.baethge.com/wordpress-plugins/wp-table-reloaded-english/extensions/
Description: Custom Extensions for WP-Table Reloaded
Version: 1.0
Author: Tobias Baethge
*/

/**
* DataTables Automatic Filtering
* @author Tobias Baethge
*/

/**
* Register necessary Plugin Filters
*/
add_filter( ‘wp_table_reloaded_table_js_options’, ‘wp_table_reloaded_add_table_js_options’, 10, 3 );
add_filter( ‘wp_table_reloaded_js_frontend_command’, ‘wp_table_reloaded_extend_js_frontend_command’, 10, 7 );

/**
* Add “autofilter” from the WordPress search to the $js_options
*/
function wp_table_reloaded_add_table_js_options( $js_options, $table_id, $output_options ) {
$js_options[‘datatables_autofilter’] = esc_js( get_query_var( ‘s’ ) ); // contains the search term from WordPress
return $js_options;
}

/**
* Add the necessary DataTables JavaScript commands for the autofiltering
*/
function wp_table_reloaded_extend_js_frontend_command( $command, $table_id, $html_id, $tablesorter_script, $js_command, $parameters, $js_options ) {
// early exit if no “autofilter” parameter given
if ( empty( $js_options[‘datatables_autofilter’] ) )
return $command;

$autofilter_word = $js_options[‘autofilter’]; // from the Shortcode parameter “autofilter”

// append necessary JavaScript to the original command
$command = “var oTable_{$table_id} = {$command}\n”;
$command .= “\toTable_{$table_id}.fnFilter( ‘{$js_options[‘datatables_autofilter’]}’ );”;

return $command;
}

?>

Thanks Tobias! But of course in my lack of knowledge I have a follow up question or two. Sorry I dont know much with code…

Is there a way to have it only look at one folder: for instance my table is on http://www.bustoshow.org/calendar. If I did a manual search on there for “STS9” it brings up my STS9 events.
With this extension, if I do http://www.bustoshow.org/?s=STS9 it will also list the blog posting on the main page. If I do http://www.bustoshow.org/calendar/?s=STS9 it tells me page not found.

Cosmetic question: Instead of ?s= can I change it to ?search= ? I changed the line: esc_js( get_query_var( ‘s’ ) to esc_js( get_query_var( ‘search’ ) and it didnt work. Of course it couldnt be that simple.

Last one. My table has a column of dates. I have found that every couple days I have to go in and manually delete the rows. Is there a way to have code so that when you load the page it would only show events that happen from today on? Granted if you resorted the table by date it will show the past, but at the same time would be better than the manual process I am doing now.

THANKS SO MUCH!