X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-add_rallye.php;h=ace68d7486c53df9e5ac4378cd25809bff0c6712;hb=2272afc569a7b308e6c34a2d28457495e6b2483b;hp=f7ef95f333c99947615c89e286cd74c8702a987a;hpb=2e715eb7f3f8ca8d259aacb4cbbddde7d9d18e01;p=mailer.git

diff --git a/inc/modules/admin/what-add_rallye.php b/inc/modules/admin/what-add_rallye.php
index f7ef95f333..ace68d7486 100644
--- a/inc/modules/admin/what-add_rallye.php
+++ b/inc/modules/admin/what-add_rallye.php
@@ -49,7 +49,7 @@ if (isFormSent()) {
 	$END   = mktime(postRequestParameter('end_hour')  , postRequestParameter('end_min')  , postRequestParameter('end_sec')  , postRequestParameter('end_month')  , postRequestParameter('end_day')  , postRequestParameter('end_year')  );
 
 	// Is there already a rallye running?
-	$result = SQL_QUERY_ESC("SELECT id, admin_id FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE (start_time <= %s AND end_time >= %s) OR (start_time >= %s AND start_time <= %s) LIMIT 1",
+	$result = SQL_QUERY_ESC("SELECT `id`, `admin_id` FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE (`start_time` <= %s AND `end_time` >= %s) OR (`start_time` >= %s AND `start_time` <= %s) LIMIT 1",
 		array($START, $START, $START, $END), __FILE__, __LINE__);
 
 	if (SQL_HASZERONUMS($result)) {
@@ -76,14 +76,14 @@ VALUES (%s,'%s','%s','%s',%s,%s,'%s','%s','%s')",
 			redirectToUrl('modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye='.$id);
 		} else {
 			// Problem detected...
-			loadTemplate('admin_settings_saved', false, '{--RALLYE_PROBLEM_CREATE--}');
+			displayMessage('{--RALLYE_PROBLEM_CREATE--}');
 		}
 	} else {
 		// Free memory
 		SQL_FREERESULT($result);
 
 		// Overlapping detected
-		loadTemplate('admin_settings_saved', false, '{--RALLYE_OVERLAP_TIMES--}');
+		displayMessage('{--RALLYE_OVERLAP_TIMES--}');
 	}
 } // END - if