-$mode = (!empty($HTTP_GET_VARS['mode'])) ? $HTTP_GET_VARS['mode'] : 'inbox';

-

-if($mode == "inbox" || $mode == "sent")

-{

-

- //

- // Load templates

- //

- $template->set_filenames(array(

- "body" => "privmsgs_body.tpl",

- "jumpbox" => "jumpbox.tpl")

- );

- $jumpbox = make_jumpbox();

- $template->assign_vars(array(

- "JUMPBOX_LIST" => $jumpbox,

- "SELECT_NAME" => POST_FORUM_URL)

- );

- $template->assign_var_from_handle("JUMPBOX", "jumpbox");

-

- $inbox_url = "<img src=\"images/msg_inbox.gif\" border=\"0\">&nbsp;";

- $inbox_url .= ($mode == "sent") ? "<a href=\"" . append_sid("privmsg.$phpEx?mode=inbox") . "\"><b>" . $lang['Inbox'] . "</b></a>" : "<b>" . $lang['Inbox'] . "</b>";

- $sent_url = "<img src=\"images/msg_inbox.gif\" border=\"0\">&nbsp;";

- $sent_url .= ($mode == "inbox") ? "<a href=\"" . append_sid("privmsg.$phpEx?mode=sent") . "\"><b>" . $lang['Sent'] . "</b></a>" : "<b>" . $lang['Sent'] . "</b>";

-

- $template->assign_vars(array(

- "INBOX_FOLDER" => $inbox_url,

- "SENT_FOLDER" => $sent_url,

-

- "L_FLAG" => $lang['Flag'],

- "L_SUBJECT" => $lang['Subject'],

- "L_DATE" => $lang['Date'],

- "L_FROM_OR_TO" => (($mode == "inbox") ? $lang['From'] : $lang['To']),

-

- "U_FOLDER2" => $u_folder2)

- );

-

- if($mode == "inbox")

- {

- $sql_tot = "SELECT COUNT(pm.privmsgs_id) AS pm_total

- FROM " . PRIVMSGS_TABLE . " pm, " . USER_GROUP_TABLE . " ug

- WHERE ug.group_id = pm.privmsgs_to_groupid

- AND ug.user_id = " . $userdata['user_id'] . "

- AND pm.privmsgs_type <> " . PRIVMSGS_SENT_MAIL;

-

- $sql = "SELECT pm.privmsgs_type, pm.privmsgs_id, pm.privmsgs_date, pm.privmsgs_subject, ug.user_id, g.group_name, g.group_single_user

- FROM " . PRIVMSGS_TABLE . " pm, " . USER_GROUP_TABLE . " ug, " . USER_GROUP_TABLE . " ug2, " . GROUPS_TABLE . " g

- WHERE ug.group_id = pm.privmsgs_from_groupid

- AND g.group_id = ug.group_id

- AND ug2.group_id = pm.privmsgs_to_groupid

- AND ug2.user_id = " . $userdata['user_id'] . "

- AND pm.privmsgs_type <> " . PRIVMSGS_SENT_MAIL . "

- ORDER BY pm.privmsgs_date DESC

- LIMIT $start, " . $board_config['topics_per_page'];

- }

- else

- {

- $sql_tot = "SELECT COUNT(pm.privmsgs_id) AS pm_total

- FROM " . PRIVMSGS_TABLE . " pm, " . USER_GROUP_TABLE . " ug

- WHERE ug.group_id = pm.privmsgs_from_groupid

- AND ug.user_id = " . $userdata['user_id'] . "

- AND pm.privmsgs_type = " . PRIVMSGS_SENT_MAIL;

-

- $sql = "SELECT pm.privmsgs_type, pm.privmsgs_id, pm.privmsgs_date, pm.privmsgs_subject, ug.user_id, g.group_name, g.group_single_user

- FROM " . PRIVMSGS_TABLE . " pm, " . USER_GROUP_TABLE . " ug, " . USER_GROUP_TABLE . " ug2, " . GROUPS_TABLE . " g

- WHERE ug.group_id = pm.privmsgs_to_groupid

- AND g.group_id = ug.group_id

- AND ug2.group_id = pm.privmsgs_from_groupid

- AND ug2.user_id = " . $userdata['user_id'] . "

- AND pm.privmsgs_type = " . PRIVMSGS_SENT_MAIL . "

- ORDER BY pm.privmsgs_date DESC

- LIMIT $start, " . $board_config['topics_per_page'];

- }

- if(!$pm_tot_status = $db->sql_query($sql_tot))

- {

- error_die(SQL_QUERY, "Could not query private message information.", __LINE__, __FILE__);

- }

- if(!$pm_status = $db->sql_query($sql))

- {

- error_die(SQL_QUERY, "Could not query private message information.", __LINE__, __FILE__);

- }

- $pm_total = $db->sql_numrows($pm_tot_status);

- $pm_list = $db->sql_fetchrowset($pm_status);

-

- //

- // Okay, let's build the index

- //

-

- for($i = 0; $i < count($pm_list); $i++)

- {

-

- $flag = $pm_list[$i]['privmsgs_type'];

- $icon_flag = ($flag == PRIVMSGS_READ_MAIL || $flag == PRIVMSGS_SENT_MAIL) ? "<img src=\"images/msg_read.gif\">" : "<img src=\"images/msg_unread.gif\">";

-

- $msg_userid = $pm_list[$i]['user_id'];

- $msg_username = stripslashes($pm_list[$i]['group_name']);

- if($pm_list[$i]['group_single_user'])

- {

- $u_from_user_profile = "profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$msg_userid";

- }

- else

- {

- $u_from_user_profile = "groupadmin.$phpEx?" . POST_GROUPS_URL . "=$msg_userid";

- }

-

- $msg_id = $pm_list[$i]['privmsgs_id'];

-

- $msg_subject = stripslashes($pm_list[$i]['privmsgs_subject']);

- $u_subject = "privmsg.$phpEx?mode=read&box=$mode&" . POST_POST_URL . "=$msg_id";

-

- $msg_date = create_date($board_config['default_dateformat'], $pm_list[$i]['privmsgs_date'], $board_config['default_timezone']);

-

- if($flag == PRIVMSGS_NEW_MAIL)

- {

- $msg_subject = "<b>" . $msg_subject . "</b>";

- $msg_date = "<b>" . $msg_date . "</b>";

- $msg_username = "<b>" . $msg_username . "</b>";

- }

-

- if(!($i % 2))

- {

- $row_color = "#".$theme['td_color1'];

- }

- else

- {

- $row_color = "#".$theme['td_color2'];

- }

-

- $template->assign_block_vars("listrow",

- array(

- "ICON_FLAG_IMG" => $icon_flag,

- "FROM" => $msg_username,

- "SUBJECT" => $msg_subject,

- "DATE" => $msg_date,

- "ROW_COLOR" => $row_color,

-

- "U_READ" => $u_subject,

- "U_FROM_USER_PROFILE" => $u_from_user_profile)

- );

- } // for ...

-

- $template->assign_vars(array(

- "PAGINATION" => generate_pagination("privmsg.$phpEx?mode=$mode", $pm_total, $board_config['topics_per_page'], $start),

- "ON_PAGE" => (floor($start/$board_config['topics_per_page'])+1),

- "TOTAL_PAGES" => ceil(($pm_total)/$board_config['topics_per_page']),

-

- "L_OF" => $lang['of'],

- "L_PAGE" => $lang['Page'],

- "L_GOTO_PAGE" => $lang['Goto_page'])

- );

-

-}

