global $wpdb, $user_ID, $table_name;

if($show_user == ""){

	$query_user = $user_ID;

}else{

	$query_user = $show_user;

}



if (current_user_can('level_0') || $show_user != ""){
$table_name2 = $wpdb->prefix . 'posts';


$sql = "";
$fav_post ="";



$defaults = array(

		'title' => '',
		'display' => 'list',
		'remove_link' => 'remove',
		'class' => 'mfp_favorites',
		'link_class' => 'mfp_link',
		'remove_link_class' => 'mfp_remove_link',
		'order_by' => 'ID'
	);



$data = $wpdb->get_var("SELECT post_id FROM $table_name WHERE user_id = '$query_user'");


if ($data == ""){
	if($show_user == ""){
echo "<p>You are logged in. Start adding videos you like to your personal favorites list.</p>";

	}else{

echo "<p>This user has not marked any posts as favorite videos yet.</p>";

	}

}else{



	$dataarray = explode(',',$data);
	foreach ($dataarray as $entry){
							$sql .= "OR ID = '$entry' ";

						}



		$endvar = wp_parse_args( $var, $defaults );
		extract( $endvar, EXTR_SKIP );



		$sql = preg_replace("/^OR./","", $sql);
		$order = $endvar['order_by'];

		$my_posts = $wpdb->get_results("SELECT * FROM $table_name2 WHERE $sql ORDER BY $order");
		$mod_url = mfp_create_link_url();







		if ($endvar['display'] == "list"){
		$wrap_before = "<ul class='".$endvar['class']."'>";
		$wrap_after = "</ul>";
		$entry_before = "<li>";
		$entry_after = "</li>";
		} else if ($endvar['display'] == "div"){
		$wrap_before = "<div class='".$endvar['class']."'>";
		$wrap_after = "</div>";
		$entry_before = "<p>";
		$entry_after = "</p>";
		}


		$avatarr = get_post_meta($entry, 'image', $single = true);

		foreach ($my_posts as $entry){

			$fav_post .= $entry_before."<a href='".get_permalink($entry->ID)."' title='".$entry->post_title."' class='".$endvar['link_class']."'><img src=".$avatarr."></img>".$entry->post_title."</a>";

			if($show_user == "" || $show_user == $user_ID){

			$fav_post .= "<a href='".$mod_url."remove-post=".$entry->ID."' class='".$endvar['remove_link_class']."'>".$endvar['remove_link']."</a>".$entry_after;

			}

		}





		//ausgabe
		echo $avatarr;
		echo $title;
		echo $wrap_before;
		echo $fav_post;
		echo $wrap_after;

	}