My Steemit Friends Update: Conversation Record now has button to show message contents, Effective SP ranking now includes Own SP

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

New Features

• What feature(s) did you add?

Previously, on the Conversation Record page, only a link to the comments were provided but not the message body itself. In this update, a button was added to the next to each link, to show conversation contents quickly on the same page, without going to Steemit. To test out the button, please go to:

http://mysteemitfriends.online/conversation.php

Enter two user names, and then click on the blue "See conversation record button".

You can now click the "Show Comment" button under each comment, to see the text of the comment.

An extra column was also added to the Effective SP ranking page, so users can compare how much a person's Effective SP is compared to how much SP is actually owned by them. Ranking table accessible here: http://mysteemitfriends.online/effectiveSP.php

• How did you implement it/them?

conversation.php

The list of conversations was retrieved by SteemSQL, as discussed in the previous article. However, the contents of each conversation was stored as an NVarChar type in SteemSQL, which was not compatible with the PDO PHP7 extension that I am using, so I cannot retrieve the message contents from SteemSQL. I therefore decided to program a button to trigger a SteemJS function to obtain the message contents from SteemJS, and then display the message in the correct location in the table.

effectiveSP.php

I added another column for "Own SP" in the ranking table. This was done using SQL in PHP. I had to convert the vests data from SteemSQL to SP using the total_vesting_fund_steem and total_vesting_shares values obtained from the SteemJS API.

---

Posted on Utopian.io - Rewarding Open Source Contributors

---