X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_rallyes.php;h=81cc4ae8aeb05aba9c2f840438632f87eae34dff;hp=f7fdcdc321f4f138089edf4144c59cb3be4a05a8;hb=f2aeaab0cd313b2eeb151642455ed558f6b186dc;hpb=d3c4fdd9bfab35389e1a5ff48f3952d527c7b4bb diff --git a/inc/modules/admin/what-list_rallyes.php b/inc/modules/admin/what-list_rallyes.php index f7fdcdc321..81cc4ae8ae 100644 --- a/inc/modules/admin/what-list_rallyes.php +++ b/inc/modules/admin/what-list_rallyes.php @@ -1,7 +1,7 @@ 0) { + if (countPostSelection() > 0) { // Init SQLs initSqls(); // Delete selected rallyes and all it's data - foreach (postRequestElement('sel') as $id => $selected) { + foreach (postRequestParameter('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)); - addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE rallye_id=%s", - 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)); + addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s", + 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)); } // END - foreach // Run SQLS runFilterChain('run_sqls'); // Output message - $message = getMessage('RALLYE_DELETED'); + $message = '{--RALLYE_DELETED--}'; } else { // No rallye selected to delete! - $message = getMessage('RALLYE_DELETE_NOTHING_SELECTED'); + $message = '{--RALLYE_DELETE_NOTHING_SELECTED--}'; } -} elseif (isPostRequestElementSet('change')) { +} elseif (isFormSent('change')) { // Change rallye - $SEL = countSelection(postRequestElement('title')); - if ($SEL > 0) { + if (countSelection(postRequestParameter('title')) > 0) { // Init SQLs initSqls(); // Change selected rallyes and all it's data - foreach (postRequestElement('title') as $id => $title) { + foreach (postRequestParameter('title') as $id => $title) { // Secure id number $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(postRequestParameter('start_hour', $id), postRequestParameter('start_min', $id), postRequestParameter('start_sec', $id), postRequestParameter('start_month', $id), postRequestParameter('start_day', $id), postRequestParameter('start_year', $id)); + $END = mktime(postRequestParameter('end_hour', $id) , postRequestParameter('end_min', $id) , postRequestParameter('end_sec', $id) , postRequestParameter('end_month', $id) , postRequestParameter('end_day', $id) , postRequestParameter('end_year', $id) ); // Update entry - addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET -title='%s', -descr='%s', -template='%s', -start_time='%s', -end_time='%s', -min_users='%s', -min_prices='%s' -WHERE `id`='".$id."' LIMIT 1", + addSql(SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_rallye_data` +SET + `title`='%s', + `descr`='%s', + `template`='%s', + `start_time`=%s, + `end_time`=%s, + `min_users`=%s, + `min_prices`=%s +WHERE + `id`=%s +LIMIT 1", array( - $title, - postRequestElement('descr', $id), - postRequestElement('templ', $id), - bigintval($START), - bigintval($END), - bigintval(postRequestElement('min_users', $id)), - bigintval(postRequestElement('min_prices', $id)), - $id + $title, + postRequestParameter('descr', $id), + postRequestParameter('templ', $id), + bigintval($START), + bigintval($END), + bigintval(postRequestParameter('min_users', $id)), + bigintval(postRequestParameter('min_prices', $id)), + $id ), __FILE__, __LINE__, false)); } @@ -161,23 +173,25 @@ WHERE `id`='".$id."' LIMIT 1", runFilterChain('run_sqls'); // Output message - $message = getMessage('RALLYE_CHANGED'); + $message = '{--RALLYE_CHANGED--}'; } } -if (isPostRequestElementSet('edit')) { +if (isFormSent('edit')) { // Check for selections - $SEL = countPostSelection(); - if ($SEL > 0) { + if (countPostSelection() > 0) { // Make all selected and deactivated rallyes editable $OUT = ''; $SW = 2; - foreach (postRequestElement('sel') as $id => $selected) { + foreach (postRequestParameter('sel') as $id => $selected) { // Load rallye basic data - $result = SQL_QUERY_ESC("SELECT title, descr, template, start_time, end_time, min_users, min_prices -FROM `{?_MYSQL_PREFIX?}_rallye_data` -WHERE `id`=%s + $result = SQL_QUERY_ESC("SELECT + `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__); + array(bigintval($id)), __FILE__, __LINE__); // Fetch an array $content = SQL_FETCHARRAY($result); @@ -210,21 +224,28 @@ LIMIT 1", // Color switching $SW = 3 - $SW; - } + } // END - foreach // Load final template loadTemplate('admin_edit_rallyes', false, $OUT); } else { // Nothing selected to edit - loadTemplate('admin_settings_saved', false, loadTemplate('admin_list_rallye_noselect', true)); + loadTemplate('admin_settings_saved', false, '{--RALLYE_NO_RALLYES_SELECTED--}'); } -} elseif ((getRequestElement('sub') == 'users') && (getRequestElement('rallye') > 0)) { +} elseif ((getRequestParameter('sub') == 'users') && (getRequestParameter('rallye') > 0)) { // List users and their refs before start and current - $result = SQL_QUERY_ESC("SELECT userid, refs, curr_points FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE rallye_id=%s ORDER BY `userid` ASC", - array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT + `userid`, `refs`, `curr_points` +FROM + `{?_MYSQL_PREFIX?}_rallye_users` +WHERE + `rallye_id`=%s +ORDER BY + `userid` ASC", + array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { $OUT = ''; $SW = 2; - $content['rallye'] = getRequestElement('rallye'); + $content['rallye'] = getRequestParameter('rallye'); while ($row = SQL_FETCHARRAY($result)) { // Check for referal count $cnt = getReferalRallyeRefsCount($row['userid'], $row['refs']); @@ -234,28 +255,21 @@ LIMIT 1", $br = ''; // Output row - if (($row['curr_points'] > 0) && ($cnt > 0)) { $bl = ""; $br = ""; } - if (($row['refs'] > 0) || ($cnt > 0)) { - // Insert link to referal list - //* DEBUG: */ outputHtml('-'.$row['userid'].'/'.$cnt.'/'.$row['refs']."-
"); - $cnt = generateUserProfileLink($row['userid'], $cnt, 'list_refs'); - $row['refs'] = generateUserProfileLink($row['userid'], $row['refs'], 'list_refs'); - } // END - if + if (($row['curr_points'] > 0) && ($cnt > 0)) { $bl = ''; $br = ''; } // Get user points $points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', false, " AND `ref_depth`=1 LIMIT 1"); - //* DEBUG: */ outputHtml(basename(__FILE__).":userid={$row['userid']},points={$points},opoints={$row['curr_points']}
"); + //* DEBUG: */ debugOutput(basename(__FILE__).':userid='.$row['userid'].',points='.$points.',opoints='.$row['curr_points']); // Prepare content - // @TODO Rewritings: userid->userid,opoints->curr_points,old->refs in template $row = array( 'sw' => $SW , - 'userid' => $row['userid'], + 'userid' => $row['userid'], 'bold_l' => $bl , 'bold_r' => $br , - 'old' => $row['refs'], + 'rews' => $row['refs'], 'cnt' => $cnt, - 'opoints' => translateComma($points - $row['curr_points']), + 'opoints' => ($points - $row['curr_points']), ); // Load row template and switch color @@ -263,114 +277,118 @@ LIMIT 1", $SW = 3 - $SW; } // END - while + // Remember rows + $content['rows'] = $OUT; + $content['rallye'] = getRequestParameter('rallye'); + // Free memory SQL_FREERESULT($result); // Load template - loadTemplate('admin_list_rallye_usr', false, $OUT); + loadTemplate('admin_list_rallye_usr', false, $content); } else { // No entries found? - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ADMIN_USERS_404')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_ADMIN_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 -FROM `{?_MYSQL_PREFIX?}_rallye_data` -ORDER BY start_time DESC", - __FILE__, __LINE__); + $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` +FROM + `{?_MYSQL_PREFIX?}_rallye_data` +ORDER BY + `start_time` DESC", __FILE__, __LINE__); + + // Records found? if (SQL_NUMROWS($result) > 0) { // List found rallyes $OUT = ''; $SW = 2; - while ($row = SQL_FETCHARRAY($result)) { + while ($data = SQL_FETCHARRAY($result)) { // Load admin login - $row['login'] = getAdminLogin($row['admin_id']); + $data['login'] = getAdminLogin($data['admin_id']); // Count joined userids - $joined = countSumTotalData($row['id'], "rallye_users", 'id', "rallye_id", true); + $users = countSumTotalData($data['id'], 'rallye_users', 'id', 'rallye_id', true); // Did some users joined this rallye? - if ($joined > 0) { + if ($users > 0) { // List joined users - $joined = "".$joined.""; + $users = '' . $users . ''; } // END - if // Alter some variables - if (empty($row['login'])) $row['login'] = '???'; - if (empty($row['template'])) $row['template'] = '---'; - if (empty($row['descr'])) $row['descr'] = '---'; + if (empty($data['login'])) $data['login'] = '???'; + if (empty($data['template'])) $data['template'] = '---'; + if (empty($data['descr'])) $data['descr'] = '---'; // Transfer data into array for the template - // @TODO Rewritings: admin_id->admin_id in template $row = array( - 'select' => "", - 'admin_id' => $row['admin_id'], - 'email_link' => generateEmailLink($row['admin_id']), - 'login' => $row['login'], - 'id' => $row['id'], - 'sw' => $SW, - 'title' => $row['title'], - 'template' => $row['template'], - 'joined' => $joined, - 'start_date' => generateDateTime($row['start_time'], 2), - 'end_date' => generateDateTime($row['end_time'] , 2), - 'active_lnk' => translateYesNo($row['is_active']), - 'notify_lnk' => translateYesNo($row['send_notify']), - 'auto_lnk' => translateYesNo($row['auto_add_new_user']), - 'notified' => translateYesNo($row['notified']), - 'prices_cnt' => translateComma(countSumTotalData($row['id'], 'rallye_prices', 'id', 'rallye_id', true)), - 'descr' => $row['descr'], - 'min_users' => $row['min_users'], - 'min_prices' => $row['min_prices'], + 'select' => '', + 'admin_id' => $data['admin_id'], + 'login' => $data['login'], + 'id' => $data['id'], + 'sw' => $SW, + 'title' => $data['title'], + 'template' => $data['template'], + 'users_content' => $users, + 'start_date' => generateDateTime($data['start_time'], 2), + 'end_date' => generateDateTime($data['end_time'] , 2), + 'is_active' => $data['is_active'], + '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), + 'descr' => $data['descr'], + 'min_users' => $data['min_users'], + 'min_prices' => $data['min_prices'], ); // Is the rallye active or not? - switch ($row['is_active']) - { + switch ($data['is_active']) { case 'Y': // Rallye is active so do not edit it! - $row['select'] = "
".$row['id']."
"; - $row['active_title'] = getMessage('RALLYE_DEACTIVATE_NOW'); - $row['active'] = 0; + $row['select'] = '
' . $row['id'] . '
'; + $row['active_title'] = '{--RALLYE_DEACTIVATE_NOW--}'; + $row['active'] = '0'; break; case 'N': - $row['active_title'] = getMessage('RALLYE_ACTIVATE_NOW'); - $row['active'] = 1; + $row['active_title'] = '{--RALLYE_ACTIVATE_NOW--}'; + $row['active'] = 1; break; - } + } // END - switch // Notification to members? - switch ($row['send_notify']) - { + switch ($data['send_notify']) { case 'Y': - $row['notify_title'] = getMessage('RALLYE_STOP_NOTIFY_NOW'); - $row['notify'] = 0; + $row['notify_title'] = '{--RALLYE_STOP_NOTIFY_NOW--}'; + $row['notify'] = '0'; break; case 'N': - $row['notify_title'] = getMessage('RALLYE_START_NOTIFY_NOW'); - $row['notify'] = 1; + $row['notify_title'] = '{--RALLYE_START_NOTIFY_NOW--}'; + $row['notify'] = 1; break; - } + } // END - switch // Auto-add of new joined members? - switch ($row['auto_add_new_user']) - { + switch ($data['auto_add_new_user']) { case 'Y': - $row['auto_title'] = getMessage('RALLYE_STOP_AUTO_ADD_NOW'); - $row['auto'] = 0; + $row['auto_title'] = '{--RALLYE_STOP_AUTO_ADD_NOW--}'; + $row['auto'] = '0'; break; case 'N': - $row['auto_title'] = getMessage('RALLYE_START_AUTO_ADD_NOW'); - $row['auto'] = 1; + $row['auto_title'] = '{--RALLYE_START_AUTO_ADD_NOW--}'; + $row['auto'] = 1; break; - } + } // END - switch // Output row $OUT .= loadTemplate('admin_list_rallyes_row', true, $row); $SW = 3 - $SW; - } + } // END - while // Free memory SQL_FREERESULT($result); @@ -382,7 +400,7 @@ ORDER BY start_time DESC", loadTemplate('admin_list_rallyes', false, $content); } else { // No rallyes setup so far - loadTemplate('admin_settings_saved', false, getMessage('RALLYE_NO_RALLYES_SETUP')); + loadTemplate('admin_settings_saved', false, '{--RALLYE_NO_RALLYES_SETUP--}'); } }