<?php
date_default_timezone_set('Europe/Berlin');
require('db.php');
require('smarty_conf.php');
$countries = array();
$nearest_countries = array();
$nearest_locations = array();
$query = "SELECT * FROM countries ORDER BY name ASC";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)) {
  $countries[] = $row;
}
$campaign_id = isset($_REQUEST['campaign']) ? $_REQUEST['campaign'] : 0;
$campaign = array();
$query = "SELECT * FROM pd_campaigns WHERE id = " . $campaign_id;
$result = mysql_query($query);
if($row = mysql_fetch_assoc($result)) {
	$campaign = $row;
}
$questions = array();
$query = "SELECT q.*, GROUP_CONCAT(pa.text ORDER BY pa.id SEPARATOR '///') AS select_option FROM pd_questions q LEFT JOIN pd_predefined_answers pa ON q.id = pa.question WHERE q.campaign = $campaign_id GROUP BY q.id ORDER BY q.sort ASC";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)) {
	$row['select_option'] = explode('///', $row['select_option']);
	foreach($row['select_option'] as &$sel) {
		$sel = explode('##', $sel);
		$sel = $sel[0];
	}
  $questions[] = $row;
}
$nl_types = array();
$query = "SELECT * FROM newsletter_types";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)) {
  $nl_types[] = $row;
}
//var_dump($questions);die();
$smarty->assign('campaign', $campaign);
$smarty->assign('countries', $countries);
$smarty->assign('questions', $questions);
$smarty->assign('nl_types', $nl_types);
$smarty->assign('referral', isset($_REQUEST['ref']) ? $_REQUEST['ref'] : '');
$smarty->display('contact_form.tpl');

?>