Link to Rising Star Utils web
Good evening to all Rising Star players!
As I am used to do in this time, I will make a monthly summary with statistics, changes in the development of the Rising Star Utils website. Next, I will make a summary of the statistics for the month of August.
Statistics
As I mentioned before, I had been working on a function that would compile the users who spent and the total STARBITS spent on the site into a table in SQL format. In total, these have been the users who have spent the most on the site and the amounts spent each day since August 15, when I implemented the function.
| Account | Starbits Spends | Swaphive Spends |
|---|---|---|
| toqs1986 | 67825714 | 0.0000 |
| vassal | 56206229 | 0.0000 |
| clipman77 | 16050385 | 0.0000 |
| liaminit1 | 9198274 | 0.0000 |
| doombot75 | 9291860 | 0.0000 |
| cryptogames12 | 4419234 | 0.0000 |
| monsterjamgold | 3809654 | 0.0000 |
| messiah-05 | 3541214 | 0.0000 |
| mateodm03 | 3297055 | 0.0000 |
| kungfukid | 2847384 | 0.0000 |
| rukien | 1438838 | 0.0000 |
| jesseoostv | 1266350 | 0.0000 |
| torran | 1226709 | 0.0000 |
| shaddrak | 1019157 | 0.0000 |
| thejosa | 894600 | 0.0000 |
| menzo | 804963 | 0.0000 |
| brickbybrick | 796428 | 0.0000 |
| cethzalez | 693186 | 0.0000 |
| motra | 708946 | 0.0000 |
| gezellig | 524150 | 0.0000 |
| diegoloco | 478143 | 0.0000 |
| tfranzini | 434604 | 0.0000 |
| smithers113 | 370912 | 0.0000 |
| specialfeelings | 360000 | 0.0000 |
| freed99 | 668183 | 0.0000 |
| edusan | 528003 | 0.0000 |
| ruralio | 498276 | 0.0000 |
| badmusgreene | 460080 | 0.0000 |
| yonyonsson | 1575010 | 0.0000 |
| raythulhu | 117813 | 0.0000 |
| Starbits Spends | Starbits Earned | SwapHive Spends | SwapHive Earned | Year Month | Date |
|---|---|---|---|---|---|
| 6192261 | 61924 | 0.243 | 0.003 | 2024-08 | 2024-08-15 |
| 10320666 | 103211 | 0.000 | 0.000 | 2024-08 | 2024-08-16 |
| 8957899 | 89586 | 0.000 | 0.000 | 2024-08 | 2024-08-17 |
| 16030221 | 160307 | 0.000 | 0.000 | 2024-08 | 2024-08-18 |
| 11012984 | 110149 | 0.000 | 0.000 | 2024-08 | 2024-08-19 |
| 12613984 | 126140 | 0.000 | 0.000 | 2024-08 | 2024-08-20 |
| 8730247 | 87305 | 0.000 | 0.000 | 2024-08 | 2024-08-21 |
| 8127839 | 81282 | 0.000 | 0.000 | 2024-08 | 2024-08-22 |
| 5569097 | 55694 | 0.000 | 0.000 | 2024-08 | 2024-08-23 |
| 17405434 | 174056 | 0.000 | 0.000 | 2024-08 | 2024-08-24 |
| 8536422 | 85365 | 0.000 | 0.000 | 2024-08 | 2024-08-25 |
| 5182647 | 51825 | 0.000 | 0.000 | 2024-08 | 2024-08-26 |
| 3933139 | 39333 | 0.000 | 0.000 | 2024-08 | 2024-08-27 |
| 9898872 | 98989 | 0.000 | 0.000 | 2024-08 | 2024-08-28 |
| 4836827 | 48369 | 0.000 | 0.000 | 2024-08 | 2024-08-29 |
| 41579638 | 415796 | 0.000 | 0.000 | 2024-08 | 2024-08-30 |
| 20039013 | 200391 | 0.000 | 0.000 | 2024-08 | 2024-08-31 |
| 7024459 | 70245 | 0.000 | 0.000 | 2024-09 | 2024-09-01 |
Looking at this table, we conclude that in only 17 days, they have spent a total of 187804592 on the site. The three users who spent the most STARBITS were @toqs1986, @vassal and @clipman77.
Regarding the traffic of users on the page, this is the graph with the results of August, similar to the previous month.
Latest changes made
Changes in mobile design.
I have made the site more accessible from mobile devices.
Can buy more than 50 cards
I have figured out how to make it possible to buy up to 200 cards.
Stats Card
What I've been working on during this time, is to be able to look up the stats of each player of Rising Star. The cover image is the ID that I used to represent the stats of each user, I have managed to collect information such as ranking, weekly minutes, fans/skill/luck/im, amount of luck in each type of instruments, total cards, epic, legendary and rare.
Much faster maintenance
Some of you may know that at 3:00 UTC a maintenance starts in order to check that there are no problems in our database. I have optimized the process by more than 500%, so the maintenance only takes about ten minutes in total.
Good practices
I have been working on improving the practices in the code of the website. So I have taken the trouble to recycle the code as much as possible and delegate responsibilities more effectively.
SQL database implementation that collects the starbits spent by each user on the page.
Based on learning a little more about SQL, and taking advantage of the access to a free database provided by the hosting. I have taken to verify that each successful transaction on the page, I take a count of everything spent by each user on the page and how much is spent per month.
What's coming
Finish implementing the stats cards
One of the problems that I have encountered to make the stats system of each user. It's the amount of cards of each user that have to be analyzed to make a return of the stats of the users. Considering that there are accounts with more than 100,000 cards, these transactions can occupy a lot of resources, so I am trying to find a way to limit these transactions, in order not to saturate the node on which the page works.
Information about each card.
Views where you can see the information about each card in the game and a graph that shows how the price of that unique card changed over time. Like the previous function, it could also be limited by not having its own node. Going through the history of each card is complicated, the contract does not provide the name of the card when searching for information, but rather the ID. Which would lead to having a database with each ID of each card in the game, which is unsustainable considering that there are more than 15 million cards in circulation.
Proposals
I wanted to reserve this space to let you know that you can express your ideas for the future of the site. I have been asked lately for some things that are not possible due to simple limitations of the nodes, but maybe there are other proposals that can be realized without any problem.
Thank you all for supporting our site! See you next time in the September report!
Others posts related:
Rising Star Utils - July Report: Montly Statitics, more changes and what is coming
We celebrate our first month of life! - Monthly Statitics, unique cards function and more!!!!
▶️ 3Speak
Congratulations @mateodm03! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)
<table><tr><td><img src="https://images.hive.blog/60x70/https://hivebuzz.me/@mateodm03/upvotes.png?202409011932" /><td>You distributed more than 4000 upvotes.<br />Your next target is to reach 5000 upvotes. <p dir="auto"><sub><em>You can view your badges on <a href="https://hivebuzz.me/@mateodm03" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">your board and compare yourself to others in the <a href="https://hivebuzz.me/ranking" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">Ranking<br /> <sub><em>If you no longer want to receive notifications, reply to this comment with the word <code>STOP <p dir="auto"><strong>Check out our last posts: <table><tr><td><a href="/hive-122221/@hivebuzz/pum-202408-result"><img src="https://images.hive.blog/64x128/https://i.imgur.com/mzwqdSL.png" /><td><a href="/hive-122221/@hivebuzz/pum-202408-result">Hive Power Up Month Challenge - August 2024 Winners List<tr><td><a href="/hive-122221/@hivebuzz/pum-202409"><img src="https://images.hive.blog/64x128/https://i.imgur.com/M9RD8KS.png" /><td><a href="/hive-122221/@hivebuzz/pum-202409">Be ready for the September edition of the Hive Power Up Month!<tr><td><a href="/hive-122221/@hivebuzz/pud-202409"><img src="https://images.hive.blog/64x128/https://i.imgur.com/805FIIt.jpg" /><td><a href="/hive-122221/@hivebuzz/pud-202409">Hive Power Up Day - September 1st 2024I wonder why my playing account (sm-pro) is not listed here. Any reasons?
I don't know, I think the function started collecting since August 17.
Just grab the top of the table to share it.
Yes, it makes sense. Thank you!