subject: [Wikitech-l] response times

in_reply_to: <1021676929.5445.3.camel@rdaneel.moisty.org>; from brion@pobox.com on Fri, May 17, 2002 at 04:08:47PM -0700

body:
Sure.  The files are attached.

Jason

Brion L. VIBBER wrote:

> On ven, 2002-05-17 at 15:40, Jason Richey wrote:
> > I have re-imported the data from the usemod-eo wiki to the php-eo
> > wiki.  Let me know if it looks better...
>
> Nope, same problem: page titles and contents have cx, gx, ux, etc
> instead of accented characters.
>
> Can I see the wikiLocalSettings.php and convertWiki2SQL.php and make
> sure they're right? It's still working fine on my machine.
>
> -- brion vibber (brion @ pobox.com)

--
"Jason C. Richey" <jasonr at bomis.com>

-------------- next part --------------
<?
# For local site-specific settings. The default configuration is set up
# in wikiSettings.php; DO NOT makes changes there. The settings here
# override the settings in that file.

## Language to use. Default is "en" (English).
# $wikiLanguage = "pl"; # Polish
# $wikiLanguage = "de"; # Deutsch (German)
$wikiLanguage = "eo"; # Esperanto

$useCachedPages = false; # Disable page cache
# $wikiReadOnly = true; # Don't allow page editing

$wikiSQLServer = "wiki_eo" ; # The name of the database, actually...
$wikiThisDBserver = "127.0.0.1" ;
$wikiThisDBuser = "wiki" ;
$wikiThisDBpassword = "actualpassword" ;

?>
-------------- next part --------------
#!/usr/bin/php -q
<?
$THESCRIPT = "wiki.phtml" ;
#include ( "./specialPages.php" ) ;
include ( "./databaseFunctions.php" ) ;
include ( "./basicFunctions.php" ) ;
include ( "./wikiTitle.php" ) ;
include ( "./wikiPage.php" ) ;
include ( "./wikiUser.php" ) ;
include ( "./wikiSettings.php" ) ;
include ( "./wikiLocalSettings.php" ) ;

## Language-dependant variables!

## Default/English:
$wikiTalk = "Talk";
$fieldSeparator = "\xb3" ;
$wikiSeeAlso = "See also" ;
$wikiConversionScript = "conversion script" ;
$wikiAutomatedConversion = "Automated conversion" ;
function recodeCharsetStub ( $text ) {
	# Temporarily, we are still using ISO-8859-1 in English
	return $text;
	}
function recodeCharsetLatin1 ( $text ) {
	# To convert ISO-8859-1 to UTF-8
	return encode_utf8 ( $text ) ;
	}
	$recodeCharset = recodeCharsetStub ;
	#$recodeCharset = recodeCharsetLatin1 ;

## Esperanto:
if ( $wikiLanguage =="eo" ) {
$wikiTalk = "Priparolu" ;
$wikiSeeAlso = "Legu anka\xc5\xad" ;
$wikiConversionScript = "konvertilo" ;
$wikiAutomatedConversion = "A\xc5\xadtomata konvertado" ;
function recodeCharsetEo ( $text ) {
	  $x = array(
	  	"Cx", "cx",  "CX", "cX",
		"Gx", "gx",  "GX", "gX",
		"Hx", "hx",  "HX", "hX",
		"Jx", "jx",  "JX", "jX",
		"Sx", "sx",  "SX", "sX",
		"Ux", "ux",  "UX", "uX");
	  $u = array(
		"\xc4\x88", "\xc4\x89",  "\xc4\x88", "\xc4\x89",
		"\xc4\x9c", "\xc4\x9d",  "\xc4\x9c", "\xc4\x9d",
		"\xc4\xa4", "\xc4\xa5",  "\xc4\xa4", "\xc4\xa5",
		"\xc4\xb4", "\xc4\xb5",  "\xc4\xb4", "\xc4\xb5",
		"\xc5\x9c", "\xc5\x9d",  "\xc5\x9c", "\xc5\x9d",
		"\xc5\xac", "\xc5\xad",  "\xc5\xac", "\xc5\xad");
	return str_replace ( $x , $u , $text ) ;
	}
	$recodeCharset = recodeCharsetEo ;
}

## French
if ( $wikiLanguage == "fr" ) {
	$wikiTalk = "Discuter" ;
	$recodeCharset = recodeCharsetLatin1 ;
	}

## Polish:
if ( $wikiLanguage == "pl" ) {
$wikiTalk = "Dyskusja" ;
$fieldSeparator = "\xff";
function RecodeCharsetPl ( $text ) {
	# Convert iso8859-2 to UTF-8
	# In a happy world, we could use iconv for this
	$l2u8 = array ( "\xA0" => "\xc2\xa0", "\xA1" => "\xc4\x84", "\xA2" => "\xcb\x98", "\xA3" => "\xc5\x81", "\xA4" => "\xc2\xa4", "\xA5" => "\xc4\xbd",
	"\xA6" => "\xc5\x9a", "\xA7" => "\xc2\xa7", "\xA8" => "\xc2\xa8", "\xA9" => "\xc5\xa0", "\xAA" => "\xc5\x9e", "\xAB" => "\xc5\xa4",
	"\xAC" => "\xc5\xb9", "\xAD" => "\xc2\xad", "\xAE" => "\xc5\xbd", "\xAF" => "\xc5\xbb", "\xB0" => "\xc2\xb0", "\xB1" => "\xc4\x85",
	"\xB2" => "\xcb\x9b", "\xB3" => "\xc5\x82", "\xB4" => "\xc2\xb4", "\xB5" => "\xc4\xbe", "\xB6" => "\xc5\x9b", "\xB7" => "\xcb\x87",
	"\xB8" => "\xc2\xb8", "\xB9" => "\xc5\xa1", "\xBA" => "\xc5\x9f", "\xBB" => "\xc5\xa5", "\xBC" => "\xc5\xba", "\xBD" => "\xcb\x9d",
	"\xBE" => "\xc5\xbe", "\xBF" => "\xc5\xbc", "\xC0" => "\xc5\x94", "\xC1" => "\xc3\x81", "\xC2" => "\xc3\x82", "\xC3" => "\xc4\x82",
	"\xC4" => "\xc3\x84", "\xC5" => "\xc4\xb9", "\xC6" => "\xc4\x86", "\xC7" => "\xc3\x87", "\xC8" => "\xc4\x8c", "\xC9" => "\xc3\x89",
	"\xCA" => "\xc4\x98", "\xCB" => "\xc3\x8b", "\xCC" => "\xc4\x9a", "\xCD" => "\xc3\x8d", "\xCE" => "\xc3\x8e", "\xCF" => "\xc4\x8e",
	"\xD0" => "\xc4\x90", "\xD1" => "\xc5\x83", "\xD2" => "\xc5\x87", "\xD3" => "\xc3\x93", "\xD4" => "\xc3\x94", "\xD5" => "\xc5\x90",
	"\xD6" => "\xc3\x96", "\xD7" => "\xc3\x97", "\xD8" => "\xc5\x98", "\xD9" => "\xc5\xae", "\xDA" => "\xc3\x9a", "\xDB" => "\xc5\xb0",
	"\xDC" => "\xc3\x9c", "\xDD" => "\xc3\x9d", "\xDE" => "\xc5\xa2", "\xDF" => "\xc3\x9f", "\xE0" => "\xc5\x95", "\xE1" => "\xc3\xa1",
	"\xE2" => "\xc3\xa2", "\xE3" => "\xc4\x83", "\xE4" => "\xc3\xa4", "\xE5" => "\xc4\xba", "\xE6" => "\xc4\x87", "\xE7" => "\xc3\xa7",
	"\xE8" => "\xc4\x8d", "\xE9" => "\xc3\xa9", "\xEA" => "\xc4\x99", "\xEB" => "\xc3\xab", "\xEC" => "\xc4\x9b", "\xED" => "\xc3\xad",
	"\xEE" => "\xc3\xae", "\xEF" => "\xc4\x8f", "\xF0" => "\xc4\x91", "\xF1" => "\xc5\x84", "\xF2" => "\xc5\x88", "\xF3" => "\xc3\xb3",
	"\xF4" => "\xc3\xb4", "\xF5" => "\xc5\x91", "\xF6" => "\xc3\xb6", "\xF7" => "\xc3\xb7", "\xF8" => "\xc5\x99", "\xF9" => "\xc5\xaf",
	"\xFA" => "\xc3\xba", "\xFB" => "\xc5\xb1", "\xFC" => "\xc3\xbc", "\xFD" => "\xc3\xbd", "\xFE" => "\xc5\xa3", "\xFF" => "\xcb\x99" ) ;
	return strtr ( $text , $l2u8 ) ;
	}
	$recodeCharset = recodeCharsetPl ;
}

## Spanish
if ( $wikiLanguage == "es" ) {
	$wikiTalk = $recodeCharset ( "Discusi?n" ) ;
	$recodeCharset = recodeCharsetLatin1 ;
	}

## Where to get the old usemod database files from:
#$rootDir = "/home/groups/w/wi/wikipedia/htdocs/fpw/wiki-de/lib-http/db/wiki/page/" ;
#$rootDir = "/home/manske/wiki/lib-http/db/wiki/page/" ;
$rootDir = "/home/wiki-eo/lib-http/db/wiki/page/" ;
#$rootDir = "/tmp/home/wiki-pl/wiki/db/page/" ;
#$rootDir = "/tmp/home/wiki-eo/lib-http/db/wiki/page/" ;

$oldid = 100; # Need unique identifiers for page histories; increment each time we use it.

	$FS = $fieldSeparator ;
	$FS1 = $FS."1" ;
	$FS2 = $FS."2" ;
	$FS3 = $FS."3" ;

function scanText2 ( $fn ) {
	global $fieldSeparator , $FS , $FS1 , $FS2 , $FS3 ;
	$ret = "" ;

	#CONSTANTS
	#$FS = "?" ;

	#READING FILE
	$t = array () ;
	$fd = fopen ( $fn , "r" ) ;
	if ( $fd == false ) return "There was an error converting this file : file not found." ;
	while (!feof($fd)) {
		$buffer = fgets($fd, 99999);
		array_push ( $t , $buffer ) ;
		}
	fclose ( $fd ) ;

	#array_pop ( $t ) ;
	$t = implode ( "" , $t ) ;
/*
	#SPLIT PAGE
	$sp = explode ( $FS1 , $t ) ;

	$x = array_pop ( $sp ) ;
	$sections = explode ( $FS2 , $x ) ;
	foreach ( $sections as $y ) {
		$text = explode ( $FS3 , $y ) ;
		foreach ( $text as $z ) {
			if ( $ret == "text" ) return $z ;
			$ret = $z ;
			}
		}

	return $ret ;
*/
	$page = splitHash ( $FS1 , $t ) ;
	$section = splitHash ( $FS2 , $page["text_default"] ) ;
	$text = splitHash ( $FS3 , $section["data"] ) ; # text_default

	return array ( "text" => $text["text"] , "summary" => $text["summary"] ,
		"minor" => $text["minor"] , "ts" => $section["ts"] ,
		"username" => $section["username"] , "host" => $section["host"] ) ;
	}

function getFileName ( $an ) {
	global $rootDir ;
	$ret = $rootDir ;
	$sd = ucfirst ( substr ( $an , 0 , 1 ) ) ;
	if ( $sd < "A" or $sd > "Z" ) $sd = "other" ;
	$ret .= "$sd/".ucfirst($an).".db" ;
	return $ret ;
	}

function fixLinks ( $s ) {
	global $npage , $ll , $ull , $allTopics ;
	global $wikiTalk , $wikiSeeAlso ;

	$talk = explode ( "/" , $npage->secureTitle ) ;
	if ( count($talk)==2 and strtolower($talk[1])==strtolower($wikiTalk) ) $isTalkPage = true ;
	else $isTalkPage = false ;

	# Automatic backlink from a subpage to a "main" page
	$backLink = "" ;
	if ( $isTalkPage == false AND count ( $talk ) == 2 ) {
		$backLink = ucfirst ( $talk[0] ) ;
		$backLink = str_replace ( "_" , " " , $backLink ) ;
		}

	# Automatic subpages, one last time...
	$s = ereg_replace ( "([\n ])/([A-Z][a-zA-Z0-9]+)" , "\\1[[/\\2|/\\2]]" , $s ) ;

	$s = " $s" ;
	$a = explode ( "[[" , $s ) ;
	$s = array_shift ( $a ) ;
	foreach ( $a as $x ) {
		$b = explode ( "]]" , $x , 2 ) ;
		$s .= "[[" ;
		if ( count ( $b ) == 1 ) $s .= $x ;
		else {
			$c = explode ( "|" , $b[0] ) ;
			$link = $c[0] ;
			if ( substr ( $link , 0 , 1 ) == "/" ) { # Converting subpages
				$u = explode ( "/" , $npage->title ) ;
				if ( count ( $c ) == 1 ) array_push ( $c , substr ( $link , 1 ) ) ;
				$link = $u[0].$link ;
				}
			if ( ucfirst ( str_replace ( "_" , " " , $link ) ) == $backLink ) $backLink = "" ; # No backlink necessary
			$n = str_replace ( " " , "_" , $link ) ;
			$n = ucfirst ( $n ) ;
			$m = substr ( $n , 0 , 1 ) ;
			if ( $m < "A" or $m > "Z" ) $m = "0" ;
			if ( in_array ( $n , $allTopics[$m] ) )  array_push ( $ll , $n ) ;
			else array_push ( $ull , $n ) ;

			# Re-linking /Talk pages to talk:
			$talk = explode ( "/" , $link ) ;
			if ( $talk[0] == "HomePage" ) {
				$talk[0] = "Main_Page" ;
				$link = $talk[0] ;
				if ( count ( $talk ) == 2 ) $link .= "/".$talk[1] ;
				}
			if ( count ( $talk ) == 2 and strtolower($talk[1]) == strtolower($wikiTalk) ) $link = strtolower($wikiTalk).":".$talk[0] ;
			else if ( $isTalkPage ) {
				if ( count ( $c ) == 1 ) array_push ( $c , $link ) ;
				$link = ":".$link ;
				}

			$s .= $link ;
			if ( count ( $c ) == 2 ) $s .= "|".$c[1] ;
			$s .= "]]".$b[1] ;
			}
		}
	if ( $backLink != "" ) $backLink = "\n:''$wikiSeeAlso :'' [[$backLink]]" ;
	return substr ( $s , 1 ).$backLink ;
	}

