" . $past . " AND uid=0;"); list($guest_online_num) = sql_fetch_row($result); // Alle User ermitteln, evtl auflisten $member_online_num = 0; $whoonlineselect = ""; $smallunmae = strtolower($username); // $GLOBALS["mxSqlDebug"] = 1; // $result = sql_query("SELECT uname, uid, user_lastvisit FROM ${user_prefix}_users WHERE (user_lastvisit >= ".$past.") AND user_stat=1 order by uname"); /** * $result = sql_query("SELECT u.uname * FROM ${user_prefix}_users As u LEFT JOIN ${prefix}_visitors AS v ON u.uid = v.uid * WHERE ((u.user_lastvisit >= ".$past.") AND (u.user_stat=1) AND (u.uname NOT IN ($excludedusers)) AND (v.uid=u.uid)) * ORDER BY u.uname"); */ $result = sql_query("SELECT uname FROM ${user_prefix}_users WHERE ((uname Not In (" . $excludedusers . ")) AND (user_lastvisit >= " . $past . ") AND (user_stat=1) AND (user_lastmod<>'logout')) ORDER BY uname"); // $GLOBALS["mxSqlDebug"] = 0; while (list($uname2) = sql_fetch_row($result)) { $sel = (strtolower($uname2) == $smallunmae) ? " selected " : ""; $uname3 = mxCutString($uname2, 18, "..", ""); # Kurzen Usernamen erstellen $whoonlineselect .= "\n"; # options fuer auswahlselect erstellen $member_online_num++; # Anzahl User hochzaehlen } // Private Nachrichten $countpm = 0; $countpmunread = 0; if (MX_IS_USER) { // Wenn aktueller User registriert ist (kein Gast) $pmactiv = (mxModuleAllowed($pm_module_name)) ? 1 : 0; # feststellen ob pm-modul aktiv ist if ($pmactiv) { // falls pm-modul aktiv ist $qry = "SELECT read_msg, Count(msg_id) FROM ${prefix}_priv_msgs WHERE to_userid=" . $uid . " group by read_msg;"; $result = sql_query($qry); while (list($read_msg, $nums) = sql_fetch_row($result)) { if ($read_msg == 0) { // wenn angemeldeter User $countpmunread = $nums; # Anzahl ungelesene ermitteln } else { $countpm = $nums; #++; # Anzahl aller pm's ermitteln } } } // else{ // $checkpmtime=0; # private Nachrichten nicht abfragen! // } } // Usergaestebuch $content_ug = ""; if (MX_IS_USER) { // Wenn aktueller User registriert ist (kein Gast) if (mxModuleAllowed("UserGuest")) { // falls gaestebuch vorhanden $qry = "SELECT Count(gid) FROM ${prefix}_userguest WHERE touserid='" . $uid . "' AND touser = '" . $username . "' AND dummy=0;"; $result = sql_query($qry); list($gbnewentries) = sql_fetch_row($result); // Usergaestebuch if (!empty($gbnewentries)) { $content_ug .= "
\"" \n $gbnewentries "; if ($gbnewentries == 1) { $content_ug .= "" . _BWOGUESTBOOK1 . ""; } else { $content_ug .= "" . _BWOGUESTBOOK2 . ""; } $content_ug .= "
"; } } } // weitere Variablen initialisieren zur Zeitberechnung :( // Creating SQL parameter $gestern = mktime(0, 0, 0, date ("m") , date ("d")-1, date("Y")); $heute = mktime(0, 0, 0, date ("m") , date ("d"), date("Y")); // Heute neu angemeldete User ermitteln $qry = "SELECT COUNT(uid) from ${user_prefix}_users WHERE user_regtime >= $heute and user_stat=1 and uname not in($excludedusers);"; list($userCount) = sql_fetch_row(sql_query($qry)); // Gestern neu angemeldete User ermitteln $qry = "SELECT COUNT(uid) from ${user_prefix}_users WHERE user_regtime >= $gestern and user_regtime < $heute and user_stat=1 and uname not in($excludedusers);"; list($userCount2) = sql_fetch_row(sql_query($qry)); //membres dans les salons ............................................ $exptime = time()-30; $member_onchat_num = 0; $result = sql_query("SELECT Count(name) FROM x7chat2_online WHERE invisible<>'1' AND time>'$exptime'"); list($member_onchat_num) = sql_fetch_row($result); // Ausgabe ................................... $content = "\n\n
\n" . "\""\n" . "\n" . "\n\n\n\n\n" . "\n\n\n\n\n" . "\n\n\n\n\n" . "\n\n\n\n\n" . "\n\n\n\n\n" . "\n\n\n\n\n" . "
" . _BWOTOTALMEMBERS . "\n$totalmembers
" . _BWOTODAYMEMBERS . "\n$userCount
" . _BWOYESTERDAYMEMBERS . "\n$userCount2
" . _BWOMEMBERS1 . "\n$member_online_num
" . _BWOGUESTES . "\n$guest_online_num
" . _CHATMEMBER . "\n$member_onchat_num
\n"; if (MX_IS_USER) { // zuletzt angemeldeter User $content .= "
" . _BWOLATEMEMBER . "
\n$lastuser
\n"; } if (MX_IS_USER || MX_IS_ADMIN || $showuserlistall) { // Wenn angemeldeter User oder Admin oder Liste immer erscheinen soll // Onlineliste anzeigen wenn User online sind if ($member_online_num > 0) { if ($onlinelistsize >= $member_online_num) { $onlinelistsize = $member_online_num + 1; } if (!MX_IS_USER || !$pmactiv) { $script = ""; } else { $script = " onDblClick=\"whob_clickit()\""; $content .= "\n"; } // background-color: $bgcolor1; font-size: 9px; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; color: $txtcolor1; width: 90%; border: 0px $bgcolor1; $content .= "\n"; $content .= "\n\n\n\n"; $content .= "\n\n\n\n"; $content .= "
\n"; $content .= "\""\n" . _BWOONLINELIST . "\n\""
\n"; $content .= "
"; # select-options verwenden $content .= "
"; $content .= ""; $content .= ""; $content .= ""; $content .= "
\n"; $content .= "
\n"; $content .= "
\n"; } // private messages if (!empty($pmactiv) && MX_IS_USER) { // pm Liste $content .= "\n"; if ($countpm) { $content .= "\n\n\n\n"; $content .= "\n\n\n"; $content .= "\n"; $content .= "\n\n"; } else { $content .= "\n"; } $content .= "
" . _BWOPMSG . "
\""" . _BWOPMSGALL . ":
\n" . _BWOPMSGUNREAD . ":		" . $countpm . "
\n"; $content .= ($countpmunread) ? "\"\" " . $countpmunread . "" : "$countpmunread"; $content .= "
\""" . _BWOPMSG . "
\n"; // Buddy if ($showbuddy) { $themedir = MX_THEME_DIR . "/images"; $buddyimg = (@file_exists($themedir . "/buddy.gif")) ? $themedir . "/buddy.gif" : $imagedir . "/buddy.gif"; $buddyimg = mxCreateImage($buddyimg, _BWOBUDDIE, 0); $windowname = md5($GLOBALS['sitename']); $content .= "" . $buddyimg . "
\n"; } } // Usergaestebuch $content .= $content_ug; } if (!MX_IS_USER) { // Gast no user $content .= "

\n" . _BWOASREGISTERED . "
\n"; } // if(MX_IS_USER && $checkpmtime>0 && $pmactiv){ // $checkpmfile="modules.php?name=$pm_module_name&file=buddy&op=check&ref_intervall=$checkpmtime"; // $content.= ""; // } $content .= "
\n\n"; // Blocktitel aus Sprachdatei auslesen $blockfiletitle = _BWOMAAXONLINE; ?>