finding images
-
Is there a way of finding the images related to this tag in the WP database?
<img class="ngg_displayed_gallery mceItem" src="http://domain.com/nextgen-attach_to_post/preview/id--43077" alt="" data-mce-placeholder="1">I’m guessing this is one of the early way of inserting galleries?
-
Hi @vespino,
Thank you for contacting us,
The <img> tag refers to the old way of embedding the images into the posts. The
id--43077likely refers to an image or gallery ID stored in the WordPress database.Basically, NextGEN Gallery stores image data in the following tables:
wp_ngg_gallery– Stores gallery information.wp_ngg_pictures– Stores image details.
To find the image, run this SQL query in phpMyAdmin (or any database management tool)
SELECT * FROM wp_ngg_pictures WHERE galleryid = 43077;I hope this helps! Could you please let me know if you have any questions?
Thanks!
That gives an empty result.
I have found a post in the posts table with the ID of 43077. This is the post_content:
eyJkaXNwbGF5X3NldHRpbmdzIjp7Im92ZXJyaWRlX3RodW1ibmFpbF9zZXR0aW5ncyI6IjAiLCJ0aHVtYm5haWxfd2lkdGgiOiIxMjAiLCJ0aHVtYm5haWxfaGVpZ2h0IjoiOTAiLCJ0aHVtYm5haWxfY3JvcCI6IjEiLCJpbWFnZXNfcGVyX3BhZ2UiOiIwIiwibnVtYmVyX29mX2NvbHVtbnMiOiI0IiwiYWpheF9wYWdpbmF0aW9uIjoiMSIsInNob3dfYWxsX2luX2xpZ2h0Ym94IjoiMCIsInVzZV9pbWFnZWJyb3dzZXJfZWZmZWN0IjoiMCIsInNob3dfcGljbGVuc19saW5rIjoiMCIsInBpY2xlbnNfbGlua190ZXh0IjoiW1BpY0xlbnMgVG9uZW5dIiwic2hvd19zbGlkZXNob3dfbGluayI6IjAiLCJzbGlkZXNob3dfbGlua190ZXh0IjoiW0RpYXZvb3JzdGVsbGluZyB0b25lbl0iLCJ0ZW1wbGF0ZSI6IiIsInVzZV9saWdodGJveF9lZmZlY3QiOnRydWUsImRpc3BsYXlfbm9faW1hZ2VzX2Vycm9yIjoxLCJkaXNhYmxlX3BhZ2luYXRpb24iOjAsInRodW1ibmFpbF9xdWFsaXR5IjoiMTAwIiwidGh1bWJuYWlsX3dhdGVybWFyayI6MCwibmdnX3RyaWdnZXJzX2Rpc3BsYXkiOiJuZXZlciJ9LCJvcmRlcl9ieSI6InNvcnRvcmRlciIsIm9yZGVyX2RpcmVjdGlvbiI6IkFTQyIsImV4Y2x1c2lvbnMiOlsxMTM0M10sImNvbnRhaW5lcl9pZHMiOlszNzBdLCJleGNsdWRlZF9jb250YWluZXJfaWRzIjpbXSwic29ydG9yZGVyIjpbXSwiZW50aXR5X2lkcyI6W10sInJldHVybnMiOiJpbmNsdWRlZCIsIm1heGltdW1fZW50aXR5X2NvdW50IjoiNTAwIiwic291cmNlIjoiZ2FsbGVyaWVzIiwiZGlzcGxheV90eXBlIjoicGhvdG9jcmF0aS1uZXh0Z2VuX2Jhc2ljX3RodW1ibmFpbHMiLCJzbHVnIjpudWxsLCJpZF9maWVsZCI6IklEIiwiX19kZWZhdWx0c19zZXQiOnRydWV9I’m guessing these are the image tags or IDs? Is there a way of decoding this?
Found it, it’s a Base64 format that translates to…
{ "display_settings": { "override_thumbnail_settings": "0", "thumbnail_width": "120", "thumbnail_height": "90", "thumbnail_crop": "1", "images_per_page": "0", "number_of_columns": "4", "ajax_pagination": "1", "show_all_in_lightbox": "0", "use_imagebrowser_effect": "0", "show_piclens_link": "0", "piclens_link_text": "[PicLens Tonen]", "show_slideshow_link": "0", "slideshow_link_text": "[Diavoorstelling tonen]", "template": "", "use_lightbox_effect": true, "display_no_images_error": 1, "disable_pagination": 0, "thumbnail_quality": "100", "thumbnail_watermark": 0, "ngg_triggers_display": "never" }, "order_by": "sortorder", "order_direction": "ASC", "exclusions": [ 11343 ], "container_ids": [ 370 ], "excluded_container_ids": [], "sortorder": [], "entity_ids": [], "returns": "included", "maximum_entity_count": "500", "source": "galleries", "display_type": "photocrati-nextgen_basic_thumbnails", "slug": null, "id_field": "ID", "__defaults_set": true }Based on this I can fetch the container_ids and exclusions.
Hi @vespino,
Great to hear that it has been sorted, and thanks for letting us know.
Feel free to get back of any questions and we will get back to you.
Thanks!
Hi @vespino ,
We haven’t heard back from you in a few days, so I’m going to go ahead and close this thread for now. But if you’d like us to assist further, please feel welcome to continue the conversation.
Thanks!
The topic ‘finding images’ is closed to new replies.