Changeset 2787671

Timestamp:

09/20/2022 01:47:54 PM (3 years ago)

Author:

tanng

Message:

Fix table prefix

Location:

prixchat

Files:

• tags/1.0.0/src/class-peer.php (modified) (1 diff)
• trunk/src/class-peer.php (modified) (1 diff)

prixchat/tags/1.0.0/src/class-peer.php

@@ -152 +152 @@
     public static function get_unread_count( $user_id ) {
         global $wpdb;
-
+        
         $query = "SELECT 
                         P.conversation_id, 
                         count(*) as total_unread 
                  FROM 
-                    `wp_prixchat_messages` M, 
-                    `wp_prixchat_peers` P 
+                    `{$wpdb->prefix}prixchat_messages` M, 
+                    `{$wpdb->prefix}prixchat_peers` P 
                 WHERE P.user_id = %d 
                 AND M.conversation_id = P.conversation_id 

prixchat/trunk/src/class-peer.php

@@ -152 +152 @@
     public static function get_unread_count( $user_id ) {
         global $wpdb;
-
+        
         $query = "SELECT 
                         P.conversation_id, 
                         count(*) as total_unread 
                  FROM 
-                    `wp_prixchat_messages` M, 
-                    `wp_prixchat_peers` P 
+                    `{$wpdb->prefix}prixchat_messages` M, 
+                    `{$wpdb->prefix}prixchat_peers` P 
                 WHERE P.user_id = %d 
                 AND M.conversation_id = P.conversation_id