<?php
/************************************************************************
- * MXChange v0.2.1 Start: 06/29/2004 *
- * ================ Last change: 02/11/2005 *
+ * Mailer v0.2.1-FINAL Start: 06/29/2004 *
+ * =================== Last change: 02/11/2005 *
* *
* -------------------------------------------------------------------- *
* File : what-list_rallyes.php *
// Some security stuff...
if ((!defined('__SECURITY')) || (!isAdmin())) {
die();
-}
+} // END - if
// Add description as navigation point
addMenuDescription('admin', __FILE__);
-if (!isGetRequestElementSet('sub')) setRequestGetElement('sub', '');
+// Init message
$message = '';
// Quick actions on a rallye
array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
);
break;
- }
+ } // END - switch
} elseif (isGetRequestElementSet('notify')) {
// Automatic notification
switch (getRequestElement('notify')) {
array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
);
break;
- }
+ } // END - switch
} elseif (isGetRequestElementSet('auto')) {
// Automatic adding of new members
switch (getRequestElement('auto')) {
array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
);
break;
- }
+ } // END - switch
}
// Run SQL command
runFilterChain('run_sqls');
} elseif (isPostRequestElementSet('remove')) {
// Delete rallyes
- $SEL = countPostSelection();
- if ($SEL > 0) {
+ if (countPostSelection() > 0) {
// Init SQLs
initSqls();
// 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",
+ 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",
+ addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s",
array(bigintval($id)), __FILE__, __LINE__, false));
} // END - foreach
}
} elseif (isPostRequestElementSet('change')) {
// Change rallye
- $SEL = countSelection(postRequestElement('title'));
- if ($SEL > 0) {
+ if (countSelection(postRequestElement('title')) > 0) {
// Init SQLs
initSqls();
if (isPostRequestElementSet('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) {
$br = '';
// Output row
- if (($row['curr_points'] > 0) && ($cnt > 0)) { $bl = "<strong>"; $br = "</strong>"; }
- if (($row['refs'] > 0) || ($cnt > 0)) {
- // Insert link to referal list
- //* DEBUG: */ outputHtml('-'.$row['userid'].'/'.$cnt.'/'.$row['refs']."-<br />");
- $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 = '<strong>'; $br = '</strong>'; }
// 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']}<br />");
// Prepare content
- // @TODO Rewritings: userid->userid,opoints->curr_points,old->refs in template
+ // @TODO Rewritings: 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'],