Ticket #1471: two_functions.txt

//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
        }
        
}