123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123 |
- <?php
- define('INSTALLDIR', dirname(__DIR__));
- define('PUBLICDIR', INSTALLDIR . DIRECTORY_SEPARATOR . 'public');
- $shortoptions = 'e::ay';
- $longoptions = ['email=', 'all', 'yes'];
- $self = basename($_SERVER['PHP_SELF']);
- $helptext = <<<END_OF_HELP
- {$self} [options]
- resends confirmation email either for a specific email (if found) or for
- all lingering confirmations.
- NOTE: You probably want to do something like this to your database first so
- only relatively fresh accounts get resent this:
- DELETE FROM confirm_address WHERE modified < (CURRENT_TIMESTAMP - INTERVAL '1' MONTH);
- Options:
- -e --email e-mail address to send for
- -a --all send for all emails in confirm_address table
- -y --yes skip interactive verification
- END_OF_HELP;
- require_once INSTALLDIR . '/scripts/commandline.inc';
- $all = false;
- $ca = null;
- if (have_option('e', 'email')) {
- $email = get_option_value('e', 'email');
- if (is_null($email)) {
- echo "You must provide an email.\n";
- exit(1);
- }
- try {
- $ca = Confirm_address::getByAddress($email, 'email');
- } catch (NoResultException $e) {
- echo sprintf(
- "Can't find %s address %s in %s table.\n",
- $e->obj->address_type,
- $e->obj->address,
- $e->obj->tableName()
- );
- exit(1);
- }
- } elseif (have_option('a', 'all')) {
- $all = true;
- $ca = new Confirm_address();
- $ca->address_type = 'email';
- if (!$ca->find()) {
- echo "confirm_address table contains no lingering email addresses\n";
- exit();
- }
- } else {
- echo "You must provide an email (or --all).\n";
- exit(1);
- }
- if (!have_option('y', 'yes')) {
- echo "About to resend confirm_address email to {$ca->N} recipients. Are you sure? [y/N] ";
- $response = fgets(STDIN);
- if (strcasecmp(trim($response), 'y') != 0) {
- echo "Aborting.\n";
- exit();
- }
- }
- function mail_confirm_address(Confirm_address $ca): void
- {
- try {
- $user = User::getByID($ca->user_id);
- $profile = $user->getProfile();
- if ($profile->isSilenced()) {
- $ca->delete();
- return;
- }
- if ($user->email === $ca->address) {
- throw new AlreadyFulfilledException('User already has identical confirmed email address.');
- }
- } catch (AlreadyFulfilledException $e) {
- echo "\n User already had verified email: " . _ve($ca->address);
- $ca->delete();
- } catch (Exception $e) {
- echo "\n Failed to get user with ID " . _ve($user_id)
- . ', deleting confirm_address entry: ' . _ve($e->getMessage());
- $ca->delete();
- return;
- }
- $ca->sendConfirmation();
- }
- require_once INSTALLDIR . '/lib/util/mail.php';
- if (!$all) {
- mail_confirm_address($ca);
- } else {
- while ($ca->fetch()) {
- mail_confirm_address($ca);
- }
- }
- echo "\nDONE.\n";
|