/[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 71 by atomo64-guest, Thu Dec 13 01:07:00 2007 UTC revision 72 by atomo64-guest, Thu Dec 13 01:15:29 2007 UTC
# Line 73  if (in_array("-db_add",$argv))  db_add(( Line 73  if (in_array("-db_add",$argv))  db_add((
73      elseif (in_array("-clear_db",$argv))  clear_db();      elseif (in_array("-clear_db",$argv))  clear_db();
74      elseif (in_array("-db_up_error",$argv))  db_up_error();      elseif (in_array("-db_up_error",$argv))  db_up_error();
75      elseif (in_array("-up_changes",$argv))  up_changes($argv[2], true);      elseif (in_array("-up_changes",$argv))  up_changes($argv[2], true);
76      elseif (in_array("-watchf",$argv) || in_array("-wwiz",$argv))  watch_wizard($argv[2]);      elseif (in_array("-watchf",$argv) || in_array("-wwiz",$argv))  watch_wizard((isset($argv[2])?$argv[2]:''));
77      elseif (in_array("-kb_total",$argv))  print "Diff      elseif (in_array("-kb_total",$argv))  print "Diff
78  #stat_up_error();  #stat_up_error();
79  #stat_up_error();to download Kb => " . kb_total($argv[2]) . "\n" ;  #stat_up_error();to download Kb => " . kb_total($argv[2]) . "\n" ;
# Line 234  function db_add($initial='', $clear_db = Line 234  function db_add($initial='', $clear_db =
234      clear_db($db);      clear_db($db);
235      pg_close($db);      pg_close($db);
236  }  }
237  function db_query($pkg,$dist) {  function db_query($pkg,$dist='%') {
238      global $dirs,$dbconn;      global $dirs,$dbconn;
239      $db = pg_pconnect($dbconn )  or  die_status(pg_last_error($db));      $db = pg_pconnect($dbconn )  or  die_status(pg_last_error($db));
240      $rsql=pg_exec($db, "SELECT pkgs.* ,mpop_inst FROM (SELECT name,MAX(binpkgs.pop_inst) AS mpop_inst FROM binpkgs GROUP BY name)      $rsql=pg_exec($db, "SELECT pkgs.* ,mpop_inst FROM (SELECT name,MAX(binpkgs.pop_inst) AS mpop_inst FROM binpkgs GROUP BY name)
241                                                                          AS binpkgs INNER JOIN pkgs ON pkgs.name=binpkgs.name                                                                          AS binpkgs INNER JOIN pkgs ON pkgs.name=binpkgs.name
242                                WHERE pkgs.name='$pkg' AND dist='$dist';");                                WHERE pkgs.name='$pkg' AND dist='$dist';");
243      if (pg_numrows($rsql)==1) {      while ($res_array=pg_fetch_array($rsql)) {
         $res_array=pg_fetch_array($rsql);  
244          print "Package=> " . $res_array['name'] . "\n";          print "Package=> " . $res_array['name'] . "\n";
245          print "Version => " . $res_array['version'] . "\n";          print "Version => " . $res_array['version'] . "\n";
246          print "Diff MD5 Downloaded => " . $res_array['md5_diff'] . "\n";          print "Diff MD5 Downloaded => " . $res_array['md5_diff'] . "\n";
# Line 253  function db_query($pkg,$dist) { Line 252  function db_query($pkg,$dist) {
252          if ($res_array['watch']) {          if ($res_array['watch']) {
253              $uscan_res=uscan_foo($res_array['name'] ,$res_array['version'],$res_array['watch']);              $uscan_res=uscan_foo($res_array['name'] ,$res_array['version'],$res_array['watch']);
254              print "Version Upstream => " . $uscan_res[0] . "\n";              print "Version Upstream => " . $uscan_res[0] . "\n";
255              print "Watch => " . $res_array['watch'];              print "Watch => " . trim($res_array['watch'])."\n";
256              print "Watch Warnings => " . $uscan_res[1];              print "Watch Warnings => " . $uscan_res[1];
257          }          }
258          else print "Watch => Not present" . "\n";          else print "Watch => Not present" . "\n";
259          if ($res_array['wwiz_type']) {          if ($res_array['wwiz_type']) {
260              $uscan_res=uscan_foo($res_array['name'] ,$res_array['version'],$res_array['wwiz']);              $uscan_res=uscan_foo($res_array['name'] ,$res_array['version'],$res_array['wwiz']);
261              print "WWiz Upstream => " . $uscan_res[0] . "\n";              print "WWiz Upstream => " . $uscan_res[0] . "\n";
262              print "WWiz => " . $res_array['wwiz'];              print "WWiz => " . $res_array['wwiz']."\n";
263              print "WWiz Warings => " . $uscan_res[1];              print "WWiz Warings => " . $uscan_res[1];
264          }          }
265          print "\n";          print "\n";
266      }      }
267      else echo "Package=> " . $pkg . "\nNot found\n!!";      if (pg_numrows($rsql)==0) echo "Package=> " . $pkg . "\nNot found\n!!";
268      pg_close($db);      pg_close($db);
269  }  }
270  function byte_total(&$db,$initial) {  function byte_total(&$db,$initial) {
Legend:
Removed from v.71  
changed lines
  Added in v.72
  ViewVC Help
Powered by ViewVC 1.1.5