CINXE.COM
[3.2] Sortieren nach Liste aus den custom profile fields - Seite 2 - phpBB.de
<!DOCTYPE html> <html dir="ltr" lang="de"> <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1" /> <title>[3.2] Sortieren nach Liste aus den custom profile fields - Seite 2 - phpBB.de</title> <link rel="alternate" type="application/atom+xml" title="Feed - phpBB.de" href="/community/feed?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"> <link rel="alternate" type="application/atom+xml" title="Feed - Neuigkeiten" href="/community/feed/news?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"> <link rel="alternate" type="application/atom+xml" title="Feed - Neue Themen" href="/community/feed/topics?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"> <link rel="alternate" type="application/atom+xml" title="Feed - Aktive Themen" href="/community/feed/topics_active?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"> <link rel="alternate" type="application/atom+xml" title="Feed - Forum - Extension Bastelstube" href="/community/feed/forum/140?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"> <link rel="alternate" type="application/atom+xml" title="Feed - Thema - [3.2] Sortieren nach Liste aus den custom profile fields" href="/community/feed/topic/240481?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"> <link rel="canonical" href="https://www.phpbb.de/community/viewtopic.php?t=240481&start=10"> <!-- phpBB style name: phpBBdev1 Based on style: prosilver (this is the default phpBB3 style) Original author: Tom Beddard ( http://www.subBlue.com/ ) Modified by: phpBB.de --> <link href="./assets/css/font-awesome.min.css?assets_version=280" rel="stylesheet"> <link href="./styles/prosilver/theme/stylesheet.css?assets_version=280" rel="stylesheet" /> <link href="./styles/phpBBdev1/theme/stylesheet.css?assets_version=280" rel="stylesheet"> <link href="./styles/phpBBdev1/theme/de/stylesheet.css?assets_version=280" rel="stylesheet"> <link href="./styles/phpBBdev1/theme/images/favicon/mask-icon.svg?assets_version=280" rel="mask-icon" color="#3E647B" /> <!--[if lte IE 9]> <link href="./styles/prosilver/theme/tweaks.css?assets_version=280" rel="stylesheet"> <![endif]--> <link href="./ext/phpbbde/pastebin/styles/prosilver/theme/pastebin.css?assets_version=280" rel="stylesheet" media="screen"> <link href="./ext/rmcgirr83/contactadmin/styles/prosilver/theme/imageset.css?assets_version=280" rel="stylesheet" media="screen"> </head> <body id="phpbb" class="nojs notouch section-viewtopic ltr "> <div id="wrap" class="wrap"> <a id="top" class="top-anchor" accesskey="t"></a> <div id="page-header"> <div class="headerbar" role="banner"> <div class="inner"> <div id="site-description" class="site-description"> <a id="logo" class="logo" href="./../" title="Startseite"> <span class="site_logo"></span> </a> <h1>phpBB.de</h1> <p>phpBB.de - Die deutsche phpBB-Community</p> <p class="skiplink"><a href="#start_here">Zum Inhalt</a></p> </div> <div id="search-box" class="search-box search-header" role="search"> <form action="./search.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" method="get" id="search"> <fieldset> <input name="keywords" id="keywords" type="search" maxlength="128" title="Suche nach Wörtern" class="inputbox search tiny" size="20" value="" placeholder="Suche…" /> <button class="button button-search" type="submit" title="Suche"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </button> <a href="./search.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="button button-search-end" title="Erweiterte Suche"> <i class="icon fa-cog fa-fw" aria-hidden="true"></i><span class="sr-only">Erweiterte Suche</span> </a> <input type="hidden" name="sid" value="cfdc3d5429fb1bb8209b76ab67d29bcf" /> </fieldset> </form> </div> <div id="phpbbde_navigation" class="phpbbde_navigation"> <div class="menu-button"> <a href="#" id="navi-toggle" title="Menü anzeigen">Menü</a> </div> <ul id="mainnavi" class="mainnavi"> <li class="mainnavi-title">phpBB.de - Navigation</li> <li class="navi-button but-about"> <a href="./../phpbbde/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"><span class="subnavi-toggle"></span>Über uns</a> <ul class="subnavi"> <li><a href="./../phpbbde/chronik/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">phpBB.de-Chronik <span>Die Geschichte von phpBB.de in Wort und Bild</span></a></li> <li><a href="./../phpbbde/team/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Das Team <span>Erfahre mehr über das Team hinter phpBB.de</span></a></li> <li><a href="./../phpbbde/fragen/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Fragen an das Team <span>Ihr habt gefragt, wir haben geantwortet</span></a></li> <li><a href="/community/contactadmin?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Kontaktformular <span>Formular zur Kontaktaufnahme mit dem phpBB.de-Team</span></a></li> <li><a href="./../phpbbde/impressum/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Impressum <span>Das phpBB.de-Impressum</span></a></li> </ul> </li> <li class="navi-button but-phpbb"> <a href="./../infos/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"><span class="subnavi-toggle"></span>phpBB</a> <ul class="subnavi"> <li><a href="./../infos/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Infos über phpBB <span>Erfahre mehr über phpBB</span></a></li> <li><a href="./../infos/tour/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Die phpBB-Tour <span>Was ist phpBB und wo bekomme ich es?</span></a></li> <li><a href="./../infos/features/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Feature-Vergleich <span>Lerne alle Features kennen, die dir phpBB bietet</span></a></li> <li><a href="./../infos/anpassen/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">phpBB anpassen <span>Nutze Erweiterungen und Styles, um phpBB deinen Wünschen anzupassen</span></a></li> <li><a href="./../infos/entwickler/3.3/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Informationen für Entwickler <span>phpBB-Projektarchiv, nützliche Links, ...</span></a></li> <li><a href="./../xref/3.3/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Cross-Referenz 3.3 <span>Cross-Referenz des phpBB-Quellcodes</span></a></li> </ul> </li> <li class="navi-button but-downloads"> <a href="./../downloads/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"><span class="subnavi-toggle"></span>Downloads</a> <ul class="subnavi"> <li><a href="./../downloads/pakete/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">phpBB-Pakete <span>Die aktuellen dt. Komplett- und Updatepakete von phpBB</span></a></li> <li><a href="./../downloads/sprachpakete/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Sprachpakete <span>Die aktuellen deutschen Sprachdateien für phpBB</span></a></li> <li><a href="./../downloads/entwicklung/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Entwicklung <span>Entwickler-Downloads</span></a></li> </ul> </li> <li class="navi-button but-docu"> <a href="./../support/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"><span class="subnavi-toggle"> </span>Support</a> <ul class="subnavi"> <li><a href="./../support/doku/quickstart/3.3/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Schnelleinstieg <span>Erklärt dir die Einrichtung deines phpBB Boards</span></a></li> <li><a href="https://www.phpbb.de/help/faq">Häufig gestellte Fragen <span>Häufige Fragen im Zusammenhang mit der Nutzung von phpBB</span></a></li> <li><a href="./../kb/index?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Knowledge Base <span>Unsere Wissensdatenbank mit vielen und hilfreichen Artikeln</span></a></li> <li><a href="./../support/videos/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Videos <span>Unsere Supportvideos erklären Funktionen von phpBB</span></a></li> <li><a href="./../support/doku/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Dokumentation <span>Hier findest Du Dokumentationen zu phpBB</span></a></li> <li><a href="./../support/doku/perror/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">MySQL-Fehlercodes <span>Mysql Fehlercodes dokumentiert</span></a></li> <li><a href="./../support/doku/htpasswd/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">.htpasswd-Generator <span>Einfach zu bedienener Generator für .htpasswd Dateien</span></a></li> </ul> </li> <li class="navi-button but-community"> <a href="./../community/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"><span class="subnavi-toggle"> </span>Community</a> <ul class="subnavi"> <li><a href="./../community/viewforum.php?f=145&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Supportforen <span>Hilfe bei der Installation und Benutzung</span></a></li> <li><a href="./../community/viewforum.php?f=104&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Communityforen<span>Allgemeine Diskussionen und phpBB-Usergroups</span></a></li> <li><a href="./../community/viewforum.php?f=148&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Extension-Foren<span>Auf der Suche nach einer Extension? Fragen zu einer Extension?</span></a></li> <li><a href="./../community/viewforum.php?f=152&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Styleforen<span>Du suchst einen neuen Style oder hast Probleme mit einem Style?</span></a></li> <li><a href="./../kb/knigge?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Der kleine phpBB.de-Knigge <span>Eine kleine Liste von wichtigen Regeln auf phpBB.de</span></a></li> <li><a href="./../phpbbde/chat/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf">Discord / Chat <span>Besuche den Discord-Server oder den Chat auf Freenode</span></a></li> </ul> </li> </ul> </div> </div> </div> <div class="navbar" role="navigation"> <div class="inner"> <ul id="nav-main" class="nav-main linklist" role="menubar"> <li id="quick-links" class="quick-links dropdown-container responsive-menu" data-skip-responsive="true"> <a href="#" class="dropdown-trigger"> <i class="icon fa-bars fa-fw" aria-hidden="true"></i><span>Schnellzugriff</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents" role="menu"> <li class="separator"></li> <li> <a href="./search.php?search_id=unanswered&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="menuitem"> <i class="icon fa-file-o fa-fw icon-gray" aria-hidden="true"></i><span>Unbeantwortete Themen</span> </a> </li> <li> <a href="./search.php?search_id=active_topics&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="menuitem"> <i class="icon fa-file-o fa-fw icon-blue" aria-hidden="true"></i><span>Aktive Themen</span> </a> </li> <li class="separator"></li> <li> <a href="./search.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="menuitem"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span>Suche</span> </a> </li> <li class="separator"></li> <li> <a href="./../phpbbde/team.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="menuitem"> <i class="icon fa-shield fa-fw" aria-hidden="true"></i><span>Das Team</span> </a> </li> <li class="separator"></li> </ul> </div> </li> <li data-skip-responsive="true"> <a href="./../help/faq?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" rel="help" title="Häufig gestellte Fragen" role="menuitem"> <i class="icon fa-question-circle fa-fw" aria-hidden="true"></i><span>FAQ</span> </a> </li> <li data-last-responsive="true"><a href="/community/pastebin/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Pastebin"><i class="icon fa-clipboard fa-fw" aria-hidden="true"></i><span>Pastebin</span></a></li> <li class="rightside" data-skip-responsive="true"> <a href="./ucp.php?mode=login&redirect=viewtopic.php%3Fstart%3D10%26t%3D240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Anmelden" accesskey="x" role="menuitem"> <i class="icon fa-power-off fa-fw" aria-hidden="true"></i><span>Anmelden</span> </a> </li> <li class="rightside" data-skip-responsive="true"> <a href="./ucp.php?mode=register&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="menuitem"> <i class="icon fa-pencil-square-o fa-fw" aria-hidden="true"></i><span>Registrieren</span> </a> </li> </ul> <ul id="nav-breadcrumbs" class="nav-breadcrumbs linklist navlinks" role="menubar"> <li class="breadcrumbs" itemscope itemtype="https://schema.org/BreadcrumbList"> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope><a itemprop="item" href="./../" data-navbar-reference="home"><i class="icon fa-home fa-fw" aria-hidden="true"></i><span itemprop="name">Startseite</span></a><meta itemprop="position" content="1" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope><a itemprop="item" href="./index.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" accesskey="h" data-navbar-reference="index"><span itemprop="name">Community</span></a><meta itemprop="position" content="2" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope data-forum-id="144"><a itemprop="item" href="./viewforum.php?f=144&sid=cfdc3d5429fb1bb8209b76ab67d29bcf"><span itemprop="name">phpBB 3.3.x</span></a><meta itemprop="position" content="3" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope data-forum-id="148"><a itemprop="item" href="./viewforum.php?f=148&sid=cfdc3d5429fb1bb8209b76ab67d29bcf"><span itemprop="name">Extension-Foren</span></a><meta itemprop="position" content="4" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope data-forum-id="140"><a itemprop="item" href="./viewforum.php?f=140&sid=cfdc3d5429fb1bb8209b76ab67d29bcf"><span itemprop="name">Extension Bastelstube</span></a><meta itemprop="position" content="5" /></span> </li> <li class="rightside responsive-search"> <a href="./search.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Zeigt die erweiterten Suchoptionen an" role="menuitem"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </a> </li> </ul> </div> </div> </div> <a id="start_here" class="anchor"></a> <div id="page-body" class="page-body" role="main"> <h2 class="topic-title"><a href="./viewtopic.php?t=240481&start=10&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">[3.2] Sortieren nach Liste aus den custom profile fields</a></h2> <!-- NOTE: remove the style="display: none" when you want to have the forum description on the topic body --> <div style="display: none !important;">In diesem Forum gibt es Starthilfe zum neuen Extension-System von phpBB 3.1/3.2. Fragen zur Entwicklung von Extensions und zur Konvertierung von phpBB 3.0.x MODs sind ebenfalls willkommen.<br /></div> <div class="action-bar bar-top"> <a href="./posting.php?mode=reply&t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="button" title="Antwort erstellen"> <span>Antworten</span> <i class="icon fa-reply fa-fw" aria-hidden="true"></i> </a> <div class="dropdown-container dropdown-button-control topic-tools"> <span title="Themen-Optionen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-wrench fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li> <a href="./viewtopic.php?t=240481&start=10&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&view=print" title="Druckansicht" accesskey="p"> <i class="icon fa-print fa-fw" aria-hidden="true"></i><span>Druckansicht</span> </a> </li> </ul> </div> </div> <div class="search-box" role="search"> <form method="get" id="topic-search" action="./search.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf"> <fieldset> <input class="inputbox search tiny" type="search" name="keywords" id="search_keywords" size="20" placeholder="Thema durchsuchen…" /> <button class="button button-search" type="submit" title="Suche"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </button> <a href="./search.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="button button-search-end" title="Erweiterte Suche"> <i class="icon fa-cog fa-fw" aria-hidden="true"></i><span class="sr-only">Erweiterte Suche</span> </a> <input type="hidden" name="t" value="240481" /> <input type="hidden" name="sf" value="msgonly" /> <input type="hidden" name="sid" value="cfdc3d5429fb1bb8209b76ab67d29bcf" /> </fieldset> </form> </div> <div class="pagination"> 43 Beiträge <ul> <li class="arrow previous"><a class="button button-icon-only" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" rel="prev" role="button"><i class="icon fa-chevron-left fa-fw" aria-hidden="true"></i><span class="sr-only">Vorherige</span></a></li> <li><a class="button" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="button">1</a></li> <li class="active"><span>2</span></li> <li><a class="button" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&start=20" role="button">3</a></li> <li><a class="button" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&start=30" role="button">4</a></li> <li><a class="button" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&start=40" role="button">5</a></li> <li class="arrow next"><a class="button button-icon-only" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&start=20" rel="next" role="button"><i class="icon fa-chevron-right fa-fw" aria-hidden="true"></i><span class="sr-only">Nächste</span></a></li> </ul> </div> </div> <div id="p1376512" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1376512"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=88733&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">520</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 24.11.2007 12:43</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von cpg"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von cpg</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="http://www.crossdresser-forum.de/phpBB3/portal" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1376512"> <h3 class="first"> <a href="./viewtopic.php?p=1376512&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1376512">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1376512&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1376512&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1376512" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a></strong> » </span><time datetime="2017-12-02T17:38:19+00:00">02.12.2017 18:38</time> </p> <div class="content">Moin,<br> <br> versprochen ist versprochen <img class="smilies" src="./images/smilies/icon_e_smile.gif" width="15" height="17" alt=":)" title="Lächeln"> <br> <br> Ich poste erst einmal die veränderte memberlist.php<br> <br> Vorher werde ich noch einmal kurz beschreiben, warum ich das gemacht habe. Es geht mir darum, ein custom_profile_field sortierbar zu machen, weil Mitglieder des Forums u.U. ein Interesse daran haben, sich persönlich zu treffen - und da scheint eine Sortierung nach Plz/Wohnort sinnvoll zu sein.<br> Wenn das mit den code-Änderungen "zu wild" ist, dann gebt bitte Bescheid. Ansonsten werde ich auch noch die zugehörige Änderungen an der html-Datei posten und beschreiben, was ich noch gemacht habe.<br> <br> Ach ja: ohne Gewähr und Gewehr <img class="smilies" src="./images/smilies/icon_e_smile.gif" width="15" height="17" alt=":)" title="Lächeln"> In meinem Forum funktioniert es.<br> <br> Gruß und schönen 1. Advent<br> cpg<br> <br> phpBB3/memberlist.php<br> <br> suche <br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>case 'livesearch': $username_chars = $request->variable('username', '', true); $sql = 'SELECT username, user_id, user_colour FROM ' . USERS_TABLE . ' WHERE ' . $db->sql_in_set('user_type', $user_types) . ' AND username_clean ' . $db->sql_like_expression(utf8_clean_string($username_chars) . $db->get_any_char()); $result = $db->sql_query_limit($sql, 10); $user_list = array(); while ($row = $db->sql_fetchrow($result)) { $user_list[] = array( 'user_id' => (int) $row['user_id'], 'result' => $row['username'], 'username_full' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'display' => get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']), ); } $db->sql_freeresult($result); $json_response = new \phpbb\json_response(); $json_response->send(array( 'keyword' => $username_chars, 'results' => $user_list, )); break; </code></pre></div> <br> <br> ersetze mit<br> <br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> case 'livesearch': $username_chars = $request->variable('username', '', true); $sql = 'SELECT username, user_id, user_colour, location_mysearch FROM ' . USERS_TABLE . ' u LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id) WHERE ' . $db->sql_in_set('user_type', $user_types) . ' AND username_clean ' . $db->sql_like_expression(utf8_clean_string($username_chars) . $db->get_any_char()); $result = $db->sql_query_limit($sql, 10); $user_list = array(); while ($row = $db->sql_fetchrow($result)) { $user_list[] = array( 'user_id' => (int) $row['user_id'], 'result' => $row['username'], 'location_mysearch' => $row['location_mysearch'], 'username_full' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'display' => get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']), ); } $db->sql_freeresult($result); $json_response = new \phpbb\json_response(); $json_response->send(array( 'keyword' => $username_chars, 'results' => $user_list, )); break;</code></pre></div> suche <br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$user_list = array(); while ($row = $db->sql_fetchrow($result)) { $user_list[] = array( 'user_id' => (int) $row['user_id'], 'result' => $row['username'], 'username_full' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'display' => get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']), ); }</code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> $user_list = array(); while ($row = $db->sql_fetchrow($result)) { $user_list[] = array( 'user_id' => (int) $row['user_id'], 'result' => $row['username'], 'location_mysearch' => $row['location_mysearch'], 'username_full' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'display' => get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']), ); }</code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$sort_key_text = array('a' => $user->lang['SORT_USERNAME'], 'c' => $user->lang['SORT_JOINED'], 'd' => $user->lang['SORT_POST_COUNT']); $sort_key_sql = array('a' => 'u.username_clean', 'c' => 'u.user_regdate', 'd' => 'u.user_posts'); </code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$sort_key_text = array('a' => $user->lang['SORT_USERNAME'], 'c' => $user->lang['SORT_JOINED'], 'd' => $user->lang['SORT_POST_COUNT'], 'n' => $user->lang['SORT_LOCATION_MYSEARCH']); $sort_key_sql = array('a' => 'u.username_clean', 'c' => 'u.user_regdate', 'd' => 'u.user_posts', 'n' => 'u.location_mysearch'); $sort_key_text['n'] = $user->lang['LOCATION_MYSEARCH']; $sort_key_sql['n'] = 'pf_location_mysearch';</code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$search_params = array('username', 'email', 'jabber', 'search_group_id', 'joined_select', 'active_select', 'count_select', 'joined', 'active', 'count', 'ip'); </code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$search_params = array('username', 'location_mysearch', 'email', 'jabber', 'search_group_id', 'joined_select', 'active_select', 'count_select', 'joined', 'active', 'count', 'ip'); </code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$username = $request->variable('username', '', true); $email = strtolower($request->variable('email', ''));</code></pre></div> <br> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$username = $request->variable('username', '', true); $location_mysearch = $request->variable('location_mysearch', '', true . '*'); $email = strtolower($request->variable('email', ''));</code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$sql_where .= ($username) ? ' AND u.username_clean ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($username))) : ''; </code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$sql_where .= ($username) ? ' AND u.username_clean ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($username))) : ''; //next cpg $sql_where .= mb_strtolower($location_mysearch) ? ' AND LOWER(pf_location_mysearch) ' . $db->sql_like_expression(str_replace('*', $db->any_char, mb_strtolower($location_mysearch,'utf-8'))) . ' ' : ''; </code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$sql_where .= ($search_group_id) ? " AND u.user_id = ug.user_id AND ug.group_id = $search_group_id AND ug.user_pending = 0 " : '';</code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>} $sql_where .= mb_strtolower($location_mysearch) ? ' AND LOWER(pf_location_mysearch) ' . $db->sql_like_expression(str_replace('*', $db->any_char, mb_strtolower($location_mysearch,'utf-8'))) . ' ' : ''; $sql_where .= ($search_group_id) ? " AND u.user_id = ug.user_id AND ug.group_id = $search_group_id AND ug.user_pending = 0 " : ''; </code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'username' => array('username', '', true), 'email' => array('email', ''),</code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'username' => array('username', '', true), 'location_mysearch' => array('location_mysearch', '', true. '*'), 'email' => array('email', ''),</code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'USERNAME' => $username, 'EMAIL' => $email,</code></pre></div> <br> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'USERNAME' => $username, 'LOCATION_MYSEARCH' => $location_mysearch, 'EMAIL' => $email,</code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'S_INACTIVE' => $row['user_type'] == USER_INACTIVE, 'U_VIEW_PROFILE' => get_username_string('profile', $user_id, $row['username']), </code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'S_INACTIVE' => $row['user_type'] == USER_INACTIVE, 'S_LOCATION_MYSEARCH' => (isset($cp_row['row']) && sizeof($cp_row['row'])) ? true : false, 'U_VIEW_PROFILE' => get_username_string('profile', $user_id, $row['username']),</code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'U_SORT_USERNAME' => $sort_url . '&sk=a&sd=' . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'), </code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'U_SORT_USERNAME' => $sort_url . '&sk=a&sd=' . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'), 'U_SORT_LOCATION_MYSEARCH' => $sort_url . '&sk=n&sd=' . (($sort_key == 'n' && $sort_dir == 'a') ? 'd' : 'a'), </code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'U_LIST_CHAR' => $sort_url . '&sk=a&sd=' . (($sort_key == 'l' && $sort_dir == 'd') ? 'a' : 'd'), </code></pre></div> <br> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'U_LIST_CHAR' => $sort_url . '&sk=a&sd=' . (($sort_key == 'l' && $sort_dir == 'd') ? 'a' : 'd'), 'LOCATION_MYSEARCH' => ($data['location_mysearch']) ? $data['location_mysearch'] : '', </code></pre></div></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1376513" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1376513"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=141641&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="avatar"><img class="avatar" src="./download/file.php?avatar=141641_1271110280.jpg" width="50" height="46" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=141641&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" style="color: #7BA76D;" class="username-coloured">BNa</a> </dt> <dd class="profile-rank">Valued Contributor</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=141641&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">3169</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 12.04.2010 23:51</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von BNa"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von BNa</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="http://4seven.bplaced.net/forum/6test/index.php" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1376513"> <h3 > <a href="./viewtopic.php?p=1376513&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1376513">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1376513&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1376513&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1376513" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=141641&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" style="color: #7BA76D;" class="username-coloured">BNa</a></strong> » </span><time datetime="2017-12-02T18:18:33+00:00">02.12.2017 19:18</time> </p> <div class="content">thx 4 sharing <img class="smilies" src="./images/smilies/icon_e_biggrin.gif" width="15" height="17" alt=":grin:" title="Überglücklich"> <img class="smilies" src="./images/smilies/icon_e_geek.gif" width="17" height="17" alt=":geek:" title="Computerfreak"> <img class="smilies" src="./images/smilies/icon_e_cookie.gif" width="24" height="29" alt=":cookie:" title="Da hastn Keks"></div> <div id="sig1376513" class="signature"><span style="font-size: 85%; line-height: normal"><a href="http://4seven.bplaced.net/forum/6test/index.php" class="postlink">Area51@4seven</a> | <a href="http://4seven.bplaced.net/forum/7test/index.php" class="postlink">Area51@4seven / Reloaded</a> | Kein Support via PN<br> <a href="https://www.youtube.com/watch?v=Y1_VsyLAGuk" class="postlink">Club goin up, on a Tuesday...</a></span></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1376515" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1376515"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=88733&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">520</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 24.11.2007 12:43</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von cpg"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von cpg</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="http://www.crossdresser-forum.de/phpBB3/portal" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1376515"> <h3 > <a href="./viewtopic.php?p=1376515&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1376515">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1376515&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1376515&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1376515" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a></strong> » </span><time datetime="2017-12-02T18:53:38+00:00">02.12.2017 19:53</time> </p> <div class="content">Die Änderungen der memberlist_body.html (style prosilver)<br> <br> memberlist_body.html<br> <br> suche <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> <!-- IF U_SORT_ACTIVE --><th class="active"><a href="{U_SORT_ACTIVE}#memberlist">{L_LAST_ACTIVE}</a></th><!-- ENDIF --></code></pre></div> <br> füge danach ein:<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> <!-- IF U_SORT_LOCATION_MYSEARCH --><th><a href="{U_SORT_LOCATION_MYSEARCH}#memberlist">.{L_LOCATION_MYSEARCH}</a></th><!-- ENDIF --></code></pre></div> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code><!-- IF S_VIEWONLINE --><td>{memberrow.LAST_ACTIVE}&nbsp;</td><!-- ENDIF --></code></pre></div> füge danach ein: <br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code><td><!-- IF memberrow.PROFILE_LOCATION_MYSEARCH_VALUE --><div>{memberrow.PROFILE_LOCATION_MYSEARCH_VALUE}</div><!-- ELSE -->&nbsp;<!-- ENDIF --></td></code></pre></div> <span style="color:#0000FF"><strong class="text-strong">Automatisch dem Beitrag hinzugefügt nach 7 Minuten 18 Sekunden</strong>. Bitte Regel für <a href="https://www.phpbb.de/kb/knigge#bumping" class="postlink">„Topic-Bumping“</a> beachten. Danke.</span><br> <br> memberlist_search.html<br> <br> suche<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code><li class="search-result-tpl"><span class="search-result"></span></li> </ul> </div> </div> <!-- ENDIF --> </dd> </dl> <!-- IF S_EMAIL_SEARCH_ALLOWED --></code></pre></div> ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code><li class="search-result-tpl"><span class="search-result"></span></li> </ul> </div> </div> <!-- ENDIF --> </dd> </dl> <dl> <dt><label for="location_mysearch">{L_LOCATION_MYSEARCH}:</label></dt> <dd><input type="text" name="location_mysearch" id="location_mysearch" value="{LOCATION_MYSEARCH}" class="inputbox" /></dd> </dl> <!-- IF S_EMAIL_SEARCH_ALLOWED --></code></pre></div> Schließlich habe ich in der language/de/common.php an passender Stelle eingefügt:<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'LOCATION_MYSEARCH' => 'Membersuche/Plz',</code></pre></div> <span style="text-decoration:underline">Weitere Hinweise:</span><br> <br> Das von mir verwemdete custom_field hat einen Voreintrag in der Art z.Zt. ----- und dem Hinweis: "bei Eintrag bitte überschreiben".<br> Das hat den Vorteil, dass die User, die hier nichts eintragen wollen, in der "Suche nach Wohnort" ganz nach hinten wandern.<br> Ansonsten hätte man in einem großen Forum zuerst (je nach Sortier-Einstellung) lauter UserInnen mit leerem Eintrag.<br> <br> Weiterhin habe ich für die UserInnen, die schon angemeldet sind und bisher nichts eingetragen haben, in der Datenbank das z.Zt -----<br> nachgetragen:<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Update phpbb_profile_fields_data SET pf_location_mysearch = 'z.Zt. ---' WHERE pf_location_mysearch = ""</code></pre></div> Gruß<br> cpg</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1378470" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1378470"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=88733&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">520</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 24.11.2007 12:43</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von cpg"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von cpg</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="http://www.crossdresser-forum.de/phpBB3/portal" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1378470"> <h3 > <a href="./viewtopic.php?p=1378470&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1378470">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1378470&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1378470&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1378470" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a></strong> » </span><time datetime="2018-01-27T17:28:20+00:00">27.01.2018 18:28</time> </p> <div class="content">Moin,<br> <br> ich habe noch einmal nachgebessert; ein Fehler in der memberlist.php verhinderte die korrekte Ausgabe von Postleitzahl-Ausgaben, bei<br> denen ein Platzhalter verwendet wurde (z.B. 24*).<br> <br> <span style="text-decoration:underline">Nur der Vollständigkeit halber</span><br> <br> suche (nach den oben geposteten Änderungen):<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$sql_where .= ($username) ? ' AND u.username_clean ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($username))) : ''; //next cpg $sql_where .= mb_strtolower($location_mysearch) ? ' AND LOWER(pf_location_mysearch) ' . $db->sql_like_expression(str_replace('*', $db->any_char, mb_strtolower($location_mysearch,'utf-8'))) . ' ' : '';</code></pre></div> Ersetze mit<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$sql_where .= ($username) ? ' AND u.username_clean ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($username))) : ''; //next cpg $sql_where .= mb_strtolower($location_mysearch) ? ' AND LOWER(pf_location_mysearch) ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($location_mysearch))) . ' ' : ''; </code></pre></div> Gruß<br> cpg</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1382185" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1382185"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=48536&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">Praggle</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=48536&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">48</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 30.05.2006 10:14</dd> </dl> <div class="postbody"> <div id="post_content1382185"> <h3 > <a href="./viewtopic.php?p=1382185&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1382185">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1382185&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1382185&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1382185" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=48536&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">Praggle</a></strong> » </span><time datetime="2018-04-20T08:19:27+00:00">20.04.2018 10:19</time> </p> <div class="content">Hi cpg,<br> <br> ich habe gerade versucht, das mal unter 3.1.12 auszuprobieren. Statt <code class="inline">$request->variable</code> habe ich <code class="inline">request_var</code> bei deiner fünften Ersetzung verwendet, aber das scheint da trotzdem nicht zu gehen.<br> <blockquote class="uncited"><div>[phpBB Debug] PHP Notice: in file [ROOT]/memberlist.php on line 882: Undefined index: SORT_LOCATION_MYSEARCH<br> [phpBB Debug] PHP Notice: in file [ROOT]/memberlist.php on line 1618: Undefined variable: data<br> [phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5348: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3937)<br> [phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5348: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3937)<br> [phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5348: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3937) </div></blockquote> Bei deiner siebten Ersetzung ist dir vermutlich eine geschweifte Klammer am Anfang rein gerutscht. Auch für 3.2 müsste es wohl heißen:<br> <br> suche:<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$username = request_var('username', '', true); $email = strtolower(request_var('email', ''));</code></pre></div> ersetze mit:<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>$username = request_var('username', '', true); $location_mysearch = request_var('location_mysearch', '', true . '*'); $email = strtolower(request_var('email', ''));</code></pre></div> also ohne <code class="inline">}</code> am Anfang.<br> <br> Ich hab leider zu wenig Programmierkenntnisse, um deinen Ansatz auf 3.1.12 übertragen zu können, wollte aber sagen, dass ich die fehlende Sortierfunktion bei den Custom Profile Fields auch für ein ernsthaft fehlendes Feature halte. Mir geht es ebenfalls so, dass ich es gerne für die Postleitzahlen nutzen würde. Insofern: Danke fürs Posten, auch wenn es mir jetzt nicht direkt weitergeholfen hat.<br> <br> Praggle</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1382293" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1382293"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=88733&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">520</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 24.11.2007 12:43</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von cpg"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von cpg</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="http://www.crossdresser-forum.de/phpBB3/portal" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1382293"> <h3 > <a href="./viewtopic.php?p=1382293&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1382293">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1382293&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1382293&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1382293" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a></strong> » </span><time datetime="2018-04-23T07:41:40+00:00">23.04.2018 09:41</time> </p> <div class="content">Moin,<br> <br> ich schaue noch einmal nach.<br> Wenn mir Änderungen/Fehler auffallen, dann melde ich mich.<br> <br> Gruß<br> CPG</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1406569" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1406569"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=48536&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">Praggle</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=48536&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">48</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 30.05.2006 10:14</dd> </dl> <div class="postbody"> <div id="post_content1406569"> <h3 > <a href="./viewtopic.php?p=1406569&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1406569">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1406569&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1406569&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1406569" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=48536&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">Praggle</a></strong> » </span><time datetime="2020-09-29T21:36:04+00:00">29.09.2020 23:36</time> </p> <div class="content">Moin cpg,<br> <br> es ist zwar schon eine Weile her, seit du an dem Thema dran warst, aber vielleicht kannst du oder irgend jemand anders mir auf die Sprünge helfen.<br> <br> Ich hab das Board inzwischen auf 3.2.10 laufen und hatte mich jetzt noch mal mit frischem Mut an deine Modifizierung rangemacht An einigen Stellen musst ""&" durch "&amp;" ersetzt werden, sonst lief das alles ganz gut. Dennoch gibt es zwei Probleme beim Aufruf der memberlist.php:<br> <br> <code class="inline">[phpBB Debug] PHP Notice: in file [ROOT]/memberlist.php on line 1771: Undefined variable: data</code> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'LOCATION_MYSEARCH' => ($data['location_mysearch']) ? $data['location_mysearch'] : '',</code></pre></div> Das ist Zeile 1771. Warum "$data"? Keine Ahnung, was es damit auf sich hat. Ist vielleicht auch nicht so dramatisch.<br> <br> Wenn ich dann mittels Klick auf die neue CPF-Spaltenüberschrift die Tabelle umsortieren möchte, geht es korrekt auf die folgenden URL: <code class="inline">memberlist.php?mode=&sk=n&sd=a#memberlist</code>. Damit (also nur mit sk=n) erscheint dann aber folgende Fehlermeldung: <blockquote class="uncited"><div>SQL ERROR [ mysqli ]<br> <br> Unknown column 'pf_location_mysearch' in 'order clause' [1054]<br> <br> SQL<br> <br> SELECT u.user_id FROM phpbb_users u WHERE u.user_type IN (0, 3, 1) ORDER BY pf_location_mysearch ASC LIMIT 50<br> <br> BACKTRACE<br> <br> FILE: (not given by php)<br> LINE: (not given by php)<br> CALL: msg_handler()<br> <br> FILE: [ROOT]/phpbb/db/driver/driver.php<br> LINE: 997<br> CALL: trigger_error()<br> <br> FILE: [ROOT]/phpbb/db/driver/mysqli.php<br> LINE: 196<br> CALL: phpbb\db\driver\driver->sql_error()<br> <br> FILE: [ROOT]/phpbb/db/driver/mysql_base.php<br> LINE: 45<br> CALL: phpbb\db\driver\mysqli->sql_query()<br> <br> FILE: [ROOT]/phpbb/db/driver/driver.php<br> LINE: 270<br> CALL: phpbb\db\driver\mysql_base->_sql_query_limit()<br> <br> FILE: [ROOT]/phpbb/db/driver/factory.php<br> LINE: 321<br> CALL: phpbb\db\driver\driver->sql_query_limit()<br> <br> FILE: [ROOT]/memberlist.php<br> LINE: 1557<br> CALL: phpbb\db\driver\factory->sql_query_limit()</div></blockquote> <code class="inline">memberlist.php?mode=&sk=a&sd=a</code> sortiert dagegen fehlerfrei nach dem Usernamen.<br> <br> Zeile 1550 bis 1557 lauten: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> // Get us some users :D $sql = "SELECT u.user_id FROM " . USERS_TABLE . " u $sql_from WHERE " . $db->sql_in_set('u.user_type', $user_types) . " $sql_where ORDER BY $order_by"; $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);</code></pre></div> Da läuft also beim Erzeugen des SQL-Statements <code class="inline">SELECT u.user_id FROM phpbb_users u WHERE u.user_type IN (0, 3, 1) ORDER BY pf_location_mysearch ASC LIMIT 50</code> irgend etwas schief. In der Tabelle <code class="inline">phpbb_users</code> gibt es logischerweise keine Spalte <code class="inline">pf_location_mysearch</code>. Die befindet sich in der Tabelle <code class="inline">phpbb_profile_fields_data</code>. Müsste das nicht irgendwie verbunden werden? Ich hab es schon mit JOIN versucht. Da kommt aber Murks bei raus und außerdem wüsste ich ohnehin nicht, was ich dann im PHP-Code ändern müsste.<br> <br> Was braucht ihr noch für Informationen von mir?<br> Gibt es inzwischen eine andere Lösung, um die Memberlist nach den Custom Profile Fields sortieren zu lassen?<br> <br> Praggle<br> <br> <span style="color:#0000FF"><strong class="text-strong">Automatisch dem Beitrag hinzugefügt nach 19 Minuten 13 Sekunden</strong>. Bitte Regel für <a href="https://www.phpbb.de/kb/knigge#bumping" class="postlink">„Topic-Bumping“</a> beachten. Danke.</span><br> <br> Ok. Ich hab gerade selbst eine Lösung für das SQL-Problem in der memberlist.php gefunden:<br> <br> Suche: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> // Get us some users :D $sql = "SELECT u.user_id FROM " . USERS_TABLE . " u $sql_from WHERE " . $db->sql_in_set('u.user_type', $user_types) . " $sql_where ORDER BY $order_by"; $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start); </code></pre></div> Ersetze: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> // Get us some users :D if(isset($sort_key_sql['n'])) { $sql = "SELECT u.user_id FROM " . USERS_TABLE . " u $sql_from LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id) WHERE " . $db->sql_in_set('u.user_type', $user_types) . " $sql_where ORDER BY $order_by"; } else { $sql = "SELECT u.user_id FROM " . USERS_TABLE . " u $sql_from WHERE " . $db->sql_in_set('u.user_type', $user_types) . " $sql_where ORDER BY $order_by"; } $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start); </code></pre></div> Könnt ihr mir noch was zur undefinierten data-Variable sagen?</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1406570" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1406570"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=88733&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">520</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 24.11.2007 12:43</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von cpg"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von cpg</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="http://www.crossdresser-forum.de/phpBB3/portal" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1406570"> <h3 > <a href="./viewtopic.php?p=1406570&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1406570">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1406570&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1406570&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1406570" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a></strong> » </span><time datetime="2020-09-30T07:24:02+00:00">30.09.2020 09:24</time> </p> <div class="content">Moin,<br> <br> ich muss zugeben: es ist schon lange her, dass ich mich damit beschäftigt habe.<br> Deshalb muss ich mich erst wieder einlesen.<br> <br> Ich habe immer mal wieder kleine Verbesserungen eingepflegt; aber so nützlich wie ich gedacht habe, scheint die Funktion nicht zu sein. <br> Sie läuft bei mir aber noch.<br> Viele UserInnen füllen jeodch das Feld nicht aus - oder falsch.<br> Das sorgt dafür, dass viele Ergebnisse ins Leere führen.<br> <br> Wenn ich Hinweise für Dich entdecke, melde ich mich noch einmal.<br> Gruß<br> cpg</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1406574" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1406574"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=48536&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">Praggle</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=48536&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">48</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 30.05.2006 10:14</dd> </dl> <div class="postbody"> <div id="post_content1406574"> <h3 > <a href="./viewtopic.php?p=1406574&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1406574">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1406574&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1406574&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1406574" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=48536&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">Praggle</a></strong> » </span><time datetime="2020-09-30T10:52:44+00:00">30.09.2020 12:52</time> </p> <div class="content">Moin moin,<br> <br> wenn ich die Zeile <code class="inline">'LOCATION_MYSEARCH' => ($data['location_mysearch']) ? $data['location_mysearch'] : '',</code> auskommentiere, kommt die PHP-Fehlermeldung logischerweise nicht mehr. Es scheint aber trotzdem zu funktionieren. Kannst du das in deiner Installation vielleicht mal kurz ausprobieren.<br> <br> Für mich wäre die Funktion schon wichtig. Wir haben ein Custom Profile Field "PLZ Wohnort" im Profil. In einer alten phpBB2-Version konnte man die Mitgliederliste nach Postleitzahlen sortieren und mit Mitgliedern in der Nähe Kontakt aufnehmen. Das hat immer gut funktioniert und wurde gerne genutzt und wird jetzt schon lange von einigen Teilnehmern vermisst. Dein Lösungsansatz war bisher für mich der einzige Lichtblick, auch wenn es natürlich nicht besonders sinnvoll ist, noch Modifizierungen am Quelltext vorzunehmen.</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1406577" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1406577"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=88733&sr=posts&sid=cfdc3d5429fb1bb8209b76ab67d29bcf">520</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 24.11.2007 12:43</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von cpg"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von cpg</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="http://www.crossdresser-forum.de/phpBB3/portal" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1406577"> <h3 > <a href="./viewtopic.php?p=1406577&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1406577">Re: [3.2] Sortieren nach Liste aus den custom profile fields</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1406577&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1406577&sid=cfdc3d5429fb1bb8209b76ab67d29bcf#p1406577" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=88733&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="username">cpg</a></strong> » </span><time datetime="2020-09-30T13:22:54+00:00">30.09.2020 15:22</time> </p> <div class="content">Original bei mir rauskopiert (ich verwende übrigens 3.3.1; aber es funktionierte schon vorher)<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>'LOCATION_MYSEARCH' => ($data['location_mysearch']) ? $data['location_mysearch'] : '',</code></pre></div> Dann muss der Fehler schon vorher sein.</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div class="action-bar bar-bottom"> <a href="./posting.php?mode=reply&t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="button" title="Antwort erstellen"> <span>Antworten</span> <i class="icon fa-reply fa-fw" aria-hidden="true"></i> </a> <div class="dropdown-container dropdown-button-control topic-tools"> <span title="Themen-Optionen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-wrench fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li> <a href="./viewtopic.php?t=240481&start=10&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&view=print" title="Druckansicht" accesskey="p"> <i class="icon fa-print fa-fw" aria-hidden="true"></i><span>Druckansicht</span> </a> </li> </ul> </div> </div> <form method="post" action="./viewtopic.php?t=240481&start=10&sid=cfdc3d5429fb1bb8209b76ab67d29bcf"> <div class="dropdown-container dropdown-container-left dropdown-button-control sort-tools"> <span title="Anzeige- und Sortierungs-Einstellungen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-sort-amount-asc fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown hidden"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents"> <fieldset class="display-options"> <label>Anzeigen: <select name="st" id="st"><option value="0" selected="selected">Alle Beiträge</option><option value="1">1 Tag</option><option value="7">7 Tage</option><option value="14">2 Wochen</option><option value="30">1 Monat</option><option value="90">3 Monate</option><option value="180">6 Monate</option><option value="365">1 Jahr</option></select></label> <label>Sortiere nach: <select name="sk" id="sk"><option value="a">Autor</option><option value="t" selected="selected">Erstellungsdatum</option><option value="s">Betreff</option></select></label> <label>Richtung: <select name="sd" id="sd"><option value="a" selected="selected">Aufsteigend</option><option value="d">Absteigend</option></select></label> <hr class="dashed" /> <input type="submit" class="button2" name="sort" value="Los" /> </fieldset> </div> </div> </div> </form> <div class="pagination"> 43 Beiträge <ul> <li class="arrow previous"><a class="button button-icon-only" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" rel="prev" role="button"><i class="icon fa-chevron-left fa-fw" aria-hidden="true"></i><span class="sr-only">Vorherige</span></a></li> <li><a class="button" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="button">1</a></li> <li class="active"><span>2</span></li> <li><a class="button" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&start=20" role="button">3</a></li> <li><a class="button" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&start=30" role="button">4</a></li> <li><a class="button" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&start=40" role="button">5</a></li> <li class="arrow next"><a class="button button-icon-only" href="./viewtopic.php?t=240481&sid=cfdc3d5429fb1bb8209b76ab67d29bcf&start=20" rel="next" role="button"><i class="icon fa-chevron-right fa-fw" aria-hidden="true"></i><span class="sr-only">Nächste</span></a></li> </ul> </div> </div> <div class="action-bar actions-jump"> <p class="jumpbox-return"> <a href="./viewforum.php?f=140&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="left-box arrow-left" accesskey="r"> <i class="icon fa-angle-left fa-fw icon-black" aria-hidden="true"></i><span>Zurück zu „Extension Bastelstube“</span> </a> </p> <div class="jumpbox dropdown-container dropdown-container-right dropdown-up dropdown-left dropdown-button-control" id="jumpbox"> <span title="Gehe zu" class="button button-secondary dropdown-trigger dropdown-select"> <span>Gehe zu</span> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li><a href="./viewforum.php?f=96&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-cat-link"> <span> Wichtige Neuigkeiten</span></a></li> <li><a href="./viewforum.php?f=9&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Ankündigungen und Neuigkeiten</span></a></li> <li><a href="./viewforum.php?f=164&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Der kleine phpBB.de-Knigge - unsere Hausordnung</span></a></li> <li><a href="./viewforum.php?f=144&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-cat-link"> <span> phpBB 3.3.x</span></a></li> <li><a href="./viewforum.php?f=145&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Support-Forum</span></a></li> <li><a href="./viewforum.php?f=148&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Extension-Foren</span></a></li> <li><a href="./viewforum.php?f=150&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ Extension Support</span></a></li> <li><a href="./viewforum.php?f=151&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ Extension Suche/Anfrage</span></a></li> <li><a href="./viewforum.php?f=149&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ Extensions in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=140&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ Extension Bastelstube</span></a></li> <li><a href="./viewforum.php?f=163&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ ABD Extensions</span></a></li> <li><a href="./viewforum.php?f=152&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Style-Foren</span></a></li> <li><a href="./viewforum.php?f=153&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ Styles, Templates und Grafiken</span></a></li> <li><a href="./viewforum.php?f=154&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ Styles in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=141&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Übersetzungs-Foren</span></a></li> <li><a href="./viewforum.php?f=161&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.3.x] Übersetzungs-Diskussionen</span></a></li> <li><a href="./viewforum.php?f=157&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.2.x] Übersetzungs-Diskussionen</span></a></li> <li><a href="./viewforum.php?f=156&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ Extension-Übersetzungen</span></a></li> <li><a href="./viewforum.php?f=143&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ Übersetzungs-Diskussionen (abgeschlossen)</span></a></li> <li><a href="./viewforum.php?f=103&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-cat-link"> <span> Entwickler-Ecke</span></a></li> <li><a href="./viewforum.php?f=6&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Coding & Technik</span></a></li> <li><a href="./viewforum.php?f=158&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Area51 auf phpBB.com</span></a></li> <li><a href="./viewforum.php?f=100&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-cat-link"> <span> Frühere Versionen</span></a></li> <li><a href="./viewforum.php?f=155&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Foren für phpBB 3.0</span></a></li> <li><a href="./viewforum.php?f=97&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Support-Foren</span></a></li> <li><a href="./viewforum.php?f=73&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Installation, Update und Konvertierung</span></a></li> <li><a href="./viewforum.php?f=74&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Administration, Benutzung und Betrieb</span></a></li> <li><a href="./viewforum.php?f=98&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Mod-Foren</span></a></li> <li><a href="./viewforum.php?f=85&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Snippets</span></a></li> <li><a href="./viewforum.php?f=87&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Mod Suche/Anfragen</span></a></li> <li><a href="./viewforum.php?f=86&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Mod Support</span></a></li> <li><a href="./viewforum.php?f=88&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Mods in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=93&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Mod Bastelstube</span></a></li> <li><a href="./viewforum.php?f=99&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Style-Foren</span></a></li> <li><a href="./viewforum.php?f=89&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Styles, Templates und Grafiken</span></a></li> <li><a href="./viewforum.php?f=129&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Styles in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=136&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Übersetzungs-Foren</span></a></li> <li><a href="./viewforum.php?f=137&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] phpBB.de-Übersetzungen</span></a></li> <li><a href="./viewforum.php?f=134&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ [3.0.x] Mod-Übersetzungen</span></a></li> <li><a href="./viewforum.php?f=135&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Foren für phpBB 2.0</span></a></li> <li><a href="./viewforum.php?f=12&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Installation und Update</span></a></li> <li><a href="./viewforum.php?f=13&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Administration, Benutzung und Betrieb</span></a></li> <li><a href="./viewforum.php?f=101&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0 Mods</span></a></li> <li><a href="./viewforum.php?f=37&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Mod-Datenbank</span></a></li> <li><a href="./viewforum.php?f=34&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Snippets</span></a></li> <li><a href="./viewforum.php?f=47&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Mod Suche/Anfragen</span></a></li> <li><a href="./viewforum.php?f=49&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Mod Support</span></a></li> <li><a href="./viewforum.php?f=48&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Mods in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=102&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0 Styles</span></a></li> <li><a href="./viewforum.php?f=42&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Styles-Datenbank</span></a></li> <li><a href="./viewforum.php?f=35&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Styles, Templates und Grafiken</span></a></li> <li><a href="./viewforum.php?f=94&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB 2.0: Mod-Bastelstube</span></a></li> <li><a href="./viewforum.php?f=104&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-cat-link"> <span> Community-Foren</span></a></li> <li><a href="./viewforum.php?f=19&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Community Talk</span></a></li> <li><a href="./viewforum.php?f=33&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ phpBB Diskussion</span></a></li> <li><a href="./viewforum.php?f=67&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Show-Off</span></a></li> <li><a href="./viewforum.php?f=105&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ phpBB Regional</span></a></li> <li><a href="./viewforum.php?f=77&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB in Norddeutschland</span></a></li> <li><a href="./viewforum.php?f=78&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB in Ostdeutschland</span></a></li> <li><a href="./viewforum.php?f=79&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB in Süddeutschland</span></a></li> <li><a href="./viewforum.php?f=80&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB in Westdeutschland</span></a></li> <li><a href="./viewforum.php?f=81&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB in Österreich</span></a></li> <li><a href="./viewforum.php?f=82&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB in der Schweiz und Liechtenstein</span></a></li> <li><a href="./viewforum.php?f=83&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳ phpBB im sonstigen Ausland</span></a></li> <li><a href="./viewforum.php?f=72&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Newsletter-Archiv</span></a></li> </ul> </div> </div> </div> </div> <div id="page-footer" class="page-footer" role="contentinfo"> <div class="navbar" role="navigation"> <div class="inner"> <ul id="nav-footer" class="nav-footer linklist" role="menubar"> <li class="breadcrumbs"> <span class="crumb"><a href="./../" data-navbar-reference="home"><i class="icon fa-home fa-fw" aria-hidden="true"></i><span>Startseite</span></a></span> <span class="crumb"><a href="./index.php?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" data-navbar-reference="index"><span>Community</span></a></span> </li> <li class="rightside">Alle Zeiten sind <span title="Europa/Berlin">UTC+01:00</span></li> <li class="rightside"> <a href="/community/user/delete_cookies?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" data-ajax="true" data-refresh="true" role="menuitem"> <i class="icon fa-trash fa-fw" aria-hidden="true"></i><span>Alle Cookies löschen</span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="./../phpbbde/impressum/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="menuitem"> <i class="icon fa-info-circle fa-fw" aria-hidden="true"></i><span>Impressum </span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="./../phpbbde/team/?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="menuitem"> <i class="icon fa-shield fa-fw" aria-hidden="true"></i><span>Das Team</span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="/community/contactadmin?sid=cfdc3d5429fb1bb8209b76ab67d29bcf" role="menuitem"> <i class="icon fa-envelope fa-fw" aria-hidden="true"></i><span>Kontakt</span> </a> </li> </ul> </div> </div> <div class="copyright"> <p class="footer-row"> <span class="footer-copyright">Powered by <a href="https://www.phpbb.com/">phpBB</a>® Forum Software © phpBB Limited</span> </p> <p class="footer-row"> <span class="footer-copyright">Deutsche Übersetzung durch <a href="https://www.phpbb.de/">phpBB.de</a></span> </p> <p class="footer-row" role="menu"> <a class="footer-link" href="./ucp.php?mode=privacy&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Datenschutz" role="menuitem"> <span class="footer-link-text">Datenschutz</span> </a> | <a class="footer-link" href="./ucp.php?mode=terms&sid=cfdc3d5429fb1bb8209b76ab67d29bcf" title="Nutzungsbedingungen" role="menuitem"> <span class="footer-link-text">Nutzungsbedingungen</span> </a> </p> <div class="sponsor-logo"> <a href="https://linevast.de/" rel="nofollow">hosted by Linevast.de <br> <img src="./styles/phpBBdev1/theme/images/linevast.png" alt="Linevast.de" height="63" width="257"> </a> </div> </div> <div id="darkenwrapper" class="darkenwrapper" data-ajax-error-title="AJAX-Fehler" data-ajax-error-text="Bei der Verarbeitung deiner Anfrage ist ein Fehler aufgetreten." data-ajax-error-text-abort="Der Benutzer hat die Anfrage abgebrochen." data-ajax-error-text-timeout="Bei deiner Anfrage ist eine Zeitüberschreitung aufgetreten. Bitte versuche es erneut." data-ajax-error-text-parsererror="Bei deiner Anfrage ist etwas falsch gelaufen und der Server hat eine ungültige Antwort zurückgegeben."> <div id="darken" class="darken"> </div> </div> <div id="phpbb_alert" class="phpbb_alert" data-l-err="Fehler" data-l-timeout-processing-req="Bei der Anfrage ist eine Zeitüberschreitung aufgetreten."> <a href="#" class="alert_close"> <i class="icon fa-times-circle fa-fw" aria-hidden="true"></i> </a> <h3 class="alert_title"> </h3><p class="alert_text"></p> </div> <div id="phpbb_confirm" class="phpbb_alert"> <a href="#" class="alert_close"> <i class="icon fa-times-circle fa-fw" aria-hidden="true"></i> </a> <div class="alert_text"></div> </div> </div> </div> <div> <a id="bottom" class="anchor" accesskey="z"></a> </div> <script src="./assets/javascript/jquery-3.7.1.min.js?assets_version=280"></script> <script src="./assets/javascript/core.js?assets_version=280"></script> <script src="./styles/phpBBdev1/template/forum_fn.js?assets_version=280"></script> <script src="./styles/phpBBdev1/template/ajax.js?assets_version=280"></script> <script src="./styles/phpBBdev1/template/phpbbde_navi.js?assets_version=280"></script> <script>(function(a){if(a.getElementsByTagName("pre").length){var c=a.getElementsByTagName("head")[0],b=a.createElement("script");a=a.createElement("link");b.type="text/javascript";b.onload=function(){hljs.initHighlighting()};b.async=!0;b.src="//cdnjs.cloudflare.com/ajax/libs/highlight.js/9.12.0/highlight.min.js";c.appendChild(b);a.type="text/css";a.rel="stylesheet";a.href="//cdnjs.cloudflare.com/ajax/libs/highlight.js/9.12.0/styles/github-gist.min.css";c.appendChild(a)}})(document)</script> </body> </html>