[3.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla)

<!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.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla) - phpBB.de</title> <link rel="alternate" type="application/atom+xml" title="Feed - phpBB.de" href="/community/feed?sid=7fb2cb63657c03f0f3f665e1c6d08672"> <link rel="alternate" type="application/atom+xml" title="Feed - Neuigkeiten" href="/community/feed/news?sid=7fb2cb63657c03f0f3f665e1c6d08672"> <link rel="alternate" type="application/atom+xml" title="Feed - Neue Themen" href="/community/feed/topics?sid=7fb2cb63657c03f0f3f665e1c6d08672"> <link rel="alternate" type="application/atom+xml" title="Feed - Aktive Themen" href="/community/feed/topics_active?sid=7fb2cb63657c03f0f3f665e1c6d08672"> <link rel="alternate" type="application/atom+xml" title="Feed - Forum - Coding & Technik" href="/community/feed/forum/6?sid=7fb2cb63657c03f0f3f665e1c6d08672"> <link rel="alternate" type="application/atom+xml" title="Feed - Thema - [3.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla)" href="/community/feed/topic/246976?sid=7fb2cb63657c03f0f3f665e1c6d08672"> <link rel="canonical" href="https://www.phpbb.de/community/viewtopic.php?t=246976">  <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" />  <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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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="7fb2cb63657c03f0f3f665e1c6d08672" /> </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=7fb2cb63657c03f0f3f665e1c6d08672"><span class="subnavi-toggle"></span>Über uns</a> <ul class="subnavi"> <li><a href="./../phpbbde/chronik/?sid=7fb2cb63657c03f0f3f665e1c6d08672">phpBB.de-Chronik <span>Die Geschichte von phpBB.de in Wort und Bild</span></a></li> <li><a href="./../phpbbde/team/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Das Team <span>Erfahre mehr über das Team hinter phpBB.de</span></a></li> <li><a href="./../phpbbde/fragen/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Fragen an das Team <span>Ihr habt gefragt, wir haben geantwortet</span></a></li> <li><a href="/community/contactadmin?sid=7fb2cb63657c03f0f3f665e1c6d08672">Kontaktformular <span>Formular zur Kontaktaufnahme mit dem phpBB.de-Team</span></a></li> <li><a href="./../phpbbde/impressum/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Impressum <span>Das phpBB.de-Impressum</span></a></li> </ul> </li> <li class="navi-button but-phpbb"> <a href="./../infos/?sid=7fb2cb63657c03f0f3f665e1c6d08672"><span class="subnavi-toggle"></span>phpBB</a> <ul class="subnavi"> <li><a href="./../infos/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Infos über phpBB <span>Erfahre mehr über phpBB</span></a></li> <li><a href="./../infos/tour/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Die phpBB-Tour <span>Was ist phpBB und wo bekomme ich es?</span></a></li> <li><a href="./../infos/features/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Feature-Vergleich <span>Lerne alle Features kennen, die dir phpBB bietet</span></a></li> <li><a href="./../infos/anpassen/?sid=7fb2cb63657c03f0f3f665e1c6d08672">phpBB anpassen <span>Nutze Erweiterungen und Styles, um phpBB deinen Wünschen anzupassen</span></a></li> <li><a href="./../infos/entwickler/3.3/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Informationen für Entwickler <span>phpBB-Projektarchiv, nützliche Links, ...</span></a></li> <li><a href="./../xref/3.3/?sid=7fb2cb63657c03f0f3f665e1c6d08672">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=7fb2cb63657c03f0f3f665e1c6d08672"><span class="subnavi-toggle"></span>Downloads</a> <ul class="subnavi"> <li><a href="./../downloads/pakete/?sid=7fb2cb63657c03f0f3f665e1c6d08672">phpBB-Pakete <span>Die aktuellen dt. Komplett- und Updatepakete von phpBB</span></a></li> <li><a href="./../downloads/sprachpakete/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Sprachpakete <span>Die aktuellen deutschen Sprachdateien für phpBB</span></a></li> <li><a href="./../downloads/entwicklung/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Entwicklung <span>Entwickler-Downloads</span></a></li> </ul> </li> <li class="navi-button but-docu"> <a href="./../support/?sid=7fb2cb63657c03f0f3f665e1c6d08672"><span class="subnavi-toggle"> </span>Support</a> <ul class="subnavi"> <li><a href="./../support/doku/quickstart/3.3/?sid=7fb2cb63657c03f0f3f665e1c6d08672">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=7fb2cb63657c03f0f3f665e1c6d08672">Knowledge Base <span>Unsere Wissensdatenbank mit vielen und hilfreichen Artikeln</span></a></li> <li><a href="./../support/videos/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Videos <span>Unsere Supportvideos erklären Funktionen von phpBB</span></a></li> <li><a href="./../support/doku/?sid=7fb2cb63657c03f0f3f665e1c6d08672">Dokumentation <span>Hier findest Du Dokumentationen zu phpBB</span></a></li> <li><a href="./../support/doku/perror/?sid=7fb2cb63657c03f0f3f665e1c6d08672">MySQL-Fehlercodes <span>Mysql Fehlercodes dokumentiert</span></a></li> <li><a href="./../support/doku/htpasswd/?sid=7fb2cb63657c03f0f3f665e1c6d08672">.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=7fb2cb63657c03f0f3f665e1c6d08672"><span class="subnavi-toggle"> </span>Community</a> <ul class="subnavi"> <li><a href="./../community/viewforum.php?f=145&sid=7fb2cb63657c03f0f3f665e1c6d08672">Supportforen <span>Hilfe bei der Installation und Benutzung</span></a></li> <li><a href="./../community/viewforum.php?f=104&sid=7fb2cb63657c03f0f3f665e1c6d08672">Communityforen<span>Allgemeine Diskussionen und phpBB-Usergroups</span></a></li> <li><a href="./../community/viewforum.php?f=148&sid=7fb2cb63657c03f0f3f665e1c6d08672">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=7fb2cb63657c03f0f3f665e1c6d08672">Styleforen<span>Du suchst einen neuen Style oder hast Probleme mit einem Style?</span></a></li> <li><a href="./../kb/knigge?sid=7fb2cb63657c03f0f3f665e1c6d08672">Der kleine phpBB.de-Knigge <span>Eine kleine Liste von wichtigen Regeln auf phpBB.de</span></a></li> <li><a href="./../phpbbde/chat/?sid=7fb2cb63657c03f0f3f665e1c6d08672">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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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%3Fp%3D1425052&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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="103"><a itemprop="item" href="./viewforum.php?f=103&sid=7fb2cb63657c03f0f3f665e1c6d08672"><span itemprop="name">Entwickler-Ecke</span></a><meta itemprop="position" content="3" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope data-forum-id="6"><a itemprop="item" href="./viewforum.php?f=6&sid=7fb2cb63657c03f0f3f665e1c6d08672"><span itemprop="name">Coding & Technik</span></a><meta itemprop="position" content="4" /></span> </li> <li class="rightside responsive-search"> <a href="./search.php?sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=246976&sid=7fb2cb63657c03f0f3f665e1c6d08672">[3.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla)</a></h2>  <div style="display: none !important;">Fragen zu allen Themen rund ums Programmieren außerhalb von phpBB können hier gestellt werden - auch zu anderen Programmiersprachen oder Software wie Webservern und Editoren.<br /></div> <div class="action-bar bar-top"> <a href="./posting.php?mode=reply&t=246976&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=246976&sid=7fb2cb63657c03f0f3f665e1c6d08672&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=7fb2cb63657c03f0f3f665e1c6d08672"> <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=7fb2cb63657c03f0f3f665e1c6d08672" 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="246976" /> <input type="hidden" name="sf" value="msgonly" /> <input type="hidden" name="sid" value="7fb2cb63657c03f0f3f665e1c6d08672" /> </fieldset> </form> </div> <div class="pagination"> 4 Beiträge • Seite <strong>1</strong> von <strong>1</strong> </div> </div> <div id="p1425037" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1425037"> <dt class="has-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=148014&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="username">FischersFritz</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=148014&sr=posts&sid=7fb2cb63657c03f0f3f665e1c6d08672">6</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 23.12.2011 14:20</dd> </dl> <div class="postbody"> <div id="post_content1425037"> <h3 class="first"> <a href="./viewtopic.php?p=1425037&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425037">[3.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla)</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1425037&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=1425037&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425037" 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=148014&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="username">FischersFritz</a></strong> » </span><time datetime="2023-12-05T20:09:01+00:00">05.12.2023 21:09</time> </p> <div class="content">Liebe alle,<br> <br> ich würde gerne auf einer Joomla-Homepage die letzten 5 öffentlichen Beiträge als Modul einbauen.<br> Ich weiß, es gibt Joomla-Erweiterungen um phpBB einzubinden, aber die Kosten entweder (p8pbb) oder wurden seit 2020 nicht mehr aktualisiert (MD5 recent).<br> <br> Etwas in der Art: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>SELECT topic_id, topic_title, topic_last_poster_name, topic_last_post_time FROM phpbb_topics ORDER BY topic_last_post_time DESC LIMIT 0,5;</code></pre></div> Erweitert darum, dass eben nur öffentliche Beiträge angezeigt werden.<br> <br> Ist das überhaupt "so einfach" möglich? Ich habe mir die Tabelle phpbb_acl_groups bereits angesehen, werde aber bisher nicht so ganz schlau daraus..<br> <br> Vielen Dank!</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="panel"> <div class="inner">Verschoben von <strong><a href="./viewforum.php?f=145&sid=7fb2cb63657c03f0f3f665e1c6d08672">Support-Forum</a></strong> nach <strong><a href="./viewforum.php?f=6&sid=7fb2cb63657c03f0f3f665e1c6d08672">Coding & Technik</a></strong> am 05.12.2023 21:24 durch <strong><a href="./memberlist.php?mode=viewprofile&u=133591&sid=7fb2cb63657c03f0f3f665e1c6d08672" style="color: #2B42AF;" class="username-coloured">Scanialady</a></strong></div> </div> <hr class="divider" /> <div id="p1425038" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1425038"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=190625&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="avatar"><img class="avatar" src="./download/file.php?avatar=190625_1430903531.jpg" width="80" height="80" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=190625&sid=7fb2cb63657c03f0f3f665e1c6d08672" style="color: #2B42AF;" class="username-coloured">LukeWCS</a> </dt> <dd class="profile-rank">Supporter<br /><img src="./images/ranks/rang_supporter.png" alt="Supporter" title="Supporter" /></dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=190625&sr=posts&sid=7fb2cb63657c03f0f3f665e1c6d08672">2725</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 15.12.2014 10:19</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von LukeWCS"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von LukeWCS</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://www.wcsaga.org" 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_content1425038"> <h3 > <a href="./viewtopic.php?p=1425038&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425038">Re: [3.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla)</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1425038&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=1425038&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425038" 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=190625&sid=7fb2cb63657c03f0f3f665e1c6d08672" style="color: #2B42AF;" class="username-coloured">LukeWCS</a></strong> » </span><time datetime="2023-12-05T20:35:22+00:00">05.12.2023 21:35</time> </p> <div class="content">Hallo<br> <blockquote cite="./viewtopic.php?p=1425037&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425037"><div><cite><a href="./memberlist.php?mode=viewprofile&u=148014&sid=7fb2cb63657c03f0f3f665e1c6d08672">FischersFritz</a> hat geschrieben: <a href="./viewtopic.php?p=1425037&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425037" aria-label="Zitierten Beitrag anzeigen" data-post-id="1425037" onclick="if(document.getElementById(hash.substr(1)))href=hash"><i class="icon fa-arrow-circle-up fa-fw" aria-hidden="true"></i></a><span class="responsive-hide">05.12.2023 21:09</span></cite> Ist das überhaupt "so einfach" möglich? Ich habe mir die Tabelle phpbb_acl_groups bereits angesehen, werde aber bisher nicht so ganz schlau daraus.. </div></blockquote> Nein, da hast du schon richtig vermutet, sooo einfach ist das nicht. In deinem Fall geht es um den Zugriff auf Beiträge die per phpBB Permissions geregelt sind. Ob man das wirklich alles nur mit einer einzigen SQL Abfrage realisieren kann, weiss ich nicht, ich bezweifle es. Das liegt aber definitiv weit ausserhalb meiner SQL Kenntnisse. <img class="smilies" src="./images/smilies/icon_e_wink.gif" width="15" height="17" alt=";)" title="Zwinkern"></div> <div id="sig1425038" class="signature">Möge das Backup mit dir sein. Immer.<br> <strong class="text-strong">Kein Support via PN!</strong> Siehe den Punkt "Private Nachrichten" im <a href="https://www.phpbb.de/kb/viewarticle?a=7" class="postlink">phpBB.de-Knigge</a>.<br> <a href="https://www.phpbb.de/community/viewtopic.php?t=246191" class="postlink">Erweiterungen - Infos zur artgerechten Haltung</a> / <a href="https://www.phpbb.de/community/viewtopic.php?t=244054" class="postlink">phpBB Ext Check - Analyse von Erweiterungen bezüglich Vorgaben und Kompatibilität</a></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="p1425042" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1425042"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=8739&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="avatar"><img class="avatar" src="./download/file.php?avatar=8739_1704634026.png" width="52" height="80" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=8739&sid=7fb2cb63657c03f0f3f665e1c6d08672" style="color: #58A504;" class="username-coloured">Dr.Death</a> </dt> <dd class="profile-rank">Moderator<br /><img src="./images/ranks/rang_moderator.png" alt="Moderator" title="Moderator" /></dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=8739&sr=posts&sid=7fb2cb63657c03f0f3f665e1c6d08672">17445</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 23.04.2003 08:22</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Xanten</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von Dr.Death"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von Dr.Death</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.lpi-clan.de" 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_content1425042"> <h3 > <a href="./viewtopic.php?p=1425042&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425042">Re: [3.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla)</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1425042&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=1425042&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425042" 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=8739&sid=7fb2cb63657c03f0f3f665e1c6d08672" style="color: #58A504;" class="username-coloured">Dr.Death</a></strong> » </span><time datetime="2023-12-06T07:56:29+00:00">06.12.2023 08:56</time> </p> <div class="content">Ich hab da noch ein kleines Script bei mir gefunden:<br> <br> <a href="http://www.lpi-clan.de/viewtopic.php?t=4546" class="postlink">Externe Beitragsanzeige (phpBB 3.3 getestet)</a><br> <a href="http://www.lpi-clan.de/external.php" class="postlink">Demo</a><br> <br> Ich gebe allerdings aus zeitlichen Gründen keinen Support dazu....habs aber heute morgen noch mit einem phpBB 3.3.11 Testforum getestet.</div> <div id="sig1425042" class="signature">Doc.<br> <br> <a href="https://www.phpbb.de/kb/knigge" class="postlink">Der kleine phpBB.de-Knigge - unsere Hausordnung</a></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="p1425052" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1425052"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="avatar"><img class="avatar" src="./download/file.php?avatar=206428_1703642850.png" width="90" height="90" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="username">IMC</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=206428&sr=posts&sid=7fb2cb63657c03f0f3f665e1c6d08672">647</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 25.11.2018 20:32</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Lüneburg</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von IMC"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von IMC</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://www.indianclub.de" 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_content1425052"> <h3 > <a href="./viewtopic.php?p=1425052&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425052">Re: [3.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla)</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1425052&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=1425052&sid=7fb2cb63657c03f0f3f665e1c6d08672#p1425052" 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=206428&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="username">IMC</a></strong> » </span><time datetime="2023-12-07T05:40:10+00:00">07.12.2023 06:40</time> </p> <div class="content">Eine weitere Möglichkeit wäre das du <a href="https://www.phpbb.de/community/viewtopic.php?t=246557" class="postlink">Recent Topics</a> dazu nutzt. Über den Link <code class="inline">https://meinforum.de/app.php/rt/simple</code> kannst du eine vereinfachte Darstellung aufrufen die du mit einem <code class="inline">iframe</code> einbetten kannst.<br> In der Datei <code class="inline">controller/page_controller.php</code> kannst du ab Zeile 84 die Anzahl der Beiträge anpassen. <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> // Displays ResentTopics in a simple page for further use case 'simple': // Topics per page, 0 use default settings $this->rt_functions->topics_per_page = 5; // Numbers of pages, 0 use default settings $this->rt_functions->topics_page_number = 1; </code></pre></div></div> <div id="sig1425052" class="signature">Gruß, Thorsten</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=246976&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=246976&sid=7fb2cb63657c03f0f3f665e1c6d08672&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=246976&sid=7fb2cb63657c03f0f3f665e1c6d08672"> <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"> 4 Beiträge • Seite <strong>1</strong> von <strong>1</strong> </div> </div> <div class="action-bar actions-jump"> <p class="jumpbox-return"> <a href="./viewforum.php?f=6&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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 „Coding & Technik“</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=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-cat-link"> <span> Wichtige Neuigkeiten</span></a></li> <li><a href="./viewforum.php?f=9&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Ankündigungen und Neuigkeiten</span></a></li> <li><a href="./viewforum.php?f=164&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-cat-link"> <span> phpBB 3.3.x</span></a></li> <li><a href="./viewforum.php?f=145&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Support-Forum</span></a></li> <li><a href="./viewforum.php?f=148&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Extension-Foren</span></a></li> <li><a href="./viewforum.php?f=150&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Style-Foren</span></a></li> <li><a href="./viewforum.php?f=153&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Übersetzungs-Foren</span></a></li> <li><a href="./viewforum.php?f=161&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-cat-link"> <span> Entwickler-Ecke</span></a></li> <li><a href="./viewforum.php?f=6&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Coding & Technik</span></a></li> <li><a href="./viewforum.php?f=158&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Area51 auf phpBB.com</span></a></li> <li><a href="./viewforum.php?f=100&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-cat-link"> <span> Frühere Versionen</span></a></li> <li><a href="./viewforum.php?f=155&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-cat-link"> <span> Community-Foren</span></a></li> <li><a href="./viewforum.php?f=19&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Community Talk</span></a></li> <li><a href="./viewforum.php?f=33&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   phpBB Diskussion</span></a></li> <li><a href="./viewforum.php?f=67&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Show-Off</span></a></li> <li><a href="./viewforum.php?f=105&sid=7fb2cb63657c03f0f3f665e1c6d08672" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   phpBB Regional</span></a></li> <li><a href="./viewforum.php?f=77&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" 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=7fb2cb63657c03f0f3f665e1c6d08672" title="Datenschutz" role="menuitem"> <span class="footer-link-text">Datenschutz</span> </a> | <a class="footer-link" href="./ucp.php?mode=terms&sid=7fb2cb63657c03f0f3f665e1c6d08672" 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>

CINXE.COM

[3.3] SQL Query für die letzten 5 öffentlichen Beiträge (Einbau in Joomla) - phpBB.de