How much has Botty tipped? $2323.25 so far

in #tips7 years ago

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

FROMTotal SBD
bottymcbotface32.893
FROMTotal STEEM
bottymcbotface348.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 :]

Image Source By @nxah

Sort:  

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 ??IMG_20180124_210449_529.jpg #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..

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