Resolved - Add following for tags

Follow tag(s).

Done - Display followed tag posts separate from stream of followed users.

Sample on a user profile page:

• Following Tags : 3

will it be possible to follow tags at the user level? - not now

will it be possible to follow a search string? - not now

maybe getting carried away. - yes. as of 26apr2013, will only implement tag following for global tags.

will at least implement following tags at the overall level and not at the user level initially. Done

database

following db table:

• id - int
• userid - int
• following - int
• createddate - date

rename "following" to "followinguserid"

add new columns.

• type - char (u=user or t=tag or b=both)
• followingtag - varchar

b=following a user tag

sql where str

• following users which exists in code now = c.authorid in (2, 5, 9, 20, 34)

• proposed following tags may looke like this = c.tags like in (x|design|x, x|blogging|x, x|mobile|x)
  • x = % sign

following user tags

will need to create and conditions for the authorid and the tag(s) being followed.

Ex:

username = junco
follow junco's tagged posts for: mobile, blogging, and design

username = jr
follow jr's tagged posts for: weather and birds.

sql where clause would include:

(c.authorid=2 and c.tags like in (x|mobile|x, x|blogging|x, x|design|x)
OR (c.authorid=1 and c.tags like in (x|weather|x, x|birds|x)

following searches

/search/responsive+AND+design

Follow search strings?

For the above: "responsive AND design"

would need another column in following table.

• followingsearch - varchar

for the "type" column:

• u = following user
• t = following tag
• b = following a user's tagged posts
• s = following a search string

possible new db table

• id - int
• userid - int
• type - char
• followinguser - int
• followingstring - varchar
• createddate - date

"followingstring" could store a single tag name or a search string with ANDs and ORs

the "type" field will determine how code operates.

#junco
#resolved