Difference between revisions of "File talk:HumanPower.jpg"
(Can you use it?) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Might use this on an AL page? It's from Xmas Story. | Might use this on an AL page? It's from Xmas Story. | ||
{{User:Gopher/sig}} On AL page AND on the "Opening Credits" page whenever I get around to making it. Side note, I really wish it was possible to write DB querries directly in Wiki. If you could build a table dynamically by polling data from other pages it'd be slick as hell, probably want it to be regenerated only when the source-data changes but adding watches to automatically do that periodically should be practical. Something like: | |||
<pre> | |||
{{SELECT "*[[", Name, "|", Nickname, "]]" | |||
FROM Characters, Appearances, Episodes | |||
WHERE Character.ID=Appearances.CharacterID | |||
AND Appearances.EpisodeID=Episodes.ID | |||
AND Episodes.Title="Space Pilot 3000" | |||
ORDER BY Nickname}} | |||
</pre> | |||
which would output a bulleted list of all characters appearing in the first ep, linked and in alphabetical order (standard SQL querry, if you don't know SQL). Could act like "subst:" prefixed templates, does the querry once and saves the output instead. But maybe that's just the coder in me. | |||
{{User:Buddy13/sig}} Actually, it's not from the opening credits... Also, I don't know dynamic anything. Just XHTML and CSS. I've been told my CSS skills are godly. But my SQL skills are... well, let's just say, if SQL (or PHP or whatever) were a school, I'd ride the short bus. | |||
Revision as of 10:46, 18 February 2006
Might use this on an AL page? It's from Xmas Story.
User:Gopher/sig On AL page AND on the "Opening Credits" page whenever I get around to making it. Side note, I really wish it was possible to write DB querries directly in Wiki. If you could build a table dynamically by polling data from other pages it'd be slick as hell, probably want it to be regenerated only when the source-data changes but adding watches to automatically do that periodically should be practical. Something like:
{{SELECT "*[[", Name, "|", Nickname, "]]"
FROM Characters, Appearances, Episodes
WHERE Character.ID=Appearances.CharacterID
AND Appearances.EpisodeID=Episodes.ID
AND Episodes.Title="Space Pilot 3000"
ORDER BY Nickname}}
which would output a bulleted list of all characters appearing in the first ep, linked and in alphabetical order (standard SQL querry, if you don't know SQL). Could act like "subst:" prefixed templates, does the querry once and saves the output instead. But maybe that's just the coder in me.
Buddy13 
Actually, it's not from the opening credits... Also, I don't know dynamic anything. Just XHTML and CSS. I've been told my CSS skills are godly. But my SQL skills are... well, let's just say, if SQL (or PHP or whatever) were a school, I'd ride the short bus.
