# double-opt-in/3.0.3/ui/UIDatabase.class.php

Double Opt-In for Contact Form 7 – Secure, GDPR-Compliant Email Verification, version 3.0.3. 130 lines.

- Page: https://pluginprobe.com/plugins/double-opt-in/3.0.3/code/ui/UIDatabase.class.php
- Raw: https://pluginprobe.com/plugins/double-opt-in/3.0.3/raw/ui/UIDatabase.class.php
- Modified: 2024-08-13T13:52:36+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/double-opt-in/3.0.3/code/ui/UIDatabase.class.php#L10-L20`.

```php
<?php

namespace forge12\contactform7\CF7DoubleOptIn {
	if ( ! defined( 'ABSPATH' ) ) {
		exit;
	}

	/**
	 * Class UIDatabase
	 *
	 * @package forge12\contactform7\CF7DoubleOptIn
	 */
	class UIDatabase extends UIPageForm {
		/**
		 * Constructor method for the class.
		 *
		 * @param TemplateHandler $templateHandler The template handler object to be used.
		 * @param string          $domain          The domain parameter for the constructor.
		 *
		 * @return void
		 */
		public function __construct( TemplateHandler $templateHandler, string $domain ) {
			parent::__construct( $templateHandler, $domain, 'database', __( 'Database', 'double-opt-in' ), 50 );
			$this->hideSubmitButton( true );
		}

		/**
		 * Save on form submit
		 */
		private function maybeCleanDatabase() {
			// Check if the form is posted and the nonce is valid
			if ( ( isset( $_POST['doi-clean-submit'] ) || isset( $_POST['doi-clean-confirmed-submit'] ) || isset( $_POST['doi-clean-unconfirmed-submit'] ) ) ) {
				$CleanUp = new CleanUp();
				if ( isset( $_POST['doi-clean-submit'] ) || isset( $_POST['doi-clean-confirmed-submit'] ) ) {
					$CleanUp->removeConfirmedOptins( true );
				}
				if ( isset( $_POST['doi-clean-submit'] ) || isset( $_POST['doi-clean-unconfirmed-submit'] ) ) {
					$CleanUp->removeUnconfirmedOptins( true );
				}

				Messages::getInstance()->add( __( 'Database cleaned.', 'double-opt-in' ), 'success' );
			}
		}

		/**
		 * Reset the database deleting all entries.
		 */
		private function maybeResetDatabase() {
			// Check if the form is posted and the nonce is valid
			if ( isset( $_POST['doi-reset-submit'] ) ) {
				$CleanUp = new CleanUp();
				$CleanUp->reset();

				Messages::getInstance()->add( __( 'Database reset finished.', 'double-opt-in' ), 'success' );
			}
		}

		/**
		 * Render the license subpage content
		 */
		protected function theContent( $slug, $page, $settings ) {
			?>
            <h2>
				<?php _e( 'Database', 'double-opt-in' ); ?>
            </h2>
			<?php
			wp_nonce_field( 'doi_settings_action', 'doi_settings_nonce' );
			?>

            <div class="option">
                <div class="label">
                    <label for="delete"><?php _e( 'Clean Database', 'double-opt-in' ); ?></label>
                </div>
                <div class="input">
                    <input type="submit" name="doi-clean-submit" class="button"
                           value="<?php _e( 'Clean All', 'double-opt-in' ); ?>"/>
                    <input type="submit" name="doi-clean-confirmed-submit" class="button"
                           value="<?php _e( 'Clean Confirmed', 'double-opt-in' ); ?>"/>
                    <input type="submit" name="doi-clean-unconfirmed-submit" class="button"
                           value="<?php _e( 'Clean Unconfirmed', 'double-opt-in' ); ?>"/>
                    <p>
						<?php _e( 'Make sure you backup your database before clicking one of these buttons.', 'double-opt-in' ); ?>
                    </p>
                </div>
            </div>
            <div class="option">
                <div class="label">
                    <label for="delete"><?php _e( 'Reset Database', 'double-opt-in' ); ?></label>
                </div>
                <div class="input">
                    <input type="submit" name="doi-reset-submit" class="button button-delete"
                           value="<?php _e( 'Reset', 'double-opt-in' ); ?>"/>
                    <p>
						<?php _e( 'Make sure you backup your database before clicking one of these buttons. If you click this button, all Opt-Ins will be deleted.', 'double-opt-in' ); ?>
                    </p>
                </div>
            </div>
			<?php
		}

		protected function theSidebar( $slug, $page ) {
			if ( $page != 'settings' ) {
				return;
			}
			?>
            <div class="box">
                <h2>
					<?php _e( 'Hint:', 'double-opt-in' ); ?>
                </h2>
                <p>
					<?php _e( "In the table on the left side, you'll find an list containing all Opt-Ins and the required information from your customers. Click on the hash to open aditional informations about the form and the user data. All unconfirmed opt-ins will be deleted after 7 days.", 'double-opt-in' ); ?>
                </p>
            </div>
			<?php
		}

		public function getSettings( $settings ) {
			return $settings;
		}

		protected function onSave( $settings ) {
			// Check if the user wants to clean the database manually
			$this->maybeCleanDatabase();
			// Check if the user wants to reset the database manually
			$this->maybeResetDatabase();

			return $settings;
		}
	}
}
```