<?php
$filename = strtoupper(logid_to_call($log_id)) . '.adi';
$filename = str_replace("/", "-", $filename);
$filepath = $exportdir . $filename;
$file = fopen($filepath, "w+");
$fileheader = '<ADIF_VER:5>2.2.1' . "\n";
$fileheader .= 'ADIF export from cqrweblog' . "\n\n";
$fileheader .= 'Internet: http://www.dl8bh.de/cqrweblog/' . "\n\n";
$fileheader .= '<PROGRAMID:9>CQRWEBLOG' . "\n";
$fileheader .= '<PROGRAMVERSION:3>0.9' . "\n";
$fileheader .= '<EOH>' . "\n";
fwrite($file, $fileheader);
$dbconnect->select_db(logid_to_tableid($log_id));
$query = mysqli_query($dbconnect, "SELECT * FROM view_cqrlog_main_by_qsodate t1 join cqrlog_main t2 on t1.id_cqrlog_main = t2.id_cqrlog_main " . $where_export, MYSQLI_USE_RESULT);
while ($row = mysqli_fetch_object($query)) {
$qsodate = $row->qsodate;
$call = $row->callsign;
$timeon = $row->time_on;
$timeoff = $row->time_off;
$band = $row->band;
$mode = $row->mode;
$freq = $row->freq;
$rst_rcvd = $row->rst_r;
$rst_sent = $row->rst_s;
$comment = $row->remarks;
$name = $row->name;
$qsl_sent = $row->qsl_s;
$qsl_rcvd = $row->qsl_r;
$qsl_via = $row->qsl_via;
$iota = $row->iota;
<html>
<head>
<?php
echo '<title>' . strtoupper(logid_to_call($log_id)) . ' \'s Logbook</title>';
//include("inc/copy.php");
?>
<link rel="stylesheet" type="text/css" href="inc/css/logold.css">
<meta charset="UTF-8">
<script src="inc/js/shortcut.js" type="text/javascript" name="shortcut/shortcut"></script>
<script src="inc/js/copy.js" type="text/javascript" name="copycall/copycall"></script>
</head>
<body style="overflow:auto;">
<div id="root">
<?php
echo '<div id="head">' . "\n";
echo '<h1 align="center">Logbook of ' . strtoupper(logid_to_call($log_id)) . '</h1><br /><br />';
echo '</div>' . "\n";
if ($enable_cluster[$log_id] && $hamqth_api && !$hamqthtimeout) {
include "inc/clusterold.php";
}
include "inc/log_inputold.php";
?>
<br /><br />
<?php
include "inc/log_procold.php";
echo '<p align="right">';
$qso_amount = count_qsos($log_id);
switch ($qso_amount) {
case 0:
echo '<font color="red"><b>Nothing found!</b>' . "\n";
include "inc/include2.php";
include "inc/parse_oldstats.php";
//include("inc/include_test.php");
?>
<html>
<head>
<?php
echo '<title>' . strtoupper(logid_to_call($log_id)) . ' \'s DXCC statistics</title>';
?>
<link rel="stylesheet" type="text/css" href="inc/css/logold.css">
</head>
<body>
<?php
echo '<h1 align="center">DXCC statistics of ' . strtoupper(logid_to_call($log_id)) . '</h1><br /><br />';
include "inc/stats_inputold.php";
?>
<br /><br />
<?php
include "inc/stats_oldproc.php";
?>
<table align="center" border="0" cellpadding="0" cellspacing="0">
<tr><td width="300" align="center" >
<?php
$match_amount = count_qsos($log_id);
switch ($match_amount) {
case 0:
echo '<font color="red"><b>Nothing found!</b>' . "\n";
}
</style>
<meta charset="UTF-8">
<?php
include "inc/metaheader.php";
?>
</head>
<body>
<?php
if ($publog_enabled) {
$publog = true;
if ($qso_count > $max_public_count) {
$qso_count = $max_public_count;
}
echo '<h1 align="center">Last ' . $qso_count . ' QSOs of ' . strtoupper(logid_to_call($log_id)) . '</h1><br /><br />' . "\n";
if ($pubsearch_enabled) {
include "inc/pubsearch_input.php";
}
if ($enable_searchcount[$log_id]) {
?>
</br>
<div class="row">
<div class="col-sm-4"></div>
<div class="alert alert-info col-sm-4">
There have been <?php
echo get_search_count($log_id);
?>
searches from <?php
echo count_qsos($log_id);
?>
include "inc/parse_search.php";
?>
<html>
<head>
<?php
echo '<title>Am I in ' . strtoupper(logid_to_call($log_id)) . ' \'s Log</title>';
?>
<meta charset="UTF-8">
</head>
<body>
<?php
if ($pubsearch_enabled) {
$pubsearch = true;
echo '<h1 align="center">Am I in ' . strtoupper(logid_to_call($log_id)) . '\'s Log?</h1><br /><br />';
include "inc/pubsearch_inputold.php";
echo '<br /><br />' . "\n";
include "inc/search_proc.php";
if (!empty($call)) {
if ($enable_searchcount[$log_id]) {
echo '<p><center>There have been ' . increment_search_count($log_id) . ' searches from Log</center></p>' . "\n";
}
echo '<p><h3 align="center"><font color="red">' . "\n";
$aqsos = count_qsos($log_id);
switch ($aqsos) {
case 0:
echo ' Your call was not found in the Log';
break;
case 1:
echo $aqsos . ' QSO with you in the log';
function count_qsos($log_id)
{
global $where;
global $dbconnect;
$log_id = mysqli_real_escape_string($dbconnect, $log_id);
if (logid_to_call($log_id)) {
$dbconnect->select_db(logid_to_tableid($log_id));
$ergebnis = mysqli_query($dbconnect, "SELECT COUNT(*) FROM view_cqrlog_main_by_qsodate " . $where);
$result = $ergebnis->fetch_row();
return $result[0];
} else {
return NULL;
}
}
<?php
include "inc/include.php";
$hamqthtimeout = false;
if (isset($_GET['log_id'])) {
$log_id = filter_input(INPUT_GET, 'log_id', FILTER_VALIDATE_INT);
if (!is_int($log_id)) {
$log_id = $defaultlog;
}
if (!logid_to_call($log_id)) {
$log_id = $defaultlog;
}
} else {
$log_id = $defaultlog;
}
if (isset($_GET['qso_count'])) {
$qso_count = filter_input(INPUT_GET, 'qso_count', FILTER_VALIDATE_INT);
if (!is_int($qso_count)) {
$qso_count = $defaultcount;
}
} else {
$qso_count = $defaultcount;
}
if (isset($_GET['qso_id'])) {
$qso_id = filter_input(INPUT_GET, 'qso_id', FILTER_VALIDATE_INT);
}
