in der Datei m\content\admin.user.php versteckt sich noch ein Fehler:
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 $
- #--------------------------------------------------------------------------------------------------
- # Copyright (C) 2002 - 2018 Soeren Wiechert
- # 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 />