Difference between revisions of "Extension:baselinker"

From Testiwiki
Jump to: navigation, search
(Usage)
Line 8: Line 8:
  
 
== Usage ==
 
== Usage ==
 +
 +
=== Basic ===
 +
 +
SQL-query is placed between '''<nowiki><sql-query></nowiki>''' and '''<nowiki></sql-query></nowiki>''' -tags
 +
 +
Example:
 +
<pre>
 +
<sql-query>
 +
select * from Variable
 +
</sql-query>
 +
</pre>
 +
 +
Generates: <sql-query>select * from Variable</sql-query>
 +
 +
Note that you can have line breaks etc. in your query. Character count is limited to 255.
 +
 +
=== Advanced ===
 +
 +
Extension has 2 additional parameters:
 +
 +
;name: Name parameter defines the name of the query link. Default is "Run query".
 +
;display: Display defines whether the SQL-query is displayed on the wiki page or not. Set this to "1" if you want your query to be displayed as pre-formatted wiki-text

Revision as of 09:51, 24 October 2008

This extension creates SQL-queries to The Result Database. Queries are actually passed as URL-parameter.

Installation

  1. Download extension file from here
  2. Place file into extension directory of your wiki
  3. Add this into your localsetting.php:
    require_once ( "$IP/extensions/rdblinker.php" );

Usage

Basic

SQL-query is placed between <sql-query> and </sql-query> -tags

Example:

<sql-query>
select * from Variable
</sql-query>

Generates: <sql-query>select * from Variable</sql-query>

Note that you can have line breaks etc. in your query. Character count is limited to 255.

Advanced

Extension has 2 additional parameters:

name
Name parameter defines the name of the query link. Default is "Run query".
display
Display defines whether the SQL-query is displayed on the wiki page or not. Set this to "1" if you want your query to be displayed as pre-formatted wiki-text