+ Reply to Thread
Page 1 of 2
1 2 LastLast
Results 1 to 20 of 23

Thread: Pm Dawn - Discography Database

  1. #1
    TBA Brian221's Avatar
    Join Date
    Dec 2001
    Location
    Milwaukee, WI
    Posts
    1,241

    Pm Dawn - Discography Database

    pmFan got me motivated. Over the next week or so, I'll be adding my entire pmdawn collection to a searchable, sortable, etc online database.

    Then you guys can send me whatever additions you have or know about.
    I already built the db and started the forms for adding stuff to it.

    ...more to come.
    I'm not signing this without my lawyer.

  2. #2
    Barney Freakin' Rubble
    Join Date
    Jul 2005
    Location
    Sunshine State
    Posts
    1,562

    YEA! What info do you want?
    Media (12" vinyl, 7" vinyl, cassette, CD),
    Title,
    tracks,
    times,
    GeeStreet/Island/V2 catalog number (like GECDX 65/854 565-2 and 314-524 147-2)?

    Peace

  3. #3
    TBA Brian221's Avatar
    Join Date
    Dec 2001
    Location
    Milwaukee, WI
    Posts
    1,241

    Here's what I've got so far --

    For each "item":
    - Artist Name
    - Title
    - Year of Release
    - Product Number
    - Origin (U.S., U.K., AUS, etc)
    - Format (12", 7", CD, 3inCD, etc)
    - Type (Album, Single, Soundtrack, Other)
    - Image_link (to the cover art, stored on pmdawn.net)

    For each related "track":
    - Track no (1, 2, etc - vinyl could be A1, B2, etc)
    - Track Title
    - Performed Flag (checked if Pm Dawn performs this track)
    - Wrote Flag (check if Pm Dawn wrote this track)
    - Produced Flag (checked if Pm Dawn produced this track)
    - Remix Flag (checked if this is a remix of an original Pm Dawn track)
    - Lyrics Link
    - Tabs Link
    - Clip Link

    If we deem track times necessary, I can add that easily.
    I'm not signing this without my lawyer.

  4. #4
    Barney Freakin' Rubble
    Join Date
    Jul 2005
    Location
    Sunshine State
    Posts
    1,562

    Wow! That's impressive! I look forward to looking through your collection and seeing what I don't have!

    CD3? Were there many things released on CD3?
    Peace

  5. #5
    TBA Brian221's Avatar
    Join Date
    Dec 2001
    Location
    Milwaukee, WI
    Posts
    1,241

    As far as I've seen, the only 3" cd with any pm dawn material was a single of the X-files them w/pm dawn remix. Thats it.
    I'm not signing this without my lawyer.

  6. #6

    Is this going to involve MSSQL and ASP?

  7. #7
    TBA Brian221's Avatar
    Join Date
    Dec 2001
    Location
    Milwaukee, WI
    Posts
    1,241

    HELL NO!

    mysql and php
    I'm not signing this without my lawyer.

  8. #8

    there is hope!!

  9. #9
    Barney Freakin' Rubble
    Join Date
    Jul 2005
    Location
    Sunshine State
    Posts
    1,562

    Quote Originally Posted by SaintHax
    there is hope!!
    Ha ha ha - feeling a little anti-MS? Hey, do you guys have any good references for PHP? What about MySQL? Any good references for a DBA?
    Peace

  10. #10
    waiting for Spring Louis85's Avatar
    Join Date
    Dec 2001
    Location
    Pittsburgh, PA
    Posts
    2,969

    I use php and mySQL for a website that I run. I just learned it about two months ago (or at least enough of it to get things going). They're both cool. Kinda different from the .NET and Oracle that I use at work, simpler in a lot of ways.

    Brian does good work. I can hardly wait to see this thing to see which cuts I'm missing.
    Last edited by Louis85; 11-15-2005 at 04:48 PM.
    I love the summer months!

  11. #11
    TBA Brian221's Avatar
    Join Date
    Dec 2001
    Location
    Milwaukee, WI
    Posts
    1,241

    Why write anything these days...it already exists!!!
    There's this nice little open source app called Mambo with an add-on called ArtistAvenue. It'll do just fine for now.

    I just started -- but here's preview.

    http://www.pmdawn.net/mambo/index.ph...id=1&Itemid=26
    I'm not signing this without my lawyer.

  12. #12
    waiting for Spring Louis85's Avatar
    Join Date
    Dec 2001
    Location
    Pittsburgh, PA
    Posts
    2,969

    Yeah, I'm using Mambo too! I didn't realize it was that popular. I think I only chose it because the initial layout was orange (my favorite color). I never heard of the ArtistAvenue add-on. What does it do?
    I love the summer months!

  13. #13
    Administrator eternals layre's Avatar
    Join Date
    Dec 2001
    Location
    kingsport tn
    Posts
    635

    Its big... using mambo for everything. jyhad.com and a few others.
    artistave is a artist database with builtin mp3 player
    America needs a Tennessee Volunteer

  14. #14
    waiting for Spring Louis85's Avatar
    Join Date
    Dec 2001
    Location
    Pittsburgh, PA
    Posts
    2,969

    That looks very nice, Brian.
    I love the summer months!

  15. #15
    Barney Freakin' Rubble
    Join Date
    Jul 2005
    Location
    Sunshine State
    Posts
    1,562

    I don't know if this helps ease the data entry, but I have an excel spreadsheet with info on about 30 CDs of/by/or having to do with PM Dawn. Let me know if you want tme to email it to you - I put it in one fat spreadsheet with all of the fields you mentioned above. (I left the picture and links fields blank). If you need pics, I can start scanning little by little over the next few weeks.
    Peace

  16. #16
    TBA Brian221's Avatar
    Join Date
    Dec 2001
    Location
    Milwaukee, WI
    Posts
    1,241

    I put some more stuff in the database today. (still 20 cds, 25 records, and some tapes/videos to go)

    http://www.pmdawn.net/mambo/index.ph...enue&Itemid=26
    I'm not signing this without my lawyer.

  17. #17
    TBA Brian221's Avatar
    Join Date
    Dec 2001
    Location
    Milwaukee, WI
    Posts
    1,241

    Quote Originally Posted by pmFan
    I don't know if this helps ease the data entry, but I have an excel spreadsheet with info on about 30 CDs of/by/or having to do with PM Dawn. Let me know if you want tme to email it to you - I put it in one fat spreadsheet with all of the fields you mentioned above. (I left the picture and links fields blank). If you need pics, I can start scanning little by little over the next few weeks.
    Sure -- email me the spreadsheet and I can compare -- I also just finished putting all my cds out on the database -- I have to work on the vinyl sometime this week.

    brianwelter@hotmail.com
    I'm not signing this without my lawyer.

  18. #18
    Senior Member Etherspin's Avatar
    Join Date
    Jan 2002
    Location
    oZ/Uk
    Posts
    3,317

    for some reason mambo is now named "Joomla" as if the name wasnt weird enough

    hey its good tho innit!
    "One day the absurdity of the almost universal human belief in the slavery of other animals will be palpable. We shall then have discovered our souls and become worthier of sharing this planet with them."
    ~Martin Luther King Jr.

  19. #19
    TBA Brian221's Avatar
    Join Date
    Dec 2001
    Location
    Milwaukee, WI
    Posts
    1,241

    My collection has all been added to the discography, and I'll continue making the mambo version of pmdawn.net more usable today.

    http://www.pmdawn.net/mambo/index.ph...enue&Itemid=26
    I'm not signing this without my lawyer.

  20. #20
    Barney Freakin' Rubble
    Join Date
    Jul 2005
    Location
    Sunshine State
    Posts
    1,562

    Brian, this is awesome!

    Tell me, how does the Ode to a Forgetful Mind Original Mix (Watcher's Point of View (underground) 12") compare to the More Than Words Mix (UK LP with extra tracks)?

    What does the Supercallla... mix sound like?

    What about the Watcher's underground?
    Peace

+ Reply to Thread

Similar Threads

  1. Discography, WIP
    By Brian221 in forum Leisure World
    Replies: 4
    Last Post: 03-06-2007, 11:04 PM
  2. Discography
    By pmFan in forum Leisure World
    Replies: 1
    Last Post: 02-01-2007, 05:02 PM
  3. pM dAwn discography
    By Hero1 in forum Leisure World
    Replies: 11
    Last Post: 02-25-2003, 12:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts