<?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) {
+function videos_init(App $a) {
if($a->argc > 1)
auto_redir($a, $a->argv[1]);
-function videos_post(App &$a) {
+function videos_post(App $a) {
$owner_uid = $a->data['user']['uid'];
-function videos_content(App &$a) {
+function videos_content(App $a) {
// URLs (most aren't currently implemented):
// videos/name
$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']),