Check the official announcement here
This is a video where I pick the LPUD winners for the month of September, this is not an announcement, it's just a video where anyone can watch the process we used to pick the winners of the 4th Leo Power Up day.
This is the SQL query I ran to get the LPUD August participants:
Select
ID, json, timestamp, tid, required_auth
From
TxCustoms
where
timestamp between '2022-09-14' and '2022-09-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:
| 73dd62e2597 | e766de425e4 | b58863974eb | dd2268b2394 |
|---|---|---|---|
| 99bbe4399b8 | e766de24d5b | 596685d76dd | 99bbe48b7b9 |
| e766de376b9 | 84ddeb3bd62 | 3b556d3e526 | e766de33499 |
| 22ee63e4982 | 22ee63458bb | 59668eb89b3 | 22ee6372223 |
| 73dd65d3584 | b588628b638 | 3b5564b4b64 | 59668ee2288 |
| b588628b638 | 73dd65d922d | 84dde5e6b4e | 73dd6568de4 |
| e766d8deb95 | 73dd656b293 | b58862672de | 3b5564bd6eb |
That's it, if anyone has any questions regarding the transparency of this process, hit me up on discord 
▶️ 3Speak