function convertText ( $s ) {
	global $recodeCharset ;
	/*
	$s = str_replace ( "\\'" , "'" , $s ) ;
	$s = str_replace ( "\\\"" , "\"" , $s ) ;
	$s = str_replace ( "\"" , "\\\"" , $s ) ;
	$s = str_replace ( "'" , "\\'" , $s ) ;
	*/
	$s = strtr ( $recodeCharset ( $s ) ,
		array ( "\\" => "\\\\" , "\"" => "\\\"" , "'" => "\\'" ) ) ;

	$a = spliti ( "<nowiki>" , $s ) ;
	$s = fixLinks ( array_shift ( $a ) ) ;
	foreach ( $a as $x ) {
		$b = spliti ( "</nowiki>" , $x , 2 ) ;
		if ( count ( $b ) == 1 ) $s .= "<nowiki>".$x ;
		else $s .= "<nowiki>".$b[0]."</nowiki>".fixLinks($b[1]);
		}

	return $s ;
	}

function splitHash ( $sep , $str ) {
	$temp = explode ( $sep , $str ) ;
	$ret = array () ;
	for ( $i = 0; $i+1 < count ( $temp ) ; $i++ ) {
		$ret[$temp[$i]] = $temp[++$i] ;
		}
	return $ret ;
	}

function makeSafe ( $str ) {
	# Escape strings and convert character set so we can insert text into the db
	global $recodeCharset ;
	return strtr ( $recodeCharset ( $str ) ,
		array ( "\\" => "\\\\" , "\"" => "\\\"" , "'" => "\\'" ) ) ;
	}

function getHistory ( $title , $st) {
	global $fieldSeparator , $FS , $FS1 , $FS2 , $FS3 , $oldid , $recodeCharset ;
	$f = preg_replace ( "/\/page\/(.*)\.db$/" , "/keep/\$1.kp" , getFileName ( $title ) ) ;
	if ( !file_exists ( $f ) ) return "" ;

	$fc = file ( $f ) ;
	$keptlist = explode ( $FS1 , implode ( "\n" , $fc ) ) ;
	array_shift ( $keptlist ) ;

	$lastoldid = "0"; $sql = array () ;

	foreach ( $keptlist as $rev ) {
		$section = splitHash ( $FS2 , $rev ) ;
		$text = splitHash ( $FS3 , $section["data"] ) ;

		$user = makeSafe ( $section["username"] ? $section["username"] : $section["host"] ) ;

		if ( $text["text"] && $text["minor"] != "" && ( $section["ts"]*1 > 0 ) ) {
			array_push ( $sql , "INSERT INTO old (old_title,old_text,old_comment,old_user,old_user_text,old_old_version,old_timestamp,old_minor_edit) "
			. "VALUES (\"$st\",\"" . makeSafe($text["text"]) . "\",\"" . makeSafe($text["summary"]) . "\","
			. "0,\"$user\",$lastoldid,FROM_UNIXTIME(" . $section["ts"] . ")," . $text["minor"] . ")" ) ;

			$lastoldid = "LAST_INSERT_ID()" ;
		} else {
			echo " (note: skipped a bad old revision)";
			}

		}
	return $sql ;
	}

function storeInDB ( $title , $text ) {
	global $of , $npage , $ll , $ull , $wikiTalk , $recodeCharset , $oldid , $wikiAutomatedConversion , $wikiConversionScript ;
	global $historyOnly , $noHistory , $connection ;
	$ll = array () ;
	$ull = array () ;
	$title = str_replace ( "\\'" , "'" , $title ) ;
	$title = str_replace ( "\\\"" , "\"" , $title ) ;
	$npage = new wikiPage ;
	$npage->title = $recodeCharset ( $title ) ;
	$npage->makeAll () ;
	$thetext = convertText ( $text["text"] ) ;
	#$ll1 = implode ( "\n" , $ll ) ;
	#$ull1 = implode ( "\n" , $ull ) ;
	$st = $npage->secureTitle ;

	# Move talk pages to talk namespace
	$talk = explode ( "/" , $st ) ;
	if ( $talk[0] == "HomePage" ) { $talk[0] = "Main_Page" ; $st = $talk[0] ; }
	if ( count ( $talk ) == 2 and $talk[1] == $wikiTalk ) $st = $wikiTalk.":".$talk[0] ;
	if ( count ( $talk ) == 2 and $talk[1] == strtolower($wikiTalk) ) return ;

	$lastoldid = "0"; $sql = array () ;
if ( ! $noHistory ) { # for testing { ****
	$sql = getHistory ( $title , $st ) ;
	if ( ! $sql ) $sql = array () ;
	if (count($sql)) $lastoldid = "LAST_INSERT_ID()" ;

	# Insert untouched version as the last in the history chain
	$user = makeSafe ( $text["username"] ? $text["username"] : $text["host"] ) ;
	if ( $text["text"] && $text["minor"] != "" && ( $text["ts"]*1 > 0 ) ) {
		array_push ( $sql , "INSERT INTO old (old_title,old_text,old_comment,old_user,old_user_text,old_old_version,old_timestamp,old_minor_edit) "
		. "VALUES (\"$st\",\"" . makeSafe($text["text"]) . "\",\"" . makeSafe($text["summary"]) . "\","
		. "0,\"$user\",$lastoldid,FROM_UNIXTIME(" . $text["ts"] . ")," . $text["minor"] . ")" );
		$lastoldid = "LAST_INSERT_ID()" ;
	} else {
		echo " (skipping last old revision - $text[ts] $text[minor] $text[text])";
		}
} # for testing **** }

	if ( $historyOnly ) {
		$sqlx = "SELECT cur_old_version FROM cur WHERE cur_title=\"$st\"" ;
		$result = mysql_query ( $sqlx , $connection ) ;
		echo mysql_error () ;
		if ( $s = mysql_fetch_object ( $result ) ) {
			$oid = $s->cur_old_version ;
			mysql_free_result ( $result ) ;
		} else $oid = 0 ;

		if ( $oid )
			array_push ( $sql , "UPDATE old SET old_old_version=LAST_INSERT_ID(),old_timestamp=old_timestamp WHERE old_old_version=0 AND old_title=\"$st\"" ) ;
		else
			array_push ( $sql , "UPDATE cur SET cur_old_version=LAST_INSERT_ID(),cur_timestamp=cur_timestamp WHERE cur_title=\"$st\"" ) ;

		foreach ( $sql as $line ) {
			mysql_query ( $line , $connection ) ;
			echo mysql_error ();
			}
	} else {
	$sql = implode ( ";\n" , $sql ) ;
	$sql .= ";\nINSERT INTO cur (cur_title,cur_ind_title,cur_text,cur_comment,cur_user,cur_user_text,cur_old_version,cur_minor_edit) VALUES ";
	$sql .= "(\"$st\",\"$st\",\"$thetext\",";
	$sql .= "\"$wikiAutomatedConversion\",0,\"$wikiConversionScript\",$lastoldid,1);\n" ;
	foreach ( $ll as $l ) {
		$sql .= "INSERT INTO linked (linked_from,linked_to) VALUES (\"$st\",\"$l\");\n";
		}
	foreach ( $ull as $l ) {
		$sql .= "INSERT INTO unlinked (unlinked_from,unlinked_to) VALUES (\"$st\",\"$l\");\n";
		}
	fwrite ( $of , $sql ) ;
	}
	}

function getTopics ( $dir ) {
	$ret = array () ;

	$mydir = opendir($dir);
	while ($entry = readdir($mydir)) {
		if ($entry != '.' && $entry != '..') {
			if ( is_dir ( "$dir/$entry" ) ) {
				$a = getTopics ( "$dir/$entry" ) ;
				foreach ( $a as $x ) array_push ( $ret , "$entry/$x" ) ;
			} else {
				if (substr ($entry, strlen ( $entry ) - 3, 3) == '.db') {
				    $x = substr ( $entry , 0 , strlen ( $entry ) - 3 ) ;
				    array_push ( $ret , $x ) ;
				} else {
				    print "Warning: File \"$entry\" doesn't seem to contain an article
\n" ;
				}
			}
		}
	}
	closedir($mydir);

	return $ret ;
	}

function dir2DB ( $letter )  {
	global $rootDir ;
	$a = getTopics ( "$rootDir/$letter" ) ;
	print "Reading :\n" ;
	foreach ( $a as $an ) {
		$fl = substr ( $an , 0 , 1 ) ;
		if ( $fl >= "a" and $fl <= "z" ) {
			print "IGNORING LOWERCASE FIRST FILE : $an\n" ;
		} else {
			print "$an" ;
			$fn = getFileName ( $an ) ;
			storeInDB ( $an , scantext2 ( $fn ) ) ;
			print "\n" ;
			}
		}
	print "\n" ;
	}

function getAllTopics () {
	global $allTopics , $rootDir , $wikiTalk;
	global $recodeCharset ;
	$allTopics = array () ;
	for ( $c = 65 ; chr($c) <= "Z" ; $c++ ) {
		$allTopics[chr($c)] = getTopics ( "$rootDir/".chr($c) ) ;
		for ( $i = 0; $i < count($allTopics[chr($c)]) ; $i++ )
			$allTopics[chr($c)][$i] = $recodeCharset ( $allTopics[chr($c)][$i] ) ;
		}
	$allTopics["0"] = getTopics ( "$rootDir/other" ) ;
	for ( $i = 0; $i < count($allTopics["0"]) ; $i++ )
		$allTopics["0"][$i] = $recodeCharset ( $allTopics["0"][$i] ) ;
	}

# MAIN PROGRAM
	global $rootDir , $historyOnly , $connection ;

	$historyOnly = in_array ( "--history" , $argv ) ; # To import only old histories into database
	$noHistory = in_array ( "--nohistory" , $argv ) ; # For testing

	set_time_limit ( 0 ) ; # Enough time for this script...

	global $ll , $ull , $allTopics ;
	$ll = array () ;
	$ull = array () ;
	getAllTopics () ;

	global $l , $of ;
	if ( ! $historyOnly ) {
		$of = fopen ( "./newiki.sql" , "w" ) ;
		$nw = file ( "./wikipedia.sql" ) ;
		foreach ( $nw as $line ) fwrite ( $of , $line ) ;
		fwrite ( $of , "DELETE FROM cur WHERE cur_title NOT LIKE \"%:%\";\n" ) ;
		fwrite ( $of , "DELETE FROM cur WHERE cur_title LIKE \"$wikiTalk:%\";\n" ) ;
	} else {
		# We need a live database to check against to import the histories
		//establish user connection
		$connection = mysql_pconnect($wikiThisDBserver , $wikiThisDBuser , $wikiThisDBpassword )
			or die("Could not get connection to database server.") ;
		//open up database
		mysql_select_db ($wikiSQLServer , $connection)
			or die("Could not select database: $wikiSQLServer");
		}
	do {
		if ( !isset ( $l ) ) $l = 65 ;
		if ( $l == "other" ) $letter = "other" ;
		else $letter = chr ( $l ) ;
		$nl = $l+1 ;
		if ( $letter == "Z" ) $nl = "other" ;
		$l = $nl ;
		dir2DB ( $letter ) ;
	} while ( $letter != "other" ) ;
	if (isset ( $of )) fclose ( $of ) ;

	print "FINISHED!\n" ;
?>


list: wikipedia-l

source: pipermail-mbox

from_name: General Wesc (LKBM)

subject: [Wikipedia-l] robots and spiders

