Some more cleanups/improvements:

[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 d276330b9e383cf26eb3cf8501e04cb8cafe3fdb..608b557b07fe161756834e3813f8bd746ff8cacb 100644 (file)
--- a/inc/modules/admin/what-add_rallye.php
+++ b/inc/modules/admin/what-add_rallye.php
@@ -56,8 +56,8 @@ if (isFormSent()) {
 
        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')",
+               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(),
                                postRequestParameter('title'),
@@ -71,10 +71,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",
-               array($START, $END, postRequestParameter('title')), __FILE__, __LINE__);
-               list($id) = SQL_FETCHROW($result);
-               SQL_FREERESULT($result);
+               $id = SQL_INSERTID();
 
                if (!empty($id)) {
                        // Reload to prices...