Page MenuHomePhabricator

D17786.diff
No OneTemporary

D17786.diff

diff --git a/resources/sql/autopatches/20170424.user.01.verify.php b/resources/sql/autopatches/20170424.user.01.verify.php
new file mode 100644
--- /dev/null
+++ b/resources/sql/autopatches/20170424.user.01.verify.php
@@ -0,0 +1,34 @@
+<?php
+
+$table = new PhabricatorUser();
+$conn = $table->establishConnection('w');
+
+foreach (new LiskMigrationIterator($table) as $user) {
+ // Ignore users who are verified.
+ if ($user->getIsEmailVerified()) {
+ continue;
+ }
+
+ // Ignore unverified users with missing (rare) or unverified (common)
+ // primary emails: it's correct that their accounts are not verified.
+ $primary = $user->loadPrimaryEmail();
+ if (!$primary) {
+ continue;
+ }
+
+ if (!$primary->getIsVerified()) {
+ continue;
+ }
+
+ queryfx(
+ $conn,
+ 'UPDATE %T SET isEmailVerified = 1 WHERE id = %d',
+ $table->getTableName(),
+ $user->getID());
+
+ echo tsprintf(
+ "%s\n",
+ pht(
+ 'Corrected account verification state for user "%s".',
+ $user->getUsername()));
+}

File Metadata

Mime Type
text/plain
Expires
May 12 2024, 3:22 AM (5 w, 2 d ago)
Storage Engine
blob
Storage Format
Encrypted (AES-256-CBC)
Storage Handle
6287938
Default Alt Text
D17786.diff (1 KB)

Event Timeline