$prj_id = 1; $milestone = 1; $newsnummer = 1; extract($_SESSION); $prjSel = new PrjMilestoneSelector2($dbConn, $peer_id, $prjm_id); extract($prjSel->getSelectedData()); $_SESSION['prj_id'] = $prj_id; $_SESSION['prjm_id'] = $prjm_id; $_SESSION['milestone'] = $milestone; // unknown project? $isTutorOwner = checkTutorOwner($dbConn, $prj_id, $peer_id); // check if this is tutor_owner of this project $prjm_id_selector = $prjSel->getSimpleForm(); $mail_button = " "; $isAdmin = hasCap(CAP_SYSTEM) ? 'true' : 'false'; $studentPicker = new StudentPicker($dbConn, $newsnummer, 'Search and select participant to add.'); $newsnummer = $studentPicker->processRequest(); if (isset($_REQUEST['baccept']) && $newsnummer != 0) { // try to insert this snummer into max prj_grp $sql = "insert into project_scribe (prj_id,scribe) values({$prj_id},{$newsnummer})\n"; $dbConn->Execute($sql); $dbConn->log($sql); // $dbConn->log($dbConn->ErrorMsg()); } if (isset($_REQUEST['bdelete']) && $newsnummer != 0) { // try to insert this snummer into max prj_grp $sql = "delete from project_scribe where scribe={$newsnummer} and prj_id={$prj_id}\n"; $dbConn->Execute($sql); $dbConn->log($sql); // $dbConn->log($dbConn->ErrorMsg()); }
requireCap(CAP_EDIT_RIGHTS); require_once 'bitset.php'; require_once 'studentpicker.php'; $newsnummer = $peer_id; /* * To change this template, choose Tools | Templates * and open the template in the editor. */ $cap_names = array('CAP_TUTOR', 'CAP_MKPROJECT', 'CAP_MKCLASSES', 'CAP_ALTER_STUDENT', 'CAP_ALTER_STUDENT_CLASS', 'CAP_LOOKUP_STUDENT', 'CAP_IMPERSONATE_STUDENT', 'CAP_TUTOR_OWNER', 'CAP_RECRUITER', 'CAP_STUDENT_ADMIN', 'CAP_TUTOR_ADMIN', 'CAP_SUBVERSION', 'CAP_SHARING', 'CAP_JAAG', 'CAP_SYSTEM', 'CAP_MENU_ADMIN', 'CAP_EDIT_RIGHTS', 'CAP_MODULE', 'CAP_GIT', 'CAP_SELECT_ALL', 'CAP20', 'CAP21', 'CAP22', 'CAP23', 'CAP24', 'CAP25', 'CAP26', 'CAP27', 'CAP28', 'CAP29', 'CAP_BIGFACE', 'CAP31'); $caps = 0; $dbMsg = ''; extract($_SESSION); // if (isSet($_REQUEST['capuserid'])) { // $capuserid = $_REQUEST['capuserid']; // } $studentPicker = new StudentPicker($dbConn, $newsnummer, 'Search user.'); $studentPicker->setShowAcceptButton(false); $studentPicker->setPresentQuery("select userid as snummer from passwd"); $newsnummer = $studentPicker->processRequest(); $student_picker_text = $studentPicker->getPicker(); if (isset($_REQUEST['capability'])) { $caps = collectBitSet($_REQUEST['capability']); } if (isset($_REQUEST['setcap']) && isset($newsnummer) && $newsnummer != 0) { $sql = "update passwd set capabilities={$caps} where userid={$newsnummer}"; $resultSet = $dbConn->Execute($sql); // $dbConn->log($sql); if ($resultSet === false) { $dbMsg = "error cause " + $dbConn->ErrorMsg(); } }
unset($_POST['newsnummer']); $_REQUEST['newsnummer'] = $newsnummer = validate($_GET['newsnummer'], 'integer', '0'); // $dbConn->log('GET '.$newsnummer); } else { if (isset($_POST['newsnummer'])) { unset($_GET['newsnummer']); $_REQUEST['newsnummer'] = $newsnummer = validate($_POST['newsnummer'], 'integer', '0'); // $dbConn->log('POST '.$newsnummer); } else { unset($_POST['newsnummer']); unset($_REQUEST['newsnummer']); unset($_GET['newsnummer']); } } $searchname = ''; $studentPicker = new StudentPicker($dbConn, $newsnummer, 'Search and select participant to add.'); if (isset($_REQUEST['searchname'])) { if (!preg_match('/;/', $_REQUEST['searchname'])) { $searchname = $_REQUEST['searchname']; $studentPicker->setSearchString($searchname); if (!isset($_REQUEST['newsnummer'])) { $newsnummer = $studentPicker->findStudentNumber(); } } else { $searchname = ''; } $_SESSION['searchname'] = $searchname; } else { $_SESSION['searchname'] = $searchname; $studentPicker->setSearchString($_SESSION['searchname']); }
unset($_POST['newauditor']); $_REQUEST['newauditor'] = $newauditor = validate($_GET['newauditor'], 'snummer', '0'); // $dbConn->log('GET '.$newauditor); } else { if (isset($_POST['newauditor'])) { unset($_GET['newauditor']); $_REQUEST['newauditor'] = $newauditor = validate($_POST['newauditor'], 'snummer', '0'); // $dbConn->log('POST '.$newauditor); } else { unset($_POST['newauditor']); unset($_REQUEST['newauditor']); unset($_GET['newauditor']); } } $searchname = ''; $studentPicker = new StudentPicker($dbConn, $newauditor, 'Search and select auditor.'); $studentPicker->setInputName('newauditor'); if (isset($_REQUEST['searchname'])) { if (!preg_match('/;/', $_REQUEST['searchname'])) { $searchname = $_REQUEST['searchname']; $studentPicker->setSearchString($searchname); if (!isset($_REQUEST['newauditor'])) { $newauditor = $studentPicker->findStudentNumber(); } } else { $searchname = ''; } $_SESSION['searchname'] = $searchname; } else { $studentPicker->setSearchString($_SESSION['searchname']); }
unset($_GET['newsnummer']); } } if (isset($_REQUEST['act_id'])) { $_SESSION['act_id'] = $act_id = validate($_REQUEST['act_id'], 'integer', $act_id); } $_SESSION['act_id'] = $act_id; if (isset($act_id) && $act_id >= 0) { $sql = "select act_id,short,description,datum,part,start_time from activity where act_id={$act_id}"; $rs = $dbConn->Execute($sql); if (!$rs->EOF) { extract($rs->fields); } } $searchname = ''; $studentPicker = new StudentPicker($dbConn, $newsnummer, 'Search and select participant to add.'); if (isset($_REQUEST['searchname'])) { # $dbConn->log($_REQUEST['searchname']); if (!preg_match('/;/', $_REQUEST['searchname'])) { $searchname = $_REQUEST['searchname']; $studentPicker->setSearchString($searchname); if (!isset($_REQUEST['newsnummer'])) { $newsnummer = $studentPicker->findStudentNumber(); } } else { $searchname = ''; } $_SESSION['searchname'] = $searchname; } else { $studentPicker->setSearchString($searchname); }
<?php require_once './peerlib/peerutils.inc'; include_once 'navigation2.inc'; requireCap(CAP_EDIT_RIGHTS); require_once 'bitset.php'; require_once 'studentpicker.php'; $newuserid = $peer_id; /* * To change this template, choose Tools | Templates * and open the template in the editor. */ $dbMsg = ''; extract($_SESSION); $tutorPicker = new StudentPicker($dbConn, $newuserid, 'Search tutor.'); $tutorPicker->setShowAcceptButton(false); $tutorPicker->setPresentQuery("select userid as snummer from tutor"); $newuserid = $tutorPicker->processRequest(); $tutor_picker_text = $tutorPicker->getPicker(); $cluster_widget = "<table border='1' style='border-collapse:collapse; width:100%'>\n"; if (isset($_REQUEST['class_cluster']) && isset($_REQUEST['newuserid'])) { $newuserid = $_REQUEST['newuserid']; $sql1 = "begin work;\n" . "delete from tutor_class_cluster where userid={$newuserid};\n"; for ($i = 0; $i < count($_REQUEST['class_cluster']); $i++) { if ($_REQUEST['cluster_order'][$i] > 0) { $sql1 .= "insert into tutor_class_cluster select {$newuserid},{$_REQUEST['class_cluster'][$i]},{$_REQUEST['cluster_order'][$i]};\n"; } } $sql1 .= "commit;\n"; $rs = $dbConn->Execute($sql1); }