PageMessagesOutboxMainCode_db_num ); } else { echo ''; } // --------------- [END] page components PageCode(); // --------------- page components functions /** * page code function */ function PageCompPageMainCode() { global $site; $messageID = ((int)$_GET['message']); $memberID = ((int)$_COOKIE['memberID']); $sender_sql = "SELECT `Recipient` FROM `Messages` WHERE `Sender` = '$memberID' AND `ID` = '$messageID'"; $sender_arr = db_arr( $sender_sql ); $senderID = $sender_arr['Recipient']; $message_sql= "SELECT m.`Text`, m.`Subject`, DATE_FORMAT( m.`Date`, '%Y-%m-%d' ) AS `Date`, p.Status FROM `Messages` AS m LEFT JOIN Profiles AS p ON m.Recipient = p.ID WHERE m.`ID` = '$messageID'";// AND`Sender` = '$senderID'"; $message_arr= db_arr($message_sql); $ret = ''; $ret .= '
'; $ret .= ProfileDetails( $senderID ); $ret .= '
'; $ret .= '
'; $ret .= '
'; $ret .= '
'; $ret .= '
'; $ret .= _t('_Date').':'; $ret .= '
'; $ret .= '
'; $ret .= $message_arr['Date']; $ret .= '
'; $ret .= '
'; $ret .= _t('_Subject').':'; $ret .= '
'; $ret .= '
'; $ret .= process_smiles( process_line_output($message_arr['Subject']) ); $ret .= '
'; $ret .= '
'; $ret .= '
'; $ret .= process_html_output($message_arr['Text'], 80); $ret .= '
'; $ret .= '
'; $ret .= '
'; //$ret .= '
'; if( $message_arr['Status'] == 'Active' ) { $ret .= '
'; $ret .= ''._t('_Write new Message').''; $ret .= '
'; $ret .= '
'; } else { $ret .= ''; } //#################################################### $ret .= '
'; $ret .= PageCorespondence( $memberID, $senderID ); $ret .= '
'; return $ret; } function PageCorespondence( $memberID, $senderID ) { global $site; global $date_format; $preview_leight = 25; $sender_nickname = getProfileInfo( $senderID ); //db_arr("SELECT `NickName` FROM `Profiles` WHERE `ID` = '$senderID'"); $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"; $member_to_sender_res = db_res($member_to_sender_query); $member_to_sender_num = mysql_num_rows($member_to_sender_res); $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"; $sender_to_member_res = db_res($sender_to_member_query); $sender_to_member_num = mysql_num_rows($sender_to_member_res); $ret .= '
'; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $j_out = '0'; while($member_to_sender_arr = mysql_fetch_assoc($member_to_sender_res)) { if(strlen( $member_to_sender_arr['Subject'] ) == 0 ) { $cor_subject_out = $member_to_sender_arr['Preview']; if ( strlen( $member_to_sender_arr['Preview'] ) >= $preview_length ) { $cor_subject_out .= "..."; } } else { $cor_subject_out = $member_to_sender_arr['Subject']; if ( strlen( $member_to_sender_arr['Subject'] ) >= $preview_length ) { $cor_subject_out .= "..."; } } if( $_GET['message'] == $member_to_sender_arr['mID'] ) { $new_out = 'current_mes.png'; $style_add_in = ''; } else { if( '1' == $member_to_sender_arr['New'] ) { $new_out = 'not_readed.gif'; $style_add = 'style="font-weight:bold;"'; } else { $new_out = 'readed.gif'; $style_add = ''; } } if( ($j_out%2) != '0') { $bgcolor = '#FFFFFF'; } else { $bgcolor = '#EAF6C6'; } $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $j_out++; } $ret .= '
'; $ret .= _t('_messages_to', $sender_nickname['NickName']); $ret .= '
'; $ret .= ''; $ret .= ''; $ret .= _t('_Date'); $ret .= ''; $ret .= _t('_Subject'); $ret .= '
'; $ret .= ''; $ret .= ''; $ret .= $member_to_sender_arr['Date']; $ret .= ''; $ret .= ''; $ret .= process_line_output(html2txt( $cor_subject_out )); $ret .= ''; $ret .= '
'; $ret .= '
'; //################################################################################# $ret .= '
'; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $j_in = '0'; while ($sender_to_member_arr = mysql_fetch_assoc($sender_to_member_res)) { if(strlen( $sender_to_member_arr['Subject'] ) == 0 ) { $cor_subject_in = $sender_to_member_arr['Preview']; if ( strlen( $sender_to_member_arr['Preview'] ) >= $preview_length ) { $cor_subject_in .= "..."; } } else { $cor_subject_in = $sender_to_member_arr['Subject']; if ( strlen( $sender_to_member_arr['Subject'] ) >= $preview_length ) { $cor_subject_in .= "..."; } } if( '1' == $sender_to_member_arr['New'] ) { $new_in = 'not_readed.gif'; $style_add_in = 'style="font-weight:bold;"'; } else { $new_in = 'readed.gif'; $style_add_in = ''; } if( ($j_in%2) != '0') { $bgcolor = '#FFFFFF'; } else { $bgcolor = '#EAF6C6'; } $ret .= ''; $ret .= ''; $ret .= ''; $ret .= ''; $j_in++; } $ret .= '
'; $ret .= _t('_messages_from', $sender_nickname['NickName']); $ret .= '
'; $ret .= ''; $ret .= ''; $ret .= _t('_Date'); $ret .= ''; $ret .= _t('_Subject'); $ret .= '
'; $ret .= ''; $ret .= ''; $ret .= $sender_to_member_arr['Date']; $ret .= ''; $ret .= ''; $ret .= process_line_output(html2txt( $cor_subject_in )); $ret .= ''; $ret .= '
'; $ret .= '
'; return $ret; } ?>