Heat Map Graph lets administrators build data heat maps backed by SQL SELECT queries on WordPress tables. Configure:
- Query: a single SELECT statement targeting WP tables
- Field mapping: row, column, and value fields produced by the query
- Color range: hex colors for min and max
- Status: enable/disable
Use the shortcode on pages/posts:
[heat_map_graph id="123"]
Security features: – Validates SQL is a single SELECT against WP tables only – Blocks DML/DDL keywords – No multiple statements – Admin-only UI with nonces and strict sanitization
On activation, two sample heat maps are created: – Posts per Day per Category (Last 30 Days) – Number of Post Tags per Category