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/venue.php | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'includes/venue.php') diff --git a/includes/venue.php b/includes/venue.php index 07dec0e..f6f46b2 100644 --- a/includes/venue.php +++ b/includes/venue.php @@ -35,6 +35,10 @@ if ( !class_exists('GiglogAdmin_Venue') ) { 'wpgvenue_city' => $city, ]); $venue->save(); + error_log( 'NEW VENUE ADDED: ' + . ' ID: ' . $venue -> id() + . ' VENUE NAME ' . $name + . ', VENUE CITY ' . $city); return $venue; } @@ -42,10 +46,14 @@ if ( !class_exists('GiglogAdmin_Venue') ) { static function find_or_create($name, $city = 'Oslo') { global $wpdb; - $venuesql = 'SELECT * FROM wpg_venues WHERE upper(wpgvenue_name)="' . $name . '"'; + $venuesql = 'SELECT * FROM wpg_venues WHERE upper(wpgvenue_name)=upper("' . $name . '")'.' and wpgvenue_city="'.$city.'"'; $results = $wpdb->get_results($venuesql); if ($results) { + error_log( 'DUPLICATE VENUE: ' + . ' ID: ' . $results[0]->id + . ' VENUE NAME ' . $name + . ', VENUE CITY ' . $city); return new GiglogAdmin_Venue($results[0]); } else { -- cgit v1.2.3