X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_rallyes.php;h=73087c8421bd4f680de1ec71040b6e62fb3cb289;hb=4f7df133f736da124e6f7bd02008b9093f736451;hp=c4eafb6ad1fa8c39df148f9e921aad0f688fa5d2;hpb=a18efdcd57ba91893f0958a457b5c58639b135c3;p=mailer.git

diff --git a/inc/modules/admin/what-list_rallyes.php b/inc/modules/admin/what-list_rallyes.php
index c4eafb6ad1..73087c8421 100644
--- a/inc/modules/admin/what-list_rallyes.php
+++ b/inc/modules/admin/what-list_rallyes.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -47,7 +47,7 @@ addYouAreHereLink('admin', __FILE__);
 $message = '';
 
 // Quick actions on a rallye
-if (isGetRequestElementSet('rallye')) {
+if (isGetRequestElementSet('rallye_id')) {
 	// Init SQL queries
 	initSqls();
 
@@ -56,13 +56,13 @@ if (isGetRequestElementSet('rallye')) {
 		switch (getRequestElement('activate')) {
 			case '1': // Activate
 				addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1",
-					array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+					array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, FALSE)
 				);
 				break;
 
 			case '0': // Deactivate
 				addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1",
-					array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+					array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, FALSE)
 				);
 				break;
 		} // END - switch
@@ -71,13 +71,13 @@ if (isGetRequestElementSet('rallye')) {
 		switch (getRequestElement('notify')) {
 			case '1': // Activate
 				addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1",
-					array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+					array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, FALSE)
 				);
 				break;
 
 			case '0': // Deactivate
 				addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1",
-					array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+					array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, FALSE)
 				);
 				break;
 		} // END - switch
@@ -86,13 +86,13 @@ if (isGetRequestElementSet('rallye')) {
 		switch (getRequestElement('auto')) {
 			case '1': // Activate
 				addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='Y' WHERE `id`=%s AND `auto_add_new_user`='N' LIMIT 1",
-					array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+					array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, FALSE)
 				);
 				break;
 
 			case '0': // Deactivate
 				addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='N' WHERE `id`=%s AND `auto_add_new_user`='Y' LIMIT 1",
-					array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+					array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__, FALSE)
 				);
 				break;
 		} // END - switch
@@ -110,21 +110,21 @@ if (isGetRequestElementSet('rallye')) {
 		foreach (postRequestElement('sel') as $id => $selected) {
 			// Remove selected rallye entirely...
 			addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE `id`=%s LIMIT 1",
-				array(bigintval($id)), __FILE__, __LINE__, false));
+				array(bigintval($id)), __FILE__, __LINE__, FALSE));
 			addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s",
-				array(bigintval($id)), __FILE__, __LINE__, false));
+				array(bigintval($id)), __FILE__, __LINE__, FALSE));
 			addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s",
-				array(bigintval($id)), __FILE__, __LINE__, false));
+				array(bigintval($id)), __FILE__, __LINE__, FALSE));
 		} // END - foreach
 
 		// Run SQLS
 		runFilterChain('run_sqls');
 
 		// Output message
-		$message = '{--RALLYE_DELETED--}';
+		$message = '{--ADMIN_RALLYE_DELETED--}';
 	} else {
 		// No rallye selected to delete!
-		$message = '{--RALLYE_DELETE_NOTHING_SELECTED--}';
+		$message = '{--ADMIN_RALLYE_DELETE_NOTHING_SELECTED--}';
 	}
 } elseif (isFormSent('do_edit')) {
 	// Change rallye
@@ -138,8 +138,8 @@ if (isGetRequestElementSet('rallye')) {
 			$id = bigintval($id);
 
 			// Generate timestamps
-			$START = mktime(postRequestElement('start_hour', $id), postRequestElement('start_min', $id), postRequestElement('start_sec', $id), postRequestElement('start_month', $id), postRequestElement('start_day', $id), postRequestElement('start_year', $id));
-			$END   = mktime(postRequestElement('end_hour', $id)  , postRequestElement('end_min', $id)  , postRequestElement('end_sec', $id)  , postRequestElement('end_month', $id)  , postRequestElement('end_day', $id)  , postRequestElement('end_year', $id)  );
+			$START = mktime(postRequestElement('start_time_hour', $id), postRequestElement('start_time_min', $id), 0, postRequestElement('start_time_month', $id), postRequestElement('start_time_day', $id), postRequestElement('start_time_year', $id));
+			$END   = mktime(postRequestElement('end_time_hour', $id)  , postRequestElement('end_time_min', $id)  , 0, postRequestElement('end_time_month', $id)  , postRequestElement('end_time_day', $id)  , postRequestElement('end_time_year', $id)  );
 
 			// Update entry
 			addSql(SQL_QUERY_ESC("UPDATE
@@ -164,18 +164,28 @@ LIMIT 1",
 				bigintval(postRequestElement('min_users', $id)),
 				bigintval(postRequestElement('min_prices', $id)),
 				$id
-			), __FILE__, __LINE__, false));
+			), __FILE__, __LINE__, FALSE));
 		}
 
 		// Run SQLS
 		runFilterChain('run_sqls');
 
 		// Output message
