Associate User to Single Venue

I figured it out, but now I need some help with the form Validation…

what variables are actually passed to

add_action('um_submit_form_errors_hook', 'validate_venue', 99,1);
function validate_venue( $args ){}

the $args array?

I am trying to have a single validation check multiple conditions and then post the correct errors on the inputs.

I have it working for venue name, but now verifying its a unique address is making me struggle…

global $ultimatemember;
	global $wpdb;

		if ( isset( $args['venue-name'] ) ){
			$venueName = $args["venue-name"];
			$venueAddress = $args["street-address"];
			$venueCity = $args["city"];

			$return_name = $wpdb->get_col($wpdb->prepare("
				SELECT meta_key
				FROM {$wpdb->eo_venuemeta}
				WHERE meta_key = '_venue-name'
				AND meta_value = %s
				", $venueName ));

			$return_address = $wpdb->get_col($wpdb->prepare("
				SELECT meta_key
				FROM {$wpdb->eo_venuemeta}
				WHERE (meta_key = '_address' AND meta_value='%s')
				", $venueAddress));

			$return_city = $wpdb->get_col($wpdb->prepare("
				SELECT meta_key
				FROM {$wpdb->eo_venuemeta}
				WHERE (meta_key = '_city' AND meta_value='%s')
				", $venueCity));

		if($return_name) {
			$ultimatemember->form->add_error("venue-name",'This Venue Name '.$venueName.', is already Taken!','ultimatemember');
		}

		if($return_address && $return_city) {

			if($return_address){
				$return_address->form->add_error("street-address",'This Venue Address '.$venueAddress.', is already Taken!','ultimatemember');
			}

			if($return_city){
				$return_address->form->add_error("city", $venueAddress.'in'.$venueCity.', is already Taken!','ultimatemember');
			}
		}

returns an error of
Fatal error: Call to a member function add_error() on a non-object in /home/prymeadmin/public_html/wp-content/themes/bizmo/functions.php on line 168

Any ideas?

I split up the returns to make sure I can variably flag whats wrong…

I know I could prolly do it with

WHERE (meta_key = '_address' AND meta_value='%s')
AND (meta_key = '_city' AND meta_value='%s')

which would be more ideal, but I need to make sure that the errors propagate the correct info first… and that I am actually gathering the correct values from the inputs.

hence the question about the structure of the $args array.

whoops, my bad your right I dont know why I posted that here… The question for you guys was more on how to interact with the eo_venuemeta but I figured that out.

The problem was the structure of the wpdb->sql statement was a little different then what I am used to doing with sqli procedural.

The question I would still have for you then, if I am manually adding the venues with my own database requests, am I going to have to insert into multiple tables or just the data in the eo_venuemeta table that was created when I made a test venue through your UI?

I ended up adding a _venue-name row, because I was not able to find the location that stores the venues name, is it stored as a post?

I assume I can use that to search by name like I was looking for, and also address? So I could restructure my code with something like:

if ( isset( $args['venue-name'] ) && eo_get_venue_by('name',$args['venue-name'] ) ){
	$venueName = $args["venue-name"];
$ultimatemember->form->add_error("venue-name",'This Venue Name '.$venueName.', is already Taken!','ultimatemember');
}

I would much rather use your API, the link you just sent me is pretty legit thank you!

So would it be more ideal to stick with my wpdb prepared statments?

Why are the requests to eo_get_venue_by not automatically getting prepared and sterilized?

I guess this is when I feature request that things like that automatically get sterilized an that the eo get venue by function could have address and geo locations requests?

Also, in the naming of the venue is it going to be smarter for me to add an associated meta-key in the venumeta table like I did or would it be more practical to link to the name stored on the separate wp table?