-else if($mode == "read")

- if(!empty($HTTP_GET_VARS['box']))

- $box_type = $HTTP_GET_VARS['box'];

- if($box_type == "inbox" || $box_type == "saved")

- if($privmsg['privmsgs_type'] == PRIVMSGS_NEW_MAIL)

- $inbox_url = "<img src=\"images/msg_inbox.gif\" border=\"0\">&nbsp;<a href=\"" . append_sid("privmsg.$phpEx?mode=inbox") . "\"><b>" . $lang['Inbox'] . "</b></a>";

- $sent_url = "<img src=\"images/msg_inbox.gif\" border=\"0\">&nbsp;<a href=\"" . append_sid("privmsg.$phpEx?mode=sent") . "\"><b>" . $lang['Sent'] . "</b></a>";

- "INBOX_FOLDER" => $inbox_url,

- "SENT_FOLDER" => $sent_url,

- "L_FROM_OR_TO" => (($mode == "inbox") ? $lang['From'] : $lang['To']),

- "U_FOLDER2" => $u_folder2)

- $quote_img = "<a href=\"".append_sid("posting.$phpEx?mode=reply&quote=true&".POST_POST_URL."=".$privmsg['post_id']."&".POST_TOPIC_URL."=$topic_id&".POST_FORUM_URL."=$forum_id")."\"><img src=\"".$images['quote']."\" alt=\"$l_replyquote\" border=\"0\"></a>";