body:
The Cunctator wrote:
> On 5/17/02 3:26 PM, "Chuck Smith" <msochuck at yahoo.com> wrote:
[Snip]
>>
>>I COMPLETELY disagree with this.  Let the robots crawl
>>everything.  It's better that someone finds one of our
>>Talk or User pages and cruises on over to our main
>>site than to simply find a completely website!
>>
>>Chuck
>>
>
> I agree with Chuck, strongly.
>
> [Wikipedia-l]
> To manage your subscription to this list, please go here:
> http://www.nupedia.com/mailman/listinfo/wikipedia-l
>

I have to wonder though...if a spider goes to Recent Changes and then to
"Last 5000 changes" (and last 90 days, and last 30 days, and last 2500
changes, and last 1000 changes, and every such combination) it seems to
me the server load could get pretty high. Perhaps talk pages should be
spidered, but not recent changes or the history (diff/changes).

--
General Wesc,
http://wescnet.cjb.net/


list: wikitech-l

from_name: Brion L. VIBBER

subject: [Wikitech-l] response times

body:
On ven, 2002-05-17 at 15:40, Jason Richey wrote:
> I have re-imported the data from the usemod-eo wiki to the php-eo
> wiki.  Let me know if it looks better...

Nope, same problem: page titles and contents have cx, gx, ux, etc
instead of accented characters.

Can I see the wikiLocalSettings.php and convertWiki2SQL.php and make
sure they're right? It's still working fine on my machine.

-- brion vibber (brion @ pobox.com)


from_name: Jason Richey

subject: [Wikitech-l] response times

in_reply_to: <1021680473.5712.0.camel@rdaneel.moisty.org>; from brion@pobox.com on Fri, May 17, 2002 at 05:07:52PM -0700

body:
Here's some (trimmed) output:

X-Powered-By: PHP/4.0.4pl1
Content-type: text/html

--Using Esperanto conversion settings--
converting: "AIM" -> "AIM"

...

converting: "Argxenta_Libro" -> "Argxenta_Libro"
converting: "Algxerio" -> "Algxerio"
converting: "Azerbajgxano" -> "Azerbajgxano"
converting: "Agxario" -> "Agxario"
converting: "Angxevo" -> "Angxevo"
converting: "Angxelo_KRIRUGXO" -> "Angxelo_KRIRUGXO"
converting: "Cxefpagxo" -> "Cxefpagxo"
converting: "Dekana_Pregxejo_De_Sankta_Maria_Magdalena" ->
"Dekana_Pregxejo_De_Sankta_Maria_Magdalena"
converting: "Esperanto-Renkontigxo" -> "Esperanto-Renkontigxo"
converting: "Figxioj" -> "Figxioj"

That's bad news...  But it does appear that we are running an older
PHP...

Jason

Brion L. VIBBER wrote:

> On ven, 2002-05-17 at 16:02, Jason Richey wrote:
> > Sure.  The files are attached.
>
> Hmm... Shouldn't be any problem. I tried substituting in those two
> files, everything still works.
>
> Try the attached convertWiki2SQL.php. I'ved added some debug messages:
> it should say "--Using Esperanto conversion settings--" at the very
> beginning, then for every piece of text that is run through the
> character set conversion it will spit out:
>
>   converting: "X" -> "X'"
>
> where X is the old string and X' is the new string. Where X contains
> character sequences like "cx", "gx", "ux", etc, X' should contain UTF-8
> byte sequences; on a terminal in 8-bit Latin1 mode they will look like
> an accented capital A followed by a square or blank character.
>
> If you don't see these messages, something is very wrong and the
> conversion isn't being called.
>
> If you see the messages but the "cx", "gx", "ux" etc are still in the
> converted text, then there's something else strange going on; possibly a
> change in the behavior of PHP's str_replace function. (I'm still running
> PHP 4.0.6.) If that's it, I'll try to whip up an alternate method.
>
> -- brion vibber (brion @ pobox.com)

--
"Jason C. Richey" <jasonr at bomis.com>


subject: [Wikitech-l] response times

body:
On ven, 2002-05-17 at 16:02, Jason Richey wrote:
> Sure.  The files are attached.

Hmm... Shouldn't be any problem. I tried substituting in those two
files, everything still works.

Try the attached convertWiki2SQL.php. I'ved added some debug messages:
it should say "--Using Esperanto conversion settings--" at the very
beginning, then for every piece of text that is run through the
character set conversion it will spit out:

  converting: "X" -> "X'"

where X is the old string and X' is the new string. Where X contains
character sequences like "cx", "gx", "ux", etc, X' should contain UTF-8
byte sequences; on a terminal in 8-bit Latin1 mode they will look like
an accented capital A followed by a square or blank character.

If you don't see these messages, something is very wrong and the
conversion isn't being called.

If you see the messages but the "cx", "gx", "ux" etc are still in the
converted text, then there's something else strange going on; possibly a
change in the behavior of PHP's str_replace function. (I'm still running
PHP 4.0.6.) If that's it, I'll try to whip up an alternate method.

-- brion vibber (brion @ pobox.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: convertWiki2SQL.php
Type: application/x-php
Size: 16657 bytes
Desc: not available
URL: <http://lists.wikimedia.org/pipermail/wikitech-l/attachments/20020517/2ec8dcd8/attachment.bin>


from_name: Lars Aronsson

subject: [Wikitech-l] response times

body:
These last 48 hours, I've sampled the response time of a number of
Wikipedia URLs every 20 minutes, for a total of 144 samples each.


subject: [Wikitech-l] response times

body:
On ven, 2002-05-17 at 17:04, Jason Richey wrote:
> Here's some (trimmed) output:
...
> converting: "Cxefpagxo" -> "Cxefpagxo"
...
>
> That's bad news...  But it does appear that we are running an older
> PHP...

Okay... Well, the conversion function on the live wiki input *does* seem
to work (it uses preg_replace rather than str_replace), and since we're
now including the local settings it should be readily available.

Try setting $recodeCharset to wikiRecodeInputEo instead of
recodeCharsetEo, and that should put things right. (A brief diff to do
this is attached.)

-- brion vibber (brion @ pobox.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: eofix.diff
Type: text/x-diff
Size: 316 bytes
Desc: not available
URL: <http://lists.wikimedia.org/pipermail/wikitech-l/attachments/20020517/19c9bb03/attachment.diff>


from_name: The Cunctator

subject: [Wikitech-l] robots.txt

body:
On 5/17/02 5:37 PM, "Axel Boldt" <axel at uni-paderborn.de> wrote:

>> A robots.txt could easily be set up to disallow
>> /wiki/special%3ARecentChanges (and various case variations). That only
>> stops _nice_ spiders, of course.
>
>> History links would need to be changed to be sufficiently
>> distinguishable, for instance using
>> /wiki.phtml?title=Foo&action=history
>> etc; then ban /wiki.phtml.
>
> I think we should do that ASAP. Let's close the whole special:
> namespace, &action=edit, &action=history, &diff=yes and &oldID stuff
> to spiders. None of this is of any value to the spiders anyway.
>
I think we should not do that any time soon. For one, this is a wikipedia-l
level discussion. Until there is direct evidence that spiders are causing
any serious problem for Wikipedia (and noone has presented any) we shouldn't
even be discussing this.

Just because you can't see why it would be of value doesn't mean that it
isn't.

Again, if we surmise that spiders are causing slowdowns, we should be able
to find evidence for that BEFORE we block parts of the site from them. And
even then we should see if the fault lies in the site's code.

Spiders simulate high traffic well, and that's something that wikipedia
should be able to handle.

tc


from_name: Gareth Owen

subject: [Wikipedia-l] Redirects broken?

body:
http://www.wikipedia.com/wiki/R.E.M.
and others.  You can't even edit these, as they're marked "Protected"?

WTHeck?

--
Gareth Owen
Byers, Langley, and Frohike


subject:
[Wikitech-l] Small, little, tiny request from the German
	Wikipedia

body:
On ven, 2002-05-17 at 17:51, Kurt Jansson wrote:
> I know you guys are busy with speeding up wikipedia and killing bugs.
> But I just wanted to remind you that the German wikipedians are more
> frequently asking for the new PHP script.
>
> The bugs in the UseMod script
> are annoying, and the new features would make life so much easier.

I know what you mean; we have better and more exciting bugs than ever in
the PHP script. :)

> If you find the time to set up a test site for us it would be very nice
> :-)

Bomis folks: I've munged wikiTextDe.php into UTF-8 and told the
conversion script to use "Diskussion" for the talk pages for German. It
should be ready to set up a test site whenever you guys are up to it.

-- brion vibber (brion @ pobox.com)


subject: [Wikitech-l] Small, little, tiny request from the German Wikipedia

in_reply_to: <1021683906.5712.4.camel@rdaneel.moisty.org>; from brion@pobox.com on Fri, May 17, 2002 at 06:05:05PM -0700

body:
I gave it a quick try just now (fresh from CVS).  I got an error:

X-Powered-By: PHP/4.0.4pl1
Content-type: text/html

Fatal error:  Call to undefined function:  encode_utf8() in
convertWiki2SQL.php on line 26

I don't really have time to do anything about it right now...

Jason

Brion L. VIBBER wrote:

> On ven, 2002-05-17 at 17:51, Kurt Jansson wrote:
> > I know you guys are busy with speeding up wikipedia and killing bugs.
> > But I just wanted to remind you that the German wikipedians are more
> > frequently asking for the new PHP script.
> >
> > The bugs in the UseMod script
> > are annoying, and the new features would make life so much easier.
>
> I know what you mean; we have better and more exciting bugs than ever in
> the PHP script. :)
>
> > If you find the time to set up a test site for us it would be very nice
> > :-)
>
> Bomis folks: I've munged wikiTextDe.php into UTF-8 and told the
> conversion script to use "Diskussion" for the talk pages for German. It
> should be ready to set up a test site whenever you guys are up to it.
>
> -- brion vibber (brion @ pobox.com)
>
> _______________________________________________
> Wikitech-l mailing list
> Wikitech-l at ross.bomis.com
> http://ross.bomis.com/mailman/listinfo/wikitech-l

--
"Jason C. Richey" <jasonr at bomis.com>


body:
On ven, 2002-05-17 at 21:18, Jason Richey wrote:
> I gave it a quick try just now (fresh from CVS).  I got an error:
>
> X-Powered-By: PHP/4.0.4pl1
> Content-type: text/html
>
>

> Fatal error:  Call to undefined function:  encode_utf8() in
> convertWiki2SQL.php on line 26

>
> I don't really have time to do anything about it right now...

Oops! The function is named "utf8_encode". Fixed now, try it again when
you have a chance.

-- brion vibber (brion @ pobox.com)


subject: [Wikipedia-l] Deleting the false redirects - how?

body:
On ven, 2002-05-17 at 23:12, Karen AKA Kajikit wrote:
> There are a whole bunch of pages that were created as protected pages
> when they were meant to be redirects. You can fix the redirect at this
> point by deleting the surplus text, but that leaves the protected page
> sitting there  by itself... these pages apparantly cannot be linked to
> or accessed once the false redirect is gone - I tried adding them to the
> 'to be deleted' list and the link doesn't transfer. So what's to be done
> about them? Should I stop correcting the redirects? Or doesn't the empty
> page matter once it's out of the linking system?

As far as I can tell, these pages don't exist and never did -- you can't
save them, after all, so they are never created -- so there's nothing to
delete!

It should probably be made clearer that a page that doesn't exist
*doesn't exist* when you try to load it up... The traditional indicator
is that a nonexistant page pops up an edit box, but that doesn't help
with illegal titles that can't be saved and thus can't be edited. I'll
throw together a nice warning message.

-- brion vibber (brion @ pobox.com)


from_name: Axel Boldt

subject: [Wikitech-l] robots.txt

body:
>A robots.txt could easily be set up to disallow
>/wiki/special%3ARecentChanges (and various case variations). That only
>stops _nice_ spiders, of course.

>History links would need to be changed to be sufficiently
>distinguishable, for instance using
>/wiki.phtml?title=Foo&action=history
>etc; then ban /wiki.phtml.

I think we should do that ASAP. Let's close the whole special:
namespace, &action=edit, &action=history, &diff=yes and &oldID stuff
to spiders. None of this is of any value to the spiders anyway.

Axel


subject: [Wikipedia-l] Naming and branding for non-English Wikipedias

body:
Before we start converting and upgrading things willy-nilly, I wanted to
check on people's (ie, both the Bomis masters' and the general
community's) preferences about the use of the Wikipedia name...

In the new software, certain classes of page are set off in special
namespaces to distinguish them from actual encyclopedia articles: talk:
for talk pages, special: for interactive functions, user: for users'
personal pages, log: for automatically generated logs, and wikipedia:
for meta-topics that aren't quite meta enough for the separate meta wiki
-- help pages, site news, bug reporting, certain user-involved
maintanence functions, etc.

For the versions in other languages, at least some of these namespaces
will be translated (particularly talk: and user:). Not difficult
technically, but my question is: what do we do about "wikipedia:"? Both
as far as the namespace for article titles, and the giant "WIKIPEDIA"
that appears at the top of every page with the new "Cologne Blue"
interface.

