My Steemit Friends Update: Witness Voting Power Ranking for all users feature integrated into website.

• My Steemit Friends Tool website.
  
• Github repository.
• Merged Pull Request

New Features

• What feature(s) did you add?

Previously, the Witness Voting Power of Proxies ranking only contained proxies. In other words, if no user has proxied their voting power to you, then you will not appear in the ranking.

In this new edition of My Steemit Friends, the Witness Voting Power of all users ranking has been integrated into My Steemit Friends. If you have any voting power not proxied to others, you will appear in this ranking, including if you are a proxy yourself. You can find a link to the ranking table from the navigation bar of the main page of the My Steemit Friends website here: http://mysteemitfriends.online.

After you click into the link in the drop down, you will see the Witness Voting Power of All Users ranking table. You can also access this page directly here if you wish: http://mysteemitfriends.online/witnessvoting.php

You can type your name into the search box to see your ranking, and then click the link to be directed to the page with your name highlighted in the ranking tables.

If you have proxied your voting power to others, then you will not appear on this ranking table, so this will be the message when you search for your ranking. It will tell you the name of the user that you have proxied your voting power to.

From the main My Steemit Friends page, you can also type in your username here and see the ranking directly, without going into the ranking table. Then you can click on the blue link at the bottom to see your name in ranking table page highlighted.

• How did you implement it/them?
  Link to relevant lines in the code on GitHub and explain briefly what you added/changed.

• witnessvoting.php: A list of all users (who have not proxied their voting power to others) ranked by the total number of vests (own vests + others who have proxied to this person, if there are any). SQL statements involving several inner joins are used to retrieve the ranking data from SteemSQL, and PHP is used to dispaly them. PHP sanitizing function is used on the page number input from the user and prepared SQL statements are used to prevent SQL injection. PHP statements are used to check for highlights.

• get_voting_rank.php: This PHP file is accessed by using AJAX when users click on Search Ranking button in either the ranking table page or the main My Steemit Friend page. SQL is used to order the users and retrieve the ranking of a particular user. Finally PHP and HTML is used to create the link to the correct page on the ranking table, and an IF statement is used to prevent an error where a userhas proxied their voting power to another user - it will output the name of the proxy instead. PHP Sanitizing function is used on the username input and then prepared SQL statement is used to prevent SQL injection.

---

Posted on Utopian.io - Rewarding Open Source Contributors

---