root/broadcast/lib.php

<?php
function broadcast_pagesetup()
{
    global $CFG, $PAGE;
    
    include($CFG->dirroot . "mod/broadcast/broadcast.config.php");

    if (defined("context") && (context == "admin") && isloggedin() && isadmin($_SESSION['userid']))
    {
        // Add to the submenu
        $num = count($PAGE->menu_sub) + 1;

        $PAGE->menu_sub[$num]['name'] = "admin:broadcast"; 
        $PAGE->menu_sub[$num]['html'] = '<a href="'.$CFG->wwwroot . 'mod/broadcast/broadcast_start.php">'.__gettext("Broadcast").'</a>';
    }
    
    // a big if that says that the broadcast link appears on community profiles is the user is an admin or community owner
    
    $pg_owner = page_owner();
    
    if (isloggedin() && defined("context") && (context == "profile") && 
        user_info('user_type',$pg_owner) == 'community' &&
        (isadmin($_SESSION['userid']) || ($broadcast_allow_owners && user_info('owner',$pg_owner) == $_SESSION['userid']))) {
            
        $body = '<p><a href="'.$CFG->wwwroot.'mod/broadcast/broadcast_start.php?cid='.$pg_owner.'" />';
        $body .= __gettext("Send a message to this community").'</a></p>';
        $body = templates_draw(array(
                    'context' => 'sidebarholder',
                    'title' => __gettext("Broadcast"),
                    'body' => $body,
                    ));
                
        sidebar_add(30, 'sidebar-myblock', $body, true, "new block");
    }
}

/*function broadcast_init() 
{
    
    global $function, $CFG;
    include('broadcast.config.php');


} // end function init*/
    
    
function broadcast_get_all_users($profile_field,$profile_value) {
    
    global $CFG;
    
    if ($profile_field && $profile_value) {
        
        $thesql= <<< END
SELECT u.*, uf.value AS email_flag 
FROM
( {$CFG->prefix}users u
   INNER JOIN {$CFG->prefix}profile_data p
   ON (u.ident = p.owner)
)
LEFT JOIN {$CFG->prefix}user_flags uf
ON (u.ident = uf.user_id AND uf.flag = 'emailnotifications')
WHERE u.user_type = "person" 
AND u.active="yes"
AND p.name = '$profile_field'
AND (p.value = '$profile_value'
    OR '$profile_value' IN (SELECT tag FROM {$CFG->prefix}tags WHERE ref = p.ident)
)
ORDER BY u.ident ASC
END;
    } else {

    $thesql= <<< END
SELECT u.*, uf.value AS email_flag
FROM {$CFG->prefix}users u 
LEFT JOIN {$CFG->prefix}user_flags uf
ON (u.ident = uf.user_id AND uf.flag = 'emailnotifications')
WHERE u.user_type = "person" 
AND u.active="yes"
ORDER BY u.ident ASC
END;
    }
    $recipients=get_records_sql($thesql);
    return $recipients;
}
                    
function broadcast_get_community_users($community,$profile_field,$profile_value) {
    
    global $CFG;
    
    if ($profile_field && $profile_value) {
        $thesql= <<<END
SELECT DISTINCT u.ident,u.username,u.name, u.email, uf.value AS email_flag FROM
(
    (
        {$CFG->prefix}friends f
        INNER JOIN {$CFG->prefix}users u 
        ON (u.ident = f.owner)
    ) INNER JOIN {$CFG->prefix}profile_data p
      ON (u.ident = p.owner)
) LEFT JOIN {$CFG->prefix}user_flags uf
  ON (u.ident = uf.user_id AND uf.flag = 'emailnotifications')
WHERE f.friend = {$community->ident}
AND u.active= 'yes'
AND u.user_type = 'person'
AND p.name = '$profile_field'
AND (p.value = '$profile_value'
    OR '$profile_value' IN (SELECT tag FROM {$CFG->prefix}tags WHERE ref = p.ident)
)
END;
    } else {
                    
      $thesql = <<<END
SELECT DISTINCT u.ident,u.username,u.name, u.email, uf.value AS email_flag FROM 
( {$CFG->prefix}friends f
  INNER JOIN {$CFG->prefix}users u ON (u.ident = f.owner)
)
LEFT JOIN {$CFG->prefix}user_flags uf
ON (u.ident = uf.user_id AND uf.flag = 'emailnotifications')
WHERE f.friend = $community->ident
AND u.active = 'yes'
AND u.user_type = 'person'
END;
    }
    
    $recipients=get_records_sql($thesql);    
    
    return $recipients;
}

?>