Unescaped parameter $sql used in $wpdb->get_row($sql)\n$sql assigned unsafely at line 172:\n $sql = "\n\t\t\tselect count(*) as `total`, count(case when meta_value < '$threshold' then 1 end) as `expired`\n\t\t\tfrom {$wpdb->sitemeta}\n\t\t\twhere meta_key like '\\_site\\_transient\\_timeout\\_%'\n\t\t\tand site_id = $site_id\n\t\t"\n$threshold assigned unsafely at line 169:\n $threshold = time() - MINUTE_IN_SECONDS
Unescaped parameter $sql used in $wpdb->get_row($sql)\n$sql assigned unsafely at line 30:\n $sql = "\n\t\t\tselect count(*) as `total`, count(case when option_value < '$threshold' then 1 end) as `expired`\n\t\t\tfrom $table\n\t\t\twhere (option_name like '\\_transient\\_timeout\\_%' or option_name like '\\_site\\_transient\\_timeout\\_%')\n\t\t"\n$threshold assigned unsafely at line 24:\n $threshold = time() - MINUTE_IN_SECONDS\n$table assigned unsafely at line 27:\n $table = $wpdb->get_blog_prefix($blog_id) . 'options'
Unescaped parameter $sql used in $wpdb->get_var($sql)\n$sql assigned unsafely at line 172:\n $sql = "\n\t\t\tselect count(*) as `total`, count(case when meta_value < '$threshold' then 1 end) as `expired`\n\t\t\tfrom {$wpdb->sitemeta}\n\t\t\twhere meta_key like '\\_site\\_transient\\_timeout\\_%'\n\t\t\tand site_id = $site_id\n\t\t"\n$threshold assigned unsafely at line 169:\n $threshold = time() - MINUTE_IN_SECONDS
Affected Plugins
Plugins that have instances of this rule violation
Unescaped parameter $sql used in $wpdb->get_var($sql)\n$sql assigned unsafely at line 38:\n $sql = "\n\t\t\tselect count(*)\n\t\t\tfrom $table\n\t\t\twhere (option_name like '\\_transient\\_%' or option_name like '\\_site\\_transient\\_%')\n\t\t\tand option_name not like '%\\_timeout\\_%'\n\t\t\tand autoload = 'yes'\n\t\t"\n$table assigned unsafely at line 27:\n $table = $wpdb->get_blog_prefix($blog_id) . 'options'\n$threshold assigned unsafely at line 24:\n $threshold = time() - MINUTE_IN_SECONDS
Unescaped parameter $sql used in $wpdb->get_var($sql)\n$sql assigned unsafely at line 48:\n $sql = "\n\t\t\tselect count(*)\n\t\t\tfrom $table\n\t\t\twhere option_name like '\\_wc\\_session\\_expires\\_%'\n\t\t"\n$table assigned unsafely at line 27:\n $table = $wpdb->get_blog_prefix($blog_id) . 'options'\n$threshold assigned unsafely at line 24:\n $threshold = time() - MINUTE_IN_SECONDS