Wikitech-l March 2002

wikitech-l@lists.wikimedia.org

18 participants
53 discussions

special_asksql.php removed
by Axel Boldt 31 Mar '02

31 Mar '02

>> Would it be safe to limit use to "select" statements for >> non-is_developer folks, so the curious could still explore the >> database? > My thoughts exactly. I'd even consider making sql-selecting > available to any registered user (not just is_sysop or is_developer). Or to anybody, with an SQL server that's open to the internet for reading. Because of load reasons, we probably shouldn't do that with the live SQL server though. I would expect that, once we have … [View More]

1 0

special_asksql.php removed
by Jimmy Wales 31 Mar '02

31 Mar '02

In the interests of security, I removed special_asksqp.php from the live server. I didn't change anything else, so the link still appears for is_sysop, but is an error page now. I think we should bring this function back, but... 1. Passwords should be encrypted in the database. In this way no one, not even me, can see them. 2. This function should be an is_developer function, so that we can freely hand out sysops even to people who might not know SQL at all -- or, like me, know just … [View More]

3 4

Security issue
by lee＠piclab.com 30 Mar '02

30 Mar '02

If we're going to be giving "sysop" status fairly liberally (and I don't disagree with that as a policy), you might consider still making at least one concession to database security: currently, anyone with sysop access can query the database and see users' passwords in plaintext. People tend to use the same password for several things--so it wouldn't surprize me at all if I were able to log onto Magnus's email account or something. It shouldn't be too much work to use some minimal encryption … [View More]

3 2

rebuildLinks.php
by Jimmy Wales 29 Mar '02

29 Mar '02

I left rebuildLinks.php running from the command line last night. It looked good when I left. This morning, I found this: 26476 of 45991: New_Zealand/People 26477 of 45991: New_Zealand/Transnational_issues 26478 of 45991: New_Zealand/Transportation 26479 of 45991: New_Zealand_English 26480 of 45991: New_directions_and_movements 26481 of 45991: New_liberalism 26482 of 45991: New_materials_(painting) 26483 of 45991: New_moon 26484 of 45991: New_moon/details 26485 of 45991: New_testament 26486 … [View More]

2 1

{{NUMBEROFARTICLES}}
by Jimmy Wales 28 Mar '02

28 Mar '02

Is this variable properly updated on the front page?

2 3

Re: [Wikipedia-l] is_sysop
by Jimmy Wales 28 Mar '02

28 Mar '02

Brion wrote (over on wikipedia-l): > * Ability to run SQL queries on the database. Not useful unless you > really know what you're doing. Gee, this sounds dangerous. Perhaps we should have is_developer, and restrict this command to developers? --Jimbo

2 1

Marian layout
by Magnus Manske 26 Mar '02

26 Mar '02

Hi all, I just liked the layout suggestion from Marian (http://www.wikipedia.com/wiki/user:Marian) so much that I couldn't resist to check in a variant as a skin to the CVS archive. It has the (preliminary) name "Cologne Blue", as both Marian and I are living in Cologne, and the layout uses some blue ;) Please check it out and help me. There are some things I didn't finish: Some links (marked with a "!"), part of the links are not using the language files, … [View More]

4 4

sample database dump with new schema
by Axel Boldt 25 Mar '02

25 Mar '02

Hi, I took the old database test dump http://wikipedia.sourceforge.net/fpw/newiki.sql.gz and applied the database scheme changes from updSchema.sql and updLinks.php to create a new dump which conforms with our current database scheme, so that new hackers have something to play with. Where can I upload it? Axel

3 2

Minor conversion script issue
by Tomasz Wegrzanowski 22 Mar '02

22 Mar '02

Conversion script adds link to parent page from subpage: Foo/Bar: <text of subpage> See also: Foo Where is this q{See also} text ? It should be q{Zobacz też} That's the only problem I could find. Btw, Jimbo or whoever else has access to wikipedia.com: when will you setup test site for Polish PHP wikipedia ?

2 1

Postgre Support
by Adam Theo 22 Mar '02

22 Mar '02

Hello, all. I just began looking into using the Wikipedia software for my thinktank website, Theoretic Solutions [ www.theoretic.com ]. I had been staying away from Wikis despite their clear benefit to managing lots of information from different people because of the awkward CamelCase-ing. However, When I stumbled upon Wikipedia's new PHP script, I realized it was perfect. Unfortunately, it requires MySQL, whereas I have Postgre installed. Is there any way to add Postgre support easily enough, … [View More]

3 2

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Wikitech-l March 2002