myty - Handbuch für Redakteure und Administratoren

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

Vorschlagssuche

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=576 WHERE 1 AND modulesfaq_questions.id=400 AND `modulesfaq_questions`.`language` = 'de' AND `modulesfaq_questions`.status = 'enabled' LIMIT 0,1

Beispiel

<ty:search type="suggest"> <ty-search:form class="fm-form">         <ty-search:config>            <ty-search-config:content limit="5"/>             <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>

weiteres Beispiel

<ty:search type="suggest">     <ty-search:config>         <ty-search-config:content subtopic="topic1,topic2" excludetopic="topic_1_1" limit="3"/>         <ty-search-config:db table="news" select="news.title" where="status='enabled'" limit="3"/>         <ty-search-config:db table="manufacturer" select="reviews.title" where="status='enabled'" join="LEFT JOIN reviews ON (manufacturer.id = reviews.man_id)" limit="3"/>         <ty-search-config:navigation topic="sandkasten" level="1" limit="3"/>     </ty-search:config>     <div id="div-search-field">         <label for="search-input">Suche:</label> <ty-search:input class="input-text" id="search-input" value="Suchwort"/><br/>         <ty-search:submit class="input-submit" id="search-submit" value="submit">Suchen!</ty-search:submit>     </div>     <ty-search:suggestion class="search-result-container" style="...">         <ty-search-suggestion:results type="content">             <ty-search-suggestion-results:header>                 <div class="suggest-results">                     Seiteninhalte:<br/>             </ty-search-suggestion-results:header>             <h2><ty-search-suggestion-results-result:title/></h2>             <p><ty-search-suggestion-results-result:text/></p>             <ty-search-suggestion-results:footer></div></ty-search-results:footer>         </ty-search-suggestion:results>         <ty-search-suggestion:results type="db" table="news">             <ty-search-suggestion-results:header>                 <div class="suggest-results">                     Inhalte aus den News:<br/>             </ty-search-suggestion-results:header>             <h2><ty-search-suggestion-results:title/></h2>             <p><ty-search-suggestion-results:text/></p>             <ty-search-suggestion-results:footer></div></ty-search-suggestion-results:footer>         </ty-search-suggestion:results>     </ty-search:suggestion> </ty:search>

Suggest-Suche im Shop

<ty:search type="suggest">     <ty-search:form class="fm-form">     <ty-search:config>         <ty-search-config:shop fields="EAN,title,name,description,manufacturer" limit="5" topics="topic1,topic2" excludetopic="topic_1_1" order="EAN DESC, title ASC" use_index="true" limit="5"/>     </ty-search:config>     <div id="div-search-field">         <label for="search-input">Suche:</label> <ty-search:input class="input-text" id="search-input" value="Suchwort"/><br/>         <ty-search:submit class="input-submit" id="search-submit" value="submit">Suchen!</ty-search:submit>     </div>     <ty-search:suggestion class="search-result-container" style="...">         <ty-search-suggestion:results type="shop">             <ty-search-suggestion-results:header>                 <div class="suggest-results">                     Shop-Artikel:<br/>             </ty-search-suggestion-results:header>             <ty-search-suggestion-results:articleList>                 <ty-shop:listOfArticlesArticle>                     <h2><ty-shop:articleName/></h2>                     <p><ty-shop:articleTeaser/></p>                     <ty-shop:articleOptions>                         <p><strong><ty-shop:optionPrice/></strong></p>                     </ty-shop:articleOptions>                 </ty-shop:listOfArticlesArticle>             </ty-search-suggestion-results:articleList>             <ty-search-suggestion-results:footer></div></ty-search-results:footer>         </ty-search-suggestion:results>     </ty-search:suggestion>     </ty-search:form> </ty:search>

Ladeanimation einbinden

<ty:search type="suggest" callback="{'onload': loadingStarts, 'oncomplete': loadingComplete}">     <ty-search:loader class="loading-container" id="search-loading-animation" tag="div">         <img src="/templates/pics/loading.gif" border="0" alt="loading"/>     </ty-search:loader> </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