}
// Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+ADD_DESCR("admin", __FILE__);
if (empty($_GET['sub'])) $_GET['sub'] = "";
$MSG = "";
foreach ($_POST['sel'] as $id => $sel)
{
// Remove selected rallye entirely...
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_data WHERE id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_prices WHERE rallye_id=%s",
- array(bigintval($id)), __FILE__, __LINE__);
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_users WHERE rallye_id=%s",
- array(bigintval($id)), __FILE__, __LINE__);
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_data WHERE id=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_prices WHERE rallye_id=%s",
+ array(bigintval($id)), __FILE__, __LINE__);
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_users WHERE rallye_id=%s",
+ array(bigintval($id)), __FILE__, __LINE__);
}
// Output message
$END = mktime($_POST['end_hour'][$id] , $_POST['end_min'][$id] , $_POST['end_sec'][$id] , $_POST['end_month'][$id] , $_POST['end_day'][$id] , $_POST['end_year'][$id] );
// Update entry
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_rallye_data SET
+ SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_rallye_data SET
title='%s',
descr='%s',
template='%s',
define('__RALLYE_VALUE', $_GET['rallye']);
while (list($uid, $old, $opoints) = SQL_FETCHROW($result))
{
- // Check for referral count
+ // Check for referal count
$cnt = RALLYE_GET_REFCOUNT($uid, $old);
// Output row
$Bl = ""; $Br = "";
- if (($opoints > 0) && ($cnt > 0)) { $Bl = "<STRONG>"; $Br = "</STRONG>"; }
+ if (($opoints > 0) && ($cnt > 0)) { $Bl = "<strong>"; $Br = "</strong>"; }
if (($old > 0) || ($cnt > 0))
{
- // Insert link to referral list
+ // Insert link to referal list
//* DEBUG: */ echo "-".$uid."/".$cnt."/".$old."-<br />";
$cnt = ADMIN_USER_PROFILE_LINK($uid, $cnt, "list_refs");
$old = ADMIN_USER_PROFILE_LINK($uid, $old, "list_refs");
}
// Get user points
- $points = GET_TOTAL_DATA($uid, "user_points", "points") - GET_TOTAL_DATA($uid, "user_data", "used_points");
+ $points = GET_TOTAL_DATA($uid, "user_points", "points", "userid", false, " AND ref_depth=1 LIMIT 1");
+ //* DEBUG: */ echo basename(__FILE__).":uid={$uid},points={$points},opoints={$opoints}<br />\n";
$content = array(
'sw' => $SW ,
'uid' => $uid,
if ($joined > 0)
{
// List joined users
- $joined = "<A href=\"".URL."/modules.php?module=admin&what=list_rallyes&sub=users&rallye=".$id."\" title=\"".RALLYE_LIST_USERS."\">".$joined."</A>";
+ $joined = "<a href=\"".URL."/modules.php?module=admin&what=list_rallyes&sub=users&rallye=".$id."\" title=\"".RALLYE_LIST_USERS."\">".$joined."</a>";
}
// Alter some variables
// Is the rallye active or not?
switch ($active)
{
- case 'Y':
+ case "Y":
// Rallye is active so do not edit it!
- $content['select'] = "<STRONG class=\"big\">".$id."</STRONG>";
+ $content['select'] = "<div class=\"big\">".$id."</strong>";
$content['active_title'] = RALLYE_DEACTIVATE_NOW;
$content['active'] = 0;
break;
- case 'N':
+ case "N":
$content['active_title'] = RALLYE_ACTIVATE_NOW;
$content['active'] = "1";
break;
// Notification to members?
switch ($notify)
{
- case 'Y':
+ case "Y":
$content['notify_title'] = RALLYE_STOP_NOTIFY_NOW;
$content['notify'] = 0;
break;
- case 'N':
+ case "N":
$content['notify_title'] = RALLYE_START_NOTIFY_NOW;
$content['notify'] = "1";
break;
// Auto-add of new joined members?
switch ($auto_add)
{
- case 'Y':
+ case "Y":
$content['auto_title'] = RALLYE_STOP_AUTO_ADD_NOW;
$content['auto'] = 0;
break;
- case 'N':
+ case "N":
$content['auto_title'] = RALLYE_START_AUTO_ADD_NOW;
$content['auto'] = "1";
break;