Create a quiz through sql

Create a quiz through sql

- Syed Irtaza Ali の投稿
返信数: 2

I have created a quiz by entering relevant data in the following tables

mdl_quiz
mdl_course_modules
mdl_course_sections
mdl_question
mdl_question_answers
mdl_quiz_slots
mdl_grade_items

but the quiz is not appearing on the course page in the Topic

Any help on the missing table entry?



Syed Irtaza Ali への返信

Re: Create a quiz through sql

- Tim Hunt の投稿
画像 Core developers 画像 Documentation writers 画像 Particularly helpful Moodlers 画像 Peer reviewers 画像 Plugin developers
Clear caches?

I woud not do it that way. I would to it using the Moodle API functions. Likely to be more reliable and more future-proof.
Tim Hunt への返信

Re: Create a quiz through sql

- Syed Irtaza Ali の投稿

Thanks Tim.

Purge All Caches worked!

I am trying to insert google forms quiz and the grade appears fine after insert in mdl_grade_grades

But the Course Total is not adding up the inserted grade. Do I have to manually update it? Any help where this CourseTotal column can be found