Eduardo Marcolino

This ACF plugin makes it possible to store ACF data in structured database tables instead of WordPress core meta tables.
It uses ACF’s <code>acf/update_field_group</code> hook to create/update the database and then uses <code>acf/save_post</code> hook to store the data.
It was heavily inspired by Austin Ginder’s post <a href="https://anchor.host/acf-custom-fields-stored-in-custom-table/" rel="nofollow ugc">https://anchor.host/acf-custom-fields-stored-in-custom-table/</a>.
You can contribute to this plugin by submit PR/Issue in <a href="https://github.com/eduardo-marcolino/acf-fields-in-custom-table" rel="nofollow ugc">https://github.com/eduardo-marcolino/acf-fields-in-custom-table</a>.
<h4>Supported Fields</h4>
<ul>
<li>Text</li>
<li>Text Area</li>
<li>Number</li>
<li>Range</li>
<li>Email</li>
<li>URL</li>
<li>Password</li>
<li>Image</li>
<li>File</li>
<li>Wysiwyg Editor</li>
<li>oEmbed</li>
<li>Select</li>
<li>Checkbox</li>
<li>Radio Button</li>
<li>Button Group</li>
<li>True / False</li>
<li>Date Picker</li>
<li>Date Time Picker</li>
<li>Time Picker</li>
<li>Color Picker</li>
<li>Link</li>
<li>Post Object</li>
<li>Page Link</li>
<li>Relationship</li>
<li>Taxonomy</li>
<li>User</li>
</ul>
<h4>Relational Fields</h4>
This plugin supports the following relational field types: Post Object, Page Link, Relationship, Taxonomy and User.
It can store both single and multiple values based on the <code>multiple</code> option.
<ul>
<li>If it’s a single value field, then the column type will be <code>bigint(20) unsigned</code></li>
<li>If it’s a multiple value field, then the column type will be longtext and the date will be stored in json format.</li>
</ul>
You can query relational fields with multiple values using using MySQL’s function <a href="https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#function_json-contains" rel="nofollow ugc">JSON_CONTAINS</a>. 
Here is an example:
Table:
<pre><code>+---------+-------------------+--------+
| post_id | title | stores |
+---------+-------------------+--------+
| 1 | Lord of the Flies | [1,2] |
| 2 | The Island | [2] |
| 3 | 1984 | [3] |
+---------+-------------------+--------+
</code></pre>
Query:
<pre><code>SELECT * FROM wp_acf_books WHERE JSON_CONTAINS(stores, 2, '$')
</code></pre>
The query above will return “Lord of the Flies” and “The Island”.
<h4>ACF Compatibility</h4>
This plugin was tested with ACF 5 FREE Version .

ACF: Fields in Custom Table

Stores ACF custom fields in a custom table instead of WordPress core meta tables.

BuddyDev

Brajesh Singh

Ravi Sharma

