function sendActivation($id, $logJoin)
{
require 'variables.php';
require 'variablesdb.php';
require_once 'log/KLogger.php';
$msg = "";
$logJoin->logInfo('sendActivation: autoApprove=' . $autoApprove);
$msg .= "autoApprove=" . $autoApprove;
if ($autoApprove > 0) {
$sql = "SELECT mail, name, signup from {$playerstable} where player_id = '{$id}'";
$logJoin->logInfo('sendActivation: sql=' . $sql);
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$toAddress = $row['mail'];
$name = $row['name'];
$signupHash = $row['signup'];
$msg .= "<br>signupHash=" . $signupHash;
if (!empty($signupHash)) {
$link = "http://www." . $leaguename . "/activate.php?id=" . $signupHash;
$res = sendActivationLinkMail($toAddress, $name, $link);
$logJoin->logInfo('sendActivation: res=' . $res);
$update_sql = "UPDATE {$playerstable} SET signupSent=1 WHERE player_id = '" . $id . "'";
$update_result = mysql_query($update_sql);
$logJoin->logInfo('sendActivation: update_result=' . $update_result);
$msg .= "<br>sent activation: toAddress=" . $toAddress . " name=" . $name;
}
}
return $msg;
}
for ($i = 0; $i < sizeof($rejectReasonsSelect); $i++) {
$id = $ids[$i];
$rejectId = $rejectIds[$i];
$rejectReasonText = $rejectReasonsText[$i];
$rejectReasonSelect = $rejectReasonsSelect[$i];
if (!empty($id)) {
$approveMsg .= "<p>";
$sql = "SELECT mail, name, signup from $playerstable where player_id = '$id'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$toAddress = $row['mail'];
$name = $row['name'];
$link = "http://www.yoursite/activate.php?id=".$row['signup'];
$res = sendActivationLinkMail($toAddress, $name, $link);
$approveMsg .= "Activation mail: <b>".$name."</b> - Address: ".$toAddress." - Result: ".$res."<br>";
$update_sql = "UPDATE $playerstable SET signupSent=1 WHERE player_id = '".$id."'";
$update_result = mysql_query($update_sql);
$approveMsg .= "</p>";
} elseif (!empty($rejectId)) {
if (!empty($rejectReasonSelect)) {
$reason = $rejectReasonSelect;
if (!empty($rejectReasonText)) {
$reason .= " (".$rejectReasonText.")";
}
} else {
$reason = $rejectReasonText;
}
$approveMsg .= "<p>";
$sql = "UPDATE $playerstable SET rejected=1, rejectReason='".$reason."' WHERE player_id = '$rejectId'";
}
}
}
}
if (!empty($_FILES['picture']['size']) && !$copywork) {
// echo "<p>Upload failed.</p>";
} else {
$sql = "UPDATE {$playerstable} SET alias = '{$alias1}', " . "mail = '{$mail1}', icq = '{$icq1}', " . "aim = '{$aim1}', msn = '{$msn1}', country = '{$country1}', nationality = '{$nationality1}', " . "passworddb = '', pwd='{$pwd}', forum='{$forum1}', sendGamesMail = '{$gamesMail1}', " . "uploadSpeed = '{$uploadSpeed1}', downloadSpeed = '{$downloadSpeed1}', " . "sendDeductMail = '{$deductMail1}', " . "sendNewsletter = '{$newsletter1}', " . "message = '{$message1}', versions = '{$versions1}', " . "defaultversion='{$defaultversion1}', favteam1='{$favteam11}', favteam2 = '{$favteam21}', " . "serial5='{$serial5}', hash5='{$hash5}', serial6='{$serial6}', hash6='{$hash6}', invalidEmail=0 WHERE name='{$cookie_name}'";
$result = mysql_query($sql);
$logEdit->logInfo('Profile saved, name=' . $cookie_name . ' pwd=' . $passworddb);
$logEdit->logInfo('sql=' . $sql);
echo "<p>Your changes have been saved.</p>";
echo "<p>You may need to log in again for changes to take effect.</p>";
if ($mail1 != $maildb && $rejected == 0 && $approved == 'no' && $signupSent == 1 && !$inactiveAndBanned) {
$link = "http://www.yoursite/activate.php?id=" . $signup;
$res = sendActivationLinkMail($mail1, $name, $link);
echo "<p>An account activation link has been sent to <b>" . $mail1 . "</b>.</p>";
}
}
} else {
echo "<p>The email address you entered is already in use by another account. Please note that only one account per player is allowed.</p>" . $back;
}
} else {
echo "<p>We couldn't find you in the database. Please try again or contact the admin if the problem persists.</p>" . $back;
}
}
}
}
}
}
}
