'; $MyPmWiki_Username = ''; $MyPmWiki_Password = ''; $MyPmWiki_DBName = ''; $MyPmWiki_TableFmt = ''; include_once('cookbook/mypmwiki.php'); to a local customization file. This script is based on ideas by JamesDavis, but has been rewritten to work wiht PmWiki v2. Version 0.2 change Markup vom _begin to inline */ Markup('MyPmWiki','inline','/\(:MyPmWiki *(.+):\)/e',"MyPmWiki('\$1')"); function MyPmWiki($SQL) { global $MyPmWiki_Hostname, $MyPmWiki_Username, $MyPmWiki_Password, $MyPmWiki_DBName, $MyPmWiki_TableFmt; global $action; global $FarmD; $ExtraErrMsg = "Please contact the administrator of this wiki."; if (!isset($MyPmWiki_Hostname)) $MyPmWiki_Hostname = "localhost"; if (!isset($MyPmWiki_TableFmt)) $MyPmWiki_TableFmt = "border='1'"; if (!isset($MyPmWiki_Username)) return "Error: \$MyPmWiki_Username not defined. $ExtraErrMsg"; if (!isset($MyPmWiki_Password)) return "Error: \$MyPmWiki_Password not defined. $ExtraErrMsg"; if (!isset($MyPmWiki_DBName)) return "Error: \$MyPmWiki_DBName not defined. $ExtraErrMsg"; if (!$dbh = mysql_connect ($MyPmWiki_Hostname, $MyPmWiki_Username, $MyPmWiki_Password)) return "Connection Error: ".mysql_error()." $ExtraErrMsg";; if(!mysql_select_db ($MyPmWiki_DBName)) $resultStr = "Error: ".mysql_error()." $ExtraErrMsg"; elseif($result = mysql_query($SQL,$dbh)) { $resultStr = ""; for ($i = 0; $i < mysql_num_fields($result); $i++) { $resultStr .= ""; } $resultStr .= ""; while($row = mysql_fetch_row($result)) { $resultStr .= ""; foreach ($row as $field) $resultStr .= ""; $resultStr .= ""; } $resultStr .= "

".mysql_field_name($result, $i)."
$field

"; } else $resultStr = "SQL Error: ".mysql_error().""; mysql_close($dbh); return $resultStr; } ?>