Changeset 3326308

Timestamp:

07/11/2025 01:36:18 PM (6 months ago)

Author:

cameron434

Message:

update messages files

Location:

dialbunny/tags/1.1.0/lib/views/dashboard/messages

Files:

• default.php (modified) (1 diff)
• messages.php (modified) (1 diff)

dialbunny/tags/1.1.0/lib/views/dashboard/messages/default.php

@@ -59 +59 @@
                 } else {
                   // Direct database query used below – $wpdb->prepare() is always used to prevent SQL injection.
-                  $opened_item = $wpdb->get_results( $wpdb->prepare("SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY from_number ORDER BY created_at DESC) AS rn FROM {$wpdb->prefix}dialbunny_messages WHERE user = %d AND to_number = %s) AS ranked_messages WHERE rn = 1 ORDER BY created_at DESC LIMIT %d", $user_id, $managed_number, $limit)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery
+                  $opened_item = $wpdb->get_results( $wpdb->prepare("SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY from_number ORDER BY created_at DESC) AS rn FROM {$wpdb->prefix}dialbunny_messages WHERE user = %d AND (from_number = %s OR to_number = %s)) AS ranked_messages WHERE rn = 1 ORDER BY created_at DESC LIMIT %d", $user_id, $managed_number,$managed_number, $limit)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery
                 }
                   // check to see if the user has a managed number

dialbunny/tags/1.1.0/lib/views/dashboard/messages/messages.php

@@ -15 +15 @@
           $managed_number = $phone_details[0]->managed_number;
           // Direct database query used below – $wpdb->prepare() is always used to prevent SQL injection.
-          $numberOfMessages = $wpdb->get_var($wpdb->prepare("SELECT COUNT(DISTINCT from_number) FROM {$wpdb->prefix}dialbunny_messages WHERE user = %d AND (from_number = %s OR to_number = %s)",$current_user_id,$managed_number,$managed_number)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery
+          $numberOfMessages = $wpdb->get_var($wpdb->prepare("SELECT COUNT(DISTINCT user) FROM {$wpdb->prefix}dialbunny_messages WHERE user = %d AND (from_number = %s OR to_number = %s)",$current_user_id,$managed_number,$managed_number)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery
           // Direct database query used below – $wpdb->prepare() is always used to prevent SQL injection.
-          $numberOfUnread = $wpdb->get_var($wpdb->prepare("SELECT COUNT(DISTINCT from_number) FROM {$wpdb->prefix}dialbunny_messages WHERE user = %d AND (from_number = %s OR to_number = %s) AND reading = '0'",$current_user_id,$managed_number,$managed_number)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery
+          $numberOfUnread = $wpdb->get_var($wpdb->prepare("SELECT COUNT(DISTINCT user) FROM {$wpdb->prefix}dialbunny_messages WHERE user = %d AND (from_number = %s OR to_number = %s) AND reading = '0'",$current_user_id,$managed_number,$managed_number)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery
       }
       $resultsPage = 1;