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
Embed this episode
No transcript yet.