Steemit Account Creation History - A new SteemFriends feature requested by @teamsteem!

Repository

https://github.com/Bulletproofmonk/MySteemitFriends

Merged Pull Request

https://github.com/Bulletproofmonk/MySteemitFriends/pull/21

http://steemfriends.org is a popular tool with approximately 20,000 hits per month.

New Features

Have you ever wondered who were the earliest users of Steemit? How much Steem Power do they have? How many Steemit accounts were created before you and do they have more SP than you? With a new feature added to Steem Friends, all of these questions will be answered.

There are many ways to access this tool. You can head to http://SteemFriends.org, click on the Rankings button on the toolbar, and scroll down to Account Creation.

After that, you will see the names of users on Steemit ranked in order of when their Account was created. Next to their account creation date, you will also see whether the account was created by mining, and how much Steem Power they own. You can also access this page using the shortcut https://steemfriends.org/ranking.php?mode=accountCreation

You can also search for your name to find out your ranking in terms of Account Creation Date. Type your name in the textbox and click Show Ranking. You may need to wait a while depending on how busy the database is.

You can then click on the link which will bring you to the page where your name is situated. Your name will be highlighted on this page.

You can see that I was the 29497th account created on Steemit! what is your ranking?

You can also find out your ranking from the main page of SteemFriends, by typing your name into the textbox and click on the Rankings button follow by "Account Creation", to display your ranking on the main page.

Special mention to @teamsteem for suggesting that I add this feature to my website!

• How did you implement it/them?

As you can see from my Merged Pull Request, many files were created / updated to make this feature happen. Those files are listed below:

ranking.php:

Rather than having every single ranking page under a different file, the ranking.php controller is designed to become a one stop shop for all rankings. Depending on which ranking the user clicks on in the nav bar, the Mode input value will inform the controller which data to retrieve and pass onto the view, such as the SBD ranking, Own SP ranking or the Account Creation Ranking.

rankingmodel.php:

This model contains the SQL queries for retrieving the data from the database, for the account creation date, SBD and Own SP rankings.

rankingview.php

The view for displaying the table showing all the rankings. Depending on what type of ranking is chosen, there will be different colors, text and data displayed in the table.

get_creation_rank.php

This is the file for retrieving the rank for each individual user accounting to their Account Creation Date, to be displayed on the ranking page via an AJAX call.

GitHub Account

https://github.com/Bulletproofmonk