7
This is a video where I pick the LPUD winners for the month of February, this is not an announcement, it's just a video where anyone can watch the process we used to pick the winners of the 10th Leo Power Up day.
This is the SQL query I ran to get the LPUD March participants:
Select
ID, json, timestamp, tid, required_auth
From
TxCustoms
where
timestamp between '2023-03-14' and '2023-03-16 14:00:00'
and tid like '%ssc_mainnet_hive%'
and json like '%"contractAction":"stake"%'
and json like '%"symbol":"LEO"%'
order by timestamp desc
This is the Javascript script I ran to clean the SQL database:
const leo = [
'{"contractName":"tokens","contractAction":"stake","contractPayload":{"to":"tinyputerboy","symbol":"LEO","quantity":"0.225"}}',
'{"contractName":"tokens","contractAction":"stake","contractPayload":{"to":"kolus290","symbol":"LEO","quantity":"2.115"}}',
];
for (let i = 0; i < leo.length; i++) {
const obj = JSON.parse(leo[i]);
console.log(obj.contractPayload.to, parseFloat(obj.contractPayload.quantity));
}
The link to the spreadsheet is here
Here are the bet IDs of every roll I made to pick the winners and you can crosscheck them with the video and on DuckDice:
739543d9d86 | 2293462eb57 | e738bdd44bd | 6267d5e7287 |
---|---|---|---|
84358ede236 | 6267d5d68b4 | 73954642dee | 99856e6766d |
99856e7ede3 | 6267d533eb2 | 22934e98e4e | dd945297837 |
99856b33e78 | 597eb6d3d25 | b5724897b47 | e738b64e835 |
73954dedeb6 | 84358d573de |
That's it, if anyone has any questions regarding the transparency of this process, hit me up on discord @anomadsoul#8455
Comments:
Reply:
To comment on this video please connect a HIVE account to your profile: Connect HIVE Account