Template talk:Fnord

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

Result - Random Fnords

<fnord> =

<fnord>

</fnord>

buy ambien buy phentermine buy viagra buy xenical fioricet ultram vicodin alprazolam levitra didrex diazepam propecia zoloft lipitor phentermine ambien xenical buy cialis buy valium buy fioricet buy tramadol buy carisoprodol buy ambien buy phentermine buy xenical buy valium buy tramadol buy fioricet buy carisoprodol buy cialis ambien adipex xanax ultram vicodin meridia didrex levitra diazepam alprazolam propecia zoloft lipitor xenical phentermine buy ambien buy phentermine buy xenical buy cialis buy valium buy fioricet buy tramadol buy carisoprodol ultram vicodin meridia alprazolam levitra didrex buy ambien buy adipex buy xanax buy phentermine buy xenical buy cialis buy valium buy fioricet buy tramadol buy carisoprodol buy hydrocodone ultram ambien adipex xanax xenical cialis valium tramadol carisoprodol buy phentermine buy xanax buy xenical buy xenical buy cialis buy ambien buy adipex buy phentermine buy xanax buy xenical buy cialis buy valium buy fioricet buy tramadol buy carisoprodol buy hydrocodone phentermine ambien adipex xanax xenical cialis valium fioricet tramadol carisoprodol ultram free ringtones hydrocodone vicodin buy valium buy tramadol buy carisoprodol buy hydrocodone ambien adipex xanax xenical cialis valium tramadol buy ambien adipex xanax carisoprodol hydrocodone buy ambien buy adipex buy xanax buy ambien buy adipex buy xanax buy xenical buy cialis buy valium buy tramadol buy carisoprodol buy xenical buy cialis buy valium buy tramadol buy carisoprodol buy hydrocodone buy phentermine buy fioricet ultram buy ambien buy phentermine buy adipex massage oil charm bracelets shower curtains buy xanax buy xenical buy cialis buy valium ambien ambien buy ambien buy adipex buy phentermine buy xanax buy xenical adipex xanax xenical cialis buy tramadol buy carisoprodol buy cialis buy valium ultram buy tramadol buy carisoprodol buy hydrocodone ambien adipex valium didrex xanax xenical cialis propecia tramadol carisoprodol valium tramadol carisoprodol hydrocodone phentermine hydrocodone phentermine tankless water heaters air purifiers laminate flooring buy ambien buy adipex buy xanax ambien buy xenical buy cialis buy valium buy tramadol buy phentermine adipex xanax xenical cialis valium tramadol buy carisoprodol buy hydrocodone carisoprodol hydrocodone phentermine