|
0)
{
while($row = mysqli_fetch_array($res))
{
$date = $row['date'];
$regex_pattern = "/(.+)-(.+)-(.+)\s(.+)/";
preg_match_all($regex_pattern, $date, $matches);
$month_name = date('F', mktime(0, 0, 0, $matches[2][0]));
$day_number = remLeadZero($matches[3][0]);
$year = $matches[1][0];
$time = date("g:i a", strtotime($matches[4][0]));
$message_id = $row['message_id'];
$from_id = $row['from_id' ];
$message = $row['message' ];
$link = $row['link' ];
$regex_pattern = "/.+&(.+)=(.+)/";
preg_match_all($regex_pattern, $link, $matches);
$link_type = $matches[1][0];
$link_id = $matches[2][0];
if ($link_type == "sid")
{
$subject = "Service: ";
$sql = "SELECT title FROM skills WHERE skill_id = $link_id";
$res2 = mysqli_query($mysqli, $sql);
if ($res2)
{
$row2 = mysqli_fetch_array($res2);
$title = $row2['title'];
mysqli_free_result($res2);
}
}
elseif ($link_type == "pid")
{
$subject = "Job: ";
$sql = "SELECT title FROM projects WHERE project_id = $link_id";
$res2 = mysqli_query($mysqli, $sql);
if ($res2)
{
$row2 = mysqli_fetch_array($res2);
$title = $row2['title'];
mysqli_free_result($res2);
}
}
else
{
$subject = "";
$title = "";
}
$sql = "SELECT user_name,profile_photo FROM profiles WHERE user_id = '$from_id'";
$res2 = mysqli_query($mysqli, $sql);
if ($res2)
{
$row2 = mysqli_fetch_array($res2);
$from_name = $row2['user_name'];
$from_photo = $row2['profile_photo'];
$mysock = getimagesize("uploads/$from_photo");
$image_size = imageResize($mysock[0], $mysock[1], 75);
mysqli_free_result($res2);
}
echo "";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo "From: $from_name | $month_name $day_number, $year - $time | ";
echo "
";
echo "";
echo "$subject$title | ";
echo "";
echo "Message: $message | ";
echo " | ";
echo "";
echo "";
echo " |
| | ";
}
}
}
mysqli_free_result($res);
//mysqli_close($mysqli);
?>
0)
{
while($row = mysqli_fetch_array($res))
{
$date = $row['date'];
$regex_pattern = "/(.+)-(.+)-(.+)\s(.+)/";
preg_match_all($regex_pattern, $date, $matches);
$month_name = date('F', mktime(0, 0, 0, $matches[2][0]));
$day_number = remLeadZero($matches[3][0]);
$year = $matches[1][0];
$time = date("g:i a", strtotime($matches[4][0]));
$message_id = $row['message_id'];
$to_id = $row['to_id' ];
$message = $row['message' ];
$link = $row['link' ];
$regex_pattern = "/.+&(.+)=(.+)/";
preg_match_all($regex_pattern, $link, $matches);
$link_type = $matches[1][0];
$link_id = $matches[2][0];
if ($link_type == "sid")
{
$subject = "Service: ";
$sql = "SELECT title FROM skills WHERE skill_id = $link_id";
$res2 = mysqli_query($mysqli, $sql);
if ($res2)
{
$row2 = mysqli_fetch_array($res2);
$title = $row2['title'];
mysqli_free_result($res2);
}
}
elseif ($link_type == "pid")
{
$subject = "Job: ";
$sql = "SELECT title FROM projects WHERE project_id = $link_id";
$res2 = mysqli_query($mysqli, $sql);
if ($res2)
{
$row2 = mysqli_fetch_array($res2);
$title = $row2['title'];
mysqli_free_result($res2);
}
}
else
{
$subject = "";
$title = "";
}
$sql = "SELECT profile_photo FROM profiles WHERE user_id = $user_id";
$res2 = mysqli_query($mysqli, $sql);
if ($res2)
{
$row2 = mysqli_fetch_array($res2);
$to_photo = $row2['profile_photo'];
$mysock = getimagesize("uploads/$to_photo");
$image_size = imageResize($mysock[0], $mysock[1], 75);
mysqli_free_result($res2);
}
$sql = "SELECT user_name FROM profiles WHERE user_id = $to_id";
$res2 = mysqli_query($mysqli, $sql);
if ($res2)
{
$row2 = mysqli_fetch_array($res2);
$to_name = $row2['user_name'];
mysqli_free_result($res2);
}
echo "";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo "To: $to_name | $month_name $day_number, $year - $time | ";
echo "
";
echo "";
echo "$subject$title | ";
echo "";
echo "Message: $message | ";
echo " | ";
echo "";
echo " |
| | ";
}
}
}
mysqli_free_result($res);
mysqli_close($mysqli);
?>
| | |