×
Create a new article
Write your page title here:
We currently have 3185 articles on s23. Type your article name above or click on one of the titles below and start writing!



s23
3185Articles

Template talk:Fnord

Revision as of 22:20, 18 March 2006 by 200.195.184.18 (talk)

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

Cookies help us deliver our services. By using our services, you agree to our use of cookies.