jQuery(document).ready(function(){
jQuery(\"#logbook_poplight\").dialog({
width: 'auto',
modal: true
});
});
";
}
if ($_REQUEST['call'])
{
echo $call;
$query = "SELECT ".$wpdb->prefix."logbook.*,".$wpdb->prefix."logbookRef.*
FROM ".$wpdb->prefix."logbook
INNER JOIN ".$wpdb->prefix."logbookRef
ON ".$wpdb->prefix."logbook.refid = ".$wpdb->prefix."logbookRef.id
WHERE ".$wpdb->prefix."logbook.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 | ";
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_showRSTS' ) == "true") echo "RSTs | ";
if (get_option( 'logbook_showRSTR' ) == "true") echo "RSTr | ";
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_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_showRSTS' ) == "true") echo "".$result->RSTS." | ";
if (get_option( 'logbook_showRSTR' ) == "true") echo "".$result->RSTR." | ";
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();
}
?>