Mobile Version: Kleiner Bug bei Aktivierungsmail Mail an User

patchstar · 13. Juni 2018

in der Datei m\content\admin.user.php versteckt sich noch ein Fehler:

Code

"Nicht vergessen: Das erste Spiel der EM ". $CONFIG['JAHR']." beginnt am 10.06.2016 um 21:00 Uhr!\n";

Der Code ist sehr statisch...

Code

$result_first_game = $CONFIG['MYSQL']['CONNECT']->query("SELECT date FROM ". $CONFIG['MYSQL']['PREFIX'] ."spiele ORDER BY date ASC LIMIT 1");
$date_first_game = $result_first_game->fetch_row();
."Nicht vergessen: Das erste Spiel der ". strtoupper($CONFIG['Turnier']) ." ". $CONFIG['JAHR']." beginnt am ". date('d.m.Y', $date_first_game[0]) ." um ". date('H:i', $date_first_game[0]) ." Uhr!\n";

ist besser.

Hier noch die komplette Datei

Code

<?php
###################################################################################################
# Dateiname: admin.user.php
#
# Last Change of File
# -------------------
# Revision: $Rev: 300 $
# Date: $Date: 2017-08-13 23:00:00 +0200 (So, 13 Aug 2017) $
# Author: $Author: soeren $
# Mods by: $Mod: stegmuellerm $
#--------------------------------------------------------------------------------------------------
# Many thanks to Sebastian Mueller for his great work on the base code!
#
# License: GPL V3 - http://www.gnu.org/licenses/gpl-3.0.txt
#
# Please read the terms of license found in the license files which should be part of the
# package of this script. If not, please contact us at http://www.xcript.de.
#
# Bitte lese die Lizenz-Informationen, die als Beilage zu diesem Script-Paket enthalten sind.
# Falls diese nicht enthalten sind, dann kontaktiere uns bitte unter http://www.xcript.de.
###################################################################################################
if (!defined('|'))
{
if (@file_exists('../include/config_wmtipp.php'))
{
require_once ("../include/config_wmtipp.php");
}
else
{
require_once "../include/inc.config.php";
}
include "../include/inc.functions.php";
header ("location: ".$CONFIG['PATH'].gLink());
}
require "include/tipp.mailer.php";
if (isset($RUNTIME['PATH'][4]) && $RUNTIME['PATH'][4] == "change1" && $RUNTIME['PATH'][6] != "" && $RUNTIME['PATH'][5] != "")
{
$CONFIG['MYSQL']['CONNECT']->query("UPDATE ". $CONFIG['MYSQL']['PREFIX'] ."users SET isUnlocked = '". (int)$RUNTIME['PATH'][6] ."' WHERE id = '". (int)$RUNTIME['PATH'][5] ."'");
if((int)$RUNTIME['PATH'][6] && $CONFIG['EMPTYTIPPER'])
addFakeRanks((int)$RUNTIME['PATH'][5]);
header("location: ".$CONFIG['PATH'] . gLink($RUNTIME['PATH'][0] ."admin/admin/user/". $RUNTIME['PATH'][3] ."/"));
if ((int)$RUNTIME['PATH'][6] == 1)
{
$result = $CONFIG['MYSQL']['CONNECT']->query("SELECT usr, email FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE id = ". (int)$RUNTIME['PATH'][5]);
$row = $result->fetch_row();
$result_first_game = $CONFIG['MYSQL']['CONNECT']->query("SELECT date FROM ". $CONFIG['MYSQL']['PREFIX'] ."spiele ORDER BY date ASC LIMIT 1");
$date_first_game = $result_first_game->fetch_row();
if ($CONFIG['TEXTART'] == 0)
{
$mailBody = "Hallo ". $row[0] ."!"
."\n\n"
."Ihr Account wurde soeben aktiviert. Sie können sich ab sofort einloggen. Viel Spaß beim Tippen."
."\n\n"
."Nicht vergessen: Das erste Spiel der ". strtoupper($CONFIG['Turnier']) ." ". $CONFIG['JAHR']." beginnt am ". date('d.m.Y', $date_first_game[0]) ." um ". date('H:i', $date_first_game[0]) ." Uhr!\n";
}
else
{
$mailBody = "Hallo ". $row[0] ."!"
."\n\n"
."Dein Account wurde soeben aktiviert. Du kannst Dich ab sofort einloggen. Viel Spaß beim Tippen."
."\n\n"
."Nicht vergessen: Das erste Spiel der ". strtoupper($CONFIG['Turnier']) ." ". $CONFIG['JAHR']." beginnt am ". date('d.m.Y', $date_first_game[0]) ." um ". date('H:i', $date_first_game[0]) ." Uhr!\n";
}
$mail->AddAddress($row[1], $row[0]);
$mail->Subject = "Freischaltung auf ". $CONFIG['PAGE']['NAME'];
$mailCSS = " <style>body{font-family:verdana,arial,tahoma;font-size:10pt;}</style>";
// HTML-Teil der eMail
$mail->Body = nl2br($mailCSS
. htmlspecialchars($mailBody))
. $CONFIG['MAIL']['HTMLFOOT'];
// Alternativ-Text, falls der eMail-Client des Empfängers keine HTML-eMails anzeigen kann.
$mail->AltBody = strip_tags($mailBody)
. $CONFIG['MAIL']['PLAINFOOT'];
$mail->Send();
// Empfänger und Anlagen entfernen, da diese sonst auch für die nächste eMail verwendet werden
$mail->ClearAllRecipients();
$mail->ClearAttachments();
}
}
if (isset($RUNTIME['PATH'][4]) && $RUNTIME['PATH'][4] == "change3" && $RUNTIME['PATH'][6] != "" && $RUNTIME['PATH'][5] != "")
{
@$CONFIG['MYSQL']['CONNECT']->query("UPDATE ". $CONFIG['MYSQL']['PREFIX'] ."users SET status = '". (int)$RUNTIME['PATH'][6] ."' WHERE id = '". (int)$RUNTIME['PATH'][5] ."'");
header("location: ". $CONFIG['PATH'] . gLink($RUNTIME['PATH'][0] ."/admin/user/". $RUNTIME['PATH'][3] ."/"));
}
if (isset($RUNTIME['PATH'][4]) && $RUNTIME['PATH'][4] == "change4" && $RUNTIME['PATH'][6] != "" && $RUNTIME['PATH'][5] != "")
{
$CONFIG['MYSQL']['CONNECT']->query("UPDATE ". $CONFIG['MYSQL']['PREFIX'] ."users SET bezahlt = '". (int)$RUNTIME['PATH'][6] ."' WHERE id = '". (int)$RUNTIME['PATH'][5] ."'");
header("location: ". $CONFIG['PATH'] . gLink($RUNTIME['PATH'][0] ."/admin/user/". $RUNTIME['PATH'][3] ."/"));
}
if (isset($RUNTIME['PATH'][4]) && $RUNTIME['PATH'][4] == "change5" && $RUNTIME['PATH'][6] != "" && $RUNTIME['PATH'][5] != "")
{
$sqlTippgruppen = $CONFIG['MYSQL']['CONNECT']->query("SELECT shortname FROM ". $CONFIG['MYSQL']['PREFIX'] ."tippgruppen WHERE id= '". (int)$RUNTIME['PATH'][6] ."'");
$ugrp = @$sqlTippgruppen->fetch_array();
$sql = "UPDATE ". $CONFIG['MYSQL']['PREFIX'] ."users SET department = '". $ugrp['shortname'] ."' WHERE id = '". (int)$RUNTIME['PATH'][5] ."'";
@$CONFIG['MYSQL']['CONNECT']->query($sql);
header("location: ". $CONFIG['PATH'] . gLink($RUNTIME['PATH'][0] ."/admin/user/". $RUNTIME['PATH'][3] ."/"));
}
if (isset($RUNTIME['PATH'][4]) && $RUNTIME['PATH'][4] == "delete" && $RUNTIME['PATH'][5] != "" && $RUNTIME['PATH'][6] == "OK")
{
$sql2 = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE id = '". $RUNTIME['PATH'][5] ."'");
$row2 = $sql2->fetch_array();
$sql1 = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE id = '". $_SESSION['s_id'] ."'");
$row1 = $sql1->fetch_array();
if ($row2['status'] == 1 && $row1['status'] == 9)
{
$sql3 = $CONFIG['MYSQL']['CONNECT']->query("UPDATE ". $CONFIG['MYSQL']['PREFIX'] ."users SET isUnlocked = -1 WHERE id = '". $RUNTIME['PATH'][5] ."'");
#$sql4 = mysql_query("DELETE FROM ". $CONFIG['MYSQL']['PREFIX'] ."tipps WHERE usr = '". $RUNTIME['PATH'][5] ."'");
$sql5 = $CONFIG['MYSQL']['CONNECT']->query("DELETE FROM ". $CONFIG['MYSQL']['PREFIX'] ."rangliste_games WHERE uid = '". $RUNTIME['PATH'][5] ."'");
$sql6 = $CONFIG['MYSQL']['CONNECT']->query("DELETE FROM ". $CONFIG['MYSQL']['PREFIX'] ."rangliste_custom WHERE owner = '". $RUNTIME['PATH'][5] ."' OR uid = '". $RUNTIME['PATH'][5] ."'");
$sql7 = $CONFIG['MYSQL']['CONNECT']->query("DELETE FROM ". $CONFIG['MYSQL']['PREFIX'] ."rangliste_boni WHERE uid = '". $RUNTIME['PATH'][5] ."'");
#$sql8 = mysql_query("DELETE FROM ". $CONFIG['MYSQL']['PREFIX'] ."bonus_tipps WHERE usr = '". $RUNTIME['PATH'][5] ."'");
echo "<p>Der User wurde erfolgreich deaktiviert!</p>";
}
}
if (isset($RUNTIME['PATH'][4]) && $RUNTIME['PATH'][4] == "undelete" && $RUNTIME['PATH'][5] != "" && $RUNTIME['PATH'][6] == "OK")
{
$sql2 = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE id = '". $RUNTIME['PATH'][5] ."'");
$row2 = $sql2->fetch_array();
$sql1 = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE id = '". $_SESSION['s_id'] ."'");
$row1 = $sql1->fetch_array();
if ($row2['status'] == 1 && $row1['status'] == 9)
{
$sql3 = $CONFIG['MYSQL']['CONNECT']->query("UPDATE ". $CONFIG['MYSQL']['PREFIX'] ."users SET isUnlocked = 0 WHERE id = '". $RUNTIME['PATH'][5] ."'");
echo "<p>Der User wurde erfolgreich aktiviert!</p>";
}
}
?>
<p>Hier können die Benutzerrechte der angemeldeten Benutzer verwaltet werden.<br />Eine Änderung der jeweiligen
E-Mailadresse oder des Passwortes ist nicht möglich.</p>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="tabHeaderRandl" colspan="2" style="width: 240px" align="left" >
<select name="select" class="TeamSelect" style="width:150px;" onChange="location.href='<?php echo $CONFIG['PATH'] . gLink($RUNTIME['PATH'][0]); ?>/admin/user/' + this.value + '/'">
<option value="0" <?php echo ($RUNTIME['PATH'][3] == 0 ? "selected" : ""); ?>>-Alle anzeigen-</option>
<?php echo createRechteNavigation($RUNTIME['PATH'][3]); ?>
<option value="-1" <?php echo ($RUNTIME['PATH'][3] == -1 ? "selected" : ""); ?>>-gelöschte-</option>
<option value="-2" <?php echo ($RUNTIME['PATH'][3] == -2 ? "selected" : ""); ?>>-nicht aktivierte-</option>
<option value="-3" <?php echo ($RUNTIME['PATH'][3] == -3 ? "selected" : ""); ?>>-nur aktivierte-</option>
</select>
</td>
<td class="tabHeaderMid" align="center" style="width: 60px">Löschen</td>
<td class="tabHeaderMid" align="center">Akt</td>
<td class="tabHeaderMid" align="center">Bez</td> <?php
if ($CONFIG['OPTIN']['MAIL'] == TRUE)
{ ?>
<td class="tabHeaderMid" align="center">OptIn</td>
<?php
} ?>
<td class="tabHeaderMid" align="center">Rechte</td>
<td class="tabHeaderMid" align="center">Reg. Datum</td>
<td class="tabHeaderMid" align="center">Letzter Login</td>
<td class="tabHeaderMid" align="center">Tippgruppe</td>
<td class="tabHeaderRandr" align="center">∑ Tipps</td>
</tr>
<?php
$remark_count = 0;
$query = "SELECT users.*, hashs.* FROM ". $CONFIG['MYSQL']['PREFIX'] ."users AS users"
." LEFT JOIN ". $CONFIG['MYSQL']['PREFIX'] ."user_hashs AS hashs ON hashs.user_id = users.id";
if ($RUNTIME['PATH'][3] > 0)
$query .= " WHERE users.status = ". $RUNTIME['PATH'][3] ." AND users.isUnlocked > -1";;
if ($RUNTIME['PATH'][3] == -1)
$query .= " WHERE users.isUnlocked = -1";
if ($RUNTIME['PATH'][3] == 0)
$query .= " WHERE users.isUnlocked > -1";
if ($RUNTIME['PATH'][3] == -2)
$query .= " WHERE users.isUnlocked = 0";
if ($RUNTIME['PATH'][3] == -3)
$query .= " WHERE users.isUnlocked = 1";
$query .= " ORDER BY users.usr ASC";
$sql = $CONFIG['MYSQL']['CONNECT']->query($query);
while ($row = $sql->fetch_array())
{
$show_remarks = false;
if (trim($row['remarks']) != "")
{
$show_remarks = true;
$remark_count++;
}
?>
<tr>
<td class="tabContentRandl" align="center" rowspan="<?php echo (isset($show_remarks) && $show_remarks ? "3" : "2"); ?>" style="width:15px; border-right:1px dotted #cdcdcd;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
#<?php echo $row['id']; ?>
</td>
<td class="tabContentMid" align="left" style="font-size:8pt; border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<b><?php echo wrapStr($row['usr'], 15, " "); ?></b>
</td>
<td class="tabContentMidmed" align="center" style="border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<?php
if ($row['id'] != 1)
{
if ($row['isUnlocked'] == -1)
{ ?>
[
<span id="confirm_button_undelete[<?php echo $row['id']; ?>]" onclick="javascript:confirm_undelete(<?php echo $row['id']; ?>);"
style="color:#00bb00; font-weight:bold;" onMouseOver="this.style.cursor='pointer';this.style.fontSize='150%';" onMouseOut="this.style.cursor='auto';this.style.fontSize='100%';">
V
</span>
]
<?php
}
else
{ ?>
[
<span id="confirm_button_delete[<?php echo $row['id']; ?>]" onclick="javascript:confirm_delete(<?php echo $row['id']; ?>);"
style="color:#ff0000; font-weight:bold;" onMouseOver="this.style.cursor='pointer';this.style.fontSize='150%';" onMouseOut="this.style.cursor='auto';this.style.fontSize='100%';">
X
</span>
]
<?php
}
}
?>
</td>
<td class="tabContentMidmed" align="center" style="border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<?php
if ($row['isUnlocked'] == 0)
{
?>
<input name="isUnlocked" type="checkbox" value="1"<?php echo ($row['id'] == 1 ? " disabled" : ""); ?>
onChange="location.href='<?php echo $CONFIG['PATH'].gLink($RUNTIME['PATH'][0]); ?>/admin/user/<?php echo $RUNTIME['PATH'][3]; ?>/change1/<?php echo $row['id']; ?>/' + this.value + '/'">
<?php
}
elseif ($row['isUnlocked'] == 1)
{
?>
<input name="isUnlocked" type="checkbox" value="0" checked<?php echo ($row['id'] == 1 ? " disabled" : ""); ?>
onChange="location.href='<?php echo $CONFIG['PATH'] . gLink($RUNTIME['PATH'][0]); ?>/admin/user/<?php echo $RUNTIME['PATH'][3]; ?>/change1/<?php echo $row['id']; ?>/' + this.value + '/'">
<?php
}
else
{
?>
<input name="isUnlocked" type="checkbox" value="0" disabled />
<?php
}
?>
</td>
<td class="tabContentMidmed" align="center" style="border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<?php
if ($row['bezahlt'] == 0)
{
?>
<input name="bezahlt" type="checkbox" value="1"<?php echo ($row['bezahlt'] == 1); ?>
onChange="location.href='<?php echo $CONFIG['PATH'].gLink($RUNTIME['PATH'][0]); ?>/admin/user/<?php echo $RUNTIME['PATH'][3]; ?>/change4/<?php echo $row['id']; ?>/' + this.value + '/'">
<?php
}
elseif ($row['bezahlt'] == 1)
{
?>
<input name="bezahlt" type="checkbox" value="0" checked="1"
onChange="location.href='<?php echo $CONFIG['PATH'] . gLink($RUNTIME['PATH'][0]); ?>/admin/user/<?php echo $RUNTIME['PATH'][3]; ?>/change4/<?php echo $row['id']; ?>/' + this.value + '/'">
<?php
}
else
{
?>
<input name="bezahlt" type="checkbox" value="0" />
<?php
}
?>
</td>
<?php
if ($CONFIG['OPTIN']['MAIL'] == TRUE)
{ ?>
<td class="tabContentMidmed" align="center" style="border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<?php
$optinpic = "";
$optintitle = "";
if ( ! is_null($row['user_id']) && $row['confirmed'] != 1 && $row['valid_until'] >= time())
{
$optinpic = "optin_wait.png";
$optintitle = "Bestätigung wurde noch nicht durchgeführt.";
}
elseif ($row['confirmed'] == 1)
{
$optinpic = "optin_ok.png";
$optintitle = "Bestätigung erhalten.";
}
elseif (is_null($row['user_id']))
{
$optinpic = "optin_missing.png";
$optintitle = "Bestätigung wurde nicht angefordert.";
}
else
{
$optinpic = "optin_notok.png";
$optintitle = "Bestätigung wurde nicht durchgeführt.";
} ?>
<img src="<?php echo $CONFIG['PATH']; ?>img/<?php echo $optinpic; ?>"
style="border:0px; width:27px; height:15px; padding:1px 0px 0px; margin:0px 0px 0px 0px;"
alt="<?php echo $optintitle ;?>" title="<?php echo $optintitle ;?>" />
</td>
<?php
} ?>
<td class="tabContentMidmed" align="center" style="border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<select name="select" class="TeamSelect" style="width:100px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>"<?php echo ($row['id'] == 1 ? " disabled" : ""); ?>
onChange="location.href='<?php echo $CONFIG['PATH'] . gLink($RUNTIME['PATH'][0]); ?>/admin/user/<?php echo $RUNTIME['PATH'][3]; ?>/change3/<?php echo $row['id']; ?>/' + this.value + '/'">
<?php echo createRechteNavigation($row['status']); ?>
</select>
</td>
<td class="tabContentMidmed" align="center" style="border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<?php echo getDateString($row['regDate']); ?><br /><?php echo getTimeString($row['regDate']); ?>
</td>
<td class="tabContentMidmed" align="center" style="border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<?php echo getDateString($row['lastLogin']); ?><br /><?php echo getTimeString($row['lastLogin']); ?>
</td>
<td class="tabContentMidmed" align="center" style="border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<select name="selectgroup" class="TeamSelect" style="width:115px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>" onChange="location.href='<?php echo $CONFIG['PATH'].gLink($RUNTIME['PATH'][0]); ?>/admin/user/<?php echo $RUNTIME['PATH'][3]; ?>/change5/<?php echo $row['id']; ?>/' + this.value + '/'">
<option value="1"<?php echo ($row['department'] == "ohne Gruppe" ? " selected" : ""); ?>>ohne Gruppe</option>
<?php
$result = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."tippgruppen WHERE active = 1 AND shortname <> 'ohne Gruppe'");
while ($grp = $result->fetch_array())
{
?>
<option value="<?php echo $grp['id']; ?>"<?php echo ($row['department'] == $grp['shortname'] ? " selected" : ""); ?>><?php echo $grp['shortname']; ?></option>
<?php
}
?>
</select>
</td>
<?php
$sqla = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."tipps WHERE usr = '".$row['id']."'");
$tipnum = $sqla->num_rows;
$checkbou = checkBonusOfUser($row['id']);
?>
<td class="tabContentRandrmed" style="text-align:center; border-bottom:0px;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
<?php echo $tipnum .'<br /><img src="img/'. ($checkbou == false ? "ok" : "nok") . ($row['isUnlocked'] == -1 ? "_off" : "") .'.gif"
style="border:0px; margin:0px 11px; padding:0px;" alt="'. ($checkbou == false ? "A" : "Nicht a") .'lle Bonustipps abgegeben!" title="'. ($checkbou == false ? "A" : "Nicht a") .'lle Bonustipps abgegeben!">'; ?>
</td>
</tr>
<tr>
<td class="tabContentMidmed" style="border-top:1px dotted #cdcdcd; border-bottom:<?php echo ($show_remarks ? "0px;" : "1px solid #b0b0b0;"); echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>" colspan="3">
<img src="<?php echo $CONFIG['PATH']; ?>img/name.gif" style="border:0px; width:10px; height:9px; padding:1px 0px 0px; margin:0px 0px 0px 0px;"> <i><?php echo $row['name']; ?></i>
</td>
<td class="tabContentMidmed" style="border-top:1px dotted #cdcdcd; border-bottom:<?php echo ($show_remarks ? "0px;" : "1px solid #b0b0b0;"); echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>" colspan="<?php echo ($CONFIG['OPTIN']['MAIL'] == TRUE ? 5 : 4); ?>">
<img src="<?php echo $CONFIG['PATH']; ?>img/email.gif" style="border:0px; width:10px; height:9px; padding:1px 0px 0px; margin:0px 0px 0px 0px;"> <i><?php echo $row['email']; ?></i>
</td>
<td class="tabContentRandrmed" style="border-top:1px dotted #cdcdcd; border-bottom:<?php echo ($show_remarks ? "0px;" : "1px solid #b0b0b0;"); echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>">
 
