September LPUD Winners - Transparency video

anomadsoul(80)

Published in

LeoFinance

Words

159

Reading

1 min

Listen

Play

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