Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.

[mailer.git] / inc / modules / admin / what-add_rallye.php

diff --git a/inc/modules/admin/what-add_rallye.php b/inc/modules/admin/what-add_rallye.php
index 3f3406b69011126b643a84b8d10360f114e5a095..4424423e8aaf2d5c83fbfda2ac2ef6f95751745e 100644 (file)
--- a/inc/modules/admin/what-add_rallye.php
+++ b/inc/modules/admin/what-add_rallye.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -45,16 +45,16 @@ addYouAreHereLink('admin', __FILE__);
 
 if (isFormSent()) {
        // Generate timestamps
-       $START = mktime(postRequestElement('start_time_hour'), postRequestElement('start_time_min'), 0, postRequestElement('start_time_month'), postRequestElement('start_time_day'), postRequestElement('start_time_year'));
-       $END   = mktime(postRequestElement('end_time_hour')  , postRequestElement('end_time_min')  , 0, postRequestElement('end_time_month')  , postRequestElement('end_time_day')  , postRequestElement('end_time_year')  );
+       $START = mktime(postRequestElement('start_time_ho'), postRequestElement('start_time_mi'), 0, postRequestElement('start_time_mo'), postRequestElement('start_time_da'), postRequestElement('start_time_ye'));
+       $END   = mktime(postRequestElement('end_time_ho')  , postRequestElement('end_time_mi')  , 0, postRequestElement('end_time_mo')  , postRequestElement('end_time_da')  , postRequestElement('end_time_ye')  );
 
        // 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 = sqlQueryEscaped("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)) {
+       if (ifSqlHasZeroNumRows($result)) {
                // Ok, start and end time did not overlap
-               SQL_QUERY_ESC("INSERT INTO
+               sqlQueryEscaped("INSERT INTO
        `{?_MYSQL_PREFIX?}_rallye_data`
 (
        `admin_id`,
@@ -96,11 +96,11 @@ if (isFormSent()) {
                        ), __FILE__, __LINE__);
 
                // Load id
-               $id = SQL_INSERTID();
+               $id = getSqlInsertId();
 
                if (!empty($id)) {
                        // Reload to prices...
-                       redirectToUrl('modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye_id=' . bigintval($id));
+                       redirectToUrl('modules.php?module=admin&amp;what=list_rallye_prices&amp;rallye_id=' . bigintval($id));
                } else {
                        // Problem detected...
                        displayMessage('{--ADMIN_RALLYE_PROBLEM_CREATE--}');
@@ -112,28 +112,28 @@ if (isFormSent()) {
        }
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 } // END - if
 
 // Starting day
-$content['start_min']   = addSelectionBox('min'  , 0                   , 'start_time');
-$content['start_hour']  = addSelectionBox('hour' , getShortHour()      , 'start_time');
-$content['start_day']   = addSelectionBox('day'  , getDay()            , 'start_time');
-$content['start_month'] = addSelectionBox('month', getMonth()          , 'start_time');
-$content['start_year']  = addSelectionBox('year' , getYear()           , 'start_time');
+$content['start_min']   = addSelectionBox('mi', 0                   , 'start_time');
+$content['start_hour']  = addSelectionBox('ho', getShortHour()      , 'start_time');
+$content['start_day']   = addSelectionBox('da', getDay()            , 'start_time');
+$content['start_month'] = addSelectionBox('mo', getMonth()          , 'start_time');
+$content['start_year']  = addSelectionBox('ye', getYear()           , 'start_time');
 
 // Ending timestamp
 $endingStamp = time() + (getOneDay() * 7);
 
 // Ending day
-$content['end_min']   = addSelectionBox('min'  , 0                     , 'end_time');
-$content['end_hour']  = addSelectionBox('hour' , getShortHour()        , 'end_time');
-$content['end_day']   = addSelectionBox('day'  , getDay($endingStamp)  , 'end_time');
-$content['end_month'] = addSelectionBox('month', getMonth($endingStamp), 'end_time');
-$content['end_year']  = addSelectionBox('year' , getYear($endingStamp) , 'end_time');
+$content['end_min']   = addSelectionBox('mi', 0                     , 'end_time');
+$content['end_hour']  = addSelectionBox('ho', getShortHour()        , 'end_time');
+$content['end_day']   = addSelectionBox('da', getDay($endingStamp)  , 'end_time');
+$content['end_month'] = addSelectionBox('mo', getMonth($endingStamp), 'end_time');
+$content['end_year']  = addSelectionBox('ye', getYear($endingStamp) , 'end_time');
 
 // Load template
-loadTemplate('admin_add_rallye', false, $content);
+loadTemplate('admin_add_rallye', FALSE, $content);
 
 // [EOF]
 ?>