How much has Botty tipped? $2323.25 so far
Many of you would have seen my tips ;] from last year, but i've had to stop tipping newbies and just provided an upvote here an there. It doesn't mean I won't restart the service again in the future. Thanks to the beauty of the blockchain I can show you how much I've tipped.
Thanks a lot to @arcange for his brilliant service http://www.steemsql.com which allows querying of the Steem blockchain using SQL Server.
Here is the query
DECLARE @name VARCHAR(50) = 'bottymcbotface'
select [FROM], sum(amount) 'Total SBD'
FROM [DBSteem].[dbo].[TxTransfers] tr
where [from] = @name and amount_symbol = 'SBD'
and ( [to] <> 'poloniex' and [to] <> 'bittrex' and [to] <> 'blocktrades' and [to] <> 'changelly')
group by [from]
select [FROM], sum(amount) 'Total STEEM'
FROM [DBSteem].[dbo].[TxTransfers] tr
where [from] = @name and amount_symbol = 'STEEM'
and ( [to] <> 'poloniex' and [to] <> 'bittrex' and [to] <> 'blocktrades' and [to] <> 'changelly')
group by [from]
This gives the following results
| FROM | Total SBD |
|---|---|
| bottymcbotface | 32.893 |
| FROM | Total STEEM |
|---|---|
| bottymcbotface | 348.325 |
Which using today's valuation from coinmarketcap.com is
32.893 *7.94 = $261.17
348.325 *5.92 = $2062.08
$261.17+ $2062.08 = $2323.25
I don't expect anything back by the way, they are a gift to the community. If you follow or upvote, that's a bonus for me :]
Here's something back from me :)
Thank You, you motivated me a little more in the beginning! :D
I remember when I was a newbie and upvoting me. You are a very helpful, giving soul. Thanks for the valuable info I am learning bit by bit.
My very 1st tip on here was from you, giving some back in upvotes :)
Still don't have much voting power and not quite sure about the random amount of steem power that was delegated to me.
When you first create an account Steemit.com allocate some steem power it will eventually get removed I believe. Only the delegated part in brackets, not your own steem power.
Ah yes, I can see it going down as I gain SP.
Now I understand why my SP decreased instantly by itself couple of weeks ago.
Thank you for the explanation.
Saya sangat menyukai posting anda, # @bottycmcbotface, kalo ada waktu, silahkan kunjungi blog saya, terimakasih
This post has been upvoted and Resteemed!
I am finally learning how steemit works, a year later!
I remember getting a tip at some point from you when I first started.
Hey Hii.. I am new to steemit.. Will you show some love for new comers like me..? Its support from you people which matters. Can i get a follow back ??
#Follow #Introduceyourself #smileforsmile #Steemit #Newtosteemit
..the first one who gave a tip 3 months ago
...thank you by the way @bottymcbotface
Nice one! Keep it up.
We are forever grateful you sexy bot! :)