BuddyPress Xprofile Custom Field Types plugin adds some essential field types to BuddyPress Profile.
The newly added BuddyPress field types are:- 
* Birthdate. 
* Image. 
* File. 
* Checkbox acceptance. 
* Country field. 
* From/To field(can be used to show 2 numbers or text strings). 
* Token (can be used to set a list of predefined approved codes for registration etc). 
* oEmbed ( allow your users to use youtube/facebook, vimeo and other oembed supporting urls to embed in their profile). 
* <a href="http://www.w3.org/TR/html-markup/input.email.html" title="Input type email - HTML5" rel="nofollow ugc">Email</a>. 
* <a href="http://www.w3.org/TR/html-markup/input.url.html" title="Input type url - HTML5" rel="nofollow ugc">Web</a>. 
* <a href="http://www.w3.org/TR/2013/NOTE-html-markup-20130528/input.date.html" title="Input type date - HTML5" rel="nofollow ugc">Datepicker</a>. 
* Custom post type selector. 
* Custom post type multiselector. 
* <a href="http://www.w3.org/TR/2013/NOTE-html-markup-20130528/input.color.html" title="Input type color - HTML5" rel="nofollow ugc">Colorpicker</a>. 
* Decimal number. 
* Number within min/max values. 
* Custom taxonomy selector. 
* Custom taxonomy multiselector. 
* Range input (slider) 
* <a href="https://select2.github.io/" rel="nofollow ugc">Select2 javascript plugin</a> for select boxes.
BuddyPress Xprofile Custom Field Types is 100% compatible with <a href="https://wordpress.org/plugins/bp-profile-search/" rel="ugc">BP Profile Search plugin</a>. 
At the moment, following fields are searchable using BP Profile Search:- 
* Birthdate 
* Datepicker 
* Color 
* Email 
* Web 
* Number Min/Max 
* Range Input 
* Decimal Number 
* Country 
Other fields such as post type, taxonomy etc., are not searchable as they are stored in serialized format( due to back compatibility).
The plugin is opensource and currently developed on github. We welcome you to be part of its future development at <a href="https://github.com/buddydev/bp-xprofile-custom-field-types" rel="nofollow ugc">https://github.com/buddydev/bp-xprofile-custom-field-types</a>.
Discuss the plugin on our <a href="https://buddydev.com/add-extra-buddypress-profile-fields-with-buddypress-xprofile-custom-field-types-plugin/" rel="nofollow ugc">release post</a> or view the plugin’s <a href="https://buddydev.com/plugins/bp-xprofile-custom-field-types/" rel="nofollow ugc">detailed documentation here</a>. 
The idea is based on @donmik’s plugin. This plugin is a complete rewrite. Some field type do share code with the original plugin. My guess, we are using 20-30% of the code for field types from the original.
In the future, we hope to add more fields.
Note: This plugin is not 100% backward compatible 
It is very easy to migrate. Should take less than 5 minute. If you are looking to move from the older plugin to this one, please read our <a href="https://buddydev.com/plugins/bp-xprofile-custom-field-types/#migrate" rel="nofollow ugc">migration guide</a>.
Note 2: The Custom taxonomy field does not allow you to categorize users. They allow you to let users select some terms and display the terms on their profile. 
 It is not intended for classifying user
<h4>Credit</h4>
<a href="http://donmik.com" rel="nofollow ugc">@donmik</a> for the <a href="https://github.com/donmik/buddypress-xprofile-custom-fields-type" rel="nofollow ugc">BuddyPress Xprofile Custom Fields Type</a> from where we adopted the field types in our first version. 
 In the first version, te plugin brought all the profile fields offered by the currently abandoned The <a href="https://github.com/donmik/buddypress-xprofile-custom-fields-type" rel="nofollow ugc">“BuddyPress Xprofile Custom Fields Type”</a> plugin.
<h4>More Plugins</h4>
We love BuddyPress, and we have created 100+ BuddyPress plugins. 
Please take a look at our 
 1. <a href="https://buddydev.com/plugins/" title="Best BuddyPress Plugins" rel="nofollow ugc">Free BuddyPress Plugins</a> 
 1. <a href="https://buddydev.com/plugins/category/buddypress-premium-plugins/" title="Best BuddyPress Premium Plugins" rel="nofollow ugc">Premium BuddyPress plugins</a> 
 We hope that it will help you take your BuddyPress network to the next level.
<h4>BuddyPress Custom development & Maintenance Service</h4>
If you need any assistance with setting up or adding new features to BuddyPress or this plugin, Our team is available for hire. 
Please use our <a href="https://buddydev.com/buddypress-custom-plugin-development-service/" rel="nofollow ugc">BuddyPress Development Services</a> for any custom development needs.

BuddyPress Xprofile Custom Field Types

This is a great plugin from the BuddyDev team,
It also saves me a lot of time when editing the users profiles,
Thanks Brajesh!
Regards
Ben

Great!

Awesome and an absolute day saver. Thank you developers.

Perfect. All the premium contents in free package

Good plugin, good support, even if we couldn't solve the problem :)

Good plugin, good support

Buddypress Xprofile Custom Field Types adds extra custom profile fields to BuddyPress. Field types are: Birthdate, Email, Url etc.

ACF: Fields in Custom Table vs BuddyPress Xprofile Custom Field Types