$text .= "| <A HREF=\"sperre.php?http_host={$http_host}&id={$id}&aktion=loginsperre0\">" . "Loginsperre: Deaktivieren" . "</A>\n";
} else {
$text .= "| <A HREF=\"sperre.php?http_host={$http_host}&id={$id}&aktion=loginsperre1\">" . "Loginsperre: Aktivieren" . "</A>\n";
}
@mysql_free_result($result);
$query = "SELECT is_domain FROM ip_sperre WHERE is_domain = '-GAST-'";
$result = mysql_query($query, $conn);
if ($result && mysql_num_rows($result) > 0) {
$text .= "| <A HREF=\"sperre.php?http_host={$http_host}&id={$id}&aktion=loginsperregast0\">" . "Loginsperre Gast: Deaktivieren" . "</A>\n";
} else {
$text .= "| <A HREF=\"sperre.php?http_host={$http_host}&id={$id}&aktion=loginsperregast1\">" . "Loginsperre Gast: Aktivieren" . "</A>\n";
}
@mysql_free_result($result);
$text .= "| <A HREF=\"blacklist.php?http_host={$http_host}&id={$id}&neuer_blacklist[u_nick]={$uname}\">" . $zusatztxt . $t['menue3'] . "</A>\n";
}
show_box2($box, $text, "100%");
echo "<IMG SRC=\"pics/fuell.gif\" ALT=\"\" WIDTH=4 HEIGHT=4><BR>\n";
// Soll Datensatz eingetragen oder geändert werden?
if (isset($eintragen) && $eintragen == $t['sonst13']) {
if (!isset($f['is_infotext'])) {
$f['is_infotext'] = "";
}
if (!isset($f['is_domain'])) {
$f['is_domain'] = "";
}
$f['is_infotext'] = htmlspecialchars($f['is_infotext']);
$f['is_domain'] = htmlspecialchars($f['is_domain']);
// IP zusamensetzen
$f['is_ip'] = $ip1 . "." . $ip2 . "." . $ip3 . "." . $ip4;
if (strlen($f['is_domain']) > 0 && $f['is_ip'] != "...") {
echo "<P>{$t['sonst5']}</P>\n";
if ($result and mysql_num_rows($result) > 0) {
$themen = $themen - mysql_result($result, 0, 0);
mysql_free_result($result);
}
// Anzahl Postings
$query = "select count(po_id) from posting";
$result = mysql_query($query, $conn);
if ($result and mysql_num_rows($result) > 0) {
$beitraege = mysql_result($result, 0, 0);
mysql_free_result($result);
}
if ($beitraege && $themen) {
$text .= str_replace("%themen%", $themen, str_replace("%beitraege%", $beitraege, $t['default8']));
}
}
show_box2(str_replace("%chat%", $chat, $ft0 . $t['default5'] . $ft1), $text, "100%", false);
echo "<IMG SRC=\"pics/fuell.gif\" ALT=\"\" WIDTH=4 HEIGHT=4><BR>\n";
}
if (!isset($unterdruecke_raeume)) {
$unterdruecke_raeume = 0;
}
if (!$unterdruecke_raeume && $abweisen == false) {
// Wer ist online? Boxen mit Usern erzeugen, Topic ist Raumname
if ($onlineanzahl) {
if (!isset($keineloginbox)) {
show_who_is_online($result2);
}
}
}
// result wird in "show_who_is_online" freigegeben
// mysql_free_result($result2);
<?php
include "functions.php";
$query = "SELECT o_who,o_name,o_level,r_name,r_status1,r_status2, r_name='Lobby' as lobby FROM online left join raum on o_raum=r_id WHERE (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(o_aktiv)) <= 300 and r_name is null ORDER BY lobby desc,r_name,o_who,o_name";
$result = mysql_query($query);
$text = "";
while ($a = mysql_fetch_array($result)) {
$text .= "{$a['o_name']} ";
}
show_box2("User online im FORUM:", $text, "100%", false);
$i++;
}
$msg .= statsPrintGraph($c_host, $STAT_TXT["0102"], $STAT_TXT["0105"]);
}
$j++;
}
}
show_box2($t['statistik3'], $msg, "100%");
break;
case "stunde":
$h = 24;
$msg = "";
$showtime = time() - ($h - 1) * 60 * 60;
statsResetHours($showtime, $h);
$r0 = @mysql_query("SELECT *, DATE_FORMAT(c_timestamp,'%k') as stunde FROM chat WHERE UNIX_TIMESTAMP(c_timestamp)>{$showtime} AND c_host LIKE '{$v}' ORDER BY c_timestamp");
if ($r0 > 0) {
$i = 0;
$n = @mysql_num_rows($r0);
while ($i < $n) {
$x = @mysql_result($r0, $i, "stunde");
$c_users = @mysql_result($r0, $i, "c_users");
$grapharray["{$x}"] += $c_users;
$i++;
}
$title = $v;
$msg .= statsPrintGraph($title, $STAT_TXT["0102"], $STAT_TXT["0103"]);
}
show_box2($t['statistik2'], $msg, "100%");
break;
}
// switch
function show_who_is_online($result)
{
// Funktion gibt Liste der Räume mit Usern aus
// $result ist gültiges Ergebnis einer Query, die o_userdata* und r_name enthalten muss
global $ft0, $ft1, $t, $whotext;
$text = "";
$r_name_alt = "";
$zeigen_alt = TRUE;
if ($result) {
while ($row = mysql_fetch_object($result)) {
if ($row->o_level == "S" || $row->o_level == "C") {
$nick = "<b>{$row->o_name}</b>";
} else {
$nick = $row->o_name;
}
// Unterscheidung Raum oder Community-Modul
if (!$row->r_name || $row->r_name == "NULL") {
$r_name = $t['default10'] . $whotext[$row->o_who];
$zeigen = TRUE;
} else {
// Nur offene, permanente Räume zeigen
if (($row->r_status1 == 'O' || $row->r_status1 == 'm') && $row->r_status2 == 'P') {
$zeigen = TRUE;
} else {
$zeigen = FALSE;
}
$r_name = $t['default9'] . $row->r_name;
}
// Textwechsel
if ($r_name_alt != $r_name) {
if (strlen($text) == 0) {
$text = "{$nick} ";
} else {
// Nur offene, permanente Räume zeigen
if ($zeigen_alt) {
show_box2(str_replace("%raum%", $r_name_alt, $ft0 . $t['default4'] . $ft1), $text, "100%", false);
echo "<IMG SRC=\"pics/fuell.gif\" ALT=\"\" WIDTH=4 HEIGHT=4><BR>\n";
}
$text = "{$nick} ";
}
$r_name_alt = $r_name;
$zeigen_alt = $zeigen;
} else {
$text .= "{$nick} ";
}
}
if ($zeigen_alt) {
show_box2(str_replace("%raum%", $r_name_alt, $ft0 . $t['default4'] . $ft1), $text, "100%", false);
echo "<IMG SRC=\"pics/fuell.gif\" ALT=\"\" WIDTH=4 HEIGHT=4><BR>\n";
}
mysql_free_result($result);
}
}
function AufladeFormular()
{
global $f, $userdata, $sms, $chat, $u_id, $farbe_tabelle_zeile1, $farbe_tabelle_zeile2, $http_host, $u_nick;
$box = $ft0 . "Guthaben aufladen" . $ft1;
$text .= "Wenn Sie SMS aus dem {$chat} verschicken möchten, so müssen Sie zuerst ein SMS Guthaben kaufen.<BR>";
$text .= "Dies funktioniert bequem im Lastschriftverfahren von Ihrem Bankkonto.";
$text .= "<BR>Jede SMS kostet Sie nur <B>{$sms['preis']} Cent</B>. <BR>Sie können die SMS in verschiedenen Staffelungen kaufen.";
$handynr = $userdata['u_sms_extra'];
$handynr = unserialize($handynr);
$handynr = $handynr['handynr'];
$text2 .= '
<script>
function CalcSMS()
{
pos=document.forms["sms"].trx_amount.selectedIndex;
centbetrag=document.forms["sms"].trx_amount.options[pos].value;
document.forms["sms"].smsanz.value= (Math.round(centbetrag / ' . $sms[preis] . '));
}
function pruefe()
{
alertmsg="";
pos=document.forms["sms"].trx_amount.selectedIndex;
if (pos == "0"){ alertmsg = "Bitte eine Betrag > 0 wählen";}
if (alertmsg == "") {
return true;
} else {
window. alert (alertmsg);
return false;
}
}
</script>
<table align=RIGHT border=0 cellpadding=5 cellspacing=0 BGCOLOR="' . $farbe_tabelle_zeile1 . '">
<form action="' . $sms[ipayment] . '" METHOD=POST name="sms" onSubmit="return pruefe()">
<input type=hidden name="trxuser_id" value="' . $sms[ipayment_trxuser_id] . '">
<input type=hidden name="trxpassword" value="' . $sms[ipayment_trx_password] . '">
<input type=hidden name="redirect_url" value="' . $sms[ipayment_redirect_url] . '">
<!--
<input type=hidden name="addr_name" value="' . $userdata['u_name'] . '">
<input type=hidden name="addr_street" value="' . $f['ui_strasse'] . '">
<input type=hidden name="addr_zip" value="' . $f['ui_plz'] . '">
<input type=hidden name="addr_city" value="' . $f['ui_ort'] . '">
<input type=hidden name="addr_email" value="' . $userdata['u_adminemail'] . '">
-->
<input type=hidden name="http_host" value="' . $http_host . '">
<input type=hidden name="u_id" value="' . $u_id . '">
<input type=hidden name="invoice_text" value="' . $chat . '">
<input type=hidden name="trx_user_comment" value="' . $http_host . '-' . $u_nick . '-' . $chat . '">
<input type=hidden name="u_nick" value="' . $u_nick . '">
<input type=hidden name="handynr" value="' . $handynr . '">
<tr><td>Aufladebetrag</td><td>
<input type=hidden name="trx_currency" value="EUR">
<input type=hidden name="trx_paymenttyp" value="elv">
<select name="trx_amount" onChange=CalcSMS()>
<option value="000">bitte wählen
<option value="300">3.00 Euro
<option value="500">5.00 Euro
<option value="1000">10.00 Euro
<option value="1500">15.00 Euro
<option value="2000">20.00 Euro
<option value="2500">25.00 Euro
</select>
<tr><td>Dafür bekommen Sie</td><td><input name="smsanz" readonly size=5> SMS</td></tr>
<TR><TD COLSPAN=2>
<input type=submit value="Jetzt SMS Guthaben aufladen">
</TD></TR>
</table>
';
$atext = $text2 . $text;
show_box2($box, $atext, "100%");
}
