CB MySQL Field Plugin
Version
1.2 (last update on Aug 3, 2010)
Rating
Compatibility
Reviews
6
License
GPLv2 or later
Non-Commercial
Type
Date Added
9 October 2009
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
- 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
Images
Excellent plugin for CB that was much needed and does exactly what it says! No issues for the installation (I use J1.7 and CB 1.7). You'll need to be familiar with MySQL to get it to do what you want, but this is a very good feature for CB.
I knew nothing about MySQL, but the Softforge team was very responsive and answered my queries ver quickly in both Joomlapolis forums and by email.
Highly recommended!
I knew nothing about MySQL, but the Softforge team was very responsive and answered my queries ver quickly in both Joomlapolis forums and by email.
Highly recommended!
It's a great plugin and gives access to a lot although it took me some time getting it to work. The comments on the support site helped me allot.
The instructions on the documentation site could use some extra notes and examples to help getting started. #___comprofiler must be edited to you're own db prefix usually jos_comprofiler or jos_users and without the #
I am still figuring out how to get it to show multiple results. All these are positive comments on a great plugin offcourse.
The instructions on the documentation site could use some extra notes and examples to help getting started. #___comprofiler must be edited to you're own db prefix usually jos_comprofiler or jos_users and without the #
I am still figuring out how to get it to show multiple results. All these are positive comments on a great plugin offcourse.
This is by far the best addon for Community Builder. It really opens up the component to add whatever you need whenever you need it! Anything SQL can be crafted into a field. You've helped me make a good site simply amazing and a few of my clients are ecstatic. Bloody brilliant, thanks guys!
It seemed to be rather simple and difficult to understand extension for Community Builder but it actually came out as one of the best extensions for our website!
Simple means that it displays any value from a CB database which is actually great! The additional customization (code) makes it a real jewel! In our case we needed to read out a number of bird species saved in the database - the extension allowed to access the database, count the number of species by using the customizable code processing the database query and retrieving and displaying the wanted number!
The new version of the plugin that Joe has written swiftly on demand is even able to save the value into the database so this value can then be used in other CB plugins as an entry value.
Together with the other Joe´s extension for CB (CB Rank Field Plugin) this has made our website work the way we needed.
I have got great support and response from Joe even though the extension is for free!
This must be the extension for those who need to customize their CB website more than the default package allows!
Simple means that it displays any value from a CB database which is actually great! The additional customization (code) makes it a real jewel! In our case we needed to read out a number of bird species saved in the database - the extension allowed to access the database, count the number of species by using the customizable code processing the database query and retrieving and displaying the wanted number!
The new version of the plugin that Joe has written swiftly on demand is even able to save the value into the database so this value can then be used in other CB plugins as an entry value.
Together with the other Joe´s extension for CB (CB Rank Field Plugin) this has made our website work the way we needed.
I have got great support and response from Joe even though the extension is for free!
This must be the extension for those who need to customize their CB website more than the default package allows!
