1 min

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

From JR's : articles
315 words - 1966 chars - 1 min read
created on
updated on
import date 2013-08-12 21:49:52 - #
source - versions

Related articles
Resolved - Fix feed command - Jun 27, 2013
Resolved - Remove the social components and maybe starting over - Aug 20, 2013
Resolved - Define status SQL possibilities in config file. - Jun 27, 2013
Add text resizer links - Aug 08, 2013
Resolved - Fix backlinks not working issue - Aug 26, 2013
more >>



A     A     A     A     A

© 2013-2017 JotHut - Online notebook

current date: Mar 29, 2024 - 3:26 a.m. EDT