Removing shortcode in column headers for 100+ tables

  • Resolved ncurrier

    (@ncurrier)


    2 years, 5 months ago

    Hi Tobias. Over the past 5 years I’ve been using a tooltips plugin that shows tooltips for column headers where I use acronyms to keep the text lengths short. To do this I inserted the plugin’s shortcode into the header texts of each column for some 140 tables.

    Fast forward 5 years and the tooltip plugin is no longer maintained and actually has insecure code that forced users to have to deactivate and delete it.

    I’d prefer to do a simple search and replace to remove the shortcodes from the hundreds of tablepress tables, but am I doing this in the wp_options sql table? Or wp_posts? I’m having trouble removing all shortcodes from my tablepress tables and wouldn’t want to do this table by table manually.

    Thank you

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The best solution that I can think of right now would indeed be a direct SQL query, using SQL’s REPLACE() function. Youl would do this on all rows of the wp_posts database table that have a value of tablepress_table in the post_type column.

    As an intermediate step, essentially to gain time, you could register that now defunct Shortcode yourself, with an empty return value. That way, the Shortcode would not be visible to site visitors. For that, e.g. add this to the “functions.php” file of your theme:

    add_shortcode( 'tooltip', '__return_empty_string' );

    (where tooltip would be the actually use Shortcode tag).

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Removing shortcode in column headers for 100+ tables’ is closed to new replies.