LPUD January - Transparency video

---

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

That's it, if anyone has any questions regarding the transparency of this process, hit me up on discord @anomadsoul#8455

---

▶️ 3Speak