Changeset 3326311

Timestamp:

07/11/2025 01:39:01 PM (7 months ago)

Author:

cameron434

Message:

update

File:

• dialbunny/tags/1.1.0/lib/views/dashboard/messages/default.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 (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
+                  $opened_item = $wpdb->get_results( $wpdb->prepare("SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY user 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