Specific issues:
* The forked Spanish group is also in the process of adopting the new
software, but they're not using the "Wikipedia" name for their project.
It's easy enough to provide an alternative for this and other cases with
a flick of a variable in the code.

* On the Esperanto wikipedia, we often use a regularly Esperantized form
of the name, changing the foreign "w" to "v" and giving it an "o" noun
ending -> "Vikipedio". This is more comfortable to use -- not just
referring to the EO version, but when referring in that language to
Wikipedia generally -- and the 'pedia has already received web, radio,
and magazine publicity under that name.

* There are fledgling wikipedias with between 1 and 17 pages for
languages that natively use a non-Latin writing system: Japanese,
Russian, Arabic, Hebrew, Chinese. For as long as I've been aware of it,
the Japanese stub page has included a katakana-ized form of the name
(roughly UiKIPIDiA) on the main page, with no appearance of the
English/Roman form outside the URL.

For page headers and titles and whatnot, should we:

A) Always use the original English/Roman form "Wikipedia" even if it's
uncomfortably foreign or difficult to type?

B) Always use the familiar/nativized form if there is one, so that users
of each language can comfortably read and type it?

C) Use "Wikipedia" for the big page header (that's brand recognition),
but familiar/nativized form for the namespace (that's going to be used
in the trenches and needs to be easy for users to type in links)?

D) Other?

Personally, I'm leaning towards C.

-- brion vibber (brion @ pobox.com)


subject: [Wikitech-l] Re: [Wikipedia-l] robots and spiders

body:
On wikipedia-l, Chuck Smith wrote:

> I COMPLETELY disagree with this.  Let the robots crawl
> everything.  It's better that someone finds one of our
> Talk or User pages and cruises on over to our main
> site than to simply find a completely website!

I think search robots should be stopped from indexing the editing
pages.  Google has already indexed this URL
http://www.wikipedia.com/wiki/Wikipedia:Help&action=edit
and I don't see the point in that.  Look here for a list,
http://www.google.com/search?q=+site:www.wikipedia.com+editing+wikipedia

This can be stopped by inserting this in the HTML <head>:
<META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">

--
  Lars Aronsson (lars at aronsson.se)
  tel +46-70-7891609
  http://aronsson.se/ http://elektrosmog.nu/ http://susning.nu/


from_name: Kurt Jansson

body:
Hi!

I know you guys are busy with speeding up wikipedia and killing bugs.
But I just wanted to remind you that the German wikipedians are more
frequently asking for the new PHP script. The bugs in the UseMod script
are annoying, and the new features would make life so much easier.

If you find the time to set up a test site for us it would be very nice
:-)

Thanks,
Kurt


from_name: Jimmy Wales

subject: [Wikipedia-l] Re: [Wikitech-l] Cause for slowdowns: spiders?

body:
wojtek pobratyn wrote:
> a usefull thing. An issue worth considering is banning robots from
> special pages, Recent Changes, Talk, User, etc. by an appropriate META tag.
> IMHO,  robots and spiders should only be allowed to go over the articles.

Google's algorithm these days takes notice of pages that change rapidly.  I think
they spider RecentChanges a lot, to get current pages.  I think we should allow
for that.

Also, in my experience, "professional" robots (google, altavista,
inktomi, etc.) are *overly* polite, hitting the site only once per
minute, etc.  Every now and then I'll find (at Bomis) some jerk who
wrote a homemade bot that's hammering us.

But really, we should be able to handle the occcassional spider with no
difficulty.


from_name: Ian

subject: [Wikipedia-l] Variable access...

body:
On Sat, 18 May 2002, Karen AKA Kajikit kaji at labyrinth.net.au XXXXXXXXXXXXXXXXXXXXX wrote:

> The wikipedia is working much better since the work was done on it. I
> seem to be able to do anything I want in the morning and afternoon
> without any problems. But in the evening it slows to a crawl and access
> becomes extremely sporadic leaning to impossible. Might that be the time
> when Google and other search engines set their automatic bots loose to
> trawl for new articles? Or maybe it's just due to general access
> demands.
>
> I've got a feeling it's related to timezones. I'm in Australia, on the
> opposite side of the world to most Wikipedia contributors...
>
> --
>
> Karen AKA Kajikit

General access demands. Certainly crawlers don't send all their bots at
the same time - bots are designed to not slow sites down as much as
possible.

It could be Wikipedia, or your ISP or something in between. When my aunt
lived in Spain she would coordinate her surfing time with low usages times
in the US.

Ian Monroe
http://ian.webhop.org


subject: [Wikitech-l] robots.txt

in_reply_to: <B90AF438.EC3%cunctator@kband.com>; from cunctator@kband.com on Fri, May 17, 2002 at 05:54:00PM -0400

body:
The Cunctator wrote:
> Again, if we surmise that spiders are causing slowdowns, we should be able
> to find evidence for that BEFORE we block parts of the site from them. And
> even then we should see if the fault lies in the site's code.

I think this is right, although blocking them from 'edit' doesn't seem harmful.
Certainly, it's good for spiders to hit 'Recent Changes', and often.

> Spiders simulate high traffic well, and that's something that wikipedia
> should be able to handle.

Right.

I'll do some research to determine if spiders are causing any
problems, but in my experienced judgment based on running high traffic
sites, I think it is pretty unlikely.

--Jimbo


subject: [Wikipedia-l] Re: [Intlwiki-l] Naming and branding for non-English Wikipedias

body:
Kurt Jansson wrote:
> One thing the nonprofit organisation could do is buy domains for the
> international wikipedias, at least the active ones. It would be nicer to
> promote.

Since for now the nonprofit organization is just me spending money for fun, feel
free to send me domain names that should be bought.  I think it's important to get
them before spammers do.

--Jimbo


from_name: Karen AKA Kajikit

subject: [Wikipedia-l] Variable access...

body:
The wikipedia is working much better since the work was done on it. I
seem to be able to do anything I want in the morning and afternoon
without any problems. But in the evening it slows to a crawl and access
becomes extremely sporadic leaning to impossible. Might that be the time
when Google and other search engines set their automatic bots loose to
trawl for new articles? Or maybe it's just due to general access
demands.

I've got a feeling it's related to timezones. I'm in Australia, on the
opposite side of the world to most Wikipedia contributors...

--

Karen AKA Kajikit

Come and visit my part of the web:
Kajikit's Corner: http://Kajikit.netfirms.com/
Aussie Support Mailing List: http://groups.yahoo.com/group/AussieSupport
Allergyfree Eating Recipe Swap:
http://groups.yahoo.com/group/Allergyfree_Eating

Love and huggles to all!


from_name: Bryan Derksen

subject: [Wikipedia-l] robots and spiders

body:
At 08:42 PM 5/18/02 +0200, Axel Boldt wrote:

> >if a spider goes to Recent Changes and then to "Last 5000 changes"
> >(and last 90 days, and last 30 days, and last 2500 changes, and last
> >1000 changes, and every such combination) it seems to me the server
> >load could get pretty high. Perhaps talk pages should be spidered,
> >but not recent changes or the history (diff/changes).
>
>I agree. Every RecentChanges page contains links to 13 other
>RecentChanges, and one of them changes its URL each time the page is
>loaded. The other special: pages like statistics, all pages, most
>wanted etc. seem to be good candidates for robot exclusion as well:
>they stress the database but don't provide much useful information for
>indices.

Actually, wouldn't "All pages" be a very _good_ page to allow spiders to
read? It would let them cut straight to the heart of the matter and get a
list of all the pages they need from Wikipedia. At the very least, they
should be allowed to read the orphans list, since the pages listed there
won't be found by spidering through the conventional pages.

--
"Let there be light." - Last words of Bomb #20, "Dark Star"


subject: [Wikitech-l] robots.txt

body:
On 5/18/02 3:08 PM, "Jimmy Wales" <jwales at bomis.com> wrote:

> The Cunctator wrote:
>> Again, if we surmise that spiders are causing slowdowns, we should be able
>> to find evidence for that BEFORE we block parts of the site from them. And
>> even then we should see if the fault lies in the site's code.
>
> I think this is right, although blocking them from 'edit' doesn't seem
> harmful.
> Certainly, it's good for spiders to hit 'Recent Changes', and often.
>
Both points make perfect sense to me.


body:
There are a whole bunch of pages that were created as protected pages
when they were meant to be redirects. You can fix the redirect at this
point by deleting the surplus text, but that leaves the protected page
sitting there  by itself... these pages apparantly cannot be linked to
or accessed once the false redirect is gone - I tried adding them to the
'to be deleted' list and the link doesn't transfer. So what's to be done
about them? Should I stop correcting the redirects? Or doesn't the empty
page matter once it's out of the linking system?

--

Karen AKA Kajikit

Come and visit my part of the web:
Kajikit's Corner: http://Kajikit.netfirms.com/
Aussie Support Mailing List: http://groups.yahoo.com/group/AussieSupport
Allergyfree Eating Recipe Swap:
http://groups.yahoo.com/group/Allergyfree_Eating

Love and huggles to all!


from_name: Daniel Mayer

subject: [Wikipedia-l] Re: Robots and special pages

body:
On Saturday 18 May 2002 12:01 pm, you wrote:
> Message: 6
> Date: Fri, 17 May 2002 15:37:47 -0700
> From: lcrocker at nupedia.com
> To: wikipedia-l at nupedia.com
> Subject: [Wikipedia-l] Robots and special pages
> Reply-To: wikipedia-l at nupedia.com
>
> This is a multi-part message in MIME format...
>
> ------------=_1021675067-23053-0
> Content-Type: text/plain
> Content-Disposition: inline
> Content-Transfer-Encoding: binary
>
> A discussion just came up on the tech list that deserves input from
> the list at large: how do we want to restrict access (if at all) to
> robots on wikipedia special pages and edit pages and such?

My two cents (well maybe a bit more),

On talk pages: OPEN to bots

Its A OK for bots to index talk pages -- these pages often have interesting
discussion that should be on search engines. Of course, if this becomes a
performance issue then we could prevent bots from indexing these.

On wikipedia pages: OPEN to bots

I STRONGLY feel that wikipedia pages should be open to bots -- remember we
are also trying to expand our community here and people do search for those
things on the net.

On user pages: OPEN to bots

I also don't see anything wrong with letting bots crawl all over user pages
-- I occasionally browse personal home pages of other people that have
similar interests to myself. This project isn't just about the articles it is
also about community building.

On log, history, print and special pages: CLOSED to bots (closed at least for
indexing -- not sure about allowing the 'follow links' function. Would
closing this allow bots to do their thing faster or slower? Is this at all
important for us to consider? If a bot can index our site fast, will it do it
more often?)

I think that the wikipedia pages are FAR better at naturally explaining what
the project is about than are the log, history and special pages are -- these
pages are far too technical and change too quickly to be useful for any
search performed on a search engine. There is also limited utility of having
direct links to the Printable version of articles -- these don't have any
active wiki links in them which obscures the fact that the page is from a
wiki.

Having history pages in the search results of external search engines is
potentially dangerous, since somebody could easily click into an older
version and save it -- thus reverting the article and unwittingly "earning"
the label of VANDAL (even if they did make a stab at improving the version
they read). Another reason to disallow bots access to history is because
there often is copyrighted material in the history of pages that has since
been removed from the current article version (it would be nice for an admin
to able to delete just an older version of an article BTW).

On Edit links: CLOSED to bots (for index and probably follow links)

The edit links REALLY should NOT be allowed to be indexed by any bot: When
somebody searches for something on a search engine, gets a link to our site,
and clicks on it; do we want them to be greeted with an edit window? They
want information -- not an edit window. No wonder we have so many pages that
only have "Describe the new page here" as their only content.

I've been tracking this for awhile and almost every one of these pages that
are created, are created by an IP that never returns to edit again. Many (if
not most) of these "mysteriously" created pages are probably from someone
clicking from a search engine, becoming puzzled by the edit window, and
hitting the save button in frustration. Heck, I think I may have created a
few of these in my pre-wiki days.

This has become a bit of a maintenance issue for the admins -- we can't
delete these pages fast enough, let alone create stubs for them. If left
unchecked, this could reduce the average quality of wikipedia articles and
give people doubt as to whether an "active" wiki link really has an article
(or even a stub) behind it.

There could, of course, be a purely technical fix for this by having the
software not recognize newly created blank or "Describe the new page here"
pages as being real pages (a Good Idea BTW). But then we still would have
frustrated people who were looking for actual info that in the future may
avoid clicking through to our site because of a previous "edit window
experience".

Conclusion:

We should try to put our best foot forward when allowing bots to index the
site and only allow indexing of pages that have information which is
potentially useful for the person searching.

Edit widows and outdated lists are NOT useful to somebody clicking through
for the first time (Recent Changes might be the only exception: Even though
any index of this will be outdated, it is centrally important to the project
and fairly self-explanatory). Links to older versions of articles and to
history pages also sets-up would-be contributors into becoming labeled as
"vandals" when trying to edit an older version -- thus turning them away
forever.

Let visitors explore a real article first and discover the difference between
an edit window an an actual article -- then they can decide about becoming a
contributor, visitor or even a developer for that matter.

