CB MySQL Field Plugin

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 use {USERID} and {VIEWERID} in the MySQL statement 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. You can also choose to use CB field substitutions of the user or viewer with the field name in square brackets like [id] and [cb_fieldname].

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
MySQL Field Parameters
If you like this plugin, please consider writing a review on the Joomla Extension Directory or the Community Builder Directory...