Fix profile wrong DISTINCT + ORDER BY

[friendica.git] / mod / videos.php

diff --git a/mod/videos.php b/mod/videos.php
index 433ce5fc63f82e2e150b7b7c9ce87325553ba50e..ea2e0d4a24f08ca84c0cca7d6406757e8f601812 100644 (file)
--- a/mod/videos.php
+++ b/mod/videos.php
@@ -6,7 +6,7 @@ require_once('include/security.php');
 require_once('include/redir.php');
 
 
-function videos_init(App &$a) {
+function videos_init(App $a) {
 
        if($a->argc > 1)
                auto_redir($a, $a->argv[1]);
@@ -102,7 +102,7 @@ function videos_init(App &$a) {
 
 
 
-function videos_post(App &$a) {
+function videos_post(App $a) {
 
        $owner_uid = $a->data['user']['uid'];
 
@@ -182,7 +182,7 @@ function videos_post(App &$a) {
 
 
 
-function videos_content(App &$a) {
+function videos_content(App $a) {
 
        // URLs (most aren't currently implemented):
        // videos/name
@@ -358,7 +358,7 @@ function videos_content(App &$a) {
 
        $r = q("SELECT hash, `id`, `filename`, filetype FROM `attach`
                WHERE `uid` = %d AND filetype LIKE '%%video%%'
-               $sql_extra GROUP BY hash ORDER BY `created` DESC LIMIT %d , %d",
+               $sql_extra GROUP BY hash, `id` ORDER BY `created` DESC LIMIT %d , %d",
                intval($a->data['user']['uid']),
                intval($a->pager['start']),
                intval($a->pager['itemspage'])