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.

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

---