SteemIt Bot Update: Showing Your Payout in Last 7 Days

Motivation

How many of you sometimes want to know how much you have been paid by writing good contents? Especially for those regular writers or even full time steemians, they want to know how much payout per week.

I am adding these to the steemit discord bot and the wechat channel.

The SteemIt Discord Bot

Adding steemit bot to your discord server:

https://discordapp.com/oauth2/authorize?client_id=418196534660694037&permissions=522304&scope=bot

Your Payout in Last 7 Days Explained

These information are now included in the profile lookup query such as ?steemit_account

discord-steemit-bot

SBD – The Steem Dollars
SP – The Steem Power via Curation or 100% Power up (These are locked up via 13 week if you power down)
STEEM – These tradeable tokens can be transferred anywhere but they are not usually given per post payout.

How to Get SteemIt Last 7 Days Payout?

via SBDS (MySQL): `

1
2
3
4
5
6
7
8
9
10
11

select 
  account, 
  sum(reward_steem) as "STEEM", 
  sum(reward_sbd) as "SBD", 
  sum(reward_vests) as "SP" 
from 
  sbds_tx_claim_reward_balances
where
  account in ('justyy')  and 
  datediff(UTC_Date(), timestamp) between 0 and 7 
group by account

select 
  account, 
  sum(reward_steem) as "STEEM", 
  sum(reward_sbd) as "SBD", 
  sum(reward_vests) as "SP" 
from 
  sbds_tx_claim_reward_balances
where
  account in ('justyy')  and 
  datediff(UTC_Date(), timestamp) between 0 and 7 
group by account

or SteemSQL (MSSQL):

1
2
3
4
5
6
7
8
9
10
11
12

select 
  account, 
  sum(reward_steem) as "STEEM", 
  sum(reward_sbd) as "SBD", 
  sum(reward_vests) as "SP" 
from 
  TxClaimRewardBalances( NOLOCK)
where
  account in ('justyy') and 
  datediff(hour, timestamp, getutcdate()) between 0 and 24*7 
group by 
  account

select 
  account, 
  sum(reward_steem) as "STEEM", 
  sum(reward_sbd) as "SBD", 
  sum(reward_vests) as "SP" 
from 
  TxClaimRewardBalances( NOLOCK)
where
  account in ('justyy') and 
  datediff(hour, timestamp, getutcdate()) between 0 and 24*7 
group by 
  account

Wechat Channel justyyuk

Update is also pushed to wechat channel so you can query the bot for last 7 days payout on wechat channel.

wechat-steemit-bot

Support me and my work as a witness by

• voting me here, or
• voting me as a proxy

Some of my contributions: SteemIt Tools, Bots, APIs and Tutorial

You may also like: SteemIt Discord 机器人更新：查询过去7天的收益

–EOF (The Ultimate Computing & Technology Blog) —