diff options
| author | momo-i <momo-i@ampache> | 2009-03-16 10:54:42 +0000 |
|---|---|---|
| committer | momo-i <momo-i@ampache> | 2009-03-16 10:54:42 +0000 |
| commit | 8c56f72e4b4f267c54330e081aad672800b6022c (patch) | |
| tree | 7e2358482706fe8b0e3509feb654d701595d1d48 /lib/class | |
| parent | ef1907143ce81b3fd01f5a164c53f9040198ac2d (diff) | |
| download | ampache-8c56f72e4b4f267c54330e081aad672800b6022c.tar.gz ampache-8c56f72e4b4f267c54330e081aad672800b6022c.tar.bz2 ampache-8c56f72e4b4f267c54330e081aad672800b6022c.zip | |
Fixed: 1 line lyrics for insert db
Diffstat (limited to 'lib/class')
| -rw-r--r-- | lib/class/artist.class.php | 5 | ||||
| -rw-r--r-- | lib/class/vainfo.class.php | 4 |
2 files changed, 5 insertions, 4 deletions
diff --git a/lib/class/artist.class.php b/lib/class/artist.class.php index 1f7848c5..ce7fe2f1 100644 --- a/lib/class/artist.class.php +++ b/lib/class/artist.class.php @@ -306,7 +306,7 @@ class Artist extends database_object { if (strlen($results['lyrics']) > 1) { debug_event("lyrics", "Use DB", "5"); - return html_entity_decode(strip_tags(($results['lyrics'])), ENT_QUOTES); + return html_entity_decode($results['lyrics'], ENT_QUOTES); } elseif (strlen($lyrics) > 1) { // encode lyrics utf8 if (function_exists('mb_detect_encoding') AND function_exists('mb_convert_encoding')) { @@ -315,8 +315,9 @@ class Artist extends database_object { $lyrics = mb_convert_encoding($lyrics, "UTF-8", $enc); } } - $sql = "UPDATE `song_data` SET `lyrics` = '" . htmlspecialchars(strip_tags($lyrics), ENT_QUOTES) . "' WHERE `song_id`='" . Dba::escape($song_id) . "'"; + $sql = "UPDATE `song_data` SET `lyrics` = '" . htmlspecialchars($lyrics, ENT_QUOTES) . "' WHERE `song_id`='" . Dba::escape($song_id) . "'"; $db_results = Dba::write($sql); + debug_event("lyrics", "Use id3v2 tag (USLT or lyrics3)", "5"); return $lyrics; } diff --git a/lib/class/vainfo.class.php b/lib/class/vainfo.class.php index 0d7fbe92..6018213c 100644 --- a/lib/class/vainfo.class.php +++ b/lib/class/vainfo.class.php @@ -268,10 +268,10 @@ class vainfo { $info['language'] = Dba::escape($results[$key]['language']); /* @TODO returned lyrics are raw data. An appropriate escape is necessary for this. @momo-i */ if (!empty($results[$key]['unsynchronised lyric'])) { // ID3v2 USLT - $info['lyrics'] = $results[$key]['unsynchronised lyric']; + $info['lyrics'] = str_replace(array("\r\n","\r","\n"), '<br />',strip_tags($results[$key]['unsynchronised lyric'])); } else { // Lyrics3 v2.0 - $info['lyrics'] = $results['info']['lyrics']['unsynchedlyrics']; + $info['lyrics'] = str_replace(array("\r\n","\r","\n"), '<br />',strip_tags($results['info']['lyrics']['unsynchedlyrics']); } $info['track'] = intval($results[$key]['track']); } |