//Function to show a info frame in the home page, only if you have new notifications
function new_notifications()
{
	global $wpdb, $current_user, $bp;
	$user_id = $current_user->id;
	$cont = 0;
	
	$groups_is_admins_or_moder = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM wp_bp_groups_members WHERE (user_id = ".$user_id." AND (is_admin = 1 OR is_mod = 1) AND is_banned = 0) ORDER BY id ASC" ) );

		foreach($groups_is_admins_or_moder as $group_is_admins_or_moder)
		{
			$group_id = $group_is_admins_or_moder->group_id;
			$group_name = $group_is_admins_or_moder->name;
			$group_private_or_hidden = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM wp_bp_groups WHERE (id = ".$group_id.")" ) );
			
				if(($group_private_or_hidden->status == 'private') || ($group_private_or_hidden->status == 'hidden'))
				{
					$creator_id = $group_private_or_hidden->creator_id;
					$group_slug = $group_private_or_hidden->slug;
					$group_name = $group_private_or_hidden->name;

					$new_users = $wpdb->get_results( $wpdb->prepare( 'SELECT * FROM wp_bp_groups_members WHERE (group_id = '.$group_id.' AND user_id != '.$creator_id.' AND (is_admin = 0 OR is_mod = 0) AND is_banned = 0 AND is_confirmed = 0 AND inviter_id = 0) ORDER BY id ASC' ) );


					foreach($new_users as $new_user)
					{ 
						$cont++;	
					}
				}
		}
	
	if ( ($notifications = bp_core_get_notifications_for_user( $bp->loggedin_user->id )) || $cont > 0 ) { ?>
			
		<div id="message-new-requests" class="info">
			<br>
			<p class="info-new-requests"><?php _e('You have new notifications!','buddypress'); ?>
				<a href="<?php echo get_option('home') ?>/notificaciones"> 
					<?php _e('Click here to see them.','buddypress'); ?>
				</a>
			</p>
		</div><?php
	}
}


//Function to show a info frame in the home page, only if you have new groups invitations
function new_invitations()
{
	global $wpdb, $current_user, $bp;
	$user_id = $current_user->id;
	$cont = 0;
	
	$groups_private_or_public = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM wp_bp_groups WHERE (creator_id !=".$user_id.")" ) );
	
	foreach($groups_private_or_public as $group_private_or_public)
	{
		if(($group_private_or_public->status == 'private') || ($group_private_or_public->status == 'public'))
		{
			$creator_id = $group_private_or_public->creator_id;
			$group_slug = $group_private_or_public->slug;
			$group_id = $group_private_or_public->id;
			$group_name = $group_private_or_public->name;
			$group_des = $group_private_or_public->description;

			if($creator_id != $user_id)
			{
					$users_invited = $wpdb->get_results( $wpdb->prepare( 'SELECT * FROM wp_bp_groups_members WHERE (group_id = '.$group_id.' AND user_id = '.$user_id.' AND (is_admin = 0 OR is_mod = 0) AND is_banned = 0 AND is_confirmed = 0 AND inviter_id = '.$creator_id.') ORDER BY id ASC' ) );


					foreach($users_invited as $user_invited)
					{ 
						$user_invited_group_id = $user_invited->group_id;
						$user_invited_user_id = $user_invited->user_id;
						$user_invited_inviter_id = $user_invited->inviter_id;
						
						$user_requested = $wpdb->get_row( $wpdb->prepare( 'SELECT * FROM wp_bp_groups_members WHERE (group_id = '.$user_invited_group_id.' AND user_id = '.$user_invited_user_id.' AND inviter_id = 0) ORDER BY id ASC' ) ); 
						
						if($user_requested->id == '')
						{
							$cont++;
							
						}	
					}
			}
			
		}
	}
	if ( $cont > 0 ) { ?>
			
		<div id="message-new-requests" class="info">
			<br>
			<p class="info-new-requests"><?php _e('You have new group invitations!','buddypress'); ?>
				<a href="<?php echo get_option('home') ?>/members/<?php echo $current_user->user_login; ?>/groups/invites"> 
					<?php _e('Click here to see them.','buddypress'); ?>
				</a>
			</p>
		</div><?php
	}
	
}