.-.-.-.-.-

<?php

require_once 'setting.config.php';
require_once 'DBConnection.php';
require_once 'SubscrData.php';
require_once 'User.php';
require_once 'Metadata.php';
require_once 'Canton.php';

$userid = $_GET['userid'];
$campaignid = $_GET['campaignid'];

$database = new DBConnection($config);
$user = new User($database);
$userobj = $user->getUserById($userid);

$metadata = new Metadata($database);
$metadataobj = $metadata->getMetadataByCampaignid($campaignid);

$canton = new Canton($database);
$cantonobj = $canton->getCantonbyZip($userobj['zipcode']);

$subscr = new SubscrData($database);

$param = [
'userid' => $userobj['user_id'],
'created' => date("Y-m-d H:i:s"),
'campaignname' => $campaignid,
'anrede' => $userobj['anrede'] == 'y' ? 'herr' : 'frau',
'vorname' => $userobj['firstname'],
'nachname' => $userobj['lastname'],
'email' => $userobj['email'],
'adresse' => $userobj['streetno'],
'plz' => $userobj['zipcode'],
'stadt' => $userobj['ort'],
'kanton' => $cantonobj['kanton'],
'geburtstag' => $userobj['date_of_birth'],
'chronoform' => 'Subscr-Campaign',
'campaignnewsletter' => $metadataobj['campaigninfoid'],
'newcampaign' => '1399'
];

$result = $subscr->insertData($param);

/home/wirbesti/nb/../public_html/php/Subscribe.php