-		$message = '{--RALLYE_CHANGED--}';
+		$message = '{--ADMIN_RALLYE_CHANGED--}';
 	}
 }
 
-if (isFormSent('edit')) {
+// edit/delete are both handled the same way
+if ((isFormSent('edit')) || (isFormSent('delete'))) {
+	// Default is 'edit'
+	$mode = 'edit';
+
+	// Is delete button used?
+	if (isFormSent('delete')) {
+		// Then set it
+		$mode = 'delete';
+	} // END - if
+	
 	// Check for selections
 	if (ifPostContainsSelections()) {
 		// Make all selected and deactivated rallyes editable
@@ -183,63 +193,79 @@ if (isFormSent('edit')) {
 		foreach (postRequestElement('sel') as $id => $selected) {
 			// Load rallye basic data
 			$result = SQL_QUERY_ESC("SELECT
-	`title`,`descr`,`template`,`start_time`,`end_time`,`min_users`,`min_prices`
+	`title`,
+	`descr`,
+	`template`,
+	`start_time`,
+	`end_time`,
+	`min_users`,
+	`min_prices`
 FROM
 	`{?_MYSQL_PREFIX?}_rallye_data`
 WHERE
 	`id`=%s
 LIMIT 1",
 				array(bigintval($id)), __FILE__, __LINE__);
+
 			// Fetch an array
 			$content = SQL_FETCHARRAY($result);
 
 			// Free result
 			SQL_FREERESULT($result);
 
-			// Starting day
-			$content['s_sec']   = addSelectionBox('sec'  , getSecond($content['start_time'])   , 'start', $id);
-			$content['s_min']   = addSelectionBox('min'  , getMinute($content['start_time'])   , 'start', $id);
-			$content['s_hour']  = addSelectionBox('hour' , getShortHour($content['start_time']), 'start', $id);
-			$content['s_day']   = addSelectionBox('day'  , getDay($content['start_time'])      , 'start', $id);
-			$content['s_month'] = addSelectionBox('month', getMonth($content['start_time'])    , 'start', $id);
-			$content['s_year']  = addSelectionBox('year' , getYear($content['start_time'])     , 'start', $id);
-
-			// Ending day
-			$content['e_sec']   = addSelectionBox('sec'  , getSecond($content['end_time'])     , 'end'  , $id);
-			$content['e_min']   = addSelectionBox('min'  , getMinute($content['end_time'])     , 'end'  , $id);
-			$content['e_hour']  = addSelectionBox('hour' , getShortHour($content['end_time'])  , 'end'  , $id);
-			$content['e_day']   = addSelectionBox('day'  , getDay($content['end_time'])        , 'end'  , $id);
-			$content['e_month'] = addSelectionBox('month', getMonth($content['end_time'])      , 'end'  , $id);
-			$content['e_year']  = addSelectionBox('year' , getYear($content['end_time'])       , 'end'  , $id);
-
-			// Remember other values
-			$content['templ']      = addReferralRallyeTemplateSelection('templ['.$id.']', $content['template']);
-			$content['id']         = $id;
+			// Only for editing ...
+			if ($mode == 'edit') {
+				// Starting day
+				$content['s_min']   = addSelectionBox('min'  , getMinute($content['start_time'])   , 'start_time', $id);
+				$content['s_hour']  = addSelectionBox('hour' , getShortHour($content['start_time']), 'start_time', $id);
+				$content['s_day']   = addSelectionBox('day'  , getDay($content['start_time'])      , 'start_time', $id);
+				$content['s_month'] = addSelectionBox('month', getMonth($content['start_time'])    , 'start_time', $id);
+				$content['s_year']  = addSelectionBox('year' , getYear($content['start_time'])     , 'start_time', $id);
+
+				// Ending day
+				$content['e_min']   = addSelectionBox('min'  , getMinute($content['end_time'])     , 'end_time'  , $id);
+				$content['e_hour']  = addSelectionBox('hour' , getShortHour($content['end_time'])  , 'end_time'  , $id);
+				$content['e_day']   = addSelectionBox('day'  , getDay($content['end_time'])        , 'end_time'  , $id);
+				$content['e_month'] = addSelectionBox('month', getMonth($content['end_time'])      , 'end_time'  , $id);
+				$content['e_year']  = addSelectionBox('year' , getYear($content['end_time'])       , 'end_time'  , $id);
+
+				// Remember other values
+				$content['templ']      = addReferralRallyeTemplateSelection('templ[' . $id . ']', $content['template']);
+			} else {
+				// Convert timestamps into human-readable
+				$content['start_time'] = generateDateTime($content['start_time'], '2');
+				$content['end_time']   = generateDateTime($content['end_time']  , '2');
+			}
+
+			// Remember id number
+			$content['rallye_id']         = bigintval($id);
 
 			// Output row
-			$OUT .= loadTemplate('admin_edit_rallyes_row', true, $content);
+			$OUT .= loadTemplate('admin_' . $mode . '_rallyes_row', TRUE, $content);
 		} // END - foreach
 
 		// Load final template
-		loadTemplate('admin_edit_rallyes', false, $OUT);
+		loadTemplate('admin_' . $mode . '_rallyes', FALSE, $OUT);
 	} else {
 		// Nothing selected to edit
-		displayMessage('{--RALLYE_NO_RALLYES_SELECTED--}');
+		displayMessage('{--ADMIN_RALLYE_NO_RALLYES_SELECTED--}');
 	}
-} elseif ((getRequestElement('sub') == 'users') && (getRequestElement('rallye') > 0)) {
+} elseif ((getRequestElement('sub') == 'users') && (getRequestElement('rallye_id') > 0)) {
 	// List users and their refs before start and current
 	$result = SQL_QUERY_ESC("SELECT
-	`userid`,`refs`,`curr_points`
+	`userid`,
+	`refs`,
+	`curr_points`
 FROM
 	`{?_MYSQL_PREFIX?}_rallye_users`
 WHERE
 	`rallye_id`=%s
 ORDER BY
 	`userid` ASC",
-		array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__);
+		array(bigintval(getRequestElement('rallye_id'))), __FILE__, __LINE__);
 	if (!SQL_HASZERONUMS($result)) {
 		$OUT = '';
-		$content['rallye'] = getRequestElement('rallye');
+		$content['rallye_id'] = bigintval(getRequestElement('rallye_id'));
 		while ($row = SQL_FETCHARRAY($result)) {
 			// Check for referral count
 			$count = getReferralRallyeRefsCount($row['userid'], $row['refs']);
@@ -255,7 +281,7 @@ ORDER BY
 			} // END - if
 
 			// Get user points
-			$points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', false, " AND `ref_depth`=1 LIMIT 1");
+			$points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', FALSE, " AND `ref_depth`=1");
 			//* DEBUG: */ debugOutput(basename(__FILE__).':userid='.$row['userid'].',points='.$points.',opoints='.$row['curr_points']);
 
 			// Prepare content
@@ -269,27 +295,38 @@ ORDER BY
 			);
 
 			// Load row template and switch color
-			$OUT .= loadTemplate('admin_list_rallye_usr_row', true, $row);
+			$OUT .= loadTemplate('admin_list_rallye_usr_row', TRUE, $row);
 		} // END - while
 
 		// Remember rows
-		$content['rows']   = $OUT;
-		$content['rallye'] = getRequestElement('rallye');
+		$content['rows']      = $OUT;
+		$content['rallye_id'] = bigintval(getRequestElement('rallye_id'));
 
 		// Free memory
 		SQL_FREERESULT($result);
 
 		// Load template
-		loadTemplate('admin_list_rallye_usr', false, $content);
+		loadTemplate('admin_list_rallye_usr', FALSE, $content);
 	} else {
 		// No entries found?
-		displayMessage('{--RALLYE_ADMIN_USERS_404--}');
+		displayMessage('{--ADMIN_RALLYE_USERS_404--}');
 	}
 } else {
 	// Start listing rallyes
 	$result = SQL_QUERY("SELECT
-	`id`,`admin_id`,`title`,`descr`,`template`,`start_time`,`end_time`,
-	`auto_add_new_user`,`is_active`,`send_notify`,`notified`,`min_users`,`min_prices`
+	`id` AS `rallye_id`,
+	`admin_id`,
+	`title`,
+	`descr`,
+	`template`,
+	`start_time`,
+	`end_time`,
+	`auto_add_new_user`,
+	`is_active`,
+	`send_notify`,
+	`notified`,
+	`min_users`,
+	`min_prices`
 FROM
 	`{?_MYSQL_PREFIX?}_rallye_data`
 ORDER BY
@@ -301,19 +338,19 @@ ORDER BY
 		$OUT = '';
 		while ($data = SQL_FETCHARRAY($result)) {
 			// Count joined userids
-			$users = countSumTotalData($data['id'], 'rallye_users', 'id', 'rallye_id', true);
+			$users = countSumTotalData($data['rallye_id'], 'rallye_users', 'rallye_id', 'rallye_id', TRUE);
 
 			// Did some users joined this rallye?
 			if ($users > 0) {
 				// List joined users
-				$users = '<a href="{%url=modules.php?module=admin&amp;what=list_rallyes&amp;sub=users&amp;rallye=' . $data['id'] . '%}" title="{--RALLYE_LIST_USERS_TITLE--}">' . $users . '</a>';
+				$users = '<a href="{%url=modules.php?module=admin&amp;what=list_rallyes&amp;sub=users&amp;rallye_id=' . $data['rallye_id'] . '%}" title="{--ADMIN_LIST_RALLYE_USERS_TITLE--}">{%pipe,translateComma=' . $users . '%}</a>';
 			} // END - if
 
 			// Transfer data into array for the template
 			$row = array(
-				'select'            => '<input type="checkbox" name="sel[' . $data['id'] . ']" class="form_field" value="1" />',
+				'select'            => '<input type="checkbox" name="sel[' . $data['rallye_id'] . ']" class="form_field" value="1" />',
 				'admin_id'          => $data['admin_id'],
-				'id'                => $data['id'],
+				'rallye_id'         => $data['rallye_id'],
 				'title'             => $data['title'],
 				'template'          => $data['template'],
 				'users_content'     => $users,
@@ -323,7 +360,7 @@ ORDER BY
 				'send_notify'       => $data['send_notify'],
 				'auto_add_new_user' => $data['auto_add_new_user'],
 				'notified'          => $data['notified'],
-				'prices_cnt'        => countSumTotalData($data['id'], 'rallye_prices', 'id', 'rallye_id', true),
+				'prices_cnt'        => countSumTotalData($data['rallye_id'], 'rallye_prices', 'rallye_id', 'rallye_id', TRUE),
 				'descr'             => $data['descr'],
 				'min_users'         => $data['min_users'],
 				'min_prices'        => $data['min_prices'],
@@ -333,13 +370,13 @@ ORDER BY
 			switch ($data['is_active']) {
 				case 'Y':
 					// Rallye is active so do not edit it!
-					$row['select']       = '<div class="big">' . $row['id'] . '</div>';
-					$row['active_title'] = '{--RALLYE_DEACTIVATE_NOW--}';
+					$row['select']       = '<div class="big">' . $row['rallye_id'] . '</div>';
+					$row['active_title'] = '{--ADMIN_RALLYE_DEACTIVATE_NOW--}';
 					$row['active']       = '0';
 					break;
 
 				case 'N':
-					$row['active_title'] = '{--RALLYE_ACTIVATE_NOW--}';
+					$row['active_title'] = '{--ADMIN_RALLYE_ACTIVATE_NOW--}';
 					$row['active']       = 1;
 					break;
 			} // END - switch
@@ -347,12 +384,12 @@ ORDER BY
 			// Notification to members?
 			switch ($data['send_notify']) {
 				case 'Y':
-					$row['notify_title'] = '{--RALLYE_STOP_NOTIFY_NOW--}';
+					$row['notify_title'] = '{--ADMIN_RALLYE_STOP_NOTIFY_NOW--}';
 					$row['notify']       = '0';
 					break;
 
 				case 'N':
-					$row['notify_title'] = '{--RALLYE_START_NOTIFY_NOW--}';
+					$row['notify_title'] = '{--ADMIN_RALLYE_START_NOTIFY_NOW--}';
 					$row['notify']       = 1;
 					break;
 			} // END - switch
@@ -360,18 +397,18 @@ ORDER BY
 			// Auto-add of new joined members?
 			switch ($data['auto_add_new_user']) {
 				case 'Y':
-					$row['auto_title'] = '{--RALLYE_STOP_AUTO_ADD_NOW--}';
+					$row['auto_title'] = '{--ADMIN_RALLYE_STOP_AUTO_ADD_NOW--}';
 					$row['auto']       = '0';
 					break;
 
 				case 'N':
-					$row['auto_title'] = '{--RALLYE_START_AUTO_ADD_NOW--}';
+					$row['auto_title'] = '{--ADMIN_RALLYE_START_AUTO_ADD_NOW--}';
 					$row['auto']       = 1;
 					break;
 			} // END - switch
 
 			// Output row
-			$OUT .= loadTemplate('admin_list_rallyes_row', true, $row);
+			$OUT .= loadTemplate('admin_list_rallyes_row', TRUE, $row);
 		} // END - while
 
 		// Free memory
@@ -381,10 +418,10 @@ ORDER BY
 		$content['rows'] = $OUT;
 
 		// Load template
-		loadTemplate('admin_list_rallyes', false, $content);
+		loadTemplate('admin_list_rallyes', FALSE, $content);
 	} else {
 		// No rallyes setup so far
-		displayMessage('{--RALLYE_NO_RALLYES_SETUP--}');
+		displayMessage('{--ADMIN_RALLYE_NO_RALLYES_SETUP--}');
 	}
 }