Template talk:Nesdbbox: Difference between revisions
From NESdev Wiki
Jump to navigationJump to search
Rainwarrior (talk | contribs) m (documented?) |
m (yes, please) |
||
| Line 1: | Line 1: | ||
If you can set unif's search type to be "unif_op=LIKE+`%25%40%25`" then we can use SQL GLOBs in the template rather than having to enumerate all the variants, q.v. "http://bootgod.dyndns.org:7777/search.php?unif_op=LIKE+%60%25%40%25%60&unif=A%25ROM" —[[User:Lidnariq|Lidnariq]] ([[User talk:Lidnariq|talk]]) 04:01, 23 April 2015 (MDT) | If you can set unif's search type to be "unif_op=LIKE+`%25%40%25`" then we can use SQL GLOBs in the template rather than having to enumerate all the variants, q.v. "http://bootgod.dyndns.org:7777/search.php?unif_op=LIKE+%60%25%40%25%60&unif=A%25ROM" —[[User:Lidnariq|Lidnariq]] ([[User talk:Lidnariq|talk]]) 04:01, 23 April 2015 (MDT) | ||
:Well, technically you could make any search string you like, the form is just "PARAM1"="PARAM2" so you could just cram "unif_op"="LIKE+%60%25%40%25%60&unif=A%25ROM" into the string, but if you can explain how that URL you just made work I could try and make an easy-to-use form of this for the template. What does unif_op do? What does "LIKE+`@% | :Well, technically you could make any search string you like, the form is just "PARAM1"="PARAM2" so you could just cram "unif_op"="LIKE+%60%25%40%25%60&unif=A%25ROM" into the string, but if you can explain how that URL you just made work I could try and make an easy-to-use form of this for the template. What does unif_op do? What does "LIKE+`%@%`" mean? Is the % in A%ROM a wildcard character that the LIKE operation expands? (Is this documented somewhere?) | ||
:What would you like the template code to look like? Something like this? | :What would you like the template code to look like? Something like this? | ||
<pre>{{nesdblink|unif_wildcard|A%ROM|AxROM}}</pre> | <pre>{{nesdblink|unif_wildcard|A%ROM|AxROM}}</pre> | ||
:- [[User:Rainwarrior|Rainwarrior]] ([[User talk:Rainwarrior|talk]]) 10:56, 23 April 2015 (MDT) | :- [[User:Rainwarrior|Rainwarrior]] ([[User talk:Rainwarrior|talk]]) 10:56, 23 April 2015 (MDT) | ||
:: In SQL-ese, "LIKE" gets you globs like filename ? and *, and "_" and "%" are equivalent to ? and *. @ here is substituted with the value of the unif parameter. (But "LIKE" is case-insensitive, while "GLOB" is case-insensitive.) | |||
:: But, yes, something like your example would be lovely. —[[User:Lidnariq|Lidnariq]] ([[User talk:Lidnariq|talk]]) 12:48, 23 April 2015 (MDT) | |||
Revision as of 18:48, 23 April 2015
If you can set unif's search type to be "unif_op=LIKE+`%25%40%25`" then we can use SQL GLOBs in the template rather than having to enumerate all the variants, q.v. "http://bootgod.dyndns.org:7777/search.php?unif_op=LIKE+%60%25%40%25%60&unif=A%25ROM" —Lidnariq (talk) 04:01, 23 April 2015 (MDT)
- Well, technically you could make any search string you like, the form is just "PARAM1"="PARAM2" so you could just cram "unif_op"="LIKE+%60%25%40%25%60&unif=A%25ROM" into the string, but if you can explain how that URL you just made work I could try and make an easy-to-use form of this for the template. What does unif_op do? What does "LIKE+`%@%`" mean? Is the % in A%ROM a wildcard character that the LIKE operation expands? (Is this documented somewhere?)
- What would you like the template code to look like? Something like this?
{{nesdblink|unif_wildcard|A%ROM|AxROM}}
- - Rainwarrior (talk) 10:56, 23 April 2015 (MDT)
- In SQL-ese, "LIKE" gets you globs like filename ? and *, and "_" and "%" are equivalent to ? and *. @ here is substituted with the value of the unif parameter. (But "LIKE" is case-insensitive, while "GLOB" is case-insensitive.)
- But, yes, something like your example would be lovely. —Lidnariq (talk) 12:48, 23 April 2015 (MDT)
