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! :)
'Remember me when you are rich :]' That's the first thing I encountered on steemit.
I will still remember you anyway even I've failed you regarding getting rich. (and your recent sexy pool dance face). Appreciate for the jumpstart :P
I hope you are rich with friends, family and knowledge too :]
A few days ago I went through my wallet history and I went back to see how it all started. You know...to have some sort of review to see where you stand now. It looks like you are part of Steemit history for sure :)
I can't remember if I thanked you for my first gift/memo so hereby I thank you and yes, I will remember you when I'm "rich" (I already am healthy so that's a plus).
Note: Your name @bottymcbotface will be impossible to forget. I see you ...everywhere! Very cool and generous gesture Botty.
Keep it up and Steem on!
hi @bottymcbotface.. you just voted up my first post.. I'm grateful. thank you! God bless you more!
Thanks alot mate for the information given much appreciated.
Thank you very much @bottymcbotface
I was one of newbies that you upvoted. A big salute for what you did to community ☺️
Thank you for supporting newbies! In the beginning it is always crucial to get support to believe in yourself and your blog!!And we all have been newbies one day :) and can be newbies, actually, every day since every day we learn something new!
Awesome stuff, I saw your vote on an individual that just started on here the other day. You made (@donwillis)that dude's day in sure. So what are you going to now @bottymcbotface?
thank you @bottymcbotface :)
Excellent
Thanks for that tip long time ago! Now you got 1000% interest back with my upvote. Keep steeming hard!
You are an inspiring good egg.
You have a very good soul! Im a newbie here! Thank you for the upvote! Seems you have helped many people, please do not stop and continue helping us. Godbless🙏🏻🙏🏻🙏🏻
I remember you tipped me and it was a privilege. Thank. That was nearly 7 months ago when I first entered the crypto space and joined Steemit.
I'm back now! For good!!!
damn! thats a lot :) thanks for all you do!
Hi @bottymcbotface , i am interest with your post.. that is an important information..
Oh ya..
Thank you very much.. you have upvote my post in my blog @rijalaronaceh
May be some time wee meet againt..
See you in the next post..
https://steemit.com/animals/@tjunaidi/squid-and-life
You have just tipped my introduction post a bit. Thank you! : )
thank you for informasion
Thanks botty!
Thanks for the upvote, you are doing a great deal for the starting peeps. Keep it up!
I'm new here . How do I joining this? any tutorial ?
keep it up bro