Changeset 3018698

Timestamp:

01/08/2024 10:17:38 AM (2 years ago)

Author:

devsoftbaltic

Message:

fixed ​https://wordpress.org/support/topic/error-after-updating-to-1-9-120/

Location:

surveyjs/trunk

Files:

• ajax_handlers/save_survey.php (modified) (1 diff)
• initializer.php (modified) (2 diffs)
• views/editor.php (modified) (1 diff)

surveyjs/trunk/ajax_handlers/save_survey.php

@@ -11 +11 @@
     function callback() {
         if($_SERVER['REQUEST_METHOD'] === 'POST') {
+            global $wpdb;
+            $table_name = $wpdb->prefix . 'sjs_my_surveys';
+
             $id = sanitize_key($_POST['Id']);
             $json = current_user_can( 'unfiltered_html' ) ? $_POST['Json'] : wp_kses_post( $_POST['Json'] );
             $theme = current_user_can( 'unfiltered_html' ) ? $_POST['Theme'] : wp_kses_post( $_POST['Theme'] );
 
+            // create 'theme' column if not exists
+            $row = $wpdb->get_results(  "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $table_name AND column_name = 'theme'"  );
+            if(empty($row)){
+                $wpdb->query("ALTER TABLE $table_name ADD theme LONGTEXT");
+            }
+            // EO create 'theme' column if not exists
+
             if(!!$json) {
-                global $wpdb;
-                $table_name = $wpdb->prefix . 'sjs_my_surveys';
-
                 $result = $wpdb->update(
                     $table_name,

surveyjs/trunk/initializer.php

@@ -174 +174 @@
         </div>
         <script>
+            let theme;
             jQuery.ajax({
                 url:  "<?php echo esc_url($getSurveyJsonUri)  ?>",
@@ -202 +203 @@
 
                 const survey<?php echo $id ?> = new Survey.Model(json);
-                survey<?php echo $id ?>.applyTheme(theme);
+                if (!!theme) {
+                    survey<?php echo $id ?>.applyTheme(theme);
+                }
                 window.survey<?php echo $id ?> = survey<?php echo $id ?>;
                 survey<?php echo $id ?>

surveyjs/trunk/views/editor.php

@@ -91 +91 @@
                     function SurveyCreatorRenderComponent() {
                         var CommercialLicense = <?php echo json_encode(file_exists(plugin_dir_path(__FILE__) . 'CommercialLicense.txt')) ?>;
-                        var editorOptions = { showThemeTab: true, showLogicTab: true, showEmbededSurveyTab: false, showOptions: true, generateValidJSON : false };
-                        Survey.setLicenseKey(
-                            "NDJiZWUxOTktM2M0ZC00MDk2LWE4ODYtOGU1ZTM0ZTFkYjc4OzE9MjAyNC0xMi0wNywyPTIwMjQtMTItMDcsND0yMDI0LTEyLTA3"
-                        );
+                        var editorOptions = { showThemeTab: true, showLogicTab: true, showTranslationTab: true, showEmbededSurveyTab: false, showOptions: true, generateValidJSON : false, haveCommercialLicense: CommercialLicense };
                         const editor = new SurveyCreator.SurveyCreator(editorOptions);
                         editor.showState = true;