X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-add_rallye.php;h=0aa241dd93ad18e07477a0fb5712aae0c6974139;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=0ea1290fc709e702b1ce7522674af093841e6220;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/modules/admin/what-add_rallye.php b/0.2.1/inc/modules/admin/what-add_rallye.php index 0ea1290fc7..0aa241dd93 100644 --- a/0.2.1/inc/modules/admin/what-add_rallye.php +++ b/0.2.1/inc/modules/admin/what-add_rallye.php @@ -1,130 +1,130 @@ -= %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) -VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", - array( - GET_ADMIN_ID($_COOKIE['admin_login']), - $_POST['title'], - $_POST['descr'], - $_POST['template'], - $START, - $END, - $_POST['auto_add'], - $_POST['active'], - $_POST['notify'], -), __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", - array($START, $END, $_POST['title']), __FILE__, __LINE__); - list($id) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - if (!empty($id)) - { - // Reload to prices... - LOAD_URL(URL."/modules.php?module=admin&what=config_rallye_prices&rallye=".$id); - } - else - { - // Problem detected... - LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_PROBLEM_CREATE); - } - } - else - { - // Free memory - SQL_FREERESULT($result); - - // Overlapping detected - LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_OVERLAP_TIMES); - } -} - -// Prepare some constants for the template -define('_AUTO_ADD_OPTIONS', ADD_OPTION_LINES("/ARRAY/", array('Y', 'N'), array(YES, NO ))); -define('_ACTIVE_OPTIONS' , ADD_OPTION_LINES("/ARRAY/", array('N', 'Y'), array(NO , YES))); -define('_NOTIFY_OPTIONS' , ADD_OPTION_LINES("/ARRAY/", array('Y', 'N'), array(YES, NO ))); - -// Starting day -define('_START_SEC' , ADD_SELECTION("sec" , "0" , "start")); -define('_START_MIN' , ADD_SELECTION("min" , "0" , "start")); -define('_START_HOUR' , ADD_SELECTION("hour" , date("G", time()), "start")); -define('_START_DAY' , ADD_SELECTION("day" , date("d", time()), "start")); -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() + (ONE_DAY * 7)); -$M = date("m", time() + (ONE_DAY * 7)); -$Y = date("Y", time() + (ONE_DAY * 7)); - -// Ending day -define('_END_SEC' , ADD_SELECTION("sec" , "0" , "end")); -define('_END_MIN' , ADD_SELECTION("min" , "0" , "end")); -define('_END_HOUR' , ADD_SELECTION("hour" , date("G", time()), "end")); -define('_END_DAY' , ADD_SELECTION("day" , $D , "end")); -define('_END_MONTH', ADD_SELECTION("month", $M , "end")); -define('_END_YEAR' , ADD_SELECTION("year" , $Y , "end")); - -// Transfer (maybe found) templates into constant for the template -define ('_TEMPLATES', RALLYE_TEMPLATE_SELECTION()); - -// Load template -LOAD_TEMPLATE("admin_add_rallye"); - -// -?> += %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) +VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", + array( + GET_ADMIN_ID($_COOKIE['admin_login']), + $_POST['title'], + $_POST['descr'], + $_POST['template'], + $START, + $END, + $_POST['auto_add'], + $_POST['active'], + $_POST['notify'], +), __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", + array($START, $END, $_POST['title']), __FILE__, __LINE__); + list($id) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + + if (!empty($id)) + { + // Reload to prices... + LOAD_URL(URL."/modules.php?module=admin&what=config_rallye_prices&rallye=".$id); + } + else + { + // Problem detected... + LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_PROBLEM_CREATE); + } + } + else + { + // Free memory + SQL_FREERESULT($result); + + // Overlapping detected + LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_OVERLAP_TIMES); + } +} + +// Prepare some constants for the template +define('_AUTO_ADD_OPTIONS', ADD_OPTION_LINES("/ARRAY/", array('Y', 'N'), array(YES, NO ))); +define('_ACTIVE_OPTIONS' , ADD_OPTION_LINES("/ARRAY/", array('N', 'Y'), array(NO , YES))); +define('_NOTIFY_OPTIONS' , ADD_OPTION_LINES("/ARRAY/", array('Y', 'N'), array(YES, NO ))); + +// Starting day +define('_START_SEC' , ADD_SELECTION("sec" , "0" , "start")); +define('_START_MIN' , ADD_SELECTION("min" , "0" , "start")); +define('_START_HOUR' , ADD_SELECTION("hour" , date("G", time()), "start")); +define('_START_DAY' , ADD_SELECTION("day" , date("d", time()), "start")); +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() + (ONE_DAY * 7)); +$M = date("m", time() + (ONE_DAY * 7)); +$Y = date("Y", time() + (ONE_DAY * 7)); + +// Ending day +define('_END_SEC' , ADD_SELECTION("sec" , "0" , "end")); +define('_END_MIN' , ADD_SELECTION("min" , "0" , "end")); +define('_END_HOUR' , ADD_SELECTION("hour" , date("G", time()), "end")); +define('_END_DAY' , ADD_SELECTION("day" , $D , "end")); +define('_END_MONTH', ADD_SELECTION("month", $M , "end")); +define('_END_YEAR' , ADD_SELECTION("year" , $Y , "end")); + +// Transfer (maybe found) templates into constant for the template +define ('_TEMPLATES', RALLYE_TEMPLATE_SELECTION()); + +// Load template +LOAD_TEMPLATE("admin_add_rallye"); + +// +?>