From c2b65f2b7bffeed46a2981f4eeb04e063c379ac0 Mon Sep 17 00:00:00 2001
From: canyonknight <canyonknight@gmail.com>
Date: Wed, 23 May 2012 15:22:51 -0400
Subject: action_form.php: Pull out DB code

* Create new functions in pkgfuncs.inc.php with SQL queries from
action_form.php
* Centralization of DB code important in a future transition to PDO interface
* Flip logic of vote and notify XHTML button to use function return rather
than a more confusing NOT (!) logical operator statement

Signed-off-by: canyonknight <canyonknight@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
---
 web/template/actions_form.php | 32 ++++++++------------------------
 1 file changed, 8 insertions(+), 24 deletions(-)

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

diff --git a/web/template/actions_form.php b/web/template/actions_form.php
index 59a6e7a..e5ab7c2 100644
--- a/web/template/actions_form.php
+++ b/web/template/actions_form.php
@@ -3,33 +3,17 @@
 		<fieldset>
 			<input type="hidden" name="IDs[<?php echo $row['ID'] ?>]" value="1" />
 			<input type="hidden" name="ID" value="<?php echo $row['ID'] ?>" />
-		<?php
-		# Voting Button
-		#
-		$q = "SELECT * FROM PackageVotes WHERE UsersID = ". $uid;
-		$q.= " AND PackageID = ".$row["ID"];
-		$result = db_query($q, $dbh);
-		if ($result):
-			if (!mysql_num_rows($result)):
-		?>
-			<input type="submit" class="button" name="do_Vote" value="<?php echo __("Vote") ?>" />
-			<?php else: ?>
+
+		<?php if (user_voted($uid, $row['ID'])): ?>
 			<input type="submit" class="button" name="do_UnVote" value="<?php echo __("UnVote") ?>" />
-			<?php endif; ?>
+		<?php else: ?>
+			<input type="submit" class="button" name="do_Vote" value="<?php echo __("Vote") ?>" />
 		<?php endif; ?>
-		<?php
-		# Comment Notify Button
-		#
-		$q = "SELECT * FROM CommentNotify WHERE UserID = ". $uid;
-		$q.= " AND PkgID = ".$row["ID"];
-		$result = db_query($q, $dbh);
-		if ($result):
-			if (!mysql_num_rows($result)):
-		?>
-			<input type="submit" class="button" name="do_Notify" value="<?php echo __("Notify") ?>" title="<?php echo __("New Comment Notification") ?>" />
-			<?php else: ?>
+
+		<?php if (user_notify($uid, $row['ID'])): ?>
 			<input type="submit" class="button" name="do_UnNotify" value="<?php echo __("UnNotify") ?>" title="<?php echo __("No New Comment Notification") ?>" />
-			<?php endif; ?>
+		<?php else: ?>
+			<input type="submit" class="button" name="do_Notify" value="<?php echo __("Notify") ?>" title="<?php echo __("New Comment Notification") ?>" />
 		<?php endif; ?>
 
 		<?php if ($row["OutOfDateTS"] === NULL): ?>
-- 
cgit v1.2.3-70-g09d2