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