General developer forum

I am trying to add few new fields to Create Course page, also added columns to mdl_course table, but can't figure it out what was wrong as some of them work but some don't.  Does any one has the experience to share?  Thanks in advance.

On the course/edit_form.php:

A. Added below and works: (course create page, after adding field designid to course table,  'designid' get to be saved to table )

1)

$designlist = array();

$designs = $DB->get_records_sql('select * from mdl_course_designs where dropdown = 1 order by name');

$designlist[0] = 'Select One';

foreach($designs as $d) {

            $designlist[$d->id] = $d->name; }

$mform->addElement('select', 'designid', 'Design', $designlist);

2)

$mform->addElement('selectyesno', 'is_design', 'Is a Design Template');

B. However, added below similar 3 things but not working ('maxstudents', 'total_ceus',  'provider' are not saved to table):

1)

$studentrange = range(0, 300);

$mform->addElement('select', 'maxstudents', 'Max Students', $studentrange);

2)

$mform->addElement('text', 'total_ceus', 'Total Number of Hours/CEUs '); $mform->setType('total_ceus', PARAM_FLOAT);

3)

       $providerlist = array();

        $providers = $DB->get_records_sql('select * from mdl_course_provider');

        $providerlist[0] = 'Select One';

        foreach($providers as $p) {

                $providerlist[$p->id] = $p->name;

        }

        $mform->addElement('select', 'provider', 'Provider', $providerlist);