myty - Handbuch für Redakteure und Administratoren

Aktuelle Info zu Sicherheitsrisiken: In den aktuellen Versionen ab 4.1. sind keine Sicherheitsprobleme bekannt.  

Suchergebnisausgabe

modul: index
Release Info
Version: 4.1
SELECT SQL_CALC_FOUND_ROWS modulesfaq_questions.*, modulesfaq_answers.Version,`modulesfaq_questions`.`id`,`modulesfaq_questions`.`status` FROM `modulesfaq_questions` LEFT JOIN modulesfaq_answers ON modulesfaq_questions.id=modulesfaq_answers.modulesfaq_questions_id AND modulesfaq_answers.id=577 WHERE 1 AND modulesfaq_questions.id=401 AND `modulesfaq_questions`.`language` = 'de' AND `modulesfaq_questions`.status = 'enabled' LIMIT 0,1

Beispiel

<ty:search type="form"> <ty-search:form class="fm-form">    <ty-search:config>            <ty-search-config:content/>       <ty-search-config:db table="modulesfaq" title="modulesfaq.Modul" text="modulesfaq.Antwort" select="Modul,Frage,Antwort,language" where="status='enabled'" order="date DESC" limit="3" cols="Modul,Frage,Antwort"/>    </ty-search:config>       <div class="div-search-field">        <div><ty-search:input class="input-text" id="search-input" value=""/> <?php /*<ty-search:submit class="input-submit" id="search-submit" value="submit">go!</ty-search:submit>*/?></div>         </div>    <ty-search:suggestion id="search-result-container" resultclass="search-result-row" activeresultclass="search-result-row-active">          <div class="search-result-title"><ty:content id="search-result-title" topic="global" display="dynamic">Suchergebnisse</ty:content></strong></div>                 <ty-search-suggestion:results type="content" mincharcount="3">                    <ty-search-suggestion-results:header>                         <div id="search-result-header">Seiteninhalte:</div>                         <div class="search-results-container">                            <ul>                  </ty-search-suggestion-results:header>                    <li id="suggestResult<ty-search-suggestion-results:globalcount/>" class="search-result-row">                                <a href="&lt;ty-search-suggestion-results:url/&gt;" title="<ty-search-suggestion-results:title/>"><strong><ty-search-suggestion-results:title/></strong></a> (<ty-search-suggestion-results:relevance format="%02d"/>%)<br />                           <p><ty-search-suggestion-results:text maxlength="50" resTextHighlightStart="<strong>" resTextHighlightEnd="</strong>"/></p>                       </li>                     <ty-search-suggestion-results:footer></ul></div></ty-search-suggestion-results:footer>                  <ty-search-suggestion-results:fallback>                           <div class="search-noresult">keine Seiteninhalte gefunden</div>                     </ty-search-suggestion-results:fallback>          </ty-search-suggestion:results>           <ty-search-suggestion:results type="db" table="modulesfaq">                       <ty-search-suggestion-results:header>                         <div id="search-result-header">FAQs:</div>                          <div class="search-results-container">                            <ul>                  </ty-search-suggestion-results:header>                    <li id="suggestResult<ty-search-suggestion-results:globalcount/>" class="search-result-row">                                <a href="<ty-search-suggestion-results:url/>/modul/<ty-search-suggestion-results:Modul/>/lang/<ty-search-suggestion-results:language/>" title="<ty-search-suggestion-results:title/>"><strong><ty-search-suggestion-results:title/></strong></a><br />                              <ty-search-suggestion-results:text maxlength="50" resTextHighlightStart="<strong>" resTextHighlightEnd="</strong>"/>                  </li>                     <ty-search-suggestion-results:footer></ul></div></ty-search-suggestion-results:footer>          </ty-search-suggestion:results>           <div class="search-result-footer">&nbsp;</div>  </ty-search:suggestion> </ty-search:form> </ty:search>
Autor: Conrad Gerlach
letzte Änderung: 08.09.2011
Kommentare 0
Fragen von Nutzern 0
ähnliche Themen 0

Ähnliche Beiträge

Es sind keine Beiträge verfügbar.

Empfohlene Beiträge

Es sind keine Beiträge verfügbar.

Kommentieren

 

Stellen Sie eine Frage

 

offene Fragen

Zu diesem Beitrag existieren keine offenen Fragen.

SELECT modulesfaq_questions.*, (SELECT modulesfaq_answers.id FROM modulesfaq_answers WHERE modulesfaq_answers.status='enabled' AND modulesfaq_answers.modulesfaq_questions_id = modulesfaq_questions.id ORDER BY modulesfaq_answers.Version DESC Limit 1) AS answer, (SELECT modulesfaq_answers.id FROM modulesfaq_answers WHERE modulesfaq_answers.modulesfaq_questions_id = modulesfaq_questions.id ORDER BY modulesfaq_answers.Version DESC Limit 1) AS answerCount, (SELECT COUNT(*) FROM modulesfaq_questions AS MQ WHERE MQ.Modul = modulesfaq_questions.Modul GROUP BY MQ.Modul) AS questionsByModul FROM modulesfaq_questions WHERE 1 AND modulesfaq_questions.language = 'de' AND modulesfaq_questions.status = 'enabled' AND modulesfaq_questions.Modul = 'index' ORDER BY modulesfaq_questions.Modul, modulesfaq_questions.pos, modulesfaq_questions.Frage

Alle Beiträge zum Thema

Auf Facebook teilen