stefanoulivieri

hi again
i’m using the free version.
Btw, it seems is a problem of ACF because using SCF everything works well

nevermind… that was not a solution
i still got the erro
and now ?it’s repeating test in the path twice.

Any suggestions?
thanks

Ok.

that’s what i found out
i got the error if i disable the use of the avatar in main configuration

everything seems ok.
i don’t know why this happen.
it happen also when i create a new user (and the photo avatar is not set at all)

nevermind, it works!

i think i found a solution

function pa_hide_um_main_meta_on_edit() {
if (isset($_GET[‘um_action’]) && $_GET[‘um_action’] == ‘edit’) {
echo ‘<style>.um-meta, .um-profile-connect, .um-member-connect { display: none; }</style>’;
}
}
add_action(‘wp_head’, ‘pa_hide_um_main_meta_on_edit’);

i did it ??

Using The Event Calendar plugin
Now it correctly list the future events form, listed in a category (id 352)

[select* lab]
[cf7-recordset id="post-data" type="database" engine="mysql" query="SELECT wp_posts.ID, wp_posts.post_title, wp_posts.guid, wp_postmeta.meta_value as event_start_date FROM {wpdb.posts} wp_posts LEFT JOIN {wpdb.term_relationships} ON (wp_posts.ID = {wpdb.term_relationships}.object_id) LEFT JOIN {wpdb.postmeta} wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) WHERE wp_posts.post_status = 'publish' AND wp_posts.post_type = 'tribe_events' AND {wpdb.term_relationships}.term_taxonomy_id = '352' AND wp_postmeta.meta_key = '_EventStartDate' AND wp_postmeta.meta_value >= CURDATE() ORDER BY wp_postmeta.meta_value ASC"]

[cf7-link-field recordset="post-data" field="lab" value="post_title" text="post_title" keep-options]

<script>document.addEventListener('cf7-recordset', function(evt){
  if(evt.detail['recordset-id'] == 'post-data') {
    let record_rows = [], 
        content_rows = evt.detail['recordset-data'], 
        row;
    for(var i in content_rows){
      row = content_rows[i]['post_title'].split(/[\n\r]/)
      record_rows.push({text: row[0], value:(1 < row.length ? row[1] : row[0] )});
    }
    cf7_datasource_set_recordset_data('post-data', record_rows);
  }
});</script>

now i wonder how to output the event start date (and not the publishing date of the event’s post)

i tried to remove thw cudate() but nothing, still not working
i’ve an event but it doesn’t showup

uff….

thanks anyway for the support!

Hi, thanks for the reply! ??

i got 7 events associated with the 352 category so i think it must works… but no luck in that way ??

The Event Calendar use “tribe_events_cat&tag_ID for the category terms… could that influence the query?

btw i tried removing the taxonomy filter but no post at all is extracted

Hi
at last i solved and changed the code, here it is:

[select* lab ]
[cf7-recordset id="post-data" type="database" engine="mysql" query="SELECT post_title, guid FROM {wpdb.posts} LEFT JOIN {wpdb.term_relationships} ON ({wpdb.posts}.ID = {wpdb.term_relationships}.object_id) WHERE post_status='publish' AND post_type='tribe_events' AND {wpdb.term_relationships}.term_taxonomy_id='352' AND post_date >= CURDATE() ORDER BY post_date DESC"]
[cf7-link-field recordset="post-data" field="lab" value="post_title" text="post_title" keep-options]

<script>
document.addEventListener('cf7-recordset', function(evt) {
  if (evt.detail['recordset-id'] === 'post-data') {
    let record_rows = evt.detail['recordset-data'].map(row => ({ text: row.post_title, value: row.post_title }));
    // Aggiorna i dati del recordset
    cf7_datasource_set_recordset_data('post-data', record_rows);
  }
});
</script>

it worked, but with the last wp’s core update it stopped working
and i can’t figure out the trouble.

any ideas?

thanks a lot ??

Thanks for the answer!
it was very usefeull!

now it works…but….. i got just 1 result instead a list

<strong>Show</strong>
[select* show ]
[cf7-recordset id="post-data" type="database" engine="mysql" query="SELECT post_title,post_content,guid FROM {wpdb.posts} LEFT JOIN {wpdb.term_relationships} ON ({wpdb.posts}.ID = {wpdb.term_relationships}.object_id)  WHERE post_status='publish' AND post_type='tribe_events' AND {wpdb.term_relationships}.term_taxonomy_id='243' ORDER BY post_date DESC"]

[cf7-link-field recordset="post-data" field="show" value="value" text="text" keep-options]

<script>document.addEventListener('cf7-recordset', function(evt){
    if(evt.detail['recordset-id'] == 'post-data') {
        let record_rows = [], content_rows = evt.detail['recordset-data'][0]['post_title'].split(/[\n\r]/);
        for(var i in content_rows) record_rows.push({text: content_rows[i], value:content_rows[i]});
        cf7_datasource_set_recordset_data('post-data', record_rows);
    }
});</script>

??

and still i’v to reslv how to don’t show the events that are just finished

BTW thanks for your help ??

i forgot… there’s also a way to filter by taxonomy name?
the event calendar got his own custom taxonomy “tribe_events_cat”

sigh! thanks ??

thanks a lot!
i missed the answer.

now i’ll check it ??

unlucky it persist
problem go away only if i deactivate the plugin