From 8c07c091e8b4bfcee33745d6c2e58a35cbf9a44d Mon Sep 17 00:00:00 2001
From: Lukas Fleischer <archlinux@cryptocrack.de>
Date: Sun, 9 Feb 2014 01:37:03 +0100
Subject: Remove LastVoted column

This has been introduced by commit aae43d9 (started working on package
comments, 2005-03-05) but it seems to be of no practical use. Remove the
field to save some space.

Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
---
 web/lib/acctfuncs.inc.php               | 3 ---
 web/lib/pkgfuncs.inc.php                | 6 ------
 web/template/account_details.php        | 6 ------
 web/template/account_search_results.php | 2 --
 web/template/search_accounts_form.php   | 1 -
 5 files changed, 18 deletions(-)

(limited to 'web')

diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php
index f705574..0207bbd 100644
--- a/web/lib/acctfuncs.inc.php
+++ b/web/lib/acctfuncs.inc.php
@@ -373,9 +373,6 @@ function search_results_page($UTYPE,$O=0,$SB="",$U="",$T="",
 		case 'i':
 			$q.= "ORDER BY IRCNick, AccountTypeID ";
 			break;
-		case 'v':
-			$q.= "ORDER BY LastVoted, Username ";
-			break;
 		default:
 			$q.= "ORDER BY Username, AccountTypeID ";
 			break;
diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php
index 59cc975..5800a26 100644
--- a/web/lib/pkgfuncs.inc.php
+++ b/web/lib/pkgfuncs.inc.php
@@ -1071,12 +1071,6 @@ function pkg_vote ($atype, $ids, $action=true) {
 
 	$dbh->exec($q);
 
-	if ($action) {
-		$q = "UPDATE Users SET LastVoted = UNIX_TIMESTAMP() ";
-		$q.= "WHERE ID = $uid";
-		$dbh->exec($q);
-	}
-
 	if ($action) {
 		return array(true, __("Your votes have been cast for the selected packages."));
 	} else {
diff --git a/web/template/account_details.php b/web/template/account_details.php
index 680a52e..5ba01d9 100644
--- a/web/template/account_details.php
+++ b/web/template/account_details.php
@@ -43,12 +43,6 @@
 					<?= $row["InactivityTS"] ? __("Inactive since") . ' ' . date("Y-m-d H:i", $row["InactivityTS"]) : __("Active"); ?>
 					</td>
 				</tr>
-				<tr>
-					<th><?= __("Last Voted") . ":" ?></th>
-					<td>
-					<?= $row["LastVoted"] ? date("Y-m-d", $row["LastVoted"]) : __("Never"); ?>
-					</td>
-				</tr>
 				<tr>
 					<th>Links:</th>
 					<td><ul>
diff --git a/web/template/account_search_results.php b/web/template/account_search_results.php
index ae7c112..bd4ee29 100644
--- a/web/template/account_search_results.php
+++ b/web/template/account_search_results.php
@@ -13,7 +13,6 @@ else:
 					<th><?= __("Real Name") ?></th>
 					<th><?= __("IRC Nick") ?></th>
 					<th><?= __("PGP Key Fingerprint") ?></th>
-					<th><?= __("Last Voted") ?></th>
 					<th><?= __("Edit Account") ?></th>
 				</tr>
 			</thead>
@@ -42,7 +41,6 @@ else:
 					<td><?php $row["RealName"] ? print htmlspecialchars($row["RealName"],ENT_QUOTES) : print "&nbsp;" ?></td>
 					<td><?php $row["IRCNick"] ? print htmlspecialchars($row["IRCNick"],ENT_QUOTES) : print "&nbsp;" ?></td>
 					<td><?php $row["PGPKey"] ? print html_format_pgp_fingerprint($row["PGPKey"]) : print "&nbsp;" ?></td>
-					<td><?php $row["LastVoted"] ? print date("Y-m-d", $row["LastVoted"]) : print __("Never") ?></td>
 					<td>
 					<?php
 						if ($UTYPE == "Trusted User" && $row["AccountType"] == "Developer"):
diff --git a/web/template/search_accounts_form.php b/web/template/search_accounts_form.php
index 202b1aa..d7f54be 100644
--- a/web/template/search_accounts_form.php
+++ b/web/template/search_accounts_form.php
@@ -57,7 +57,6 @@
 					<option value="t"><?= __("Account Type"); ?></option>
 					<option value="r"><?= __("Real Name"); ?></option>
 					<option value="i"><?= __("IRC Nick"); ?></option>
-					<option value="v"><?= __("Last vote"); ?></option>
 				</select>
 			</td>
 		</tr>
-- 
cgit v1.2.3-54-g00ecf