From c2b65f2b7bffeed46a2981f4eeb04e063c379ac0 Mon Sep 17 00:00:00 2001 From: canyonknight 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 Signed-off-by: Lukas Fleischer --- web/lib/pkgfuncs.inc.php | 40 ++++++++++++++++++++++++++++++++++++++++ web/template/actions_form.php | 32 ++++++++------------------------ 2 files changed, 48 insertions(+), 24 deletions(-) (limited to 'web') diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php index 5696321..2265c76 100644 --- a/web/lib/pkgfuncs.inc.php +++ b/web/lib/pkgfuncs.inc.php @@ -973,6 +973,46 @@ function getvotes($pkgid, $dbh=NULL) { return $votes; } +# Determine if a user has already voted for a specific package +function user_voted($uid, $pkgid, $dbh=NULL) { + if(!$dbh) { + $dbh = db_connect(); + } + + $uid = db_escape_string($uid); + $pkgid = db_escape_string($pkgid); + + $q = "SELECT * FROM PackageVotes WHERE UsersID = ". $uid; + $q.= " AND PackageID = ".$pkgid; + $result = db_query($q, $dbh); + if (mysql_num_rows($result)) { + return true; + } + else { + return false; + } +} + +# Determine if a user wants notifications for a specific package +function user_notify($uid, $pkgid, $dbh=NULL) { + if(!$dbh) { + $dbh = db_connect(); + } + + $uid = db_escape_string($uid); + $pkgid = db_escape_string($pkgid); + + $q = "SELECT * FROM CommentNotify WHERE UserID = ". $uid; + $q.= " AND PkgID = ".$pkgid; + $result = db_query($q, $dbh); + if (mysql_num_rows($result)) { + return true; + } + else { + return false; + } +} + /** * Toggle notification of packages * 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 @@
- - " /> - + + " /> - + + " /> - - " title="" /> - + + " title="" /> - + + " title="" /> -- cgit v1.2.3-70-g09d2