<?php
/**
 * This program is free software: you can redistribute it and/or modify it under the
 * terms of the GNU General Public License as published by the Free Software Foundation,
 * either version 3 of the License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along with this program.
 * If not, see https://www.gnu.org/licenses/.
 */

if (!defined('WPINC')) {
	die;
}

global $wpdb;

$table_name = "{$wpdb->prefix}correos_oficial_configuration";

$datas = array(
	array(
		'name' => 'GDPR',
		'value' => 0,
		'type' => 'analitica',
	),
	array(
		'name' => 'betatester',
		'value' => 0,
		'type' => 'analitica',
	),
	array(
		'name' => 'Analitica_date',
		'value' => gmdate('Y-m-d H:i:s'),
		'type' => 'analitica',
	),
);

foreach ($datas as $data) {
	$name = $data['name'];
	$value = $data['value'];
	$dataType = $data['type'];

	$wpdb->query($wpdb->prepare('
	INSERT INTO %i (`name`, `value`, `type`)
	SELECT %s, %s, %s
	WHERE NOT EXISTS (
		SELECT 1 FROM %i
		WHERE `name` = %s AND `type` = %s
	) LIMIT 1', $table_name, $name, $value, $dataType, $table_name, $name, $dataType));
}