'; $odbcPMWiki_Username = ''; $odbcPMWiki_Password = ''; $odbcPMWiki_TableFmt = ''; include_once('cookbook/odbcpmwiki.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('odbcPmWiki','inline','/\(:odbcPmWiki *(.+):\)/e',"odbcPmWiki('\$1')"); function odbcPMWiki($SQL) { global $odbcPMWiki_dsn, $odbcPMWiki_Username, $odbcPMWiki_Password, $odbcPMWiki_TableFmt; global $action; global $FarmD; $ExtraErrMsg = "Please contact the administrator of this wiki."; if (!isset($odbcPMWiki_dsn)) return "Error: \$odbcPMWiki_dsn not defined. $ExtraErrMsg"; if (!isset($odbcPMWiki_TableFmt)) $odbcPMWiki_TableFmt = "border='1'"; if (!isset($odbcPMWiki_Username)) return "Error: \$odbcPMWiki_Username not defined. $ExtraErrMsg"; if (!isset($odbcPMWiki_Password)) return "Error: \$odbcPMWiki_Password not defined. $ExtraErrMsg"; if (!$dbh = odbc_connect ($odbcPMWiki_dsn, $odbcPMWiki_Username, $odbcPMWiki_Password)) return "Connection Error: ".odbc_error()." $ExtraErrMsg";; if($result = odbc_exec($dbh,$SQL)) { $resultStr = ""; for ($i = 1; $i <= odbc_num_fields($result); $i++) { $resultStr .= ""; } $resultStr .= ""; while(odbc_fetch_row($result)) { $resultStr .= ""; for($i=1;$i<=odbc_num_fields($result);$i++) { $resultStr .= ""; } $resultStr .= ""; } $resultStr .= "

".odbc_field_name($result, $i)."
".odbc_result($result,$i)."

"; } else $resultStr = "SQL Error: ".odbc_error().""; odbc_close($dbh); return $resultStr; }