Index: trunk/www/flare_alerts/index.php
===================================================================
--- trunk/www/flare_alerts/index.php	(revision 19777)
+++ trunk/www/flare_alerts/index.php	(revision 19778)
@@ -116,5 +116,5 @@
 
     $query="SELECT CONCAT(fTriggerKey, '[', fTriggerType, ']') AS 'Trigger[Type]', if (isnull(fName), fSourceName, fName) AS 'Source', ";
-    $query.="fPacketTypeKey AS 'Packet', CONCAT(Round(fRa,1), '/', Round(fDec,1), '/', Round(fErr,1)) AS 'Ra/Dec/Err', ";
+    $query.="fPacketTypeKey AS 'Packet', CONCAT(Round(fRa,2), '/', Round(fDec,2), '/', Round(fErr,2)) AS 'Ra/Dec/Err', ";
     $query.="CONCAT(fNight, '_', fRunID) AS 'Run', ";
     $query.="if (fBinning=-1, 'nightly', CONCAT(fBinning, ' min')) AS 'Binning', ";
@@ -154,7 +154,29 @@
         }
         echo "<tr>\n";
-        foreach ($colnames as $key) {
-            
-            echo "<td>".$row[$key]."</td>\n";
+        foreach ($colnames as $key)
+        {
+            echo "<td>".$row[$key];
+            if ($key=="Ra/Dec/Err")
+            {
+                $coordinates=explode("/", $row[$key], 3);
+                $rahh=floor($coordinates[0]);
+                $ramm=floor(($coordinates[0]-$rahh)*60);
+                $rass=round((($coordinates[0]-$rahh)*60-$ramm)*60, 2);
+                //echo "RA: ".$rahh.":".$ramm.":".$rass;
+                $decdd=floor($coordinates[1]);
+                $decmm=floor(($coordinates[1]-$decdd)*60);
+                $decss=floor((($coordinates[1]-$decdd)*60-$decmm)*60);
+                $decss=round((($coordinates[1]-$decdd)*60-$decmm)*60, 2);
+                //echo "Dec: ".$decdd.":".$decmm.":".$decss;
+
+                //echo "<iframe width='100%' height='315' src='http://tevcat.uchicago.edu/visplot.cgi?tname=Sample-Crab&ra=19 24 00&dec=15 54 00&lat=28.76&date=24-10-2019&lon=-17.88&mode=1' frameborder='0' allowfullscreen></iframe>\n";
+                echo " <a target='_blank' rel='noopener' href='http://tevcat.uchicago.edu/visplot.cgi?tname=".str_replace("#", "", $row["Source"])."&ra=".$rahh." ".$ramm." ".$rass."&dec=".$decdd." ".$decmm." ".$decss."&lat=28.76&date=24-10-2019&lon=-17.88&mode=1'>vis</a>\n";
+            }
+            if ($key=="Source")
+            {
+                if (strpos($row[$key], "GBM")!==false)
+                    echo " <a target='_blank' rel='noopener' href='https://gcn.gsfc.nasa.gov/other/".str_replace("GBM#", "", $row[$key]).".fermi'>gcn</a>\n";
+            }
+            echo "</td>\n";
         }
         echo "</tr>\n";