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.

You can define 3 parts to make up the MySQL query, the SELECT, the FROM and the WHERE clause. You can also use {USERID} and {VIEWERID} 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.

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