From: Steinar H. Gunderson <sesse@samfundet.no>
Date: Sun, 13 Feb 2005 16:45:40 +0000 (+0000)
Subject: Fix SQL escaping in wiki parser.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=4df0f31f45e22db83701a52dd2e5dc9ecc3ea67b

Fix SQL escaping in wiki parser.
---

diff --git a/parse/parse-wiki-songlist.pl b/parse/parse-wiki-songlist.pl
index 49934c8..169dbd2 100644
--- a/parse/parse-wiki-songlist.pl
+++ b/parse/parse-wiki-songlist.pl
@@ -27,8 +27,8 @@ while (<>) {
 	$artist =~ s/\[\[//g;
 
 	# minimal SQL escaping
-	$songname =~ s/'/\'/g;
-	$artist =~ s/'/\'/g;
+	$songname =~ s/'/\\'/g;
+	$artist =~ s/'/\\'/g;
 
 	$maxbpm = $minbpm if (!defined($maxbpm));
 	($maxbpm,$minbpm) = ($minbpm,$maxbpm) if ($maxbpm < $minbpm);