/* $Id: activegroup.php 1825 2014-12-27 14:57:05Z hom $ */
include_once './peerlib/peerutils.inc';
include_once './peerlib/simplequerytable.inc';
include_once 'makeinput.inc';
include_once 'tutorhelper.inc';
include_once 'navigation2.inc';
require_once 'studentPrjMilestoneSelector.php';
$prj_id = 1;
$milestone = 1;
$prjm_id = 0;
$grp_num = 1;
$prjtg_id = 1;
extract($_SESSION);
$judge = $snummer;
$prjSel = new StudentMilestoneSelector($dbConn, $judge, $prjtg_id);
extract($prjSel->getSelectedData());
$_SESSION['prjtg_id'] = $prjtg_id;
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
$_SESSION['grp_num'] = $grp_num;
$may_change = hasStudentCap($snummer, CAP_SET_PROJECT_DATA, $prjm_id, $grp_num);
if ($may_change && isset($_POST['submit_data'])) {
$long_name = substr(pg_escape_string($_POST['long_name']), 0, 40);
$alias = substr(pg_escape_string($_POST['alias']), 0, 15);
$productname = substr(pg_escape_string($_POST['productname']), 0, 128);
$website = substr(pg_escape_string($_POST['website']), 0, 128);
$youtube_link = substr(pg_escape_string($_POST['youtube_link']), 0, 128);
$youtube_icon_url = substr(pg_escape_string($_POST['youtube_icon_url']), 0, 128);
$sql = "select count(*) from grp_alias where prjtg_id={$prjtg_id}";
$resultSet = $dbConn->Execute($sql);
require_once './peerlib/validators.inc';
require_once './peerlib/simplequerytable.inc';
include_once 'navigation2.inc';
require_once 'studentPrjMilestoneSelector.php';
$doctype = 0;
$version_limit = 2;
$url = $PHP_SELF;
$filesizelimit = 10000000;
$prj_id = 1;
$milestone = 1;
$prjm_id = 0;
$prjtg_id = 1;
extract($_SESSION);
$prjSel = new StudentMilestoneSelector($dbConn, $snummer, $prjm_id);
$prjSel->setExtraConstraint(" and prjm_id in (select distinct prjm_id from project_deliverables) and valid_until > now()::date ");
$pp = $prjSel->getSelectedData();
extract($pp);
$pp['filesizelimit'] = $filesizelimit;
$pp['uploadMessage'] = '';
$_SESSION['prjtg_id'] = $prjtg_id;
$_SESSION['prj_id'] = $prj_id;
$_SESSION['prjm_id'] = $prjm_id;
$_SESSION['milestone'] = $milestone;
$_SESSION['grp_num'] = $grp_num;
if (!isset($_SESSION['userfile'])) {
$_SESSION['userfile'] = '';
}
$sql = "select rtrim(afko) as uafko,year as myear,roepnaam as uroepnaam,\n" . " rtrim(email1) as uemail1, rtrim(email2) as uemail2, voorvoegsel as uvoorvoegsel,\n" . "achternaam as uachternaam,grp_num as ugrp,description as udescription,prjm_id,prjtg_id \n" . "from prj_grp join all_prj_tutor using(prjtg_id) join student using(snummer) left join alt_email using(snummer)\n" . "where prjm_id={$prjm_id} and snummer={$snummer}";
$resultSet = $dbConn->Execute($sql);
//echo $sql;
if ($resultSet === false) {
