Changeset 9458 for trunk/MagicSoft/Mars/datacenter/db/plotinclude.php

Timestamp:

06/16/09 13:22:10 (16 years ago)

Author:

aparavac

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/plotinclude.php (modified) (3 diffs)

trunk/MagicSoft/Mars/datacenter/db/plotinclude.php

@@ -73 +73 @@
     $stop1=$_GET["Stop"];
 
+    if (empty($_GET["fSourceN"]))
+        $_GET["fSourceN"]="";
+    $source=$_GET["fSourceN"];
+
     $query="SELECT " . $table . "." . $primary . ", ";
     if ($column==$primary)
@@ -99 +103 @@
     $query.=$joins[$primary];
 
+    if (!empty($source))
+        $query.= " LEFT JOIN Source USING(fSourceKEY) ";
+
     if (!empty($primstart))
         $query.= " WHERE " . $table . "." . $primary . " > " . $primstart;
@@ -155 +162 @@
         $query.= CheckQuery($query) . GetTable($table, $column4) . " < " . $stop4;
 
+    if (!empty($source))
+        $query.= CheckQuery($query) . " fSourceName REGEXP \"^" . $_GET["fSourceN"] . "\" ";
+
     return $query;
 }