Community Mode: Custom Tag Logic

[tibfox]

In DIYHub we categorize posts when we curate them with a 1:1 category relation. We use MySQL for our curation database and I imagine a folder-like structure for users to explore the community on a dedicated page.

by clicking on one of those they get to another level where all the specific categories are listed.

This is just an idea - if a tree is easier to implement I think that would work too.

Our database:

1. Table "curationChoices"
   • postAuthor
   • postPermlink
   • category

2. Table "curationCategories"
   • categoryShort
   • categoryLong
   • mainCategory

3. The relation between both tables is via category <> categoryShort ( I know I should have used the id ;) )

We could create a database view where the postAuthor is combined with the postPermlink and the mainCategory+categoryLong are already joined.

In the best case there is a new admin part:

1. enter the curation database system (MySQL, ms SQL, etc.)
2. enter host, port, credentials
3. pick the post table / database view
4. pick the 3 important columns from 3.
   • post identifier (@author/permlink)
   • post main category
   • post sub category