/[dehs]/trunk/dehs_pg.php
ViewVC logotype

Diff of /trunk/dehs_pg.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 70 by atomo64-guest, Wed Dec 12 01:23:48 2007 UTC revision 71 by atomo64-guest, Thu Dec 13 01:07:00 2007 UTC
# Line 648  function watch_wizard($src_name='%'){ Line 648  function watch_wizard($src_name='%'){
648      global $dirs,$dbconn,$sfIgnore,$watchFileExts,$watchFormat;      global $dirs,$dbconn,$sfIgnore,$watchFileExts,$watchFormat;
649      $db = pg_pconnect($dbconn) or die_status ("Db error");      $db = pg_pconnect($dbconn) or die_status ("Db error");
650      $checked=$errors=$notfound=$verok=$notmatch=0;      $checked=$errors=$notfound=$verok=$notmatch=0;
     $sqlstring="SELECT mpop_inst,name,pkgs.version,pkgs.section,pkgs.dist,tot_up_error, tot_avg_error_date, wwiz_version FROM pkgs INNER JOIN  
         (Select max(pop_inst) as mpop_inst,SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist HAVING max(pop_inst) IS NOT NULL) as binpkgs using(name,dist)  
         WHERE (watch IS NULL OR watch='') AND name LIKE '$src_name%' ORDER BY mpop_inst DESC";  
     $rsql=pg_exec($db, $sqlstring);  
651    
652      // prepare some stuff that needs to be done once per run      // prepare some stuff that needs to be done once per run
653      $opts = '';      $opts = '';
# Line 669  function watch_wizard($src_name='%'){ Line 665  function watch_wizard($src_name='%'){
665          $opts = 'opts=uversionmangle=s/\.' . $exts . '$// \\';          $opts = 'opts=uversionmangle=s/\.' . $exts . '$// \\';
666      }      }
667    
668        $sqlstring="SELECT mpop_inst,name,pkgs.version,pkgs.section,pkgs.dist,tot_up_error, tot_avg_error_date, wwiz_version FROM pkgs INNER JOIN
669            (Select max(pop_inst) as mpop_inst,SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist HAVING max(pop_inst) IS NOT NULL) as binpkgs using(name,dist)
670            WHERE (watch IS NULL OR watch='') AND name LIKE '$src_name%' ORDER BY mpop_inst DESC";
671        $rsql=pg_exec($db, $sqlstring);
672    
673      while ($res_array=pg_fetch_array($rsql)) {      while ($res_array=pg_fetch_array($rsql)) {
674    
675          if (substr($res_array["name"],0,3)=='lib')          if (substr($res_array["name"],0,3)=='lib')
# Line 760  function watch_wizard($src_name='%'){ Line 761  function watch_wizard($src_name='%'){
761                      $uscan_res=uscan_foo($res_array['name'] ,$res_array['version'],$watch);                      $uscan_res=uscan_foo($res_array['name'] ,$res_array['version'],$watch);
762    
763                      if ($uscan_res[0]) {                      if ($uscan_res[0]) {
764                          break 2;                          break;
765                      }                      }
766                  }                  }
767    
# Line 826  function dehsqa_db () { Line 827  function dehsqa_db () {
827              //"<dversion>$res_array[version]</dversion>" .              //"<dversion>$res_array[version]</dversion>" .
828              //"<dversionmangled>$res_array[versionmangled]</dversionmangled>" .              //"<dversionmangled>$res_array[versionmangled]</dversionmangled>" .
829              "<wwiz>$wwiz</wwiz>" .              "<wwiz>$wwiz</wwiz>" .
830              //"<updated>" . ($res_array['updated']=='f')? 'true': 'false' . "</updated>" .              //"<updated>" . ($res_array['updated']=='t')? 'true': 'false' . "</updated>" .
831              "</data>";              "</data>";
832              $value=addslashes($xml);              $value=addslashes($xml);
833              dba_replace($res_array[name],$xml,$id);              dba_replace($res_array[name],$xml,$id);
Legend:
Removed from v.70  
changed lines
  Added in v.71
  ViewVC Help
Powered by ViewVC 1.1.5