diff options
| author | AndreaChirulescu <andrea.chirulescu@gmail.com> | 2021-04-23 21:38:53 +0200 |
|---|---|---|
| committer | AndreaChirulescu <andrea.chirulescu@gmail.com> | 2021-04-23 21:38:53 +0200 |
| commit | ed163a66fd56ce82efb2c04eba8cde0c4dc7412a (patch) | |
| tree | 09e0a65729865d7679453e2d7328214ad80d55dc /includes/concert.php | |
| parent | 283e01a784e566b1c6e44456202699cb127ab9a8 (diff) | |
| download | gigologadmin-ed163a66fd56ce82efb2c04eba8cde0c4dc7412a.tar.gz gigologadmin-ed163a66fd56ce82efb2c04eba8cde0c4dc7412a.tar.bz2 gigologadmin-ed163a66fd56ce82efb2c04eba8cde0c4dc7412a.zip | |
Added an uppercase in sql for venue and concert duplicate check
Added test to create duplicate concert with varied cases in string
Diffstat (limited to 'includes/concert.php')
| -rw-r--r-- | includes/concert.php | 2 |
1 files changed, 1 insertions, 1 deletions
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 . '"'; |