function check_adif2($adif, $log_id, $band = 'ALL', $mode = 'ALL', $paper = true, $lotw = true, $eqsl = true)
{
global $dbconnect;
$dbconnect->select_db(logid_to_tableid($log_id));
$adif = mysqli_real_escape_string($dbconnect, $adif);
$log_id = mysqli_real_escape_string($dbconnect, $log_id);
$band = mysqli_real_escape_string($dbconnect, $band);
$mode = mysqli_real_escape_string($dbconnect, $mode);
$paper = mysqli_real_escape_string($dbconnect, $paper);
$lotw = mysqli_real_escape_string($dbconnect, $lotw);
$eqsl = mysqli_real_escape_string($dbconnect, $eqsl);
$qslstring = qslstring($paper, $lotw, $eqsl);
if ($mode == "RTTY") {
$mode = "DATA";
}
if ($band == "ALL") {
$bandstring = '';
} else {
$bandstring = ' and band="' . $band . '"';
}
$dbconnect->select_db(logid_to_tableid($log_id));
switch ($mode) {
case 'ALL':
$ergebnis = mysqli_query($dbconnect, 'select callsign from cqrlog_main where adif=' . $adif . $bandstring . $qslstring . ' limit 1');
break;
case 'DATA':
$ergebnis = mysqli_query($dbconnect, 'select callsign from cqrlog_main where adif=' . $adif . $bandstring . ' and mode!="SSB" and mode !="CW" and mode !="FM"' . $qslstring . ' limit 1');
break;
default:
$ergebnis = mysqli_query($dbconnect, 'select callsign from cqrlog_main where adif=' . $adif . $bandstring . ' and mode="' . $mode . '"' . $qslstring . ' limit 1');
}
while ($row = mysqli_fetch_object($ergebnis)) {
return array("C", '<td align="center" bgcolor="#40FF00">', '</td>');
}
switch ($mode) {
case 'ALL':
$ergebnis2 = mysqli_query($dbconnect, 'select callsign from cqrlog_main where adif=' . $adif . $bandstring . ' limit 1');
break;
case 'DATA':
$ergebnis2 = mysqli_query($dbconnect, 'select callsign from cqrlog_main where adif=' . $adif . $bandstring . ' and mode!="SSB" and mode !="CW" and mode !="FM" limit 1');
break;
default:
$ergebnis2 = mysqli_query($dbconnect, 'select callsign from cqrlog_main where adif=' . $adif . $bandstring . ' and mode="' . $mode . '" limit 1');
}
while ($row = mysqli_fetch_object($ergebnis2)) {
return array('W', '<td align="center" bgcolor="Red">', '</td>');
}
return array('N', '<td>', '</td>');
}
//echo foo;
//echo $time_on;
if (!empty($call)) {
echo $dxcc_name;
if (!empty($manager)) {
echo ', QSL via ' . $manager;
}
if (!empty($iota_nr)) {
echo ', ' . $iota_name . ' with IOTA reference ' . $iota_nr;
}
if (!empty($locator)) {
echo ', at locator ' . $locator;
}
if (!empty($state)) {
echo ', in US-State ' . $state;
}
}
if (empty($call)) {
// echo '<p><h3> <font color=red>Please insert Callsign</font></h3></p>' . "\n";
} elseif (empty($band)) {
// echo '<p><h3> <font color=red>Please insert Frequency</font></h3></p>' . "\n";
} else {
$insert = "insert into cqrlog_main (qsodate,time_on,time_off,callsign,freq,mode,rst_s,rst_r,name,remarks,idcall,band,adif,itu,waz,qsl_via,iota,loc,state) " . "values('" . $datum . "','" . $time_on . "','" . $time_on . "','" . $call . "'," . $freq . ",'" . $mode . "','" . $rst_sent . "','" . $rst_rcvd . "','" . $name . "','" . $remarks . "','" . $id_call . "','" . $band . "','" . $adif . "','" . $itu . "','" . $waz . "','" . $manager . "','" . $iota_nr . "','" . $locator . "','" . $state . "')";
if ($debugmode) {
echo $insert;
} else {
$dbconnect->select_db(logid_to_tableid($log_id));
mysqli_query($dbconnect, $insert);
}
//echo " <p class='hl'>last QSOs</p>";
}
<table align="center" border="0" cellpadding="0" cellspacing="0">
<tr>
<th bgcolor="grey" width="100px">DXCC</th>
<td width="15" bgcolor="grey"></td><td bgcolor="Black" width="1px"></td><td width="15" bgcolor="grey"></td>
<th bgcolor="grey" width="350px">Name / Mode</th>
<!--<td width="15" bgcolor="grey"></td><td bgcolor="Black" width="1px"></td><td width="15px" bgcolor="grey"></td>-->
<?php
$i = 0;
$dbconnect->select_db("cqrlog_common");
$ergebnis = mysqli_query($dbconnect, 'SELECT DISTINCT t1.band from cqrlog_common.bands t1 join ' . logid_to_tableid($log_id) . '.cqrlog_main t2 on t1.band = t2.band order by t1.b_begin asc');
while ($band = mysqli_fetch_object($ergebnis)) {
$bands[] = $band->band;
}
foreach ((array) $bands as $band_in) {
echo '<td width="15" bgcolor="grey"></td><td bgcolor="Black" width="1px"></td><td width="15" bgcolor="grey"></td>' . "\n";
echo '<th bgcolor="grey" width="30px">' . $band_in . '</th>' . "\n";
}
echo '<td width="15" bgcolor="grey"></td><td bgcolor="Black" width="1px"></td>' . "\n";
?>
</tr>
<?php
$dbconnect->select_db("cqrlog_common");
$query = mysqli_query($dbconnect, 'SELECT distinct adif,pref,name from dxcc_ref ' . $wheredxcc);
while ($row = mysqli_fetch_object($query)) {
$dxcc = $row->pref;
$name = $row->name;
$adif = $row->adif;
echo '<tr>' . "\n";
echo '<td bgcolor="#E6E6E6"><font size=+1>' . $dxcc . '</font></td>' . "\n";
echo '<td bgcolor="#E6E6E6"></td><td bgcolor="Black" width="0.3px"></td><td bgcolor="#E6E6E6"></td>' . "\n";
function count_dxcc($log_id, $band, $mode, $paper, $lotw, $eqsl)
{
global $dbconnect;
$dbconnect->select_db(logid_to_tableid($log_id));
$log_id = mysqli_real_escape_string($dbconnect, $log_id);
$band = mysqli_real_escape_string($dbconnect, $band);
$mode = mysqli_real_escape_string($dbconnect, $mode);
$paper = mysqli_real_escape_string($dbconnect, $paper);
$lotw = mysqli_real_escape_string($dbconnect, $lotw);
$eqsl = mysqli_real_escape_string($dbconnect, $eqsl);
$qslstring = qslstring($paper, $lotw, $eqsl);
$querystring = 'select count(distinct adif) from cqrlog_main where adif<>0 ';
if ($band != "ALL") {
$querystring .= 'and band="' . $band . '" ';
}
if ($mode == "DATA") {
$querystring .= 'and mode!="SSB" and mode!="CW" and mode!="FM" ';
} else {
if ($mode != "ALL") {
$querystring .= 'and mode="' . $mode . '" ';
}
}
$querystring .= $qslstring;
$ergebnis = mysqli_query($dbconnect, $querystring);
$result = $ergebnis->fetch_row();
return $result[0];
}
