public static function getVideo($id)
{
$video = DB::table('videos AS v')->join('users AS u', 'v.user_id', '=', 'u.id')->where('v.id', $id)->select(array('*', 'v.id AS video_id', 'v.creation_date AS video_creation_date'))->first();
$video->time_interval = calculate_time_period($video->video_creation_date);
$video->video_view_count = show_view_count($video->video_view_count);
$video->view_count = show_view_count($video->view_count);
return $video;
}
public static function getPhoto($id)
{
$photo = DB::table('photos AS p')->join('users AS u', 'p.user_id', '=', 'u.id')->join('files AS f', 'f.parent_id', '=', 'p.id')->where('p.id', $id)->select(array('*', 'p.id AS photo_id', 'p.creation_date AS photo_creation_date'))->first();
$photo->time_interval = calculate_time_period($photo->photo_creation_date);
$photo->photo_view_count = show_view_count($photo->photo_view_count);
$photo->view_count = show_view_count($photo->view_count);
return $photo;
}
