Eduardo Marcolino

<p>This ACF plugin makes it possible to store ACF data in structured database tables instead of WordPress core meta tables.</p>
<p>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.</p>
<p>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>.</p>
<p>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>.</p>
<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>
<p>This plugin supports the following relational field types: Post Object, Page Link, Relationship, Taxonomy and User.</p>
<p>It can store both single and multiple values based on the <code>multiple</code> option.</p>
<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>
<p>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>.<br />
Here is an example:</p>
<p>Table:</p>
<pre><code>+---------+-------------------+--------+
| post_id |       title       | stores |
+---------+-------------------+--------+
|       1 | Lord of the Flies | [1,2]  |
|       2 | The Island        | [2]    |
|       3 | 1984              | [3]    |
+---------+-------------------+--------+
</code></pre>
<p>Query:</p>
<pre><code>SELECT * FROM wp_acf_books WHERE JSON_CONTAINS(stores, 2, '$')
</code></pre>
<p>The query above will return “Lord of the Flies” and “The Island”.</p>
<h4>ACF Compatibility</h4>
<p>This plugin was tested with <em>ACF 5 FREE Version</em> .</p>


ACF: Fields in Custom Table

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

Maxime Culea

<p>To use ACF Beautiful Flexible, simply activate the plugin to improve the ACF flexible UI. By default, it uses random images, but the idea is to customize them by adding your own.</p>
<h4>Image convention</h4>
<ul>
<li>The size of image should be 366×150 or bigger 732×300.</li>
<li>They should be named based on the flexible key (<code>push_2_light</code>) with no underscores but dashes (<code>push-2-light.[extension]</code>).</li>
<li>The following extensions will be resolved in that order: <code>.jpg</code>, <code>.jpeg</code>, <code>.png</code> and <code>.gif</code>.</li>
</ul>
<h4>Where images should be situated</h4>
<p>They should more likely be situated into your theme <code>wp-content\themes\my-theme\assets\acf-beautiful-flexible\</code>. But if you have a child-theme and added images into it, these will overwrite those from parent-theme.<br />
The following directories will be solved according to order: plugin’s folder, child theme’s folder, theme’s folder.</p>
<p>Also note that you can filter this path to gather all your images into a same folder :<br />
    add_filter( ‘acf_beautiful_flexible.images_path’, $path );</p>
<p>Finally, you could filter all images like this :<br />
    add_filter( ‘acf_beautiful_flexible.images’, $images );</p>
<h4>About ACF Beautiful Flexible</h4>
<p>I, <a href="https://profiles.wordpress.org/MaximeCulea" rel="nofollow ugc">Maxime Culea</a>, have created this plugin which I only maintain. I do not guarantee some free support. Also, thank others listed in the <a href="https://github.com/MaximeCulea/acf-beautiful-flexible/blob/main/CREDITS.md" rel="nofollow ugc">credits</a>.</p>
<p>Consider reporting an <a href="https://wordpress.org/support/plugin/acf-beautiful-flexible/" rel="ugc">issue</a> and be patient.<br />
Any code suggestions? I am on <a href="https://github.com/maximeculea/acf-beautiful-flexible" rel="nofollow ugc">GitHub</a> as well!</p>


ACF Beautiful Flexible

ACF Beautiful Flexible: Transform ACF's flexible layouts list into a beautiful popup.

ACF: Fields in Custom Table vs ACF Beautiful Flexible