function insertFeedback($uid, $pid, $done, $time, $tried, $liked, $skills, $breakthrough, $fun, $difficulty, $when_return)
{
mysql_query('START TRANSACTION');
if (strcmp($done, 'yes') == 0) {
$donetext = 'Yes';
$done = 0;
} else {
if (strcmp($done, 'no') == 0) {
doneTestingPuzzle($uid, $pid);
$donetext = 'No';
$done = 1;
} else {
if (strcmp($done, 'notype') == 0) {
doneTestingPuzzle($uid, $pid);
$donetext = 'No, this isn\'t a puzzle type I like.';
$done = 2;
} else {
if (strcmp($done, 'nostuck') == 0) {
doneTestingPuzzle($uid, $pid);
$donetext = 'No, I\'m not sure what to do and don\'t feel like working on it anymore.';
$done = 3;
} else {
if (strcmp($done, 'nofun') == 0) {
doneTestingPuzzle($uid, $pid);
$donetext = 'No, I think I know what to do but it isn\'t fun/I\'m not making progress.';
$done = 4;
} else {
if (strcmp($done, 'nospoiled') == 0) {
doneTestingPuzzle($uid, $pid);
$donetext = 'No, I was already spoiled on this puzzle';
$done = 5;
} else {
if (strcmp($done, 'nodone') == 0) {
doneTestingPuzzle($uid, $pid);
$donetext = 'No, I\'ve solved it.';
$done = 6;
}
}
}
}
}
}
}
$comment = createFeedbackComment($donetext, $time, $tried, $liked, $skills, $breakthrough, $fun, $difficulty, $when_return);
$ncomment = "<p><strong>Testing Feedback</strong></p>";
$ncomment .= "<p><a class='description' href='#'>[View Feedback]</a></p>";
$ncomment .= "<div>{$comment}</div>";
addComment($uid, $pid, $ncomment, FALSE, TRUE, TRUE);
$sql = sprintf("INSERT INTO testing_feedback (uid, pid, done, how_long, tried, liked, skills, breakthrough, fun, difficulty, when_return)\n VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %s, %s, '%s')", mysql_real_escape_string($uid), mysql_real_escape_string($pid), mysql_real_escape_string($done), mysql_real_escape_string($time), mysql_real_escape_string($tried), mysql_real_escape_string($liked), mysql_real_escape_string($skills), mysql_real_escape_string($breakthrough), mysql_real_escape_string($fun), mysql_real_escape_string($difficulty), mysql_real_escape_string($when_return));
query_db($sql);
mysql_query('COMMIT');
}
function displayPrevFeedback($uid, $pid)
{
$prevFeedback = getPreviousFeedback($uid, $pid);
if (!$prevFeedback) {
return;
}
echo '<h3>Previous Feedback</h3>';
echo '<table>';
foreach ($prevFeedback as $pf) {
if ($pf['done'] == 0) {
$done = 'Yes';
} else {
if ($pf['done'] == 1) {
$done = 'No';
} else {
if ($pf['done'] == 2) {
$done = 'No, this isn\'t a puzzle type I like.';
} else {
if ($pf['done'] == 3) {
$done = 'No, I\'m not sure what to do and don\'t feel like working on it anymore.';
} else {
if ($pf['done'] == 4) {
$done = 'No, I think I know what to do but it isn\'t fun/I\'m not making progress.';
} else {
if ($pf['done'] == 5) {
$done = 'No, I was already spoiled on this puzzle';
} else {
if ($pf['done'] == 6) {
$done = 'No, I\'ve solved it.';
}
}
}
}
}
}
}
$feedback = createFeedbackComment($done, $pf['how_long'], $pf['tried'], $pf['liked'], $pf['skills'], $pf['breakthrough'], $pf['fun'], $pf['difficulty'], $pf['when_return']);
$purifier = new HTMLPurifier();
$cleanComment = $purifier->purify($feedback);
echo '<tr class="feedback">';
echo '<td class="feedback">' . $pf['time'] . '</td>';
echo '<td class="feedback">' . nl2br2($cleanComment) . '</td>';
echo '</tr>';
}
echo '</table>';
}
