From 2040e49f949396aa79fb84ed9e025e4de5571ed6 Mon Sep 17 00:00:00 2001
From: MaZderMind
Date: Mon, 22 Dec 2014 13:30:42 +0100
Subject: standalone feedback page & intrinsic save mechanism

---
 pages/feedback.php | 42 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 42 insertions(+)
 create mode 100644 pages/feedback.php

(limited to 'pages/feedback.php')

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'],
+	));
+}
-- 
cgit v1.2.3