</td>
</tr>
<?php
if (isset($show_remarks) && $show_remarks)
{
?>
<tr>
<td class="tabContentRandrmed" style="border-top:1px dotted #cdcdcd;<?php echo ($row['isUnlocked'] == 0 ? " background:#ffcccc;" : ($row['isUnlocked'] == -1 ? " background:#cccccc; color:#888888;" : "")); ?>" colspan="<?php echo ($CONFIG['OPTIN']['MAIL'] == TRUE ? 9 : 8); ?>">
<img src="<?php echo $CONFIG['PATH']; ?>img/remarks.gif" style="border:0px; width:12px; height:12px; padding:1px 0px 0px; margin:0px 0px 0px 0px;" /> <i><?php echo $row['remarks']; ?></i>
</td>
</tr>
<?php
}
}
?>
</table>
<?php
$sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT id FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE isUnlocked = 1");
$numactive = $sql->num_rows;
$sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT id FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE bezahlt = 1");
$numbezahlt = $sql->num_rows;
$sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT id FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE isUnlocked = 0");
$numpending = $sql->num_rows;
$sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT id FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE isUnlocked = -1");
$numdeleted = $sql->num_rows;
$sql2 = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."users ORDER BY regDate DESC LIMIT 1");
$row2 = $sql2->fetch_array();
?>
<table align="center" cellpadding="0" cellspacing="0" style="font-style:italic;">
<tr>
<td style="text-align:right; width:12px;">
<img src="<?php echo $CONFIG['PATH']; ?>img/name.gif" style="border:0px; width:10px; height:9px; padding:1px 0px 0px; margin:0px 0px 0px 0px;">
</td>
<td style="text-align:left;"> Name</td>
<td style="width:40px;"> </td>
<td style="text-align:right; width:12px;">
<img src="<?php echo $CONFIG['PATH']; ?>img/email.gif" style="border:0px; width:10px; height:9px; padding:1px 0px 0px; margin:0px 0px 0px 0px;">
</td>
<td style="text-align:left;"> E-Mail Adresse</td>
<?php
if ($remark_count > 0)
{
?>
<td style="width:40px;"> </td>
<td style="text-align:right; width:12px;">
<img src="<?php echo $CONFIG['PATH']; ?>img/remarks.gif" style="border:0px; width:12px; height:12px; padding:1px 0px 0px; margin:0px 0px 0px 0px;">
</td>
<td style="text-align:left;"> Bemerkungen des Users</td>
<?php
}
?>
</tr>
</table>
<br />
<div class="infobox" style="text-align:center;">
Es sind <?php echo ($numactive + $numdeleted + $numpending); ?> Benutzer registriert. Aktiv: <?php echo $numactive; ?> - Bezahlt: <?php echo $numbezahlt; ?> - Inaktiv: <?php echo $numpending; ?> - Gelöscht: <?php echo $numdeleted; ?><br /><br />
Zuletzt registriert: "<i><?php echo $row2['usr']; ?></i>" (Registrierung am <?php echo date("d.m.y \u\m H:i",$row2['regDate']); ?> Uhr).
</div>
<br /><br />

Alles anzeigen

Mobile Version: Kleiner Bug bei Aktivierungsmail Mail an User

patchstar 13. Juni 2018

Ähnliche Themen

E-Mail bei Bezahlung

Registrieung Bestätigung bei Admin Aktivierung aus

Siegerseite (Treppchen)

Tags