standalone feedback page & intrinsic save mechanism

1 files changed, 42 insertions, 0 deletions

diff --git a/pages/feedback.php b/pages/feedback.php
new file mode 100644
index 0000000..8335c6f
--- /dev/null
+++ b/pages/feedback.php
@@ -0,0 +1,42 @@
+<?php
+
+if(
+	!isset($_POST['datetime']) ||
+	!isset($_POST['net']) ||
+	!isset($_POST['os']) ||
+	!isset($_POST['player']) ||
+	!isset($_POST['stream']) ||
+	!isset($_POST['provider']) ||
+	!isset($_POST['issuetext'])
+) {
+	require_once('lib/bootstrap.php');
+
+	echo $tpl->render(array(
+		'page' => 'feedback',
+		'title' => 'Give Feedback',
+	));
+}
+else
+{
+	$db = new PDO('sqlite:/opt/31c3-streaming-feedback/feedback.sqlite3');
+	$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+
+	$stm = $db->prepare('
+		INSERT INTO feedback (reported, datetime, net, os, player, stream, ipproto_v4, ipproto_v6, provider, issues, issuetext)
+			VALUES (:reported, :datetime, :net, :os, :player, :stream, :ipproto_v4, :ipproto_v6, :provider, :issues, :issuetext)
+	');
+
+	$stm->execute(array(
+		'reported' => time(),
+		'datetime' => strtotime($_POST['datetime']),
+		'net' => $_POST['net'],
+		'os' => $_POST['os'],
+		'player' => $_POST['player'],
+		'stream' => $_POST['stream'],
+		'ipproto_v4' => isset($_POST['ipproto']) && is_array($_POST['ipproto']) && in_array('v4', $_POST['ipproto']),
+		'ipproto_v6' => isset($_POST['ipproto']) && is_array($_POST['ipproto']) && in_array('v6', $_POST['ipproto']),
+		'provider' => $_POST['provider'],
+		'issues' => isset($_POST['issues']) && is_array($_POST['issues']) ? implode(',', $_POST['issues']) : '',
+		'issuetext' => $_POST['issuetext'],
+	));
+}