LPUD - June Winners Transparency Video
from anomadsoul 3Speak Podcast Hosted by anomadsoul
https://3speak.tv/watch?v=anomadsoul/yaeylfxd ### Check the official announcement here This is a video where I pick the LPUD winners for the month of June, this is not an announcement, it's just a video where anyone can watch the process we used to pick the winners of the Leo Power Up day First anniversary. This is the SQL query I ran to get the LPUD June participants: Select ID, json, timestamp, tid, required_auth From TxCustoms where timestamp between '2023-06-14' and '2023-06-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 That's it, if anyone has any questions regarding the transparency of this process, hit me up on discord @anomadsoul#8455
Embed this episode
No transcript yet.