[Skip to main content](#vessel-content) # How to find the HxW of thumbnailHxW ## - **[BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile")** - [![BRupholdt's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2684.jpg)](/forum/user/2684-brupholdt "View BRupholdt's Profile") Topic Author - [ Offline](/forum/user/2684-brupholdt) Less More - Posts: 29 - Thank you received: 2 - - 14 years 2 months ago [\#62059](#62059) by [BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile") *[How to find the HxW of thumbnailHxW](/forum/4-how-to/62059-how-to-find-the-hxw-of-thumbnailhxw#62059 "I've setup an integration between HikaShop and a Joomla content construction kit. The CCK queries the HikaShop tables to get various information including the image name. In previous versions of HS,...")* was created by *[BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile")* I've setup an integration between HikaShop and a Joomla content construction kit. The CCK queries the HikaShop tables to get various information including the image name. In previous versions of HS, all thumbnails were in the same thumbnail folder making this approach quite simple. With the newer version though, the thumbnails are in a folder named with the dimensions. Is the dimension information stored in the database somewhere that I can query for it to fix my integration? If not, is there a way to create all thumbnails in a single thumbnail folder instead? Possibly using a plugin? I'm reaching for ways to make this work again. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYyMDU5LWhvdy10by1maW5kLXRoZS1oeHctb2YtdGh1bWJuYWlsaHh3P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile")** - [![BRupholdt's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2684.jpg)](/forum/user/2684-brupholdt "View BRupholdt's Profile") Topic Author - [ Offline](/forum/user/2684-brupholdt) Less More - Posts: 29 - Thank you received: 2 - - 14 years 2 months ago - 14 years 2 months ago [\#62060](#62060) by [BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile") Replied by *[BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile")* on topic *[Re: How to find the HxW of thumbnailHxW](/forum/4-how-to/62059-how-to-find-the-hxw-of-thumbnailhxw#62060 "I've setup an integration between HikaShop and a Joomla content construction kit. The CCK queries the HikaShop tables to get various information including the image name. In previous versions of HS,...")* Here's the query I use to draw HS info into the CCK. Code: SQL Query: SELECT concat_ws('|', convert(product_id,char), file_path, product_name, db_menu.id ), product_name FROM db_hikashop_file JOIN db_hikashop_product ON product_id=file_ref_id JOIN db_menu on published = published WHERE file_type='product' AND db_menu.link='index.php?option=com_hikashop&view=product&layout=listing' AND db_menu.parent_id=1 GROUP BY product_name ORDER BY product_name,file_id desc Last edit: 14 years 2 months ago by [BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYyMDU5LWhvdy10by1maW5kLXRoZS1oeHctb2YtdGh1bWJuYWlsaHh3P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14296 - - 14 years 2 months ago [\#62166](#62166) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: How to find the HxW of thumbnailHxW](/forum/4-how-to/62059-how-to-find-the-hxw-of-thumbnailhxw#62166 "I've setup an integration between HikaShop and a Joomla content construction kit. The CCK queries the HikaShop tables to get various information including the image name. In previous versions of HS,...")* It's quite complex to know the thumbnails sizes available for an image by looking at the data in the database. It can come from the Files/Images tab configuration options, it can come from a module or a menu option. I see two simple ways to solve your issue: 1. Have HikaShop display the image. If you call the function display of the helper.image class, it will echo the HTML of the thumbnail and create the thumbnail in the correct folder if necessary. 2. Parse the thumbnail folders and see if the images have their thumbnail there. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYyMDU5LWhvdy10by1maW5kLXRoZS1oeHctb2YtdGh1bWJuYWlsaHh3P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile")** - [![BRupholdt's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2684.jpg)](/forum/user/2684-brupholdt "View BRupholdt's Profile") Topic Author - [ Offline](/forum/user/2684-brupholdt) Less More - Posts: 29 - Thank you received: 2 - - 14 years 2 months ago [\#62286](#62286) by [BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile") Replied by *[BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile")* on topic *[Re: How to find the HxW of thumbnailHxW](/forum/4-how-to/62059-how-to-find-the-hxw-of-thumbnailhxw#62286 "I've setup an integration between HikaShop and a Joomla content construction kit. The CCK queries the HikaShop tables to get various information including the image name. In previous versions of HS,...")* I'd considered parsing the folders to find the image but was hoping for a better way. I like the idea of having HS show the image but how would I go about that in a separate php file? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYyMDU5LWhvdy10by1maW5kLXRoZS1oeHctb2YtdGh1bWJuYWlsaHh3P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14296 - - 14 years 2 months ago [\#62413](#62413) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: How to find the HxW of thumbnailHxW](/forum/4-how-to/62059-how-to-find-the-hxw-of-thumbnailhxw#62413 "I've setup an integration between HikaShop and a Joomla content construction kit. The CCK queries the HikaShop tables to get various information including the image name. In previous versions of HS,...")* Like that: if(!include_once(rtrim(JPATH_ADMINISTRATOR,DS).DS.'components'.DS.'com_hikashop'.DS.'helpers'.DS.'helper.php')) return true; $image = hikashop_get('helper.image'); echo $image->display('myimage.png',false,'My image file', '' , '' ,180, 120); The following user(s) said Thank You: [BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYyMDU5LWhvdy10by1maW5kLXRoZS1oeHctb2YtdGh1bWJuYWlsaHh3P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile")** - [![BRupholdt's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2684.jpg)](/forum/user/2684-brupholdt "View BRupholdt's Profile") Topic Author - [ Offline](/forum/user/2684-brupholdt) Less More - Posts: 29 - Thank you received: 2 - - 14 years 2 months ago [\#62494](#62494) by [BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile") Replied by *[BRupholdt](/forum/user/2684-brupholdt "View BRupholdt's Profile")* on topic *[Re: How to find the HxW of thumbnailHxW](/forum/4-how-to/62059-how-to-find-the-hxw-of-thumbnailhxw#62494 "I've setup an integration between HikaShop and a Joomla content construction kit. The CCK queries the HikaShop tables to get various information including the image name. In previous versions of HS,...")* That worked perfectly and was a far better way than parsing for thumbnails that might not exist yet. Thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYyMDU5LWhvdy10by1maW5kLXRoZS1oeHctb2YtdGh1bWJuYWlsaHh3P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.073 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)