maveric149


from_name: Vicki Rosenzweig

subject:
[Wikipedia-l] Re: [Intlwiki-l] Naming and branding for
  non-English Wikipedias

body:
At 12:20 PM 5/18/02 -0700, you wrote:
>Kurt Jansson wrote:
> > One thing the nonprofit organisation could do is buy domains for the
> > international wikipedias, at least the active ones. It would be nicer to
> > promote.
>
>Since for now the nonprofit organization is just me spending money for
>fun, feel
>free to send me domain names that should be bought.  I think it's
>important to get
>them before spammers do.

We can get .com, .org, and .net (and I think .fr and maybe some others) from
GANDI.net for a whopping 12 euros a year; I have two domains registered there,
and they seem to be both efficient and reputable (no spam, for example).
This may
not be the best price available, but it's pretty good.

Vicki, not associated with GANDI

>--Jimbo
>[Wikipedia-l]
>To manage your subscription to this list, please go here:
>http://www.nupedia.com/mailman/listinfo/wikipedia-l

--
Vicki Rosenzweig
vr at redbird.org
http://www.redbird.org


from_name: Chuck Smith

subject: [Wikipedia-l] Re: Wikipedia-l digest, Vol 1 #389 - 14 msgs

body:
> One thing the nonprofit organisation could do is buy
> domains for the
> international wikipedias, at least the active ones.
> It would be nicer to
> promote.

Well, they've already bought vikipedio.com for us.
Unfortunately it points to eo.wikipedia.com, but none
of the links on there work.  It is partly my fault
though because Jimmy asked me to bug him every day
until it was fixed and it seems I've been slacking on
the job.  Hey Jimmy, could you look into this?  :)

Chuck

=====
Come to my homepage!  Venu al mia hejmpagxo!
http://amuzulo.babil.komputilo.org/
====
Venu al la senpaga, libera enciklopedio
esperanta reta! http://eo.wikipedia.com/

_________________________________________________________
Do You Yahoo!?
Informaci?n de Estados Unidos y Am?rica Latina, en Yahoo! Noticias.
Vis?tanos en http://noticias.espanol.yahoo.com


body:
Hi Brion!

> For page headers and titles and whatnot, should we:
>
> A) Always use the original English/Roman form "Wikipedia" even if it's
> uncomfortably foreign or difficult to type?
>
> B) Always use the familiar/nativized form if there is one, so that
users
> of each language can comfortably read and type it?
>
> C) Use "Wikipedia" for the big page header (that's brand recognition),
> but familiar/nativized form for the namespace (that's going to be used
> in the trenches and needs to be easy for users to type in links)?
>
> D) Other?
>
> Personally, I'm leaning towards C.

I think C makes sense. But that doesn't affect the German Wikipedia,
because fortunately nobody had the idea to call it "Wikip?die" which
sounds dull (Wikip?dia would be an alternative).

One thing the nonprofit organisation could do is buy domains for the
international wikipedias, at least the active ones. It would be nicer to
promote.

Bye,
Kurt


subject: [Wikipedia-l] robots and spiders

body:
>if a spider goes to Recent Changes and then to "Last 5000 changes"
>(and last 90 days, and last 30 days, and last 2500 changes, and last
>1000 changes, and every such combination) it seems to me the server
>load could get pretty high. Perhaps talk pages should be spidered,
>but not recent changes or the history (diff/changes).

I agree. Every RecentChanges page contains links to 13 other
RecentChanges, and one of them changes its URL each time the page is
loaded. The other special: pages like statistics, all pages, most
wanted etc. seem to be good candidates for robot exclusion as well:
they stress the database but don't provide much useful information for
indices.

Regarding talk:, wikipedia: and user: pages, I don't see any reason not
to have them indexed.

Diff pages seem to be useless to spiders since the same information
is contained in the two article versions.

Remaining question is: what about article histories and old versions
of articles? Do we want Google to have a copy of every version of
every article, or only the current one?

Axel


body:
On sab, 2002-05-18 at 16:32, Daniel Mayer wrote:
> Another reason to disallow bots access to history is because
> there often is copyrighted material in the history of pages that has since
> been removed from the current article version (it would be nice for an admin
> to able to delete just an older version of an article BTW).

I've been meaning to add this, but haven't gotten around to it yet.
It'll go in with some other maintanence tools (for the ability to
undelete something if necessary, and to find and reattach or dump
"homeless" entries that may have somehow come loose in the database.
Actually, those last two are the same ability.)

> The edit links REALLY should NOT be allowed to be indexed by any bot:

Amen!

> There could, of course, be a purely technical fix for this by having the
> software not recognize newly created blank or "Describe the new page here"
> pages as being real pages (a Good Idea BTW).

Good idea, and should be easy to do; I'll add this right away if there
are no objections.

> Links to older versions of articles and to
> history pages also sets-up would-be contributors into becoming labeled as
> "vandals" when trying to edit an older version -- thus turning them away
> forever.

Good point.

-- brion vibber (brion @ pobox.com)


subject: [Wikitech-l] robots.txt

body:
> Certainly, it's good for spiders to hit 'Recent Changes', and often.

Why? The spider doesn't know that the pages on RecentChanges have had
recent changes. It's just a list of links, like special:allpages or
special:ShortPages.

Maybe one could add
  /wiki/special:RecentChanges&
to the robots.txt file; that way, the spider would fetch only one copy
of RecentChanges, not 14.

Axel


body:
> Every now and then I'll find (at Bomis) some jerk who wrote a
> homemade bot that's hammering us.

It doesn't have to be homemade though. If I didn't have a fast
always-on and flat-rate internet connection, the first thing I would do
upon coming across Wikipedia would be to whip out wget and download
the baby, so that I can browse offline. I can't be the only one.

Axel


from_name: wojtek pobratyn

subject: [Wikipedia-l] computeruser article

body:
hi all.

I stubled upon a new article mentioning our little project:
http://www.computeruser.com/articles/2105,4,33,1,0501,02.html

Overall, the article is very positive and enthusiastic. Funnily enough
in the final paragraph we read:
'I also strongly advise not clicking on the "All Pages" link in the right-hand column from
Wikipedia's main page, unless you need to leave the computer for about 10 minutes.'

:-)
regards,
[[user:WojPob]]

<wojtek[at]seti23[dot]org>
what burns twice as bright, burns half
as long, and you have burnt so very,
very brightly roy.


body:
Hi Jimmy!

> Kurt Jansson wrote:
> > One thing the nonprofit organisation could do is buy domains for the
> > international wikipedias, at least the active ones. It would be
nicer to
> > promote.
>
> Since for now the nonprofit organization is just me spending money for
fun,

:-)

> feel free to send me domain names that should be bought.  I think it's
important
> to get them before spammers do.

That's right. www.wikipedia.de would be nice to have. I think we own
.net and .org already? I don't know if the new ones like .info are of
any importance.

Thanks Jimmy!

Kurt


body:
|Kurt Jansson wrote:
|
| That's right. www.wikipedia.de would be nice to have. I think we own
| .net and .org already? I don't know if the new ones like .info are of
| any importance.

I think I mentioned this six months ago: wikipedia.info is registered
by Jimmy and is still dead, i.e. it redirectes to the registrars page
that tries to install spyware on your PC:-(

[[user:WojPob]]


body:
> > feel free to send me domain names that should be bought.  I think
it's
> important
> > to get them before spammers do.
>
> That's right. www.wikipedia.de would be nice to have.

Well, the last time I checked it was still free, but now denic.de gives
these infos:

Domaindaten
Domainname:  wikipedia.de
Domaininhaber:  thomas promny
buckower weg 13c
14715 steckelsdorf
Letzte Aktualisierung:  Donnerstag, 25. April 2002

Administrativer Ansprechpartner, technischer Ansprechpartner,
Zonenverwalter
Name:  Harrold Ursachi
Kontakttyp:  Person
Adresse:  Hesperus
Ostengasse 4
Stadt:  Regensburg
PLZ:  93047
Land:  GERMANY
E-Mail:  harrold_ursachi at hotmail.com

Shall I write him a nice mail and ask him to
a) redirect to de.wikipedia.com
b) transfer the domain to Jimmy?

What legal position do we have if he doesn't want to? Maybe he's a nice
guy, but I made a google search for Thomas Promny and it seems that he
owns a number of domains that he tries to sell:
http://www.buythisdomain.de/domains.htm (but wikipedia.de is not
mentioned there)

Kurt


subject: [Wikipedia-l] query on page deletion

body:
I seem to recall that the page deletion facility used to have a place to
say why
you were deleting a page. Now it just asks "are you sure?" and, if so, does the
deed and logs what was deleted and by whom.

Is there any place to record reasons for page deletions?
--
Vicki Rosenzweig
vr at redbird.org
http://www.redbird.org


in_reply_to: <000501c1feb2$e60c8ae0$fe0110ac@apc2124>; from wojtek.pobratyn@gmx.net on Sat, May 18, 2002 at 11:28:04PM +0200

body:
wojtek pobratyn wrote:

> |Kurt Jansson wrote:
> |
> | That's right. www.wikipedia.de would be nice to have. I think we own
> | .net and .org already? I don't know if the new ones like .info are of
> | any importance.
>
> I think I mentioned this six months ago: wikipedia.info is registered
> by Jimmy and is still dead, i.e. it redirectes to the registrars page
> that tries to install spyware on your PC:-(

spyware?  Yow.  I didn't bother redirecting it, because I'm mostly just trying to
keep squatters from getting it.  But if the page it points to is evil, I should
change it.


in_reply_to: <005401c1feb8$9f2abba0$65afe6d9@maximilian>; from jansson@gmx.net on Sun, May 19, 2002 at 12:06:24AM +0200

body:
Ugh.

Kurt Jansson wrote:

>
>
> > > feel free to send me domain names that should be bought.  I think
> it's
> > important
> > > to get them before spammers do.
> >
> > That's right. www.wikipedia.de would be nice to have.
>
> Well, the last time I checked it was still free, but now denic.de gives
> these infos:
>
> Domaindaten
> Domainname:  wikipedia.de
> Domaininhaber:  thomas promny
> buckower weg 13c
> 14715 steckelsdorf
> Letzte Aktualisierung:  Donnerstag, 25. April 2002
>
> Administrativer Ansprechpartner, technischer Ansprechpartner,
> Zonenverwalter
> Name:  Harrold Ursachi
> Kontakttyp:  Person
> Adresse:  Hesperus
> Ostengasse 4
> Stadt:  Regensburg
> PLZ:  93047
> Land:  GERMANY
> E-Mail:  harrold_ursachi at hotmail.com
>
> Shall I write him a nice mail and ask him to
> a) redirect to de.wikipedia.com
> b) transfer the domain to Jimmy?
>
> What legal position do we have if he doesn't want to? Maybe he's a nice
> guy, but I made a google search for Thomas Promny and it seems that he
> owns a number of domains that he tries to sell:
> http://www.buythisdomain.de/domains.htm (but wikipedia.de is not
> mentioned there)
>
> Kurt
>
>
> [Wikipedia-l]
> To manage your subscription to this list, please go here:
> http://www.nupedia.com/mailman/listinfo/wikipedia-l


subject: [Wikipedia-l] query on page deletion

body:
On dim, 2002-05-19 at 06:54, Magnus Manske wrote:
> Vicki Rosenzweig wrote:
> > I seem to recall that the page deletion facility used to have a place to
> > say why you were deleting a page. Now it just asks "are you sure?" and,
> > if so, does the deed and logs what was deleted and by whom.
> >
> I don't know where that went.

I don't think it's ever been there, in the software process of deleting
a page. (At least, on the current software; I have no idea what the
delete function in Perl-land was like.)

There _is_ a place to put an explanation for banning IPs, and there
_should be_ one for deleting pages and deleting uploaded files.

In the human process of deleting a page, there are now two places where
you can place your reasons for deleting something, but you have to
explicitly do this yourself...

> > Is there any place to record reasons for page deletions?
>
> You could vote for deletion, state your
> reason, then really delete it...

So what exactly is the overlap between [[Wikipedia:Votes for Deletion]]
and [[Wikipedia utilities/Page titles to be deleted]]? Is the latter now
deprecated?

-- brion vibber (brion @ pobox.com)


subject: [Wikipedia-l] sidebar links

body:
On dim, 2002-05-19 at 09:28, Chuck Smith wrote:
[ re: offline browsing? ]
> It might really make people think if they can click
> Download Wikipedia!  :o)  What would you think of
> adding this to the sidebar?  Perhaps we could move
> this file to another server so it wouldn't diminish
> Wikipedia performance... maybe download.com?  :o)

Download wikipedia! And install a web server, database server, and PHP
interpreter, and configure them all just right. :) Eventually, we might
want to set something up for generating a "static" version of wikipedia
from the database, which could then be downloaded for offline viewing,
mirroring, putting on a CD for archival purposes... (Every page would
have a link to the article on the live wikipedia to see/edit the current
version, of course.)

In the meantime though, it might be nice if the database dump were
updated from time to time for backups' and developers' sake.

