Skip to content
July LPUD Winners - Transparency Video episode artwork

Jul 17, 2023 44 min

July LPUD Winners - Transparency Video

from anomadsoul 3Speak Podcast Hosted by anomadsoul

### [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](https://docs.google.com/spreadsheets/d/1bI__xltj1sgWx_z3z47narLbimPENn_HVfD6do3PU44/edit#gid=946090411) *** 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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

July LPUD Winners - Transparency Video

0:00 44:02

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of anomadsoul 3Speak Podcast?

This episode is 44 minutes long.

When was this anomadsoul 3Speak Podcast episode published?

This episode was published on July 17, 2023.

Can I download this anomadsoul 3Speak Podcast episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.