How are these SQL instructions entered?
On Nov 9, 2007 10:36 PM, sannse <[EMAIL PROTECTED]> wrote:
> OK, It's in the requests list. Hopefully it won't take too long.
>
> -- sannse
>
>
> On Nov 8, 2007 8:56 PM, DanTMan <[EMAIL PROTECTED]> wrote:
> > Yes, those are the prefixes that need converting to namespaces.
> > (Emphasizing conversion of prefixes to namespaces rather than just a
> > namespace addition, cause a page like [[Card Gallery:Dark Magician
> > ]]should still be located at [[Card Gallery:Dark Magician]] after the
> > conversion, the only difference being that {{NAMESPACE}} returns Card
> > Gallery, and {{PAGENAME}} returns Dark Magician rather than both
> > {{PAGENAME}} and {{FULLPAGENAME}} returning Card Gallery:Dark Magician.)
> >
> > There aren't any other prefixes to worry about. If the wiki needs a new
> > Namespace later on for some reason we can do it the normal special page
> > way. Though, it would be nice if the numericals (
> > http://yugioh.wikia.com/wiki/Special:Allpages/45023678 ), and the set
> > names ( http://yugioh.wikia.com/wiki/Special:Allpages/DB1-EN007 |
> > http://yugioh.wikia.com/wiki/Special:Allpages/DB1-EN007 |
> > http://yugioh.wikia.com/wiki/Special:Allpages/SDP-044 ) could be put
> > into some magical type of special namespace. But, thats a whole
> > different technical issue. ^_^ Regex Namespaces, now that would be an
> > awesome update to MediaWiki.
> >
> > ~Daniel Friesen(Dantman) of:
> > -The Gaiapedia (http://gaia.wikia.com)
> > -Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG)
> > -and Wiki-Tools.com (http://wiki-tools.com)
> >
> >
> > sannse wrote:
> > > OK, so we'll get this on to the technical to-do list.
> > >
> > > Dantman, can you just confirm that the change needed is to add 6 new
> > > namespaces:
> > >
> > > Card Gallery:
> > > Card Rulings:
> > > Card Errata:
> > > Card Tips:
> > > Anime and Manga Appearances:
> > > Card Trivia:
> > >
> > > Thanks,
> > >
> > > -- sannse
> > >
> > > ----
> > > Lisa "sannse" Carter
> > > Wikia Community and Technical Support Team
> > > http://www.wikia.com/
> > >
> > > On Oct 25, 2007 6:42 PM, DanTMan <[EMAIL PROTECTED]> wrote:
> > >
> > >> Ok, it took a while to get the Community to actually put in their
> > >> feedback instead of just staring at other parts of the site.
> > >> http://yugioh.wikia.com/wiki/Yu-Gi-Oh%21:Community_Portal#Prefixes_to_Namespaces
> > >> There are 3 confirmations from active users of the site. You can see
> > >> from the IRC Log above that one of the most active Sysops, Deltaneos
> > >> gives his support of the change. And there isn't anything listed on that
> > >> page, but the wiki's founder TwoTailedFox also said in IRC that he likes
> > >> the idea. Feel free to ask him for confirmation if you want it...
> > >>
> > >> So that would be something nice to have done. At whatever time you do,
> > >> since it's an active wiki would it be to much to ask for Wikia's staff
> > >> to put a notice inside of the Sitenotice and Anonnotice a day before
> > >> that the next day during a scheduled time the database will be locked
> > >> and some pages may be temporarily unavailable during the change?
> > >>
> > >> ~Daniel Friesen(Dantman) of:
> > >> -The Gaiapedia (http://gaia.wikia.com)
> > >> -Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG)
> > >> -and Wiki-Tools.com (http://wiki-tools.com)
> > >>
> > >> Bill Kaufmann wrote:
> > >>
> > >>> Hi DanTMan -
> > >>>
> > >>> Great ideas and thoughts. But I want to make sure that someone from
> > >>> Yu-Gi-Oh! requested the changes you mention below. Is the entire
> > >>> community aware of what you intend to do? If not, then I am reluctant
> > >>> to suggest we change anything (either behind the scenes or in full
> > >>> view) until they are a part of the discussion. I would much prefer
> > >>> that you show the Yu-Gi-Oh! community the possibilities on a talk page
> > >>> and have them embrace the help rather than force something on them
> > >>> which they don't feel is needed. If the majority of the community
> > >>> doesn't acknowledge the improvements you are offering, then I think
> > >>> it's wise to give them space until they do.
> > >>>
> > >>> Thanks,
> > >>> Bill
> > >>>
> > >>>
> > >>> On 9/23/07, *DanTMan* < [EMAIL PROTECTED]
> > >>>
> > >>> <mailto:[EMAIL PROTECTED]>> wrote:
> > >>>
> > >>> *Short Summary:* Yu-Gi-Oh! Wiki needs Namespaces, but it can't be
> > >>> done the normal way through the staff Special page because of the
> > >>> wiki's size and the quantity of pages.
> > >>>
> > >>> ------------------------------------------------------------------------
> > >>> I've been starting to out the Yu-Gi-Oh! Wiki lately. While they
> > >>> are quite well off in editors and admins, they are largely
> > >>> undeveloped with any of the normal /complex/ templates and other
> > >>> tricks.
> > >>> Which brings me to a bit of an issue I'm trying to solve:
> > >>> On the Yu-Gi-Oh! Wiki they basically have 7 specific pages for a
> > >>> card:
> > >>>
> > >>> * /Card name/ - The card page with the information on the card.
> > >>> * Card Gallery:/Card name/ - A gallery of the different images
> > >>> of the card (Cards can be from multiple packs, starter sets,
> > >>> promos, be 1st Edition, or holofoil, have English/Japanese
> > >>> versions, and even have other versions with different lore
> > >>> (the card text or effect))
> > >>> * Card Rulings:/Card name/ - Lists various Rulings used in
> > >>> various game tournaments and other official rulings about
> > >>> the card.
> > >>> * Card Errata:/Card name/ - A list/table/explanation of the
> > >>> various changes to things on the card such as it's lore,
> > >>> which were changed with different releases of the card.
> > >>> * Card Tips:/Card name/ - Tips on how the card can be
> > >>> effectively used, or combined with other cards.
> > >>> * Anime and Manga Appearances:/Card name/ - Times where the
> > >>> card was used in one of the Anime or Manga.
> > >>> * Card Trivia:/Card name/ - Various other small bits of
> > >>> information on the card which don't fit elsewhere.
> > >>>
> > >>> But now the issue is on the templates.
> > >>> Unfortunately, instead of putting the Gallery, Rulings, Errata,
> > >>> Tips, etc... index into one template. They each have their own,
> > >>> but that's not the big problem.
> > >>> The issue lies in this:
> > >>> While on the /Card name/ page you can nicely link to the gallery
> > >>> within one of the Card Table templates using "Card
> > >>> Gallery:{{PAGENAME}}", that doesn't work that well on the "Card
> > >>> Gallery:/Card name/" page. So instead, while the Card's page links
> > >>> using {{PAGENAME}}, the others link with a template parameter. And
> > >>> that starts to not work out to well. If you move a Card page to a
> > >>> new title, all the links fix themselves and point to the correct
> > >>> page, because the thing in common with all the pages is always the
> > >>> /Card name/ bit in the name, if that's different they're not part
> > >>> of each other. But, when you move a page like a "Card Errata:/Card
> > >>> name/" page, the links don't change, and now it's linking back to
> > >>> incorrect pages, which don't link back properly.
> > >>>
> > >>> So the real problem is, that the things like "Card Gallery:"
> > >>> should actually be namespaces. But there's an issue with asking
> > >>> the staff to do this.
> > >>> Go to
> > >>> http://yugioh.wikia.com/wiki/Special:Prefixindex/Card_Trivia: this
> > >>> is just one of them. There are 6 namespaces which would need to be
> > >>> created. In simple terms, as you see on that page list there, a
> > >>> Special:Prefixindex list, filled up, with only one of those sets,
> > >>> only gets half the list. So, count that number there, multiply it
> > >>> by 2, then multiply that by 6... And that's a few thousand pages
> > >>> which would need to be moved, then a request would need to be made
> > >>> to the staff, then things would need to be moved back. Sure it's
> > >>> possible to move things by bot, but what about the users. The
> > >>> Yu-Gi-Oh! Wiki is a highly active wiki, we start moving, and
> > >>> editors start getting confused and recreating stuff. Either that
> > >>> or we come up with some way to basically shut down the wiki for a
> > >>> few days. But then, one of Wikia's large wiki is dead for a few
> > >>> days...
> > >>>
> > >>> So this is something that would need to be done by the Techs.
> > >>> Through the normal PHP edit, and a set of SQL queries.
> > >>> Basically the 6 new namespaces would need to be added, then a set
> > >>> of 6 SQL queries like this, would need to be run:
> > >>> |UPDATE pages SET page_namespace = 104, page_name =
> > >>> SUBSTRING(page_namespace, 12) WHERE page_namespace = 0 AND
> > >>> 'Card_Trivia:' = LEFT(page_name, 12)|
> > >>> Which of course, basically would go over all the pages in the Main
> > >>> namespace starting with 'Card_Trivia:', change the namespace to
> > >>> the new one (104 in the example), and then strip out the
> > >>> 'Card_Trivia:' from the start of the title so we don't have it now
> > >>> at |Card_Trivia:||Card_Trivia:/Card name/|.
> > >>>
> > >>> Is this something that could still be requested of the techs?
> > >>>
> > >>> --
> > >>> ~Daniel Friesen(Dantman) of The Gaiapedia, Wikia Graphical
> > >>> Entertainment Project, and Wiki-Tools.com
> > >>>
> > >>>
> > >>> _______________________________________________
> > >>> Wikia-l mailing list
> > >>> [email protected] <mailto:[email protected]>
> > >>> http://lists.wikia.com/mailman/listinfo/wikia-l
> > >>>
> > >>>
> > >>> ------------------------------------------------------------------------
> > >>>
> > >>> _______________________________________________
> > >>> Wikia-l mailing list
> > >>> [email protected]
> > >>> http://lists.wikia.com/mailman/listinfo/wikia-l
> > >>>
> > >>>
> > >> _______________________________________________
> > >> Wikia-l mailing list
> > >> [email protected]
> > >> http://lists.wikia.com/mailman/listinfo/wikia-l
> > >>
> > >>
> > > _______________________________________________
> > > Wikia-l mailing list
> > > [email protected]
> > > http://lists.wikia.com/mailman/listinfo/wikia-l
> > >
> > >
> > _______________________________________________
> > Wikia-l mailing list
> > [email protected]
> > http://lists.wikia.com/mailman/listinfo/wikia-l
> >
> _______________________________________________
> Wikia-l mailing list
> [email protected]
> http://lists.wikia.com/mailman/listinfo/wikia-l
>
--
"I had a handle on life, but then it broke"
_______________________________________________
Wikia-l mailing list
[email protected]
http://lists.wikia.com/mailman/listinfo/wikia-l
