Sign in to follow this  
Raugust

An up-to-date Regina fansite?

Recommended Posts

quote:
Originally posted by stwongbad85:

david's 2 cents..just make sure on this new super-group fan site that you can download all the sheet music from the yahoo group Matt W (bloodroses) created.

.

that is all carry on with this enourmous thread which i have not read at all

Oh, don't worry. I know all about Matt Winksworth and co and their immense genious. I'm sure he'd be happy to share. He's rad.

Share this post


Link to post
Share on other sites

quote:
Originally posted by adamjk:

I've been planning on doing straight up html/css, and using cutenews (a free, php-based content system) for the "news" page.

If you have better ideas, such as a better news-updating system with ability for multiple users to log in under different accounts, that would be great.

In addition, I currently plan on doing the lyrics in straight HTML. A page for each song, at the top listing any other names for the song, the first time played live, etc., and then a master page with links to each of those pages. Probably a javascript drop-down box at the top of each lyrics page somewhere as well, done with includes so I could just update the one list, and not have to update each page's drop-down list seperately.

If you have a better way to do the lyrics, particularly one that also could be updated by a number of people with seperate login names, that would be really great. Because clearly people like Ragaust will have to be able to get in there and make changes.

But, to close, YEAH, I'm really more an artsy type than a coding type, and I'd/we'd love your help!

Is the server running Linux or Windows? If it's a linux server, then doing PHP/MySQL would be one choice, or doing JSP's with MySQL would be another. If it's windows, ASP.NET/MS SQL Server would be superb.

In either case, my reccommended structure would be basically the same:

Each part of the site gets a table in the database (be it MySQL or MS SQL Server). Then, each "news" entry gets a row in the "NEWS" table, and each song could have one or more rows in the lyrics table.

The drop down box (or nav-bar, etc.) of songs gets dynamically populated from the database, so it's always up-to-date. When a request is made for, say, the lyrics to the song "Bartender", the web server will query the database for all known lyrics to the song and return them as a dynamic page.

This would also give fans the ability to search based on lyrics, if there is uncertainty about song titles. If, for instance, I don't know the title of a song, but I know it contains the line "they're just public mosoleums", I can search for that in the "lyrics" field of the SONG_LYRICS table and the appropriate song will be returned.

So, in my suggested method, there would only be a handful of actual pages, which would have a basic layout hard-coded and then a dynamic content section which is populated by the database when a request is made.

For example, at amazon.com, we have millions of products. We don't sit there and write a product page for every one. We write one product page, without any details, and then populate the details with the results of a database query.

As for login, using a database makes that very easy. The permissions for each user can be managed on the database server, multiple users can be logged in simultaneously, and each user will have access to update the appropriate parts of the database.

Of course, users won't have to know anything about the database, they'll just see HTML forms and fill them in. The server-side code will then take the information they've entered into the forms and store it nicely in the database.

Share this post


Link to post
Share on other sites

That sounds utterly fantastic. However, I personally am totally shit at mySQL or whatever that is. I can't even tell you if it's Linux or Windows. I can, however, tell you I have hosting with Dreamhost.com

I'd love to have such an intelligent structure, but honestly? I'd be doing literally nothing because I am completely clueless as to how to accomplish all of that. If you were really willing to put up with doing such a tremendous amount of work, then I certainly won't complain, but then again, it might be hard to work with from a creative standpoint. In addition, if I'm completely clueless, changes in my hosting's services or mistakes made would render me useless 'cause I wouldn't know how to react and fix things.

Hmm.

Share this post


Link to post
Share on other sites

quote:
Originally posted by adamjk:

That sounds utterly fantastic. However, I personally am totally shit at mySQL or whatever that is. I can't even tell you if it's Linux or Windows. I can, however, tell you I have hosting with Dreamhost.com

I'd love to have such an intelligent structure, but honestly? I'd be doing literally nothing because I am completely clueless as to how to accomplish all of that. If you were really willing to put up with doing such a tremendous amount of work, then I certainly won't complain, but then again, it might be hard to work with from a creative standpoint. In addition, if I'm completely clueless, changes in my hosting's services or mistakes made would render me useless 'cause I wouldn't know how to react and fix things.

Hmm.

Well, if it's dreamhost, I think they're all linux. How comitted are you to dreamhost? I'm personally a fan of GoDaddy hosting, and have some very cheap webspace from them (50gig/1TB for a couple bucks a month).

I'm not saying dreamhost wouldn't work, but the concern you have about being creatively inhibited is what leads me to suggest GoDaddy. With GoDaddy, we can get windows hosting (they include a SQL database) and we can run ASP.NET.

ASP.NET has a very nice structure called "Code-Behind" that is designed so that "programmers" and "web designers" can work together without screwing each other up. In Code-Behind, there are two parts to every page, one part is the HTML and CSS, the other part is the server-side language (C# or VB.NET). The server combines the two parts when the page gets rendered, but basically, the designer can work on the HTML part without the programmer ever having to touch it.

If you want to stick with dreamhost, we'd be doing PHP/MySQL (which I am fine with, it's just not as nice as ASP.NET). In that case, there would be a little more of a challenge in seperating out the program-code from the HTML, since they're both stored in the same file.

