CB MySQL Field Plugin

Written by Joe Palmer | 18 September 2009

The MySQL field type plugin adds a "MySQL Field" to the available list of CB fields. It does not actually add a new field to the database and cannot be edited by the user. It simply queries the database and displays the result of a MySQL statement. Another Community Builder field can be defined for saving the result of the query if required.

You can choose whether the query will return a single result or multiple and define up to 5 parts of the MySQL query including the SELECT, the FROM, the WHERE, the ORDER BY and the LIMIT clause. You can also use {USERID} and {VIEWERID} in the WHERE clause which get substituted for the user’s ID and viewer’s ID of the currently viewed profile. You can restrict the query to only execute for the user and/or viewer as well as add a prefix, delimiter and suffix to the output.

Installation Instructions

1. Install the plugin through the CB Plugin Management page
2. Publish the plugin on the CB Plugin Management page
3. Add a new “MySQL Field” type from the CB Field Management page
4. Define a MySQL query and set the other parameters as desired