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.

You can define 3 parts to make up the MySQL query, the SELECT, the FROM and the WHERE 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 and/or 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

- Install the plugin through the CB Plugin Management page
- Publish the plugin on the CB Plugin Management page
- Add a new 'MySQL Field' type from the CB Field Management page
- Define a MySQL query and set the other parameters as desired

Feedback Forum

http://www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/catid,13/id,111666