[Contest] FFR Perfect Project: Revival

[Zyxel]

submitted my Lolitonic score o7

might take a deeper look into doing ffrperfectproject stuff #real

[SubaruPoptart]

Originally Posted by Zyxel

submitted my Lolitonic score o7

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!

[catbug_]

do i bother redoing my ghost AAA for this

[catbug_]

submitted diabolic swing

[scoper49]

Submitted Kirlian Voyage.

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

[justin]

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.

Will report back once I see where I get this week

[justin]

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

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.

[Zyxel]

woah this is sick, looks good! excited to see how this goes