External URL resolve to a timely url

here’s the problem:
it’s located in ../wp-content/plugins/all-in-one-event-calendar/app/view/event
script it ticket.php

if ( $event->get( 'contact_url' ) ) {
			$contact .=
			'<div class="ai1ec-contact-url">' .
			'<a class="url" target="_blank" href="' .
			esc_attr( $event->get( 'contact_url' ) ) .
			'"><i class="ai1ec-fa ai1ec-fa-fw ai1ec-fa-link"></i> ' .
			apply_filters(
				'ai1ec_contact_url',
				__( 'Event website', AI1EC_PLUGIN_NAME )
			) .
			' <i class="ai1ec-fa ai1ec-fa-external-link"></i></a></div>';
		}

just need to figure out how best to modify it without impacting core

narrowing the issue down —

ai1ec picks off the wrong value for $event->get( 'contact_url' )

strange that my MySQL table wp_ai1ec_events contains the proper value in the contact_url column for this post id.

strange too that the other contact table data appears and is pulled correctly, such as contact_email

so weird

wrote my own function

here’s the revision I implemented:

PART 1

edit /wp-content/plugins/all-in-one-event-calendar/app/view/event/ticket.php (yeah, I know…)

replace lines 70-81 with:

if(function_exists('get_correct_contact_url')) {
			if ( $event->get( 'contact_url' ) ) {
				$contact .=
				'<div class="ai1ec-contact-url">' .
				'<a class="url" href="' .
				get_correct_contact_url('mysql_db_table_name', esc_attr( $event->get('post_id'))) .
				'"><i class="ai1ec-fa ai1ec-fa-fw ai1ec-fa-link"></i> ' .
				apply_filters(
					'ai1ec_contact_url',
					__( 'Event website', AI1EC_PLUGIN_NAME )
				) .
				'</a></div>';
			}
		} else {
			if ( $event->get( 'contact_url' ) ) {
				$contact .=
				'<div class="ai1ec-contact-url">' .
				'<a class="url" target="_blank" href="' .
				esc_attr( $event->get( 'contact_url' ) ) .
				'"><i class="ai1ec-fa ai1ec-fa-fw ai1ec-fa-link"></i> ' .
				apply_filters(
					'ai1ec_contact_url',
					__( 'Event website', AI1EC_PLUGIN_NAME )
				) .
				' <i class="ai1ec-fa ai1ec-fa-external-link"></i></a></div>';
			}
		}

PART 2

create a new function in your theme’s functions.php file

<?php

function get_correct_contact_url( $wp_table = null, $post_id = null ) {

	$link = mysql_connect('host-name', 'your_username', 'your_password') or die(mysql_error());
	mysql_select_db('your_db_name', $link) or die(mysql_error());

	// mysql query
	$result = mysql_query('
		SELECT contact_url
		FROM ' . $wp_table . '
		WHERE post_id = "' . $post_id . '"
		LIMIT 1
	') or die(mysql_error());
	$row = mysql_fetch_row($result);
	mysql_free_result($result);
	return $row[0];

}

?>

PART 3

and either never update this plugin or save these code mods to apply again in future.

good luck.

??