From 354c86b6c608c8923d0a087285f97d5d8121ed08 Mon Sep 17 00:00:00 2001
From: Loui Chang <louipc.ist@gmail.com>
Date: Sun, 25 Jan 2009 13:17:54 -0500
Subject: Move package comment form into a new template.

Feature the form on the package details page.

Signed-off-by: Loui Chang <louipc.ist@gmail.com>
---
 web/template/pkg_comment_form.php | 68 +++++++++++++++++++++++++++++++++++++++
 1 file changed, 68 insertions(+)
 create mode 100644 web/template/pkg_comment_form.php

(limited to 'web/template/pkg_comment_form.php')

diff --git a/web/template/pkg_comment_form.php b/web/template/pkg_comment_form.php
new file mode 100644
index 0000000..70570da
--- /dev/null
+++ b/web/template/pkg_comment_form.php
@@ -0,0 +1,68 @@
+<?php
+# Add a comment to this package
+if (isset($_REQUEST['comment'])) {
+
+	# Insert the comment
+	$dbh = db_connect();
+	$q = 'INSERT INTO PackageComments ';
+	$q.= '(PackageID, UsersID, Comments, CommentTS) VALUES (';
+	$q.= intval($_REQUEST['ID']) . ', ' . uid_from_sid($_COOKIE['AURSID']) . ', ';
+	$q.= "'" . mysql_real_escape_string($_REQUEST['comment']) . "', ";
+	$q.= 'UNIX_TIMESTAMP())';
+	db_query($q, $dbh);
+
+	# Send email notifications
+	$q = 'SELECT CommentNotify.*, Users.Email ';
+	$q.= 'FROM CommentNotify, Users ';
+	$q.= 'WHERE Users.ID = CommentNotify.UserID ';
+	$q.= 'AND CommentNotify.UserID != ' . uid_from_sid($_COOKIE['AURSID']) . ' ';
+	$q.= 'AND CommentNotify.PkgID = ' . intval($_REQUEST['ID']);
+	$result = db_query($q, $dbh);
+	$bcc = array();
+
+	if (mysql_num_rows($result)) {
+		while ($row = mysql_fetch_assoc($result)) {
+			array_push($bcc, $row['Email']);
+		}
+
+		$q = 'SELECT Packages.Name ';
+		$q.= 'FROM Packages ';
+		$q.= 'WHERE Packages.ID = ' . intval($_REQUEST['ID']);
+		$result = db_query($q, $dbh);
+		$row = mysql_fetch_assoc($result);
+
+		# TODO: native language emails for users, based on their prefs
+		# Simply making these strings translatable won't work, users would be
+		# getting emails in the language that the user who posted the comment was in
+		$body =
+		'from http://aur.archlinux.org/packages.php?ID='
+		. $_REQUEST['ID'] . "\n"
+		. username_from_sid($_COOKIE['AURSID']) . " wrote:\n\n"
+		. $_POST['comment']
+		. "\n\n---\nIf you no longer wish to receive notifications about this package, please go the the above package page and click the UnNotify button.";
+		$body = wordwrap($body, 70);
+		$bcc = implode(', ', $bcc);
+		$headers = "Bcc: $bcc\nReply-to: nobody@archlinux.org\nFrom: aur-notify@archlinux.org\nX-Mailer: AUR\n";
+		@mail(' ', "AUR Comment for " . $row['Name'], $body, $headers);
+	}
+}
+
+	# Prompt visitor for comment
+?>
+<div class="pgbox">
+	<form action='<?php echo $_SERVER['PHP_SELF'] . '?ID=' . $_REQUEST['ID'] ?>' method='post'>
+	<div style="padding: 1%">
+<?php
+if (isset($_REQUEST['comment'])) {
+	echo '<b>' . __('Comment has been added.') . '</b>';
+}
+?>
+	<input type='hidden' name='ID' value="<?php echo $_REQUEST['ID'] ?>">
+	<?php echo __('Enter your comment below.') ?><br />
+	<textarea name='comment' rows='10' style="width: 100%"></textarea><br />
+	<input type='submit' value="<?php echo __("Submit") ?>">
+	<input type='reset' value="<?php echo __("Reset") ?>">
+	</div>
+	</form>
+</div>
+
-- 
cgit v1.2.3-70-g09d2