X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fvideos.php;h=2ee73c211d438c1787432bebb2069e1f7fe312b2;hb=7034d6efbd988e7481ac6f5d6413a8925221ed6b;hp=19d5ce9402b17ba448508e3f21c89d0dca84e8a1;hpb=5a6da8b447430174ae231a3b8203fd4bd8416cc1;p=friendica.git

diff --git a/mod/videos.php b/mod/videos.php
index 19d5ce9402..2ee73c211d 100644
--- a/mod/videos.php
+++ b/mod/videos.php
@@ -1,17 +1,19 @@
 <?php
+
+use Friendica\App;
+
 require_once('include/items.php');
 require_once('include/acl_selectors.php');
 require_once('include/bbcode.php');
 require_once('include/security.php');
 require_once('include/redir.php');
 
-
 function videos_init(App $a) {
 
-	if ($a->argc > 1)
+	if($a->argc > 1)
 		auto_redir($a, $a->argv[1]);
 
-	if ((get_config('system','block_public')) && (! local_user()) && (! remote_user())) {
+	if((get_config('system','block_public')) && (! local_user()) && (! remote_user())) {
 		return;
 	}
 
@@ -19,15 +21,14 @@ function videos_init(App $a) {
 
 	$o = '';
 
-	if ($a->argc > 1) {
+	if($a->argc > 1) {
 		$nick = $a->argv[1];
 		$user = q("SELECT * FROM `user` WHERE `nickname` = '%s' AND `blocked` = 0 LIMIT 1",
 			dbesc($nick)
 		);
 
-		if (!dbm::is_result($user)) {
+		if(! count($user))
 			return;
-		}
 
 		$a->data['user'] = $user[0];
 		$a->profile_uid = $user[0]['uid'];
@@ -53,35 +54,35 @@ function videos_init(App $a) {
 			intval($a->data['user']['uid'])
 		);
 
-		if (count($albums)) {
+		if(count($albums)) {
 			$a->data['albums'] = $albums;
 
 			$albums_visible = ((intval($a->data['user']['hidewall']) && (! local_user()) && (! remote_user())) ? false : true);
 
-			if ($albums_visible) {
+			if($albums_visible) {
 				$o .= '<div id="sidebar-photos-albums" class="widget">';
 				$o .= '<h3>' . '<a href="' . App::get_baseurl() . '/photos/' . $a->data['user']['nickname'] . '">' . t('Photo Albums') . '</a></h3>';
 
 				$o .= '<ul>';
-				foreach ($albums as $album) {
+				foreach($albums as $album) {
 
 					// don't show contact photos. We once translated this name, but then you could still access it under
 					// a different language setting. Now we store the name in English and check in English (and translated for legacy albums).
 
-					if ((! strlen($album['album'])) || ($album['album'] === 'Contact Photos') || ($album['album'] === t('Contact Photos')))
+					if((! strlen($album['album'])) || ($album['album'] === 'Contact Photos') || ($album['album'] === t('Contact Photos')))
 						continue;
 					$o .= '<li>' . '<a href="photos/' . $a->argv[1] . '/album/' . bin2hex($album['album']) . '" >' . $album['album'] . '</a></li>';
 				}
 				$o .= '</ul>';
 			}
-			if (local_user() && $a->data['user']['uid'] == local_user()) {
+			if(local_user() && $a->data['user']['uid'] == local_user()) {
 				$o .= '<div id="photo-albums-upload-link"><a href="' . App::get_baseurl() . '/photos/' . $a->data['user']['nickname'] . '/upload" >' .t('Upload New Photos') . '</a></div>';
 			}
 
 			$o .= '</div>';
 		}*/
 
-		if (! x($a->page,'aside'))
+		if(! x($a->page,'aside'))
 			$a->page['aside'] = '';
 		$a->page['aside'] .= $vcard_widget;
 
@@ -195,7 +196,7 @@ function videos_content(App $a) {
 	// videos/name/video/xxxxx/edit
 
 
-	if ((get_config('system','block_public')) && (! local_user()) && (! remote_user())) {
+	if((get_config('system','block_public')) && (! local_user()) && (! remote_user())) {
 		notice( t('Public access denied.') . EOL);
 		return;
 	}
@@ -205,7 +206,7 @@ function videos_content(App $a) {
 	require_once('include/security.php');
 	require_once('include/conversation.php');
 
-	if (! x($a->data,'user')) {
+	if(! x($a->data,'user')) {
 		notice( t('No videos selected') . EOL );
 		return;
 	}
@@ -218,16 +219,16 @@ function videos_content(App $a) {
 	// Parse arguments
 	//
 
-	if ($a->argc > 3) {
+	if($a->argc > 3) {
 		$datatype = $a->argv[2];
 		$datum = $a->argv[3];
 	}
-	elseif (($a->argc > 2) && ($a->argv[2] === 'upload'))
+	elseif(($a->argc > 2) && ($a->argv[2] === 'upload'))
 		$datatype = 'upload';
 	else
 		$datatype = 'summary';
 
-	if ($a->argc > 4)
+	if($a->argc > 4)
 		$cmd = $a->argv[4];
 	else
 		$cmd = 'view';
@@ -246,19 +247,19 @@ function videos_content(App $a) {
 
 	$community_page = (($a->data['user']['page-flags'] == PAGE_COMMUNITY) ? true : false);
 
-	if ((local_user()) && (local_user() == $owner_uid))
+	if((local_user()) && (local_user() == $owner_uid))
 		$can_post = true;
 	else {
-		if ($community_page && remote_user()) {
-			if (is_array($_SESSION['remote'])) {
-				foreach ($_SESSION['remote'] as $v) {
-					if ($v['uid'] == $owner_uid) {
+		if($community_page && remote_user()) {
+			if(is_array($_SESSION['remote'])) {
+				foreach($_SESSION['remote'] as $v) {
+					if($v['uid'] == $owner_uid) {
 						$contact_id = $v['cid'];
 						break;
 					}
 				}
 			}
-			if ($contact_id) {
+			if($contact_id) {
 
 				$r = q("SELECT `uid` FROM `contact` WHERE `blocked` = 0 AND `pending` = 0 AND `id` = %d AND `uid` = %d LIMIT 1",
 					intval($contact_id),
@@ -276,17 +277,17 @@ function videos_content(App $a) {
 
 	// perhaps they're visiting - but not a community page, so they wouldn't have write access
 
-	if (remote_user() && (! $visitor)) {
+	if(remote_user() && (! $visitor)) {
 		$contact_id = 0;
-		if (is_array($_SESSION['remote'])) {
-			foreach ($_SESSION['remote'] as $v) {
-				if ($v['uid'] == $owner_uid) {
+		if(is_array($_SESSION['remote'])) {
+			foreach($_SESSION['remote'] as $v) {
+				if($v['uid'] == $owner_uid) {
 					$contact_id = $v['cid'];
 					break;
 				}
 			}
 		}
-		if ($contact_id) {
+		if($contact_id) {
 			$groups = init_groups_visitor($contact_id);
 			$r = q("SELECT * FROM `contact` WHERE `blocked` = 0 AND `pending` = 0 AND `id` = %d AND `uid` = %d LIMIT 1",
 				intval($contact_id),
@@ -299,14 +300,14 @@ function videos_content(App $a) {
 		}
 	}
 
-	if (! $remote_contact) {
-		if (local_user()) {
+	if(! $remote_contact) {
+		if(local_user()) {
 			$contact_id = $_SESSION['cid'];
 			$contact = $a->contact;
 		}
 	}
 
-	if ($a->data['user']['hidewall'] && (local_user() != $owner_uid) && (! $remote_contact)) {
+	if($a->data['user']['hidewall'] && (local_user() != $owner_uid) && (! $remote_contact)) {
 		notice( t('Access to this item is restricted.') . EOL);
 		return;
 	}
@@ -324,13 +325,13 @@ function videos_content(App $a) {
 	//
 
 
-	if ($datatype === 'upload') {
+	if($datatype === 'upload') {
 		return; // no uploading for now
 
 		// DELETED -- look at mod/photos.php if you want to implement
 	}
 
-	if ($datatype === 'album') {
+	if($datatype === 'album') {
 
 		return; // no albums for now
 
@@ -338,7 +339,7 @@ function videos_content(App $a) {
 	}
 
 
-	if ($datatype === 'video') {
+	if($datatype === 'video') {
 
 		return; // no single video view for now
 
@@ -357,7 +358,9 @@ function videos_content(App $a) {
 		$a->set_pager_itemspage(20);
 	}
 
-	$r = q("SELECT hash, `id`, `filename`, filetype FROM `attach`
+	$r = q("SELECT hash, ANY_VALUE(`id`) AS `id`, ANY_VALUE(`created`) AS `created`,
+		ANY_VALUE(`filename`) AS `filename`, ANY_VALUE(`filetype`) as `filetype`
+		FROM `attach`
 		WHERE `uid` = %d AND filetype LIKE '%%video%%'
 		$sql_extra GROUP BY hash ORDER BY `created` DESC LIMIT %d , %d",
 		intval($a->data['user']['uid']),