July LPUD Winners - Transparency Video

in LeoFinance • 2 years ago (edited)

▶️ Watch on 3Speak

Check the official announcement here

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

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

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

92993bee43725228eeb82492993b7b557d7ddb599b32
929936828b439bbe8369824244798e9b6d7ddb5bb2eb
7833b4b239839bbe82688239bbe825d87929936d7b46
6422bd7bb8e9299365527292993652b837833b45649b
5399db5e4737833b4834e892993693de9bb55d452474
bb55d455d35bb55d4549435399db8d58e2522846d4eb
5399db88b77

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

▶️ 3Speak

Posted Using LeoFinance Alpha

2 years ago in LeoFinance by
$96.86
542 votes
Reply 15
Sort:  
  • Trending
    • [-]
     2 years ago  

    If you have any comments or something to say about LPUD, check the official announcement and leave it there!

    $0.00
      Reply
      [-]
       2 years ago  

      That's transparent 👍🏽 Do you write the SQL query and Javascript yourself? 👀

      $0.00
        Reply
        [-]
         2 years ago  

        I did a while ago, I even had to learn SQL from scratch to be able to do this report xD

        JS I already knew but at a rookie level, so writing that small script took some research.

        Thanks for the feedback fren :D