Free Lyrics Script

Hello, I want to start a lyrics site. Does anyone know of an open source lyrics script? Help would be greatly appreciated.

 

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.

 

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 was it any good? im looking for one my self

 

Thanks Endurer

 

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.

 

how to install?

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

btw thanks for the script

 

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.

 

Thanks mate...

that's help me alot..

 

well thank mate but is there any demo link where we can see it working it would be appreciated

 

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...

 

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):

 

what admin name password?

 

Do you have lyrics database?

 

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.

 

This type of software is very hard to find. Especially considering the amount of lyrics sites out there.

 

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 ^__^

 

how many records you have there?

 

how is the final product of the site look like guys? can i see some URL to the site using the script plz.?

 

looking forward to see the final results..thanks for everyone who's sharing this