/*$sql="select users.id as uid,users.username,users.photo,photos.*,photos.id as pid,Year(NOW())-Year(photos.date) as time_elapsed,photos.date as photo_date from date_request join users on user_id_requestor=users.id join photos on photos.user_id=date_request.user_id_owner and (date_format(photos.date,'%m-%d')=date_format( '$user_date','%m-%d') or (DATE(photos.date) BETWEEN ('$user_date' - INTERVAL 6 DAY) AND ('$user_date'))) where user_id_owner=:uid and status=0";*/
//echo $sql;die;
$sth = $conn->prepare($sql);
$sth->bindValue("uid", $uid);
try {
$sth->execute();
} catch (Exception $e) {
}
$res1 = $sth->fetchAll();
if (count($res1)) {
$success = '1';
$msg = "Request Found";
if ($res1) {
foreach ($res1 as $key => $value) {
if (!isset($final[$value['uid']])) {
$final[$value['uid']] = array('requestor_id' => $value['uid'], 'username' => $value['username'] ? $value['username'] : "", 'user_pic' => $value['photo'] ? BASE_PATH . "timthumb.php?src=uploads/" . $value['photo'] : "", 'pictures' => DataClass::get_pictures($value['uid'], $uid, $zone, $user_date, $date));
}
/*if(!ISSET($final[$value['uid']]['pictures'][$value['pid']])){
if($value['pid']){
$final[$value['uid']]['pictures'][$value['pid']]=array(
"image_id"=>$value['pid']?$value['pid']:"",
"image_url"=>$value['image']?BASE_PATH."timthumb.php?src=uploads/".$value['image']:"",
"time_elapsed"=>$value['time_elapsed']?$value['time_elapsed']:0,
"photo_date"=>$value['photo_date']?$value['photo_date']:""
);
}}*/
}
}
if ($final) {
foreach ($final as $key => $value) {
$data2 = array();
