▶️
This is a video where I pick the LPUD winners for the month of December, this is not an announcement, it's just a video where anyone can watch the process we used to pick the winners of the 7th Leo Power Up day.
This is the SQL query I ran to get the LPUD December participants:
Select
ID, json, timestamp, tid, required_auth
From
TxCustoms
where
timestamp between '2022-12-14' and '2022-12-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(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:
| 22d4ed35686 | 84b8db54646 | dd852883324 | 44d9eddbd57 |
|---|---|---|---|
| 22d4edd6d68 | e7eb6eebb66 | e7eb6e9e888 | 9946b4294b5 |
| 7324d286524 | dd8528d9e34 | 84b8db44286 | b53483562d8 |
| b5348354898 | e7eb6ed2353 | 595b658e8e6 | 22d4ed6de64 |
| 22d4ed64e47 | 22d4ed67224 | e7eb6e68586 | 7324d24b968 |
| 22d4ed487b9 | 44d9ed9254e | 629de9dde33 | 629de9397d5 |
| 629de935383 | 9946b28386e | dd85279882b | b5348b7b3ed |
| 84b8d93d955 | dd8527b376b | 22d4e5876e2 | b5348b9b326 |
That's it, if anyone has any questions regarding the transparency of this process, hit me up on discord @anomadsoul#8455
▶️
