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>'; }