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.

account namepunk imagepunk number
@stayoutoftherz1936
@goranb3292
@lloyddavis2656
@aicoding4468
@erikah7189
@allcapsonezero702
@marcurio5972
@shitsignals2373
@martibis2334
@fredfettmeister1521
@maxxstorm7186
@freedomprepper4619
@solymi2596
@spinvest9623
@h3nny3328
@swelker1015427
@muenchen4890
@muratkbesiroglu3969
@black-jack-215043
@hetty-rowan3242
@brettpullen6371
@thethoughtpolice6811
@icom73114
@olegn4728
@onebakeryprod7858
@jasonrussell532
@papowich5855
@jk62768315
@jonamccallum5267
@wizardx6065
@queengaga7910
@kentzz0013216
@distorsionz8478
@reseller4157
@dragosroua3004
@robmojo4667
@laritheghost3755
@cooperclub2213
@blainjones517
@thisismylife2458
@buff-news4466
@sharkthelion3111
@cancermancer990
@splinternews3071
@blackzoda6222
@dinopack4006
@frewdist4644
@crossflow990
@howweroll4524
@clayboyn3082
@splashocean4796
@wehmoen428
@gungunkrishu3807
@ctrpch8675
@shawnsporter3351
@vlemon2484
@steify5020
@cloutinho693221
@cryptothesis5506
@ericwilson4589
@emrebeyler8171
@akmenos8269
@khan.dayyanz4811
@skylinebuds1776
@gertph6284
@shandalar7729
@weitoostrong3341
@atnazo8391
@rival4683
@brianhuang8306
@kwskicky8481

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
nfts proofofbrain punks crypto palnet neoxian
32
0
0.043 PAL
53 comments
(Edited)

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 ?

3
0
0.000 PAL
Reply
(Edited)

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

0
0
0.000 PAL
Reply
(Edited)

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.

0
0
0.000 PAL
Reply
(Edited)

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.

3
1
0.001 PAL
Reply
(Edited)

Maybe a solution will be to create an endpoint on your domain. Something like:

https://punks.usehive.com/avatar/asgarth/5423

That will resolve in the punk image only if the account asgarth own the punk 5423. 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.

2
0
0.000 PAL
Reply
(Edited)

Some nice looking punks out there 😀

7
0
0.000 PAL
Reply
(Edited)

Fact, just made some updates to the table, grew to 71 😀

3
0
0.000 PAL
Reply
(Edited)

yeah man like yours

0
0
0.000 PAL
Reply
(Edited)

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

5
0
0.000 PAL
Reply
(Edited)

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 😀

1
0
0.000 PAL
Reply
(Edited)

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.

1
0
0.000 PAL
Reply
(Edited)

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.

0
0
0.000 PAL
Reply
(Edited)

ah okay fair enough. was just wondering so no worries.

1
0
0.000 PAL
Reply
(Edited)

I have been trying out a few as profiles to see which one sticks. Love this project.

1
0
0.000 PAL
Reply
(Edited)

Cool. The current one looks awesome 😎

2
0
0.000 PAL
Reply
(Edited)

Thanks. Super exited for the potential of punks on hive

1
0
0.000 PAL
Reply
(Edited)

Nice, cool to see what punks other people have picked for their profiles as well. :P

1
0
0.000 PAL
Reply
(Edited)

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!

0
0
0.000 PAL
Reply
(Edited)

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. :)

1
0
0.000 PAL
Reply
(Edited)

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!

0
0
0.000 PAL
Reply
(Edited)

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

2
0
0.000 PAL
Reply
(Edited)

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.

0
0
0.000 PAL
Reply
(Edited)

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.

0
0
0.000 PAL
Reply
(Edited)

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.

0
0
0.000 PAL
Reply
(Edited)

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

1
0
0.000 PAL
Reply

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.

0
0
0.000
Reply
(Edited)

Thanks for mention here, is really hard to decide for me, which to chose for profile picture :D

1
0
0.000 PAL
Reply
(Edited)

LOL how many do you have?

0
0
0.000 PAL
Reply
(Edited)

I minted 30 yesterday.

0
0
0.000 PAL
Reply
(Edited)

WOW - maybe a GIF as profile pic? Not sure if it would work tho 😂

0
0
0.000 PAL
Reply
(Edited)

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!

0
0
0.000 PAL
Reply
(Edited)

That's also a good idea

0
0
0.000 PAL
Reply
(Edited)

Hmm, maybe this one!

0
0
0.000 PAL
Reply
(Edited)

Nice. These are so perfect for peakd profile pics.

1
0
0.000 PAL
Reply
(Edited)

True! It's pretty cool to get the notifications of people and all of them have a hive punk as profile 🥲

0
0
0.000 PAL
Reply
(Edited)

My Hive punks profile photo.

Punk on Hive is amazing.

!PIZZA

1
0
0.000 PAL
Reply
(Edited)

I couldn't agree more! Thanks for pizza 🍕

0
0
0.000 PAL
Reply
(Edited)

Thanks for the mention! !BEER for you. Great that some are starting to use as profile pics. I do like that viking helmet.

1
0
0.000 PAL
Reply
(Edited)

Haha you're welcome. I would also like to have another one with viking helmet and long hair 😎

0
0
0.000 PAL
Reply
(Edited)

Yes..I got a lot of bald ones but some cool hair too. Like this one.

1
0
0.000 PAL
Reply
(Edited)

Oh how cool! I like this one. I also saw someone got one crying, so rare.

1
0
0.000 PAL
Reply
(Edited)

Congratulations @aicoding! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s):

You made more than 100 comments.
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 STOP

To support your work, I also upvoted your post!

Check out the last post from @hivebuzz:

HiveFest⁶ Meetings Contest

0
0
0.000 PAL
Reply