*/
require_once('../../config/cis.config.inc.php');
require_once('../../include/basis_db.class.php');
require_once('../../include/phrasen.class.php');
require_once('../../include/functions.inc.php');
$sprache = getSprache();
$p = new phrasen($sprache);
if(!$uid = get_uid())
die($p->t('global/fehlerBeimErmittelnDerUID'));
echo '
';
include('../../include/meta/jquery.php');
include('../../include/meta/jquery-tablesorter.php');
?>
'.$p->t('mailverteiler/personenImVerteiler').'
';
if (!$db = new basis_db())
die($p->t('global/fehlerBeimOeffnenDerDatenbankverbindung'));
if (!isset($_GET['kz']))
die($p->t('global/fehlerBeiDerParameteruebergabe'));
if (isset($_GET['all']))
{
$qry = "SELECT
vorname, nachname, uid, geschlecht
FROM
campus.vw_student
WHERE
aktiv=true
AND studiengang_kz=".$db->db_add_param($_GET['kz'])."
AND semester<10
AND semester>0
ORDER BY nachname, vorname";
}
else
{
$qry = "SELECT
vorname, nachname, uid, geschlecht
FROM
campus.vw_student
WHERE
aktiv=true
AND studiengang_kz=".$db->db_add_param($_GET['kz']);
if (isset($_GET['sem']))
$qry.=" AND semester=".$db->db_add_param($_GET['sem'], FHC_INTEGER);
if (isset($_GET['verband']))
$qry.=" AND verband=".$db->db_add_param($_GET['verband']);
if (isset($_GET['grp']))
$qry.=" AND gruppe=".$db->db_add_param($_GET['grp']);
$qry.= ' ORDER BY nachname, vorname';
}
echo '