> Also, please, please, PLEASE fix that horrible date
> link on the sidebar.  It's HORRIBLE!  I'll repeat:
> it's *horrible*!  Either change it so it links
> individually to the date and year, or link it to
> Current_Events or just delete it... but do
> something!!!

Switch your skin to Cologne Blue -- no more date link! :)

-- brion vibber (brion @ pobox.com)


from_name: Neil Harris

subject: [Wikipedia-l] Caching

body:
Speed is now excellent, and the Wikipedia is back in action.
Congratualtions to the programmers!

Page caching seems to be causing some problems -- should caching now be
turned off for a bit? It did not seem to influence speed very much
before, and seems to create problems with pages which could potentially
lead to content loss.

Neil


subject: [Wikipedia-l] sidebar links

body:
> It doesn't have to be homemade though. If I didn't
> have a fast
> always-on and flat-rate internet connection, the
> first thing I would do
> upon coming across Wikipedia would be to whip out
> wget and download
> the baby, so that I can browse offline. I can't be
> the only one.

It might really make people think if they can click
Download Wikipedia!  :o)  What would you think of
adding this to the sidebar?  Perhaps we could move
this file to another server so it wouldn't diminish
Wikipedia performance... maybe download.com?  :o)

Also, please, please, PLEASE fix that horrible date
link on the sidebar.  It's HORRIBLE!  I'll repeat:
it's *horrible*!  Either change it so it links
individually to the date and year, or link it to
Current_Events or just delete it... but do
something!!!

Thanks,
Chuck

=====
Come to my homepage!  Venu al mia hejmpagxo!
http://amuzulo.babil.komputilo.org/
====
Venu al la senpaga, libera enciklopedio
esperanta reta! http://eo.wikipedia.com/

_________________________________________________________
Do You Yahoo!?
Informaci?n de Estados Unidos y Am?rica Latina, en Yahoo! Noticias.
Vis?tanos en http://noticias.espanol.yahoo.com


subject: [Wikipedia-l] sidebar links

body:
On dim, 2002-05-19 at 10:27, Magnus Manske wrote:
> > Switch your skin to Cologne Blue -- no more date link! :)
>
> Which reminds me - should we make CB the default skin? I have switched to it
> since the big update a week or so ago, and I like it a lot better than the
> standard one.

Might not hurt... There are still a few bugs to be worked out, and
general usability issues that I've discovered since switching to it
full-time:

General:
* The sidebar is getting so long that I have to scroll down to see
everything, and I'm running at 1280x1024.

* A lot of the things I want to use are hidden in the middle or bottom
somewhere and take a while to find: "Edit this page" is helped by being
in a larger font, but "Add to watchlist" and "Talk" are scrunched down
among other things and I easily lose them; "My watchlist"[1] and "My
settings" aren't even visible until I scroll down. "Previous versions"
and "pages that link here" are also way down there. Same with "this
user's edits" on a user page.

Meanwhile, "Short pages", "Long articles", "User list" etc are taking up
valuable real estate at the top of the screen.

* I find it odd that "My watchlist" and "Add to watchlist" are so
distantly separated.

Specific things:
* There's no access to "previous versions" or "pages that link here"
when editing a page; you have to hit "cancel" and get at the links from
there unless you had the presence of mind to open the edit link in a
separate window.

* Hitting "Edit this page" on a previous page version edits the most
recent version instead. (Fixed in CVS)

[1] Notice that special:Watchlist is currently buggy, giving false
notice about nonexistent pages and ordering things horribly wrongly;
this is fixed in CVS. Although, the watchlist page itself isn't as
important now that RecentChanges indicates changes to your watchlist
entries in bold... But I still use my watchlist as a kind of bookmark
list.

> On the statistics page, you might notice that most people never changed
> skins - the ones who deliberately chose a skin are counted, the rest never
> tried. In case of making CB standard, should these be switched as well (they
> can always change back, of course)?

I rather figured that would be part of the process of making it the
standard skin, yeah.

Note though that we should fix the cookie problem for
"http://www.wikipedia.com/" (without the /wiki/ part) so that the
mainpage always comes up in the user's selected skin.

-- brion vibber (brion @ pobox.com)


subject: [Wikipedia-l] Overwriting uploaded files

body:
On dim, 2002-05-19 at 12:50, Bryan Derksen wrote:
> At 03:38 PM 5/19/02 -0400, you wrote:
> >On 5/19/02 3:25 PM, "Axel Boldt" <axel at uni-paderborn.de> wrote:
> > > I propose that we completely forbid the overwriting of existing
> > > uploaded files.
> >But that's annoying if you want to update a file with a corrected version.
> >There should be a better way.
>
> It would be nice if uploaded files had a "history" like articles do. That
> way a vandalism like overwriting with junk could be easily undone.

Hmm...

> Also, while I'm thinking about it, a "trash bin" where deleted files and
> articles go for a while before being truly and permanently deleted would be
> a nice safety feature;

That would be pretty easy, I think. Just create a separate directory
(with web access disallowed), move 'deleted' files over it; maybe have a
cron job clear it out every now and then.

> Oh, and an "articles that link here" feature for the files in uploads would
> be great, too! Would make it easier to spot the files which are actually
> used by articles and the ones put there by jerks just using Wikipedia for
> free hosting space.

This would be easier if we add a table to list external links just like
we currently have for internal links to existing and nonexisting
articles. When saving an article, we could list all the web links,
images, and perhaps inter-wiki links, dump them to this table; then,
it's a simple database query to check against the URL and grab any
article -- on _this_ wiki -- that links to a given file.

(If there's any reason not to do it this way, let's discuss further on
wikitech-l; however it's implemented, it's a needed feature.)

This will not solve the problem of tracking files that are used on
_other_ wikipedia sites; a lot of images are shared between articles on
the different languages 'pedias, and a number of specifically
non-English files (labelled maps and diagrams, for instance) are hosted
on the English or Meta 'pedias because the others haven't been converted
yet... though theoretically this could be tracked in the future by
checking the link tables for each language's database.

-- brion vibber (brion @ pobox.com)


body:
At 03:38 PM 5/19/02 -0400, you wrote:
>On 5/19/02 3:25 PM, "Axel Boldt" <axel at uni-paderborn.de> wrote:
> > I propose that we completely forbid the overwriting of existing
> > uploaded files.
>But that's annoying if you want to update a file with a corrected version.
>There should be a better way.

It would be nice if uploaded files had a "history" like articles do. That
way a vandalism like overwriting with junk could be easily undone.

Also, while I'm thinking about it, a "trash bin" where deleted files and
articles go for a while before being truly and permanently deleted would be
a nice safety feature; someone was just recently asking about possible ways
to recover an article he'd deleted, and I myself am often reduced to a
quivvering mass of indecision and fear when I'm about to click on "delete
this page" even if I've spent considerable effort convincing myself it's
the right thing to do.

Oh, and an "articles that link here" feature for the files in uploads would
be great, too! Would make it easier to spot the files which are actually
used by articles and the ones put there by jerks just using Wikipedia for
free hosting space.

I think I'm done wishing for now. :)

--
"Let there be light." - Last words of Bomb #20, "Dark Star"


body:
On 5/19/02 3:25 PM, "Axel Boldt" <axel at uni-paderborn.de> wrote:

> Right now, any registered user can upload a file with the same name as
> an already existing one, thereby either unintentionally or
> deliberately overwriting and removing the original file. This will be
> recorded on the upload logs page, but not in the history of the page
> which contains the image. As a result, anybody who uploads images
> needs to keep local safety copies and needs to check from time to time
> to make sure that the file on the server is still the intended one.
>
> I propose that we completely forbid the overwriting of existing
> uploaded files. If you have a new version of your image, give it a
> different name and change the link in the article. That way, the
> change will be recorded in the article's history, and the previous
> version of the image will still be accessible.
>
> Sysops would of course still be able to remove any file.
>
But that's annoying if you want to update a file with a corrected version.
There should be a better way.


from_name: Magnus Manske

subject: [Wikipedia-l] query on page deletion

body:
I don't know where that went. You could vote for deletion, state your
reason, then really delete it...

Magnus

> -----Original Message-----
> From: wikipedia-l-admin at nupedia.com
> [mailto:wikipedia-l-admin at nupedia.com]On Behalf Of Vicki Rosenzweig
> Sent: Sunday, May 19, 2002 2:23 PM
> To: wikipedia-l at nupedia.com
> Subject: [Wikipedia-l] query on page deletion
>
>
> I seem to recall that the page deletion facility used to have a place to
> say why
> you were deleting a page. Now it just asks "are you sure?" and,
> if so, does the
> deed and logs what was deleted and by whom.
>
> Is there any place to record reasons for page deletions?
> --
> Vicki Rosenzweig
> vr at redbird.org
> http://www.redbird.org
>
> [Wikipedia-l]
> To manage your subscription to this list, please go here:
> http://www.nupedia.com/mailman/listinfo/wikipedia-l


body:
At 11:49 PM 5/19/02 +0200, Axel Boldt wrote:
> > It would be nice if uploaded files had a "history" like articles do.
> > That way a vandalism like overwriting with junk could be easily
> > undone.
>
>How would that work though? Suppose we both use the same image of a
>German flag on different articles. Now I decide that I like my flag
>bigger, and upload the new one. Which one will be displayed on your
>page? And, which one will be displayed on yesterday's version of my
>article?

I would vote for all references to the flag in articles pointing to the
latest version of the uploaded file, just like how all links to other
articles point to the latest version of that article. I mainly proposed the
uploaded file individual history record as a way to prevent vandalism, so
that the overwritten file would not be irrevokably lost; in all other
respects it would work like uploads already work right now.

Trying to keep track of which versions of the article pointed to which
versions of the uploaded file would be overly complex and unnecessary, as
bad as trying to keep track of which version of an article links to which
version of other articles. I don't see what significant advantage would be
gained by that, other than forcing you to somehow hunt down and update all
links to an image when you update it with a better one.

If someone changes an uploaded file that's used on two different articles,
so that it now works well on one article but not on the other, then someone
should go into the history of that file to find the old version and
re-upload it as a separate image instead. The image would be "forked" that
way, like how overly-long articles sometimes get broken up into multiple
articles.

--
"Let there be light." - Last words of Bomb #20, "Dark Star"


subject: [Wikipedia-l] sidebar links

body:
> > Also, please, please, PLEASE fix that horrible date
> > link on the sidebar.  It's HORRIBLE!  I'll repeat:
> > it's *horrible*!  Either change it so it links
> > individually to the date and year, or link it to
> > Current_Events or just delete it... but do
> > something!!!
>
> Switch your skin to Cologne Blue -- no more date link! :)

Which reminds me - should we make CB the default skin? I have switched to it
since the big update a week or so ago, and I like it a lot better than the
standard one.

On the statistics page, you might notice that most people never changed
skins - the ones who deliberately chose a skin are counted, the rest never
tried. In case of making CB standard, should these be switched as well (they
can always change back, of course)?

Magnus


body:
Right now, any registered user can upload a file with the same name as
an already existing one, thereby either unintentionally or
deliberately overwriting and removing the original file. This will be
recorded on the upload logs page, but not in the history of the page
which contains the image. As a result, anybody who uploads images
needs to keep local safety copies and needs to check from time to time
to make sure that the file on the server is still the intended one.

I propose that we completely forbid the overwriting of existing
uploaded files. If you have a new version of your image, give it a
different name and change the link in the article. That way, the
change will be recorded in the article's history, and the previous
version of the image will still be accessible.

Sysops would of course still be able to remove any file.

Axel


subject: [Wikipedia-l] Downloading wikipedia (was: sidebar links)

body:
> It might really make people think if they can click
> Download Wikipedia!  :o)  What would you think of
> adding this to the sidebar?

That would be cool. It should direct to a server where you could
download either the raw SQL data for people who want to do fancy
things, or a ready-to-browse static HTML tree (with edit, special and
history links pointing to wikipedia.com).

Jimbo, could you start your cron script again to make regular database
dumps? We could then easily write a script which produces such a static
HTML tree.

mysqldump --user="XXX" --password="XXX" --opt wiki cur old linked unlinked | gzip -9 > wikipedia_dump_`date +%Y%m%d`.sql.gz

(if the mysql database is called wiki)

Axel


body:
> But that's annoying if you want to update a file with a corrected version.

True, but that's a rare event, and furthermore an event that should
not happen silently but should be recorded in the article's history.
In addition, what if some other author on some other page uses your
image, and does not want your correction? In the current scheme, they
have absolutely no say in the matter.

Axel


body:
> It would be nice if uploaded files had a "history" like articles do.
> That way a vandalism like overwriting with junk could be easily
> undone.

How would that work though? Suppose we both use the same image of a
German flag on different articles. Now I decide that I like my flag
bigger, and upload the new one. Which one will be displayed on your
page? And, which one will be displayed on yesterday's version of my
article?

Axel


subject: [Wikipedia-l] query on page deletion

body:
"Brion L. VIBBER" wrote:

