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*



h2. 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

h2. 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)


h2. 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


h2. 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

toc=no