New Features
- What feature(s) did you add?
The new SBD and Own SP rankings have been integrated into the My Steemit Friends website. You can find links to them from the navigation bar of the main page of the My Steemit Friends website here: http://mysteemitfriends.online.
After you click into each of the links under the drop down, you will see the following ranking tables:
Ranking table for SBD:
Ranking table for Own SP:
You can also type your name into the search boxes to see your ranking, as shown in screenshot above.
You can also navigate between the pages using the buttons or type the page number into the search box directly, on the bottom left or the ranking tables.
From the main My Steemit Friends page, you can also type in a user name there and see the rankings directly, without going into the ranking table.
If you click on the link to see your name in ranking table page, it will go to the right page your name is on and highlight your name in the table.
- How did you implement it/them?
sbd.php and ownSP.php
SQL is used to retrieve the ranking data, 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 and assist with converting from vests to SP.
get_osp_rank.php and get_sbd_rank.php
These php files are 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 retrieve the ranking of a particular user, and then PHP and HTML is used to create the link to the correct page on the ranking table. 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