Thread: Inbox, Outbox, Reply problems

Ok, ready, everything seems to work fine, thanks to lodlock, hats off and I know everybody is going to appreciate this a lot.

As a note, for the changes to work for me I had to change this line at outbox.php for layout and icon to appear correctly.

At outbox.php:

The line from lodlock is:

Code:

<td rowspan="2" colspan="3" align="center" valign="center"><img src="<? getTemplateIcon('outbox.gif') ?>" /></td>

I had to change it to:

Code:

<td rowspan="2" colspan="2" align="center" valign="center"><img src="<?= getTemplateIcon('outbox.gif') ?>" /></td>

So, if the layout of outbox.php is appearing wrong and/or the icon image is not appearing, this might fix the problem.

Thanks again, everybody take care.

First of all, thanks to Prometheus for helping improving this fix.

Well, I had a problem with the sintax of the suggested solution for this last issue.

I changed it to:

Replace:

Code:

$query = "UPDATE `Messages` SET `ib` = '0'";

With:

Code:

$query = "UPDATE `Messages` SET `ib` = '0', `New` = '0'";

Including it here just in case someone face the same syntax problem with the suggested solution above.

Take care.

If you click the subject of a message at the inbox page you get to the page where you can see the message (messages_inbox.php), at this page there is a delete link that has to be modified to behave like when you are deleting messages at the inbox page.

The messages lists at the pages for viewing specific messages (messages_inbox.php and messages_outbox.php) have to be modified for it to not list the messages a member have deleted from the inbox or outbox, respectively, without affecting the same lists of messages from the member who is at the other side of the communication.

To do the above:

At messages_inbox.php:

Replace:

Code:

$delete_query = "DELETE FROM `Messages` WHERE `ID` = '$mes_id'";

With:

Code:

	$ib_ob_arr = db_arr( "SELECT `ib`, `ob` FROM `Messages` WHERE `ID` = '$mes_id'" );
	if (!$ib_ob_arr['ob'])
	{
		$delete_query_add = "DELETE FROM `Messages`";
	}
	else
	{
		$delete_query_add = "UPDATE `Messages` SET `ib` = '0', `New` = '0'";
	}
	$delete_query = "$delete_query_add WHERE `ID` = '$mes_id'";

Replace:

Code:

$member_to_sender_query = "SELECT `Profiles`.`ID` AS pID, `Profiles`.`NickName`, `Profiles`.`Status`, `Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '$date_format') as 'Date', `Subject`, LEFT( `Text`, {$preview_leight} ) AS Preview FROM `Messages` LEFT JOIN `Profiles` ON `Messages`.`Recipient` = `Profiles`.`ID` WHERE `Sender` = '" . (int)$memberID . "' AND `Recipient` = '" . (int)$senderID . "' ORDER BY `Date` DESC";

With:

Code:

$member_to_sender_query = "SELECT `Profiles`.`ID` AS pID, `Profiles`.`NickName`, `Profiles`.`Status`, `Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '$date_format') as 'Date', `Subject`, LEFT( `Text`, {$preview_leight} ) AS Preview, `Messages`.`ob` FROM `Messages` LEFT JOIN `Profiles` ON `Messages`.`Recipient` = `Profiles`.`ID` WHERE `Sender` = '" . (int)$memberID . "' AND `Recipient` = '" . (int)$senderID . "' AND `ob` = '1' ORDER BY `Date` DESC";

Replace:

Code:

$sender_to_member_query = "SELECT `Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '$date_format') as 'Date', `Subject`, LEFT( `Text`, {$preview_leight} ) AS Preview FROM `Messages` LEFT JOIN `Profiles` ON Messages.Sender = Profiles.ID WHERE `Sender` = '" . (int)$senderID . "' AND `Recipient` = '" . (int)$memberID . "' ORDER BY `Date` DESC";

With:

Code:

$sender_to_member_query = "SELECT `Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '$date_format') as 'Date', `Subject`, LEFT( `Text`, {$preview_leight} ) AS Preview, `Messages`.`ib` FROM `Messages` LEFT JOIN `Profiles` ON Messages.Sender = Profiles.ID WHERE `Sender` = '" . (int)$senderID . "' AND `Recipient` = '" . (int)$memberID . "' AND `ib` = '1' ORDER BY `Date` DESC";

At messages_outbox.php:

Replace:

Code:

$member_to_sender_query = "SELECT `Profiles`.`ID` AS pID, `Profiles`.`NickName`, `Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '$date_format') as Date, `Subject`, LEFT( `Text`, {$preview_leight} ) AS Preview FROM `Messages` LEFT JOIN `Profiles` ON `Messages`.`Recipient` = `Profiles`.`ID` WHERE `Sender` = '$memberID' AND `Recipient` = '$senderID' ORDER BY `Date` DESC";

With:

Code:

$member_to_sender_query = "SELECT `Profiles`.`ID` AS pID, `Profiles`.`NickName`, `Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '$date_format') as Date, `Subject`, LEFT( `Text`, {$preview_leight} ) AS Preview, `Messages`.`ob` FROM `Messages` LEFT JOIN `Profiles` ON `Messages`.`Recipient` = `Profiles`.`ID` WHERE `Sender` = '$memberID' AND `Recipient` = '$senderID' AND `ob` = '1' ORDER BY `Date` DESC";

Replace:

Code:

$sender_to_member_query = "SELECT `Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '$date_format') as Date, `Subject`, LEFT( `Text`, {$preview_leight} ) AS Preview FROM `Messages` LEFT JOIN `Profiles` ON Messages.Sender = Profiles.ID WHERE `Sender` = '$senderID' AND `Recipient` = '$memberID' ORDER BY `Date` DESC";

With:

Code:

$sender_to_member_query = "SELECT `Messages`.`ID` AS mID, `New`, DATE_FORMAT( `Date`, '$date_format') as Date, `Subject`, LEFT( `Text`, {$preview_leight} ) AS Preview, `Messages`.`ib` FROM `Messages` LEFT JOIN `Profiles` ON Messages.Sender = Profiles.ID WHERE `Sender` = '$senderID' AND `Recipient` = '$memberID' AND `ib` = '1' ORDER BY `Date` DESC";

That's all, hope it helps, take care, bye.

Im trying to use the solution posted here in this thread on 03-18-2007 to solve a truncate problem when large messages are sent but I actually have 6.0 and code mentioned in the solutions in compose.php does not exist in 6.0.

can any one refer me to a solution for this for 6.x?

Thank you

makenoize