Skip to content

Instantly share code, notes, and snippets.

View bogdan's full-sized avatar
💭
Developing everything, fixing everything, delivering everything

Bogdan Gusiev bogdan

💭
Developing everything, fixing everything, delivering everything
View GitHub Profile
import {pack} from '@ethersproject/solidity';
import ethers from 'ethers';
import {keccak256} from '@ethersproject/keccak256';
import {verifyMessage} from '@ethersproject/wallet';
import { BigNumber } from 'ethers';
class SignedRecordUtils {
messageToSign(
tokenId: string,
ownerAddress: string,
Timing is on.
email | name | owner_address | node
---------------------------------+----------------------------------------------------------------------------------------------+--------------------------------------------+--------------------------------------------------------------------
alannaroth79entero37@gmail.com | -carolawintheiseriv2.zil | 0xf45c019eec7fbff3570fc229aa59fa96bf9022fe | 0x27e6ab05c7c3c26e9c102d5618be16c93a1a4b49b7b973000e336ce7a23f7ba8
julian.brabec@gmail.com | -adam-back.zil | 0x550d904d1dabf418a8cff430ff5d16da8b66b188 | 0x447c7c4ad8c9333bb09ee43ab343b7662f398bd753c190284c79a1d6d9f69c47
kyle-unstoppable@protonmail.com | -0x04
Timing is on.
id | created_at | updated_at | user_id | ownership_pending | owner_address | name | parent_id | node | resolver | resolution | registry_type | recent_event_id | reverse | logical_owner_address | tld_id
-----------+----------------------------+----------------------------+---------+-------------------+--------------------------------------------+-------------------------------
Timing is on.
type | status | count | min_created | max_created | ?column?
----------------------------------+------------+--------+----------------------------+----------------------------+----------
FundZilAccountAction | Completed | 12 | 2022-10-06 03:55:00.33466 | 2023-01-20 13:26:20.503714 | 1
FundMaticAccountAction | Completed | 6792 | 2022-10-03 08:55:00.064043 | 2023-02-14 13:15:00.099999 | 1
FundMaticAccountAction | InProgress | 1 | 2023-02-14 13:25:00.215663 | 2023-02-14 13:25:00.215663 | 1
FundMaticAccountAction | Failed | 1 | 2023-02-13 12:25:00.229621 | 2023-02-13 12:25:00.229621 | 1
FundEthAccountAction | Completed | 14 | 2022-10-18 17:05:00.115423 | 2023-01-20 13:43:38.589518 | 1
DotCoinReturnAction | Completed | 477 | 2022-12-15 01:37:56.553044 | 2023-02-14 13:28:37.693757 | 1
DotCoin
Timing is on.
otp_secret | email | crypto_logins | count
------------+-------+---------------+---------
f | f | f | 6697663
f | t | f | 782893
f | f | t | 137459
t | t | f | 41713
f | t | t | 40745
t | t | t | 8726
t | f | t | 833
Timing is on.
otp_secret | email | count
------------+-------+---------
f | f | 6835086
f | t | 823636
t | t | 50439
t | f | 1337
(4 rows)
Time: 1414.042 ms (00:01.414)
Timing is on.
type | fail_reason | count | last_at
---------+----------------------------------------------------------------------------------------------+-------+----------------------------
MaticTx | Unknown Ethereum network rejection reason | 9 | 2023-01-18 10:39:20.063131
MaticTx | Eth call reverted: cannot estimate gas; transaction may fail or may require manual gas limit | 987 | 2023-01-14 09:21:07.43858
MaticTx | Eth call reverted: processing response error | 10 | 2023-01-02 09:58:46.338178
MaticTx | Parent transaction was rejected | 52 | 2022-12-30 15:27:02.687473
MaticTx | Manually Rejected | 10 | 2022-12-16 12:17:24.117274
(5 rows)
Timing is on.
id | blockchain | transaction_hash | level | name | created_at | ?column?
----------+------------+--------------------------------------------------------------------+-------+-------------------------------------+----------------------------+----------
21570897 | ETH | 0x0af2490a093b46d0e5567226d722259a506e3b6bf194559934fff9125ef91daa | 2 | nftslamz.nft | 2023-01-04 04:24:01.147644 | 1
21570890 | ETH | 0xfca9074465c001eb50f46a150ba5b9a0120a78638dc526a94129b05737a98539 | 2 | nftslamz.nft | 2023-01-04 04:23:00.684611 | 1
21520285 | ETH | 0x8d7dfd70a2f7b7090a54b44287769795dd98407d7fdbcea34cfaa80b5e790f64 | 2 | manutec.hi | 2023-01-01 15:02:00.705426 | 1
21520284 | ETH | 0x45fb93bee5b6bacdd308f761931f8ab1238ec6710e12622a46c992ad895dd0d2 | 2 | manutec.hi
Timing is on.
type | blockchain | count
------------------+------------+---------
Set | MATIC | 5287853
NewKey | MATIC | 5127323
Transfer | MATIC | 2924957
NewURI | MATIC | 2624531
Sync | ETH | 457652
Transfer | ETH | 393949
NewURI | ETH | 338442
Timing is on.
registry_type | resolver | count
---------------+--------------------------------------------+---------
UnsMatic | 0xa9a6a3626993d487d2dbda3173cf58ca1a9d9e9f | 1432489
Cns | 0xb66dce2da6afaaa98f2013446dbcb0f4b0ab2842 | 225586
Zns | 0x0000000000000000000000000000000000000000 | 45509
Cns | | 44957
Uns | 0x049aba7510f45ba5b64ea9e658e342f904db358d | 29419
Cns | 0x878bc2f3f717766ab69c0a5f9a6144931e61aed3 | 19568
Cns | 0xa1cac442be6673c49f8e74ffc7c4fd746f3cbd0d | 15915