Content added Content deleted
imported>mutante mNo edit summary |
imported>mutante mNo edit summary |
||
Line 11: | Line 11: | ||
</pre> |
</pre> |
||
=== Made fnord.sql import file === |
==== Made fnord.sql import file ==== |
||
Using [[UltraEdit]] Macros i added '''insert into fnord.fnord (text) values ("''' to the start and '''");''' to the end of every line from [http://is-root.de/~mutante/fnord.txt this file]. |
Using [[UltraEdit]] Macros i added '''insert into fnord.fnord (text) values ("''' to the start and '''");''' to the end of every line from [http://is-root.de/~mutante/fnord.txt this file]. |
||
=== Imported into wikidb.fnord === |
==== Imported into wikidb.fnord ==== |
||
<pre> |
<pre> |
||
Line 21: | Line 21: | ||
</pre> |
</pre> |
||
=== Made Fnord Mediawiki extension === |
==== Made Fnord Mediawiki extension ==== |
||
<pre> |
<pre> |
||
Line 68: | Line 68: | ||
put this into /var/www/wiki/extensions/ as FnordExtension.php |
put this into /var/www/wiki/extensions/ as FnordExtension.php |
||
=== Included extension in LocalSettings === |
==== Included extension in LocalSettings ==== |
||
Added '''include("extensions/FnordExtension.php");''' to the end of /var/www/wiki/LocalSettings.php''' |
Added '''include("extensions/FnordExtension.php");''' to the end of /var/www/wiki/LocalSettings.php''' |
Revision as of 13:52, 17 April 2005
How this works
Created mysql table
CREATE TABLE `fnord` ( `id` int(11) NOT NULL auto_increment, `text` varchar(255) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
Made fnord.sql import file
Using UltraEdit Macros i added insert into fnord.fnord (text) values (" to the start and "); to the end of every line from this file.
Imported into wikidb.fnord
mysql -u root -p wikidb < fnord.sql
Made Fnord Mediawiki extension
<?php # Fnord Mediawiki extension # display random fnord definitions in wiki pages using a <fnord> tag # inside a {{Template:Fnord}} # input can be used for LIMITing the mysql random select (later) # by mutante 17.04.2005 $wgExtensionFunctions[] = "wfFnordExtension"; function wfFnordExtension() { global $wgParser; $wgParser->setHook( "fnord", "renderFnord" ); } function renderFnord( $input ) { $input = mysql_escape_string($input); # check if input is integer else set to 1 if (is_int($input)){ $limit = $input; } else { $limit = 1; } $hd = mysql_connect("localhost", "wikiuser", "PASSWORD") or die ("Unable to connect"); mysql_select_db ("wikidb", $hd) or die ("Unable to select database"); $res = mysql_query("SELECT * from fnord ORDER BY rand() LIMIT 0,$limit", $hd) or die ("Unable to run query"); while ($row = mysql_fetch_assoc($res)) { $id = $row["id"]; $fnord = $row["text"]; } $output = " $fnord ((K)fnord_id #$id))"; return $output; } ?>
put this into /var/www/wiki/extensions/ as FnordExtension.php
Included extension in LocalSettings
Added include("extensions/FnordExtension.php"); to the end of /var/www/wiki/LocalSettings.php
<fnord> =