X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-add_rallye.php;h=12798e889970eb523980b60d6f0bc647a8e8ec23;hb=77cdaff2afb97ed32985ced906a3a95ee078c2ef;hp=d22abccd5eda15dfb24caebfaee7abd84ce5382b;hpb=357b2ca133fc1f89db74097955c366cb4bee6996;p=mailer.git

diff --git a/inc/modules/admin/what-add_rallye.php b/inc/modules/admin/what-add_rallye.php
index d22abccd5e..12798e8899 100644
--- a/inc/modules/admin/what-add_rallye.php
+++ b/inc/modules/admin/what-add_rallye.php
@@ -47,16 +47,16 @@ if (isset($_POST['ok']))
 	$END   = mktime($_POST['end_hour']  , $_POST['end_min']  , $_POST['end_sec']  , $_POST['end_month']  , $_POST['end_day']  , $_POST['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_NUMROWS($result) == 0)
 	{
 		// Ok, start and end time did not overlap
-		$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_rallye_data (admin_id, title, descr, template, start_time, end_time, auto_add_new_user, is_active, send_notify)
+		SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_rallye_data` (admin_id, title, descr, template, start_time, end_time, auto_add_new_user, is_active, send_notify)
 VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s')",
  array(
-	GET_ADMIN_ID(get_session('admin_login')),
+	GET_CURRENT_ADMIN_ID(),
 	$_POST['title'],
 	$_POST['descr'],
 	$_POST['template'],
@@ -68,7 +68,7 @@ VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s')",
 ), __FILE__, __LINE__);
 
 		// Load ID
-		$result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_rallye_data WHERE start_time='%s' AND end_time='%s' AND title='%s' LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_rallye_data` WHERE start_time='%s' AND end_time='%s' AND `title`='%s' LIMIT 1",
 		 array($START, $END, $_POST['title']), __FILE__, __LINE__);
 		list($id) = SQL_FETCHROW($result);
 		SQL_FREERESULT($result);
@@ -108,9 +108,9 @@ define('_START_MONTH', ADD_SELECTION("month", date("m", time()), "start"));
 define('_START_YEAR' , ADD_SELECTION("year" , date('Y', time()), "start"));
 
 // Calcualte ending date
-$D = date("d", time() + ($_CONFIG['one_day'] * 7));
-$M = date("m", time() + ($_CONFIG['one_day'] * 7));
-$Y = date('Y', time() + ($_CONFIG['one_day'] * 7));
+$D = date("d", time() + (getConfig('one_day') * 7));
+$M = date("m", time() + (getConfig('one_day') * 7));
+$Y = date('Y', time() + (getConfig('one_day') * 7));
 
 // Ending day
 define('_END_SEC'  , ADD_SELECTION("sec"  , "0"              , "end"));