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>');
}
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];
}
