Main Page: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m →TidBits |
||
| (12 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
__NOCACHE__{{DISPLAYTITLE:<span style="position: absolute; clip: rect(1px 1px 1px 1px); clip: rect(1px, 1px, 1px, 1px);">{{FULLPAGENAME}}</span>}} <!-- Hides the Main Page title --> | |||
Welcome to the Squirrelslair. We provide a variety of services, please see the projects below for more info. If you have a project you think we could help you with, please email us at webcontact@squirrelslair.ca | Welcome to the Squirrelslair. We provide a variety of services, please see the projects below for more info. If you have a project you think we could help you with, please email us at webcontact@squirrelslair.ca | ||
<!-- name and description was CONCAT(_pageName, " - ", shortDescription)=Descript | |||
-->{{#cargo_query: | |||
tables=Project | |||
|fields=Project.mainImage,CONCAT("[[",_pageName,"]]")=Descript,_pageName | |||
|where=projectType HOLDS "Featured Project" | |||
|default= | |||
|format=gallery | |||
|mode=packed | |||
|show bytes=0 | |||
|show dimensions=0 | |||
|show filename=0 | |||
|image width=150 | |||
|caption field=Descript | |||
|alt field=_pageName | |||
|link field=_pageName | |||
|limit=1000 | |||
}} | |||
== [[Project Type]] == | == [[Project Type]] == | ||
| Line 26: | Line 45: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Project | tables=Project | ||
|fields= CONCAT("[[",Project.mainImage,"\|100px]]")=, Project._pageName=Project | |fields= CONCAT("[[File:",Project.mainImage,"\|100px]]")=, Project._pageName=Project | ||
|order by=Project._pageName | |||
|limit=0 | |limit=0 | ||
|rows per page=1000 | |rows per page=1000 | ||
| Line 32: | Line 52: | ||
|default=no projects found | |default=no projects found | ||
|more results text=Click here for a full list of projects | |more results text=Click here for a full list of projects | ||
}} | |||
== TidBits == | |||
Some things we have been playing with that aren't quite projects but might be of interest to some people. | |||
{{#cargo_query: | |||
tables=TidBit | |||
|fields= CONCAT("[[", _pageName,"|", shortDescription,"]]")=x <!-- weird error if there is no field name --> | |||
|where= _pageName NOT LIKE "Internal:%" | |||
|order by=featured DESC , _pageID DESC | |||
|limit=1000 | |||
|more results text=more TidBits | |||
|default=no TidBits found | |||
|format=ul | |||
}} | }} | ||
Latest revision as of 21:31, 2024 August 17
Welcome to the Squirrelslair. We provide a variety of services, please see the projects below for more info. If you have a project you think we could help you with, please email us at webcontact@squirrelslair.ca
{{#cargo_query: tables=Project |fields=Project.mainImage,CONCAT("",_pageName,"")=Descript,_pageName |where=projectType HOLDS "Featured Project" |default= |format=gallery |mode=packed |show bytes=0 |show dimensions=0 |show filename=0 |image width=150 |caption field=Descript |alt field=_pageName |link field=_pageName |limit=1000 }}
We have done the following types of projects: {{#cargo_query: tables=Project |fields=projectType |group by=projectType |limit=5000 |format=ul |default=no project types found }}
We have the following skillsets: {{#cargo_query: tables=Project |fields=skillSet |group by=skillSet |limit=5000 |format=ul |default=no project types found }}
Projects
{{#cargo_query: tables=Project |fields= CONCAT("File:",Project.mainImage,"\")=, Project._pageName=Project |order by=Project._pageName |limit=0 |rows per page=1000 |format=dynamic table |default=no projects found |more results text=Click here for a full list of projects }}
TidBits
Some things we have been playing with that aren't quite projects but might be of interest to some people. {{#cargo_query: tables=TidBit |fields= CONCAT("", shortDescription,"")=x |where= _pageName NOT LIKE "Internal:%" |order by=featured DESC , _pageID DESC |limit=1000 |more results text=more TidBits |default=no TidBits found |format=ul }}