{"id":247768,"date":"2025-08-23T14:40:53","date_gmt":"2025-08-23T14:40:53","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/heat-map-graph\/"},"modified":"2025-08-23T16:12:48","modified_gmt":"2025-08-23T16:12:48","slug":"heat-map-graph","status":"publish","type":"plugin","link":"https:\/\/pcd.wordpress.org\/plugins\/heat-map-graph\/","author":17950784,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.0","stable_tag":"1.0.0","tested":"6.8.5","requires":"6.0","requires_php":"","requires_plugins":null,"header_name":"Heat Map Graph","header_author":"Hayan Mamoun","header_description":"Create and display heat maps from custom SQL queries. Define row, column, and value fields, select color ranges, and render via shortcode.","assets_banners_color":"f3b188","last_updated":"2025-08-23 16:12:48","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/hayan.mamouns.xyz\/heat-map-graph-plugin\/","header_author_uri":"https:\/\/hayan.mamouns.xyz\/","rating":0,"author_block_rating":0,"active_installs":10,"downloads":241,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0.0":{"tag":"1.0.0","author":"hmamoun","date":"2025-08-23 16:12:48"}},"upgrade_notice":{"1.0.0":"<p>Initial release.<\/p>"},"ratings":[],"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3349025,"resolution":"128x128","location":"assets","locale":""},"icon-256x256.png":{"filename":"icon-256x256.png","revision":3349025,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3349025,"resolution":"1544x500","location":"assets","locale":""},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3349025,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3349025,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3349025,"resolution":"2","location":"assets","locale":""}},"screenshots":[],"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[232,4108,6207,80,1625],"plugin_category":[36,43,59],"plugin_contributors":[243235],"plugin_business_model":[],"class_list":["post-247768","plugin","type-plugin","status-publish","hentry","plugin_tags-analytics","plugin_tags-charts","plugin_tags-heatmap","plugin_tags-shortcode","plugin_tags-sql","plugin_category-analytics","plugin_category-customization","plugin_category-utilities-and-tools","plugin_contributors-hmamoun","plugin_committers-hmamoun"],"banners":{"banner":"https:\/\/ps.w.org\/heat-map-graph\/assets\/banner-772x250.png?rev=3349025","banner_2x":"https:\/\/ps.w.org\/heat-map-graph\/assets\/banner-1544x500.png?rev=3349025","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/heat-map-graph\/assets\/icon-128x128.png?rev=3349025","icon_2x":"https:\/\/ps.w.org\/heat-map-graph\/assets\/icon-256x256.png?rev=3349025","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/heat-map-graph\/assets\/screenshot-1.png?rev=3349025","caption":""},{"src":"https:\/\/ps.w.org\/heat-map-graph\/assets\/screenshot-2.png?rev=3349025","caption":""}],"raw_content":"<!--section=description-->\n<p>Heat Map Graph lets administrators build data heat maps backed by SQL SELECT queries on WordPress tables. Configure:<\/p>\n\n<ul>\n<li>Query: a single SELECT statement targeting WP tables<\/li>\n<li>Field mapping: row, column, and value fields produced by the query<\/li>\n<li>Color range: hex colors for min and max<\/li>\n<li>Status: enable\/disable<\/li>\n<\/ul>\n\n<p>Use the shortcode on pages\/posts:<\/p>\n\n<pre><code>[heat_map_graph id=\"123\"]\n<\/code><\/pre>\n\n<p>Security features:\n- Validates SQL is a single SELECT against WP tables only\n- Blocks DML\/DDL keywords\n- No multiple statements\n- Admin-only UI with nonces and strict sanitization<\/p>\n\n<p>On activation, two sample heat maps are created:\n- Posts per Day per Category (Last 30 Days)\n- Number of Post Tags per Category<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload the plugin folder <code>heat-map-graph<\/code> to <code>\/wp-content\/plugins\/<\/code><\/li>\n<li>Activate the plugin<\/li>\n<li>Under Heat Map Graph in the admin menu, create a heat map or use samples<\/li>\n<li>Place the shortcode <code>[heat_map_graph id=\"&lt;ID&gt;\"]<\/code> where you want the heat map<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id='which%20tables%20can%20i%20query%3F'><h3>Which tables can I query?<\/h3><\/dt>\n<dd><p>Only WordPress core tables, prefixed by your site\u2019s <code>$wpdb-&gt;prefix<\/code>.<\/p><\/dd>\n<dt id='can%20i%20pass%20parameters%3F'><h3>Can I pass parameters?<\/h3><\/dt>\n<dd><p>Use static queries or views; dynamic user input is not supported for security.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.0<\/h4>\n\n<ul>\n<li>Initial release<\/li>\n<\/ul>","raw_excerpt":"Create and display heat maps from custom SQL queries. Define row, column, and value fields, select color ranges, and render via shortcode.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/247768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=247768"}],"author":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/hmamoun"}],"wp:attachment":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=247768"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=247768"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=247768"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=247768"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=247768"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=247768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}