get_channel(); $is_owner = (local_user() && (local_user() == $channel['channel_id'])); //maintenance - see if a file got dropped and remove it systemwide $x = q("SELECT * FROM item WHERE verb = '%s' AND obj_type = '%s' AND uid = %d", dbesc(ACTIVITY_UPDATE), dbesc(ACTIVITY_OBJ_FILE), intval(local_user()) ); if($x) { foreach($x as $xx) { $object = json_decode($xx['object'],true); $hash = $object['hash']; //If object has a mid it's an update - the inlcuded mid is the latest and should not be removed $update = (($object['mid']) ? true : false); if($update) { $mid = $object['mid']; $y = q("DELETE FROM item WHERE (mid != '%s' AND obj_type = '%s' AND object LIKE '%s') AND (verb = '%s' OR verb = '%s')", dbesc($mid), dbesc(ACTIVITY_OBJ_FILE), dbesc('%"hash":"' . $hash . '"%'), dbesc(ACTIVITY_POST), dbesc(ACTIVITY_UPDATE) ); } else { $z = q("DELETE FROM item WHERE (obj_type = '%s' AND object LIKE '%s') AND (verb = '%s' OR verb = '%s')", dbesc(ACTIVITY_OBJ_FILE), dbesc('%"hash":"' . $hash . '"%'), dbesc(ACTIVITY_POST), dbesc(ACTIVITY_UPDATE) ); } } } //drop single file - localuser if((argc() > 2) && (argv(2) === 'drop')) { $id = intval(argv(1)); q("DELETE FROM item WHERE id = %d AND uid = %d", intval($id), intval(local_user()) ); goaway(z_root() . '/sharedwithme'); } //drop all files - localuser if((argc() > 1) && (argv(1) === 'dropall')) { q("DELETE FROM item WHERE verb = '%s' AND obj_type = '%s' AND uid = %d", dbesc(ACTIVITY_POST), dbesc(ACTIVITY_OBJ_FILE), intval(local_user()) ); goaway(z_root() . '/sharedwithme'); } //list files $r = q("SELECT * FROM item WHERE verb = '%s' AND obj_type = '%s' AND uid = %d AND owner_xchan != '%s'", dbesc(ACTIVITY_POST), dbesc(ACTIVITY_OBJ_FILE), intval(local_user()), dbesc($channel['channel_hash']) ); $o = profile_tabs($a, $is_owner, $channel['channel_address']); $o .= '

'; $o .= ' ' . t('Remove all entries') . ''; $o .= '

' . t('Files shared with me') . '

'; $o .= '

'; if($r) { foreach($r as $rr) { $object = json_decode($rr['object'],true); $url = rawurldecode(get_rel_link($object['link'],'alternate')); $o .= '' . $url . '

'; } } $o .= '

'; return $o; }