summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--UPGRADING7
-rw-r--r--support/schema/aur-schema.sql1
-rw-r--r--web/lib/acctfuncs.inc.php10
3 files changed, 16 insertions, 2 deletions
diff --git a/UPGRADING b/UPGRADING
index d8527e34..c5846473 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -10,6 +10,13 @@ From 2.2.0 to 2.3.0
ALTER TABLE Users ADD COLUMN InactivityTS BIGINT NOT NULL DEFAULT 0;
----
+2. Add a field to store the total number of TUs to the "TU_VoteInfo" table:
+
+----
+ALTER TABLE TU_VoteInfo
+ ADD COLUMN ActiveTUs tinyint(3) unsigned NOT NULL default '0';
+----
+
From 2.1.0 to 2.2.0
-------------------
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 68db93f4..51f9601d 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -202,6 +202,7 @@ CREATE TABLE IF NOT EXISTS TU_VoteInfo (
Yes tinyint(3) unsigned NOT NULL default '0',
No tinyint(3) unsigned NOT NULL default '0',
Abstain tinyint(3) unsigned NOT NULL default '0',
+ ActiveTUs tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (ID),
FOREIGN KEY (SubmitterID) REFERENCES Users(ID) ON DELETE CASCADE
) ENGINE = InnoDB;
diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php
index 7602ec28..738c7b27 100644
--- a/web/lib/acctfuncs.inc.php
+++ b/web/lib/acctfuncs.inc.php
@@ -618,10 +618,16 @@ function open_user_proposals($user) {
function add_tu_proposal($agenda, $user, $votelength, $submitteruid) {
$dbh = DB::connect();
- $q = "INSERT INTO TU_VoteInfo (Agenda, User, Submitted, End, SubmitterID) VALUES ";
+ $q = "SELECT COUNT(*) FROM Users WHERE AccountTypeID = 2";
+ $result = $dbh->query($q);
+ $row = $result->fetch(PDO::FETCH_NUM);
+ $active_tus = $row[0];
+
+ $q = "INSERT INTO TU_VoteInfo (Agenda, User, Submitted, End, ";
+ $q.= "SubmitterID, ActiveTUs) VALUES ";
$q.= "(" . $dbh->quote($agenda) . ", " . $dbh->quote($user) . ", ";
$q.= "UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + " . $dbh->quote($votelength);
- $q.= ", " . $submitteruid . ")";
+ $q.= ", " . $submitteruid . ", " . $active_tus . ")";
$result = $dbh->exec($q);
}