コード例 #1
0
            
            $sql = "INSERT INTO $dbNameForm.user_field_options (field_id, option_value, option_display_text, option_order) values ($id, '1', 'AtOnce',1) ";
            $result = iDatabase::query($sql);
            $sql = "INSERT INTO $dbNameForm.user_field_options (field_id, option_value, option_display_text, option_order) values ($id, '8', 'Daily',2) ";
            $result = iDatabase::query($sql);
            $sql = "INSERT INTO $dbNameForm.user_field_options (field_id, option_value, option_display_text, option_order) values ($id, '0', 'No',3) ";
            $result = iDatabase::query($sql);
                     
            //Fixing table access_url_rel_course if the platform have courses that were created in Dok€os 1.8.5
              
            if (!isset($_configuration['multiple_access_urls']) || $_configuration['multiple_access_urls'] == false) {
                $sql = "SELECT code FROM $dbNameForm.course";
                $result = iDatabase::query($sql);
                while ($row = iDatabase::fetch_array($result)) {
                    //Adding course to default URL just in case
                    $sql = "INSERT INTO $dbNameForm.access_url_rel_course SET course_code = '".iDatabase::escape_string($row['code'])."', access_url_id = '1' ";  
                    iDatabase::query($sql);
                }                
            }
        }
    }
    
    




    /* // This fragment of code is not necessary so far.
    // Get the courses databases queries list (c_q_list)
    $c_q_list = get_sql_file_contents('migrate-db-'.$old_file_version.'-'.$new_file_version.'-post.sql', 'course');
    if (count($c_q_list) > 0) {