1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Free Lyrics Script

Discussion in 'Scripts' started by Hobbit2, Jun 22, 2006.

  1. #1
    Hello, I want to start a lyrics site. Does anyone know of an open source lyrics script? Help would be greatly appreciated.
     
    Hobbit2, Jun 22, 2006 IP
    carl_in_florida likes this.
  2. Endurer

    Endurer Well-Known Member

    Messages:
    1,113
    Likes Received:
    84
    Best Answers:
    0
    Trophy Points:
    140
    #2
    I'm not the author of this script neither do I take any credit/responsibility of any kind. Found it while searching on the internet and I'm not quite sure who the author is.
     

    Attached Files:

    Endurer, Jun 28, 2006 IP
  3. Hobbit2

    Hobbit2 Active Member

    Messages:
    720
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    60
    #3
    Sorry for the late reply, but thanks! I appreciate it. I'll post it if was any good.

    EDIT: Should I leave the footer as is? His link is dead.
     
    Hobbit2, Jul 3, 2006 IP
  4. dre

    dre Peon

    Messages:
    1,367
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hobbit2 was it any good? im looking for one my self
     
    dre, Sep 5, 2006 IP
  5. lordlisa

    lordlisa Peon

    Messages:
    58
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Thanks Endurer
     
    lordlisa, Sep 6, 2006 IP
  6. Endurer

    Endurer Well-Known Member

    Messages:
    1,113
    Likes Received:
    84
    Best Answers:
    0
    Trophy Points:
    140
    #6
    Hobbit2, It's always nice to give credit to the original author. If the link is dead then remove it but leave his name in the footer or mention it at least in some way on your website.

    You are welcome.
     
    Endurer, Sep 11, 2006 IP
  7. h4nh4n

    h4nh4n Peon

    Messages:
    931
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #7
    how to install?

    i don't know how to install that, do we have to import the sql?

    btw thanks for the script :)
     
    h4nh4n, Sep 11, 2006 IP
  8. Endurer

    Endurer Well-Known Member

    Messages:
    1,113
    Likes Received:
    84
    Best Answers:
    0
    Trophy Points:
    140
    #8
    It's pretty simple. Just make a new database with the help of phpmyadmin. Copy the entire content from the file base.sql.. go to your phpmyadmin, select the database you recently created from the left hand side drop down menu. Now you will see a link on the right hand side frame with the text "SQL". Paste the code there and execute it.

    Now configure your config.inc.php file in the home directory by filling in the required field & thats it.
     
    Endurer, Sep 11, 2006 IP
    h4nh4n likes this.
  9. h4nh4n

    h4nh4n Peon

    Messages:
    931
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Thanks mate...

    that's help me alot.. :)
     
    h4nh4n, Sep 12, 2006 IP
  10. linkbuilding

    linkbuilding Banned

    Messages:
    399
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #10
    well thank mate but is there any demo link where we can see it working it would be appreciated :)
     
    linkbuilding, Sep 13, 2006 IP
    Yfcadmin likes this.
  11. new2006

    new2006 Peon

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Hey I get error when tried to creat the table with PhpMyAdmin:

    Error
    SQL query:

    CREATE TABLE `lyrics_albums` (

    `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `artist` int( 11 ) NOT NULL default '0',
    `album` varchar( 40 ) NOT NULL default '',
    PRIMARY KEY ( `id` ) UNIQUE KEY `album` ( `album` )
    ) TYPE = MYISAM ;



    MySQL said:

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIQUE KEY `album` (`album`)
    ) TYPE=MyISAM' at line 6

    My SQL version is 5.0..I think...
     
    new2006, Jan 22, 2007 IP
  12. Endurer

    Endurer Well-Known Member

    Messages:
    1,113
    Likes Received:
    84
    Best Answers:
    0
    Trophy Points:
    140
    #12
    There are two commas missing:

    Use the following:

    
    CREATE TABLE `lyrics_albums` (
    `id` int(11) NOT NULL auto_increment,
    `artist` int(11) NOT NULL default '0',
    `album` varchar(40) NOT NULL default '',
    PRIMARY KEY (`id`), 
    UNIQUE KEY `album` (`album`)
    ) TYPE=MyISAM;
    
    
    CREATE TABLE `lyrics_artist` (
    `id` int(11) NOT NULL auto_increment,
    `artist` varchar(30) NOT NULL default '',
    PRIMARY KEY (`id`),
    UNIQUE KEY `artist` (`artist`)
    ) TYPE=MyISAM;
    
    
    CREATE TABLE `lyrics_songs` (
    `id` int(11) NOT NULL auto_increment,
    `album` int(11) NOT NULL default '0',
    `name` varchar(30) NOT NULL default '',
    `text` text NOT NULL,
    PRIMARY KEY (`id`), 
    UNIQUE KEY `name` (`name`)
    ) TYPE=MyISAM;
    Code (markup):
     
    Endurer, Jan 22, 2007 IP
  13. Karacoder

    Karacoder Peon

    Messages:
    87
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #13
    what admin name password?
     
    Karacoder, Jan 24, 2007 IP
  14. ColdMoney

    ColdMoney Peon

    Messages:
    65
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #14
    Do you have lyrics database?
     
    ColdMoney, Feb 1, 2007 IP
  15. Endurer

    Endurer Well-Known Member

    Messages:
    1,113
    Likes Received:
    84
    Best Answers:
    0
    Trophy Points:
    140
    #15
    I don't have a lyrics database at the moment. You can search for it in the buy/sell/trade section here at DP.. I am sure there are some topics on it already.
     
    Endurer, Feb 2, 2007 IP
  16. BamaStangGuy

    BamaStangGuy Notable Member

    Messages:
    955
    Likes Received:
    51
    Best Answers:
    1
    Trophy Points:
    245
    #16
    This type of software is very hard to find. Especially considering the amount of lyrics sites out there.
     
    BamaStangGuy, Feb 7, 2007 IP
  17. jehzlau

    jehzlau Active Member

    Messages:
    301
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    73
    #17
    I have a lyrics database, and I added all the lyrics manually by myself, it took a year or 2 to have this huge database.. if you want il give it to you, all i want is a link back to my blog, that's all ^__^
     
    jehzlau, Feb 28, 2007 IP
  18. hextraordinary

    hextraordinary Well-Known Member

    Messages:
    2,171
    Likes Received:
    115
    Best Answers:
    0
    Trophy Points:
    105
    #18
    how many records you have there?
     
    hextraordinary, Feb 28, 2007 IP
  19. toby

    toby Notable Member

    Messages:
    6,923
    Likes Received:
    269
    Best Answers:
    0
    Trophy Points:
    285
    #19
    how is the final product of the site look like guys? can i see some URL to the site using the script plz.?
     
    toby, Feb 28, 2007 IP
  20. Kerunai

    Kerunai Active Member

    Messages:
    649
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #20
    looking forward to see the final results..thanks for everyone who's sharing this ;)
     
    Kerunai, Mar 2, 2007 IP