{"action":"created","issue":{"url":"https://api.github.com/repos/HelloZeroNet/ZeroNet/issues/233","labels_url":"https://api.github.com/repos/HelloZeroNet/ZeroNet/issues/233/labels{/name}","comments_url":"https://api.github.com/repos/HelloZeroNet/ZeroNet/issues/233/comments","events_url":"https://api.github.com/repos/HelloZeroNet/ZeroNet/issues/233/events","html_url":"https://github.com/HelloZeroNet/ZeroNet/issues/233","id":125769042,"number":233,"title":"New ZeroHello with News feed","user":{"login":"HelloZeroNet","id":10350359,"avatar_url":"https://avatars.githubusercontent.com/u/10350359?v=3","gravatar_id":"","url":"https://api.github.com/users/HelloZeroNet","html_url":"https://github.com/HelloZeroNet","followers_url":"https://api.github.com/users/HelloZeroNet/followers","following_url":"https://api.github.com/users/HelloZeroNet/following{/other_user}","gists_url":"https://api.github.com/users/HelloZeroNet/gists{/gist_id}","starred_url":"https://api.github.com/users/HelloZeroNet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/HelloZeroNet/subscriptions","organizations_url":"https://api.github.com/users/HelloZeroNet/orgs","repos_url":"https://api.github.com/users/HelloZeroNet/repos","events_url":"https://api.github.com/users/HelloZeroNet/events{/privacy}","received_events_url":"https://api.github.com/users/HelloZeroNet/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/HelloZeroNet/ZeroNet/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/HelloZeroNet/ZeroNet/labels/hard","name":"hard","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"shortcutme","id":1019235,"avatar_url":"https://avatars.githubusercontent.com/u/1019235?v=3","gravatar_id":"","url":"https://api.github.com/users/shortcutme","html_url":"https://github.com/shortcutme","followers_url":"https://api.github.com/users/shortcutme/followers","following_url":"https://api.github.com/users/shortcutme/following{/other_user}","gists_url":"https://api.github.com/users/shortcutme/gists{/gist_id}","starred_url":"https://api.github.com/users/shortcutme/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shortcutme/subscriptions","organizations_url":"https://api.github.com/users/shortcutme/orgs","repos_url":"https://api.github.com/users/shortcutme/repos","events_url":"https://api.github.com/users/shortcutme/events{/privacy}","received_events_url":"https://api.github.com/users/shortcutme/received_events","type":"User","site_admin":false},"milestone":null,"comments":9,"created_at":"2016-01-09T16:55:21Z","updated_at":"2016-01-20T12:51:42Z","closed_at":null,"body":"Allow to sign up to database queries, so you can have one, unified list of latest blog posts/comments/replies.\r\n\r\nTodo:\r\n - [x] Static version of new ZeroHello\r\n - [ ] Implement new commands\r\n - [x] Modify ZeroBlog to allow signup to New posts/Username mentions/Comments\r\n - [ ] Modify ZeroTalk to allow signup to New topic/Username mentions/Comments\r\n - [ ] Site listing on new ZeroHello\r\n - [ ] Site commands on new ZeroHello: Pause, Delete, Clone\r\n - [ ] Display newsfeed on new ZeroHello\r\n - [ ] Tor/Port open status to new ZeroHello\r\n - [ ] New logo favicon/systray\r\n\r\nNew commands:\r\n - [ ] feedFollow feeds -> Set queries that user follows {Name: Query, ...}\r\n - [ ] dbQueryFeed -> List last results from signed up queries (admin permission required)\r\n\r\n~~UI modifications idea 1:~~\r\n - ~~Add new tab to sidebar~~\r\n - ~~Add per site notification count to ZeroHello~~\r\n\r\nUI modifications idea 2:\r\n - Create a new ZeroHello with newsfeed-like activity listing\r\n\r\nQuery specification:\r\n - event_uri: unique id of the event\r\n - type: article, topic, comment, message, image, news, mention, album, warning, error, info\r\n - date_added\r\n - title\r\n - body\r\n - url\r\n\r\nQuery examples:\r\nLast posts in ZeroBlog:\r\n ```sql\r\nSELECT \r\n post_id AS event_uri\r\n \"article\" AS type,\r\n date_published AS date_added,\r\n title AS title,\r\n body AS body,\r\n \"/Post:\" || post_id AS url\r\nFROM post ORDER BY date_published DESC\r\n ```\r\n\r\nNew topic in ZeroTalk:\r\n```sql\r\nSELECT \r\n topic_id || \"_\" || topic_creator_json.directory AS event_uri,\r\n 'topic' AS type,\r\n added AS date_added,\r\n \"New topic: \" || title AS title,\r\n body AS body,\r\n \"/Topic:\" || topic_id || \"_\" || topic_creator_json.directory AS url\r\nFROM `topic`\r\nLEFT JOIN json AS topic_creator_json ON (topic_creator_json.json_id = topic.json_id)\r\nORDER BY added DESC\r\n```\r\n\r\nLast posts in ZeroTalk mentioned username:\r\n```sql\r\nSELECT \r\n topic_uri AS event_uri,\r\n 'mention' AS type,\r\n added AS date_added,\r\n body AS body\r\nFROM comment \r\nWHERE body LIKE '%@nofish%' OR body LIKE '%[nofish]%' \r\nORDER BY added DESC\r\n```\r\n\r\nIn the current form ZeroMail messages unfortunately won't be possible to put in the News feed"},"comment":{"url":"https://api.github.com/repos/HelloZeroNet/ZeroNet/issues/comments/173195236","html_url":"https://github.com/HelloZeroNet/ZeroNet/issues/233#issuecomment-173195236","issue_url":"https://api.github.com/repos/HelloZeroNet/ZeroNet/issues/233","id":173195236,"user":{"login":"idlesong","id":1185261,"avatar_url":"https://avatars.githubusercontent.com/u/1185261?v=3","gravatar_id":"","url":"https://api.github.com/users/idlesong","html_url":"https://github.com/idlesong","followers_url":"https://api.github.com/users/idlesong/followers","following_url":"https://api.github.com/users/idlesong/following{/other_user}","gists_url":"https://api.github.com/users/idlesong/gists{/gist_id}","starred_url":"https://api.github.com/users/idlesong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/idlesong/subscriptions","organizations_url":"https://api.github.com/users/idlesong/orgs","repos_url":"https://api.github.com/users/idlesong/repos","events_url":"https://api.github.com/users/idlesong/events{/privacy}","received_events_url":"https://api.github.com/users/idlesong/received_events","type":"User","site_admin":false},"created_at":"2016-01-20T12:51:42Z","updated_at":"2016-01-20T12:51:42Z","body":"This feature seams like a kind of zerome, they seams very familiar."}}