function demoteMember($demotee, $reason, $ip)
{
global $fontString, $myrow, $today2, $today, $today1;
$result = @mysql_query("SELECT * FROM members WHERE username = \"$demotee\"");
$theirrow = mysql_fetch_array($result);
$rank1 = getRankByNum($myrow["rank"]);
if ($theirrow['lastdemo'] == NULL) {
$sincedemo = "19010101";
}
else {
$sincedemo = $theirrow['lastdemo'];
}
if($sincedemo == $today1) {
echo("
<center>$fontString
<META HTTP-EQUIV=\"Refresh\" CONTENT=\"4; URL=usr_cmd.php\">
$promotee was already demoted once today. You can't demote a member twice in one day, please wait until tomorrow. Please hang tight, I'm forwarding you back to your login menu.
");
}
else{
if($myrow > ($theirrow["rank"] + 2)) {
$newrank = $theirrow["rank"] - 1;
$rank = getRankByNum($newrank);
$ault1 = @mysql_query("SELECT * FROM site_info");
$rrow = mysql_fetch_array($ault1);
mail("$theirrow[email]", "ATTENTION: $rank1 $myrow[username] has demoted you!", "ATTENTION: You have been demoted by $rank1 $myrow[username] to $rank. For more information, please visit the website.", "From: $rrow[admin_email]\r\nReply-To: $rrow[admin_email]\r\nX-Mailer: DT_formmail");
@mysql_query("
UPDATE members SET rank = \"$newrank\", lastdemo = \"$today\" WHERE username = \"$demotee\"
");
@mysql_query("
INSERT INTO log SET info = \"$rank1 $myrow[username] demoted $demotee to $rank for $reason on $today2.\",
ip = \"$ip\"
");
echo("
<center>$fontString
<META HTTP-EQUIV=\"Refresh\" CONTENT=\"3; URL=usr_cmd.php\">
You have demoted $demotee to $rank. Please hold tight while I forward you back to the login menu.
");
}
}
}
function autodemote($demotee, $reason, $ip)
{
global $fontString, $myrow, $today2, $today, $today1;
$result = @mysql_query("SELECT * FROM members WHERE username = \"$demotee\"");
$theirrow = mysql_fetch_array($result);
$rank1 = getRankByNum($myrow["rank"]);
if($theirrow['lastdemo'] != $today1) {
$newrank = $theirrow["rank"] - 1;
$rank = getRankByNum($newrank);
$ault1 = @mysql_query("SELECT * FROM site_info");
$rrow = mysql_fetch_array($ault1);
mail("$theirrow[email]", "ATTENTION: You have been demoted for not logging in!", "ATTENTION: You have been demoted for not logging in on $rrow[title]. For more information, please visit the website.", "From: $rrow[admin_email]\r\nReply-To: $rrow[admin_email]\r\nX-Mailer: DT_formmail");
@mysql_query("
UPDATE members SET rank = \"$newrank\", lastdemo = \"$today\" WHERE username = \"$demotee\"
");
@mysql_query("
INSERT INTO log SET info = \"$demotee was demoted to $rank for inactivity on $today2.\",
ip = \"$ip\"
");
}
}
