while ($row = mysql_fetch_array($result)) {
$iid = $row[0];
$type = $row[1];
if ($type == 1) {
$type = '<span class="bold red">Payment</span>';
} elseif ($type == 2) {
$type = '<span class="bold blue">Invoice</span>';
} elseif ($type == 3) {
$type = '<span class="bold green">Credit</span>';
}
$inv = $row[2];
$from = $row[3];
$to = $row[4];
$amount = $row[5];
$timestamp = $row[6];
$time = chronos($timestamp, 0);
$status = $row[7];
if ($status == '0') {
$status = '<span class="bold red">Pending</span>';
} elseif ($status == '1') {
$status = '<span class="bold green">Cleared</span>';
}
$row_color = $row_count % 2 ? $color1 : $color2;
?>
<tr class="<?php
echo $row_color;
?>
">
<td valign="top"><a href="https://www.benfund.com/client/payment_manager/view_invoice.php?iid=<?php
echo $iid;
?>
<?php
benfund_connect();
$pid = $_GET['pid'];
$mid = $_SESSION['mid'];
$mpage_query = "SELECT title, content, date FROM mpages WHERE mid = '{$mid}' AND pid = '{$pid}' LIMIT 1";
$mpage_results = mysql_query($mpage_query) or die(mysql_error());
$mpage_row = mysql_fetch_row($mpage_results) or die(mysql_error());
$ptitle = $mpage_row[0];
$pcontent = $mpage_row[1];
$pdate = chronos($mpage_row[2], 4);
<th valign="top" >Delete</th>
</tr>
<?php
benfund_connect();
$comment_result = mysql_query("SELECT id, comment_name, comment_title, comment_text, comment_time FROM comments WHERE mid='{$mid}' AND approved ='1' AND comment_private='1'");
$color1 = "row0";
$color2 = "row1";
$row_count = 0;
while ($comment_row = mysql_fetch_array($comment_result)) {
$comment_id = $comment_row[0];
$comment_from = $comment_row[1];
$comment_title = $comment_row[2];
//$comment_text = $comment_row[3];
$comment_text = substr($comment_row[3], 0, 40);
$comment_text = substr($comment_row[3], 0, strrpos($comment_text, " "));
$comment_date = chronos($comment_row[4], 0);
$row_color = $row_count % 2 ? $color1 : $color2;
if ($comment_read == 0) {
$fresh = '<img src=https://www.benfund.com/images/elements/icons/sm/mail-new.png>';
}
if ($comment_read == 1) {
$fresh = '<img src=https://www.benfund.com/images/elements/icons/sm/mail-open.png>';
}
if ($comment_reply == 1) {
$fresh = '<img src=https://www.benfund.com/images/elements/icons/sm/mail-reply.png>';
}
if ($comment_reply == 2) {
$fresh = '<img src=https://www.benfund.com/images/elements/icons/sm/mail-forward.png>';
}
?>
<tr class="<?php
session_start();
if (!isset($_SESSION[valid_user])) {
header('Location:../login.php');
} else {
$page_title = "View Client Note";
require "../includes/globals.php";
require $ROOT . "/functions/common.php";
$nid = $_GET['nid'];
benfund_connect();
$notes_query = "SELECT id, mid, cid, date, text FROM client_notes WHERE id = '{$nid}' AND mid = '{$mid}'";
$notes_result = mysql_query($notes_query) or die(mysql_error());
$notes_row = mysql_fetch_row($notes_result) or die(mysql_error());
$nid = $notes_row[0];
$cid = $notes_row[2];
$n_date = chronos($notes_row[3], 4);
$n_text = $notes_row[4];
benfund_connect();
$client_query = "SELECT first_name, m_i, last_name FROM client WHERE cid = '{$cid}' AND mid = '{$mid}'";
$client_result = mysql_query($client_query) or die(mysql_error());
$client_row = mysql_fetch_row($client_result) or die(mysql_error());
$c_name = $client_row[0] . ' ' . $client_row[1] . ' ' . $client_row[2];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
echo $page_title;
?>
- BenFund</title>
<?php