raghavsood
Copper Member
Sr. Member
Offline
Activity: 378
Merit: 477
Track Burns @ burned.money
|
|
July 11, 2024, 07:32:50 PM Last edit: July 12, 2024, 05:43:09 AM by raghavsood |
|
Like some of the other folks, I'm not here with a bone to pick - I own none of these items (although I really do like the design and will likely buy some), but I've found some more discrepencies. I am very much hoping these are simply data errors/oversights/a bad spell in funding responsibilities. I encourage you to read this entire post before drawing a conclusion, and if you are in a position to clear up some of the discrepancies (such as by owning an item involved), reply to this post or reaching out to me directly if you do not wish to identify yourself - I will update this post and keep your identity anonymous. Loading StatusI have loaded all of the series mentioned in the MASTER MAKER/ADDRESS/LISTS OF LISTS!!! for MrCryptHodl into Collectible Money. If you own any items from his series (BTC only for now), you can use the site to look them up and track them. If the data you see on the site does not match the physical item in your hand, please reach out to me (read the rest of this post for an explanation as to why) As of writing, this tallies up to 2.75 BTC, or around 160k USD in TVL for items in his series. We can tally up the funding status of each series, as well as the first and most recent funding activity, using God ModeSELECT series_name, COUNT(CASE WHEN first_active IS NULL THEN 1 END) AS unfunded_count, COUNT(CASE WHEN first_active IS NOT NULL AND redeemed_on IS NULL THEN 1 END) AS funded_count, COUNT(CASE WHEN redeemed_on IS NOT NULL THEN 1 END) AS redeemed_count, MAX(first_active) AS most_recent_funding_date, MIN(first_active) AS first_funding_date FROM god_view WHERE creators LIKE '%mrcrypthodl%' GROUP BY series_name;
This gives us: Most series have one or more unfunded items. To be clear, I'm not saying all of these are sold, unfunded-but-should-be-funded. As stated by MrCryptHodl previously, not all collections sold out, and items sold via the website or other channels may have been sold as unfunded and are correctly in that state. However, while importing this data, I noticed several data discrepancies. Data Discrepencies We are fortunate that MJ and cygan has religiously duplicated the address lists from MrCryptHodl's announcement and sales threads into the Master list - this gives us a snapshot of those at some past point in time. Against those, I have discovered that there have been several changes and unexplained additions/removals to the address lists. Links are to the master list, which contains links to the MrCryptHodl's posts for that series: 1HoDLCLUB Golden Brass BTC Poker chips - BGC107 1xBTCQoi3h3zADDNPTgJgNF7EtWsQhat6 marked as destroyed 1HoDLCLUB Orange Clay BTC Poker chips Solo chips - MJ's list is much longer - 1xBTCfYRcsw1UwKQjZ1RkfZFZm7Fjvggm, 1xBTCGot3tLTrGvYA6ev7jatLCAW6nnMk, and 1xBTCJPbaxheGnhawx7cg62NArvNS5yJY do not appear on MJ's list. This means at some point a longer list was posted, and then some addresses were changed (so the current list in MrCryptHodl's post is not simply a subset of the first). 1HoDLCLUB Fine Gold 999.9 Bitcoin chips - 1, 2, 3 marked as stolen, address for 10 changed to 1xBTCZuGUu6JGNP1Mb3TsBeXcPmvFnbNN from 1xBTCVABBYzBrGXCJ22JCNG3xeX18qsnd1HoDLCLUB 1oz GENESIS Coin - 18 addresses changed - 3, 6, 7, 14, 17, 21, 34, 39, 42, 43, 51, 56, 60, 68, 73, 81, 88, 1761 YEAR EDITION MOON PASS Fine Silver 999.9 - MJ has 42 1MoonxderhUFResRw7cDCSd5qPTud5Jmed that does not appear in the OP1HoDLCLUB 5oz GENESIS Fine Silver 999.9 Ingots - MJ has 1-9 that do not appear in the OPThe other collections not explicitly mention above have a 100% match between the snapshot in the master maker list and the announcement posts by MrCryptHodl. Additionally, if my assumption holds that MJ and cygan simply copied the original lists from the OPs when they made those posts on the master maker list, it looks like some addresses were duplicated across collections in the initial announcements. I'm hopeful that this was just a data/transcription error, and that there are no duplicate addresses in real world items (especially since many of the announcement posts have been edited with updated address lists). I imported primarily from the master maker list, but some collections were cross checked or copied from the announcement posts. Once again, using God Mode: SELECT addresses, json_group_array(json_object('series_name', series_name, 'serial', serial)) AS series_serials FROM god_view WHERE creators like '%mrcrypthodl%' AND addresses <> '[null]' GROUP BY addresses HAVING COUNT(DISTINCT item_id) > 1;
We get: addresses series_serials ["1ozGencDviL4Se3nRrKFzieWQWcqHs3Xr"] [{"series_name":"1HoDLCLUB 1oz GENESIS Coin","serial":"175"},{"series_name":"1HoDLCLUB 1oz GENESIS Coin","serial":"21"}] ["1xBTC1GJSVXQHZEj91DycYkZEz1XiUCHP"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"86"}] ["1xBTC2C7K92ubPqFZaxHzqxU8XwdQCoxu"] [{"series_name":"1HoDLCLUB Copper BTC Poker Chips","serial":"boc208"},{"series_name":"1HoDLCLUB Golden Brass BTC chips Rolls","serial":"BGC-213"}] ["1xBTC3gn5zRWJ3VSmSNDiPWmii4ZySqod"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"91"}] ["1xBTC3n3mTQgSMLNwX7fBBhixhcN3ZR7s"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"40"}] ["1xBTC45a7U3CpKJjXbm61Xi6qFySksSXd"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"71"}] ["1xBTC5yYXy8n5xQJvDeSHyUxZq1N24RDG"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"79"}] ["1xBTC6srTxaKvnmuhetPQaBeNzYoNQkvQ"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"75"}] ["1xBTC8rfw7Naedhp1kqXX8qSUspfLo7ui"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"45"}] ["1xBTC9BNAYmUC3U3qj1EFJxXV6qzNMneV"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"80"}] ["1xBTC9Wa3X96pdRtuDdTUT2fBFx6h19zz"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"67"}] ["1xBTCAJKnDZoKxb8BNkNkh45eeDwyMKbF"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"76"}] ["1xBTCAnku9Xqx12TqskC6Vw3o8bwZXVtA"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"70"}] ["1xBTCBXba4DKRKpQNjjW9sqq47ZcLAxNz"] [{"series_name":"1HoDLCLUB Copper BTC Poker Chips","serial":"boc210"},{"series_name":"1HoDLCLUB Golden Brass BTC chips Rolls","serial":"BGC-215"}] ["1xBTCDFzczzMd4E5FxaRoZvX9jLVvCsdM"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"44"}] ["1xBTCDaHUAvU7waDg2TCEKmGsTMuVD2p8"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"82"}] ["1xBTCDu8oEPxGYNrPPjm6XWcAVJKuvAT8"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"89"}] ["1xBTCE5ASLArR9bD5zsJM95NJnKjUWJn2"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"72"}] ["1xBTCGqCotvbBEfrjUHkDw7T1CJq3iZxo"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"97"}] ["1xBTCHcD4r8r1ei9iixASpMckE8TH5m4U"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"56"}] ["1xBTCKAfVZUALoAFYiCcaTj3n5w1FZ55U"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"84"}] ["1xBTCKnWJmWEVGDbJFfwWT3BdsyEKrsFW"] [{"series_name":"1HoDLCLUB Copper BTC Poker Chips","serial":"boc206"},{"series_name":"1HoDLCLUB Golden Brass BTC chips Rolls","serial":"BGC-211"}] ["1xBTCLJR6Jnnb2qGtkTnGPTCXsegiT6yW"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"94"}] ["1xBTCLpNvgBctzhKJnkxkEGaMkUxdnR3V"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"59"}] ["1xBTCMMKo1yo7G3xY1dLasjs3Vu4vnwxN"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"63"}] ["1xBTCNdkCrcNBmnSRyVv22CLhMGV3UpQg"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"54"}] ["1xBTCPDnrqKdHhUwPVcf7WYnLmgu3ZeN3"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"50"}] ["1xBTCQQftCUm7r4irvnbVrwGiYx2Hrt5x"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"85"}] ["1xBTCSQd3158TMy68PjqNBkWLGecZwugw"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"88"}] ["1xBTCSpeP8Ni6mF8oeVLLDWw7vHfoTQwf"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"74"}] ["1xBTCTWzATCDMWtHEXNdpdjupDBvDLjTV"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"77"}] ["1xBTCTeySL4yPWJaWTNsjR4YwgAjH2Moq"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"46"}] ["1xBTCU71sinDSuH7WDTTG6TcaiSvzLBU4"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"81"}] ["1xBTCUA44DErLCMujNDTy2Dy4GHnADaoB"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"87"}] ["1xBTCUAMPnaFLt5Pn26kdEiAeaieyfKn5"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"83"}] ["1xBTCUZuTgitYCAfmX4HQTpGdfETWX6uP"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"98"}] ["1xBTCVyLG7jsDUnEWX11H5nE6Sy4SWTiW"] [{"series_name":"1HoDLCLUB Copper BTC Poker Chips","serial":"boc207"},{"series_name":"1HoDLCLUB Golden Brass BTC chips Rolls","serial":"BGC-212"}] ["1xBTCXZ5jhYXAM7qhPBqgyhQY741T3Gso"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"96"}] ["1xBTCYcUaR8pniFwHs27d8X83GXDSKgFF"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"55"}] ["1xBTCZJ2np1YpfvapWiKUwFZE7iKioeB3"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"66"}] ["1xBTCaHrbVdEJZca5KSNJZZV6nufEEfkX"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"60"}] ["1xBTCauuJdRFafJXueBBNHiP2wyjdcAQC"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"92"}] ["1xBTCbLN3rwDXKEbuXJipEs6abWPyE74f"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"62"}] ["1xBTCbPK1BwMWc1G4pKKFPRC92SimbQGy"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"43"}] ["1xBTCeNdxeXdpBec6ET2oC3gAR63rhyXb"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"52"}] ["1xBTCeRyQMPWgGjTNb8G9EdD762Lc9M1c"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"57"}] ["1xBTCgmpvJzKj8NvyMKvaJN6qMj38TSpi"] [{"series_name":"1HoDLCLUB Copper BTC Poker Chips","serial":"boc209"},{"series_name":"1HoDLCLUB Golden Brass BTC chips Rolls","serial":"BGC-214"}] ["1xBTCiJepZhY9ktdRaTqpbu6wcgUbLvD8"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"93"}] ["1xBTCiKFGNrS21Kzze719ryQtiLcNwzsy"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"48"}] ["1xBTCjydiLnwS5A27QDfEa49H7yGdU9xE"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"53"}] ["1xBTCmf94F8YX1qUUkgXbdxmZ4LpuvvF3"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"58"}] ["1xBTCnMksratYaNTkXJ7jwyRqpj2R3tA7"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"47"}] ["1xBTCnT9AHokkFRfTWbpVzQpJ2WcbNmEx"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"95"}] ["1xBTCnf9bHHYNBaua8C6R7HcwxZbjzrSr"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"99"}] ["1xBTCnnnFMVqoKDz1qZ82UiAkUMse3gKF"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"65"}] ["1xBTCoaEpkQozFY1PSmi1FzbVMvbBH62c"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"100"}] ["1xBTCpCct2GRKGmFv24bpgDwTk9sKGZeb"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"69"}] ["1xBTCpzjmrPjbP6tUjEyDK39h1nsSScQm"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"42"}] ["1xBTCqpT8kJFQkC4mxG6C1uSqrnoSQg6T"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"73"}] ["1xBTCrkbfu3KXntLg6ESmWoEpNq6BTZZ5"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"49"}] ["1xBTCuaZBUSzUg8Hf9hpSsorEhUU8rsa8"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"41"}] ["1xBTCvzjWo5eJ1CKt67Y6su4vuCVZbaqn"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"64"}] ["1xBTCxWKy8wNzbDWxPenAUU2Jv8ivnM3x"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"61"}] ["1xBTCxnZpjYe1DTMZ2QrJemTMQTrsswTQ"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"68"}] ["1xBTCyQFK6xMBw246Eu3wK4bUV4XNLvzw"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"78"}] ["1xBTCzA6yTsBdoxWUKHaQPGTYdHuyAB44"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"51"}] ["1xBTCzSvkB4iGM6eXRKd2pUwrUWtEh1Vc"] [{"series_name":"1HoDLCLUB Orange Clay BTC Poker chips","serial":""},{"series_name":"1HoDLCLUB Silver BTC Poker Chips","serial":"90"}]
Some of these seem to have been simple data entry errors - for example 1xBTCAJKnDZoKxb8BNkNkh45eeDwyMKbF was funded with 0.0025 BTC, which would imply it actually belongs to the Silver Poker chips rather than the Orange Clay ones which were to be funded with 0.0005 BTC. However, the Orange Clay chips list was truncated, and no longer contains a serial 244 to cross check against MJ's original post. HELP IDENTIFYIf you own any of the items referenced in the above table, please post a reply here with the serial (if it is a serialized item), and the address - including a photo is helpful. If you do not wish to be public about your ownership, you can send it to me directly and I will convey it here. DisclaimersI am not saying that MyCryptHodl is a scam, but clearly there is room for improvement here - so far, there is no indication of any items being swept or the keys being compromised. The designs are solid, and I'm generally a fan of his work. However, it is important to ensure that if we're paying for funded items, they are funded, and that the keys match the addresses. I'm hopeful that this will blow over in a few days and things will be cleared up, and that we can get revised, accurate address and funding updates.
|