Profile Punks!
(Edited)
Now that we are all sharing our Hive punks, I thought it would be interesting/fun to see what are those punks that have made it to profile pictures! So far there are only 71 in the list - looking forward to see it growing.
How to?
As always, sharing is caring. If you are into exploring @hivesql data, here is a query that will allow you to easily retrieve this table:
SELECT *,
CASE WHEN LEN(punksTable.[Punk image]) > 51 THEN SUBSTRING(punksTable.[Punk image], 45, 4)
ELSE SUBSTRING(punksTable.[Punk image], 45, 3) END as 'Punk number'
FROM( SELECT
'@' + [name] AS 'Account'
,JSON_VALUE(JSON_QUERY([posting_json_metadata], '$.profile'), '$.profile_image') AS 'Punk image'
FROM [DBHive].[dbo].[Accounts]
where posting_json_metadata like '%hivepunks%') punksTable
0
0
0.000
Some nice looking punks out there 😀
Fact, just made some updates to the table, grew to 71 😀
Very nice :o).
yeah man like yours
Very cool punks on hive.
Indeed 😀
Nice, cool to see what punks other people have picked for their profiles as well. :P
True, it's pretty cool to see. Maybe I can figure out a way to see how many punks each of the users minted and then see their ultimate profile picture choice!
It would be amazing to get some statistics on how many and what punks different users have collected in one place, rather than having to look through each individual gallery. I hope Marky will come up with something, but great to see it pop up other stuff regarding these guys in the community as well!
Didn't know about @hivesql btw, that's very neat, will need to have a look into that myself at some point. :)
Yes, you can get pretty cool stas from that DB. I need to look into @hivesql maybe there is some data already reagrding the amount of punks per user - but it will probaby need some advance query implementation!
Maybe you can write a query that checks if the profile pic punk actually is owned by the user? Some are just screenshots (or jpg downloads, as they got the filename) of punk they don't own. Just good promo for that punk, I guess, but would be nice to see a list of punks both owned and used. :P
In this case, the URL of the picture indicates that the user is using an original punk - if it would be a screenshot they wouldn't officially appear in this list. The thing I am trying to find now is which ones are actually owned without being used as profile pic.
990 appears two times in the list while also being listed on the market by a different user (the one that sold for 5555 hive). You get the original jpg filename if you download the punk jpg, before uploading it as a profile pic, making the path look correct, I assume.
I am guessing as the original punk url is https://f002.backblazeb2.com/file/hivepunks/4468.png if you were to download the picture and upload it, your url would look like this
https://images.hive.blog/DQmXBzmydCMNwSV8e6fTVjbmRSuHDMUjn7abgrtAp6ci5Kb/4468.png as the filename is just the punk number. I might be wrong as well.
I was also wondering about the 990 - which now is changed by the seller.
I know for a fact that neither of the two users listed above with 990 are owners of the punk, as they both are members of my Splinterlands guild. Discovered now that you still got the "set as Hive avatar" link/button available on all punks even if you don't own them, which makes the path look legit, I guess (but not on the block chain ofc). :P
Oh right gotcha now! Can't know about that as I don't own many to sell :D but thanks for the spot - I guess with a more complex query on the transactions could be a way to corroborate the ownership if the possibility of removing the "set as hive as an avatar button" even if you don't own it, is not an option.
Cool idea. I didn't realize it was possible to see which punk someone used for their profile picture. I'm glad I did it the official way! At first, I took a screenshot of the same one I have now and used that.
I have some that are more rare and more interesting looking, but I went with the punk that most realistically resembles me. 😂
!PIZZA
Actually, now that you mention this I hope people are reading this post so they shift to the official way, in case they also went through the screenshot route.
Thanks for the pizza 😀
yeah, I think it's much better to go the official route. but is there a way to prevent screenshots from being used? cuz that would be amazing.
I was thinking through the official URL way but in another conversation here I was informed that even if you sell your punk you can set it as profile picture in the official way - so at this point I am not even sure how to prevent that.
ah okay fair enough. was just wondering so no worries.
PIZZA Holders sent $PIZZA tips in this post's comments:
sharkthelion tipped aicoding (x1)
@steem82868(20/20) tipped @aicoding (x1)
Learn more at https://hive.pizza.
Thanks for mention here, is really hard to decide for me, which to chose for profile picture :D
LOL how many do you have?
I minted 30 yesterday.
Same here, haha!
WOW - maybe a GIF as profile pic? Not sure if it would work tho 😂
Nah, I'm currently looking at galleries of others to find the one that I feel resembles me most, haha! Than will trade for that one!
That's also a good idea
Hmm, maybe this one!
Congratulations @aicoding! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s):
Your next target is to reach 200 comments.
You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPTo support your work, I also upvoted your post!
Check out the last post from @hivebuzz:
Nice. These are so perfect for peakd profile pics.
True! It's pretty cool to get the notifications of people and all of them have a hive punk as profile 🥲
My Hive punks profile photo.
Punk on Hive is amazing.
!PIZZA
I couldn't agree more! Thanks for pizza 🍕
Thanks for the mention! !BEER for you. Great that some are starting to use as profile pics. I do like that viking helmet.
Haha you're welcome. I would also like to have another one with viking helmet and long hair 😎
Yes..I got a lot of bald ones but some cool hair too. Like this one.
Oh how cool! I like this one. I also saw someone got one crying, so rare.
Didn't even realize that crying was an attribute. That is cool.
Check out @icom7
View or trade
BEER.Hey @aicoding, here is a little bit of
BEERfrom @thethoughtpolice for you. Enjoy it!Did you know that you can use BEER at dCity game to **buy dCity NFT cards** to rule the world.
Big punks family haha!
Yeah
I have been trying out a few as profiles to see which one sticks. Love this project.
Cool. The current one looks awesome 😎
Thanks. Super exited for the potential of punks on hive
I would love to see @peakd add some sort of verified badge for people who are using a verified punk (ie a profile pic they own). This would be super cool and drive adoption and stop fraud. Any thoughts on this @jarvie, I know your a punk fan ?
It would be nice of course and @asgarth helped Marky with the project as well ... not sure it's high level importance but if it doesn't take a lot of time I'm all for it.
What would you suggest. A border around the circle for the profile? A small symbol? If so what?
Cc @themarkymark
It would have to be something that goes outside the boundaries of the normal image area so you could not am just screen grab it and upload as a profile pic manually.
I do have planned adding a badge, but it will hard to verify they are using an image they are using without some machine learning to detect the image.
Maybe a solution will be to create an endpoint on your domain. Something like:
https://punks.usehive.com/avatar/asgarth/5423That will resolve in the punk image only if the account
asgarthown the punk5423. Otherwise in a 404 error.Will be slower the first time, But after that the CDN and the cache should handle it pretty well. And every 6/12 hours the CDN will expire and will need to be validated again.