Statistik |
Beiträge: 144.530 (Täglich: 19,19 )
Themen: 16.700
Mitglieder: 13.209
Neuestes Mitglied: zitronentee.
Ausl. d. letzten Minute: 368%
Ausl. d. letzten 5 Minuten: 389%
Ausl. d. letzten 15 Minuten: 364%
Aktulle Uhrzeit: 14:07
Freier Webspace: 4.04 TB
PHP-Version: 7.4.33
|
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
Zitat: Original von Viktor
|
Zitat: Original von KleenMicha
Externe Javascript-Dateien sollte man nur bedacht einfügen. Dazu zählt auch das von Viktor erkannte. Schön zu hören dass ihr den Fehler gefunden habt.
in dem Zuge würde ich empfehlen alle Sachen die extern eingebunden sind eine Überprüfung zu unterziehen. Man weiß einfach nie was auf der Gegenseite einmal geändert wird.
|
|
|
Hallo,
jo darauf muss man schon achten.
Nicht vergessen das Forum wieder Online zu schalten.
Gruß
Viktor
|
|
|
suuuuuuuuuper vielen lieben dank viktor was wäre ich im wbb ohne deine hilfe
hast mir mal wieder echt geholfen
nun muss ich das nur noch irgendwie mit dem chat hinbekommen denn sind die user wieder glücklich
lg tommi
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
Zitat: Original von Viktor
Hallo,
so das Forum geht wieder.
Im Template "headinclude" hast du das drin.
code: |
1:
2:
3:
|
<script type="text/javascript src="http://www.kostenlose-javascripts.de/startScript.php?id=254"></script>
|
|
Da stimmt was nicht.
Ich habe es in der Datei "cache/templates"0_headinclude.php" raus genommen da ich keinen ACP-Zugang hatte.
Bitte im ACP das Template "headinclude" bearbeiten und die Codezeile da raus nehmen.
Gruß
Viktor
|
|
|
hääää du bist doch als admin eingetragen ???? komisch
ok ich mach das mal weg
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
Zitat: Original von KleenMicha
ich habe den teil mit dem SecurityHack von CT einmal auskommentiert, da ,mir das nicht so recht normal vorkommt. Am Rest konnte ich nichts falsches feststellen.
Was passiert wenn du diese Datei aus dem Anhang nutzt? |
|
|
ich glaube der gute viktor hat es geschaft
vieleicht sagt er uns ja was da war
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
|
Zitat: Original von KleenMicha
Sieht die Datei exakt so aus? Bitte hänge sie einmal hier an.
Versuche diese ruhig als *.zip-Datei zu packen. |
|
|
jo kommt
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
Zitat: Original von KleenMicha
Da spricht alles für eine Bearbeitung der Datei: ./global.php, oder eben einer darin includierten. Mein Tipp wäre es diese Datei genau anzusehen. Sprich hier anzuhängen.
|
|
|
php: |
1:
|
<?php require("./acp/lib/ct_funktion.inc.php"); include("./ct_blocker.php"); $countername = "./ct_blocker.txt"; $count_value1 = @file_get_contents($countername); $count_value1 = str_replace(",", ".",number_format($count_value1)); $counternamespy = "./ct_spy.txt"; $count_valuespy = @file_get_contents($counternamespy); $count_valuespy = str_replace(",", ".",number_format($count_valuespy)); $counternametrap = "./ct_bb/cttrappcount.txt"; $count_valuetrap = @file_get_contents($counternametrap); $count_valuetrap = str_replace(",", ".",number_format($count_valuetrap)); if ($badbot_options_link == 1) { $ct_badbot_url = "<center><a href=\"./ct_bb/ct_bb.php\"><img src=\"images/pixel.gif\" border=\"0\" alt=\"\"></img></a></center>"; }else{ $ct_badbot_url =""; } $counternameflood = "./ct_flood.txt"; $count_valueflood = @file_get_contents($counternameflood); $count_valueflood = str_replace(",", ".",number_format($count_valueflood)); // ************************************************************************************// // * WoltLab Burning Board 2 // ************************************************************************************// // * Copyright (c) 2001-2004 WoltLab GmbH // * Web http://www.woltlab.de/ // * License http://www.woltlab.de/products/burning_board/license_en.php // * http://www.woltlab.de/products/burning_board/license.php // ************************************************************************************// // * WoltLab Burning Board 2 is NOT free software. // * You may not redistribute this package or any of it's files. // ************************************************************************************// // * $Date: 2006-06-26 15:41:24 +0200 (Mo, 26 Jun 2006) $ // * $Author: Burntime $ // * $Rev: 1707 $ // ************************************************************************************// srand( (double)microtime() * 1000000 ); $tt_num1 = rand( 1, 9 ); $tt_num2 = rand( 1, 9 ); @error_reporting(7); $phpversion = phpversion(); /** get function libary **/ require('./acp/lib/functions.php'); if (version_compare($phpversion, '4.1.0') == -1) { $_REQUEST = array_merge($HTTP_COOKIE_VARS, $HTTP_POST_VARS, $HTTP_GET_VARS); $_COOKIE =& $HTTP_COOKIE_VARS; $_SERVER =& $HTTP_SERVER_VARS; $_FILES =& $HTTP_POST_FILES; $_GET =& $HTTP_GET_VARS; $_POST =& $HTTP_POST_VARS; } // remove slashes in get post cookie data... if (get_magic_quotes_gpc()) { if (count($_REQUEST)) $_REQUEST = stripslashes_array($_REQUEST); if (count($_POST)) $_POST = stripslashes_array($_POST); if (count($_GET)) $_GET = stripslashes_array($_GET); if (count($_COOKIE)) $_COOKIE = stripslashes_array($_COOKIE); if (count($_SERVER)) $_SERVER = stripslashes_array($_SERVER); } @set_magic_quotes_runtime(0); @ini_set('magic_quotes_sybase', '0'); /** * check uploaded files.. * search in Superglobal $_FILES * LM: 09.05.2006 00:13 Zagon Hornik */ if (!empty ($_FILES) && is_Array ($_FILES)) { foreach ($_FILES as $key=>$val) { if (!checkFile ($_FILES[$key]['tmp_name'])) { @unlink ($_FILES[$key]['tmp_name']); unset ($_FILES[$key]); } } } /** connect db **/ require('./acp/lib/config.inc.php'); require('./acp/lib/class_db_mysql.php'); $db = &new db($sqlhost, $sqluser, $sqlpassword, $sqldb, $phpversion); /** get configuration **/ require('./acp/lib/options.inc.php'); /** load smtp_socket function **/ require('./acp/lib/class_smtp.php'); /** Laufschrift **/ $laufen = $db->query_first("SELECT * FROM bb".$n."_laufschrift"); /** request ids **/ if (isset($_REQUEST['postid'])) $postid = $_REQUEST['postid']; if (isset($_REQUEST['threadid'])) $threadid = $_REQUEST['threadid']; if (isset($_REQUEST['pollid'])) $pollid = $_REQUEST['pollid']; if (isset($_REQUEST['attachmentid'])) $attachmentid = $_REQUEST['attachmentid']; if (isset($_REQUEST['boardid'])) $boardid = $_REQUEST['boardid']; /** verify ids **/ if (isset($postid)) { $postid = intval($postid); $post = $db->query_first("SELECT * FROM bb".$n."_posts WHERE postid = '$postid'"); if (!$post['postid']) unset($postid); else $threadid = $post['threadid']; } /** start session **/ require('./acp/lib/session.php'); /** verify ids **/ if (isset($threadid)) { $threadid = intval($threadid); $select = ''; $join = ''; if ($filename == "thread.php") { $select .= ", v.id AS isvoted"; $join .= " LEFT JOIN bb".$n."_votes v ON (v.id=t.threadid AND v.votemode=2 AND ".(($wbbuserdata['userid']) ? ("v.userid='".$wbbuserdata['userid']."'") : ("v.ipaddress='".addslashes($REMOTE_ADDR)."'")).")"; if ($wbbuserdata['userid']) { $select .= ", tv.lastvisit, s.emailnotify, s.countemails"; $join .= " LEFT JOIN bb".$n."_threadvisit tv ON (tv.threadid=t.threadid AND tv.userid='".$wbbuserdata['userid']."') LEFT JOIN bb".$n."_subscribethreads s ON (s.userid='".$wbbuserdata['userid']."' AND s.threadid=t.threadid)"; } } $thread = $db->query_first("SELECT t.*".$select." FROM bb".$n."_threads t".$join." WHERE t.threadid = '$threadid'"); $select = ''; $join = ''; if (!$thread['threadid']) unset($threadid); else $boardid = $thread['boardid']; } if (isset($pollid)) { $pollid = intval($pollid); $poll = $db->query_first("SELECT bb".$n."_threads.*, bb".$n."_polls.* FROM bb".$n."_polls LEFT JOIN bb".$n."_threads USING (threadid) WHERE bb".$n."_polls.pollid = '$pollid'"); if (!$poll['pollid']) unset($pollid); else { if ($poll['boardid']) { $boardid = $poll['boardid']; unset($threadid); unset($thread); } } } if (isset($attachmentid)) { $attachmentid = intval($attachmentid); $attachment = $db->query_first("SELECT at.*, ". "t.boardid, p.threadid, p.visible, p.userid, ". "pm.privatemessageid, pm.inoutbox, pm.senderid, pmr.recipientid, pmr.deletepm ". "FROM bb".$n."_attachments at ". "LEFT JOIN bb".$n."_posts p ON (p.postid=at.postid) ". "LEFT JOIN bb".$n."_threads t ON (t.threadid=p.threadid) ". "LEFT JOIN bb".$n."_privatemessage pm ON (pm.privatemessageid=at.privatemessageid) ". "LEFT JOIN bb".$n."_privatemessagereceipts pmr ON (pmr.privatemessageid=pm.privatemessageid AND pmr.recipientid='$wbbuserdata[userid]') ". "WHERE at.attachmentid = '$attachmentid'"); if (!$attachment['attachmentid']) { unset($attachmentid); unset($attachment); } if ($attachment['postid'] && !$attachment['privatemessageid']) { // post attachment if ($attachment['boardid']) { $boardid = $attachment['boardid']; $threadid = $attachment['threadid']; unset($thread); } } elseif (!$attachment['postid'] && $attachment['privatemessageid']) { // private message attachment unset($boardid); unset($threadid); unset($thread); } } if (isset($boardid)) { $boardid = intval($boardid); $board = getBoardAccessData($boardid); if (!$board['boardid']) unset($boardid); } /** update session **/ $db->unbuffered_query("UPDATE bb".$n."_sessions SET lastactivity = '".$session['lastactivity']."', request_uri = '".addslashes($REQUEST_URI)."', boardid='" . ((isset($boardid)) ? ($boardid) : (0)) . "', threadid='".((isset($threadid)) ? ($threadid) : (0))."'" . ((isset($styleid)) ? (", styleid = '$styleid'") : ("")).((isset($langid)) ? (", langid='$langid'") : ("")).((isset($authentificationcode)) ? (", authentificationcode='".addslashes($authentificationcode)."'") : (""))." WHERE sessionhash = '$sid'", 1); // JGS-XA JGS-Chat Start if($filename=="jgs_chat.php"){$jgs_xa_chat_code_in_global_eingebaut="1";require("./jgs_chat_global.php");} // JGS-XA JGS-Chat Ende /** get style **/ // JGS-Portal Start if($filename=="jgs_portal.php"){require("./jgs_portal_global.php");} // JGS-Portal Ende $style = array(); if (isset($board) && ($board['enforcestyle'] == 1 || ($board['styleid'] != 0 && $wbbuserdata['styleid'] == 0))) { $style = $db->query_first("SELECT s.styleid, s.templatepackid, s.designpackid, tp.templatestructure FROM bb".$n."_styles s LEFT JOIN bb".$n."_templatepacks tp ON(tp.templatepackid=s.templatepackid) WHERE s.styleid = '".$board['styleid']."'"); $wbbuserdata['designpackid'] = $style['designpackid']; $wbbuserdata['templatepackid'] = $style['templatepackid']; $wbbuserdata['styleid'] = $style['styleid']; $wbbuserdata['templatestructure'] = $style['templatestructure']; } $result = $db->unbuffered_query("SELECT * FROM bb".$n."_designelements WHERE designpackid = '$wbbuserdata[designpackid]'"); while ($row = $db->fetch_array($result)) $style[$row['element']] = $row['value']; /** template class **/ require('./acp/lib/class_headers.php'); require('./acp/lib/class_tpl_file.php'); $tpl = &new tpl(intval($wbbuserdata['templatepackid'])); /** language packs **/ require('./acp/lib/class_language.php'); $lang = &new language($wbbuserdata['languagepackid']); $lang->load('GLOBAL,OWN'); // global, own langcat define('ENCODING', $lang->get('LANG_GLOBAL_ENCODING')); $supportedCharsets = array('UCS-4', 'UCS-4BE', 'UCS-4LE', 'UCS-2', 'UCS-2BE', 'UCS-2LE', 'UTF-32', 'UTF-32BE', 'UTF-32LE', 'UCS-2LE', 'UTF-16', 'UTF-16BE', 'UTF-16LE', 'UTF-8', 'UTF-7', 'ASCII', 'EUC-JP', 'SJIS', 'EUCJP-WIN', 'SJIS-WIN', 'ISO-2022-JP', 'JIS', 'ISO-8859-1', 'ISO-8859-2', 'ISO-8859-3', 'ISO-8859-4', 'ISO-8859-5', 'ISO-8859-6', 'ISO-8859-7', 'ISO-8859-8', 'ISO-8859-9', 'ISO-8859-10', 'ISO-8859-13', 'ISO-8859-14', 'ISO-8859-15', 'BYTE2BE', 'BYTE2LE', 'BYTE4BE', 'BYTE4LE', 'BASE64', '7bit', '8bit', 'UTF7-IMAP'); if (in_array(wbb_strtoupper(ENCODING), $supportedCharsets) && extension_loaded('mbstring') && version_compare($phpversion, '4.3.0') >= 0) { define('USE_MBSTRING', true); } else { define('USE_MBSTRING', false); } /** imagefolder prefix **/ $style['imagefolder'] = $lang->get("LANG_GLOBAL_IMAGEFOLDER_PREFIX").$style['imagefolder']; /** OWN langvars **/ $o_master_board_name = $master_board_name; $master_board_name = getlangvar($master_board_name, $lang); /** templates & style **/ $phpinclude = wbb_trim($tpl->get("phpinclude")); if ($phpinclude != '') { $phpinclude = str_replace('\\"', '"', $phpinclude); $phpinclude = str_replace('\\\\', '\\', $phpinclude); eval($phpinclude); } /* ############## Laufschrifttext by Beziehungs-Kiste.net ##############*/ if ($laufschrift_onoff == 1) { $result = $db->query ("SELECT laufschriftid, username, laufschrifttext FROM bb".$n."_laufschrift ORDER BY laufschriftid DESC LIMIT 0,$laufschrift_limit"); while ($row = $db->fetch_array($result)) { $count++; eval ("\$lauftext .= \"".$tpl->get("laufschrift_show")."\";"); } } /* ############## Laufschrifttext by Beziehungs-Kiste.net ##############*/ /** default templates **/ $header_pms = ''; $header_acp = ''; eval("\$css = \"".$tpl->get("css")."\";"); // JGS-Portal Start require("./jgs_portal_global_sponsor.php"); // JGS-Portal Ende eval("\$headinclude = \"".$tpl->get("headinclude")."\";"); $lang->items['LANG_GLOBAL_COPYRIGHT'] = $lang->get("LANG_GLOBAL_COPYRIGHT", array('$boardversion' => $boardversion)); eval("\$ct_footeranzeigen = \"".$tpl->get("ct_footeranzeigen")."\";"); eval("\$footer = \"".$tpl->get("footer")."\";"); if ($wbbuserdata['userid']) $usercbar_username = htmlconverter($wbbuserdata['username']); else $usercbar_username = ''; eval("\$usercbar = \"".$tpl->get("usercbar")."\";"); eval("\$header = \"".$tpl->get("header")."\";"); // JGS-Portal Start require("./jgs_portal_log.php"); require("./jgs_portal_boardinclude.php"); // JGS-Portal Ende if ($wbbuserdata['can_view_board'] == 0 && $filename != "login.php" && $filename != "logout.php" && $filename != "register.php" && $filename != "forgotpw.php") access_error(); verify_ip($REMOTE_ADDR); if ($offline == 1 && $wbbuserdata['can_view_off_board'] == 0 && $filename != "login.php" && $filename != "logout.php" && $filename != "forgotpw.php" && $filename != "register.php") { $offlinemessage = nl2br(htmlconverter($offlinemessage)); eval("\$tpl->output(\"".$tpl->get("offline")."\");"); exit(); } if ($wbbuserdata['pmpopup'] == 2) { if ($filename != "pms.php" && (!isset($_POST) || count($_POST) == 0) && $filename != "attachment.php" && $filename != "attachmentedit.php" && $filename != "logout.php" && $filename != "markread.php" && $filename != "misc.php" && $filename != "modcp.php" && $filename != "polledit.php" && $filename != "register.php" && $filename != "search.php" && ($filename != "thread.php" || !isset($_REQUEST['goto'])) && $filename != "threadrating.php" && $filename != "usercp.php") { eval("\$headinclude .= \"".$tpl->get("pmpopup_open")."\";"); } } if (isset($boardid)) { /** OWN langvars **/ $board['o_title'] = $board['title']; $board['title'] = getlangvar($board['title'], $lang); if (!checkpermissions("can_enter_board")) access_error(); if ($board['password'] && ($filename != "usercp.php" || $_REQUEST['action'] != 'removesubscription')) { $lang->load('BOARD'); if (isset($_COOKIE[$cookieprefix.'boardpasswords'])) $boardpasswords = decode_cookie($_COOKIE[$cookieprefix.'boardpasswords']); else $boardpasswords = array(); if (isset($_POST['boardpassword'])) { if ($_POST['boardpassword'] == $board['password']) { $boardpasswords[$boardid] = md5($board['password']); if ($wbbuserdata['usecookies'] == 1) encode_cookie('boardpasswords', time() + 3600 * 24 * 365, false); else encode_cookie('boardpasswords', 0, false); redirect($lang->items['LANG_BOARD_PASSWORD_REDIRECT'], "board.php?boardid=$boardid".$SID_ARG_2ND); } else { eval("error(\"".$lang->get("LANG_BOARD_ERROR_FALSEPASSWORD")."\");"); } } elseif (!isset($boardpasswords[$boardid]) || $boardpasswords[$boardid] != md5($board['password'])) { eval("\$tpl->output(\"".$tpl->get("board_password")."\");"); exit(); } } } if (isset($threadid) && isset($thread['visible']) && $thread['visible'] == 0 && !checkmodpermissions()) { error($lang->get("LANG_GLOBAL_ERROR_FALSELINK", array('$adminmail' => $adminmail))); } if (isset($postid) && isset($post['visible']) && $post['visible'] == 0 && !checkmodpermissions()) { error($lang->get("LANG_GLOBAL_ERROR_FALSELINK", array('$adminmail' => $adminmail))); } if (isset($_POST['change_editor']) && $_POST['change_editor']) { $wbbuserdata['usewysiwyg'] = $_POST['change_editor']; } else if (isset($_POST['usewysiwyg']) && $_POST['usewysiwyg']) { $wbbuserdata['usewysiwyg'] = $_POST['usewysiwyg']; } $guthaben = $db->query_first("SELECT * FROM bb".$n."_guthaben WHERE gutid='1'"); if($guthaben['lottoonoff']) require("./acp/lib/lottoziehung.php"); /* ######## Guthaben Werben ########## */ $coo_var = $cookieprefix . 'werberid'; if (isset($_REQUEST['werberid'])){ $werberid = intval($_REQUEST['werberid']); bbcookie("werberid","$werberid",time()+3600*24*45); } elseif (isset($HTTP_COOKIE_VARS["$coo_var"])) $werberid = $HTTP_COOKIE_VARS["$coo_var"]; else $werberid = ''; if ($werberid != ''){ $werberchk = $db->query_first("SELECT username FROM bb".$n."_users where userid='".intval($werberid)."'"); if ($werberchk['username'] == '') unset($werberid); else $werbername = $werberchk['username']; } /* ################################### */ ?> |
|
hoffe es bringt was
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
Zitat: Original von KleenMicha
Da habe ich spontan noch eine Idee um herauszufinden ob es ein forum-, oder serverseitiges Problem ist.
Erstelle einmal folgende Datei: test.php mit dem Inhalt:
php: |
1:
2:
3:
|
<?php
echo 'das ist ein test';
?> |
|
und zweitens eine Datei namens: forumtest.php mit folgendem Inhalt:
php: |
1:
2:
3:
4:
5:
6:
|
<?php
$filename="forumtest.php";
require("./global.php");
$lang->load('GLOBAL');
echo 'das ist ein test';
?> |
|
Was passiert jeweils? |
|
|
nix weiter nur das ist ein test steht da mehr nicht
zum heulen
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
Zitat: Original von Viktor
Hallo,
oh das ist schon Komisch bei Dir.
Alles was ich aufrufe kommt der Fehler außer das ACP und die Datei "misc.php".
Es sieht so aus als ob du umgeleitet werden sollst und das nicht klappt.
Geändert hast du nichts und die Rechte der Dateien stimmen auch noch.
Gruß
Viktor
|
|
|
richtig Viktor
ne hatte nix gemacht aufeinmal ging die seite nicht mehr
versthe das abzulut nicht
ne hatte bei frank noch nicht nachgefragt
hab da ne email addy drinne die es nicht mehr gibt plödes ding
ich teste mal michas idee
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
Zitat: Original von KleenMicha
Im Zweifelsfall würde ich dies mal entfernen und dann sehen was passiert.
Kann sehr gut möglich sein, dass es damit Probleme gibt. |
|
|
hab ich schon gemacht
hat auch nix geholfen
ich bin voll verzweifelt :-(
weil komisch ist ja das ich ins acp komme aber nicht ins forum
und neu machen hab ich echt schmerzen mit
|
|
Thema: Hilfe Seite nicht mehr aufzufinden |
Tommi
Antworten: |
26 |
Hits: |
4.886 |
|
|
|
Zitat: Original von KleenMicha
Sieht nach einer Art Umleitungsfehler aus. Hast du irgendeine Art Umleitung mittels: .htaccess verwendet? |
|
|
DirectoryIndex portal.php index.php
mehr nicht
|
|
Thema: GT-CHAT instalieren wie macht man es richtig |
|
hallöchen
also dasding ist das ich das ja im wbb haben möchte :-)
und die server strucktur ist html/wbb
alsodenke ich doch das ich es im wbb ordner stecken sollte
oder ist das etwa egal ????
hab nun einige jahre nix mehr gemacht und bin da voll raus
gruß tommi
|
|
Thema: profil gästebuch ala meinVZ |
|
|
Zitat: Original von SMHAMK1985
Kannst du es uns auch mitteilen? Bin auch auf der suche auf sowas!!
Danke
|
|
|
gefunden bei mywbb
sind 2 haCKS profil gästebuch und gästebuch ins profil
|
|
Thema: memberslist useravatar |
|
|
Zitat: Original von PapsW.
Hallo,
nehme den Code:
code: |
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
|
$result = $db->unbuffered_query("SELECT u.*
".(($read_profilefields == 1) ? (", uf.*") : (""))."
".(($read_avatars == 0) ? (", a.avatarid, a.avatarextension, a.width, a.height") : (""))."
".(($read_ranks == 1) ? (", r.ranktitle, r.rankimages") : (""))."
".$select."
FROM bb".$n."_users u
".(($read_profilefields == 1) ? (" LEFT JOIN bb".$n."_userfields uf USING (userid)") : (""))."
".(($read_avatars == 0) ? (" LEFT JOIN bb".$n."_avatars a ON (u.avatarid=a.avatarid)") : (""))."
".(($read_ranks == 1) ? (" LEFT JOIN bb".$n."_ranks r ON (u.rankid=r.rankid)") : (""))."
WHERE u.userid IN (0$userids)
ORDER BY $sortby $order");
|
|
Gruß
PapsW. |
|
|
jo zeigt er die seite wieder an aber das avatar nicht
gruß tommi
|
|
Thema: memberslist useravatar |
|
OO
nöö
|
Zitat:
SQL-DATABASE ERROR
Database error in WoltLab Burning Board (2.3.6): Invalid SQL: SELECT u.* , a.avatarid, a.avatarextension, a.width, a.height, a.vgavatarfrei FROM bb1_users u LEFT JOIN bb1_avatars a ON (u.avatarid=a.avatarid) WHERE u.userid IN (0,1,4,2,3) ORDER BY userposts DESC
mysql error: Unknown column 'a.vgavatarfrei' in 'field list'
mysql error number: 1054
mysql version: 5.0.32-Debian_7etch12-log
php version: 5.2.0-8+etch16
Date: 05.04.2010 @ 22:52
Script: /memberslist.php
|
|
|
php: |
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
584:
585:
586:
587:
588:
589:
590:
591:
592:
593:
594:
595:
596:
597:
598:
599:
600:
601:
602:
603:
604:
605:
606:
607:
608:
609:
610:
611:
612:
613:
614:
615:
616:
617:
618:
619:
620:
621:
622:
623:
624:
625:
626:
627:
628:
629:
630:
631:
632:
633:
634:
635:
636:
637:
638:
639:
640:
641:
642:
643:
644:
645:
646:
647:
648:
649:
650:
651:
652:
653:
654:
655:
656:
657:
658:
659:
660:
661:
662:
663:
664:
665:
666:
667:
668:
669:
670:
671:
672:
673:
674:
675:
676:
|
<?php
// ************************************************************************************//
// * WoltLab Burning Board 2
// ************************************************************************************//
// * Copyright (c) 2001-2004 WoltLab GmbH
// * Web http://www.woltlab.de/
// * License http://www.woltlab.de/products/burning_board/license_en.php
// * http://www.woltlab.de/products/burning_board/license.php
// ************************************************************************************//
// * WoltLab Burning Board 2 is NOT free software.
// * You may not redistribute this package or any of it's files.
// ************************************************************************************//
// * $Date: 2005-02-07 16:18:22 +0100 (Mon, 07 Feb 2005) $
// * $Author: Burntime $
// * $Rev: 1549 $
// ************************************************************************************//
$filename = 'memberslist.php';
require('./global.php');
if ($wbbuserdata['can_view_mblist'] == 0) access_error();
require('./acp/lib/class_parse.php');
$lang->load('MEMBERS');
/**
* cache custom profile fields
*
* @return void
*/
function cacheProfilefields() {
global $profilefieldcache, $db, $n;
$profilefieldcache = array();
$result = $db->unbuffered_query("SELECT * FROM bb".$n."_profilefields");
while ($row = $db->fetch_array($result)) $profilefieldcache[$row['profilefieldid']] = $row;
}
/**
* parse members bit
*
* @param string userid
*
* @return string membersbit
*/
function makeMembersbit($userids, $link) {
global $a_show, $select, $letter, $sortby, $order, $colspan, $profilefieldcache, $fieldheader, $db, $n, $style, $tpl, $lang, $wbbuserdata, $showavatar, $allowflashavatar, $session, $SID_ARG_1ST, $SID_ARG_2ND, $SID_ARG_2ND_UN;
$read_profilefields = 0;
$read_avatars = 0;
$read_ranks = 0;
$read_useronlinemarking = 0;
$letter_enc = urlencode($letter);
reset($a_show);
while (list($key, $val) = each($a_show)) {
$fieldname = $lang->get('LANG_MEMBERS_MBL_'.wbb_strtoupper($val));
if ($val == 'avatar') $read_avatars = 1;
elseif ($val == 'ranktitle' || $val == 'rankimage') $read_ranks = 1;
elseif (strstr($val, 'profilefield')) {
$read_profilefields = 1;
if ($profilefieldcache == 0) cacheProfilefields();
if ($profilefieldcache[wbb_substr($val, 12)]['hidden'] == 1 && $wbbuserdata['a_can_view_hidden'] != 1) continue;
$fieldname = getlangvar($profilefieldcache[wbb_substr($val, 12)]['title'], $lang);
}
$searchname = getSearchFieldname($val);
$colspan++;
eval("\$fieldheader .= \" ".$tpl->get("memberslist_fieldheader")."\";");
}
$result = $db->unbuffered_query("SELECT u.*
".(($read_profilefields == 1) ? (", uf.*") : (""))."
".(($read_avatars == 0) ? (", a.avatarid, a.avatarextension, a.width, a.height") : (""))."
".(($read_ranks == 1) ? (", r.ranktitle, r.rankimages") : (""))."
".$select."
FROM bb".$n."_users u
".(($read_profilefields == 1) ? (" LEFT JOIN bb".$n."_userfields uf USING (userid)") : (""))."
".(($read_avatars == 0) ? (" LEFT JOIN bb".$n."_avatars a ON (u.avatarid=a.avatarid)") : (""))."
".(($read_ranks == 1) ? (" LEFT JOIN bb".$n."_ranks r ON (u.rankid=r.rankid)") : (""))."
WHERE u.userid IN (0$userids)
ORDER BY $sortby $order");
$count = 0;
$membersbit = '';
while ($members = $db->fetch_array($result)) {
reset($a_show);
$fields = "";
$count = 1;
while (list($key, $val) = each($a_show)) {
$tdclass = getone($count, 'tablea', 'tableb');
$username = $members['username'];
if (strstr($val, 'profilefield')) {
$profilefield = $profilefieldcache[wbb_substr($val, 12)];
if (($profilefield['hidden'] == 1 && $wbbuserdata['a_can_view_hidden'] != 1)) continue;
$fieldcontent = $members["field".$profilefield['profilefieldid']];
if ($fieldcontent && $fieldcontent != "0000-00-00") {
if ($profilefield['fieldtype'] == "multiselect") $fieldcontent = str_replace("\n", "; ", $fieldcontent);
elseif ($profilefield['fieldtype'] == "date") {
$row_datearray = explode("-", $fieldcontent);
if ($row_datearray[0] == "0000") $fieldcontent = $row_datearray[2].".".$row_datearray[1].".";
else $fieldcontent = $row_datearray[2].".".$row_datearray[1].".".$row_datearray[0];
}
$fieldcontent = htmlconverter(textwrap($fieldcontent, 30));
eval("\$fields .= \"".$tpl->get("memberslist_userfields")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
}
else {
switch ($val) {
case 'username':
$useravatar = '';
if ($members['avatarid'] && $showavatar == 1 && $wbbuserdata['showavatars'] == 1 {
$avatarname = "images/avatars/avatar-".$members['avatarid'].".".$members['avatarextension'];
$avatarwidth = $members['width'];
$avatarheight = $members['height'];
if ($members['avatarextension'] == "swf" && $allowflashavatar == 1) {
eval("\$useravatar = \"".$tpl->get("avatar_flash")."\";");
}
else if ($members['avatarextension'] != "swf") {
eval("\$useravatar = \"".$tpl->get("avatar_image")."\";");
}
}
$members['username'] = htmlconverter($members['username']);
eval("\$fields .= \" ".$tpl->get("memberslist_username")."\";");
break;
case 'email':
$LANG_MEMBERS_SENDEMAIL = $lang->get("LANG_MEMBERS_SENDEMAIL", array('$username' => $username));
if ($members['showemail'] == 1) {
$members['email'] = getASCIICodeString($members['email']);
eval("\$fields .= \" ".$tpl->get("memberslist_email")."\";");
}
else if ($members['usercanemail'] == 1) eval("\$fields .= \" ".$tpl->get("memberslist_formmail")."\";");
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'homepage':
if ($members['homepage']) {
$members['homepage'] = htmlconverter($members['homepage']);
$LANG_MEMBERS_HOMEPAGE = $lang->get("LANG_MEMBERS_HOMEPAGE", array('$username' => $username));
eval("\$fields .= \" ".$tpl->get("memberslist_homepage")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'pm':
if ($members['receivepm'] && $wbbuserdata['can_use_pms'] == 1) {
$LANG_MEMBERS_PM = $lang->get("LANG_MEMBERS_PM", array('$username' => $username));
eval("\$fields .= \" ".$tpl->get("memberslist_pm")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'search':
$LANG_MEMBERS_SEARCH = $lang->get("LANG_MEMBERS_SEARCH", array('$username' => $username));
eval("\$fields .= \" ".$tpl->get("memberslist_search")."\";");
break;
case 'userposts':
if ($members['userposts'] >= 1000) $userposts = number_format($members['userposts'], 0, "", $lang->get("LANG_GLOBAL_THOUSANDS_SEP"));
else $userposts = $members['userposts'];
eval("\$fields .= \" ".$tpl->get("memberslist_userposts")."\";");
break;
case 'postsperday':
$regdays = (time() - $members['regdate']) / 86400;
if ($regdays < 1) $postperday = $members['userposts'];
else $postperday = $members['userposts'] / $regdays;
$postperday = number_format($postperday, 2, $lang->get("LANG_GLOBAL_DEC_POINT"), $lang->get("LANG_GLOBAL_THOUSANDS_SEP"));
$LANG_MEMBERS_PROFILE_POSTSPERDAY = $lang->get("LANG_MEMBERS_PROFILE_POSTSPERDAY", array('$postperday' => $postperday));
eval("\$fields .= \" ".$tpl->get("memberslist_postsperday")."\";");
break;
case 'userlevel':
$userlevel = userlevel($members['userposts'], $members['regdate']);
eval("\$fields .= \" ".$tpl->get("memberslist_userlevel")."\";");
break;
case 'avatar':
if ($members['avatarid'] && $showavatar == 1 && $wbbuserdata['showavatars'] == 1) {
$avatarname = "images/avatars/avatar-".$members['avatarid'].".".$members['avatarextension'];
$avatarwidth = $members['width'];
$avatarheight = $members['height'];
if ($members['avatarextension'] == "swf" && $allowflashavatar == 1) {
eval("\$useravatar = \"".$tpl->get("avatar_flash")."\";");
eval("\$fields .= \" ".$tpl->get("memberslist_avatar")."\";");
}
else if ($members['avatarextension'] != "swf") {
eval("\$useravatar = \"".$tpl->get("avatar_image")."\";");
eval("\$fields .= \" ".$tpl->get("memberslist_avatar")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'ranktitle':
if ($members['title']) $members['ranktitle'] = htmlconverter($members['title']);
else $members['ranktitle'] = getlangvar($members['ranktitle'], $lang);
eval("\$fields .= \" ".$tpl->get("memberslist_ranktitle")."\";");
break;
case 'rankimage':
$rankimages = formatRI($members['rankimages']);
eval("\$fields .= \" ".$tpl->get("memberslist_rankimage")."\";");
break;
case 'usertext':
if ($members['usertext']) {
$members['usertext'] = htmlconverter(textwrap($members['usertext'], 40));
eval("\$fields .= \" ".$tpl->get("memberslist_usertext")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'icq':
if ($members['icq']) {
$LANG_MEMBERS_ICQ = $lang->get("LANG_MEMBERS_ICQ", array('$username' => $username));
eval("\$fields .= \" ".$tpl->get("memberslist_icq")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'aim':
if ($members['aim']) {
$members['aim'] = htmlconverter($members['aim']);
$aim = $members['aim'];
$LANG_MEMBERS_AIM = $lang->get("LANG_MEMBERS_AIM", array('$username' => $username, '$aim' => $aim));
eval("\$fields .= \" ".$tpl->get("memberslist_aim")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'yim':
if ($members['yim']) {
$members['yim'] = htmlconverter($members['yim']);
$yim = $members['yim'];
$LANG_MEMBERS_YIM = $lang->get("LANG_MEMBERS_YIM", array('$username' => $username, '$yim' => $yim));
eval("\$fields .= \" ".$tpl->get("memberslist_yim")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'msn':
if ($members['msn']) {
$members['msn'] = htmlconverter($members['msn']);
$LANG_MEMBERS_MSN = $lang->get("LANG_MEMBERS_MSN", array('$username' => $username));
eval("\$fields .= \" ".$tpl->get("memberslist_msn")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'lastactivity':
if ($members['invisible'] == 0 || $wbbuserdata['a_can_use_acp'] == 1) {
$la_date = formatdate($wbbuserdata['dateformat'], $members['lastactivity'], 1);
$la_time = formatdate($wbbuserdata['timeformat'], $members['lastactivity']);
eval("\$fields .= \" ".$tpl->get("memberslist_lastactivity")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'birthday':
if ($members['birthday'] && $members['birthday'] != "0000-00-00") {
$birthday_array = explode("-", $members['birthday']);
if ($birthday_array[0] == "0000") $birthday = $birthday_array[2].".".$birthday_array[1].".";
else $birthday = $birthday_array[2].".".$birthday_array[1].".".$birthday_array[0];
eval("\$fields .= \" ".$tpl->get("memberslist_birthday")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'gender':
if ($members['gender']) {
if ($members['gender'] == 1) $gender = $lang->items['LANG_MEMBERS_PROFILE_MALE'];
else $gender = $lang->items['LANG_MEMBERS_PROFILE_FEMALE'];
eval("\$fields .= \" ".$tpl->get("memberslist_gender")."\";");
}
else eval("\$fields .= \" ".$tpl->get("memberslist_none")."\";");
break;
case 'buddy':
$LANG_MEMBERS_BUDDY = $lang->get("LANG_MEMBERS_BUDDY", array('$username' => $username));
eval("\$fields .= \" ".$tpl->get("memberslist_buddy")."\";");
break;
case 'regdate':
$regdate = formatdate($wbbuserdata['dateformat'], $members['regdate']);
eval("\$fields .= \" ".$tpl->get("memberslist_regdate")."\";");
break;
}
}
$count++;
}
eval("\$membersbit .= \" ".$tpl->get("memberslist_membersbit")."\";");
}
return $membersbit;
}
if (isset($_REQUEST['action'])) $action = $_REQUEST['action'];
else $action = '';
$profilefieldcache = 0;
$a_show = explode("|", $memberslistoptions_show);
if (isset($_REQUEST['sortby'])) $_REQUEST['sortby'] = $_REQUEST['sortby'];
else $_REQUEST['sortby'] = '';
$sortby = '';
while (list($key, $val) = each($a_show)) {
$fieldname = getSearchFieldname($val);
if ($fieldname != '' && $fieldname == $_REQUEST['sortby']) {
$sortby = $_REQUEST['sortby'];
break;
}
}
if ($sortby == '') $sortby = $default_memberslist_sortfield;
if (isset($_REQUEST['order'])) $order = $_REQUEST['order'];
else $order = '';
switch ($order) {
case 'ASC': break;
case 'DESC': break;
default: $order = $default_memberslist_sortorder;
}
$sel_order[$order] = " selected=\"selected\" ";
// members search
if ($action == "search") {
$colspan = 2;
$membersbit = '';
if (isset($_REQUEST['send'])) {
$where = '';
if (isset($_REQUEST['limit'])) {
$limit = intval($_REQUEST['limit']);
if ($limit <= 0) $limit = $membersperpage;
if ($limit > 500) $limit = 500;
}
else $limit = $membersperpage;
$link = "memberslist.php?action=search&send=send&limit=$limit&".$SID_ARG_2ND."&";
if (isset($_REQUEST['username']) && $_REQUEST['username']) {
add2where("username LIKE '%".addslashes($_REQUEST['username'])."%'");
linkGenerator("username", $_REQUEST['username']);
}
if (isset($_REQUEST['email']) && $_REQUEST['email']) {
add2where("showemail=1 AND email LIKE '%".addslashes($_REQUEST['email'])."%'");
linkGenerator("email", $_REQUEST['email']);
}
if (isset($_REQUEST['title']) && $_REQUEST['title']) {
add2where("title LIKE '%".addslashes($_REQUEST['title'])."%'");
linkGenerator("title", $_REQUEST['title']);
}
if (isset($_REQUEST['usertext']) && $_REQUEST['usertext']) {
add2where("usertext LIKE '%".addslashes($_REQUEST['usertext'])."%'");
linkGenerator("usertext", $_REQUEST['usertext']);
}
if (isset($_REQUEST['signature']) && $_REQUEST['signature']) {
linkGenerator("signature", $_REQUEST['signature']);
add2where("signature LIKE '%".addslashes($_REQUEST['signature'])."%'");
}
if (isset($_REQUEST['homepage']) && $_REQUEST['homepage']) {
add2where("homepage LIKE '%".addslashes($_REQUEST['homepage'])."%'");
linkGenerator("homepage", $_REQUEST['homepage']);
}
if (isset($_REQUEST['icq']) && $_REQUEST['icq']) {
add2where("icq LIKE '%".intval($_REQUEST['icq'])."%'");
linkGenerator("icq", $_REQUEST['icq']);
}
if (isset($_REQUEST['aim']) && $_REQUEST['aim']) {
add2where("aim LIKE '%".addslashes($_REQUEST['aim'])."%'");
linkGenerator("aim", $_REQUEST['aim']);
}
if (isset($_REQUEST['yim']) && $_REQUEST['yim']) {
add2where("yim LIKE '%".addslashes($_REQUEST['yim'])."%'");
linkGenerator("yim", $_REQUEST['yim']);
}
if (isset($_REQUEST['msn']) && $_REQUEST['msn']) {
add2where("msn LIKE '%".addslashes($_REQUEST['msn'])."%'");
linkGenerator("msn", $_REQUEST['msn']);
}
if (isset($_REQUEST['userposts_morethen']) && $_REQUEST['userposts_morethen'] != '') {
add2where("userposts > '".intval($_REQUEST['userposts_morethen'])."'");
linkGenerator("userposts_morethen", $_REQUEST['userposts_morethen']);
}
if (isset($_REQUEST['userposts_lessthen']) && $_REQUEST['userposts_lessthen'] != '') {
add2where("userposts < '".intval($_REQUEST['userposts_lessthen'])."'");
linkGenerator("userposts_lessthen", $_REQUEST['userposts_lessthen']);
}
if (isset($_REQUEST['gender']) && $_REQUEST['gender'] != 0) {
add2where("gender = '".intval($_REQUEST['gender'])."'");
linkGenerator("gender", $_REQUEST['gender']);
}
$userfields = 0;
$dayfield = $_REQUEST['dayfield'];
$monthfield = $_REQUEST['monthfield'];
$yearfield = $_REQUEST['yearfield'];
$result_userfields = $db->unbuffered_query("SELECT profilefieldid,fieldtype FROM bb".$n."_profilefields WHERE hidden = 0 ORDER BY profilefieldid ASC");
while ($row = $db->fetch_array($result_userfields)) {
switch ($row['fieldtype']) {
case 'text':
if (isset($_REQUEST['profilefield'][$row['profilefieldid']]) && $_REQUEST['profilefield'][$row['profilefieldid']]) {
$userfields = 1;
add2where("field".$row['profilefieldid']." LIKE '%".addslashes($_REQUEST['profilefield'][$row['profilefieldid']])."%'");
linkGenerator("profilefield[".$row['profilefieldid']."]", $_REQUEST['profilefield'][$row['profilefieldid']]);
}
break;
case 'checkbox':
if (isset($_REQUEST['profilefield'][$row['profilefieldid']]) && $_REQUEST['profilefield'][$row['profilefieldid']]) {
$userfields = 1;
add2where("field".$row['profilefieldid']."='".addslashes($_REQUEST['profilefield'][$row['profilefieldid']])."'");
linkGenerator("profilefield[".$row['profilefieldid']."]", $_REQUEST['profilefield'][$row['profilefieldid']]);
}
break;
case 'select':
if (isset($_REQUEST['profilefield'][$row['profilefieldid']]) && $_REQUEST['profilefield'][$row['profilefieldid']]) {
$userfields = 1;
add2where("field".$row['profilefieldid']."='".addslashes($_REQUEST['profilefield'][$row['profilefieldid']])."'");
linkGenerator("profilefield[".$row['profilefieldid']."]", $_REQUEST['profilefield'][$row['profilefieldid']]);
}
break;
case 'multiselect':
if (isset($_REQUEST['profilefield'][$row['profilefieldid']]) && is_array($_REQUEST['profilefield'][$row['profilefieldid']]) && count($_REQUEST['profilefield'][$row['profilefieldid']])) {
$userfields = 1;
$subwhere = '';
foreach ($_REQUEST['profilefield'][$row['profilefieldid']] as $val) {
if ($subwhere != '') $subwhere .= ' OR ';
$subwhere .= "field".$row['profilefieldid']." like '%".addslashes($val)."%'";
linkGenerator("profilefield[".$row['profilefieldid']."][]", $val);
}
if ($subwhere != '') add2where("(".$subwhere.")");
}
break;
case 'date':
if ($dayfield[$row['profilefieldid']] && $monthfield[$row['profilefieldid']]) {
$userfields = 1;
$datefield = ((wbb_strlen($yearfield[$row['profilefieldid']]) == 4) ? ($yearfield[$row['profilefieldid']]) : (((wbb_strlen($yearfield[$row['profilefieldid']]) == 2) ? ("19".$yearfield[$row['profilefieldid']]) : ("0000"))))."-".(($monthfield[$row['profilefieldid']] < 10) ? ("0".$monthfield[$row['profilefieldid']]) : ($monthfield[$row['profilefieldid']]))."-".(($dayfield[$row['profilefieldid']] < 10) ? ("0".$dayfield[$row['profilefieldid']]) : ($dayfield[$row['profilefieldid']]));
add2where("field".$row['profilefieldid']."='".$datefield."'");
linkGenerator("yearfield[".$row['profilefieldid']."]", $yearfield[$row['profilefieldid']]);
linkGenerator("monthfield[".$row['profilefieldid']."]", $monthfield[$row['profilefieldid']]);
linkGenerator("dayfield[".$row['profilefieldid']."]", $dayfield[$row['profilefieldid']]);
}
break;
}
}
$userids = '';
$result = $db->query("SELECT u.userid FROM bb".$n."_users u".(($userfields == 1) ? (" LEFT JOIN bb".$n."_userfields USING (userid)") : ("")).(($where) ? (" WHERE $where") : ("")));
$memberscount = $db->num_rows($result);
if ($memberscount == 0) error($lang->items['LANG_GLOBAL_ERROR_SEARCHNORESULT']);
while ($row = $db->fetch_array($result)) $userids .= ",".$row['userid'];
if (isset($_REQUEST['page'])) {
$page = intval($_REQUEST['page']);
if ($page < 1) $page = 1;
}
else $page = 1;
$linkpages = $link . "order=$order&sortby=$sortby";
$pages = ceil($memberscount / $limit);
if ($page > $pages) $page = 1;
if ($pages > 1) $pagelink = makePageLink($linkpages, $page, $pages, $showpagelinks - 1);
$select = '';
$join = '';
if (strstr($sortby, "field")) $join .= " LEFT JOIN bb".$n."_userfields uf USING(userid)";
if ($sortby == "postsperday") $select .= ", IF((UNIX_TIMESTAMP()-regdate)/86400>1,userposts/((UNIX_TIMESTAMP()-regdate)/86400),userposts) AS postsperday";
if ($sortby == "userlevel") $select .= ", userposts*((UNIX_TIMESTAMP()-regdate)/86400) AS userlevel";
if ($sortby == "ranktitle") {
$select .= ", IF(title<>'',title,r.ranktitle) AS ranktitle";
$join .= " LEFT JOIN bb".$n."_ranks r ON(u.rankid=r.rankid)";
}
$result = $db->unbuffered_query("SELECT u.userid".$select." FROM bb".$n."_users u".$join." WHERE u.userid IN (0$userids) ORDER BY $sortby $order", 0, $limit, $limit * ($page - 1));
$userids = '';
while ($row = $db->fetch_array($result)) $userids .= ",".$row['userid'];
$fieldheader = '';
$colspan = 0;
$membersbit = makeMembersbit($userids, $link);
if ($membersbit == '') error($lang->items['LANG_GLOBAL_ERROR_SEARCHNORESULT']);
}
else {
$morebit = '';
$count = 0;
$result = $db->unbuffered_query("SELECT profilefieldid, title, fieldtype, fieldoptions FROM bb".$n."_profilefields WHERE hidden = 0 ORDER BY fieldorder ASC");
while ($row = $db->fetch_array($result)) {
$field_options = '';
switch ($row['fieldtype']) {
case 'select':
$row_options = explode("\n", wbb_trim($row['fieldoptions']));
$field_options = "<option value=\"\"></option>\n";
foreach ($row_options as $option) $field_options .= makeoption(wbb_trim($option), wbb_trim($option), "");
break;
case 'multiselect':
$row_options = explode("\n", wbb_trim($row['fieldoptions']));
$field_options = '';
foreach ($row_options as $option) $field_options .= makeoption(wbb_trim($option), wbb_trim($option), "");
break;
case 'date':
$dayfield_value = "<option value=\"\"></option>\n";
$monthfield_value = "<option value=\"\"></option>\n";
for ($i = 1; $i <= 31; $i++) $dayfield_value .= makeoption($i, $i, "");
for ($i = 1; $i <= 12; $i++) $monthfield_value .= makeoption($i, getmonth($i), "");
$yearfield_value = '';
break;
}
$searchfield = getlangvar($row['title'], $lang);
if ($row['fieldtype'] == "multiselect" || $row['fieldtype'] == "text") {
$LANG_SEARCHFIELD_PROFILEFIELD = $lang->get("LANG_MEMBERS_MBS_SEARCHFIELD_CONTAINS", array('$searchfield' => $searchfield));
}
else {
$LANG_SEARCHFIELD_PROFILEFIELD = $lang->get("LANG_MEMBERS_MBS_SEARCHFIELD_IS", array('$searchfield' => $searchfield));
}
$rowclass = getone($count++, "tablea", "tableb");
eval("\$morebit .= \"".$tpl->get("memberssearch_morebit_".$row['fieldtype'])."\";");
}
$fields_contains = array("USERNAME", "EMAIL", "TITLE", "USERTEXT", "SIGNATURE", "HOMEPAGE", "ICQ", "AIM", "YIM", "MSN");
for ($i = 0; $i < count($fields_contains); $i++) {
$searchfield = $lang->items['LANG_MEMBERS_MBL_'.$fields_contains[$i]];
$name = "LANG_SEARCHFIELD_$fields_contains[$i]";
$$name = $lang->get("LANG_MEMBERS_MBS_SEARCHFIELD_CONTAINS", array('$searchfield' => $searchfield));
}
$searchfield = $lang->items['LANG_MEMBERS_MBL_GENDER'];
$LANG_SEARCHFIELD_GENDER = $lang->get("LANG_MEMBERS_MBS_SEARCHFIELD_IS", array('$searchfield' => $searchfield));
}
reset($a_show);
$sortby_options = '';
while (list($key, $val) = each($a_show)) {
$fieldname = $lang->get("LANG_MEMBERS_MBL_".wbb_strtoupper($val));
if (strstr($val, "profilefield")) {
if ($profilefieldcache == 0) cacheProfilefields();
if ($profilefieldcache[wbb_substr($val, 12)]['hidden'] == 1 && $wbbuserdata['a_can_view_hidden'] != 1) continue;
$fieldname = getlangvar($profilefieldcache[wbb_substr($val, 12)]['title'], $lang);
}
$searchname = getSearchFieldname($val);
if ($searchname != '') $sortby_options .= makeoption($searchname, $fieldname, $sortby);
}
eval("\$tpl->output(\"".$tpl->get("memberssearch")."\");");
}
else {
$letteroptions = '';
$alpha = "#ABCDEFGHIJKLMNOPQRSTUVWXYZ";
if (!isset($_GET['letter']) || ($_GET['letter'] && !strstr($alpha, $_GET['letter']))) $letter = '';
else $letter = urldecode($_GET['letter']);
for ($i = 0; $i < wbb_strlen($alpha); $i++) $letteroptions .= makeoption($alpha[$i], $alpha[$i], $letter, 1);
eval("\$options_letter = \"".$tpl->get("memberslist_letter")."\";");
if ($letter != '') {
if ($letter == "#") $result = $db->query("SELECT userid FROM bb".$n."_users WHERE SUBSTRING(username,1,1) NOT IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')");
else $result = $db->query("SELECT userid FROM bb".$n."_users WHERE SUBSTRING(username,1,1)='$letter'");
$memberscount = $db->num_rows($result);
$userids = '';
while ($row = $db->fetch_array($result)) $userids .= ",".$row['userid'];
}
else list($memberscount) = $db->query_first("SELECT COUNT(*) FROM bb".$n."_users");
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
if ($page < 1) $page = 1;
}
else $page = 1;
$link = "memberslist.php?letter=".urlencode($letter).$SID_ARG_2ND."&";
$pages = ceil($memberscount / $membersperpage);
if ($page > $pages) $page = 1;
if ($pages > 1) $pagelink = makepagelink($link . "order=$order&sortby=$sortby", $page, $pages, $showpagelinks - 1);
$select = "";
$join = "";
if (strstr($sortby, "field")) $join .= " LEFT JOIN bb".$n."_userfields uf USING(userid)";
if ($sortby == "postsperday") $select .= ", IF((UNIX_TIMESTAMP()-regdate)/86400>1,userposts/((UNIX_TIMESTAMP()-regdate)/86400),userposts) AS postsperday";
if ($sortby == "userlevel") $select .= ", userposts*((UNIX_TIMESTAMP()-regdate)/86400) AS userlevel";
if ($sortby == "ranktitle") {
$select .= ", IF(title<>'',title,r.ranktitle) AS ranktitle";
$join .= " LEFT JOIN bb".$n."_ranks r ON(u.rankid=r.rankid)";
}
$result = $db->unbuffered_query("SELECT u.userid".$select." FROM bb".$n."_users u".$join." ".(($letter != '') ? ("WHERE u.userid IN (0$userids) ") : (""))."ORDER BY $sortby $order", 0, $membersperpage, $membersperpage * ($page - 1));
$userids = '';
while ($row = $db->fetch_array($result)) $userids .= ",".$row['userid'];
$fieldheader = '';
$colspan = 0;
$membersbit = makeMembersbit($userids, $link);
eval("\$options_order = \"".$tpl->get("memberslist_order")."\";");
reset($a_show);
$sortby_options = '';
while (list($key, $val) = each($a_show)) {
$fieldname = $lang->get("LANG_MEMBERS_MBL_".wbb_strtoupper($val));
if (strstr($val, "profilefield")) {
if ($profilefieldcache == 0) cacheProfilefields();
if ($profilefieldcache[wbb_substr($val, 12)]['hidden'] == 1 && $wbbuserdata['a_can_view_hidden'] != 1) continue;
$fieldname = getlangvar($profilefieldcache[wbb_substr($val, 12)]['title'], $lang);
}
$searchname = getSearchFieldname($val);
if ($searchname != '') $sortby_options .= makeoption($searchname, $fieldname, $sortby);
}
eval("\$options_sortby = \"".$tpl->get("memberslist_sortby")."\";");
$lang->items['LANG_MEMBERS_MBL_SORTOPTIONS'] = $lang->get("LANG_MEMBERS_MBL_SORTOPTIONS", array('$options_letter' => $options_letter, '$options_sortby' => $options_sortby, '$options_order' => $options_order));
eval("\$tpl->output(\"".$tpl->get("memberslist")."\");");
}
?>
|
|
code: |
1:
2:
3:
|
<td class="$tdclass" align="left" nowrap="nowrap"><span class="normalfont">$useravatar<br /><b><a href="profile.php?userid=$members[userid]{$SID_ARG_2ND}">$members[username]</a></b></span></td>
|
|
was da nun falsch ??
|
|
Thema: memberslist useravatar |
|
|
Zitat: Original von Viktor
Hallo,
jo editiere die Datei "memberslist.php".
Suche:
code: |
1:
2:
3:
4:
|
switch ($val) {
case 'username':
|
|
Füge darunter ein:
code: |
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
|
if ($members['avatarid'] && $showavatar == 1 && $wbbuserdata['showavatars'] == 1 && $members['vgavatarfrei'] == 1) {
$avatarname = "images/avatars/avatar-".$members['avatarid'].".".$members['avatarextension'];
$avatarwidth = $members['width'];
$avatarheight = $members['height'];
if ($members['avatarextension'] == "swf" && $allowflashavatar == 1) {
eval("\$useravatar = \"".$tpl->get("avatar_flash")."\";");
}
else if ($members['avatarextension'] != "swf") {
eval("\$useravatar = \"".$tpl->get("avatar_image")."\";");
}
}
|
|
Editiere das Template "memberslist_username".
Suche:
code: |
1:
2:
3:
|
<td class="$tdclass" align="left" nowrap="nowrap"><span class="normalfont">
|
|
Füge direkt dahinter ein:
code: |
1:
2:
3:
|
$useravatar<br />
|
|
Gruß
Viktor
|
|
|
danke viktor aber scheint nicht zu funzen
|
|
Thema: memberslist useravatar |
|
hallo
ich würde gerne in der memberslist über den user nick das user avatar anzeigenlassen
hat wer nen tipp
code: |
1:
2:
3:
4:
|
switch ($val) { case 'username': $members['username'] = htmlconverter($members['username']); eval("\$fields .= \" ".$tpl->get("memberslist_username")."\";"); break;
|
|
denke das ich da was machen muß nur was ??
gruß tommi
|
|
|
|