> So what exactly is the overlap between [[Wikipedia:Votes for Deletion]]
> and [[Wikipedia utilities/Page titles to be deleted]]? Is the latter now
> deprecated?

I think Votes for deletion is the better page of the two because ANYONE
can access it just by clicking a button rather than actually having to
physically go looking for the other page. The software does the
searching for you...

--

Karen AKA Kajikit

Come and visit my part of the web:
Kajikit's Corner: http://Kajikit.netfirms.com/
Aussie Support Mailing List: http://groups.yahoo.com/group/AussieSupport
Allergyfree Eating Recipe Swap:
http://groups.yahoo.com/group/Allergyfree_Eating

Love and huggles to all!


subject:
[Wikipedia-l] Need to alter the front page links to
  include East Timor

body:
At 08:02 PM 5/20/02 +1000, Karen wrote:
>Somebody who can alter the breaking news and current events list needs
>to add East Timor to it. I think the creation of a 'new country' (even
>though it's not actually new) is kind of important... Somebody who knows
>about politics could write a better article for the subject too.

I've edited the main page, will now go in and do Current Events. Thanks for the
heads-up.
--
Vicki Rosenzweig
vr at redbird.org
http://www.redbird.org


subject: [Wikipedia-l] image namespace

body:
I remember there being talk some time ago about
creating an Image namespace which I think would solve
this problem nicely... this could also eliminate
having to type
http://www.wikipedia.com/upload/blah_blah_blah.png,
which is not very user friendly.  But make sure doing
this doesn't break the non-English wikipedias!

Chuck

=====
Come to my homepage!  Venu al mia hejmpagxo!
http://amuzulo.babil.komputilo.org/
====
Venu al la senpaga, libera enciklopedio
esperanta reta! http://eo.wikipedia.com/

_________________________________________________________
Do You Yahoo!?
Informaci?n de Estados Unidos y Am?rica Latina, en Yahoo! Noticias.
Vis?tanos en http://noticias.espanol.yahoo.com


body:
Is my sense of the general opinion correct, that we should keep the
current "overwriting-uploaded-files-is-ok" policy unless and until we
implement a more sophisticated image history system?

Axel


from_name: Brion L. VIBBER

subject: [Wikipedia-l] Re: [Wikitech-l] Bug bugs!

body:
On lun, 2002-05-20 at 16:22, The Cunctator wrote:
> What is going on?
>
> Warning: Supplied argument is not a valid MySQL result resource in
> /home/wiki-newest/work-http/wikiPage.php on line 215
>
>
> Warning: Supplied argument is not a valid MySQL result resource in
> /home/wiki-newest/work-http/wikiPage.php on line 219
>
> Also, pages aren't updating from [Link]? to working links when I create the
> pages.

As noted in http://www.wikipedia.com/wiki/wikipedia:Bug+reports/Editing
this is now fixed in CVS. (Two one-character typos, which were hidden
from execution and thus never found and fixed during the period that
caching was disabled.)

Jimbo, I highly recommend updating to the CVS version (which also fixes
some watchlist bugs, list rendering bugs, and redirect bugs) and
clearing the page cache. (The page cache should always be cleared when
the software is upgraded in a way that might change the way pages are
rendered -- like fixing rendering bugs!)

  UPDATE cur SET cur_cache="",cur_timestamp=cur_timestamp

-- brion vibber (brion @ pobox.com)


subject: [Wikitech-l] Bug bugs!


subject: [Wikipedia-l] image namespace

body:
On lun, 2002-05-20 at 12:17, Chuck Smith wrote:
> I remember there being talk some time ago about
> creating an Image namespace which I think would solve
> this problem nicely... this could also eliminate
> having to type
> http://www.wikipedia.com/upload/blah_blah_blah.png,

I like that; in [[Germany]] for instance there could be:

  [[image:de-flag.jpg]]

which would be the equal, after rendering, of

  http://www.wikipedia.com/upload/de-flag.jpg

We could also use the name-piping feature to add alt text (short
descriptions of the image for text-mode and speech browsers):

  [[image:de-flag.jpg|German flag]]

It might be desireable also to make the images themselves link to an
information page, which could include the list of articles that use the
image, when it was uploaded (and by whom), etc.

> which is not very user friendly.  But make sure doing
> this doesn't break the non-English wikipedias!

I can't think of any reason to gratuitously break the old syntax -- we
might still want to be able to link to external images (with
permission), and I'd prefer not to break the zillions of existing pages
using full URLs! (They could be auto-corrected by a script, though.)

-- brion vibber (brion @ pobox.com)


subject: [Wikipedia-l] Bug bugs!

body:
At 09:46 AM 5/21/02 +1000, Karen AKA Kajikit wrote:

>I noticed that - it's WIERD! If you follow a newly created link or
>redirect like that it takes you to an edit screen for the entry, with
>the text you just added on it. I guess it's something to do with
>caching?

Also, I deleted a couple of pages that were listed on the
votes-for-deletion page and afterward the links leading to them still
showed them as "existing" pages rather than links to the editing page.

--
"Let there be light." - Last words of Bomb #20, "Dark Star"


subject: [Wikipedia-l] Bug bugs!

body:
What is going on?

Warning: Supplied argument is not a valid MySQL result resource in
/home/wiki-newest/work-http/wikiPage.php on line 215

Warning: Supplied argument is not a valid MySQL result resource in
/home/wiki-newest/work-http/wikiPage.php on line 219

Also, pages aren't updating from [Link]? to working links when I create the
pages.

E.g. I made the [[tobacco industry]] link on the Cigarette entry, then made
the Tobacco industry page, but the Cigarette entry still displays [tobacco
industry]?.


subject: [Wikitech-l] Bug bugs!


subject: [Wikipedia-l] Need to alter the front page links to include East Timor

body:
Somebody who can alter the breaking news and current events list needs
to add East Timor to it. I think the creation of a 'new country' (even
though it's not actually new) is kind of important... Somebody who knows
about politics could write a better article for the subject too.

--

Karen AKA Kajikit

Come and visit my part of the web:
Kajikit's Corner: http://Kajikit.netfirms.com/
Aussie Support Mailing List: http://groups.yahoo.com/group/AussieSupport
Allergyfree Eating Recipe Swap:
http://groups.yahoo.com/group/Allergyfree_Eating

Love and huggles to all!


from_name: Jason Richey

subject: [Wikitech-l] php-wiki de

body:
I have set up the test site at http://test-de.wikipedia.com/, I had to
remove an insert from the newiki.sql because it was causing an error.
Of course, I lost the exact text of the error somewhere, but it
basically said that there was already an entry for Main_Page (the
entry I removed looked like it may have been a discussion forum for
the actual main page).  However, it was a fairly large chunk.  So,
take a look.

A diff to my modified newiki.sql is attached.

--
"Jason C. Richey" <jasonr at bomis.com>

-------------- next part --------------
133229,133372d133228
< ----
<
< Im Prinzip ist es ja eine gute Idee, von der Homepage zu den Unterkategorien zu linken, die sich hinter den mehrzahligen Begriffen verbergen (z.B. [[Gewerkschaften]]). Dort findet sich dann eine Aufz??hlung. Allerdings sind Neulinge oft irritiert, weil sie unter dem Eintrag auch die Definition (+ Geschichte etc.) vermuten, die aber wie ??blich unter der Einzahl steht (z.B. [[Gewerkschaft]]). Ist das klug?

< Oder w??re es besser, die Leute zun??chst zur Definition zu schicken, von wo sie sich zu den Unterklassifizierungen weiterklicken k??nnen? Stelle ich mal zu Diskussion (wobei ich zu letzterem tendiere).

< An sich gef??llt mir die Trennung (Singular/Plural) ganz gut. Sie ist schl??ssig, ??bersichtlich und erlaubt gezielteres Setzen von Links, als wenn sich alles auf einer Seite befindet. Nur darf man nat??rlich das Hin- und Zur??cklinken nicht vergessen. Was meint Ihr? --[[Kurt Jansson]]
< ----
< Soweit die Unterscheidung zwischen Plural und Singular bei einem Wort m??glich ist, ist diese Aufteilung stimmig, was ist aber mit Begriffen die nicht z??hlbar sind, z.B. Musik? Auch bei dem Stichwort Recht ist grunds??tzlich zwischen Definition und weiteren Verweisen zu unterscheiden, allerdings scheint mir \"Rechte\" als entsprechender Seiteneintrag nicht auf Anhieb nachvollziehbar.  -- [[Carsten Loscher]]
<
< Wie w??re es bei Musik mit Musikrichtungen oder Musikstile, bei Recht mit [[Recht (Aufz??hlung)]]? Naja, klingt etwas komisch, aber die Idee sollte klar sein :)

< Vielleicht ist Trennen auch nicht immer das Beste. --[[Vulture]]
< ----
<
< Gibt es eigentlich eine M??glichkeit die Seiten die den Zugriff ??ber alphabetische Stichw??rter regeln, automatisch erstellen zu lassen? Oder anders gefragt wie kriege ich es den Griff, da?? ein Eintrag (z.B. Virginia, Woolf) in allen Systematischen Verzeichnissen erscheint in denen er wegen der Vollst??ndigkeit gebraucht wird (bei Virginia Woolf, z.B. unter Autoren und Personen und welchen noch? -- [[Carsten Loscher]].
<
< Nein, leider nicht. Unter [[Suche Person/Alle]] stehen grad alle aus dem [http://de.wikipedia.com/wiki.cgi?action=index Index] - zumindest alle, die ich als Person erkannt habe. Ansonsten hilft nur Handarbeit, also gleich beim Erstellen entsprechend eintragen. --[[Vulture]]
<
< ----
<
< Noch eine grunds??tzliche Frage: Gibt es die M??glichkeit die Software und den Wiki-\"Standard\" zu ver??ndern oder anzupassen? Sinnvoll schiene mir eine Erweiterung um eine Art Metatags, die den Artikelinhalt beschreiben und anhand derer Skripte/Programme automatisch systematische Stichwortverzeichnisse erstellen k??nnten. --[[Carsten Loscher]]
<
< Das erscheint mir auch sinnvoll :) Siehe dazu auch [http://wikipedia.com/wiki/Wikipedia/Our_Replies_to_Our_Critics hier] im letzten Abschnitt. --[[Vulture]]
<
< ----
<
< Auf Anregungen aus Wiki-Kreisen habe ich heute (15.03.2002) mit einer Klasse das Projekt \"Wikipedia at school\" gestartet.
<
< ??ber den Ablauf des Projekts und meine Erfahrungen damit werde ich hier regelm????ig berichten.
<
< Infos:
<
< Gerhard Siegwart [[Siggi]]
< Lehrer an der
< Gotthard-M??ller-Schule
< (Grund- und Hauptschule mit Werkrealschule)
< La Souterrainer Stra??e 9
< 70794 Filderstadt
<
< 1. Vorstellung von Wikipedia in der Klasse 8a:
< Einige Sch??ler sind sehr interessiert, einige mehr beil??ufig, und wenige v??llig desinteressiert.
< Bei der Erl??uterung der M??glichkeiten (direkt online mit Beamer, Sch??ler ebenfalls online an den Sch??lerrechnern) zur Ver??nderung und Neuerstellung von Seiten kam nat??rlich sofort der Vorschlag: \"Da kann man ja alles l??schen!\"
< Also wurde auch gleich die Ansicht der verschiedenen Revisionen einer Seite gezeigt, und dann war den Sch??lern klar, dass ihnen ein endg??ltiges L??schen der Inhalte wohl nicht m??glich ist.
<
< Die Bedeutung der GDL und der GPL wurde besprochen, damit klar ist, dass nur selbstverfasste und/oder public-domain-Texte verwendet werden d??rfen.
<
< Hausaufgabe f??r die Sch??ler: Auf der Spielwiese die Editier und Formatierm??glichkeiten ausprobieren, das Tutorial durchlesen.
<
< N??chster Schritt wird die Themensuche sein.
< Erst wenn das Thema beschlossen und klar ist, k??nnen die Sch??ler mit Recherchen beauftragt werden.
< Zun??chst werden die Informationen nur gesammelt, und sp??ter wird dann der Artikel verfasst und bei Wikipedia eingebracht.
<
< [[Siggi]]
<
< ----
<
< Vorschlag:
<
< W??re es nicht sinnvoll, die neuen Beitr??ge oben einzutragen? Dann h??tte man sie immer gleich vor Augen!
<
< Ich wollte es nur nicht ungefragt eigenm??chtig machen. --[[Siggi]]
< ----
< Je ??fter ich bei Wikipedia rumschn??ffele, desto mehr beschleicht mich die Erkenntnis, dass vorheriges gr??ndlichs Nachdenken und ein getipptes Konzept (in einem ASCII-Editor) vor dem Einspeichern die richtige Vorgehensweise ist. Alleine die Korrekturen dieses [[Kurt Jansson]] zeigen mir deutlich: Darauf h??tte ich auch selbst kommen k??nnen :-)
<
< Ich werde mich bessern! -- [[Siggi]]
<
< ----
<
< Hey Siggi, mach dir mal keinen Kopf  ;-) Zum ??berarbeiten und Verbessern ist die Wikipedia ja schlie??lich da - den perfekten Artikel gibt es nicht, wir k??nnen nur versuchen m??glichst nahe dranzukommen.

< Die Reihenfolge der Diskussionsbeitr??ge zu ??ndern halte ich f??r keine gute Idee, zum einen hat es sich eingeb??rgert (okay, kein gutes Argument), und zum anderen ist die Diskussion so f??r sp??tere Leser (die im Endeffekt die Mehrheit bilden) am einfachsten nachzuvollziehen.
<
< Ich habe mal die ersten Zeilen etwas ??berarbeitet. Die vielen Links ??berfordern Neulinge eher, zumal sie ja auf der Willkommens-Seite auch schon stehen. Au??erdem k??nnen wir wohl mitlerweile auch mit unserer eigenen Artikelzahl klotzen (und mit der neuen Software haben wir dann ja auch einen Counter ...)
< --[[Kurt Jansson]]
<
< ----
<
< Hey, wie w??rs die ??berschrift Wissenschaft zu verlinken mit dem Artikel [[Wissenschaft]] ? Ich sehe sonst keine einfache Weise auf das Stichwort zuzugreifen.
<
< --[[GillianAnderson]]
<
<
<
 Gute Idee, ich habe mal alle ??berschriften wikifiziert, warum auch nicht? Ein paar Eintr??ge erscheinen mir recht speziell f??r eine Portal-Seite, aber da denke ich nochmal dr??ber nach.

< Wei?? jemand wie der aktuelle Status der beiden spanischen Wikipedias ist? Jemand hat auf unserer Homepage die \'alte\' durch die \'neue\' ersetzt. Ist das okay? Oder sollten wir beide verlinken? (Meine pers??nliche Meinung ist, da?? es wenig relevant ist, auf welchem Server das Projekt gehostet wird, sondern ob es in unserem Geist gef??hrt wird.) --[[Kurt Jansson]]
<
< Ich finde es sollten beide verlinkt werden. Wikipedias leben von Beitr??gen und wenn sie nicht zu finden sind so ist das sehr schlecht f??r ihr Wachstum. In beiden ist anscheinend bereits Material, es w??re also schade.
< --[[GillianAnderson]]
<
<
< ----
<
< k??nnte man nicht (vieleicht gibts es schon und ich habs noch nicht gefunden *g*), eine seite anlegen an dem sich die autoren bei wikipedia unterhalten (auch ??ber nicht wiki-zeugs) tipps geben, intressante links austauschen usw., k??nnen??
<
< sagt doch mal was ihr dazu meint
< --gruss [[draggi]]
<
< vielleicht [[wikipedianer/Talk]]  .. [[StefanRybo]]
<
< Ich selbst bin mit dem verteilten Talk zufrieden. Zumal der st??ndige Blick auf \'Letzte ??nderungen\' immer anzeigt, wo gerade jemand seine Meinung kundtut (soweit er oder sie sich daran h??lt, daf??r Talk oder User seiten zu benutzen. [[StefanRybo]]
<
< Draggis Vorschlag gef??llt mir. Ich hatte sowas in der Art auch schon vermisst. Die verschiedenen Talkseiten sind ok, wenn es um ganz konkrete Sachthemen geht. Aber f??r eine nette kleine Unterhaltung, auch off-topic, finde ich [[wikipedianer/Talk]] passender. -- [[Ben-Zin]]
< --------------
< Hallo an Alle,
<
< 1.Ich habe angefangen ein paar Artikel einzutun. Da ich nur ein keyboard ohne Umlaute und ohne sz habe, ist das oft sehr stoerend mit dem ae  usw, besonders wenn ich neue Themen anfange. [[Kurt Jansson]] hat mir schon geholfen. Ich will aber mehr eintippen und habe versucht, beim Text die Umlaute zu kopieren. Jedes einzeln ist aber schrecklich pieselich. Hat jemand einen Einfall, wie ich besser die Umlaute tippen koennte. Ich kann ja nicht staendig Kurt damit belaestigen.
<
< 2.Ebenfalls stoert, dass dieses wiki keine Begrenzung des Textes rechts eingebaut hat. In anderen Worten , es kommt zu breit raus und sieht nicht schoen aus. Hat da jemand einen Einfall?
<
< 3.[[Ben-Zin]]\'s Vorschlag, wikipedianer/Talk evtl. wikipedi/Rede ? waere mir Beides recht.
<
< 4.Gibt es einen, der dieses Deutsche Wiki leitet oder dafuer verantwortlich ist, oder ist alles vom wiki/international geleitet ?
<
< [[H. Jonat]]
<
< zu 1.: Vor ein paar Wochen hatte ich schon mal in der wikitech-l-Mailingliste gefragt. Dort hie?? es, zur Zeit solle man noch HTML-Entities benutzen, also (Auszug aus [http://de.selfhtml.org/html/allgemein/zeichen.htm SelfHTML]):
<
< Ersetzen Sie das Zeichen ä durch die Zeichenfolge &auml;

< Ersetzen Sie das Zeichen Ä durch die Zeichenfolge &Auml;

< Ersetzen Sie das Zeichen ö durch die Zeichenfolge &ouml;

< Ersetzen Sie das Zeichen Ö durch die Zeichenfolge &Ouml;

< Ersetzen Sie das Zeichen ü durch die Zeichenfolge &uuml;

< Ersetzen Sie das Zeichen Ü durch die Zeichenfolge &Uuml;

< Ersetzen Sie das Zeichen ß durch die Zeichenfolge &szlig;
<
< Beim Wechsel zum PHP-Script und [[Unicode]] w??rde das dann automatisch konvertiert (und durch ein einfacheres System ersetzt). Mal sehn ob das klappt ...
<
< zu 2.: Wei?? nicht genau was Du meinst, bei mir ist nichts zu breit. Beschreib mal genauer :-)
<
< zu 4.: Weder noch w??rde ich mal sagen. Jimbo Wales, der den Server betreibt, ist der deutschen Sprache kaum m??chtig, wir k??nnen hier also treiben was wir wollen - [[Anarchie]] pur! :-)

< Allerdings gibt es schon ein paar Leute, die sich f??r das Projekt verantwortlich f??hlen (mich eingeschlossen). Was sicher fehlt ist ein eindeutiger Ansprechpartner von au??en, z.B. f??r Leute, die mit uns zusammenarbeiten wollen oder f??r Journalisten. --[[Kurt Jansson]]
<
< Hallo :)
< zu 2: Das kenne ich nur von vorformatiertem Text (mit Leerzeichen am Zeilenanfang bzw. entsprechenden HTML-Tags). Das sieht man dann auch an der Schrift (alle Zeichen sind gleich breit - wie auch immer das noch mal hei??t), die keine Proportionalschrift mehr ist. Ist glaube ich auch f??r HTML normal, dass da kein automatischer Zeilenumbruch stattfindet, allerdings werden entsprechend CR als Zeilenumbruch interpretiert.
< --[[Vulture]]
< ---------
< Hallo Kurt und Vulture,
<
< 1.das werde ich mal ausprobieren ä
<
< 2.Das kann man beim wikipedia englisch sehen http://www.wikipedia.com ,wenn man da Text eintippt, bekommt man eine \"eingerahmte\" Seite, rechts mit Rahmen, allerdings auch mit Rubriken. Ausserdem haben die jetzt neu mit hellgruener Umrahmung angefangen, was den Augen gut tut.
<
< 3. Kurt, kann ich vorschlagen, dass Du der Ansprechpartner bist ? Wie ich sehe, hast Du das schon gemacht. Wenn Du das nicht staendig machen willst, dann koennen wir nach jemand anderen fragen.
< Wenn Jimbo Wales dieses Deutsche wiki auch auf seinem server fuehrt, dann hat er letzthin die hoechste Gewalt. Koennte also bestimmen oder abschalten, wenn er wollte.
<
< Vielen Dank fuer die Auskuenfte.
<
< :''See also :'' [[HomePage]]","Automated conversion",0,"conversion script",LAST_INSERT_ID(),1);


