function ist_online($user)
{
// Prüft ob User noch online ist
// liefert 1 oder 0 zurück
global $dbase, $timeout, $ist_online_raum, $conn, $whotext;
$ist_online_raum = "";
$user = mysql_real_escape_string($user);
// sec
$query = "SELECT o_id,r_name FROM online left join raum on r_id=o_raum " . "WHERE o_user={$user} " . "AND (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(o_aktiv)) <= {$timeout}";
$result = mysql_query($query, $conn);
if ($result && mysql_NumRows($result) > 0) {
$ist_online_raum = mysql_result($result, 0, "r_name");
if (!$ist_online_raum || $ist_online_raum == "NULL") {
$ist_online_raum = "[" . $whotext[2] . "]";
}
@mysql_free_result($result);
return 1;
} else {
@mysql_free_result($result);
return 0;
}
}
function announces_subsections($sess, $rub, $pri, $cs, $cs1)
{
@($sqk = mysql_query("SELECT S.*,count(D.ann_id) FROM uniletim_subsections S \r\n\t LEFT JOIN uniletim_announces D ON S.sub_id=D.ann_sub \r\n\t WHERE S.sub_section='{$rub}' AND S.ul_group = '{$sess['4']}' GROUP BY S.sub_id ORDER BY S.sub_name"));
$pocet = mysql_NumRows($sqk);
?>
<div class="content-subsections"><?php
$i = 0;
while ($rok = mysql_fetch_row($sqk)) {
if ($i != "0") {
?>
|
<?php
}
if ($pri != $rok[0]) {
?>
<a href="index.php?rub=<?php
echo "{$rub}";
?>
&pri=<?php
echo "{$rok['0']}";
?>
&tbp=<?php
echo "{$tbp}";
?>
"><?php
echo $rok[1];
?>
</a> (<?php
} else {
echo "<b class=error>{$rok['1']}</b> (";
}
if ($sess[5] >= "2") {
?>
<a href="index.php?rub=<?php
echo "{$rub}";
?>
&pri=<?php
echo "{$rok['0']}";
?>
&view=admin"><?php
echo $rok[4];
?>
</a><?php
} else {
echo $rok[4];
}
?>
)<?php
$i++;
}
if ($tbp != "") {
?>
<br><a href="index.php?rub=<?php
echo "{$rub}";
?>
&pri=all&tbp=<?php
echo "{$tbp}";
?>
"><?php
echo _ALL;
?>
</a> |
<?php
} else {
?>
<br><a href="index.php?rub=<?php
echo "{$rub}";
?>
&pri=all"><?php
echo _ALL;
?>
</a> |
<a href="index.php?rub=<?php
echo "{$rub}";
?>
&pri=<?php
echo "{$pri}";
?>
&action=print"><?php
echo _PRINT;
?>
</a>
<?php
}
if ($sess[5] >= "2") {
?>
|
<a href="r_pr_zmena.php?rub=<?php
echo "{$rub}";
?>
"><?php
echo _CHANGE;
?>
</a><?php
}
?>
</div>
<?php
}
echo "<P><B>Fehler:</B> Kann Logdatei '{$r_name}' nicht öffnen!</P>\n";
}
$loesche .= "{$row->c_id}";
$raum_alt = $r_name;
$i++;
}
mysql_free_result($result);
// Chat-Zeilen löschen
$query = "DELETE FROM chat WHERE c_id IN ({$loesche})";
$result3 = mysql_query($query, $conn);
}
if ($expire_privat) {
// Chat expire und Kopie in Log für alle privaten Zeilen, die älter als 15 Minuten sind
$query = "SELECT SQL_BUFFER_RESULT * FROM chat " . "WHERE (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(c_zeit)) > 900 " . "AND c_typ='P' ORDER BY c_raum,c_id";
$result = mysql_query($query, $conn);
$rows = mysql_NumRows($result);
if ($rows > 0) {
$i = 0;
while ($i < $rows) {
set_time_limit(20);
$row = @mysql_fetch_object($result);
// Chat-Zeile in Log schreiben
$r_name = $log . "/chat_privatnachrichten";
// Ggf. Log routieren, falls > 100 MB
if (filesize($r_name) > 100000000) {
rename($r_name, $r_name . "_" . date("dmY"));
}
$handle = fopen($r_name, "a");
if ($handle != -1) {
$text = "[" . $row->c_zeit . "][" . $row->c_typ . "]";
if (strlen($row->c_von_user) > 0) {
