Posts

LPUD January - Transparency video

avatar of @anomadsoul
25
@anomadsoul
·
0 views
·
1 min read

▶️ Watch on 3Speak


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