might take a deeper look into doing ffrperfectproject stuff #real
I've gotta solve computer space once again but I'm tryna update the spreadsheet with new songs whenever I got time btw. I try to keep all the submissions that have been downloaded just in case anything happens and this has been building up a lotttt alongside everything else I've been doing lately; not too familiar with how more sophisticated data storage schemes work but I'm gonna try to find somethin better.
Crazy behind on the spreadsheet cuz I've had to work a lot, been sick a lot and still gotta figure out when I can get down to sign up for classes for next semester but I'll try and gather the submissions sent thus far and do what I can as I can. Thank you for your submission!
I hope this project isn't dead because now I want to contribute to it more. I have a lot of random SDG and blackflags to improve.
And actually, is there any way I can help with this? I played a song last night that wasn't on the spreadsheet. The YouTube channel hasn't been updated in over a year with new submissions. :l
Not dead, just a bit backed up. I've got extra time this week so I'm looking at revamping the project to move away from the spreadsheet -- this will make it easier for those running the project to update submissions and new songs, etc.
Bump - I've done a lot of work over the week to put together a proof-of-concept for a new FFR Perfect Project site to track the submissions, etc. built in Angular.
https://ffrperfectproject.com/ - NOTE - if you get errors and no page loads it's because the site is trying to store a cookie for light/dark mode that is being blocked. For now you'll have to enable cookies on the site to run it, I've noted that to be fixed in the future.
There are management options for FFRPP 'staff' to add/edit contributions, sync new songs, etc.
With these changes we'd be able to take submissions for any song from any user, irrespective of if someone had already submitted it, and display them all for toggling (see Trisection for an example of multiple submissions)
Ideally in time I'll have more of a welcome/landing page, explaining the project and showing recent uploads to the channel as we had on the old site's landing page.
Also have other things I'd like to implement into the site down the road, ranging from additional 'features' to extra 'management' tools to make maintaining the FFRPP easier on those who are doing the work to keep it updated
SQUASHED --- Right now the site is powered by a simple Firestore database, which I intend to move away from given they charge on a read/write/delete basis. I'd like to move to a database option that charges on storage (since all I'm storing are song details and submission details, no images or larger files), but I'm having trouble doing so and switching it out for the current Firestore implementation.
I have a PHP MariaDB database located on the server that I do the website hosting through, but no matter what I do to try to "hook it up" I can't get it to work with the site.
If someone has experience in the space or specific pointers/recommendations let me know. I'm a novice with both Angular and web/hosted database stuff in general so this is a bit of an uphill trudge lol (I work primarily in vb.net and C# services)
EDIT: landing page is in, updated filters and sorting on the song list.
Have made significant progress in terms of overall function and admin tools on the site, nearly there for going live with it. Once we do, we'll be able to drop the spreadsheet.
Users: Home page, song list (filtering, viewing, jump to FFR song page), leaderboard, individual user page with submissions and stats
Admin: Edit submissions, add submissions, resync song details (one or all), tools to make wiki updating easier, tools to make YT upload easier, sync new songs, sync changelogs (ease of knowing when to update info on YT, etc. for changed song info), tools to make managing badges for users easier if/when we get the green light on doing FFRPP badges.
Overall this should streamline quite a bit of the process for admin which should help us keep things updated a bit better.
I still have more to work on and more ideas on how we may be able to improve things, but thought I'd share an update. I've worked on this almost every day since the last update.
The new and improved FFR Perfect Project site now has embedded videos for all submissions, and a wide variety of management tools to help us keep the project rolling smoothly. We've also introduced some fun new stats (home page, song list page), leaderboards, and profiles specific to the project (including achievements to obtain!).
Some of these new achievements will award FFR profile badges as well, as noted on the "Achievements" section of the user profiles mentioned above. Given some users have already unlocked these badges through their existing submissions, we'll be going through and retroactively awarding these profile badges once they are available in the backend of FFR to be handed out. We're hoping that this might help to encourage new activity on the FFR Perfect Project!
Fixed a bug where songs marked as pending still showed under pending after a submission was added.
I've been working with Subaru regarding the backlog, we've got a chunk of files marked as pending upload but more to process through. I'll update this post when we get through marking songs with submissions as pending. From there, we'll be looking to try and tackle the remaining backlog of uploads to try and catch up with current submissions.
Thank you to those who continue to submit - once we get caught back up to present on this, things should be a lot more reasonable on the submission to upload timeframe.
EDIT: I believe all pending submissions have been marked as such, will be reviewing one or two more folders to be sure but that most should be marked now.
Fixed another issue where a few achievements weren't calculating correctly.
Also implemented a generic "Achievements" page that shows all of the achievements available along with how many users have unlocked said achievements via submissions. The numbers aren't totally accurate at the moment given the backlog (as it only counts uploaded submissions) but once we get caught up that will be accurate too on user counts for achievements obtained.
Also cleaned up a tad bit of UI around the admin menu and a few screen sizes.
If anyone runs into any problems using the site let me know!
All badges owed from submissions that are currently uploaded have been distributed! I'm traveling for the next week and a half but after that I'll be launching into getting the backlog uploaded.
Let me know if there are any questions or issues with the badges that were distributed!
Sent in another batch of songs to the email (last time I was told to send them in one zip folder or media fire link so I sent a zip file of them all together for easier download, let me know if it's okay or if I need to re-send. The individual videos themselves should have the proper "song title (username)" format).
Sent the following:
caprice for if [86]
Chlorophyll v2 [87]
Dis Dancehall Ting Is Better Than That T.V. Ting Tony [87]
Sound Burglar [87]
Magical 8bit Tour v2 [88]
RAINBOWNESS [88]
Ripcord [88]
Assault TAXI [89]
If Eat Rotten Food Often I'll Get Upset Stomach [89]
Fool The Detector [90]
Mathsma Attack [91]
Swindon [91]
1nput This 2 Y0ur Spine [92]
Canary Part V [92]
Digital Kecak No. 5 [92]
Escucha [92]
Heartbreak Furry Fandom v2 [92]
SHIMASHO!!!!!!! [92]
Super Mario Main Theme [92]
Mario Love Breakcore [93]
Re: End of a Dream [93]
Bust It Out [94]
Diabolic Swing [94]
Hai La Noi (eDUB Remix) [94]
Comment