#7 Survey Block

[Frank Lace]

if the options a name implies a question mark, a modification the query will be wrong.
replace question mark the bID

for example:
survey options: sssss? and zzzzz
bID: 46
wrong query: DELETE FROM btSurveyOptions WHERE optionName NOT IN ('sssss'46'','zzzzz') AND bID =

[Frank Lace]

I found the solution.
My solution:
blocks/survey/controller.php line:151
change this:
$db->query("DELETE FROM btSurveyOptions WHERE optionName NOT IN ('".implode("','",$args['survivingOptionNames'])."') AND bID = ?",array($this->bID));
for this:
$db->query("DELETE FROM btSurveyOptions WHERE optionName NOT IN ('".implode("','",$args['survivingOptionNames'])."') AND bID =".$this->bID);

[Andrew Embler]

Thanks for the patch. We will include this.

[Andrew Embler]

I think we may have a different issue on this, when including apostrophes. We'll investigate.