Hello All,
I have been reading around and have not been able to get this working, and am hoping someone, maybe John “the bidirectional King” Huebner.
I have used the Bidirectional tutorial on here and also John’s bidirectional Relationship tutorial but neither are working the way I need them and I can’t figure out how to adjust to get it working. I currently have the ACF Custom Database Tables plugin installed on my site, which stores the custom fields created by ACF in custom tables, and this is causing the above scripts to not work.
My setup is that I have Artists & Releases, and want them to be connected and bidirectional.
The first script requires field names to be the same, but CDT requires the different fields on different post types to have different names. So I have artist_release and release_artist
The second script pulls data using get_meta, but since the values are stored in custom database tables, it won’t pull the data using get_meta. I would have to use get_field and update_field, but have tried just updating the script to use those and when trying to update it either times out or runs forever.
I then thought I could use the first script, and assign the second field name based on the first. So I added in the “if($field_name =” part, and then assigned the field_name2 and field_key2 and adjusted the get/update fields to use the second name/key, but this isn’t working either. Any help or suggestions would be greatly appreciated!
function bidirectional_acf_update_value( $value, $post_id, $field ) {
// vars
$field_name = $field['name'];
$field_key = $field['key'];
if($field_name = 'artist_releases') { $field_name2 = 'release_artists'; $field_key2 = 'field_5bf7a2e215e5c'; }
if($field_name = 'release_artists') { $field_name2 = 'artist_releases'; $field_key2 = 'field_5bf79ed45b371'; }
$global_name = 'is_updating_' . $field_name;
// bail early if this filter was triggered from the update_field() function called within the loop below
// - this prevents an inifinte loop
if( !empty($GLOBALS[ $global_name ]) ) return $value;
// set global variable to avoid inifite loop
// - could also remove_filter() then add_filter() again, but this is simpler
$GLOBALS[ $global_name ] = 1;
// loop over selected posts and add this $post_id
if( is_array($value) ) {
foreach( $value as $post_id2 ) {
// load existing related posts
$value2 = get_field($field_name2, $post_id2, false);
// allow for selected posts to not contain a value
if( empty($value2) ) {
$value2 = array();
}
// bail early if the current $post_id is already found in selected post's $value2
if( in_array($post_id, $value2) ) continue;
// append the current $post_id to the selected post's 'related_posts' value
$value2[] = $post_id;
// update the selected post's value (use field's key for performance)
update_field($field_key2, $value2, $post_id2);
}
}
// find posts which have been removed
$old_value = get_field($field_name, $post_id, false);
if( is_array($old_value) ) {
foreach( $old_value as $post_id2 ) {
// bail early if this value has not been removed
if( is_array($value) && in_array($post_id2, $value) ) continue;
// load existing related posts
$value2 = get_field($field_name2, $post_id2, false);
// bail early if no value
if( empty($value2) ) continue;
// find the position of $post_id within $value2 so we can remove it
$pos = array_search($post_id, $value2);
// remove
unset( $value2[ $pos] );
// update the un-selected post's value (use field's key for performance)
update_field($field_key2, $value2, $post_id2);
}
}
// reset global varibale to allow this filter to function as per normal
$GLOBALS[ $global_name ] = 0;
// return
return $value;
}
add_filter('acf/update_value/name=related_posts', 'bidirectional_acf_update_value', 10, 3);
