New Effective SP ranking feature has been integrated in My Steemit Friends

Tool website: http://mysteemitfriends.online
Github: https://github.com/Bulletproofmonk/MySteemitFriends
Merged Pull Request: https://github.com/Bulletproofmonk/MySteemitFriends/pull/3

New Features

• What feature(s) did you add?

My Steemit Friends has been upgraded with a new feature, called "Effective SP rank", as you can see the red button on the main page.

After entering your Steemit User Name and Clicking the red button, you will see your Effective SP ranking, as shown below:

You can also click the link to see the Effective SP ranking against other users. Screenshot below.

You may also access the Effective SP ranking directly from the navigation bar at the top of the page to start with the top 50 rankings. On this page you may also search for a particular user to find out their ranking, or you can navigate to a particular page.

The original features are all still accessible by clicking the blue button on the main page to get the upvote statistics.

• How did you implement it/them?
  The data for how many vests a user has can be obtained from SteemSQL. SQL queries were written with PHP. The values required to calculate effective SP from vests were obtained using the SteemJS API and regularly updated using a cron job.

In particular, these specfic changes in coding were made to the following files:

index.php:

• Created Nav Bar to navigate between 3 tools - Upvote stats, Followers ranking, Effective SP ranking.
• Added Effective SP Rank button (in red) to find effective SP rank of specified user.
• Added code for the funionailty of Effective SP rank button.
  Verified

style.css:
Updated CSS styles to include new nav bar background color, hovering color and text color.
Verified

effectiveSP.php
Code for retrieving a list of users ranked by their amount of effective SP. Code for organisation of list into pages and browsing the list. Code for highlighting particular users on the list.

get_esp_rank.php
Code for finding the ranking of a particular user in terms of effective SP and which page on the list they are on, and a link to effectiveSP.php to locate the user on the list.

global.txt
Text file containing the total_vesting_fund_steem and total_vesting_shares values needed to calculate a user's steem power from vesting shares. Updated periodically using updateglobal.php.

updateglobal.php
Retrieve total_vesting_fund_steem and total_vesting_shares using the SteemJS API, and then update values in global.txt for calculation of SP.

---

Posted on Utopian.io - Rewarding Open Source Contributors

---