Welcome to the new directory. If you find a bug, please report it on our Issue Tracker.

Arrow up
Arrow down

Joomla! Extensions Directory

logo

Introduction

Extension Specific, Community Builder extensions

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.

  • Get this

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

Being familiar with MySQL helps a lot. You can have fields of absolutely anything you want. Great plug-in!


Great plugin!


Posted on 19 August 2011

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!


Valuable Plugin


Posted on 27 November 2010

A flexible tool to display statistical data in user profiles.



The builder-style form to retreive data from database is a very good idea.



I found it quite easy to use provided that you have some knowledge of MySQL and Joomla! database model.



Thanks for a good extension!


Difficult but great!!


Posted on 18 August 2010

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.


Amazing Plugin


Posted on 04 August 2010

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 made our site!


Posted on 16 May 2010

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!

Shadowbox Media Viewer

Shadowbox Media Viewer

Free | Multimedia Display | Joe Palmer
2.5 3
Score:
76
31 reviews
Shadowbox is an online media viewer application that supports all of the web's most popular media publishing formats. Shadowbox is written entirely in JavaScript and CSS and is highly customisable. Using Shadowbox, website authors can showcase a wide assortment of media in all major browsers without navigating users away from the linking page. Although Shadowbox can be used in standalone mode, it's just as easy to use Shadowbox with your JavaScript library of choice for a given project. Shadowbox comes bundled with adapters for the following JavaScript frameworks: Prototype jQuery MooTools (requires 1.2 Core) Dojo Toolkit Yahoo! User Interface Library (requires yahoo-dom-event.js) Ext (requires ext-core.js) Shadowbox supports many different media formats via the Flash, QuickTime, and Windows Media Player browser plugins. Windows media files are supported on the Mac via the Flip4Mac QuickTime plugin. Shadowbox includes many front-end languages such as Arabic, Catalan, Czech, Danish, German (Swiss), German, English, Spanish, Estonian, Finnish, French, Galician, Hebrew, Hungarian, Indonesian, Icelandic, Italian, Japanese, Korean, Burmese, Dutch, Norwegian, Polish, Portuguese (Brazilian), Portuguese, Romanian, Russian, Slovak, Swedish, Turkish, Chinese (Simplified) and Chinese (Traditional). The simplest way to tell Shadowbox which links you want it to open is to add a rel="shadowbox" (or rel="lightbox") attribute to each link. See the documentation for full usage instructions.
p
Submit Article Redirect

Submit Article Redirect

Free | Content Submission | Joe Palmer
2.5
Score:
73
3 reviews
Submit Article Redirect is a simple content plugin that allows you to redirect a user to a chosen menu item with an optional message when they add or edit an article from the frontend. Installation Instructions Install/Upgrade the plugin through the normal Joomla Install/Uninstall page Open Submit Article Redirect in the Plugin Manager Select the menu item to redirect the user to when they add and/or edit an article Enter a message to display to the user on the add and/or edit article redirect page (optional) Save and publish the plugin v1.1 - Added check to make sure that it only triggers on core content.
p
SOBI2 fo Community Builder

SOBI2 fo Community Builder

Free | Community Builder extensions | Joe Palmer
2.5
Score:
0
8 reviews
The CB SOBI2 Plugin shows the SOBI2 entries of a user in a Community Builder Tab. It has been based on the original version for CB 1.1 by Derek Fernandes and Radek Suski and has been upgraded to use CB 1.2 and Joomla 1.5. Owners can edit and delete their entries if permission is set in the General Configuration of SOBI2. The icon, number of hits and end date for the entries can also be displayed. Usage instructions: Install the plugin through the CB Plugin Management page Edit the “CB SOBI2” plugin on the CB Plugin Management page Chose whether to show the icon, number of hits and end date for the entries Publish the plugin and configure the tab as required Changelog: v1.1: Fixed "always showing your entries" bug v1.2: Added paging and sorting options (Thanks Bosko) v1.2: Added Romanian language file (Thanks Sacas)
e
CB Rank Field

CB Rank Field

Free | Community Builder extensions | Joe Palmer
2.5
Score:
0
1 review
The rank field type plugin adds a “Rank Field” to the available list of Community Builder fields. It does not actually add a new field to the database and cannot be edited by the user. It simply calculates a user’s rank based on another CB field. You can define any numeric CB field that exists in the database (eg. any integer or decimal field) to be used to calculate the ranking. You can also set the rank ordering be selecting whether first place is the highest or lowest value. Usage instructions: Install the plugin through the CB Plugin Management page Publish the plugin on the CB Plugin Management page Add a new “Rank Field” type from the CB Field Management page Enter the name of a numeric CB field and select a rank ordering in the parameters Requires Community Builder v1.2 or above. All feedback and suggestions welcome.
e
CB Decimal Field

CB Decimal Field

Free | Community Builder extensions | Joe Palmer
2.5
Score:
0
0 reviews
The decimal field type plugin adds a “Decimal Field” to the available list of Community Builder fields. It is based on the built in integer field type and used a double precision floating-point MySQL data type to store the values. You can set a minimum and maximum allowed value as well as the number of decimal places the value is rounded to. Usage instructions: Install the plugin through the CB Plugin Management page Publish the plugin on the CB Plugin Management page Add a new field on the CB Field Management page Select the “Decimal Field” type and configure the parameters Requires Community Builder v1.2 or above. All feedback and suggestions welcome.
e
CB Ratio Field

CB Ratio Field

Free | Community Builder extensions | Joe Palmer
2.5
Score:
0
0 reviews
The ratio field type plugin adds a "Ratio 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 calculates a user's ratio based on 2 other numeric CB fields. You can define any 2 numeric CB fields that exist in the database (eg. any integer or decimal fields) to be used to calculate the ratio. If displayed as a decimal or percentage, you can set the number of decimal places to round the result to. If displayed as fraction, you have the option to simplify it if possible and define what is used as the separator. Installation Instructions Install the plugin through the CB Plugin Management page Publish the plugin on the CB Plugin Management page Add a new “Ratio Field” type from the CB Field Management page Define the field names to use and set the other parameters as desired
e

MySQL Field for CB

Version:
1.2
Developer:
Joe Palmer
Date added:
Oct 09 2009
License:
GPLv2 or later
Type:
Free download
Uses updater:
Includes:
Compatibility:
Download DemoNot available Support Documentation
  • Overall
    Not rated
  • Functionality

    Not rated
  • Ease of use

    Not rated
  • Documentation

    Not rated
  • Support

    Not rated