Thread: How can i intergrate priv Msg into Dolphin

Hiya all, Got abit of trouble here...Needing to intergrate PHPBB messaging (Private messages) into Boonex Dolphin V6.003, to replace the mail system that comes with Boonex Dolphin...Reasons for which are my own...

Problems i'm having are as follows, no idea how to transform the following into the new code version...also ID's of users in Boonex & PHPBB differ, so if you can get it working for username + nickname would be great..!!!

Any help out there...??? For those who can fix my problem i am willing to trade (unsupported) Deleting of outbox items for V6.003 of Dolphin for your assistance...

Thanks
-Spike



Old Code:

Code:

// new messages attention
	$new_mess_arr = db_arr( "SELECT ID FROM `Messages` WHERE Recipient = $p_arr[ID] AND New = '1' ORDER BY Date DESC LIMIT 1" );
	if ( $new_mess_arr )
		$mess = $new_mess_arr[ID];

New code (This is what i've tried....but not working yet..) :

Code:

	// new messages attention
	$new_mess_arr = db_arr( "SELECT `privmsgs_id` FROM `phpbb_privmsgs` WHERE privmsgs_to_userid = $p_arr[ID] AND New = '1' ORDER BY Date DESC LIMIT 1" );
		if ( $new_mess_arr )
		$mess = $new_mess_arr[ID];

I would get the query working in phpMyAdmin first - and then go from there - rather than just do it off the get go in php.

Smoge