how to get URL of the image with category id from the database manually

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Mattia Roccoberton

    (@blocknotes)

    Hi thamaraiselvam.
    I save the categories images id inside a WordPress option. If you want to see the source code of the plugin it is available to the public:
    https://plugins.svn.www.ads-software.com/category-featured-images/trunk/

    My plugin doesn’t work with custom taxonomies because it requires 2 actions to work (‘edited_category’ and ‘category_edit_form’) and these actions in a custom taxonomy depends on the category slug.

    Just others that might be interested in this information.

    All the Category Featured Image data for images is stored in one record in the wp_options table. The record is option_name = cfi_featured_images.

    The option_value field then contains a long string with all the Category Featured Image data. The structure of the string is as follows:
    i:wp_terms.term_id;s:4:”wp_posts.ID”;
    When there is no image it is: i:wp_terms.term_id;N;

    The wp_posts.ID corresponds to the image post entry.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘how to get URL of the image with category id from the database manually’ is closed to new replies.