Directory

  • CB Plugin

MySQL Field Type Plugin

Rating
1 vote
DemoSubmit reviewRecommendContact OwnerVisitOwner's listing
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

- 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
Reviews (1)
Not working with cb 1.2.1
bybb66633, November 26, 2009
1 of 2 people found this review helpful
There are not parameters I can deal with.
Results 1 - 1 of 1

CBSubs 1.0

CBSubs 1.0.3 released!

Find out more about the revolutionary new Joomla subscription system:

Info on CBSubs

CB 1.2.3 Documentation

Thank you bonus:

ProfileBook (+Blog) 1.2RC
ProfileGallery 1.2RC2
CB Privacy 1.0RC

What? Why? Where?

Click here for a yearly subscription: subscribe now

CB 1.2.3 Download

Community Builder 1.2.3
Stable and native for:
Joomla 1.5 & 1.0 & Mambo
(incl. CB 1.2.3 Installation pdf)
You need to be a registered member to download.

Full 180 pages updated
CB 1.2.3 documentation:
You need to be a CB doc subscriber to download.

CB Login