from_name: Lee Daniel Crocker

subject: [Wikitech-l] New codebase in CVS

body:
The "newcodebase" directory in CVS now contains the codebase I've been
working on.  The structure is complete and the basic functions of user
logins, page viewing, and editing are filled in.  Filling in the rest
should be a pretty straightforward case of fleshing out functions that
are already in place with modified code from the old codebase.  It looks
like it will fix a lot of problems, and it's a real miser on database
accesses.

Both codebases are running on my server (the old code is at
http://www.piclab.com/wiki/wiki.phtml, and the new code is at
http://www.piclab.com/newwiki/wiki.phtml, each with a March dump of
the Wikipedia database).  I'd again like to stress that coders can use
that for testing before installation.

--
Lee Daniel Crocker <lee at piclab.com> <http://www.piclab.com/lee/>
"All inventions or works of authorship original to me, herein and past,
are placed irrevocably in the public domain, and may be used or modified
for any purpose, without permission, attribution, or notification."--LDC


subject: [Wikitech-l] New codebase in CVS

body:
On lun, 2002-05-20 at 22:31, Lee Daniel Crocker wrote:
> Both codebases are running on my server (the old code is at
> http://www.piclab.com/wiki/wiki.phtml, and the new code is at
> http://www.piclab.com/newwiki/wiki.phtml, each with a March dump of
> the Wikipedia database).  I'd again like to stress that coders can use
> that for testing before installation.

By the way, Jimbo just made a new database dump:
http://www.wikipedia.com/tarballs/wikipedia_dump_20020520.sql.gz

-- brion vibber (brion @ pobox.com)


subject: [Wikipedia-l] Paedophilia on Wikipedia

body:
Um... why is paedophilia in 'current events and breaking news'?

Dragon Dave.


subject: [Wikipedia-l] Paedophilia on Wikipedia

body:
At 08:03 AM 5/21/02 +0100, Dragon Dave wrote:
>Um... why is paedophilia in 'current events and breaking news'?

Probably because of the current scandal in the US about pedophile priests
and the Catholic Church.

--
Vicki Rosenzweig
vr at redbird.org
http://www.redbird.org


subject: [Wikipedia-l] Bug bugs!

body:
The Cunctator wrote:
>
> What is going on?
>
> Warning: Supplied argument is not a valid MySQL result resource in
> /home/wiki-newest/work-http/wikiPage.php on line 215
>
> Warning: Supplied argument is not a valid MySQL result resource in
> /home/wiki-newest/work-http/wikiPage.php on line 219
>
> Also, pages aren't updating from [Link]? to working links when I create the
> pages.
>
> E.g. I made the [[tobacco industry]] link on the Cigarette entry, then made
> the Tobacco industry page, but the Cigarette entry still displays [tobacco
> industry]?.

I noticed that - it's WIERD! If you follow a newly created link or
redirect like that it takes you to an edit screen for the entry, with
the text you just added on it. I guess it's something to do with
caching?

--

Karen AKA Kajikit

Come and visit my part of the web:
Kajikit's Corner: http://Kajikit.netfirms.com/
Aussie Support Mailing List: http://groups.yahoo.com/group/AussieSupport
Allergyfree Eating Recipe Swap:
http://groups.yahoo.com/group/Allergyfree_Eating

Love and huggles to all!


subject: [Intlwiki-l] Re: [Wikitech-l] php-wiki de

body:
On mar, 2002-05-21 at 06:28, Kurt Jansson wrote:
> > I have set up the test site at http://test-de.wikipedia.com/,
>
> Thanks Jason! I informed the German Wikipedians and hope they'll start
> playing around with it soon.
>
> I wrote down some bugs I found on
> http://test-de.wikipedia.com/wiki/wikipedia:Beobachtete+Fehler
>
> But that's in German, and I don't know anybody else but Magnus will
> understand it. So shell I post a (bad) translated report to wikitech-l
> from time to time?
>
> * The search for words with umlauts doesn't seem to work. The script
> doesn't find them,

Hmm, looks like the search needs another drubbing. I believe it's
chopping up words at the boundaries of non-ASCII characters; if your
word is big enough on either end (?bersetzung, terroranschl?ge) this
does a good enough job anyway, but it's hardly the way it should work!

I'll try it on my own machine later today; if it works there, I'll send
some MySQL character set config tweaks I've made that may help.

> and when I search for more than one word (including
> one with umlauts) I get MySQL errors.

I'm not getting that, this seems to work for me. (Try for example
"terroranschl?ge staaten".)

Note of course that the dreaded 4-character minimum is still in place.

> * The conversion didn't correct the upper and lower case problem in
> article titles. I thought someone made a script for this?

Working on it...

> * And can't we prevent the loss of article histories when converting to
> the new format?
>
> BTW, maybe it's possible to keep an unlimited revision history (and
> import the old ones) when the script is faster again, or when we change
> to the new server.

We already do this since ages. (But nobody's yet run the recovery script
which will add these to the *English* version which was converted with
an older, more primitive conversion script.)

Which articles are missing histories? I checked a few at random and so
far, so good.

> More complaints coming soon ... ;-)

Vielen dank!

-- brion vibber (brion @ pobox.com)