July LPUD Winners - Transparency Video

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:

92993bee437	25228eeb824	92993b7b557	d7ddb599b32
929936828b4	39bbe836982	4244798e9b6	d7ddb5bb2eb
7833b4b2398	39bbe826882	39bbe825d87	929936d7b46
6422bd7bb8e	92993655272	92993652b83	7833b45649b
5399db5e473	7833b4834e8	92993693de9	bb55d452474
bb55d455d35	bb55d454943	5399db8d58e	2522846d4eb
5399db88b77

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

▶️ 3Speak

July LPUD Winners - Transparency Video | Ecency