<?php

require_once('fpdf.php');

require_once('fpdi.php');

include "config.php";


if(get_aantal_operators($_GET['call'] , $operators) >= count($operators))
{
   // data uit de database halen:
   $call_sql = "SELECT * FROM calls WHERE `CALL` = '".mysql_real_escape_string($_GET['call'])."' LIMIT 1";
   $call_uitvoeren = mysql_query($call_sql);
   $call_onderdelen = mysql_fetch_array($call_uitvoeren);

       $pdf = new FPDI();
       $pdf->AddPage('l', array(138,220));
       $pdf->setSourceFile('Dutch Xmas Award 2016.pdf');
       $tplIdx = $pdf->importPage(1);
       $pdf->useTemplate($tplIdx, 0, 0, 221);
       $pdf->AddFont('SnowForSanta');
       $pdf->SetFont('SnowForSanta');
       $pdf->SetTextColor(9, 179, 37);
       $pdf->SetFontSize(18);

       $pdf->SetXY(20, 108);
       $pdf->Write(0, $call_onderdelen['CALL']);

       $datum = substr($call_onderdelen['QSO_DATE'],6,2)."-".substr($call_onderdelen['QSO_DATE'],4,2)."-".substr($call_onderdelen['QSO_DATE'],0,4);
       $pdf->SetXY(44, 108);
       $pdf->Write(0, $datum);

       $pdf->SetXY(85, 108);
       $pdf->Write(0, $call_onderdelen['TIME_ON']);

       $pdf->SetXY(115, 108);
       $pdf->Write(0, $call_onderdelen['FREQ']);

       $pdf->SetXY(160, 108);
       $pdf->Write(0, $call_onderdelen['N3FJP_MODECONTEST']);

       $pdf->SetXY(190, 108);
       $pdf->Write(0, $call_onderdelen['RST_SENT']);


       $pdf->Output();
}
else
{
   echo "You need to work first one of the four stations before you can download your Qsl card!";
}
?>