Beispiel #1
0
    }
    // if($formCorrectlySent)
}
//end if($_REQUEST['submitWrk'])
/*============================================================================
                          ADMIN ONLY COMMANDS
  =============================================================================*/
if ($is_allowedToEditAll) {
    /*--------------------------------------------------------------------
                          CHANGE VISIBILITY
      --------------------------------------------------------------------*/
    // change visibility of a work
    if ($cmd == 'exChVis' && isset($_REQUEST['wrkId'])) {
        if (isset($_REQUEST['vis'])) {
            $_REQUEST['vis'] == 'v' ? $visibility = 'VISIBLE' : ($visibility = 'INVISIBLE');
            Submission::updateSubmissionVisibility($_REQUEST['wrkId'], $visibility);
        }
    }
    /*--------------------------------------------------------------------
                          DELETE A WORK
      --------------------------------------------------------------------*/
    if ($cmd == "exRmWrk" && isset($_REQUEST['wrkId'])) {
        // get name of file to delete AND name of file of the feedback of this work
        $sql = "SELECT `id`, `submitted_doc_path`\n                  FROM `" . $tbl_wrk_submission . "`\n                  WHERE `id` = " . (int) $_REQUEST['wrkId'] . "\n                     OR `parent_id` = " . (int) $_REQUEST['wrkId'];
        $filesToDelete = claro_sql_query_fetch_all($sql);
        foreach ($filesToDelete as $fileToDelete) {
            // delete the file
            @unlink($assignment->getAssigDirSys() . $fileToDelete['submitted_doc_path']);
            // delete the database data of this work
            $sqlDelete = "DELETE FROM `" . $tbl_wrk_submission . "`\n                              WHERE `id` = " . (int) $fileToDelete['id'];
            claro_sql_query($sqlDelete);