My Steemit Friends Update: Witness Voting Power Ranking can now exclude users with 0 witness votes. Search & page browsing functions work under both modes.

• My Steemit Friends Tool website.
  
• Github repository.
• Commit for this update and other commits on Feb 20, 2018.

New Features

Some new features have been added to the Witness Voting Power Ranking, which you can access at http://mysteemitfriends.online/witnessvoting.php

Feature 1

You can see on the left hand side of the page, there is now an "Options" box, which will allow you to select between to modes - whether you want to include all users or to exclude users who have not voted for any witnesses. See the difference in ranking for the two modes.

Mode 1: All users.

Mode 2: Users who have voted for at least one witness.

Feature 2

The search function will work under both modes (Make sure you click "Refresh" to get into that mode first). Here are some possibilities:

In All Users mode, my ranking is:

In "Votes Casted >0" mode, my ranking is:

You can click the blue link at the bottom of the ranking to see your name highlighted in the tables.

In the "Votes Casted > 0" mode, if you search for a user who has casted 0 votes, it will return this result:

In either modes, if you search for a user who has set their proxy to another user, it will return this result:

Feature 3

The page browsing features will work under both modes and retrieve the ranking table for which ever mode you are on.

How did you implement it/them?

• Relevant commit and other commits on Feb 20, 2018.

In witnessvoting.php, I created a radio button form to collect input from the user as to whether they want all users included in the ranking, or if they just want the users who have voted for at least one witness included in the ranking. I then used PHP to retrieve this input and then use an IF statement to alter the SQL query according to what the user has chosen. I also edited the PHP code for the username search box and page browsing links to make sure they work under both modes.

In get_voting_rank.php, I again used a PHP If statemnt to modify the SQL query for querying the database under both modes, and return the correct result depending on which query was executed. A second query is executed in the search result to find out a user's proxy if they are not part of the ranking. If they did not have a proxy and are not part of the ranking, then it must mean that they have not casted any witness votes (only occurs in Witness votes >0 mode).

---

Posted on Utopian.io - Rewarding Open Source Contributors

---