LPUD January - Transparency video

anomadsoul(80)

Published in

Threespeak

Words

155

Reading

1 min

Listen

Play

Check the official announcement here

This is a video where I pick the LPUD winners for the month of January, this is not an announcement, it's just a video where anyone can watch the process we used to pick the winners of the 8th Leo Power Up day.

This is the SQL query I ran to get the LPUD January participants:

Select 
ID, json, timestamp, tid, required_auth
From
TxCustoms
where
timestamp between '2023-01-14' and '2023-01-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:

dd4877735b7	3b4d99969e9	9954222b227	223d5529d83
845b99445d5	223d55659e3	845b99d5722	223d55e2583
223d5549984	99542263926	dd48775d7bb	223d55466d8
995422792000	59e533283b3	dd4877eee25	845b9435246
6279426e78d	b523b5dd933	3b4d9be5dd8	223d52b8e7b
845b947e845	3b4d9b44568	44bd24b9459	223d52dd64d