Citizendium Forums
May 23, 2012, 09:01:39 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: POSTING RULES FOR MAIN CZ BOARDS: (1) The CZ Forums are Citizens-only (a "Citizen" is a Citizendium member). Non-Citizens may use only the "Non-Citizen comments" board, but still must register before posting (it's easy!). Non-Citizen posts elsewhere will be summarily deleted. (2) All must use their own real names. To edit your displayed name, click on Profile > Account Related Settings. (3) Citizens must link to their CZ user pages. To edit your signature, click on Profile > Forum Profile Information.
Click here to return to the wiki
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: showing non-tagged articles  (Read 7733 times)
Joe Quick
Forum Regular
****
Posts: 1530


« on: March 16, 2007, 08:32:50 PM »

Is there a way to write code for a page that would show all of the articles that are not in a particular category?  For example, all articles that are not checklisted?  This would help us maintain the article checklists after the initial push with the Big Cleanup and maybe allow us to dump [[Category:CZ Live]].
Logged

Jason "Electrawn" Potkanski
Forum Communicator
***
Posts: 158


I eat vandals like treats.


« Reply #1 on: March 17, 2007, 06:55:54 PM »

Short Answer: No.

Longer Answer: Categories are stored inside the text of the article itself..to search down categories requires intensive, wasteful CPU time.

-jtp
Logged
Joe Quick
Forum Regular
****
Posts: 1530


« Reply #2 on: March 17, 2007, 11:46:17 PM »

Okay, thanks.  I figured something like that would already be in place if it were practical, but I had to ask anyway Wink.
Logged

Joe Quick
Forum Regular
****
Posts: 1530


« Reply #3 on: April 04, 2007, 01:32:14 PM »

Okay, how about this?

A tool that will compare the contents of two different categories.  So, for instance, I could compare the contents of [[Category:Checklisted articles]] against [[Special:Allpages]]

Would this also eat up cpu time?
Logged

Zachary Pruckowski
Forum Regular
****
Posts: 933


« Reply #4 on: April 04, 2007, 02:52:25 PM »

Relevant manual page

It looks possible to do it that way.  We'd have a pile of cur_id values, which I imagine could be translated to page_id values, from when we could use the page table to get names.

But I am not a database expert.
Logged

a.a.s.
Forum Communicator
***
Posts: 152


« Reply #5 on: May 15, 2007, 10:18:46 AM »

I guess I have a python script for it (python is easy to use; it is included in most Linux distributions and may be installed on many platforms (in particular, a quick installation on windows is available). For more details see www.python.org).
In fact, the script allows to determine the intersection of or the difference between any two categories (Special:Allpages included). So if you are interested in it, please send me a personal mail on this forum (just click to see my profile and scroll down to Additional Info). I'd readily share it but I don't think that publishing the code would be the best solution now.
Logged

a.a.s.
Forum Communicator
***
Posts: 152


« Reply #6 on: May 16, 2007, 02:08:03 AM »

Forgotten to add that now we have [[CZ:Unchecklisted Articles]], see here .
Logged

Joe Quick
Forum Regular
****
Posts: 1530


« Reply #7 on: May 19, 2007, 01:45:36 PM »

Forgotten to add that now we have [[CZ:Unchecklisted Articles]], see here .

I saw that.  Very cool.  And exactly what I had in mind. Wink
Logged

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.13 | SMF © 2006-2011, Simple Machines LLC Valid XHTML 1.0! Valid CSS!