Difference between revisions of "Help:Sandbox/protected"

From HypertWiki
Jump to navigation Jump to search
(this SQL works fine in the query browser; need to figure out why it won't work here)
(done debugging)
 
Line 1: Line 1:
This page is for sysops to experiment with W3TPL code and anything else that requires edit protection.
This page is for sysops to experiment with W3TPL code and anything else that requires edit protection.
<let name=topic val="ValueOptions" />
<let name=max val=10 />
  <let name=idx />
  <let name=including val=1 />
  <!-- let name=topic farg=iTopic / -->
  <let name=topic self with="_"> </let>
  <let name=sqlWhere>(cl_to='</let>
  <let name=sqlList>SELECT q1.* FROM qryW3_Titles_Catgs AS q1 LEFT JOIN qryW3_Titles_Catgs AS q2 ON q1.cl_from=q2.cl_from WHERE (q1.cl_to='Data/blog/post') AND (q2.cl_to='</let>
  <let name=sqlList append copy=topic />
  <let name=sqlList append>') ORDER BY page_title DESC LIMIT </let>
  <let name=sqlList append copy=max />
SQL 1: <get name=sqlList />
  <let name=noLoad val=1 />
  <for sql=$sqlList hide>
    <let name=pg_nspace_code>{{ns:</let>
    <let name=pg_nspace_code append val=@row.page_namespace />
    <let name=pg_nspace_code append>}}</let>
    <let name=pg_nspace copy=pg_nspace_code parse />
    <let name=pg_title val="@row.page_title" />
    <let name=pg_name copy=pg_nspace />
    <let name=pg_name append>:</let>
    <let name=pg_name append copy=pg_title />
    <let name=idx inc />
    <let name=data[Title] null />
    <load page=$pg_name />
    <if flag=data[Title]>
      <call GetBlogEntryBrief />
      <let name=e.rtn append copy=e.out />
    </if>
    <let name=data />
  </for>
SQL 2: <get name=sqlList />

Latest revision as of 21:53, 15 September 2011

This page is for sysops to experiment with W3TPL code and anything else that requires edit protection.