I'm in sort of predicament and I'm looking for ideas on how to move forward w/ my JR5 site. I apologize in advance if this is long but you'll see what going through my mind at least.
So, I have 3 quotas migrated over from my old JR4 site:
1. Artist Basic (member).
2. Artist15 - 15 song slots allowed
3. Artist100 - 100 song slots allowed
They exist now in JR5, with the same amount of song slots in JR4. My goal is to offer a subscription that is based on Disk Space (For this example, let's say 5GB space).
Problem 1 - Some artists in the Artist15 quota have zero audio loaded in their profile. When I launch the site, I don't want them to be able to use these 15 slots. Thus, I need a way (SQL update statement perhaps?) to find all artists with 0 audio, then change their quota to Artist Basic (member) quota. This basic quota still allows for SoundCloud import so it does have features that artist will still find useful to promote audio. They just wont be included in site audio rankings since that is only for uploaded audio hosted on my JR site. Subscribing to our site will grant them disk space, and thus allow them to appear in the audio listings. That's how I'll pitch it. So that's the first problem, how do I search for these artists and move them in bulk? In the old JR4 quota browser, there was a column for "disk space" usage that I could use to sort these. Is there something similar on JR5?
Problem 2 - Artists in the Artist15 quota that DO have audio loaded I want to be able to pitch to them the subscription for disk space that has a trial period. Meaning, "Upgrade to our Artist Elite package free trial for 30 days..." Let's say they upgrade, and upload (say) 3Gb of audio. Lets say they choose not to continue with the subscription. What behaviour will occur with the audio when the subscription expires? They will be bumped back down to the Artist15 quota, correct? I'm assuming, all 3Gb of audio will be visible to them, but not playable from site listings? Or ?? Not sure what will happen here. My thought is, the first 15 song slots that occupy the audio quota will be playable and visible, but the rest will not. Just want to know what to expect here so I can draft my documentation accordingly.
Problem 3 - If an account is associated to multiple profiles, does the quota apply to the account or profile(s)? Meaning, an account with 3 profiles, will still have (overall) 5Gb of disk space between the 3 profiles, correct?
Ultimately, artists WITH audio are grandfathered in, and will (at least) have what was available to them in the previous site, but they will be in sort of a limbo state between being a Basic Member and Subscription.
That's pretty much it for now. Thanks for listening to that mouthful lol.
updated by @ilovehousemusic: 04/12/14 02:59:43AM
JAMROOM