edit: since posting this, I've thrown together a quick sample. I set up some very generic tables for news and lyrics and then threw html front ends on them. This only reflects about 25 minutes of work, so it's very ugly (but hey, that's where you come in, right?) but you can add news/lyrics and search.

The functionality can certainly be expanded upon, and extended to mp3's, videos, articles, sheet music, etc.

Anyway, here's the example: http://aaron.doomray.com/aaron/reginapolis/

edit again: Threw in basic MP3 Search/Download functionality for kicks.

Share this post


Link to post
Share on other sites

quote:
Originally posted by a_secret_chord:

wots the security like on a windows host tho, i was under the impression its complete pap.

The Securty with IIS 6.0 is pretty good. I've actually had more security problems come up with running PHP (injection-attack) then with ASP.NET, if only because it's easier to build parameterized queries and do input validation with .NET.

Some more recent studies actually find that a Linux webserver is more vulnerable, for example: http://www.securityinnovation.com/resources/linux_windows.shtml

In reality though, any decent hosting company is going to have things locked down pretty tightly. I haven't really heard of security issues in Windows or Linux, being the fault of the host, in any cases. If there's a security issue, it's usually because of quesitonable coding practices by the developers who buy the web space.

Share this post


Link to post
Share on other sites

I've been using Dreamhost for nearly 2 years now, and I'm really happy with them. I intend to stay with them.

I like what you've come up with a lot!

However, I feel like some things would be better off more bare-bones. The way you have mp3s done is fantastic, but a bit unnecessary, and the news system is promising, but unless you feel like spending a lot more time than you need to, we could just use CuteNews (the php-based news system) instead. If you want to keep working on that though, that's up to you and I don't have a problem with that as long as you can show me how to go about customizing that.

As far as the lyrics go, I'd LOVE LOVE LOVE to use your system. It's fantastic and far better than I could have done. If you can make it so each page would be editable by a few users it'd be great, because people like Ragaust could just go right ahead and make additions and edits as needed. I don't care for the "added by" tagline, but I assume that's a detail that we can remove. A "notes section" at the top under the name would be great for additional details to appear in italics though.

So, after all this rambling, if you'd be able to create a system for lyrics that would work with Dreamhost, it'd be great. If you'd like to continue discussing this by email, my email address is adam@sogoddamnyoung.org

Thank you so much!

Share this post


Link to post
Share on other sites

quote:
However, I feel like some things would be better off more bare-bones. The way you have mp3s done is fantastic, but a bit unnecessary,

What aspect of the mp3 set-up on that site seemed unnecessary? I thought it looked fantastic; near-perfect, with a little fiddling (e.g., "show date" doesn't need time of day, "date added" seems like it'd be only be useful for brand-new additions, "showname" and "showvenue" could probably be combined, and "user" should be replaced by something to credit the original recorder/provider of the mp3).

Share this post


Link to post
Share on other sites

quote:
Originally posted by adamjk:

I've been using Dreamhost for nearly 2 years now, and I'm really happy with them. I intend to stay with them.

I like what you've come up with a lot!

However, I feel like some things would be better off more bare-bones. The way you have mp3s done is fantastic, but a bit unnecessary, and the news system is promising, but unless you feel like spending a lot more time than you need to, we could just use CuteNews (the php-based news system) instead. If you want to keep working on that though, that's up to you and I don't have a problem with that as long as you can show me how to go about customizing that.

As far as the lyrics go, I'd LOVE LOVE LOVE to use your system. It's fantastic and far better than I could have done. If you can make it so each page would be editable by a few users it'd be great, because people like Ragaust could just go right ahead and make additions and edits as needed. I don't care for the "added by" tagline, but I assume that's a detail that we can remove. A "notes section" at the top under the name would be great for additional details to appear in italics though.

So, after all this rambling, if you'd be able to create a system for lyrics that would work with Dreamhost, it'd be great. If you'd like to continue discussing this by email, my email address is adam@sogoddamnyoung.org

Thank you so much!

If you want to keep using Dreamhost and Cutenews, that's fine. I'm not particularly concerned with the news section, as that can work just about any-which-way.

I can setup a similar thing for lyrics in PHP/MySql, I'd just need access to upload the PHP scripts and to create tables in the database (details like this we can address through email, though. My address is in my first post in this thread.).

It seems like there might be some need for discussion on the MP3 section. I like what Raugust has suggested, and it would just require a little change to the table layout on what I've already done. What did you have in mind?

Share this post


Link to post
Share on other sites

hi everyone, i'm new! i've been a fan of regina's for over a year now but i never thought to seek out a regina forum since we talk about her constantly at the fiona apple bb i go to. heh.

anyway, i dont' know shit about website making, but i want to help make a good one for regina. i have been saving every rare-ish pic i find and so i have little collection going that i'd love to share. just let me know if there's anything i can do to help! be it organizing pics or... well that's probably all i'm qualified to do. but whatever.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this