/* $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) {