Sandbox

From syn2cat - HackerSpace.lu
Revision as of 17:35, 11 October 2009 by Kwisatz (Talk | contribs)

Jump to: navigation, search

Contents

Poll

<poll> Do you like this extension? Yes No I don't know yet. </poll>

Today query

A date that has a time is > than one that does not. :(
This should be a workable workaround

TODAY:

Debug Output by SMWSQLStore3

Generated Wiki-Query

[[Category:Event||ExternalEvent||Workshop]] [[StartDate::≥20 April 2024 00:00:00]] [[StartDate::≤20 April 2024 23:59:00]]

Query Metrics

Query-Size:5
Query-Depth:1

SQL Query

SELECT DISTINCT t7.smw_title AS t,t7.smw_namespace AS ns FROM `smw_object_ids` AS t7 INNER JOIN `smw_fpt_inst` AS t1 ON t7.smw_id=t1.s_id INNER JOIN `t2` AS t2 ON t1.o_id=t2.id INNER JOIN `smw_di_time` AS t3 ON t1.s_id=t3.s_id INNER JOIN `smw_di_time` AS t5 ON t1.s_id=t5.s_id WHERE (((t3.o_sortkey>='2460420.5') AND t3.p_id='59') AND ((t5.o_sortkey<='2460421.4993056') AND t5.p_id='59')) ORDER BY t3.o_sortkey ASC LIMIT 2 OFFSET 0;

Auxilliary Tables Used

  • Temporary table t2
      Recursively computed hierarchy for element(s) ('490'),('465').

Errors and Warnings

The part "|Meeting" of the query was not understood. Results might not be as expected.
The part &quot;|Meeting&quot; of the query was not understood.

Results might not be as expected.

{{#ask:[[Category:Event||ExternalEvent||Workshop|Meeting]]
[[StartDate::>{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} 00:00]]
[[StartDate::<{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} 23:59]]
| ?StartDate=
| intro='''TODAY''':_
| searchlabel=
| sort=StartDate
| limit=1
| format=list
}}

the mainpage has an additional [[Category:!RecurringEvent]]

The part &quot;|Meeting&quot; of the query was not understood. Results might not be as expected.

External Data

asking for events from our wiki {{#get_external_data:https://www.hackerspace.lu/wiki/Special:Ask?title=Special%3AAsk&q=%0D%0AStartDate::+&po=%3FStartDate&sc=0&eq=yes&p=format%3Dcsv&sep=%3D,|CSV with Header|event=|startdate=StartDate}} {{#for_external_table: * {{{event}}} starts on {{{startdate}}}
}}

asking for external data from hackerspaces.org {{#get_external_data:http://hackerspaces.org/wiki/Special:Ask?title=Special%3AAsk&q=%0D%0A&po=%3FStart%20date%0D%0A%3Ftitle%0D%0A&sc=0&eq=yes&p=format%3Dcsv&sep=%3D,%7CCSV with Header|event=title|startdate=Start date}} {{#for_external_table: * {{{event}}} has {{{startdate}}}
}}

asking for opendoors startdate from our wiki {{#get_external_data:https://www.hackerspace.lu/wiki/Special:Ask/-5B-5BOpenDoors-5D-5D/-3FStartDate/-3FEndDate/format%3Dcsv/sep%3D,%7Ccsv with header|sdate=StartDate|edate=EndDate}}

  • Opendoors has StartDate {{#external_value:sdate}} and ends on {{#external_value:edate}}

asking for smw sample data from semanticweb.org: {{#get_external_data:http://semanticweb.org/wiki/Special:Ask/-5B-5BGermany-5D-5D/-3FBorders/-3FPopulation/-3FArea/format%3Dcsv/sep%3D,%7Ccsv with header|bordered countries=borders|population=population|area=area}}

  • Germany has area {{#external_value:area}}.

OggHandler

FlashMP3

Howto: http://www.mediawiki.org/wiki/Extension:FlashMP3

Error: file 02 - Mineralogique.mp3 not found


amazon

Note: if you don't see anything, maybe try turning Adblock off :D
Single box:
Single direkt link without preview: Hackers
Single direkt link with preview: Circuit Bending
Single search link: Books for Hackers

Older Sandbox stuff on Sandbox/2

Retrieved from "http://wiki.syn2cat.lu/w/index.php?title=Sandbox&oldid=5275"
Personal tools
Namespaces

Variants
Actions
Navigation
syn2cat
Hackerspace
Activities
Initiatives
Community
Tools
Tools