SteemFriends.org New Features - Tag and Title filters for Upvoted & Written Article Listings, Stricter rules to filter out comments

Repository
https://github.com/Bulletproofmonk/MySteemitFriends

Merged Pull Request
https://github.com/Bulletproofmonk/MySteemitFriends/pull/23

http://steemfriends.org is a popular tool with approximately 20,000 hits per month.

New Feature One

You are now able to find an article you wrote, from a long time ago, instead of scrolling down your list of articles on Steemit for a very long time.

E.g. I wrote an article about Korea last year sometime, about my travel in Busan. If I wanted to find it on Steemit, I will have to scroll down on my main page through hundreds of articles. This is how you find it on my website.

Firstly, from the main page, type your Steem username in the textbox, then go to "User History" then click on "Written Articles".

You will see the follow page, with a list of articles you have written, in the last month:

Now, change the date range to when you think you wrote the article, so I changed it to beginning of 2017 until today. I then also typed the key word "Busan" into the title bar, which allowed me to find the two articles I wrote on Busan straight away.

Clicking on the permlink will also bring you to the Busan page.

New Feature Two

If you want to list all the articles you have written for a specific tag, you can also find it using this new feature.

Let's say I want to look at all the contributions I have made for Utopian. Simply type utopian-io into the tag textbox, set your wanted date range and then search.

Notice how the resulting list includes comments as well as articles. If I want to filter our comments, just click "Exclude Comments" and then the blue button to refresh results.

And now you can see all the articles I have written for Utopian! Yay!

New Feature Three

The tag and title filter boxes which work for the Written Articles also work for Upvoted articles. So, let's say I want to list all the articles in CN which I have upvoted in the last month. I simply go to the Upvoted Articles page by using the navigation bar (on the top right of the page):

Then I put my name in the username box, CN in the tag textbox and then click Search:

You may also use any of the other features, such as title filter and comments filter, with upvoted articles too.

In the last contribution, @emrebeyler mentioned that my code for filtering out comments may not be enough to filter out all comments made by other dapps. I have approached @arcange for assistance (thank you @arcange!) and now the new code uses the depth field of each post to decide whether it is a comment.

How they were implemented:

3 files were updated in this pull request:

articlelist.php
Controller gathers input for tag and title
The controller for article list now gathers Input for both the tag and the title filters set by the user. It then passes these to the models to retrieve data (list of articles filtered by tag and title).

articlelistmodel.php
Added tag and title filters to both votes and written articles
For both Written Articles and Voted Articles queries, the $tag and $title filters from the controller have been used to filter query results. If the user types a tag or a title or both into the form, the result will return articles matching their request.
The Written Articles query has also been re-written so that it does not rely on the "re-" prefix in the permlink to filter out comments. Rather, the TxVotes table has been joined with the Comments table using the author column as well as the permlink column, to use the depth field in the Comments table to filter out comments.

articlelistview.php
Added two input boxes for tag and title
Two input boxes have been added to the form:
The user can now enter a tag they want to filter the article list against.
The user can now enter a title they want to filter the article list against.
Both input boxes will work in both modes (Written & Upvoted articles).

GitHub Account
https://github.com/Bulletproofmonk