<?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); }