]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-add_rallye.php
Rewrites/fixes for handling config entries in SQLs
[mailer.git] / inc / modules / admin / what-add_rallye.php
index 1d7c7d6f1b237b5b9c67cef990af7884589cd70c..0cb4d2e5aed861f8f4a74c3ca1ca2fe20e73ae7a 100644 (file)
@@ -18,6 +18,7 @@
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -46,32 +47,32 @@ addMenuDescription('admin', __FILE__);
 
 if (isFormSent()) {
        // Generate timestamps
-       $START = mktime(postRequestElement('start_hour'), postRequestElement('start_min'), postRequestElement('start_sec'), postRequestElement('start_month'), postRequestElement('start_day'), postRequestElement('start_year'));
-       $END   = mktime(postRequestElement('end_hour')  , postRequestElement('end_min')  , postRequestElement('end_sec')  , postRequestElement('end_month')  , postRequestElement('end_day')  , postRequestElement('end_year')  );
+       $START = mktime(postRequestParameter('start_hour'), postRequestParameter('start_min'), postRequestParameter('start_sec'), postRequestParameter('start_month'), postRequestParameter('start_day'), postRequestParameter('start_year'));
+       $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",
                array($START, $START, $START, $END), __FILE__, __LINE__);
 
-       if (SQL_NUMROWS($result) == '0') {
+       if (SQL_HASZERONUMS($result)) {
                // Ok, start and end time did not overlap
                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(
                                getCurrentAdminId(),
-                               postRequestElement('title'),
-                               postRequestElement('descr'),
-                               postRequestElement('template'),
+                               postRequestParameter('title'),
+                               postRequestParameter('descr'),
+                               postRequestParameter('template'),
                                $START,
                                $END,
-                               postRequestElement('auto_add'),
-                               postRequestElement('active'),
-                               postRequestElement('notify'),
+                               postRequestParameter('auto_add'),
+                               postRequestParameter('active'),
+                               postRequestParameter('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, postRequestElement('title')), __FILE__, __LINE__);
+               array($START, $END, postRequestParameter('title')), __FILE__, __LINE__);
                list($id) = SQL_FETCHROW($result);
                SQL_FREERESULT($result);