From ed163a66fd56ce82efb2c04eba8cde0c4dc7412a Mon Sep 17 00:00:00 2001 From: AndreaChirulescu Date: Fri, 23 Apr 2021 21:38:53 +0200 Subject: Added an uppercase in sql for venue and concert duplicate check Added test to create duplicate concert with varied cases in string --- includes/concert.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'includes/concert.php') diff --git a/includes/concert.php b/includes/concert.php index aff41ac..d95934e 100644 --- a/includes/concert.php +++ b/includes/concert.php @@ -147,7 +147,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) { global $wpdb; $sql = 'SELECT id from wpg_concerts' - . ' where wpgconcert_name = "' . $cname .'"' + . ' where upper(wpgconcert_name) = upper("' . $cname .'")' . ' and venue = ' . $venue . ' and wpgconcert_date ="' . $date . '"'; -- cgit v1.2.3