Template talk:Nesdbbox: Difference between revisions

From NESdev Wiki
Jump to navigationJump to search
(can you explain that URL to me?)
m (documented?)
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+`@%@`" mean? Is the % in A%ROM a wildcard character that the LIKE operation expands?
: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)

Revision as of 17:25, 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)