PHP F_question_set_enabled Examples

Example #1

File: tce_functions_questions.php Project: dungvu/tcexam

/**
 * Delete selected question (or disable it if used)
 * @author Nicola Asuni
 * @since 2008-11-26
 * @param $question_id (int) question ID
 * @param $subject_id (int) subject ID
 */
function F_question_delete($question_id, $subject_id)
{
    global $l, $db;
    require_once '../config/tce_config.php';
    $question_id = intval($question_id);
    $subject_id = intval($subject_id);
    // check if this record is used (test_log)
    if (!F_check_unique(K_TABLE_TESTS_LOGS, 'testlog_question_id=' . $question_id . '')) {
        F_question_set_enabled($question_id, false);
    } else {
        $sql = 'START TRANSACTION';
        if (!($r = F_db_query($sql, $db))) {
            F_display_db_error();
        }
        // get question position (if defined)
        $question_position = F_question_get_position($question_id);
        // delete question
        $sql = 'DELETE FROM ' . K_TABLE_QUESTIONS . ' WHERE question_id=' . $question_id . '';
        if (!($r = F_db_query($sql, $db))) {
            F_display_db_error(false);
            F_db_query('ROLLBACK', $db);
            // rollback transaction
        } else {
            // adjust questions ordering
            if ($question_position > 0) {
                $sql = 'UPDATE ' . K_TABLE_QUESTIONS . ' SET
					question_position=question_position-1
					WHERE question_subject_id=' . $subject_id . '
						AND question_position>' . $question_position . '';
                if (!($r = F_db_query($sql, $db))) {
                    F_display_db_error(false);
                    F_db_query('ROLLBACK', $db);
                    // rollback transaction
                }
            }
            $sql = 'COMMIT';
            if (!($r = F_db_query($sql, $db))) {
                F_display_db_error();
            }
        }
    }
}

Example #2

File: tce_show_all_questions.php Project: dungvu/tcexam

                        F_question_delete($question_id, $subject_id);
                    }
                    break;
                case 'copy':
                    if (isset($new_subject_id) and $new_subject_id > 0) {
                        F_question_copy($question_id, $new_subject_id);
                    }
                    break;
                case 'delete':
                    F_question_delete($question_id, $subject_id);
                    break;
                case 'disable':
                    F_question_set_enabled($question_id, false);
                    break;
                case 'enable':
                    F_question_set_enabled($question_id, true);
                    break;
            }
            // end of switch
        }
    }
    F_print_error('MESSAGE', $l['m_updated']);
}
echo '<div class="container">' . K_NEWLINE;
echo '<div class="tceformbox">' . K_NEWLINE;
echo '<form action="' . $_SERVER['SCRIPT_NAME'] . '" method="post" enctype="multipart/form-data" id="form_selectquestions">' . K_NEWLINE;
echo '<div class="row">' . K_NEWLINE;
echo '<span class="label">' . K_NEWLINE;
echo '<label for="subject_module_id">' . $l['w_module'] . '</label>' . K_NEWLINE;
echo '</span>' . K_NEWLINE;
echo '<span class="formw">' . K_NEWLINE;