lbryio / comment-server Goto Github PK

Database needs a new table to accommodate:

• Pinning comments #29
  • one-to-many relation PINS: CLAIM -> COMMENT
• Channel Blocking
  • one-to-many relation BLOCKS: CHANNEL -> CHANNEL
• Storing information about claims, including public keys, addresses, stake amounts, etc.
  • CLAIM
    • type
    • stake_amount
    • address
    • claim_id
    • name
    • signing_channel
• CHANNEL
  • public_key
  • signature
  • public_key_id
• Requires making a table CLAIM which stores claim_type, signing_channel, stake_amount
• Action history (e.g. channel x edits comment y at time z)
  • either loose relation on table CHANNEL or a many-to-many relation between CHANNEL & COMMENT
    • action (creates, deletes, updates, hides, pins, etc.)
    • timestamp (good for modification time, etc.)
    • signature (of the action)
    • comment_id (if there is one)
• Messages
  • dunno if this will either be a modified signed version of COMMENT or if this should be its own entity entirely

What's needed:

• install and setup MySQL server both on comment server as well as elsewhere
• Migrate DDL to be compliant with MySQL datatypes
• Simplify existing queries to be MySQL compliant
• Create a quick setup script for MySQL server so unit-tests can run on Travis CI

Flagged comments should be reviewed & deleted accordingly

Users should be able to receive notifications whenever someone comments on their stuff

• users should be able to delete their comments in the app.
• users should also be able to edit their comments in the app.
• channel owners should be able to toggle whether or not selected comments may be hidden in the app
• channel owners should be allowed to toggle whether or not comments can be made by anonymous users, or at all

lbryio/lbry-sdk#2904

This might be part of a more generic method that would be used to mark comments

To support the api changes described in lbryio/lbry-sdk#2369

Comments should be allowed to thread, but only 1-layer deep.

i.e. {"jsonrpc":"2.0","method":"comment_update","params":{"comment_id":"5d35b5eedf7a8c90cc06e2dfb99ad0e66efa7333d0911d80ec8d460fe8abc6a2","comment":"What happens when this thread gets really long? Probably should collapse for viewers, with a \"show replies\"? "},"id":1584736786511}

As a super-user, copy the .service and .target files to the systemd directory:
$ sudo comment-server/config/comment-server* /etc/systemd/system
should read ( since you are in the comment-server directory );

sudo cp config/comment-server* /etc/systemd/system

Primary

• 1. Tipping Comment (Desktop Side)
• 2. Notifications (Desktop + Server + ???)
• 3. Threading/Replies (Desktop + Server maybe)
• 4. Toggle Comment Enabling (By Channel? By Claim?) (Desktop Side)
• 5. Deleting or Hiding (Desktop)
• 6. Editing Comments (Desktop)

Secondary

• up/downvotes
• respecting wallet server blacklists
• sorting

Desktop app

an api endpoint to track latest comments with claim_id, claim_name or maybe claim URLs to show to track comments on LBRY Platform

Comments need a button at the top right corner that allows users to edit/delete/report

In a step towards enabling comment moderation by claim/channel owners, we don't want to allow anonymous comments since there's no cost to spamming with them. We will prompt users to create a channel if they want to comment, and channel owners can block other channels from commenting (separate issue).