- <a href="http://mysteemitfriends.online">My Steemit Friends Tool website.</a><br> 
- <a href="http://github.com/Bulletproofmonk/MySteemitFriends">Github repository.</a> 
- <a href="https://github.com/Bulletproofmonk/MySteemitFriends/pull/16">Merged Pull Request. </a>

### New Features

The Voting Power of Witness Proxies ranking feature has been integrated into the My Steemit Friends website. 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.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518612820/qs80esdvhuq71kr20mqf.png)

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

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518612946/r963ierx0jnmrlex8ek6.png)

You can type your name (if someone has chosen you as a proxy) 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.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518613002/by3ushzit6hjqd3b0usz.png)

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.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518613136/kbkwusjw8tm2d88nkpfs.png)

Click on the blue link at the bottom to see your name in ranking table page highlighted.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518613254/hkzoy3qxm06q1xv3ev9q.png)

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518613237/cd0qimnurx3medwtbf67.png)

## How did you implement it/them?

- [**witnessproxies.php**](https://github.com/Bulletproofmonk/MySteemitFriends/blob/master/witnessproxies.php):  A list of Witness Proxies ranked by the total number of vests (own vests + others who have proxied to this person). SQL statements involving many 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_proxy_rank.php**](https://github.com/Bulletproofmonk/MySteemitFriends/blob/master/get_proxy_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 user is not a witness proxy for any other user. PHP Sanitizing function is used on the username input and then prepared SQL statement is used to prevent SQL injection. 


<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@magicmonk/my-steemit-friends-update-voting-power-of-witness-proxies-ranking-feature-integrated-into-website">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>