STEEMIT Holmes is your personal assistant and scout in the STEEM Blockchain, he helps you to get information out of the STEEM blockchain.
Information that is not immediately visible and difficult to obtain through the blockchain. He is like a STEEM Blockchain Explorer with Superpowers.
STEEMIT Holmes requires an S2DB instance
Restructuring of the user stats
More and more user statistics are added, so, that the whole thing becomes clearer,
we have split it a little bit to get a better overview.
Integrated of Bot usage
The new statistic shows how much the user have spent on vote bots
For this purpose we have started to distribute the user stats a little and divide them into categories. This helps to implement more stats and we are getting no more space problems.
The whole thing is now accessible via drop down menu.
The Changelog can you find here
Additionally, the user name is kept and navigating between all points is no longer a problem.
So that we could query the bots we created a general botlist.
https://github.com/pcsg/steemit-holmes/blob/master/src/libs/botList.php
We have considered over 100 voting bots in this list. If someone knows more bots, we would be happy if you create an issue for us: https://github.com/pcsg/steemit-holmes/issues
For the preview image I used a user from the trending (because i don't really use voting bots)
If you want to do something like this by yourself, the main logic is in MySQL Query.
This query also works with an SBDS instance.
First, we get all of a user's transactions
SELECT *
FROM s2db.sbds_tx_transfers
WHERE
`timestamp` >= :from AND
`timestamp` < :to AND
(`from` = :username OR `to` = :username);
After that we filter all transactions which are coming from the bots. Thats it ;-)
You can find the complete logic under: https://github.com/pcsg/steemit-holmes/blob/master/src/user/usedBotsThisMonth.php
The nice thing about the S2DB is, that there are many small widgets and so even beginners can see how its possible to get information out of STEEM.
See you next time and thanks for reading
Hen, for PCSG Developers
