<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) PHP Fusion Inc
| https://phpfusion.com/
+--------------------------------------------------------+
| Filename: message_rewrite_include.php
| Author: Chan (Frederick MC Chan)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
defined('IN_FUSION') || exit;
$regex = [
"%msg_id%" => "([0-9]+)",
"%msg_const%" => "(new)",
"%folder%" => "([a-zA-Z._]+)",
"%folder_inbox%" => "(inbox)",
"%folder_outbox%" => "(outbox)",
"%folder_archive%" => "(archive)",
"%user_name%" => "([0-9a-zA-Z._\W]+)",
"%rowstart%" => "([0-9]+)"
];
$pattern = [
"messages/%msg_const%/new-message" => "messages.php?msg_send=%msg_const%",
"messages/send-message-to-%msg_id%" => "messages.php?msg_send=%msg_id%",
"messages/%folder_outbox%/%msg_id%/message-to-%user_name%" => "messages.php?folder=%folder_outbox%&msg_read=%msg_id%",
"messages/%folder_inbox%/%msg_id%/message-from-%user_name%" => "messages.php?folder=%folder_inbox%&msg_read=%msg_id%",
"messages/%folder_archive%/%msg_id%/message-with-%user_name%" => "messages.php?folder=%folder_archive%&msg_read=%msg_id%",
"messages/%folder%" => "messages.php?folder=%folder%",
"messages/%folder%/rowstart/%rowstart%" => "messages.php?folder=%folder%&rowstart=%rowstart%",
"messages" => "messages.php"
];
if (isset($_GET['folder'])) {
global $userdata;
$join_table = "";
$folder = $_GET['folder'];
switch ($_GET['folder']) {
case "inbox":
$join_table = "INNER JOIN ".DB_USERS." u ON m.message_from = u.user_id";
break;
case "outbox":
$join_table = "INNER JOIN ".DB_USERS." u ON m.message_from = u.user_id";
break;
case "archive":
$join_table = "INNER JOIN ".DB_USERS." u ON m.message_from = u.user_id";
break;
}
$pattern_tables["%msg_id%"] = [
"table" => DB_MESSAGES." m $join_table",
"primary_key" => "message_id",
"query" => "message_user='".fusion_get_userdata('user_id')."'",
"id" => ["%msg_id%" => "message_id"],
"columns" => ["%user_name%" => "user_name"]
];
}