Member-messages no coming through

Try this new version. Replace this query line ~1430 (original version)

$q1 = $wpdb->get_results("SELECT 
	M.id,
	M.sender,
	M.recipient,
	M.date,
	M.read,
	U.ID
FROM
	".$wpdb->prefix."rencontre_msg M,
	".$wpdb->prefix."users U
WHERE 
	(M.recipient='".$current_user->user_login."' and 
	M.deleted!=1 and
	U.user_login=M.sender)
	or
	(M.sender='".$current_user->user_login."' and 
	M.deleted!=2 and
	U.user_login=M.recipient)
ORDER BY M.date DESC"); // delete=1 : supp par dest - delete=2 : supp par writter

with this new code :

$q1 = $wpdb->get_results("SELECT 
		M.id,
		M.sender,
		M.recipient,
		M.date,
		M.read,
		U.ID
	FROM
		".$wpdb->prefix."rencontre_msg M,
		".$wpdb->prefix."users U
	WHERE 
		U.user_login=M.sender and
		M.recipient='".$current_user->user_login."' and 
		M.deleted!=1");
$q2 = $wpdb->get_results("SELECT 
		M.id,
		M.sender,
		M.recipient,
		M.date,
		M.read,
		U.ID
	FROM
		".$wpdb->prefix."rencontre_msg M,
		".$wpdb->prefix."users U
	WHERE 
		U.user_login=M.recipient and
		M.sender='".$current_user->user_login."' and 
		M.deleted!=2");
$q1 = array_merge($q1,$q2);
usort($q1, function($a,$b){return strcmp($b->date,$a->date);});
echo "*********Count result : ".count($q1);

• This reply was modified 8 years, 4 months ago by Jacques Malgrange.

Hi Jacques

I’ve put in an ekstra letter in the echo, just to make sure that I actually did change the code on the site, but unfortunately still empty and count result: 0

Henrik

Hallo M.Malgrange

Anything new on this topic ? I ofcourse have updated Rencontre. Status is this:
When a member sends a message to another member, he or she will get an email. In the mail there is a link, which leads to the empty message-page we talked about before in this thread. The message-page is always empty, even though there are messages.

Any suggestions ? Am I the only one with this problem ?

Regards

Henrik