Jump to content

cmgmyr

Members
  • Posts

    1,278
  • Joined

  • Last visited

    Never

Posts posted by cmgmyr

  1. If you are matching up the album names wouldn't it be:

    $media = mysql_query('SELECT * FROM files LEFT JOIN albums ON (files.album=albums.name) ORDER BY timestamp DESC LIMIT 0, 1');

    ...what you should do is make another key in files (a_id) for album id then it can be (files.a_id=albums.id) which would make it a lot easier
  2. $media = mysql_query('SELECT * FROM files LEFT JOIN albums ON (files.album=albums.id) ORDER BY timestamp DESC LIMIT 0, 1');

    Try that, I usually inclose the join with (). Also your WHERE didn't do anything...this is more then likely your problem.

    Let me know how it works out.
    -Chris
  3. Just read up on different types of lists and what you can do with them. CSS menus are pretty easy to understand/make. Look at examples but don't copy and paste them...you won't learn anything that way ;)
  4. Thank you for that link, I missed that the first time I went through that page :)

    Here is my final header portion of the script:[code]$fileHandle = 'mp3/'.$mp3;
    $new_name = "$name - $title.mp3";
    header('HTTP/1.1 200 OK');
    header('Date: ' . date("D M j G:i:s T Y"));
    header('Last-Modified: ' . date("D M j G:i:s T Y"));
    header("Content-Type: audio/mp3");
    header("Content-Length: " . (string)(filesize($fileHandle)) );
    header("Content-Transfer-Encoding: Binary");
    header('Content-Disposition: attachment; filename='.$new_name );
    readfile($fileHandle); [/code]
  5. ok, so if I make the filename Metallica - Enter Sandman.mp3:
    header("Content-Disposition: attachment; filename=Metallica - Enter Sandman.mp3");

    How do I get that to download from mp3/$mp3 (mp3/rvtzsr7ec25quj7u.mp3) ?

    [quote author=dark dude link=topic=112942.msg458644#msg458644 date=1161965629]
    And btw, slightly offtopic, but good example band + song given thar :P
    [/quote] You can never go wrong with that song ;)
  6. I like that one better. I also like that you moved that lower nave over to the right. I would keep the login where it is.

    Try cutting the footer down a little (half) and see how it looks. Right now it looks a little too big.

    -Chris
  7. It loaded slow for me too.

    Good stuff:
    - left nav
    - color scheme
    - text and size

    Not so good stuff:
    - photos (looks kinda cheesy and old)
    - red color fonts (header and news)
    - need to find a new color for the news title the red is too bold and in-your-face

    a good start so far.

    -Chris
  8. I would stick with header #2 but i would cut that stroke/glow down a lot, try it (if it is stroke) to 1px or 2px, I don't think I would go over 2 though.

    I def like the new design though. Once you get the footer filled in it will look a little better too. I also like the icons you used, did you make those or find them somewhere?

    Can't wait to see the live version.

    -Chris
  9. Hey everyone,
    I would like to have a download script that will take a file name from the databse and rename it, then prompt for download. This is what I have so far:

    [code=php:0]<?php
    global $user;
    $maid = $_GET['maid'];
    $cookie_read = explode("|", base64_decode($user));
    $userid = $cookie_read[0];

    include "connect.php";

    //Find the mp3
    $result = mysql_query("SELECT * FROM mp3_activity WHERE maid = '$maid' AND userid = $userid AND pur = 1") or die('Query failed: ' . mysql_error());
    if (mysql_numrows($result) <= 0){
    echo "You can not download this file.";
    }else{
    $row = mysql_fetch_array($result);
    $mid = stripslashes($row['mid']);

    //Find the mp3
    $result = mysql_query("SELECT * FROM mp3 WHERE mid = '$mid'") or die('Query failed: ' . mysql_error());
    $row = mysql_fetch_array($result);
    $title = stripslashes($row['title']);
    $bandid = stripslashes($row['bandid']);
    $mp3 = stripslashes($row['mp3']);
    //Find Band name
    $result = mysql_query("SELECT * FROM users WHERE userid = '$bandid'") or die('Query failed: ' . mysql_error());
    $row = mysql_fetch_array($result);
    $name = stripslashes($row['name']);

    //want to re-name the $mp3 file here

    header("Content-Type: audio/mpeg");
    header("Content-Disposition: attachment; filename=$mp3");
    header("Pragma: no-cache");
    header("Expires: 0");
    }

    ?> [/code]

    all mp3's are stored in the directory "mp3". What I want to have happen is, is when the user goes to download the file it renames the file to Band Name - MP3 title.mp3 (ex. Metallica - Entersandman.mp3). The filename that is in the system was randomly generated so it would be something like rvtzsr7ec25quj7u.mp3

    Thanks,
    -Chris
  10. [quote author=akitchin link=topic=112560.msg458386#msg458386 date=1161915225]
    Nightslyr - ... kudos man, it's inspiring.[/quote]

    Double Kudos buddy. It seems like you are keeping your head up through everything and that is great. Mind over Matter. Your mind will always wins. If you wanna feel great then put a smile on, if you wanna feel sorry for yourself then join the rest of the world. I think it's awesome that there are people out there that can still lead happy and productive lives even if it isn't like others'.

    I'm glad to have you on the site, please let me know if you need any help with anything :)

    -Chris
  11. [quote author=effigy link=topic=112560.msg457398#msg457398 date=1161786092]
    [quote author=cmgmyr link=topic=112560.msg456951#msg456951 date=1161717466]
    Let me know if you wanna chat music or gear sometime.
    [/quote]
    Have you tried electronic drums?
    [/quote]

    Yeah I have tried a few of them. The problem is, is that do get a decent sound...you need to pay A LOT of money. The ones that I'm looking at now are Roland TD-12S: V-Stage Series (http://www.rolandus.com/products/productdetails.aspx?ObjectId=659&ParentId=60). These and the Studio series have the best feeling pads (get better bounce off of them) and the brain is a lot better. But all good things come at a price, the Stage series is about $3,200-$3,800 depending on where you find it. I think the studio is $5,000+ (which is way too much for me). Hopefully I can get the Stage series within a year. (Sometimes I want to practice at like 2 in the morning and I can't because I don't want to piss the neighbors off :) so the electronic ones would be good.)

    For acoustic drum sets I have 2:
    The first one (my baby) is a Mapex Orion Classic which is polished black with gold and silver hardware. It looks SWEET!
    (old pics but you get the idea)
    [img]http://chrisgmyr.com/kickax/images/equip/front.jpg[/img] [img]http://chrisgmyr.com/kickax/images/equip/middle.jpg[/img] This is a 10+ piece kit (not fully set up in the picture)

    The other one is a Tama swingstar that I picked up real cheap and use it as a practice/beater kit. This is just a normal 5 piece kit.
    [img]http://forcedentryband.com/images/tama_front.jpg[/img] [img]http://forcedentryband.com/images/tama_top.jpg[/img]

    The pictures don't really give to 2 kits justice, but you get the idea. I love music! and there is nothing better then being up on stage playing! Plus it makes the girls go crazy...it's not even fair. It's like fishing in a stocked pond with dynamite 8)

    Later,
    -Chris
  12. [quote author=akitchin link=topic=112560.msg457164#msg457164 date=1161745346]
    girlfriended (thanks effigy)[/quote]

    Thats awesome, it sounds like some sort of plague or sickness or something. I've been "girlfriended" for a while but I got out of it a short time ago, and as I said previously I'm trying to make it out in the single world...luckily business is good ;)


    Another little side note: my first website was for my first "real" band in middle school and it was on Geocities. *Pukes* O well it was fun...but I learned quickley geocities was NOT the way to go...
  13. I have an IPN set up on a website right now and it works great for single purchases. What I'm setting up is an mp3 store where bands can log on and upload music that they want to sell. Other users log on and purchase the music. Then at the end of the month I will download the list of purchases and then pay the bands.

    Questions:
    1. How do I get the items that were purchased out of the script?
    2. What is the best way to go about doing this?

    Please let me know if you need any more information or if you would like to see my script.

    Thanks,
    -Chris
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.