Changeset 2734420

Timestamp:

05/31/2022 04:39:26 AM (4 years ago)

Author:

morphii

Message:

Removed jQuery
Updated DB Connection method to Prepare statement

Location:

morphii/trunk

Files:

• includes/class.morphii-data.php (modified) (2 diffs)
• morphii.php (modified) (1 diff)

morphii/trunk/includes/class.morphii-data.php

@@ -98 +98 @@
                 foreach ($json_morphiies as $morphii_key => $morphii_value) {
                     
-                    $dbqry="SELECT post_id FROM ". $wpdb->postmeta . " WHERE meta_value = '".$morphii_value->Question_ID."' AND meta_key = 'morphii-question-id'";
-                    
+                    $dbqry=$wpdb->prepare( "SELECT post_id FROM  ".$wpdb->postmeta." WHERE meta_value = %s AND meta_key =%s", array(  $morphii_value->Question_ID, 'morphii-question-id' ) );
+
                     $results = $wpdb->get_results( $dbqry, ARRAY_A );
                     
@@ -126 +126 @@
                 }
                 else{
+                    
                     $post_id=$results[0]['post_id'];
                     update_post_meta( $post_id, 'morphiis', $morphii_value->Morphiies);  

morphii/trunk/morphii.php

@@ -130 +130 @@
         public function enqueue_scripts() {     
 
-            wp_enqueue_script( 'jquery-min',  MORPHII_MWAR_URL . 'assets/js/jquery.min.js', false );
+            //wp_enqueue_script( 'jquery-min',  MORPHII_MWAR_URL . 'assets/js/jquery.min.js', false );
 
             wp_enqueue_script( 'morphii-widget', 'https://widget.morphii.com/v2/morphii-widget.min.js', false );