My Steemit Friends Update: SBD and Own SP rankings integrated into website.
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
A great new update!
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
thanks so much vladimir
Hey @magicmonk I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x
thank you so much :)
Thank you so much for this feature! You're making the Steemit platform better and better!
Thanks for information.
Will definitely give it a try, this invention here drives competition for each and every one of us to do our best in building the steemit platform, thanks man will definitely be following your work and more.
This is an excellent innovations from a positive mind. I just joined Steemit less than an hour but this post really gives me the courage to carry on.
Excellent tool, @magicmonk. I already started using it ..
Upvoted, Thank you.
Update baru yang hebat
Terima kasih atas kontribusi nya telah di setujui.anda bisa menghubungi kami di diskord utopian moderator