Thread Starter
robdxw
(@robdxw)
Thanks, much appreciated!
Thread Starter
robdxw
(@robdxw)
Thread Starter
robdxw
(@robdxw)
Thanks @r3098. Looking at the changeset for 1.5.2, I’m not sure it will fix the issue, as wpdb::prepare uses sprintf-like syntax for its placeholders, rather than question marks, https://developer.ww.wp.xz.cn/reference/classes/wpdb/prepare/.
Given CLICK_PC and CLICK_MOBILE are both set to hexadecimals, I’d expect the line to read:
$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}ahm_events WHERE event IN (%d, %d) AND ( x < 1 AND y < 1 )", $this::CLICK_PC, $this::CLICK_MOBILE ) );
But that’s untested, so may need further tweaks.