statBot v2.1.0: Added delegation, delegator checking and delegatee checking
statBot is a utility discord bot being used in #teammalaysia, AUS/NZ and Steemph.cebu. This bot has features like cryptocurrency price check, cryptocurrency conversion rate (between crypto to crypto and crypto to fiat), and some query check into SteemSQL to get performance of a tag and delegator.
![](https://steemitimages.com/640x0/https://cdn.utopian.io/posts/127cfc98dde95eba023bdbc2c8a587ff899efavicon.png)
I have changed the repository name from superoo7/steem-discord to superoo7/statBot
Thanks #SteemBC and @justyy for helping me out in the SQL query.
Github Commits
New Features
What feature(s) did you add?
- Check Delegator and Delegatee of a Steem Account
- Generate link for Delegation
How did you implement it/them?
For checking delegator, I added an SQL query to SteemSQL
SELECT
delegator, vesting_shares, timestamp
FROM
TxDelegateVestingShares
WHERE
delegatee = '${username}'
ORDER BY
timestamp desc
For checking delegatee, I also added an SQL Query to SteemSQL
SELECT
delegatee, vesting_shares, timestamp
FROM
TxDelegateVestingShares
WHERE
delegator = '${username}'
ORDER BY
timestamp desc
And using JavaScript, I parse out all the data into the latest SP delegation list
About this Projects
- What is the project about?
This is a discord bot that are able to consume Steem API, check crypto price, convert crypto and fiat price, use of SteemSQL to carry out Query about Steem Blockchain.
- Technology Stack
Node.js, TypeScript, MSSQL (SteemSQL)
Roadmap
- Coversion of fiat to fiat
- Added Testing (Jest)
- Detail documentation on all the available commands
How to contribute?
- Join the Discord Channel to test the bot
- To contribute, first you need to have SteemSQL subscription. (check @steemsql or arcange)
- Edit the .env file, and paste ur SteemSQL subscription details into it
- Pull Request and Issue filling are welcomed on GitHub
Posted on Utopian.io - Rewarding Open Source Contributors
Hi, I'm an Upvote bot. I will upvote your post if you reply to this comment with "Upvote". 👍 a-0-0
You've been upvoted by TeamMalaysia community. Here are trending posts by other TeamMalaysia authors at http://steemit.com/trending/teammalaysia
To support the growth of TeamMalaysia Follow our upvotes by using steemauto.com and follow trail of @myach
Vote TeamMalaysia witness bitrocker2020 using this link vote for witness
你好!cn区点赞机器人 @cnbuddy 谢谢你对cn区的贡献。倘若你不喜欢我的留言,请回复“取消”。
Thanks for the contribution. It has been approved.
Need help? Write a ticket on https://support.utopian.io.
Chat with us on Discord.
[utopian-moderator]
Congratulations! This post has been upvoted from the communal account, @minnowsupport, by superoo7 from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews, and netuoso. The goal is to help Steemit grow by supporting Minnows. Please find us at the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.
If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP.
Be sure to leave at least 50SP undelegated on your account.
Hey @superoo7! Thank you for the great work you've done!
We're already looking forward to your next contribution!
Fully Decentralized Rewards
We hope you will take the time to share your expertise and knowledge by rating contributions made by others on Utopian.io to help us reward the best contributions together.
Utopian Witness!
Vote for Utopian Witness! We are made of developers, system administrators, entrepreneurs, artists, content creators, thinkers. We embrace every nationality, mindset and belief.
Want to chat? Join us on Discord https://discord.me/utopian-io