jQuery(document).ready(function(){
jQuery(\"#logbook_poplight\").dialog({
width: 'auto',
modal: true
});
$('.dialog').dialog('destroy').remove();
});
";
}
if ($_REQUEST['call'])
{
echo $call;
$query = "SELECT t1.id,
t1.MyCallsign,
date_format(t1.Date, \"%d.%m.%Y\") AS Date,
t1.Time,
t1.Time_off,
t1.Callsign,
t1.Band,
t1.Frequency,
t1.Mode,
t1.RSTS,
t1.RSTR,
t1.QSLS,
t1.QSLR,
t1.refid,
t1.booksid,
t1.Prop_Mode,
".$wpdb->prefix."logbookRef.*
FROM ".$wpdb->prefix."logbook AS t1
INNER JOIN ".$wpdb->prefix."logbookRef
ON t1.refid = ".$wpdb->prefix."logbookRef.id
WHERE t1.Callsign = '".$_REQUEST['call']."'
ORDER BY Date
";
if ($wpdb->get_results($query))
{
$call = strtoupper($call);
$results = $wpdb->get_results($query);
$num_rows = $wpdb -> num_rows;
echo "
";
echo "
";
echo " ";
if (get_option( 'logbook_showMyCallsign' ) == "true") echo "| Call sign used | ";
if (get_option( 'logbook_showDate' ) == "true") echo "Date | ";
if (get_option( 'logbook_showTime' ) == "true") echo "Time on | ";
if (get_option( 'logbook_showTime_off' ) == "true") echo "Time off | ";
if (get_option( 'logbook_showCall' ) == "true") echo "Callsign | ";
if (get_option( 'logbook_showBand' ) == "true") echo "Band | ";
if (get_option( 'logbook_showFreq' ) == "true") echo "Frequency | ";
if (get_option( 'logbook_showMode' ) == "true") echo "Mode | ";
if (get_option( 'logbook_showProp_Mode' ) == "true") echo "Propagation Mode | ";
if (get_option( 'logbook_showRSTS' ) == "true") echo "RSTs | ";
if (get_option( 'logbook_showRSTR' ) == "true") echo "RSTr | ";
if (get_option( 'logbook_showQSLS' ) == "true") echo "QSLs | ";
if (get_option( 'logbook_showQSLR' ) == "true") echo "QSLr | ";
if (get_option( 'logbook_showRefNO' ) == "true") echo "Reference | ";
if (get_option( 'logbook_showRefDesc' ) == "true") echo "Reference Description | ";
echo "
";
foreach ($results as $result){
echo "";
if (get_option( 'logbook_showMyCallsign' ) == "true") echo "| ".$result->MyCallsign." | ";
if (get_option( 'logbook_showDate' ) == "true") echo "".$result->Date." | ";
if (get_option( 'logbook_showTime' ) == "true") echo "".$result->Time." | ";
if (get_option( 'logbook_showTime_off' ) == "true") echo "".$result->Time_off." | ";
if (get_option( 'logbook_showCall' ) == "true") echo "".$result->Callsign." | ";
if (get_option( 'logbook_showBand' ) == "true") echo "".$result->Band." | ";
if (get_option( 'logbook_showFreq' ) == "true") echo "".$result->Frequency." | ";
if (get_option( 'logbook_showMode' ) == "true") echo "".$result->Mode." | ";
if (get_option( 'logbook_showProp_Mode' ) == "true") echo "".$result->Prop_Mode." | ";
if (get_option( 'logbook_showRSTS' ) == "true") echo "".$result->RSTS." | ";
if (get_option( 'logbook_showRSTR' ) == "true") echo "".$result->RSTR." | ";
if (get_option( 'logbook_showQSLS' ) == "true") echo "".$result->QSLS." | ";
if (get_option( 'logbook_showQSLR' ) == "true") echo "".$result->QSLR." | ";
if (get_option( 'logbook_showRefNO' ) == "true") echo "".$result->refnumber." | ";
if (get_option( 'logbook_showRefDesc' ) == "true") echo "".$result->refdescription." | ";
echo "
";
}
echo "
";
echo "
WordPress ADIF Log Search Widget
";
echo "
Sorry, nothing found in the logbook!
";
logbook_search_form();
}
}
else
{
logbook_search_form();
}
?>