Changeset 7548 for trunk/MagicSoft/Mars/datacenter/db
- Timestamp:
- 02/28/06 21:24:09 (19 years ago)
- Location:
- trunk/MagicSoft/Mars/datacenter/db
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/MagicSoft/Mars/datacenter/db/dbstatus.php
r7546 r7548 136 136 $query0 .= "Sequences.fSequenceFirst BETWEEN " . $_GET["fRunMin"] . " AND " . $_GET["fRunMax"] . " "; 137 137 else 138 $query0 = substr($query0, 0, - 4);138 $query0 = substr($query0, 0, -6); 139 139 140 140 /* … … 222 222 223 223 if (empty($_GET["fAllFilesAvailStatus"])) 224 $_GET["fAllFilesAvailStatus"]= "7";224 $_GET["fAllFilesAvailStatus"]=$first?"7":""; 225 225 226 226 if (empty($_GET["fCallisto"])) … … 228 228 229 229 if (empty($_GET["fCallistoStatus"])) 230 $_GET["fCallistoStatus"]= "7";230 $_GET["fCallistoStatus"]=$first?"7":""; 231 231 232 232 if (empty($_GET["fFillCallisto"])) … … 240 240 241 241 if (empty($_GET["fStarStatus"])) 242 $_GET["fStarStatus"]= "7";242 $_GET["fStarStatus"]=$first?"7":""; 243 243 244 244 if (empty($_GET["fFillStar"])) -
trunk/MagicSoft/Mars/datacenter/db/index.html
r7546 r7548 43 43 <li><A HREF="queryrbk.php">Runbook Database</A></li> 44 44 <li><A HREF="datasetinfo.php">Dataset Information</A> 45 (<!--<A HREF="http://www.astro.uni-wuerzburg.de/~dorner/analysis/datasets.html">comments</A>, 46 --> 47 <A HREF="http://www.astro.uni-wuerzburg.de/datacenter/datasets/">dataset files</A>)</li> 45 (<A HREF="http://www.astro.uni-wuerzburg.de/datacenter/datasets/">dataset files</A>)</li> 48 46 <li><A HREF="ganymed.php">Results of the Automatic Analysis</A> 49 47 </ul> … … 63 61 <li><A HREF="statussps.php">Sequence Process Status</A>: querying only the information from the table SequenceProcessStatus </li> 64 62 <li><A HREF="printtable.php?fTable=MarsVersion">Mars Versions in the DC</A>: querying all information from the table MarsVersions </li> 65 <li><A HREF="dbstatus.php?fAllFilesAvailStatus=0&fCallisto=On&fCallistoStatus=7&fStar=On&fStarStatus=7&fFillCallistoStatus=0&fFillStarStatus=0&fSourceName=On&fSourceKEY=0 &fSourceN=&fStartDate=0000-00-00&fStopDate=2010-10-04&fRunMin=3340&fRunMax=64713&fNumResults=20">Processing status</A> (a simplified version of sequinfo.php)</li>63 <li><A HREF="dbstatus.php?fAllFilesAvailStatus=0&fCallisto=On&fCallistoStatus=7&fStar=On&fStarStatus=7&fFillCallistoStatus=0&fFillStarStatus=0&fSourceName=On&fSourceKEY=0">Processing status</A> (a simplified version of sequinfo.php)</li> 66 64 </ul> 67 65 Some very simple queries:<p> -
trunk/MagicSoft/Mars/datacenter/db/queryrbk.php
r7546 r7548 19 19 ini_set("mysql.trace_mode", "Off"); 20 20 ini_set("display_errors", "Off"); 21 22 printf("Night (yyyy-mm-dd) <input name=\"fNight\" type=\"text\" size=\"10\" maxlength=\"10\" value=\""); 23 printf("%s\"> \n", $_GET["fNight"]); 21 24 22 25 printf("<input class='Width' type='submit' value='Query Table'> \n"); … … 48 51 if (!empty($_GET["fRegexp"])) 49 52 $query0 .= "AND fRunBookText REGEXP '" . $_GET["fRegexp"] . "' "; 53 54 if (!empty($_GET["fNight"])) 55 $query0 .= "AND fRunBookDate < '" . $_GET["fNight"] . " 13:00:00' AND fRunBookDate > ADDDATE( '" . $_GET["fNight"] . " 13:00:00', INTERVAL -1 DAY) "; 50 56 51 57 $query0 .= "ORDER BY fRunBookDate";
Note:
See TracChangeset
for help on using the changeset viewer.