febinky

Thank you for your assistance. In the wp_nextend2_section_storage table, I used the following query:

SELECT * FROM wp_nextend2_section_storage WHERE section LIKE ‘%-304%’

This query retrieves the image->images array under the assets object in the column’s value, where application is set to cache. These images are the ones we’re expecting.

However, I’ve noticed that when we publish or unpublish through the backend site of the wordpress application, these cached images do not reflect the changes unless we reload the WordPress application site successfully.

Could you please advise on how to ensure the cache updates properly without needing to reload the site?

Hi Team,

While examining the slider parameters, I came across the following data structure:

{
"ordering": 0,
"static-slide": 0,
"backgroundColor": "ffffff00",
"backgroundImage": "{image}",
"backgroundImageOpacity": 100,
"backgroundAlt": "",
"backgroundTitle": "",
"backgroundMode": "default",
"backgroundVideoMp4": "",
"backgroundVideoOpacity": 100,
"backgroundVideoMuted": 1,
"backgroundVideoLoop": 1,
"backgroundVideoMode": "fill",
"link": "|*|_self",
"slide-duration": 0,
"background-type": "image",
"record-slides": "200",
"version": "3.3.27"
}

<span style=”font-size: inherit; text-wrap: var(–wp–custom–body–typography–text-wrap);”>This seems to represent various properties related to a slide, such as the background image, colors, video settings, and more. Specifically, the </span><code style=”text-wrap: var(–wp–custom–body–typography–text-wrap);”>”backgroundImage”: “{image}”<span style=”font-size: inherit; text-wrap: var(–wp–custom–body–typography–text-wrap);”> parameter indicates the background image, which is likely a placeholder that will be replaced with the actual image reference.</span>

I can see that in the wp_posts table (with post_type = 'attachment'), there are multiple image GUIDs (12 in total) associated with a post. However, I’m unclear on where to retrieve all the images related to each slider, as I’m looking for not just background images, but additional images related to the post.

Could you please clarify:

1. Where the remaining images are stored: Beyond the background image, where can I find other images used in the slider (such as in the wp_posts table or elsewhere)?
2. How to correctly link the images from the slider parameters: For example, how do I map the image placeholders in the slider configuration to the actual published images in WordPress?

I appreciate your guidance in clarifying how to retrieve all the images associated with a post and its sliders.