W3TPL/recipes

Pages and Categories

List all categorized Titles without defining any VIEWs:

Wikitext

<xml> <hide>

 <for sql="SELECT * FROM categorylinks AS cl LEFT JOIN page AS p ON cl_from=page_id">
   <let name=pg_title val=@row.page_title />
   <let name=out append>

• [[</let>

   <let name=out append copy=pg_title />
   <let name=out append>|</let>

   <let load page=$pg_title name=data />
   <let name=out append copy=data[summary] />
   <let name=out append>]]</let>

</hide><get name=out /> </xml>

List all Titles in a specific category:

SQL

<mysql>CREATE OR REPLACE VIEW qryW3_Titles_Catgs AS

 SELECT * FROM
 categorylinks AS cl LEFT JOIN page AS p ON cl_from=page_id;</mysql>

• Very similar to the dpl_clview view used by DPL

Wikitext

<xml> <let name=including val="1" /> </hide><for table="qryW3_Titles_Catgs" where="(cl_to='Data/target') AND (page_namespace=0)" name=pg hide>

 <let name=pg_title val="@row.pg.page_title" />
 <load page=$pg_title />

 <let name=title_link>[[</let>
 <let name=title_link append copy=pg_title />
 <let name=title_link append>|</let>
 <let name=title_link append copy=keyname />
 <let name=title_link append>]]</let>
 <echo>

• <get name=title_link />: "<get name=title />": <get name=source /></echo>

</for> </xml>

• Replace "Data/target" with the name of the category you want to list
• Alter the line which begins with Template:Xmltag (i.e. everything between the Template:Xmltag tags) to display what you want; "title" and "source" are from an actual live installation (PsyCrit) and are defined within the pages in that category, so each output line gives a little information about the page (effectively a mini-"report")
• The "including" variable tells the included pages not to show their category, so that this page won't think it is also in that same category.

To use the same data to generate a form with a drop-down list of all titles returned: <xml><func xmltag contents>

 <let name=out chr=60 />
 <let name=out append copy=contents />
 <let name=out append chr=62 />
 <echo><get name=out raw /></echo>

</func>

<call xmltag contents="form" /> <call xmltag contents="SELECT NAME=target" /> <for table="qryW3_Titles_Catgs" where="(cl_to='Data/target') AND (page_namespace=0)" sort="page_title DESC" name=pg hide>

 <let name=pg_title val="@row.pg.page_title" />
 <load page=$pg_title />
 <echo><call xmltag contents="OPTION" /><get name=keyname /> - <get name=title /><call xmltag contents="/OPTION" /></echo>

</for> <call xmltag contents="/SELECT" /> <call xmltag contents="/form" /> </xml>