2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 06/29/2004 *
4 * =================== Last change: 08/22/2004 *
6 * -------------------------------------------------------------------- *
7 * File : what-add_rallye.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Add new rallye *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Neue Ref-Rallye einfuegen *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * -------------------------------------------------------------------- *
18 * Copyright (c) 2003 - 2009 by Roland Haeder *
19 * Copyright (c) 2009 - 2012 by Mailer Developer Team *
20 * For more information visit: http://mxchange.org *
22 * This program is free software; you can redistribute it and/or modify *
23 * it under the terms of the GNU General Public License as published by *
24 * the Free Software Foundation; either version 2 of the License, or *
25 * (at your option) any later version. *
27 * This program is distributed in the hope that it will be useful, *
28 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
29 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
30 * GNU General Public License for more details. *
32 * You should have received a copy of the GNU General Public License *
33 * along with this program; if not, write to the Free Software *
34 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
36 ************************************************************************/
38 // Some security stuff...
39 if ((!defined('__SECURITY')) || (!isAdmin())) {
43 // Add description as navigation point
44 addYouAreHereLink('admin', __FILE__);
47 // Generate timestamps
48 $START = mktime(postRequestElement('start_time_hour'), postRequestElement('start_time_min'), 0, postRequestElement('start_time_month'), postRequestElement('start_time_day'), postRequestElement('start_time_year'));
49 $END = mktime(postRequestElement('end_time_hour') , postRequestElement('end_time_min') , 0, postRequestElement('end_time_month') , postRequestElement('end_time_day') , postRequestElement('end_time_year') );
51 // Is there already a rallye running?
52 $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",
53 array($START, $START, $START, $END), __FILE__, __LINE__);
55 if (SQL_HASZERONUMS($result)) {
56 // Ok, start and end time did not overlap
57 SQL_QUERY_ESC("INSERT INTO
58 `{?_MYSQL_PREFIX?}_rallye_data`
86 postRequestElement('title'),
87 postRequestElement('descr'),
88 postRequestElement('template'),
91 postRequestElement('auto_add'),
92 postRequestElement('active'),
93 postRequestElement('notify'),
94 bigintval(postRequestElement('min_users')),
95 bigintval(postRequestElement('min_prices'))
96 ), __FILE__, __LINE__);
102 // Reload to prices...
103 redirectToUrl('modules.php?module=admin&what=config_rallye_prices&rallye_id=' . bigintval($id));
105 // Problem detected...
106 displayMessage('{--ADMIN_RALLYE_PROBLEM_CREATE--}');
110 // Overlapping detected
111 displayMessage('{--ADMIN_RALLYE_OVERLAP_TIMES--}');
115 SQL_FREERESULT($result);
119 $content['start_min'] = addSelectionBox('min' , 0 , 'start_time');
120 $content['start_hour'] = addSelectionBox('hour' , getShortHour() , 'start_time');
121 $content['start_day'] = addSelectionBox('day' , getDay() , 'start_time');
122 $content['start_month'] = addSelectionBox('month', getMonth() , 'start_time');
123 $content['start_year'] = addSelectionBox('year' , getYear() , 'start_time');
126 $endingStamp = time() + (getOneDay() * 7);
129 $content['end_min'] = addSelectionBox('min' , 0 , 'end_time');
130 $content['end_hour'] = addSelectionBox('hour' , getShortHour() , 'end_time');
131 $content['end_day'] = addSelectionBox('day' , getDay($endingStamp) , 'end_time');
132 $content['end_month'] = addSelectionBox('month', getMonth($endingStamp), 'end_time');
133 $content['end_year'] = addSelectionBox('year' , getYear($endingStamp) , 'end_time');
136 loadTemplate('admin_add_rallye', false, $content);