Difference between revisions of "Talk:Caretaker.pl"
From Organic Design wiki
(SQL query to obtain the owner of an article) |
m |
||
| Line 4: | Line 4: | ||
*Categorise items into eg. [[:Category:Articles created by xxx]] | *Categorise items into eg. [[:Category:Articles created by xxx]] | ||
::include the <tt>cur_is_new,cur_user_text</tt> columns in the <tt>SELECT FROM cur</tt> query in the main loop, | ::include the <tt>cur_is_new,cur_user_text</tt> columns in the <tt>SELECT FROM cur</tt> query in the main loop, | ||
| − | ::if <tt>cur_is_new</tt> | + | ::if <tt>cur_is_new=0</tt>, then <tt>SELECT old_user_text FROM old WHERE old_title='$title' ORDER BY old_timestamp LIMIT 1;</tt> |
*Categorise items into [[:Category:Articles linking to external news]] | *Categorise items into [[:Category:Articles linking to external news]] | ||
*Change http://[www.]organicdesign.co.nz to {{SERVER}} | *Change http://[www.]organicdesign.co.nz to {{SERVER}} | ||
Revision as of 10:10, 30 December 2006
I added the caretaker so we can add tidying and categorisation rules which are applied to all articles on a daily basis. This script is declared on startup of Bender and its main function, caretaker() is called at 6am each morning. It loops slowly through all articles over a period of a a couple of hours so there's no noticable reduction of resource during the process.
Current and propsed rules
- Categorise items into eg. Category:Articles created by xxx
- include the cur_is_new,cur_user_text columns in the SELECT FROM cur query in the main loop,
- if cur_is_new=0, then SELECT old_user_text FROM old WHERE old_title='$title' ORDER BY old_timestamp LIMIT 1;
- Categorise items into Category:Articles linking to external news
- Change http://[www.]organicdesign.co.nz to {{SERVER}}
- Change lib, libs to library, libraries
Renumber headings so they start at =(done)domain-names: articles(done)- date: articles
- Also, by months, year day of week....
- cat articles using embed
- cat articles using apply
cat articles containing maths(done)- cat articles using document-code table
- change ampersand articles to "and" (or get & working instead)
- cat peers and change eg. peer/bender cat to just bender
common typo's, eg implementation to implementation(done)- move cat links to start and format in a line (done)
- fix sigs?
XML: remove empty elements(done)- orphans: remove xml orphans
change redundant applies to embeds(done)remove redundant properties elements(done)- change <tt>[[... to svens template
Discussion
how bout marking the edits as minor? --Phalseid 18:36, 24 Oct 2006 (NZDT)
- Done - I'll just wait until it runs tomorrow to see if its working --Nad 18:53, 24 Oct 2006 (NZDT)



