We now should send all data in the new format

[friendica.git] / mod / videos.php

diff --git a/mod/videos.php b/mod/videos.php
index ea2e0d4a24f08ca84c0cca7d6406757e8f601812..2ee73c211d438c1787432bebb2069e1f7fe312b2 100644 (file)
--- a/mod/videos.php
+++ b/mod/videos.php
@@ -1,11 +1,13 @@
 <?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)
@@ -356,9 +358,11 @@ 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, `id` ORDER BY `created` DESC LIMIT %d , %d",
+               $sql_extra GROUP BY hash ORDER BY `created` DESC LIMIT %d , %d",
                intval($a->data['user']['uid']),
                intval($a->pager['start']),
                intval($a->pager['itemspage'])